cancel
Showing results for 
Search instead for 
Did you mean: 
GolfNut72
Level 4

I am working with a client who's books are several years behind.  I am now working on Accounts Receivable and trying to determine how to create a report that will show me the outstanding balances for new customers by year.

 

I have run the reports for 2017, 2018, and 2019.  On each report are the customers with outstanding balances but several customers have outstanding balances from previous years.  How do you create a report that will show just the new customers for a particular year?  I also realize that some of the customers from 2017 are from previous years and I will have to review each customer and determine how to close out any outstanding balance on the account.

 

I hope I explained this so it is understandable.

 

Thanks for your help and guidance with this.

 

EJ

 

 

Solved
Best answer August 28, 2020

Best Answers
LieraMarie_A
QuickBooks Team

Hey there, @GolfNut72.

 

Currently, the option to filter a report to show the new customers with outstanding balances only in that specific year isn't available. You may consider sorting out the names with open balances from the Modify Report window.

 

Here's how:

  1. Go to Reports.
  2. Select Customers & Receivables and choose Customer Balance Detail.
  3. Click on the Customize Report button.
  4. Set the date range.
  5. Select the Filters tab.
  6. Type in "Name" in the Search Filters field.
  7. Click the All names drop-down.
  8. Choose the Multiple names option.
  9. Select the names by placing a check mark.
  10. Click OK.

 

As another option, you can export it to Excel to make such modifications or any other changes that you need.

 

Here's how:

  1. Click on the Excel drop-down menu.
  2. Select Create New Worksheet.
  3. Select Export.

 

You can also check out this article on how to save your report so that you don't have to do the same process again: Create, access, and modify memorized reports.

 

Let me know if there's anything else. We're always here to help. Have a great day.

View solution in original post

1 Comment
LieraMarie_A
QuickBooks Team

Hey there, @GolfNut72.

 

Currently, the option to filter a report to show the new customers with outstanding balances only in that specific year isn't available. You may consider sorting out the names with open balances from the Modify Report window.

 

Here's how:

  1. Go to Reports.
  2. Select Customers & Receivables and choose Customer Balance Detail.
  3. Click on the Customize Report button.
  4. Set the date range.
  5. Select the Filters tab.
  6. Type in "Name" in the Search Filters field.
  7. Click the All names drop-down.
  8. Choose the Multiple names option.
  9. Select the names by placing a check mark.
  10. Click OK.

 

As another option, you can export it to Excel to make such modifications or any other changes that you need.

 

Here's how:

  1. Click on the Excel drop-down menu.
  2. Select Create New Worksheet.
  3. Select Export.

 

You can also check out this article on how to save your report so that you don't have to do the same process again: Create, access, and modify memorized reports.

 

Let me know if there's anything else. We're always here to help. Have a great day.

View solution in original post

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us