Consistent categories make a rental worksheet easier to review, compare and hand to someone else. The aim is not to create a tax classification; it is to record ordinary operating costs in a repeatable way.
The categories below are practical examples. Confirm the treatment of any cost with a qualified professional and the rules that apply to you.
Start with a small, stable list
Choose a handful of categories you can apply consistently across properties. A short list is easier to maintain than a long list with overlapping definitions.
| Category | Examples of ordinary costs |
|---|---|
| Repairs and maintenance | Small fixes, replacement parts, routine servicing |
| Utilities | Electricity, water, gas or other utilities you pay for |
| Insurance | Landlord or property insurance premiums |
| Management and services | Letting agent, cleaning or lawn-care services |
| Administration | Software, bank fees or other routine admin costs |
Use one rule for each entry
Write a short description that identifies the property and the purpose. If a cost could fit two categories, choose the one that reflects the main purpose and apply the same choice next time.
Handle irregular costs separately
Annual insurance, larger repairs or seasonal services can distort a single month. Record the actual date and amount, and use the summary rather than a single month to review the year.
A monthly review routine
- Check that every transaction has a date, property ID, type and amount.
- Review the entry check column for rows that need correction.
- Compare the monthly totals with the underlying receipts or statements.
- Keep the original documents with the working copy.
Common mistakes
- Mixing personal spending with property operating costs.
- Using a vague description that cannot be matched to a receipt later.
- Changing category names partway through the year.
- Treating the sample totals as tax advice or a final accounting record.
Scope
This guide is general record-keeping guidance. It does not decide whether a cost is deductible, how a property should be taxed, or which accounting standard applies. The free sample uses fictional data and USD; verify your own local requirements.
Use the how-to guide for the spreadsheet workflow, or download the free sample.