Bank statement to Tally
Entering a month of bank transactions into Tally by hand takes hours. This converter reads the PDF statement, checks it against the running balance, and writes an XML file that Tally imports as vouchers: a Payment for money out, a Receipt for money in, and a Contra for cash.
No sign-up. Your statement is read in your browser; nothing is uploaded.
Free trial: 1 run of Bank Statement Converter every day. After that, 2 credits per run.
How rows become vouchers
- Money out: a Payment voucher, crediting the bank ledger
- Money in: a Receipt voucher, debiting the bank ledger
- ATM and cash withdrawals or deposits: a Contra with the cash ledger
- Rules send rows that mention a word to the ledger you name
- Rows no rule matches go to one ledger, Suspense by default, to sort in Tally
- The description and reference become the voucher narration
Importing into TallyPrime
Open the company and press Alt+O to import. If the ledgers named in the file do not exist yet, choose Masters first and give the path of the ledger file. Then import again, choose Transactions, and give the path of the vouchers file. In Tally.ERP 9 the same steps are under Import of Data on the Gateway of Tally.
Writing ledger rules
Put one rule on each line: a word or phrase from the description, then =>, then the ledger name exactly as it is in Tally. For example, "salary => Salary Payable" or "electricity => Electricity Charges". The first rule that matches a row decides its ledger, and matching ignores capital letters.
Questions
Why did Tally skip some vouchers?
Tally rejects a voucher that names a ledger it cannot find. Check that the bank ledger is spelled exactly as in Tally, and import the ledger file under Masters before the vouchers so every ledger in your rules exists.
Does it work with Tally.ERP 9 as well as TallyPrime?
Yes. The file uses the XML import format both versions read. In Tally.ERP 9, go to Import of Data from the Gateway of Tally and choose Masters or Vouchers instead of pressing Alt+O.
Can I import into a particular company?
Type the company name in the Company box and the file names it, so Tally imports into that company as long as it is open. Leave the box empty to import into the company that is active.
What happens to rows in the Suspense ledger?
They are imported against Suspense so the bank balance is right straight away. Alter each voucher in Tally later to move it to the correct ledger, or add a rule and convert the statement again.