Payment Tracking Skill

What problem does it solve?

This Skill provides a robust framework for managing Accounts Receivable (AR) aging, tracking payment statuses, and calculating Days Sales Outstanding (DSO). It streamlines payment reconciliation, identifies overdue invoices early, and helps optimize cash flow by providing clear visibility into outstanding payments.

Core Features & Use Cases

• AR Aging Framework: Classifies overdue invoices into buckets (0-30, 31-60, 61-90, 91-120, 120+ days) to prioritize collection efforts.
• DSO Calculation: Automatically calculates Days Sales Outstanding to measure collection efficiency and identify trends.
• Payment Status Lifecycle: Manages invoice statuses (Pending, Due, Paid, Overdue, Disputed, Partial) and guides reconciliation processes for overpayments and underpayments.
• Use Case: A business needs to monitor its outstanding invoices. This Skill automatically categorizes invoices by their aging bucket, calculates the current DSO, and flags invoices that are partially paid or disputed, allowing the AR team to focus on critical collections.

Quick Start

Example: Calculating Days Sales Outstanding (DSO)

AR = $50,000

Credit Sales (last 30 days) = $75,000

Days in Period = 30

DSO = (AR / Credit Sales) × Days in Period

DSO = ($50,000 / $75,000) × 30 = 20 days