Skip to main content

Review ledger aging and export records

The ledger surface answers the money questions the invoice list cannot: who owes us, how old is the debt, which balances are at risk, and how much we owe suppliers. Filtered exports turn that view into the books without re-keying.

Receivable aging buckets​

Every customer with an outstanding balance is summarised into aging buckets:

BucketMeaning
currentNot yet due under the customer's credit terms.
dueSoonDue within the near window defined by the credit terms.
d1_301–30 days overdue.
d31_6031–60 days overdue.
d61_9061–90 days overdue.
d90plusMore than 90 days overdue.
totalOutstandingThe full outstanding balance across open invoices.

The summary also carries the number of open unpaid invoices and the oldest due date, so a manager can see both the total and the shape of the risk.

At-risk exposure​

The aging view flags exposure by severity:

  • Overdue — any amount in d1_30 or d31_60.
  • Severe — any amount in d61_90 or d90plus.

"At risk" is configurable per workspace: set the threshold that defines what the team treats as exposure, and the aging view marks those parties accordingly. This is a working signal for follow-up, not a promise about collectability.

Supplier payables​

The ledger also tracks supplier payables: how much the business owes each supplier and the same aging context where resolvable. This gives the owner both sides of the ledger — receivables from customers and payables to suppliers — in one surface.

Filtered exports​

The ledger supports filtered exports to CSV and XLSX:

  1. Apply the filters you want (party type, aging bucket, balance range, search term).
  2. Choose CSV or XLSX export.
  3. The export contains exactly the filtered rows — no broader dump to re-filter in a spreadsheet.
  4. Exports are recorded so the audit trail shows who exported what and when.

Use exports for the monthly handoff to your accountant: the filtered ledger export becomes the source data for receivables and payables, and the aging buckets give context without a separate reconciliation.

Good habits​

  • Review aging weekly. Overdue debt grows faster than it is collected; a weekly glance at the d61_90 and d90plus buckets prevents surprises at month-end.
  • Drill to the invoices. The aging view links to the exact unpaid invoices behind a bucket, so a follow-up call has a concrete list.
  • Export with filters, not after. Filter first, export second — the file you hand over should match the view you reviewed.
  • Confirm exposure thresholds. Set the at-risk threshold to what your business actually treats as risky, and review it when terms change.