ASB Bank Statement to Excel Converter

ClearlyLedger converts ASB Bank PDF statements into structured Excel and CSV files for New Zealand accountants, bookkeepers, SMEs, contractors, property investors, and lenders. The ASB profile handles NZD formatting, year-less date rows, AP and DD narration, EFTPOS descriptions, bill-payment references, and balance verification before export.

Last updated 2026-06-05

What does an ASB statement format look like?

ASB statements commonly use date, transaction details, withdrawals, deposits, and balance fields. Some rows omit the year and rely on the statement period for context.

ClearlyLedger detects ASB layouts, infers the correct year from the statement period, and exports the rows into clean Excel or CSV columns.

How are AP, DD, EFTPOS and bill-payment narration handled?

New Zealand transaction narration often carries meaning in AP, DD, EFTPOS, and bill-payment references. Generic converters can drop these labels or split reference text away from the amount.

The ASB profile preserves those details while normalizing NZD amounts and descriptions for Xero NZ, MYOB, and lender-review workflows.

Which export should I use for Xero NZ, MYOB or GST review?

Use Excel when reviewing ASB statements for GST return support, IR3 or IR4 preparation, mortgage packs, or rental-property reconciliation. Use CSV when importing into Xero NZ or MYOB.

ClearlyLedger checks extracted transactions against the printed balance before export, which helps catch missing rows, date inference problems, and sign errors before bookkeeping starts.

ASB Bank source profile used by this guide

Printed statement structure: PDF with Date, Transaction Details, Withdrawals, Deposits, Balance

Source conventions: DD MMM dates, NZ$ NZD amounts, and 3–10 pages.

ASB observations to sample during review

  • ASB has been a wholly owned subsidiary of Commonwealth Bank of Australia since 1989, and its FastNet online banking brand is how most customers refer to statement downloads rather than 'ASB' alone
  • Date column omits the year on standard statements — inferred from the statement period header
  • Automatic Payments and Direct Debits are identified by 'AP' / 'DD' prefixes rather than a separate transaction-type column
  • Cardless cash withdrawals appear with a mobile phone number reference in the description instead of a card number
  • Multiple accounts may appear in one combined PDF, each prefixed with the account nickname the customer set, not a fixed account-type label

These ASB details identify the rows most likely to need inspection after extraction. Review the first and final transaction, each PDF page boundary, and any row affected by the observations above before using the spreadsheet in an accounting import.

Related workflows

Continue from this guide into the matching converter, accounting import, security, or country hub pages so crawlers and readers can follow the full workflow.

Frequently asked questions

How do I convert an ASB statement to Excel?

Upload the ASB PDF to ClearlyLedger. The ASB layout is detected automatically, year-less dates are inferred from the statement period, transactions are normalized, the balance is verified, and the statement is exported to Excel.

Can I convert ASB statements to CSV for Xero?

Yes. ClearlyLedger exports ASB transactions to CSV with date, description, reference, debit, credit, and balance columns for Xero NZ, MYOB, and reconciliation workflows.

Does it handle ASB rows without a year?

Yes. The ASB parser infers the year from the statement period and handles calendar-year boundaries where possible.

Does it preserve AP, DD, and EFTPOS details?

Yes. Automatic payment, direct debit, EFTPOS, bill-payment, and transfer narration is preserved where possible for transaction matching.

Related ClearlyLedger resources

Use these canonical pages to compare formats, verify data handling, and move from PDF extraction into accounting review.

Loading interactive converter… Try ClearlyLedger free