Add Missing Bank Transactions in QuickBooks Online

To add missing bank transactions in QuickBooks Online, you have three options depending on how old they are. For recent activity, run a manual update on the bank feed to pull it in. For a small number of gaps, open the account register and enter each transaction by hand. For a whole missing month or anything older than 90 days, upload a file: download the statement from your bank as a .csv, .qbo, or .ofx, then use Transactions, Bank transactions, the dropdown next to Link account, and Upload from file. The converter at the top of this page turns a PDF statement into that .qbo file when your bank only gives you a PDF.

Missing transactions are one of the most common reasons a QuickBooks reconciliation will not finish, because the bank shows activity that your books never recorded. The fix is straightforward once you know which path fits the gap. This guide covers manual entry, file upload, the 90-day download limit, and how to avoid creating duplicates while you backfill, with the converter ready at the top to handle PDF-only statements.

Why are bank transactions missing in QuickBooks Online?

Transactions go missing for a few predictable reasons: the bank feed only pulls about the last 90 days, so older activity never downloads, or the feed had a connection error during that period. A transaction may also have been excluded or deleted, posted to the wrong account, or fall outside the date range you are viewing. Pinning down which cause applies tells you whether to refresh the feed, change a filter, or upload the missing data. Each cause and its fix is covered in detail in the guide to bank transactions missing in QuickBooks.

How do I add missing bank transactions in QuickBooks Online?

Start by running a manual update from Bank transactions, since recent gaps often just need a refresh. If that does not bring the activity in, the transactions are likely older than 90 days or never downloaded, so add them by entering each one in the account register or by uploading a file from your bank. Pick manual entry for a few lines and file upload for a full month, then reconcile to confirm nothing is left out.

How do I manually add a bank transaction in QuickBooks?

Open the account register from the Chart of accounts by selecting View register next to the bank account. Choose Add deposit, Add check, or Add expense from the dropdown, then enter the date, payee, category, and amount exactly as they appear on the statement, and save. Manual entry is best for a small number of missing lines. For many transactions at once, uploading a file is faster and less error-prone.

How do I upload missing transactions from a file in QuickBooks Online?

Go to Transactions, then Bank transactions, select the dropdown arrow next to Link account, and choose Upload from file. Browse to the file your bank gave you, pick the QuickBooks account to import into, map the date, description, and amount columns if prompted, then select the transactions and import them. The uploaded lines land in the For review tab so you can categorize or match them just like feed transactions. The full walkthrough, including the formats QuickBooks accepts, is in our guide to import a bank statement into QuickBooks Online.

What file formats can I upload into QuickBooks Online?

QuickBooks Online accepts .csv, .txt, .qbo, and .ofx files for a bank transaction upload, and you can include up to 1,000 lines per file with one transaction per line. CSV is the most common because most banks export it, while .qbo (Web Connect) files import with the least mapping. If your bank only provides a PDF statement, convert it to a .qbo file first so the upload goes in cleanly.

Why won't QuickBooks download transactions older than 90 days?

The bank feed is built to pull only about the last 90 days of history, a limit set by the banks and the aggregator QuickBooks uses, not something you can change in settings. When you first connect an account or reconnect one, you get roughly that 90-day window and nothing older. Anything before that has to be added by hand or uploaded from a file, which is why backfilling a full year always means a file upload.

How do I get transactions older than 90 days into QuickBooks?

Log in to your bank's website and download the older statements as a file, choosing .csv or Web Connect (.qbo) if the bank offers it, then upload that file through Upload from file. If your bank only gives you PDF statements for older months, convert each PDF to a .qbo file with the converter at the top of this page and upload it. Either route fills in the months the live feed will never reach on its own.

How do I find which transactions are missing?

Compare your QuickBooks account register against the bank statement line by line for the period in question, or run a Transaction Detail by Account report and match it to the statement. The reconciliation screen is also useful: as you check off cleared items, anything on the statement with no matching line in QuickBooks is a missing transaction. Note the dates of the gaps so you know exactly which months to upload.

How do I add missing bank transactions in QuickBooks Desktop?

In QuickBooks Desktop, use File, then Utilities, then Import, then Web Connect Files to bring in a .qbo file downloaded from your bank, or enter the lines directly in the account register. Desktop also pulls only a limited window through Bank Feeds, so older history comes in through a Web Connect file. Import each file once to avoid duplicates, then review the transactions in the Bank Feeds Center before they post.

Will adding missing transactions create duplicates?

It can if a transaction is added both by hand and through the feed, so match instead of adding a second copy whenever the line already exists. When you upload a file that overlaps with dates already in your books, QuickBooks may bring in repeats, so import only the exact missing range. If duplicates do appear, exclude or undo the extra copy rather than deleting it from the register, which would invite the feed to re-download it.

How do I add missing transactions for reconciliation?

Add every missing transaction for the statement period before you start the reconciliation, because the Difference will not reach $0.00 while activity is absent. Enter or upload the gaps, confirm each one has the correct date and amount, then open the reconciliation and check items off against the statement. Doing the backfill first turns a reconciliation that would not balance into one that closes cleanly.

Can I import a whole bank statement to fill the gaps?

Yes, and it is usually the fastest fix for a full missing month or year. Instead of typing dozens of lines, download the statement, or convert the PDF statement to a QuickBooks .qbo file with the converter at the top of this page, then upload it through Upload from file. Every transaction lands at once, dated and ready to categorize or match, and you reconcile from there. This is the cleanest way to backfill periods the 90-day feed never reached.

After you fill the gaps, finish the period by working through how to reconcile bank statements in QuickBooks, and if the totals still look off, see why your bank balance doesn't match QuickBooks. For the full backfill workflow, read importing old bank statements into QuickBooks and how far back QuickBooks can import bank transactions, and to keep new uploads categorized automatically, set up QuickBooks bank rules. If you would rather review the statement in a spreadsheet before uploading, a bank statement to Excel converter helps you check the lines first, an account that only exports CSV can run through a CSV to QBO converter, and you can tie expense lines back to their paperwork with receipt and invoice OCR.