Skip to main content
June 7, 2022
Question

Can i filter out customers with negative totals from my A/R report

  • June 7, 2022
  • 1 reply
  • 0 views
can i filter out customers with negative totals from my A/R report

1 reply

Jen_D
June 8, 2022

It's great to have you here in the QuickBooks Community, Herbert.

 

Allow me to help you with this Accounts Receivable reporting you're asking about. To share some insights about A/R reports, they will only show unpaid invoices or aging unpaid balances for each customer, grouped by days past due. 

 

This means that this reporting type will not display customer balances especially those with negatives. If you want to view customer balances, you'll need a Customer Balance Detail report. This will display how much each customer owes you or if they have a credit on their account.

 

You can easily spot the names with negative balances. Take note of them because filtering specific data must be done manually. Once you've identified the names with negatives, you can specify the customers using the filter option. Here's how:

 

  1. On the Report, click the Customize option.
  2. Click the Filter menu, then locate the Customer drop-down.
  3. From the drop-down, mark the name of the customers with negative balances.
  4. After you added other filters, click Run report.

 

You can access these report under Reports then the Who owes you section. To learn more about the reporting process in QBO and other tips, use the following references:

 

 

 

Mention me anytime if there's anything else you need with QuickBooks Online. I'm here to help make sure your reporting is accurate and assist you with other tasks.