Guide
How to import bank and credit card statements into Zoho Books
Zoho Books can import transactions into a bank or credit card account from a CSV, TSV, XLS, OFX, QIF, CAMT.053, CAMT.054 or MT940 file, and it reads a PDF statement only from the short list of banks and card providers it supports. This page covers a Zoho Books bank statement import from a CSV file, for a bank account and a credit card account: the file Zoho Books expects, what changes for a card, the errors that stop an import, and a recorded walkthrough of the whole thing. MatchLedger reads your statement from a PDF, CSV or Excel file. It then writes the CSV that Zoho Books imports. See how MatchLedger works.
Recorded September 2026
What the walkthrough says
Recorded September 2026
- From bank statement to posted transactions, with no manual entry. MatchLedger extracts your statement and exports it in a Zoho Books-ready format, so Zoho Books can match and reconcile it for you.
- Upload your bank statement to get started.
- Select your statement file.
- Click Upload. MatchLedger takes it from here.
- Feel free to close this. We'll email you when it's ready.
- Export your transactions in seconds.
- Select your platform to stay in sync.
- Pick Zoho Books - Bank. No new setup needed.
- Download your CSV and you're set.
- With your CSV downloaded, go to Zoho Books and click Banking to continue.
- Choose the account you'll upload your downloaded CSV to.
- Import your statement. We take it from there.
- No copy-paste, just choose a file.
- Pick where you saved the file. Desktop or Documents both work.
- You'll need to specify how amounts are formatted here.
- Go with this one, since it matches what MatchLedger already gives you.
- One step closer to reconciled books.
- Just one detail left to confirm.
- Import now. Everything's ready to go.
- Zoho recognizes existing rules right away. Just click Categorize to post.
- No match? Enter the details manually. You're covered.
- This is the only part you'll fill in manually. Everything else is already taken care of.
- Save to finish. One less task on your plate.
- Unlike rules, bills and invoices need a manual check. Click the row to see if one exists.
- Here it is, the matching invoice. Click Match and it's posted.
- Same idea here. See if a bill lines up with this transaction.
- There it is. Hit Match and it's posted.
- Same check needed here. Take a look for a match.
- There's the bill. Select Match to close it out.
- Everything settled, in one view.
- That wraps things up. Your Dashboard keeps everything in one live view, always in sync.
- Now your entire statement is categorized and matched in Zoho Books. Rules applied automatically, bills and invoices confirmed with a click, even across hundreds or thousands of transactions. That's the full workflow: from bank statement to accurate books, in minutes instead of hours.
The file Zoho Books accepts
| What | What Zoho Books needs | What MatchLedger's export writes |
|---|---|---|
| File type | A CSV, TSV, XLS, OFX, QIF, CAMT.053, CAMT.054 or MT940 file. A PDF statement only from the banks and card providers Zoho Books lists. | A CSV file. Several statements at once come back as a ZIP with one CSV per statement. |
| Columns | A heading row that Zoho Books maps to its own fields, auto-selecting the best match for each heading. You also choose the file's character encoding and delimiter. | Four comma-separated columns with a heading row: Date, Description, Reference Number, Amount. |
| Amount layout | One of three layouts: Double Column (deposits and withdrawals in separate columns), Single Column and Amount Type (an amount plus a debit or credit column), or Single Column with Negative Values (one signed amount). | One signed Amount column, for the Single Column with Negative Values layout. |
| Amount sign | In a single signed column, a positive amount is a deposit and a negative one a withdrawal. In the other two layouts every amount is positive. | Bank: withdrawals negative, deposits positive. Card: charges negative, payments and credits positive. |
| Date format | Every date in one format. Zoho Books lists an incorrect date format among the common reasons a statement import fails. | MM/DD/YYYY for a statement written month first. A statement written day first exports as YYYY-MM-DD. |
Pick Zoho Books when you export from MatchLedger and the file comes out in this shape, with headings named after Zoho Books' own fields. Both of its Zoho Books exports, bank and card, are marked Verified in the app, each checked with a live import into Zoho Books. See the supported exports.
Importing a credit card statement
- It goes into a credit card account. A card is a liability, so its statement belongs in a credit card account, not a bank account. In Zoho Books that is an account of the Credit Card type, and a card statement goes into it through the same statement import as a bank account's.
- The signs flip. On a card, a charge increases what you owe and a payment reduces it, the opposite of a bank account, and Zoho Books expects its own convention for which is which. Zoho Books reads a single signed column the same way on both: a positive amount is a deposit and a negative one a withdrawal. On the card, a payment or refund is the deposit and a charge the withdrawal.
- A card payment is a transfer. The payment leaves your bank account and arrives on the card, so it shows up on both statements. Match it once as a transfer, rather than booking it twice as an expense and as income. Zoho Books' help describes a transfer between two of its accounts as a withdrawal in one and a deposit in the other: categorize the withdrawal as Transfer To Another Account, then match the deposit in the receiving account to it, so the money is recorded once.
MatchLedger's Zoho Books card export writes charges as negative amounts and payments as positive ones, the convention confirmed by a live import into a Zoho Books credit card account. See the export formats.
Common Zoho Books import errors
Why does Zoho Books say my bank statement file format is not supported?
Zoho Books imports a statement from a CSV, TSV, XLS, OFX, QIF, CAMT.053, CAMT.054 or MT940 file, and it reads a PDF only from the banks and card providers it lists. Any other file, including a PDF from a bank that is not on that list, is rejected as an unsupported format. Turn the statement into a CSV first. MatchLedger reads the PDF and writes a CSV in the shape Zoho Books imports.
Why won't Zoho Books import the negative amounts in my bank statement?
The amount layout chosen at import does not match the file. With Double Column or Single Column and Amount Type, Zoho Books expects every amount to be positive, so a minus sign stops the import. A file with one signed amount column needs the Single Column with Negative Values layout, where a negative amount is a withdrawal. MatchLedger's Zoho Books export is written for that layout.
Why do my dates fail or come in wrong when I import transactions into Zoho Books?
Zoho Books lists an incorrect date format among the most common reasons a statement import fails. A date written day first, such as 03/09/2026 for 3 September, is read as 9 March when the file is treated as month first. Keep every date in the file in one format and make sure the date format Zoho Books uses for the file is that same one. MatchLedger exports a statement written day first with YYYY-MM-DD dates, which cannot be read the wrong way round.
How do I fix duplicate transactions after a Zoho Books bank statement import?
If the whole statement went in twice, or into the wrong account, Zoho Books can undo the last import, and then you import the right file once. A few stray duplicates can be excluded so they stay out of your reports. A transfer or card payment appears on both accounts by design: match the two sides instead of categorizing each one, so the money is recorded once.
Why are my credit card charges showing up as deposits in Zoho Books?
Either the statement went into a bank account instead of the card's Credit Card account, or its amounts are signed the other way round, with charges positive, while the import reads a positive amount as a deposit. Check the account first. If the account is right, undo the import and bring in a file where charges are negative. MatchLedger's card export writes charges as negative and payments as positive, the convention confirmed by a live import into a Zoho Books credit card account.
Imported is not the same as reconciled
An import checks the shape of the file, not whether it holds every transaction the statement lists. Once the month is in Zoho Books, reconcile the ledger back against the statement itself, so a missing or duplicated transaction shows up before you close the month rather than after. Extraction gets the data in. Reconciliation is what lets you say the month is right. See how MatchLedger does both.
Turn your bank and credit card statements into a CSV for Zoho Books, then reconcile the month against the statement.
Start FreeOnly one statement to do? Convert it with the free converter.