How do I upload a bank statement to QuickBooks Online?

Which file should you upload?

• .qbo (QuickBooks Web Connect): the format QuickBooks suggests. It carries the account and a unique ID for each transaction, so there are no columns to map. See what a QBO file is.
• .ofx or .qfx: the same transaction data in the general open format. QuickBooks accepts it as well.
• CSV or TXT: works everywhere, but you map the columns during upload. QuickBooks needs either 3 columns (Date, Description, Amount) or 4 (Date, Description, Credit, Debit).
• PDF or photo of the statement: the US and UK editions can read an uploaded statement for you. The Canadian edition accepts only CSV, TXT, QBO and OFX files.

If you only have the PDF, convert it to a .qbo file and upload that. A .qbo file skips the column mapping, which is where most CSV uploads go wrong.

Step by step: upload the file

1. Get the transaction file. Download it from your bank's website, or convert the PDF statement to .qbo.
2. In QuickBooks Online, open Bank transactions. In the current layout it's under All apps → Accounting; older layouts show it under Transactions (or Banking).
3. Open the Link account dropdown and choose Upload from file. If you have no linked accounts yet, look for Upload transactions manually.
4. Select your file and choose Continue.
5. Pick the QuickBooks account the transactions belong to. Choose the matching bank or credit card account, not a different one with a similar name.
6. For a CSV, map the columns: tell QuickBooks which column holds the date, the description and the amount, and choose the date format the file uses. A .qbo or .ofx file skips this step.
7. Open the For review tab. Categorise each transaction, match it to an existing entry, or add it. Nothing reaches your books until you do.

Limits to check before you upload

• 350 KB or less per file.
• Up to 1,000 lines per upload, one transaction per line.
• English only. Translate non-English column headers and descriptions first.
• One date format for every row. QuickBooks recommends dd/mm/yyyy.
• Blank, not zero. Leave Amount, Credit or Debit cells empty rather than 0.00.

A year of a busy account can break the size or line limit. Split it into quarters and upload them one after another, without overlapping dates.

When to convert the PDF first

• Your edition doesn't take PDFs. The Canadian edition needs a transaction file.
• The statement is a scan or a phone photo and you want to check the figures before they reach QuickBooks.
• You want the balances checked. StatementFlow compares every row's running balance with the printed one and flags rows that don't match, before you download the .qbo. A misread digit is easier to fix there than in For review.
• You also need the data in Excel, for an accountant, a lender or a year-end file. One conversion gives you both.
• The statement isn't in English, since QuickBooks reads English files only.

Common upload problems and fixes

• The file is too large: split the period and upload each part.
• Dates come in wrong or the upload fails on dates: make every row use the same format, and pick that format in the mapping step.
• Amounts are rejected: remove currency symbols, thousands separators and the word "amount" from the amount columns.
• Transactions appear twice: two uploads covered the same dates, or a bank feed already brought them in. Keep date ranges separate, and exclude the duplicates from For review.
• Nothing seems to arrive: check the For review tab of the account you picked in step 5. Uploads never post straight to the register.
• Money in shows as money out: in a 3-column CSV, payments must be negative and deposits positive. In a 4-column file, fill either Credit or Debit on each row, never both.