Founding offer: 40% off the first payment on selected apps with code FOUNDING40, until 30 November 2026.40% off selected apps’ first payment: FOUNDING40 until 30 Nov. See founding prices

Atesen Software Find your appAll apps
Menu

Missing transactions in the Xero or QuickBooks Online bank feed: how to find the gap against the bank statement

To find missing transactions in a Xero or QuickBooks Online bank feed, compare the bank's own statement with the bank account in your books for the same dates, line by line. Check first that the feed is not just late, then load the missing lines from a bank file instead of retyping them.

By Atesen Software · Last updated

Everything below follows Xero Central and Intuit's QuickBooks Online help articles, which we opened and read on 13 November 2026. Where a source gives a list of causes, we repeat only that list. Menus and options can change, and some Xero articles differ by region.

Why a bank feed can be missing lines

Neither vendor claims its list is complete. These are the reasons the help articles give.

Xero

  • The feed is late. Xero Central says not every direct feed imports every day and that expected import times differ for each bank. It also lists known disruptions on a Disruptions to bank feeds page, which it says is updated every day.
  • No blank statements. Some banks do not send a blank statement, so a day without transactions shows no statement in Xero.
  • Yodlee and Plaid feeds. Xero says these usually need a manual refresh, and that a refresh only imports transactions the bank has cleared, not pending ones.
  • The feed started after your conversion date. For missing lines from the period when you first started using Xero, Xero says the feed may have started after the conversion date.

QuickBooks Online

  • Timing. Intuit says QuickBooks Online downloads the latest transactions every night and that it may take up to 48 hours for them to arrive.
  • What is downloaded. Intuit says QuickBooks Online does not download pending transactions or transactions older than 90 days, only posted ones.
  • The line is there, in another place. It can sit in the For review, Categorized or Excluded tab, in the wrong account, or in Uncategorized Income or Uncategorized Expense. A bank rule set to auto-add moves transactions straight into your books, so they never appear in For review.

How to find the gap against the bank statement

  1. Rule out a late feed. In Xero, open Accounting > Bank accounts, click the menu icon for the account and select View Status Updates, which opens the Disruptions to bank feeds page. In QuickBooks Online, go to Bank transactions, select Update and look in For review. If lines from the last few days are the only ones missing, wait for the feed before doing anything else.
  2. Download the bank's own record for a fixed period. From online banking, export the posted transactions as CSV or Excel for one account and one date range. Write down the opening and closing balances shown by the bank. Use the same account, currency and dates for everything that follows.
  3. Export the ledger side for the same period. For Xero, use the Account Transactions report for the bank account, or the Bank Statement section of the Bank Reconciliation report pack to see the statement lines Xero holds. For QuickBooks Online, use a transaction report or the register of the bank account (Chart of accounts, then View register).
  4. Make the two files comparable. Put both in one date format. Use one signed amount column in each, with money in positive and money out negative, because a debit in one file can be a credit in the other. Delete title rows, total rows and balance columns. If your bank file is a PDF statement, convert it to CSV first.
  5. Match the lines. Pair lines with the same date and amount first. Then pair lines with the same amount a few days apart, since card payments can clear later than they are recorded. Mark each pair as you go. What is left is the gap: lines only in the bank, and lines only in the books. Lines only in the books are as important as missing ones, because they explain a balance that is too high.
  6. Look for each unmatched bank line before you add anything. In Xero, open the Bank Statements view of the account. The Status column shows Unreconciled, Reconciled or Deleted, and the Source column shows Bank Feed, Imported or User. A Deleted line or a User line may be the answer. In QuickBooks Online, check For review, Categorized and Excluded, then the register, the Uncategorized accounts and your bank rules.
  7. Load only the lines that are really missing. In Xero, export the missing transactions from online banking and import them as a statement. Xero says to create account transactions and use mark as reconciled only if you cannot import, because that creates a new statement line and can cause duplicates and wrong bank balances. In QuickBooks Online, use Link account then Upload from file on the Bank transactions page. Intuit says the file must start at least one day before your oldest QuickBooks transaction in that account, and that you should check the Chart of accounts first to avoid duplicates.
  8. Check the balance. Xero says to make sure the statement balance in Xero matches your actual bank balance once the missing lines are imported. In QuickBooks Online, reconcile the account against the statement and check that the difference reaches zero.

Xero: the two reports Xero Central names

Xero Central's article on missing bank transactions says to run the Bank Reconciliation Summary report and compare it with your online bank account. It describes opening the Bank Reconciliation report pack, selecting Bank Statement under Contents, setting the pack date range from your conversion date to a day or two after the feed started, choosing the bank account and clicking Update. It then says to compare that statement with the actual bank account to see which statement lines are missing. The article we opened is the UK version, so the names can differ in your region.

For a CSV that Xero will accept, see our guide to the Xero bank statement CSV format and import errors. To list what is still unreconciled, see how to find unreconciled transactions in Xero.

QuickBooks Online: upload limits to know first

Intuit's manual upload article says a list file can be QBO, QFX or CSV, in English, 350 KB or less, with up to 1,000 lines per upload. Each file needs either three columns (Date, Description, Amount) or four (Date, Description, Credit and Debit). It also says to put every date in the same format and to leave zero amounts blank. For bigger gaps, download the transactions in smaller date ranges.

Intuit's article on the Reconcile Discrepancy Report covers a beginning balance that is off after a past reconciliation. It is a different problem from a missing line, but if the balance stays wrong after the lines are loaded, see our QuickBooks Online reconciliation discrepancy guide.

Option: compare the two files with Recondiff

Atesen Software publishes this guide and makes Recondiff; the steps above work without it.

Recondiff compares a bank CSV with a ledger CSV, such as a Xero Account Transactions export or a QuickBooks Online register or report, and shows what differs. Its page says the files are read in the browser and not uploaded. It matches the same amount on the same date first, then the same amount within three days, then similar descriptions, and what remains is listed as lines only in the bank, lines only in the ledger and possible duplicates. The free preview covers the first 50 rows of each file and needs no sign-up. A row can look unmatched in the preview only because its partner is below row 50.

Recondiff does not post entries to Xero or QuickBooks Online; you make each fix in your accounting software. If you only have a PDF statement, the PDF bank statement to CSV page turns a text-based PDF into a CSV first.

Compare two files free Convert a PDF free

Atesen Software is independent. Xero is a trademark of Xero Limited, and QuickBooks is a trademark of Intuit Inc. This page is not affiliated with or endorsed by Xero or Intuit. Sources: Identify and fix missing bank transactions, Check if your bank feed is late and View bank statements and bank statement lines on Xero Central, and Find missing downloaded transactions, Manually upload transactions into QuickBooks Online and Fix beginning balance issues when reconciling in QuickBooks Online from Intuit, all checked on 13 November 2026. This is a how-to guide, not accounting advice.

Questions about this guide: support@atesensoftware.com.

Questions people ask

Why are transactions missing from my Xero bank feed?

Xero Central names a late feed, banks that send no blank statement, Yodlee or Plaid feeds that need a refresh and do not import pending items, and a feed that started after your conversion date. Check the Disruptions to bank feeds page first, then compare the statement with Xero.

Why are transactions missing from my QuickBooks Online bank feed?

Intuit says it can take up to 48 hours for transactions to arrive, and that pending transactions and transactions older than 90 days are not downloaded. The line may also be in For review, Categorized or Excluded, in the wrong account, in an Uncategorized account, or auto-added by a bank rule.

Can I fill the gap by importing a CSV from my bank?

Yes in both. Xero says to export the missing transactions from online banking and import them. In QuickBooks Online, use Link account and Upload from file, with up to 1,000 lines per upload. Import only the lines that are really missing, so you do not create duplicates.

Should I just enter the missing transaction by hand?

Not if you can import it. Xero says to create account transactions and mark them as reconciled only when you cannot import the statement line, because it can lead to duplicates and wrong bank balances. Intuit says to use file import instead of entering transactions manually.

How do I find which lines are missing when the balances differ?

Export the bank's lines and the ledger's lines for the same account and dates, put dates and signs in the same form, and pair lines by date and amount. The lines left on each side are the gap. A spreadsheet works, and so does a comparison tool such as Recondiff.