cancel
Showing results for 
Search instead for 
Did you mean: 
effectus01
Level 1

Hi There, how do i run a report that shows non online match expenses

I am trying to see if I have posted expenses that have not been match to online bank account i.e. maybe wrong expenses
1 Comment 1
Kevin_C
QuickBooks Team

Hi There, how do i run a report that shows non online match expenses

I've got your back, @effectus01

 

I'll make sure you'll be able to run a report that shows expenses that haven't matched your online banking transactions.

 

In QBO, we can pull up the Transactions Detail by Account report and then customise it to show these unmatched expenses. 

 

Here's how:

 

  1. Go to the Reports menu. 
  2. In the search field, you can enter and click on Transaction Detail by Account.
    Tanx1.PNG
  3. Select the date range from the Report period.
  4. In the upper-right corner, click Customise button.
    Tanx2.PNG
  5. Select the Change columns link, then place a checkmark next to Online Banking.
  6. Scroll down then click the Filter drop-down.
  7. From the Transaction Type, choose the Expense account.
    Tanx3.PNG
  8. Click Run report.

 

Running this customised report will display all of your expense transactions. Then, under the Online Banking column, you'll see the following:

 

  • Manually matched if it's an expense that has been matched to your online bank transactions.
  • Manually added if it's categorised or added directly from your bank transactions.
  • And you'll see a blank in the column if it's not matched to your online bank transactions.
    Tanx4.PNG

 

Furthermore, you can focus on the details that matter the most to you when you pull up reports in QBO. If you wish to know more about this process, I'd recommend checking out this article: Customise reports in QuickBooks Online. Then, if you want to memorise the report you've customised, feel free to check out this article for the detailed steps and information: Memorise Reports in QuickBooks Online.

 

Feel free to tag my name in the comment section if you need more help in managing your other reports in QBO. I'm always here to lend a helping hand. Keep safe!