Duplicate Bank Feed Entries in QuickBooks: Pricing a Cleanup Job
A routine receipt-scanning job can become a full cleanup when bank feeds post twice. Here is how to spot the cause and price the work honestly.
A bookkeeper takes a small side job: scan receipts, attach them to charges, and reconcile so nothing slips. Then the reconciliation uncovers months of duplicated credit card transactions, and the tidy hourly agreement no longer matches the work. This happens more than you would think. The cause is usually the bank feed setup itself, and the fix starts with a scope conversation, not a spreadsheet.
Why does a bank feed post the same charge twice?
Duplicates arrive when more than one source feeds the same account. One pattern we see often: a shared card account connected once per cardholder, so two downloads land in the same register. Another: a live feed running alongside manual statement imports. The software treats every download as new information. It cannot know that two entries describe one purchase.
The setup may even have come from a well-meant support session. Whoever configured it followed the card users rather than the card statement. The damage stays hidden until someone sits down to reconcile.
How do you know the job has become a cleanup?
Run a reconciliation before you promise anything ongoing. If the opening balance is off, or a charge appears twice in the same month, the file needs repair before it needs routine entry. Count the duplicates. List the affected accounts. Note the earliest statement that shows the problem. Those numbers turn a sinking feeling into something you can discuss calmly.
Have the scope conversation before the hours pile up
Show the client what you found, in plain words, with the register on screen. The original agreement covered receipt capture and a light reconciliation. Nobody agreed to a multi-account cleanup.
Most clients are not being sly; they repeated setup advice they trusted. Saying so keeps the tone collegial. Silence is the expensive option, because resentment at a low rate eventually shows up in the work.
Can you raise the rate in the middle of the job?
Yes, and honesty is the only version that works. Bring a short written summary: what was agreed, what you found, and a proposed structure. Many bookkeepers price the cleanup as a fixed project fee, then a lower monthly rate once the file is clean. That is easier to accept than a surprise hourly overrun.
If a referral or a mentor relationship is attached to this client, the candid conversation protects it. Quiet underpricing erodes it.
Clear the duplicates, oldest statement first
- Inventory every connected feed and disconnect the extras, keeping one connection per card statement.
- In the review queue, exclude any downloaded duplicate that was never accepted.
- For entries already accepted, delete the copy with no attachment and keep the one tied to a receipt.
- Reconcile one month at a time against the card statement before moving forward.
- Resume routine entry only after the oldest period reconciles cleanly.
One connection per statement prevents a repeat
A shared card account with several cardholders usually produces one statement, and it needs one feed. Separate cards with separate statements deserve separate accounts in the chart of accounts. When the feed structure mirrors the statements, duplicates stop at the source.
Start with the count, not the conversation. Twenty minutes with the oldest statement gives you the duplicate total, the affected accounts, and a fair basis for a new price. If the file is too far gone for a manual pass, our QuickBooks duplicate transaction repair service can take the cleanup off your desk.