Exchange rate in Export


(Dominic Adshead) #1

Hi

I use my monzo card when travelling a broad for business.

So i can reconcile this with our expenses system I use the export function for the expenses category (obviously I also have my receipts)

What would be great is if you could add the exchange rate you got for each transaction to the export function rather than just the amount in foreign currency and the amount in GBP.


Making Monzo Better: The Big List
#2

I’m definitely going to pass this on to our product team, @doma2345!


(Jolin) #3

Assuming you open the exported file in a spreadsheet app, couldn’t you just add another column with a simple =E1/D1 formula (or whatever the relevant columns are)?


(Dominic Adshead) #4

@jzw95 you’re right I could, but i don’t have to, it is already held in the app under each transaction, I just want this information easily accessible for reconciliation rather than having to go into each individual transaction, it will also make it much easier when working with multiple different exchange rates and currencies which I often have to.


(Eddie B ) #5

I concur with jzw95, much easier to add a column which you can autofill in the spreadsheet.
I worked in Foreign Exchange, golden rule was Currency 1, Currency 2 & exchange rate are the three components. You only ever pass two of the three downstream through systems OR you get errors.
Reason being currency rates are usually to 4 decimal places, calculations will end up with the calculated currency being a potentially large number of decimal places which is rounded to two to get a meaningful answer.
i.e. if you get Currency 1, Currency 2 and exchange rate you will end up with numbers that don’t work because of the rounding. much better to have Currency 1, Currency 2 and derive the rate, that is what you will have actually have done the “real” exchange at. Make sense?


(Andrew Hinshaw) #6

This could be done in a spreadsheet but a soreadsheet is not accepted by my employer. It needs to be a ‘bank statement’ that shows either the exchange rate or both the local currency change and sterling amount.


(Andrew Hinshaw) #7

This makes sense but we currently only get 1 of those 3 in a statement. Sterling rate only.
The csv export produces currency 1 currency 2 but this info is not provided in the statement


(Andrew Hinshaw) #8

This is quite a dull thing to admit to but I’ve made an excel template. Took a bit of fannying on but now I can simply copy and paste the data from the csv file into my template on 1 sheet and I’ve got the data just the way i need it on the next sheet. :nerd_face: Exchange rate and all :ok_hand:
I think Monzo could be amazing for expenses.