bbva bank statement example

Download an authentic BBVA statement

In BBVA's app or web banking, select the account and look for Extractos or Correspondencia to download the official PDF.

BBVA official statement instructions ↗

Decimal comma and thousands separator

Spanish and wider European formatting writes one thousand two hundred thirty-four euros and fifty-six cents as 1.234,56. A tool expecting Anglo-American formatting reads the point as a decimal and produces 1.234, losing three orders of magnitude on every large amount while leaving small ones looking plausible. That mixture is what makes the error hard to spot by eye.

The fastest diagnostic is the balance chain: a reconciliation that fails by roughly a factor of a hundred or a thousand is a separator problem, not a missing transaction.

Day-first dates

BBVA prints dates day/month, so 03/02 is the third of February. From the 1st to the 12th of any month the swapped reading is also a real date and nothing in the cell warns you. Test one row against the Periodo line at the top: only the day-first reading keeps every movement inside it.

Settle the convention for the whole file at once. Checking rows individually is slow and will miss exactly the cases that matter.

IBAN identification and SEPA activity

The account is identified by its IBAN, which must be stored as text. Transfers move through the SEPA framework, carrying counterparty name, IBAN and a remittance reference chosen by the sender. Direct debits are collected under a mandate, with amounts that can vary between collections.

The remittance reference is usually the only description of a transfer's purpose; capture it exactly as printed rather than summarising it.

Card activity and account fees

Card purchases post on settlement rather than authorisation, so a purchase made at the end of a period may appear in the next statement. Account maintenance fees and transaction charges appear as their own rows and are worth isolating, since they explain balance movements with no purchase behind them.

On a savings product, interest credited is income rather than a transfer, and categorising it as a deposit will distort any summary.

Reconciling in euros

The two euro balances and the period's movement form the identity to verify first. Run that check before categorising, because an extraction with a separator problem will produce categories that look reasonable while being uniformly wrong.

Check the transaction count as well as the totals: offsetting errors can leave a sum intact.

Obtaining and converting the statement

Select account and period inside your own BBVA banking and save the file. Keep the IBAN and period with the file.

On import, set the decimal separator, the date order and the IBAN column to text before the first row is read. All three are far harder to fix afterwards than to specify in advance.

European formatting in this bbva bank statement example

Two of these rows exist purely because European formatting differs from Anglo-American formatting.

A BBVA dataset is safe to use when:

• The decimal comma was configured before import, not corrected afterwards
• Day-first dates were confirmed against the statement period
• Remittance references were captured exactly as printed

Spanish conventions next to an English-language statement

An English-language statement from another market shows how much of this is formatting rather than banking. Rules for the SEPA instruments above are published by The European Payments Council, which maintains the SEPA schemes.

The downloaded document feeds the Excel converter or the CSV converter, and the extraction guide the method.

BBVA bank statement example: recibos, Bizum and dates