[GNC] How to handle recurring transactions with currency conversion
Tommy Trussell
tommy.trussell at gmail.com
Wed Jul 3 14:26:37 EDT 2024
You might try using one or more variables in a scheduled transaction and it
will prompt you for the variable amount(s) when it creates the transaction.
SO for example, if you put the letters "amount" (without quotation marks)
in the credit AND debit portions of the scheduled transaction template, it
will prompt you for the "amount" in the Since Last Run dialog.
Alternatively, you could prompt for the USD / CHF exchange rate, maybe
"exch_rate", and create a formula using that variable and the scheduled
transaction will prompt for it. Scheduled transactions can perform all the
math functions you can do when you're entering transactions.
If you don't have a way to know the exact amount until later (for your
example, the earliest you can find the CHF exchange rate the US Treasury
uses is after you see the transaction at the bank) it's probably easiest to
put in a "placeholder" amount, maybe the number from a typical month, and
if it gets too far off from reality you can update the scheduled
transaction. In that sort of situation I also enter a very visible comment
in the transaction note such as "?? AMOUNT ??" that I remove when I go
through reconciling the account.
On Wed, Jul 3, 2024 at 10:44 AM William Prescott <will at theprescotts.com>
wrote:
> You can leave the amount blank on the scheduled transactions. Just put in
> the lines for the accounts. It will create the transactions on schedule and
> you just have to fill in the amount when you have it. I'm not sure if that
> is helpful.
>
> Best wishes,
> Will
>
> On 3 Jul 2024, at 6:08, rsbrux via gnucash-user <gnucash-user at gnucash.org>
> wrote:
>
> We receive monthly payments from U.S. Social Security. These werre
> previously paid out in U.S. dollars (USD) but are now paid out in Swiss
> Francs (CHF).
>
> I previously handled these with a scheduled transaction, since the amounts
> remained the same over at least a year, but this doesn't work anymore.
>
> Since the income account is in USD, each deposit (to a CHF account) is now
> associated with a currency conversion rate determined ad hoc by the U.S.
> Social Security Administration.
>
> Is there an elegant way to handle this, perhaps with a scheduled
> transaction having a constant USD amount and prompting for a conversion
> foctor, or should I just give up and create a corresponding income account
> in CHF and enter the transactions manually?
>
> Is there an alternative solution that I haven't thought of?
>
> Thanks in advance for any tips!
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
More information about the gnucash-user
mailing list