Convert bank statements from Excel into clean Tally Receipt and Payment vouchers with automatic debit/credit recognition, automated balance audit verification, and monthly XML splitting.
VinTax uses simple Excel column letters instead of confusing 0-based indices. Simply enter the letter of the column from your bank spreadsheet:
| Setting Field | Default Letter | Description & Example |
|---|---|---|
| Data Start Row | 2 (Row number) |
Row number where transactions begin. If your bank statement has account headers in rows 1–10, set this to 11. |
| Date Column | A |
Transaction date (e.g. 01/04/2026, 2026-04-01, 01-Apr-2026) |
| Narration | B |
Description, remarks, or transfer details from bank |
| Withdrawal | C |
Debit amount column (outward payments/charges) |
| Deposit | D |
Credit amount column (inward receipts/collections) |
| Balance | E |
Running closing balance column (used for audit verification) |
Whenever a deposit amount > 0 is found:
SBI Bank)Suspense)Whenever a withdrawal amount > 0 is found:
Suspense)SBI Bank)VinTax performs an automated reconciliation check between consecutive row closing balances:
Calculated Balance = Last Balance + Deposit - Withdrawal.
If any difference is detected (e.g. a bank charge row was missing or hidden), VinTax highlights the exact row number, date, and missing amount so you can review it before importing into Tally.
.xlsx or .xls) format.Suspense).