suncorp bank statement example

Banking activity and insurance premiums are different records

An insurance premium paid from a Suncorp bank account appears on the bank statement as an outgoing payment, exactly like any other direct debit. It is not an insurance record: the policy documents live separately and carry the cover details, the policy number and the renewal terms. The statement only knows that money left the account.

When you categorise, record the premium as an expense from the bank's perspective and keep the policy reference in your own column if you need it. Do not expect the statement to carry cover information.

Recurring premiums are usually direct debits

Premiums typically arrive as recurring direct debits, which means the amount can change at renewal without a new arrangement being set up. A premium that rose between one year and the next will show as the same payee with a different amount, and nothing on the statement explains why.

Match recurring items by payee and date rather than by amount, and check an annual change against the policy documents rather than against the bank statement.

BSB, account number and BPAY references

The account is identified by BSB and account number, both of which belong in text fields; BSBs commonly carry a leading zero that a numeric import will remove. BPAY payments add a biller code and a customer reference, both numeric in appearance and both needing the same treatment.

Setting these columns to text before import is faster and more reliable than repairing them afterwards, which in most cases is not possible at all.

Card spending and transfer activity

Card purchases post after authorisation, transfers through the fast payment system settle quickly and may identify the counterparty by PayID, and withdrawals reduce the balance on the day. Each has a different relationship to the statement's closing date.

Reconcile on the printed posting dates. Apparent gaps near the period boundary are usually transactions that settled into the next statement.

Where the Suncorp statement period ends

The period's movement has to join the two printed balances without a remainder. Recompute any printed running balance row by row; the first divergence is the row to investigate and nothing after it needs checking until that is resolved.

Verify the transaction count as well as the totals before building any analysis.

Getting the documents

Download the bank statement for the account and period from your own Suncorp online banking or app. Insurance documents come from the insurance side of the relationship and are separate files with separate purposes.

Keep each PDF with the data you derive from it.

Banking and insurance around this suncorp bank statement example

The premium row is listed separately because it is the field most often expected to carry information it does not.

With insurance debits categorised apart, confirm:

• Premium payments are categorised as expenses without expecting policy detail
• BSB and BPAY references kept every digit through import
• Recurring items were matched by payee and date, not by amount

A banking-only customer's simpler categories

A banking-only relationship produces a simpler categorisation problem, which is a useful comparison. Australian payments industry material is maintained by AusPayNet, the Australian payments industry body.

After obtaining the file, the Excel converter or the CSV converter builds the rows, and the extraction guide explains why.

Suncorp bank statement example: premiums and policies