Tineo home

Settings

How do you track spending in two currencies?

Tineo Editorial Team Last updated 6 min read

You track spending in two currencies by writing every purchase in the currency you actually paid, and writing the other currency only when you know the amount you gave up to get it. Cash gets that second amount from the exchange receipt. A card charge gets it from the posted statement, not from a converter you checked in the morning. Each currency keeps its own running total. You add across to a home-currency total only for rows whose home-currency amount is already real, plus a clearly marked estimate for the rows still waiting.

Two columns, and a status on the second

A row needs a date, a short description, the currency you spent, the amount in that currency, how you paid (cash, card in local currency, or card already converted by the merchant), and the home-currency amount. The home-currency amount has a status: receipt, posted, or estimate. Receipt and posted are records. An estimate is a translation you can replace.

The foreign column adds to a foreign total. The home column adds to a home total. Those two totals answer different questions. The foreign total tells you how much of the cash in your pocket is gone. The home total tells you what the trip has drawn from the account you live on. Adding the foreign total to the home total, without converting row by row, produces a number with no unit. Leave the foreign total in foreign units until each of its rows has a home-currency status you trust.

The person who paid writes the row in the currency they used. A share owed to them stays in that currency unless you settle in home currency from posted amounts only. Name the rate at settlement, from the post or the cash receipt.

Cash uses the exchange you made

When you change money, write one row: home currency paid, foreign currency received, fees the changer printed, and the date. That pair is the rate for that cash. Later cash purchases reduce the foreign total only. The home currency already left on the exchange row. A fresh conversion on each coffee counts the exchange twice.

If the changer charged a fee, the fee is part of the home-currency cost of the whole cash pile, not a second fee on each coffee. You can note it on the exchange row. Mastercard’s FAQ says foreign currency is usually best obtained at your destination, because institutions at home have paid to transport, secure, and store it and pass those costs on. That is Mastercard’s general advice, not a quote for your counter. Whichever counter you use, the receipt you keep is the rate the log is allowed to call real.

A cash withdrawal is the same kind of row, with extra cells if the card issuer posts a separate charge. Those cells are filled from the post, on the rules in how card foreign-transaction fees work. The foreign notes in your hand are the foreign amount. The home-currency cost is whatever the account shows, including a fee the statement separates.

Card rows wait for the post

A card purchase in local currency gets a foreign amount immediately, from the receipt or the screen, and a blank home-currency cell marked “wait for post.” Visa’s exchange-rate calculator says the bank may or may not bill you at the calculator’s rate, may add fees, and does not apply the calculator rate at all when the merchant or the ATM operator converts the transaction. An estimate you scribble from that calculator, or from a reference rate, can sit in the cell if you mark it “estimate” and date it. The posted amount replaces it. You do not average the estimate and the post. The post wins.

If you accept the merchant’s offer to charge your home currency, the receipt is already a home-currency record. Fill the home cell from the receipt, status “receipt,” and still check the statement in case an issuer fee arrives as its own line. Mastercard’s FAQ says that kind of offer comes at a cost and that the better practice is to decline it and let your bank convert. Follow that or not. The log records the path you took.

The European Central Bank publishes euro foreign-exchange reference rates and says they are for information only. It strongly discourages using them for transactions. On this log, an ECB rate is allowed only inside an estimate cell: write the rate, the date you read it, and “reference only.” Why trip budgets break is where that same reference rate, plus a gap you choose, is used to plan the trip before anyone has spent. The log is the later document. Planning numbers do not overwrite posted ones, and posted ones retire the plan’s translation for that row.

An illustrative log

Every unit below is illustrative. It is not an exchange rate, a fee, a meal price, or a cash-counter quote.

You exchange 100 home-currency units and receive 80 local units, with the fee already inside the 100 on the receipt. The exchange row is 100 home, status receipt, and 80 local. Coffee the next morning is 4 local, cash. The foreign total of spending rises by 4. The home total does not change, because the 100 already counted. You have 76 local left from that pile.

Lunch is 20 local on a card, charged in local currency. The row is 20 local, home cell “estimate,” dated, and you leave the estimate out of the trusted home total or you include it only in a column titled “estimated home.” The statement later posts 28 home-currency units for that lunch. You replace the estimate with 28, status posted. The trusted home total rises by 28. You do not also add a piece of the original 100.

A museum is 16 local, and you accept the terminal’s conversion at 24 home-currency units. The row is 24 home, status receipt, and 16 local so you can still see the sticker. If a later statement line adds an issuer fee of 2 illustrative units, that 2 is a new row, not a rewrite of the museum’s 24, unless the statement combines them. Match the statement’s split.

Trusted home total so far, in illustrative units: 100 for the cash pile, plus 28 posted lunch, plus 24 museum, plus 2 if the fee posted. The 4-local coffee is inside the 100. Estimated cells that you have not replaced stay out of this sentence.

Reconcile on statement day

Match the statement to the log. Every posted trip charge needs a row, and every card row needs a posted amount or a note that it is still pending. Then the trusted home total is what you compare with the cap on the travel budget planner.

Cash still in your pocket is not spending. It is the remainder of the exchange row. When you convert leftover cash back, write a new exchange row in the other direction and reduce the home-currency cost of the trip by the home currency you received. The leftover, converted back, is why the first exchange row was a pile and not a list of coffees.

Do the reconcile while you can still remember a charge. A log closed a month later will match the statement’s home-currency total and lose the foreign amounts you never wrote down. The foreign amounts are how you notice that one day, not the trip in general, ran away from the meal ceilings in how to budget meals.

The log can live in a shared note

A trip note can hold the two columns, and a shared trip lets a second payer add the currency they actually used. Forward or paste a booking confirmation when the spend is a reservation Tineo parses, including flights, lodging, trains, ferries, transfers, and activities. The posted card amount is still a figure you type over the estimate. Itineraries can sync for offline use. The statement comparison waits until you have the post. Connecting Gmail is optional, and it does not read your card statement into the note.

Frequently asked questions

How do I track a trip spent in two currencies?

Give every purchase a row in the currency you handed over. Fill the other currency only from a cash-exchange receipt or from the amount the card posts. Keep a running total for each currency in its own column.

When do I convert a card purchase into my home currency?

When the statement or the banking app posts the charge. Before that, the home-currency cell stays blank or carries an estimate you have dated and marked as an estimate. The posted figure replaces the estimate.

Can I add foreign currency and home currency in one sum?

Add them only after each foreign row has its own posted or exchanged home-currency amount. A mixed column of euros and home-currency units is not a total. It is two currencies written in one place.

What rate do I use for cash?

Use the rate on the receipt for the exchange you actually made: how much home currency you paid, and how much foreign currency you received. A reference rate is a labeled estimate for rows that have no receipt yet.

Sources