cancel
Showing results for 
Search instead for 
Did you mean: 
ER5
Experienced Member
Solved

Reverse a Reconciled Sales Receipt which was entered with Blank Customer Name

I am helping to clean up books and have found a sales receipt entry which was done incorrectly (the total is correct, but one sales receipt was created to lump sum multiple customer orders). The Sales receipt entry has been reconciled as it is dated last year, though the Undeposited Funds account is where it was entered. The customer name fields were left blank during the entry, so I'm not certain creating a credit memo is an option. Looking for suggestions for the best way to reverse this entry so that I can enter each of the customer sales receipts individually and also keep the reconciliation balance correct. (This was done in desktop QuickBooks Premier Edition 2016). Thanks!

Best answer 04-18-2019 04:52 PM

Accepted Solutions
QuickBooks Team

Re: Reverse a Reconciled Sales Receipt which was entered with Blank Customer Name

Hello, @ER5.

 

Please allow me to help share additional ways to handle your sales receipts.

 

If you wish to correct this by deleting and recreating as 131 transactions, then, you can. However, once you delete the reconciled sales receipt, it will post a discrepancy on the opening balance of the reconciliation.

 

On the other hand, recreating the 131 transactions, then manually reconciling them in the Account Register will fix the problem. Just ensure that the total amount is the same as what was deleted.

 

For your future reference about fixing reconciliation discrepancy, you may check this article: Fix Reconciliation Discrepancies.

 

As always, don't hesitate to add a post/comment below if you have any other questions. I'm just a post away.

3 Comments
Highlighted
QuickBooks Team

Re: Reverse a Reconciled Sales Receipt which was entered with Blank Customer Name

Hi there, @ER5.

 

I'd be glad to help you today so you'll be able to handle your reconciled sales receipt correctly.

 

To keep the correct reconciliation balance, you can simply add a customer designated for the Sales Receipt created. Modifying the reconciled transaction with the customer name won't affect the reconciliation unless you'll modify the date/amount of the transaction.

 

However, if you wish to reverse or delete the sales receipt with blank customer name, you really need to undo the reconciliation.

 

To learn more about reconciliation in QuickBooks Desktop, you may check these articles:

 

Please feel free to add a post/comment below if you have any other reconciliation concerns, I'll be right here to help you. Wishing you the best!

ER5
Experienced Member

Re: Reverse a Reconciled Sales Receipt which was entered with Blank Customer Name

Thank you for your response @Angelyn_T

 

The difficulty I have is that the one sales receipt which was entered is actually the sum total of 131 different customer orders over a six month period. Only one of the orders has the same date of the incorrect sales receipt, and I would need to adjust the amount of that one sales receipt. I don't understand how the Undeposited Funds account is reconciled, though it seems to be automatic.

 

Would I create issues by making these new entries and adjusting the amount of the one incorrect entry or even deleting it? (All of this is occurring in the Undeposited Funds account and the balance will again be zero after correcting entries). 

 

Thanks again!

QuickBooks Team

Re: Reverse a Reconciled Sales Receipt which was entered with Blank Customer Name

Hello, @ER5.

 

Please allow me to help share additional ways to handle your sales receipts.

 

If you wish to correct this by deleting and recreating as 131 transactions, then, you can. However, once you delete the reconciled sales receipt, it will post a discrepancy on the opening balance of the reconciliation.

 

On the other hand, recreating the 131 transactions, then manually reconciling them in the Account Register will fix the problem. Just ensure that the total amount is the same as what was deleted.

 

For your future reference about fixing reconciliation discrepancy, you may check this article: Fix Reconciliation Discrepancies.

 

As always, don't hesitate to add a post/comment below if you have any other questions. I'm just a post away.