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

Missing customer

When running open invoice report for fiscal quarter ending June 30, a customer with balance does not show up. Why not? That customer recently had a name change.

2 Comments 2
KlentB
Moderator

Missing customer

Hi there, Janet32.

 

I'll make sure that you'll get an accurate report at the end of the  day. All the customers with open invoices should show in this report, this includes active and inactive customers. To isolate the issue, you'll want to make sure there are no other filters applied to the report aside from the date. 

 

  1. Go to the Reports menu.
  2. Choose Customers & Receivables.
  3. Select Open Invoice, then click the Show Filters at the top.
  4. Clear the filters.

if the customer is still not showing, I recommend running the Verify and Rebuild utilities to scan your file for potential data integrity issues causing the report discrepancy.

 

Lastly, here a reference that you can check to help track your sales and customer transactions in QuickBooks Desktop: Customize customer, job, and sales reports.

 

Don't hesitate to add a comment below if you need further assistance in running your other reports.

BigRedConsulting
Community Champion

Missing customer

The name change doesn't matter.

 

If you mean that a customer had an open invoice on June 30, but is has been paid since, then by default the invoice won't show up on the report, because it is current paid off.

 

If you want transactions to appear that are currently paid off, but were not on the date of the report, there's a setting you can change to make that happen:

Capture.JPG

 

You you pick Report Date as shown above, transactions after the report date are magically backed out of the data and invoices will appear with their balances due as of the report date, even if they are paid on a later date.

Need to get in touch?

Contact us