Bank Statement Format Guides

Browse common statement layouts, date formats, currency conventions and account-export workflows by bank. ClearlyLedger uses dedicated templates for selected formats and a general extraction path for other PDFs; exports are released only after verification checks pass.

Last updated 2026-07-28

All supported banks (147)

Each guide covers that bank's statement layout, date ordering, currency conventions and the quirks its PDFs print.

Australia (7) — Australia bank statement converter hub

ANZ Bank statement to Excel (DD MMM · A$ AUD)
Bendigo Bank statement to Excel (DD/MM/YYYY · A$ AUD)
Commonwealth Bank statement to Excel (DD MMM YYYY · A$ AUD)
ING Australia statement to Excel (DD/MM/YYYY · A$ AUD)
Macquarie Bank statement to Excel (DD MMM YYYY · A$ AUD)
National Australia Bank statement to Excel (DD/MM/YYYY · A$ AUD)
Westpac statement to Excel (DD MMM YY · A$ AUD)

Canada (11) — Canada bank statement converter hub

Bank of Montreal statement to Excel (MMM DD · C$ CAD)
CIBC statement to Excel (MMM DD · C$ CAD)
Desjardins statement to Excel (YYYY-MM-DD · C$ CAD)
EQ Bank statement to Excel (DD MMM YYYY · C$ CAD)
HSBC Canada statement to Excel (DD MMM YYYY · C$ CAD)
National Bank of Canada statement to Excel (YYYY-MM-DD · C$ CAD)
Royal Bank of Canada statement to Excel (DD MMM YYYY · C$ CAD)
Scotiabank statement to Excel (DD MMM · C$ CAD)
Simplii Financial statement to Excel (MMM DD · C$ CAD)
Tangerine Bank statement to Excel (DD MMM YYYY · C$ CAD)
TD Canada Trust statement to Excel (MMM DD · C$ CAD)

Colombia (7) — Colombia bank statement converter hub

Banco AV Villas statement to Excel (DD/MM/YYYY · $ COP)
Banco de Bogotá statement to Excel (DD/MM/YYYY · $ COP)
Banco de Occidente statement to Excel (DD/MM/YYYY · $ COP)
Banco Popular Colombia statement to Excel (DD/MM/YYYY · $ COP)
Bancolombia statement to Excel (DD/MM/YYYY · $ COP)
BBVA Colombia statement to Excel (DD/MM/YYYY · $ COP)
Davivienda statement to Excel (DD/MM/YYYY · $ COP)

France (9) — France bank statement converter hub

Banque Populaire statement to Excel (DD/MM/YYYY · EUR EUR)
BNP Paribas France statement to Excel (DD/MM/YYYY · EUR EUR)
Boursorama Banque statement to Excel (DD/MM/YYYY · EUR EUR)
Caisse d'Epargne statement to Excel (DD/MM/YYYY · EUR EUR)
Credit Agricole France statement to Excel (DD/MM/YYYY · EUR EUR)
Fortuneo Banque statement to Excel (DD/MM/YYYY · EUR EUR)
La Banque Postale statement to Excel (DD/MM/YYYY · EUR EUR)
LCL France statement to Excel (DD/MM/YYYY · EUR EUR)
Societe Generale France statement to Excel (DD/MM/YYYY · EUR EUR)

Germany (2)

Deutsche Bank statement to Excel (DD.MM.YYYY · € EUR)
Sparkasse statement to Excel (DD.MM.YYYY · € EUR)

India (10) — Indian bank statement converter guide

Axis Bank statement to Excel (DD-MM-YYYY · ₹ INR)
Bank of Baroda statement to Excel (DD/MM/YYYY · ₹ INR)
HDFC Bank statement to Excel (DD/MM/YY · ₹ INR)
ICICI Bank statement to Excel (DD/MM/YYYY · ₹ INR)
IDBI Bank statement to Excel (DD/MM/YYYY · ₹ INR)
IDFC FIRST Bank statement to Excel (DD-MM-YYYY · ₹ INR)
Kotak Mahindra Bank statement to Excel (DD-MMM-YYYY · ₹ INR)
Punjab National Bank statement to Excel (DD/MM/YYYY · ₹ INR)
State Bank of India statement to Excel (DD MMM YYYY · ₹ INR)
Yes Bank statement to Excel (DD-MMM-YY · ₹ INR)

Ireland (5) — Ireland bank statement converter hub

Allied Irish Banks statement to Excel (DD/MM/YYYY · € EUR)
Bank of Ireland statement to Excel (DD MMM YY · € EUR)
N26 Ireland statement to Excel (DD/MM/YYYY · EUR EUR)
Permanent TSB statement to Excel (DD/MM/YYYY · € EUR)
Revolut Ireland statement to Excel (DD/MM/YYYY · EUR EUR)

Italy (6) — Italy bank statement converter hub

Banca Monte dei Paschi di Siena statement to Excel (DD/MM/YYYY · EUR EUR)
Banco BPM statement to Excel (DD/MM/YYYY · EUR EUR)
BPER Banca statement to Excel (DD/MM/YYYY · EUR EUR)
Intesa Sanpaolo statement to Excel (DD/MM/YYYY · EUR EUR)
Mediobanca Premier statement to Excel (DD/MM/YYYY · EUR EUR)
UniCredit statement to Excel (DD/MM/YYYY · EUR EUR)

Kenya (6) — Kenya bank statement converter hub

Absa Bank Kenya statement to Excel (DD/MM/YYYY · KSh KES)
Co-operative Bank of Kenya statement to Excel (DD/MM/YYYY · KSh KES)
Equity Bank Kenya statement to Excel (DD/MM/YYYY · KSh KES)
KCB Bank Kenya statement to Excel (DD/MM/YYYY · KSh KES)
NCBA Bank Kenya statement to Excel (DD/MM/YYYY · KSh KES)
Stanbic Bank Kenya statement to Excel (DD/MM/YYYY · KSh KES)

Malaysia (2) — Malaysia bank statement converter guide

CIMB Bank statement to Excel (DD/MM/YYYY · RM MYR)
Maybank statement to Excel (DD/MM/YYYY · RM MYR)

Mexico (7) — Mexico bank statement converter hub

Banorte statement to Excel (DD/MM/YYYY · $ MXN)
BBVA Mexico statement to Excel (DD/MM/YYYY · $ MXN)
Citibanamex statement to Excel (DD/MM/YYYY · $ MXN)
HSBC Mexico statement to Excel (DD/MM/YYYY · $ MXN)
Inbursa statement to Excel (DD/MM/YYYY · $ MXN)
Santander Mexico statement to Excel (DD/MM/YYYY · $ MXN)
Scotiabank Mexico statement to Excel (DD/MM/YYYY · $ MXN)

Netherlands (5) — Netherlands bank statement converter hub

ABN AMRO statement to Excel (DD-MM-YYYY · EUR EUR)
ASN Bank statement to Excel (DD-MM-YYYY · EUR EUR)
bunq statement to Excel (DD-MM-YYYY · EUR EUR)
ING Netherlands statement to Excel (DD-MM-YYYY · EUR EUR)
Rabobank statement to Excel (DD-MM-YYYY · EUR EUR)

New Zealand (5) — New Zealand bank statement converter hub

ANZ New Zealand statement to Excel (DD/MM/YYYY · NZ$ NZD)
ASB Bank statement to Excel (DD MMM · NZ$ NZD)
Bank of New Zealand statement to Excel (DD MMM · NZ$ NZD)
Kiwibank statement to Excel (DD MMM YYYY · NZ$ NZD)
Westpac New Zealand statement to Excel (DD/MM/YYYY · NZ$ NZD)

Nigeria (8) — Nigeria bank statement converter hub

Access Bank Nigeria statement to Excel (DD/MM/YYYY · NGN NGN)
Fidelity Bank Nigeria statement to Excel (DD/MM/YYYY · NGN NGN)
First Bank of Nigeria statement to Excel (DD/MM/YYYY · NGN NGN)
Guaranty Trust Bank statement to Excel (DD/MM/YYYY · ₦ NGN)
Moniepoint statement to Excel (DD/MM/YYYY · NGN NGN)
OPay statement to Excel (DD/MM/YYYY · NGN NGN)
United Bank for Africa statement to Excel (DD/MM/YYYY · NGN NGN)
Zenith Bank statement to Excel (DD/MM/YYYY · NGN NGN)

Singapore (4) — Singapore bank statement converter hub

DBS Bank statement to Excel (DD MMM YYYY · S$ SGD)
OCBC Bank statement to Excel (DD/MM/YYYY · S$ SGD)
Standard Chartered Singapore statement to Excel (DD MMM YYYY · S$ SGD)
United Overseas Bank statement to Excel (DD MMM YYYY · S$ SGD)

South Africa (2) — South Africa bank statement converter guide

First National Bank statement to Excel (DD/MM/YYYY · R ZAR)
Standard Bank South Africa statement to Excel (DD MMM YYYY · R ZAR)

Spain (6) — Spain bank statement converter hub

Banco Sabadell statement to Excel (DD/MM/YYYY · EUR EUR)
Banco Santander Spain statement to Excel (DD/MM/YYYY · EUR EUR)
Bankinter statement to Excel (DD/MM/YYYY · EUR EUR)
BBVA Spain statement to Excel (DD/MM/YYYY · EUR EUR)
CaixaBank statement to Excel (DD/MM/YYYY · EUR EUR)
Kutxabank statement to Excel (DD/MM/YYYY · EUR EUR)

Switzerland (5) — Switzerland bank statement converter hub

Credit Suisse Switzerland statement to Excel (DD.MM.YYYY · CHF CHF)
PostFinance statement to Excel (DD.MM.YYYY · CHF CHF)
Raiffeisen Switzerland statement to Excel (DD.MM.YYYY · CHF CHF)
UBS Switzerland statement to Excel (DD.MM.YYYY · CHF CHF)
Zurcher Kantonalbank statement to Excel (DD.MM.YYYY · CHF CHF)

United Arab Emirates (8) — UAE bank statement converter hub

Abu Dhabi Commercial Bank statement to Excel (DD/MM/YYYY · د.إ AED)
Abu Dhabi Islamic Bank statement to Excel (DD/MM/YYYY · د.إ AED)
Dubai Islamic Bank statement to Excel (DD/MM/YYYY · د.إ AED)
Emirates NBD statement to Excel (DD/MM/YYYY · د.إ AED)
First Abu Dhabi Bank statement to Excel (DD/MM/YYYY · د.إ AED)
HSBC UAE statement to Excel (DD MMM YYYY · د.إ AED)
Mashreq Bank statement to Excel (DD/MM/YYYY · د.إ AED)
RAKBANK statement to Excel (DD/MM/YYYY · د.إ AED)

United Kingdom (10) — UK bank statement converter hub

Barclays statement to Excel (DD MMM YY · £ GBP)
Halifax statement to Excel (DD MMM YY · £ GBP)
HSBC UK statement to Excel (DD MMM YY · £ GBP)
Lloyds Bank statement to Excel (DD MMM YY · £ GBP)
Monzo statement to Excel (DD MMM YYYY · £ GBP)
Nationwide Building Society statement to Excel (DD MMM YYYY · £ GBP)
NatWest statement to Excel (DD MMM YYYY · £ GBP)
Revolut UK statement to Excel (DD MMM YYYY · £ GBP)
Santander UK statement to Excel (DD/MM/YYYY · £ GBP)
Starling Bank statement to Excel (DD MMM YYYY · £ GBP)

United States (22) — USA bank statement converter hub

Ally Bank statement to Excel (MM/DD/YYYY · $ USD)
American Express statement to Excel (MM/DD/YYYY · $ USD)
Bank of America statement to Excel (MM/DD/YY · $ USD)
Capital One statement to Excel (MMM DD, YYYY · $ USD)
Charles Schwab Bank statement to Excel (MM/DD/YYYY · $ USD)
Chase Bank statement to Excel (MM/DD/YYYY · $ USD)
Citibank statement to Excel (MM/DD/YY · $ USD)
Citizens Bank statement to Excel (MM/DD/YYYY · $ USD)
Discover Bank statement to Excel (MM/DD/YY · $ USD)
Fidelity statement to Excel (MM/DD/YYYY · $ USD)
Fifth Third Bank statement to Excel (MM/DD/YYYY · $ USD)
Huntington Bank statement to Excel (MM/DD/YY · $ USD)
KeyBank statement to Excel (MM/DD/YY · $ USD)
Navy Federal Credit Union statement to Excel (MM/DD/YYYY · $ USD)
PNC Bank statement to Excel (MM/DD/YYYY · $ USD)
Regions Bank statement to Excel (MM/DD/YYYY · $ USD)
SoFi Bank statement to Excel (MM/DD/YYYY · $ USD)
Synchrony Bank statement to Excel (MM/DD/YYYY · $ USD)
TD Bank (US) statement to Excel (MM/DD · $ USD)
Truist Bank statement to Excel (MM/DD/YYYY · $ USD)
U.S. Bank statement to Excel (MM/DD/YYYY · $ USD)
Wells Fargo statement to Excel (MM/DD · $ USD)

Loading interactive converter… Try ClearlyLedger free