Skip to content
Specimen controls
Theme
Value colours
Row density
Family 10 · 3 of 13 components built

Receivables from invoice to cash.

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
DescriptionAccountRecognitionAmountRemove

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 US Dollar and 14 cents
Pay by 30 Oct 2026
16,836 US Dollar and 88 cents

Totals

Subtotal15,500 US Dollar
California state @ 6%930 US Dollar
San Francisco district @ 2.625%406 US Dollar and 88 cents
Total16,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.

Balance due

1,000 US Dollar

of 1,840 US Dollar invoiced

INV-2041

Northwind Traders

Issued 12 Jul 2026 · due 12 Aug 2026

Payment history

4 Aug 2026ACH600 US Dollar
Applied credits240 US Dollar
Balance due1,000 US Dollar

Void is unavailable once a payment has been applied — issue a credit note instead.

Audit trail

  1. Issued INV-2041

    Billing (System) · 12 Jul 2026, 10:00 UTC

  2. 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 US Dollar

Invoice register
InvoiceCustomerIssuedDueAgeTotalBalance
INV-2041Northwind Traders12 Jul 202612 Aug 202649d overdue1,840 US Dollar1,000 US Dollar
INV-2042Contoso Ltd28 Aug 202627 Sep 20263d overdue425 US Dollar425 US Dollar
INV-2043Fabrikam GmbH1 Sep 20261 Oct 2026Invoice pending3,109 US Dollar3,109 US Dollar
INV-2040Tailspin Toys15 Sep 202615 Oct 2026Invoice settled1,160 US Dollar0 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.

Accounts receivable aging

Accounts receivable aging
CustomerCurrent1–30 days31–60 days61–90 days90+ daysTotal
Northwind Traders4,200 US Dollar1,840 US Dollarzerozerozero6,040 US Dollar
Contoso Ltd2,100 US Dollar420 US Dollar960 US Dollarzerozero3,480 US Dollar
Fabrikam GmbH960 US Dollar580 US Dollarzero420 US Dollar1,149 US Dollar3,109 US Dollar
Tailspin Toys1,160 US Dollarzerozerozerozero1,160 US Dollar
Total8,420 US Dollar2,840 US Dollar960 US Dollar420 US Dollar1,149 US Dollar13,789 US Dollar

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.

Payment 4,865 US DollarApplied 0 US DollarRemaining4,865 US Dollar

No invoices selected

Unapplied payment

Northwind Traders

Received 29 Sep 2026 · ref ACH 20260929-4417

4,865 US Dollar

Held as a liability until applied. It does not reduce accounts receivable.

Open invoices — Northwind Traders

  • INV-2041Due 12 Aug 20261,000 US Dollar
  • INV-2042Due 27 Sep 2026425 US Dollar
  • INV-2043Due 1 Oct 20263,109 US Dollar
  • INV-2045Due 8 Oct 2026360 US Dollar

Applying is reversible and audited.

No combination of open invoices sums to 4,865 US Dollar exactly.

UnappliedCashPanel · CollectionsWorklist · DunningTimeline · CustomerCreditPanel

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 days421 US Dollar
  • Tailspin ToysReceived 30 Aug 2026 · aged 31 days1,840 US Dollar

Collections worklistranked by amount × age × risk

  • Fabrikam GmbHOldest 118 days · high riskBroken promise: 1,149 US Dollar by 15 Sep 2026Promise overdue3,109 US Dollar
  • Contoso LtdOldest 62 days · low riskDisputed — excluded from dunning · Implementation milestone 2 contested — customer says it was not delivered.3,480 US Dollar
  • Northwind TradersOldest 49 days · medium riskPromised: 1,000 US Dollar by 10 Oct 20261,000 US Dollar

Fabrikam GmbH — dunning history

  1. Reminder, 7 days past dueemail · opened20 Aug 2026, 09:00 UTC
  2. Second notice, 21 days past dueemail · sent3 Sep 2026, 09:00 UTC
  3. Collections call — promise to pay loggedcall · responded14 Sep 2026, 15:30 UTC
  4. 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 US DollarExposure 5,624 US Dollar112.5 percent
Exposure by group entity
EntityInvoicedUnbilled ordersExposure
Fabrikam GmbH3,109 US Dollar840 US Dollar3,949 US Dollar
Fabrikam Austria GmbH1,275 US Dollar400 US Dollar1,675 US Dollar
Group exposure5,624 US Dollar

Tax-exemption certificate expired 30 Jun 2026.

CustomerStatement · SalesOrderTable · ArMetricsPanel

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.

Acme Holdings, Inc.

Customer statement

Northwind Traders

1 – 30 September 2026 · Open items only

Statement of account for Northwind Traders, 1 – 30 September 2026
DateReferenceDescriptionChargesCreditsBalance
Opening balance1,840 US Dollar
4 Sep 2026PMT-4417ACH receipt600 US Dollar1,240 US Dollar
18 Sep 2026CN-0031Credit note — service credit, SLA breach240 US Dollar1,000 US Dollar
Balance due1,000 US Dollar

Sales order backlog

Orders have no general ledger impact. These figures are not revenue and do not appear on any statement.

Sales orders
OrderCustomerExpected shipOrder valueInvoiced
SO-1180Northwind Traders15 Oct 202612,400 US Dollar0 US Dollar
SO-1181Contoso Ltd1 Nov 202616,000 US Dollar4,000 US Dollar
Backlog28,400 US Dollar

Days sales outstanding

48.2 days

(Accounts receivable ÷ Credit sales) × Days in period

( 1,284,000 ÷ 2,398,000 ) × 90

Cohort
All customers with credit terms
Period
Quarter ended 30 September 2026
Source
AR subledger · countback method not used

Best possible DSO

31.0 days

(Current receivables ÷ Credit sales) × Days in period

( 826,000 ÷ 2,398,000 ) × 90

Cohort
Receivables not yet past due
Period
Quarter ended 30 September 2026
Source
AR subledger

Collection effectiveness index

87.4%

(Opening AR + Credit sales − Closing total AR) ÷ (Opening AR + Credit sales − Closing current AR)

( 1,140,000 + 2,398,000 − 1,284,000 ) ÷ ( 1,140,000 + 2,398,000 − 826,000 )

Cohort
All customers
Period
Quarter ended 30 September 2026
Source
AR subledger

Bad debt rate

0.42%

Write-offs ÷ Credit sales

( 10,072 ÷ 2,398,000 )

Cohort
All customers
Period
Quarter ended 30 September 2026
Source
GL account 6900 · Bad debt expense

The 3 components on this page

Each has a page with its four-layer spec, its dependencies, the whole source file and the one-line install. The family spec they were all built against is Receivables (AR).

10 more in this family are specified but not yet built, so they are not on this page: InvoiceDetail, InvoiceRegister, UnappliedCashPanel, CreditNoteForm, CollectionsWorklist, DunningTimeline, CustomerStatement, CustomerCreditPanel, SalesOrderTable, ArMetricsPanel.

Works in your QuickBooks Online or Xero file

Get your books closed every month

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.

$200/month when we open. No card now.