Bank statement converter that also categorizes: QuickBooks and Xero CSV

What the import formats need

QuickBooks Online accepts bank-transaction CSVs in a three-column layout (Date, Description, Amount, with negative amounts for money out) or a four-column layout with separate credit and debit columns. Guides advise removing currency symbols, using MM/DD/YYYY dates for US QuickBooks, and staying under about 1,000 lines and 350 KB per file. Xero needs only Date and Amount, with optional Payee, Description and Reference, and one guide gives a cap of 500 lines per CSV. These details come from third-party guides: check Intuit and Xero help pages for the current rules before a big import.

What we produce

Only real bank and card transactions go into the CSV: transfers between your own accounts that would appear twice are left out. Ask for Xero in the note, otherwise you get the QuickBooks layout. If your month has more lines than the software limit, say so in the note.

Where converters are enough

If you only need a PDF statement turned into a spreadsheet, tools such as DocuClipper and Bank Statement Hub do that, some with a free tier or free trial, and several export QBO files for bank-feed style imports. We produce CSV, not QBO. If you want only conversion, a converter is probably cheaper.

Where we differ

• Every transaction categorized in a standard small-business chart, with the reason where it is not obvious.
• Receipts matched to statement lines.
• A P&L and per-account totals, checked against statement totals.
• A Questions tab for duplicates, personal-looking charges and unclear vendors.

The import file only contains transactions: categories live in the ledger workbook, so you either categorize inside QuickBooks or Xero using the ledger as the guide, or hand the ledger to your accountant.

A converter workflow vs ours

Preparing your statements

• CSV or Excel exports from the bank are the cleanest input. PDF statements work too.
• Include every account that touched the business.
• Do not edit the files: leave them as downloaded so totals can be checked.
• Redact full account and social security numbers.

Up to 60 files, 100 MB each.

Questions to ask any converter

1. Does it check the extracted rows against the statement totals?
2. Does it handle scanned statements, or only digital PDFs?
3. Where are my statements stored, and for how long?
4. What formats can it export for my software?

Ours: totals are checked and the result is written in the Notes tab, receipts as photos are handled, uploads are deleted after 30 days, and the export is CSV in the QuickBooks Online or Xero layout.

A concrete example

Say your checking CSV has 121 rows, you have a card statement as PDF and five receipts. Upload them with the note: Retail shop. QuickBooks Online. Owner transfers are draws. You get the ledger with each row categorized, the receipt file name beside any matched row, a P&L, a questions list, and import.csv with Date, Description and Amount. Our own test with inputs of that size, for a fictional business, took 2 minutes and produced 38 questions. It is one test, not a benchmark.

Cost and limits

$49 a month, 4 uploads. Bookkeeping prep only, not tax advice. You import the file yourself. See pricing.

Upload this month's statements. Bookkeeping prep only, not tax advice. 14-day refund if it misses, two rounds of changes, cancel any time.

More about Books

Sources (checked 2026-11-09): www.dancingnumbers.com/import-bank-transactions-into-quickbooks-online · schemacpa.com/blog/xero-bank-statement-csv-import-template · invoicedataextraction.com/blog/xero-csv-import-errors · www.docuclipper.com/solutions/bank-statement-to-excel/ · bankstatementhub.com/