Travel and vehicles

Which exchange rate should expenses use? A pounds example

Compare the card statement rate, a published daily rate and today's rate for foreign expenses, with a pounds example and a simple rule for choosing.

Editorial illustration for Which exchange rate should expenses use? A pounds example

Use the rate that was in force when the money moved, and where your card statement shows the pounds actually charged, use that figure directly. Daily published rates and today's rate are useful, but they are second and third choices for records of past spending.

The numbers here are invented. Nothing below is guidance on tax or accounting treatment.

Three rates, three purposes

  • Statement figure: what you actually paid. Best for a personal record.
  • Published daily rate: a neutral reference. Useful when you have no statement line, such as cash you cannot trace.
  • Today's rate: what it would cost now. Useful for planning, not for recording.

What happens if you use today's rate?

Say you bought a conference ticket for 300 euros in the spring, and your card was charged 258 pounds. Reading it back in the autumn at a rate of 0.89 pounds per euro gives 267, nine pounds more than you paid, because 300 times 0.89 is 267. Your record now says you spent 267, but your statement says 258, and the gap has nothing to do with your behaviour.

How should the rate be written down?

PurchaseForeign amountPounds chargedRate (£ per €)
Conference ticket€300258.000.86
Train in Spain€4841.760.87
Dinner€7262.640.87

The rates in the last column are calculated, for instance 258 divided by 300 is 0.86 and 41.76 divided by 48 is 0.87. Notice they differ a little, even though the purchases were close in time. That is a good reason to store the rate on each row.

What if you are invoicing in another currency?

Then there are two moments: the date of the invoice and the date the money arrives. Do not smooth them together. Record the invoice at the rate on its date if you are tracking what you earned, and record the money received at the pounds that arrived. The difference is a genuine gain or loss from the rate moving, and it should be visible rather than hidden. How such differences are treated for tax is a question for your accountant.

How do you pick a published rate if you need one?

  1. Choose one source and name it in your file.
  2. Use the rate for the transaction date, not the posting date.
  3. If the date was a weekend, use the last published rate before it and note that you did.
  4. Do not change source in the middle of a year.

Does the order of operations matter?

A little. If you enter the foreign amount first and let a sheet or app fill in pounds with a rate, check one row by hand: multiply the foreign amount by the rate and compare with the statement. A wrong rate typed once into a formula can silently spread through hundreds of rows. A thirty second spot check on three random rows each month catches it early, before a whole quarter has to be redone.

Where do cash purchases fit?

Cash has no statement line, so you need a rate you can defend. Use the average cost of the cash you bought, found by dividing the pounds you paid by the euros you received. If you bought cash twice, work out one blended figure across both lots and use it for every cash purchase. State this once at the top of the sheet. It is a fair method, it is easy to repeat, and it is close to what the cash actually cost you.

A last check

Add up the pounds in your sheet for one month and compare with the card statement for that month. If they match within a few pounds, your method works. If they differ, look for rows converted at today's rate instead of the day's.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports