To import a bank statement into Zoho Books, open Banking, select the manually created bank or card account, click the gear icon and choose Import Statement. Upload a CSV, TSV, OFX or QIF file, pick how amounts are laid out, map the columns, check the preview and import. Then reconcile against the statement's closing balance.
Which bank statement formats can Zoho Books import?
Zoho Books imports bank statements as CSV, TSV, OFX, QIF, CAMT.053, CAMT.054 and MT940 files, and as PDF for a short list of banks. Zoho's help page on adding bank transactions gives that list and says statement import is for bank and credit card accounts you created manually.
That last condition matters. Statement import is described for accounts you added by hand, such as an account at a small bank with no feed, an old account you closed, or a card you want to keep separate.
Which file to download depends on what your bank offers:
- OFX or QIF. The fields are labelled inside the file, so there is less to map.
- CSV or TSV. The most common download. You tell Zoho Books which column is which.
- CAMT.053, CAMT.054 or MT940. Formats used mostly by banks outside the US. Pick one if your bank offers it.
- PDF. Only for the banks Zoho Books supports for PDF import, covered below.
If your bank offers several, an OFX file usually takes the fewest decisions. A CSV is easier to open and check by eye first. Either works if the content is right.
Zoho Books Import Statement steps for a manual bank account
The Zoho Books Import Statement option sits under the gear icon on a bank account's page in the Banking module. You upload the file, choose the amount layout and file settings, map the columns, preview and import. Every step after the upload is a chance to catch a problem before it reaches your books.
The steps from Zoho's help page, in order:
- Go to Banking and select the bank or credit card account.
- Click the gear icon and choose Import Statement.
- Upload the statement file from your computer.
- For a CSV or TSV, choose the amount column type, the character encoding and the file delimiter.
- On the Map Fields screen, match each header in your file to a Zoho Books field.
- On the Preview screen, look for errors and unmapped fields. Use Previous to go back if something looks wrong.
- Click Import.
Zoho suggests checking your file to confirm its character encoding. If payee names arrive with odd symbols, such as accented letters turned into boxes, the encoding chosen in step 4 doesn't match the file. Go back and try the other common choice.
Zoho Books also lets you forward statements by email. Forwarded files appear under Bank Statements From Inbox in the Banking module, and you click Add to Bank to import them. They pass through the same mapping steps as an upload.
Picking the Zoho Books amount column type for your CSV
Zoho Books offers three amount column types for a CSV or TSV statement: a double column with separate deposits and withdrawals, a single column with an amount type marking debit or credit, and a single column where negative values are withdrawals. Choose the one that matches how your bank laid out the file, not the one you would prefer.
The table shows each layout with example rows. The values are made up.
| Amount column type in Zoho Books | What your file looks like | Example row |
|---|---|---|
| Double Column | One column for deposits, another for withdrawals | 2026-05-03, OFFICE SUPPLIES, (deposit blank), 64.20 |
| Single Column and Amount Type | One amount column plus a column saying debit or credit | 2026-05-03, OFFICE SUPPLIES, 64.20, Debit |
| Single Column with Negative Values | One signed amount column | 2026-05-03, OFFICE SUPPLIES, -64.20 |
Getting this wrong has a recognizable result. If you pick the signed single column for a double-column file, Zoho Books may read only one of the two money columns. If you pick double column for a signed file, every withdrawal can arrive as a deposit. The preview shows the problem before import, so read a few rows of it closely.
Credit card files need a second look. On a card statement, a purchase increases what you owe. Check in the preview that purchases land as spending and payments to the card land as money in.
Mapping CSV headers to Zoho Books fields
Mapping in Zoho Books means telling it which header in your CSV fills each of its fields, such as the date, the description and the amount. Zoho selects the best matches for you, and you can save your choices so the next import from the same bank is already mapped.
Look at each automatic match rather than accepting all of them. Common trouble spots:
- Two date columns. Some banks give a transaction date and a posting date. Pick one and use the same one every month.
- Description versus reference. Map the column with the payee name to the description. A reference or check number column is useful, but it shouldn't stand in for the payee.
- Balance column. A running balance is not a transaction amount. Leave it unmapped unless Zoho offers a field meant for it.
Before you upload, check the date style in the file. A file that switches between styles, such as 05/03/2026 on one row and 2026-05-04 on the next, may be read in two different ways. Make every row use one style.
Saving the mapping pays off quickly. A business that imports one statement a month repeats these choices twelve times a year otherwise, and each repeat is another chance to map a column wrongly.
Will Zoho Books read the PDF statement itself?
Zoho Books reads a PDF statement only for specific banks and card issuers, and Zoho's help page names Chase Bank, TD Bank and American Express as examples. For a supported bank, you choose the bank's name during import, enter the password if the PDF is protected, check the preview and import.
For every other bank, the PDF needs converting first. The usual target is a CSV with one row per transaction and either one signed amount or separate money columns. Whichever layout you produce, pick the matching amount column type described earlier.
Before you convert, ask the bank whether the same months are available as a download. A bank file avoids conversion errors entirely. For a closed account or very old months, the PDF may be all there is.
SimpleBankConvert is being built to turn digital PDF statements into clean CSV files with one date format and one signed amount column. It targets QuickBooks and Xero, so treat a Zoho Books import as something to test with one statement first, and follow along as accounts open.
Undoing a doubled or wrong Zoho Books statement import
Zoho Books has an Undo Last Import option for a statement uploaded twice or into the wrong account. Click the gear icon on the account and choose Undo Last Import. Zoho shows the transactions it will delete, and you confirm with Undo Import. As the name says, it works on the last import, so act before importing again.
Use it in these cases:
- You uploaded the same statement twice.
- You imported into the wrong bank or card account.
- The preview looked fine, but the amounts came in with the wrong sign.
- The dates landed in the wrong month or year.
Fix the file before the next attempt. If the problem was the amount column type or the mapping, choose differently in the import steps. If it was the file, correct the file. Then import again and check the result.
This kind of clean-up exists in every accounting program, and the steps differ. If you also keep books in Sage, compare the process in how to import a bank statement into Sage Accounting and in how to import a bank statement into Sage 50.
A statement import is also the fallback when a bank connection stops asking politely and demands more security steps. In QuickBooks that shows up as QuickBooks error 185, where the bank wants more information. In Zoho Books, uploading a statement for a manual account covers the days a broken connection would have missed.
Reconciling the Zoho Books account to the statement closing balance
Reconciling in Zoho Books proves the import is complete by matching its cleared total against the statement's closing balance. Zoho's reconciliation help page has you enter the start date, end date and closing balance, select the transactions, and finish when the difference is zero.
The steps:
- In Banking, open the account, click the gear icon and choose Reconcile Account.
- Click Initiate Reconciliation at the top right.
- Enter the statement's start date, end date and closing balance.
- Select the transactions that appear on the statement. Zoho's page says only matched, categorized or manually added transactions are listed, so match or categorize the imported lines first.
- Check that the closing balance and the cleared amount match, with a difference of zero.
- Click Reconcile.
Zoho warns that the opening balance can't be edited once transactions are reconciled. So check the opening figure against the statement before your first reconciliation on a new account.
A worked example
Example values for a May statement: opening balance 2,480.00, closing balance 2,915.30. If the difference shows 64.20 after you select every imported line, look for a 64.20 line. Most likely it is missing from the import. A line with a flipped sign leaves twice its amount instead, so a 64.20 line imported as a deposit would show 128.40. A zero difference means you can close the month.