Before any entries go into Tally, your sheet should have one row per voucher line with a date, a voucher type, the ledger name, the amount, a narration and a reference number. How those are actually fed in depends on your Tally version and the import route you use, so treat this as the preparation checklist, not a promise about any screen.
Which fields does a voucher import usually need?
| Field | What it holds | Common trap |
|---|---|---|
| Date | The day the transaction happened, one format throughout | Mixing 05/11/2026 with 5 Nov 2026 |
| Voucher type | Payment, Receipt, Journal, Contra, Sales, Purchase | Using Payment for a transfer between your own banks |
| Ledger (debit side) | Usually the expense or asset ledger | Spelling that differs from the ledger name already in Tally |
| Ledger (credit side) | Usually the bank, cash or party ledger | Writing the bank's name instead of your ledger name |
| Amount | Positive number, no currency symbol, no commas | Text such as ₹ 1,200.00 instead of 1200 |
| Narration | A readable description of the entry | Blank, or a long UPI reference code |
| Reference | Bill number, cheque number or UTR | Reusing one reference across unrelated entries |
How do I turn a tracker export into those columns?
An expense tracker export usually gives date, description, category, amount and account. Map each to a voucher field.
- Date: convert to one consistent format and check no cell is stored as text.
- Voucher type: for money going out of a bank or card, Payment; for money coming in, Receipt. Anything else, such as moving cash to the bank, is a Contra or Journal in most set-ups.
- Debit ledger: the category becomes the expense ledger. Keep a small mapping table, for example category Groceries to a ledger called Office Pantry, so the same names are used every time.
- Credit ledger: the account (bank, card, cash) becomes the ledger the money came out of.
- Amount: one positive number per row; the voucher type already says which way the money moved.
- Narration: the cleaned description from your tracker, plus a reference if you have one.
What should I clean before importing?
- Trailing spaces in ledger names, which make two identical-looking names different.
- Merged cells, blank rows and subtotal rows inside the data range.
- Dates typed as text; test by sorting, and if they sort oddly they are text.
- Duplicate rows from importing the same statement twice.
- Refunds mixed in with expenses; decide whether each is a Receipt or a negative on the original.
Can SpendixAI help prepare this file?
SpendixAI's Export centre has a template for Tally, along with templates for Zoho Books and QuickBooks and a standard all-transactions file. Categories there can also carry an accounting code, which is a handy place to record the ledger you intend to use. Use the template as a starting point and compare its columns with what your own Tally setup expects; do not assume it will match every version or every set of ledger names.
What does one row look like as a voucher?
Take a hypothetical fuel payment. The sheet row reads: date 11/11/2026, voucher type Payment, debit ledger Fuel, credit ledger Current Account, amount 2400, narration Fuel for delivery van, November, reference UPI 4821.
As a voucher, that is a Payment dated 11 November in which Fuel is debited ₹2,400 and the Current Account is credited ₹2,400. A money-in row works the other way: a Receipt in which the bank is debited and the customer or income ledger is credited.
- If the credit and debit ledgers are swapped, the entry still balances but your reports will be wrong.
- If one row carries several expense lines for one payment, repeat the voucher number on each line, and check how your import route expects split entries to be laid out.
- Keep one test row per voucher type you plan to import, so you can see each type behave before you load a month.
Before you press import
- Ask your accountant which ledger names and voucher types they want used.
- Back up your Tally data first.
- Check that the total of the sheet's amounts equals the total of the bank or card statement for the period.
- Keep the cleaned file with the month's papers, so any entry can be traced to its row.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


