Two questions, two exchange rates
A budget answers two questions, and they need different exchange rates:
- How much did I spend? — use the rate on the day you spent it. That's what the purchase actually cost you.
- How much do I have? — use today's rate. That's what your money is worth now.
Converting everything at today's rate answers the second question correctly and the first one wrong: every time the market moves, your past spending changes.
Step 1: pick one base currency
Choose the currency you think in — usually the one most of your spending is in. Every total, budget and chart is shown in it. Your accounts don't change: a dollar account stays in dollars, a USDT wallet stays in USDT. The base currency is only the ruler you measure everything with.
Step 2: record spending at the rate of its date
Say your base currency is the peso. In January you pay $1,000 rent when $1 = ₱56. That's ₱56,000 of January spending — and it should stay ₱56,000.
In March the dollar is at ₱58. If your spreadsheet converts at today's rate, January's rent now shows as ₱58,000: your January report changed by ₱2,000 although you didn't spend a single extra peso. Store the rate next to each transaction and convert with it, and the past stops moving.
Step 3: value balances at today's rate
Balances are the opposite: you want to know what your money is worth today. $5,000 of savings is ₱290,000 at ₱58 — no matter what the rate was when you put it aside.
Step 4: show the difference as revaluation
If you saved those $5,000 when the dollar was ₱56, they were worth ₱280,000 then and ₱290,000 now. The ₱10,000 difference is revaluation — an exchange-rate gain. When the rate goes the other way, it's a loss.
Revaluation is neither income nor spending: no money came in or went out. Keep it as its own line. Mixed into income, it makes a good month look better than it was; mixed into spending, a strong peso would look like you suddenly spent less. Accountants do the same — transactions at the rate of their date, balances at the closing rate, the difference as exchange gains or losses.
Transfers between currencies
When you move money from a dollar account to a peso account, record both sides as they happened: $500 left, ₱27,600 arrived. Don't type a rate — the two amounts are the rate. If the market said ₱28,000, the missing ₱400 is what the bank or remittance service took; you can check a transfer with our remittance cost calculator.
Crypto is just another currency
The same rules work for BTC or USDT: spending at the price of the day, balances at today's price, price moves as revaluation — not as income. Keep enough decimals (bitcoin has 8), or small amounts round down to zero. Stablecoins aren't exactly $1 either; over a year the difference adds up.
Doing it in a spreadsheet — or letting an app do it
In a spreadsheet: add a column for the rate on each transaction's date, convert spending with it, and convert balances with a single "today" rate cell. Revaluation is the balance at today's rate minus the sum of transactions at their own rates. It works — as long as you look up and type every rate. To lay out the month itself, start from our monthly budget planner — it downloads as an Excel template.
Flash Budget does exactly this automatically: rates update by themselves, each transaction keeps the rate of its date, balances use today's, and your own rate wins whenever you set one. That's all in the free plan; the revaluation line in statistics is part of the paid plan. More in multi-currency budgeting and crypto and fiat in one budget.