Export the period to Tally

Prepares and downloads Tally-ready Excel and XML exports for every transaction type and master in this store — sales, credit and debit notes, purchases, expenses, customers and stock items — from one Export Hub.

The two ways an import goes wrong

Checking before you export

Each invoice in the selection list is badged with how it will be taxed.

IGST

An inter-state supply.

Intra

CGST and SGST apply.

1. Scan the badges before exporting.
2. An invoice badged the wrong way means the customer's state or place of supply is wrong, not the export.
3. Fix the customer master and the badge follows.

The Export Hub

Transactions is one card per type — Sales, Credit Notes, Debit Notes, Purchases, Expenses — each showing its voucher count, total value, and any export-blocking issues for the current date range. Masters adds Customer and Stock Item cards, tickable and click-through in exactly the same way.

1. Tick a card's checkbox to include that type in a bulk download.
2. Or click the card body to drill in and review, preview or export just that type alone.

Download Selected

Everything ticked. The button label counts what is ticked as you go.

Download Everything

Every transaction type and master, ignoring the checkboxes.

From / To filters every card's voucher count and total, and every tab's rows, to a date range — Sales, Credit Notes and Debit Notes by invoice date; Purchases and Expenses by bill date.

1. Pick a From date, a To date, or both — leave either blank to leave that end open.
2. A Clear button appears once at least one is set, to reset both in one click.

Warnings, instructions and the sales gate

Warnings flags problems that would make a record export broken or incomplete in Tally: missing customer or vendor names, unresolved sales ledgers, zero taxable values, invoice date and number sequence conflicts, stock items with no ledger mapping, and cancelled invoices swept into the batch.

1. Click Warnings to open the full list, grouped by severity.
2. Once the current tab has nothing to flag, the button relabels to No warnings and disables itself.

Instructions explains which ledgers the current tab's vouchers post to, and the Tally menu path to import the file.

1. Click Instructions.
2. A popup opens showing the ledger postings for the current tab and the exact Tally menu path to import the file — including the rounding mode in use.

The gate on the sales side

I understand — continue confirms you have read the Warnings list for Sales, Credit Notes or Debit Notes and moves on to export.

1. Click I understand — continue after reading the warnings. It only appears when the current tab has at least one warning to review.
2. For Sales it opens Choose what to download next. For Credit Notes and Debit Notes it downloads immediately.

Choose what to download then offers to bundle the Customer master, Stock items and Sales ledgers into the same download as your sales vouchers.

1. Tick any masters — Customer master, Stock items, Sales ledgers — to bundle them in.
2. Click Download.
3. You get a single Excel file if you ticked no masters, or one ZIP containing everything if you ticked any.

Sales, credit notes and debit notes

Four filters narrow what the tab shows and what the download contains.

1. Inv. No. Range — type a From and/or To invoice number. It restricts by numeric sequence rather than by formatted text, and either end can be left blank.
2. Customer — open the dropdown and tick individual customers, or use Select All / Select None. Click Done to close it; the selection is already applied as you tick.
3. Invoice Order — click to toggle newest-first against oldest-first. The button's own label always names the order currently applied.
4. Clear Filters — resets the date range, the invoice-number range and the customer filter together. It only appears once at least one of them is active.

Download Sales Excel

Downloads the filtered invoices — or, on the Credit Notes and Debit Notes tabs, the notes — as a Tally-ready Excel voucher file. The label and count follow whichever tab and row selection are active.

1. Tick specific rows to export just those, or leave none ticked to export everything in the current filter.
2. Click Download Sales Excel — or Download Credit Notes / Debit Notes Excel on those tabs.
3. Sales always opens Choose what to download next. Credit Notes and Debit Notes download straight away, unless there are warnings to review first.

Ledger Masters XLSX / Ledger Masters XML

Downloads the Tally sales and GST ledger names from Settings › Tally Ledger Defaults — or your per-item overrides — as a standalone master file, in whichever format suits the import path you use.

1. On the Sales tab, click Ledger Masters XLSX for the Alt+O › Masters › Default Template import path.
2. Or click Ledger Masters XML instead, for the Alt+O › Masters › select XML file path.

New masters for Tally

A collapsible section on the Sales tab only, listing the customers and stock items that need importing into Tally before this export's vouchers — so Tally does not reject them as unknown parties and items. Click the section header to expand or collapse it.

1. Choose New in period or All in this export. The first is only available once a From date is set above; without one, Quillix always shows everything.
2. Tick rows in the list — or use Select All / Clear.
3. Click Download Customer Excel or Download Stock Items Excel. If nothing is ticked, Quillix asks you to select at least one first.

Purchases and expenses

Download Purchases Excel and Download Expenses Excel take every non-cancelled purchase or other-expense in the current date range as a Tally-ready Excel file — Purchase vouchers for Purchases, Journal vouchers for Expenses.

1. Set From / To above if you need a date range — it is optional.
2. Click the matching Download button for Purchases or Expenses.

Two master files go in ahead of them. Vendor Master XLSX downloads your vendors as Sundry Creditor party ledgers; Purchase Ledgers XLSX downloads the Purchase A/c, Input GST, Purchase Discount and Round Off ledgers these vouchers need. If there are no vendors yet, Quillix shows a warning rather than downloading an empty file.

Customers and stock items

The two master cards on the Export Hub each open to a preview with one download.

1. Open the Customers or Stock Items card from the Export Hub.
2. Click Download Customer Master XLSX or Download Stock Items XLSX.
3. If there are none yet, Quillix shows a warning instead of downloading an empty file.

Common questions

Why does Tally reject rows for unknown parties or items?

The masters have not been imported yet. Import the Ledger Masters, Customer master and Stock Items files into Tally before the vouchers — New Masters for Tally lists exactly which ones this export needs.

Why did importing create duplicate ledgers in Tally?

A ledger name that differs from the client Tally company by even one word creates a second ledger rather than updating the first. Never rename ledgers by hand, and rebuild the chart of accounts before every export.

Do warnings block the export?

No. Critical warnings never block it — Quillix still lets the export through, but the resulting Tally voucher may be incomplete. Fix the record at source and recheck rather than exporting past it.

Last updated 5 Aug 2026