A chart of accounts, MSME-sized.

Fifty-one accounts, numbered the way Malaysian accountants expect. SST payable and input, EPF, SOCSO, EIS and PCB controls are already in place, and every expense row carries a note on what LHDN lets you deduct.

Download the Excel template Free · .xlsx · No signup

Pick your format.

Same chart in each. The Excel file is formatted for reading and printing; the CSV is a flat list your software can import.

Excel · recommended

Excel, grouped by section

Assets through expenses in colour-banded sections, with a tax treatment column and a note on every account. Print it or keep it open while you book.

Download .xlsx
Google Sheets

Open it in Google Sheets

Upload the .xlsx to Google Drive and open it. Sheets keeps the sections and formatting, so the chart lives in your browser.

Get the .xlsx
CSV · .csv

Flat CSV list

Code, name, type, category, tax treatment. One row per account, ready to import into accounting software or your own spreadsheet.

Download .csv

What's inside.

Five account types across eight sections, each in its own code range. The numbering follows the convention Malaysian SME software uses.

Assets · 1000s

What the business owns

  • Cash on hand and bank accounts
  • Accounts receivable and undeposited funds
  • Inventory
  • Property, plant & equipment, flagged as capital
Liabilities · 3000s

What the business owes

  • Accounts payable and credit cards
  • SST payable, deferred, and input recoverable
  • EPF, SOCSO, EIS and PCB control accounts
  • Salary control for net pay owed to staff
Equity & income · 4–5000s

Capital and sales

  • Owner's share capital and retained earnings
  • Sales income and discounts given
  • Other income: interest earned, exchange gains
Costs · 6000s

Cost of sales and expenses

  • Cost of sales and inventory adjustment
  • Salaries plus employer EPF / SOCSO / EIS
  • The everyday bills: rent, utilities, internet, marketing
  • Tax-flagged rows: entertainment at 50%, fines, donations, depreciation

Will my tax agent approve?

The structure follows the numbering Malaysian SME software has settled on, so a tax agent or bookkeeper can find their way around it without a briefing. The tax treatment column marks the usual Section 39 add-backs (entertainment at 50%, fines, donations, depreciation) before your agent asks for them. It's also the same chart Kiira creates when you open an account, so if you outgrow the spreadsheet, your account codes come with you.

From download to first entry.

Five minutes to trim, then it just sits there being right.

  1. Trim

    Delete what you don't need

    No stock? Remove the inventory rows. Not SST-registered? Drop the SST accounts. A shorter chart is easier to book against, and you can always add rows back.

  2. Extend

    Add accounts inside the ranges

    A new expense account takes the next free 65xx code, a new income account the next 50xx. Keep the type column filled so your reports still group correctly.

  3. Book

    Use the same account every time

    Petrol always goes to Daily Commute, never sometimes to General Expense. Consistency is what makes the year-end numbers mean something.

Who uses this.

Anyone setting up books for the first time, or cleaning up a shoebox.

Kedai · F&B

First real set of books

Stock, rent, wages and the Grab payout each get a numbered home. When the tax agent asks where the money went, the answer is a code, not a shrug.

Online seller

Marketplace fees, sorted

Shopee commission, shipping subsidies and ad spend stop hiding inside one lump. Split them across the expense range and see what selling actually costs.

Services

Freelancers and small agencies

A lean chart: income, software subscriptions, professional fees, travel. Trim the stock and SST rows and you're left with exactly what a service business needs.

Tax season

Handing over to a tax agent

The deductibility notes mean your agent spends the hour on advice instead of re-sorting entertainment receipts from office expenses.

Common questions, short answers.

Is this actually free?

+
Yes. No signup, no email gate, no watermark. Download it, keep it, share it with a friend who needs it.

Do I have to use all fifty-one accounts?

+
No. Most micros run comfortably on twenty. Delete the rows that don't apply — the chart is a menu, not a checklist. What matters is that the accounts you keep get used consistently.

I'm not SST-registered. Which rows do I delete?

+
Remove SST Payable, SST Deferred, SST Input Recoverable and SST Expense. If you register later (the threshold for most sectors is RM500,000 in annual taxable turnover), add them back with the same codes.

Can I rename accounts or change the codes?

+
Rename freely — "Water & Electricity" can become "Utilities TNB + Air Selangor" if that's clearer for you. Keep the code ranges intact though: assets in 1000s, liabilities in 3000s, income in 5000s, expenses in 6000s. That grouping is what your reports and your accountant rely on.

Does this work with Bukku, SQL Account, or QuickBooks?

+
The structure follows the same Malaysian SME convention those systems use, and the CSV is a clean import file. Column names may need a quick remap in the import screen, but the codes and grouping carry straight over.

What does the tax treatment column mean?

+
It flags how LHDN treats each expense at year end: fully deductible, 50% deductible (entertainment), non-deductible add-backs (fines, donations, depreciation), or capital items relieved through capital allowances. Your tax agent makes the final call; the column just stops the common surprises.
When the chart starts working

Accounts that
book themselves.

Forward a receipt on WhatsApp and Kiira posts it to the right account in this exact chart. You review; nothing files itself without you.

Free tier · No card · Malaysia