Accounts receivable detail on statements and invoices

When editing your statement's custom format with the Format Wizard, you can pick what level of A/R detail you want to appear on your statement or invoice.
Use the following guidelines to determine how the various options for the A/R Ledger section of Statement formats work in Practice CS.
  1. Select
    Setup
    then
    Custom Formats
    .
  2. Open your statement format.
  3. Select
    Format Wizard
    on the toolbar.
  4. Go to the
    A/R Information
    tab.
  5. The A/R Detail section is designed to give you a breakdown of the A/R balance and activity for the current period.
Specifics about how the various options work are detailed in the following sections. In the examples given, the current period is May and there are 2 outstanding prior invoices:
  • 1/31 for $400.00
  • 2/28 for $700.00
There is also 1 current period receipt, applied to those 2 prior invoices:
  • 5/31 for $600.00 (with $400 applied to the 1/31 invoice, and $200 applied to the 2/28 invoice)

A/R Ledger option

The
A/R Ledger
option shows a summarized beginning (of period) AR balance, plus current activity.
AR ledger

A/R Open Items with Current Activity option

The
A/R Open Items with Current Activity
option shows a detailed list of all prior open A/R items (i.e., dated prior to beginning date in the Statement Activity Date Range in Print Statements), plus current activity. Notice that the original invoice amount is shown, and then the credit is applied on a separate row (with a running balance in the total column). It does NOT show the receipt amount that is applied to each of the outstanding invoices on the above rows.
AR open items with current activity

A/R Open Items option

The
A/R Open Items
option shows any open A/R items, and shows the open/ending balance only. Notice that the current period receipt of $600 is not shown at all. Only the one open invoice, and its remaining balance is shown (with its original amount reduced by the amount of the current receipt). The 1/31 invoice is not shown at all because it was completely relieved by the current period payment.
AR open items