QuickBooks Online imports bank transactions from CSV files, and NoRekey's CSV export is shaped to map straight in.
Step by step
- Convert your statement and download the CSV export.
- In QuickBooks Online, go to Transactions → Bank transactions, choose the account, and select Upload from file.
- Pick the CSV. When QuickBooks asks about the format, choose the three-column style if you use signed amounts (our default) — money out is negative, money in is positive.
- Map the columns: Date → date, Description → description, Amount → amount. The running balance column can be ignored by the import; it's there for your own reconciliation.
- Review and confirm. QuickBooks de-duplicates against existing transactions on import.
Which date format?
Our CSV uses ISO dates (YYYY-MM-DD), which QuickBooks accepts directly. If your QuickBooks region expects DD/MM/YYYY, pick that mapping on the import screen — the values convert unambiguously.
Reconciling afterwards
Because every NoRekey conversion is balance-checked before export, the total of the imported transactions will match the statement's closing balance. If QuickBooks shows a different ending balance after import, the difference is in QuickBooks — usually duplicates from an overlapping bank feed — not the file.