Bank Statement Converter for MYOB — Import a PDF Statement

When you'd convert rather than rely on the feed

A live bank feed is the norm in MYOB now, but it has blind spots:

• Before the feed existed. You connected the feed recently, but need the months before it for a full year or a catch-up.
• An unlinked account. A savings, loan or second trading account that isn't on a feed.
• Onboarding a client. A bookkeeper taking on a business has PDFs, not a feed, for the history.

You already hold the statement PDFs in those cases, so converting them is far quicker than manual entry — and it means the reconciliation starts from complete data.

From PDF to a MYOB import

1. Download each statement as a PDF from your bank — CommBank's NetBank, Westpac, NAB, ANZ and the rest keep them in online banking.
2. Convert it to a CSV. Every transaction comes back as a row — date, description, debit, credit and balance — with the closing figure checked.
3. Import into MYOB. In MYOB Business, bring the CSV in through the bank transactions area; in AccountRight, use Import Bank Statements. You map the date, description and amount columns once.
4. Match and reconcile. The lines land in the account ready to allocate and reconcile as usual.

What the converter handles that a copy-paste won't

Australian statements often wrap a long payee or a BPAY reference onto a second line. Pasted into a spreadsheet, that overflow becomes a stray row and the debit and credit columns slide out of step — which shows up in MYOB as a reconciliation that won't balance. The converter joins each wrapped line back to its transaction, so the columns stay aligned and the import matches the statement.

It also checks the maths before you download: opening balance, plus credits, minus debits, has to reach the closing balance. That catches a line dropped between pages before it becomes an unreconciled difference in MYOB.

Getting the columns right

MYOB's import wants a clean date, description and amount. The converted CSV gives exactly that, one row per transaction, so the column mapping is straightforward and MYOB doesn't reject the file for a stray line or a merged cell. If you'd rather work in Excel first — to split a mixed personal-and-business account, say — you can, then import the tidied CSV.

Reconciling once it's in MYOB

With the transactions imported, MYOB's reconciliation is the familiar one — match each bank line to a bill, an invoice or a spend-money entry, and the reconciled balance should agree with the statement. A clean conversion smooths that in two ways. First, the closing balance was already checked during the conversion, so if MYOB won't balance, the problem is in your matching rather than a missing bank line — which narrows the search straight away. Second, if the account mixes business and personal spending, it's easier to split it in the CSV before importing: flag the personal lines in a column, filter them out, and import only the business transactions, so MYOB isn't cluttered with drawings you'll only have to unpick later.

There's a timing benefit too. Because the converted months arrive complete, you can reconcile a whole catch-up period in one sitting rather than discovering halfway through that a statement is missing. For a bookkeeper bringing a new client onto MYOB, that means the historical reconcile is a single, predictable job instead of a series of stops to chase paperwork.