Guides

How to Import Bank Statements into Zoho Books from a PDF

Zoho Books imports bank statements, but only from files it understands — and a PDF from most banks is not one of them. Zoho's own PDF import works for a short list of banks, and its bank feeds only reach back 90 days. Everything older, and every statement from a bank outside that list, has to arrive as a file you prepare yourself. This guide shows how to import bank statements into Zoho Books from a PDF: convert the file with a bank statement converter, shape it to Zoho's CSV layout, upload it, and check that what landed matches the statement.

When you need to import bank statements into Zoho Books by hand

Use a manual import when the automatic routes cannot give you the lines. The three common cases are history older than 90 days, a bank with no Zoho feed, and a statement that exists only as a PDF. Zoho Books brings live transactions in through bank feeds (Yodlee, Plaid or Token, depending on your edition), but a connected feed can only fetch the last 90 days. Anything older must come in through a statement import, and your bank may not appear in the feed list at all.

Zoho's built-in PDF import does not close the gap for most people. It works only for a short list of banks — in the US, Chase, Bank of America, TD Bank, Truist, Regions, Capital One and American Express cards; in Canada, RBC, CIBC, National Bank of Canada and Kindred Credit Union — and uploaded PDFs are processed through a third party, Perfios. If your bank is not on that list, which covers most banks and credit unions, the file Zoho needs is a CSV made from that PDF.

  • Write down the missing date range for one bank account before you start.
  • Keep each bank and card account in a separate file — Zoho imports one account at a time.
  • Keep the original PDF beside the converted file, so any row can be traced back to the page it came from.
  • Import one month at a time for a long cleanup, rather than a whole year in one file, so a mistake stays small.

What Zoho Books accepts, and what your PDF becomes

Zoho Books accepts CSV, TSV, OFX, QIF, CAMT.053, CAMT.054 and MT940 files for statement import, and PDF only for the listed banks above. Statement import works only for bank and credit card accounts you created manually in Zoho Books — you cannot import into an account that a feed created for you. Imported lines arrive uncategorised, ready to match or categorise, which is exactly what you want: the import puts the lines in, and you decide what they mean afterwards.

RouteWhen to use itWhat to watch
CSV (recommended)Any bank, any period; the route this guide followsYou must pick the right Amount Column Type and map the fields
OFXYou import the same account every month and want no column mappingCurrency and account type must match the Zoho account exactly
Zoho's built-in PDF importYour bank is on Zoho's short list and the statement is recentOnly listed banks; older history still needs a file
Bank feedLive transactions from a supported bank, last 90 daysCannot fetch older history or unsupported banks
The two practical routes from a PDF to Zoho Books.

This guide follows the CSV route because it works for every bank and every period, and because a CSV can be checked line by line before Zoho ever sees it. If you prefer OFX, the conversion step is the same and the import steps are nearly identical — Zoho reads the account and period from the file itself, so there is no column mapping. Our comparison of OFX, QBO and QIF formats explains when each format earns its place.

Step 1: Convert the PDF to a file Zoho Books can read

Zoho Books cannot read a PDF statement from an unlisted bank, so convert the PDF first. Drop it into the bank statement converter and review every row against the PDF page before you download anything. Check the balance result: opening balance plus money in, minus money out, should equal the closing balance printed on the statement. That check is the whole point of converting through a tool that verifies balances, rather than copying numbers by hand.

A balance check matters more for Zoho Books than for a spreadsheet. A spreadsheet error stays visible on screen. A wrong line inside Zoho gets categorised, matched to an invoice, and can end up on a report before anyone notices. Our guide on how to check a bank statement conversion explains the test in detail, and our guide to why a bank statement does not balance covers the common causes when the numbers refuse to agree.

  • Convert one account and one statement period per file — never mix two accounts in one CSV.
  • If the PDF is a scan, confirm the converter read it with OCR and check the figures, not just the dates: OCR misreads digits more often than words. Our guide to scanned vs digital bank statements explains the difference.
  • If the PDF is password-protected, unlock it once for the conversion; the password is used to open the file and is never stored. See our guide to password-protected bank statement PDFs.
  • If you have a year of statements, convert them in batches and import month by month — our guide to converting multiple bank statements at once shows how to keep the batch organised.

Step 2: Pick Zoho's Amount Column Type before you shape the CSV

Zoho Books offers three Amount Column Types, and choosing the wrong one is the most common reason an import comes out with every amount positive or every withdrawal missing. Decide first, then shape the file to match — do not shape the file and hope the setting fits.

Amount Column TypeWhat Zoho expectsBest for
Single Column with Negative ValuesOne Amount column: deposits positive, withdrawals negativeThe simplest match for a converted statement
Double ColumnTwo columns: one for deposits, one for withdrawals; every amount positiveStatements that already split money in and money out
Single Column and Amount TypeOne Amount column plus a separate column saying debit or credit; every amount positiveFiles that carry an explicit debit/credit marker
Zoho Books Amount Column Types: what each one expects.

Zoho's own knowledge base names "Negative value in the amount column" as an import error: with Double Column or Single Column and Amount Type, every amount must be positive, and a negative number is rejected. So if your converted file has one signed Amount column — deposits positive, withdrawals negative — choose Single Column with Negative Values. If you choose one of the other two, you must strip the minus signs first and put the direction somewhere else, or the import will fail on the first withdrawal it meets.

Do not mix signs and columns. A file with a signed Amount column uploaded as Double Column will import withdrawals as deposits, and the account will be wrong by twice the amount of every payment. If the preview looks wrong, stop and fix the file — do not import and hope to sort it out later.

Step 3: Shape the CSV to Zoho's layout

A normal statement conversion gives you a Date, a Description, an Amount, and a running balance, often with separate money-in and money-out columns. Zoho needs a small, clean version of that. Download CSV from the bank statement converter, then reshape it to the layout below. Keep the header row: Zoho's Map Fields step reads the headers to offer the mapping.

Converted fileZoho CSVNotes
Date columnDateUse a consistent format; Zoho accepts common date formats, but one format throughout the file
Money in + money outAmount (signed)Deposits positive, withdrawals negative, two decimal places
Description / narrativeDescriptionKeep the bank narrative; add a reference where you have one
Running balanceRemoveZoho does not need it on import, and it is not a transaction
Summary and header rowsRemoveOpening balance, totals and fee notes are not transactions
From a converted statement to Zoho's CSV (Single Column with Negative Values).
  • Remove currency symbols, commas inside numbers and blank rows.
  • Keep one transaction per row, even when the PDF wrapped its description over two lines.
  • Save the file with a .csv extension and keep the comma delimiter; Zoho lets you choose the delimiter, but comma is the least surprising choice.
  • Zoho allows up to 5 files of up to 5 MB each per import, so split a very long period rather than forcing it into one oversized file.

Step 4: Import bank statements into Zoho Books, step by step

  1. In Zoho Books, open Banking on the left sidebar and select the bank or credit card account. The account must be one you created manually — statement import is not available for feed-created accounts.
  2. Click the gear icon in the top right corner and choose Import Statement. (On some editions the button reads Import Statement at the top right of the account page.)
  3. Choose the file from your desktop. Pick CSV as the format if Zoho asks, then select the Amount Column Type you decided in Step 2 — Single Column with Negative Values for a signed Amount column.
  4. Select the character encoding (UTF-8 by default) and the file delimiter (comma), then click Next.
  5. On the Map Fields tab, match each imported header to the Zoho Books field: Date to Date, Amount to Amount, Description to Description. Save the mapping if you will import the same account again next month.
  6. Check the preview. Confirm the dates read the right way round, withdrawals show as negative, and the first and last transactions match the PDF.
  7. Click Import. The lines land as uncategorised bank transactions, ready to match or categorise.

If Zoho rejects the file, check the format before trying again: the Amount Column Type against the signs in the file, the comma delimiter, the .csv extension, and the account being a manually created one. A file saved from a spreadsheet as semicolon-separated is the most common cause, followed closely by a signed Amount column uploaded under Double Column.

After the upload: match, categorise, then reconcile

Importing and bookkeeping are two separate jobs, and keeping them separate is what lets you review the file before it touches the books. Each imported line needs attention: match it to an invoice or bill, categorise it, or mark it as a transfer between your own accounts. Work through the oldest transactions first, and reconcile the account as you go. If the Zoho balance for the month does not match the PDF closing balance, the file was wrong before Zoho saw it — go back to the conversion check rather than fixing lines one by one inside Zoho.

The same discipline applies whatever system you use. Our guides to importing bank statements into Xero, importing bank statements into QuickBooks and importing bank statements into Sage follow the same pattern — clean, balance-checked file, the target system's own layout, a defined date range, review before reconcile — so a practice that handles several systems can keep one conversion workflow and export the right file for each. And if you reconcile in a spreadsheet first, our guide to reconciling a bank statement in Excel after converting PDF to CSV shows how to catch conversion errors before they reach any accounting system.

Duplicates, date errors and other import problems

ProblemLikely causeWhat to do
"Negative value in the amount column" errorSigned amounts uploaded under Double Column or Single Column and Amount TypeSwitch to Single Column with Negative Values, or strip minus signs and use two columns
Dates are a month and day swappedFile uses MM/DD/YYYY but Zoho read DD/MM/YYYY, or the reverseDelete the upload, fix the date format, and re-import
Money out shows as money inSigned column uploaded as Double Column, so negatives were read as positivesRebuild the file with the matching Amount Column Type and re-import
The same lines appear twiceThe period overlaps a bank feed or a previous importUse Undo Last Import from the gear menu, then narrow the next file to start the day after the last existing transaction
Upload is rejectedWrong delimiter, wrong extension, or more than 5 files / 5 MB per fileSave as comma-delimited .csv within the size limit, one account per file
A row imports as 0.00A summary or fee note was converted as a transactionRemove zero rows before import; they are not statement lines
Account missing from the import listThe account was created by a bank feed, not manuallyCreate the account manually in Banking, or import into the existing manual account
Problems people hit when they import bank statements into Zoho Books, and the fix for each.

Zoho Books lets you undo a statement import from the gear menu — Undo Last Import — so a bad file is recoverable. Use that rather than deleting transactions one at a time: it is faster, and it leaves no stray lines behind. Then fix the file, narrow the date range to the missing days, and import again. That loop — convert, balance-check, import, verify — is the whole workflow, and it turns a shoebox of PDFs from a new client into a set of monthly imports you can prove, one statement at a time.

Sources and further reading

Put it into practice

Convert a statement now and watch the balance check run on your own file. The first 10 pages each month are free, and exports are never cut short.

Convert a statement See plans

More guides

How to Convert a Bank Statement PDF to CSV · How to Convert a Bank Statement PDF to Excel · How to Import Bank Statements into QuickBooks (QBO Files) · OFX vs. QBO vs. QIF: Which Format Should You Download? · Why a Converted Bank Statement Does Not Balance — and How to Fix It · How to Check a Converted Bank Statement Is Correct · Scanned vs. Digital Bank Statements: Why One Converts and the Other Does Not · How to Convert a Password-Protected Bank Statement PDF · How to Convert Many Bank Statements at Once (and Merge Them Cleanly) · Is It Safe to Convert Bank Statements Online? A Privacy Checklist · How to Import Bank Statements into Xero · How to Reconcile a Bank Statement in Excel After Converting PDF to CSV · How to Import Bank Statements into Sage from a PDF · How to Import Bank Statements into FreeAgent from a PDF