Banks

Convert Commonwealth Bank (CommBank) Statements to Excel

Convert CommBank statement PDFs and NetBank transaction lists to Excel and CSV, with CR and DR read as signs and every balance checked. 15 pages free.

Drop your statement here PDF up to 25 MB. Scans and photos saved as PDF, and password-protected PDFs, work too.

We turn your Commonwealth Bank statement PDF into a spreadsheet with the columns the statement prints, and we check every balance on the way. We read both the statement CommBank issues and the transaction list you can save as a PDF from NetBank.

What a CommBank statement looks like

  • A CommBank statement has five columns: Date, Transaction, Debit, Credit and Balance.
  • The balance carries CR when the account is in credit and DR when it is overdrawn, as in $6,183.66 CR. We read CR and DR as the sign of the balance, so we never take an overdrawn balance for money you had.
  • A card purchase carries its value date in the details, such as Value Date: 28/12/2019. We keep it in the description cell.
  • The date is printed as day and month, such as 03 Jan, with the year left to the statement's period.

What a NetBank transaction list looks like

  • A list saved from NetBank has four columns: Date, Transaction details, Amount and Total. Total is the balance after each transaction.
  • The newest transaction comes first.
  • Each amount and balance carries its sign, as in - $159.06 or
    • $49,528.99, and we read the sign as printed.

What your spreadsheet looks like

Date Transaction Debit Credit Balance Ledger
01 Jan OPENING BALANCE $1,520.00 CR ok
02 Jan A SUPERMARKET SYDNEY NS AUS Card xx1234 Value Date: 30/12/2019 48.20 $1,471.80 CR ok
03 Jan Direct Credit A COMPANY PAYROLL 1,640.00 $3,111.80 CR ok

The rows above are an example, not a real statement.

How we test it

We test against two CommBank statements and one NetBank transaction list, 25 pages in all: 537 transactions. The Ledger column flags 3 of them, and the cause of each is in the PDF itself. In one statement, a balance does not follow from the row before it as printed. In the NetBank list, the page hides the last digit of one balance under a button. We read that balance as you would see it on the page, so the Ledger column flags its row and the row next to it. Every other transaction balances against the row before it.

Convert a CommBank statement

  1. Drop the PDF in the box on this page, and we show you its first page converted.
  2. Sign up with your email address to download it. You do not need a card. Your free trial converts up to 5 pages of a statement, 15 pages in all.
  3. To convert every page, choose a plan on the pricing page.

To bring the transactions into your books, download the file for your accounting software from your list of statements, then import it into Xero, QuickBooks or FreeAgent. You get this file on the free trial and on the Standard and Plus plans. Lite gives Excel and CSV.

Once the statement is in your account, we delete the PDF when its conversion finishes. If you drop it in and do not sign in, we delete it too. Our privacy policy says what we keep, and for how long.

Other banks

We convert other banks' statements too. See every bank page.

Convert your own statement.

We read every row, check every balance, and give you a file for your spreadsheet or your books.