User Guide · Bring in data
Journal entries from Excel
Import journal, receipt, payment and contra vouchers from a simple Excel template.
Open Journal Entry, choose the client and click Download template. Type one entry per row. Blue columns are required. In every entry, debits must equal credits.
The template has 10 ledger pairs (Ledger 1 / Amount 1 up to Ledger 10 / Amount 10). Fill them left to right, with no gaps. The last column, Difference (must be 0), adds up the amounts for you: it shows 0 when the entry balances. Don't type in it. The grey EXAMPLE row is never imported; delete it or leave it. Your own file also works if it has one ledger per row (Date, Voucher No, Ledger, Dr and Cr).
The columns
| Column | What to enter |
|---|---|
| Vch. Date* | 01-05-2026, 2026-05-01, 01-May-2026 or an Excel date. Up to the last day of the current month (the dry run flags dates after today). Not before 2000. |
| Vch. Type* | Journal, Receipt, Payment, Contra, Sales, Purchase, Credit Note or Debit Note — or the client's own voucher types once they are pulled from Tally. |
| Vch. No. | Optional. If blank, Tally numbers the voucher. |
| Ref. No. / Ref. Date | Optional. Goes into the voucher's reference fields. Ref. Date is used only with a Ref. No. |
| Narration | Optional. |
| Ledger 1* to Ledger 10 | The ledger names exactly as they appear in the client's Tally. Ledger 1 and 2 are required. |
| Amount 1* to Amount 10 Cr/(Dr) | A plain number is a Credit: 25000. A number with a minus sign is a Debit: -25000 (a number in brackets, (25000), also works). |
| Difference (must be 0) | Shows 0 when the entry balances. Don't type here. |
Example, rent for May: Rent A/c -25000 and Landlord A/c 25000. Rent is debited ₹25,000 and the landlord credited ₹25,000.
Before anything is charged
- Picking a file runs a dry run. It shows the vouchers and credits, the rows that will be skipped and why, and ledger names not in the client's Tally.
- Nothing is charged until you click Upload & Process. Vouchers already imported are skipped free.
- The same entry under a different voucher number is imported and charged like any other voucher. If it was typed twice by mistake, delete one of them before pushing.
- If a row has a mistake (debits not matching credits, a ledger with no amount, an unreadable date), the whole voucher is skipped and the error names the sheet row. The rest of the file still imports.
- A voucher that changes nothing (same ledger debited and credited by the same amount) is skipped.
- Vouchers that share a Vch. No. are kept as separate vouchers when each balances on its own.
Reviewing and pushing journals
- Click the eye icon on an import to open its journals. Filter by Not pushed or Pushed and date.
- Tick vouchers and click Push selected, or Push on a single voucher.
- Undo push clears the pushed mark here; the voucher stays in Tally, so delete it there if unwanted. Re-push sends it again and Tally updates the same voucher.
- Journals cannot be edited. Delete it (the credit is not refunded) and import the corrected row.
One credit per voucher, charged when saved. Pushing, undoing and re-pushing are free. If you lack credits for the file, nothing is imported or charged.