Accounts Receivable Summary by Invoice Type Legacy Report

Overview

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 in the main navigation menu.
On the Reports screen that opens, click Legacy Reports.
In the Search field, search for Accounts Receivable Summary by Invoice Type.
Click the report name. Then you will be able to set filters and run the report.

User interface displaying report search for Accounts Receivable Summary.

Report filters

Accounts receivable summary interface with options for business unit and invoice status.

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.

Button labeled 'Update' for submitting changes or refreshing content.

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.

Invoice summary showing total balances and average balances for Gold Member Invoices.

The report includes the following columns:

Columns	Description
Invoice Type	Invoice type. To create or edit an invoice type, navigate to Settings > Payment and Invoice Types. To 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. 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. 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.
Total Invoice	Invoice total for all outstanding invoices, including tax.
Avg. Invoice	Average invoice total of outstanding 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. 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	Description
Total Balance Ratio	Total Balance-invoice ratio. This is the percentage of all invoice totals that remains outstanding. 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.

Total

Description

Total Balance Ratio

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

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.