How do I track rent, deposits and property tax across my rental properties in Malaysia?

What a landlord has to keep track of

A landlord tracks four things: rent, deposits, leases and the taxes on each property. Most of the trouble comes from keeping them in different places. Rent and deposits belong to a tenant and a unit; taxes belong to the property and to the name it is held under. When they sit across a spreadsheet, WhatsApp chats and bank statements, every question costs an evening of searching.

Record	What to keep	When it matters
Rent	Tenant, unit, monthly amount, due day, what was paid and when	Every month
Deposits	Each deposit received (as named in your tenancy agreement), date received, amount returned	Move-in and move-out
Lease	Start and end dates, renewal terms, any rent increase, stamp duty paid on the agreement	Before renewal
Assessment tax (cukai pintu)	Amount per property, which council, dates paid	Twice a year
Quit rent (cukai tanah)	Amount per title, which land office, date paid	Once a year
Upkeep	Repairs, contractor bills, who paid	When it happens, and at tax time

The tax dates are set by the authorities, not by your tenants. Local councils collect assessment tax in two halves: Majlis Perbandaran Kluang, for example, sets the deadlines before 28 February and before 31 August, and adds late charges automatically after that. Quit rent goes to the state land office once a year: Penang’s land office gives the payment window as 1 January to 31 May, with a late fine after. Your own council and land office bills show the exact amounts and dates for your properties.

How to set up one register in a spreadsheet

Build the register around the unit, not the property. A shophouse with a shop downstairs and two rooms upstairs is three rows, because each has its own tenant and its own rent.

1. One row per rentable unit. Columns: property, unit, tenant, phone, lease start, lease end, monthly rent, due day.
2. Deposits on the same row. Amount received, date received, and an empty column for the amount returned. The deposit with no record is the one that gets disputed at move-out.
3. A rent tab by month. One column per month. After you check the bank, mark each unit paid, part-paid or unpaid. Do it on the same day every month.
4. A tax tab by property. Property, title or account number, whose name it is under (yours, your spouse’s, your company’s), assessment tax amount and due dates, quit rent amount and due date, and the date you actually paid.
5. A costs tab. Every repair and bill against the property it belongs to, so year-end figures come from records rather than memory.
6. A yearly total per property. Rent received, minus taxes, repairs and loan instalments. This is the number that tells you which property actually earns.

Steps 1 to 4 are the records you need anyway. Step 6 is the one that tells you whether a property is worth keeping.

When a spreadsheet stops being enough

A spreadsheet records what you type into it; it does not issue an invoice, flag a late tenant or warn you that cukai pintu or quit rent is due. Everything depends on someone opening the right file on the right day.

Before I built a property system for one owner, the situation looked like this: rent tracked in spreadsheets, deposits remembered by memory, tax deadlines rediscovered every year, and no way to answer a simple question. Which property actually makes money after maintenance, taxes and financing?

You have reached that point when:

• matching bank credits to tenants takes more than one sitting, or someone else has to do it for you;
• properties sit under more than one name, and your accountant asks for the figures split by owner;
• a deposit, a rent increase or a tax payment has already been missed or argued over once;
• you cannot say, without a day’s work, what each property earned last year.

What a property management system does differently

A property management system keeps the same register but does the repetitive work itself. The one I built for that owner is organised like the spreadsheet above (property, then units, then leases), and covers houses, shophouses, offices and land:

• Rent invoices are generated every cycle, with rent increases and late-payment terms applied, ready to print or send as PDF.
• Payments are matched against invoices, and an aging report shows who owes what and for how long.
• Deposits have their own ledger, tied to the lease.
• Cukai pintu, quit rent, RPGT and stamp duty are records with due dates and payment bills, and they flow into each property’s profit and loss. Before cukai pintu and quit rent fall due, the system reminds you.
• Reports in one click: rent roll, profit and loss per property, receivables aging, cash flow, occupancy and an annual tax summary, all exportable to CSV.
• The accountant logs in with an accountant’s access and sees the finances, nothing else.

For that owner, rent collection now runs on invoices and aging reports instead of memory and bank statements, and tax season became an export instead of a reconstruction project. You can see the screens in the property management case study.

	Spreadsheet	Property management system
Rent invoices	You prepare them	Generated every cycle
Late rent	Noticed when you check the bank	Listed on the aging report
Tax dates	Remembered, or rediscovered	Recorded per property, with payment bills
Profit per property	Rebuilt at year end	One report
Cost	Free	One-time build from RM 8,000; no monthly fee per unit

When you don’t need a custom system

If you own one to three units under one name and your tenants pay by bank transfer on a fixed day, the spreadsheet above is enough. Update it once a month, put the tax dates in your phone’s calendar, and keep your money. A system to replace that would not pay for itself.

If you manage properties for other owners, list units for rent, or run a strata committee (JMB or MC), you want agency or building management software, not this. Those tools are built around listings, commissions and community management, and they do that job well.

The line for a custom system is where the spreadsheet stops being a once-a-month job: several properties, some split into units, held under more than one name, with an accountant who needs the figures by owner. That is the situation I build for.

Between a spreadsheet and a custom build there is another step. If the property system I have already built fits the way you work as it is, I deploy it for you unchanged, from RM 3,999, one fixed price confirmed in writing at quote time. Nothing is customised, so it costs less than building the same system for you; if you want changes later, they are quoted separately. Under this option the code stays mine and your data is yours; what you may do with the code is set out in the quote.

Next step

The property management system page shows what the system covers and how it compares with off-the-shelf tools. On price: a first phase with properties, leases and automatic invoicing sits in the RM 8,000 to 20,000 bracket, and most property systems with automatic invoicing and Malaysian taxes land in RM 20,000 to 60,000 (see pricing). The price is fixed per milestone and agreed in writing, you pay the balance of each milestone only after you have used it live, defects in what I built are fixed free for 90 days after handover, and the code and database are yours.

Tell me on WhatsApp how many properties and units you have and how you track them today, and I will reply with a concrete range within one business day.