[GNC] Fwd.: A new start - somewhat strange

[Norbert Klein]

My advice to you:

1. Do read the GnuCash concepts and tutorial guide, especially Chapter
12 /Multiple Currencies/
.

= =
To enable them go to File → Properties+Accounts tab and check the Use
Trading Accounts checkbox.
DONE
= =

2. Do enable Trading Accounts, as described in 12. /Automatically
Recording Currency Transactions using Trading Accounts/
.

I have always used them. (In fact, I cannot tell you what happens if you

do not use them, because I have not tried.

= =

But I have not yet found the place where I can enter my second currency
KHR - I only see the many things I will be able to do AFTER I will have
entered it.

Can you please help me trough this step?

= =

3. I second Paul Kroitor's excellent advice that you make a "test book"
for practice and experiments. Accept a default chart of accounts. Make a
few accounts in KHR currency. Enter a few test transactions. See how
things work.  Then set up your real book.


Of course I will do this.


4. I use the one currency structure for my asset accounts, and a
different currency structure for my expense accounts. See if either of
these makes sense for you.

I hope this is helpful.  Have fun with the experiments!

Best regards,

  —Jim DeLaHunt, Vancouver, Canada

Yes it is very helpful, Thanks, Norbert


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] A new start - somewhat strange

[Norbert Klein]

Thanks – moving on; I followed this:

1) Just create a new file:
 File -> New File (I called it spf2)

2) Save to a folder in your personal workspace. Just like you'd do with
your personal word processing files. - (I did it into gnucash on Documents)


Now I get the list of

Asets
Equity
Expenses
Income
Liabilities

and their sub-accounts which I created.

Question 1) I still think I should get a GnuCash Common Entry or
something, when I click on the GnuCach icon on the desktop. Wrong?

Question 2) Before I make entries into the accounts, I would like to
select a second currency (the Cambodian Riel) which I am using almost
daily, together with the US$ which is the main currency already set
during installation. I did some reading of the GnuCash documents, but I
did not find out how to start to do it. Any help with more detailed
recommendations please.
Some time ago, I saw on the list here a clear graphic example: the
Groceries heading, with two subheadings with two different currencies –
but my download was lost with my recent hard-disk crash.

Thanks for the really helpful helps so far!

Norbert
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] A new start - somewhat strange

[Norbert Klein]

Thanks - that helped me to do the next step:

   Just create a new file:

   File -> New File

I followed the recommendations, at the end I gave a name, and should
download everything to C:\Program Files
(x86)\gnuucash\bin]\spf-total.gnucash

BUT I got: ...may be on a read-only file system ... you may not have
write permission... or your anti-virus software is preventing this action.

Why? So what next?

I see the whole range of directories have been created:

*Assets*

*Expenses*

*Income*

*Liabilities*

but I cannot save what I created.

I beg to be aware that I do not have any people around (in the Cambodian
countryside, where I live) whom I could ask here...

But I still have a previous unsolved question: Why did I have to take
action (thanks for the advice!), initiating the creation of New Files -
is this not part of the setup? Any problem on my side?

Thanks for the help - we start moving.

Norbert

=


On 8/31/2022 21:46, David Carlson wrote:

Norbert,

That message means that GnuCash did not find and open an existing data
file so it is expecting you to create a new one.  Thus Derek's answer.

___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Change Linked Document Path

[Norbert Klein]

Similar to what I wrote yesterday (but no reaction yet) - I had a new
disk - no data files on a separate partition - but as my screen-print
showed, after installation there was no program visible on the screen,
but only the small note: "Unsaved Book - GnuCash"

Any idea what went wrong? Thanks for any help.

Norbert


On 8/29/2022 18:10, john murdoch wrote:

Hello

I did a clean reinstall on windows on my PC and then reinstalled GNU
Cash. My GNUCash data file was located on a separate partition so
following reinstallation I just opened the data file with GNU and that
all worked fine. However I also had linked documents located on the
separate partition.


My problem now is that GNU looks for the attached document in the
windows document folder on the C Drive. I have tried editing the
preferences in GNU to point to the correct location of the documents
on the alternate partition but this doesn't automatically link to the
document.


I can then manually link each document by using  the "manage document
link" function on the right click menu in the account field of GNU
cash. That  of course will be quite tedious and I was enquiring if
there is a "global fix" so that all files could be re-linked in one
procedure? Perhaps editing settings or the system registry?


I did try a feature as per the attached screenshot without any success.





___
gnucash-user mailing list
gnucash-user@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@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.

[GNC] A new start - somewhat strange

[Norbert Klein]

Self introduction: I am Norbert Klein, a 88 year old German, living
since 32 years in Cambodia.

Some years ago, I had been using GnuCash on a computer running under Ubuntu.

Some months ago, I wanted to set up GnuCash again, this time on a
computer using Windows  -  but before I could move ahead, I had a
hard-disk failure and had to get a news hard-disk.

Now I wanted to start again, Windows 10, GnuCash 4.11-1 setup
downloaded, I accepted all suggestions during setup; at the end I saw
the GnuCash icon on the desktop. I clicked on it, expecting some kind of
initial GnuCash program – but I got only this:

“Unsaved Book – GnuCash”




















Before I might make some mistakes, I rather ask. Any suggestions? Please…

Norbert – nhkl...@mgmx.net




___
gnucash-user mailing list
gnucash-user@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.

[GNC] GnuCash installation problems

[Norbert Klein]

After installation (in Windows 10), I get when I click the GnuCash icon
on the desktop, in “Program Files (x86)” the following.  But it says
“Unsaved Book” – and the screen shows:

bin
doc
etc
lib
share
uninstall

I tried to find a “trigger” file to start GnuCash runnig – but I could not.

Maybe there is an installation error on my computer? Any helpful
suggestion please.

Norbert

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Multiple currencies

[Norbert Klein]

Thanks, David,

This kind of VERY simple example is really helpful for a beginner:

Expenses
- Groceries
- - USD (USD-denominated account)
- - KHR (KHR-denominated account)

Norbert

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Multiple currencies

[Norbert Klein]

Servus GNUcash helper,

thanks for the detailed advice - I am working through it.

But I get aware that my problems start sometime one more level down,
when I read: "When you create a new account, you have the option to
define the commodity in which that account is denominated."

Yes, I try to create a sample database, but "when I create a new
account" - I have not yet been able to define the commodity (in which
that account is denominated).

I hope to get it soon (others tell me at my ago of 88 I should just not
try new things. I do not agree.

Norbert


On 18-Jul-22 02:10, list+gnuc...@jdlh.com wrote:

Servus Norbert, welcome to GnuCash:

On 2022-07-16 22:14, Norbert Klein wrote:

I am a new gnucash user, living in Cambodia (since 32 years).

I downloaded (in Windows 10), installed and tried to set up gnucash with
the US$ as the basic currency (which was already set-up as a default). I
have not yet set up the accounts.

Then I tried to find out how to make it possible to use, in addition,
also the Cambodian currency - the Riel - which is used here,
alternatively to the US$, every day. The Riel is available as one of the
currencies that can be used in gnucash.

I spent quite some time reading gnucash documents, but so far without
success. I would be most grateful if somebody could help me.


I have used GnuCash for many years with a book that included
transactions in Canadian Dollars, US Dollars, Euros,  Japanese Yen,
and more. It all works quite well. I can encourage you that what you
seek is definitely possible.

My advice to you:

1. Do read the GnuCash concepts and tutorial guide, especially Chapter
12 /Multiple Currencies/
<https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_currency.html>.

2. Do enable Trading Accounts, as described in 12. /Automatically
Recording Currency Transactions using Trading Accounts/
<https://www.gnucash.org/docs/v4/C/gnucash-guide/currency_trading_accts.html>.
I have always used them. (In fact, I cannot tell you what happens if
you do not use them, because I have not tried.

3. I second Paul Kroitor's excellent advice that you make a "test
book" for practice and experiments. Accept a default chart of
accounts. Make a few accounts in KHR currency. Enter a few test
transactions. See how things work.  Then set up your real book.

4. I use the one currency structure for my asset accounts, and a
different currency structure for my expense accounts. See if either of
these makes sense for you.

a. Who / Currency / Category / Detail structure, which I use in my
Asset accounts.

Level 1: Who, i.e. Personal assets vs My Business assets.
Level 2: Currency, e.g. CAD Personal assets vs USD Personal assets.
Level 3: Category, adopted from GnuCash suggested chart of accounts,
i.e. Current Assets, Investments, Accounts Receivable
Level 4: Detail, adopted from specific bank accounts and investment
accounts, e.g. Credit Union Chequing, Cash, Brokerage Account Cash
Balance.

e.g. Assets:Personal Assets:CAD Personal Assets:Current Assets:Credit
Union Chequing
Assets:Personal Assets:CAD Personal Assets:Current Assets:Cash CAD in
pocket
Assets:Personal Assets:USD Personal Assets:Investments:Brokerage
account:USD Cash Balance
Assets:Business Assets:USD Personal Assets:Current Assets:Paypal acct USD

b. Who / Detail / Currency structure, which I use in my Expense accounts.

Level 1: Who, i.e. Personal expenses vs My Business expenses.
Level 2: Detail, adopted from GnuCash suggested chart of accounts,
modified by my own needs, i.e. Rent, Groceries, Dining
Level 3: Currency, e.g. CAD Groceries vs USD Groceries.

e.g. Expenses:Personal Expenses:Groceries:CAD Groceries
Expenses:Personal Expenses:Groceries:USD Groceries
Expenses:Personal Expenses:Groceries:CAD Rent
Expenses:Business Expenses:Computer Accessories:CAD Computer Accessories
Expenses:Business Expenses:Computer Accessories:USD Computer Accessories

I enter way more Expense account paths than Asset account paths. This
currency-last structure makes it easier for GnuCash to complete each
segment of the path when I type just the first few characters. If I
type "Ex:P:Gro:C" then GnuCash expands those initial characters to
"Expenses:Personal Expenses:Groceries:CAD Groceries".

5. Don't feel like you have to get the account tree right the first
time. You can change the structure and the account names later, and
the transactions will move with the changes.

Or more accurately: when you create an Account, GnuCash gives it a
unique identifier behind the scenes. The transactions are linked to
these unique identifiers, not to the Account's name or parent
accounts. When you change the Account's name, or move it to a
different parent Account, the identifier remains unchanged. Thus the
transactions are still attached to the account, despite its new name
and parent.

I hope this is helpful.  Have fun with the experiments!

Best regards,

Re: [GNC] Multiple currencies

[Norbert Klein]

Thanks, Paul (yours was the first), and several others who responded.

My responses are often late, because my Internet access (in the
countryside in Cambodia) is not regular and stable.

Thanks a lot!

Norbert


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Multiple currencies

[Norbert Klein]

I am a new gnucash user, living in Cambodia (since 32 years).

I downloaded (in Windows 10), installed and tried to set up gnucash with
the US$ as the basic currency (which was already set-up as a default). I
have not yet set up the accounts.

Then I tried to find out how to make it possible to use, in addition,
also the Cambodian currency - the Riel - which is used here,
alternatively to the US$, every day. The Riel is available as one of the
currencies that can be used in gnucash.

I spent quite some time reading gnucash documents, but so far without
success. I would be most grateful if somebody could help me.

Norbert (Klein) - a German

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to move my Windows 10 2.6.17 to a new Windows, 10 machine?

[Norbert Klein]

Thanks, Stan,

for sharing your work with all.

But it only makes me feel sorry - I am a non-programmer user of GnuCash :-(

I still hope there will be - some time in the not too distant future - a 
program which can be used also by a non-programmer to move a well 
working GnuCash system from one Widows 10 computer to a new Windows 10 
computer.


Still not giving up hope.

Norbert


On 13.7.2018 5:29, Stan Brown wrote:

Dick, here is a batch file I use to save and restore my GnuCash settings
and reports, for transferring them between machines.  You'd need to
change my file names and paths to yours, but still it could save you
some time.

If you don't want to be elaborate as I am -- my batch files tend to be a
bit over-engineered -- just look for the "reg" lines. Those are the ones
that save or restore the settings and reports.


@set MYECHO=echo off
@%MYECHO
set RZIPNAME=_stanReports.zip
set GFILNAME=_stanSettings.reg
setlocal
set MYNAME=%@name[%0]
if "%1" ne "/?" .and. "%1" ne "-?" .and. "%1" ne "" goto 000_Start
echo off
echo.
echo %MYNAME: Save or restore GnuCash settings
echo.
echo options:
echo /q Quiet
echo /v Verbose
echo /purge Delete saved log files (used with "save" or "apply")
echo save   Save settings
echo apply  Apply saved settings
echo purge  Delete saved log files.
echo Just one of 'save', 'apply', 'purge' is required.
echo.
echo Settings are saved in %GFILNAME and %RZIPNAME, in the same
echo folder as the GnuCash accounting file.
quit

2018-02-25  new program
2018-03-21  Add the purge option.
2018-03-31  With 'purge', suppress error message if there are no files ...
2018-04-01  ... and also delete GnuCash files in %TEMP%.
2018-04-18  Add /purge as an option, used with "save" or "apply".
2018-05-05  Program didn't abort after an an unknown option.

 Copyright 2018 Stan Brown, Oak Road Systems  http://oakroadsystems.com/

:000_Start

:: Scan the options.
set ACTION=none
set PURGING=0
set VERBOSE=1
do while "%1" ne ""
 iff %1 == save .or. %1 == apply .or. %1 == purge then
 iff %ACTION ne none then
 echo %MYNAME: Only one of 'save', 'apply', purge is allowed.
 cancel
 endiff
 set ACTION=%@lower[%1]
 elseiff %1 == /q then
 set VERBOSE=0
 elseiff %1 == /v then
 set VERBOSE=2
 elseiff %1 == /purge then
 set PURGING=1
 else
 echo %MYNAME: Unknown option '%1'.
 cancel 2
 endiff
 shift
enddo
iff %ACTION == none then
 echo %MYNAME: You need one of 'save', 'apply', or 'purge'.
 cancel
elseiff %VERBOSE == 2 then
 echo %MYNAME: Plaanning to %ACTION the %@if[%ACTION == 
purge,files,settings].
 echo.
endiff

:: Check existence of files and folders.
 set GDIR=e:\sb\$\GnuCash
iff not isdir "%GDIR" then
 echo %MYNAME: Financials folder '%GDIR' not found.
 cancel
elseiff not exist "%GDIR\Stan.gnucash" then
 echo %MYNAME: File Stan.gnucash not found in '%GDIR'.
 cancel
endiff
set RDIR=%USERPROFILE\.gnucash
set RZIP=%GDIR\%RZIPNAME
set GKEY=HKCU\Software\GSettings\org\gnucash
set GFIL=%GDIR\%GFILNAME
iff %VERBOSE == 2 then
 echo %MYNAME: Financial database is in folder '%GDIR'.
 echo %MYNAME: GnuCash reports are in folder '%RDIR'.
 echo %MYNAME: GnuCash reports are zipped in file '%RZIP'.
 echo %MYNAME: GnuCash settings are in '%GKEY'.
 echo %MYNAME: GnuCash settings are exported to file '%GFIL'.
 echo.
endiff

iff %ACTION == save then
 if %PURGING == 1 gosub PurgeAction
 iff not isdir "%RDIR" then
 echo %MYNAME: Reports folder '%RDIR' not found.
 cancel
 endiff
 pushd "%RDIR"
 set ZIPOPT=
 set OPTS=-r -T -o
 if %VERBOSE lt 2 set OPTS=%OPTS -q
 @if %VERBOSE ge 1 echo on
 zip %OPTS "%RZIP" *
 @%MYECHO
 @echo.
 popd
 @if %VERBOSE ge 1 echo on
 reg export %GKEY "%GFIL" /y
 @%MYECHO

elseiff %ACTION == apply then
 if %PURGING == 1 gosub PurgeAction
 iff not exist "%GFIL" then
 echo %MYNAME: Registy export file '%GFIL' not found.
 cancel
 endiff
 iff not exist "%RZIP" then
 echo %MYNAME: Reports ZIP file '%RZIP' not found.
 cancel
 endiff
 iff not isdir "%RDIR" then
 echo %MYNAME: Reports folder '%RDIR' not found.
 input /c /k"yYnN" /l1 Create it?^  %%X
 echo.
 if %X == N cancel
 md "%RDIR"
 endiff
 set OPTS=-uo
 if %VERBOSE == 0 set OPTS=%OPTS -q
 @if %VERBOSE ge 1 echo on
 unzip %OPTS "%RZIP" -d "%RDIR"
 @%MYECHO
 @echo.
 @if %VERBOSE ge 1 echo on
 reg delete %GKEY /f
 @echo.
 reg import "%GFIL"
 @%MYECHO

elseiff %ACTION == purge then
 gosub PurgeAction

else
 echo %MYNAME: Internal error: %%ACTION = '%ACTION'
 cancel

Re: [GNC] How to regularly use two currencies

[Norbert Klein]

Thanks, Geert,

for you clear and specific suggestions.

I think they will result in what I need - I will try to implement it and 
will let you (and gnucash-user@gnucash.org) know after some days.


There will be - as far as I can see now - only one additional procedure 
necessary (and a short additional time) for every shop action: to do the 
transaction from Riel to US$. But that is OK if all the other results 
will be what we need.


Thanks again for thinking through our special Cambodian "regularly two 
currencies" situation.


Norbert

=


On 30.6.2018 17:56, Geert Janssens wrote:

Hi Norbert,

While you seem to think you want to account in multiple currencies, your
replies so far all suggest you only want to track payments in multiple
currencies.

I read these requirements:
Quote 1:
"I have to know - at the end of the  day - how many US$, and how many Riel,
should be in the cash boxes."
Quote 2:
"But while I have to keep track of the actual cash in the cash boxes, at
certain times (daily, weekly, monthly etc.) I also need to know "how we did as
a business" and this should say something in US$ (for all the activities which
did happen in both currencies)."

So essentially this says you want to keep track of two cash boxes: one in US$
and one in Riel. Yet in the end you estimate your business in US$.

So your income and expense accounts should only exist in US$, while in your
assets you will can two cash accounts: one in US$ and one in Riel.

When a customer pays you in Riel, you make a transaction from your Riel cash
box account to your single income account (which is in US$) and apply the
exchange rate from Riel to US$ to that transaction. By default gnucash will
ask you for this exchange rate. If a customer pays in US$ you create a
transaction from your US$ cash box account to your income account. As the
currencies match there's no conversion rate to apply.

The same goes if you pay for expenses or goods to a supplier. If you pay in
Riel you create a transaction from the Riel cash box account to the
appropriate expense account (which is always in US$). If you pay in US$ the
money goes out of your US$ cash box account into the (same) US$ expense
account.

That will give you all the information you request:
Do you want to know what's in your cash boxes ? Check the appropriate cash box
account or generate a report over it.
Do you want to know how you did as a business ? Generate a report over your
income/expense accounts which are in US$.

Unless you have other requirements you didn't mention I don't think you need
the parent/multi-currency-subaccount structure in your income and expense
accounts as you have currently set up. And it will probably simplify your
accounting if you could do without.

Regards,

Geert

Op zaterdag 30 juni 2018 11:58:51 CEST schreef Norbert Klein:

Thanks, Geert,

I will respond between the lines.

On 29.6.2018 17:58, Geert Janssens wrote:

Hi Norbert,

I don't know the accounting customs of your country,

There are no general accounting customs set - everybody does what seems
to cover the needs of he place.


so first a question:
Is it common in Cambodia to *account* in two currencies as well or only to
*pay* in two currencies ?

In daily life, we may *pay* in either of the two currencies - it is only
customary to make payments in Riel for small and in US$ for larger
amounts. But again, there is no general definition what is "larger" - it
is easier to handle bigger "values" in US$, where 1 US$ corresponds to
roughly 4000 Riels.

We may ask in our shop - as an example - for a price of US$ 4.00, but
the person may hand over 16,000 Riel. Or the other way round. I do not
know if there are many countries with such a situation. But here it is
totally flexible - every person, for every purchase, may choose one way,
and the next minute for another purchase the other way.

So the answer is: BOTH - we pay in two currencies, but we also have to
account in two currencies.

So in the shop we have a Riel cash box, and a US$ cash box, and while we
enter for each purchase an amount - and I have to enter the amount
either into the "Cash in wallet $" or into the "Cash in wallet Riel" -
because we have all the time changes in both cash boxes. And for the
same purchase I enter the amount either into the sub-account "Vegetables
$" or "Vegetables R" - both under ONE Placeholder account "Vegetables"
(set for US$)


Or put differently - do you want to track your income in the two
currencies or just in one (hence the placeholder account) ?

For the actual conducting of purchases, I am tracking the US$ purchases
and the Riel purchases separately - but I put both under ONE placeholder
because I am not only interested in individual purchases, but also in
the overall income (or loss) situation. I had assumed to have a common
placeholder would serve this purpose. Maybe this was wrong.


But you

Re: [GNC] How to regularly use two currencies

[Norbert Klein]

Thanks, Geert,

I will respond between the lines.

On 29.6.2018 17:58, Geert Janssens wrote:

Hi Norbert,

I don't know the accounting customs of your country,
There are no general accounting customs set - everybody does what seems 
to cover the needs of he place.

so first a question:
Is it common in Cambodia to *account* in two currencies as well or only to
*pay* in two currencies ?
In daily life, we may *pay* in either of the two currencies - it is only 
customary to make payments in Riel for small and in US$ for larger 
amounts. But again, there is no general definition what is "larger" - it 
is easier to handle bigger "values" in US$, where 1 US$ corresponds to 
roughly 4000 Riels.


We may ask in our shop - as an example - for a price of US$ 4.00, but 
the person may hand over 16,000 Riel. Or the other way round. I do not 
know if there are many countries with such a situation. But here it is 
totally flexible - every person, for every purchase, may choose one way, 
and the next minute for another purchase the other way.


So the answer is: BOTH - we pay in two currencies, but we also have to 
account in two currencies.


So in the shop we have a Riel cash box, and a US$ cash box, and while we 
enter for each purchase an amount - and I have to enter the amount 
either into the "Cash in wallet $" or into the "Cash in wallet Riel" - 
because we have all the time changes in both cash boxes. And for the 
same purchase I enter the amount either into the sub-account "Vegetables 
$" or "Vegetables R" - both under ONE Placeholder account "Vegetables" 
(set for US$)

Or put differently - do you want to track your income in the two currencies or
just in one (hence the placeholder account) ?
For the actual conducting of purchases, I am tracking the US$ purchases 
and the Riel purchases separately - but I put both under ONE placeholder 
because I am not only interested in individual purchases, but also in 
the overall income (or loss) situation. I had assumed to have a common 
placeholder would serve this purpose. Maybe this was wrong.

But you do want to be able to
accept/make payments in the two currencies ?
Yes - it depends on the buyer - depending of which of the two currencies 
he of she has in their purse.

If you only want to accept/make payments in two currencies but just track it
in one, the account structure would be slightly different.
"track it only in one" - for the actual operation of the shop this is 
not possible. I have to know - at the end of the  day - how many US$, 
and how many Riel, should be in the cash boxes.

If you want to track your income in multiple currencies as you have set up,
you'll need to make sure you have entries in your price database for
conversion rates between USD and Cambodia Riel.
In my former mail, I had said: "(In Tools, Price Editor, I have set 
Khmer Riels as the second currency in addition to US$.)" - saying that 1 
US$ corresponds to 4000 Riel, with hardly any fluctuation. Any more to do?


But while I have to keep track of the actual cash in the cash boxes, at 
certain times (daily, weekly, monthly etc.) I also need to know "how we 
did as a business" and this should say something in US$ (for all the 
activities which did happen in both currencies).

Or more generally between your
book's currency and the foreign currencies you trade in.
Well, I do not feel that "we trade in a foreign currency" - both 
currencies co-exist here in everybody's wallet. Te bill from the 
electricity company comes in Riel, the bill from the ISP comes in US$ - etc.


So what else can you please suggest to me to do?

Really many thanks,

Norbert

Regards,

Geert




Op vrijdag 29 juni 2018 12:28:00 CEST schreef Norbert Klein:

How to regularly use two currencies

I would very much appreciate if somebody could help me to solve a problem.

In GnuCash 2.6.19,on a Windows 10 computer, I made the following
arrangements – but maybe my assumptions were wrong, as I cannot see the
results I had hope for. I do not have much experience, so I dare to ask
for advice and help.

I live in Cambodia, where it is usual all over the country to use two
currencies regularly: the Cambodian Riel, and the US$ (at normally 4000
Riel per Dollar).

(In Tools, Price Editor, I have set Khmer Riels as the second currency
in addition to US$.)

I live on a farm, where, among other things, we produce, sell, and buy
vegetables.

Under Income, I created an account FARM, and under FARM an account SHOP,
and under shop a Placeholder account VEGETABLES (currency USD). Under
VEGETABLES I created a VEG$ sub-account for business in US dollars, and
another sub-account VEGR for business in Riels.

Now I enter all business actions into VEG$ or VEGR, either as Income or
Charge, according to the currency used.

After some entries, I can see the calculated result (gain or loss) in
US$ in the Placeholder account VEGETABLES

[GNC] How to regularly use two currencies

[Norbert Klein]

How to regularly use two currencies

I would very much appreciate if somebody could help me to solve a problem.

In GnuCash 2.6.19,on a Windows 10 computer, I made the following 
arrangements – but maybe my assumptions were wrong, as I cannot see the 
results I had hope for. I do not have much experience, so I dare to ask 
for advice and help.


I live in Cambodia, where it is usual all over the country to use two 
currencies regularly: the Cambodian Riel, and the US$ (at normally 4000 
Riel per Dollar).


(In Tools, Price Editor, I have set Khmer Riels as the second currency 
in addition to US$.)


I live on a farm, where, among other things, we produce, sell, and buy 
vegetables.


Under Income, I created an account FARM, and under FARM an account SHOP, 
and under shop a Placeholder account VEGETABLES (currency USD). Under 
VEGETABLES I created a VEG$ sub-account for business in US dollars, and 
another sub-account VEGR for business in Riels.


Now I enter all business actions into VEG$ or VEGR, either as Income or 
Charge, according to the currency used.


After some entries, I can see the calculated result (gain or loss) in 
US$ in the Placeholder account VEGETABLES.


I had hoped that the entries in VEGR would be transferred into US$ and 
also be part of the reported results in the placeholder account 
VEGETABLES – but this is not the case.


Now my kind request:

1) please tell me if there is a way to get also the Riel values 
reflected in the Placeholder account above the VEGR; I had assumed that 
this should be possible with Placeholder accounts which are “intended to 
be used for hierarchical organization of accounts” - but maybe not when 
different currencies are involved?


2) please give me advice if all this is wrong – how could I handle our 
situation? Every purchase and sale has to be recorded in one of the two 
currencies.


My hope was to get the overall results in US dollars in this way – and 
the goal remains the same: at the end of he day/week/month, I want to 
know how we did manage – all calculated in US$.


Thanks for any help.

Norbert KLEIN

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Two currencies handling

[Norbert Klein]

Dear GnuCash Users,

I am fairly new here – no coding, just learning to use GnuCash 2.9.16 on 
Windows 10.


I live and work in Cambodia, on a farm, where I do some administration 
assistance.


In Cambodia, booth the Cambodian Riel (=KHR) and the US$ are legal, and 
both are being used everywhere and daily. So for many bookings (in and 
out) I have set up the possibility to enter either of the two 
currencies. The basic currency for the whole system is set to US$, with 
a standard exchange rate of US$1.00 to Khmer Riel = KHR4000.00


For Example (as we buy and sell vegetables):

I set an INCOME account “Vegetables” as a “Placeholder” marked for US$.

I set up two Sub-accounts under it, one in US$ and the other in KHR (and 
in both are Expense and Rebate [why is this called “rebate” and not 
“income”???] columns).


As it happens, there are vegetables SOLD in US$, and there are 
vegetables sold in US$, and I make the entries in the respective 
sub-accounts.


And there are vegetables BOUGHT in KHR, and there are vegetables bought 
also in KHR, and I make the entries in the respective sub-accounts.


Of course every sale or purchase in Vegetables is also shown (“double 
booking” system) in the “US$ Cash in Wallet” or the “KHR Cash in Wallet” 
accounts.


Now I thought GnuCash will add up the sub-accounts – one in US$ and the 
other, changing the KHR also into US$, and show the sum in the 
Placeholder above of the two.


But actually, the placeholder shows only the US$21.00 which were booked 
in the US$-Sub-Account, while the KHR2114400 are still only visible in 
the KHR-Sub-Account, where they were entered.


I can also change cash US$ to cash KHR, or the other way round, with 
ACTIONS and TRANSFER – no problems.


Where/when/how are the Expenses/Incomes in KHR re-calculated and their 
exchanged values will be combined with the original US$ entries?


Please help me, I want to learn.

Norbert KLEIN

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: One account for both Income and Expenses possible?

[Norbert Klein]

Thank, Maf,

your advice was very clear and helpful - I rearranged what I had used 
before accordingly.


But you advised me also:


Let me start by saying that you should have started a new thread for your
question and not hijacked the existing thread
I am sorry - but when I started my mail with "One account for both 
Income and Expenses possible?" I was not aware that that this was an 
existing thread.


How can I check - when I start to write something again - that what I 
want to use is NOT YET an existing thread?


Thanks for any advice and help.

Norbert KLEIN
still quite new on GnuCash
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

One account for both Income and Expenses possible?

[Norbert Klein]

I am a complete newcomer to GNUcash, using version 2.6.19 on Windows 10.

My name is Norbert, living in the countryside in Cambodia.

This is my first posting.

Apologies for my very simple question. I would appreciate to get help.

I live on a farm – we produce, sell, and buy vegetables, fruits, and 
handicrafts.


When I set up a GNUcash system it created an Expense and an Income 
section, and under them I created specific accounts and sub-accounts.


When I now enter something like “Selling vegetables” I can enter the 
price under “Charge/Income” into Income. - When I enter something like 
“Buying vegetables” I can enter the income under “Expense/Rebate” into 
Expenses (and as a double-entry to Cash, increasing or decreasing).


The same for fruits, and for handicrafts.

But could I instead set up an account “Vegetables” where I can enter 
both BOUGHT Vegetables and SOLD Vegetables? (same for fruits and 
handicrafts)


When I tried to create such an account, I can select only ONE Account 
Type: Expense or Income.


Please kindly advise.


Norbert



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.