Re: 2.6.19: find source of imbalance in reconciled accounts

2018-02-13 Thread David Carlson
I'm balances are usually caused by transactions that involve more than one
currency or purchase or sale of stock or other commodity.

One way to get closer to any transaction that may be causing the I'm
balance is reduce the time window until the imbalance disappears, then work
back to find the date when it appears.  Then look at all the transaction s
for that date in the journal.

My tablet is changing my words around and it sometime s won't let me fix
them.

If I recall you can try to isolate which account has the I'm balances.

David C

On Feb 13, 2018 5:44 PM, "Rich Shepard"  wrote:

>   I'm puzzled how I can find the source of the imbalance at the bottom of
> the 2017 trial balance report when both the checking and saving accounts
> reconcile with the bank's records (as of today). The trial balance period
> is
> 1 Jan 2017 through 31 Dec 2017.
>
>   Please provide a clue stick where I should start looking.
>
> Regards,
>
> Rich
>
> ___
> 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.


Re: 2.6.19: Accounts reconciled; trial balance has imbalance

2018-02-13 Thread Adrien Monteleone
Rich,

If you’re using digest mode, I’d recommend turning it off.

My experience has been it’s more trouble to maintain and sort through. The 
digest also seems to not be quite ‘regular’ in its delivery, either in number 
of messages, or in elapsed time. Replies will also seem to appear out of 
sequence or be unnecessarily delayed.

Without digest, some days or times will be very quiet; others will blow up your 
in-box. Set a filter/rule to file your GnuCash messages to their own folder for 
sanity.

You could optionally enable the setting to CC you on all of your own list 
submissions, but I really don’t think that would help you, and might possibly 
add to the confusion, but it is an option.

Regards,
Adrien

> On Feb 13, 2018, at 5:55 PM, Rich Shepard  wrote:
> 
> On Tue, 13 Feb 2018, Rich Shepard wrote:
> 
>> The trial balance report for 2017 for a checking account shows a 4-figure
>> imbalance at the bottom, yet the account is properly reconciled with the
>> bank (through yesterday). How can this be?
> 
>  I apologize for posting to two threads on the same issue. It's taking so
> long for messages I send to appear on the list (at least the copies returned
> to me) that I lost track of what I sent.
> 
> Rich
> ___
> 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.

Re: Recording non-cash donations [RESOLVED]

2018-02-13 Thread Adrien Monteleone
That was quick, you answered your own question with a recommendation from an 
accountant in 3 minutes. (at least by my clock)

I’m curious for a clarification.

Does your accountant mean to expense the non-cash goods and services provided 
at once?

Or to hold these as deferred and expense them as used?

Or even to accept them as ‘revenue’ and later deduct them against matching 
expenses?

Just curious. Overall, I think I see where she’s going, I just want to 
understand the advice better.

Regards,
Adrien

> On Feb 13, 2018, at 5:09 PM, Rich Shepard  wrote:
> 
> On Tue, 13 Feb 2018, Rich Shepard wrote:
> 
>> For tax purposes non-cash donations of goods and services are deductible.
>> I would like to track those as an account (or off-setting accounts) in
>> gnucash and do not find how best to do this in the guide or help docs. I'm
>> open to suggestions on how to track these transactions.
> 
>  I spoke with my accountant and she approved my solution: and expense
> account for non-cash donations and an asset account 'goodwill.'
> 
>  That'll work.
> 
> Rich
> ___
> 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.

Re: inventory management examples or links

2018-02-13 Thread Adrien Monteleone
Matt,

Perhaps you are misunderstanding.

I’m not describing any integration between inventory and Gnucash.

Gnucash is an accounting application.

It can handle lots of situations without special features.

Inventory is just one of them.

Anything I’ve posted is just a regurgitation of accounting texts, either in 
print or online.

A simple search would turn up the same sample transactions and suggested 
accounts.

While it would be nice if Gnucash gave some direction in some areas, I see why 
pointing anyone in any one in particular direction could be a problem.

Accounting laws are different based on your business entity arrangement and 
local jurisdiction.

Gnucash is general enough to be flexible to allow you to accomplish your task. 
It is not designed to adhere to any particular set of laws.

It’s probably best if basic accounting questions were posed to the web search 
engines, or better yet, a local CPA.

Regards,
Adrien

> On Feb 13, 2018, at 3:20 PM, Matt Graham  wrote:
> 
> https://wiki.gnucash.org/wiki/Inventory_Handling
>  
> This issue must have come up before. The wiki could ideally use some 
> discussion about separation of inventory and accounting systems. I imagine 
> for a small business that just wants to keep track of a few things they would 
> want them both integrated (but then later realise that they really need them 
> separate – unless GNUcash wants to branch into both worlds).
>  
> I didn’t find anything in the tutorials and concepts guide under the business 
> features – but unless Gnucash is going to get an “inventory” capability, 
> that’s probably okay.
>  
> Adrien – do you have time to put your example on the wiki of how to integrate 
> inventory systems with GNUcash’s accounting?
>  
> Thanks and regards,
> 
> Matt
>  
> From: Adrien Monteleone
> Sent: Tuesday, 13 February 2018 10:11 PM
> To: Bert Heijne
> Cc: gnucash-user@gnucash.org
> Subject: Re: inventory management examples or links
>  
> Bert,
> 
> I posted some more replies in the original thread containing various 
> inventory related transaction examples and suggested accounts.
> 
> Let me know if you need anything specific that isn’t covered and I’ll see 
> what I can do.
> 
> Really, these are just basic accounting entries for a retail business that 
> you can find in any standard accounting text book, or online.
> 
> There’s nothing special about them with regards to Gnucash.
> 
> Regards,
> Adrien
> 
> > On Feb 12, 2018, at 6:25 AM, Bert Heijne  wrote:
> > 
> > Hello All.
> > 
> > This is a nice treat about Inventory but are there some “real examples”  or 
> > “ putting it all together”  of gnucash for Inventory or stock of goods 
> > management?
> > And how this is covered with the invoice.
> > I now that gnu cash is not build for that but small stock would be nice
> > Woocommerce webshop is in construction so this will be covered mostly by WC.
> > 
> > Would be nice to see some real samples in gnucash to study.
> > Any links or G search links  would be nice
> > 
> > Gr. Bert
> > 
> > Verzonden met Windows Mail
> > 
> > Van: Robert Heller
> > Verzonden: ‎zondag‎ ‎11‎ ‎februari‎ ‎2018 ‎17‎:‎15
> > Aan: stepbystepf...@dialup4less.com
> > CC: gnucash-user@gnucash.org
> > 
> > At Sun, 11 Feb 2018 10:55:58 -0500 stepbystepf...@dialup4less.com wrote:
> > 
> >> 
> >> On 2/11/2018 9:03 AM, Robert Heller wrote:
> >>> At Sun, 11 Feb 2018 08:15:56 +0100 Jeff Abrahamson  wrote:
> >>> ... transfer
> >>> "money" from the vegetable account to a bank account (income when you sell
> >>> vegetables) and when you transfer money from a bank account to the 
> >>> vegetable
> >>> account (an expense when you buy vegetables). *I* do this which my 
> >>> inventory
> >>> of thumb drives. GnuCash does not have "inventory" accounts or any way of
> >>> dealing with inventory as such
> >> Inventory MANAGEMENT is something else (gnucash lacks this but that
> >> belongs in an inventory system*, not "general ledger".
> > 
> > Yes, I understand.
> > 
> >> 
> >> But you are saying that gnucash does not support inventory value and
> >> cost accounting and that is simply not so.
> > 
> > Only in the sense of not specificly labeling things as "inventory value and
> > cost accounting". You are right, one can use gnucash to "manage" inventory
> > value and cost accounting. From the point of a newbie, there isn't a 
> > specific
> > menu of things relating to inventory value and cost accounting, so there is
> > the *appearence* of a of lack of support for inventory. My intent was to 
> > point
> > the OP in "right direction", one that is not obvious. Inventory value and 
> > cost
> > accounting is handled in GnuCash under "other names" -- it is a matter of
> > understanding that inventory is really a kind of asset (that is bought and
> > sold) and can (should) be treated as 

Re: 2.6.19: Accounts reconciled; trial balance has imbalance

2018-02-13 Thread John Ralls


> On Feb 13, 2018, at 4:01 PM, Rich Shepard  wrote:
> 
> On Tue, 13 Feb 2018, John Ralls wrote:
> 
>> The trial balance report checks that the accounting equation (Assets +
>> Income - Expenses = Liabilities + Equity) holds.
> 
>> Running it on a single account makes no sense; it should be run on the
>> whole book.
> 
> John,
> 
>  It's run on the whole book; in the case of the discrepancy the only other
> account is the Cash asset account and that, too, is reconciled with
> expenses.
> 
>> Reconciliation ensures that your local view of a single asset or liability
>> account matches that of the other party on the account. Since it's a
>> single-account check it's quite possible for you to have all of those
>> accounts reconciled and still have your books out of balance.
> 
>  Well, haven't found an inconsistency yet but will keep looking.

Try this: Set the Start of Adjusting/Closing on 1 Jan 2017 and the Date of 
Report on 30 June 2017. If it's in balance, change the report date to 30 
September, otherwise to 31 March. If it's now (or still) in balance change it 
again to halfway between the current date and the out-of-balance date. Keep 
doing that until you find the first date where it's out of balance, then use 
the General Ledger to look at all of the transactions on that date. One of them 
is off. Fix it and repeat the process until it's in balance for the year.

The main cause for out-of-balance on a trial balance report is that some asset 
has a realized gain or loss with respect to the report currency and it isn't 
recorded. Dunno if that applies in your case.

Regards,
John Ralls
___
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: Cannot print reports: 2.6.19

2018-02-13 Thread Rich Shepard

On Tue, 13 Feb 2018, John Ralls wrote:


What does "changed the report display for the business account" mean?


John,

  It means I changed the stylesheet from Default to Footer.


Yes, "Export to PDF..." does indeed run the same dialog, pre-populated
with some options for printing to file. If that works for both accounts
then when it doesn't work from Print ... it probably means that you've
selected some options in the dialog that are incompatible with making a
PDF.


  'Export to PDF' works for all reports on both accounts. Trying to print
the reports (using any stylesheet) is not allowed. The only options I change
are the stylesheet and the period covered by the reports (i.e,.
01/01/2017-12/31/2017).

  Having the reports placed on disk as .pdf files is what I need. Using the
export rather than print menu items does the job so that's fine with me.

Thanks very much,

Rich
___
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: Cannot print reports: 2.6.19

2018-02-13 Thread John Ralls


> On Feb 12, 2018, at 4:33 PM, Rich Shepard  wrote:
> 
> On Mon, 12 Feb 2018, John Ralls wrote:
> 
>> That's not coming from GnuCash, it's coming from the OS. Since it works
>> for one user and not the other I'd suspect a permissions problem.
> 
> John,
> 
>  When I changed the report display for the business account they refused to
> print, too. Regardless, I'll just 'export to PDF' and ignore the 'Print'
> function.

What does "changed the report display for the business account" mean?

Yes, "Export to PDF..." does indeed run the same dialog, pre-populated with 
some options for printing to file. If that works for both accounts then when it 
doesn't work from Print ... it probably means that you've selected some options 
in the dialog that are incompatible with making a PDF.

Regards,
John Ralls

___
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: Cannot print reports: 2.6.19

2018-02-13 Thread Rich Shepard

On Mon, 12 Feb 2018, John Ralls wrote:


That's not coming from GnuCash, it's coming from the OS. Since it works
for one user and not the other I'd suspect a permissions problem.


John,

  When I changed the report display for the business account they refused to
print, too. Regardless, I'll just 'export to PDF' and ignore the 'Print'
function.

Thanks,

Rich
___
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: 2.6.19: Accounts reconciled; trial balance has imbalance

2018-02-13 Thread John Ralls


> On Feb 13, 2018, at 3:35 PM, Rich Shepard  wrote:
> 
>  The trial balance report for 2017 for a checking account shows a 4-figure
> imbalance at the bottom, yet the account is properly reconciled with the
> bank (through yesterday). How can this be?
> 
>  My accountant tells me that if the checking account register transactions
> balance with expense accounts, and the asset account reconciles with the
> bank's view of it, the trial balance should have no discrepancies
> (imbalances in gnucash language).
> 
>  There is no imbalance on the other checking account's trial balance.
> 
>  (As an aside, it's taken 8-10 hours for messages I posted this morning to
> appear on the mail list so I don't expect to see this there until tomorrow
> some time.)

The trial balance report checks that the accounting equation (Assets + Income - 
Expenses = Liabilities + Equity) holds. 
Running it on a single account makes no sense; it should be run on the whole 
book.

Reconciliation ensures that your local view of a single asset or liability 
account matches that of the other party on the account. Since it's a 
single-account check it's quite possible for you to have all of those accounts 
reconciled and still have your books out of balance.

Regards,
John Ralls

___
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: 2.6.19: Accounts reconciled; trial balance has imbalance

2018-02-13 Thread Rich Shepard

On Tue, 13 Feb 2018, Rich Shepard wrote:


 The trial balance report for 2017 for a checking account shows a 4-figure
imbalance at the bottom, yet the account is properly reconciled with the
bank (through yesterday). How can this be?


  I apologize for posting to two threads on the same issue. It's taking so
long for messages I send to appear on the list (at least the copies returned
to me) that I lost track of what I sent.

Rich
___
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.


2.6.19: find source of imbalance in reconciled accounts

2018-02-13 Thread Rich Shepard

  I'm puzzled how I can find the source of the imbalance at the bottom of
the 2017 trial balance report when both the checking and saving accounts
reconcile with the bank's records (as of today). The trial balance period is
1 Jan 2017 through 31 Dec 2017.

  Please provide a clue stick where I should start looking.

Regards,

Rich

___
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: Cannot print reports: 2.6.19 [RESOLVED]

2018-02-13 Thread Rich Shepard

On Mon, 12 Feb 2018, Rich Shepard wrote:


That's what I'm trying to do with these reports. The message box, "Error
printing. Operation not supported." appears when I view a report and
select the Print menu item, then select print to file.


John,

  Got it figured out. I hadn't paid attention to the last menu item: export
as PDF because I'm used to printing to a disk file. Same result, different
paths to it.

  Exporting to PDF works on both business and personal accounts. Seems like
the Print option works only on actual printers. That's OK with me as I now
know how to produce digital copies of the reports.

Regards,

Rich


___
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.


2.6.19: Accounts reconciled; trial balance has imbalance

2018-02-13 Thread Rich Shepard

  The trial balance report for 2017 for a checking account shows a 4-figure
imbalance at the bottom, yet the account is properly reconciled with the
bank (through yesterday). How can this be?

  My accountant tells me that if the checking account register transactions
balance with expense accounts, and the asset account reconciles with the
bank's view of it, the trial balance should have no discrepancies
(imbalances in gnucash language).

  There is no imbalance on the other checking account's trial balance.

  (As an aside, it's taken 8-10 hours for messages I posted this morning to
appear on the mail list so I don't expect to see this there until tomorrow
some time.)

Regards,

Rich

___
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: Users replying to digest rather than starting a new thread

2018-02-13 Thread Dean Gibson

On 2018-02-13 09:31, Dr. David Kirkby wrote:

[prior message omitted]
There was a discussion about this on the HP/Agilent Yahoo group a week or
two ago. Someone mentioned that some other group he was a member of, anyone
that receives the digest was on 'permanent moderation' so if ever they
replied to a digest, it would be blocked. If they replied to a non-digest
message, the moderator would let it pass. This does not seem unreasonable
to me, because it inconveniences a lot of people to have a subject such as
the month of the digest, rather than something more specific.

Dave


Seems very reasonable, but for me personally, it doesn't matter:  I 
delete ALL messages (no matter what the forum) that have a subject of a 
"digest".


Aside from being thoughtless, self-centered, and clueless, replies to 
digests are INHERENTLY STUPID:  By the very nature of digests, they 
usually don't include the more recent messages on a topic.  As a result, 
any reply usually duplicates ideas (eg, solutions) in later messages 
(that weren't included in the digest).


My advice?  Disable digests, & explain to new users why the subject line 
is important if one gets a lot of eMail.


___
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.

Recording non-cash donations

2018-02-13 Thread Rich Shepard

Hi all,

  For tax purposes non-cash donations of goods and services are deductible.
I would like to track those as an account (or off-setting accounts) in
gnucash and do not find how best to do this in the guide or help docs. I'm
open to suggestions on how to track these transactions.

Regards,

Rich
___
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: Users replying to digest rather than starting a new thread

2018-02-13 Thread Matt Graham
Actually – better idea:
Can the digest produce a hyperlink at the end of each topic that is titled 
“Reply to this thread”. The hyperlink would be a standard “mailto:” hyper link 
that sets up an email to this user thread with the subject line of the thread. 
Would make it extremely easy to reply to a digest (and harder to do it wrong!).

Should be possible making the link address 
‘mailto:gnucash-user@gnucash.org?subject=Previous subject string’. Just don’t 
know if it is possible with mailman.

Thanks and regards,

Matt

From: Matt Graham
Sent: Wednesday, 14 February 2018 8:44 AM
To: gnucash-user@gnucash.org
Subject: RE: Users replying to digest rather than starting a new thread

No worries Liz,

I was thinking how off-putting it must be for a new user receiving messages 
from other users saying “Don’t post like that!!!”

My next idea would be for the server to automatically change the subject line 
to ‘ “Question from “ + User Name’ whenever someone replies straight to a 
digest.

Happy for no change though – just means we’ll probably still keep getting 
people replying to the digests like this. Ultimately, it isn’t a big issue, and 
if there is no easy way to fix it, we can just work with it.

Thanks and regards,

Matt

From: Liz
Sent: Tuesday, 13 February 2018 5:49 PM
To: gnucash-user@gnucash.org
Subject: Re: Users replying to digest rather than starting a new thread

On Sun, 11 Feb 2018 05:29:13 +
Matt Graham  wrote:

> Probably stupid question – is there a way to set rules on the
> gnucash-user account?
>
> Ie anytime someone sends an email that starts with “Re gnucash-user
> Digest”, the system rejects their email with a response along the
> lines of “Please do not reply to the digest without changing the
> subject line. Start a new email with the subject line the same as the
> topic you wish to respond to.”
>
> Thanks and regards,
>
> Matt

I'm not aware of a place to put such an option.
I wouldn't like to get such an email if I was a new user with a
question related to a topic on the digest, and I'm not in favour of
making such a change.

Liz
Moderator
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7C3bc50f9d260146db808108d572adf749%7C84df9e7fe9f640afb435%7C1%7C0%7C636541013856348160=LlRjzoHtVNrz9j%2F7VNrpqsDV462KPt1IwcpHzsGiqIA%3D=0
If you are using Nabble or Gmane, please see 
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=02%7C01%7C%7C3bc50f9d260146db808108d572adf749%7C84df9e7fe9f640afb435%7C1%7C0%7C636541013856348160=%2FTKZ8ySMJ%2Fh%2FCWMgXKfOhu6hSdJekV8lqVUxs5C5sHU%3D=0
 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://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7Ccff2ecdae28a40e0f9e608d5732afc43%7C84df9e7fe9f640afb435%7C1%7C0%7C636541550805828852=zcx0b%2B6m23MlsWOO69EeJpws6RAK5Mu5uudSF60Kq1c%3D=0
If you are using Nabble or Gmane, please see 
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=02%7C01%7C%7Ccff2ecdae28a40e0f9e608d5732afc43%7C84df9e7fe9f640afb435%7C1%7C0%7C636541550805828852=I2tONWBr9smRjtkhn%2F4KjAsMs6%2FRYXCYquFRzvV9HpE%3D=0
 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.


RE: Users replying to digest rather than starting a new thread

2018-02-13 Thread Matt Graham
No worries Liz,

I was thinking how off-putting it must be for a new user receiving messages 
from other users saying “Don’t post like that!!!”

My next idea would be for the server to automatically change the subject line 
to ‘ “Question from “ + User Name’ whenever someone replies straight to a 
digest.

Happy for no change though – just means we’ll probably still keep getting 
people replying to the digests like this. Ultimately, it isn’t a big issue, and 
if there is no easy way to fix it, we can just work with it.

Thanks and regards,

Matt

From: Liz
Sent: Tuesday, 13 February 2018 5:49 PM
To: gnucash-user@gnucash.org
Subject: Re: Users replying to digest rather than starting a new thread

On Sun, 11 Feb 2018 05:29:13 +
Matt Graham  wrote:

> Probably stupid question – is there a way to set rules on the
> gnucash-user account?
>
> Ie anytime someone sends an email that starts with “Re gnucash-user
> Digest”, the system rejects their email with a response along the
> lines of “Please do not reply to the digest without changing the
> subject line. Start a new email with the subject line the same as the
> topic you wish to respond to.”
>
> Thanks and regards,
>
> Matt

I'm not aware of a place to put such an option.
I wouldn't like to get such an email if I was a new user with a
question related to a topic on the digest, and I'm not in favour of
making such a change.

Liz
Moderator
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7C3bc50f9d260146db808108d572adf749%7C84df9e7fe9f640afb435%7C1%7C0%7C636541013856348160=LlRjzoHtVNrz9j%2F7VNrpqsDV462KPt1IwcpHzsGiqIA%3D=0
If you are using Nabble or Gmane, please see 
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=02%7C01%7C%7C3bc50f9d260146db808108d572adf749%7C84df9e7fe9f640afb435%7C1%7C0%7C636541013856348160=%2FTKZ8ySMJ%2Fh%2FCWMgXKfOhu6hSdJekV8lqVUxs5C5sHU%3D=0
 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.


RE: inventory management examples or links

2018-02-13 Thread Matt Graham
https://wiki.gnucash.org/wiki/Inventory_Handling

This issue must have come up before. The wiki could ideally use some discussion 
about separation of inventory and accounting systems. I imagine for a small 
business that just wants to keep track of a few things they would want them 
both integrated (but then later realise that they really need them separate – 
unless GNUcash wants to branch into both worlds).

I didn’t find anything in the tutorials and concepts guide under the business 
features – but unless Gnucash is going to get an “inventory” capability, that’s 
probably okay.

Adrien – do you have time to put your example on the wiki of how to integrate 
inventory systems with GNUcash’s accounting?

Thanks and regards,

Matt

From: Adrien Monteleone
Sent: Tuesday, 13 February 2018 10:11 PM
To: Bert Heijne
Cc: gnucash-user@gnucash.org
Subject: Re: inventory management examples or links

Bert,

I posted some more replies in the original thread containing various inventory 
related transaction examples and suggested accounts.

Let me know if you need anything specific that isn’t covered and I’ll see what 
I can do.

Really, these are just basic accounting entries for a retail business that you 
can find in any standard accounting text book, or online.

There’s nothing special about them with regards to Gnucash.

Regards,
Adrien

> On Feb 12, 2018, at 6:25 AM, Bert Heijne  wrote:
>
> Hello All.
>
> This is a nice treat about Inventory but are there some “real examples”  or “ 
> putting it all together”  of gnucash for Inventory or stock of goods 
> management?
> And how this is covered with the invoice.
> I now that gnu cash is not build for that but small stock would be nice
> Woocommerce webshop is in construction so this will be covered mostly by WC.
>
> Would be nice to see some real samples in gnucash to study.
> Any links or G search links  would be nice
>
> Gr. Bert
>
> Verzonden met Windows Mail
>
> Van: Robert Heller
> Verzonden: ‎zondag‎ ‎11‎ ‎februari‎ ‎2018 ‎17‎:‎15
> Aan: stepbystepf...@dialup4less.com
> CC: gnucash-user@gnucash.org
>
> At Sun, 11 Feb 2018 10:55:58 -0500 stepbystepf...@dialup4less.com wrote:
>
>>
>> On 2/11/2018 9:03 AM, Robert Heller wrote:
>>> At Sun, 11 Feb 2018 08:15:56 +0100 Jeff Abrahamson  wrote:
>>> ... transfer
>>> "money" from the vegetable account to a bank account (income when you sell
>>> vegetables) and when you transfer money from a bank account to the vegetable
>>> account (an expense when you buy vegetables). *I* do this which my inventory
>>> of thumb drives. GnuCash does not have "inventory" accounts or any way of
>>> dealing with inventory as such
>> Inventory MANAGEMENT is something else (gnucash lacks this but that
>> belongs in an inventory system*, not "general ledger".
>
> Yes, I understand.
>
>>
>> But you are saying that gnucash does not support inventory value and
>> cost accounting and that is simply not so.
>
> Only in the sense of not specificly labeling things as "inventory value and
> cost accounting". You are right, one can use gnucash to "manage" inventory
> value and cost accounting. From the point of a newbie, there isn't a specific
> menu of things relating to inventory value and cost accounting, so there is
> the *appearence* of a of lack of support for inventory. My intent was to point
> the OP in "right direction", one that is not obvious. Inventory value and cost
> accounting is handled in GnuCash under "other names" -- it is a matter of
> understanding that inventory is really a kind of asset (that is bought and
> sold) and can (should) be treated as such, at which point all of pieces fall
> into place. The OP wanted to treat his inventory as income or expense and that
> what was confusing (to him).
>
>>
>> Let's say incidental to its main activity an organization sells various
>> things (tee shirts, coffee mugs, etc.) as a fund raiser. You create
>> under Assets (after "current assets" and "fixed assets") a parent
>> "Inventory of goods". Under that might be accounts (more likely also
>> parents as batches of goods might have different basis) for "tee
>> shirts", "coffee mugs", etc. When the organization buys a new batch of
>> tee shirts that is a debit to "tee shirts" (or as I mentioned, perhaps
>> "tee shirts batch 4" --- the account description can include what the
>> unit price was for this batch) and a credit to checking << note: we get
>> confused using the supposedly more user friendly terms worrying about
>> what sort of "transfer" this is). Each sale of a tee shirt not only
>> debits cash and credits "sale of tee shirts" for the sale price but also
>> debits "cost of goods sold" and credits the inventory account "tee
>> shirts batch N" for the unit cost of batch N << going to be a 

Re: One account for both Income and Expenses possible?

2018-02-13 Thread Adrien Monteleone


> On Feb 11, 2018, at 9:57 AM, Robert Heller  wrote:
> 
> At Sun, 11 Feb 2018 15:51:30 +0100 Jeff Abrahamson  wrote:
> 
>> 
>> On 11/02/18 15:46, Robert Heller wrote:
>>> Here is a "practical" application:
>>> 
>>> Lets say you buy a case of tomatoes for $10 -- this would be a transaction
>>> from your bank account (for the check you gave the vegetable wholeseller) of
>>> $10 to your Assets:vegetables account. (It is not actually an expense!). 
>>> Then
>>> you sell that case of tomatoes for $12. This would be a split transaction: 
>>> $10
>>> from your Assets:vegetables account and $2 to an income account. The $12 
>>> would
>>> come from whatever account the $12 was paid into (eg "Cash" if it was a cash
>>> transaction). This brings the Assets:vegetables down to zero (you have no
>>> vegetables in stock right now). At the end of the year you generate a report
>>> showing the Assets:vegetables at the beginning of the year and and the end 
>>> of
>>> the year. The difference is your "cost of goods sold" -- this is what goes 
>>> on
>>> your tax form (actually, the form has your inventory at the beginning of the
>>> year, and your inventory at the end of the year, plus whatever you spent to
>>> acquire your inventory during the year, at least that is how the 1040C form
>>> works and I guess theo 1040F is similar).
>> 
>> Our emails crossed.  I see what you mean, but I don't think the tax
>> authorities would find that particularly legal here.  It would also make
>> VAT computations impossible, I think, although we are exempt from VAT.
> 
> If VAT is anything like Sales Tax, the sales transaction would include all of 
> the pieces as parts of the "split".  This is what I do:
> 
> gross cash/payment in => 1) reduce inventory account by the cost of the goods
> 2) sales tax on the transaction to the sales tax 
>account
> 3) whatever is left over to an income account (this 
>will show up on your P report)
> 
Be sure #2 posts to a "Liability:Sales Tax Payable" (or VAT Payable) account, 
and not a tax expense account.

#3 is not correct, and there are two splits missing.

You should have this for every sale (I’m assuming cash payment, adjust as 
needed):

Dr. Assets:Current Assets:Cash
Dr. Expenses:Cost of Goods Sold
Cr. Liability:Sales Tax Payable
Cr. Income:Sales
Cr. Assets:Current Assets:Inventory

The 1st split is the total amount received as payment.
The 2nd is your #1
The 3rd is your #2
The 4th is 1st split - 3rd split. (the difference between amount received and 
the sales tax, that is, the pre-tax sub-total amount of the actual sale)
The 5th is the same as 2nd (COGS debit and Inventory credit should balance 
between themselves, this could be a separate transaction)

Dealing with a VAT or an otherwise inclusive tax jurisdiction/rule is a little 
messier but similar. (depends on the local laws)

> Yes, the only real gotcha is that vegatables are not durable goods, so you 
> have to account for spoilage somehow.

Very easy:

Expenses:Cost of Goods Sold:Spoilage

Either expense these with a credit against inventory as needed/identified 
(ideally), or periodically with a reconciliation count of inventory.

Regards,
Adrien


> 
> It is possible to group things:
> 
> Assets:Inventory:Vegetables
> Assets:Inventory:Fruits
> Assets:Inventory:Handicrafts
> Assets:Inventory:Meat
> etc.
> (And further subdivide -- Assets:Inventory:Vegetables:Tomatoes, 
> Assets:Inventory:Vegetables:GreenBeans,etc. It would depend on the level of 
> detailneeded and you can generate reports using the accounts at different
> levels, depending on what you need.)
> 
> 
>> 
>> Thanks for explaining clearly!
>> 
> 
> -- 
> Robert Heller -- 978-544-6933
> Deepwoods Software-- Custom Software Services
> http://www.deepsoft.com/  -- Linux Administration Services
> hel...@deepsoft.com   -- Webhosting Services
> 
> ___
> 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.

Re: Installation

2018-02-13 Thread Geert Janssens
I too believe this is a good idea, just like several others:

https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/
1470507-configuration-option-for-backup-location

https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/
17837134-specify-seperate-folder-for-backup-and-log-files

It's primarily waiting for someone to actually implement it. My fingers are 
itching but my time is too limited ATM...

Geert

Op dinsdag 13 februari 2018 09:46:03 CET schreef Colin Law:
> I would support the idea of the log and backup files being in a
> subdirectory named using the accounts file name as a seed, so for example
> myaccounts.gnucash.archive or maybe for those windows users who have
> problems with file extensions not being shown myaccounts_gnucash_archive.
> Something like that anyway. I think that would reduce the likelihood of
> users accidentally opening backup files instead of the main accounts file,
> which is something we hear of here regularly. Also it would allow the
> accounts file to be placed on the desktop which is something some users
> seem to like doing.
> 
> Colin


___
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?

2018-02-13 Thread Adrien Monteleone
Norbert,

If the vegetables, fruits and handicrafts that you buy are purchased for resale 
as your inventory, then yes, you can and should, use one account to track them. 
(not by quantity, but by value)

Because you are also a manufacturer, you might also have a ‘work-in-progress’ 
account at least for the handicrafts. (the produce items would depend on the 
actual work flow from being attached to the plant to being sellable goods, if 
there is an in-between state, you should probably track that) These should all 
be asset accounts. (neither expenses, nor income)

Here’s an example:

Assets:Current Assets:Inventory:Vegetables
Assets:Current Assets:Inventory:Fruits
Assets:Current Assets:Inventory:Handicrafts

--

For products that you have started to make but not finished yet:

Assets:Current Assets:Inventory:Work-In-Progress (again, if more than one type, 
use sub-accounts for better detail)

for the raw materials that go into making the handicrafts until they become 
part of ‘work-in-progress’:

Assets:Current Assets:Inventory:Raw Materials

and possibly also:

Assets:Current Assets:Supplies

--

To track the cost of goods as you sell them (or conduct a periodic inventory) 
you’ll need this account:

Expenses:Cost of Goods Sold

you might also need:

Expenses:Cost of Goods Sold:Spoilage/Damaged
Expenses:Cost of Goods Sold:Samples

and optionally:

Expenses:Cost of Goods Sold:Quality Control

--

When you buy inventory to resell, you will post it to A/P and your line-items 
in your bills should be posted to the appropriate inventory asset account.
When you sell inventory, you post it to A/R and your line-items in your 
invoices should be posted to your respective Income accounts. You might 
breakdown your sales into sub-accounts by category or type of inventory like so:

Income:Sales:Vegetables
Income:Sales:Fruits
Income:Sales:Handicrafts

--

If you are making these buying and selling entries manually instead of using 
the business features, here’s what they should look like:

Sale:
Dr. Assets:Current Assets:Cash
Cr. Income:Sales:Vegetables

Purchase:

Dr. Assets:Current Assets:Inventory:Vegetables
Cr. Assets:Current Assets:Cash

--

If you are running a perpetual inventory system, you would also create a 
transaction for each sale that debited Expenses:Cost of Goods Sold for the 
cost-value of the items on the invoice and credited the respective Inventory 
asset account for those same values. (reducing the asset, and transferring the 
value to an expense)

for example:

Dr. Expenses:Cost of Goods Sold
Cr. Assets:Current Assets:Inventory:Vegetables

--

If you are running a periodic inventory system, you would instead physically 
count inventory at the end of each period. Then you would calculate the basic 
inventory equation:

Starting Inventory + Purchases - Ending Inventory = Cost of Goods Sold

Then make a single transaction debiting the COGS expense account and crediting 
the respective Inventory asset accounts.

Dr. Expenses:Cost of Goods Sold
Cr. Assets:Current Assets:Inventory:Vegetables
Cr. Assets:Current Assets:Inventory:Fruits
Cr. Assets:Current Assets:Inventory:Handicrafts

--

With a perpetual system, you will still likely want to periodically verify your 
inventory, in which case you’d make one-item correcting entries to as with the 
periodic system. You wouldn’t need the starting inventory or purchases amounts, 
just the difference between expected ending inventory and actual, that 
difference would be expensed to an account like this one:

Expenses:Cost of Goods Sold:Shrinkage

This is to account for ‘missing’ inventory where you can’t identify a reason 
for it being missing. (if you knew the reason, you’d likely put it under 
‘spoilage’, ‘samples’ etc.)

--

IF on the other hand, the vegetables, fruits and handicrafts you buy are for 
your OWN use, and not for resale, then NO, you should not lump those together 
with your inventory. Those should be either expensed directly, or held as an 
asset and expensed as you actually use them. (similar to how the inventory/COGS 
accounts work, but not using those exact same accounts since the items aren’t 
part of sales operations)


Regards,
Adrien

> On Feb 10, 2018, at 10:22 PM, Norbert Klein  wrote:
> 
> 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 

Re: Trading Accounts

2018-02-13 Thread Les

Good advice David.

I have always just used my broker reports for tax purposes.  I guess I 
never really relied on GC for such reporting.  I use GC to keep track of 
my day-to-day transactions; inputing from paper receipts as I receive 
them. Also reconciling bank and brokerage accounts at month end.


Les
On 02/12/2018 08:27 PM, David Carlson wrote:
Be sure to compare what Gnucash generates to what your broker reports 
to the government.  Gnucash has trouble calculating the net gain that 
the IRS wants to see.


Many of us still use spreadsheet s to compare to the brokerage reports 
that are sent to the IRS.


David C

On Feb 12, 2018 2:27 PM, "Les" > wrote:


I ran a balance sheet for 2016 and compared the two. Everything
looks the same until I reach the equity account.  Here is where
the difference occurs (and I completely missed it initially).  In
the GC file without the use of Trading Accounts, I have unrealized
gains, whereas in the GC file using Trading Accounts, I have
trading gains.

I think I need to start using Trading Accounts, if I want to
obtain a more accurate set of accounts.

For what it is worth, I have been relying on my brokerage accounts
to determine gains and losses for tax purposes.

I am thinking about copying my production GC file to my test
computer and run balance sheet and income and expense for ye 2017
and compare.  I think it will be significant.


Les
p.s.: I did read the the link from Christopher.


On 02/12/2018 12:05 PM, David Carlson wrote:

If you read Christopher's links, they go into the theory behind
the development of trading accounts.

I personally do not need them for my use, so I am not conversant
with how they work.

I think that you may need them, based on the fact that you are
looking into using them, but I cannot help with details.

Perhaps another user that does use them can chime in (hint Hint)

David C

On Mon, Feb 12, 2018 at 11:12 AM, Les > wrote:

I use, in addition to USD. AUD, HKD, CAD, CNY and SGD.  I buy
in tranches for average cost.  So, not sure that means I have
complicated trades but I make sure I never have any orphan
accounts. I checked my test file for capital and it did not
list any. Although, at the bottom of my accounts list, there
is a list of currencies and exchanges with totals for each.
But, again, there isn't any difference in income and expenses.

Les

On 02/12/2018 08:18 AM, David Carlson wrote:

UnfOrtumately I cannot read the article that zchristofer
cited from my
clunky Tablet ant tablet really messes up mystery
composition skills.

I think that if you have always correctly calculated
every capital gain in
every closing transaction and never had any ambiguously
matched lots there
will not be any overall difference with or without
trading accounts.

I would guess trading accounts help the most for users
with more
complicated trades.

I am sure that you would need to drill down to the
capital gains and
incomes in closing transactions to see where the  T A
could make a
difference.

David C



On Feb 12, 2018 6:53 AM, "Christopher Lam"
>
wrote:

Hi Les

Really interesting question, with a simple and a
complicated answer.

Simple answer: I think Trial Balance would differ if
you deal with
multiple currencies or stock (i.e. multiple
conversions with differing
dates and prices).

Complicated answer:

https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html



https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html



C

On 12/02/18 20:41, Les wrote:

I have a "test" laptop with GC 2.6.17 running the
latest Linux Mint.  I
opened GC and tried using Trading Accounts, did
check and repair, noted the
totals of assets, liabilities, income and expense
before and after.  There
was no difference.  I then ran a Income and
Expense report for year 2016
(which is the same as my production GC and
 

Re: Installation

2018-02-13 Thread Adrien Monteleone
I stand corrected on the lock file, though other apps that I see use them make 
them hidden so the user isn’t confused.

I still don’t see ANY other software dumping backups or log files into my data 
directories for any other file type. Gnucash is the only one. Everything else 
seems to be happy and quite functional with either /var/log, /tmp or some 
variant depending on the OS. I have yet to open a data directory and see a pile 
of log or state-backups mixed in along with my actual data file I’m looking 
for. Have I just been lucky all these years? Why are users so confused then if 
this is ‘standard procedure?’ (they should be quite used to it after all)

Regards,
Adrien

> On Feb 13, 2018, at 3:11 AM, Maf. King  wrote:
> 
> On Tuesday, 13 February 2018 04:05:12 GMT Adrien Monteleone wrote:
>> It would seem to me the ‘cleaner’ option to store the log and lock files in
>> some data directory like ".gnucash" "\Application Data\Gnucash" or
>> "~/Library/Application Support/Gnucash" (or otherwise as per the OS
>> recommendations) than have everything lumped together. Then, the user can
>> store their book in whatever place they like and not have other files the
>> app needs lying about to clutter their vision or aid to their confusion.
>> 
>> Certainly other needed files like reports, user prefs and the like are
>> handled this way. I never did grasp why the log and lock files weren’t.
>> 
> 
> Surely the lock file needs to be in the same place as the main data file?  
> Think 
> of 2 users on an nfs shared directory, for example.  Similarly for the 
> backups, though I guess a sub-folder in the same parent as the main data file 
> would be tidy.
> 
> ie 
> foo.gnucash
> backups-foo.gnucash/foo.gnucash.20180213091110.gnucash
> 
> etc.
> 
> 0.02
> Maf.
> 
> ___
> 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.

Re: Installation

2018-02-13 Thread Adrien Monteleone
Accessible? Sure. Always visible in the same location as their regular file 
mixed in? This seems to be a source of confusion. I have yet to encounter any 
other piece of software I can think of that operates this way. I’ve been using 
computers for several decades. My memory could be failing me, but I don’t 
recall this behavior elsewhere and I’ve never had an issue recovering data 
unless I was careless enough not to have a backup stored somewhere else.

The way Gnucash works right now would be somewhat analogous to a word processor 
saving file states every 5 minutes or so with a special extension. When you 
look in your documents directory you’d see dozens or more files with similar 
names, only one being the current ‘complete’ file you are looking for. Now, 
multiply that by 100s of files. Perhaps it isn’t so bad for those with one 
file, but one file is certainly not the only use case.

If what you say is the case, why do *nix distributions have an entirely 
separate /var/log tree instead of just piling everything into your file's 
working directory? Windows has a similar setup with their Application Data tree.

Regards,
Adrien

> On Feb 13, 2018, at 1:59 AM, David T.  wrote:
> 
> Adrien, 
> 
> Log files have to be visible to the user, so that when they have to recover 
> from an error state in their files, they can use them to restore. 
> 
> David
> 
> 
> On Tue, Feb 13, 2018 at 9:05, Adrien Monteleone
>  wrote:
> It would seem to me the ‘cleaner’ option to store the log and lock files in 
> some data directory like ".gnucash" "\Application Data\Gnucash" or 
> "~/Library/Application Support/Gnucash" (or otherwise as per the OS 
> recommendations) than have everything lumped together. Then, the user can 
> store their book in whatever place they like and not have other files the app 
> needs lying about to clutter their vision or aid to their confusion.
> 
> Certainly other needed files like reports, user prefs and the like are 
> handled this way. I never did grasp why the log and lock files weren’t.
> 
> Regards,
> Adrien
> 
> > On Feb 12, 2018, at 10:45 AM, David Carlson  
> > wrote:
> > 
> > Michael,
> > 
> > I agree that the backup scheme should be as idiot proof as possible.
> > 
> > However, one reason (of several) that I personally am not using a cloud
> > service yet is that I do not see how the cloud would handle all all those
> > log files coming and going and data files being renamed every few minutes.
> > 
> > Also, ordinary users get lost if they browse the folder looking for a data
> > file.
> > 
> > Perhaps a simple (?) scheme of putting backup s in a sub folder named
> > filename_backup or similar might help with these issues, even if it adds
> > overhead to move files around.
> > 
> > I think the developer s are considering relocating backups in the 3.0
> > release do this is a good time to discuss this.
> > 
> > Sorry my tablet just decided that I nrrdrf a smaller keyboard.
> > 
> > David
> > 
> > On Feb 12, 2018 9:49 AM, "Mike or Penny Novack" <
> > stepbystepf...@dialup4less.com> wrote:
> > 
> >> On 2/12/2018 10:08 AM, David Carlson wrote:
> >> 
> >> Johnathan,
> >> 
> >> GnuCash may or may not play well with various cloud storage services
> >> because of it's insistence (in current releases) on keeping it's automatic
> >> backups in the same folder as the data file.
> >> 
> >> 
> >> Just so understood why it makes sense (to me)  to "insist" the automatic
> >> backups go into the same directory as the file. It guarantees gnucash being
> >> able to make up a UNIQUE name for the backups. If you were allowed to
> >> specify a directory B  in which to put the automatic backups for
> >> books.gnucash in directory A, what prevents directory B from also
> >> containing  a file named books.gnucash ?
> >> 
> >> Yes of course, care by the user could prevent a disaster like that, but as
> >> somebody who used to get paid to unscramble messes caused by that sort of
> >> carelessness, absolute prevention is better.
> >> 
> >> Michael D Novack
> >> 
> > ___
> > 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 

Re: Installation

2018-02-13 Thread Maf. King
On Tuesday, 13 February 2018 04:05:12 GMT Adrien Monteleone wrote:
> It would seem to me the ‘cleaner’ option to store the log and lock files in
> some data directory like ".gnucash" "\Application Data\Gnucash" or
> "~/Library/Application Support/Gnucash" (or otherwise as per the OS
> recommendations) than have everything lumped together. Then, the user can
> store their book in whatever place they like and not have other files the
> app needs lying about to clutter their vision or aid to their confusion.
> 
> Certainly other needed files like reports, user prefs and the like are
> handled this way. I never did grasp why the log and lock files weren’t.
> 

Surely the lock file needs to be in the same place as the main data file?  
Think 
of 2 users on an nfs shared directory, for example.  Similarly for the 
backups, though I guess a sub-folder in the same parent as the main data file 
would be tidy.

ie 
foo.gnucash
backups-foo.gnucash/foo.gnucash.20180213091110.gnucash

etc.

0.02
Maf.

___
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: Installation

2018-02-13 Thread Colin Law
I would support the idea of the log and backup files being in a
subdirectory named using the accounts file name as a seed, so for example
myaccounts.gnucash.archive or maybe for those windows users who have
problems with file extensions not being shown myaccounts_gnucash_archive.
Something like that anyway. I think that would reduce the likelihood of
users accidentally opening backup files instead of the main accounts file,
which is something we hear of here regularly. Also it would allow the
accounts file to be placed on the desktop which is something some users
seem to like doing.

Colin

On 13 February 2018 at 07:59, David T. via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Adrien,
> Log files have to be visible to the user, so that when they have to
> recover from an error state in their files, they can use them to restore.
> David
>
>
>
>   On Tue, Feb 13, 2018 at 9:05, Adrien Monteleone gmail.com> wrote:   It would seem to me the ‘cleaner’ option to store the
> log and lock files in some data directory like ".gnucash" "\Application
> Data\Gnucash" or "~/Library/Application Support/Gnucash" (or otherwise as
> per the OS recommendations) than have everything lumped together. Then, the
> user can store their book in whatever place they like and not have other
> files the app needs lying about to clutter their vision or aid to their
> confusion.
>
> Certainly other needed files like reports, user prefs and the like are
> handled this way. I never did grasp why the log and lock files weren’t.
>
> Regards,
> Adrien
>
> > On Feb 12, 2018, at 10:45 AM, David Carlson 
> wrote:
> >
> > Michael,
> >
> > I agree that the backup scheme should be as idiot proof as possible.
> >
> > However, one reason (of several) that I personally am not using a cloud
> > service yet is that I do not see how the cloud would handle all all those
> > log files coming and going and data files being renamed every few
> minutes.
> >
> > Also, ordinary users get lost if they browse the folder looking for a
> data
> > file.
> >
> > Perhaps a simple (?) scheme of putting backup s in a sub folder named
> > filename_backup or similar might help with these issues, even if it adds
> > overhead to move files around.
> >
> > I think the developer s are considering relocating backups in the 3.0
> > release do this is a good time to discuss this.
> >
> > Sorry my tablet just decided that I nrrdrf a smaller keyboard.
> >
> > David
> >
> > On Feb 12, 2018 9:49 AM, "Mike or Penny Novack" <
> > stepbystepf...@dialup4less.com> wrote:
> >
> >> On 2/12/2018 10:08 AM, David Carlson wrote:
> >>
> >> Johnathan,
> >>
> >> GnuCash may or may not play well with various cloud storage services
> >> because of it's insistence (in current releases) on keeping it's
> automatic
> >> backups in the same folder as the data file.
> >>
> >>
> >> Just so understood why it makes sense (to me)  to "insist" the automatic
> >> backups go into the same directory as the file. It guarantees gnucash
> being
> >> able to make up a UNIQUE name for the backups. If you were allowed to
> >> specify a directory B  in which to put the automatic backups for
> >> books.gnucash in directory A, what prevents directory B from also
> >> containing  a file named books.gnucash ?
> >>
> >> Yes of course, care by the user could prevent a disaster like that, but
> as
> >> somebody who used to get paid to unscramble messes caused by that sort
> of
> >> carelessness, absolute prevention is better.
> >>
> >> Michael D Novack
> >>
> > ___
> > 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.
> ___
> 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.
>

Template for GST India

2018-02-13 Thread Frank H. Ellenberger
Thanks to all involved! I adjusted the PR for both branches. So the
template will be in GnuCash 2.6.20 and 2.7.5.

Because the language is english (en), but the region is India (IN) you
will see it if you run
$ LANG=en_IN gnucash

But you can choose another language for the surface of the program if
you start it e.g. with
$ LANGUAGE=hi LANG=en_IN gnucash

Some of you might prefer one of the following values for LANUAGE:
as, brx, doi, gu, kn, kok, kok@latin, ks, mai, mni, mni@bengali, mr, ne,
ta, te, ur.

For details about LANG* see
https://wiki.gnucash.org/wiki/Locale_Settings

Regards
Frank

Am 08.02.2018 um 11:30 schrieb Deva -:
> Thanks Amish. I am glad you were able to compensate for my failings…
> 
> I am sure many users can benefit from your template, especially if it gets 
> shipped as part of the next release like Frank said.
> 
> Cheers,
> Deva
> 
>> Message: 1
>> Date: Wed, 7 Feb 2018 22:26:35 +0530
>> From: Amish 
>> To: gnucash-user@gnucash.org
>> Subject: Re: Instructions for GST India
>> Message-ID: <9ab0f1b1-c69b-707b-6bb9-262578619...@gmail.com>
>> Content-Type: text/plain; charset=utf-8; format=flowed
>>
>>
>> On Tuesday 06 February 2018 08:02 PM, Frank H. Ellenberger wrote:
:
>> Created pull request:
>> https://github.com/Gnucash/gnucash/pull/275
>>
>> Description:
>> This is the base module for setting up accounts for an Indian Business 
>> with Goods and Service Tax (GST).
>>
>> Mostly uses Indian terminology to ease the filing of many Indian 
>> Government returs - e.g. Income tax returns, MCA returns and GST returns.
>>
>> Amish

___
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.