[GNC] Scheduled Transaction with Currency Conversion
sunfish62 at yahoo.com
sunfish62 at yahoo.com
Wed Sep 4 12:14:44 EDT 2024
In my (limited) experience, the conversion rate dialog allows you to enter a rate *or a destination amount*. I always use the destination amount in this dialog, since I know how many CHF (to use your example) I received, but never the rate to 34 decimal places, which is what GnuCash seems to want.
This is something that annoys me immensely, BTW. It's opposite to what it should be; I'll note it is recommended that GnuCash commodity transactions be entered with dollar value and shares (the "foreign" currency), and leave the price per share empty, since that is never stored anyhow. Why would currency transactions operate differently?
Also, while I haven't tried using a scheduled transaction for what you're doing, I'll note that if you simply use auto complete to enter these transactions, the exchange dialog will NOT trigger if the local value is unchanged. It will use the last value in the transaction. However, you can open the transaction and edit the exchange rate (as above) to change the destination amount. Personally, that seems as easy as using the scheduled transaction method you're trying.
David T.
On Sep 4, 2024, 2:21 PM, at 2:21 PM, rsbrux via gnucash-user <gnucash-user at gnucash.org> wrote:
>We have monthly transactions where a payment in USD is credited to a
>CHF
>bank account. The USD amount is fixed, but the CHF amount varies
>depending on the conversion rate. As has been recommended on this list,
>
>I have configured these as scheduled transactions with a variable in
>place of the CHF amount . However, when the scheduled transaction
>triggers in GnuCash, I am asked to fill in both the CHF amount *and*
>the
>USD -> CHF conversion rate. Unfortunately the bank notification does
>not
>include the conversion rate. In fact the bank doesn't even know the
>conversion rate, because this is determined by the payor, which
>performs
>the conversion before the bank deposit. We don't receive any
>notification from the payor (U.S. Social Security). IMHO, it should be
>enough to supply *either* the credited amount in CHF *or* the USD ->
>CHF
>conversion rate, since GnuCash can calculate one from the other, but GC
>
>won't allow me to click "OK" without supplying the USD -> CHF
>conversion
>rate explicitly. The scheduled transaction template has no place to
>enter the conversion rate, otherwise I would put in a formula based on
>the variable CHF amount. How can I get the scheduled transactions to
>complete, without knowing the conversion rate?
>
>_______________________________________________
>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