Initial Invoices Available to Collect by Payment Mode

Report Overview

This report provides a breakdown of the projected amounts available to collect, grouped by profit center and categorized by the invoice age. It separates the accounts into payment mode types (bank draft, statement/manual billing, credit card, problem). For each payment mode type, the report lists the number and dollar value of the invoices.

You can see the same information, but broken out by account type across the top columns in the Initial invoices by Account report.

Data is available beginning January 1, 2015.

Account Ages

Each profit center on the report categorizes members by account age. The account age categories (in order of most likely to least likely to connect) are:

  • Current, Next 30 Days - Members that are current but have an invoice coming due in the next 30 days.
  • Current w/ Past Due - Members who have an invoice coming due in the next 30 days but also have one or more past due invoices. (The invoice due in the next 30 days will appear under this category. Other past due invoices will appear in the appropriate past due category, which is determined by the length of time the invoice is past due.)
  • Past Due 31-60 Days - Invoices past due 31-60 days.
  • Past Due 61-90 Days - Invoices past due 61-90 days.
  • Past Due 91-Up Days - Invoices past due 91 or more days.

If a member is 90 days past due they will appear in every bucket up to their most recently past due payment or the payment for the following month, stopping at Current w/Past Due. (The member will not appear in the Current Next 30 Days bucket as it contains ONLY members in good standing.)

Sample Report

Here is a sample of the Initial Invoices by Payment Mode report.

Drill-Down Reports

The drill-down links in this report drill to a detail report showing the members included in each category, with the number of invoices and total amount.

Here is a sample of the Dues drill-down report: