How to Import Bank Statements into MYOB

Quick Answer: To import bank statements into MYOB, convert your PDF bank statement to a MYOB-compatible CSV using QuickBankConvert, then use MYOB AccountRight's Bank Statement Import or MYOB Essentials' Import Transactions feature. MYOB requires a specific CSV format with Date (DD/MM/YYYY), Description, and Amount columns — QuickBankConvert formats the output correctly for Australian banks.

MYOB (Mind Your Own Business) is Australia's most widely used accounting software, with a strong presence in New Zealand as well. Its AccountRight and Essentials platforms handle bank statement imports, but they're specific about format — particularly dates, which follow the Australian DD/MM/YYYY convention rather than the US or ISO format.

This guide covers the full bank statement import workflow for both MYOB AccountRight and MYOB Essentials, including the specific CSV format required, how to convert PDF statements from Australian and international banks, and how to handle reconciliation after import.

MYOB and Bank Statement Management Overview

MYOB offers two approaches to bank data:

1. Bank Feeds (Automatic): MYOB's bank feed service automatically imports transactions from connected Australian banks — ANZ, CBA, NAB, Westpac, and many others. Transactions arrive daily and appear in MYOB ready for reconciliation. This is the preferred ongoing method for supported banks.

2. Manual CSV Import: For banks not supported by MYOB feeds, for historical data, or for any period where the feed wasn't active, manual CSV import is the solution. Both MYOB AccountRight and MYOB Essentials support this.

The CSV import is also essential for businesses with:

• International bank accounts (US, UK, Asian banks)
• Some credit unions and building societies not on the MYOB feed list
• Business accounts excluded from personal banking feed programs
• Historical import requirements (going back before the feed was activated)

Callout: Even if your bank is on the MYOB feed list, manual CSV import is often preferable for historical data. Bank feeds typically only pull 90 days of history when first connected. For older statements, CSV import via QuickBankConvert is your path to getting complete historical records into MYOB.

MYOB CSV Format for Bank Statement Import

MYOB's bank statement import requires a specific CSV structure. The format differs slightly between AccountRight and Essentials:

MYOB AccountRight CSV Format

MYOB AccountRight provides a downloadable template from the import screen — download and use this as your base to avoid format errors.

MYOB Essentials CSV Format

MYOB Essentials accepts a slightly more flexible format but also expects DD/MM/YYYY dates. Some Essentials versions accept separate Credit and Debit columns rather than a single signed Amount column.

Key MYOB requirement: Dates in Australian format (DD/MM/YYYY). This is the most common source of import errors for users who download CSV files from US or international banks, which typically use MM/DD/YYYY or YYYY-MM-DD.

Converting Bank PDFs to MYOB-Compatible CSV

Most Australian banks provide statements as PDFs from their online banking portal. Converting these PDFs for MYOB requires:

1. Extracting transaction data from the PDF structure
2. Formatting dates as DD/MM/YYYY
3. Ensuring amounts use the correct sign convention
4. Removing header/footer content and running balance columns

QuickBankConvert handles all of these automatically for both Australian and international banks. The conversion process:

1. Navigate to QuickBankConvert
2. Upload your bank PDF (ANZ, CBA, NAB, Westpac, or any other bank)
3. Select MYOB CSV as the output format
4. Download the converted file

QuickBankConvert outputs DD/MM/YYYY dates for MYOB output, correctly signed amounts, and clean descriptions that map directly to MYOB's import fields.

For international banks: If your business bank account is with a US, UK, or Asian bank, QuickBankConvert handles those statement formats too, converting dates and formatting amounts to MYOB's requirements.

For credit card statements: Credit card PDF statements work the same way — upload to QuickBankConvert and download the MYOB-formatted CSV. You'll import it into your credit card account journal in MYOB rather than a bank account.

Importing Bank Statements into MYOB AccountRight

Step 1 — Set Up Your Bank Account

Before importing, ensure your bank account is configured in MYOB AccountRight:

1. Go to Lists > Accounts
2. Confirm your bank account exists (Asset type, linked to the correct BSB and account number)
3. If it's a new account, create it with the correct opening balance

Step 2 — Navigate to Bank Statement Import

1. Go to Banking > Bank Statement Import
2. If this is your first import for this account, click Import Bank Statement
3. Select your bank account from the dropdown

Step 3 — Import Your CSV

1. Click Choose File and select your converted CSV
2. MYOB will attempt to auto-detect the column mapping — verify that Date, Description, and Amount are correctly mapped
3. Preview the import and check that:

- Dates are displaying correctly (check both early and late dates in the list)

- Amounts have correct signs (withdrawals negative, deposits positive)

- Transaction count matches your statement

1. Click Import

MYOB adds the transactions to your bank account register as unreconciled items, creating a "bank statement" entry for the imported period.

Step 4 — Reconcile

Go to Banking > Reconcile Accounts and select your bank account. Work through each transaction:

• Match bank statement lines to existing MYOB transactions (customer receipts, supplier payments, payroll)
• Create new transactions for items not yet in MYOB (bank fees, interest, direct debits not yet entered)
• Confirm the closing balance matches your statement

Importing Bank Statements into MYOB Essentials

MYOB Essentials has a slightly different import path:

1. Go to Banking in the left navigation
2. Select the bank account you want to import into
3. Click Import Transactions
4. Upload your CSV file
5. Map columns and confirm the import

MYOB Essentials provides a simpler reconciliation interface — transactions appear in the bank feed view and can be matched to invoices, bills, or coded directly to expense categories.

Essentials tip: If MYOB Essentials shows a "Date format error," your CSV dates are in the wrong format. Use DD/MM/YYYY for Australian Essentials instances.

Bank Reconciliation Workflow in MYOB

MYOB's bank reconciliation confirms that your accounting records match your bank statement. The workflow after import:

Automatic matching: MYOB attempts to match imported statement lines to existing transactions based on amount, date, and payee. Exact matches are suggested automatically — review and accept.

Bank rules: Set up bank rules (Banking > Bank Rules) for recurring transactions like:

• Monthly rent payment → auto-code to Rent expense
• Payroll direct debits → auto-match to payroll journals
• Bank fees → auto-create expense entry

Rules dramatically reduce manual reconciliation work for businesses with predictable recurring transactions.

Unmatched items: For statement lines with no match, you can:

• Search manually for an existing transaction that matches
• Create a new transaction (expense, income, transfer) directly from the reconciliation screen
• Split a single statement line across multiple accounts (e.g., a payment covering two expense categories)

Completing the reconciliation: When all lines are matched or accounted for, MYOB shows a difference of $0 between your statement balance and your MYOB book balance. Click Reconcile to close the period.

Troubleshooting MYOB Bank Import Issues

"Date Format Not Recognized"

The most common MYOB import error. MYOB AccountRight expects DD/MM/YYYY for Australian accounts.

Fix: Ensure your CSV uses DD/MM/YYYY. QuickBankConvert's MYOB output uses this format. If you're manually formatting, use Excel's TEXT formula: =TEXT(A2,"DD/MM/YYYY").

Amounts with Reversed Signs

Deposits appearing as expenses or vice versa.

Fix: MYOB expects negative values for withdrawals and positive for deposits. Check your Amount column sign convention. QuickBankConvert handles this automatically.

Duplicate Transactions After Import

Statement lines appear multiple times in MYOB.

Fix: Each import creates new statement lines — MYOB does not automatically detect duplicates from CSV imports. Before importing, check your bank statement list for the date range and delete any existing statement that covers the same period.

Import Succeeds but Transactions Missing

MYOB imported fewer rows than expected.

Fix: Open your CSV and check for blank Amount fields, rows with text in the Amount column (like "N/A"), or rows with no date. MYOB silently skips unparseable rows.

Callout: Always reconcile your MYOB bank account after every import. If the closing balance after reconciliation doesn't match your bank statement, it signals an import error — either a missing transaction, a duplicated transaction, or an incorrect amount. Catching this immediately after import is far easier than debugging it months later.

For Australian bank statement conversion, visit QuickBankConvert(/). For other accounting software guides, see our articles on [Manager.io and Odoo.