QuickBooks Online shows an extra payment during reconciliation

1. Check the statement and the reconciliation settings

Open the statement for the same bank account. Verify the statement ending date and balance entered in QuickBooks, then check the beginning balance. If the beginning balance differs from the previous reconciliation's ending balance, investigate that before checking this month's payment count. Intuit's guide to the Reconcile Discrepancy Report.

Note the amount shown in Difference and review the payments selected in the reconcile window. If a filter hides dates after the statement ended, include those dates while checking whether a later payment is already selected. Compare any candidate with the statement before changing its selection. Intuit's end-of-reconciliation checks.

2. Compare dates, amounts and references

Put the statement and the bank account register side by side. For a longer statement, use the bank CSV and a QuickBooks register or report export. Work from copies for the same account, currency and period. If the QuickBooks export opens as a spreadsheet, save a copy as CSV and check that the dates and debit and credit signs still read correctly.

For each unmatched payment, note the bank posting date, QuickBooks transaction date, signed amount and any check number or reference. Two $45 payments on the same day can both be real. Check the references, and look at the next statement for a payment recorded near month end. If the bank shows a combined amount, check whether several register lines add up to it.

3. Confirm whether the extra payment is in the register

Start with the register for the account you are reconciling. A payment still waiting for review in the bank feed can appear alongside an entry already in the register. Compare the actual register entries against the statement to establish whether the payment was recorded twice.

If the suspected duplicate was already reconciled or belongs to a closed period, record the transaction references and have the person responsible for the close review it. Once you have dealt with the verified issue, check the reconciliation again against the original statement. The difference should reach zero before you finish.

Compare longer statements with Recondiff

Open Recondiff and choose QuickBooks Online under the file inputs to try the comparison with sample data. To use your own data, add the bank CSV and the ledger CSV, check the date format and ledger signs, and select Compare.

Start with Only in bank, Only in ledger and Possible duplicates. The free preview shows the first 50 rows of each file, so a match beyond those rows can appear as a difference. Files are read and compared in your browser. Confirm each candidate in QuickBooks, where any changes to the register are made.

Open the Recondiff CSV comparison

For a difference that remains after the payments are accounted for, see the broader QuickBooks reconciliation discrepancy guide.