Previous  Next          Contents  Index  Navigation  Glossary  Library

Collection Effectiveness Indicators

Use this report to monitor your customers' overall payment patterns and see debit item information by the split amount you defined in the System Options window. Receivables automatically runs this report when you close an accounting period.

If you calculate collections effectiveness for a closed period, and the value you specify for the Report Date option for this report is either on or after the end date of this period, Receivables stores the results. You can display these results the next time you run the report.

Receivables converts all foreign currency receipt and debit items into your functional currency for this report.

Receivables stores the information it generates for this report, and then displays it in the subsequent period's report as prior period information.

Report Parameters

Periods to Recalculate: Receivables calculates your collections effectiveness indicators for the number of accounting periods that you specify. You can recalculate a maximum of ten periods. If you enter 0, Receivables does not calculate any new values, but reports on stored values from previous runs.

Report Headings

Report Date: Your report date.

Rolling Ten Periods: The Collection Effectiveness Indicators report prints ten periods of activity so you can monitor payment patterns and review your collections effectiveness over time.

Row Headings

Adjustments Created: The total amount of adjustments created during each period.

Average Invoice Over Split Amount: The average amount for invoices, debit memos, and chargebacks greater than the split amount you specify in the QuickCash window for this report. The Average Invoice Over Split Amount only includes debit items for the period you are reviewing.

Average Invoice Under Split Amount: The average amount for invoices, debit memos, and chargebacks less than the split amount you specify in the Transactions window for this report. The Average Invoice Under Split Amount only includes debit items for the period you are reviewing.

Amount Collected: The total amount of the cash receipts collected in each period.

Conventional DSO: The following equation shows how Receivables calculates your Conventional Day Sales Outstanding:

Conventional DSO = (total outstanding receivables / total sales for prior DSO days) * (DSO days)

DSO Calculation Days: The number of days to use in calculating your Conventional Day Sales Outstanding. You specify the number of days in the DSO Calculation Days field in the System Options window.

Gross Receivables: The total amount of open invoices, debit memos, and chargebacks as of the date you run the report, regardless of the period in which they were created.

Inv. Split Amount: The split amount to determine the number of invoices, debit items, and chargebacks over and under this amount and the total amounts remaining. You specify your split amount in the Split Amount field in the System Options window.

Invoice Amount Over Split Amount: The total invoice amount for invoices, debit memos, and chargebacks greater than the split amount. The Invoice Amount Over Split Amount only includes debit items for the period you are reviewing.

Invoice Amount Under Split Amount: The Invoice Amount Under Split Amount only includes debit items for the period you are reviewing.

Net Receivables: The total amount collectable in each period. Receivables calculates this field by subtracting your Open Receipts and Open Credit Memos from your Gross Receivables.

Number of Invoices Over Split Amount: The number of open invoices, debit memos, and chargebacks created for each period that are over the split amount.

Number of Invoices Under Split Amount: The number of open invoices, debit memos, and chargebacks created for each period that are under the split amount.

Open Credit Memos: The total amount of open credit memos as of the Report Date or the end of the period, whichever is earlier.

Open Receipts: The total amount of open receipts as of the Report Date or the end of the period which ever is earlier.

Payment Pattern (% Collected): The cumulative percentage of debit item amounts you collect per period sales for each of the 9 periods before your current period. You can use this section to see how much of the prior periods sales are collected. Receivables prints cumulative amounts so you can review the payment patterns over time to further assess the effectiveness of your collectors. For example, when you review the 2 Periods Prior row, this is the amount of the sales from 2 periods prior that have been collected as of the time you run this report.

(#) Period Prior: The cumulative percent collected for each period's sales as of x periods before your current period.

Total: The total number of invoices, debit memos, and chargebacks.

See Also

Running Standard Reports and Listings

Common Report Parameters

Receivables Standard Reports


         Previous  Next          Contents  Index  Navigation  Glossary  Library