historical currency rates

[Traffic]

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]

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]

Thanks, but I have hundreds of items at different dates so going and checking one date at a time is not practical

[4Q]

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]

I used to use the following when doing historic currency conversion: https://fxds-hcc.oanda.com/

[mikef]

Excel stockhistory function?

[Greatesthit12]

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]

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.