On Fri, Jul 19, 2019 at 5:37 AM Paulo Phagula <[email protected]> wrote:
>
> Hi,
>
> I'd like to know how I should go about tracking transactions with multiple
> currencies in ledger. To give more context, let me explain my situation.
>
> I live in Mozambique so all of my transactions are made in MT (MZM), I use
> some services like Dropbox and Netflix which are paid in USD. I buy books on
> Amazon UK and thus have payments done in GBP. I travel to South Africa to buy
> some stuff in ZAR.
> For each transaction made typically the bank will send me a notification
> telling me how much I paid in MT and the equivalent in the forex currency.
>
> Even though Mozambique's central bank publishes rates all of these
> currencies, I find I cannot use commodity pricing (P) entries in my ledger
> because in the end of the day each bank has a different exchange rate, and on
> the same day I can make 2 forex payments in the same currency using two
> different banks.
>
> How should I go about booking these transactions?
>
Greetings
I do not use your base currency but I do also use multiple currencies.
For my purposes I use a system that goes like this.
some date some weird payee
; booked as $142.34 usd @ 1.372563 base currency
Expense: blahblah: myexpensecode numberinmybasecurrency
Expense: blahblah2: expensecode2
numberinmybasecurrency
Expense: tax: expensecode3
numberinmybasecurrency
Asset: creditcard1: assetcode
numberinmybasecurrency
my system requires more computational effort (need to calculate every
number in the home currency) but also allows me to track every part of
the expense accurately.
Yes this is a nuisance when there are 8 items in the transaction but
then my system allows me the granularity to follow lots of detail.
This way every transaction can have its own exchange rate. I am
finding that credit cards have different rates at different times as
well so I am not trying to use one exchange rate as a basis for all
transactions for the day.
When I travel and exchange an amount of the base currency into the
foreign currency in cash I treat that transaction as above.
Then when I use the foreign cash to purchase I use my system (above)
and a FX info service (usually Oanda) to find an exchange rate.
This isn't necessarily accurate (as Oanda reports use a different
system for reporting (its more a mid level rate than a retail rate
(and there are lots of those)) but that inaccuracy isn't going to show
until amounts in 4 figures or more are used.
HTH
--
---
You received this message because you are subscribed to the Google Groups
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ledger-cli/CAPpdf5-fAy2qO5UJSeX6VDpqUK%2BHH7QUHYB-9byt7F801SJ-HA%40mail.gmail.com.