Two similar bank transactions in QuickBooks do not always mean money left your bank twice.
One real transaction may appear as two QuickBooks records. The bank statement may also show that two real payments took place.
Check the bank statement before you delete or exclude anything.
Why can the same transaction appear twice?
Common reasons include:
- a transaction was entered by hand and then downloaded from the bank;
- bank transactions were uploaded and later downloaded again;
- a downloaded transaction was added instead of matched;
- the same bank account was connected more than once;
- two real transactions have the same amount and date;
- a transfer appears in more than one account view.
The two records may look alike while representing different things.
What should I check first?
Start with your bank statement.
If the bank statement shows the payment twice, the two QuickBooks records may both be real.
If the bank statement shows it once, compare the QuickBooks records:
- date;
- amount;
- bank account;
- supplier or customer name;
- transaction type;
- category;
- memo;
- match status;
- whether either record was entered by hand.
Do not rely on the amount alone.
What is the difference between matching and adding?
When a bank transaction already has a record in QuickBooks, matching links the downloaded item to that record.
Adding creates a new record.
If an existing payment is added again instead of matched, QuickBooks may show two records for one bank transaction.
Should I exclude one transaction?
Only after you confirm that it is a duplicate downloaded item.
An excluded transaction does not appear in account registers or reports. Excluding the wrong item can make your QuickBooks records differ from the bank.
If you are unsure, ask your bookkeeper or accountant before changing it.
Does a duplicate-looking record prove a duplicate payment?
No.
Two records in QuickBooks do not prove that money moved twice. Your bank statement is an important check.
The reverse is also true. One QuickBooks record does not prove that the bank processed only one payment.
Why can this become hard to check?
One pair may be easy to review.
A full year may contain manual entries, bank downloads, transfers, checks, expenses, and card payments. Similar dates and amounts can occur for valid reasons.
Matching-looking records are clues. They are not proof by themselves.
Where RecurSave fits
RecurSave provides Financial Leakage Reviews for owner-led service businesses.
You send us standard QuickBooks exports. You do not share your login or give us access to your QuickBooks account.
We review what the submitted records support. We do not assume that two similar QuickBooks records prove that money left twice.
The review is free. If the records support material estimated recoverable value, you receive a free Findings Summary.