Cent Allocation
Allocate shared charges by relative weights with an exact cent reconciliation.
Prepare your sheet
Use one row per charge id observation. Enter Charge EUR, Cost centre, Weight. Check that every row belongs to the same review scope.
Decision rule
Each charge ID must repeat the same total. Weights must sum above zero. Remaining cents go to the largest fractional remainders, then input order.
Worked result
The fictional example contains 3 input rows. Its result is €100.00 allocated.
| Charge | Centre | Weight | Allocation |
|---|---|---|---|
| Shared | Design | 1 | €33.34 |
| Shared | Operations | 1 | €33.33 |
| Shared | Support | 1 | €33.33 |
Run it on your own inputs
- Open the tool and choose Start empty or edit the example.
- Enter the inputs, resolve validation messages and review the decision sheet.
- Download the text report or print the summary for the responsible person.
Source and support
Allocate shared charges by relative weights with an exact cent reconciliation. The business case pairs prepared back-office work with a person responsible for exceptions. Benchcraft designed this tool’s inputs, decision rule and example for this office task. Reviewed source · Greg Isenberg at 1:45.
Request a custom workflow. €149 one-time pilot after written scope agreement. JB Codex adapts one repeated job with a worked example and owner review.