Business

Tally import file: the columns a voucher import needs

The fields to hold in a sheet before bringing entries into Tally: date, voucher type, ledger, amount, narration and reference, and how to prepare them.

Editorial illustration for Tally import file: the columns a voucher import needs

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?

FieldWhat it holdsCommon trap
DateThe day the transaction happened, one format throughoutMixing 05/11/2026 with 5 Nov 2026
Voucher typePayment, Receipt, Journal, Contra, Sales, PurchaseUsing Payment for a transfer between your own banks
Ledger (debit side)Usually the expense or asset ledgerSpelling that differs from the ledger name already in Tally
Ledger (credit side)Usually the bank, cash or party ledgerWriting the bank's name instead of your ledger name
AmountPositive number, no currency symbol, no commasText such as ₹ 1,200.00 instead of 1200
NarrationA readable description of the entryBlank, or a long UPI reference code
ReferenceBill number, cheque number or UTRReusing 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.

  1. Date: convert to one consistent format and check no cell is stored as text.
  2. 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.
  3. 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.
  4. Credit ledger: the account (bank, card, cash) becomes the ledger the money came out of.
  5. Amount: one positive number per row; the voucher type already says which way the money moved.
  6. 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.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports