Convert BOQ statements to Excel or CSV
There are two ways into BOQ online banking, myBOQ and Classic Internet Banking, and each has its own statement screens. Either way, the statement arrives as a PDF. Whether you're a sole trader doing your own books or an accountant reconciling a client's accounts, the job is the same: get those statements into a spreadsheet. Upload the PDF and download Excel, CSV or an accounting-ready file.
Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.
Several statements? Drop up to 100 at once: one payment for all of them, priced by their total pages.
98% of numbers correct on 82 hand-checked pages How we measure
How to get your BOQ statement into Excel
-
Download the PDF statement from BOQ online banking
- Log in to myBOQ Internet Banking or the myBOQ app.
- In Internet Banking, select 'Statements' and choose an account from the drop down, or select an account and click 'View Statements'; in the app, tap the 'Profile' icon and then 'Statement and documents'.
- Select the 'View' or 'Download' option for the statement (in the app, select the statement and tap the 'Share icon').
- Save the statement for the period you need as a PDF.
-
Upload it here
Scans and phone photos work too.
-
Download Excel, CSV, or QuickBooks and Xero CSV
Check the rows against the statement, then export.
Sample result
Your BOQ statement in Excel
Made-up sample rows, not a real statement.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 2026-01-02 Salary - Example Employer Ltd | Salary - Example Employer Ltd | 2,500.00 | 3,500.00 | |
| 2026-01-05 Card payment - Sample Grocery Co | Card payment - Sample Grocery Co | 120.00 | 3,380.00 | |
| 2026-01-09 Rent - Placeholder Properties | Rent - Placeholder Properties | 1,200.00 | 2,180.00 | |
| 2026-01-14 Transfer from savings | Transfer from savings | 300.00 | 2,480.00 | |
| 2026-01-20 Utility bill - Demo Energy Co | Utility bill - Demo Energy Co | 80.00 | 2,400.00 | |
| 2026-01-27 Card payment - Fictional Coffee Co | Card payment - Fictional Coffee Co | 15.00 | 2,385.00 |
Statement notes
What to know about BOQ statements
Interim statements overlap
You can request an interim statement that runs from your last statement date to today. It is handy mid-cycle, but when the next regular statement arrives, both files cover the same days. Upload them together and the overlap is flagged, so shared transactions aren't counted twice in your spreadsheet.
Two platforms, one kind of PDF
The myBOQ guides cover viewing and downloading statements, while the Classic Internet Banking FAQs also describe exporting transaction history as .dat, .csv or .qif after a search. Whichever platform you use, statement PDFs convert the same way, and Classic keeps a minimum of seven years of them.
Two columns become one amount
The statements show debits and credits in separate columns next to the balance. The converter writes a single signed amount for each transaction, negative for payments out, and makes sure the rows add up from the printed opening balance to the closing one.
Long descriptions
Card and transfer descriptions can carry on to a second line. Copy-paste turns that into an extra row; the conversion keeps the full description with its transaction instead, which makes matching and bank rules in your accounting software far less fiddly.
Output and review
From BOQ PDF to your books
Accounting tip
QuickBooks Online in Australia accepts .csv uploads in a three-column Date, Description and Amount layout, which is how the QuickBooks-ready file is built. Intuit recommends dd/mm/yyyy dates, and that is how the file writes them; if your QuickBooks company reads dates another way, change Date format in the export menu before downloading.
-
Checked before export
Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.
-
Export formats
Excel, CSV, JSON, or QuickBooks and Xero CSV.
-
Private workspace
HTTPS uploads, kept private until you ask support to delete them.
FAQ
BOQ statement questions
Can I export BOQ transactions to CSV?
I uploaded an interim and a regular statement. Why the warning?
Can I import converted BOQ rows into QuickBooks or Xero?
Convert your BOQ statement to Excel
Page 1 free, no sign-up to see it; just an email to download.
More Bank Statement Converters
pdf2text is independent and not affiliated with or endorsed by BOQ.