Importing a Bank Statement File into MYOB: Formats and Limits

If you searched for how to import a bank statement CSV into MYOB, the key finding from MYOB’s own help is that the bank statement import pages do not mention CSV at all. They describe statement files in bank formats instead.

For MYOB Business (the browser product), the help says to save the bank statement as a .QIF or .OFX file. For AccountRight (the desktop product), it says the supported formats are OFX, QFX, QIF and OFC. Our evidence covers these two products and the MYOB Ledger article below, so check MYOB’s current help for any other MYOB product you use.

MYOB states that bank statement files must be less than 10 MB. On dates, the browser steps say that if you are offered a choice of date formats, you should choose dd/mm/yy.

MYOB also says you cannot import transactions dated earlier than the Opening balance month in MYOB Business, or earlier than the Conversion Month set when the company file was created in AccountRight. Transactions dated before a lock date also cannot be imported.

For MYOB Business, the help describes opening the Banking hub, choosing Import statement for the account, picking the bank account for the transactions, selecting your statement file and clicking Import.

For AccountRight, it describes opening Reconcile Accounts from the Banking command centre, entering the account, closing balance and statement date, clicking Get Statement and selecting the file, then matching or adding transactions before clicking Done.

Menu names change over time, so follow MYOB’s current article for the exact path in your version.

MYOB’s Client Accounting help has a separate article on importing a .CSV file. That import is for ledger data, not bank statements: it expects all column headers in row 1, a mandatory account code column, a transaction date in DD/MM/YYYY or DD-MM-YYYY format, and amounts that do not include the characters $ or ,. It also requires the amount column to total zero, so it works like a journal import.

MYOB’s Ledger article on importing a bank statement mentions only a .QIF file, with the same advice to choose dd/mm/yy if a date format choice is offered.

If your bank gives you only a CSV or a PDF, the MYOB pages we read do not describe a CSV route into the bank statement import. Check whether your bank also offers an OFX, QFX or QIF download, which are the formats MYOB lists. If you need the figures in a spreadsheet for checking or reconciliation, PDFtoRow converts statement PDFs to Excel/CSV, with a free 10-row preview.