If you live or travel in Europe, your payment screenshots may show euros one day and another currency the next, and many show both. That makes the usual advice to copy the amount into a sheet incomplete. The method below records what you paid in euros, keeps the original amount beside it, and avoids dozens of tiny calculations.
Decide what the sheet's main currency is
Pick one currency for your totals, probably euros, and stay with it. Everything that arrives in another currency gets two columns: the amount as shown in that currency, and the euros you were actually charged. The euro figure is the one you total. The other is there to explain it.
Build the sheet with five columns
- Date.
- Payee.
- Amount charged in euros.
- Original amount and its currency, if different.
- Category.
When the screenshot shows only euros, leave column four blank. When it shows two figures, copy both exactly as written, and do not recalculate from an internet rate. Your card or app has already applied its own rate, so what it shows is the true charge.
Which figure on the screenshot is the real one?
Look for words that tell you. Labels like "total charged", "debited" or "you paid" refer to your own currency. A label like "merchant amount" or "amount in local currency" refers to the shop's. If the labels are unclear, open your bank app's transaction list and read the debit there. The debit is final.
A worked example in euros
Say a weekend city trip produced these screenshots.
| Date | Payee | Charged | Original | Category |
|---|---|---|---|---|
| 9 Sep | Hotel | €186.00 | None | Lodging |
| 9 Sep | Museum | €22.50 | None | Sightseeing |
| 10 Sep | Market stall | €14.80 | 110.00 in the local currency | Food |
| 10 Sep | Taxi | €31.40 | 235.00 in the local currency | Transport |
| 11 Sep | Station kiosk | €7.60 | None | Food |
The euro total is 186.00 plus 22.50 plus 14.80 plus 31.40 plus 7.60, which is €262.30. Food alone is 14.80 plus 7.60, which is €22.40. The two rows with an original amount show why the extra column helps: if the taxi driver later says he was paid 235.00, you can see at a glance that your card was charged €31.40 for it, and the charged column is the one that counts.
What do I do about screenshots that show a refund?
A refund screenshot should be entered as a negative amount against the same category, with the original payment still on its own row. That way, the month shows what you spent, what came back, and the net. Label the row "refund" and keep the date it arrived, which is often later than the original purchase.
When to move off the screenshot altogether
If you pay mostly by card, your bank's statement or an export from its app already lists the debits. Entering them from there beats retyping them from images. Screenshots are the right source for payments that never appear as clean rows, such as peer-to-peer transfers or payments made in an app that does not export anything.
Dealing with rounding
When you add several converted amounts, tiny differences of a cent or two will appear between your sheet and the statement. Accept them. Round each row to two decimal places as the screenshot shows it, total the sheet, and write the difference at the bottom. A difference of a few cents over a month is rounding, not a missing payment.
A checklist for the end of the month
- Every screenshot has a row, and every row has a screenshot or a statement entry behind it.
- Rows with a foreign amount carry the original figure in the notes column.
- The sheet's total agrees with the statement's debits for the same dates, or the difference is written down.
- Screenshots with account details are cropped or deleted once the row is confirmed.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


