Skip to main content
June 12, 2022
Question

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

  • June 12, 2022
  • 1 reply
  • 0 views
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 reply

June 12, 2022

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.

  3. Select the date range from the Report period.
  4. In the upper-right corner, click Customise button.
  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.

  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.

 

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!