B Benchcraft StudioOWNER WORKSHEETS   /   UTILITIES
RECONCILIATION STUDY   /   01

One meter.
Several stays.

Allocate fixed charges by calendar days and usage charges by verified meter readings. Keep shared and unexplained amounts visible for the owner to review.

Owner-review worksheet. No invoice is issued. This approach assumes successive use of one cumulative meter. It does not divide overlapping tenancies or decide what someone owes.
01

Copy the source figures

Use the two charge totals from the same bill and the bill's start and closing meter values. Include taxes or other charges only when you can allocate them consistently into the two categories.

02

Record who used each period

Add each non-overlapping period once. Enter the first and last verified readings within that period, or leave both empty. Untested usage stays unassigned; it is never estimated from occupied days.

Choose “Shared use” only for a period known to be shared. Uncovered dates and gaps between readings are reported separately as unassigned. Group labels are anonymous.

ALLOCATION REGISTER

Review the split

Scroll across the table for the charge components.

03

Check the workings

All interval dates are inclusive. Allocations are calculated once per group before rounding, even if a group appears in several periods.

Show the dates and meter ranges used
How fractional cents are assigned

For each charge type, multiply its total cents by the group’s share of all billed days or recorded meter units. Take the whole cents first, then assign any remaining cents to the largest fractional remainders. Ties follow the displayed group order. Fixed and usage totals each reconcile separately.

The HTML and print versions include the source figures, anonymous periods, working method and review balances. No account or information transfer is required. Nothing entered here is saved when you leave.

SCOPED TEMPLATE SERVICE

A worksheet for your own bill format

€39 once for a custom shared-bill worksheet from an agreed anonymised sample, including one revision. You choose the allocation rule. Confirm scope before a PayPal invoice is issued.

Discuss the €39 template →
Benchcraft Studio · Public validation tool. Review the source documents and agreed rule before using any allocation.