How to import a bank statement into Zoho Books (CSV, OFX, QIF or PDF)

Zoho Books takes more statement formats than most accounting software: CSV, TSV, XLS, OFX, QIF, CAMT.053, CAMT.054 and MT940, plus PDFs from a short list of U.S. banks. The import itself is one screen. What decides whether it goes smoothly is picking the right file, the right Amount Column Type for a CSV, and checking the result before you reconcile. This guide covers all of it, with a sample statement you can try, and how to take an import back out.

1. The ways bank data gets into Zoho Books

From Zoho's banking help, there are four routes. Most businesses use two: a bank feed for new activity and a statement import for everything else.

You can also type transactions in by hand (Add Transaction, with Money Out and Money In tabs); they're labelled Manually Added. Zoho's help says statement import is for bank and credit card accounts you've added to Zoho Books, and its Add Accounts page points to a manual statement import for the history before a feed's start date. If your account is a corporate card fed directly through Zoho Expense, the Import Statement option is hidden, because the feed already brings the lines in.

2. Which file to import

Zoho's help and file-format article list these. Your bank's download page usually offers two or three of them.

An OFX statement is a text file with the account, one entry per transaction and the closing balance. These lines are from the OFX Utilly writes for the sample statement:

<BANKACCTFROM><BANKID>999999999<ACCTID>0427<ACCTTYPE>CHECKING</BANKACCTFROM>
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260901120000<TRNAMT>-6420.18<FITID>20260901E26D1A27070800<NAME>ACH DEBIT GUSTO PAYROLL 0912<MEMO>ACH DEBIT GUSTO PAYROLL 0912</STMTTRN>
<LEDGERBAL><BALAMT>13440.52<DTASOF>20260930</LEDGERBAL>

The same transaction in the sample's QIF file:

!Type:Bank
D09/01/2026
T-6420.18
PACH DEBIT GUSTO PAYROLL 0912
MACH DEBIT GUSTO PAYROLL 0912
^

Every tag is explained in sample OFX file, and the QIF codes in QIF format.

3. Import a statement, step by step

From Zoho's help page Add Transactions and its knowledge-base article How to import a bank statement:

1. Go to Banking on the left sidebar and select the bank or credit card account. If the account isn't there yet, add it with Add Bank or Credit Card → Add Account (account name, currency, account number, bank name).
2. Click the Gear icon in the top right corner and select Import Statement.
3. Click Choose File, then Choose File from Desktop (or Choose File from Documents), and pick the file.
4. For a CSV, TSV or XLS, select the Amount Column Type, the Character Encoding and the File Delimiter, then click Next.
5. On Map Fields, check that each of your file's headers is matched to the right Zoho Books field; Zoho pre-selects its best guess. Tick Save these selections for use during future imports if you'll import the same layout again. Click Next.
6. On Preview, look for errors and unmapped fields. Click Previous to change anything, then Import.

Import one account's statement into that account. For a credit card, select the card account in step 1; Utilly's card statement converter writes the same files for card statements.

4. CSV and Excel files: the Amount Column Type

This setting is where most CSV imports go wrong. Zoho offers three, and the right one depends on how your file holds the money:

Here are the sample statement's first two lines in each layout. Single Column with Negative Values:

Date,Description,Amount
2026-09-01,ACH DEBIT GUSTO PAYROLL 0912,-6420.18
2026-09-01,STRIPE TRANSFER ST-K2M8Q4,3184.27

Double Column:

Date,Description,Withdrawals,Deposits
2026-09-01,ACH DEBIT GUSTO PAYROLL 0912,6420.18,
2026-09-01,STRIPE TRANSFER ST-K2M8Q4,,3184.27

Single Column and Amount Type:

Date,Description,Amount,Type
2026-09-01,ACH DEBIT GUSTO PAYROLL 0912,6420.18,Debit
2026-09-01,STRIPE TRANSFER ST-K2M8Q4,3184.27,Credit

Zoho's error article is specific about the last two: "If you select Double Column, or Single Column and Amount Type in the Amount Column Type field, enter a positive value in the amount column." A file with minus signs belongs under Single Column with Negative Values.

Utilly's CSV is the first layout. These are the first rows of the sample statement's CSV:

Date,Description,Amount,Balance
2026-09-01,ACH DEBIT GUSTO PAYROLL 0912,-6420.18,5998.18
2026-09-01,STRIPE TRANSFER ST-K2M8Q4,3184.27,9182.45
2026-09-02,CHECK 2041,-1850.00,7332.45

Choose Single Column with Negative Values, then map Date, Description and Amount. The running Balance column doesn't need to be mapped. Keep the date column filled on every row: Zoho's article on the date field says it looks at the date and the amount to suggest a match for each line.

Two more settings from Zoho's error article: choose the Character Encoding that fits the file's language and script (UTF-8 for most exports), and watch the dates. The article lists "Incorrect date format" as a common error and says to enter dates in DD-MM-YYYY format. If the Preview tab shows dates in the wrong month or flags them, fix the date column in the file, or import the OFX instead, which writes dates as year, month, day.

5. PDF statements

Zoho Books imports PDF statements only from the banks and card providers its help lists. As of November 10, 2026 that list is: NOVO Bank, First Internet Bank, Chase Bank, Huntington Bank, Dollar Bank, TD Bank, First National Bank, Costco Anywhere Visa Card, American Express Card, Bank of America (bank and credit card), Regions Bank, Capstar Bank, Southwest Airlines Credit Card, Truist Bank, Chase Card, Chase Marriott and Capital One Credit Card.

If your bank is on it, try Zoho's own PDF import first: on the Import Statement screen, choose the file, select the Bank Name, tick This file is password protected and enter the password if the PDF has one, then Import and check the Preview. It's built into Zoho Books, so you don't need anything else.

If your bank isn't listed, or the PDF import can't read a statement, convert the PDF to a data file first. That's what Utilly's PDF to OFX converter does: it reads the statement, checks that the opening balance plus every transaction equals the closing balance, and writes an OFX, QIF and CSV of the same lines. Each statement becomes one file you can import with the steps above. Scanned PDFs of up to 10 pages are read with OCR; save a phone photo as a PDF first. For a business that's months or years behind, catch-up bookkeeping from bank statements covers the order of work.

6. After the import: match and categorize

Zoho's knowledge base says the imported lines "will be added as uncategorized transactions". Nothing is in your books until you deal with each one, from the account's Uncategorized Transactions tab. Zoho's matching help describes three outcomes:

• Match found. The line meets the criteria to match a transaction already in Zoho Books, such as an invoice payment or a bill payment. Check it and click Match. For a line without the tag, click it and pick from Possible Matches; you can select several transactions as long as their total equals the bank line.
• Recognized. A transaction rule you set up recognized the line and filled in the category. Verify and click Save, or bulk-categorize recognized lines with Categorize now.
• Neither. Click Categorize and fill in the transaction (expense, deposit, transfer and so on). Zoho creates the transaction from the statement line.

Duplicates: Zoho's article on duplicate transactions says Zoho Books excludes duplicated transactions automatically; you'll find them under Uncategorized Transactions → Excluded. To exclude others yourself, select them, click Exclude and give a reason. Excluded lines can be restored later. For a catch-up, setting up transaction rules for the payees that repeat (payroll, rent, card processors) before you import saves the most clicks.

7. Months before your bank feed started

When you connect a feed, Zoho lets you fetch transactions from a start date within the last 90 days. Its Add Accounts help says that for transactions before the selected date, you import statements manually. The usual pattern is:

1. Note the feed's start date. Don't import any statement lines dated on or after it, or you'll have the same activity twice.
2. For each earlier month, import that month's statement file into the same account, oldest first.
3. Match or categorize each month, and reconcile it (section 8) before moving to the next.

Zoho's feed help also explains why a feed can look a day behind: feeds are fetched every 24 hours for banks without multi-factor authentication, and a fetch brings in the previous day's transactions. Banks that use multi-factor authentication need a manual Refresh Feeds, which is limited to once a day.

8. Check the import, then reconcile

Before you reconcile, compare what came in with the statement. For the sample:

To reconcile, from Zoho's reconciliation help: in the account, click the Gear icon, choose Reconcile Account, then Initiate Reconciliation. Enter the statement's Start Date, End Date and Closing Balance, click Start Reconciliation, and select the transactions on the statement. Only matched, categorized and manually added transactions appear in the reconciliation window, so finish section 6 first. The Closing Balance and Cleared Amount must be the same, with a difference of zero, before you click Reconcile. Zoho also warns that the opening balance can't be edited once transactions have been reconciled, so check it first.

When the difference won't go to zero, finding bank reconciliation discrepancies shows how to find the line, and the free bank statement balance checker confirms the statement itself adds up.

9. Undo or delete an imported statement

• The last import was wrong (wrong file, wrong account, or the same statement twice): click the Gear icon and choose Undo Last Import. Zoho shows the transactions that will be deleted; click Undo Import.
• A line was matched or categorized wrongly: Zoho says matched or categorized statement lines can't be deleted directly. On the All Transactions tab, select it and click Unmatch (the line goes back to uncategorized, and the Zoho Books transaction to Manually Added, which you can then delete) or Uncategorize (the line goes back to uncategorized and the transaction created from it is deleted).
• Some lines from an older import shouldn't be there: select them on the Uncategorized Transactions tab and click Exclude, with a reason. They stay out of your reports and can be restored.
• Manually added transactions: filter Manually Added, select them and use Delete (Bulk Delete).

10. Common problems

11. Convert your own statement

Utilly reads a bank or credit card statement PDF, checks every transaction against the opening and closing balances, and writes OFX, QIF and CSV files for Zoho Books' Import Statement. PDF statements get a free preview; CSV, Excel and OFX files convert free up to 100 rows. Files are read in memory and not stored.

Utilly isn't affiliated with Zoho. Menu names change; the steps above are from Zoho Books' US help and knowledge base, checked November 10, 2026, and weren't run in a live Zoho Books organization. Sources: Add Transactions (Import Statement, Amount Column Type, PDF bank list, auto-forward, Undo Last Import), Add Accounts, Bank Feeds, Match & Categorize Transactions, Other Actions, Reconciliation, How to import a bank statement, Supported file formats, Errors while importing bank statements, Why fill the date field, Save import preferences, Undo last import, Delete a matched or categorized transaction, Duplicate transactions, Import Statement unavailable for corporate cards. The sample statement is fictional.

FAQ

Related guides

• Free sample OFX file (bank and credit card), explained
• QIF file format explained: every field, with a real example
• Catch-up bookkeeping: getting 12 months of bank statements into QuickBooks or Xero and reconciled
• How to find a bank reconciliation discrepancy: 7 causes and a 15-minute method
• Free sample bank statement files: PDF, CSV, QBO, IIF, QIF and Xero CSV
• How to import a bank statement into Sage 50 (U.S., UK and Canadian editions)

Related tools

• Bank reconciliation checker: compare a bank statement to your books and list missing, duplicate and mismatched transactions.
• Receipt to CSV: turn PDF or photo receipts and invoices into CSV, Excel, or QuickBooks and Xero bill imports.