Financial Documents

Bendigo Bank Statement to Excel: Adelaide Bank and RACQ Bank

Bendigo e-banking exports 18 months of transactions and keeps seven years of PDFs. How to get the full history into Excel, with Adelaide Bank and RACQ Bank.

Published
Updated
Reading time
15 min
Topics:Financial DocumentsBank StatementsAustraliaBendigo BankAdelaide BankRACQ BankExcelXeroMYOBAgrimasterBAS preparationBendigo e-bankingBendigo bank statement to ExcelBendigo transactions older than 18 months

Bendigo e-banking downloads the past 18 months of an account's transactions from its Activity tab, as a standard or extended CSV, QIF, OFC or BAI2 file. Anything older than 18 months is only in the e-statements, which Bendigo keeps as PDFs in e-banking for up to seven years on an open account.

So getting a Bendigo Bank statement to Excel depends on the period. A recent BAS quarter is one CSV download. A catch-up of several years is two sources: the export for the last 18 months, and the PDF statements, converted, for everything before it, joined in one sheet and checked against each statement's printed opening and closing balances.

A growing share of that history did not start at Bendigo. Adelaide Bank's accounts moved onto Bendigo's systems in December 2025, with new account numbers for its home loan and offset customers, and RACQ Bank's customers became Bendigo customers over the weekend of 13 to 15 November 2026. For those clients, one financial year can hold the same account under two numbers and two statement designs.

Downloading Transactions from Bendigo e-banking, and Which of the Six Formats to Pick

Bendigo's e-banking accounts support page sets out the download:

  1. Select the account.
  2. Choose Download on the Activity tab, or go to settings and choose Download Transactions.
  3. Set the date range. In Bendigo's words, "the past 18 months is available".
  4. Choose a format and download.

The format menu has six entries, and two of them exist for very particular readers:

Bendigo's labelWho it is for
CSV Standard FormatAnyone opening the file in Excel or Google Sheets. This is the one a spreadsheet job wants.
Extended CSV Format – Suitable for Agrimaster and PhoenixFarm clients whose books run in Agrimaster or Phoenix, the rural accounting packages.
Microsoft Money Format (OFC)Only a client still keeping their accounts in Microsoft Money.
Quicken Format (QIF) – Suitable for Quicken and MYOBA Quicken file, or an import into MYOB.
Classic Quicken Format (QIF) - Suitable for older softwareOlder software, in Bendigo's words. Try it only if the current QIF will not import.
BAI2 FormatCorporate cash-management and treasury systems. BAI2 is a bank-reporting standard, and seeing it on a retail bank's menu is unusual.

For bookkeeping, set each download's range to a period you report on: a BAS quarter, a half-year, or a whole financial year while it still fits inside the window. Files cut that way line up with the returns they feed, and nothing falls between two downloads or lands in both. Use one format for every download in a job, so the files combine without reformatting.

The window rolls. Bendigo's page points beyond it: "To view transactions that are not available for download, you can access your statements online in e-banking." A quarter that is inside the 18 months today will be outside it later, so download a period the books may need while it is still reachable rather than when the question comes up.

Other Australian banks set different limits: Macquarie issues its deposit-account statements every six months, so the guide to Macquarie bank statements to Excel deals with a long statement rather than a short window.

Past 18 Months: A Seven-Year Catch-Up Worked Through

Beyond the download window, the record is the e-statement. Bendigo's e-statements support page covers how far they go:

  • Where: Accounts, then the Statements tab. Each statement downloads as a PDF.
  • How far back: "Statements for open accounts are available in e-banking for up to seven years."
  • Closed accounts: "please visit your local branch".
  • Interim statements: not self-serve. Call 1300 236 344 or visit a branch, and the statement is "generated overnight and can be accessed in e-banking the next day".

Put dates on that. It is mid-November 2026, and a client needs every transaction from 1 July 2020, the start of FY2020-21, for a catch-up of unlodged years.

PeriodSourceForm
1 July 2020 to about May 2025E-statements onlyPDF
About May 2025 to the last statement's closing dateThe download, or the e-statementsCSV (or another of the six formats), or PDF
Since the last statement closedThe download, or an interim statementCSV, or PDF the next day

Close to five years of that history, July 2020 to about May 2025, exists only as PDFs. Had the client also needed FY2019-20, its first months, July to about November 2019, would already be past the seven years. Those months, and any statement for an account that has since closed, have no self-serve route on Bendigo's pages: the branch is where to ask.

Making the join

The last 18 months exist both ways, which gives you room to choose where the PDFs stop and the download starts. Pick a statement whose closing date falls inside the window, take the PDF rows up to and including that date, and start the download on the next day. Every transaction then comes from exactly one source, and none is counted twice at the seam.

There is a second option: take the whole run from the PDFs. One source means every row sits under a statement with printed balances to check it against, and no join at all. The cost is the stretch since the last statement closed, which needs an interim statement. The download earns its place when the client's package wants one of Bendigo's file formats, or when the job is only the last year or so.

Checking the result

The statements check themselves, once their transactions are in a sheet:

  • For each statement, the opening balance plus credits minus debits equals the printed closing balance.
  • Each statement's closing balance equals the next statement's opening balance.
  • A break in that chain is a missing page or a missing statement, and the statement period shows where.
  • At the join, the closing balance of the statement where the PDFs stop, plus the download's credits less its debits, should arrive at the account's current balance in e-banking (not the available balance, which counts pending items).

Over five years of statements, that chain is what tells you the history is complete. The full method for reconciling transactions against statement balances, including how to chase a difference, is in its own guide.

Turning the PDF Years into One Sheet

Five years of statements is a long run of PDFs per account, and copying from them does not scale. A multi-line description splits across cells when pasted, every page break restarts the tidy-up, and dates pasted from a PDF often land in Excel as text that sorts alphabetically. Over a run that long, a statement's layout can also change, so the same column does not always sit in the same place.

The sheet to aim for has one row per transaction:

  • date, description, debit, credit and running balance, in one date format throughout
  • the account number and the statement period on every row
  • each statement's printed opening and closing balance, so the balance chain from the catch-up check runs inside the sheet itself

With the period on every row, any transaction traces back to the statement it came from, and a query about one month filters down to one statement.

Our extraction assistant is built for this part of the job. Upload the Bendigo e-statements as they are, digital or scanned, five years of them as one task (up to 6,000 files), and describe the sheet you want in plain words. For example:

One row per transaction: date, description, debit, credit, balance. Add the account number and the statement period to every row, and each statement's opening and closing balance. Format dates as DD/MM/YYYY.

An empty prompt box also offers ready-made prompts for bank statements, set up for one row per transaction. They are general rather than written for Bendigo, so adjust one to the columns above and save it to your Prompt Library for the next client who banks there.

The results download as Excel, CSV or JSON. In Excel, numbers come through as numbers and dates as dates, so the balance-chain formulas work straight away. Every row carries a Source File column with the file and page it came from. A value or a row the panel of AI agents cannot agree on is flagged as Review Needed, with what to check, and a page that cannot be processed is reported, never skipped in silence. That is what makes it practical to convert Bendigo PDF statements to Excel for a five-year catch-up: the balance chain tells you whether anything is missing, and the Source File column tells you which page to open when a figure needs checking.

The output stops at Excel, CSV and JSON. It does not produce QIF, OFC, BAI2 or Bendigo's Extended CSV. If a client's package needs one of those files, Bendigo's own download is the route for the last 18 months. For the older periods, check what the package's own spreadsheet import takes: a Structured Prompt fixes the exact column headers in the exact order, which is how you match a layout another system imports.

Bank Feeds to Xero, MYOB and QuickBooks Begin with a Signed Form

For the months ahead, a bank feed is the right way to get a Bendigo account into the books. It is not instant, though, and it is not a history. Bendigo's data feeds page sets out the three routes:

  • Xero: "download the application form from Xero", then "sign and email it to Xero". Bendigo says feeds start "in 10 working days".
  • MYOB: the "MYOB BankLink Authority Form which is available from participating accountants or via MYOB's online accounting systems".
  • QuickBooks Online: a prompt inside QuickBooks, then a form to print, sign and email to SISS Data Services.

Each is a form, a signature and a wait. Bendigo's page says nothing about how much past activity a new feed brings with it, so do not plan on it bringing any. Treat the periods the books need before the feed's first transaction as yours to supply: from the download if they fall inside 18 months, from the e-statements if they do not. Once the feed is live, check the date of its first transaction before importing anything for the weeks around it, or the same transactions arrive twice.

For those earlier periods, the import is a manual one. Bendigo labels its QIF as suitable for MYOB, so a period inside the window can go straight from the download. A period outside it goes in from the converted sheet, used as a staging file and imported a period at a time, so each import can be checked against that statement's closing balance. In every case the spreadsheet feeds the import; nothing posts to the ledger by itself.

The step-by-step, including the file types each package accepts, is in the guides to importing bank statements into Xero and importing bank statements into MYOB.

Adelaide Bank Accounts Moved to Bendigo in December 2025 with New Numbers

Bendigo spent six years folding its banks into one. Its media release of 10 December 2025 reports core banking cut from eight systems in 2019 to one, and brands cut from 13 to two main customer-facing ones, Bendigo Bank and Up. The last step was Adelaide Bank: "more than 180,000 Adelaide Bank customer accounts" migrated in the week before the release.

Bendigo's changes booklet for Adelaide Bank home loan and offset customers sets out what changed for the records:

  • "From the transition date the BSB for your accounts will be 633 000."
  • Each account held received a new account number.
  • "Statements of account issued to you prior to the transition date that were available through Adelaide Bank Online Banking will be available in Bendigo e-banking after the transition date."

So those Adelaide Bank statements now sit in Bendigo e-banking, as PDFs, beside the Bendigo ones. What the booklet does not say is whether transactions from before the move can be downloaded through Bendigo's 18-month window. Work from the statements, which are documented, and treat any download covering the Adelaide months as something to confirm against them.

For the books, FY2025-26 is where the move shows. An Adelaide Bank offset account's year runs from July to early December 2025 on Adelaide Bank statements under the old account number, then on Bendigo statements under the new number to 30 June 2026. Two statement designs, two numbers, one account.

Build the year so the sheet knows that:

ColumnWhat it holds
AccountOne stable label for the account, the same on every row
Account numberAs printed on the statement the row came from, old or new
Statement periodAs printed on that statement
Date, description, debit, credit, balanceOne format for every row, whichever bank's design the statement used

The account label is what lets a SUMIFS or a pivot table treat the year as one account, while the number column keeps each row traceable to the statement it came from. Then run the balance chain across the move: the closing balance on the last Adelaide Bank statement should open the first Bendigo statement, or appear on it as a transfer in. If it does neither, find out why before the year is lodged.

RACQ Bank Customers Became Bendigo Customers on 15 November 2026

Bendigo and Adelaide Bank bought RACQ Bank's retail loan and deposit books, and RACQ Bank's customers moved to Bendigo with them. According to the ACCC's register entry for the RACQ Bank acquisition, RACQ Bank served approximately 90,000 customers, with A$2.7 billion in retail loans and A$2.5 billion in retail deposits as at 30 June 2025. The ACCC approved the acquisition, publishing its determination on 28 April 2026.

RACQ set the move for a single weekend. RACQ's banking pages give the transition as running from 12.00pm AEST (Queensland time) on Friday 13 November 2026 to 8.00pm AEST on Sunday 15 November 2026. After it, RACQ Bank accounts "will be permanently closed and can no longer be used", and "Bendigo Bank will contact RACQ Bank members directly with new banking details, including new account details".

What neither RACQ's pages nor Bendigo's say, as of mid-November 2026, is how a former RACQ Bank customer gets their past RACQ statements, their transaction history or their feeds after the move. Bendigo did bring Adelaide Bank's old statements into e-banking, as the previous section sets out, but that was Bendigo's arrangement for Adelaide, not a published commitment for RACQ Bank.

For a bookkeeper with RACQ Bank clients, the plan works from what is known:

  1. Collect what the client already has. Any RACQ statements and exports they saved before the transition are the first source for the pre-move months.
  2. Ask for what is missing. For any pre-move statement the books need and the client does not have, ask RACQ or Bendigo directly, and keep what they send with the client's records.
  3. Take Bendigo's records from 15 November. Statements and downloads under the new account details, from Bendigo e-banking.

FY2026-27 then runs across two banks. July to the transition weekend of 13 to 15 November 2026 sits on RACQ Bank statements under the old account details, and after it on Bendigo statements under the new ones. For a quarterly GST payer the October to December 2026 quarter straddles the move (for a monthly payer, November does), so that BAS period needs transactions from both banks.

Build the year as the Adelaide Bank case is built, with one more column: the bank, alongside the stable account label, the account number as printed and the statement period on every row. Run the balance chain across the move, from the last RACQ closing balance to the first Bendigo statement, and explain any difference before the quarter is lodged. RACQ and Bendigo PDFs can go into the same task in our extraction assistant, with the prompt asking for the bank, the account number and the statement period on each row, and they come back in the same columns and formats.

RACQ Bank is not the only Australian brand whose history now crosses a move. Westpac is moving the commercial accounts behind St.George, Bank of Melbourne and BankSA statements onto its own brand, and Suncorp Bank's customers move to ANZ during 2027. The guide to Suncorp Bank statements from before the move to ANZ covers that one while it is still ahead.

Extract invoice data to Excel with AI

Upload your invoices, say what you need in plain words, and download the spreadsheet.

  • A panel of AI agents has to agree on every value
  • What the panel cannot agree on is flagged as Review Needed
  • 50 free pages every month, no subscription
  • Any layout, any language, scans and phone photos
  • Numbers come through as numbers and dates as dates
  • Files encrypted and deleted within 48 hours