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
- Drop the PDF in the box on this page, and we show you its first page converted.
- 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.
- 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.
Read next
- Bank Statement Codes: What DD, BGC, FPI and the Rest Mean
- Why a Converted Bank Statement Does Not Balance
Other banks
- Convert ANZ Bank Statements to Excel
- Convert ICICI Bank Statements to Excel
- Convert Metro Bank Statements to Excel
- Convert Monzo Bank Statements to Excel
- Convert Nationwide Bank Statements to Excel
- Convert HSBC Bank Statements to Excel
- Convert Lloyds Bank Statements to Excel
- Convert NatWest Bank Statements to Excel
- Convert Santander Bank Statements to Excel
- Convert TSB Bank Statements to Excel
- Convert Virgin Money Bank Statements to Excel
We convert other banks' statements too. See every bank page.