You are here: Ajera Help (A-Z) > Reports > Report descriptions > Vendor Invoice Aging report

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.

See also

Producing reports

Using the reports toolbar

 

 

© 2015 Deltek Inc. All rights reserved.