MYOB Bank Statement Converter: PDF to QIF for AccountRight
Convert Australian bank statement PDFs to MYOB QIF format with ReckonFlow. The QIF file imports directly into MYOB AccountRight via Banking → Import → QIF file. Supports ANZ, Westpac, NAB, CBA, and Macquarie statements with full balance verification before export.
Why MYOB Insists on QIF/OFX
MYOB AccountRight was built around the older Quicken Interchange Format (QIF) and the Open Financial Exchange (OFX) standards. Those formats carry the precise field structure MYOB expects: a date, a payee, an amount, and a clear debit/credit flag. CSV files, by contrast, are a free-form spreadsheet export that banks tailor to their own layouts: column order varies, date formats shift between DD/MM/YYYY and YYYY-MM-DD, and some banks lump debits and credits into a single column with a plus/minus sign. When you feed that straight into AccountRight, the import wizard either throws an error or mis-maps the data, leaving you with duplicate transactions or, worse, missing entries that throw off your reconciliation.
Because MYOB's import routine is hard-coded to look for QIF/OFX tags, there's no native CSV-to-QIF bridge inside the software. Bookkeepers therefore need an external tool that can read the bank's PDF or CSV, interpret the columns correctly, and spit out a QIF file that AccountRight will swallow without complaint. The right converter does more than just change the file extension: it normalises dates, separates debits from credits, and preserves the memo field so that each transaction retains its original description.
The "Dodgy Converter" Problem
Jump onto any Australian bookkeeping Facebook group or the MYOB Community forum and you'll see the same refrain: "I tried that free online converter and my QIF came out with all dates as 01/01/1970." Or, "The tool said it succeeded, but half my debits showed as credits." These complaints usually point to converters that:
* Assume a single date format and fail when the bank mixes DD/MM/YYYY with MM/DD/YYYY.
* Guess the debit/credit column based on the presence of a minus sign, which fails when banks use parentheses or separate columns.
* Strip out the memo or reference field, making it impossible to match a transaction to an invoice.
* Produce QIF files with malformed headers that AccountRight rejects outright.
The result is wasted time: you spend ten minutes running the conversion, another ten trying to import, and then you're back at square one, manually re-entering data or chasing the bank for a fresh statement. For a practice juggling twenty-plus clients, those minutes add up quickly, eroding billable hours and increasing stress during BAS season.
How Reliable QIF Conversion Works
A trustworthy converter tackles three core challenges:
1. Date normalisation: It scans the source file, detects the date pattern used (whether DD/MM/YYYY, DD-MM-YY, or YYYY/MM/DD), and converts every entry to the QIF-required format. Some banks embed the date in a narrative line; a good parser will extract it regardless of surrounding text.
2. Debit/credit separation: Rather than relying on a minus sign, the converter looks for explicit debit and credit columns. If only one amount column exists, it applies the bank's convention: outflows are debits, inflows are credits. This logic is essential for Australian banks that render debits with ( suffixes or separate DR/CR columns.
3. Memo preservation: The payee, reference, and any extra notes are copied into the QIF fields. Keeping this information intact means you can still run bank rules or match transactions to invoices after import.
When the converter outputs a QIF file, it begins with the mandatory !Type:Bank header, follows each transaction with the correct D, T, P, M, and ^ delimiters, and ends with a clean !End. AccountRight's import routine recognises this structure instantly, posting each line to the correct account with the correct sign.
Batch Conversion for Practices
For a sole trader, converting one statement a month is a minor inconvenience. For a bookkeeping firm that manages dozens of clients, each with multiple bank accounts and monthly statements, doing conversions one-by-one is untenable. A batch-capable converter lets you:
* Drop a folder of PDFs into the workflow.
* Process all files in a single run, outputting a QIF for each statement.
* Log any files that fail parsing so you can review them individually without stopping the whole queue.
This approach turns what could be an hour-long manual chore into a ten-minute automated step, freeing you to focus on analysis, advisory work, or simply getting home earlier.
Free Trials vs Paid: What's Worth It
Most converters offer a free trial that limits either the number of files you can process or the features available. For a bookkeeper who only needs to convert an occasional statement, a trial might be sufficient. However, professional practices quickly outgrow those limits:
* File caps: If you're processing more than five statements a week, a trial that stops at three files forces you to keep restarting or upgrade mid-month.
* Licensing model: Look for a subscription that includes updates. Banks tweak their statement layouts regularly; a converter that isn't maintained will soon produce broken QIF files again.
When evaluating cost, consider the hourly rate you charge clients. If a paid converter saves you even one hour per month per client, the licence fee pays for itself many times over. For most Australian bookkeeping practices, $29-79/mo is a worthwhile investment that protects both accuracy and billable time.
Practical Steps: PDF to QIF
1. Download the bank statement as a PDF from the client's online banking portal.
2. Upload the PDF: drag and drop it onto the converter. The tool automatically detects it's a CBA statement and extracts the BSB, account number, and period.
3. Review the extracted transactions: you'll see each date, description, debit/credit amount, and the running balance. The balance verification runs automatically: opening + credits - debits = closing.
4. Export as QIF for MYOB: the file includes proper headers, DD/MM/YYYY date fields, separate debit/credit handling, and preserved memo fields. Ready for direct import into AccountRight.
5. Import into MYOB: File → Import Data → Bank Transactions, select the QIF file, and AccountRight reads it without errors.
If the balance verification shows a mismatch (opening + credits - debits ≠ closing), you know there's a problem before you import: no guesswork, no manual cross-checking in Excel.
---
Convert PDF bank statements to QIF for MYOB
ReckonFlow supports MYOB AccountRight QIF export alongside Xero CSV. Upload a PDF and get both formats.