Expense Transactions list - why in the F*&$ is there not a column to show if the expense has already been matched, or a filter to allow you to show those not matched?

Welcome to Community @qbcsc,

QuickBooks Online automatically downloads your recent transactions. Then it shows you if they match any records you’ve already recorded in QuickBooks Online. You can see that transaction under the For Review tab. Let me walk you through how to locate the transactions:

1. On the left panel, go to Banking.
2. Select the Banking tab.
3. Choose the blue tile for the account you want to review.
4. Select the For Review tab.
5. Under the Category or Match column, you can see the match and unmatch transaction.

You can view this screenshot for your reference.

I've also added an article if you need help on how to match and categorize your bank transactions: Match and categorize bank transactions in QuickBooks Online.

In case you need help reconciling your account, please refer to this article: Reconcile an account in QuickBooks Online.
 

If you have other concerns, just leave a message below. I'm always here to help. Have a good one!

Thanks for taking the time, but this is the opposite of what I was trying to find out. I mentioned that I was looking at expense transactions, trying to find which of them had not yet been matched. 

For example, if I get X receipts that I need to enter for different employees at different times (I'll avoid setting up the scenario of why this can happen, because it does), why cant I look at all the expenses, and jsimply select in the filter "unmatched".

This would solve entry errors for amounts, combined amounts for multiple receipts all from one employee that were aggregated into a single check, ACH payment, expense report, and 1000 other things I can list here.

When I MANUALLY click on each expense I can see that, and after wasting 4 hours the other day doing so, finally found the entries that I needed to, which could have been found in 1.3 seconds had this simple option been in the filter, or a column in the display that was sortable (like payee, method, source, etc.)

I have no problems understanding reconcile, only wit the toold provided to debug an account that will not reconcile.

Simple addition to filter, immediately solves thousands of issues.

Thanks,

Marty

Thanks for coming back, @qbcsc. I appreciate you for sharing your sentiments about the tools used in reconciliation. 

You can use the filter to show all the transactions that haven't matched with your statement yet. Here's how: 

1. In the Reconciliation page, select the Funnel icon above the Date column. 
2. In the Cleared status drop-down list, select Not cleared. 
3. Select any expenses transactions in the Transaction Type drop-down. 
4. Select the Payee in the drop-down.
5. Click Apply whenever you're ready. 

Form there, it would be easier for you to track and match the transactions. 

For future reference, follow and use our reconciliation guide to help you reconcile your account with QuickBooks. It also includes helpful links related to reconciliation. 

Let me know if you have additional concerns. We're always delighted to help. 

Thanks for trying again, but you have answered the question BACKWARDS, not how I presented it. Reconciling an account, WILL NOT HELP. I understand how to reconcile, been doing it a long time.

I'll give you an example, even though the it really should not matter why, I just want a FILTER OPTION in the expense transaction list that solves all the problems!

Example:

I do NOT have a SINGLE transaction in a SINGLE bank account that I cannot find a match for, but INSTEAD I have several bank/checking ACCOUNTS with several transactions that are not yet matched for the past couple weeks, and several expenses. I have RECEIPTS THAT WERE EMAILED IN TO THE RECEIPTS FEATURE OF BANKING, or entered in manually, that have been reviewed, that have been categorized, and have created expenses.

So lets recap, several receipts were used to create several expenses. I now have several expenses in the expense list, some of which have not been matched, maybe several, and some transaction in bank accounts that are not matched. Some receipts may have been combined to make a single payment (why write 7 checks when I can write 1?).

So, what if I am not a 100% perfect human, and I mistakenly put an expense in with a "pay from" account that was not correct? What if I mistakenly put in an amount incorrectly (typo) because the receipt was not read in by the receipts feature? What if 500 other things I could waste all our time on happened?

If I had a filter option in the expenses list, I could IMMEDIATELY, figure out the mistake. This is trivial.

I appreciate the detailed information, qbcsc.

Currently, the only workaround I can think to locate the expense transactions list by account is to pull up a report. We can customize it to the specific bank account.

1. Select Reports on the left menu and search Transaction list by Vendor.
2. Click the Customize button and set the correct Report period.
3. Go to the Filter section and select the bank in the Account field.
4. You can filter the Transaction Type if necessary.
5. Click Run report.

From there, you should be able to trace back the transactions.

Please get back to us if you require additional assistance in doing this.

Thank you very much.

Though entirely convoluted, this gets what I need, and apparently it is the only way to get it.

BTW, once I had the info I solved my issue in less than 2 minutes!

However, simply putting an option in the filter in the expense transaction list would be a great debugging tool for mistakes. A first year CS student (or I) could add this filter in about 90 seconds, I don't understand why it is not there. My car has an OBD port, and a coolant overflow tank. If the car overheats, I check the coolant overflow tank, I dont hook up to the OBD and try to work backwards.

Thanks again for your diligence.

I have tried this method and there is not an option 'cleared' or 'uncleared' only 'specified' and 'unspecified'. I ran the report for 'unspecified' in case the wording meant the same thing and the report is not an itemised list but an overview. 

I have to echo the original question - why the F*&" is there not an easy way to see within the expenses area which I have already assigned. I have matched 150 and there are another 100 to do but I haven't a clue which they are from within the expenses area!!!

Consider that not all transactions come from the bank feed - there may be multiple payment methods involved so marketing items matching in the banking feed is of little use.

Thanks for joining this thread, @Brienne.

I appreciate you performing the steps to locate those uncleared expense transactions. I've also tried the workaround recommended by @smallbiznumbers here in my sample company and filter the report to uncleared.

For your visual reference, you may refer to the screenshots below to see open expense transactions that haven’t cleared any of the bank accounts.

Here's a handy article that you may visit to guide you in filtering data and personalizing your report in QuickBooks: Customize reports. This also includes steps on how to export, send, and print reports. 

To learn more about the latest product updates in QuickBooks Online, check our QuickBooks Blog. This page provides details for product recent improvements, news, and product enhancements.

Let me know how it goes and leave a reply below. I'm always here if you need help opening reports in QuickBooks. Take care always.

how did you fix your issue? i need help!

Hi QuickBooks,

I have tried to work my way through the “Solved” answer. But one I have gone through all of the steps it just leaved me with an overwhelming log of transactions where I have to hunt for the unreconciled expenses.

All we need is an easy way see all of the expenses that have been put in. Exactly the same as when you select “Match” to reconcile a transaction with an expense. But rather than only seeing the expenses that have been suggested we need to see all of the ones we have put in.

The reason is that when we input them sometimes we make a mistake and as such QuickBooks does not suggest the appropriate expense and then it is lost as we have no way to know how to find it. This is a simple option that is available in Xero for example.

Please solve this in a simple clear way. It’s important.

OK the solution actually works. Almost. The selected solution misses out one crucial step which is to select “Transaction type” = Expence.

See here for a screenshot of the missing link.

https://quickbooks.intuit.com/learn-support/en-us/account-management/how-do-i-run-a-report-showing-a...