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

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

 

6: 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.

 

Need help with QuickBooks?  Schedule an appointment today!