FREE BOOKKEEPING TOOLS

Rental property profit or loss

An April–March rental schedule with monthly totals, annual results and your ownership share.

Your entries stay in this tab's memory. We do not save them to an account, cookies or browser storage. Refreshing or closing clears the tool. Print a report before leaving if you need a copy. Your browser or device may retain printed files.

Enter GST-inclusive amounts for a long-term residential rental. Enter only the rental-business portion of expenses. Keep capital costs, mortgage principal and refundable tenant bonds out of operating income/expenses. This is a management profit or loss, not a completed tax return.

CategoryAprMayJunJulAugSepOctNovDecJanFebMarYear total
Rent received$0.00
Expense reimbursements$0.00
Insurance (all policies combined)$0.00
Mortgage interest$0.00
Council / water rates$0.00
Property management / letting$0.00
Repairs and maintenance$0.00
Accounting and administration$0.00
Operating body corporate levies$0.00
Utilities paid by landlord$0.00
Gardening / cleaning$0.00
Other operating expenses$0.00
Chattels depreciation (non-cash)$0.00
Mortgage principal (cash flow only)$0.00
Capital purchases / improvements (cash flow only)$0.00

Profit and cash flow are different

Profit = rent and reimbursements − operating expenses − chattels depreciation. Cash flow = income − cash operating expenses − mortgage principal − capital purchases. This assumes entered income and cash expenses were received/paid; it does not reconcile receivables, deposits or bank opening/closing balances.

Use an accountant-reviewed depreciation amount for eligible chattels. Land and building depreciation is excluded. A loss here does not automatically reduce tax on wages; residential rental excess deduction rules may apply.

IRD rental income guidance