<< Click to Display Table of Contents >> Navigation:  Report Dashboard > Aging Report - Report Writer > Description and Usage

The Aging Report provides a weekly and/or monthly aged analysis of the balance owed to each vendor based on the how the as of date is being run. This report may be printed by Transaction Date, Invoice Date or Due Date that was entered for each invoice. Vendors with or without balances may be printed. If the report is run by transaction for the last day of a month, it should have the same balance as the Accounts Payable Control account.

 

The Report Writer application allows the user to filter, sort and manipulate this report so that they may customize the data extracted out of the system. See the additional documentation on Report Writer for more information on these options.

 

 

Aging Report - Report Writer

 

 

 

Listed below is an explanation of each column.

 

•Vendor #: Pulls the Vendor Number from Page 1 of the Vendor Master.

 

•Vendor Name: Pulls the Vendor Name from Page 1 of the Vendor Master.

 

•Vendor Phone: Pulls the Vendor Phone from Page 1 of the Vendor Master.

 

•Class: Pulls the Vendor Class from Page 3 of the Vendor Master.

 

•Pay Code: Pulls the default Pay Code from Page 2 of the Vendor Master.

 

•Invoice #: Pulls all invoices that have not purged from Vendor Detail.

 

•Tran Dt: Pulls the Transaction Date of the invoice.

 

•Inv Dt: Pulls the date of the invoice.

 

•Due Dt: Pulls the Due Date of the invoice.

 

•Check Dt: If the invoice has been paid, will pull the date the check was printed.

 

•Pay: Pulls the Pay Code on the invoice.

 

•Invoice Amount: Pulls the total amount of the invoice.

 

 

Weekly Aging Totals

 

•Current: Pulls the total amount of unpaid invoices that are less than 7 days old.

 

•Over 7 Days: Pulls the total amount of unpaid invoices that are over 7 days old.

 

•Over 14 Days: Pulls the total amount of unpaid invoices that are over 14 days old.

 

•Over 21 Days: Pulls the total amount of unpaid invoices that are over 21 days old.

 

•Over 28 Days: Pulls the total amount of unpaid invoices that are over 28 days old.

 

•Balance: The total of all unpaid invoices for each vendor.

 

 

Monthly Aging Totals

 

•Current: Pulls the total amount of unpaid invoices that are less than 30 days old.

 

•Over 30 Days: Pulls the total amount of unpaid invoices that are over 30 days old.

 

•Over 60 Days: Pulls the total amount of unpaid invoices that are over 60 days old.

 

•Over 90 Days: Pulls the total amount of unpaid invoices that are over 90 days old.

 

•Over 120 Days: Pulls the total amount of unpaid invoices that are over 120 days old.

 

•Balance: The total of all unpaid invoices for each vendor.

 

 

Weekly Aging Totals

 

•Weekly Grand Totals: The combined weekly totals for all Vendors by aging category and balance.

 

 

Monthly Aging (Grand) Totals

 

•Monthly Grand Totals: The combined monthly totals for all Vendors by aging category and balance.