Currency formulas for CSV export

savedave

Hi there

What formulas would I use to create the following output:

Col 1: original currency
Col 2: total in original currency
Col 3: amount in GBP (my default currency)

(As an aside, I use a % increase on foreign currency transactions. I wouldn't want this to influence transactions made in my default currency)

marshallsteeves

Could you use something like this:

Col 1: {expense:currency}

Col 2: {expense:amount:{expense:currency}:nosymbol}

Col 3: {expense:amount:GBP}

The third column is essentially converting the original amount to the specified currency (in your case, I used GBP - separated by a colon and the currency symbol).

Sheena Trepanier

Hi @savedave, welcome! You can find a full list of formula in our Help Center, I hope this helps!

Formula

Cheers!