# Import Bank Statement into MYOB

- Author: SimpleBankConvert (https://www.simplebankconvert.com)
- Published: 2025-01-02
- Updated: 2025-01-02
- Category: Quicken and other software
- Canonical: https://www.simplebankconvert.com/blog/import-bank-statement-into-myob

> How to import a bank statement into MYOB from an OFX, QIF or CSV file, where the import sits in MYOB Business and how to check the result.
To import a bank statement into MYOB Business in the browser, go to Banking, then Banking hub, open the account's three-dot menu and choose Import statement. MYOB reads QIF and OFX files under 10 MB, so a CSV has to become one of those first. Imported lines appear on the Bank transactions page for you to check.

## Which bank statement files MYOB accepts, and where CSV fits

MYOB names its statement file types plainly. [MYOB's help article on importing bank and credit card statements](https://www.myob.com/au/support/myob-business/banking/bank-statements/import-bank-and-credit-card-statements) says the browser version accepts QIF or OFX files, and the desktop version also lists QFX and OFC. CSV does not appear on that list, so treat it as unsupported for this import.

That leaves three practical cases:

- **Your bank offers OFX.** Download it. Both MYOB versions read it, and each line carries a bank-assigned transaction ID.
- **Your bank offers only a Quicken file.** QFX works in the desktop version. The browser version does not list it, so you need another format. [What to do when the bank only offers a Quicken download](/blog/bank-only-offers-quicken-download) explains what sits inside a QFX file and how it relates to its OFX cousins.
- **Your bank offers only CSV.** Convert the CSV to OFX or QIF, or ask the bank whether another format is hidden under a different export menu.

The same article asks you to pick a dd/mm/yy date format when your bank offers a choice, and to keep each file under 10 MB. A file that large is rare for one account and one month, but a multi-year download can pass it. Split long ranges by month.

## Where is the bank statement import in MYOB Business?

In the browser version of MYOB Business, the bank statement import starts at Banking, then Banking hub. Each account has a three-dot menu, and Import statement is one of its options. The MYOB article gives the full sequence, which ends on an import history page that lists earlier imports.

The steps, as the MYOB article lists them:

1. Go to Banking, then Banking hub.
2. For the account, click the three dots and choose Import statement.
3. On the import history page, click Import statement and select the bank account.
4. Click Import statement file, browse to the file and click Open.
5. Click Import.

Check the bank account selected in step 3 against the account on the statement. The menu you opened in step 2 belongs to one account, but the selection on the import page is what decides where the lines go.

## The MYOB desktop statement import inside Reconcile Accounts

The desktop version of MYOB handles a bank statement file as part of reconciling. You open the Banking command centre, click Reconcile Accounts, choose the account, enter the closing balance and statement date, then click Get Statement and select the file. MYOB then matches the statement lines to your records.

The MYOB article says this matching uses the cheque number, date and amount. Lines that do not match go to an Unmatched Statement Transactions window. For each one, you either match it to an existing transaction or add it as a spend money or receive money transaction.

Two habits help on desktop. Enter the closing balance from the statement itself, not from your online banking on a later day. Work the unmatched list before you close the window, because a skipped line will keep the account from reconciling.

## Why does an MYOB statement import bring in nothing or duplicates?

An MYOB statement import brings in nothing when every line is dated before a date the file is allowed to reach, and it doubles lines when the statement repeats what a bank feed already delivered. The MYOB article covers both, and the fixes differ.

| What you see | Likely reason, per MYOB's help | What to do |
| --- | --- | --- |
| Zero lines imported | Lines dated before the opening balance month (browser) or conversion month (desktop) | Check the opening balance date; older lines cannot come in |
| Zero lines imported | Lines dated before a lock date | Review the lock date in your settings before importing |
| Lines doubled | The statement overlaps transactions already brought in by bank feeds | Delete the import, download a range that starts after the feed, import again |
| File rejected | Wrong file type or over 10 MB | Download OFX or QIF, or split the range |

For a backlog of several months, the MYOB article suggests importing and reconciling one month at a time. It also notes that statements do not need to go in date order, which helps when you find a missing month later.

## Checking imported MYOB statement lines on the Bank transactions page

In the browser version, imported statement lines appear on the Bank transactions page. From there you allocate each line to an account or match it to a transaction you already entered, and the MYOB article notes you can set up rules so repeating lines are handled for you next time.

A quick check after each import:

- **Count the lines.** The number of new lines should equal the number of transactions on the statement for those dates.
- **Read the first and last dates.** They should match the range you downloaded, with no gaps.
- **Compare the closing balance.** After allocating, the account balance should equal the statement's closing balance.

If MYOB is not your only option, other desktop tools read the same files. [Importing a bank statement into GnuCash](/blog/import-bank-statement-into-gnucash) and [importing a bank statement into Moneydance](/blog/import-bank-statement-into-moneydance) show the equivalent screens there.

When the only copy of a month is a PDF statement, a conversion step comes first. SimpleBankConvert is being built to make QuickBooks and Xero files from PDFs; it does not produce MYOB's formats, so check [what it makes](/) before relying on it.