> On 29/06/2018 I backed up my GNU file.
> I did some editing, entering additional transactions and
> reconciliations on the 30th, and today, without realizing that
> GNUcash had opened up my backup file instead.
I've been there, and I feel your pain. You've already seen people's
suggestions for the immediate situation, but here's how I stop myself
from making that mistake again.
I've hidden my shortcut to the GnuCash _program_, and instead have a
shortcut to my GnuCash _data file_. Windows recognizes the .gnucash file
type, and launches GnuCash with that data file. Internally I imagine
it's a command-line argument, so something similar should work in other
OSes, or at least you could make a shortcut or alias to "GnuCash {your
data file name}".
--
Regards,
Stan Brown
Tompkins County, New York, USA
http://BrownMath.com
http://OakRoadSystems.com
On 2018-07-01 04:01, gnucash-user-requ...@gnucash.org wrote:
> Send gnucash-user mailing list submissions to
> gnucash-user@gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-requ...@gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-ow...@gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
> 1. Re: Windows strawberry perl and online prices (David Carlson)
> 2. Re: Rethinking the placeholder account concept (was: Re:
> Fwd: The two modules) (Christian Kluge)
> 3. Re: How To Record an In-Kind Charitable Donation?
> (Mike or Penny Novack)
> 4. Re: How To Record an In-Kind Charitable Donation? (Rich Shepard)
> 5. Re: GnuCash 3.2 Released (DaveC49)
> 6. Re: Rethinking the placeholder account concept (was: Re:
> Fwd: The two modules) (DaveC49)
> 7. Re: Change Reconcile Starting Balance (D)
> 8. Re: How to regularly use two currencies (Norbert Klein)
> 9. My bad (Tony Vanson)
> 10. Re: My bad (Colin Law)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sat, 30 Jun 2018 16:17:00 -0500
> From: David Carlson <david.carlson....@gmail.com>
> To: Tim Kallmer <tkall...@gmail.com>
> Cc: Gnucash Users <gnucash-user@gnucash.org>
> Subject: Re: [GNC] Windows strawberry perl and online prices
> Message-ID:
> <cadygsbkmcarx_+yuabz7vqx_qw5shrer89jzqtpbskh0tmy...@mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> Actually, I have a very similar problem which I have not had time to track
> down yet. I think that it is somewhere in the Finance:Quote configuration,
> but I am not sure.
>
> David C
>
> On Sat, Jun 30, 2018 at 3:24 PM, Tim Kallmer <tkall...@gmail.com> wrote:
>
>> ?I actually did uninstall strawberry perl and the leftover strawberry
>> folder when I went to 3.2, and when I went back to 2.6. It didn't make a
>> difference.?
>>
>>
>> On Sat, Jun 30, 2018 at 12:00 PM, David Carlson <
>> david.carlson....@gmail.com> wrote:
>>
>>> There has been some discussion in this list recently suggesting that
>>> especially when changing between releases from the 2..6 series and 3.0, 3.1
>>> or 3.2, one should uninstall the previous version manually. In Windows,
>>> the Control Panel uninstall feature should work. If you did not do that
>>> you may need to manually delete some files before installing a new
>>> version. I am not sure where to look for detailed instructions.
>>>
>>> I think 3.2 or 2.6.21 are the preferred releases, depending on which
>>> works better for you.
>>>
>>> David C
>>>
>>> On Sat, Jun 30, 2018 at 10:40 AM, Tim Kallmer <tkall...@gmail.com> wrote:
>>>
>>>> Has anyone using gnucash on windows had online prices stop working? For
>>>> me
>>>> the strawberry perl window opens and never finishes after hours of
>>>> waiting.
>>>> I eventually have to close the window and give up. I've tried
>>>> un/reinstalling gnucash and perl. I've tried 3.1 and 3.2 and 2.6. I've
>>>> double-checked my alphavantage key is correct. Any suggestions?
>>>> _______________________________________________
>>>> 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.
>>>>
>>>
>>>
>>
>
>
> ------------------------------
>
> Message: 2
> Date: Sat, 30 Jun 2018 23:23:49 +0200
> From: Christian Kluge <frakturfr...@gmail.com>
> To: gnucash-u...@lists.gnucash.org
> Subject: Re: [GNC] Rethinking the placeholder account concept (was:
> Re: Fwd: The two modules)
> Message-ID: <ph8s91$45m$1...@blaine.gmane.org>
> Content-Type: text/plain; charset=utf-8
>
> Am 30.06.2018 um 22:52 schrieb John Ralls:
>>
>>
>>> On Jun 30, 2018, at 12:00 PM, Christian Kluge <frakturfr...@gmail.com>
>>> wrote:
>>>
>>> Am 30.06.2018 um 05:37 schrieb John Ralls:
>>>>
>>>>
>>>>> On Jun 29, 2018, at 3:26 PM, Christian Kluge <frakturfr...@gmail.com>
>>>>> wrote:
>>>>>
>>>>> Hi,
>>>>>
>>>>> Am 29.06.2018 um 19:26 schrieb John Ralls:
>>>>>>
>>>>>>
>>>>>>> On Jun 29, 2018, at 9:52 AM, Geert Janssens
>>>>>>> <geert.gnuc...@kobaltwit.be> wrote:
>>>>>>>
>>>>>>> Op vrijdag 29 juni 2018 16:59:07 CEST schreef John Ralls:
>>>>>>>> Stock accounts need to have a parent denominated the currency in which
>>>>>>>> the
>>>>>>>> stock trades in order for the asset roll-up to work correctly on the
>>>>>>>> Accounts page. Three-commodity transactions are possible using trading
>>>>>>>> accounts, but I haven?t dealt with that stuff in a while and the
>>>>>>>> details
>>>>>>>> have gone fuzzy on me.
>>>>>>>>
>>>>>>>> Stock accounts aside, let?s not conflate different purposes. We
>>>>>>>> *should*
>>>>>>>> have an account type to accommodate the European Passive account with
>>>>>>>> Liability and Equity children, so let?s create that. We?ll need to
>>>>>>>> tweak
>>>>>>>> some of the reports a bit to accommodate it, but otherwise it won?t
>>>>>>>> have
>>>>>>>> much impact. It should, of course, be what we now call a placeholder
>>>>>>>> and it
>>>>>>>> should be able to have only Root as a parent and only one each
>>>>>>>> Liability
>>>>>>>> and Equity placeholder children.
>>>>>>>>
>>>>>>> I was in fact deliberately trying to come up with a solution that's
>>>>>>> more
>>>>>>> flexible than fitting the currently known use cases. The European
>>>>>>> Passive
>>>>>>> account was just one example.
>>>>>>>
>>>>>>> However we may be spending more time on it than necessary. I checked in
>>>>>>> the
>>>>>>> current version of the commercial accounting package* I also have to
>>>>>>> deal with
>>>>>>> and it doesn't define a Passive type at all. "Passive" it doesn't even
>>>>>>> appear
>>>>>>> on its default balance sheet. That is a bit uncommon though as the
>>>>>>> reports I
>>>>>>> get from my accountant do have a passive section. However just like
>>>>>>> gnucash
>>>>>>> this package is targeting a worldwide audience (though with country
>>>>>>> specific
>>>>>>> extensions). That may explain why they didn't bother adding the Passive
>>>>>>> section.
>>>>>>>
>>>>>>> Let me add that contrary to other accounting packages I have played
>>>>>>> with in
>>>>>>> gnucash the chart of accounts takes a very central place. So whether or
>>>>>>> not we
>>>>>>> want our own Passive type to group liabilities and equity
>>>>>>> hierarchically on
>>>>>>> the chart of accounts as well is up for debate.
>>>>>>>
>>>>>>>> I don?t think that creating a generic placeholder type account that
>>>>>>>> can have
>>>>>>>> children of any type is a good idea,
>>>>>>>
>>>>>>> Here's another example: a household that wants to track its finances,
>>>>>>> but
>>>>>>> would want to keep separate account hierarchies per family member.
>>>>>>> Standard
>>>>>>> response: create two files. However they would benefit from common
>>>>>>> reporting
>>>>>>> which is cumbersome with two separate files. So what if we would allow
>>>>>>> to
>>>>>>> create two independent account hierarchies in one file. With a view
>>>>>>> type
>>>>>>> account one could create two top-levels ("Husband" and "Wife") and
>>>>>>> create a
>>>>>>> independent hierarchy for each. While this could also be solved if we
>>>>>>> would
>>>>>>> allow multiple root accounts and make that root visible I'm using it
>>>>>>> here to
>>>>>>> illustrate there are use cases we are not covering well.
>>>>>>>
>>>>>>> I borrowed the idea of a view type account from an old version of the
>>>>>>> commercial package* we have to use. Looking more closely it turns out
>>>>>>> the
>>>>>>> current version has dropped view accounts and instead is organizing
>>>>>>> charts/
>>>>>>> reports using a combination of account type (roughly like we do) and
>>>>>>> hierarchical account numbers. So I must admit perhaps the idea was not
>>>>>>> so
>>>>>>> bright after all :)
>>>>>>>
>>>>>>> The package also doesn't have a hierarchical account tree. It's flat
>>>>>>> and
>>>>>>> hierarchy is only added in reports as explained above. So there is no
>>>>>>> such
>>>>>>> thing as a parent account in that package and hence no restriction on
>>>>>>> which
>>>>>>> account type a certain account can be.
>>>>>>>
>>>>>>> Again in gnucash the chart of accounts is very central and visible so
>>>>>>> we
>>>>>>> probably shouldn't drop its hierarchical structure just yet.
>>>>>>>
>>>>>>> The downside of this hierarchical structure is then of course we have
>>>>>>> to think
>>>>>>> about issues like whether or not we should allow accounts to have any
>>>>>>> type of
>>>>>>> child or not. I believe parts of gnucash rely on this (I seem to
>>>>>>> remember a
>>>>>>> relatively recent issue in the export code that it didn't find all
>>>>>>> liability
>>>>>>> accounts if they had a non-liability parent or such).
>>>>>>>
>>>>>>>> and I think that we already have too
>>>>>>>> many overlapping account types with subtle behavior differences that
>>>>>>>> are
>>>>>>>> neither documented nor easily discoverable in code.
>>>>>>>>
>>>>>>> I'm all for clearing this up. If we can reduce the number of account
>>>>>>> types
>>>>>>> that would be great.
>>>>>>> For reference this is the list of 17 account types supported by the
>>>>>>> commercial
>>>>>>> package*:
>>>>>>> Receivable, payable, bank and cash (one type), current assets,
>>>>>>> non-current
>>>>>>> assets, prepayments, fixed assets, current liabilities, non-current-
>>>>>>> liabilities, equity, current year earnings, other income, income,
>>>>>>> depreciation, expenses, cost of revenue, credit card.
>>>>>>>
>>>>>>> Gnucash currently has 15 of which a few are internal only:
>>>>>>> Bank, cash, credit, asset, liability, stock, mutual, currency, income,
>>>>>>> expense, equity, receivable, payable, root and trading.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> The leftovers from this long discussion for immediate use may be
>>>>>>> summarized
>>>>>>> as:
>>>>>>> - on reports display placeholder accounts once as aggregate account and
>>>>>>> once
>>>>>>> as its own account if it has splits.
>>>>>>> - work to be more pedantic about the meaning of "placeholder". It
>>>>>>> should
>>>>>>> become an empty account used for structuring the account hierarchy and
>>>>>>> for
>>>>>>> collecting (sub)totals.
>>>>>>> - introduce a read-only status for accounts one doesn't want to
>>>>>>> accidentally
>>>>>>> modify, but that should still appear in the chart of accounts in
>>>>>>> various
>>>>>>> places
>>>>>>> - replace "hidden" combined with current "placeholder" with "inactive".
>>>>>>> - consider introducing a passive account type to be able to structure
>>>>>>> the
>>>>>>> chart of accounts and reports conform European habits.
>>>>>>> - think of ways to have more than one chart of account in one file
>>>>>>> (only
>>>>>>> mentioned first in this message).
>>>>>>
>>>>>> There?s been an effort over the last several years between the IASB and
>>>>>> the US?s FASB to reconcile IAS and US GAAP for the obvious reason that
>>>>>> it?s a royal PITA for international businesses to have to present their
>>>>>> books in different ways to different regulators. I discovered when
>>>>>> looking for an IAS example CoA earlier today that it?s apparently come
>>>>>> to fruition as IFRS and that the standard CoA doesn?t have a ?Passive?
>>>>>> super-category [1], so perhaps the rest of the world is catching up with
>>>>>> GnuCash. ;-)
>>>>>>
>>>>>
>>>>> Not the whole world. Section 266 of the German HGB requires the balance
>>>>> sheet to split in active and passive and that?s how it?s displayed in
>>>>> every German accounting software.
>>>>>
>>>>> https://www.gesetze-im-internet.de/hgb/__266.html
>>>>> <https://www.gesetze-im-internet.de/hgb/__266.html>
>>>>>
>>>>> Also while you add it think about new account structures and the
>>>>> placeholder concept could you also consider the equivalents of the other
>>>>> types mentioned in the document above.
>>>>
>>>>
>>>> No surprise that individual country?s legislation hasn?t caught up. That
>>>> will likely take several more years.
>>>
>>> I hope this will never happen because the American way of doing it
>>> destroys the fundamental aesthetic of the balance sheet, that there two
>>> numerically identical sides which have just one top label each.
>>>
>>>> I don?t see any account types there other than the Active/Passive sections
>>>> that GnuCash doesn?t already support. What I can?t figure out is what
>>>> parts of the CoA small companies are allowed to leave out. (And no, my
>>>> German isn?t good enough to thoroughly read the document. I used Google
>>>> translate and so I may have gotten some of it wrong.)
>>>
>>> To summarize which sections each company type has to use:
>>>
>>> micro-entities: capital letters
>>> small sized: capital letters + Roman numerals
>>> medium sized and large: capital letters + Roman numerals + numbers
>>
>> Thanks.
>> So it's just that larger companies have to report more detail?
>>
>
> There are some exceptions, like limited partnerships with a limited
> liability company as general partner (GmbH & Co. KG) being required to
> list a more detailed break-down of their equity regardless of their size
> and stock market oriented companies always being treated as large
> companies but basically yes, the larger the company the more detailed
> the reports have to be.
>
> Regards
>
> Christian Kluge
>
>
>
> ------------------------------
>
> Message: 3
> Date: Sat, 30 Jun 2018 18:57:09 -0400
> From: Mike or Penny Novack <stepbystepf...@dialup4less.com>
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] How To Record an In-Kind Charitable Donation?
> Message-ID: <5b380ac5.80...@dialup4less.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> On 6/30/2018 3:10 PM, Eric H. Bowen via gnucash-user wrote:
>> I performed some design work and provided custom-printed envelopes and
>> materials for a local 501c3 charitable ministry. I am not charging them
>> money for the items, but I would like to receive credit for their fair
>> market value as an in-kind charitable donation. The ministry's treasurer
>> said to send him an invoice for the material and he would acknowledge
>> its receipt as a donation. Am I able to use Gnucash to track this
>> donation and, if so, what is the proper way to record the activity?
> The proper way is the way your tax lawyer/accountant tells you to. Once
> THAT has been settled, we can then tell you "how in gnucash".
>
> I lack the "qualifications" to give this sort of advice, especially as
> there are two parts to it. The "materials" part of it is easy, a debit
> to donations and a credit to your materials inventory. The "design work"
> part of it I would not be willing to hazard a guess. Maybe somebody on
> this list who donates professional services might answer.
>
> Michael D Novack
>
>
> ------------------------------
>
> Message: 4
> Date: Sat, 30 Jun 2018 16:10:07 -0700 (PDT)
> From: Rich Shepard <rshep...@appl-ecosys.com>
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] How To Record an In-Kind Charitable Donation?
> Message-ID:
> <alpine.lnx.2.20.1806301606530.12...@salmo.appl-ecosys.com>
> Content-Type: text/plain; format=flowed; charset=US-ASCII
>
> On Sat, 30 Jun 2018, Mike or Penny Novack wrote:
>
>> The proper way is the way your tax lawyer/accountant tells you to. Once THAT
>> has been settled, we can then tell you "how in gnucash".
>
> FWIW, I make non-cash donations to Goodwill several times each year. What
> I did (and my accountant confirmed is appropriate, at least for Oregon and
> the feds) is set up two accounts: an asset account, 'Goodwill,' and an
> expense account, 'Donations (non-cash).' If I donate time and effort to a
> non-profit other than Goodwill I'll add another asset account and use that
> to offset the non-cash donation.
>
> Regards,
>
> Rich
>
>
> ------------------------------
>
> Message: 5
> Date: Sat, 30 Jun 2018 01:26:57 -0700 (MST)
> From: DaveC49 <davidcous...@bigpond.com>
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] GnuCash 3.2 Released
> Message-ID: <1530347217312-0.p...@n4.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
> Hi John,
>
> If GnuCash is not built with Ninja, there is a cmake_uninstall.cmake file in
> the top level of the build directory which seems to read the
> install_manifest.txt file. The Makefile in the same level produced by CMake
> has an uninstall target - not sure how it executes the commands in the
> cmake_uninstall.cmake file but it appears to.
>
> Executing "make uninstall" ( prefixed with sudo if installed in a system
> location) in the build directory does remove all of the GnuCash files
> installed in the <prefix> specified to cmake. (GnuCash V3.2 from the
> SourceForge tarball on Linux Mint 18.3 built using Cmake, make and - should
> be the same for Ubuntu).
>
> Not sure that happens if it is built with Ninja rather than make though.
>
> David Cousens
>
>
>
> -----
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>
>
> ------------------------------
>
> Message: 6
> Date: Sat, 30 Jun 2018 16:57:12 -0700 (MST)
> From: DaveC49 <davidcous...@bigpond.com>
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Rethinking the placeholder account concept (was:
> Re: Fwd: The two modules)
> Message-ID: <1530403032780-0.p...@n4.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
> Stephen John, Geert
>
> In accounting terms there are really only 3 basic account types:
> Asset
> Liability
> Equity
>
> These all *must *satisfy the basic accounting equation Assets=Liabilities
> +Equity.
>
> The two sides of this equation are what the German /European system defines
> as Activa and Passiva but these groupings are primarily reporting
> requirements not account heirarchy. Is there really a need to have an
> additional placeholder category as the reporting grouping can be readily
> defined from the existing basic account heirarchy structure?
>
> Each type can have function specific sub-types which impose functional
> restrictions for that subtype and where the children but these subtypes are
> always one of the above basic types. Children of the types and sub-types
> must conform to the restriction that they have the same type or subtype as
> the parent E.g.
>
> Asset
> Top level placeholder
> Current
> placeholder
> Bank
> Accounts-Receivable
> business - no children
> Stock
> Trading
> Non-current
> placeholder
>
> Liability
> Top level placeholder
> Accounts payable
> business functionality-no children
> Equity
> Top level placeholder
> Income
> Current period revenue placeholder
> Expenses
> Current period expenditure placholder
>
> My experimentation and what I have understood of the code is this is already
> what GnuCash imposes in its account heirarchy with the exception perhaps
> that Income and Expenses are treated as their own types and the Equity type
> is enforced in any end of period closing operations and/or in the reporting
> and the expanded version of the accounting equation is enforced in the code.
>
> Assets=Liabilities + Equity + Income - Expenses
>
> For business purposes it is usually a requirement that each legal entity
> should have it's own set of books. I handle the situation where I need to
> separate different individual contributions within an entity in the manner
> John suggested (e.g. a household or a partnership) with labelled subaccounts
> within each type as defined above. If there really is a need to fully
> separate the individuals in terms of separately recording assets,
> liabilities and equity, then it is appropriate to run a separate set of
> books.
>
> I think it would be useful/nice to clearly document somewhere, perhaps the
> wiki, what the existing account structure is at this point and what
> attributes accounts currently have and what their intended purpose is from
> the developers point of view as well as the other unintended uses that the
> user base can come up with. That could then provide a basis for looking at
> restructuring those attributes. Something like the design documents that
> were produced at times in the past. This would also give the documenters a
> chance to reflect that in the documentation.
>
> David Cousens
>
>
>
>
>
> -----
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>
>
> ------------------------------
>
> Message: 7
> Date: Sun, 01 Jul 2018 00:33:48 -0400
> From: D <sunfis...@yahoo.com>
> To: Roger Miskowicz <rmisk...@gmail.com>
> Cc: Gnucash Users <gnucash-user@gnucash.org>
> Subject: Re: [GNC] Change Reconcile Starting Balance
> Message-ID: <yrvya9bwcoalktrx2qi3tm2k.1530419540...@email.android.com>
> Content-Type: text/plain; charset=utf-8
>
> I'm glad you've fixed it.
>
> On June 30, 2018, at 3:04 PM, Roger Miskowicz <rmisk...@gmail.com> wrote:
>
> I have fixed my account but not sure about the root cause.
>
>
> I fixed it by manually, item-by-item, clearing all reconciles which set the?
> Starting Balance? to zero.? After which I was able to reconcile producing
> results I expected.
>
>
> Thanks for helping me fix it.
>
>
> Roger
>
>
> P.S.? A nice feature would be the abililty to select a bunch of items to set
> or clear reconciles.
>
>
>
> On Sat, Jun 30, 2018 at 8:55 AM, D <sunfis...@yahoo.com> wrote:
>
> Only manually, a transaction at a time.
>
> What happens if you ignore the opening balance, enter the correct closing
> balance, and reconcile then?
>
> Often, if there's an inconsistency in the opening balance, you can proceed
> with reconciling, mark your current transactions and any earlier ones that
> were missed before (such as your opening balance transaction, say), and they
> balance out.
>
> David
>
>
> On June 30, 2018, at 8:23 AM, Roger Miskowicz <rmisk...@gmail.com> wrote:
>
> Thanks Colin.
>
> Is there anyway I can clear all reconcilation of the the account and start
> again from scratch?
>
> Roger
>
> On Sat, Jun 30, 2018 at 8:15 AM, Colin Law <clan...@gmail.com> wrote:
>
>> The starting balance in the reconcile start dialog will be the nett
>> balance of all reconciled transactions so far. Is this the first time
>> you have reconciled it?? If not then it should be the same as the
>> ending balance the last time you reconciled, unless you have editted a
>> reconciled transaction.
>>
>> Colin
>>
>> On 30 June 2018 at 13:08, Roger Miskowicz <rmisk...@gmail.com> wrote:
>>> I am using GC Version 3.2 and trying to reconcile my Credit Card Account
>>> which I started at the beginning of the year with an opening balance.
>>>
>>> I would like to reconcile the account from the opening balance but I
>> don't
>>> know how to set the 'starting balance' which happens to be some number
>> that
>>> doesn't seem relevant.
>>>
>>> Can the 'starting balance' in 'reconcile' be manuallly set, and if so,
>> how?
>>> _______________________________________________
>>> 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.
>>
> _______________________________________________
> 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.
>
>
>
> ------------------------------
>
> Message: 8
> Date: Sun, 1 Jul 2018 12:02:32 +0700
> From: Norbert Klein <nhkl...@gmx.net>
> To: Geert Janssens <geert.gnuc...@kobaltwit.be>
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] How to regularly use two currencies
> Message-ID: <702e48af-e3ae-bff1-35bd-ff4c77148...@gmx.net>
> Content-Type: text/plain; charset=utf-8; format=flowed
>
> 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 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.
>>>>>
>>>>> 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.
>>
>>
>>
>
>
>
> ------------------------------
>
> Message: 9
> Date: Sun, 1 Jul 2018 14:47:59 +0700
> From: Tony Vanson <tonyvan...@gmail.com>
> To: gnucash-user <gnucash-user@gnucash.org>
> Subject: [GNC] My bad
> Message-ID:
> <CACnjAud7-OXyfk12Q_QgnMR2Xz_GmtV-=brc1venkhtvemc...@mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> Hi 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
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.
