How to Upload Bank Statements to QuickBooks Online When the Feed Has Gaps

QuickBooks Online lets you attach a PDF to a transaction or to a reconciliation, but attaching is not importing. The upload screen reads transaction files, mainly CSV and the Web Connect QBO format, and ignores PDFs as a data source.

That leaves two practical choices.

• Retype or copy the lines into a spreadsheet and save it as CSV. This works for a short statement and becomes slow with long ones, scans or credit card statements full of small purchases.
• Convert the PDF with a tool that reads the table and writes a CSV or QBO file, then check the totals before uploading.

Copying text out of a PDF tends to break rows, merge the description with the amount, and drop minus signs, so even the manual route needs a careful review.

QuickBooks Online maps CSV columns during the upload, and it supports two shapes.

• 3 column: Date, Description, Amount, with deposits positive and withdrawals negative.
• 4 column: Date, Description, Credit, Debit, with each amount in its own column and the other one empty.

Statements that print separate columns for deposits and withdrawals fit the 4 column layout naturally. Statements with one amount column and a running balance fit the 3 column layout, as long as you make withdrawals negative.

Pick one date format for the file. US statements usually read MM/DD/YYYY; statements from many other countries use DD/MM/YYYY. Watch statements that print dates without a year, such as Jan 04, and add the correct year, especially on December to January statements.

Delete the opening balance line, page subtotals and carried forward rows. They look like transactions in a spreadsheet but are not.

A bank statement to csv converter produces this layout directly and drops summary rows for you.

Step 1. Open the banking area of QuickBooks Online (look for Bank transactions in the left menu).

Step 2. Use the Upload from file option, often found next to or under the Link account button.

Step 3. Select the CSV or QBO file built from the statement.

Step 4. Choose the bank account in QuickBooks that matches the statement. Double check the last digits of the account number, since firms often hold several accounts at one bank.

Step 5. For a CSV, map date, description and amount columns and choose the date format. A QBO file skips this step.

Step 6. Review the preview, deselect any rows that overlap with feed data, and import.

Step 7. Work through For review, matching lines to existing entries such as invoice payments, and adding the rest with the right category.

When you are filling several months, upload them oldest first. It keeps the review list in order and makes a missing month obvious.

A QBO file holds a unique ID for every transaction. QuickBooks reads those IDs and skips lines it has already seen from the same file source, which matters when a statement overlaps a period you uploaded before.

QBO files also carry the statement closing balance, so the file itself documents where the period ended. If you convert statements regularly, a pdf to qbo converter removes column mapping from the job entirely.

CSV stays the better choice when you want to edit lines before upload, for example to split a combined deposit or rewrite vague descriptions.

• The upload screen says the file cannot be read: open the CSV in a text editor and check for a second header row, an empty first line or a stray bank logo text line at the top.
• Some months import twice: the feed already covered part of the statement. Exclude the duplicates in For review and note the cut off date for next time.
• Totals do not match after import: summary rows such as Total deposits slipped into the file. Search the import for those words and exclude them.
• Credit card statement signs look reversed: on a card account, purchases increase the balance owed. Check that charges import as expenses and payments as transfers, and flip the sign column if not.
• Scanned statements produce garbled descriptions: re-scan at a higher resolution or use a converter that reads scans and photos, then review the lines with low confidence.

Uploading fills the register; reconciling proves it is right.

Step 1. Open the reconcile screen for the account (look for Reconcile under the gear menu).

Step 2. Enter the statement ending date and ending balance.

Step 3. Clear the transactions for that period until the difference is 0.00.

Step 4. Where QuickBooks offers it, attach the PDF statement to the reconciliation so reviewers and auditors can open the source document next to the report.

Work one statement at a time. Reconciling twelve months in a single pass hides which month went wrong.

StatementsConverter turns PDF, scanned and photographed bank and credit card statements into CSV, Excel, QBO and other formats. Before you download, it runs a balance check on each statement: opening balance plus deposits minus withdrawals has to equal the closing balance. A missing page or a misread amount shows up there, not in the QuickBooks reconciliation weeks later.

Batches are grouped by client, so a catch up job with a year of statements for one client stays in one place. The QuickBooks workflow is described in more detail on the pdf bank statement to quickbooks page.