Skip to main content
October 26, 2022
Question

Does QBO have an open item match function?

  • October 26, 2022
  • 1 reply
  • 0 views
I would like to match invoices with receipts to get an accurate open item report

1 reply

October 26, 2022

I've got a way how you can compare your invoices to sales receipts, elismaniemann-pe.

 

You can't match invoices with sales receipts since both are sales transactions. But you can compare them. 

 

You can pull up a Transaction List by Customer report and customise it to Invoice transaction type, then run another one for Sales receipts. This way, you can easily compare the two.

 

Here's how:

 

  1. Go to the Reports tab.
  2. From the Sales and customers section, select Transaction List by Customer.
  3. Click Customise.
  4. Click Filter and choose Invoice from the Transaction Type.
  5. Click on Run report.

 

Repeat another step for the Sales receipts to get the data needed.

 

Check our understanding of the difference between invoices and sales receipts so you can properly enter these transactions into your account.

 

Moreover, I've added these resources for customising your report and common custom reports for future reference:

 

 

If I can be of any additional assistance, feel free to add a reply so I can get back to you.