Malaysian bank statements to Excel

Malaysian statements come in a few shapes: Maybank prints one amount column with the sign after the number (1,234.56- or 500.00+), CIMB separate Withdrawal and Deposits columns, Public Bank short dates like 05/03. StatementEasy reads each of them, joins DuitNow and IBG details to their transaction and checks every row against the balance.

Banks

Five Malaysian banks are tested on their statement layouts: Maybank, CIMB, Public Bank, as well as RHB and Hong Leong Bank. Other banks are read by the generic reader; the balance check shows whether every line was read. If yours is not, tell us the bank.

Malaysian statement formats, read correctly

Bank by bank

• Maybank — ENTRY DATE and VALUE DATE as 05/03/25, one TRANSACTION AMOUNT column signed after the number, and the STATEMENT BALANCE.
• CIMB — DD/MM/YYYY dates, a Cheque / Ref No column, then Withdrawal, Deposits and Balance.
• Public Bank — dates like 05/03 with the year taken from the statement date, from Balance B/F.
• RHB — dates written 05-03-2025, from the B/F BALANCE.
• Hong Leong Bank — Withdrawal and Deposit columns, from the balance carried over from the previous statement.

What Malaysian statements are used for

• LHDN e-Filing — convert January to December and total income and expenses.
• Loan applications — banks usually ask for three to six months; the Monthly sheet lists each month’s salary and balance.
• Businesses — export CSV for your accounting software.