LedgerMatch
QuickBooks Online Bank Feed Missing Transactions: What to Check
Published
Missing transactions in a QuickBooks Online bank feed can come from the date range, connection state, duplicate handling, or the source bank. Use this checklist before you reconcile.
When a QuickBooks Online bank feed is missing transactions, do not start by forcing the reconciliation to balance. First determine whether the transactions are missing at the bank, feed, or register layer. The distinction tells you whether to refresh, review excluded items, or use a statement export as the reliable source.
1. Confirm the statement date range
- Compare the bank statement period with the date range currently visible in the QBO Banking or Transactions area.
- Look for the last transaction date that actually arrived, not only the date of the most recent successful connection.
- Check whether the missing activity is older than the feed retention window or falls before the account was connected.
2. Check the feed and account state
- Open the connected bank account and look for a connection warning, required sign-in, or requested reauthorization.
- Confirm that the transactions are going to the intended QBO account rather than another account with a similar name.
- Review the For Review, Categorized, and Excluded areas; a transaction can be present but not in the list you first checked.
3. Look for excluded or duplicate activity
A transaction may have been excluded because it was a duplicate, categorized earlier, or reviewed by another user. Search the account register by date and amount before adding anything manually. If the same activity appears twice, keep the bank-supplied row that belongs to the correct period and investigate the duplicate rather than accepting both.
4. Use a CSV fallback for a complete period
If the feed cannot provide a complete historical period, download the statement CSV from the bank and export the QBO account register for the same dates. A CSV comparison gives you a fixed source of truth for the missing period and avoids depending on a live connection while you clean up the books.
- Export the bank statement for the exact reconciliation period.
- Export the matching QBO account register or transaction list.
- Compare dates, amounts, and descriptions, keeping the missing and duplicate rows visible.
- Only after the exception is understood, add or correct the QBO transaction and document why.
Frequently asked questions
Why is my QuickBooks Online bank feed missing older transactions?
Older activity may be outside the available feed history, may predate the connection, or may have been excluded or categorized already. Compare the exact statement dates with the account register before adding anything manually.
Can I reconcile QuickBooks Online if the bank feed is incomplete?
Yes, but use a complete statement export as the source for the period. Export the QBO register, compare the two files, and resolve missing or duplicate rows before finishing the reconciliation.
Should I disconnect and reconnect the bank feed?
Only after checking the date range, account mapping, and connection warning. Disconnecting is not a substitute for identifying what is missing and can make the recovery path harder to document.