Export Tally Data to Excel and Build a Sales Dashboard

Export Tally Data to Excel and Build a Sales Dashboard featured illustration

📎 This article includes 1 downloadable practice file ↓

⏱ 3 min read

Tally’s reports are fine for looking, but analysis (trends, top customers, item mix, comparisons) is much easier in Excel. The trick is exporting cleanly and building a dashboard you can refresh each month.

In this article
  1. Export from TallyPrime
  2. Clean the export
  3. Key numbers
  4. The dashboard
  5. Where people go wrong
  6. Continue learning

Export from TallyPrime

  1. Open the report: Display More Reports › Account Books › Sales Register (or Day Book, Stock Summary, Outstanding).
  2. Set the period (Alt+F2) and switch to Detailed view with item details if needed (Alt+F5 / F12 configure).
  3. Alt+E › Export › format Excel (Spreadsheet), choose a folder, export.
💡 Configure the report first (F12): show item details, voucher numbers and party names in columns. A detailed, row-per-voucher export is far easier to analyse than a summary.

Clean the export

  • Delete the title rows above the headers; keep one header row.
  • Remove subtotal and grand-total rows (filter them out or use Power Query, which repeats the clean-up every month).
  • Check that Date is a real date and amounts are numbers.
  • Press Ctrl+T to make it a Table named Sales.

Key numbers

Total sales:         =SUM(Sales[Value])
Party total:         =SUMIFS(Sales[Value], Sales[Particulars], A2)
July vouchers:       =COUNTIFS(Sales[Date], ">=" & DATE(2026,7,1), Sales[Date], "<=" & DATE(2026,7,31))
Best item:           =INDEX(SORTBY(UNIQUE(Sales[Item]), SUMIFS(Sales[Value], Sales[Item], UNIQUE(Sales[Item])), -1), 1)

The dashboard

  1. Pivot: Particulars in rows, Date grouped by month in columns, Value summed; sort by total.
  2. Pivot chart of monthly sales.
  3. Top-10 customers (Value Filters › Top 10) and item mix.
  4. Slicers for Item and month.

Next month: export again to the same file name, paste into the table (or refresh the Power Query), Refresh All.

Advertisement

Where people go wrong

Problem Fix
Totals double Subtotal rows left in the export
Dates as text Text to Columns › Date DMY
Party names split by spaces Trim; use the same ledger names in Tally

The practice workbook mimics a TallyPrime sales register export with 150 vouchers and 9 checked tasks. See also the Tally & Busy course.

⚡ Interactive Practice Lab & Formula Tester:

Test formulas dynamically in our web formula laboratory or download the companion Excel workbook.

Continue learning

All Excel for Finance guides →
Excel Month-End Financial Close: Step-by-Step Checklist, Reconciliation Formulas & TemplateMastering the Month-End Financial Close in Excel The month-end close process is the pulse…Excel Variance Analysis: Budget vs Actual Reconciliation Formulas, Waterfalls & ModelBuilding a Corporate Budget vs. Actual Variance Analysis in Excel Variance analysis evaluates the…Bank Reconciliation Statement (BRS) in Excel: Month-End Close ChecklistA practical bank-reconciliation workflow with a downloadable Excel template, matching process and month-end review…SAP FICO Essential T-Codes: General Ledger, AP, AR & Period-End ClosingIn SAP ERP (ECC 6.0 and S/4HANA), SAP FICO (Financial Accounting & Management Controlling)…

📎 Practice files for this article

  • 📗
    Tally sales register practice workbook150 vouchers in TallyPrime sales-register export format with 9 checked analysis tasks.
    ⬇ XLSX · 21 KB

Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.

✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong