cancel
Showing results for 
Search instead for 
Did you mean: 
ER5
Level 1

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!

Solved
Best answer April 18, 2019

Best Answers
Angelyn_T
QuickBooks Team

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.

View solution in original post

5 Comments 5
Angelyn_T
QuickBooks Team

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
Level 1

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!

Angelyn_T
QuickBooks Team

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.

7539
Level 1

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

My problem is a little different. I have a husband and wife who have separated and, until now, their donations have been posted in one Customer record. Now I have created a new record for the husband and want to move his 13 donations over. However, most of his donations went into Undeposited Funds and were then grouped with other online donations and deposited in the Bank. To change his donations means deleting them from the grouped deposits and then redepositing them, a solution that is cumbersome and risks messing up our reconciliation. I thought of posting a credit/refund to the wife's record and then re-entering them in the husband's record but that seems to be putting an extra entry in Accounts Receivable that I'm not sure what to do with. Any advice?

Candice C
QuickBooks Team

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

Hi, @7539.  

 

I hope your week is going well. I'm unable to advise you on which route to take, but you can consult with your accountant to be sure. They'll be able to give you a breakdown of what you can do and the best accounting advice for your unique business. If you don't have an accountant, you can check out our find an accountant link to help you find the support you need. 

 

If you have any other questions, don't hesitate to ask. I want to make sure that your concerns are addressed. Enjoy the rest of your week!

Need to get in touch?

Contact us