How to import a bank statement into MYOB

Why MYOB needs OFX or QIF, not CSV

MYOB’s statement import is built for files your bank produces, so it reads statement formats rather than spreadsheets. MYOB Business asks for .QIF or .OFX files. AccountRight on Windows reads OFX, QFX, QIF and OFC.

That matters when the bank only gives you PDFs: past statements, a closed account, or months before your bank feed started. Convert the PDF straight to OFX and import that.

Route	Works with MYOB statement import?	When to use
Bank’s own OFX or QIF download	Yes	Recent transactions the bank still lets you export
PDF → OFX	Yes	Older months, closed accounts, PDFs a client sends
CSV straight in	No	Not accepted by the statement import
AccountRight Import Data (CSV or tab-delimited)	Sometimes	Creating Spend Money and Receive Money entries in AccountRight desktop

Step 1: Convert the PDF statement to OFX

Download the PDF from internet banking, then convert it. BankConv reads the transaction table and writes each transaction into the OFX file’s fixed fields: date, amount and description. MYOB reads those without any column mapping.

1. Upload the PDF to BankConv’s bank statement to OFX converter. Password-protected PDFs work.
2. Compare the rows on screen with the PDF.
3. Choose OFX and download the file. A free account is needed to download. Rename it, for example westpac-business-2026-09.ofx.

Australian statements often print Debit and Credit columns with a running Balance. BankConv turns debits into negative amounts, leaves opening balance rows out, and writes the closing balance into the file. The CommBank, Westpac, ANZ and NAB pages show each bank’s layout and quirks.

If BankConv can’t tell which column is the date or the amount, it says so before the download. CSV always works in that case, and the free CSV to OFX tool lets you map the columns yourself.

The file is OFX 1.0.2, the older SGML style. Some MYOB users report that older editions read only OFX version 1 files, so this is the safer version.

Step 2: Import the OFX file into MYOB

The steps differ between MYOB Business in a browser and AccountRight on Windows. Menu names can change between releases, so look for the closest match.

MYOB Business (browser):

1. Go to Banking and choose Banking hub.
2. On the account, click the three dots (…) and choose Import statement.
3. On the Bank statement import history page, click Import statement.
4. Choose the Bank account.
5. Click Import statement file, then Browse, and select the OFX file.
6. Click Import. MYOB shows how many statement lines it imported.

The lines then appear on the Bank transactions page, ready to allocate or match.

AccountRight on Windows:

1. Go to the Banking command centre and click Reconcile Accounts.
2. Choose the account, then enter the statement’s closing balance and closing date.
3. Click Get Statement, select the OFX file and click OK.
4. MYOB matches what it can by cheque number, date and amount. For the rest, use Match Transaction or Add Transaction.

The CSV route in AccountRight, if you prefer it

AccountRight on Windows also has a general Import Data option, usually under the File menu, that reads comma-separated or tab-delimited text files. It can create Spend Money and Receive Money transactions instead of statement lines.

Use it only if you are comfortable with its field mapping. Back up the company file first. Import with no other users logged in. A common tip from MYOB users is to export one existing Spend Money transaction first, to see the exact layout it expects.

For most people, the OFX route is simpler and easier to undo.

Common MYOB import problems and fixes

Most failures come from the file type, the date order or summary rows. Check those first.

What you see	Cause	Fix
File can’t be selected or is rejected	It is a CSV or PDF	Download the statement as OFX from BankConv
Dates land in the wrong month	Day and month read the wrong way round	Check the dates in BankConv’s preview against the PDF before downloading
Deposits show as withdrawals	Money in and out read the wrong way round	Compare a few rows with the PDF; if they’re flipped, use CSV and the CSV to OFX tool to map them yourself
An extra line with a balance or total	A summary row read as a transaction	Check the preview for stray total rows before downloading
Duplicate lines	Dates overlap the bank feed	Import only statements for months the feed doesn’t cover
Error on a large file	File over MYOB’s 10MB limit	Split by month

Check the import against the statement

MYOB won’t tell you if a transaction is missing. Run three checks after each import.

1. Row count. Transactions on the PDF should equal lines imported.
2. Totals. Sum debits and credits and compare them with the statement summary.
3. Closing balance. After reconciling, MYOB’s balance should equal the closing balance on the PDF.

If a check fails, compare page by page. A missing row usually sits at a page break.

Tips for regular MYOB imports

• Keep a bank feed for current months and use statement imports only for gaps and history.
• Name files by bank and month so you can see what’s been imported.
• Convert a quarter at once: BankConv takes up to 10 PDFs in a batch. See pricing.
• Uploaded files and outputs are deleted after 24 hours. See security.
• New to the format? Read what an OFX file is.