Calculation guide
Apply the tenant’s agreed area share to eligible costs. Positive reconciliation is due to the landlord and a negative balance is a credit.
balance = cost*area/building-paid; share = 100*area/building; actual = cost*area/building
Inputs
Eligible annual common costs
Example entry 240000 (in the selected currency).
Tenant area
Example entry 200.
Total allocable area
Example entry 4000. Minimum 0.001.
Advances paid
Example entry 10000 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Eligible annual common costs | 240,000 |
| Tenant area | 200 |
| Total allocable area | 4,000 |
| Advances paid | 10,000 |
| Result | Value |
|---|---|
| Reconciliation balance | 2,000 |
| Tenant share | 5% |
| Allocated annual costs | 12,000 |
Calculation steps
Reconciliation balance = (((Eligible annual common costs × Tenant area) ÷ Total allocable area) − Advances paid)
(((240,000 × 200) ÷ 4,000) − 10,000) = 2,000
Tenant share = ((100 × Tenant area) ÷ Total allocable area)
((100 × 200) ÷ 4,000) = 5%
Allocated annual costs = ((Eligible annual common costs × Tenant area) ÷ Total allocable area)
((240,000 × 200) ÷ 4,000) = 12,000
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Eligible annual common costs | 240,000 | 264,000 | Reconciliation balance | 2,000 | 3,200 |
| Tenant area | 200 | 220 | Reconciliation balance | 2,000 | 3,200 |
| Total allocable area | 4,000 | 4,400 | Reconciliation balance | 2,000 | 909.090909 |
| Advances paid | 10,000 | 11,000 | Reconciliation balance | 2,000 | 1,000 |
