Bank statements

Prepare a year of bank statements for your accountant in Europe

Get twelve months of statements ready in an hour, including the euro formatting traps: decimal commas, date styles and shared household accounts.

Editorial illustration for Prepare a year of bank statements for your accountant in Europe

Preparing a year of statements for an accountant is mostly a matter of order: list your accounts, download every month, fix number and date formats so they behave in a spreadsheet, and hand over a single folder with a short index. The part people forget, and the part that quietly ruins totals, is how euro amounts and dates are written in the files.

Why do my euro amounts turn into text?

Many European exports write 1.234,56 with a full stop for thousands and a comma for decimals. A spreadsheet set to another regional style may read that as plain text, so it refuses to add it up. The same happens with dates written 31.03.2025 or 03/04/2025, where it is unclear whether April or March is meant.

Test it on one file before you start. Open an exported CSV or paste a table into a sheet and try =SUM on the amount column. If you get 0, or if the cells align left like words, they are text. Fix it once with Find and Replace by turning the full stop into nothing and the comma into a decimal point, or change the sheet's regional setting to match your bank's file.

Which accounts go in?

  • Every current account, whether yours, a partner's or a joint account
  • Savings and notice accounts
  • Cards, including debit cards that run on their own account
  • Anything held in another currency, listed separately with its currency named
  • Accounts for a side business or freelance work, which your accountant may treat differently

Ask which of these the accountant wants. A short email naming the accounts you plan to send avoids both missing items and unnecessary oversharing.

A worked example: a household with one freelance partner

Say a couple has a joint current account, one savings account and a card used for the translation work one partner does on the side. That is 3 accounts and 12 months, so 36 statements. Allow one minute each to download, check and rename: 36 minutes. Add 10 minutes for the format fixes above, 10 for the balance checks and 4 for the index, and the hour is gone.

StepTimeCheck
Download and rename 36 files36 minNames follow year-month-account
Fix number and date formats10 minSUM returns a real total
Balance handover check10 minEach closing equals next opening
Index and cover note4 minEvery month ticked

How do I check each month hangs together?

Compare closing and opening balances across each month boundary. Suppose March closes at €3,420.50 and April opens at €3,420.50: good. If May opens at €3,150.00 but April closed at €3,175.00, there is a €25.00 gap, which means a statement page is missing or a mid-month document covers different dates than you thought.

What about transfers between our own accounts?

Each one appears twice, once leaving and once arriving. If your accountant adds both sides, the money looks like it was both spent and earned. Make a short list titled Own transfers with the date, amount and the two accounts, and attach it. Do the same for a refund and the purchase it reverses.

What should I leave for the accountant to decide?

Anything involving tax treatment, deductions or thresholds. Rules differ between countries and change over time, so this article sticks to records. Your task is to provide complete, clearly named documents with consistent formats.

SpendixAI is built around India and INR rather than European banks. One idea from it is worth copying anyway: keep every currency visible. Each expense can carry its own currency, with totals shown in a base currency.

Before you send

  • Amounts and dates behave properly in a spreadsheet
  • Every account and month is present or explained
  • Own transfers and refunds are listed
  • File names have no full account numbers
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports