Skip to content

Penny-exact allocation

Split 100.00 three ways and get 33.34 / 33.33 / 33.33 — never a cent left in suspense.

Runs
In this tab
Data sent
None
Rounding
Once, at the end
Also in
The Chrome extension

Penny-exact allocation, worked

Showing a worked example — type over it

ISO 4217 code — sets the decimals: JPY 0, USD 2, KWD 3.

Result

#WeightShareAmount
1133.33%3,333.34
2133.33%3,333.33
3133.33%3,333.33
Allocated10,000.00

Sums to the total exactly.

How the penny-exact allocation works.

Allocation (largest-remainder, sums to the total exactly)

Quoted from the toolbelt spec, the document this tool was built against.

Where these numbers come from.

Negatives are parenthesised because that is what a statement does. The rest is four promises.

More in money maths

The same number, elsewhere.

A calculator answers the question once. These carry the answer into a product, name what it computed, and argue the method.

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.