How to Generate a Vendor Aging Report

The Vendor Aging report displays the balances due to vendors. They are summarized by the following aging periods: Current, 30, 60, 90 and 120 days.

Use the following steps to generate a Vendor Aging Report:

1. Click on the Business tab, click Vendor, and select Vendor Reports.

2. Click on the Select a Report Option drop-down menu and select Aging Report.

3. If applicable, in the Search by section, select the Vendor Name (selected by default) or Vendor Number radio button.

4. If applicable, enter the vendor name or vendor number in the Starting At and/or Ending At, or click on the Search icon to search for a Vendor.

Note: Refer to How to use Vendor Search for more information on how to use this feature.

If the same vendor is used for the Starting At and Ending At fields, the Exact Match Only selection box will automatically be selected.

5. If applicable, click on the Type Code drop-down menu to select an option.

6. If applicable, enter or select the Aging Date.

This field indicates the date from which the aging will begin.

6. If applicable, click on the Include Deactivated Vendors selection box.

7. In the Aging Report Type section, select the Detail Aging Report (selected by default) or Summary Aging Report radio button.

The Detail Aging Report includes the Vendor Number, Vendor Name, Invoice Number, Invoice Due Date, Invoice Balance, Reference and Totals (by aging periods).

The Summary Aging report includes the Vendor Number, Vendor Name and Totals (by aging periods).

8. Click on the Generate Report button, or click on the Clear All button to remove all input information and reset the fields to their default values.

9. To download the report in an Excel, PDF or Word file format select the corresponding option and click the Export button.

Note: All exported file types have the Save (Download) or Print options.

10. Click on the Back button to return to the Vendor Reports screen.