Accounts Receivable Summary by Invoice Type Report GuideLast updated on 03/22/2022

Purpose of the Accounts Receivable Summary by Invoice Type Report:

This report displays a summary of invoices with an outstanding balance. The report displays data by invoice type. Data is based on invoice dates. This report includes all invoices with an outstanding balance (completed jobs only).

Common uses for this report:

Use this report to view the total number of outstanding invoices, total balance of all outstanding invoices, average balance, total invoice amount, average invoice amount, and balance ratio.

How to find this report:

Click Reports > Search Accounts Receivable Summary by Invoice Type > Click the report name. Then you will be able to set filters and run the report.

Report filters

Business Unit

Filter by business unit. This report can be run by a single business unit or all business units.

Status

Filter by status. This report can be run by posted, exported, or all invoices.

View or download the report

Click Update to view the report.

The report can be downloaded in three different formats:

Download PDF
Export to Excel (*.xlsx) (click the dropdown arrow next to Download PDF)
Export to Comma separated (*.csv) (click the dropdown arrow next to Download PDF)

Explanation of report columns

Data in this report is broken down by Invoice Type. Totals for all outstanding invoices appear at the bottom of the report.

The first row of the report (where Invoice Type is blank) includes all invoices with no Invoice Type.

The report includes the following columns:

(Report columns)

Invoice Type	Invoice type. How to configure - Create invoice type: To create or edit an invoice type, navigate to Settings > Payment and Invoice Types. How to configure - Set the invoice type on an invoice: Click Update invoice details from the left menu on the invoice page. Set Invoice Type, then click Save.
Total Balance	Total balance of outstanding invoices, including tax. Calculation - Total Balance: [Sum of invoice totals for invoices with an outstanding balance, completed jobs only]. Note: Customer credits are accounted for. Customer deposits are not included. If the total balance is a positive amount:The total balance is an unpaid amount. If the total balance is a negative amount:The total balance is a customer credit, even though individual customers may have unpaid balances.
Avg. Balance	Average balance of outstanding invoice Calculation - Avg. balance: [Total Balance] / [Num. Invoices]. This figure is rounded to the nearest hundredth. If the average balance is a positive amount:The average balance is an unpaid amount. If the average balance is a negative amount:The average balance is a customer credit, even though individual customers may have unpaid balances.
Num. Invoices	Total number of outstanding invoices.

(Report columns continued)

Total Invoice	Invoice total for all outstanding invoices, including tax.
Avg. Invoice	Average invoice total of outstanding invoices. Calculation - Avg. invoice: [Total Invoice] / [Num. Invoices]. This figure is rounded to the nearest hundredth.
Balance Ratio	Balance-invoice ratio. This is the percentage of your invoice total that remains outstanding. Calculation - Balance Ratio: [Total Balance] / [Total Invoice] * 100%. If the Balance Ratio is a positive amount:A positive Balance Ratio gives you the total percentage of invoice amounts that remain unpaid. If the Balance Ratio exceeds 100%:A Balance Ratio over 100% means there are unpaid balances in excess of original invoice amounts. This likely means that adjustment invoices have been created. If the Balance Ratio is a negative amount:A negative Balance Ratio gives you the total percentage of customer credits that exceed invoice amounts, even though individual customers may have unpaid balances.

Explanation of report totals

Total Balance Ratio

Total Balance-invoice ratio. This is the percentage of all invoice totals that remains outstanding.

Calculation - Total Balance Ration: [Sum of Total Balance] / [Sum of Total Invoice] * 100%.

If the Balance Ratio is a positive amount:A positive Balance Ratio gives you the total percentage of invoice amounts that remain unpaid.

If the Balance Ratio exceeds 100%:A Balance Ratio over 100% means there are unpaid balances in excess of original invoice amounts. This likely means that adjustment invoices have been created.

If the Balance Ratio is a negative amount:A negative Balance Ratio gives you the total percentage of customer credits that exceed invoice amounts, even though individual customers may have unpaid balances.

All Other Total Amounts

All other total amounts are calculated by taking the sum of the entire column.

Important note: Some features may not be currently included in your account and additional configuration may be required. Please contact technical support for details.