Orders and settlements

Know exactly who owes you what.

Write down what a customer ordered. Record each payment as it lands. Folio works out the balance, decides whether the order is short or late, and keeps the arithmetic exact to the cent.

Open the demo

Loaded with real orders. Or start your own

Outstanding

$7,368.00

5 orders

Overdue

$5,752.00

2 past the due date

Collected

$3,972.00

Across all orders

Northwind Traders$4,556.00
Acme Corp$1,196.00
Brightside Media$725.00
Stellar Studios$891.00
Harbour Logistics$0.00

Totals come from the lines, balances come from the payments, and the status comes from both. Nothing on this screen was typed in.

How it works

Three steps, and the third one happens on its own.

  1. 01

    Write the order

    Customer, due date, and the lines you supplied. The total comes from the lines, so you never type it and it can never be wrong.

    Rugged tablet3 × 649.00
    Order total$1,947.00
  2. 02

    Record what arrives

    Money lands in your bank, you note it here. Part payments are normal, and each one is a permanent record rather than an edit.

    $947.00First instalment4 Jul
    $1,000.00Balance cleared28 Jul
  3. 03

    See what is short

    The balance and the status update themselves. Nothing to reconcile, nothing to recalculate, nothing to keep in your head.

    Overdue$4,556.00
    Part paid$725.00
    Paid$0.00

The one hard part

An order can be late and part paid at the same time.

Both descriptions are true, so precedence has to decide which one you see. Folio checks in this order, and the consequence is the point: an order settled after its due date reads as paid, because nothing is owed and so nothing can be late.

Status is never stored. It is derived from the payments and the date every time it is read, so it cannot be stale and there is no state to migrate when the rule changes.

  1. 1

    Payments cover the total

    Even if it settled long after the due date

    Paid
  2. 2

    Past the due date

    Lateness outranks how much has been paid

    Overdue
  3. 3

    Something has been paid

    Still within the due date

    Part paid
  4. 4

    Nothing yet

    The starting state of every order

    Pending

To the cent

Money is counted in whole cents, never in decimals.

Three payments of $33.33 against a $100 order leave exactly one cent outstanding. Held as decimals that balance computes to 0.010000000000005116, which prints as $0.01 and fails every comparison you would write against it.

Folio stores integers end to end. Nothing is rounded on the way in or on the way out, so the balance is exact by construction rather than by hoping the rounding cancels.

Order total$100.00
Payment$33.33
Payment$33.33
Payment$33.33
Still due, in cents$0.01
Still due, in decimals0.010000000000005116