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.

See pricing

98% of numbers correct on 82 hand-checked pages How we measure

How to get your BOQ statement into Excel

  1. 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.
    Go to BOQ Online Banking
  2. Upload it here

    Scans and phone photos work too.

  3. 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.

sample-statement-2026-01.xlsx Jan 2026 · AUD
Sample bank statement rows with made-up data, amounts in AUD
Date Debit Credit Balance
2026-01-02 Salary - Example Employer Ltd 2,500.00 3,500.00
2026-01-05 Card payment - Sample Grocery Co 120.00 3,380.00
2026-01-09 Rent - Placeholder Properties 1,200.00 2,180.00
2026-01-14 Transfer from savings 300.00 2,480.00
2026-01-20 Utility bill - Demo Energy Co 80.00 2,400.00
2026-01-27 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.

    Files for QuickBooks Online

    Files for Xero

  • Private workspace

    HTTPS uploads, kept private until you ask support to delete them.

FAQ

BOQ statement questions

Can I export BOQ transactions to CSV?
The Classic Internet Banking FAQs describe exporting transaction history as .dat, .csv or .qif after a Transaction History search. The myBOQ guides only cover viewing and downloading statements. If you're on that platform, or need a period covered by statements, convert the statement PDF here.
I uploaded an interim and a regular statement. Why the warning?
An interim statement covers the days since your last statement, and the next regular statement covers many of the same days. The warning is the overlap check doing its job. Keep the regular statement for those dates and drop the interim rows, or exclude the interim file from the export.
Can I import converted BOQ rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your BOQ statement to Excel

Page 1 free, no sign-up to see it; just an email to download.

pdf2text is independent and not affiliated with or endorsed by BOQ.