How to import bank transactions into QuickBooks UK
By Arron Child, reviewed by Arron Child. Updated 15 July 2026.
QuickBooks Online UK uploads statement CSVs through Transactions, then Banking, then Upload transactions. It accepts two shapes of CSV; knowing which you are producing avoids the mapping screen guessing wrong.
The two accepted layouts
Three columns
| Date | Description | Amount |
|---|---|---|
| 12/01/2026 | CARD PAYMENT TO TESCO | -45.60 |
One signed amount column: money in positive, money out negative.
Four columns
| Date | Description | Credit | Debit |
|---|---|---|---|
| 12/01/2026 | CARD PAYMENT TO TESCO | 45.60 |
Separate columns, both holding positive numbers. Do not mix the two conventions; a file with a signed Amount plus a Debit column will map badly.
The generic accounting preset from the converter carries separate Money out and Money in columns plus a signed Amount, which maps cleanly onto either shape; delete the columns you are not mapping if QuickBooks hesitates.
Upload steps
- Transactions, then Banking, then the Upload transactions link.
- Choose the file, pick the QuickBooks account it belongs to, and step through the mapping screen: date format (DD/MM/YYYY for UK statements), which column is the amount or credit/debit pair, and whether the first row is a header.
- Review the preview. QuickBooks excludes rows it has seen before as duplicates; check its idea of a duplicate matches yours, particularly for same-day identical card payments, which are common and legitimate.
- Import, then confirm the row count matches your file.
UK-specific gotchas
- QuickBooks' sample screenshots use US dates; make sure the mapping step says DD/MM/YYYY, or every ambiguous date shifts.
- Amounts with £ signs or commas fail silently or import as zero: plain decimals only.
- Statements spanning a year boundary: check January rows landed in the right year after import.
Verify
After importing, the account's For review list should show exactly as many transactions as the statement holds. Then check the account balance after reconciling matches the closing balance printed on the PDF. If it does not, the fault is nearly always in the file, not in QuickBooks; find the break first.
Checked against QuickBooks Online UK on 15 July 2026. QuickBooks is a trademark of Intuit Inc.; ukbankconv is not affiliated with Intuit.