Guide
Finding bank transactions missing from QuickBooks Online
A practical routine for a US checking account: check where QuickBooks keeps downloaded transactions, export one account report, compare it with your bank’s CSV, and add only what is truly absent. It summarizes three Intuit help articles as read in November 2026 (each was last updated in August 2026). Intuit’s pages are the authority; check them before acting.
1. Look where downloaded transactions go
- Intuit’s article “Find missing downloaded transactions” says to open Bank transactions, select the bank account, and look in the For review, Categorized and Excluded tabs.
- Transactions still in For review have been downloaded but are not in your books yet, so they do not appear in reports. Categorizing them adds them.
- A categorized transaction may have been posted to the wrong account; the article describes how to unmatch and move it.
- Excluded transactions (for example marked as personal or duplicate) can be restored with Undo and then categorized from For review.
- The same article says QuickBooks doesn’t download pending transactions or transactions older than 90 days, only posted ones, and that downloads may take up to 48 hours. Bank rules set to auto-add never appear in For review.
Because BankFeedGap only sees the report you export, it never claims a transaction is absent from your bank feed. A row it lists as “not found in the QuickBooks report” may still be sitting in one of these tabs.
2. Export one account report
Intuit’s article “Run a ledger report that shows debits and credits for each transaction” suggests starting from the Transaction Detail by Account report, and its steps use the General Ledger:
- Go to Reports, then Standard reports, and find General Ledger.
- Under Columns, select the Credit and Debit checkboxes.
- Under Filter, choose Account and select the account.
For BankFeedGap, select only the one checking account and set the report period to the same dates as your bank download. Then use the report’s export option to save it as Excel (.xlsx) or CSV. For a bank (asset) account, a ledger Debit is money in and a Credit is money out; BankFeedGap proposes that direction and lets you confirm or swap it.
3. Download the bank CSV for the same dates
- From your bank’s website, download the checking account’s transactions as CSV for the same period.
- Use posted transactions. If the file has a Status column, rows marked Pending are left out of the comparison.
- Do not edit amounts or dates. If a row cannot be read, BankFeedGap tells you which one and blocks exports until the file is fixed.
4. Compare and read the result
- Matched: exactly one bank row and one QuickBooks row share the date and amount.
- Not found in the QuickBooks report: a bank row with no same-date, same-amount row in the report. Check the bank feed tabs first.
- Only in QuickBooks: a report row with no bank row, for example an uncleared check, a manual entry, a duplicate or a date typo.
- Ambiguous: repeated equal candidates, or the same amount a few days apart. These are never matched or selected for you.
5. Upload only what is truly absent
Intuit’s article “Manually upload transactions into QuickBooks Online” describes the file and the steps:
- Files can be CSV and must be in English, 350 KB or less, with up to 1,000 lines per upload.
- Each file needs either 3 columns (Date, Description, Amount) or 4 (Date, Description, Credit, Debit). Enter all dates in the same format; the article recommends dd/mm/yyyy.
- Steps: Bank transactions, then Link account ▼ and Upload from file; choose the file and the QuickBooks account; match the columns; select the transactions to import; confirm.
- The article recommends checking your Chart of accounts to avoid creating duplicate transactions, and after uploading you match and categorize the uploaded transactions.
BankFeedGap’s upload file uses the 3-column layout with money in positive and money out negative, contains only the bank rows you tick, and lets you choose MM/DD/YYYY or DD/MM/YYYY. Pick the same date format in QuickBooks’ mapping step and check that the signs look right before importing.
What BankFeedGap never does
- It never uploads your files, connects to QuickBooks or your bank, or posts anything.
- It never auto-selects ambiguous or QuickBooks-only rows for the upload file.
- It never claims a transaction is missing from your bank feed, only from the report you exported.