The accounts payable aging report categorizes payables to suppliers based on time buckets. The report is typically set up with 30-day time buckets, so that each successive column in the report lists supplier invoices that are:
Accounting Manager Resume Invoice Aging Report Excel Template Joe Sennate 17 West State St PA Responsible for monthly billing totaling $7M. Produced monthly aging, open invoices, sales and revenue recognition reports. Responsible for payroll processing for over 500 employees Budgets created in Excel can be imported into a Dynamics SL project for review and approval.
- 0 to 30 days old
- 31 to 60 days old
- 61 to 90 days old
- Older than 90 days
The intent of the report is to give the user a visual aid in determining which invoices are overdue for payment. However, a key flaw in this report is that it assumes all invoices are due for payment in 30 days. In reality, some invoices may be due on receipt, in 60 days, or almost anywhere in between. Consequently, an invoice listed on the aging report as current might actually be overdue for payment, while an invoice listed in the 31 to 60 days time bucket may not yet actually be payable.
For the report to be effective, it should be periodically cleaned up, so that stray debits and credits are removed from the report. Otherwise, it tends to become cluttered over time and therefore more difficult to read.
Given the issues noted here, a better solution is to use a report generated by the accounting system, which lists only those supplier invoices that are nearly due or overdue for payment, based on invoice dates and supplier payment terms.
The aging report is sometimes used by a company's outside auditors as a listing of payables due as of the audit date. However, this report is only useful to them if its total matches the ending accounts payable balance in the general ledger.
Related Courses
Optimal Accounting for Payables
Payables Management
Payables Management