historical currency rates

historical currency rates

Author
Discussion

Traffic

Original Poster:

360 posts

45 months

Friday 7th March
quotequote all
Hi,

I am putting together spreadsheets of my expenditure for my accountant, however there has been a lot of different purchases in different currencies. Is there somewhere I can get specific rates on historic dates over the past 2 years?

Thanks in advance

mikef

5,600 posts

266 months

Friday 7th March
quotequote all
I always used https://www.xe.com/en-gb/currencytables/ for expenses FX rates, although many expense submission systems do an automated conversion based on the tax date

Traffic

Original Poster:

360 posts

45 months

Friday 7th March
quotequote all
Thanks, but I have hundreds of items at different dates so going and checking one date at a time is not practical

4Q

3,555 posts

159 months

Friday 7th March
quotequote all
If you paid on a UK card or paid by transfer from your account they will have been converted to GBP by your bank. Unless you’re talking £1000’s, a small percentage either way won’t make a lot of difference so just pick a number that looks about right and use that.

WyrleyD

2,176 posts

163 months

Saturday 8th March
quotequote all
I used to use the following when doing historic currency conversion: https://fxds-hcc.oanda.com/

mikef

5,600 posts

266 months

Saturday 8th March
quotequote all
Excel stockhistory function?

Greatesthit12

93 posts

57 months

Wednesday 12th March
quotequote all
You can easily run a formula column in google sheets to calculate this. You would need:
- amount
- currency paid (USD, EUR, etc)
- date of transaction

Google sheets can then calculate for you in GBP based on details above. You just use the GOOGLEFINANCE function.

MustangGT

13,116 posts

295 months

Thursday 13th March
quotequote all
Traffic said:
Hi,

I am putting together spreadsheets of my expenditure for my accountant, however there has been a lot of different purchases in different currencies. Is there somewhere I can get specific rates on historic dates over the past 2 years?

Thanks in advance
Are you making payments using a card or bank account? If so, easy enough from the statements. If using cash then simply use the exchange rate you bought the currency at from the exchange receipt.