Card Deposits Recorded Twice: A Bookkeeper's Guide to the Duplicate Feed Problem

Card deposits that appear twice in the ledger usually are not a posting error at all. They are a process error: two import paths are both bringing the same money in. This article covers how the duplication shows up, what it does to the close, and how to prevent it.

How the duplication happens?

Merchant service deposits can arrive in your books through two doors. The first is the merchant service deposit recording function, which books the card sales and the associated fees as a matched deposit. The second is the bank feed, which sees the same money landing in the account and offers it to you as an unmatched transaction.

If you record the deposit through the merchant service window and later accept the same item from the feed, the ledger now holds two deposits for one movement of cash. Neither entry is wrong on its own. The fault sits in the process, not in either individual posting.

How does it show up in the ledger?

The pattern is distinctive once you know to look for it. Bank deposits on the account exceed the bank statement for the period, and the gap equals the card sales recorded through both paths. The bank reconciliation shows the feed-side deposits as already cleared, while the merchant service deposits sit uncleared, or vice versa depending on which side the bank matched first.

Income is overstated by the duplicated gross sales, and the merchant fee expense may be doubled as well. If the period has closed with the duplication in place, sales tax or VAT reported on those sales may also be overstated, which is a disclosure question rather than a bookkeeping one.

How do you tell it apart from an ordinary posting mistake?

A genuine duplicate posting, say a deposit entered twice by hand, shows the same date, the same amount, and the same memo. Feed-versus-merchant duplication is messier. The two entries rarely match exactly, because the merchant service deposit is net of fees while the feed item is the net amount that actually landed, and the dates differ by the settlement lag.

That mismatch is the tell. If the two amounts differ by exactly the fee, and the dates are one to three days apart, you are looking at the two-door problem rather than a fat-fingered entry.

What does it do to the close?

The damage is concentrated in the reconciliation. The bank rec will not balance until one side of each pair is removed, and the uncleared duplicates clutter the outstanding list. Sales and fee accounts are both wrong, so any margin reporting drawn from the period is unreliable until the duplicates are cleared.

The sooner you catch it, the cheaper it is. A duplication caught inside the month is a deletion and a re-reconciliation. One caught after the period has closed and reported may need a correcting entry instead, and a conversation about whether the reported figures need revisiting.

What should you preserve before cleaning up?

Before deleting anything, take a copy of the current reconciliation state and note which deposits cleared the bank in the affected period. Print or export the deposit detail for the account covering the duplicated dates. If the file is shared, confirm nobody else is mid-recording in the merchant service window while you work.

That evidence lets you prove, later, exactly what was removed and why. It also protects you if the deletion turns out to touch a period someone else has already reported on.

Where does the fix stop being bookkeeping?

Removing the duplicate is straightforward while the entries are simple deposits against income. It stops being routine bookkeeping if the duplication spans a closed period with reported sales tax, if the amounts do not reconcile to the fee explanation, or if deletions in the file trigger balance or list damage symptoms such as failing verification or reports that will not open.

At that point the file itself may be compromised, and that is repair work rather than cleanup. Our sister service handles QuickBooks file damage repair, and that is where we send it.

How do you prevent it next month?

Pick one door and close the other. If you want the fee detail and the sales linkage, record through the merchant service window and dismiss the matching items from the feed rather than accepting them. If you prefer working from the bank side, record the feed item and leave the merchant service items unrecorded.

Write the choice into your close checklist so anyone covering for you follows the same path. The duplication is always a process question, and the fix is always a decision about which door stays open.