A/R Report Page Glossary

Filters

Region: Filter by a specific 3STEP region.
Sport: Filter by a specific sport vertical.
Brand(s): Filter by specific brands, or enable the Select All checkbox.
Aging Minimum/Aging Maximum: Only display customers with aging in the range, they may have additional agings outside this range.
Negative A/Rs: Enable to include overpaid invoices, these are excluded from aging brackets but contribute towards Net Due

Brand Summary Table

This table will break down A/R by brand.

Invoiced: Total invoiced of all invoices within the min to max aging range. For a Min Aging of zero or less, this includes invoices not due yet.
Payments/Concessions: Payment and Concessions applied across all included invoices.
Net Due: (Total invoiced of all invoices not paid yet) minus (payments and concessions applied across all included invoices). This total includes any future schedule payments.
Customer Count: Total number of customers for all included invoices.
1-14: Days past due.
15-29: Days past due.
30-59: Days past due.
60-89: Days past due.
90-179: Days past due. Open balance is in collections.
180+: Days past due. Open balance is pending being written off as bad debt.
Total Past Due: Open balance that is past due. Excludes any future scheduled payments.
15+ Program End: Open balance that is 15+ days after the end of servicing.
Before Program Start: Open balance that is due before the start of servicing.
In Collections: Open balance that started servicing and 90+ days past due/15+ days after the end of servicing.
Current: Open balance that is not yet due.

Program Summary Table

This table will break down A/R by Programs within the Regions/Sports/Brands selected.

Invoiced: Total invoiced of all invoices within the min to max aging range. For a Min Aging of zero or less, this includes invoices not due yet.
Payments/Concessions: Payment and Concessions applied across all included invoices.
Net Due: (Total invoiced of all invoices) minus (payments and concessions applied across all included invoices). This total includes any future schedule payments.
Customer Count: Total number of customers for all included invoices.
1-14: Days past due.
15-29: Days past due.
30-59: Days past due.
60-89: Days past due.
90-179: Days past due. Open balance is in collections.
180+: Days past due. Open balance is pending being written off as bad debt.
Total Past Due: Open balance that is past due. Excludes any future scheduled payments.
15+ Program End: Open balance that is 15+ days after the end of servicing.
Before Program Start: Open balance that is due before the start of servicing.
In Collections: Open balance that started servicing and 90+ days past due/15+ days after the end of servicing.
Current: Open balance that is not yet due.

Customer Summary Table

This table will show A/R and notes for customer within the Regions/Sports/Brands selected.
NOTE: On the far right of the table, click the > icon to see each invoice for the customer on its own line.

Actions: Can be used to add an A/R Note or to check the Note History for the customer.

• How to Add Customer Notes on the A/R Report Page

Last A/R Note: The most recent A/R Note for the customer will populate here.
Last A/R Note Age: Will show how long ago the most recent A/R Note was sent.
Payment Plan: Will show a green checkmark if all items have a payment plan assigned.
Payment Method: Will show a green checkmark if a Credit Card or ACH is set to charge.
Max Aging: The longest amount of aging for that account.
Invoiced: Total invoiced of all invoices within the min to max aging range. For a Min Aging of zero or less, this includes invoices not due yet.
Payments/Concessions: Payment and Concessions applied across all included invoices.
Net Due: (Total invoiced of all invoices) minus (payments and concessions applied across all included invoices). This total includes any future schedule payments.
Customer Count: Total number of customers for all included invoices.
1-14: Days past due.
15-29: Days past due.
30-59: Days past due.
60-89: Days past due.
90-179: Days past due. Open balance is in collections.
180+: Days past due. Open balance is pending being written off as bad debt.
Total Past Due: Open balance that is past due. Excludes any future scheduled payments.
15+ Program End: Open balance that is 15+ days after the end of servicing.
Before Program Start: Open balance that is due before the start of servicing.
In Collections: Open balance that started servicing and 90+ days past due/15+ days after the end of servicing.
Current: Open balance that is not yet due.