How do I allocate shared charges by relative weights with an exact cent reconciliation?
Each charge ID must repeat the same total. Weights must sum above zero. Remaining cents go to the largest fractional remainders, then input order.
Open Cent AllocationTry the worked example
These are the example inputs from Cent Allocation. Replace them in the tool to run your own case.
| Charge ID | Charge EUR | Cost centre | Weight |
|---|---|---|---|
| Shared | 100 | Design | 1 |
| Shared | 100 | Operations | 1 |
| Shared | 100 | Support | 1 |
Example result
€100.00 allocated
Who uses this?
Shared services lead. The free online tool runs the calculation in your browser. To edit the files and use the tools offline in one business, see the €49 offline edition.
Where the idea came from
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.
Original video