These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Accounts Receivable System
- Features
- Receivables reporting
Receivables reporting
Receivables reporting gives finance a view of what customers owe and how the team is working those balances. AR aging, DSO, dunning results, cash application and collections reports answer different operating questions. AR aging snapshots preserve a customer-level balance at a stated cutoff. Keep current queues and historical snapshots distinct so a later receipt does not silently rewrite the evidence used for an earlier reconciliation.
OverviewLatest AR Aging Snapshot×
Accounts Receivable System · Receivables reporting
New
Latest AR Aging Snapshot
AR aging snapshots
| Customer | As of date | Current amount | Bucket 1to 30 | Bucket 31to 60 | Bucket 61to 90 | |
|---|---|---|---|---|---|---|
| Juniper Crest Foods | 22 Oct | 3,234.85 | 9,593.38 | 28,872.62 | 7,480.91 | |
| Harborwick Marine Supply | 28 Oct | 17,158.90 | 18,561.96 | 9,622.13 | 10,861.91 | |
| Ternfield Energy Services | 20 Oct | 14,719.66 | 12,021.88 | 13,850.40 | 13,374.16 | |
| North Alder Clinics | 04 Nov | 16,852.12 | 45,628.87 | 44,035.93 | 15,494.87 | |
| Blue Vale Equipment Co. | 19 Oct | 8,733.94 | 11,264.12 | 1,223.42 | 27,971.65 |
6 of 6 records
Juniper Crest FoodsAR aging snapshots · AS-38282
As of date22 Oct
Current amount3,234.85
Bucket 1to 309,593.38
Bucket 31to 6028,872.62
Bucket 61to 907,480.91
What you can do
Reconcile the aging population
The aging summary groups open balances by customer and due-date band. A snapshot retains its as of date and bucket values, including the current amount and overdue bands. The Controller compares the stated population with the connected ledger and explains timing differences, pending journals and external billing references. Producing a snapshot does not close the accounting period. Reconcile local invoices and externally owned collection references without counting the same customer obligation or payment twice.
Use reports to guide the next action
Dunning Effectiveness shows communication activity and subsequent responses; Cash Application Rate shows the incoming transaction and review route. Collections Case Funnel shows work across case stages. These measures help managers decide where to investigate rather than guarantee a result. Open the related operational records to see the reason behind a total. A queued proposal is not accepted cash, a sent reminder is not a recovered balance, and an approved write-off remains separate from the posted adjustment register.
Keep access and interpretation consistent
Sales Rep sees assigned-customer aging, while Viewer receives the intended aggregate read-only reporting scope. Detailed bank references, individual decisions and unrestricted customer records require their own permissions. Record the report period, customer filters and calculation basis when exporting or sharing a result. Recurring Revenue Run-Rate describes annualized billing schedules; it is not a revenue-recognition conclusion. Before rollout, compare the dashboards with known invoices, credits, partial payments, unapplied cash and reversals, then verify that each role sees only its permitted portion of those examples.
What your team sees
- Latest AR Aging Snapshot. Open the related records within your assigned scope.
- My Customers’ Aging (Sales). Open the related records within your assigned scope.
What it keeps track of
Data model- AR aging snapshots
- Period-frozen aging buckets per Customer. Written by the ar-aging-snapshot scheduled workflow on the last day of each period.
- Invoices
- The customer invoice — the AR atom. Header carries totals; detail lives in invoice lines.
- Payments received
- An incoming payment from a Customer. May be auto-created by the auto-match workflow from a bank feed transaction or manually keyed by an AR Clerk.
- Payment applications
- Distributes a payment received across one or more Invoices (or leaves the remainder unapplied on the customer’s account).
- Collections cases
- Escalated collections workflow. Opened when an Invoice crosses dunning policy band4 days or by AR Manager intervention.
- Dunning events
- The audit trail of every dunning communication sent. One row per Invoice per band per send.
- Write-offs
- Uncollectible AR written off the books. Requires Controller approval; posts a JE in fin-accounting that contras the AR balance and hits Bad Debt Expense.
- Customers
- The AR-grain customer record. May shadow a CRM Account; this row carries the credit, billing, and dunning fields finance owns.
Who uses it
Permissions- Controller / CFO
- Reviews reconciliation and historical snapshots.
- AR Manager
- Tracks collection performance.
- AR Clerk
- Works the related queues.
- Sales Rep
- And Viewer receive only the reporting scope assigned to their roles.
Set up Accounts Receivable System your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.