General Ledger + Converter in one subscription.

See pricing
Skip to content
  1. Home
  2. Bank statement converter
  3. MYOB bank statement import

GUIDE · MYOB

Import a bank statement into MYOB,
in the file type it accepts, without duplicates.

To import a bank statement into MYOB Business, download an OFX or QIF file from your bank, go to Banking, Banking hub, click the three dots on the account and choose Import statement. MYOB doesn’t import PDF or CSV statements. When all you have is a PDF, ZeraBooks is the fix: its bank statement converter proves the statement to the cent, and the ZeraBooks general ledger keeps the books straight from PDF statements.

7-day trial · card required, nothing charged for 7 days · 1,000 pages a month from $79/month billed annually

Statements in, proven to the cent.

FILE TYPES

What file format does MYOB accept for bank statements?

MYOB’s help splits the import by how you use MYOB. Checked on MYOB’s support site on October 22, 2026:

MYOB Business in a browserAccountRight on the desktop
Files it imports.OFX or .QIFOFX, QFX, QIF or OFC
PDF or CSV statementNot listedNot listed
File sizeLess than 10MBNo limit given
Date formatChoose dd/mm/yy if the bank asksNo guidance given
Where you startBanking › Banking hub › Import statementBanking command centre › Reconcile Accounts › Get Statement
MatchingLines land on the Bank transactions pageMatched by cheque number, date and amount; the rest go to Unmatched Statement Transactions

If your bank offers both, MYOB’s browser help takes either. ProperSoft’s MYOB guide suggests trying OFX first because QIF is being phased out. MYOB’s data import tool (File › Import/Export Assistant on the desktop) takes lists like cards and items as .txt files, not bank transactions.

We set you up and catch up your past months for free. Then ZeraBooks keeps your books done.

A REAL EXPORT

What does a CommBank statement look like after a Money in and out download?

A real run in ZeraBooks Convert: the fictional CommBank sample statement CommBank_Business_Transaction_7714_Sep2026.pdf, already proven to the cent, downloaded Money in and out as an Excel file. The file that came out, Money in and out - CommBank_Business_Transaction_7714_Sep2026.xlsx, has 13 rows with the columns Date, Description, Money In, Money Out, Balance.

A real export: the CommBank sample statement downloaded Money in and out. Fictional figures.

The format, picked in Convert

The ZeraBooks Convert Download dialog with Money in and out selected for the CommBank statement.
Money in and out picked in the Download dialog.

The file that downloaded

The Money in and out file downloaded from ZeraBooks Convert for the CommBank statement, opened as a spreadsheet: its header row and every transaction.
The downloaded Money in and out file, opened.

MYOB BUSINESS · BROWSER

How do you import a bank statement in MYOB Business?

These are the clicks in MYOB’s current browser help. Download the OFX or QIF from your online banking first, for one account and one date range.

  1. 1

    Open the Banking hub

    Go to the Banking menu and choose Banking hub.

  2. 2

    Pick the account

    Click the three dots (...) on the account and choose Import statement.

  3. 3

    Start a new import

    On the Bank statement import history page, click Import statement and choose the Bank account the lines belong to.

  4. 4

    Choose the file

    Click Import statement file, then Browse, select the .OFX or .QIF and click Open.

  5. 5

    Import

    Click Import. A message at the top says how many statement lines came in. Write that number down.

  6. 6

    Check the count and the balance

    Open Bank transactions and compare the lines with the statement. The statement’s opening balance plus the imported lines should reach its closing balance.

WORKED EXAMPLE

How do you import a backlog of months into MYOB?

Saltbush Coffee is a fictional café on MYOB Business. Its opening balance month is July 2026, and its bank feed started on 1 October. July to September have to come in as statement files. MYOB says to import and reconcile a backlog one month at a time:

FileOpeningMoney inMoney outClosingResult
June 2026 OFX0 lines: before the opening balance month
July 2026 OFX18,240.6024,615.0023,902.3518,953.25Imported, reconciled
August 2026 OFX18,953.2522,980.4024,105.9017,827.75Imported, reconciled
September 2026 OFX17,827.7526,310.0023,448.1520,689.60Imported, ends 30/09
July to September18,240.6073,905.4071,456.4020,689.60

The proof: 18,240.60 + 73,905.40 − 71,456.40 = 20,689.60, which must be the balance the bank feed’s first October line starts from. Each month’s closing is the next month’s opening, so no month is missing. The September file stops on 30 September. A file running from 15/09 to 14/10 would double the feed’s first two weeks of October.

WHEN IT GOES WRONG

Why did my MYOB statement import bring in 0 lines, or too many?

MYOB’s help names these causes. Each one has a quick check.

  • Dated before the opening balance month

    Lines dated before your opening balance month (the Conversion Month on the desktop) are not imported. Saltbush’s June file brought in nothing for this reason. Check the month in your business settings.

  • Dated before a lock date

    A lock date stops new lines on or before it. Move the lock date only if your accountant agrees the earlier period should change.

  • Overlap with the bank feed

    A file whose dates overlap lines the feed already brought in creates duplicates. MYOB’s fix: delete the imported statement, download a file whose dates stop before the feed’s first line, and import again.

  • The wrong file type

    A PDF or CSV isn’t on MYOB’s list. Go back to online banking and look for an export option named OFX, QIF, MYOB or Money.

  • A file over 10MB

    The browser import needs files under 10MB. Download shorter date ranges, which also keeps the one-month-at-a-time habit.

BEFORE YOU IMPORT

What should you check before importing a statement into MYOB?

  • The file is .OFX or .QIF, for one account and one date range, and under 10MB.
  • Dates are dd/mm/yy if the bank asks which format to use.
  • Every line falls in or after the opening balance month and after any lock date.
  • The file’s dates stop before the bank feed’s first line, so nothing comes in twice.
  • The statement’s opening balance plus the lines reaches its closing balance, and each month’s closing is the next month’s opening.

ONLY A PDF

What if my bank only gives me a PDF statement?

It can happen with old months or a closed account. Three routes, from least to most work:

  • Ask the bank for a transaction file

    Ask your bank whether it can export the months you need as OFX or QIF, even if online banking only shows PDFs for them. It is worth one message before converting anything.

  • Keep the books from the PDF in ZeraBooks

    The ZeraBooks general ledger works from uploaded PDF statements. Autopilot categorizes and reconciles each month against the printed balances, so the PDF never has to become a MYOB file at all. How that compares with a desktop OFX converter is on our ProperSoft comparison.

  • Check the PDF, then key the lines

    For a handful of lines, typing them into MYOB is fine. ZeraBooks Convert turns the PDF into a checked spreadsheet first, so you key from a list that adds up to the closing balance instead of from the PDF.

WHERE ZERABOOKS FITS

What ZeraBooks Convert does with a MYOB statement, and what it doesn’t.

ZeraBooks Convert makes Excel and CSV in fixed formats. It does not make OFX, QIF or any MYOB file, and it doesn’t connect to MYOB.

PROVEN TO THE CENT

A PDF checked against its own balances.

Upload the statement PDF and Convert adds every line it read to the opening balance and compares the result with the closing balance printed on the page. A statement that doesn’t add up is marked Needs a look before you download. That is useful before you key a PDF into MYOB, or when you need a year of old statements in a spreadsheet for your accountant. Step by step: convert a bank statement to Excel.

How Convert proves a statement
The statement proof: every account adds up to the statement to the cent, with the opening balance, transactions and closing balance for each account.

ONE THING TO KNOW

Downloads use U.S. dates.

Every ready-made Convert format writes dates as MM/DD/YYYY. Australian and New Zealand users reading the file should keep that in mind: 03/07/2026 in a Convert download is 7 March, not 3 July. If you need a CSV for other software, bank statement to CSV lists the formats.

Choose a download format
The Download dialog: choose a ready-made format such as Standard, QuickBooks-ready or Xero-ready, a file type and how to split the file.

MORE IMPORT GUIDES

Getting statements into other software

QUESTIONS

MYOB bank statement import: common questions

Ask Damin directly
Can I import a CSV bank statement into MYOB Business?

MYOB’s current help for importing statements lists only .QIF and .OFX for MYOB Business in a browser, and OFX, QFX, QIF or OFC for AccountRight on the desktop. CSV isn’t on either list. By contrast, Sage and Wave import CSV bank files.

Can I import a PDF bank statement into MYOB?

No. Ask the bank for a transaction file, or enter the lines by hand from a ZeraBooks Convert spreadsheet that is already proven against the closing balance. You can also keep the books in ZeraBooks, which works from PDF statements directly.

Should I use OFX or QIF for MYOB?

MYOB’s browser import takes either. ProperSoft’s guide recommends OFX first because QIF is being phased out; if you do use QIF, pick dd/mm/yy dates when the bank offers a choice.

How do I remove a statement I imported twice?

MYOB’s help says to delete the imported statement, download a file whose date range doesn’t overlap lines already in MYOB, and import it again. The Bank statement import history page lists past imports.

Does ZeraBooks connect to MYOB?

No. ZeraBooks has no MYOB connection and makes no OFX or QIF files. Convert gives you a checked Excel or CSV of a PDF statement, which helps when you review or key old months, and the ZeraBooks General Ledger keeps the books from the same PDFs.

How much does ZeraBooks Convert cost?

Convert comes with the ZeraBooks subscription: 1,000 pages a month for $79 a month billed annually or $149 monthly (USD), after a 7-day trial. See ZeraBooks pricing.

Damin Mutti, founder of ZeraBooks

About the author

Damin Mutti

Founder of ZeraBooks, Vancouver

Damin founded ZeraBooks in 2025 and still talks to the bookkeepers, firms and owners who use it every week. He writes about what he sees in their statements and ledgers, and every page here is checked against the live product before it goes up.

FREE SETUP + CATCH-UP

Got old statements as PDFs?
Check them to the cent first.

Upload a statement and see whether every line reaches the printed closing balance before you key it anywhere. 1,000 pages a month from $79 a month billed annually. ZeraBooks also includes AI bookkeeping for books kept from statements.

Book a call with Damin

Our founder. 30 minutes on Google Meet. Pick a time on the next screen.

About: Have us do your books