Multi Year Accounts Receivable Report

GolfNut72 · ‎August 28, 2020

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

LieraMarie_A · ‎August 28, 2020

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:

Go to Reports.
Select Customers & Receivables and choose Customer Balance Detail.
Click on the Customize Report button.
Set the date range.
Select the Filters tab.
Type in "Name" in the Search Filters field.
Click the All names drop-down.
Choose the Multiple names option.
Select the names by placing a check mark.
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:

Click on the Excel drop-down menu.
Select Create New Worksheet.
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

LieraMarie_A · ‎August 28, 2020

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:

Go to Reports.
Select Customers & Receivables and choose Customer Balance Detail.
Click on the Customize Report button.
Set the date range.
Select the Filters tab.
Type in "Name" in the Search Filters field.
Click the All names drop-down.
Choose the Multiple names option.
Select the names by placing a check mark.
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:

Click on the Excel drop-down menu.
Select Create New Worksheet.
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.

Topics

Training

Community

Resources

Multi Year Accounts Receivable Report

Multi Year Accounts Receivable Report

Multi Year Accounts Receivable Report

Emailing Year-End Reports

How do run a multi week employee hours worked report

Multi-Currency

When I export an account register to csv (example exporting Accounts receivable register from the Chart of Accounts), I only get the last 2 years of transactions. What do

Custom Report

Need to get in touch?