Which exchange rate is the real one?
There are three rates an ordinary person meets, and all three are real. They answer different questions.
The mid-market rate is the midpoint between what buyers are offering and sellers are asking in the wholesale currency market at a given moment. Most ordinary transactions do not happen at it; where a provider does convert at it, the cost shows up as a separate fee instead of inside the rate.
The rate that was actually applied is the one your card issuer used on a specific purchase, on the day that purchase was processed, plus whatever the issuer added on top. It is the only rate describing money that has genuinely left your account.
The rate a converter app shows today is a mid-market rate as of right now. It is useful for a rough sense of value and useless for checking a statement, because it is neither the right day nor the right kind of rate.
They never match because they measure different things: a wholesale midpoint, a retail price with some or all of the cost inside it, and a snapshot from another day.
Why doesn't the exchange rate on my statement match the rate I looked up?
Four things stack up. First, timing: a card purchase abroad is converted when it is processed, not when you tap, often a day or three later, so a Tuesday purchase can be converted at Thursday's rate.
Second, whose rate: conversion is normally done at the card network's rate, which is set periodically rather than continuously, so it will not equal a live mid-market number even on the same day.
Third, a markup: many issuers add a percentage on top of the network rate, invisible on the statement, simply making the converted amount larger. Fourth, the fee, which may sit on its own line or be folded into the amount.
You can recover the all-in rate without knowing any of those numbers, as long as you capture the fee. Divide the home-currency amount charged by the purchase amount in the foreign currency when the fee is folded into that line; when the fee sits on its own line, add it in first, or what you get is the network rate rather than what the purchase cost you.
One case looks different: if a card machine abroad offers to charge you in your home currency, the conversion is done by the merchant's payment processor at its own rate, and the statement shows a home-currency amount with no conversion visible at all.
Should I convert a whole month at one rate, or each purchase at its own rate?
Both, for different jobs. The mistake is using one method to answer the other one's question.
Convert each purchase at the rate that was actually charged when you want to know what you really spent. That is the right method for reconciling against a statement, for deciding whether you stayed inside a budget, and for anything you might have to justify.
Convert a whole month at one chosen rate when you are planning forward or comparing one month with another. A single rate strips out the currency noise, so the comparison shows how your behavior changed rather than how the market moved. It is a deliberate simplification, and that is what makes it useful.
The two answers will disagree, usually by a small percentage. The rule that matters is never to mix them: if some lines are converted at their own rate and others at today's, the total means nothing.
How does a foreign transaction fee show up on my statement?
In one of three ways, depending on the card and the country.
Most visibly, as a separate line right after the purchase, labeled something like foreign transaction fee or international transaction fee. That is the easiest to work with: you can total those lines and see what conversion cost you.
Less visibly, folded into the converted amount, so the purchase line is simply larger than the network rate alone would produce and there is nothing to point at. You detect it by working out the effective rate and comparing it with the mid-market rate for roughly that date; the gap is markup plus fee. Occasionally it appears instead as a single summary line for the billing cycle.
Cash is its own case: withdrawing abroad often carries a separate cash withdrawal fee, and on a credit card a cash withdrawal may start accruing interest immediately. For budgeting, decide once whether fees belong inside each purchase or in a category of their own, then stay consistent.
Which currency should my budget be in?
Pick one home currency and stay with it. The best choice is usually the currency your obligations are in: rent or mortgage, loan payments, utilities, school fees. Those are the numbers that hurt if you come up short, so they should sit still.
A budget is a comparison across time, and a comparison only works when the unit stays fixed. If January is measured in one currency and February in another, you cannot tell whether you spent more or whether the market moved. Converting everything into one currency costs a little accuracy on individual lines and buys a number you can act on.
One honest exception: if you genuinely run two separate financial lives, with income and bills in each country that do not fund each other, two budgets side by side are cleaner than one converted total that matches no real decision.
What if I earn in one currency and spend in another?
Then one side of your budget moves on its own, and your job is to decide which side.
Budget in the currency of your obligations and convert your income into it. Your spending line then stays stable and your income line moves with the rate, which is uncomfortable but truthful: if you are paid abroad and your rent is at home, your real income does change every month whether you track it or not.
Some people set the planning rate slightly against themselves — lower than today's if they are converting income in, higher if they are paying costs out — so that a small move in the wrong direction is already inside the plan. A larger move is not, and no rate chosen in advance covers every outcome. It is a way of leaving room, not a prediction.
If you convert money in a lump once a month it gets simpler still: that day's rate is your real rate for the period, your income is the amount that landed, and everything you spend afterward is already in one currency.
What happens to my budget when the exchange rate moves mid-month?
Nothing, if you set it up so a rate move cannot rewrite what already happened. The mistake is re-converting the whole month every time the rate ticks, which gives a budget that changes daily and tells you nothing.
Do it in three parts. Fix a planning rate at the start of the month and leave it alone. Record actual spending at the rates actually charged. At month end, split the difference between plan and actual into the part caused by the rate and the part caused by your own choices. That tells you whether you overspent or simply had an unhelpful month.
If the rate has moved and stayed moved, change the planning rate for next month rather than this one.
The part a plain spreadsheet usually drops is keeping both numbers on every transaction: the amount in the currency you paid and the amount in your home currency. Without both you cannot reconstruct what happened. An app that stores both and lets you set a home currency is one way to do this, and Tally works that way.
Can you show a worked example with two currencies?
All the numbers below are illustrative. Say your home currency is dollars and you also spend euros.
One purchase. On the 3rd you buy a meal for 60.00 euros. The mid-market rate you looked up was 1.10 dollars to the euro, so you expected about 66.00 dollars. Your issuer processes the purchase on the 5th at a network rate of 1.1050 and charges 66.30, then adds a 2 percent foreign transaction fee of 1.33. The statement shows 67.63. The effective rate is 67.63 divided by 60.00, about 1.1272 per euro, roughly 2.5 percent above the rate you looked up.
A month. You spend 1,200 euros over the month. At today's mid-market rate of 1.10 that is 1,320 dollars; converted line by line at the rates actually charged it comes to 1,352. The gap is 32 dollars, about 2.4 percent: invisible on one coffee, visible across a year.
For what did I spend last month, the answer is 1,352. For next month, do not plan at 1.10; use the effective rate you just observed, about 1.1267, so the cost of converting money is already inside the plan.
Income. Say you are paid 3,000 euros a month and your rent is 1,400 dollars. At 1.10 your income is 3,300 and you have 1,900 left after rent; at 1.05 it is 3,150 and you have 1,750. The rent did not move, but 150 dollars did. Planning at 1.05 from the start would have made that headroom instead of a hole.
This guide explains how the arithmetic works. It is not financial advice.