Re: [GNC] How To Record an In-Kind Charitable Donation?

[Adrien Monteleone]

Definitely talk to a local CPA on this.

Materials and services which would otherwise have to be purchased by the 
ministry are generally recordable by both entities. However, the services are 
possibly not (at least in the US) deductible. If you regularly produce these 
materials for other customers without separate material and design fees, then 
you can invoice the full amount and get a donation receipt accordingly, but if 
the design fees are usually separate, the ministry may not be allowed to 
include that in their receipt to you. (this is why you need to talk to a local 
CPA)

Regardless, you can record the fair market value you would normally sell the 
materials for, not the cost. Yes, this would be a debit to some Charitable 
Expense account and a credit to Income/Revenue. (the debit/credit is the same 
for services rendered)

Note, you can’t ‘donate’ services as a professional that aren’t your 
profession. For example, an attorney stuffing envelopes for a non-profit 
mail-out doesn’t record a donation of his consultation time and the non-profit 
doesn’t record receipt of any professional service. But in your case, if you 
routinely handle mail-outs as a service to other customers you could maybe 
donate this to the ministry, though again, can’t likely deduct it or get a 
receipt for it. (but you should probably still invoice it so you can each 
record the gift/expense on your books)

Regards,
Adrien

> Eric H. Bowen on Sat Jun 30 15:10:52 EDT 2018
> 
> 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?
> 
> Eric H. Bowen



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

Re: [GNC] Getting My Account To Trial Balance

[Adrien Monteleone]

I’ll give 3.3 a try and test. I seem to recall this error in the past and then 
it was working again because I recall helping someone hunt down an issue with 
this report in April or May. (I was supposed to file a bug report on how 
foreign currency balances are calculated for the report, but I think 
Christopher Lam's upcoming report changes are going to render that moot)

Regards,
Adrien

> On Jul 25, 2018, at 11:21 PM, David Carlson  
> wrote:
> 
> David T,
> 
> Yes, I trade securities and GnuCash can handle my books as well as it can a 
> very simple set of books.
> Shug had indicated in an earlier message that in this case there was only one 
> currency and no securities and Adrien and I were trying to tailor our answers 
> to his case.
> 
> David C
> 
> 
> 
> On Wed, Jul 25, 2018, 8:51 PM David T.  wrote:
> David,
> 
> I imagine that the number of GnuCash users who only have accounts in a single 
> currency (i.e., without any investments in stocks, mutual funds, or other 
> commodities) is probably pretty small.
> 
> For those who *do* have such holdings, a balanced transaction will still fail 
> the trial balance if the gain or loss isn’t entered. In this instance, there 
> will be no entries in IMBALANCE-XXX, since each transaction balances. 
> Example: buy 10 shares of X for $100, using cash from your checking account 
> (credit/debit of $100). Then sell those shares for $150 (debit/credit of 
> $150). Both transaction balance—but where did that extra cash come from? 
> Without entering the gain of $50 as income, the Trial balance will fail. You 
> can enter that gain manually, or use trading accounts or the scrub lots 
> feature to help manage this.
> 
> David T.
> 
> On July 25, 2018 at 7:45:10 PM, David Carlson (david.carlson@gmail.com) 
> wrote:
> 
>> I have no experience with release 3.2 or with High Sierra, so I hope others
>> can help Shug with reports.
>> 
>> As Adrien Monteleone and David T both point out, the Trial Balance report
>> may be of little or no value to users who only use one currency and do not
>> buy or sell stock or other commodities. You could probably skip that
>> report altogether.
>> 
>> GnuCash forces every transaction to either be a perfectly balanced double
>> entry transaction in one currency or it automatically adds one of the two
>> accounts that Adrien Monteleone mentioned. When those are equal to zero,
>> your books are balanced
>> 
>> The Trial Balance report is for users with more complex needs.
>> 
>> David C.
>> 
>> On Wed, Jul 25, 2018 at 6:05 PM, Adrien Monteleone <
>> adrien.montele...@lusfiber.net> wrote:
>> 
>> > I get that same error. (MacOS High Sierra, GnuCash 3.2)
>> >
>> > My suspicion is misconfigured report options, but I’m not familiar with
>> > the report enough to know which one(s). I never bother with this report
>> > because I don’t use the Close Books function. I also don’t really
>> > understand it’s purpose with a perpetual system in light of the existence
>> > of the orphan-xxx and imbalance-xxx accounts. If those are both zero, how
>> > does one still need to adjust anything before closing books?
>> >
>> > Regards,
>> > Adrien
>> >
>> > > On Jul 25, 2018, at 5:49 PM, David Carlson 
>> > wrote:
>> > >
>> > > That is a bird of a different feather. Then it will help to know which
>> > > release you are using and what operating system your computer has,
>> > because
>> > > the solution may be to switch to a different release or to try some more
>> > > complex debugging if you are up to it.
>> > >
>> > > Do include gnucash-user@gnucash.org in every reply so other users see
>> > the
>> > > comments.
>> > >
>> > > David C
>> > >
>> > > On Wed, Jul 25, 2018 at 3:13 PM, H M MacDonald OBE <
>> > sassunach...@gmail.com>
>> > > wrote:
>> > >
>> > >> Hi David/Richard
>> > >>
>> > >> The error message is as follows:
>> > >>
>> > >> *Report error*
>> > >>
>> > >> *An error occurred while running the report.*
>> > >>
>> > >> It doesn’t give any clue as to what’s wrong.
>> > >>
>> > >> Thanks.
>> > >>
>> > >> Shug
>> > >>
>> > >> From: D 
>> > >> Date: Wednesday, 25 July 2018 at 20:33
>> > >> To: David Carlson , Hugh MacDonald OBE <
>> > >> spahonsec...@gmail.com>
>> > >> Cc: Gnucash Users 
>> > >> Subject: Re: [GNC] GETTING MY ACCOUNT TO TRIAL BALANCE
>> > >>
>> > >> Shug,
>> > >>
>> > >> I would ask you to tell us what error message you have received, since I
>> > >> don't usually see any error messages when I run this report. (I do have
>> > >> trouble getting this report to balance, however).
>> > >>
>> > >> However, David has made useful advice regarding tracking transaction
>> > gain
>> > >> or loss; I would add that in Gnucash, a commodity is a broadly defined
>> > >> concept, and covers anything you have that is not counted in your
>> > default
>> > >> currency.
>> > >>
>> > >> In other words, stocks, mutual funds, as well as accounts denominated in
>> > >> another currency will all fall into this category, and any time you
>> > have a
>> > 

[GNC] Bug in design of commodity sell transactions? (was Re: Getting My Account To Trial Balance)

[Adrien Monteleone]

I suppose this is for another thread and certainly not on point for the OP’s 
question, but I don’t see those two transactions as balanced.

The first one is. You credit $100 from Assets:Cash and debit $100 to 
Assets:Stocks (or whatever it’s designated as)

The second one is not balanced. You’re debiting $150 to Cash, but you only have 
$100 in Assets:Stocks to credit. It doesn’t magically grow to $150. Sure, the 
sell price reflects this, but the difference as you note is Income. That sell 
transaction can’t be balanced without a credit to Income as part of it. If 
GnuCash allows this, I’d say that’s a bug. (not a feature) Perhaps the 
implementation of the feature was designed that way, but then the bug is not in 
the code but in the design of the feature. I find it strange GC would 
auto-enter a split for Imbalance-xxx or Orphan-xxx in any normal register 
transaction, but a sell transaction doesn’t do the same if you don’t book a 
gain or loss as one of the splits.

I’m sure I’m not understanding how this works. (I do account for multiple 
currencies as on-off acquisitions, but I don’t trade them or any securities) It 
can’t be that easy to create an unbalanced sell transaction is it?

Do the price revaluations not auto-generate splits balanced to Unrealized 
Loss/Gain accounts? Or at least store the info in order to generate that 
Loss/Gain balancing split on the sale?

Regards,
Adrien

> On Jul 25, 2018, at 8:50 PM, David T.  wrote:
> 
> David,
> 
> I imagine that the number of GnuCash users who only have accounts in a single 
> currency (i.e., without any investments in stocks, mutual funds, or other 
> commodities) is probably pretty small.
> 
> For those who *do* have such holdings, a balanced transaction will still fail 
> the trial balance if the gain or loss isn’t entered. In this instance, there 
> will be no entries in IMBALANCE-XXX, since each transaction balances. 
> Example: buy 10 shares of X for $100, using cash from your checking account 
> (credit/debit of $100). Then sell those shares for $150 (debit/credit of 
> $150). Both transaction balance—but where did that extra cash come from? 
> Without entering the gain of $50 as income, the Trial balance will fail. You 
> can enter that gain manually, or use trading accounts or the scrub lots 
> feature to help manage this.
> 
> David T.

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

Re: [GNC] Getting My Account To Trial Balance

[David Carlson]

David T,

Yes, I trade securities and GnuCash can handle my books as well as it can a
very simple set of books.
Shug had indicated in an earlier message that in this case there was only
one currency and no securities and Adrien and I were trying to tailor our
answers to his case.

David C



On Wed, Jul 25, 2018, 8:51 PM David T.  wrote:

> David,
>
> I imagine that the number of GnuCash users who only have accounts in a
> single currency (i.e., without any investments in stocks, mutual funds, or
> other commodities) is probably pretty small.
>
> For those who *do* have such holdings, a balanced transaction will still
> fail the trial balance if the gain or loss isn’t entered. In this instance,
> there will be no entries in IMBALANCE-XXX, since each transaction balances.
> Example: buy 10 shares of X for $100, using cash from your checking account
> (credit/debit of $100). Then sell those shares for $150 (debit/credit of
> $150). Both transaction balance—but where did that extra cash come from?
> Without entering the gain of $50 as income, the Trial balance will fail.
> You can enter that gain manually, or use trading accounts or the scrub lots
> feature to help manage this.
>
> David T.
>
> On July 25, 2018 at 7:45:10 PM, David Carlson (david.carlson@gmail.com)
> wrote:
>
> I have no experience with release 3.2 or with High Sierra, so I hope others
> can help Shug with reports.
>
> As Adrien Monteleone and David T both point out, the Trial Balance report
> may be of little or no value to users who only use one currency and do not
> buy or sell stock or other commodities. You could probably skip that
> report altogether.
>
> GnuCash forces every transaction to either be a perfectly balanced double
> entry transaction in one currency or it automatically adds one of the two
> accounts that Adrien Monteleone mentioned. When those are equal to zero,
> your books are balanced
>
> The Trial Balance report is for users with more complex needs.
>
> David C.
>
> On Wed, Jul 25, 2018 at 6:05 PM, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
> > I get that same error. (MacOS High Sierra, GnuCash 3.2)
> >
> > My suspicion is misconfigured report options, but I’m not familiar with
> > the report enough to know which one(s). I never bother with this report
> > because I don’t use the Close Books function. I also don’t really
> > understand it’s purpose with a perpetual system in light of the existence
> > of the orphan-xxx and imbalance-xxx accounts. If those are both zero, how
> > does one still need to adjust anything before closing books?
> >
> > Regards,
> > Adrien
> >
> > > On Jul 25, 2018, at 5:49 PM, David Carlson <
> david.carlson@gmail.com>
> > wrote:
> > >
> > > That is a bird of a different feather. Then it will help to know which
> > > release you are using and what operating system your computer has,
> > because
> > > the solution may be to switch to a different release or to try some
> more
> > > complex debugging if you are up to it.
> > >
> > > Do include gnucash-user@gnucash.org in every reply so other users see
> > the
> > > comments.
> > >
> > > David C
> > >
> > > On Wed, Jul 25, 2018 at 3:13 PM, H M MacDonald OBE <
> > sassunach...@gmail.com>
> > > wrote:
> > >
> > >> Hi David/Richard
> > >>
> > >> The error message is as follows:
> > >>
> > >> *Report error*
> > >>
> > >> *An error occurred while running the report.*
> > >>
> > >> It doesn’t give any clue as to what’s wrong.
> > >>
> > >> Thanks.
> > >>
> > >> Shug
> > >>
> > >> From: D 
> > >> Date: Wednesday, 25 July 2018 at 20:33
> > >> To: David Carlson , Hugh MacDonald OBE <
> > >> spahonsec...@gmail.com>
> > >> Cc: Gnucash Users 
> > >> Subject: Re: [GNC] GETTING MY ACCOUNT TO TRIAL BALANCE
> > >>
> > >> Shug,
> > >>
> > >> I would ask you to tell us what error message you have received,
> since I
> > >> don't usually see any error messages when I run this report. (I do
> have
> > >> trouble getting this report to balance, however).
> > >>
> > >> However, David has made useful advice regarding tracking transaction
> > gain
> > >> or loss; I would add that in Gnucash, a commodity is a broadly defined
> > >> concept, and covers anything you have that is not counted in your
> > default
> > >> currency.
> > >>
> > >> In other words, stocks, mutual funds, as well as accounts denominated
> in
> > >> another currency will all fall into this category, and any time you
> > have a
> > >> transaction involving thread accounts, you will need to account for
> > gain or
> > >> loss hidden in the conversion.
> > >>
> > >> David T
> > >>
> > >> On July 25, 2018, at 1:52 PM, David Carlson <
> > david.carlson@gmail.com>
> > >> wrote:
> > >>
> > >> I assume that you mean the debits do not equal the credits rather than
> > that
> > >> GnuCash failed to generate the report.
> > >>
> > >> This is commonly the result of selling a commodity for a different
> price
> > >> than what was originally paid without correctly accounting for the

Re: [GNC] Getting My Account To Trial Balance

[David T. via gnucash-user]

David,

I imagine that the number of GnuCash users who only have accounts in a single 
currency (i.e., without any investments in stocks, mutual funds, or other 
commodities) is probably pretty small.

For those who *do* have such holdings, a balanced transaction will still fail 
the trial balance if the gain or loss isn’t entered. In this instance, there 
will be no entries in IMBALANCE-XXX, since each transaction balances. Example: 
buy 10 shares of X for $100, using cash from your checking account 
(credit/debit of $100). Then sell those shares for $150 (debit/credit of $150). 
Both transaction balance—but where did that extra cash come from? Without 
entering the gain of $50 as income, the Trial balance will fail. You can enter 
that gain manually, or use trading accounts or the scrub lots feature to help 
manage this.

David T.

On July 25, 2018 at 7:45:10 PM, David Carlson (david.carlson@gmail.com) 
wrote:

I have no experience with release 3.2 or with High Sierra, so I hope others
can help Shug with reports.

As Adrien Monteleone and David T both point out, the Trial Balance report
may be of little or no value to users who only use one currency and do not
buy or sell stock or other commodities. You could probably skip that
report altogether.

GnuCash forces every transaction to either be a perfectly balanced double
entry transaction in one currency or it automatically adds one of the two
accounts that Adrien Monteleone mentioned. When those are equal to zero,
your books are balanced

The Trial Balance report is for users with more complex needs.

David C.

On Wed, Jul 25, 2018 at 6:05 PM, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> I get that same error. (MacOS High Sierra, GnuCash 3.2)
>
> My suspicion is misconfigured report options, but I’m not familiar with
> the report enough to know which one(s). I never bother with this report
> because I don’t use the Close Books function. I also don’t really
> understand it’s purpose with a perpetual system in light of the existence
> of the orphan-xxx and imbalance-xxx accounts. If those are both zero, how
> does one still need to adjust anything before closing books?
>
> Regards,
> Adrien
>
> > On Jul 25, 2018, at 5:49 PM, David Carlson 
> wrote:
> >
> > That is a bird of a different feather. Then it will help to know which
> > release you are using and what operating system your computer has,
> because
> > the solution may be to switch to a different release or to try some more
> > complex debugging if you are up to it.
> >
> > Do include gnucash-user@gnucash.org in every reply so other users see
> the
> > comments.
> >
> > David C
> >
> > On Wed, Jul 25, 2018 at 3:13 PM, H M MacDonald OBE <
> sassunach...@gmail.com>
> > wrote:
> >
> >> Hi David/Richard
> >>
> >> The error message is as follows:
> >>
> >> *Report error*
> >>
> >> *An error occurred while running the report.*
> >>
> >> It doesn’t give any clue as to what’s wrong.
> >>
> >> Thanks.
> >>
> >> Shug
> >>
> >> From: D 
> >> Date: Wednesday, 25 July 2018 at 20:33
> >> To: David Carlson , Hugh MacDonald OBE <
> >> spahonsec...@gmail.com>
> >> Cc: Gnucash Users 
> >> Subject: Re: [GNC] GETTING MY ACCOUNT TO TRIAL BALANCE
> >>
> >> Shug,
> >>
> >> I would ask you to tell us what error message you have received, since I
> >> don't usually see any error messages when I run this report. (I do have
> >> trouble getting this report to balance, however).
> >>
> >> However, David has made useful advice regarding tracking transaction
> gain
> >> or loss; I would add that in Gnucash, a commodity is a broadly defined
> >> concept, and covers anything you have that is not counted in your
> default
> >> currency.
> >>
> >> In other words, stocks, mutual funds, as well as accounts denominated in
> >> another currency will all fall into this category, and any time you
> have a
> >> transaction involving thread accounts, you will need to account for
> gain or
> >> loss hidden in the conversion.
> >>
> >> David T
> >>
> >> On July 25, 2018, at 1:52 PM, David Carlson <
> david.carlson@gmail.com>
> >> wrote:
> >>
> >> I assume that you mean the debits do not equal the credits rather than
> that
> >> GnuCash failed to generate the report.
> >>
> >> This is commonly the result of selling a commodity for a different price
> >> than what was originally paid without correctly accounting for the
> profit
> >> or loss. One technique to close in on a transaction contributing to the
> >> difference is to include a shorter time period in the report until the
> >> values do balance. Once the date is determined, look for a commodity
> >> transaction that is not balanced by a profit or loss.
> >>
> >> David C
> >>
> >> On Wed, Jul 25, 2018 at 12:20 PM, H Millar MacDonald OBE <
> >> spahonsec...@gmail.com> wrote:
> >>
> >> Hi
> >>
> >> I¹ve just become involved with GnuCash 3.2 and set up my first accounts
> for
> >> our club. It all looks okay except and will provide a profit and loss
> >> report on 

Re: [GNC] Payroll add-on, module, software?

[John Ralls]

> On Jul 25, 2018, at 2:55 PM, Mike or Penny Novack 
>  wrote:
> 
> On 7/25/2018 2:06 PM, Adrien Monteleone wrote:
>> R. but the short answer is, no, there is no (and probably won’t ever be) 
>> any payroll module or features. Unfortunately, the jurisdictional 
>> requirement nightmare to comply with every nuance across the entire planet 
>> is beyond the time and resources of the small development team.
>> 
>> However, GnuCash can handle the payroll accounting entries and even print 
>> the checks. (with vouchers if you’re up for some finagling)
>> 
>> You’ll have to calculate the deductions from gross separately in some other 
>> software first though. The most common suggestion I’ve seen is to setup a 
>> spreadsheet with the proper deduction rates and you just fill in the 
>> gross.
> 
> But that is ONLY if there is an insistence on monolithic design. What might 
> not be beyond the capabilities of the development team is to introduce a 
> facility for gnucash to accept FEEDS (from external components). Once that 
> capability is present, it would be possible for OTHER teams to come into 
> existence to create POS and Payroll systems << both of those have 
> jurisdiction dependencies so might well be just for this or that jurisdiction 
> >> that would interface with gnucash and other external facilities like 
> "inventory" which would be more likely universal << not jurisdiction 
> dependent >>
> 
> However I've always been on the modular side in the great monolithic vs 
> modular debate.

GnuCash is actually very modular (perhaps a little too much, there are parts of 
it that are modules and probably shouldn't be). I wouldn't say it's easy, 
nothing in programming GnuCash seems to be easy, but it's possible for a third 
party developer to create a payroll module for their jurisdiction and for users 
in that jurisdiction to add it to their GnuCash installations.

But in 20 years no third party developer has ever expressed any interest in 
creating a GnuCash plugin. 

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: [GNC] Getting My Account To Trial Balance

[David Carlson]

I have no experience with release 3.2 or with High Sierra, so I hope others
can help Shug with reports.

As Adrien Monteleone and David T both point out, the Trial Balance report
may be of little or no value to users who only use one currency and do not
buy or sell stock or other commodities.  You could probably skip that
report altogether.

GnuCash forces every transaction to either be a perfectly balanced double
entry transaction in one currency or it automatically adds one of the two
accounts that Adrien Monteleone mentioned. When those are equal to zero,
your books are balanced

The Trial Balance report is for users with more complex needs.

David C.

On Wed, Jul 25, 2018 at 6:05 PM, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> I get that same error. (MacOS High Sierra, GnuCash 3.2)
>
> My suspicion is misconfigured report options, but I’m not familiar with
> the report enough to know which one(s). I never bother with this report
> because I don’t use the Close Books function. I also don’t really
> understand it’s purpose with a perpetual system in light of the existence
> of the orphan-xxx and imbalance-xxx accounts. If those are both zero, how
> does one still need to adjust anything before closing books?
>
> Regards,
> Adrien
>
> > On Jul 25, 2018, at 5:49 PM, David Carlson 
> wrote:
> >
> > That is a bird of a different feather.  Then it will help to know which
> > release you are using and what operating system your computer has,
> because
> > the solution may be to switch to a different release or to try some more
> > complex debugging if you are up to it.
> >
> > Do include gnucash-user@gnucash.org in every reply so other users see
> the
> > comments.
> >
> > David C
> >
> > On Wed, Jul 25, 2018 at 3:13 PM, H M MacDonald OBE <
> sassunach...@gmail.com>
> > wrote:
> >
> >> Hi David/Richard
> >>
> >> The error message is as follows:
> >>
> >> *Report error*
> >>
> >> *An error occurred while running the report.*
> >>
> >> It doesn’t give any clue as to what’s wrong.
> >>
> >> Thanks.
> >>
> >> Shug
> >>
> >> From: D 
> >> Date: Wednesday, 25 July 2018 at 20:33
> >> To: David Carlson , Hugh MacDonald OBE <
> >> spahonsec...@gmail.com>
> >> Cc: Gnucash Users 
> >> Subject: Re: [GNC] GETTING MY ACCOUNT TO TRIAL BALANCE
> >>
> >> Shug,
> >>
> >> I would ask you to tell us what error message you have received, since I
> >> don't usually see any error messages when I run this report. (I do have
> >> trouble getting this report to balance, however).
> >>
> >> However, David has made useful advice regarding tracking transaction
> gain
> >> or loss; I would add that in Gnucash, a commodity is a broadly defined
> >> concept, and covers anything you have that is not counted in your
> default
> >> currency.
> >>
> >> In other words, stocks, mutual funds, as well as accounts denominated in
> >> another currency will all fall into this category, and any time you
> have a
> >> transaction involving thread accounts, you will need to account for
> gain or
> >> loss hidden in the conversion.
> >>
> >> David T
> >>
> >> On July 25, 2018, at 1:52 PM, David Carlson <
> david.carlson@gmail.com>
> >> wrote:
> >>
> >> I assume that you mean the debits do not equal the credits rather than
> that
> >> GnuCash failed to generate the report.
> >>
> >> This is commonly the result of selling a commodity for a different price
> >> than what was originally paid without correctly accounting for the
> profit
> >> or loss.  One technique to close in on a transaction contributing to the
> >> difference is to include a shorter time period in the report until the
> >> values do balance.  Once the date is determined, look for a commodity
> >> transaction that is not balanced by a profit or loss.
> >>
> >> David C
> >>
> >> On Wed, Jul 25, 2018 at 12:20 PM, H Millar MacDonald OBE <
> >> spahonsec...@gmail.com> wrote:
> >>
> >> Hi
> >>
> >> I¹ve just become involved with GnuCash 3.2 and set up my first accounts
> for
> >> our club.   It all looks okay except  and will provide a profit and loss
> >> report on Income and Expenditure  which is good.  However, when I try to
> >> get
> >> a Trial Balance I get an error message which according to Google seems
> to
> >> be
> >> quite common.  I don¹t know where to start to fix this.  Can anyone
> offer
> >> any advice please?  I am an absolute novice at all of this so please be
> >> patient with my request.
> >>
> >> Many thanks.
> >>
> >> Shug
> >>
> >>
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >>
> >> 

Re: [GNC] GETTING MY ACCOUNT TO TRIAL BALANCE

[Rich Shepard]

On Thu, 26 Jul 2018, H Millar MacDonald OBE wrote:


The release is 3.2 and the OS is High Sierra. I’m not very savvy so
complex debugging is probably beyond me. If all else fails then i can do
the trial balance manually but it rather defeats the purpose.


  My accountant likes to see a trial balance for each bank account when I
send her tax information. It's a quick check of errors. That's what I use it
for, too.

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: [GNC] GETTING MY ACCOUNT TO TRIAL BALANCE

[H Millar MacDonald OBE]

Thanks David.  The release is 3.2 and the OS is High Sierra.  I’m not very 
savvy so complex debugging is probably beyond me.  If all else fails then i can 
do the trial balance manually but it rather defeats the purpose.

Shug

> On 25 Jul 2018, at 23:49, David Carlson  wrote:
> 
> That is a bird of a different feather.  Then it will help to know which 
> release you are using and what operating system your computer has, because 
> the solution may be to switch to a different release or to try some more 
> complex debugging if you are up to it.
> 
> Do include gnucash-user@gnucash.org in every reply so other users see the 
> comments.
> 
> David C
> 
>> On Wed, Jul 25, 2018 at 3:13 PM, H M MacDonald OBE  
>> wrote:
>> Hi David/Richard
>> 
>> The error message is as follows:
>> 
>> Report error
>> 
>> An error occurred while running the report.
>> 
>> It doesn’t give any clue as to what’s wrong.
>> 
>> Thanks.
>> 
>> Shug
>> 
>> From: D 
>> Date: Wednesday, 25 July 2018 at 20:33
>> To: David Carlson , Hugh MacDonald OBE 
>> 
>> Cc: Gnucash Users 
>> Subject: Re: [GNC] GETTING MY ACCOUNT TO TRIAL BALANCE
>> 
>> Shug,
>> 
>> I would ask you to tell us what error message you have received, since I 
>> don't usually see any error messages when I run this report. (I do have 
>> trouble getting this report to balance, however).
>> 
>> However, David has made useful advice regarding tracking transaction gain or 
>> loss; I would add that in Gnucash, a commodity is a broadly defined concept, 
>> and covers anything you have that is not counted in your default currency.
>> 
>> In other words, stocks, mutual funds, as well as accounts denominated in 
>> another currency will all fall into this category, and any time you have a 
>> transaction involving thread accounts, you will need to account for gain or 
>> loss hidden in the conversion.
>> 
>> David T
>> 
>> On July 25, 2018, at 1:52 PM, David Carlson  
>> wrote:
>> 
>> I assume that you mean the debits do not equal the credits rather than that
>> GnuCash failed to generate the report.
>> 
>> This is commonly the result of selling a commodity for a different price
>> than what was originally paid without correctly accounting for the profit
>> or loss.  One technique to close in on a transaction contributing to the
>> difference is to include a shorter time period in the report until the
>> values do balance.  Once the date is determined, look for a commodity
>> transaction that is not balanced by a profit or loss.
>> 
>> David C
>> 
>> On Wed, Jul 25, 2018 at 12:20 PM, H Millar MacDonald OBE <
>> spahonsec...@gmail.com> wrote:
>> 
>> Hi
>> 
>> I¹ve just become involved with GnuCash 3.2 and set up my first accounts for
>> our club.   It all looks okay except  and will provide a profit and loss
>> report on Income and Expenditure  which is good.  However, when I try to
>> get
>> a Trial Balance I get an error message which according to Google seems to
>> be
>> quite common.  I don¹t know where to start to fix this.  Can anyone offer
>> any advice please?  I am an absolute novice at all of this so please be
>> patient with my request.
>> 
>> Many thanks.
>> 
>> Shug
>> 
>> 
>> ___
>> 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.

Re: [GNC] Getting My Account To Trial Balance

[Adrien Monteleone]

I get that same error. (MacOS High Sierra, GnuCash 3.2)

My suspicion is misconfigured report options, but I’m not familiar with the 
report enough to know which one(s). I never bother with this report because I 
don’t use the Close Books function. I also don’t really understand it’s purpose 
with a perpetual system in light of the existence of the orphan-xxx and 
imbalance-xxx accounts. If those are both zero, how does one still need to 
adjust anything before closing books?

Regards,
Adrien

> On Jul 25, 2018, at 5:49 PM, David Carlson  
> wrote:
> 
> That is a bird of a different feather.  Then it will help to know which
> release you are using and what operating system your computer has, because
> the solution may be to switch to a different release or to try some more
> complex debugging if you are up to it.
> 
> Do include gnucash-user@gnucash.org in every reply so other users see the
> comments.
> 
> David C
> 
> On Wed, Jul 25, 2018 at 3:13 PM, H M MacDonald OBE 
> wrote:
> 
>> Hi David/Richard
>> 
>> The error message is as follows:
>> 
>> *Report error*
>> 
>> *An error occurred while running the report.*
>> 
>> It doesn’t give any clue as to what’s wrong.
>> 
>> Thanks.
>> 
>> Shug
>> 
>> From: D 
>> Date: Wednesday, 25 July 2018 at 20:33
>> To: David Carlson , Hugh MacDonald OBE <
>> spahonsec...@gmail.com>
>> Cc: Gnucash Users 
>> Subject: Re: [GNC] GETTING MY ACCOUNT TO TRIAL BALANCE
>> 
>> Shug,
>> 
>> I would ask you to tell us what error message you have received, since I
>> don't usually see any error messages when I run this report. (I do have
>> trouble getting this report to balance, however).
>> 
>> However, David has made useful advice regarding tracking transaction gain
>> or loss; I would add that in Gnucash, a commodity is a broadly defined
>> concept, and covers anything you have that is not counted in your default
>> currency.
>> 
>> In other words, stocks, mutual funds, as well as accounts denominated in
>> another currency will all fall into this category, and any time you have a
>> transaction involving thread accounts, you will need to account for gain or
>> loss hidden in the conversion.
>> 
>> David T
>> 
>> On July 25, 2018, at 1:52 PM, David Carlson 
>> wrote:
>> 
>> I assume that you mean the debits do not equal the credits rather than that
>> GnuCash failed to generate the report.
>> 
>> This is commonly the result of selling a commodity for a different price
>> than what was originally paid without correctly accounting for the profit
>> or loss.  One technique to close in on a transaction contributing to the
>> difference is to include a shorter time period in the report until the
>> values do balance.  Once the date is determined, look for a commodity
>> transaction that is not balanced by a profit or loss.
>> 
>> David C
>> 
>> On Wed, Jul 25, 2018 at 12:20 PM, H Millar MacDonald OBE <
>> spahonsec...@gmail.com> wrote:
>> 
>> Hi
>> 
>> I¹ve just become involved with GnuCash 3.2 and set up my first accounts for
>> our club.   It all looks okay except  and will provide a profit and loss
>> report on Income and Expenditure  which is good.  However, when I try to
>> get
>> a Trial Balance I get an error message which according to Google seems to
>> be
>> quite common.  I don¹t know where to start to fix this.  Can anyone offer
>> any advice please?  I am an absolute novice at all of this so please be
>> patient with my request.
>> 
>> Many thanks.
>> 
>> Shug
>> 
>> 
>> ___
>> 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.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription 

Re: [GNC] GETTING MY ACCOUNT TO TRIAL BALANCE

[David Carlson]

That is a bird of a different feather.  Then it will help to know which
release you are using and what operating system your computer has, because
the solution may be to switch to a different release or to try some more
complex debugging if you are up to it.

Do include gnucash-user@gnucash.org in every reply so other users see the
comments.

David C

On Wed, Jul 25, 2018 at 3:13 PM, H M MacDonald OBE 
wrote:

> Hi David/Richard
>
> The error message is as follows:
>
> *Report error*
>
> *An error occurred while running the report.*
>
> It doesn’t give any clue as to what’s wrong.
>
> Thanks.
>
> Shug
>
> From: D 
> Date: Wednesday, 25 July 2018 at 20:33
> To: David Carlson , Hugh MacDonald OBE <
> spahonsec...@gmail.com>
> Cc: Gnucash Users 
> Subject: Re: [GNC] GETTING MY ACCOUNT TO TRIAL BALANCE
>
> Shug,
>
> I would ask you to tell us what error message you have received, since I
> don't usually see any error messages when I run this report. (I do have
> trouble getting this report to balance, however).
>
> However, David has made useful advice regarding tracking transaction gain
> or loss; I would add that in Gnucash, a commodity is a broadly defined
> concept, and covers anything you have that is not counted in your default
> currency.
>
> In other words, stocks, mutual funds, as well as accounts denominated in
> another currency will all fall into this category, and any time you have a
> transaction involving thread accounts, you will need to account for gain or
> loss hidden in the conversion.
>
> David T
>
> On July 25, 2018, at 1:52 PM, David Carlson 
> wrote:
>
> I assume that you mean the debits do not equal the credits rather than that
> GnuCash failed to generate the report.
>
> This is commonly the result of selling a commodity for a different price
> than what was originally paid without correctly accounting for the profit
> or loss.  One technique to close in on a transaction contributing to the
> difference is to include a shorter time period in the report until the
> values do balance.  Once the date is determined, look for a commodity
> transaction that is not balanced by a profit or loss.
>
> David C
>
> On Wed, Jul 25, 2018 at 12:20 PM, H Millar MacDonald OBE <
> spahonsec...@gmail.com> wrote:
>
> Hi
>
> I¹ve just become involved with GnuCash 3.2 and set up my first accounts for
> our club.   It all looks okay except  and will provide a profit and loss
> report on Income and Expenditure  which is good.  However, when I try to
> get
> a Trial Balance I get an error message which according to Google seems to
> be
> quite common.  I don¹t know where to start to fix this.  Can anyone offer
> any advice please?  I am an absolute novice at all of this so please be
> patient with my request.
>
> Many thanks.
>
> Shug
>
>
> ___
> 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.

Re: [GNC] Logs.

[David Carlson]

Then try a very short setting.  One or two days.  I  know that a thirty day
setting works fine in 2.6.x releases to delete old logs and backups.

David C

On Wed, Jul 25, 2018 at 3:00 PM, varda241  wrote:

> It is not just one or two. There are logs created each time I open the
> program.
>
>
>
> Sent from my Verizon, Samsung Galaxy smartphone
>
>
>  Original message 
> From: David Carlson 
> Date: 7/25/18 1:12 PM (GMT-05:00)
> To: varda241 
> Cc: gnucash-user 
> Subject: Re: [GNC] Logs.
>
> I never tried that setting, but if there is one or two, is that a problem?
>
> David C
>
> On Wed, Jul 25, 2018 at 11:29 AM, varda241 via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
>>
>>
>> Is there any way to stop them? I have "never" on my preference and tha
>> still show up.Thanks, Varda
>>
>>
>> Sent from my Verizon, Samsung Galaxy smartphone
>> ___
>> 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: [GNC] Payroll add-on, module, software?

[Mike or Penny Novack]

On 7/25/2018 2:06 PM, Adrien Monteleone wrote:

R. but the short answer is, no, there is no (and probably won’t ever be) 
any payroll module or features. Unfortunately, the jurisdictional requirement 
nightmare to comply with every nuance across the entire planet is beyond the 
time and resources of the small development team.

However, GnuCash can handle the payroll accounting entries and even print the 
checks. (with vouchers if you’re up for some finagling)

You’ll have to calculate the deductions from gross separately in some other 
software first though. The most common suggestion I’ve seen is to setup a 
spreadsheet with the proper deduction rates and you just fill in the gross.


But that is ONLY if there is an insistence on monolithic design. What 
might not be beyond the capabilities of the development team is to 
introduce a facility for gnucash to accept FEEDS (from external 
components). Once that capability is present, it would be possible for 
OTHER teams to come into existence to create POS and Payroll systems << 
both of those have jurisdiction dependencies so might well be just for 
this or that jurisdiction >> that would interface with gnucash and other 
external facilities like "inventory" which would be more likely 
universal << not jurisdiction dependent >>


However I've always been on the modular side in the great monolithic vs 
modular debate.


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.

Re: [GNC] Payroll add-on, module, software?

[Adrien Monteleone]

Interesting. I’ll look’em over. Thanks!

Regards,
Adrien

> On Jul 25, 2018, at 3:07 PM, Rich Shepard  wrote:
> 
> On Wed, 25 Jul 2018, Adrien Monteleone wrote:
> 
>> Firefox is a browser, not a search engine, but I believe the current
>> version defaults to using Google for it’s combo address bar-search field.
>> (you can customize the toolbar to show the old separate search field where
>> you can install many search engines and choose between them when
>> searching) If you’re on an older version then it uses Yahoo! You can also
>> manually change the default to any engine you have installed in the
>> browser.
> 
> Adrien,
> 
>  True. I should have written that duckduckgo allows for both mail list
> searching as well as > 1,000 bang (!) codes. See, for example,
> .
> 
> 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.

[GNC] Installing 3.2

[Raymond Moritz]

I’m running 3.0 on Windows 10. I’d like to move to 3.2. Do I have to
uninstall 3.0 first? Import or convert the data file? Any other things that
must be done or precautions?

Sent this first from the wrong account. Sorry.

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

Re: [GNC] Payroll add-on, module, software?

[Rich Shepard]

On Wed, 25 Jul 2018, Adrien Monteleone wrote:


Firefox is a browser, not a search engine, but I believe the current
version defaults to using Google for it’s combo address bar-search field.
(you can customize the toolbar to show the old separate search field where
you can install many search engines and choose between them when
searching) If you’re on an older version then it uses Yahoo! You can also
manually change the default to any engine you have installed in the
browser.


Adrien,

  True. I should have written that duckduckgo allows for both mail list
searching as well as > 1,000 bang (!) codes. See, for example,
.

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: [GNC] Logs.

[varda241 via gnucash-user]

It is not just one or two. There are logs created each time I open the program.


Sent from my Verizon, Samsung Galaxy smartphone

 Original message 
From: David Carlson  
Date: 7/25/18  1:12 PM  (GMT-05:00) 
To: varda241  
Cc: gnucash-user  
Subject: Re: [GNC] Logs. 

I never tried that setting, but if there is one or two, is that a problem?
David C

On Wed, Jul 25, 2018 at 11:29 AM, varda241 via gnucash-user 
 wrote:




Is there any way to stop them? I have "never" on my preference and tha still 
show up.Thanks, Varda





Sent from my Verizon, Samsung Galaxy smartphone

___

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: [GNC] GETTING MY ACCOUNT TO TRIAL BALANCE

[D via gnucash-user]

Shug,

I would ask you to tell us what error message you have received, since I don't 
usually see any error messages when I run this report. (I do have trouble 
getting this report to balance, however).

However, David has made useful advice regarding tracking transaction gain or 
loss; I would add that in Gnucash, a commodity is a broadly defined concept, 
and covers anything you have that is not counted in your default currency. 

In other words, stocks, mutual funds, as well as accounts denominated in 
another currency will all fall into this category, and any time you have a 
transaction involving thread accounts, you will need to account for gain or 
loss hidden in the conversion.

David T

On July 25, 2018, at 1:52 PM, David Carlson  wrote:

I assume that you mean the debits do not equal the credits rather than that
GnuCash failed to generate the report.

This is commonly the result of selling a commodity for a different price
than what was originally paid without correctly accounting for the profit
or loss.  One technique to close in on a transaction contributing to the
difference is to include a shorter time period in the report until the
values do balance.  Once the date is determined, look for a commodity
transaction that is not balanced by a profit or loss.

David C

On Wed, Jul 25, 2018 at 12:20 PM, H Millar MacDonald OBE <
spahonsec...@gmail.com> wrote:

> Hi
>
> I¹ve just become involved with GnuCash 3.2 and set up my first accounts for
> our club.   It all looks okay except  and will provide a profit and loss
> report on Income and Expenditure  which is good.  However, when I try to
> get
> a Trial Balance I get an error message which according to Google seems to
> be
> quite common.  I don¹t know where to start to fix this.  Can anyone offer
> any advice please?  I am an absolute novice at all of this so please be
> patient with my request.
>
> Many thanks.
>
> Shug
>
>
> ___
> 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.

Re: [GNC] Payroll add-on, module, software?

[Roderick Anderson]

Thanks Adrien.  The restricted/qualified search string worked great.  I 
was just searching for FOSS payroll software.  Too many wrong results.


I'm thinking your suggestion to use a spreadsheet might be the trick needed.

I'm seeing my friend later today so I'll suggest this as an option too.


Again thanks,
Aod
--
On 07/25/2018 11:06 AM, Adrien Monteleone wrote:

site:lists.gnucash.org payroll

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

Re: [GNC] Payroll add-on, module, software?

[Adrien Monteleone]

Firefox is a browser, not a search engine, but I believe the current version 
defaults to using Google for it’s combo address bar-search field. (you can 
customize the toolbar to show the old separate search field where you can 
install many search engines and choose between them when searching) If you’re 
on an older version then it uses Yahoo! You can also manually change the 
default to any engine you have installed in the browser.

I just tried the site: option on both Bing and Yahoo and they both work. 
StartPage has severely truncated results with this specifier. (some terms 
return nothing) I’ve yet to see DuckDuckGo return anything at all using this. 
(both DuckDuckGo and StartPage use the Google engine via proxy)

Regards,
Adrien

> On Jul 25, 2018, at 1:45 PM, Rich Shepard  wrote:
> 
> On Wed, 25 Jul 2018, Adrien Monteleone wrote:
> 
>> That will limit the search to only the mailing list server. (I don’t think
>> other search engines have that feature)
> 
> Adrien,
> 
>  Firefox does.
> 
> 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: [GNC] GETTING MY ACCOUNT TO TRIAL BALANCE

[Rich Shepard]

On Wed, 25 Jul 2018, H Millar MacDonald OBE wrote:


However, when I try to get a Trial Balance I get an error message which
according to Google seems to be quite common. I don¹t know where to start
to fix this. Can anyone offer any advice please? I am an absolute novice
at all of this so please be patient with my request.


Shug,

  It would help folks to help you if you provide the error message you see.

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: [GNC] Payroll add-on, module, software?

[Adrien Monteleone]

Rod,

Do a list search for payroll questions via Google like this:

“site:lists.gnucash.org payroll”

That will limit the search to only the mailing list server. (I don’t think 
other search engines have that feature)

You’ll find many list topics dealing with the subject but the short answer is, 
no, there is no (and probably won’t ever be) any payroll module or features. 
Unfortunately, the jurisdictional requirement nightmare to comply with every 
nuance across the entire planet is beyond the time and resources of the small 
development team.

However, GnuCash can handle the payroll accounting entries and even print the 
checks. (with vouchers if you’re up for some finagling)

You’ll have to calculate the deductions from gross separately in some other 
software first though. The most common suggestion I’ve seen is to setup a 
spreadsheet with the proper deduction rates and you just fill in the gross.

If you spend some time on the formatting and setup, you could possibly even 
import the resulting transactions to GnuCash so as to avoid data duplication 
entry errors. (and save time)

Also, if the payroll transactions are generally the same, that is, salary based 
and regularly issued, you could either simply use the ‘duplicate transaction’ 
function each pay period, or otherwise set up a template scheduled transaction 
accordingly. (you get to approve the actual transaction) The latter option has 
the benefit of tying into a future scheduled transaction report so you can use 
that data to track future profitability.

Regards,
Adrien

> On Jul 25, 2018, at 11:22 AM, Roderick Anderson  wrote:
> 
> Looking for a way to handle payroll (US) that works/blends with  GNUCash.
> 
> The company I'm helping (actually a friend) is running some software that 
> isn't even available any more.
> 
> I've exposed her to GNUCash but the biggest hold up is payroll.  She does 
> accounting for some (very) small Water Districts and Homeowner Associations.
> 
> The database and associated files are hosted on a Linux server.  After this 
> last crash I really need to get her to move to software I can support.
> 
> Any suggestions or pointers to methods to handle payroll with GNUCash as the 
> accounting/bookkeeping.
> 
> 
> Side trip.  I use GNUCash for a small not-for-profit but have almost no 
> accounting experience so have kind-of blundered my way along -- 
> accounting-wise. (They keep reelecting me as Treasurer so I must be doing 
> something right.  Or, more probably, nobody else wants the job.)  :-)
> 
> 
> TIA,
> Rod
> -- 
> ___
> 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: [GNC] balance sheet and account equation for Business Accounts

[Stephen M. Butler]

On 07/25/2018 09:13 AM, nor via gnucash-user wrote:
> I have separate income accounts for USD and Euro transactions. When the need
> arises than only funds from Euro is converted to default USD account held at
> the bank at the prevailing exchange rate. 
>
> balance sheet report is with exchange rates at balance sheet report date.
> May be these exchange rate variations are not automatically accounts as
> gain/loss in B/L report.
>
> nor
>

You need to enable trading accounts and follow the setup described at
https://wiki.gnucash.org/wiki/Trading_Accounts
Please read the two articles it mentions at the top.  Essentially
foreign exchange rate changes act like stock price fluctuations.

--Steve

-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

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

Re: [GNC] GETTING MY ACCOUNT TO TRIAL BALANCE

[David Carlson]

I assume that you mean the debits do not equal the credits rather than that
GnuCash failed to generate the report.

This is commonly the result of selling a commodity for a different price
than what was originally paid without correctly accounting for the profit
or loss.  One technique to close in on a transaction contributing to the
difference is to include a shorter time period in the report until the
values do balance.  Once the date is determined, look for a commodity
transaction that is not balanced by a profit or loss.

David C

On Wed, Jul 25, 2018 at 12:20 PM, H Millar MacDonald OBE <
spahonsec...@gmail.com> wrote:

> Hi
>
> I¹ve just become involved with GnuCash 3.2 and set up my first accounts for
> our club.   It all looks okay except  and will provide a profit and loss
> report on Income and Expenditure  which is good.  However, when I try to
> get
> a Trial Balance I get an error message which according to Google seems to
> be
> quite common.  I don¹t know where to start to fix this.  Can anyone offer
> any advice please?  I am an absolute novice at all of this so please be
> patient with my request.
>
> Many thanks.
>
> Shug
>
>
> ___
> 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.

[GNC] GETTING MY ACCOUNT TO TRIAL BALANCE

[H Millar MacDonald OBE]

Hi

I¹ve just become involved with GnuCash 3.2 and set up my first accounts for
our club.   It all looks okay except  and will provide a profit and loss
report on Income and Expenditure  which is good.  However, when I try to get
a Trial Balance I get an error message which according to Google seems to be
quite common.  I don¹t know where to start to fix this.  Can anyone offer
any advice please?  I am an absolute novice at all of this so please be
patient with my request.

Many thanks.

Shug


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

Re: [GNC] Logs.

[David Carlson]

I never tried that setting, but if there is one or two, is that a problem?

David C

On Wed, Jul 25, 2018 at 11:29 AM, varda241 via gnucash-user <
gnucash-user@gnucash.org> wrote:

>
>
> Is there any way to stop them? I have "never" on my preference and tha
> still show up.Thanks, Varda
>
>
> Sent from my Verizon, Samsung Galaxy smartphone
> ___
> 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.

[GNC] Logs.

[varda241 via gnucash-user]

Is there any way to stop them? I have "never" on my preference and tha still 
show up.Thanks, Varda


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

[GNC] Payroll add-on, module, software?

[Roderick Anderson]

Looking for a way to handle payroll (US) that works/blends with  GNUCash.

The company I'm helping (actually a friend) is running some software 
that isn't even available any more.


I've exposed her to GNUCash but the biggest hold up is payroll.  She 
does accounting for some (very) small Water Districts and Homeowner 
Associations.


The database and associated files are hosted on a Linux server.  After 
this last crash I really need to get her to move to software I can support.


Any suggestions or pointers to methods to handle payroll with GNUCash as 
the accounting/bookkeeping.



Side trip.  I use GNUCash for a small not-for-profit but have almost no 
accounting experience so have kind-of blundered my way along -- 
accounting-wise. (They keep reelecting me as Treasurer so I must be 
doing something right.  Or, more probably, nobody else wants the job.)  :-)



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

Re: [GNC] balance sheet and account equation for Business Accounts

[nor via gnucash-user]

Thanks. Shall do by this weekend. In Ver 3.2 standard report seems to be
located at user/.gnucash/book

nor




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

Re: [GNC] balance sheet and account equation for Business Accounts

[nor via gnucash-user]

I have separate income accounts for USD and Euro transactions. When the need
arises than only funds from Euro is converted to default USD account held at
the bank at the prevailing exchange rate. 

balance sheet report is with exchange rates at balance sheet report date.
May be these exchange rate variations are not automatically accounts as
gain/loss in B/L report.

nor




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

Re: [GNC] opening my accounts after I have saved them

[DaveC49]

Johnnie
Use File ->Open from the menu and navigate to the location where you saved
the file. Hopefully you did not save the file to a read only CD. You should
have received a warning that the device could not be written to if you had
attempted to do that.

Open the file .gnucash where filename is the name you saved the
file with.

Ignore files with the format .gnucash..gnucash or 
.gnucash..log as these are backup and logfiles, useful
for rebuilding if your main file becomes corrupted.

After this, on most or all operating systems GnuCash should open the file
selected above. On some operating systems you cannot run GnuCash by double
clicking on the data file . See the archives of this mailing list for
details for specific OSes.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Missing menus

[DaveC49]

Joe,

I've been using GnuCash on Linux Mint for approx 5 years with no problems.
The Software manager version is sometimes a little behind the current
GnuCash version but at present it has a flatpak GnuCash V3.2 available that
worked fine under LM18.3 and is working fine on LM19.  I'm currently running
Linux Mint 19 (Tara) and previously used the LM17 and 18 versions. I have
also built GnuCash from source on Linux Mint for the last couple of years
and I like to stay up to date (also kid myself I might get involved in
development in a minor way when I get bored with being retired).

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] opening my accounts after I have saved them

[Colin Law]

It should automatically open the last saved accounts file if you restart
gnucash.  If not then use File > Open and browse to the file.  Assuming
that works then close and reopen gnucash and check it re-opens the file.

Note that on a Mac you cannot double click an accounts file to open it,
that will just open the last uese accounts file.

Colin

On 24 July 2018 at 23:56, JOHNNIE BROWNING  wrote:

> I am unable to open my account after I have posted and then saved them. It
> keepts opening my cd drive
> ___
> 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: [GNC] opening my accounts after I have saved them

[Maf. King]

On Tuesday, 24 July 2018 23:56:04 BST JOHNNIE BROWNING wrote:
> I am unable to open my account after I have posted and then saved them. It
> keepts opening my cd drive

Hi Jonnie,

Are you on a Mac, by any chance?

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.


-- 
Maf. King
PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542





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