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 to read and check a statement, and 5 pages a day download free with a free account. A PDF with text is read in your browser and not uploaded; scans and photos go to AI only if you choose.
5 statement pages free every day with a free account, and every row and the balance check to see first. A Statement Pass covers bigger jobs, paid once.
- Stays on your deviceA PDF with text is read in this browser and never uploaded. A scan is sent to our AI provider only if you choose.
- Checked against the balanceEvery row has to land on the running balance the bank printed, so a misread figure shows up before it reaches your books.
- Nothing keptNo statement or download is stored on our servers, and a password only opens the file.
See it before you upload
From PDF lines to rows your books accept
The first rows of the made-up sample statement, as printed and as you download them. Press “Try a sample statement” above to open all of it.
What the statement prints
- 08/01POS PURCHASE BLUE DOOR COFFEE #12 SEATTLE WA5.45Withdrawals
- 08/02CHECK 10451,200.00Withdrawals
- 08/03ACH DEPOSIT NORTHWIND LLC PAYROLL2,500.00Deposits
- 08/05WIRELESS BILL AUTOPAY89.99Withdrawals
- 08/08POS PURCHASE BLUE DOOR COFFEE #12 SEATTLE WA6.10Withdrawals
What you download
- Blue Door Coffee SeattleRestaurants and takeaway−$5.45Aug 1
- Check 1045Uncategorized−$1,200.00Aug 2
- Northwind LLC PayrollPayroll and wages+$2,500.00Aug 3
- Wireless Bill AutopayPhone and internet−$89.99Aug 5
- Blue Door Coffee SeattleRestaurants and takeaway−$6.10Aug 8
Reconciled: every running balance matches
Opens in the software you use
- QuickBooks OnlineQBO or CSV
- QuickBooks DesktopQBO or IIF
- XeroOFX or CSV
- QuickenQFX
- SageCSV
- WaveCSV
- FreeAgentCSV
- MYOBOFX or QIF
- Zoho BooksCSV, OFX or QIF
- GnuCashOFX or QIF
- Excel and Google SheetsXLSX or CSV
- TallyXML
Product names belong to their owners; Toolspike is not connected with them. Each file is one that program’s own import reads.
Insights on every statement
- Average daily balance
- $7,103.26
- Biggest spending category
- Rent and mortgage, $2,000.00
- Recurring payment found
- Blue Door Coffee Seattle, weekly, about $5.45
- Returned, NSF or overdraft rows
- 1
Figures from the made-up sample. Your own statements get the same panel, and the full lists in the Insights sheet of the Excel download.
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.