cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How can I find invoices not matched to a deposit? I am worried about duplicate invoices from syncing jobber, but can't find a list of paid invoices not matched to deposit

 
3 Comments
QuickBooks Team

Re: How can I find invoices not matched to a deposit? I am worried about duplicate invoices from ...

You can run two reports to get the data you need, jbeato2009.

 

The Transaction List by Customer and Transaction List by Account can show you if an invoice has been matched to a deposit or not. You'll only need to filter it to show the Cleared status and the Transaction Type.

 

Like this:

  1. Click Reports on the left panel.
  2. Type Transaction List by Customer/Account in the search box.
  3. Click the Customize button in the upper right-hand corner.
  4. Maximize the Rows/Columns section, and then click the Change columns link.
  5. Check the Clr box.
  6. Maximize the Filter section.
  7. Check the Transaction Type box and choose Invoice.
  8. Checked the Cleared box and select All.
  9. Click Run report.

After filtering the report, look for the invoices that doesn't have a letter C under the CLR column. This means that they are not yet matched to any deposits.

 

If you have any further questions, just let me know.

Not applicable

Re: How can I find invoices not matched to a deposit? I am worried about duplicate invoices from ...

Hey,

 

I followed all your steps but the report I get is showing blank under CLR column even for the invoices i have manually matched to banking.

When i sort by all and not just transactions it shows payments and invoices in the report but the payments have a C marked under CLR. 

 

Am I going wrong somewhere ?

QuickBooks Team

Re: How can I find invoices not matched to a deposit? I am worried about duplicate invoices from ...

I'd like to check why your report is not showing the correct details, Siddharth sawhney.

 

When you see a C mark on the payments under the CLR column, it only means one thing. They were successfully matched to the invoices. Please take note though that in the reports, only the payments will be recognized as cleared and not the invoices. This behavior in QBO is working as designed.

 

To find the unmatched invoices, you'll have to do it directly from the Banking page.

 

Here's how:

  1. Click Banking on the left panel.
  2. Look for a payment in the For Review tab.
  3. Select the Find Match radio button.
  4. Click the Show drop-down, and then select Open invoices.
  5. From the list, look for the match and select it.
  6. Click Save.

You can also take a screenshot of the open invoices list so you don't have to switch tabs.

 

Please keep me posted if there's anything else you need.

Need to get in touch?

Contact us