AR collections
Applies cash receipts to open invoices, recalculates aging, and prioritizes each collector’s worklist
How it works
-
Upload a completed worklist
The invoice-level worklist and summary for each collector
-
Add the source files
The open invoice aging, receipts applied in the period, the customer master with collector assignments, and the promise-to-pay log
-
Skipper learns the collection rules
How cash receipts are applied to calculate open balances, how aging buckets and days past due are calculated, and how each factor is weighted in the priority score
-
Upload the new aging each week
Skipper applies the latest cash receipts, reprioritizes the portfolio, and prepares each collector’s worklist in priority order
Input files
- open_invoice_aging_202X-07-31.xlsx Open invoices with invoice date, due date, terms, amount, and business unit
- cash_receipts_202X-07.xlsx Receipts applied against invoices during the period
- customer_master.xlsx Segment, credit limit, assigned collector, and risk rating
- payment_promises_202X-07.xlsx Payment promises, promised amounts, and fulfillment status
Output workbook
collections_worklist_202X-07-31.xlsx
- Summary Total outstanding balance, total past due, and balance by aging bucket
- Collections Worklist Open balance, days past due, aging bucket, risk rating, broken-payment-promise flag, and priority score by invoice
- Collector Summary Portfolio balance and the count of urgent invoices for each collector
- Checks Reconciliation of open balances to the aging and receipt files