Re: [GNC] Postgress connection string for nonstandard port

[Peter West]

Are you on Windows, Mac or linux? How do you invoke GnuCash? There will be some 
sort of environment in which the invocation occurs from your end.

—
Peter West
p...@pbw.id.au
“Blessed are the peacemakers, for they shall be called sons of God.”

> On 23 Feb 2023, at 2:13 am, Bob Treumann  wrote:
> 
> 
> 
> I could set it since I control the server, but I don't know where I would set 
> it so that it would take effect before the connection attempt is made.   
> 
> On Tue, Feb 21, 2023 at 10:53 PM Peter West  > wrote:
> Is it possible for you to set the PGPORT environment variable?
> 
> 
> —
> Peter West
> p...@pbw.id.au 
> “Blessed are the peacemakers, for they shall be called sons of God.”
> 
>> On 22 Feb 2023, at 11:01 am, Peter West > > wrote:
>> 
>> I’m using the default port, so I can’t help there.
>> 
>> “Database” refers to the database, in my case, gnucash.
>> 
>> 
>> —
>> Peter West
>> p...@pbw.id.au 
>> “Blessed are the pure in heart, for they shall see God.”
>> 
>>> On 22 Feb 2023, at 8:07 am, Bob Treumann >> > wrote:
>>> 
>>> I am running PG on an amazon server on a non standard port (6543).
>>> 
>>> The connection setup on gnucash does not have a filed to input the port.
>>> I added the port to the end of the hostname, a style that has worked with
>>> other applications.
>>> 
>>> There is a field to enter the "database", which in PG contains multiple
>>> schemas.
>>> The user is typically connected to a schema by a default path.
>>> 
>>> My questions are:
>>> How do I define the port?
>>> Does "Database" refer to "Schema"?
>>> 
>>> I would try every combination but the interface only gives me one chance.
>>> It gives a "cannot connect" message then closes.
>>> 
>>> 
>>> [image: image.png]
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org 
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>>> 
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org 
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>> 
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Using Plaid

[john]

> On Feb 22, 2023, at 2:01 PM, Ben Pracht  wrote:
> 
> I'd like to use Plaid with GnuCash. There is a plaid2qif project that
> claims to have been extensively tested with GnuCash and Plaid. However,
> when I created the Plaid account, it asks for either a limited developer
> account or a production account with a compliance audit. What account type
> should I use? Anything else helpful to know?

Neither. See 
https://github.com/ebridges/plaid2qif/blob/master/gen-access-token/README.md,

Pay particular attention to the disclaimer at the bottom of that page.

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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Cash on Hand [was: Interest Income]

[Gyle McCollam]

I track all the money I spend, but my wife doesn't want to be bothered.  So, 
when she takes money from the bank or other sources, I just credit that source 
and expense the money to an account named for her.  you could do the same for 
each person's "mad" money.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of R Losey 
Sent: Wednesday, February 22, 2023 4:36 PM
To: Larry Long 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Cash on Hand [was: Interest Income]

It's a good idea, but I apparently wasn't clear... we have set up a scheme
where each of us gets a certain amount of private money ("pin money" is an
old term for this; some call it "mad money" or "fun money") - it can  be
spent however the person chooses with no questions asked. We have
sub-accounts to track our private money, and when we take cash out, it is
taken away from the subaccount balance.  But when we spend cash from our
private fund, we don't track them (by choice).

Cash money spent that is NOT from our private account is tracked... and we
do have "Gifts" and "Gifts:Birthday" , and "Dining", etc.  We try to ensure
that we get receipts and record all of these.  Sometimes, we run to the
store for something small and pay cash - that, too is tracked.

Because of that, I just have to adjust the cash balance every now and then,
and "Adjustment" works well for our situation.

But thank you for the suggestions.

RL

On Tue, Feb 21, 2023 at 10:09 AM Larry Long  wrote:

>  M/M Losey,
> As you say, your actual cash funds can easily diverge from what is shown
> in your GNC 'Cash on Hand" account.Instead of periodically equalizing via a
> "Balance Adjustment" account, you might consider setting up some expense
> accounts that allow you to be more definitive.
> For recording known spending, you could have some accounts such as these:
>
>- Expenses:Gifts
>- Expenses:Gifts:Christmas
>- Expenses:Dining
>- Expenses:Dining:Cash Tips
>- Expenses:Personal Care
>- Expenses:Miscellaneous
> When you get a haircut for example, you could enter that as a $25 transfer
> from "Assets:Cash on Hand" to "Expenses:Personal Care".
> If you are like me, at the end of the month you might find only $60 in
> your wallet, while GNC shows $100 cash.  Knowing that you did, but not
> remembering where you spent the difference, you could always throw $40 in
> GNC from "Cash on Hand" into "Miscellaneous".
> Larry 
> On Tuesday, February 21, 2023 at 06:38:31 AM EST,
> gnucash-user-requ...@gnucash.org 
> wrote:
>  Date: Mon, 20 Feb 2023 21:24:49 -0600
> From: R Losey 
> To: Abe Sternberg 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Interest Income
> Message-ID:
> 
> Content-Type: text/plain; charset="UTF-8"
>
> In your example, one account is the savings account and the other would be
> something like "Income:Interest Income".
>
> I'm a non-bookkeeper (though I have had an overview of accounting);
> unfortunately, the general language which we use has "debit" used to mean
> "to take away from" and "credit" meaning "to add to". I could learn the
> proper distinction, but I just turn off the formal terms.
>
>
> To me, the idea of double-entry just means that every transaction needs to
> balance... for example, a deposit to your checking account doesn't come out
> of thin air -- it's either a salary or a gift or a refund or something you
> sold: there has to be SOMETHING that it came from.
>
> I had to create a "balance adjustment" account, since when I cash a check,
> I add the cash to "Cash on Hand", but some of that money is private
> spending money for family members, and that isn't tracked, so I routinely
> have to update the "Cash on Hand" balance.
>
> ...
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


--
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Using Plaid

[Ben Pracht]

I'd like to use Plaid with GnuCash. There is a plaid2qif project that
claims to have been extensively tested with GnuCash and Plaid. However,
when I created the Plaid account, it asks for either a limited developer
account or a production account with a compliance audit. What account type
should I use? Anything else helpful to know?

Thanks,
Ben
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Cash on Hand [was: Interest Income]

[R Losey]

It's a good idea, but I apparently wasn't clear... we have set up a scheme
where each of us gets a certain amount of private money ("pin money" is an
old term for this; some call it "mad money" or "fun money") - it can  be
spent however the person chooses with no questions asked. We have
sub-accounts to track our private money, and when we take cash out, it is
taken away from the subaccount balance.  But when we spend cash from our
private fund, we don't track them (by choice).

Cash money spent that is NOT from our private account is tracked... and we
do have "Gifts" and "Gifts:Birthday" , and "Dining", etc.  We try to ensure
that we get receipts and record all of these.  Sometimes, we run to the
store for something small and pay cash - that, too is tracked.

Because of that, I just have to adjust the cash balance every now and then,
and "Adjustment" works well for our situation.

But thank you for the suggestions.

RL

On Tue, Feb 21, 2023 at 10:09 AM Larry Long  wrote:

>  M/M Losey,
> As you say, your actual cash funds can easily diverge from what is shown
> in your GNC 'Cash on Hand" account.Instead of periodically equalizing via a
> "Balance Adjustment" account, you might consider setting up some expense
> accounts that allow you to be more definitive.
> For recording known spending, you could have some accounts such as these:
>
>- Expenses:Gifts
>- Expenses:Gifts:Christmas
>- Expenses:Dining
>- Expenses:Dining:Cash Tips
>- Expenses:Personal Care
>- Expenses:Miscellaneous
> When you get a haircut for example, you could enter that as a $25 transfer
> from "Assets:Cash on Hand" to "Expenses:Personal Care".
> If you are like me, at the end of the month you might find only $60 in
> your wallet, while GNC shows $100 cash.  Knowing that you did, but not
> remembering where you spent the difference, you could always throw $40 in
> GNC from "Cash on Hand" into "Miscellaneous".
> Larry 
> On Tuesday, February 21, 2023 at 06:38:31 AM EST,
> gnucash-user-requ...@gnucash.org 
> wrote:
>  Date: Mon, 20 Feb 2023 21:24:49 -0600
> From: R Losey 
> To: Abe Sternberg 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Interest Income
> Message-ID:
> 
> Content-Type: text/plain; charset="UTF-8"
>
> In your example, one account is the savings account and the other would be
> something like "Income:Interest Income".
>
> I'm a non-bookkeeper (though I have had an overview of accounting);
> unfortunately, the general language which we use has "debit" used to mean
> "to take away from" and "credit" meaning "to add to". I could learn the
> proper distinction, but I just turn off the formal terms.
>
>
> To me, the idea of double-entry just means that every transaction needs to
> balance... for example, a deposit to your checking account doesn't come out
> of thin air -- it's either a salary or a gift or a refund or something you
> sold: there has to be SOMETHING that it came from.
>
> I had to create a "balance adjustment" account, since when I cash a check,
> I add the cash to "Cash on Hand", but some of that money is private
> spending money for family members, and that isn't tracked, so I routinely
> have to update the "Cash on Hand" balance.
>
> ...
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Postgress connection string for nonstandard port

[Bob Treumann]

I could set it since I control the server, but I don't know where I would
set it so that it would take effect before the connection attempt is made.


On Tue, Feb 21, 2023 at 10:53 PM Peter West  wrote:

> Is it possible for you to set the PGPORT environment variable?
>
>
> —
> Peter West
> p...@pbw.id.au
> “Blessed are the peacemakers, for they shall be called sons of God.”
>
> On 22 Feb 2023, at 11:01 am, Peter West  wrote:
>
> I’m using the default port, so I can’t help there.
>
> “Database” refers to the database, in my case, gnucash.
>
>
> —
> Peter West
> p...@pbw.id.au
> “Blessed are the pure in heart, for they shall see God.”
>
> On 22 Feb 2023, at 8:07 am, Bob Treumann  wrote:
>
> I am running PG on an amazon server on a non standard port (6543).
>
> The connection setup on gnucash does not have a filed to input the port.
> I added the port to the end of the hostname, a style that has worked with
> other applications.
>
> There is a field to enter the "database", which in PG contains multiple
> schemas.
> The user is typically connected to a schema by a default path.
>
> My questions are:
> How do I define the port?
> Does "Database" refer to "Schema"?
>
> I would try every combination but the interface only gives me one chance.
> It gives a "cannot connect" message then closes.
>
>
> [image: image.png]
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Not-for-profit report configurations sought

[Michael or Penny Novack]

On 2/22/2023 8:13 AM, briancady413--- via gnucash-user wrote:

Hi folks,
I seek standard not-for-profit report configurations, for quarterly use 
internal-to-organization.
Links/leads appreciated,
Brian-


I can help with this BUT ..

a) The how to set up the CoA and what is normal for reports isn't REALLY 
a gnucash question. In other words, were you still keeping your books 
the old fashioned way pen and ink on paper, what would your CoA look 
like and what would your reports look like.


b) Because the Board of Directors probably want a different level of 
detail than you might need to fill out reports you must file with 
authorities, perhaps the easiest approach is to create the reports with 
the highest detail required, export from gnucash, and then edit the 
reports to simplify detail as desired. For example, if doing a 
990/990-EZ "printing and postage" is a line item but the BoD probably 
wants to see total event cost, not how much was printing and postage. Or 
with interns, etc. you need to know how much each paid (need to fill out 
a 1099-MISC) but the BoD probably wants to see just the total for all 
interns.


c) The titles of some reports are different. For example, not "Profit 
and Loss" but "Revenues and Expenses" (but it i the same report). It is 
customary for the annual report to do current year and previous side by 
side, but again, this is easiest done outside of gnucash using your 
favorite editor. Normally you want the ability to add 
annotation/footnotes for anything unusual and a full power editor makes 
that easier.


d) A minor annoyance but gnucash does not allow using business features 
like invoicing without being on the accrual basis but the membership 
often wants membership statements. There are work-arounds. The point 
here is that membership dues in a voluntary organization are not a 
receivable (there is no obligation to renew membership)


e) I can only help with state filing requirements for Massachusetts 
(don't know what those might be for any other jurisdictions)


f) You did NOT say what sort of non-profit (under what designation)


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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Not-for-profit report configurations sought

[briancady413--- via gnucash-user]

Hi folks,
I seek standard not-for-profit report configurations, for quarterly use 
internal-to-organization.
Links/leads appreciated,
Brian-
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.