Skip to main content
L
Lexie22
October 4, 2019
Question

Using recent bank transactions to record sales

  • October 4, 2019
  • 1 reply
  • 0 views

I have a client who deals with cash only sales and has been using the bank feed function to record them. This is obviously giving an inaccurate picture of the accounts as it doesn't actually show what sales were made when only when they hit the bank account.

My question is how do I rectify this? If I input the sales using control accounts as you would normally will this double enter everything or can I then reconcile/ link the transactions?

 

Thanks in advance for any help

1 reply

R
Ryan_M
October 4, 2019

Hi @Lexie22,

 

You can advise your client to record their sales in real-time. You can then match the downloaded bank transactions to those transactions.

 

Here's how:

  1. From the Banking tab, select the bank account in question.
  2. Under the For Review tab, select any transaction and then match it to its corresponding transaction.

Take a look at this article where you can learn how to add or match your downloaded bank transactions. It even includes a short video of the process, for your reference. 

 

Do you have other questions? Post them below, and I'll get back to you.

L
Lexie22Author
October 5, 2019

Thank you for the quick response. 

Is it possible to retrospectively match transactions that have not been input yet? No sales are showing on the dashboard unless I input them and I don't want to accidentally double up records

C
Charies_M
October 5, 2019

Hello there, Lexie22.

 

Yes, you can add the sales payments from the Banking page even you have not entered yet in QBO. This way, it will not duplicate the transaction and it will automatically reflect on the dashboard. Just make sure that you have categorized them properly.

 

Please refer to this article for a complete instruction manually upload transactions into QuickBooks Online.

 

All downloaded transaction will show on your For review tab. To avoid duplicates, you can exclude the double transactions from there.

 

Once done, you can start matching your downloaded bank transactions. 

 

If you meant something else, please let me know and I'd be happy to help you further.

    Terms & ConditionsAccessibility statement