Skip to main content
February 15, 2020
Solved

Daily Sales and imported deposits

  • February 15, 2020
  • 1 reply
  • 0 views

I have created a ‘daily sales’ customer to track sales for sales tax purposes.  I auto import bank transactions. How do I reconcile this so that it does not show double income, as the daily sales receipt automatically shows paid 

Best answer by vpcontroller

@AThornhill 

 

"I have created a ‘daily sales’ customer to track sales for sales tax purposes."

 

This is the right way to record sales tax transactions in QBO.

 

Reconciling the bank deposit transactions with a deposit from the sales receipts may need some knowledge in QBO on how to MATCH with already recorded deposits. 

 

You're right, you do not want to add again. Adding it will create duplicate income.

Normally, you should see the MATCH icon and click match and done. In case, you're not seeing match for deposit item (money in), click the deposit transaction row and select the "Find match" icon and try to match it.  This is the process and it's supposed to work in QBO.

 

In case, there is no way to match the deposits based on the way you're creating daily sales receipts, the other option would be to Exclude deposits from the Banking For Review tab and then reconcile the bank account at the month-end.

 

Hope this helps!

 

 

 

1 reply

vpcontroller
February 15, 2020

@AThornhill 

 

"I have created a ‘daily sales’ customer to track sales for sales tax purposes."

 

This is the right way to record sales tax transactions in QBO.

 

Reconciling the bank deposit transactions with a deposit from the sales receipts may need some knowledge in QBO on how to MATCH with already recorded deposits. 

 

You're right, you do not want to add again. Adding it will create duplicate income.

Normally, you should see the MATCH icon and click match and done. In case, you're not seeing match for deposit item (money in), click the deposit transaction row and select the "Find match" icon and try to match it.  This is the process and it's supposed to work in QBO.

 

In case, there is no way to match the deposits based on the way you're creating daily sales receipts, the other option would be to Exclude deposits from the Banking For Review tab and then reconcile the bank account at the month-end.

 

Hope this helps!

 

 

 

February 17, 2020

Yes I will try that!  Thank you!