Multi-currency bank statements, in one currency

Why mixed currencies are hard to total

If you hold accounts in several currencies, such as a home account, a travel card and a business account abroad, no single statement tells you what you earned or spent overall. Adding amounts in different currencies is meaningless, and converting by hand row by row is slow and easy to get wrong. A spreadsheet needs a rate table that you must find, keep and apply correctly.

How the conversion works

Each statement keeps its own currency; every row shows its original amount and currency. You choose a reporting currency (any ISO currency code) and Tallyscope adds a converted column and computes combined totals. The original amounts are never overwritten, so you can always see what the bank actually printed.

Rates come from free public rate services that need no key, tried in a set order: a community currency dataset served through jsDelivr and Cloudflare, then open.er-api.com, then ECB data via Frankfurter, and finally a cached or bundled snapshot if none is reachable. For rows with dates, a dated rate is looked up when available. The lookups send only currency codes and dates, never transaction details.

What to be careful about

• Rates are indicative. They are public reference rates, not what your bank or card issuer charged, which includes their margin and fees. For a legal or tax filing, use the rate your authority or accountant specifies.
• Verification stays in the original currency. The running-balance check is done on each statement's own numbers, never on converted ones, so conversion cannot hide or create a discrepancy.

Combining with the other tools

Currency conversion works together with merging: duplicates from overlapping periods and transfers between your own accounts are handled before the combined totals are computed. An internal transfer between a euro account and a dollar account is recognised, and excluded from totals by default.

In the exports

CSV and Excel include the original Currency and Amount columns and a column named after your reporting currency, for example Amount (EUR). The Statements sheet of the Excel workbook lists each statement's closing balance both in its own currency and in the reporting currency. Excel, PDF and JSON exports are included in the Day pass and Pro plans; the free CSV includes the first 25 rows.

A typical use

A freelancer paid in dollars and euros, with expenses in pounds, wants one year's income and spending in euros for a bookkeeper. They load twelve months of statements from three accounts, choose EUR, check that every statement shows Verified, and export an Excel workbook whose Summary sheet gives the combined figures and whose Transactions sheet gives the detail. Nothing was uploaded, and every figure traces back to a row.

Ready? Open Tallyscope, or read how verification keeps the original numbers honest.