Re: [GNC] Questions about setting up new accounts from brand new user

[R Losey]

I agree.  I let GnuCash create a chart of accounts and then modify it to
meet my needs.

On Mon, Jan 23, 2023 at 12:21 PM David Carlson 
wrote:

> Maf showed you how to start to create a single account.
>
> If you want to create an entire chart of accounts click File > New and
> select the option to create New Account Hierarchy Setup
> You might want to try this more than once because it will then give you a
> lot of choices for different applications and you may be a little
> overwhelmed the first time around.
>
> On Mon, Jan 23, 2023 at 11:29 AM Maf. King  wrote:
>
> > On Monday, 23 January 2023 17:10:51 GMT Ann Bowes wrote:
> > > Hi folks,
> > >
> > > I'm trying to set up a simple manual checking account for a small farm
> > > business.  I've down-loaded the gnucash program to my laptop (linux
> > > zorin OS), and have tried to open new accounts, but am completely
> > > stumped as to how to do this.  I've read through the tutorial (at
> > > https://gnucash-docs-rst.readthedocs.io/en/latest/index.html), but I'm
> > > still stumped  Can anyone give me some pointers?
> > >
> >
> > Hi Ann,
> >
> > you mean you need to create an account in your Gnucash books?
> >
> > see the attached image for a pointer...
> >
> > HTH,
> > 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
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> --
> David Carlson
> ___
> 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] Questions about setting up new accounts from brand new user

[Adrien Monteleone]

On 1/23/23 2:33 PM, flywire wrote:

that isn't the latest, nor official documentation.


No, it's not but it is the version I recommend. Feedback on how it compares
with the official version would be useful.


The official documentation should always be the recommendation. It is 
actively maintained, refined and updated to match the current app 
version. (not perfect, but it is always the best version)


You'd have to diff the two or find a way to merge/copy the gnucash-docs 
PRs to that readthedocs repo.


Also, that link is just the Tutorial & Concepts Guide. It doesn't look 
that Repo contains the Help documentation, and I didn't find a separate 
link for one.



Two farm-related use issues for me are no automatic sales tax calculations
for cash accounting (only business features with accrual accounting) and no
classification on transactions (eg classify your vehicle expenses for lamb
and tourism enterprises then report by classification). There are
workarounds.


And those workarounds aren't terribly difficult:

1. Create invoices as needed, and either wait to post until they are 
paid, or unpost/repost/process-payment. (or handle 
point-of-sales/invoicing outside of GnuCash and import the result)


2. Use any free-form 'tag' in your transactions using various or 
multiple fields and use the Transaction Report with filters. (not 
perfect, I know, and it would be nicer if the Income Statement supported 
the same filters)



Regards,
Adrien

___
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] Questions about setting up new accounts from brand new user

[David Cousens]

Ann,
I you are getting the window with the Accounts tab (it is the default until you
open an account register) click on it then right click on whichever of the top
level accounts you wish to create the account under and slect New Account and
the account creation dialogue will come up. You can edit account details at any
time but changing the parent account will change the position in the account
tree. The choices for account type are usually limited to appropriate choices
for the parent account you selected in the first step.
David Cousens
On Mon, 2023-01-23 at 09:10 -0800, Ann Bowes wrote:
> Hi folks,
> 
> I'm trying to set up a simple manual checking account for a small farm 
> business.  I've down-loaded the gnucash program to my laptop (linux 
> zorin OS), and have tried to open new accounts, but am completely 
> stumped as to how to do this.  I've read through the tutorial (at 
> https://gnucash-docs-rst.readthedocs.io/en/latest/index.html), but I'm 
> still stumped  Can anyone give me some pointers?
> 
> Much thanks,
> 
> Ann
> 
> ___
> 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] Questions about setting up new accounts from brand new user

[Adrien Monteleone]

Ann, that isn't the latest, nor official documentation.

For that, see https://gnucash.org/docs.phtml (the Documentation link 
from the left-hand menu under either Downloads or Support)


There is the 'Help' and the 'Tutorial & Concepts Guide'.

Both should be accessible from the Help menu when running GnuCash as well.

-
*The Read the Docs version was created 3 years ago as a proof of concept 
for a different formatting and delivery means for the documentation but 
was not necessarily intended as 'ready for public consumption'. It has 
not been adopted for official use by the developers as of yet, and is 
not maintained or kept up to date. (and appears to be quite incomplete 
as well)


-
If you read the official documentation, it describes an Account creation 
wizard that helps you get the basic accounts set up to get you started. 
If it did not run initially for some reason, you can proceed without it 
and individually create accounts, or try starting a new file to see if 
it will trigger the wizard. If it does not, report back here and we can 
help.



Regards,
Adrien

On 1/23/23 11:10 AM, Ann Bowes wrote:

Hi folks,

I'm trying to set up a simple manual checking account for a small farm 
business.  I've down-loaded the gnucash program to my laptop (linux 
zorin OS), and have tried to open new accounts, but am completely 
stumped as to how to do this.  I've read through the tutorial (at 
https://gnucash-docs-rst.readthedocs.io/en/latest/index.html), but I'm 
still stumped  Can anyone give me some pointers?


___
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] Questions about setting up new accounts from brand new user

[David Carlson]

Maf showed you how to start to create a single account.

If you want to create an entire chart of accounts click File > New and
select the option to create New Account Hierarchy Setup
You might want to try this more than once because it will then give you a
lot of choices for different applications and you may be a little
overwhelmed the first time around.

On Mon, Jan 23, 2023 at 11:29 AM Maf. King  wrote:

> On Monday, 23 January 2023 17:10:51 GMT Ann Bowes wrote:
> > Hi folks,
> >
> > I'm trying to set up a simple manual checking account for a small farm
> > business.  I've down-loaded the gnucash program to my laptop (linux
> > zorin OS), and have tried to open new accounts, but am completely
> > stumped as to how to do this.  I've read through the tutorial (at
> > https://gnucash-docs-rst.readthedocs.io/en/latest/index.html), but I'm
> > still stumped  Can anyone give me some pointers?
> >
>
> Hi Ann,
>
> you mean you need to create an account in your Gnucash books?
>
> see the attached image for a pointer...
>
> HTH,
> 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
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
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] Questions about setting up new accounts from brand new user

[Maf. King]

On Monday, 23 January 2023 17:10:51 GMT Ann Bowes wrote:
> Hi folks,
> 
> I'm trying to set up a simple manual checking account for a small farm
> business.  I've down-loaded the gnucash program to my laptop (linux
> zorin OS), and have tried to open new accounts, but am completely
> stumped as to how to do this.  I've read through the tutorial (at
> https://gnucash-docs-rst.readthedocs.io/en/latest/index.html), but I'm
> still stumped  Can anyone give me some pointers?
> 

Hi Ann,

you mean you need to create an account in your Gnucash books?

see the attached image for a pointer...

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

Re: [GNC] questions from a new user

[Jim DeLaHunt]

Hello, Neil, and welcome to GnuCash.

On 2023-01-08 16:14, Neil Morrish wrote:

Hi
I am not sure if gnucash is right for me, as it seems quite hard to get
started. Can you advise me what steps to learn about for my simple
requirement please?
I want to keep a record of business transactions so I can send invoices and
make an annual report for my tax calculation.
I do work for 4 or 5 customers and like to give an invoice that shows the
things I've done , the cost of the work, and the expenses I incur.
I dont want to link this to my bank account.
When it is set up, is it easy to input the entries quickly?


Your situation sounds familiar. It reminds me of my requirements for 
invoicing, when starting out my small consulting business.


What I get from your requirements are:

 * main task is to generate invoices
 * small volume of invoices
 * easy

That, plus "track my time spent by project", was my requirements list 
when I looked for an invoicing tool.  GnuCash can generate invoices, but 
it doesn't track time spent, and it is not "easy". GnuCash is really 
good for bookkeeping, keeping track of those bank accounts and credit 
cards. It does some business-related tasks like generating invoices. And 
it has a steep learning curve. And the customer support is this list — 
we are friendly, well-intentioned, but only volunteer, so not always 
fast or effective.


So I ended up paying hundreds of dollars CAD per year to Freshbooks 
, a web-hosted tool which puts a lot of effort 
into making invoice generation easy, making time-tracking easy, and 
having very good customer support.


So, GnuCash is good for a lot of situations. It can certainly meet all 
your requirements except "easy". But it may not be best for your 
requirements.


Best regards,
    —Jim DeLaHunt

___
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] questions from a new user

[David T. via gnucash-user]

Michael,

I took Neil's comment to mean that he didn't want to connect to his bank 
account online. 

Neil,

I'd like to point out that, despite the scope of your endeavor, you're in 
business, which will entail a certain amount of record keeping. Gnucash is 
directly designed for this sort of business, and will allow you to manage those 
finances in the ways you've described, but it *does* have a stiff learning 
curve, and you do have to learn a bit about accounting to use it. That being 
said, many non-accountants (myself among them) have been able to use GnuCash 
successfully to meet their needs. 

⁣David T. ​

On Jan 9, 2023, 4:42 AM, at 4:42 AM, Michael or Penny Novack 
 wrote:
>On 1/8/2023 7:14 PM, Neil Morrish wrote:
>> Hi
>> I am not sure if gnucash is right for me, as it seems quite hard to
>get
>> started. Can you advise me what steps to learn about for my simple
>> requirement please?
>> I want to keep a record of business transactions so I can send
>invoices and
>> make an annual report for my tax calculation.
>> I do work for 4 or 5 customers and like to give an invoice that shows
>the
>> things I've done , the cost of the work, and the expenses I incur.
>> I dont want to link this to my bank account.
>> When it is set up, is it easy to input the entries quickly?
>
>By "I don't want to "link" to my bank account do you perhaps mean that 
>you are NOT wanting this to be a full personal set of books? You want 
>this JUST for your small number of customers business.
>
>Yes, you CAN use gnucash for this purpose. In effect, you are setting
>up 
>a subset of what would be full books. It WOULD have a "bank account"
>for 
>when the invoices you sent customers are paid. But this "bank account" 
>would be a (virtual) subset of your actual bank account. So don;t 
>(later) ask us how you can use gnucash's reconciliation << will be 
>manual for you >>
>
>So you would set up using the business features option and just the 
>income and expense accounts associated with your business plus that 
>asset account "bank". You will be able to run a report for the year 
>showing profit (or loss) for tax purposes. The only complication I can 
>see is if you file your taxes "cash basis" because using the business 
>features requires accrual basis, but it IS possible to adjust for that 
>at year end << for tax filing, subtract what's still in "receivables" 
>form income and what's still in "payables" from expenses >>
>
>BUT -- if new to double entry bookkeeping do carefully read the
>tutorial 
>and if that's not enough to give you understanding, some standard 
>"Bookkeeping 101" text or on-line. Software like gnucash is partially 
>automating the process of keeping double entry books but you still have
>
>to understand what you are doing.
>
>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.
___
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] questions from a new user

[Michael or Penny Novack]

On 1/8/2023 7:14 PM, Neil Morrish wrote:

Hi
I am not sure if gnucash is right for me, as it seems quite hard to get
started. Can you advise me what steps to learn about for my simple
requirement please?
I want to keep a record of business transactions so I can send invoices and
make an annual report for my tax calculation.
I do work for 4 or 5 customers and like to give an invoice that shows the
things I've done , the cost of the work, and the expenses I incur.
I dont want to link this to my bank account.
When it is set up, is it easy to input the entries quickly?


By "I don't want to "link" to my bank account do you perhaps mean that 
you are NOT wanting this to be a full personal set of books? You want 
this JUST for your small number of customers business.


Yes, you CAN use gnucash for this purpose. In effect, you are setting up 
a subset of what would be full books. It WOULD have a "bank account" for 
when the invoices you sent customers are paid. But this "bank account" 
would be a (virtual) subset of your actual bank account. So don;t 
(later) ask us how you can use gnucash's reconciliation << will be 
manual for you >>


So you would set up using the business features option and just the 
income and expense accounts associated with your business plus that 
asset account "bank". You will be able to run a report for the year 
showing profit (or loss) for tax purposes. The only complication I can 
see is if you file your taxes "cash basis" because using the business 
features requires accrual basis, but it IS possible to adjust for that 
at year end << for tax filing, subtract what's still in "receivables" 
form income and what's still in "payables" from expenses >>


BUT -- if new to double entry bookkeeping do carefully read the tutorial 
and if that's not enough to give you understanding, some standard 
"Bookkeeping 101" text or on-line. Software like gnucash is partially 
automating the process of keeping double entry books but you still have 
to understand what you are doing.


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.

Re: [GNC] questions.

[Phyllis Bruce]

Ornithology, sounds like you are starting fresh.  If you’ve used Gnucash for 
years you probably forgot you have to create or choose a chart of accounts as a 
starting point.  The help files are great for guiding you through the process.

> On Dec 11, 2022, at 10:34 AM, Derek Atkins  wrote:
> 
> Did you copy your data file?
> Did you File -> Open your data file?
> 
> -derek
> Sent using my mobile device. Please excuse any typos.
>> On December 11, 2022 11:26:21 Orith  wrote:
>> 
>> 1. I got a New computer - Lenovo. no gnu-cash from previous computers, i
>> cleaned it out to make sure the viruses did not come to the new laptop.
>> Thus, I need to download the new version 4/11. When it is opened, no list
>> of accounts are available, I need them. tried to delete and restore and
>> tried again, still no accounts.
>> 
>> 2.  I have used Gnu for over 10 years. always happy. This time, when I
>> tried to make my own accounts and save them, they were on the desktop. I
>> tried to change the settings, and it gave me a new window,  I'm just
>> getting confused.
>> 
>> thanks for your help in advance
>> orith c.
>> ___
>> 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] questions.

[Derek Atkins]

Did you copy your data file?
Did you File -> Open your data file?

-derek
Sent using my mobile device. Please excuse any typos.
On December 11, 2022 11:26:21 Orith  wrote:


1. I got a New computer - Lenovo. no gnu-cash from previous computers, i
cleaned it out to make sure the viruses did not come to the new laptop.
Thus, I need to download the new version 4/11. When it is opened, no list
of accounts are available, I need them. tried to delete and restore and
tried again, still no accounts.

2.  I have used Gnu for over 10 years. always happy. This time, when I
tried to make my own accounts and save them, they were on the desktop. I
tried to change the settings, and it gave me a new window,  I'm just
getting confused.

thanks for your help in advance
orith c.
___
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] Questions on invoicing and invoice format

[Charles Vincent]

Adrien,
Thank you VERY much for your replies. I will definitely be less frustrated
not being able to figure something out which cannot be done (at this stage).
Good suggestion for q. no. 1.
Again, thanks.


Charles VINCENT
Membre fondateur et ancien président du Conseil d'Administration

Ecole Française de Battambang

+33 6 7082 0475 (Mobile & WhattsApp)
+855 12 635612 (Telegram)

www.ecolefrancaisedebattambang.org

On Wed, Jun 22, 2022, 20:34 Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> On 6/22/22 4:40 AM, Charles Vincent wrote:
> > 1. Is it possible to delete invoices?  As I was setting up invoices, I
> made
> > some mistakes so I now have invoice 1, invoice 2 and invoice 3 with
> > different print options for the same student but I cannot seem to find a
> > way to delete unnecessary invoices. Any option for that?
>
> No, you can't delete them.
>
> But you can re-assign them to someone else.
>
> When this happens, I usually edit the invoice# to be something like 'Use
> Next' and before starting an invoice, I'll do a Find for the 'Use Next'
> invoice#, then edit from there.
>
> > 2. How do I save a Fancy invoice configuration which will apply to all
> > clients?  Right now, the only way I have been able to do it is to save
> the
> > fancy configuration for client 1 but when I use the same configuration
> for
> > client 2, it comes out with the name of client 1 instead of client 2.
> > What I am asking is the process to save a Print Invoice configuration
> (or a
> > Report /Saved Report configurations) which can be used for many clients
> > without having to format each individual client.
>
> As far as I know, there is no way to specify a different default
> configuration. It would be a very useful enhancement. Unless you really
> need to, I'd avoid putting client info in the configuration. Keep it as
> general as possible.
>
>
> > 3.  What is the process to ensure that When I open and insert amounts in
> a
> > new invoice, what is the process to ensure that it automatically goes to
> > the right print invoice fancy format?  I cannot figure it out.
>
> It doesn't work automatically. You have to choose the stylesheet each
> time if you want to use one other than the default. (note, you *can*
> edit and save changes to the default) There is no way to change *which*
> stylesheet is the default. This too would be quite useful.
>
>
> Regards,
> Adrien
>
> ___
> 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] Questions on invoicing and invoice format

[Adrien Monteleone]

On 6/22/22 4:40 AM, Charles Vincent wrote:

1. Is it possible to delete invoices?  As I was setting up invoices, I made
some mistakes so I now have invoice 1, invoice 2 and invoice 3 with
different print options for the same student but I cannot seem to find a
way to delete unnecessary invoices. Any option for that?


No, you can't delete them.

But you can re-assign them to someone else.

When this happens, I usually edit the invoice# to be something like 'Use 
Next' and before starting an invoice, I'll do a Find for the 'Use Next' 
invoice#, then edit from there.



2. How do I save a Fancy invoice configuration which will apply to all
clients?  Right now, the only way I have been able to do it is to save the
fancy configuration for client 1 but when I use the same configuration for
client 2, it comes out with the name of client 1 instead of client 2.
What I am asking is the process to save a Print Invoice configuration (or a
Report /Saved Report configurations) which can be used for many clients
without having to format each individual client.


As far as I know, there is no way to specify a different default 
configuration. It would be a very useful enhancement. Unless you really 
need to, I'd avoid putting client info in the configuration. Keep it as 
general as possible.




3.  What is the process to ensure that When I open and insert amounts in a
new invoice, what is the process to ensure that it automatically goes to
the right print invoice fancy format?  I cannot figure it out.


It doesn't work automatically. You have to choose the stylesheet each 
time if you want to use one other than the default. (note, you *can* 
edit and save changes to the default) There is no way to change *which* 
stylesheet is the default. This too would be quite useful.



Regards,
Adrien

___
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] questions on 4.1

[Geoff]

> In 3.11 it was changed so that other splits are NOT modified so that 
the status of each split can be individually maintained in the reconcile 
window.


Which is for me a really useful feature!

Geoff
=

On 13/06/2022 12:24 pm, Chris Good wrote:

Hi David,

  


In 3.9, it was changed so that changing 1 split for the bank account (or it’s 
subaccounts) changed all splits for the bank account (and it’s subaccounts) to 
the new status, rather than toggling the status of the other splits. Toggling 
means: c to n and n to c.

In 3.11 it was changed so that other splits are NOT modified so that the status 
of each split can be individually maintained in the reconcile window.

  


Regards,

Chris Good

  


From: David Carlson 
Sent: Monday, 13 June 2022 11:59 AM
To: Chris Good 
Cc: Gnucash Users ; Top Cat 
Subject: Re: [GNC] questions on 4.1

  


Chris,

  


Thank you for your input.  However, your reference to a bug that was created in 
release 3.9 and reverted in 3.11 may not be identical to the behavior that Top 
Cat saw in release 3.7 which seems to be different in release 4.1.

  


Is it possible that the reversion in 3.11 did not exactly return to the 
behavior of releases prior to release 3.9?  If so, which is correct or at least 
preferable?

  


On Sun, Jun 12, 2022, 8:21 PM Chris Good mailto:goodchri...@gmail.com> > wrote:

From: gnucash-user mailto:gmail@gnucash.org>
<mailto:gmail@gnucash.org <mailto:gmail@gnucash.org> >
<mailto:gnucash-user-bounces+gylemc <mailto:gnucash-user-bounces%2Bgylemc>  
<mailto:gnucash-user-bounces%2Bgylemc <mailto:gnucash-user-bounces%252Bgylemc> >
=gmail@gnucash.org <mailto:gmail@gnucash.org>  <mailto:gmail@gnucash.org 
<mailto:gmail@gnucash.org> > > > on
behalf of Top Cat mailto:t...@fractalcat.io>  
<mailto:t...@fractalcat.io <mailto:t...@fractalcat.io> >
<mailto:t...@fractalcat.io <mailto:t...@fractalcat.io>  <mailto:t...@fractalcat.io 
<mailto:t...@fractalcat.io> > > >
Sent: Saturday, June 11, 2022 12:44 PM
To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>  
<mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> >
<mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>  
<mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > >
mailto:gnucash-user@gnucash.org>  
<mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> >
<mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>  
<mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > >
Subject: [GNC] questions on 4.1

I have been using gnucash since 2.x with a MySQL database


I recently build a new machine and updated to 4.1, and have run into several
issues

1.  On the accounts page, I can no longer show the account numbers, or
sort by them
2.  On reconciliations, paired transactions (like transfers from one
subaccount to another) no longer clear "both sides" when one is checked - it
requires manually marking both sides separately.


Is this correct behavior? Are there settings I am missing? do I need to
reinstall/save and restore data?

Any help would be appreciated

___

Hi Top Cat,

Re 2.:
This behaviour changed in 3.9. and again in 3.11 as detailed in  Bug 797648
https://bugs.gnucash.org/show_bug.cgi?id=797648.

BTW,  The changes in each release are listed at
https://www.gnucash.org/news.phtml.

Regards,
Chris Good

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto: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] questions on 4.1

[Chris Good]

Hi David,

 

In 3.9, it was changed so that changing 1 split for the bank account (or it’s 
subaccounts) changed all splits for the bank account (and it’s subaccounts) to 
the new status, rather than toggling the status of the other splits. Toggling 
means: c to n and n to c.

In 3.11 it was changed so that other splits are NOT modified so that the status 
of each split can be individually maintained in the reconcile window.

 

Regards,

Chris Good

 

From: David Carlson  
Sent: Monday, 13 June 2022 11:59 AM
To: Chris Good 
Cc: Gnucash Users ; Top Cat 
Subject: Re: [GNC] questions on 4.1

 

Chris,

 

Thank you for your input.  However, your reference to a bug that was created in 
release 3.9 and reverted in 3.11 may not be identical to the behavior that Top 
Cat saw in release 3.7 which seems to be different in release 4.1.

 

Is it possible that the reversion in 3.11 did not exactly return to the 
behavior of releases prior to release 3.9?  If so, which is correct or at least 
preferable?

 

On Sun, Jun 12, 2022, 8:21 PM Chris Good mailto:goodchri...@gmail.com> > wrote:

From: gnucash-user mailto:gmail@gnucash.org> 
<mailto:gmail@gnucash.org <mailto:gmail@gnucash.org> > 
<mailto:gnucash-user-bounces+gylemc <mailto:gnucash-user-bounces%2Bgylemc>  
<mailto:gnucash-user-bounces%2Bgylemc <mailto:gnucash-user-bounces%252Bgylemc> >
=gmail@gnucash.org <mailto:gmail@gnucash.org>  
<mailto:gmail@gnucash.org <mailto:gmail@gnucash.org> > > > on
behalf of Top Cat mailto:t...@fractalcat.io>  
<mailto:t...@fractalcat.io <mailto:t...@fractalcat.io> >
<mailto:t...@fractalcat.io <mailto:t...@fractalcat.io>  
<mailto:t...@fractalcat.io <mailto:t...@fractalcat.io> > > >
Sent: Saturday, June 11, 2022 12:44 PM
To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>  
<mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> >
<mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>  
<mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > >
mailto:gnucash-user@gnucash.org>  
<mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> >
<mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>  
<mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > >
Subject: [GNC] questions on 4.1

I have been using gnucash since 2.x with a MySQL database


I recently build a new machine and updated to 4.1, and have run into several
issues

1.  On the accounts page, I can no longer show the account numbers, or
sort by them
2.  On reconciliations, paired transactions (like transfers from one
subaccount to another) no longer clear "both sides" when one is checked - it
requires manually marking both sides separately.


Is this correct behavior? Are there settings I am missing? do I need to
reinstall/save and restore data?

Any help would be appreciated

___

Hi Top Cat,

Re 2.:
This behaviour changed in 3.9. and again in 3.11 as detailed in  Bug 797648
https://bugs.gnucash.org/show_bug.cgi?id=797648.

BTW,  The changes in each release are listed at 
https://www.gnucash.org/news.phtml.

Regards,
Chris Good

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto: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] questions on 4.1

[David Carlson]

Chris,

Thank you for your input.  However, your reference to a bug that was
created in release 3.9 and reverted in 3.11 may not be identical to the
behavior that Top Cat saw in release 3.7 which seems to be different in
release 4.1.

Is it possible that the reversion in 3.11 did not exactly return to the
behavior of releases prior to release 3.9?  If so, which is correct or at
least preferable?

On Sun, Jun 12, 2022, 8:21 PM Chris Good  wrote:

> From: gnucash-user  
> 
> =gmail@gnucash.org  > > on
> behalf of Top Cat mailto:t...@fractalcat.io>
>  > >
> Sent: Saturday, June 11, 2022 12:44 PM
> To: gnucash-user@gnucash.org 
>  >
> mailto:gnucash-user@gnucash.org>
>  > >
> Subject: [GNC] questions on 4.1
>
> I have been using gnucash since 2.x with a MySQL database
>
>
> I recently build a new machine and updated to 4.1, and have run into
> several
> issues
>
> 1.  On the accounts page, I can no longer show the account numbers, or
> sort by them
> 2.  On reconciliations, paired transactions (like transfers from one
> subaccount to another) no longer clear "both sides" when one is checked -
> it
> requires manually marking both sides separately.
>
>
> Is this correct behavior? Are there settings I am missing? do I need to
> reinstall/save and restore data?
>
> Any help would be appreciated
>
> ___
>
> Hi Top Cat,
>
> Re 2.:
> This behaviour changed in 3.9. and again in 3.11 as detailed in  Bug 797648
> https://bugs.gnucash.org/show_bug.cgi?id=797648.
>
> BTW,  The changes in each release are listed at
> https://www.gnucash.org/news.phtml.
>
> Regards,
> Chris Good
>
> ___
> 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] questions on 4.1

[Chris Good]

From: gnucash-user mailto:gmail@gnucash.org> 

=gmail@gnucash.org  > > on
behalf of Top Cat mailto:t...@fractalcat.io>
 > >
Sent: Saturday, June 11, 2022 12:44 PM
To: gnucash-user@gnucash.org 
 >
mailto:gnucash-user@gnucash.org>
 > >
Subject: [GNC] questions on 4.1

I have been using gnucash since 2.x with a MySQL database


I recently build a new machine and updated to 4.1, and have run into several
issues

1.  On the accounts page, I can no longer show the account numbers, or
sort by them
2.  On reconciliations, paired transactions (like transfers from one
subaccount to another) no longer clear "both sides" when one is checked - it
requires manually marking both sides separately.


Is this correct behavior? Are there settings I am missing? do I need to
reinstall/save and restore data?

Any help would be appreciated

___

Hi Top Cat,

Re 2.:
This behaviour changed in 3.9. and again in 3.11 as detailed in  Bug 797648
https://bugs.gnucash.org/show_bug.cgi?id=797648.

BTW,  The changes in each release are listed at 
https://www.gnucash.org/news.phtml.

Regards,
Chris Good

___
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] questions on 4.1

[Top Cat]

As my children often say – zok

 

I really was not offended by the tone at all, nor was I trying to force a 
fallback. I was just baffled by the change, and couldn’t determine if I had 
missed a setting, or if it was change in behavior

 

I appreciate everything the gnucash team does – both product and support – and 
LOVE the product

 

Thanks for all the hard work from all of y’all

 

From: David Carlson  
Sent: Sunday, June 12, 2022 4:12 PM
To: Top Cat 
Cc: Gyle McCollam ; Gnucash Users 
Subject: Re: [GNC] questions on 4.1

 

TopCat,

Sorry for my seemingly dismissive reply earlier.

 

In my Gmail I completely missed your detailed description about how 3.7 and 4.1 
actually work today on your machines until I finally found it by drilling down 
into thread history.  I do not like how Gmail does that, but I cannot solve 
that right now.

 

I personally do not have subaccounts under bank accounts that I reconcile by 
that method so I have not seen your issue, but it appears to be a bug in 
release 3.7 that has been fixed in release 4.1.  I doubt that the developers 
would entertain a request to revert to previous behavior, but you are free to 
ask. 

 

  

 

On Sun, Jun 12, 2022 at 12:54 PM David Carlson mailto:david.carlson@gmail.com> > wrote:

Oh, and Gyle very clearly explained why it it works the way it does.

 

On Sun, Jun 12, 2022, 12:48 PM David Carlson mailto:david.carlson@gmail.com> > wrote:

What did it did?  I have never seen GnuCash reconciliation  mark any 
transaction split account other than the account being reconciled since I 
started using GnuCash 2.something less than 4 many years ago.

 

On Sun, Jun 12, 2022, 10:18 AM Top Cat mailto:t...@fractalcat.io> > wrote:

I understand your thoughts, and don't disagree; the question was more that
it DID do this until I upgraded to 4.x



I'm not sure if something changed in gnucash4, or if I inadvertently broke
something in the migration and upgrade



From: Gyle McCollam mailto:gmccol...@live.com> > 
Sent: Sunday, June 12, 2022 10:38 AM
To: Top Cat mailto:t...@fractalcat.io> >; 
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
Subject: Re: [GNC] questions on 4.1



I only initially responded to the 1st question you raised.  However, as for
the 2nd question, I feel, that the software is operating correctly.  When
you are reconciling an account, say Bank A, you are reconciling only that
account, not the accounts that the other side of the transactions are posted
to.  When you reconcile those accounts, you would reconcile that half (or
less depending on how many splits there are).  Say the other half of the
split was Bank B, You wouldn't want to reconcile that transaction when you
do Bank A because when you get Bank B's statement, they may not have
credited your account (not likely, but) and it would make it harder to
determine where the error is at.



Thank You,   
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

 <mailto:gmccol...@gyleshomes.com <mailto:gmccol...@gyleshomes.com> > 
gmccol...@live.com <mailto:gmccol...@live.com>email

  _  

From: gnucash-user mailto:gmail@gnucash.org> 
<mailto:gnucash-user-bounces+gylemc <mailto:gnucash-user-bounces%2Bgylemc> 
=gmail@gnucash.org <mailto:gmail@gnucash.org> > > on behalf of
Gyle McCollam mailto:gmccol...@live.com>  
<mailto:gmccol...@live.com <mailto:gmccol...@live.com> > >
Sent: Sunday, June 12, 2022 10:20 AM
To: ja...@comcast.net <mailto:ja...@comcast.net>  <mailto:ja...@comcast.net 
<mailto:ja...@comcast.net> >  mailto:ja...@comcast.net> 
<mailto:ja...@comcast.net <mailto:ja...@comcast.net> > >; 
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
<mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> >  
mailto:gnucash-user@gnucash.org> 
<mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > >
Subject: Re: [GNC] questions on 4.1 



Jay,
Happy you found this helpful.  I respond to questions because others have
responded to me or I have found their responses to other helpful, as you did
this response.  I don't know enough programing, just enough to be dangerous,
so I help where I can.  I have picked up several tip/tricks along the way
and I am grateful to those who take the time to respond to questions.  I
picked this up from a previous question/answer session and feel it is part
of my obligation to pass it on when I can.  Several names keep appearing in
response to questions.  Do you hear me: Adrein, David T, Michael, and
others.  Thanks to you and everyone that takes the time!


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com <mailto:gmccol...@live.com> 
<mailto:gmccol...@gyleshomes.com>   email


From: j

Re: [GNC] questions on 4.1

[David Carlson]

TopCat,
Sorry for my seemingly dismissive reply earlier.

In my Gmail I completely missed your detailed description about how 3.7 and
4.1 actually work today on your machines until I finally found it by
drilling down into thread history.  I do not like how Gmail does that, but
I cannot solve that right now.

I personally do not have subaccounts under bank accounts that I reconcile
by that method so I have not seen your issue, but it appears to be a bug in
release 3.7 that has been fixed in release 4.1.  I doubt that the
developers would entertain a request to revert to previous behavior, but
you are free to ask.



On Sun, Jun 12, 2022 at 12:54 PM David Carlson 
wrote:

> Oh, and Gyle very clearly explained why it it works the way it does.
>
> On Sun, Jun 12, 2022, 12:48 PM David Carlson 
> wrote:
>
>> What did it did?  I have never seen GnuCash reconciliation  mark any
>> transaction split account other than the account being reconciled since I
>> started using GnuCash 2.something less than 4 many years ago.
>>
>> On Sun, Jun 12, 2022, 10:18 AM Top Cat  wrote:
>>
>>> I understand your thoughts, and don't disagree; the question was more
>>> that
>>> it DID do this until I upgraded to 4.x
>>>
>>>
>>>
>>> I'm not sure if something changed in gnucash4, or if I inadvertently
>>> broke
>>> something in the migration and upgrade
>>>
>>>
>>>
>>> From: Gyle McCollam 
>>> Sent: Sunday, June 12, 2022 10:38 AM
>>> To: Top Cat ; gnucash-user@gnucash.org
>>> Subject: Re: [GNC] questions on 4.1
>>>
>>>
>>>
>>> I only initially responded to the 1st question you raised.  However, as
>>> for
>>> the 2nd question, I feel, that the software is operating correctly.  When
>>> you are reconciling an account, say Bank A, you are reconciling only that
>>> account, not the accounts that the other side of the transactions are
>>> posted
>>> to.  When you reconcile those accounts, you would reconcile that half (or
>>> less depending on how many splits there are).  Say the other half of the
>>> split was Bank B, You wouldn't want to reconcile that transaction when
>>> you
>>> do Bank A because when you get Bank B's statement, they may not have
>>> credited your account (not likely, but) and it would make it harder to
>>> determine where the error is at.
>>>
>>>
>>>
>>> Thank You,
>>> Gyle McCollam
>>>
>>> Gyle McCollam
>>>
>>> 609.680.2326 Mobile
>>>
>>>  <mailto:gmccol...@gyleshomes.com> gmccol...@live.com   email
>>>
>>>   _
>>>
>>> From: gnucash-user >> <mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on behalf
>>> of
>>> Gyle McCollam mailto:gmccol...@live.com> >
>>> Sent: Sunday, June 12, 2022 10:20 AM
>>> To: ja...@comcast.net <mailto:ja...@comcast.net>  >> <mailto:ja...@comcast.net> >; gnucash-user@gnucash.org
>>> <mailto:gnucash-user@gnucash.org>  >> <mailto:gnucash-user@gnucash.org> >
>>> Subject: Re: [GNC] questions on 4.1
>>>
>>>
>>>
>>> Jay,
>>> Happy you found this helpful.  I respond to questions because others have
>>> responded to me or I have found their responses to other helpful, as you
>>> did
>>> this response.  I don't know enough programing, just enough to be
>>> dangerous,
>>> so I help where I can.  I have picked up several tip/tricks along the way
>>> and I am grateful to those who take the time to respond to questions.  I
>>> picked this up from a previous question/answer session and feel it is
>>> part
>>> of my obligation to pass it on when I can.  Several names keep appearing
>>> in
>>> response to questions.  Do you hear me: Adrein, David T, Michael, and
>>> others.  Thanks to you and everyone that takes the time!
>>>
>>>
>>> Thank You,
>>> Gyle McCollam
>>>
>>> Gyle McCollam
>>>
>>> 609.680.2326 Mobile
>>>
>>> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
>>>
>>> 
>>> From: ja...@comcast.net <mailto:ja...@comcast.net>  >> <mailto:ja...@comcast.net> >
>>> Sent: Sunday, June 12, 2022 7:57 AM
>>> To: 'Gyle McCollam' mailto:gmccol...@live.com> >

Re: [GNC] questions on 4.1

[David Carlson]

Oh, and Gyle very clearly explained why it it works the way it does.

On Sun, Jun 12, 2022, 12:48 PM David Carlson 
wrote:

> What did it did?  I have never seen GnuCash reconciliation  mark any
> transaction split account other than the account being reconciled since I
> started using GnuCash 2.something less than 4 many years ago.
>
> On Sun, Jun 12, 2022, 10:18 AM Top Cat  wrote:
>
>> I understand your thoughts, and don't disagree; the question was more that
>> it DID do this until I upgraded to 4.x
>>
>>
>>
>> I'm not sure if something changed in gnucash4, or if I inadvertently broke
>> something in the migration and upgrade
>>
>>
>>
>> From: Gyle McCollam 
>> Sent: Sunday, June 12, 2022 10:38 AM
>> To: Top Cat ; gnucash-user@gnucash.org
>> Subject: Re: [GNC] questions on 4.1
>>
>>
>>
>> I only initially responded to the 1st question you raised.  However, as
>> for
>> the 2nd question, I feel, that the software is operating correctly.  When
>> you are reconciling an account, say Bank A, you are reconciling only that
>> account, not the accounts that the other side of the transactions are
>> posted
>> to.  When you reconcile those accounts, you would reconcile that half (or
>> less depending on how many splits there are).  Say the other half of the
>> split was Bank B, You wouldn't want to reconcile that transaction when you
>> do Bank A because when you get Bank B's statement, they may not have
>> credited your account (not likely, but) and it would make it harder to
>> determine where the error is at.
>>
>>
>>
>> Thank You,
>> Gyle McCollam
>>
>> Gyle McCollam
>>
>> 609.680.2326 Mobile
>>
>>  <mailto:gmccol...@gyleshomes.com> gmccol...@live.com   email
>>
>>   _
>>
>> From: gnucash-user > <mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on behalf of
>> Gyle McCollam mailto:gmccol...@live.com> >
>> Sent: Sunday, June 12, 2022 10:20 AM
>> To: ja...@comcast.net <mailto:ja...@comcast.net>  > <mailto:ja...@comcast.net> >; gnucash-user@gnucash.org
>> <mailto:gnucash-user@gnucash.org>  > <mailto:gnucash-user@gnucash.org> >
>> Subject: Re: [GNC] questions on 4.1
>>
>>
>>
>> Jay,
>> Happy you found this helpful.  I respond to questions because others have
>> responded to me or I have found their responses to other helpful, as you
>> did
>> this response.  I don't know enough programing, just enough to be
>> dangerous,
>> so I help where I can.  I have picked up several tip/tricks along the way
>> and I am grateful to those who take the time to respond to questions.  I
>> picked this up from a previous question/answer session and feel it is part
>> of my obligation to pass it on when I can.  Several names keep appearing
>> in
>> response to questions.  Do you hear me: Adrein, David T, Michael, and
>> others.  Thanks to you and everyone that takes the time!
>>
>>
>> Thank You,
>> Gyle McCollam
>>
>> Gyle McCollam
>>
>> 609.680.2326 Mobile
>>
>> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
>>
>> 
>> From: ja...@comcast.net <mailto:ja...@comcast.net>  > <mailto:ja...@comcast.net> >
>> Sent: Sunday, June 12, 2022 7:57 AM
>> To: 'Gyle McCollam' mailto:gmccol...@live.com> >
>> Subject: RE: [GNC] questions on 4.1
>>
>> Gyle, Thank you. I had overlooked that arrow and feature.
>>
>> -Original Message-
>> From: gnucash-user > <mailto:gnucash-user-bounces+jaypj=comcast@gnucash.org> > On
>> Behalf Of Gyle McCollam
>> Sent: Saturday, June 11, 2022 3:42 PM
>> To: Top Cat mailto:t...@fractalcat.io> >;
>> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
>> Subject: Re: [GNC] questions on 4.1
>>
>> I'm sure your aware, but just in case.  Did you know there is a down arrow
>> at the far right of the account heading screen.  This allows you to add or
>> remove columns from the accounts page.  Maybe, the account code box is not
>> checked (3rd one down).
>>
>>
>> Thank You,
>> Gyle McCollam
>>
>> Gyle McCollam
>>
>> 609.680.2326 Mobile
>>
>> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
>>
>> 
>> From: gnucash-user > <mailto

Re: [GNC] questions on 4.1

[David Carlson]

What did it did?  I have never seen GnuCash reconciliation  mark any
transaction split account other than the account being reconciled since I
started using GnuCash 2.something less than 4 many years ago.

On Sun, Jun 12, 2022, 10:18 AM Top Cat  wrote:

> I understand your thoughts, and don't disagree; the question was more that
> it DID do this until I upgraded to 4.x
>
>
>
> I'm not sure if something changed in gnucash4, or if I inadvertently broke
> something in the migration and upgrade
>
>
>
> From: Gyle McCollam 
> Sent: Sunday, June 12, 2022 10:38 AM
> To: Top Cat ; gnucash-user@gnucash.org
> Subject: Re: [GNC] questions on 4.1
>
>
>
> I only initially responded to the 1st question you raised.  However, as for
> the 2nd question, I feel, that the software is operating correctly.  When
> you are reconciling an account, say Bank A, you are reconciling only that
> account, not the accounts that the other side of the transactions are
> posted
> to.  When you reconcile those accounts, you would reconcile that half (or
> less depending on how many splits there are).  Say the other half of the
> split was Bank B, You wouldn't want to reconcile that transaction when you
> do Bank A because when you get Bank B's statement, they may not have
> credited your account (not likely, but) and it would make it harder to
> determine where the error is at.
>
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
>  <mailto:gmccol...@gyleshomes.com> gmccol...@live.com   email
>
>   _
>
> From: gnucash-user  <mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on behalf of
> Gyle McCollam mailto:gmccol...@live.com> >
> Sent: Sunday, June 12, 2022 10:20 AM
> To: ja...@comcast.net <mailto:ja...@comcast.net>   <mailto:ja...@comcast.net> >; gnucash-user@gnucash.org
> <mailto:gnucash-user@gnucash.org>   <mailto:gnucash-user@gnucash.org> >
> Subject: Re: [GNC] questions on 4.1
>
>
>
> Jay,
> Happy you found this helpful.  I respond to questions because others have
> responded to me or I have found their responses to other helpful, as you
> did
> this response.  I don't know enough programing, just enough to be
> dangerous,
> so I help where I can.  I have picked up several tip/tricks along the way
> and I am grateful to those who take the time to respond to questions.  I
> picked this up from a previous question/answer session and feel it is part
> of my obligation to pass it on when I can.  Several names keep appearing in
> response to questions.  Do you hear me: Adrein, David T, Michael, and
> others.  Thanks to you and everyone that takes the time!
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
>
> 
> From: ja...@comcast.net <mailto:ja...@comcast.net>   <mailto:ja...@comcast.net> >
> Sent: Sunday, June 12, 2022 7:57 AM
> To: 'Gyle McCollam' mailto:gmccol...@live.com> >
> Subject: RE: [GNC] questions on 4.1
>
> Gyle, Thank you. I had overlooked that arrow and feature.
>
> -Original Message-
> From: gnucash-user  <mailto:gnucash-user-bounces+jaypj=comcast@gnucash.org> > On
> Behalf Of Gyle McCollam
> Sent: Saturday, June 11, 2022 3:42 PM
> To: Top Cat mailto:t...@fractalcat.io> >;
> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
> Subject: Re: [GNC] questions on 4.1
>
> I'm sure your aware, but just in case.  Did you know there is a down arrow
> at the far right of the account heading screen.  This allows you to add or
> remove columns from the accounts page.  Maybe, the account code box is not
> checked (3rd one down).
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
>
> 
> From: gnucash-user  <mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on
> behalf of Top Cat mailto:t...@fractalcat.io> >
> Sent: Saturday, June 11, 2022 12:44 PM
> To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
> mailto:gnucash-user@gnucash.org> >
> Subject: [GNC] questions on 4.1
>
> I have been using gnucash since 2.x with a MySQL database
>
>
>
> I recently build a new machine and updated to 4.1, and have run into
> several
> issues
>
> 1.  On the accounts page, I can no longer show the account numbers, or
> sort by them
> 2.  On 

Re: [GNC] questions on 4.1

[Top Cat]

I just tested against the same DB from three different machines -2 on 4.x
and 1 on 3.x

 

When I run it on Version: 3.7 Build ID: 3.7+(2019-09-07), it marks BOTH
transactions as reconciled

 

When I run it on Version: 4.10 Build ID: 4.10+(2022-03-26), it marks ONLY
the transaction that I mark, and I am required to reconcile both sides
separately

 

From: Top Cat  
Sent: Sunday, June 12, 2022 12:47 PM
To: 'gnucash-user@gnucash.org' 
Subject: RE: [GNC] questions on 4.1

 

To clarify the situation I am having issues with:

*   I have Account A
*   I have two Subaccounts under A - B & C
*   I transferred funds from B to C (Transaction 1)
*   I then reconciled A and "include subaccounts"
*   When I mark Transaction 1B as reconciled on the reconciliation
screen, it used to mark 1C as reconciled as well; under 4.x it does not

 

I assume this to be my fault, but I cannot find any setting that would cause
this, nor does my data migration, since if I create a new transaction
(either as just a transaction or as an "official" transfer) it still
requires clearing both sides

 

It's not killing me; I just don't understand why it used to work and does
not now

 

From: Top Cat mailto:t...@fractalcat.io> > 
Sent: Sunday, June 12, 2022 11:18 AM
To: 'Gyle McCollam' mailto:gmccol...@live.com> >; 'Top
Cat' mailto:t...@fractalcat.io> >;
'gnucash-user@gnucash.org' mailto:gnucash-user@gnucash.org> >
Subject: RE: [GNC] questions on 4.1

 

I understand your thoughts, and don't disagree; the question was more that
it DID do this until I upgraded to 4.x

 

I'm not sure if something changed in gnucash4, or if I inadvertently broke
something in the migration and upgrade

 

From: Gyle McCollam mailto:gmccol...@live.com> > 
Sent: Sunday, June 12, 2022 10:38 AM
To: Top Cat mailto:t...@fractalcat.io> >;
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
Subject: Re: [GNC] questions on 4.1

 

I only initially responded to the 1st question you raised.  However, as for
the 2nd question, I feel, that the software is operating correctly.  When
you are reconciling an account, say Bank A, you are reconciling only that
account, not the accounts that the other side of the transactions are posted
to.  When you reconcile those accounts, you would reconcile that half (or
less depending on how many splits there are).  Say the other half of the
split was Bank B, You wouldn't want to reconcile that transaction when you
do Bank A because when you get Bank B's statement, they may not have
credited your account (not likely, but) and it would make it harder to
determine where the error is at.

 

Thank You,   
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

 <mailto:gmccol...@gyleshomes.com> gmccol...@live.com   email

  _  

From: gnucash-user mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on behalf of
Gyle McCollam mailto:gmccol...@live.com> >
Sent: Sunday, June 12, 2022 10:20 AM
To: ja...@comcast.net <mailto:ja...@comcast.net>  mailto:ja...@comcast.net> >; gnucash-user@gnucash.org
<mailto:gnucash-user@gnucash.org>  mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] questions on 4.1 

 

Jay,
Happy you found this helpful.  I respond to questions because others have
responded to me or I have found their responses to other helpful, as you did
this response.  I don't know enough programing, just enough to be dangerous,
so I help where I can.  I have picked up several tip/tricks along the way
and I am grateful to those who take the time to respond to questions.  I
picked this up from a previous question/answer session and feel it is part
of my obligation to pass it on when I can.  Several names keep appearing in
response to questions.  Do you hear me: Adrein, David T, Michael, and
others.  Thanks to you and everyone that takes the time!


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email


From: ja...@comcast.net <mailto:ja...@comcast.net>  mailto:ja...@comcast.net> >
Sent: Sunday, June 12, 2022 7:57 AM
To: 'Gyle McCollam' mailto:gmccol...@live.com> >
Subject: RE: [GNC] questions on 4.1

Gyle, Thank you. I had overlooked that arrow and feature.

-Original Message-
From: gnucash-user mailto:gnucash-user-bounces+jaypj=comcast@gnucash.org> > On
Behalf Of Gyle McCollam
Sent: Saturday, June 11, 2022 3:42 PM
To: Top Cat mailto:t...@fractalcat.io> >;
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
Subject: Re: [GNC] questions on 4.1

I'm sure your aware, but just in case.  Did you know there is a down arrow
at the far right of the account heading screen.  This allows you to add or
remove columns from the accounts page.  Maybe, the account code box is not
checked 

Re: [GNC] questions on 4.1

[Top Cat]

To clarify the situation I am having issues with:

*   I have Account A
*   I have two Subaccounts under A - B & C
*   I transferred funds from B to C (Transaction 1)
*   I then reconciled A and "include subaccounts"
*   When I mark Transaction 1B as reconciled on the reconciliation
screen, it used to mark 1C as reconciled as well; under 4.x it does not

 

I assume this to be my fault, but I cannot find any setting that would cause
this, nor does my data migration, since if I create a new transaction
(either as just a transaction or as an "official" transfer) it still
requires clearing both sides

 

It's not killing me; I just don't understand why it used to work and does
not now

 

From: Top Cat  
Sent: Sunday, June 12, 2022 11:18 AM
To: 'Gyle McCollam' ; 'Top Cat' ;
'gnucash-user@gnucash.org' 
Subject: RE: [GNC] questions on 4.1

 

I understand your thoughts, and don't disagree; the question was more that
it DID do this until I upgraded to 4.x

 

I'm not sure if something changed in gnucash4, or if I inadvertently broke
something in the migration and upgrade

 

From: Gyle McCollam mailto:gmccol...@live.com> > 
Sent: Sunday, June 12, 2022 10:38 AM
To: Top Cat mailto:t...@fractalcat.io> >;
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
Subject: Re: [GNC] questions on 4.1

 

I only initially responded to the 1st question you raised.  However, as for
the 2nd question, I feel, that the software is operating correctly.  When
you are reconciling an account, say Bank A, you are reconciling only that
account, not the accounts that the other side of the transactions are posted
to.  When you reconcile those accounts, you would reconcile that half (or
less depending on how many splits there are).  Say the other half of the
split was Bank B, You wouldn't want to reconcile that transaction when you
do Bank A because when you get Bank B's statement, they may not have
credited your account (not likely, but) and it would make it harder to
determine where the error is at.

 

Thank You,   
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

 <mailto:gmccol...@gyleshomes.com> gmccol...@live.com   email

  _  

From: gnucash-user mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on behalf of
Gyle McCollam mailto:gmccol...@live.com> >
Sent: Sunday, June 12, 2022 10:20 AM
To: ja...@comcast.net <mailto:ja...@comcast.net>  mailto:ja...@comcast.net> >; gnucash-user@gnucash.org
<mailto:gnucash-user@gnucash.org>  mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] questions on 4.1 

 

Jay,
Happy you found this helpful.  I respond to questions because others have
responded to me or I have found their responses to other helpful, as you did
this response.  I don't know enough programing, just enough to be dangerous,
so I help where I can.  I have picked up several tip/tricks along the way
and I am grateful to those who take the time to respond to questions.  I
picked this up from a previous question/answer session and feel it is part
of my obligation to pass it on when I can.  Several names keep appearing in
response to questions.  Do you hear me: Adrein, David T, Michael, and
others.  Thanks to you and everyone that takes the time!


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email


From: ja...@comcast.net <mailto:ja...@comcast.net>  mailto:ja...@comcast.net> >
Sent: Sunday, June 12, 2022 7:57 AM
To: 'Gyle McCollam' mailto:gmccol...@live.com> >
Subject: RE: [GNC] questions on 4.1

Gyle, Thank you. I had overlooked that arrow and feature.

-Original Message-
From: gnucash-user mailto:gnucash-user-bounces+jaypj=comcast@gnucash.org> > On
Behalf Of Gyle McCollam
Sent: Saturday, June 11, 2022 3:42 PM
To: Top Cat mailto:t...@fractalcat.io> >;
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
Subject: Re: [GNC] questions on 4.1

I'm sure your aware, but just in case.  Did you know there is a down arrow
at the far right of the account heading screen.  This allows you to add or
remove columns from the accounts page.  Maybe, the account code box is not
checked (3rd one down).


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email


From: gnucash-user mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on
behalf of Top Cat mailto:t...@fractalcat.io> >
Sent: Saturday, June 11, 2022 12:44 PM
To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
mailto:gnucash-user@gnucash.org> >
Subject: [GNC] questions on 4.1

I have been using gnucash since 2.x with a MySQL database



I recently build a

Re: [GNC] questions on 4.1

[D via gnucash-user]

Thanks for the kind words, Gyle.

On the topic, it'd be nice if the Accounts menu bar could somehow keep the 
options button (the aforementioned triangle) on screen, instead of being off 
screen to the far right. Maybe the button should go on the left?

David T. 

On Jun 12, 2022, 10:21, at 10:21, Gyle McCollam  wrote:
>Jay,
>Happy you found this helpful.  I respond to questions because others
>have responded to me or I have found their responses to other helpful,
>as you did this response.  I don't know enough programing, just enough
>to be dangerous, so I help where I can.  I have picked up several
>tip/tricks along the way and I am grateful to those who take the time
>to respond to questions.  I picked this up from a previous
>question/answer session and feel it is part of my obligation to pass it
>on when I can.  Several names keep appearing in response to questions. 
>Do you hear me: Adrein, David T, Michael, and others.  Thanks to you
>and everyone that takes the time!
>
>
>Thank You,
>Gyle McCollam
>
>Gyle McCollam
>
>609.680.2326 Mobile
>
>gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
>
>
>From: ja...@comcast.net 
>Sent: Sunday, June 12, 2022 7:57 AM
>To: 'Gyle McCollam' 
>Subject: RE: [GNC] questions on 4.1
>
>Gyle, Thank you. I had overlooked that arrow and feature.
>
>-Original Message-
>From: gnucash-user 
>On
>Behalf Of Gyle McCollam
>Sent: Saturday, June 11, 2022 3:42 PM
>To: Top Cat ; gnucash-user@gnucash.org
>Subject: Re: [GNC] questions on 4.1
>
>I'm sure your aware, but just in case.  Did you know there is a down
>arrow
>at the far right of the account heading screen.  This allows you to add
>or
>remove columns from the accounts page.  Maybe, the account code box is
>not
>checked (3rd one down).
>
>
>Thank You,
>Gyle McCollam
>
>Gyle McCollam
>
>609.680.2326 Mobile
>
>gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
>
>
>From: gnucash-user 
>on
>behalf of Top Cat 
>Sent: Saturday, June 11, 2022 12:44 PM
>To: gnucash-user@gnucash.org 
>Subject: [GNC] questions on 4.1
>
>I have been using gnucash since 2.x with a MySQL database
>
>
>
>I recently build a new machine and updated to 4.1, and have run into
>several
>issues
>
>1.  On the accounts page, I can no longer show the account numbers,
>or
>sort by them
>2.  On reconciliations, paired transactions (like transfers from
>one
>subaccount to another) no longer clear "both sides" when one is checked
>- it
>requires manually marking both sides separately.
>
>
>
>Is this correct behavior? Are there settings I am missing? do I need to
>reinstall/save and restore data?
>
>
>
>Any help would be appreciated
>
>___
>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 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] questions on 4.1

[Adrien Monteleone]

What version were you previously using? I've never seen this behavior 
and I've been using GnuCash since the early 2.6 days.


Regards,
Adrien

On 6/12/22 10:17 AM, Top Cat wrote:

I understand your thoughts, and don't disagree; the question was more that
it DID do this until I upgraded to 4.x


___
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] questions on 4.1

[Top Cat]

I understand your thoughts, and don't disagree; the question was more that
it DID do this until I upgraded to 4.x

 

I'm not sure if something changed in gnucash4, or if I inadvertently broke
something in the migration and upgrade

 

From: Gyle McCollam  
Sent: Sunday, June 12, 2022 10:38 AM
To: Top Cat ; gnucash-user@gnucash.org
Subject: Re: [GNC] questions on 4.1

 

I only initially responded to the 1st question you raised.  However, as for
the 2nd question, I feel, that the software is operating correctly.  When
you are reconciling an account, say Bank A, you are reconciling only that
account, not the accounts that the other side of the transactions are posted
to.  When you reconcile those accounts, you would reconcile that half (or
less depending on how many splits there are).  Say the other half of the
split was Bank B, You wouldn't want to reconcile that transaction when you
do Bank A because when you get Bank B's statement, they may not have
credited your account (not likely, but) and it would make it harder to
determine where the error is at.

 

Thank You,   
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

 <mailto:gmccol...@gyleshomes.com> gmccol...@live.com   email

  _  

From: gnucash-user mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on behalf of
Gyle McCollam mailto:gmccol...@live.com> >
Sent: Sunday, June 12, 2022 10:20 AM
To: ja...@comcast.net <mailto:ja...@comcast.net>  mailto:ja...@comcast.net> >; gnucash-user@gnucash.org
<mailto:gnucash-user@gnucash.org>  mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] questions on 4.1 

 

Jay,
Happy you found this helpful.  I respond to questions because others have
responded to me or I have found their responses to other helpful, as you did
this response.  I don't know enough programing, just enough to be dangerous,
so I help where I can.  I have picked up several tip/tricks along the way
and I am grateful to those who take the time to respond to questions.  I
picked this up from a previous question/answer session and feel it is part
of my obligation to pass it on when I can.  Several names keep appearing in
response to questions.  Do you hear me: Adrein, David T, Michael, and
others.  Thanks to you and everyone that takes the time!


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email


From: ja...@comcast.net <mailto:ja...@comcast.net>  mailto:ja...@comcast.net> >
Sent: Sunday, June 12, 2022 7:57 AM
To: 'Gyle McCollam' mailto:gmccol...@live.com> >
Subject: RE: [GNC] questions on 4.1

Gyle, Thank you. I had overlooked that arrow and feature.

-Original Message-
From: gnucash-user mailto:gnucash-user-bounces+jaypj=comcast@gnucash.org> > On
Behalf Of Gyle McCollam
Sent: Saturday, June 11, 2022 3:42 PM
To: Top Cat mailto:t...@fractalcat.io> >;
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
Subject: Re: [GNC] questions on 4.1

I'm sure your aware, but just in case.  Did you know there is a down arrow
at the far right of the account heading screen.  This allows you to add or
remove columns from the accounts page.  Maybe, the account code box is not
checked (3rd one down).


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email


From: gnucash-user mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on
behalf of Top Cat mailto:t...@fractalcat.io> >
Sent: Saturday, June 11, 2022 12:44 PM
To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
mailto:gnucash-user@gnucash.org> >
Subject: [GNC] questions on 4.1

I have been using gnucash since 2.x with a MySQL database



I recently build a new machine and updated to 4.1, and have run into several
issues

1.  On the accounts page, I can no longer show the account numbers, or
sort by them
2.  On reconciliations, paired transactions (like transfers from one
subaccount to another) no longer clear "both sides" when one is checked - it
requires manually marking both sides separately.



Is this correct behavior? Are there settings I am missing? do I need to
reinstall/save and restore data?



Any help would be appreciated

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto: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] questions on 4.1

[David Carlson]

I have not seen an answer to the second question yet.  The reconciliation
process in GnuCash has never marked any part of a transaction as
"Reconciled" other than the part that is in the account which is being
reconciled.  That may not match what happened in other financial programs.

On Sun, Jun 12, 2022 at 9:21 AM Gyle McCollam  wrote:

> Jay,
> Happy you found this helpful.  I respond to questions because others have
> responded to me or I have found their responses to other helpful, as you
> did this response.  I don't know enough programing, just enough to be
> dangerous, so I help where I can.  I have picked up several tip/tricks
> along the way and I am grateful to those who take the time to respond to
> questions.  I picked this up from a previous question/answer session and
> feel it is part of my obligation to pass it on when I can.  Several names
> keep appearing in response to questions.  Do you hear me: Adrein, David T,
> Michael, and others.  Thanks to you and everyone that takes the time!
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
>
> 
> From: ja...@comcast.net 
> Sent: Sunday, June 12, 2022 7:57 AM
> To: 'Gyle McCollam' 
> Subject: RE: [GNC] questions on 4.1
>
> Gyle, Thank you. I had overlooked that arrow and feature.
>
> -Original Message-
> From: gnucash-user  On
> Behalf Of Gyle McCollam
> Sent: Saturday, June 11, 2022 3:42 PM
> To: Top Cat ; gnucash-user@gnucash.org
> Subject: Re: [GNC] questions on 4.1
>
> I'm sure your aware, but just in case.  Did you know there is a down arrow
> at the far right of the account heading screen.  This allows you to add or
> remove columns from the accounts page.  Maybe, the account code box is not
> checked (3rd one down).
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
>
> 
> From: gnucash-user  on
> behalf of Top Cat 
> Sent: Saturday, June 11, 2022 12:44 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] questions on 4.1
>
> I have been using gnucash since 2.x with a MySQL database
>
>
>
> I recently build a new machine and updated to 4.1, and have run into
> several
> issues
>
> 1.  On the accounts page, I can no longer show the account numbers, or
> sort by them
> 2.  On reconciliations, paired transactions (like transfers from one
> subaccount to another) no longer clear "both sides" when one is checked -
> it
> requires manually marking both sides separately.
>
>
>
> Is this correct behavior? Are there settings I am missing? do I need to
> reinstall/save and restore data?
>
>
>
> Any help would be appreciated
>
> ___
> 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.
>


-- 
David Carlson
___
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] questions on 4.1

[Gyle McCollam]

I only initially responded to the 1st question you raised.  However, as for the 
2nd question, I feel, that the software is operating correctly.  When you are 
reconciling an account, say Bank A, you are reconciling only that account, not 
the accounts that the other side of the transactions are posted to.  When you 
reconcile those accounts, you would reconcile that half (or less depending on 
how many splits there are).  Say the other half of the split was Bank B, You 
wouldn't want to reconcile that transaction when you do Bank A because when you 
get Bank B's statement, they may not have credited your account (not likely, 
but) and it would make it harder to determine where the error is at.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email


From: gnucash-user  on 
behalf of Gyle McCollam 
Sent: Sunday, June 12, 2022 10:20 AM
To: ja...@comcast.net ; gnucash-user@gnucash.org 

Subject: Re: [GNC] questions on 4.1

Jay,
Happy you found this helpful.  I respond to questions because others have 
responded to me or I have found their responses to other helpful, as you did 
this response.  I don't know enough programing, just enough to be dangerous, so 
I help where I can.  I have picked up several tip/tricks along the way and I am 
grateful to those who take the time to respond to questions.  I picked this up 
from a previous question/answer session and feel it is part of my obligation to 
pass it on when I can.  Several names keep appearing in response to questions.  
Do you hear me: Adrein, David T, Michael, and others.  Thanks to you and 
everyone that takes the time!


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email


From: ja...@comcast.net 
Sent: Sunday, June 12, 2022 7:57 AM
To: 'Gyle McCollam' 
Subject: RE: [GNC] questions on 4.1

Gyle, Thank you. I had overlooked that arrow and feature.

-Original Message-
From: gnucash-user  On
Behalf Of Gyle McCollam
Sent: Saturday, June 11, 2022 3:42 PM
To: Top Cat ; gnucash-user@gnucash.org
Subject: Re: [GNC] questions on 4.1

I'm sure your aware, but just in case.  Did you know there is a down arrow
at the far right of the account heading screen.  This allows you to add or
remove columns from the accounts page.  Maybe, the account code box is not
checked (3rd one down).


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email


From: gnucash-user  on
behalf of Top Cat 
Sent: Saturday, June 11, 2022 12:44 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] questions on 4.1

I have been using gnucash since 2.x with a MySQL database



I recently build a new machine and updated to 4.1, and have run into several
issues

1.  On the accounts page, I can no longer show the account numbers, or
sort by them
2.  On reconciliations, paired transactions (like transfers from one
subaccount to another) no longer clear "both sides" when one is checked - it
requires manually marking both sides separately.



Is this correct behavior? Are there settings I am missing? do I need to
reinstall/save and restore data?



Any help would be appreciated

___
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 preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If y

Re: [GNC] questions on 4.1

[Gyle McCollam]

Jay,
Happy you found this helpful.  I respond to questions because others have 
responded to me or I have found their responses to other helpful, as you did 
this response.  I don't know enough programing, just enough to be dangerous, so 
I help where I can.  I have picked up several tip/tricks along the way and I am 
grateful to those who take the time to respond to questions.  I picked this up 
from a previous question/answer session and feel it is part of my obligation to 
pass it on when I can.  Several names keep appearing in response to questions.  
Do you hear me: Adrein, David T, Michael, and others.  Thanks to you and 
everyone that takes the time!


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email


From: ja...@comcast.net 
Sent: Sunday, June 12, 2022 7:57 AM
To: 'Gyle McCollam' 
Subject: RE: [GNC] questions on 4.1

Gyle, Thank you. I had overlooked that arrow and feature.

-Original Message-
From: gnucash-user  On
Behalf Of Gyle McCollam
Sent: Saturday, June 11, 2022 3:42 PM
To: Top Cat ; gnucash-user@gnucash.org
Subject: Re: [GNC] questions on 4.1

I'm sure your aware, but just in case.  Did you know there is a down arrow
at the far right of the account heading screen.  This allows you to add or
remove columns from the accounts page.  Maybe, the account code box is not
checked (3rd one down).


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email


From: gnucash-user  on
behalf of Top Cat 
Sent: Saturday, June 11, 2022 12:44 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] questions on 4.1

I have been using gnucash since 2.x with a MySQL database



I recently build a new machine and updated to 4.1, and have run into several
issues

1.  On the accounts page, I can no longer show the account numbers, or
sort by them
2.  On reconciliations, paired transactions (like transfers from one
subaccount to another) no longer clear "both sides" when one is checked - it
requires manually marking both sides separately.



Is this correct behavior? Are there settings I am missing? do I need to
reinstall/save and restore data?



Any help would be appreciated

___
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] questions on 4.1

[Chuck Mauthe]

Thanks - and no - I had missed that. I do love gnucash, but the interface
often reminds of my old Swedish saab; nice, but . unique

 

From: Gyle McCollam  
Sent: Saturday, June 11, 2022 3:42 PM
To: Top Cat ; gnucash-user@gnucash.org
Subject: Re: [GNC] questions on 4.1

 

I'm sure your aware, but just in case.  Did you know there is a down arrow
at the far right of the account heading screen.  This allows you to add or
remove columns from the accounts page.  Maybe, the account code box is not
checked (3rd one down).

 

Thank You,   
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

 <mailto:gmccol...@gyleshomes.com> gmccol...@live.com   email

  _  

From: gnucash-user mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on behalf of
Top Cat mailto:t...@fractalcat.io> >
Sent: Saturday, June 11, 2022 12:44 PM
To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
mailto:gnucash-user@gnucash.org> >
Subject: [GNC] questions on 4.1 

 

I have been using gnucash since 2.x with a MySQL database

 

I recently build a new machine and updated to 4.1, and have run into several
issues

1.  On the accounts page, I can no longer show the account numbers, or
sort by them
2.  On reconciliations, paired transactions (like transfers from one
subaccount to another) no longer clear "both sides" when one is checked - it
requires manually marking both sides separately.

 

Is this correct behavior? Are there settings I am missing? do I need to
reinstall/save and restore data?

 

Any help would be appreciated

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto: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] questions on 4.1

[Gyle McCollam]

I'm sure your aware, but just in case.  Did you know there is a down arrow at 
the far right of the account heading screen.  This allows you to add or remove 
columns from the accounts page.  Maybe, the account code box is not checked 
(3rd one down).


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Top Cat 
Sent: Saturday, June 11, 2022 12:44 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] questions on 4.1

I have been using gnucash since 2.x with a MySQL database



I recently build a new machine and updated to 4.1, and have run into several
issues

1.  On the accounts page, I can no longer show the account numbers, or
sort by them
2.  On reconciliations, paired transactions (like transfers from one
subaccount to another) no longer clear "both sides" when one is checked - it
requires manually marking both sides separately.



Is this correct behavior? Are there settings I am missing? do I need to
reinstall/save and restore data?



Any help would be appreciated

___
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] Questions on how best to setup a non-profit account in gnucash

[Nelson Handcock]

Hi,

I use Gnucash to manage the accounts of a not-for-profit association based
in Australia.

At the end of the day, it's treated like any other business, but may be
exempt from certain taxes.

You'd first need to familiarise yourself with the requirements for a
not-for-profit association and comply with the rules that are applicable
for where your association is going to be set up. These rules will vary
from country to country and maybe even from state to state.

For the association I help manage, we are registered with the state
government body as a not-for-profit incorporated association. We can
therefore declare ourselves as exempt from paying tax on our net company
profit. We are 100% run by volunteers, so we don't have to pay salaries and
collect or pay tax on behalf of any employees. We pay rent, utilities,
operating expenses and insurances just the same as any other business.

In our case, we usually have a turn-over that exceeds a certain limit, so
we have to collect GST on sales, and we submit a quarterly Business
Activity Statement to declare how much GST we pay on purchases and expenses
and we either get a net refund or we pay the net shortfall. To calculate
GST on our activity we use the Gnucash Tax Tables and set up GST liability
accounts so it's not difficult to figure out the required information to
submit.

We use Gnucash to reconcile our bank accounts and generate financial
reports annually, and we submit to an annual audit performed by a certified
practising accountant. We receive a report which we have to submit annually
to the state government body we are registered with.

Hope this helps!



On Fri, Aug 9, 2019 at 11:36 AM Mike or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 8/8/2019 12:24 PM, Larry Wagner wrote:
> > I would like some comments about how one would set up gnucash for a
> > non-profit.
> >
> > Here are some of the specifics:
>
> What kind of non-profit are you? What do you have to file with what
> jurisdictions?
>
> << There are non-profits that do not pay taxes, but are not tax
> deductible organizations. The rules are different with what gets filed
> with whom >>
>
> Michael D Novack
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Questions on how best to setup a non-profit account in gnucash

[Mike or Penny Novack]

On 8/8/2019 12:24 PM, Larry Wagner wrote:
I would like some comments about how one would set up gnucash for a 
non-profit.


Here are some of the specifics:


What kind of non-profit are you? What do you have to file with what 
jurisdictions?


<< There are non-profits that do not pay taxes, but are not tax 
deductible organizations. The rules are different with what gets filed 
with whom >>


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] Questions on how best to setup a non-profit account in gnucash

[David Cousens]

Larry,

As Adrien noted we connot offer accounting advice per se. However we can
give you some guidance in setting up GnuCashand using its features.

Generally you will need to create an income sub account for each source of
income you wish to be able to track, in the example you gave, for each of
the dance categories.

Similarly you will need to have an expense category for each of those dance
categories and for each of those categories a further sub account for each
of the general expense categories. This will allow you to get basic reports
like a balance sheet and income statement which will list those categories.

The Customer and Vendor business features are used for those who provide you
with goods or services and those to whom you provide goods and services.
I.e. each of your callers, the suppliers of advertising  and the hall will
be your vendors. 

You may find the accounts payable useful if you do not operate on a cash
basis only, i.e. your suppliers extend credit to you and only require
payment at the end of the month for example, but it may be overkill for the
scale of your operations. 

The Jobs business feature could be used to track particular dances as you
thought but it also would possibly be overkill. AFAIK it is designed for the
business situation where you need to track all the expenses associated for
one specific project out of many  for a given customer.

The customers are of course those who come to the dances and pay you fees.
It is unlikely that you would need to track them individually from your
description.  GnuCash has various facilities for searching for specific
information in the description field of a transaction and these can be used
to produce transaction reports which list all transactions including certain
terms to a specific account for example.

The following is an outline of a possible basic CoA for the functonality you
have described. The colons indicate subaccounts. You would normally set up
the categories as placeholder accounts. These do not have transactions
directly into them, only to the subaccounts they group, but they will allow
you to get totals of those subaccounts.

The reports in GnuCash generally have their own setups and options and you
can customize them to meet your specific requirements providing you have a
good basic account structure.

Assets:Current Assets:Checking

Income:F:Door
Income:F:Tickets
Income: DF:Door
Income: DF:Tickets
Income:JBO:Door
Income:JBO:Tickets

Expenses:F:Venue
Expenses:F:Square caller
Expenses:F:Round caller
Expenses:F:Advertising
Expenses:F:Miscellaneous

You would then need similar expense accounts as described above for the F
category for each of the two other categories.

If you include a searchable unique label for each dance in the description
field, you would be able to produce reports for each dance by setting an
appropriate period for the report and filtering using those specific labels. 
This would require you to include the appropriate label in the descriptions
for all transactions associated with a particular event.

The introductory chapters of the GnuCash Tutorial and Concepts Guide
https://www.gnucash.org/docs/v3/C/gnucash-guide/index.html
should give you a basic understanding of the accounting concepts involved. 

Your jurisdiction will normally have its own rules and regulations about the
organizational and accounting requirements for clubs and associations and
other not for profits.   This may add additional requirements on  how you
perform the accounting in addition to what I have outlined above,
particularly any reporting and auditing requirements. If you have a
participant who is an accountant you may be able to seek their help. in some
cases accountants may help out pro bono, particularly if the operation is
charitable. 

The above is one possible treatment of the situation as you described it and
not necessarily the only way to do it or even a complete description of a
suitable CoA for your organization. The best way is of course the one which
provides you with the information you need for your club's internal use and
any external requirements. GnuCash is reasonably flexible and you can
probably refine and fine tune the account structure over time as you become
more familiar with GnuCash.

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] Questions on how best to setup a non-profit account in gnucash

[Adrien Monteleone]

I’ll also add the following advice:

1. Don’t fret about getting your accounts perfect the first time. You’ll find 
yourself moving things around and creating more detail with more accounts 
during your first 6-12 months of using GnuCash as you figure out how things 
work and you start having to run reports and make decisions based off the data 
you entered.

2. For this reason and others, put as much detail as possible into every 
transaction. Use the split memos for detail if the info doesn’t apply to the 
entire transaction but just one part of it. 2-3 years from now, you may want or 
need that info and it won’t be there. But if you put it now, you’ll have it. 
This will become very apparent when you want to divide an account (like 
Miscellaneous) and you’ll need detailed info to tell you exactly what that 
split/transaction was for in order to do so properly. An example that might 
seem overkill to some but that I have found invaluable is when entering store 
receipts, enter each line item as its own split, even if you can group them by 
expense account. If you have the individual items already separated, should you 
need/want to give them their own more specific expense account (or sub-account) 
later, you’ll be able to do so. The Auto-Fill feature will quickly reduce the 
typing workload. In line with this is also:

3. If your receipts have a separate line-item for sales tax, do not lump it 
into your expense account entry. (e.g., If you went to the Dollar Store to buy 
paper plates, don’t just enter the entire receipt as Expenses:Supplies) Give it 
its own expense account and its own split. While it is part of the transaction 
you can’t separate because you can’t *not* pay it, you will run yourself ragged 
when you have a receipt with multiple expense accounts and one tax line and you 
try to allocate the tax across them. You will find that is more work in the 
long run than simply entering the tax as its own expense category. (note, this 
might not apply to jurisdictions with VAT style taxation, that is its own 
animal, and probably already allocated and part of the line-item prices anyway.)

4. Some people may find this last point controversial, but I found I didn’t 
really grasp what GnuCash was doing, and thus how to structure my accounts and 
what info I needed to enter until I turned on Transaction Journal (in the 
Preferences or the View menu) and Double Line mode. This allows you to see all 
splits at all times and have the extra Note field for categories/tagging. I 
also found sanity once I turned on formal accounting labels because some of the 
informal labels didn’t quite make sense for every transaction I was entering. 
But debits and credits are consistent. (which you use might not be, but the 
labels are always left column=debit, right column=credit)

Regards,
Adrien

> On Aug 8, 2019, at 12:07 PM, Adrien Monteleone 
>  wrote:
> 
> Larry,
> 
> We can’t offer accounting advice here. You’d need to speak to a local CPA who 
> is familiar with your jurisdiction and optimally one familiar with 
> non-profits to help you set up your account tree.
> 
> Beyond that, we can help with how to accomplish the various things you want 
> with respect to GnuCash.
> 
> I’ll address other items in-line below.
> 
>> On Aug 8, 2019, at 11:24 AM, Larry Wagner  wrote:
>> 
>> I would like some comments about how one would set up gnucash for a 
>> non-profit.
>> 
>> Here are some of the specifics:
>> 
>> We hold 3 different types (categories) of dances:
>> 
>> 1) F dances - those sponsored by our club (~15 dances per year)
>> 2) DF dances - those we share sponsorship with another club (~5 dances per 
>> year)
>> 3) JBO dances - those sponsored jointly with yet another club (~2 dances per 
>> year)
> First, GnuCash does not have a categorization or tagging function. You are 
> limited to accounts. (but there are creative work arounds)
> 
>> 
>> General expenses for the dances are:
>> i) venue costs
>> ii) Square Dance caller costs
>> iii) Round Dance cuer costs
>> iv) advertisement costs
>> v) miscellaneous expenses (decorations, etc)
>> 
>> Dance income
>> i) Door donations
>> ii) 50/50 ticket proceeds
> 
> These would simply be setup as their respective expense and income accounts
> 
> So for this simple example you’d have something like:
> 
> Expenses
> Expenses:Venues
> Expenses:Callers
> Expenses:Cuers
> Expenses:Advertising
> Expenses:Miscellaneous
> 
> Note, I wouldn’t get carried away with using the Miscellaneous account as a 
> ‘dump bucket’ for ‘everything else’. You’re going to find you will want more 
> fine-grained reporting later on. Only use Miscellaneous for things that truly 
> are, or that are very small and rare one-off transactions.
> 
> You already know ‘decorations’ is something you’ll be spending money on and 
> may need to track. You’ll likely want it to be its own expense category.
> 
> For the Income accounts something like:
> 
> Income
> Income:Door Donations
> Income:Ticket 

Re: [GNC] Questions on how best to setup a non-profit account in gnucash

[Adrien Monteleone]

Larry,

We can’t offer accounting advice here. You’d need to speak to a local CPA who 
is familiar with your jurisdiction and optimally one familiar with non-profits 
to help you set up your account tree.

Beyond that, we can help with how to accomplish the various things you want 
with respect to GnuCash.

I’ll address other items in-line below.

> On Aug 8, 2019, at 11:24 AM, Larry Wagner  wrote:
> 
> I would like some comments about how one would set up gnucash for a 
> non-profit.
> 
> Here are some of the specifics:
> 
> We hold 3 different types (categories) of dances:
> 
> 1) F dances - those sponsored by our club (~15 dances per year)
> 2) DF dances - those we share sponsorship with another club (~5 dances per 
> year)
> 3) JBO dances - those sponsored jointly with yet another club (~2 dances per 
> year)
First, GnuCash does not have a categorization or tagging function. You are 
limited to accounts. (but there are creative work arounds)

> 
> General expenses for the dances are:
> i) venue costs
> ii) Square Dance caller costs
> iii) Round Dance cuer costs
> iv) advertisement costs
> v) miscellaneous expenses (decorations, etc)
> 
> Dance income
> i) Door donations
> ii) 50/50 ticket proceeds

These would simply be setup as their respective expense and income accounts

So for this simple example you’d have something like:

Expenses
Expenses:Venues
Expenses:Callers
Expenses:Cuers
Expenses:Advertising
Expenses:Miscellaneous

Note, I wouldn’t get carried away with using the Miscellaneous account as a 
‘dump bucket’ for ‘everything else’. You’re going to find you will want more 
fine-grained reporting later on. Only use Miscellaneous for things that truly 
are, or that are very small and rare one-off transactions.

You already know ‘decorations’ is something you’ll be spending money on and may 
need to track. You’ll likely want it to be its own expense category.

For the Income accounts something like:

Income
Income:Door Donations
Income:Ticket Proceeds
> 
> How should the accounts (and reports) be setup to provide the following:
> 
> a) breakout and total expenses for each of the 5 expense categories listed 
> above
> b) breakout and total income for each of the 2 income categories listed above

Not sure what you mean by ‘breakout’, but a standard Income Statement/P will 
show you the income & expenses in your book in one report. (you could also make 
separate reports if you like)

If you want a detailed transaction list, both the Transaction Report and 
Account Report might be useful here.

> c) a breakout of the income and expenses for each individual dance, 
> regardless of the dance category
> d) a breakout of the income and expenses for each dance category

Again, not sure of the reference to ‘breakout’ but the Transaction Report could 
possibly be used here. While there is no extra category level or tagging system 
in GnuCash, you can mimic this with some careful planning.

Pretty much any field in a transaction can be used as a filter for reports. 
Some likely fields to use for placing your dance category names and individual 
dance event names might be the Description, Note, or Memo depending on your 
needs. Description is usually used as ‘payee’ or ‘payor’ but can also be an 
occurrence or event, especially if the concept of payee/payor doesn’t quite fit 
with the particular transaction. The Memo field is a good place to put info 
about a specific split. The Note field is a good place to put info about the 
entire transaction. (you have to have Double Line Mode turned on to see the 
Note field)

There are also account tree schemes where some people create parent accounts 
for each category and then duplicate the needed accounts under each. Others 
will keep the main accounts as-is and then make sub-accounts under each 
representing each category. Both methods are going to be tedious and have 
limitations. If you can manage using field information and filters, I’d go that 
route.

Keep in mind, even with this workaround, you still might not get exactly what 
you want out of a GnuCash report. In that case, get it as close as you can, 
then export or copy/paste the report data to a spreadsheet and refine it there.

> e) a breakout of the income and expenses for all dance categories combined

That should be the same as the Income Statement/P
> 
> I don't have a background in accounting so some of the terms are not 
> familiar, but I think I can better communicate what I am thinking by 
> considering the following:
> 
> a) Jobs (tasks) - All individual dances, which need to fall under one of the 
> three dance categories listed above

Sorry, ‘Jobs’ in GnuCash are not like this. The feature is more like ‘Purchase 
Order’. So you can’t use it as a categorization tool.
> b) Vendors - All callers and cuers
Sure, as well as any other suppliers you pay expenses to. Note that not every 
place you spend money needs to be a vendor, just the ones that will send you 
bills. A trip to the local dollar 

Re: [GNC] Questions

[Christopher Lam]

I think I'll get the draft multicolumn report into v3.6 due approximately
end of June.
No guarantees it's bugfree (especially involving multiple
currencies/stocks) but at least it'll have increased exposure, and I'm sure
many users will find them useful.
Multi-date balance-sheets aim to report on realized-gains, unrealized-gains
& retained-earnings when valuing currencies/stocks to report-currency.
Multi-period profit-and-loss reports hopelessly does not even try to figure
out these amounts when converting to report-currency across periods.
But for single-currency books, or unconverted currencies, they work fairly
well.
Bug reports are welcome, but not guaranteed to be fixable unless they are
accompanied by very clear instructions how these valuations should be
calculated.

On Thu, 9 May 2019 at 00:46, Stephen C. Camidge 
wrote:

> Sounds like you wrote the program - I am new to this and do not know the
> history.
>
> As a recently retired accountant, I am use GNU Cash as a replacement for
> Quickbooks. I like what I see, but would like the reporting capabilities of
> Quickbooks where possible. To me, monthly P and comparative P to prior
> year are very useful. I would never tell you not to implement it. I would
> rather request it.
>
> Yes, I now see that I can export to a spreadsheet and modify it, but I do
> not think I should have to. The program should do it for me. My view may
> not match that of other people, so will use the workaround.
>
> Thank you very much for the comments and advice (to all) and for the
> program!
>
> --
> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>
> On Wed, May 8, 2019, at 8:59 AM, Michael or Penny Novack wrote:
> > On 5/7/2019 11:22 PM, Adrien Monteleone wrote:
> >
> > > Comparative-period P is not yet implemented in GnuCash. (but as
> Chris Lamm noted, he has a testing version of the report that *might* fit
> your needs - if you can try it, please do so)
> >
> > One reason it has not been implemented is that when I began (2007) using
> > gnucash for organizational accounting I was advised not to bother.  A
> > non-profit, for annual reports, always shows this year vs last year
> > Balance Sheet and Statement of Revenues and Expenses (what a non-profit
> > calls P). As a recently retired senior analyst, decades
> > designing/writing financial systems software, and able to at least read
> > LISP, I could presumably have managed the scheme for these special
> > reports. And if I wrote them, I would have shared them.
> >
> > The lawyer/accountant who said "do it outside of gnucash with a full
> > power editor" was persuasive, correct that there would STILL be a lot of
> > editing remaining to be done, so better to do all editing at one time
> > with one tool designed for the purpose.
> >
> > Michael D Novack, FLMI
> >
> > ___
> > 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] Questions

[Stephen C. Camidge]

Sounds like you wrote the program - I am new to this and do not know the 
history.

As a recently retired accountant, I am use GNU Cash as a replacement for 
Quickbooks. I like what I see, but would like the reporting capabilities of 
Quickbooks where possible. To me, monthly P and comparative P to prior year 
are very useful. I would never tell you not to implement it. I would rather 
request it.

Yes, I now see that I can export to a spreadsheet and modify it, but I do not 
think I should have to. The program should do it for me. My view may not match 
that of other people, so will use the workaround.

Thank you very much for the comments and advice (to all) and for the program!

-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Wed, May 8, 2019, at 8:59 AM, Michael or Penny Novack wrote:
> On 5/7/2019 11:22 PM, Adrien Monteleone wrote:
> 
> > Comparative-period P is not yet implemented in GnuCash. (but as Chris 
> > Lamm noted, he has a testing version of the report that *might* fit your 
> > needs - if you can try it, please do so)
> 
> One reason it has not been implemented is that when I began (2007) using 
> gnucash for organizational accounting I was advised not to bother.  A 
> non-profit, for annual reports, always shows this year vs last year 
> Balance Sheet and Statement of Revenues and Expenses (what a non-profit 
> calls P). As a recently retired senior analyst, decades 
> designing/writing financial systems software, and able to at least read 
> LISP, I could presumably have managed the scheme for these special 
> reports. And if I wrote them, I would have shared them.
> 
> The lawyer/accountant who said "do it outside of gnucash with a full 
> power editor" was persuasive, correct that there would STILL be a lot of 
> editing remaining to be done, so better to do all editing at one time 
> with one tool designed for the purpose.
> 
> Michael D Novack, FLMI
> 
> ___
> 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] Questions

[Stephen C. Camidge]

I used Libre Office and it worked. Thank you very much for the workaround!

Steve


-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Wed, May 8, 2019, at 8:55 AM, Maf. King wrote:
> On Wednesday, 8 May 2019 12:33:34 BST Stephen C. Camidge wrote:
> > I tried that. I added an autosum command totalling a column with a result of
> > $0 (wrong total). It is like it treats the cell as text. I tried opening
> > with excels' Data buttons for From HTML and From Text - still no success.
> > > On Wednesday, 8 May 2019 12:13:05 BST Stephen C. Camidge wrote:
> > > > Thank you to both of you. I have not figured out how to export to a
> > > > spreadsheet - I tried but only could export to html, added a sum of the
> > > > column, but the sum gave a total of $0.
> > > 
> 
> 
> Sorry, yes.  Forgot a step.
> 
> the HTML has £123.45 in the cells.  Libre Office imports these as text. 
>  Doing a 
> Find and Replace on the whole sheet and replacing £ with  
> works in 
> Libre Office.  Hope Excel is similar.
> 
> HTH,
> Maf.
>  
> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Questions

[Maf. King]

On Wednesday, 8 May 2019 12:33:34 BST Stephen C. Camidge wrote:
> I tried that. I added an autosum command totalling a column with a result of
> $0 (wrong total). It is like it treats the cell as text. I tried opening
> with excels' Data buttons for From HTML and From Text - still no success.
> > On Wednesday, 8 May 2019 12:13:05 BST Stephen C. Camidge wrote:
> > > Thank you to both of you. I have not figured out how to export to a
> > > spreadsheet - I tried but only could export to html, added a sum of the
> > > column, but the sum gave a total of $0.
> > 


Sorry, yes.  Forgot a step.

the HTML has £123.45 in the cells.  Libre Office imports these as text.  Doing 
a 
Find and Replace on the whole sheet and replacing £ with  works in 
Libre Office.  Hope Excel is similar.

HTH,
Maf.
 



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

Re: [GNC] Questions

[Michael or Penny Novack]

On 5/7/2019 11:22 PM, Adrien Monteleone wrote:


Comparative-period P is not yet implemented in GnuCash. (but as Chris Lamm 
noted, he has a testing version of the report that *might* fit your needs - if you 
can try it, please do so)


One reason it has not been implemented is that when I began (2007) using 
gnucash for organizational accounting I was advised not to bother.  A 
non-profit, for annual reports, always shows this year vs last year 
Balance Sheet and Statement of Revenues and Expenses (what a non-profit 
calls P). As a recently retired senior analyst, decades 
designing/writing financial systems software, and able to at least read 
LISP, I could presumably have managed the scheme for these special 
reports. And if I wrote them, I would have shared them.


The lawyer/accountant who said "do it outside of gnucash with a full 
power editor" was persuasive, correct that there would STILL be a lot of 
editing remaining to be done, so better to do all editing at one time 
with one tool designed for the purpose.


Michael D Novack, FLMI

___
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] Questions

[Stephen C. Camidge]

I tried that. I added an autosum command totalling a column with a result of $0 
(wrong total). It is like it treats the cell as text. I tried opening with 
excels' Data buttons for From HTML and From Text - still no success.


-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Wed, May 8, 2019, at 7:25 AM, Maf. King wrote:
> On Wednesday, 8 May 2019 12:13:05 BST Stephen C. Camidge wrote:
> > Thank you to both of you. I have not figured out how to export to a
> > spreadsheet - I tried but only could export to html, added a sum of the
> > column, but the sum gave a total of $0.
> 
> Hi Stephen
> 
> 2 suggestions:
> 
> 1. I believe that most popular, modern spreadsheets can open (or import) html.
> 
> 2. Copy & Paste the GC output into a blank spreadsheet
> 
> HTH,
> Maf.
> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Questions

[Maf. King]

On Wednesday, 8 May 2019 12:13:05 BST Stephen C. Camidge wrote:
> Thank you to both of you. I have not figured out how to export to a
> spreadsheet - I tried but only could export to html, added a sum of the
> column, but the sum gave a total of $0.

Hi Stephen

2 suggestions:

1. I believe that most popular, modern spreadsheets can open (or import) html.

2. Copy & Paste the GC output into a blank spreadsheet

HTH,
Maf.



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

Re: [GNC] Questions

[Stephen C. Camidge]

Thank you to both of you. I have not figured out how to export to a spreadsheet 
- I tried but only could export to html, added a sum of the column, but the sum 
gave a total of $0.


-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Tue, May 7, 2019, at 11:44 PM, Christopher Lam wrote:
> Thanks Adrien.
> I've realised that unless the multicolumn report is merged into mainstream,
> it will never gain enough exposure for bug reports. So perhaps it'll be
> better to merge for 3.6 into an 'experimental' submenu within reports.
> C
> 
> 
> On Wed, 8 May 2019 at 13:24, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> 
> > Stephen,
> >
> > Comparative-period P is not yet implemented in GnuCash. (but as Chris
> > Lamm noted, he has a testing version of the report that *might* fit your
> > needs - if you can try it, please do so)
> >
> > You *can* run a multi-column report with each period in its own column,
> > but it will get messy with each column having its own row headers, as
> > you’ve likely discovered. (you could set all columns to use all accounts,
> > show zero balance accounts, and then copy/paste or export to spreadsheet
> > and then manipulate from there)
> >
> > Probably an easier route is to maintain a spreadsheet of your P’s and
> > paste in each column every period. Be sure to include all account including
> > zero balance accounts so everything lines up on the proper rows in the
> > spreadsheet. (I use this method along with percentage and variance columns
> > that I add)
> >
> > Regards,
> > Adrien
> >
> > > On May 6, 2019, at 8:35 AM, Stephen C. Camidge 
> > wrote:
> > >
> > > 2) Yes, I can get multi column reports with the Transaction Report, show
> > totals monthly by account, but it will not display monthly totals and it
> > will not display Revenue separately from Expenses with totals for Revenue
> > and for Expenses.
> >
> >
> > ___
> > 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] Questions

[Christopher Lam]

Thanks Adrien.
I've realised that unless the multicolumn report is merged into mainstream,
it will never gain enough exposure for bug reports. So perhaps it'll be
better to merge for 3.6 into an 'experimental' submenu within reports.
C


On Wed, 8 May 2019 at 13:24, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Stephen,
>
> Comparative-period P is not yet implemented in GnuCash. (but as Chris
> Lamm noted, he has a testing version of the report that *might* fit your
> needs - if you can try it, please do so)
>
> You *can* run a multi-column report with each period in its own column,
> but it will get messy with each column having its own row headers, as
> you’ve likely discovered. (you could set all columns to use all accounts,
> show zero balance accounts, and then copy/paste or export to spreadsheet
> and then manipulate from there)
>
> Probably an easier route is to maintain a spreadsheet of your P’s and
> paste in each column every period. Be sure to include all account including
> zero balance accounts so everything lines up on the proper rows in the
> spreadsheet. (I use this method along with percentage and variance columns
> that I add)
>
> Regards,
> Adrien
>
> > On May 6, 2019, at 8:35 AM, Stephen C. Camidge 
> wrote:
> >
> > 2) Yes, I can get multi column reports with the Transaction Report, show
> totals monthly by account, but it will not display monthly totals and it
> will not display Revenue separately from Expenses with totals for Revenue
> and for Expenses.
>
>
> ___
> 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] Questions

[Adrien Monteleone]

Stephen,

Comparative-period P is not yet implemented in GnuCash. (but as Chris Lamm 
noted, he has a testing version of the report that *might* fit your needs - if 
you can try it, please do so)

You *can* run a multi-column report with each period in its own column, but it 
will get messy with each column having its own row headers, as you’ve likely 
discovered. (you could set all columns to use all accounts, show zero balance 
accounts, and then copy/paste or export to spreadsheet and then manipulate from 
there)

Probably an easier route is to maintain a spreadsheet of your P’s and paste 
in each column every period. Be sure to include all account including zero 
balance accounts so everything lines up on the proper rows in the spreadsheet. 
(I use this method along with percentage and variance columns that I add)

Regards,
Adrien

> On May 6, 2019, at 8:35 AM, Stephen C. Camidge  wrote:
> 
> 2) Yes, I can get multi column reports with the Transaction Report, show 
> totals monthly by account, but it will not display monthly totals and it will 
> not display Revenue separately from Expenses with totals for Revenue and for 
> Expenses.


___
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] Questions

[Stephen C. Camidge]

Sorry. I followed the instructions but do not see the report in the Reports 
Menu.

Steve

--
Stephen C. Camidge scami...@fastmail.fm (519) 363-3912




On Mon, May 6, 2019, at 7:05 PM, Christopher Lam wrote:
> Oops it's set to "Experimental" menu.
> Just delete the 2 lines towards the end of the file as follows:
> 
> 'menu-path (list gnc:menuname-experimental)
> 
> On Tue, 7 May 2019 at 01:31, Stephen C. Camidge  wrote:
>> __
>> Thank you. I found the location but could not locate the report in the 
>> Reports Menu.
>> 
>> --
>> Stephen C. Camidge scami...@fastmail.fm (519) 363-3912
>> 
>> 
>> 
>> 
>> On Mon, May 6, 2019, at 10:31 AM, Christopher Lam wrote:
>>> Hi Stephen
>>> 
>>> You are very welcome to try the following report. Save it into 
>>> standard-reports folder, found deep within the Gnucash.app package, and it 
>>> will automatically add a new multicolumn income-statement and balance-sheet 
>>> report as you describe.
>>> 
>>> https://raw.githubusercontent.com/christopherlam/gnucash/maint-balsheet-pnl/gnucash/report/standard-reports/balsheet-pnl.scm
>>> 
>>> Your input will be very welcome regarding foreign-currency conversions, 
>>> realized/unrealized gain/loss, retained-earnings reporting. I'm sure you 
>>> know these definitions are a deep rabbit-hole. This report is a 
>>> work-in-progress for nearly 1 month due to unresolved questions.
>>> 
>>> Regards, Chris
>>> 
>>> On Mon, 6 May 2019 at 13:37, Stephen C. Camidge  
>>> wrote:
 2) Yes, I can get multi column reports with the Transaction Report, show 
 totals monthly by account, but it will not display monthly totals and it 
 will not display Revenue separately from Expenses with totals for Revenue 
 and for Expenses.
 
 3) I did make the multiple selection. Thank you for confirming that 
 something is indeed going on.
 
 
 -- 
 Stephen C. Camidge scami...@fastmail.fm (519) 363-3912
 
 On Mon, May 6, 2019, at 9:17 AM, David T. wrote:
 > 3 - I spoke too soon. There is something weird going on there. I can 
 > select multiple accounts, and some will display, while others do not. 
 > Not sure what is going on there.
 > 
 > > On May 6, 2019, at 6:38 PM, David T. via gnucash-user 
 > >  wrote:
 > > 
 > > 2 - Multicolumn reports are already part of GnuCash.
 > > 3 - I just loaded 3.5, ran the G/L report, selected a random set of 
 > > disjoint accounts, and received sane results. Is it possible that when 
 > > you attempted to select multiple accounts, you actually selected only 
 > > the last account you clicked? Many’s the time that I have thought I 
 > > had the Command key held down, only to discover that I’d succeeded in 
 > > picking only that last account…
 > > 
 > > 
 > > David
 > > 
 > >> On May 6, 2019, at 6:15 PM, Stephen C. Camidge  
 > >> wrote:
 > >> 
 > >> 1) OK
 > >> 
 > >> 2) yes - this would be most useful
 > >> 
 > >> 3) General Ledger - I can select multiple accounts, but for me (Mac, 
 > >> 3.5) only the first selected account appears in the General Ledger 
 > >> Report.
 > >> 
 > >> -- 
 > >> Stephen C. Camidge scami...@fastmail.fm (519) 363-3912
 > >> 
 > >> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
 > >>> 1 - As I mentioned, account codes will work for this. Assign each 
 > >>> account a numeric code, add the code column to the COA, and sort on 
 > >>> it. 
 > >>> Done.
 > >>> 2 - Multicolumn reports.
 > >>> 3 - Are you talking about the “General Ledger” report, or the 
 > >>> “General 
 > >>> Journal” report? My version of the former report (GC 3.4 under 
 > >>> MacOX) 
 > >>> behaves exactly like the generic “Transaction Report” you mention 
 > >>> (indeed, I suspect that under the hood, that’s what it is). IOW, I 
 > >>> am 
 > >>> able to select accounts for inclusion on the report. Can you explain 
 > >>> more specifically what you are doing and seeing, and what you expect 
 > >>> to 
 > >>> find that you are not?
 > >>> 
 > >>> David
 > >>> 
 >  On May 6, 2019, at 5:56 PM, Stephen C. Camidge 
 >   wrote:
 >  
 >  1) different order to reflect what I am used to seeing in other 
 >  accounting programs
 >  
 >  2) I agree that comparative reports would be useful - other 
 >  programs offer them as option, the program should too
 >  
 >  3) multiple accounts in a G/L report are standard elsewhere - the 
 >  transaction report can do this, but the G/L detail report should.
 >  
 >  
 >  -- 
 >  Stephen C. Camidge scami...@fastmail.fm (519) 363-3912
 >  
 >  On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
 > > On 5/6/2019 7:13 AM, Stephen Camidge wrote:
 > >> 1) I set up a new book on the Mac 

Re: [GNC] Questions

[Stephen C. Camidge]

Thank you. I found the location but could not locate the report in the Reports 
Menu.

--
Stephen C. Camidge scami...@fastmail.fm (519) 363-3912




On Mon, May 6, 2019, at 10:31 AM, Christopher Lam wrote:
> Hi Stephen
> 
> You are very welcome to try the following report. Save it into 
> standard-reports folder, found deep within the Gnucash.app package, and it 
> will automatically add a new multicolumn income-statement and balance-sheet 
> report as you describe.
> 
> https://raw.githubusercontent.com/christopherlam/gnucash/maint-balsheet-pnl/gnucash/report/standard-reports/balsheet-pnl.scm
> 
> Your input will be very welcome regarding foreign-currency conversions, 
> realized/unrealized gain/loss, retained-earnings reporting. I'm sure you know 
> these definitions are a deep rabbit-hole. This report is a work-in-progress 
> for nearly 1 month due to unresolved questions.
> 
> Regards, Chris
> 
> On Mon, 6 May 2019 at 13:37, Stephen C. Camidge  wrote:
>> 2) Yes, I can get multi column reports with the Transaction Report, show 
>> totals monthly by account, but it will not display monthly totals and it 
>> will not display Revenue separately from Expenses with totals for Revenue 
>> and for Expenses.
>> 
>>  3) I did make the multiple selection. Thank you for confirming that 
>> something is indeed going on.
>> 
>> 
>>  -- 
>>  Stephen C. Camidge scami...@fastmail.fm (519) 363-3912
>> 
>>  On Mon, May 6, 2019, at 9:17 AM, David T. wrote:
>>  > 3 - I spoke too soon. There is something weird going on there. I can 
>>  > select multiple accounts, and some will display, while others do not. 
>>  > Not sure what is going on there.
>>  > 
>>  > > On May 6, 2019, at 6:38 PM, David T. via gnucash-user 
>>  wrote:
>>  > > 
>>  > > 2 - Multicolumn reports are already part of GnuCash.
>>  > > 3 - I just loaded 3.5, ran the G/L report, selected a random set of 
>> disjoint accounts, and received sane results. Is it possible that when you 
>> attempted to select multiple accounts, you actually selected only the last 
>> account you clicked? Many’s the time that I have thought I had the Command 
>> key held down, only to discover that I’d succeeded in picking only that last 
>> account…
>>  > > 
>>  > > 
>>  > > David
>>  > > 
>>  > >> On May 6, 2019, at 6:15 PM, Stephen C. Camidge  
>> wrote:
>>  > >> 
>>  > >> 1) OK
>>  > >> 
>>  > >> 2) yes - this would be most useful
>>  > >> 
>>  > >> 3) General Ledger - I can select multiple accounts, but for me (Mac, 
>> 3.5) only the first selected account appears in the General Ledger Report.
>>  > >> 
>>  > >> -- 
>>  > >> Stephen C. Camidge scami...@fastmail.fm (519) 363-3912
>>  > >> 
>>  > >> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
>>  > >>> 1 - As I mentioned, account codes will work for this. Assign each 
>>  > >>> account a numeric code, add the code column to the COA, and sort on 
>> it. 
>>  > >>> Done.
>>  > >>> 2 - Multicolumn reports.
>>  > >>> 3 - Are you talking about the “General Ledger” report, or the 
>> “General 
>>  > >>> Journal” report? My version of the former report (GC 3.4 under MacOX) 
>>  > >>> behaves exactly like the generic “Transaction Report” you mention 
>>  > >>> (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
>>  > >>> able to select accounts for inclusion on the report. Can you explain 
>>  > >>> more specifically what you are doing and seeing, and what you expect 
>> to 
>>  > >>> find that you are not?
>>  > >>> 
>>  > >>> David
>>  > >>> 
>>  >  On May 6, 2019, at 5:56 PM, Stephen C. Camidge 
>>  wrote:
>>  >  
>>  >  1) different order to reflect what I am used to seeing in other 
>> accounting programs
>>  >  
>>  >  2) I agree that comparative reports would be useful - other programs 
>> offer them as option, the program should too
>>  >  
>>  >  3) multiple accounts in a G/L report are standard elsewhere - the 
>> transaction report can do this, but the G/L detail report should.
>>  >  
>>  >  
>>  >  -- 
>>  >  Stephen C. Camidge scami...@fastmail.fm (519) 363-3912
>>  >  
>>  >  On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
>>  > > On 5/6/2019 7:13 AM, Stephen Camidge wrote:
>>  > >> 1) I set up a new book on the Mac version of gnucash using "A 
>> Simple 
>>  > >> Checkbook". The Chart of Accounts places Income below Expenses - 
>> why? 
>>  > >> I added Top Level Accounts for Liabilities and it was put below 
>>  > >> Income. The Transaction Report shows Income below Expenses. How do 
>> I 
>>  > >> change the order?
>>  > > Collating sequence ( L > I) Just curious, but why do you want a 
>>  > > different order?
>>  > > 
>>  > >> 2) Income Statement show the selected period in the right order 
>> but 
>>  > >> cannot show columns by month. Same with Profit and Loss. 
>> Transaction 
>>  > >> report can, but in the wrong order (see 1).
>>  > > You are asking for a series of 

Re: [GNC] Questions

[Stephen C. Camidge]

2 Thank you. I am not yet comfortable with using that report - can't get it to 
work. Will experiment later.

-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Mon, May 6, 2019, at 10:11 AM, David T. wrote:
> 2 - You misunderstand me. I am not speaking about using the Transaction 
> Report with subtotals. I am speaking about using multiple instances of 
> the Income report you desire, each set for the period you want. Go to 
> Reports->Sample & Custom Reports->Custom Multicolumn Report and set it 
> up with (for example) two columns, with an Income report for the 
> previous quarter in the first column, and an Income Report for the 
> current quarter in the second column.
> 
> 3 - There is something fishy with the General Ledger report. It doesn’t 
> seem to recognize certain accounts, and there doesn’t seem rhyme or 
> reason to the accounts it includes or omits. This is true in both 3.4 
> and 3.5. It doesn’t seem to be the currency of the accounts (that is, I 
> can see some but not all accounts denominated in different currencies). 
> It doesn’t seem to be the depth of the accounts selected (I can see 
> some but not all accounts at numerous different levels of the 
> hierarchy). I will note that it will not display a selected account if 
> there are no transactions in the period selected. However, that doesn’t 
> explain everything that’s going on here…
> 
> David
> 
> 
> > On May 6, 2019, at 7:05 PM, Stephen C. Camidge  wrote:
> > 
> > 2) Yes, I can get multi column reports with the Transaction Report, show 
> > totals monthly by account, but it will not display monthly totals and it 
> > will not display Revenue separately from Expenses with totals for Revenue 
> > and for Expenses.
> > 
> > 3) I did make the multiple selection. Thank you for confirming that 
> > something is indeed going on.
> > 
> > 
> > -- 
> > Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> > 
> > On Mon, May 6, 2019, at 9:17 AM, David T. wrote:
> >> 3 - I spoke too soon. There is something weird going on there. I can 
> >> select multiple accounts, and some will display, while others do not. 
> >> Not sure what is going on there.
> >> 
> >>> On May 6, 2019, at 6:38 PM, David T. via gnucash-user 
> >>>  wrote:
> >>> 
> >>> 2 - Multicolumn reports are already part of GnuCash.
> >>> 3 - I just loaded 3.5, ran the G/L report, selected a random set of 
> >>> disjoint accounts, and received sane results. Is it possible that when 
> >>> you attempted to select multiple accounts, you actually selected only the 
> >>> last account you clicked? Many’s the time that I have thought I had the 
> >>> Command key held down, only to discover that I’d succeeded in picking 
> >>> only that last account…
> >>> 
> >>> 
> >>> David
> >>> 
>  On May 6, 2019, at 6:15 PM, Stephen C. Camidge  
>  wrote:
>  
>  1) OK
>  
>  2) yes - this would be most useful
>  
>  3) General Ledger - I can select multiple accounts, but for me (Mac, 
>  3.5) only the first selected account appears in the General Ledger 
>  Report.
>  
>  -- 
>  Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>  
>  On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
> > 1 - As I mentioned, account codes will work for this. Assign each 
> > account a numeric code, add the code column to the COA, and sort on it. 
> > Done.
> > 2 - Multicolumn reports.
> > 3 - Are you talking about the “General Ledger” report, or the “General 
> > Journal” report? My version of the former report (GC 3.4 under MacOX) 
> > behaves exactly like the generic “Transaction Report” you mention 
> > (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
> > able to select accounts for inclusion on the report. Can you explain 
> > more specifically what you are doing and seeing, and what you expect to 
> > find that you are not?
> > 
> > David
> > 
> >> On May 6, 2019, at 5:56 PM, Stephen C. Camidge  
> >> wrote:
> >> 
> >> 1) different order to reflect what I am used to seeing in other 
> >> accounting programs
> >> 
> >> 2) I agree that comparative reports would be useful - other programs 
> >> offer them as option, the program should too
> >> 
> >> 3) multiple accounts in a G/L report are standard elsewhere - the 
> >> transaction report can do this, but the G/L detail report should.
> >> 
> >> 
> >> -- 
> >> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> >> 
> >> On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
> >>> On 5/6/2019 7:13 AM, Stephen Camidge wrote:
>  1) I set up a new book on the Mac version of gnucash using "A Simple 
>  Checkbook". The Chart of Accounts places Income below Expenses - 
>  why? 
>  I added Top Level Accounts for Liabilities and it was put below 

Re: [GNC] Questions

[Stephen C. Camidge]

Understood, thank you.

-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Mon, May 6, 2019, at 11:03 AM, wheelercsg-li...@yahoo.com wrote:
> I'm still using GnuCash 2.6.15, so it may be different in later 
> releases, but in 2.6.15 you can change the sort order of the top-level 
> accounts by clicking on the header labelled "Account Name".
> 
> > Date: Mon, 6 May 2019 07:13:17 -0400
> > From: Stephen Camidge
> > To:gnucash-user@gnucash.org
> > Subject: [GNC] Questions
> > Message-ID:<51dc21db-a256-9b77-a0a0-911a821d9...@fastmail.fm>
> > Content-Type: text/plain; charset=utf-8; format=flowed
> >
> > 1) I set up a new book on the Mac version of gnucash using "A Simple
> > Checkbook". The Chart of Accounts places Income below Expenses - why? I
> > added Top Level Accounts for Liabilities and it was put below Income.?
> > The Transaction Report shows Income below Expenses.? How do I change the
> > order?
> >
> > [snip]
> >
> > What am I missing?
> >
> > Thank you.
> 
>
___
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] Questions

[wheelercsg-lists--- via gnucash-user]

I'm still using GnuCash 2.6.15, so it may be different in later 
releases, but in 2.6.15 you can change the sort order of the top-level 
accounts by clicking on the header labelled "Account Name".



Date: Mon, 6 May 2019 07:13:17 -0400
From: Stephen Camidge
To:gnucash-user@gnucash.org
Subject: [GNC] Questions
Message-ID:<51dc21db-a256-9b77-a0a0-911a821d9...@fastmail.fm>
Content-Type: text/plain; charset=utf-8; format=flowed

1) I set up a new book on the Mac version of gnucash using "A Simple
Checkbook". The Chart of Accounts places Income below Expenses - why? I
added Top Level Accounts for Liabilities and it was put below Income.?
The Transaction Report shows Income below Expenses.? How do I change the
order?

[snip]

What am I missing?

Thank you.


___
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] Questions

[Christopher Lam]

typo: This report is a work-in-progress for nearly 1 year due to such
unresolved questions

On Mon, 6 May 2019 at 14:31, Christopher Lam 
wrote:

> Hi Stephen
>
> You are very welcome to try the following report. Save it into
> standard-reports folder, found deep within the Gnucash.app package, and it
> will automatically add a new multicolumn income-statement and balance-sheet
> report as you describe.
>
>
> https://raw.githubusercontent.com/christopherlam/gnucash/maint-balsheet-pnl/gnucash/report/standard-reports/balsheet-pnl.scm
>
> Your input will be very welcome regarding foreign-currency conversions,
> realized/unrealized gain/loss, retained-earnings reporting. I'm sure you
> know these definitions are a deep rabbit-hole. This report is a
> work-in-progress for nearly 1 month due to unresolved questions.
>
> Regards, Chris
>
> On Mon, 6 May 2019 at 13:37, Stephen C. Camidge 
> wrote:
>
>> 2) Yes, I can get multi column reports with the Transaction Report, show
>> totals monthly by account, but it will not display monthly totals and it
>> will not display Revenue separately from Expenses with totals for Revenue
>> and for Expenses.
>>
>> 3) I did make the multiple selection. Thank you for confirming that
>> something is indeed going on.
>>
>>
>> --
>> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>>
>> On Mon, May 6, 2019, at 9:17 AM, David T. wrote:
>> > 3 - I spoke too soon. There is something weird going on there. I can
>> > select multiple accounts, and some will display, while others do not.
>> > Not sure what is going on there.
>> >
>> > > On May 6, 2019, at 6:38 PM, David T. via gnucash-user <
>> gnucash-user@gnucash.org> wrote:
>> > >
>> > > 2 - Multicolumn reports are already part of GnuCash.
>> > > 3 - I just loaded 3.5, ran the G/L report, selected a random set of
>> disjoint accounts, and received sane results. Is it possible that when you
>> attempted to select multiple accounts, you actually selected only the last
>> account you clicked? Many’s the time that I have thought I had the Command
>> key held down, only to discover that I’d succeeded in picking only that
>> last account…
>> > >
>> > >
>> > > David
>> > >
>> > >> On May 6, 2019, at 6:15 PM, Stephen C. Camidge 
>> wrote:
>> > >>
>> > >> 1) OK
>> > >>
>> > >> 2) yes - this would be most useful
>> > >>
>> > >> 3) General Ledger - I can select multiple accounts, but for me (Mac,
>> 3.5) only the first selected account appears in the General Ledger Report.
>> > >>
>> > >> --
>> > >> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>> > >>
>> > >> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
>> > >>> 1 - As I mentioned, account codes will work for this. Assign each
>> > >>> account a numeric code, add the code column to the COA, and sort on
>> it.
>> > >>> Done.
>> > >>> 2 - Multicolumn reports.
>> > >>> 3 - Are you talking about the “General Ledger” report, or the
>> “General
>> > >>> Journal” report? My version of the former report (GC 3.4 under
>> MacOX)
>> > >>> behaves exactly like the generic “Transaction Report” you mention
>> > >>> (indeed, I suspect that under the hood, that’s what it is). IOW, I
>> am
>> > >>> able to select accounts for inclusion on the report. Can you
>> explain
>> > >>> more specifically what you are doing and seeing, and what you
>> expect to
>> > >>> find that you are not?
>> > >>>
>> > >>> David
>> > >>>
>> >  On May 6, 2019, at 5:56 PM, Stephen C. Camidge <
>> scami...@fastmail.fm> wrote:
>> > 
>> >  1) different order to reflect what I am used to seeing in other
>> accounting programs
>> > 
>> >  2) I agree that comparative reports would be useful - other
>> programs offer them as option, the program should too
>> > 
>> >  3) multiple accounts in a G/L report are standard elsewhere - the
>> transaction report can do this, but the G/L detail report should.
>> > 
>> > 
>> >  --
>> >  Stephen C. Camidge scami...@fastmail.fm   (519)
>> 363-3912
>> > 
>> >  On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
>> > > On 5/6/2019 7:13 AM, Stephen Camidge wrote:
>> > >> 1) I set up a new book on the Mac version of gnucash using "A
>> Simple
>> > >> Checkbook". The Chart of Accounts places Income below Expenses -
>> why?
>> > >> I added Top Level Accounts for Liabilities and it was put below
>> > >> Income.  The Transaction Report shows Income below Expenses.
>> How do I
>> > >> change the order?
>> > > Collating sequence ( L > I)   Just curious, but why do you
>> want a
>> > > different order?
>> > >
>> > >> 2) Income Statement show the selected period in the right order
>> but
>> > >> cannot show columns by month. Same with Profit and Loss.
>> Transaction
>> > >> report can, but in the wrong order (see 1).
>> > > You are asking for a series of "Income Statement" reports for
>> > > consecutive periods displayed side by side 

Re: [GNC] Questions

[Christopher Lam]

Hi Stephen

You are very welcome to try the following report. Save it into
standard-reports folder, found deep within the Gnucash.app package, and it
will automatically add a new multicolumn income-statement and balance-sheet
report as you describe.

https://raw.githubusercontent.com/christopherlam/gnucash/maint-balsheet-pnl/gnucash/report/standard-reports/balsheet-pnl.scm

Your input will be very welcome regarding foreign-currency conversions,
realized/unrealized gain/loss, retained-earnings reporting. I'm sure you
know these definitions are a deep rabbit-hole. This report is a
work-in-progress for nearly 1 month due to unresolved questions.

Regards, Chris

On Mon, 6 May 2019 at 13:37, Stephen C. Camidge 
wrote:

> 2) Yes, I can get multi column reports with the Transaction Report, show
> totals monthly by account, but it will not display monthly totals and it
> will not display Revenue separately from Expenses with totals for Revenue
> and for Expenses.
>
> 3) I did make the multiple selection. Thank you for confirming that
> something is indeed going on.
>
>
> --
> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>
> On Mon, May 6, 2019, at 9:17 AM, David T. wrote:
> > 3 - I spoke too soon. There is something weird going on there. I can
> > select multiple accounts, and some will display, while others do not.
> > Not sure what is going on there.
> >
> > > On May 6, 2019, at 6:38 PM, David T. via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> > >
> > > 2 - Multicolumn reports are already part of GnuCash.
> > > 3 - I just loaded 3.5, ran the G/L report, selected a random set of
> disjoint accounts, and received sane results. Is it possible that when you
> attempted to select multiple accounts, you actually selected only the last
> account you clicked? Many’s the time that I have thought I had the Command
> key held down, only to discover that I’d succeeded in picking only that
> last account…
> > >
> > >
> > > David
> > >
> > >> On May 6, 2019, at 6:15 PM, Stephen C. Camidge 
> wrote:
> > >>
> > >> 1) OK
> > >>
> > >> 2) yes - this would be most useful
> > >>
> > >> 3) General Ledger - I can select multiple accounts, but for me (Mac,
> 3.5) only the first selected account appears in the General Ledger Report.
> > >>
> > >> --
> > >> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> > >>
> > >> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
> > >>> 1 - As I mentioned, account codes will work for this. Assign each
> > >>> account a numeric code, add the code column to the COA, and sort on
> it.
> > >>> Done.
> > >>> 2 - Multicolumn reports.
> > >>> 3 - Are you talking about the “General Ledger” report, or the
> “General
> > >>> Journal” report? My version of the former report (GC 3.4 under
> MacOX)
> > >>> behaves exactly like the generic “Transaction Report” you mention
> > >>> (indeed, I suspect that under the hood, that’s what it is). IOW, I
> am
> > >>> able to select accounts for inclusion on the report. Can you explain
> > >>> more specifically what you are doing and seeing, and what you expect
> to
> > >>> find that you are not?
> > >>>
> > >>> David
> > >>>
> >  On May 6, 2019, at 5:56 PM, Stephen C. Camidge <
> scami...@fastmail.fm> wrote:
> > 
> >  1) different order to reflect what I am used to seeing in other
> accounting programs
> > 
> >  2) I agree that comparative reports would be useful - other
> programs offer them as option, the program should too
> > 
> >  3) multiple accounts in a G/L report are standard elsewhere - the
> transaction report can do this, but the G/L detail report should.
> > 
> > 
> >  --
> >  Stephen C. Camidge scami...@fastmail.fm   (519)
> 363-3912
> > 
> >  On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
> > > On 5/6/2019 7:13 AM, Stephen Camidge wrote:
> > >> 1) I set up a new book on the Mac version of gnucash using "A
> Simple
> > >> Checkbook". The Chart of Accounts places Income below Expenses -
> why?
> > >> I added Top Level Accounts for Liabilities and it was put below
> > >> Income.  The Transaction Report shows Income below Expenses.  How
> do I
> > >> change the order?
> > > Collating sequence ( L > I)   Just curious, but why do you
> want a
> > > different order?
> > >
> > >> 2) Income Statement show the selected period in the right order
> but
> > >> cannot show columns by month. Same with Profit and Loss.
> Transaction
> > >> report can, but in the wrong order (see 1).
> > > You are asking for a series of "Income Statement" reports for
> > > consecutive periods displayed side by side (each P aka Statement
> of
> > > Revenues and Expenses < what called depends on entity, same report
> >. In
> > > other words, EACH has a defined start and end date since this
> report is
> > > for an interval.
> > >
> > > To produce such a (finished) report, use an 

Re: [GNC] Questions

[David T. via gnucash-user]

2 - You misunderstand me. I am not speaking about using the Transaction Report 
with subtotals. I am speaking about using multiple instances of the Income 
report you desire, each set for the period you want. Go to Reports->Sample & 
Custom Reports->Custom Multicolumn Report and set it up with (for example) two 
columns, with an Income report for the previous quarter in the first column, 
and an Income Report for the current quarter in the second column.

3 - There is something fishy with the General Ledger report. It doesn’t seem to 
recognize certain accounts, and there doesn’t seem rhyme or reason to the 
accounts it includes or omits. This is true in both 3.4 and 3.5. It doesn’t 
seem to be the currency of the accounts (that is, I can see some but not all 
accounts denominated in different currencies). It doesn’t seem to be the depth 
of the accounts selected (I can see some but not all accounts at numerous 
different levels of the hierarchy). I will note that it will not display a 
selected account if there are no transactions in the period selected. However, 
that doesn’t explain everything that’s going on here…

David


> On May 6, 2019, at 7:05 PM, Stephen C. Camidge  wrote:
> 
> 2) Yes, I can get multi column reports with the Transaction Report, show 
> totals monthly by account, but it will not display monthly totals and it will 
> not display Revenue separately from Expenses with totals for Revenue and for 
> Expenses.
> 
> 3) I did make the multiple selection. Thank you for confirming that something 
> is indeed going on.
> 
> 
> -- 
> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> 
> On Mon, May 6, 2019, at 9:17 AM, David T. wrote:
>> 3 - I spoke too soon. There is something weird going on there. I can 
>> select multiple accounts, and some will display, while others do not. 
>> Not sure what is going on there.
>> 
>>> On May 6, 2019, at 6:38 PM, David T. via gnucash-user 
>>>  wrote:
>>> 
>>> 2 - Multicolumn reports are already part of GnuCash.
>>> 3 - I just loaded 3.5, ran the G/L report, selected a random set of 
>>> disjoint accounts, and received sane results. Is it possible that when you 
>>> attempted to select multiple accounts, you actually selected only the last 
>>> account you clicked? Many’s the time that I have thought I had the Command 
>>> key held down, only to discover that I’d succeeded in picking only that 
>>> last account…
>>> 
>>> 
>>> David
>>> 
 On May 6, 2019, at 6:15 PM, Stephen C. Camidge  
 wrote:
 
 1) OK
 
 2) yes - this would be most useful
 
 3) General Ledger - I can select multiple accounts, but for me (Mac, 3.5) 
 only the first selected account appears in the General Ledger Report.
 
 -- 
 Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
 
 On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
> 1 - As I mentioned, account codes will work for this. Assign each 
> account a numeric code, add the code column to the COA, and sort on it. 
> Done.
> 2 - Multicolumn reports.
> 3 - Are you talking about the “General Ledger” report, or the “General 
> Journal” report? My version of the former report (GC 3.4 under MacOX) 
> behaves exactly like the generic “Transaction Report” you mention 
> (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
> able to select accounts for inclusion on the report. Can you explain 
> more specifically what you are doing and seeing, and what you expect to 
> find that you are not?
> 
> David
> 
>> On May 6, 2019, at 5:56 PM, Stephen C. Camidge  
>> wrote:
>> 
>> 1) different order to reflect what I am used to seeing in other 
>> accounting programs
>> 
>> 2) I agree that comparative reports would be useful - other programs 
>> offer them as option, the program should too
>> 
>> 3) multiple accounts in a G/L report are standard elsewhere - the 
>> transaction report can do this, but the G/L detail report should.
>> 
>> 
>> -- 
>> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>> 
>> On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
>>> On 5/6/2019 7:13 AM, Stephen Camidge wrote:
 1) I set up a new book on the Mac version of gnucash using "A Simple 
 Checkbook". The Chart of Accounts places Income below Expenses - why? 
 I added Top Level Accounts for Liabilities and it was put below 
 Income.  The Transaction Report shows Income below Expenses.  How do I 
 change the order?
>>> Collating sequence ( L > I)   Just curious, but why do you want a 
>>> different order?
>>> 
 2) Income Statement show the selected period in the right order but 
 cannot show columns by month. Same with Profit and Loss. Transaction 
 report can, but in the wrong order (see 1).
>>> You are asking for a 

Re: [GNC] Questions

[Stephen C. Camidge]

2) Yes, I can get multi column reports with the Transaction Report, show totals 
monthly by account, but it will not display monthly totals and it will not 
display Revenue separately from Expenses with totals for Revenue and for 
Expenses.

3) I did make the multiple selection. Thank you for confirming that something 
is indeed going on.


-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Mon, May 6, 2019, at 9:17 AM, David T. wrote:
> 3 - I spoke too soon. There is something weird going on there. I can 
> select multiple accounts, and some will display, while others do not. 
> Not sure what is going on there.
> 
> > On May 6, 2019, at 6:38 PM, David T. via gnucash-user 
> >  wrote:
> > 
> > 2 - Multicolumn reports are already part of GnuCash.
> > 3 - I just loaded 3.5, ran the G/L report, selected a random set of 
> > disjoint accounts, and received sane results. Is it possible that when you 
> > attempted to select multiple accounts, you actually selected only the last 
> > account you clicked? Many’s the time that I have thought I had the Command 
> > key held down, only to discover that I’d succeeded in picking only that 
> > last account…
> > 
> > 
> > David
> > 
> >> On May 6, 2019, at 6:15 PM, Stephen C. Camidge  
> >> wrote:
> >> 
> >> 1) OK
> >> 
> >> 2) yes - this would be most useful
> >> 
> >> 3) General Ledger - I can select multiple accounts, but for me (Mac, 3.5) 
> >> only the first selected account appears in the General Ledger Report.
> >> 
> >> -- 
> >> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> >> 
> >> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
> >>> 1 - As I mentioned, account codes will work for this. Assign each 
> >>> account a numeric code, add the code column to the COA, and sort on it. 
> >>> Done.
> >>> 2 - Multicolumn reports.
> >>> 3 - Are you talking about the “General Ledger” report, or the “General 
> >>> Journal” report? My version of the former report (GC 3.4 under MacOX) 
> >>> behaves exactly like the generic “Transaction Report” you mention 
> >>> (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
> >>> able to select accounts for inclusion on the report. Can you explain 
> >>> more specifically what you are doing and seeing, and what you expect to 
> >>> find that you are not?
> >>> 
> >>> David
> >>> 
>  On May 6, 2019, at 5:56 PM, Stephen C. Camidge  
>  wrote:
>  
>  1) different order to reflect what I am used to seeing in other 
>  accounting programs
>  
>  2) I agree that comparative reports would be useful - other programs 
>  offer them as option, the program should too
>  
>  3) multiple accounts in a G/L report are standard elsewhere - the 
>  transaction report can do this, but the G/L detail report should.
>  
>  
>  -- 
>  Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>  
>  On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
> > On 5/6/2019 7:13 AM, Stephen Camidge wrote:
> >> 1) I set up a new book on the Mac version of gnucash using "A Simple 
> >> Checkbook". The Chart of Accounts places Income below Expenses - why? 
> >> I added Top Level Accounts for Liabilities and it was put below 
> >> Income.  The Transaction Report shows Income below Expenses.  How do I 
> >> change the order?
> > Collating sequence ( L > I)   Just curious, but why do you want a 
> > different order?
> > 
> >> 2) Income Statement show the selected period in the right order but 
> >> cannot show columns by month. Same with Profit and Loss. Transaction 
> >> report can, but in the wrong order (see 1).
> > You are asking for a series of "Income Statement" reports for 
> > consecutive periods displayed side by side (each P aka Statement of 
> > Revenues and Expenses < what called depends on entity, same report >. 
> > In 
> > other words, EACH has a defined start and end date since this report is 
> > for an interval.
> > 
> > To produce such a (finished) report, use an editor capable of 
> > supporting 
> > columns and export each, then bring into its proper column. WHY not 
> > "within" gnucash? Stop a moment and think. Think of all the possible 
> > variations that would be wanted (how many to show in parallel, somebody 
> > else might want quarters or years, not months). Think about the after 
> > editing required (the CoA might have had changes, not exactly the same 
> > in each interval).
> > 
> > BTW -- since I keep books for non-profits, usually doing two years in 
> > parallel
> > 
> >> 
> >> 3) G/L report shows one account only, no matter how many I select. 
> >> Transaction Report can select all.
> > Why would you expect different reports to be the same in this regard?
> > 
> > Michael D Novack
> > 
> > 

Re: [GNC] Questions

[Stephen C. Camidge]

I am an accountant and am quite familiar with this information. I just expected 
to be able to select all transactions for a period in a number of accounts with 
the General Ledger report.

-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Mon, May 6, 2019, at 9:18 AM, Michael or Penny Novack wrote:
> On 5/6/2019 8:22 AM, Stephen C. Camidge wrote:
> 
> >
> > 3 - G/L is General Ledger
> >
> 
> Ah. being misled by the name of the report.
> 
> This is a situation where useful to understand how traditional pen and 
> ink on paper bookkeeping worked. You FIRST entered transactions in 
> chronological order into a "book" called the Journal. These entries were 
> then "posted" to the Ledger (to the ledger accounts affected).
> 
> Gnucash allows us to enter the transactions beginning in any of the 
> affected ledger accounts. We don't even see something resembling a 
> journal entry unless entering a "split transaction". In other words, the 
> journal is virtual.
> 
> But gnucash CAN show you the journal if you ask it to. As a report. Your 
> problem is with your expectation of what you are looking at when you ask 
> gnucash to give you a G/L or General Journal report.
> 
> Michael D Novack
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Questions

[David T. via gnucash-user]

3 - I spoke too soon. There is something weird going on there. I can select 
multiple accounts, and some will display, while others do not. Not sure what is 
going on there.

> On May 6, 2019, at 6:38 PM, David T. via gnucash-user 
>  wrote:
> 
> 2 - Multicolumn reports are already part of GnuCash.
> 3 - I just loaded 3.5, ran the G/L report, selected a random set of disjoint 
> accounts, and received sane results. Is it possible that when you attempted 
> to select multiple accounts, you actually selected only the last account you 
> clicked? Many’s the time that I have thought I had the Command key held down, 
> only to discover that I’d succeeded in picking only that last account…
> 
> 
> David
> 
>> On May 6, 2019, at 6:15 PM, Stephen C. Camidge  wrote:
>> 
>> 1) OK
>> 
>> 2) yes - this would be most useful
>> 
>> 3) General Ledger - I can select multiple accounts, but for me (Mac, 3.5) 
>> only the first selected account appears in the General Ledger Report.
>> 
>> -- 
>> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>> 
>> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
>>> 1 - As I mentioned, account codes will work for this. Assign each 
>>> account a numeric code, add the code column to the COA, and sort on it. 
>>> Done.
>>> 2 - Multicolumn reports.
>>> 3 - Are you talking about the “General Ledger” report, or the “General 
>>> Journal” report? My version of the former report (GC 3.4 under MacOX) 
>>> behaves exactly like the generic “Transaction Report” you mention 
>>> (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
>>> able to select accounts for inclusion on the report. Can you explain 
>>> more specifically what you are doing and seeing, and what you expect to 
>>> find that you are not?
>>> 
>>> David
>>> 
 On May 6, 2019, at 5:56 PM, Stephen C. Camidge  
 wrote:
 
 1) different order to reflect what I am used to seeing in other accounting 
 programs
 
 2) I agree that comparative reports would be useful - other programs offer 
 them as option, the program should too
 
 3) multiple accounts in a G/L report are standard elsewhere - the 
 transaction report can do this, but the G/L detail report should.
 
 
 -- 
 Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
 
 On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
> On 5/6/2019 7:13 AM, Stephen Camidge wrote:
>> 1) I set up a new book on the Mac version of gnucash using "A Simple 
>> Checkbook". The Chart of Accounts places Income below Expenses - why? 
>> I added Top Level Accounts for Liabilities and it was put below 
>> Income.  The Transaction Report shows Income below Expenses.  How do I 
>> change the order?
> Collating sequence ( L > I)   Just curious, but why do you want a 
> different order?
> 
>> 2) Income Statement show the selected period in the right order but 
>> cannot show columns by month. Same with Profit and Loss. Transaction 
>> report can, but in the wrong order (see 1).
> You are asking for a series of "Income Statement" reports for 
> consecutive periods displayed side by side (each P aka Statement of 
> Revenues and Expenses < what called depends on entity, same report >. In 
> other words, EACH has a defined start and end date since this report is 
> for an interval.
> 
> To produce such a (finished) report, use an editor capable of supporting 
> columns and export each, then bring into its proper column. WHY not 
> "within" gnucash? Stop a moment and think. Think of all the possible 
> variations that would be wanted (how many to show in parallel, somebody 
> else might want quarters or years, not months). Think about the after 
> editing required (the CoA might have had changes, not exactly the same 
> in each interval).
> 
> BTW -- since I keep books for non-profits, usually doing two years in 
> parallel
> 
>> 
>> 3) G/L report shows one account only, no matter how many I select. 
>> Transaction Report can select all.
> Why would you expect different reports to be the same in this regard?
> 
> Michael D Novack
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
 ___
 gnucash-user mailing list
 gnucash-user@gnucash.org
 To update your subscription preferences or to unsubscribe:
 

Re: [GNC] Questions

[Michael or Penny Novack]

On 5/6/2019 8:22 AM, Stephen C. Camidge wrote:



3 - G/L is General Ledger



Ah. being misled by the name of the report.

This is a situation where useful to understand how traditional pen and 
ink on paper bookkeeping worked. You FIRST entered transactions in 
chronological order into a "book" called the Journal. These entries were 
then "posted" to the Ledger (to the ledger accounts affected).


Gnucash allows us to enter the transactions beginning in any of the 
affected ledger accounts. We don't even see something resembling a 
journal entry unless entering a "split transaction". In other words, the 
journal is virtual.


But gnucash CAN show you the journal if you ask it to. As a report. Your 
problem is with your expectation of what you are looking at when you ask 
gnucash to give you a G/L or General Journal report.


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] Questions

[David T. via gnucash-user]

2 - Multicolumn reports are already part of GnuCash.
3 - I just loaded 3.5, ran the G/L report, selected a random set of disjoint 
accounts, and received sane results. Is it possible that when you attempted to 
select multiple accounts, you actually selected only the last account you 
clicked? Many’s the time that I have thought I had the Command key held down, 
only to discover that I’d succeeded in picking only that last account…


David

> On May 6, 2019, at 6:15 PM, Stephen C. Camidge  wrote:
> 
> 1) OK
> 
> 2) yes - this would be most useful
> 
> 3) General Ledger - I can select multiple accounts, but for me (Mac, 3.5) 
> only the first selected account appears in the General Ledger Report.
> 
> -- 
> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> 
> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
>> 1 - As I mentioned, account codes will work for this. Assign each 
>> account a numeric code, add the code column to the COA, and sort on it. 
>> Done.
>> 2 - Multicolumn reports.
>> 3 - Are you talking about the “General Ledger” report, or the “General 
>> Journal” report? My version of the former report (GC 3.4 under MacOX) 
>> behaves exactly like the generic “Transaction Report” you mention 
>> (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
>> able to select accounts for inclusion on the report. Can you explain 
>> more specifically what you are doing and seeing, and what you expect to 
>> find that you are not?
>> 
>> David
>> 
>>> On May 6, 2019, at 5:56 PM, Stephen C. Camidge  wrote:
>>> 
>>> 1) different order to reflect what I am used to seeing in other accounting 
>>> programs
>>> 
>>> 2) I agree that comparative reports would be useful - other programs offer 
>>> them as option, the program should too
>>> 
>>> 3) multiple accounts in a G/L report are standard elsewhere - the 
>>> transaction report can do this, but the G/L detail report should.
>>> 
>>> 
>>> -- 
>>> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>>> 
>>> On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
 On 5/6/2019 7:13 AM, Stephen Camidge wrote:
> 1) I set up a new book on the Mac version of gnucash using "A Simple 
> Checkbook". The Chart of Accounts places Income below Expenses - why? 
> I added Top Level Accounts for Liabilities and it was put below 
> Income.  The Transaction Report shows Income below Expenses.  How do I 
> change the order?
 Collating sequence ( L > I)   Just curious, but why do you want a 
 different order?
 
> 2) Income Statement show the selected period in the right order but 
> cannot show columns by month. Same with Profit and Loss. Transaction 
> report can, but in the wrong order (see 1).
 You are asking for a series of "Income Statement" reports for 
 consecutive periods displayed side by side (each P aka Statement of 
 Revenues and Expenses < what called depends on entity, same report >. In 
 other words, EACH has a defined start and end date since this report is 
 for an interval.
 
 To produce such a (finished) report, use an editor capable of supporting 
 columns and export each, then bring into its proper column. WHY not 
 "within" gnucash? Stop a moment and think. Think of all the possible 
 variations that would be wanted (how many to show in parallel, somebody 
 else might want quarters or years, not months). Think about the after 
 editing required (the CoA might have had changes, not exactly the same 
 in each interval).
 
 BTW -- since I keep books for non-profits, usually doing two years in 
 parallel
 
> 
> 3) G/L report shows one account only, no matter how many I select. 
> Transaction Report can select all.
 Why would you expect different reports to be the same in this regard?
 
 Michael D Novack
 
 ___
 gnucash-user mailing list
 gnucash-user@gnucash.org
 To update your subscription preferences or to unsubscribe:
 https://lists.gnucash.org/mailman/listinfo/gnucash-user
 If you are using Nabble or Gmane, please see 
 https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
 -
 Please remember to CC this list on all your replies.
 You can do this by using Reply-To-List or Reply-All.
 
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see 
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> 
>> 

___
gnucash-user mailing list

Re: [GNC] Questions

[Stephen C. Camidge]

1) OK

2) yes - this would be most useful

3) General Ledger - I can select multiple accounts, but for me (Mac, 3.5) only 
the first selected account appears in the General Ledger Report.

-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
> 1 - As I mentioned, account codes will work for this. Assign each 
> account a numeric code, add the code column to the COA, and sort on it. 
> Done.
> 2 - Multicolumn reports.
> 3 - Are you talking about the “General Ledger” report, or the “General 
> Journal” report? My version of the former report (GC 3.4 under MacOX) 
> behaves exactly like the generic “Transaction Report” you mention 
> (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
> able to select accounts for inclusion on the report. Can you explain 
> more specifically what you are doing and seeing, and what you expect to 
> find that you are not?
> 
> David
> 
> > On May 6, 2019, at 5:56 PM, Stephen C. Camidge  wrote:
> > 
> > 1) different order to reflect what I am used to seeing in other accounting 
> > programs
> > 
> > 2) I agree that comparative reports would be useful - other programs offer 
> > them as option, the program should too
> > 
> > 3) multiple accounts in a G/L report are standard elsewhere - the 
> > transaction report can do this, but the G/L detail report should.
> > 
> > 
> > -- 
> > Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> > 
> > On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
> >> On 5/6/2019 7:13 AM, Stephen Camidge wrote:
> >>> 1) I set up a new book on the Mac version of gnucash using "A Simple 
> >>> Checkbook". The Chart of Accounts places Income below Expenses - why? 
> >>> I added Top Level Accounts for Liabilities and it was put below 
> >>> Income.  The Transaction Report shows Income below Expenses.  How do I 
> >>> change the order?
> >> Collating sequence ( L > I)   Just curious, but why do you want a 
> >> different order?
> >> 
> >>> 2) Income Statement show the selected period in the right order but 
> >>> cannot show columns by month. Same with Profit and Loss. Transaction 
> >>> report can, but in the wrong order (see 1).
> >> You are asking for a series of "Income Statement" reports for 
> >> consecutive periods displayed side by side (each P aka Statement of 
> >> Revenues and Expenses < what called depends on entity, same report >. In 
> >> other words, EACH has a defined start and end date since this report is 
> >> for an interval.
> >> 
> >> To produce such a (finished) report, use an editor capable of supporting 
> >> columns and export each, then bring into its proper column. WHY not 
> >> "within" gnucash? Stop a moment and think. Think of all the possible 
> >> variations that would be wanted (how many to show in parallel, somebody 
> >> else might want quarters or years, not months). Think about the after 
> >> editing required (the CoA might have had changes, not exactly the same 
> >> in each interval).
> >> 
> >> BTW -- since I keep books for non-profits, usually doing two years in 
> >> parallel
> >> 
> >>> 
> >>> 3) G/L report shows one account only, no matter how many I select. 
> >>> Transaction Report can select all.
> >> Why would you expect different reports to be the same in this regard?
> >> 
> >> Michael D Novack
> >> 
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see 
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >> 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> 
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Questions

[David T. via gnucash-user]

1 - As I mentioned, account codes will work for this. Assign each account a 
numeric code, add the code column to the COA, and sort on it. Done.
2 - Multicolumn reports.
3 - Are you talking about the “General Ledger” report, or the “General Journal” 
report? My version of the former report (GC 3.4 under MacOX) behaves exactly 
like the generic “Transaction Report” you mention (indeed, I suspect that under 
the hood, that’s what it is). IOW, I am able to select accounts for inclusion 
on the report. Can you explain more specifically what you are doing and seeing, 
and what you expect to find that you are not?

David

> On May 6, 2019, at 5:56 PM, Stephen C. Camidge  wrote:
> 
> 1) different order to reflect what I am used to seeing in other accounting 
> programs
> 
> 2) I agree that comparative reports would be useful - other programs offer 
> them as option, the program should too
> 
> 3) multiple accounts in a G/L report are standard elsewhere - the transaction 
> report can do this, but the G/L detail report should.
> 
> 
> -- 
> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> 
> On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
>> On 5/6/2019 7:13 AM, Stephen Camidge wrote:
>>> 1) I set up a new book on the Mac version of gnucash using "A Simple 
>>> Checkbook". The Chart of Accounts places Income below Expenses - why? 
>>> I added Top Level Accounts for Liabilities and it was put below 
>>> Income.  The Transaction Report shows Income below Expenses.  How do I 
>>> change the order?
>> Collating sequence ( L > I)   Just curious, but why do you want a 
>> different order?
>> 
>>> 2) Income Statement show the selected period in the right order but 
>>> cannot show columns by month. Same with Profit and Loss. Transaction 
>>> report can, but in the wrong order (see 1).
>> You are asking for a series of "Income Statement" reports for 
>> consecutive periods displayed side by side (each P aka Statement of 
>> Revenues and Expenses < what called depends on entity, same report >. In 
>> other words, EACH has a defined start and end date since this report is 
>> for an interval.
>> 
>> To produce such a (finished) report, use an editor capable of supporting 
>> columns and export each, then bring into its proper column. WHY not 
>> "within" gnucash? Stop a moment and think. Think of all the possible 
>> variations that would be wanted (how many to show in parallel, somebody 
>> else might want quarters or years, not months). Think about the after 
>> editing required (the CoA might have had changes, not exactly the same 
>> in each interval).
>> 
>> BTW -- since I keep books for non-profits, usually doing two years in 
>> parallel
>> 
>>> 
>>> 3) G/L report shows one account only, no matter how many I select. 
>>> Transaction Report can select all.
>> Why would you expect different reports to be the same in this regard?
>> 
>> Michael D Novack
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Questions

[Stephen C. Camidge]

1) different order to reflect what I am used to seeing in other accounting 
programs

2) I agree that comparative reports would be useful - other programs offer them 
as option, the program should too

3) multiple accounts in a G/L report are standard elsewhere - the transaction 
report can do this, but the G/L detail report should.


-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
> On 5/6/2019 7:13 AM, Stephen Camidge wrote:
> > 1) I set up a new book on the Mac version of gnucash using "A Simple 
> > Checkbook". The Chart of Accounts places Income below Expenses - why? 
> > I added Top Level Accounts for Liabilities and it was put below 
> > Income.  The Transaction Report shows Income below Expenses.  How do I 
> > change the order?
> Collating sequence ( L > I)   Just curious, but why do you want a 
> different order?
> 
> > 2) Income Statement show the selected period in the right order but 
> > cannot show columns by month. Same with Profit and Loss. Transaction 
> > report can, but in the wrong order (see 1).
> You are asking for a series of "Income Statement" reports for 
> consecutive periods displayed side by side (each P aka Statement of 
> Revenues and Expenses < what called depends on entity, same report >. In 
> other words, EACH has a defined start and end date since this report is 
> for an interval.
> 
> To produce such a (finished) report, use an editor capable of supporting 
> columns and export each, then bring into its proper column. WHY not 
> "within" gnucash? Stop a moment and think. Think of all the possible 
> variations that would be wanted (how many to show in parallel, somebody 
> else might want quarters or years, not months). Think about the after 
> editing required (the CoA might have had changes, not exactly the same 
> in each interval).
> 
> BTW -- since I keep books for non-profits, usually doing two years in 
> parallel
> 
> >
> > 3) G/L report shows one account only, no matter how many I select. 
> > Transaction Report can select all.
> Why would you expect different reports to be the same in this regard?
> 
> Michael D Novack
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Questions

[Stephen C. Camidge]

2 - The Transaction Report is a workaround, but does not give a subtotal for 
income and a subtotal for expenses.

3 - G/L is General Ledger


--
Stephen C. Camidge scami...@fastmail.fm (519) 363-3912




On Mon, May 6, 2019, at 7:47 AM, David T. wrote:
> 1 - it's alphabetical. You could rename the accounts with numeric prefixes or 
> use account codes and story on them. 
> 
> 2 - the income statement isn't set up to accommodate those breakdowns. You 
> might try creating a multi column report with income statements for different 
> time periods.
> 
> 3 - don't even know what "G/L" stands for here, so can't help. 
> 
> David
> 
> 
> 
>> On Mon, May 6, 2019 at 16:44, Stephen Camidge
>>  wrote:
>> 1) I set up a new book on the Mac version of gnucash using "A Simple 
>> Checkbook". The Chart of Accounts places Income below Expenses - why? I 
>> added Top Level Accounts for Liabilities and it was put below Income. 
>> The Transaction Report shows Income below Expenses. How do I change the 
>> order?
>> 
>> 2) Income Statement show the selected period in the right order but 
>> cannot show columns by month. Same with Profit and Loss. Transaction 
>> report can, but in the wrong order (see 1).
>> 
>> 3) G/L report shows one account only, no matter how many I select. 
>> Transaction Report can select all.
>> 
>> What am I missing?
>> 
>> Thank you.
>> 
>> 
>> 
>> 
>> 
>> ___
>> 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] Questions

[Michael or Penny Novack]

On 5/6/2019 7:13 AM, Stephen Camidge wrote:
1) I set up a new book on the Mac version of gnucash using "A Simple 
Checkbook". The Chart of Accounts places Income below Expenses - why? 
I added Top Level Accounts for Liabilities and it was put below 
Income.  The Transaction Report shows Income below Expenses.  How do I 
change the order?
Collating sequence ( L > I)   Just curious, but why do you want a 
different order?


2) Income Statement show the selected period in the right order but 
cannot show columns by month. Same with Profit and Loss. Transaction 
report can, but in the wrong order (see 1).
You are asking for a series of "Income Statement" reports for 
consecutive periods displayed side by side (each P aka Statement of 
Revenues and Expenses < what called depends on entity, same report >. In 
other words, EACH has a defined start and end date since this report is 
for an interval.


To produce such a (finished) report, use an editor capable of supporting 
columns and export each, then bring into its proper column. WHY not 
"within" gnucash? Stop a moment and think. Think of all the possible 
variations that would be wanted (how many to show in parallel, somebody 
else might want quarters or years, not months). Think about the after 
editing required (the CoA might have had changes, not exactly the same 
in each interval).


BTW -- since I keep books for non-profits, usually doing two years in 
parallel




3) G/L report shows one account only, no matter how many I select. 
Transaction Report can select all.

Why would you expect different reports to be the same in this regard?

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] Questions

[David T. via gnucash-user]

1 - it's alphabetical. You could rename the accounts with numeric prefixes or 
use account codes and story on them. 
2 - the income statement isn't set up to accommodate those breakdowns. You 
might try creating a multi column report with income statements for different 
time periods.
3 - don't even know what "G/L" stands for here, so can't help. 
David

 
 
  On Mon, May 6, 2019 at 16:44, Stephen Camidge wrote:   
1) I set up a new book on the Mac version of gnucash using "A Simple 
Checkbook". The Chart of Accounts places Income below Expenses - why? I 
added Top Level Accounts for Liabilities and it was put below Income.  
The Transaction Report shows Income below Expenses.  How do I change the 
order?

2) Income Statement show the selected period in the right order but 
cannot show columns by month. Same with Profit and Loss. Transaction 
report can, but in the wrong order (see 1).

3) G/L report shows one account only, no matter how many I select. 
Transaction Report can select all.

What am I missing?

Thank you.





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