Aging runs from the due date, not the invoice date, and the aging total ties to its control account. Unapplied cash never becomes revenue, and a customer left with a net credit balance is a liability, not negative AR.
InvoiceForm
Each line declares whether it credits revenue now or deferred revenue on a schedule, and the recognition preview is shown per line before the invoice is issued. The invoice number is system-assigned and gapless — the user cannot pick it.
Invoice numberINV-2044System-assigned and gapless — many VAT regimes require a sequence.
Invoice lines
Description
Account
Recognition
Amount
Remove
Credits deferred revenue, recognized over 12 months from 30 Sep 2026.
Credits revenue on issue.
Terms
2% discount if paid within 10 days, otherwise due in 30 days.
Pay by 10 Oct 2026
($16,500.14)16,500 US Dollar and 14 cents
Pay by 30 Oct 2026
($16,836.88)16,836 US Dollar and 88 cents
Totals
Subtotal
($15,500.00)15,500 US Dollar
California state @ 6%
($930.00)930 US Dollar
San Francisco district @ 2.625%
($406.88)406 US Dollar and 88 cents
Total
($16,836.88)16,836 US Dollar and 88 cents
InvoiceDetail · InvoiceRegister · CreditNoteForm
A credit note is not a refund and not a write-off — three different actions with three different GL and tax treatments, so the form says so before you use the wrong one. Void is offered only while the invoice is unpaid and its period is open.
Void is unavailable once a payment has been applied — issue a credit note instead.
Audit trail
Issued INV-2041
Billing (System) · 12 Jul 2026, 10:00 UTC
Applied $600.00 ACH receipt
A. Rivera (Staff accountant) · 4 Aug 2026, 14:20 UTC
Credit note
A credit note reduces what the customer owes. It is not a refund (which returns cash) and not a write-off (which recognizes a loss). Those are separate actions with different GL and tax treatment.
Against invoice INV-2041, balance ($1,000.00)1,000 US Dollar
Invoice numbering has 1 gap (INV-2039). Most tax regimes require an unbroken sequence, and a gap is an audit finding.
Invoice register
Invoice
Customer
Issued
Due
Age
Total
Balance
INV-2041
Northwind Traders
12 Jul 2026
12 Aug 2026
49d overdue
($1,840.00)1,840 US Dollar
($1,000.00)1,000 US Dollar
INV-2042
Contoso Ltd
28 Aug 2026
27 Sep 2026
3d overdue
($425.00)425 US Dollar
($425.00)425 US Dollar
INV-2043
Fabrikam GmbH
1 Sep 2026
1 Oct 2026
PendingInvoice pending
($3,109.00)3,109 US Dollar
($3,109.00)3,109 US Dollar
INV-2040
Tailspin Toys
15 Sep 2026
15 Oct 2026
SettledInvoice settled
($1,160.00)1,160 US Dollar
($0.00)0 US Dollar
AgingTable
Buckets run from the due date, not the invoice date — a 60-day-old invoice on net-90 terms is current, and aging it by invoice date would show a problem that does not exist. The column totals and the grand total tie to the AR control account.
Row totals and column totals agree with the grand total.
CashApplication · PaymentSuggestion
Every case, not the happy path: exact application, partial payment, short pay, lump sum across many invoices, and overpayment. Every difference gets an explicit disposition, and a write-off above the threshold needs approval before it can be taken.
Unapplied cash is never revenue, and a customer sitting in a net credit position is flagged for reclassification to a liability at period end. Collections is ranked by amount × age × risk, not by age alone. Dunning pauses when a dispute is open — chasing a disputed invoice is how you lose the customer and the money.
1 customer have a net credit balance in AR (Tailspin Toys). Consider reclassifying to a liability at period end.
Unapplied cash
Contoso LtdReceived 12 Sep 2026 · aged 18 days($421.00)421 US Dollar
Tailspin ToysReceived 30 Aug 2026 · aged 31 days($1,840.00)1,840 US Dollar
Collections worklistranked by amount × age × risk
Fabrikam GmbHOldest 118 days · high riskBroken promise: ($1,149.00)1,149 US Dollar by 15 Sep 2026OverduePromise overdue($3,109.00)3,109 US Dollar
Contoso LtdOldest 62 days · low riskDisputed — excluded from dunning · Implementation milestone 2 contested — customer says it was not delivered.($3,480.00)3,480 US Dollar
Northwind TradersOldest 49 days · medium riskPromised: ($1,000.00)1,000 US Dollar by 10 Oct 2026($1,000.00)1,000 US Dollar
Fabrikam GmbH — dunning history
Reminder, 7 days past dueemail · opened20 Aug 2026, 09:00 UTC
Second notice, 21 days past dueemail · sent3 Sep 2026, 09:00 UTC
Collections call — promise to pay loggedcall · responded14 Sep 2026, 15:30 UTC
Formal demand, promise brokenletter · sent24 Sep 2026, 09:00 UTC
Next: Final notice before referral on 8 Oct 2026
Pauses if: An open dispute on any invoice in the balance, A promise to pay logged and not yet past its date, An active payment plan.
Fabrikam Group — credit
Limit ($5,000.00)5,000 US DollarExposure ($5,624.00)5,624 US Dollar112.5%112.5 percent
Open-item and full-activity are different statements and the mode is stated. A sales order has no general ledger impact at all — so it renders on a dashed, sunken surface that says so, and never on a statement.
Lopifi is building AI bookkeeping that keeps your books closed on US GAAP as transactions happen, with a CPA review every quarter, for $200 a month. We’re not open yet.