banking

Add Your Bank Account and Import Statements

Add a Malaysian bank account to IntBooks and bring in transactions by importing statement files (CSV, OFX or MT940). Direct bank feeds aren't available yet.

By IntBooks Editorial Team · Last updated:

Can IntBooks connect directly to my bank? Not yet. IntBooks does not have direct bank feeds with Malaysian banks. You bring transactions in by importing the statement files you download from your bank’s online banking. This article covers adding the bank account, the file formats IntBooks reads, and what happens after import.

Step 1: Add the bank account

  1. Go to AR/AP → Bank Reconciliation and click Add Bank Account.
  2. Enter an account name you’ll recognise, for example “Main Operating Account”.
  3. Enter the bank name and the account number as they appear on your statement.
  4. Optionally enter the SWIFT code.
  5. Set the currency, usually MYR. Statements must be in the same currency as the account.
  6. Enter the GL account code this bank account posts to in your chart of accounts.
  7. Tick default if this is the account most customer payments land in.
  8. Save.

Step 2: Download a statement from your bank

Log in to your bank’s online business banking and download the statement for the period you want. IntBooks reads these file types:

FormatFile extensionsNotes
CSV.csvYou map the columns for date, amount, description and reference. Day-first dates (DD/MM/YYYY), as most Malaysian banks use, are the default.
OFX.ofx, .qfxOpen Financial Exchange, offered by many online banking systems.
MT940.mt940, .sta, .940The SWIFT statement format, often available from corporate banking platforms.

PDF statements aren’t imported as transactions. If your bank only offers PDF, ask it for a CSV or OFX export.

Step 3: Import the file

Upload the statement file against the bank account. IntBooks reads each line and skips any line you’ve already imported, matching on account, date, amounts and reference, so overlapping statements don’t create duplicates. Each import is kept in the account’s import history.

Statement file upload is being rolled out during the closed beta. If you don’t see the upload option in your workspace yet, contact support.

Step 4: Match the imported transactions

Go to AR/AP → Bank Reconciliation and run Auto-Match. IntBooks compares each bank line with the customer receipts and supplier payments you’ve recorded. It scores each pair on the amount, how close the dates are, and the reference, and proposes the best pair as a match for you to review.

For lines it can’t match:

  • Customer payment or supplier payment: record the payment in IntBooks if you haven’t already, then match the bank line to it.
  • Bank fee, interest or other items: record them with a journal entry, then match.

See Reconcile bank statements for the full month-end routine.

Common issues

”Currency mismatch” when importing

The statement’s currency must match the bank account’s currency. If you hold a foreign-currency account, set up a separate bank account record in that currency.

My CSV imports with the wrong dates

Check the date format in your column mapping. IntBooks assumes day-first dates unless you specify another format.

I imported the same statement twice

Lines already imported for that account are skipped, so a second import of the same file shouldn’t create duplicate transactions. Check the import history to see how many rows were skipped as duplicates.

My bank statement has Chinese or Malay characters in the description

That’s fine. Descriptions are stored in UTF-8.

What’s next?