Start with your own records
Download the blank apartment cost organiser (CSV)
Open it in your spreadsheet app. The CSV is a manual worksheet: it has no formulas, automatic duplicate detection or connection to Lot. Fill the annual amount yourself after checking the payment count. Keep personal documents and account numbers in your own files.
Use one copy for one apartment and one stated 12-month window, such as 1 January to 31 December 2027. Decide whether you are recording past payments or planning future ones. Keep those two views separate, and label future figures as estimates. This worksheet does not calculate a statutory levy, assess affordability or decide whether a building has adequate funds.
The suggested rows are prompts, not a list of charges every apartment has. Add or remove categories for your own scope. If you include loan repayments, record that choice explicitly; a payment total is not a tax calculation or an investment-return measure.
Put the figures on the same period
Equal-payment total = amount per payment × number of payments in your chosen 12 months.
Use the actual schedule or clearly label an assumption. Twelve monthly payments and four quarterly payments are convenient examples, not proof that your payments are equal or that every charge runs for the whole year. For weekly or fortnightly payments, count the payment dates in your window rather than assuming that every calendar year has the same count.
If an amount changes partway through the year, split it into separate rows. For unequal or one-off payments, list each amount once and add them. For example, two known payments of $300 and $700 total $1,000; multiplying the first by two would give the wrong figure.
A monthly equivalent is the 12-month total divided by 12. It helps compare periods, but it is not the amount due each month. Keep the actual due dates beside the annual view so a large quarterly payment does not disappear into an average.
A fictional example: A$8,390 across 12 months
Every amount below is fictional. These are not typical costs or a recommended budget. Assume each item is separately payable by this owner, covers the same 12-month window and uses the stated amount payable, with no overlapping charges. The example excludes loan repayments and other unlisted costs.
| Item | Amount | Payments | 12-month amount |
|---|---|---|---|
| Owner contribution notices | $1,400 | 4 | $5,600 |
| Electricity | $110 | 12 | $1,320 |
| Contents insurance | $300 | 1 | $300 |
| Separate water charges | $180 | 4 | $720 |
| One repair | $450 | 1 | $450 |
| Known subtotal | $8,390 |
$5,600 + $1,320 + $300 + $720 + $450 = $8,390. The monthly equivalent is $8,390 ÷ 12 = $699.17, rounded to cents. The annual figure remains the starting amount; multiplying the rounded monthly figure by 12 introduces a four-cent rounding difference.
This is a subtotal of the listed items. It is not the complete cost of owning an apartment. If another relevant amount is unknown, retain an unresolved row rather than treating $8,390 as a complete answer.
Check for the same cost appearing twice
Give each row a document reference, period and scope. Before adding it, ask whether another included row already contains the same charge.
- Whole building versus your apartment: do not add a whole-building expense budget to the amount on your own contribution notice.
- Total versus components: use a notice total or its component amounts, not both.
- Bill versus payment: the invoice and the bank payment may be two records of the same cost. Link the records rather than adding both.
- Old versus revised document: retain the version history, but choose the applicable figure once.
- Estimate versus actual: use separate planning and historical views rather than adding both figures for the same payment.
Mark a suspected overlap as “Review” in the CSV and explain it in the notes. The worksheet cannot establish what a charge includes. Ask the issuer when that is unclear. For Queensland document labels, see how to read a building budget.
Keep missing amounts and genuine zeroes different
A blank means you do not yet know the amount or payment count. A confirmed zero is a number supported by your records. Mark a relevant but unknown row “Unknown”, leave its amount blank and keep it in the worksheet. Mark a row “Excluded” only when you have deliberately left it outside the stated scope, with a reason.
Add only checked, non-overlapping rows to the known subtotal. Record the number of unresolved rows beside that subtotal. An unresolved row with a blank amount cannot make a complete annual total. A confirmed $0 paid four times contributes $0; a missing quarterly amount contributes an unresolved question.
Before relying on the result, review the date window, included categories, estimates, exclusions and unresolved items. Save the worksheet with its preparation date and source versions so the next update can be compared with this one.
Common questions
Is this a strata levy calculator?
No. It organises figures you supply. It does not determine an owner’s legal contribution, calculate entitlements or assess whether a building budget is sufficient.
Can I multiply a quarterly amount by four?
Only if four payments of that amount belong in the chosen 12-month window. Check the schedule. If payments vary or start partway through the year, list the applicable amounts instead.
What do I do with a one-off or irregular payment?
Record each known payment once in the relevant window. Do not repeat a one-off payment every quarter or turn one unusually low bill into an annual estimate without stating that assumption.
Does the CSV calculate totals or find duplicates automatically?
No. It is a blank manual worksheet. Use the steps on this page to calculate amounts, flag possible overlaps and keep unknown rows visible.
Can a blank cost be entered as zero?
Only enter zero when your records establish zero for the stated scope and period. Otherwise keep it blank, mark the row Unknown and label the sum of checked amounts a known subtotal.
Is the monthly equivalent my next monthly bill?
No. It spreads a 12-month total evenly for comparison. The real payments may fall on different dates and have different amounts.
Sources & method
Prepared by Lot with AI assistance. This is an original organisation method using user-supplied figures and reproducible arithmetic. The example is fictional, not a price benchmark, quote or levy calculation. The blank CSV has no formulas or automatic checks. No practitioner review is claimed. How we research and check our resources.