Vendor Invoice Aging report

Use this report to help you decide which invoices to pay, and when to pay them. Track all your unpaid vendor invoices for timely payment.

This report displays aging for vendor invoices.

You can summarize the information by vendor and drill down to detail for a vendor invoice.

This report ages outstanding vendor invoices based on the accounting date or invoice date. Use this report, selecting the date basis of Accounting date, to reconcile to the Accounts Payable account on your Trial Balance report.

Note:

Expense report transactions are aged based on the transaction date, not the ending date of the expense report.

Audience

Principal

Accounting

CPA

Producing the report

From the > Reports menu, click Vendor > Vendor Invoice Aging.

Report options

Option	Description
Company	Multi-company only. The report contains information for all companies in your organization, unless you select a specific company in this field.
Project	The report contains information for all projects unless you select a specific project in this field.
Vendor	The report contains information for all vendors unless you select a specific vendor in this field.
As of date	The report contains information for unpaid vendor invoices as of today’s date unless you select a different date in this field.

After changing report options, click (Refresh).

Customize options

Option	Description
Report title	You can change the title of the report.
Sort order	Sorts the report by vendor, project, or vendor type. If you use multi-company, you can also sort by company.
Basis	Uses either invoice or accounting date.
Aging interval	The time period (by number of days) of the aging amount columns.
Unpaid invoices only	If selected, it prints only unpaid invoices.
Include expense	If selected, it includes expenses in invoice amounts.
Include consultant	If selected, it includes consultants in the invoice amounts.
Use drilldown	If selected, you can drill down to further detail on the report. If cleared, all information, including the lowest level of detail, prints on the report.
Print customize options on reports	If selected, it prints a list of the options that you select.

Report contents

Column	Description
Vendor	The name of the vendor.
Invoice Number	The number of the invoice.
Accounting/Invoice Date	The accounting date (invoice date) associated with the invoice. The accounting date determines when the information appears on financial statements.
Payment ID	The payment or check number of any payments made toward the invoice.
Payment Date	The date of the payment.
Payment Method	The method of the payment, such as check or electronic funds transfer (EFT).
Outstanding	The total amount of all unpaid invoices.
Time period columns that show aging amounts	The amount of unpaid invoices for the time period in each column. You can define the time span (number of days) of the time periods by clicking (Customize) and selecting the number of days in the Aging Interval field.