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

How to match an unapplied sales receipt to a deposit that has already been reconciled.

I created daily sales receipts for my cash sales, however I did not match with the online bank connection for the deposits.

I have already reconciled my bank account, so how do I link / match the sales receipts to the already reconciled deposits?   

4 Comments 4
ShiellaGraceA
QuickBooks Team

How to match an unapplied sales receipt to a deposit that has already been reconciled.

Thanks for visiting the Community, @steinv.

 

I'll share and guide you with the steps on how to match your transactions. Let's go to your register to see it.

 

  1. Go to Accounting, then Chart of Accounts.
  2. Look for the account where the sales receipts are recorded, then click the View register link.
  3. Locate the reconciled sales receipt. Then, continuously tick the Reconcile status until it's blank of empty.
  4. Hit Save.

Below is the screenshot on how it looks like to change the reconciliation status.

 

 

After changing the reconcile status to blank, you can now match it to your deposit. Moving forward, you can just match your downloaded transactions with your sales receipts in QuickBooks. For more information about matching transactions, check out this guide: Categorise and match online bank transactions in QuickBooks Online.

 

Need help with other banking tasks? click this link to go to our general banking and bank feed topics with articles. 

steinv
Level 1

How to match an unapplied sales receipt to a deposit that has already been reconciled.

Thank you for your response.   

I'm a little confused about changing the "R" because this will create an out of balance bank reconciliation.   

ShiellaGraceA
QuickBooks Team

How to match an unapplied sales receipt to a deposit that has already been reconciled.

Thanks for responding, @steinv.

 

Changing the reconciliation status will let you undo and rematch your downloaded transaction with QuickBooks transactions. After matching, manually reconcile your account to correct your books.

 

If the deposit is already in QuickBooks, you can delete or exclude the duplicate transaction as your other option. That way, you won't need to undo or reconcile again. Let me guide you how:

 

  1. Go to Banking, then Banking at the top.
  2. Look for the duplicate transaction, then put a check mark on it.
  3. Click the Exclude button. This transaction will then move to the Excluded tab.

From there you can tick the box of the excluded transaction and Delete (see image below). For more details, please check out this link.

 

Know that I'm always here if you still have questions. Don't hesitate to reply. Take care and have a wonderful day. 

steinv
Level 1

How to match an unapplied sales receipt to a deposit that has already been reconciled.

When I made the deposit I "added the fund to the deposit" and selected the income account rather then selecting the sales receipts.  My goof up.   Because this happened back in June 2020, and discovered this when I was comparing my income statement with my sales report.   I am skeptical about unreconciling the transaction because the reconciliations for my bank account is in balance with QBO.  I don't want to create any discrepancies with the bank account.   

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up