| Bank feed backfill |
About 90 days on a new QuickBooks or Xero connection |
A year-end catch-up starts with most of the year missing |
| Online banking CSV download |
Typically 90 days to 18 months of activity, varies by bank |
Older periods can only be reached through the PDF statement |
| PDF statement archive |
Commonly up to 7 years online at US banks |
The statement outlasts every data export, so it is the real source of history |
| QuickBooks Online upload |
1,000 transactions and 350 KB per file; CSV, QBO, QFX, or OFX |
A busy year has to be split into several files |
| QuickBooks CSV layout |
3 columns (Date, Description, Amount) or 4 (Date, Description, Credit, Debit) |
An extra column or a category column fails the import |
| QuickBooks Desktop Web Connect |
Reads .qbo files only, not QFX, QIF, or CSV |
Many banks hand out QFX or QIF, which Desktop refuses |
| Xero bank statement import |
1,000 statement lines per CSV; PDF and Excel are rejected |
A PDF statement has to be converted to CSV or OFX first |
| FreshBooks bank reconciliation import |
500 transactions per CSV file |
The strictest documented cap of the common packages |
| NetSuite bank statement parser |
10,000 transactions per import, one account per CSV |
The highest ceiling, but the file layout is rigid |
| Closed accounts |
No feed and no download once the account is closed |
Saved PDF statements are the only remaining record |