Convert a bank statement into a Zoho Books import
Upload a PDF, Excel or CSV bank statement and download a workbook containing a Zoho Books Import sheet — every transaction laid out as a double-entry voucher, ready to import into Zoho Books. The statement is processed entirely in your browser and is never uploaded.
What the Zoho Books import sheet contains
Once you classify the cleaned statement, the downloaded workbook gains a Zoho Books Import sheet using a two-line journal format with one debit leg and one credit leg per voucher.
- Each transaction produces two rows — the debit leg and the credit leg — which is the journal shape Zoho Books imports.
- The double-entry mapping is identical to the Tally export; only the row layout differs.
- Referenced ledgers are listed above the table so you can pre-create any that are missing in Zoho.
- Unresolved rows land in Suspense for review rather than being force-fitted to a head.
Why entries are never silently guessed
A voucher import that quietly assigns the wrong ledger costs more time to unpick than manual entry would have taken. So every row that the classifier cannot resolve with confidence is parked in Suspense and counted, rather than being pushed into a plausible-looking head.
The list of every ledger the sheet references is printed above the table, so you can create any missing ledgers in Zoho Books before you import. Transfers between your own accounts are routed to a Contra / Own Transfer ledger — the account holder's name is read from the statement header, so a transfer to yourself is never booked as income.
Teach it once, and it remembers
Rows left in Suspense can be resolved in bulk from the worklist. Assign the correct ledger head, tick "Teach rule", and the keyword pattern is saved in your browser — every matching row in that statement reclassifies immediately, and every future statement you clean uses the same rule.
Because the classifier is rule-based rather than a machine-learning model, every classification is explainable: you can see which rule matched, edit it, and delete it. Nothing about your transactions is sent to a cloud categorisation service.
Frequently asked questions
How do I import the sheet into Zoho Books?
Download the cleaned workbook after classifying, choose Zoho Books from the format selector before downloading, then use Zoho Books's own Excel import to bring the Zoho Books Import sheet in. The columns are already in the shape it expects.
What happens to transactions it cannot classify?
They are parked in a Suspense ledger and the count is shown above the table, so nothing is silently misfiled. You can resolve them in bulk from the Suspense worklist before downloading.
Does the double-entry mapping differ between accounting packages?
No. Money out is always a Payment (debit the ledger head or counterparty, credit the bank ledger) and money in is always a Receipt (debit the bank, credit the income or party ledger). Only the row layout changes — Tally and Vyapar use one row per voucher, Zoho Books and QuickBooks use a two-line journal.
Is my statement sent to a server to generate the Zoho Books sheet?
No. Parsing, classification and Excel generation all run in your browser. The workbook is assembled on your own machine and downloaded directly from the page.