Correcting Income Recorded Twice in QuickBooks Desktop

(once as a sale receipt/invoice and once as a deposit into the register)

Identify the sales recorded in the register as income (and not as a sales receipt or invoice payment).  There are multiple approaches to this, I’m going to show you one.

1: Generate the profit and loss report (Reports → Company & Financial → Profit and Loss Standard)

2: Double click the number (dollar amount) for the line called Total Income, this generates a list of all of the transactions in a given period of time that were posted to the income account.  If you are also recording your sales as sales receipts or invoices, these will duplicate (increase) your income.

3: Click the customize report button (upper left corner)

4: Click on the tab labeled filters

5: Scroll down for the filter called transaction type

6: To the right of this where it says all, replace all with deposit

7: Click OK

Link the deposit with a previously recorded sale that is pending in undeposited funds.

1: Click on any deposit in the list you generated above.

2: On a piece of scratch paper, write down the amount of this deposit

3: Click on the icon that says payments

4: Click on the payment(s) that equal the deposit previously recorded

5: Click OK

6: Click on the line that does not say “undeposited funds” for the account, this is likely to be the first line in the list.  Delete all text from this line — the account, the amount, etc.

7: Confirm your deposit equals the amount you wrote down on step 2.

8: Click save and close

9: A message will appear “you have changed the transaction. Do you want to record your changes?”, click yes.

10: Repeat until no more deposits appear in the report you generated in the above set of steps.

☕ If you found this helpful you can say “thanks” by buying me a coffee…
https://www.buymeacoffee.com/gentlefrog