cancel
Showing results for 
Search instead for 
Did you mean: 
accounts-frostcr
Level 1

How to check if there are any Sales Receipts in Quickbook that's not being matched to actual bank transactions?

 
Solved
Best answer June 21, 2021

Best Answers
DivinaMercy_N
Moderator

How to check if there are any Sales Receipts in Quickbook that's not being matched to actual bank transactions?

Welcome to the QuickBooks Community, @accounts-frostcr.

 

To clarify, are you referring to the sales receipts that haven’t cleared any of the bank accounts? If so, you can run a Transaction Report to view those transactions. Let me guide you on how:

 

  1. Go to the Reports menu and choose Balance Sheet.
  2. Once opened, click the Total Assets amountsr1.PNG
  3. Select the Customise button.
  4. From the Report period, choose All Dates.
  5. Next, go to the Rows/Columns field and check the box beside Clr
  6. Then, in the Filter section, check Transaction Type and choose Sales Receipts
  7. Check also the Cleared option. 
  8. Once done, click Run reportsr2.PNG

 

The report will let you see all the sales receipts that haven't been matched to any transactions on the bank statements (or haven't cleared the bank). If you want to view the details of the transaction, simply click the amount to open the Sales Receipt form. sr3.PNG

 

Also, QuickBooks Online (QBO) makes it easy to save your report customisation so you'll be able to use it in the future. To do so, simply click the Save customisation button in the reports window. 

 

If there is anything else I can do to help you in viewing sales receipts that haven't been matched in QBO, please post a response below. I'm always available to help in case you need it. Have a good one.

View solution in original post

6 Comments 6
DivinaMercy_N
Moderator

How to check if there are any Sales Receipts in Quickbook that's not being matched to actual bank transactions?

Welcome to the QuickBooks Community, @accounts-frostcr.

 

To clarify, are you referring to the sales receipts that haven’t cleared any of the bank accounts? If so, you can run a Transaction Report to view those transactions. Let me guide you on how:

 

  1. Go to the Reports menu and choose Balance Sheet.
  2. Once opened, click the Total Assets amountsr1.PNG
  3. Select the Customise button.
  4. From the Report period, choose All Dates.
  5. Next, go to the Rows/Columns field and check the box beside Clr
  6. Then, in the Filter section, check Transaction Type and choose Sales Receipts
  7. Check also the Cleared option. 
  8. Once done, click Run reportsr2.PNG

 

The report will let you see all the sales receipts that haven't been matched to any transactions on the bank statements (or haven't cleared the bank). If you want to view the details of the transaction, simply click the amount to open the Sales Receipt form. sr3.PNG

 

Also, QuickBooks Online (QBO) makes it easy to save your report customisation so you'll be able to use it in the future. To do so, simply click the Save customisation button in the reports window. 

 

If there is anything else I can do to help you in viewing sales receipts that haven't been matched in QBO, please post a response below. I'm always available to help in case you need it. Have a good one.

accounts-frostcr
Level 1

How to check if there are any Sales Receipts in Quickbook that's not being matched to actual bank transactions?

Thank you! That was very helpful!

IntuitAika
Intuit

How to check if there are any Sales Receipts in Quickbook that's not being matched to actual bank transactions?

You're welcome, accounts-frostcr!

 

Let us know if you have other concerns. Have a great day! 

FreddieCardiff
Level 2

How to check if there are any Sales Receipts in Quickbook that's not being matched to actual bank transactions?

I need to do this as well - there appears to be no option within the Sales part of Quickbooks to just ask it to either show you the transactions which have a match or have been 'cleared'.  You can ask for lots of other columns, though why not this?

I have tried your solution above and there is no 'Total Assets' to click on, and when I try with other headings, I don't get the Sales Receipts.  Surely it should be easy to run a report telling us whether money from all Sales Receipts has been banked....there is scope here for someone to enter sales though not bank the proceeds.

FreddieCardiff
Level 2

How to check if there are any Sales Receipts in Quickbook that's not being matched to actual bank transactions?

I have just worked this out - the heading is actually titled 'Total Cash at bank and in hand'.

I have set this report up and saved it, as advised, though this should be MUCH easier to do.  I have just found several Sales Receipts which hadn't been cleared, so must have been duplicated, as there are no transactions remaining to be matched and the banking has all been done for these Sales Receipts.

There is MASSIVE room for error here and only a report like this will solve it, however, a simple 'cleared' column on the Sales Recipts page would easily enable users to see what has been cleared or not.  Please could this be added?

FreddieCardiff
Level 2

How to check if there are any Sales Receipts in Quickbook that's not being matched to actual bank transactions?

I have also just realised that 'cleared' doesn't provide the information that we need.  You have to select a column called 'online banking' for transaction matching from the bank account to be shown, which is seperate to transactions having been 'cleared'.