"travel money card"
Can the software account for teh various currencies or should I be using a work arround such as having several accounts in Quicken for the same card - each with a difference currency?
Comments
-
Alex,
My daughter is travelling with one of these multi-currency debit cards and I am trying to monitor the transactions in a spread sheet. I am finding it a challenge.
Each currency has a "bucket".
Some transactions can sometimes be posted in a different currency to the currency of that bucket, sometimes split between buckets, sometimes without fees and sometimes with fees. Confusion reigns when some buckets become empty.
Currency conversion rates also vary with time, so I was looking to have a lookup table of conversion rates, although these rates vary depending if there is a real or virtual conversion.
Unfortunately, there is not sufficient detail provided to track these conversions.
I would recommend you try to set up a multi-currency spread sheet to monitor the type of transactions that occur, both between currencies and between buckets. You need to think laterally to get there. There does appear to be some logic to it and I did get close, but still out by 1-2%. It did help to understand what types of transfer transactions can be applied.
I am not surprised that RPP can not do this.
In the end, I found it too hard. I eventually concluded my problem is not trying to monitor the transactions but actually trying to stop them !! There were holes in the buckets !!
John
1 -
Alex
I like and use the idea of setting up notional 'cards' for each of the currencies and entering the transactions in the relevant 'card' . This is what I do in most instances though for me there are only $AUD, $US and RMB.
The transfers that occur between each 'card' and the funding source, either external or between the 'card' currencies, I post to a currency exchange account so that each 'card' currency has pure transactions only.
Like John there are always differences caused by exchange rates, fees and charges, commissions etc. I don't try and resolve those as it is not that material. In fact I manually enter an exchange rate for each currency based on the initial funding rates and do not change that for the trip.
Try it out with an $AUD and say $US and process some testing transactions so you are confident it will suite your needs in a copy of your DB. Not too many, they can always be deleted if you don't like the results.
And there is always the spreadsheet if you need more detail and accuracy.
Malcolm
1 -
Malincan, you beat me to the punch, I was going to suggest creating virtual accounts per foreign currency, what you refer to as 'notional' cards. I do this with Paypal, I've got AUD, US & UK virtual Paypal accounts but only one real/physical Paypal account.
2 -
Thanks to all. I have created the dummy card accounts and it now all works fine. Fortunately CBA provides a balance for each currency so I can reconcile each one - just have to do it 4 times instead of once, but no big deal. I can transfer money from an AUD account to any of the others. It calculates on the updated exchange rate, but I can also enter the actual foreign currency and the right amount comes out and goes in like a 'normal' transfer.
0
Categories
- All Categories
- 6.4K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 5.9K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.3K Reckon Payroll 🚀
- 21 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 3K Reckon One
- 7 📢 Reckon One - Announcements
- 10 Reckon Invoices App
- 14 Reckon Insights
- 107 Reckon API
- 822 Payroll Premier
- 307 Point of Sale
- 1.9K Personal Plus and Home & Business
- 63 About Reckon Community