What is landlord DIY bookkeeping, and why bother keeping clean records?
Landlord DIY bookkeeping is the day-to-day discipline of recording every rent receipt, every expense, and every deposit movement for each property, so that at year-end you can answer three questions in minutes: how much rent came in, what expenses can be deducted, and what the deposit is doing. Clean records turn tax season from a reconstruction job into a 30-minute copy-paste.
SPEEDHOME's landlord workflow produces most of the records a tax agent or LHDN enquiry asks for: the listing, the tenancy, the rent trail, the repair conversation and the handover. That does not replace bookkeeping — it is the raw material bookkeeping needs. The point of this page is the working layer on top: a chart of accounts you can copy, a monthly close you can run in an hour, and an honest decision on when a spreadsheet stops being enough.
This guide is for the ordinary Malaysian residential landlord — one to a few units, taxed as non-business (investment) source under Section 4(d) of the Income Tax Act 1967 — who would rather do it themselves than pay RM1,500–RM3,000 a year to a bookkeeper, but who also wants to be defensible if LHDN or a tax agent asks for the file.
1. Why start with a chart of accounts a landlord actually uses?
A landlord chart of accounts is just a fixed list of categories — rent received, deposits held, the seven or eight deductible expense types, and a couple of tax-only lines — that every transaction gets sorted into. Pick it once, use it every month, and your year-end tax working paper writes itself.
The most common DIY mistake is to record everything as one "rental" line. That is the same as recording nothing, because at tax time you cannot prove which RM was a fire insurance premium and which was a cracked-tile repair. Use a small, fixed list. The categories below mirror what LHDN Public Ruling No. 12/2018 actually allows, plus the practical lines a landlord needs.
| Account | What goes in | Tax treatment (PR 12/2018) |
|---|---|---|
| 4100 Rental income | Every monthly rent received, by unit and tenant | Gross income, Section 4(d) |
| 4200 Security deposit received | Deposit held — not income until forfeited or applied | Balance-sheet only; do not run through P&L |
| 4300 Other receipts | Late charges, key-card replacements, utility reimbursements | Tag each one; tax treatment varies |
| 5100 Quit rent and assessment | Annual or bi-annual council / land-office bill | Deductible direct expense |
| 5200 Fire insurance premium | Annual policy, landlord's name | Deductible direct expense |
| 5300 Loan interest | Bank interest schedule for the rental loan | Deductible direct expense (interest only, not principal) |
| 5400 Repairs (keep state) | Contractor invoice to fix a broken item to working order | Deductible if wholly and exclusively for the rental |
| 5500 Renewals & new-tenant costs | Subsequent tenancy: agent commission, new stamping, advertising | Deductible from second letting onwards |
| 5600 Management / platform fees | SPEEDHOME or agent management fee | Deductible if wholly and exclusively for the rental |
| 5700 Repairs vs improvement (capex) | New kitchen, retiling, new air-con unit | Capital — capitalise, then depreciate per Schedule 3 |
| 5800 First-letting costs | First tenancy's advertising, legal, stamp duty, agent commission | Initial expense — NOT deductible (PR 12/2018 para 8.3) |
| 7100 Drawings / personal | Money moved to your personal account | Not a tax line; track for cash-flow only |
For a sole proprietor with 1–3 units, this fits comfortably in Google Sheets or Numbers with one tab per unit and a summary tab. Do not invent more categories than this; the discipline is to use the same ten lines every month, not to design a perfect chart.
For a company-owned rental or a landlord with 4+ units, switch to a proper double-entry tool (Xero, SQL Account, AutoCount) so the chart of accounts becomes a real ledger. The same categories work — they just stop being a flat list and become a real general ledger. The 5700 line is where most DIY landlords get stuck: a fresh retile or a new air-con unit is a capital improvement, not a repair, and the tax treatment is different — the capital allowance vs repair guide for landlord tax carries the line-by-line split.
2. Cash basis or accrual basis — how do you decide and write the answer down?
For an ordinary residential landlord with 1–3 units taxed under Section 4(d), cash basis is almost always correct: record rent when the money lands, record expenses when you pay, and stop trying to match invoices to months. Switch to accrual only when the bank, the bank audit, or a tax agent tells you to.
Most Malaysian residential landlords default to cash basis without naming it. That is the right default. Cash basis means a December rent receipt is December income, even if it covers January, and a January contractor invoice paid in February is a February expense. The record is the date money actually moved, and the bank statement is the source of truth.
Accrual basis means: rent is income in the month it covers, not the month it was paid; expenses match the invoice date; and you need a separate receivable / payable schedule. The discipline is higher and the year-end adjustments are heavier, but for a company-owned rental block, a serviced residence, or a short-stay operation, it is the only honest way to read the numbers.
| Basis | When to use it | What it forces you to track | What it does NOT do |
|---|---|---|---|
| Cash | Sole-prop landlord, 1–3 units, Section 4(d) investment source | Date money moved, who paid, what for | Does not match income to the period it covers |
| Accrual | Company-owned rental, 4+ units, serviced or short-stay, bank requires it | Invoice date, period covered, receivable / payable schedule | Does not replace the cash-flow view of the business |
| Hybrid (common DIY compromise) | Landlord doing 1–3 units but wanting tax-agent-ready files | Record on cash basis, but keep a separate invoice-received log | Acceptable working file if disclosed to the tax agent |
If you are unsure, the safe DIY position is: cash basis for the books, a separate folder of unpaid invoices, and a one-line note in your tax file that says "basis: cash." A tax agent can convert to accrual later if they need to; they cannot convert from nothing.
3. How do you run a monthly close that takes an hour, not a weekend?
A monthly close is the same six steps every month: download the bank statement, post every line into the chart of accounts, reconcile the bank balance to the rent ledger, file the month's invoices and messages into the unit's folder, and write one line of "what is different this month." Do it on the same day each month and tax season becomes trivial.
The biggest bookkeeping risk for a DIY landlord is not the spreadsheet — it is the gap between February and the moment you actually open the file. By April you cannot remember whether the March plumber was for unit A or unit B, and by July you are reconstructing from bank statements. The fix is not a better tool. It is a calendar block.
| Step | What you do | Time | Where it goes |
|---|---|---|---|
| 1. Pull the bank statement | Export the rental bank account for the month, CSV or PDF | 5 min | Bank |
| 2. Post every line | Match each entry to a category in the chart of accounts; tag the unit | 20 min | Ledger |
| 3. Reconcile | Opening balance + receipts − payments = closing balance; matches the bank | 10 min | Ledger |
| 4. Match to rent due | Cross-check tenant-by-tenant: who paid, who is short, who is in advance | 10 min | Rent schedule |
| 5. File the documents | Drop invoices, receipts and bank proof into the unit's folder, named YYYY-MM | 10 min | Unit folder |
| 6. Note what is different | One line: "March — unit B water heater replaced, RM680, deductible repair" | 5 min | Monthly note |
Total: about an hour, once a month, on a fixed day (the 5th of the next month is the natural slot). The discipline is the date, not the tool. A Google Sheet run on the 5th beats an Xero file you "will get to next week."
For a landlord with more than three units, the same six steps still apply, but step 2 (posting) is the one that breaks first. That is the sign to move to accounting software — see the decision flow in section 5.
4. The records LHDN actually asks for, and what to keep per property
For ordinary residential letting under Section 4(d), LHDN asks for records that prove three things: rent was received, the expense was real, and the expense was connected to producing rental income. Bank proof alone is weaker than bank proof plus invoice, tenancy document, repair photo and message. Keep at least five years of file per property, in one place, named by year.
The Malaysian tax record-keeping rule for individuals is the Income Tax Act 1967 s.82, with a working interpretation that residential landlords should keep records that support the figures in their return. The fact pack is narrower than competitors make it sound: the question is not "do I have a binder?" but "if LHDN asks in year 4, can I produce the receipt, the tenancy, the bank proof and a one-line note in 15 minutes?"
| Record | Why LHDN / a tax agent wants it | How long to keep |
|---|---|---|
| Tenancy agreement (stamped) | Proves the rental source, parties, rent amount and term | 5 years after the tenancy ends |
| Rent ledger (date, tenant, unit, month, amount) | Matches rent months to bank entries; supports the gross-income figure | 5 years |
| Bank statements (rental account) | Proves money movement; the only record some landlords keep | 5 years |
| Loan interest schedule (annual) | Separates interest from principal; supports the 5300 line | 5 years |
| Quit-rent and assessment bills | Supports the 5100 line; council / land-office | 5 years |
| Fire insurance policy and receipt | Supports the 5200 line; check the policy holder is the landlord | 5 years |
| Repair invoices + before/after photos | Supports the 5400 line; shows the difference between repair and improvement | 5 years |
| Agent / SPEEDHOME management invoices | Supports the 5600 line; ties the management fee to the rental | 5 years |
| Deposit movement record | Tracks what was held, what was applied, what was refunded | 5 years after the tenancy ends |
| Handover and move-out photos | Supports the deposit discussion and any repair-vs-improvement question | 5 years after the tenancy ends |
The fact-pack line to internalise: first-letting advertising, first tenancy legal cost, first tenancy stamp duty and first-tenant agent commission are initial expenses and are NOT deductible against rental income (PR 12/2018, para 8.3). Do not file them in 5500; file them in 5800 and forget about them for tax. Renewal and subsequent-tenant costs are different — they go in 5500. For the 5300 line specifically, the deducting mortgage interest from rental income page covers the loan-interest schedule and the principal-vs-interest split that the 5300 line depends on.
5. When to graduate from spreadsheet to software (or to a tax agent)
Use a spreadsheet while you have 1–3 units and one bank account, you can keep the monthly close inside an hour, and no one outside the household is asking for a P&L. Move to accounting software when you cross 4 units, take on a second property owner, or a tax agent asks for a digital ledger. Move to a tax agent when the facts leave the simple-residential-let pattern: non-resident owner, company owner, short-stay, mixed-use, multiple income sources, or a CP500 notice you do not understand.
The decision is about defensibility, not software preference. A spreadsheet is a perfectly good ledger at small scale. The moment the audit risk rises — a bank asking for statements, a tax agent asking for a tidy file, LHDN issuing a CP500 query — the spreadsheet stops being enough because it cannot produce a real trial balance, a real receivable schedule, or a real fixed-asset register.
| Scale | Typical setup | What it gives you | When it stops being enough |
|---|---|---|---|
| 1 unit, 1 bank account | Google Sheet / Numbers, one tab per unit, summary tab | Cash-basis rent ledger and expense log | A second unit, a co-owner, a tax agent asking for a P&L |
| 2–3 units | Same sheet, one extra column for unit; or Xero / SQL Account starter | Same as above plus a real general ledger if you use software | A serviced unit, a company-owned unit, a non-resident co-owner |
| 4–10 units | Accounting software (Xero, SQL Account, AutoCount) + a fixed-ass register | Real P&L, balance sheet, receivable schedule | First LHDN query, first cross-border owner, first short-stay setup |
| 10+ units or company-owned | Tax agent or outsourced bookkeeping | Full set of management accounts, quarterly review, tax filing | — |
The honest DIY drawbacks: a spreadsheet will not give you a deferred-repairs reserve (the money you should set aside each year for the water heater that will fail in year 4), it will not produce a capital-allowance schedule, and it will not remind you about e-Invoice if your annual rental income crosses the LHDN threshold (under the live LHDN e-Invoice timeline, updated 30 August 2026, taxpayers below RM3,000,000 annual turnover or revenue — individual landlords included — are exempt; the earlier RM500,000-band and RM1,000,000-floor figures are superseded). For an ordinary 1–3 unit landlord, none of that is a current problem. For a landlord scaling up, each one is the next thing the tax agent will ask for.
For a landlord in the YA2026 transition period, LHDN has waived the penalty for non-payment or under-estimation of CP500 instalments for individuals with non-employment income such as rental, interest and royalties — the tax still has to be paid, only the penalty is waived. The bookkeeping job does not change because of that; the file still has to be clean when the final assessment arrives.
For a current read on what similar Malaysian units are renting for in your area, see live SPEEDHOME listings before you sit down to budget next year's expenses.
FAQ
Do I really need a separate bank account for rental income?
It is not a legal requirement, but it is the single most useful bookkeeping habit a DIY landlord can build. A separate account makes the bank reconciliation take 10 minutes instead of an hour, it produces a clean bank statement for the tax agent, and it removes the dangerous habit of mixing personal transfers with rental money in the same notes. If you only do one thing from this page, do this.
What records should I keep if I only have one rental unit?
The same records as a 10-unit landlord, just less of them. Tenancy agreement, a simple rent ledger (one row per month, with date paid and bank reference), the bank statement for the rental account, the loan interest schedule, the quit-rent / assessment bill, the fire insurance receipt, and any repair invoices with photos. Five years of file, in one folder, named by year. Most LHDN queries for a single-unit landlord settle on whether the rent was declared and whether the deduction is supported; this file answers both.
Is cash basis or accrual basis better for a small landlord?
For a sole-prop residential landlord with 1–3 units, cash basis is simpler and is what most tax agents expect. Record the money on the date it actually moved. Switch to accrual only if the bank, the audit, or a tax agent tells you to, or if you start running a serviced or short-stay operation where matching income to the period it covers matters.
How do I handle the deposit in my books?
The deposit is not rental income. It is a balance-sheet item: money the landlord holds on the tenant's behalf, governed by the tenancy agreement and general contract law, with no statutory cap. Record the receipt as a liability (deposit held), record any agreed deduction at move-out with a receipt or quote, and refund the rest. Forfeited deposit amounts are a tax-agent conversation, not an automatic income line.
Where does Zero Deposit fit into a landlord's bookkeeping?
Zero Deposit is SPEEDHOME's managed rental-risk system, not a financial guarantee product, and it replaces the upfront cash deposit so the tenant does not pay a deposit at move-in while the landlord stays protected through the rental-protection process. From a bookkeeping angle, the change is that the deposit line on the liability side starts at zero, and the end-of-tenancy damage discussion moves off the bilateral landlord-tenant ledger into a managed claims process. The chart of accounts does not need a new line; the monthly close gets one fewer item to reconcile.
When should a DIY landlord stop doing it themselves?
When the facts leave the simple-residential-let pattern: non-resident owner, company owner, short-stay or serviced setup, mixed-use property, four or more units, a CP500 notice you do not understand, or any LHDN query. The cost of a tax agent is usually smaller than the cost of filing a wrong position with confidence. For the full tax-only picture, the how rental income is taxed in Malaysia pillar carries the LHDN-side mechanics; the 5 best practices of rental income reporting family is the reporting-side companion.
Accuracy note. Grounded in Income Tax Act 1967. Every figure is bound to a dated fact registry and re-verified on each update. Spotted an error? Email [email protected] with this page's link.