Import bank statements into QuickBooks Online or Xero
A bank statement PDF can't be imported into accounting software directly. ApexParser turns it into a CSV with the columns, date format and signs the import expects — so the upload works the first time instead of failing on a format error.
Why imports fail
Both QuickBooks Online and Xero accept CSV bank data, but each is strict about the shape of the file. Most failed imports come down to the same handful of problems — and all of them happen before the data ever reaches your chart of accounts.
Wrong column layout
QuickBooks Online expects either a three-column file — date, description, and one signed amount — or a four-column file with separate credit and debit columns. A raw copy-paste from a PDF matches neither.
Debits and credits the wrong way round
Xero typically expects a single signed amount column: money in positive, money out negative. Statements print two separate columns instead, so the sign has to be derived correctly rather than guessed.
Formatting inside the numbers
Currency symbols and thousands separators inside an amount field will break an import. Amounts need to be clean numbers before upload.
File too large for one upload
Both platforms cap how much a single import file can hold. A full year of a busy business account usually needs splitting by month or quarter.
What you get instead
Import-ready from the moment it downloads — the sign on every row is derived from the statement's own printed balance, not from keywords in the description.
| Date | Description | Amount |
|---|---|---|
| 2025-07-04 | Rogers Communications | -94.15 |
| 2025-07-05 | Deposit, client payment | 1500.00 |
| 2025-07-07 | TD ATM withdrawal | -100.00 |
Where this fits in your workflow
ApexParser handles the step between the PDF and the import screen. Everything after that stays where it belongs.
Data in, accurately
Every transaction extracted and checked against the statement's declared totals, so nothing goes missing on the way in.
Categorization stays in your software
Your chart of accounts, rules and reconciliation live in QuickBooks or Xero — ApexParser doesn't try to replace them.
Works for accounts with no bank feed
Closed accounts, older periods, and institutions your accounting software can't connect to still produce a PDF — and that's all this needs.
Multiple banks, one process
Clients with accounts at different institutions all come out in the same import-ready shape.
Common questions
Why won't my bank statement CSV import into QuickBooks Online?
The most common causes are the wrong column layout, dates in a format the import doesn't recognize, currency symbols or thousands separators inside the amount fields, or a file that's too large for a single upload.
How does Xero expect debits and credits to be formatted?
Xero typically expects a single signed amount column rather than separate debit and credit columns. Money in is positive, money out is negative.
Can I import a full year of statements at once?
You can convert a full year in one go, but both platforms cap how much a single import file can contain. Splitting by month or quarter avoids hitting that limit.
Do I still need to categorize the transactions?
Yes. ApexParser gets the transaction data in cleanly and accurately; categorization and reconciliation still happen inside your accounting software where your chart of accounts lives.