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.
Current: Open balance that is not yet due.
1-14: Days past due.
15-29: Days past due.
30-59: Days past due.
60-89: Days past due.
90-119: Days past due.
120-149: Days past due.
150-179: Days past due.
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.
Before Start of Servicing: Open balance that is due before the start of servicing.
During Servicing: Open balance that is within the time of servicing.
1-14 After Servicing: Open balance that is 1-14 days after the end of sevicing.
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.
Bad Debt Warning: 120+ days past due and less than 15 days to program end. Open balance is within 30 days of being written off as bad debt.
120+/15+ Bad Debt: 120+ past due and 15+ past program end date. Open balance is pending being written off as bad debt.
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-119: Days past due.
120-149: Days past due.
150-179: Days past due.
180+: Days past due. Open balance is pending being written off as bad debt.
Current: Open balance that is not yet due.
Total Past Due: Open balance that is past due. Excludes any future scheduled payments.
Before Start of Servicing: Open balance that is due before the start of servicing.
1-14 After Servicing: Open balance that is 1-14 days after the end of servicing.
15+ After Servicing: Open balance that is 15+ days after the end of servicing.
In Collections: Open balance that started servicing and 90+ days past due/15+ days after the end of servicing.
Bad Debt Warning: 120+ days past due and less than 15 days to program end. Open balance is within 30 days of being written off as bad debt.
120+/15+ Bad Debt: 120+ past due and 15+ past program end date. Open balance is pending being written off as bad debt.
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.
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.
Bad Debt: Will indicate if the customer has had bad debt recorded in the past 2 years.
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-119: Days past due.
120-149: Days past due.
150-179: Days past due.
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.
1-14 After Servicing: Open balance that is 1-14 days after the end of servicing.
15+ After Servicing: Open balance that is 15+ days after the end of servicing.
Before Start of Servicing: Open balance that is due before the start of servicing.
Bad Debt Warning: 120+ days past due and less than 15 days to program end. Open balance is within 30 days of being written off as bad debt.
120+/15+ Bad Debt: 120+ past due and 15+ past program end date. Open balance is pending being written off as bad debt.