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

accounts-frostcr · ‎June 21, 2021

DivinaMercy_N · ‎June 21, 2021

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:

Go to the Reports menu and choose Balance Sheet.
Once opened, click the Total Assets amount.
Select the Customise button.
From the Report period, choose All Dates.
Next, go to the Rows/Columns field and check the box beside Clr.
Then, in the Filter section, check Transaction Type and choose Sales Receipts.
Check also the Cleared option.
Once done, click Run report.

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.

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

DivinaMercy_N · ‎June 21, 2021

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:

Go to the Reports menu and choose Balance Sheet.
Once opened, click the Total Assets amount.
Select the Customise button.
From the Report period, choose All Dates.
Next, go to the Rows/Columns field and check the box beside Clr.
Then, in the Filter section, check Transaction Type and choose Sales Receipts.
Check also the Cleared option.
Once done, click Run report.

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.

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 · ‎June 21, 2021

Thank you! That was very helpful!

IntuitAika · ‎June 21, 2021

You're welcome, accounts-frostcr!

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

FreddieCardiff · ‎September 01, 2021

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 · ‎September 01, 2021

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 · ‎September 01, 2021

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'.

Topics

Training

Community

Resources

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