[GNC] Enhancement request: multi-currency accounts

G R Hewitt hewittgr at gmail.com
Wed Oct 19 02:01:37 EDT 2022


I use Sterling and Euros but like to know what the total Sterling value of
all accounts is.
I have the nominals set up in the two currencies, like has been explained
in others posts: 'Food£', 'Food€' etc.,
and have set up in the 'Price Database' Sterling and Euro securities as
'Currencies', which converts the Euros to Sterling,and this shows up in a
separate column ('Total GPB' in this case),
and also in the P&L and BS reports the Euro amounts and converted to
Sterling amounts also show. I don't know if this is the way the Price
Database should be used, but it works for me.

On Wed, 19 Oct 2022 at 01:45, R Losey <rlosey at gmail.com> wrote:

> For me, since my salary, bank, and credit cards are in USD, even when I
> spend EUR or CAN or AUS, I normally wait until the credit card expense
> shows up in USD and enter the USD value.  Often, I will put the actual
> local expense on the 2nd line (I don't remember if that is called
> Description or Memo in Gnucash).
>
> I said that to say that I think the proposal would generally be useful only
> if you actually have bank accounts, credit cards in multiple currencies.
>
>
> On Tue, Oct 18, 2022 at 4:19 PM David Carlson <david.carlson.417 at gmail.com
> >
> wrote:
>
> > This is interesting and it might be an optional configuration for the
> > automatic account creation wizard, but not for most users who use a
> single
> > currency in their accounting.  Also, this is not the usual place to
> propose
> > enhancements, but it would be a good place to refine a concept prior to
> > making an actual proposal.
> >
> > What do others think?
> >
> > On Tue, Oct 18, 2022 at 3:54 PM Anton Tsyganenko <
> > anton-tsyganenko at yandex.ru>
> > wrote:
> >
> > > Let's take a look on accounts that are created in gnucash by default.
> > > Generally most of the accounts may be multi-currency, i. e. not bond to
> > > a specific currency: you may have cash in multiple currencies, your
> > > opening balances may be in multiple currencies, you may have incomes
> and
> > > expenses in multiple currencies. Bank accounts generally have only one
> > > currency, but there are some banks that offer multi-currency cards and
> > > deposits. These surely can be considered as just a few different
> > > accounts, but it may be more convenient to group them together.Now I
> > > solve that by creating sub-accounts for each currency I need for each
> > > account where I need it. It looks like:
> > > Expenses:Dining:USD
> > > Expenses:Dining:EUR
> > > Expenses:Dining:CAD
> > > Expenses:Transport:USD
> > > Expenses:Transport:EUR
> > > Expenses:Transport:CAD
> > >
> > > It's very painful to create all of them. I know that I may have only
> one
> > > account in my _main_ currency, but I prefer all currencies to be equal
> > > and not perform redundant currency conversions, for example when I
> spend
> > > CAD cash for dining in Canada.
> > >
> > > So my proposal is:
> > >
> > > All accounts that user creates are "multi-currency", like placeholder
> > > accounts without any specific currency. Sub-accounts for each currency
> > > are created automatically, when the first operation in this currency in
> > > this account is made. If a multi-currency account is deleted and
> > > operations are moved to another account, operations in all the
> > > subaccounts are moved to the corresponding subaccounts of the second
> > > account. Balances can be shown as a sum of (non-null) amounts in
> > > different currencies (but sometimes can be converted to one currency).
> > > In a multi-currency account's view (basic ledger) there should be just
> > > an additional column -- currency of an operation (editable as a
> > > drop-down menu). So user opens account "cash" and sees something like:
> > >
> > > Date | Description | Transfer | Debit | Credit | Currency | Balance
> > >
> > > 2022-10-18 | Dinner in a restaurant | Expenses:Dining | | 25 | EUR |
> 100
> > > USD + 55 EUR
> > >
> > > That operation is a transfer of 25 EUR from Assets:Cash:EUR to
> > > Expenses:Dining:EUR.
> > >
> > > I would be happy to discuss the concept.
> > > _______________________________________________
> > > 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.
> > >
> >
> >
> > --
> > David Carlson
> > _______________________________________________
> > 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.
> >
>
>
> --
> _________________________________
> Richard Losey
> rlosey at gmail.com
> Micah 6:8
> _______________________________________________
> 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