cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
ttanner
Level 2

Deposits and Invoices added - how to reverse for entire year

Have a client that has made the mistake of adding the deposit without matching up and then added the invoices so income is double counted, for the entire year.  There are more than 1000 transactions so can't do an undo and rematch.  I have reconciled the bank accounts and they are good, but the invoices have been added so P&L is off since counted twice. 

 

Any ideas how to fix this???

2 Comments 2
MaryLandT
Moderator

Deposits and Invoices added - how to reverse for entire year

I understand that you've already reconciled the bank account, ttanner. However, matching invoices with deposits will fix double entries on the Profit and Loss report.

 

That being said, you'll want to undo the previous reconciliations using the special tool on your QuickBooks Online Accountant plan. Here's how:

 

  1. Go to Accounting from the left menu, then select the Reconcile tab.
  2. Click History by account.
    This is an image of the main reconcile an account screen, highlighting the link to History by account
  3. Choose the account you want to reconcile and the date range from the drop-down.
  4. Find the reconciliation on the list and click View report.
    This is an image of your history by account screen
  5. This opens the Reconciliation report.
  6. Review any discrepancies and changes your client wants to make.
  7. When you’re ready, select the drop-down ▼ in the Action column, then click Undo.
  8. Select Yes, then Undo to confirm.

 

Once done, go to the Banking page and match transactions from there. Then, redo the reconciliation.

 

To prevent duplicate entries moving forward, your client should match transactions. That way, you won't start over with the reconciliation process.

 

Keep me posted if you need anything else. I'll be right here to answer your questions @ttanner.

ttanner
Level 2

Deposits and Invoices added - how to reverse for entire year

Thanks for the info, but that is information I already knew.  Neither the client or I want to sit through 1000+ transactions by undoing the transactions, undo the bank recs, etc.  I was looking for another solution other than the obvious, and maybe there is not another solution other than the obvious.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us