We are running a foreign currency cash account in addition to our sterling bank accounts. (The ability to do this is a fantastic feature!)
Just one issue with it. When exporting transactions into Excel, the amounts exported (money out and money in) are shown in sterling equivalent. This is fine and necessary, but I also need to see the same data in the target currency. That is, I need to have an Excel copy of the foreign currency amounts as they are shown on screen when I am maintaining the account data.
At the moment, I am having to export the transactions (in sterling), and then add extra columns manually to the spreadsheet to record the values in the foreign currency. This is not only a tedious process (it involves copying and pasting each transaction amount one by one from the data shown on screen), but it is also error-prone as I have found to my cost.
Would there be any possibility of modifying the export process for foreign currency accounts, so that money out and money in are each downloaded twice - once in sterling and once in the foreign currency? This would be a wonderful help to those (perhaps few) people like myself, who need to deal with accounts of this type.
Many thanks, Glenn. We are in a somewhat unusual situation: we are a small UK charity that funds peace and social work in the countries of the former Soviet Union. A large proportion of our charitable giving takes the form of cash grants in roubles to “micro” NGOs in Russia. For operational reasons we have to keep a substantial amount of our money in roubles in a cash box in Moscow. I have set this up in Quickfile as a foreign currency petty cash account. It is perhaps somewhat unusual in that all of the flow is one-way: the rouble balance is kept topped up by cash transfers (by various means) from the sterling bank account, and all the outgoings are in roubles. We never have to repatriate any of the roubles back into the UK (thank goodness, given how the exchange rate is going).
This is all working brilliantly, and the Quickfile facilities are all we need. The only small issue is having an easy means to download the foreign currency transactions into spreadsheets for distribution to (e.g.) our Board members. When the Board makes funding decisions the amounts are usually agreed in roubles rather than sterling, hence the importance of this data.
Hope that explains things! Glad to supply any more information if you are interested.
Yes I understand, and I can imagine the issues around tracking the GBP/RUB exchange rate the way things are right now!
Having the foreign currency amounts and local GBP amounts side by side in the CSV export would be very helpful and it’s actually simple for us to add this.
We are working on this today and I shall update you when it goes live, however that will most likely be early next week.
These changes have now been made on our developments system and will go live on the next release (later this week). I will update this thread when the changes are live.
On foreign currency accounts we are now including two additional columns on the CSV export to show debits and credits in currency as will as their Sterling equivalents.