Customer Aging report

The Customer Aging report shows a list of customers who owe you money and either how many days it took them to pay you or how many days past due their payments are. Use this report to determine how well you are collecting on your receivables.

Assuming the standard aging periods of 0-30, 31-60, 61-90 and 91-120 days, you see columns for each of these aging periods. For example, if a customer is late on a payment that's now 66 days past the point when it was due, you will see that amount in the 61-90 column.

You can create additional aging periods if the standard ones do not fit your business needs.

If you use the Construction application, your customer retainage appears in this report. See View retainage details for more information.

Who typically needs this report?

• Finance managers who need to spot and correct problems in the management of receivables.

For information on terms that may differ in your location, see Terminology across locales.

To generate this report, go to Accounts Receivable > All > Reports > Customer aging.

View a monthly report

To run a report:

1. On the report settings page, select View.

   The report appears all results for the default reporting period.

2. To refine the report, select Customize.

A Customer Aging report shows the amounts that your customers owe you. Most businesses run an aging report at the end of each month.

Customize and run

Before running the report, you can select the time period, types of items to include, and specify how you want the report to appear.

To customize and run this report:

1. Select the aging periods for the report.
2. Set the filters to get the specific data you want.
• Filters enable you to include or exclude specific types of data in the report. As a general rule, to get fewer and more precise results in your report, set more filters.
3. Format the report.
   • Format options will vary from report to report. Generally, you can set the layout of the report and arrange how to group and display the data contained in the report.
   • You can customize the detailed report to show only the dates that you need with the Dates to display option.
4. Enter a title, subtitle, and footer text for your report.
5. To view, process, memorize, or export the report, select one of the following:

How to work with reports

To:	Select:
View the report now, in your browser.	View
Display the report in PDF format so you can print it or save it to your local drive.	Print
Generate the report and store it for later access. Available formats include HTML, printable (PDF), Excel, CSV (comma-separated value), and Text. Reports can be stored: In Intacct In the My stored reports list Delivered to a cloud storage location, such as Dropbox Learn more about processing and storing reports.	Process and store
Add the report to your dashboard.	Add to dashboard
Memorize (that is, save) the report in the Memorized reports list so that later you can refer back to it or modify and re-run it. You can schedule memorized reports to run on a recurring basis. Intacct can automatically email the reports or deliver them to a cloud storage location.	Memorize
Export the report to a separate file that you can then distribute or save to your local drive.  Available file formats vary among reports.	Export

After you run a report, you can either email it to others or return to the Report Settings page to refine the results.

Share and refine reports

After running the report, to...	Select
Email the report to others.	Email
Return to the main report page and refine the report further.	Customize

Specify the reporting currency

Use this section to select a single currency for your report.

To specify the currency to use for the report:

1. In the Reporting currency section, select the Reporting currency down arrow, and then select the currency to use for this report (for example, CAD, EUR, or USD).
2. Select how to convert currencies:
   • Select Base currency to convert the amount from the base currency of each entity into a single reporting currency using the exchange rate as of the report date
   • Select Transaction currency to convert the amount from the transaction currency of each invoice into the reporting currency using the exchange rate as of the report date.

Reporting Period Section	Notes	Limitations
Reporting currency	Select from the dropdown list.
Convert currency from	Your selection can produce different reporting amounts due to exchange rate differences. The default selection is to convert currency from base currency to produce a consolidated view of the aging report.

Time period

You can adjust the time period, customer type, and other details to meet your reporting needs. For example, you might prefer listing the outstanding amounts by due date rather than invoice date.

To specify the time period for the report:

Time Period	Notes
Aging periods	Currently the only selection is -0, 1-30, 31-60, 61-90, 91-.
Report as of	Select either Today or Select date for the Report as of date (the date to use as a baseline for the period you select). If you chose Select date, then you must specify the date in the Date to use (prior label Selected date) box.
Select date (Prior label selected date)	Specify the date on which to list the outstanding amounts customers owe.
Based on	Set and display the date you are basing the report on: invoice date, due date, or the GL posting date. The Based on date type appears at the head of the report.

Report filters

You can filter the list of customers by customer name or type.

The following table describes each item in the Filters section of this report settings page:

Filters	Notes	Limitations
Customer selection	Range: This option lets you set the report to show results for a specific customer or range of customers with the From customer and To customer dropdowns. By default these boxes are blank, which means the report will get results for all customers. With this option, you can choose to Include child customers in your filter results. How to use the From and To fields All From and To field pairs work the same way. Use them to get search results in as broad or as fine a range as you need, from everything in the system down to a single specific object. To run this report for a single object: From the From dropdown list, select the object you want. From the To dropdown list, select the same object. To run this report for a specific range of objects: From the From dropdown list, select the object that you want at the beginning of the range. From the To dropdown list, select the object that you want at the end of the range. To run this report for all objects: Leave both fields blank. If you have a large number of objects or the report takes too long to process, use the From and To fields to run a series of smaller reports. For example, you can run five reports, one each for objects whose names begin with A-E, then F-J, K-O, P-T, and U-Z. An object is a catch-all term that refers to any specific data item in the system. Customers, vendors, items, and accounts are all examples of objects. Multiple customers: This option lets you add multiple customers and ranges of customers the filter list to better target your report results. Customer group: This option lets you filter for all customers within a particular customer group.	The Include child customers option is available when filtering by range.
Customer type	Enables you to get data only for the type of customer you specify here. By default this box is blank, which means the report will get results for all customer types.
Territory	Enables you to select a specific territory if you organize your sales geographically. You can also select predefined groups of territories by selecting the icon. For example, you can select the group US TERR, which includes WEST and EAST. The report will include the data for those territories only. Optionally, select the Individual reports checkbox if you want to print the data for each department/location on its own report. When you select Individual reports, all of the individual reports are contained in a single report or Excel workbook.	Select Process and store if you select the Individual report option.
Transaction currency	Enables you to specify the currency. By default this option is clear, which means the report will get results for all currencies.
Exchange rate types	Enables you to specify the exchange rate to use when calculating the amount. The default is Intacct daily rate.
Location	Enables you to limit report results to a specific location. To filter the report by geographic location, enter the name of the region, country, state or territory, or city in the Location box, or select the down arrow, and then select the location from the list. Enter or select a location if you want to run this report at the top level. The location you specify determines the appropriate currency.	Only appears for multi-currency, multi-entity companies.
Department	Enables you to limit report results to a specific department. To filter the report by department within the company, enter the name of the department in the Department box, or select the down arrow and then, from the list that appears, select the department you want.	Only displays for multi-currency, multi-entity companies.
Individual report	Select this checkbox if you want each entity or department and/or location to have its own report page.	Due to their potentially large size, reports with departments and locations on individual pages can be run offline only. Therefore, if you select the Individual report option, you can select only Process and store.
Prompt on run	Select this checkbox to require you (or anyone using this report) to enter an entity or location and department before the report will run.
Show for	Enables you to display transactions for certain locations regardless of the location selected in the Location dropdown. All locations: show transactions for all locations within the location specified in the Location box. This location: show transactions for the entity's location within the location specified in the Location box. Child locations: shows transactions only for areas subordinate to the location of your entity.	Example: Suppose that your location is USA > California > Bay Area > San Francisco. All locations would show transactions for California > Bay Area > Los Gatos. This location would show transactions for California. Child locations would show transactions for Bay Area and Los Gatos only.

Formatting

You can sort by customer ID, name, amount, or GL posting date. You can accept the default of a simplified report that summarizes the detail into a single line per customer, or generate a detailed report of all invoices to the customer. Additionally, you can choose to suppress or display accounts with zero balances.

To format this report:

Format	Notes
Sort by	Select the Sort by dropdown, and then select the category to sort by. The abbreviation "desc" after an option means "Descending order", reverse alphabetical or reverse numerical order. The default sort order and number of options change depending on whether you want a summary report or a detail report. Customer ID is the default sort order.
Report type	Select the Report type that you want. By default you will get a summary report. The Summary report type condenses all account details to a single line. The Detail report type displays one line per customer per account. It also includes additional columns of information.
Show customers with zero balance	Select Yes to include customers with a zero balance, or select No to exclude them from this report. No is the default option.
Page orientation	To set the page layout, select either Portrait or Landscape.
Dates to display	Choose to include a column in the report for invoice dates, due dates, or GL posting dates. The default is to include all dates in the report. These dates are displayed in the box marked Selected. To hide a specific date, select a date and select the left arrow to move it into the box marked Available.

Titles and footer

Titles, subtitles, and footers apply only to the PDF version of this report.

Generate a PDF version

1. Open the report and select Graph.
2. From the graph page, select Print.

To add a title, subtitle, and footer to the report:

1. Enter the title in the Report title 1 box.
• This title appears in large type at the top of the page, directly under your company name,
• You can change any default name that was supplied in this box.
2. Enter the subtitle in the Report title 2 box.
• The subtitle appears in smaller type, directly beneath the main title.
3. Enter the footer text in the Footer text box. Footer text appears at the bottom center of the report.

What's in this report?

The default Customer Aging report consists of the following columns:

Report column heading	Description
Based on:	The date filter on which the report is based: Bill date Due date GL posting date
Customer ID	The ID associated with your customer
Customer name	The name of your customer
Document no.	The transaction number, such as the invoice number or advance payment ID. For detailed report only.
GL posting date Invoice date Due date	GL posting date: the date the invoice actually posts to the GL Bill date: The date on which the invoice was sent to the vendor Due date: The date the invoice is due For detailed report only.
Days aged	The number of days calculated from the as of date to due date. For detail report only
Txn currency	The transaction currency used. For detailed report only.
Txn amount	The transaction amount. For detailed report only.
-0	The amount the customer owes you for invoices made during the current month.
1-30	The amount the customer owes you that's 1 to 30 days past due.
31-60	The amount the customer owes you that's 31 to 60 days past due.
61-90	The amount the customer owes you that's 61 to 90 days past due.
91-	The amount the customer owes you that's over 91 days past due.
Total	The total amount that the customer owes. (You can select this number to see detailed information about the invoice sent to the customer.)

You can select any link to drill down to the details.

When do transactions drop off of an aging report?

There are several reasons that a transaction no longer appears on an aging report. When you run the report, you’ll no longer see transaction if:

• the aging due date is reached for the transaction (for example, dropping off a 0-30 day report on day 31)
• the invoice is paid
• a credit or advance is applied to the invoice
• the invoice is deleted or reversed