Search

Convert Maybank Statement PDFs to Excel (Step-by-Step Guide)

How to turn Maybank2u current, savings, and fixed deposit statement PDFs into clean Excel — what gets extracted, common quirks, and how to verify the output.

Admin4 min read

If you download Maybank statements from Maybank2u every month and copy them into Excel by hand, this guide will save you that step. It walks through what a Maybank statement PDF actually contains, how Transift extracts it, and how to verify the Excel output before it touches your books.

What you get from a Maybank2u PDF

Maybank2u (Maybank Malaysia — Malayan Banking Berhad) lets you download monthly statements for current accounts, passbookless savings accounts, and fixed deposits. The PDF is digitally generated — text is selectable, not a scan — which means it can be parsed reliably rather than OCR’d.

A typical Maybank current or savings statement includes:

  • Account header — account number, account holder, statement period.
  • Opening balance carried from the previous statement.
  • Transaction rows — transaction date, value date, description, debit or credit amount, and a running balance.
  • Fees, interest, and withholding tax entries, sometimes grouped at the foot of the statement.
  • Closing balance at the end of the period.

Note: Maybank does not issue eStatement PDFs for passbook savings accounts. Those still come as a printed passbook and need an OCR-based pipeline, not Transift. Transift also does not process Maybank credit card statements.

Step-by-step: from Maybank2u to Excel

  1. Download the PDF from Maybank2u or the MAE app. On the Maybank2u website, the most direct path is to sign in, open Accounts, select the account, and click View Statement. Alternatively, use the Bills & Statements menu and pick Statements to see all your eStatements in one place. The MAE app exposes the same statements under each account. Do not print-to-PDF from the browser — that path sometimes flattens the layout and loses the running balance column.
  2. Upload the PDF to Transift. Drag and drop, or pick the file from your device. You can upload several Maybank statements at once — Transift will group them into a single Maybank batch, stitch statements of the same account into a continuous timeline, and put different accounts on separate sheets in the resulting workbook.
  3. Review the extracted rows. Transift shows you the parsed transactions before you download Excel. Each row carries its date, description, reference, debit/credit, and balance.
  4. Run the balance continuity check. The tool validates that opening balance plus the sum of transactions equals closing balance. If anything is off, the affected row is flagged.
  5. Download Excel. You get a .xlsx file with one sheet per account, columns aligned to your statement, and the original balances preserved.

When statements become available

Maybank does not release every account’s eStatement on the 1st of the month. The official availability is:

Account type Statement available
Current Account 4th of the month
Passbookless Savings Account 8th of the month

If the first week of the month has passed and you still cannot see a statement, double-check that the account type above is eStatement-eligible and that any minimum-balance condition has been met (passbookless savings requires a RM1,000 monthly average balance for the cycle).

How to verify the Excel before reconciliation

Two quick checks catch most issues before they reach your ledger:

  • Balance continuity. Compare the opening balance plus the sum of all debits and credits to the closing balance. It should reconcile to the cent. If it does not, re-export and re-check — it usually means a row was truncated on a multi-page boundary.
  • Row count. The number of transactions in Excel should match the number of transactions shown in the PDF’s transaction listing (usually printed at the top or foot of the statement). If it is off by one or two, look at the multi-page seam.

For deeper validation, Transift runs these checks automatically and flags any mismatch on the review screen, so you do not need to do the math by hand.

When Transift is the wrong tool

Transift only handles digitally-generated PDFs. If your Maybank statement is a scanned image — for example, an old paper statement you scanned at home, or a branch printout that was rescanned — the tool will not produce reliable output. You will need an OCR-based pipeline instead. Note that Maybank has been on paperless e-statements since 19 December 2015 for active M2U customers, so most current customers will not have paper originals at all — but pre-2016 statements do exist in the wild.

What’s next

Once the Maybank current and savings statements are flowing cleanly, the same workflow applies to your other Malaysian accounts.

To try it on a real Maybank statement, create a Transift account. It is free during the open beta.