MYOB BankStatement ImportComplete Guide.
Import bank statements into MYOB AccountRight and MYOB Business with 99.6% accuracy. Convert PDF statements to MYOB-formatted CSV, set up bank feeds, and automate transaction categorization for faster reconciliation.
"Handles all kinds of messy PDFs from different banks. Saves me probably 10 hours a week."
Ashish Josan, Manager CPA — Manning Elliott
TL;DR
MYOB bank statement import accepts CSV, OFX, and QIF formats via manual upload or direct bank feeds (AU/NZ banks only). PDF bank statements require conversion first. Zera Books converts PDF bank statements to MYOB-formatted CSV at 99.6% accuracy with AI transaction categorization, multi-account auto-detection, and batch processing of 50+ statements at once — all for $79/month unlimited.
MYOB Versions and Import Options
MYOB offers two main products with different bank statement import capabilities. Understanding which version you use determines your import method. Both products serve the Australian and New Zealand accounting market, which makes MYOB the dominant accounting platform in the ANZ region.
MYOB AccountRight
Desktop + Cloud Hybrid
Import formats: OFX, QIF, CSV
Bank feeds: Via BankLink or manual import
Best for: Larger firms with complex chart of accounts
MYOB Business
Cloud-Only
Import formats: Bank feeds, CSV
Bank feeds: Direct bank feeds (AU/NZ banks)
Best for: Small businesses wanting automated feeds
Both MYOB versions support CSV imports, making CSV the universal format for bank statement imports. If your bank provides PDF-only statements — common with smaller regional banks — you need a conversion tool. Our accounting integrations guide covers how Zera Books connects with MYOB and other platforms.
Step-by-Step MYOB Bank Statement Import
Follow these six steps to import bank statements into any MYOB version. The process covers PDF conversion, CSV formatting, and reconciliation. Accountants processing statements for multiple clients can reference the best bank statement converter for CPAs for batch workflow tips.
Export Statement from Your Bank
2 minutesDownload your bank statement as PDF or CSV from your online banking portal. Most banks offer monthly or custom date range exports.
Convert PDF to MYOB-Formatted CSV
30 secondsIf your bank only provides PDF statements, use Zera Books to convert them to MYOB-compatible CSV. The AI extracts transactions, detects accounts, and formats columns automatically.
Open MYOB Bank Import
1 minuteIn AccountRight: Banking > Bank Feeds > Import Statement. In MYOB Business: Banking > Bank Transactions > Import Statement. Select the target bank account.
Map Columns and Verify Format
2-3 minutesMYOB expects Date (DD/MM/YYYY for AU/NZ), Amount (positive for credits, negative for debits), and Description columns. Map your CSV columns to match.
Review and Import Transactions
1-2 minutesPreview the transaction list for accuracy. Check date ranges to avoid duplicates with existing entries. Click Import to load transactions into your bank register.
Categorize and Reconcile
5-15 minutesMYOB matches imported transactions against existing records. Assign categories to uncategorized items. With Zera Books pre-categorization, 85-90% of transactions arrive already mapped.
Pro tip: For firms processing multiple client statements, Zera Books batch processes 50+ statements at once. Upload all client PDFs, and Zera Books outputs individual MYOB-formatted CSVs per client account.
MYOB CSV Format Requirements
MYOB is strict about CSV formatting. Mismatched date formats or incorrect column headers cause import failures. Here are the exact requirements for a successful MYOB bank statement CSV import.
| Field | Format | Notes | Required |
|---|---|---|---|
| Date | DD/MM/YYYY | Australian/NZ format required. US format (MM/DD/YYYY) causes errors. | |
| Amount | Numeric (e.g., -150.00) | Single column: negative = debit, positive = credit. Or use separate Debit/Credit columns. | |
| Description | Text (max 255 chars) | Transaction narrative. Remove special characters that cause encoding errors. | |
| Reference/Cheque No | Alphanumeric | Optional but helps with reconciliation matching. | Optional |
| Category/Account | MYOB account code or name | Pre-mapping categories speeds up reconciliation by 70-80%. | Optional |
Zera Books automatically formats output CSVs to match MYOB requirements — correct date format, clean descriptions, and proper encoding. This eliminates the most common import errors MYOB users encounter. For a broader look at converting PDFs to accounting-ready formats, see our best PDF-to-CSV converter guide for accounting.
Bank Feeds vs Manual CSV vs Zera Books
Three approaches exist for getting bank data into MYOB. Bank feeds work for supported AU/NZ banks. Manual CSV import works universally but requires formatting effort. Zera Books automates the conversion and categorization for any bank worldwide.
| Feature | MYOB Bank Feed | Manual CSV | Zera Books + MYOB |
|---|---|---|---|
| Import Method | Automatic daily sync | Manual file upload each time | Batch convert PDFs, upload formatted CSV |
| Bank Support | Major AU/NZ banks only | Any bank (if CSV export available) | Any bank (PDF statements from any bank) |
| Setup Time | 5 min + 24-48hr first sync | 10-15 min per statement | 30 sec per statement (batch: 2 min for 50) |
| Transaction Categorization | Rules-based in MYOB | Fully manual | AI pre-categorized before import |
| Multi-Account Handling | One feed per account | One file per account | Auto-splits combined PDF into separate files |
| Historical Statements | Limited to 90 days back | Depends on bank export range | Any PDF, any date range |
| Cost | Included in MYOB plan | Free (manual labor cost) | $79/month unlimited |
For practices that manage clients across multiple banks — including international banks that MYOB feeds do not support — Zera Books fills the gap. Compare this approach with other bank statement converter tools to evaluate your options.
Troubleshooting MYOB Import Errors
These are the five most common MYOB bank statement import errors, ranked by frequency. Each includes the root cause and fastest fix.
Date Format Mismatch
Cause: CSV uses MM/DD/YYYY instead of DD/MM/YYYY
Fix: Convert dates to DD/MM/YYYY before import. Zera Books auto-detects and reformats.
Duplicate Transactions
Cause: Overlapping date ranges between imports
Fix: Check your last import date in MYOB before uploading. Never overlap date ranges.
Encoding Errors (Special Characters)
Cause: Non-UTF-8 characters in bank descriptions
Fix: Save CSV as UTF-8 encoding. Zera Books cleans descriptions automatically.
Amount Column Not Recognized
Cause: Currency symbols ($) or comma separators in amount field
Fix: Strip currency symbols and use period as decimal separator (1234.56 not $1,234.56).
File Too Large
Cause: Importing more than 12 months of transactions at once
Fix: Split into monthly files. Or use batch processing to prepare multiple smaller imports.
Automating MYOB Imports with Zera Books
Zera Books eliminates the manual conversion step between receiving bank PDFs and importing to MYOB. Here is how the automated workflow compares to the manual process for a typical bookkeeping firm processing 20 client bank statements per month.
Manual Process
- Download PDF from bank portal (2 min per client)
- Copy-paste transactions to Excel (15-30 min per statement)
- Reformat dates and amounts for MYOB (5-10 min)
- Manually categorize each transaction (20-40 min)
- Import and reconcile in MYOB (10-15 min)
Total: 52-97 minutes per statement × 20 clients = 17-32 hours/month
Zera Books + MYOB
- Upload all 20 client PDFs at once (2 min total)
- AI extracts, categorizes, and formats all statements (1 min)
- Download MYOB-formatted CSV per client (1 min)
- Import each CSV to MYOB (2 min per client)
- Review pre-categorized transactions (3-5 min per client)
Total: 5-7 minutes per statement × 20 clients = 1.7-2.3 hours/month
ROI for MYOB Users
At an average bookkeeping rate of $50-80/hour, saving 15-30 hours/month translates to $750-2,400/month in recovered billable time. Zera Books costs $79/month — a 9-30x return on investment. For firms managing more clients, the month-end close solution shows how to build this into your recurring workflow.
Frequently Asked Questions
What file formats does MYOB accept for bank statement import?
MYOB AccountRight accepts OFX, QIF, and CSV. MYOB Business supports bank feeds and CSV uploads. For PDF bank statements, convert to CSV first using Zera Books for 99.6% accuracy.
How do I import a CSV bank statement into MYOB?
In AccountRight: Banking > Bank Feeds > Import Statement. In MYOB Business: Banking > Bank Transactions > Import Statement. Select your CSV, map the Date/Amount/Description columns, and click Import.
Can I automate bank statement imports into MYOB?
MYOB Business supports automatic bank feeds for major AU/NZ banks. For banks without feed support, batch-convert PDFs with Zera Books. Upload 50+ statements, get MYOB-ready CSVs with AI categorization in under 2 minutes total.
Why do my MYOB bank statement imports fail?
The most common cause is incorrect date format. MYOB expects DD/MM/YYYY for Australian/NZ accounts. Other causes include currency symbols in amount columns, non-UTF-8 encoding, or overlapping date ranges creating duplicates.
What does Zera Books cost for MYOB bank statement import?
$79/month for unlimited conversions. No per-page fees, no volume limits. Includes AI categorization, multi-account detection, batch processing, and export in MYOB CSV format. Try it for one week to test with your actual bank statements.
Table of Contents
$79/month after trial
"We were drowning in bank statements from two provinces and multiple revenue streams. Zera Books cut our month-end reconciliation from three days to about four hours."
Manroop Gill, Co-Founder — Zoom Books
Related Integration Guides
QuickBooks Bank Statement Import
Import PDF statements to QuickBooks Online with QBO format or direct API integration.
Xero Bank Feed Setup Guide
Configure direct bank feeds, troubleshoot connection issues, and set up manual imports in Xero.
Sage Intacct Bank Statement Integration
Import bank transactions to Sage Intacct with CSV or API-based bank feed connections.
Wave Bank Statement Import
Convert PDF bank statements for Wave accounting with auto-formatted CSV exports.
FreshBooks Bank Statement Integration
Import bank data to FreshBooks with automated CSV conversion and categorization.
Bank Reconciliation Guide
Learn the reconciliation process, common errors, and how automation reduces month-end close time.
Ready to Automate Your MYOB Bank Imports?
Convert any PDF bank statement to MYOB-formatted CSV with 99.6% accuracy. AI categorization, multi-account detection, and batch processing included. $79/month unlimited.