How to get a PDF bank statement into QuickBooks Online as a CSV

When a bank connection is not available, QuickBooks Online lets you upload transactions from a CSV file. Here is how to prepare one from a PDF statement.

CSV versus QBO files

QuickBooks Online accepts bank transactions from a CSV file, and also from files such as QBO or OFX. Producing a valid QBO or OFX file from scratch needs bank identifiers that a PDF does not contain, so for a one-off statement the CSV route is usually simpler. This guide covers CSV.

The layout QuickBooks expects

QuickBooks Online's help describes two layouts: three columns (Date, Description, Amount) or four columns (Date, Description, Credit, Debit). Pick one, keep a single header row, and do not mix them. Check the current help page in your region, because the details can change.

Steps

Get a text-based PDF from your bank's online portal.
Convert it to CSV. You want one row per transaction with a date, a description and an amount.
Shape the columns. Rename or arrange to Date, Description, Amount. Use negative amounts for money out and positive for money in, consistently across the file.
Clean the values. Remove currency symbols and thousands separators, and delete any title, balance or total rows. Make dates unambiguous.
Check the arithmetic. Opening balance plus the sum of the amounts should equal the closing balance printed on the statement. If not, find the missing or flipped row first.
Upload. In QuickBooks Online, use the option to upload from a file in the Banking area, choose the account, map the columns, and review the preview before importing.
Reconcile. After the import, run a reconciliation against the same statement using its ending balance.

Watch for

Importing the same statement twice, or two statements that overlap by a day, creating duplicates.
Uploading to the wrong account, especially when a card and a bank account are both listed.
Reversed signs on a credit card account, where the meaning of positive and negative differs from a bank account.

Where PennyTie fits

PennyTie is one way to do the conversion and the check. It converts a text-based statement PDF to CSV in your browser, verifies opening balance + transactions = closing balance, and flags rows to review. Because nothing is uploaded, it suits statements you would rather not send to a third-party server.

Limits

PennyTie reads text PDFs only; scanned statements need OCR first. It outputs a generic CSV, so you may need to rename or reorder columns to match the three- or four-column layout, and it does not create QBO or OFX files. Review flagged rows against the PDF before importing.

Try it: open PennyTie, drop a text-based statement PDF (or use the built-in fictional sample) and see whether the totals tie out. Free for statements up to 5 pages; nothing is uploaded.