Client Invoice Aging report

Use this report to monitor cash flow and identify past-due accounts for collection calls. View a summary of outstanding balances, and drill into full detail of invoices and receipts. An aging of outstanding items is available at every level.

This report ages outstanding client invoices based on the invoice date or accounting date.

To reconcile to the Accounts Receivable account on your Trial Balance report, click (Customize), and select the Accounting Date option in the Basis field.

Note:

Billed amounts include invoice adjustments unless you select the > Manage > Project Command Center > Project Info tab > Billing subtab > Exclude from billed for reporting check box for an adjustment.
When you change the status of a client invoice from Final back to Draft, the invoice is voided. The voided invoice number appears on the Client Invoice Aging report with no amount. If you select the Unpaid invoices only check box in the Customize options, voided invoices and paid invoices do not appear.

Audience

Principal

Project manager

Accounting

CPA

Producing the report

From the > Reports menu, click Client > Client 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.
Client	The report contains information for all clients unless you select a specific client in this field.
Project	The report contains information for all projects unless you select a specific project in this field.
Billing Manager	The report contains information for all billing managers unless you select a specific billing manager in this field.
Project Manager	The report contains information for all project managers unless you select a specific project manager in this field.
Principal in Charge	The report contains information for all principals in charge unless you select a specific principal in charge in this field.
Billing contact	The report contains information for all billing contacts unless you select a specific billing contact in this field.
As of date	The report contains information 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

If sorted by	The report prints in this order
Client	Client, project, and invoice
Project	Project, client, and invoice
Billing manager	Billing manager, client, and project
Project manager	Project manager, client, and project
Principal in charge	Principal in charge, client, and project
Project type	Project type, client, and project
Client type	Client type, client, and project
Department	Department, client, and project
Company	Multi-company only. Company, client, and project
Invoice date	Invoice date, client, and project
Accounting date	Accounting date and project

Date Basis

Uses either invoice or accounting date.

Limit by

Only prints projects associated with either the department, billing manager, project manager, or principal in charge who is producing the report. You can print all projects by selecting the No Limit option. If you use multi-company, you can also limit by company.

Aging interval

The time span (by number of days)of the time period columns that shows the amount of unpaid invoices by age

Unpaid invoices only

If selected, it prints only unpaid invoices. Otherwise, it prints all invoices only showing aging for outstanding invoices.

Include labor

If selected, it includes labor in the invoice amounts.

Include expense

If selected, it includes expenses in the invoice amounts.

Include consultant

If selected, it includes consultants in the invoice amounts.

Include finance charge

If selected, it includes finance charges in the amounts on this report.

Print contact information

If selected, it prints the billing contact's phone number and email address from the invoice group and client.

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 report

If selected, it prints a list of the options that you select.

Report contents

Column

Description

Invoice Number

The number of the invoice

Accounting/Invoice Date

The accounting date (invoice date) associated with the invoice after it is Final. The accounting date determines when the information appears on financial statements.

Receipt Method

The way you received the payment, such as check or electronic funds transfer (EFT)

Receipt ID

Any identification number entered for the receipt

Receipt Date

The date when you received the payment

Item Type

The type of item, such as an invoice, cash receipt, or prepayment

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 the each column. You can define the time span (number of days) of the time periods by clicking the (Customize) and selecting the number of days in the Aging Interval field.

Prepayment Amount

The amount of any client and/or project prepayments

Note:

To view all prepayments, sort the report by client.