ing bank statement example

The IBAN is the account identifier

European accounts are identified by an International Bank Account Number, a long alphanumeric string that encodes the country and the account. On a statement it may be printed in full or partly masked. It is not a number in the arithmetic sense, and a spreadsheet that treats it as one will mangle it.

Store the IBAN as text alongside the statement period. When you hold accounts in more than one country, the IBAN's country prefix is the fastest way to tell the documents apart later.

SEPA transfers and the remittance reference

A SEPA credit transfer carries the counterparty's name, their IBAN and a remittance reference that the sender chose. That reference is frequently the only explanation of the payment: an invoice number, a contract reference, a tenancy identifier. The counterparty name alone will not tell you what a payment was for when the same party appears repeatedly.

SEPA direct debits work the other way: an organisation collects under a mandate you granted, and the amount can vary. Both mandate reference and creditor identifier may appear on the row, and both are worth keeping.

European number and date formatting

Continental European documents commonly use a comma as the decimal separator and a point or space for thousands, and dates are written day first. A converter configured for Anglo-American conventions will read 1.234,56 as something quite different, and will swap day and month for the first twelve days of each month.

Resolve both conventions once, against the statement period and against a known amount, then apply them to the entire file.

Card payments, standing instructions and fees

Card purchases post on settlement, standing instructions recur on schedule, and account or transaction fees appear as separate rows. The reconciliation treats them identically; the categorisation does not, and a fee is worth isolating because it explains a movement with no purchase behind it.

Where the statement is for a savings product, interest credited is income rather than a transfer you made.

Reconciling a euro account

In euros and inside the printed window, the activity has to reconcile the two balances. If the chain fails by a factor that looks like a decimal shift, the decimal separator was misread; if it fails by a transaction-sized amount, look for a wrapped description or a boundary-dated item.

Both failure modes have distinct signatures, which makes diagnosis quick once you know to look for them.

Getting the document

Pull the period from your own ING banking and note the IBAN with it. Keep the IBAN and the period with the file. A statement is a closed document; an on-screen transaction list is not.

Retain the PDF alongside any spreadsheet you derive from it.

IBAN and SEPA in this ing bank statement example

The IBAN heads this list because it is both the account identifier and the field most often damaged in conversion.

An ING extraction is reliable when:

• The IBAN survived import as text with every character intact
• The comma decimal separator was interpreted correctly
• Remittance references were captured in full

Decimal commas and IBANs against sterling and dollars

A sterling or dollar statement needs none of the separator care, which makes the European conventions obvious. The SEPA schemes named here are maintained by The European Payments Council, which maintains the SEPA schemes.

With the authentic file ready, the Excel converter or CSV converter converts and the extraction guide explains.

ING bank statement example: mandates and SEPA rows