Duplicate Income in QuickBooks: Invoice Payments and Deposits

Why is my income showing twice in QuickBooks?

Income shows twice when one sale has two records in the books, such as an invoice with its payment plus the bank deposit for the same money added as new income. Another typical cause is a payment-app connection that posts sales next to your invoices. The fast check is one month's income against that month's deposits.

A higher income total than your deposits is not always a duplicate. Unpaid invoices and deposits that arrive net of processor fees and refunds make income run above deposits; sales tax imposed on your buyers that you collect and remit, and tips passed on to others, work the other way, since they sit in deposits but not in income. Sales tax imposed on you as the seller and charged to customers is generally part of gross receipts (Publication 334). A duplicate is income that no extra sale supports.

The accounting method matters for the comparison. Under the cash method, income counts in the year it is actually received or made available to you without restriction; under an accrual method, generally in the year it is earned (Publication 538). A cash-basis income report should track money received. An accrual report also includes unpaid invoices.

A case is not simple when:

• the doubling runs across several months or years;
• a payment app syncs into more than one account or company file;
• some of the months are already reconciled or locked;
• a filed return may have used the doubled figure.

In those cases, have a bookkeeper or tax preparer look at the file before you delete anything.

Gather before you start:

• the income report by month for the affected period, run on the method your return uses;
• bank and payment-app statements for the same months;
• the list of open and paid invoices;
• the app-connection or sync settings, and the date each was turned on;
• any Form 1099-K;
• the filed return for each affected year.

Where do duplicate deposits come from: one as a payment, one as a deposit?

Duplicates come from recording the same money or the same sale through two routes. Five patterns are common.

QuickBooks Online's matching page says a bank line whose transaction already exists in the books may offer a Match option, and Add categorizes the line as an entry (QuickBooks Online help). Adding a line that already exists is how the first pattern starts. If the payment still sits in Undeposited Funds after you remove the added entry, see Undeposited Funds balance.

How do I confirm income is counted twice?

Tie one month's income to the money received and the invoices behind it. A duplicate is a sale with two records and one deposit.

1. Pick a month. Open the income report by transaction, not totals, covering every income account (including any catch-all or uncategorized one), on the method your return uses, cash or accrual.
2. List that month's deposits from the bank and payment-app statements. Set aside deposits that are not sales: loans, money the owners put in, transfers between your own accounts, and buyer-imposed sales tax you collect for remittance or tips collected for others.
3. Compare the cash-method income with those deposits. They should match, apart from processor fees, refunds and month-end timing.
4. If you use accrual, explain the gap from cash income with the change in unpaid sales: sales invoiced that month less payments received that month on invoices, income portion only (leave out sales tax), adjusted for credit notes. Advance payments and unbilled income need a preparer's review, and an unexplained gap is a lead, not proof.
5. If income is higher than that explains, look for one sale in two places. Sort the income lines by amount, then date. The same amount twice within a few days, one tied to an invoice and one not, is the usual match.
6. Check each suspect against the statements: one deposit at the bank, two income records in the books.

A bank reconciliation can tie to the penny while income is doubled, because the second copy can sit in an account the reconciliation never covers. Reconcile every month (Publication 583), and also compare income with deposits: bank feeds are not reconciliation.

Which copy do I keep: match, delete or exclude?

Usually keep the record tied to the invoice and to the bank line, and remove the loose second copy. If it is not clear which that is, stop and ask a bookkeeper before deleting.

QuickBooks Online's exclude steps start from the For review tab, so they cover bank lines still waiting there. A line already added to the books is fixed in the books.

Traps:

• Deleting the linked copy. An invoice and its payment are linked. Remove the loose entry, not the payment that closes the invoice, or the invoice's payment history breaks.
• Excluding a line that is not a duplicate. Two real deposits can share an amount and a date. Exclude a line only after you find the same line already in the books, and compare amount, date and description.
• Removing from a reconciled month without a plan. See the section on closed months below.
• No record of what changed. Write down each removal: date, amount, customer, what you kept and why. Treasury regulations name a reconciliation of differences between the books and the return as an example of the supporting records to keep (26 CFR 1.446-1); your removal notes feed it.

How do I fix Stripe and QuickBooks sync duplicates, and stop new ones?

Decide where each sale is recorded once, stop the other route, then clear the duplicates month by month. Settings differ by app and software, and their own help pages cover them; this guide does not.

1. Choose the one source for sales: your invoices, or the sales the app syncs.
2. Turn the other route off now, so new copies stop. If you delete first while the sync is running, new copies can follow.
3. Find the first month where income runs above deposits. That is usually close to when the connection started; confirm it against the date each connection was turned on.
4. Clear the duplicates oldest month first. After each month, compare that month's income with its deposits again.
5. Check the next payout after the change. Each sale in it should already appear once, and the deposit should match those records instead of adding new sales income.

Payouts arrive net of fees and refunds, so a payout is smaller than the sales behind it without any duplicate. That tie-out: reconciling sales and payouts. Per app: Stripe, Square, Shopify. Refunds booked as income: recording refunds in the books.

What if the duplicate sits in a month already reconciled or closed?

A duplicate in a reconciled or locked month can be fixed, but fix it where it sits and record why. Changing a reconciled entry can leave that month out of line with the bank statement, and the next reconciliation can start from a different balance (reconciliation beginning balance wrong). A closing date may ask for a password before you change a locked date (closing date after taxes are filed).

An adjusting entry dated today moves the fix out of the period where the extra was recorded. Income is reported for the year it is received or earned (Publication 538), so a lump sum this year leaves the earlier year overstated and this year understated. If the year is already filed, the corrected books will no longer match the return until the return is corrected or a preparer records why the two differ (see the filed-return section below).

The IRS lists correcting a math or posting error as not a change in accounting method (Publication 538). A duplicate entry is that kind of error; which return carries the correction depends on the entity and on whether the earlier year can still be amended.

Does a Form 1099-K amount tell me whether income is doubled?

No. Form 1099-K reports the gross payments one filer processed through payment cards or payment apps. It cannot show whether your books count a sale twice. Box 1a is not reduced for items such as fees, credits, refunds, shipping or discounts, so it is not net income either (IRS).

Use it only as a prompt, not proof. If your books show more sales through that card processor or app than the form's gross amount, look for double entries first. A form and your books can also differ with no duplicate, for example from a shared card terminal or a change of owner or tax ID (IRS) or from year-end timing; a form above your books can also mean sales missing from the books.

You report all income whether or not a form arrives (IRS). Thresholds, and what to do with a wrong or duplicate form: payment platform reporting threshold and wrong or corrected platform tax form. The full tie-out: reconciling sales and payouts.

Did the doubled income reach a return I already filed?

It did if the return was prepared from the doubled books. First trace the return line to the books: gross receipts or total income against the corrected income report. A return prepared from deposits or a Form 1099-K may never have carried the extra. If the books were not yet used for a return, fix them first and give your preparer the corrected reports. What else to check before sending them: bookkeeping cleanup checklist.

If the return did carry the extra, it stays as filed until it is corrected.

Doubled income can overstate the tax paid, so correcting it can be a claim for refund. A refund claim has a deadline: 3 years after filing the original return or 2 years after paying the tax, whichever is later, counted from the claimant's own return and payment. A return filed early counts as filed on its due date, and a claim filed after the deadline gets no credit or refund unless an exception gives more time (IRS). So an owner of a partnership or S corporation counts from the owner's own return. A partnership's administrative adjustment request generally must be filed within 3 years after the later of its return's filing date or unextended due date, and an IRS notice opening an administrative proceeding for that year generally bars it (26 U.S.C. 6227). A change to a federal return can also affect a state return (IRS).

The same income figure may also sit in a sales tax return, a loan package or an investor report. Check those too. For sales tax: sales tax payable does not match the return.

How do I keep income from being recorded twice again?

Give every sale one home, match instead of add, and compare income with deposits every month.

• One source for sales. Decide whether invoices or the payment app create the sale record, and turn off the other.
• Match, don't add. When the bank line's transaction already exists, use Match (QuickBooks Online help).
• No statement upload on top of a live feed. To fill a gap, see bank feed stopped importing.
• Reconcile monthly. The IRS says to reconcile the checking account each month, and computer records must reconcile with your books and return (Publication 583).
• Test a new connection. After connecting any app, compare one month's income with its deposits, and look at open invoices and Undeposited Funds, before you trust the sync.
• Lock the year after filing. Closing date after taxes are filed.

Example

These examples are illustrative; the amounts are in US dollars.

A deposit added instead of matched

A design studio invoices a client US$8,000 in May. The client pays, and the payment is applied to the invoice. The bank feed then shows the deposit, and it is added as income instead of matched. May income reads US$16,000 against one deposit of US$8,000. The studio removes the added income entry and matches the bank line to the existing record. May income is US$8,000 again.

A payment app connected in September

An online shop that files on a calendar year connects a payment app in September. For four months each sale appears as an invoice and again as a synced sale, about US$22,000 of extra income. The shop chooses invoices as its one source, switches off the sync's sales, and clears the duplicates month by month, comparing each month with its deposits. If that year's return was already filed from these books, the extra US$22,000 is on the return, and the next step is the amended-return check above.

An upload and the feed

A contractor uploads a bank statement by hand and adds its 60 deposits, US$9,400 in all. The live feed then delivers the same 60 lines into For review. The contractor checks each against the deposit already recorded and excludes the 60 feed copies before they are added, so the books keep US$9,400 of deposits, not US$18,800. Had both sets already been added, the posted extras would need correcting in the books and the account reconciling again.

Different for you?

• The doubling spans months, a payment app syncs into several accounts, reconciled periods are involved, or a filed return may have reported the extra income: get bookkeeping help to settle which entries to keep, whether any return needs amending, and how to set up so each sale is recorded once.
• A partnership or S corporation return may have carried the extra income: see correcting a filed business return.
• A payment never clears and Undeposited Funds keeps growing: see Undeposited Funds balance.
• Payouts, fees or a Form 1099-K do not match your sales: see reconciling sales and payouts and payouts in the books.
• A reconciliation is off after you deleted items: see reconciliation beginning balance wrong.
• Refunds were recorded as income: see recording refunds in the books.
• A filed year keeps changing after the return went in: see closing date after taxes are filed.
• The books are months behind, or the IRS has written about the year: see catching up on overdue books with bookkeeping help, or an IRS notice to your business.