Re: [GNC] General Ledger Report Request

[Stan Brown (using GC 4.14)]

On 2024-06-13 14:04, John Ralls wrote:
> The one thing we can’t do is pagination, it’s not something that HTML is 
> capable of.

HTML as such, you're correct. But CSS is capable of formatting pages,
though my attempts in non-GnuCash contexts didn't come out well.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
___
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] General Ledger Report Request

[John Ralls]

Have you explored Reports>Assets & Liabilities>General Ledger? It’s pretty 
thoroughly configurable, I’d think you can get almost everything you want out 
of it. The one thing we can’t do is pagination, it’s not something that HTML is 
capable of.

Regards,
John Ralls


> On Jun 13, 2024, at 1:17 PM, Sara-Jayne Slocombe  
> wrote:
> 
> I would like to echo Bruce's request for a General Ledger report. This is
> incredibly useful when trying to trace what's happened when things go wrong
> or reports give results you don't expect.
> 
> Bruce, you're right, when using T-tables with pencil and paper, the totals
> are at the bottom (or whenever you close off a period). However, most
> accounting software does provide the option for a running balance column
> alongside the debit and credit columns, which can be quite useful.
> 
> I am brand new to GnuCash, so will be delighted if anyone corrects Bruce
> and I and tells us this already exists.
> 
> Many thanks,
> Sara-Jayne
> 
> 
> On Thu, Jun 13, 2024 at 5:00 PM  wrote:
> 
>> 
>> 
>> Message: 1
>> Date: Wed, 12 Jun 2024 14:56:28 -0600
>> From: Bruce Irving 
>> To: gnucash-user@gnucash.org
>> Subject: Re: [GNC] gnucash-user Digest, Vol 255, Issue 13
>> Message-ID:
>>   > gaeftg6c...@mail.gmail.com>
>> Content-Type: text/plain; charset="UTF-8"
>> 
>> 
>> There is one feature I would like to see, though I doubt many would have a
>> use for it.  I learned bookkeeping BC (Before Computer) so I learned the
>> paper/pencil method.  I wish there was a report that would let me print a
>> General Journal much like what appears on screen for a particular period.
>> I would also like to print the various active accounts: Date GL 1st
>> Description, with debit and credit columns.  While I would like a running
>> balance, I believe the proper way was totals at the bottom.  Oh, and each
>> account would be its own page(s).
>> 
> ___
> 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] General Ledger Report Request

[Sara-Jayne Slocombe]

I would like to echo Bruce's request for a General Ledger report. This is
incredibly useful when trying to trace what's happened when things go wrong
or reports give results you don't expect.

Bruce, you're right, when using T-tables with pencil and paper, the totals
are at the bottom (or whenever you close off a period). However, most
accounting software does provide the option for a running balance column
alongside the debit and credit columns, which can be quite useful.

I am brand new to GnuCash, so will be delighted if anyone corrects Bruce
and I and tells us this already exists.

Many thanks,
Sara-Jayne


On Thu, Jun 13, 2024 at 5:00 PM  wrote:

>
>
> Message: 1
> Date: Wed, 12 Jun 2024 14:56:28 -0600
> From: Bruce Irving 
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] gnucash-user Digest, Vol 255, Issue 13
> Message-ID:
>  gaeftg6c...@mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
>
> There is one feature I would like to see, though I doubt many would have a
> use for it.  I learned bookkeeping BC (Before Computer) so I learned the
> paper/pencil method.  I wish there was a report that would let me print a
> General Journal much like what appears on screen for a particular period.
> I would also like to print the various active accounts: Date GL 1st
> Description, with debit and credit columns.  While I would like a running
> balance, I believe the proper way was totals at the bottom.  Oh, and each
> account would be its own page(s).
>
___
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] General Ledger amounts missing

[Geert Janssens]

If I remember correctly the General ledger only shows the last 30 days of 
transactions. You 
can use Edit->Filter by... to change that.

Regards,

Geert

Op vrijdag 5 november 2021 16:22:14 CET schreef Sharon Sydnor:
> Gyle, yes thank you I considered that and did set the correct start and end
> dates and also thought to look to the PREFERENCES of the entire program and
> there is a place there to also set the start and end dates and select if
> they are RELATIVE or ABSOLUTE, and I chose the latter.  I’ll change to
> relative and see if it makes a difference although I don’t understand why
> it would.  Also since I do my books “at one sitting” and block out a period
> of time and work straight through from Jan to Dec of usually the former
> year, I change the date and time on the entire computer as well,  setting
> it back to Dec 31 of the required year. Sharon
> 
> Sent from my iPhone
> 
> > On Nov 4, 2021, at 10:17 PM, Adrian Yong 
> > wrote:
> > 
> > 
> > Hi All,
> > 
> > I have raised this detail before...
> > 
> > It was explained to me that the normal General Ledger which classified
> > Assets, Liabilities, and Proprietorship with their total amounts so that
> > the auditor can be sure that A = L + P is observed but GNUCash works on a
> > double entry system so A = L + P will always be observed. However,
> > sometimes an entry may be a negative Asset instead of being a positive
> > Liability and this is not so easily picked up without a normal General
> > Ledger...
> > 
> > I have downloaded the General Ledger or Transaction Report and created my
> > normal GL using Excel.
> > 
> > Regards,
> > Adrian
> > 
> >> On Fri, Nov 5, 2021 at 10:23 AM Gyle McCollam  wrote:
> >> Sharon, not sure, but the simple answer seems to be that under "edit
> >> report options" you didn't change the start and end dates.  The reports
> >> default to the current accounting period and you need the start and end
> >> of the year.  Hope this helps.
> >> 
> >> 
> >> Thank You,
> >> Gyle McCollam
> >> 
> >> Gyle McCollam
> >> 
> >> 609.680.2326 Mobile
> >> 
> >> gmccol...@live.com   email
> >> 
> >> 
> >> From: gnucash-user  on
> >> behalf of sydnorbill...@bellsouth.net 
> >> Sent: Thursday, November 4, 2021 7:05 PM
> >> To: gnucash-user@gnucash.org 
> >> Subject: [GNC] General Ledger amounts missing
> >> 
> >> Relative newbie, even though using gnucash for four years, but only use
> >> it
> >> once a year to prepare for tax filing and by the next time filing comes
> >> around the following year I forget a lot of how it worked.
> >> 
> >> 
> >> 
___
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] General Ledger amounts missing

[Michael or Penny Novack]

On 11/5/2021 11:22 AM, Sharon Sydnor wrote:

Gyle, yes thank you I considered that and did set the correct start and end 
dates and also thought to look to the PREFERENCES of the entire program and 
there is a place there to also set the start and end dates and select if they 
are RELATIVE or ABSOLUTE, and I chose the latter.  I’ll change to relative and 
see if it makes a difference although I don’t understand why it would.  Also 
since I do my books “at one sitting” and block out a period of time and work 
straight through from Jan to Dec of usually the former year, I change the date 
and time on the entire computer as well,  setting it back to Dec 31 of the 
required year.
Sharon

I think it might help clarify things if instead of referring to gnucash 
report names you said what reports you wanted in terms of their standard 
accounting names. Thus a "balance sheet" report has a DATE associated 
with it (the :as of" date) while a "statement of income and expenses" 
would have a DATE RANGE (start and stop date of the interval.


BUT --- "I change the date and time on the entire computer as well" is 
not needed. Like most accounting software, gnucash does NOT assume 
either data entry of transactions nor dates for reports are in "real 
time'. You SPECIFY the date/dates.


One oddity that MIGHT be tripping you up is that with gnucash specify 
dates for reports only after they exist! In other words, you first "run" 
the report with whatever default dates present and then use the "edit 
report options" to change things like the effective date (and 
formatting, etc.) This might seem like extra work but ensures that you 
explicitly set dates, etc. instead of forgetting this and mistakenly 
having the dates form the last time being used.


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] General Ledger amounts missing

[Sharon Sydnor]

Gyle, yes thank you I considered that and did set the correct start and end 
dates and also thought to look to the PREFERENCES of the entire program and 
there is a place there to also set the start and end dates and select if they 
are RELATIVE or ABSOLUTE, and I chose the latter.  I’ll change to relative and 
see if it makes a difference although I don’t understand why it would.  Also 
since I do my books “at one sitting” and block out a period of time and work 
straight through from Jan to Dec of usually the former year, I change the date 
and time on the entire computer as well,  setting it back to Dec 31 of the 
required year.  
Sharon 

Sent from my iPhone

> On Nov 4, 2021, at 10:17 PM, Adrian Yong  wrote:
> 
> 
> Hi All,
> 
> I have raised this detail before...
> 
> It was explained to me that the normal General Ledger which classified 
> Assets, Liabilities, and Proprietorship with their total amounts so that the 
> auditor can be sure that A = L + P is observed but GNUCash works on a double 
> entry system so A = L + P will always be observed. However, sometimes an 
> entry may be a negative Asset instead of being a positive Liability and this 
> is not so easily picked up without a normal General Ledger...
> 
> I have downloaded the General Ledger or Transaction Report and created my 
> normal GL using Excel.
> 
> Regards,
> Adrian
> 
>> On Fri, Nov 5, 2021 at 10:23 AM Gyle McCollam  wrote:
>> Sharon, not sure, but the simple answer seems to be that under "edit report 
>> options" you didn't change the start and end dates.  The reports default to 
>> the current accounting period and you need the start and end of the year.  
>> Hope this helps.
>> 
>> 
>> Thank You,
>> Gyle McCollam
>> 
>> Gyle McCollam
>> 
>> 609.680.2326 Mobile
>> 
>> gmccol...@live.com   email
>> 
>> 
>> From: gnucash-user  on 
>> behalf of sydnorbill...@bellsouth.net 
>> Sent: Thursday, November 4, 2021 7:05 PM
>> To: gnucash-user@gnucash.org 
>> Subject: [GNC] General Ledger amounts missing
>> 
>> Relative newbie, even though using gnucash for four years, but only use it
>> once a year to prepare for tax filing and by the next time filing comes
>> around the following year I forget a lot of how it worked.
>> 
>> 
>> 
>> In trying to print out a General Ledger report, after selecting reports and
>> General Ledger under Assets & Liabilities, then going to options and
>> selecting the obvious under GENERAL, then DISPLAY, and ACCOUNTS when I click
>> OK, the report that comes up has NO AMOUNTS on it?
>> 
>> 
>> 
>> What simple item am I missing?
>> 
>> 
>> 
>> Sharon
>> 
>> 
>> 
>> ___
>> 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] General Ledger amounts missing

[Adrian Yong]

Hi All,

I have raised this detail before...

It was explained to me that the normal General Ledger which classified
Assets, Liabilities, and Proprietorship with their total amounts so that
the auditor can be sure that A = L + P is observed but GNUCash works on a
double entry system so A = L + P will always be observed. However,
sometimes an entry may be a negative Asset instead of being a positive
Liability and this is not so easily picked up without a normal General
Ledger...

I have downloaded the General Ledger or Transaction Report and created my
normal GL using Excel.

Regards,
Adrian

On Fri, Nov 5, 2021 at 10:23 AM Gyle McCollam  wrote:

> Sharon, not sure, but the simple answer seems to be that under "edit
> report options" you didn't change the start and end dates.  The reports
> default to the current accounting period and you need the start and end of
> the year.  Hope this helps.
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com   email
>
> 
> From: gnucash-user  on
> behalf of sydnorbill...@bellsouth.net 
> Sent: Thursday, November 4, 2021 7:05 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] General Ledger amounts missing
>
> Relative newbie, even though using gnucash for four years, but only use it
> once a year to prepare for tax filing and by the next time filing comes
> around the following year I forget a lot of how it worked.
>
>
>
> In trying to print out a General Ledger report, after selecting reports and
> General Ledger under Assets & Liabilities, then going to options and
> selecting the obvious under GENERAL, then DISPLAY, and ACCOUNTS when I
> click
> OK, the report that comes up has NO AMOUNTS on it?
>
>
>
> What simple item am I missing?
>
>
>
> Sharon
>
>
>
> ___
> 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] General Ledger amounts missing

[Gyle McCollam]

Sharon, not sure, but the simple answer seems to be that under "edit report 
options" you didn't change the start and end dates.  The reports default to the 
current accounting period and you need the start and end of the year.  Hope 
this helps.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user  on 
behalf of sydnorbill...@bellsouth.net 
Sent: Thursday, November 4, 2021 7:05 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] General Ledger amounts missing

Relative newbie, even though using gnucash for four years, but only use it
once a year to prepare for tax filing and by the next time filing comes
around the following year I forget a lot of how it worked.



In trying to print out a General Ledger report, after selecting reports and
General Ledger under Assets & Liabilities, then going to options and
selecting the obvious under GENERAL, then DISPLAY, and ACCOUNTS when I click
OK, the report that comes up has NO AMOUNTS on it?



What simple item am I missing?



Sharon



___
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] General Ledger

[Adrien Monteleone]

The file does contain CSV data. The extension doesn’t change that. It affects 
how *some* operating systems detect that fact.

By all means, file an RFE.

The present method is the most versatile for *all* users. It does require the 
user to know some basics of their computer though.

There’s a valid question of the cost-benefit between holding a user’s hand, 
general usability, and more code to maintain.

Maybe it will get added, maybe not. If the current dev team doesn’t pick it up, 
that doesn’t stop someone else from contributing.

Regards,
Adrien

> On Mar 30, 2020 w14d90, at 11:28 AM, Kenneth Schneider 
>  wrote:
> 
> When a GNUcash user requests that data be exported to an “CSV” file the 
> expectation is that the file contents will indeed contain “CSV” data. 
> Therefore I see no reason for omitting the “.csv” file extension.
> 
> Just my 2¢
> 
> Ken Schneider

___
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] General Ledger

[Kenneth Schneider]

When a GNUcash user requests that data be exported to an “CSV” file the 
expectation is that the file contents will indeed contain “CSV” data. Therefore 
I see no reason for omitting the “.csv” file extension.

Just my 2¢

Ken Schneider 

> On Mar 30, 2020, at 12:15 PM, Adrien Monteleone 
>  wrote:
> 
> I hadn’t noticed since most of my files have extensions anyway, but indeed, 
> I just tested a markdown file by removing the extension. It changed the 
> association from Atom to TextEdit, but couldn’t open it. (Something about 
> UTF-8 not being applicable. ?? Really ?? Opening with Atom worked fine 
> though.)
> 
> Preview doesn’t work either as noted.
> 
> Thanks for the info.
> 
> Regards,
> Adrien
> 
>>> On Mar 29, 2020 w14d89, at 10:17 PM, John Ralls  wrote:
>>> 
>>> 
>>> 
 On Mar 29, 2020, at 4:52 PM, Adrien Monteleone 
  wrote:
>>> 
>>> Linux and Mac don’t generally care if a file has an extension. They 
>>> determine the file type independent of it.
>> 
>> That's sadly no longer true of MacOS and hasn't been since IIRC 10.7. The 
>> pre-NeXTStep MacOS used a extended attribute to determine file type and the 
>> early versions of Mac OS X continued the practice. Support for that was 
>> deprecated in 10.6 and while not formally removed it seemed to stop working 
>> in 10.7. There is limited support for determining file type from the command 
>> line by looking at the file header, but Finder can't do that. File type 
>> displayed in Finder, application associations, and QuickLook  display of 
>> files is all driven by the extension.
>> 
>> Regards,
>> John Ralls
>> 
>> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
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] General Ledger

[Adrien Monteleone]

I hadn’t noticed since most of my files have extensions anyway, but indeed, I 
just tested a markdown file by removing the extension. It changed the 
association from Atom to TextEdit, but couldn’t open it. (Something about UTF-8 
not being applicable. ?? Really ?? Opening with Atom worked fine though.)

Preview doesn’t work either as noted.

Thanks for the info.

Regards,
Adrien

> On Mar 29, 2020 w14d89, at 10:17 PM, John Ralls  wrote:
> 
> 
> 
>> On Mar 29, 2020, at 4:52 PM, Adrien Monteleone 
>>  wrote:
>> 
>> Linux and Mac don’t generally care if a file has an extension. They 
>> determine the file type independent of it.
> 
> That's sadly no longer true of MacOS and hasn't been since IIRC 10.7. The 
> pre-NeXTStep MacOS used a extended attribute to determine file type and the 
> early versions of Mac OS X continued the practice. Support for that was 
> deprecated in 10.6 and while not formally removed it seemed to stop working 
> in 10.7. There is limited support for determining file type from the command 
> line by looking at the file header, but Finder can't do that. File type 
> displayed in Finder, application associations, and QuickLook  display of 
> files is all driven by the extension.
> 
> Regards,
> John Ralls
> 
> 


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

Re: [GNC] General Ledger

[Michael or Penny Novack]

On 3/29/2020 7:12 PM, Adrian Yong wrote:

Hi Michael,

*_Your Point No. 5 is interesting._*

Gnucash's instruction is Export X to csv. One would be led to 
believe that the file type is automatically csv. But in reality, you 
are saying that it can export to any format provided you specify the 
file type as an extension to the filename.


All your other comments are relevant if we get this file type 
specification step correct.


Regards,
Adrian


You misunderstand.  A file extension "announces" what the data type of a 
file is. It does NOT make it so. And "type" can be understood at many 
levels. Thus .csv stands for "comma separated variables" which would be 
a description of the data at a lowish level, a series of ":records" each 
consisting of a number of fields with the comma as the delineator" 
between the fields. It does NOT specify the meaning of this data. Thus 
that COULD be data that would make sense if used in a spreadsheet but 
could also be data that would not.


ANY file can be considered at the lowest level as type "binary". When a 
file has extension .exe that is telling the computer that the file 
should be an executable program. But "run" isn't the only thing I might 
do with a program. People like myself who could read machine code might 
want to  examine it (open under the control of a hex editor).


So back to what you started with, gnucash can export to some file types, 
in this case.csv AND it so happens that this comma separated data would 
make sense if opened by a spreadsheet application. That application 
MIGHT be MS Excel. It might also be somebody else's spreadsheet app. I 
will repeat, ALL that a file extension is doing is telling your computer 
what to do with an object when you double click it IF you have created 
an association between that file extension and the app << you tell your 
machine "with this extension use that app"  if you have never done 
this you are probably using just default associations. Thus Microsoft 
wants you to use their products so Windows comes with defaults set that 
way. The don't want you to know you have a choice >>


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] General Ledger

[John Ralls]

> On Mar 29, 2020, at 4:52 PM, Adrien Monteleone 
>  wrote:
> 
> Linux and Mac don’t generally care if a file has an extension. They determine 
> the file type independent of it.

That's sadly no longer true of MacOS and hasn't been since IIRC 10.7. The 
pre-NeXTStep MacOS used a extended attribute to determine file type and the 
early versions of Mac OS X continued the practice. Support for that was 
deprecated in 10.6 and while not formally removed it seemed to stop working in 
10.7. There is limited support for determining file type from the command line 
by looking at the file header, but Finder can't do that. File type displayed in 
Finder, application associations, and QuickLook  display of files is all driven 
by the extension.

Regards,
John Ralls

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

Re: [GNC] General Ledger

[Adrian Yong]

My reply below in red bold letters.

On Mon, Mar 30, 2020 at 7:53 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> No, it is a csv, but you have the option to specify an extension or not.
>
> Linux and Mac don’t generally care if a file has an extension. They
> determine the file type independent of it.
>

*Ok... Point noted.*

>
> Windows on the other hand does rely somewhat (if not exclusively) on the
> extension. (not sure if that changed in Win10 or not)
>
> *I am using Win10*


> You don’t always have to have an extension in Windows, but that means you
> can’t double-click a file to open it with the proper app.
>
> You can’t change the file type as you found, (as reported by Windows) but
> you can add or change the extension. Windows will then use the extension to
> determine the file type and associate a default app to open it.
>
> As an experiment, take that same file and change the extension to “.txt”,
> and Windows will now report it as a text file type and open it with your
> default plain text editor. (probably Notepad)
>
> Then change it to “.xls” and observe how Windows changes the type again,
> and what app it associates with it.
>
> *note - a ‘csv’ file (for Comma Separated Values) *is* a plain text file
> with each line a list of values separated by comma. (or other character as
> you happened to designate in the export dialog) Some apps that read csv
> will accept any separator or let you specify on import. Some choke on
> anything but a comma. GnuCash gives you the flexibility to choose what you
> need.
>
> The problem you found isn’t a problem with GnuCash, it is a limitation of
> how the Windows OS recognizes files.
>

*Point taken.*

>
> Regards,
> Adrien
>
>
> > On Mar 29, 2020 w14d89, at 6:12 PM, Adrian Yong <
> adrianyong.88p...@gmail.com> wrote:
> >
> > Hi Michael,
> >
> > *Your Point No. 5 is interesting.*
> >
> > Gnucash's instruction is Export X to csv. One would be led to believe
> > that the file type is automatically csv. But in reality, you are saying
> > that it can export to any format provided you specify the file type as an
> > extension to the filename.
> >
> > All your other comments are relevant if we get this file type
> specification
> > step correct.
> >
> > Regards,
> > Adrian
> >
>
>
> ___
> 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] General Ledger

[Adrien Monteleone]

No, it is a csv, but you have the option to specify an extension or not.

Linux and Mac don’t generally care if a file has an extension. They determine 
the file type independent of it.

Windows on the other hand does rely somewhat (if not exclusively) on the 
extension. (not sure if that changed in Win10 or not)

You don’t always have to have an extension in Windows, but that means you can’t 
double-click a file to open it with the proper app.

You can’t change the file type as you found, (as reported by Windows) but you 
can add or change the extension. Windows will then use the extension to 
determine the file type and associate a default app to open it.

As an experiment, take that same file and change the extension to “.txt”, and 
Windows will now report it as a text file type and open it with your default 
plain text editor. (probably Notepad)

Then change it to “.xls” and observe how Windows changes the type again, and 
what app it associates with it.

*note - a ‘csv’ file (for Comma Separated Values) *is* a plain text file with 
each line a list of values separated by comma. (or other character as you 
happened to designate in the export dialog) Some apps that read csv will accept 
any separator or let you specify on import. Some choke on anything but a comma. 
GnuCash gives you the flexibility to choose what you need.

The problem you found isn’t a problem with GnuCash, it is a limitation of how 
the Windows OS recognizes files.

Regards,
Adrien


> On Mar 29, 2020 w14d89, at 6:12 PM, Adrian Yong  
> wrote:
> 
> Hi Michael,
> 
> *Your Point No. 5 is interesting.*
> 
> Gnucash's instruction is Export X to csv. One would be led to believe
> that the file type is automatically csv. But in reality, you are saying
> that it can export to any format provided you specify the file type as an
> extension to the filename.
> 
> All your other comments are relevant if we get this file type specification
> step correct.
> 
> Regards,
> Adrian
> 


___
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] General Ledger

[Adrian Yong]

Hi Michael,

*Your Point No. 5 is interesting.*

Gnucash's instruction is Export X to csv. One would be led to believe
that the file type is automatically csv. But in reality, you are saying
that it can export to any format provided you specify the file type as an
extension to the filename.

All your other comments are relevant if we get this file type specification
step correct.

Regards,
Adrian

On Mon, Mar 30, 2020 at 12:28 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 3/28/2020 11:21 PM, Adrian Yong wrote:
> > I can't change the file type...
> >
> > Neither can I access Excel by choosing Open With...
> >
> > Finally got to add file type extension .csv to filename. That worked... I
> > think gnucash should either addd anothe filetype dialog box or advise
> users
> > to add filetype extension to the filename.
> >
> > Thanks
> >
> This isn't about gnucash but general computer basics.
>
> 1) Whether a particular app can (usefully) open a file depends on the
> (actual) type of the file. As opposed to the file NAME. The extension
> that may be on the end of the name is just an IDENTIFIER that might or
> might not correctly identify the type. SOME few apps can of course open
> anything (a hex editor, for example).
>
> 2) The only thing the file extension on the end of an "object" does is
> help the system choose an app when you tell the computer "open object"
> (say by double clicking o it). If your computer does not "know" what to
> do with an object of that type it will ask you to select an application.
> In many cases it will not ask because you have chosen an app to always
> use with objects of that type or using the default app your OS uses if
> you don't choose one.
>
> 3) You can instead start the application and then tell IT to open the
> object. That doesn't require a file extension but does mean you have to
> know that the object is of a suitable type << some apps can open many
> types and I gave you an example of one that could open ANYTHING >> You
> of course have to know the name of the file you want opened.
>
> 4) You intended to open with Excel? Then although the data format is
> "comma separated variable" you could have made the file extension more
> specific to Excel like .xlsx   An .xlsx file will be in .csv format but
> the converse is not necessarily true
>
> 5) But no, gnucash should not DO this for you (offering you a reminder
> of extensions you might want to choose between another matter). Why
> should the gnucash team favor some particular commercial product? On MY
> computer, the associated app would be LibreOffice Calc and not  MS Excel.
>
> 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] General Ledger

[Michael or Penny Novack]

On 3/28/2020 11:21 PM, Adrian Yong wrote:

I can't change the file type...

Neither can I access Excel by choosing Open With...

Finally got to add file type extension .csv to filename. That worked... I
think gnucash should either addd anothe filetype dialog box or advise users
to add filetype extension to the filename.

Thanks


This isn't about gnucash but general computer basics.

1) Whether a particular app can (usefully) open a file depends on the 
(actual) type of the file. As opposed to the file NAME. The extension 
that may be on the end of the name is just an IDENTIFIER that might or 
might not correctly identify the type. SOME few apps can of course open 
anything (a hex editor, for example).


2) The only thing the file extension on the end of an "object" does is 
help the system choose an app when you tell the computer "open object" 
(say by double clicking o it). If your computer does not "know" what to 
do with an object of that type it will ask you to select an application. 
In many cases it will not ask because you have chosen an app to always 
use with objects of that type or using the default app your OS uses if 
you don't choose one.


3) You can instead start the application and then tell IT to open the 
object. That doesn't require a file extension but does mean you have to 
know that the object is of a suitable type << some apps can open many 
types and I gave you an example of one that could open ANYTHING >> You 
of course have to know the name of the file you want opened.


4) You intended to open with Excel? Then although the data format is 
"comma separated variable" you could have made the file extension more 
specific to Excel like .xlsx   An .xlsx file will be in .csv format but 
the converse is not necessarily true


5) But no, gnucash should not DO this for you (offering you a reminder 
of extensions you might want to choose between another matter). Why 
should the gnucash team favor some particular commercial product? On MY 
computer, the associated app would be LibreOffice Calc and not  MS Excel.


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] General Ledger

[Adrian Yong]

Thanks Fred...

On Sun, 29 Mar. 2020, 16:54 Fred Bone,  wrote:

> On 29 March 2020 at 10:40, Adrian Yong said:
>
> > Hi Adrien,
> >
> > Below is the screenshot... I get a file type FILE.
> >
> > [image: image.png]
>
> Because you chose to give it a plain name with no ".csv" extension.
>
> > When I double click on the file to open it, Excel is not on the list:
> >
> > [image: image.png]
>
> See above.
>
> Try renaming it so Windows knows it's supposed to be a CSV file. Or use
> "file->open" in Excel. Or ...
>
>
> ___
> 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] General Ledger

[Fred Bone]

On 29 March 2020 at 10:40, Adrian Yong said:

> Hi Adrien,
> 
> Below is the screenshot... I get a file type FILE.
> 
> [image: image.png]

Because you chose to give it a plain name with no ".csv" extension.

> When I double click on the file to open it, Excel is not on the list:
> 
> [image: image.png]

See above.

Try renaming it so Windows knows it's supposed to be a CSV file. Or use 
"file->open" in Excel. Or ...


___
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] General Ledger

[Adrian Yong]

I can't change the file type...

Neither can I access Excel by choosing Open With...

Finally got to add file type extension .csv to filename. That worked... I
think gnucash should either addd anothe filetype dialog box or advise users
to add filetype extension to the filename.

Thanks

On Sun, Mar 29, 2020 at 10:58 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> I could be mistaken, but when you save, you should be able to specify a
> file extension. If not, simply change it after the fact to “.csv” and see
> if Excel is offered as a default app to open it.
>
> Otherwise, you can still open it with Excel via the right-click menu using
> a ‘open with’ option, or, start Excel first, then try to File > Open, or
> Insert > Sheet from File operation.
>
> Regards,
> Adrien
>
> > On Mar 28, 2020 w13d88, at 9:40 PM, Adrian Yong <
> adrianyong.88p...@gmail.com> wrote:
> >
> > Hi Adrien,
> >
> > Below is the screenshot... I get a file type FILE.
> >
> > 
> >
> > When I double click on the file to open it, Excel is not on the list:
> >
> > 
> >
> > Wish is not surprising because the file is a .csv file...
> >
> > Regards,
> > Adrian
> >
>
>
> ___
> 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] General Ledger

[Adrien Monteleone]

I could be mistaken, but when you save, you should be able to specify a file 
extension. If not, simply change it after the fact to “.csv” and see if Excel 
is offered as a default app to open it.

Otherwise, you can still open it with Excel via the right-click menu using a 
‘open with’ option, or, start Excel first, then try to File > Open, or Insert > 
Sheet from File operation.

Regards,
Adrien

> On Mar 28, 2020 w13d88, at 9:40 PM, Adrian Yong  
> wrote:
> 
> Hi Adrien,
> 
> Below is the screenshot... I get a file type FILE.
> 
> 
> 
> When I double click on the file to open it, Excel is not on the list:
> 
> 
> 
> Wish is not surprising because the file is a .csv file...
> 
> Regards,
> Adrian
> 


___
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] General Ledger

[Adrien Monteleone]

CSV files can be opened in Excel or just about any spreadsheet app. There are 
also options to ‘Export Transactions’ and ‘Export Active Register”. The Account 
Tree is just a shell of a list of accounts with no transactions. I’m not 
familiar with how that is different from ‘Export Accounts’. Perhaps someone 
more knowledgeable can shed light. Honestly, an export isn’t probably all that 
useful. Reports are more likely what they are looking for.

Acrobat is for PDF files only as far as I am aware.

What *exactly* are you being asked to provide by the auditors?

What do you mean by ‘cannot be opened in MSExcel’? Are you getting a specific 
error? What is the text of the error?

Regards,
Adrien



> On Mar 28, 2020 w13d88, at 9:09 PM, Adrian Yong  
> wrote:
> 
> Hi Adrien,
> 
> I tried exporting the "Export Account Tree to csv" and "Export Accounts" 
> options.
> 
> However the exported files cannot be opened in MSExcel nor Acrobat Reader 
> DC...
> 
> Regards,
> Adrian


___
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] General Ledger

[Adrian Yong]

Hi Adrien,

I tried exporting the "Export Account Tree to csv" and "Export Accounts"
options.

However the exported files cannot be opened in MSExcel nor Acrobat Reader
DC...

Regards,
Adrian

On Thu, Mar 19, 2020 at 8:30 AM Adrian Yong 
wrote:

> Thanks Adrien..
>
> On Thu, 19 Mar. 2020, 08:29 Adrien Monteleone, <
> adrien.montele...@lusfiber.net> wrote:
>
>> If they find info is missing or they don’t care for the formats, report
>> back here and we’ll try to help you refine them.
>>
>> Regards,
>> Adrien
>>
>> > On Mar 18, 2020 w12d78, at 6:01 PM, Adrian Yong <
>> adrianyong.88p...@gmail.com> wrote:
>> >
>> > Thank you very much, Adrien, Michael and Stephen for helping me
>> understand
>> > Gnucash...
>> >
>> > I will submit the documents as suggested by Stephen and see what the
>> > auditors say... They are CPAs...
>>
>> ___
>> 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] General Ledger

[Adrian Yong]

Thanks Adrien..

On Thu, 19 Mar. 2020, 08:29 Adrien Monteleone, <
adrien.montele...@lusfiber.net> wrote:

> If they find info is missing or they don’t care for the formats, report
> back here and we’ll try to help you refine them.
>
> Regards,
> Adrien
>
> > On Mar 18, 2020 w12d78, at 6:01 PM, Adrian Yong <
> adrianyong.88p...@gmail.com> wrote:
> >
> > Thank you very much, Adrien, Michael and Stephen for helping me
> understand
> > Gnucash...
> >
> > I will submit the documents as suggested by Stephen and see what the
> > auditors say... They are CPAs...
>
> ___
> 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] General Ledger

[Adrien Monteleone]

If they find info is missing or they don’t care for the formats, report back 
here and we’ll try to help you refine them.

Regards,
Adrien

> On Mar 18, 2020 w12d78, at 6:01 PM, Adrian Yong  
> wrote:
> 
> Thank you very much, Adrien, Michael and Stephen for helping me understand
> Gnucash...
> 
> I will submit the documents as suggested by Stephen and see what the
> auditors say... They are CPAs...

___
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] General Ledger

[Adrian Yong]

Thank you very much, Adrien, Michael and Stephen for helping me understand
Gnucash...

I will submit the documents as suggested by Stephen and see what the
auditors say... They are CPAs...







On Thu, 19 Mar. 2020, 06:37 Michael or Penny Novack, <
stepbystepf...@comcast.net> wrote:

> On 3/18/2020 1:52 PM, Stephen M. Butler wrote:
> > Adrian,
> >
> > I give my CPA three items:
> >
> > 1.  Balance Sheet.
> >
> > 2.  Profit Loss statement
> >
> > 3.  Transaction Report of all transactions for the year sorted by
> > account and then by date within account.
> >
> That last is the "general ledger" (when for all accounts). As I noted
> earlier, the NAMES gnucash uses for reports can be confusing.  There
> isn't a way around this  in many cases because what some of these
> reports would be called depends on the type of entity. Thus the report
> named "Income Statement" would be called "Profit and Loss" if the entity
> is a for profit enterprise but "Statement of Revenues and Expenses" by
> an organization/non-profit.
>
> 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] General Ledger

[Michael or Penny Novack]

On 3/18/2020 1:52 PM, Stephen M. Butler wrote:

Adrian,

I give my CPA three items:

1.  Balance Sheet.

2.  Profit Loss statement

3.  Transaction Report of all transactions for the year sorted by
account and then by date within account.

That last is the "general ledger" (when for all accounts). As I noted 
earlier, the NAMES gnucash uses for reports can be confusing.  There 
isn't a way around this  in many cases because what some of these 
reports would be called depends on the type of entity. Thus the report 
named "Income Statement" would be called "Profit and Loss" if the entity 
is a for profit enterprise but "Statement of Revenues and Expenses" by 
an organization/non-profit.


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] General Ledger

[Stephen M. Butler]

On 3/17/20 8:50 PM, Adrian Yong wrote:
> Hi Adrien,
>
> Thanks for your very detailed explanation...
>
> I appreciate that we enter each transaction using the double entry system
> into the accounts.. This is almost the same as manual accounting.
>
> The problem arises when the auditors do not use Gnucash. In the manual
> system, the auditors will be provided with a General Ledger which is a
> collation of all transactions sorted into each of the accounts.
>
> If the auditors uses Gnucash, all I need to do is to furnish them with
> gnucash data file and my problem would vanish... But
>
> Regards,
> Adrian

Adrian,

I give my CPA three items:

1.  Balance Sheet.

2.  Profit Loss statement

3.  Transaction Report of all transactions for the year sorted by
account and then by date within account.

So far he hasn't complained.

--Steve

>
>
>
>
> On Wed, 18 Mar. 2020, 01:28 Adrien Monteleone, <
> adrien.montele...@lusfiber.net> wrote:
>
>> I think I understand now what you are asking.
>>
>> TLDR; your GnuCash file **is** the General Ledger. GnuCash **is not**
>> QuickBooks. QuickBooks has a separate view of the General Ledger because
>> they otherwise hide it from you.
>>
>>
>> QuickBooks in particular, hides the double-entry nature of accounting from
>> you with their home screen. They strongly urge you to enter transactions
>> via the various flow steps that they provide and they really want you to
>> use their workflow. You don’t make entries in the General Ledger, but in
>> various special entry screens. But you can make direct General Ledger
>> entries for special cases. However, they frown upon it. You can also view
>> the General Ledger separately. (but you don’t have to in order to run a P&L
>> or Balance Sheet, but that is where all QuickBooks transactions are
>> officially stored.)
>>
>> GnuCash takes the opposite approach and offers double-entry, by default.
>> You don’t need to open something special, or run a special report, you
>> *are* working directly in the various accounts that are part of the General
>> Ledger. Thus, each GnuCash file *is* the General Ledger. It is the
>> collection of all of your accounts and all transactions in them, in one
>> place. There is a summary tab labeled “Accounts” where you can see balances
>> in any account at a glance without having to open each one or run a special
>> report. There is also a General Journal, which is the pen and paper
>> equivalent of putting all transactions in one place, then later copying
>> them to the individual accounts. (but with GnuCash you don’t have to copy
>> them, you just enter them once.) Think of the various account registers as
>> subsets of the General Journal. Some (like myself) prefer to work directly
>> in various accounts. Some prefer to enter transactions into the General
>> Journal.
>>
>> An exception to this direct entry approach is the Business Features. While
>> you don’t need to use them, you can, and they offer special functions and
>> reports. If you use them, you should only make changes (with regards to
>> those individual special business transactions) via their special windows
>> rather than directly in the AR/AP accounts. But you can always view AR/AP
>> at any time. You can also have ‘Other’ AR/AP accounts and make all the
>> manual entries in them that you need. With regard to Bills and Invoices,
>> you can do those manually, or you can use the Business Features. If you do
>> so, you can’t edit the resulting transactions in Expense or Income accounts
>> directly, you have to use the Edit Bill/Invoice window to do so. (but you
>> can always view those transactions at any time, just like AR/AP by simply
>> viewing the relevant Income or Expense account, they are in fact, the same
>> transactions as what appears in AR/AP.)
>>
>>
>> Regards,
>> Adrien
>>
>>
>>
>>
>>> On Mar 17, 2020 w12d77, at 2:20 AM, Adrian Yong <
>> adrianyong.88p...@gmail.com> wrote:
>>>
>>> Adrien,
>>>
>>> In the General Ledger, every account has it history recorded and all
>> these is collated in one book called the General Ledger...
>>> As I am used to QuickBooks and manually accounting methods, the General
>> Ledger is the basis for P&L, and Balance Sheet. QuickBooks seems to emulate
>> manual accounting.
>>> Somehow, I have to generate a report on each account and collate them
>> manually into one collection..
>>> Regards,
>>> Adrian
>>>
>>> On Tue, 17 Mar. 2020, 13:39 Adrien Monteleone, <
>> adrien.montele...@lusfiber.net> wrote:
>>> If you mean you want to see the individual transaction activity in your
>> accounts related to a single customer, yes.
>>> If you just want to see the balanced owed by all customers, you can use
>> the Accounts Receivable report. (each customer can be listed separately,
>> along with a total)
>>> But both of these are entirely different things than your original
>> question. Which is quite fine, but please do clarify what it is you are
>> trying to accomplish so we can help you efficiently.
>>> Regard

Re: [GNC] General Ledger

[Adrien Monteleone]

#1, 2, are available in GnuCash and easy enough to produce.

#3 would be done as an ‘Account Report’ while viewing the General Journal. 
Recall though that you’ll have to adjust the View > Filter By to show the 
desired dates before running the report.

#4 can be accomplished as I previously noted with a Transaction Report. But as 
Michael pointed out, because the way GnuCash works, there won’t be any 
difference (other than maybe form) as to what #3 and #4 contain. As the Journal 
and Ledger are not separate things (you don’t make an entry and then transfer 
info) there won’t be any difference in the transaction info for each. You might 
have to produce each just to make the auditors happy till they learn one is 
pointless with GnuCash.

While #5 exists in GnuCash, it does not match any textbook example I’ve seen of 
such a report. If you can provide an obfuscated previous example we can advise 
if the built-in report will suffice or if you’d have to use some other report, 
or need something entirely custom.

#6 is available in GnuCash.

Also, note that GnuCash can export your data in CSV, and it is stored by 
default in XML, both of which are open formats (non-proprietary) and can 
possibly be imported by whatever software they use. (the XML is compressed by 
default, but you can set a preference to store it uncompressed, or just unzip 
it before sending) That might be an option. But the reports are certainly 
doable.

Regards,
Adrien

> On Mar 18, 2020 w12d78, at 12:59 AM, Adrian Yong 
>  wrote:
> 
> Thank you very much for your assistance.
> 
> I submit the following to the auditors:
> 
> 1) P&L
> 2) Balance Sheet
> 3) Journal
> 4) General Ledger
> 5) Funds(Cash) Flow Statement
> 6) Trial Balance
> 
> That's because they don't use QuickBooks...
> 
> Regards,
> Adrian


___
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] General Ledger

[Michael or Penny Novack]

On 3/18/2020 1:59 AM, Adrian Yong wrote:

Thank you very much for your assistance.

I submit the following to the auditors:

1) P&L
2) Balance Sheet
3) Journal
4) General Ledger
5) Funds(Cash) Flow Statement
6) Trial Balance

That's because they don't use QuickBooks...

Regards,
Adrian

All of these are standard reports, just as they were in the old pen and 
ink on paper days.


Is your question how to produce each of these when using gnucash? Keep 
in mind that in some of these cases, terminology/names may be part of 
the issue. Thus "general ledger" can refer to both the ledger* itself 
and a report of it. At least part of the problem is the names used by 
gnucash.


Michael D Novack

* The "general" in the name is because of "cash book accounting", a 
shortcut method from the old days where the :cash" account was handled 
differently from the rest << since 90+% of transactions affected cash, 
those were not journalized but entered into the special "cash" ledger 
and posted from there --- actually similar to what we do in gnucash for 
all accounts --- think "virtual journal" bookkeeping >>


In traditional pen and ink on paper all transactions initially entered 
into the "journal" and then POSTED from there to the ledger. Errors 
while posting were frequent, finding them "fun". You can think of 
gnucash as backwards auto-posting. You enter directly into the ledger 
BUT gnucash can show you the corresponding "journal" if you ask it to.



___
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] General Ledger

[Adrian Yong]

Thank you very much for your assistance.

I submit the following to the auditors:

1) P&L
2) Balance Sheet
3) Journal
4) General Ledger
5) Funds(Cash) Flow Statement
6) Trial Balance

That's because they don't use QuickBooks...

Regards,
Adrian

On Wed, 18 Mar. 2020, 13:21 Adrien Monteleone, <
adrien.montele...@lusfiber.net> wrote:

> I guess I’d have to see what QuickBooks is offering auditors then, short
> of an accountant’s copy of the file. (I have a client that uses it so I
> could investigate, but I can’t promise anything right away)
>
> Until then, I’d go the route of a Transaction Report. Play around with
> that to see if it gets you something like what you need. It has extensive
> sorting abilities. (check the Sort tab of Options)
>
> With it, you can craft a report that includes every account, sorted by
> account, and then by date, showing all transactions from the opening
> balance to the closing date of the audit trail.
>
> That’s the best I can think of at the moment.
>
> If you have some issues getting something ‘just so’ with the report, let
> us know here and we’ll see if we can help.
>
> Regards,
> Adrien
>
> > On Mar 17, 2020 w12d77, at 10:50 PM, Adrian Yong <
> adrianyong.88p...@gmail.com> wrote:
> >
> > Hi Adrien,
> >
> > Thanks for your very detailed explanation...
> >
> > I appreciate that we enter each transaction using the double entry
> system into the accounts.. This is almost the same as manual accounting.
> >
> > The problem arises when the auditors do not use Gnucash. In the manual
> system, the auditors will be provided with a General Ledger which is a
> collation of all transactions sorted into each of the accounts.
> >
> > If the auditors uses Gnucash, all I need to do is to furnish them with
> gnucash data file and my problem would vanish... But
> >
> > Regards,
> > Adrian
>
> ___
> 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] General Ledger

[Adrien Monteleone]

I guess I’d have to see what QuickBooks is offering auditors then, short of an 
accountant’s copy of the file. (I have a client that uses it so I could 
investigate, but I can’t promise anything right away)

Until then, I’d go the route of a Transaction Report. Play around with that to 
see if it gets you something like what you need. It has extensive sorting 
abilities. (check the Sort tab of Options)

With it, you can craft a report that includes every account, sorted by account, 
and then by date, showing all transactions from the opening balance to the 
closing date of the audit trail.

That’s the best I can think of at the moment.

If you have some issues getting something ‘just so’ with the report, let us 
know here and we’ll see if we can help.

Regards,
Adrien

> On Mar 17, 2020 w12d77, at 10:50 PM, Adrian Yong 
>  wrote:
> 
> Hi Adrien,
> 
> Thanks for your very detailed explanation...
> 
> I appreciate that we enter each transaction using the double entry system 
> into the accounts.. This is almost the same as manual accounting.
> 
> The problem arises when the auditors do not use Gnucash. In the manual 
> system, the auditors will be provided with a General Ledger which is a 
> collation of all transactions sorted into each of the accounts.
> 
> If the auditors uses Gnucash, all I need to do is to furnish them with 
> gnucash data file and my problem would vanish... But
> 
> Regards,
> Adrian

___
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] General Ledger

[Adrian Yong]

Hi Adrien,

Thanks for your very detailed explanation...

I appreciate that we enter each transaction using the double entry system
into the accounts.. This is almost the same as manual accounting.

The problem arises when the auditors do not use Gnucash. In the manual
system, the auditors will be provided with a General Ledger which is a
collation of all transactions sorted into each of the accounts.

If the auditors uses Gnucash, all I need to do is to furnish them with
gnucash data file and my problem would vanish... But

Regards,
Adrian





On Wed, 18 Mar. 2020, 01:28 Adrien Monteleone, <
adrien.montele...@lusfiber.net> wrote:

> I think I understand now what you are asking.
>
> TLDR; your GnuCash file **is** the General Ledger. GnuCash **is not**
> QuickBooks. QuickBooks has a separate view of the General Ledger because
> they otherwise hide it from you.
>
>
> QuickBooks in particular, hides the double-entry nature of accounting from
> you with their home screen. They strongly urge you to enter transactions
> via the various flow steps that they provide and they really want you to
> use their workflow. You don’t make entries in the General Ledger, but in
> various special entry screens. But you can make direct General Ledger
> entries for special cases. However, they frown upon it. You can also view
> the General Ledger separately. (but you don’t have to in order to run a P&L
> or Balance Sheet, but that is where all QuickBooks transactions are
> officially stored.)
>
> GnuCash takes the opposite approach and offers double-entry, by default.
> You don’t need to open something special, or run a special report, you
> *are* working directly in the various accounts that are part of the General
> Ledger. Thus, each GnuCash file *is* the General Ledger. It is the
> collection of all of your accounts and all transactions in them, in one
> place. There is a summary tab labeled “Accounts” where you can see balances
> in any account at a glance without having to open each one or run a special
> report. There is also a General Journal, which is the pen and paper
> equivalent of putting all transactions in one place, then later copying
> them to the individual accounts. (but with GnuCash you don’t have to copy
> them, you just enter them once.) Think of the various account registers as
> subsets of the General Journal. Some (like myself) prefer to work directly
> in various accounts. Some prefer to enter transactions into the General
> Journal.
>
> An exception to this direct entry approach is the Business Features. While
> you don’t need to use them, you can, and they offer special functions and
> reports. If you use them, you should only make changes (with regards to
> those individual special business transactions) via their special windows
> rather than directly in the AR/AP accounts. But you can always view AR/AP
> at any time. You can also have ‘Other’ AR/AP accounts and make all the
> manual entries in them that you need. With regard to Bills and Invoices,
> you can do those manually, or you can use the Business Features. If you do
> so, you can’t edit the resulting transactions in Expense or Income accounts
> directly, you have to use the Edit Bill/Invoice window to do so. (but you
> can always view those transactions at any time, just like AR/AP by simply
> viewing the relevant Income or Expense account, they are in fact, the same
> transactions as what appears in AR/AP.)
>
>
> Regards,
> Adrien
>
>
>
>
> > On Mar 17, 2020 w12d77, at 2:20 AM, Adrian Yong <
> adrianyong.88p...@gmail.com> wrote:
> >
> >
> > Adrien,
> >
> > In the General Ledger, every account has it history recorded and all
> these is collated in one book called the General Ledger...
> >
> > As I am used to QuickBooks and manually accounting methods, the General
> Ledger is the basis for P&L, and Balance Sheet. QuickBooks seems to emulate
> manual accounting.
> >
> > Somehow, I have to generate a report on each account and collate them
> manually into one collection..
> >
> > Regards,
> > Adrian
> >
> > On Tue, 17 Mar. 2020, 13:39 Adrien Monteleone, <
> adrien.montele...@lusfiber.net> wrote:
> > If you mean you want to see the individual transaction activity in your
> accounts related to a single customer, yes.
> >
> > If you just want to see the balanced owed by all customers, you can use
> the Accounts Receivable report. (each customer can be listed separately,
> along with a total)
> >
> > But both of these are entirely different things than your original
> question. Which is quite fine, but please do clarify what it is you are
> trying to accomplish so we can help you efficiently.
> >
> > Regards,
> > Adrien
> >
> > > On Mar 16, 2020 w12d76, at 11:47 PM, Adrian Yong <
> adrianyong.88p...@gmail.com> wrote:
> > >
> > > Hi Christopher,
> > >
> > > That means I have to generate a report for each of the accounts ie
> Cash in
> > > Bank, Trade Debtors, each customer at a time ?
> > >
> > > Regards,
> > > Adrian
>
> _

Re: [GNC] General Ledger

[Adrien Monteleone]

I think I understand now what you are asking.

TLDR; your GnuCash file **is** the General Ledger. GnuCash **is not** 
QuickBooks. QuickBooks has a separate view of the General Ledger because they 
otherwise hide it from you.


QuickBooks in particular, hides the double-entry nature of accounting from you 
with their home screen. They strongly urge you to enter transactions via the 
various flow steps that they provide and they really want you to use their 
workflow. You don’t make entries in the General Ledger, but in various special 
entry screens. But you can make direct General Ledger entries for special 
cases. However, they frown upon it. You can also view the General Ledger 
separately. (but you don’t have to in order to run a P&L or Balance Sheet, but 
that is where all QuickBooks transactions are officially stored.)

GnuCash takes the opposite approach and offers double-entry, by default. You 
don’t need to open something special, or run a special report, you *are* 
working directly in the various accounts that are part of the General Ledger. 
Thus, each GnuCash file *is* the General Ledger. It is the collection of all of 
your accounts and all transactions in them, in one place. There is a summary 
tab labeled “Accounts” where you can see balances in any account at a glance 
without having to open each one or run a special report. There is also a 
General Journal, which is the pen and paper equivalent of putting all 
transactions in one place, then later copying them to the individual accounts. 
(but with GnuCash you don’t have to copy them, you just enter them once.) Think 
of the various account registers as subsets of the General Journal. Some (like 
myself) prefer to work directly in various accounts. Some prefer to enter 
transactions into the General Journal.

An exception to this direct entry approach is the Business Features. While you 
don’t need to use them, you can, and they offer special functions and reports. 
If you use them, you should only make changes (with regards to those individual 
special business transactions) via their special windows rather than directly 
in the AR/AP accounts. But you can always view AR/AP at any time. You can also 
have ‘Other’ AR/AP accounts and make all the manual entries in them that you 
need. With regard to Bills and Invoices, you can do those manually, or you can 
use the Business Features. If you do so, you can’t edit the resulting 
transactions in Expense or Income accounts directly, you have to use the Edit 
Bill/Invoice window to do so. (but you can always view those transactions at 
any time, just like AR/AP by simply viewing the relevant Income or Expense 
account, they are in fact, the same transactions as what appears in AR/AP.)


Regards,
Adrien




> On Mar 17, 2020 w12d77, at 2:20 AM, Adrian Yong  
> wrote:
> 
> 
> Adrien,
> 
> In the General Ledger, every account has it history recorded and all these is 
> collated in one book called the General Ledger...
> 
> As I am used to QuickBooks and manually accounting methods, the General 
> Ledger is the basis for P&L, and Balance Sheet. QuickBooks seems to emulate 
> manual accounting.
> 
> Somehow, I have to generate a report on each account and collate them 
> manually into one collection..
> 
> Regards,
> Adrian
> 
> On Tue, 17 Mar. 2020, 13:39 Adrien Monteleone, 
>  wrote:
> If you mean you want to see the individual transaction activity in your 
> accounts related to a single customer, yes.
> 
> If you just want to see the balanced owed by all customers, you can use the 
> Accounts Receivable report. (each customer can be listed separately, along 
> with a total)
> 
> But both of these are entirely different things than your original question. 
> Which is quite fine, but please do clarify what it is you are trying to 
> accomplish so we can help you efficiently.
> 
> Regards,
> Adrien
> 
> > On Mar 16, 2020 w12d76, at 11:47 PM, Adrian Yong 
> >  wrote:
> > 
> > Hi Christopher,
> > 
> > That means I have to generate a report for each of the accounts ie Cash in
> > Bank, Trade Debtors, each customer at a time ?
> > 
> > Regards,
> > Adrian

___
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] General Ledger

[Adrian Yong]

Adrien,

In the General Ledger, every account has it history recorded and all these
is collated in one book called the General Ledger...

As I am used to QuickBooks and manually accounting methods, the General
Ledger is the basis for P&L, and Balance Sheet. QuickBooks seems to emulate
manual accounting.

Somehow, I have to generate a report on each account and collate them
manually into one collection..

Regards,
Adrian

On Tue, 17 Mar. 2020, 13:39 Adrien Monteleone, <
adrien.montele...@lusfiber.net> wrote:

> If you mean you want to see the individual transaction activity in your
> accounts related to a single customer, yes.
>
> If you just want to see the balanced owed by all customers, you can use
> the Accounts Receivable report. (each customer can be listed separately,
> along with a total)
>
> But both of these are entirely different things than your original
> question. Which is quite fine, but please do clarify what it is you are
> trying to accomplish so we can help you efficiently.
>
> Regards,
> Adrien
>
> > On Mar 16, 2020 w12d76, at 11:47 PM, Adrian Yong <
> adrianyong.88p...@gmail.com> wrote:
> >
> > Hi Christopher,
> >
> > That means I have to generate a report for each of the accounts ie Cash
> in
> > Bank, Trade Debtors, each customer at a time ?
> >
> > Regards,
> > Adrian
>
>
> ___
> 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] General Ledger

[Adrien Monteleone]

If you mean you want to see the individual transaction activity in your 
accounts related to a single customer, yes.

If you just want to see the balanced owed by all customers, you can use the 
Accounts Receivable report. (each customer can be listed separately, along with 
a total)

But both of these are entirely different things than your original question. 
Which is quite fine, but please do clarify what it is you are trying to 
accomplish so we can help you efficiently.

Regards,
Adrien

> On Mar 16, 2020 w12d76, at 11:47 PM, Adrian Yong 
>  wrote:
> 
> Hi Christopher,
> 
> That means I have to generate a report for each of the accounts ie Cash in
> Bank, Trade Debtors, each customer at a time ?
> 
> Regards,
> Adrian


___
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] General Ledger

[Adrian Yong]

Thanks Adrien...

On Tue, 17 Mar. 2020, 13:28 Adrien Monteleone, <
adrien.montele...@lusfiber.net> wrote:

> There are no specific ‘ending balances’ except the balance as of the last
> transaction in any account.
>
> The details between that and the opening balances are simply every
> transaction in that account. There is no other ‘detail’ or ’summary’ that
> is relevant or even available in *any* software.
>
> In GnuCash, you can view that by viewing an account register.
>
> If you want a printable report format, open said account, and run an
> Account Report.
>
> Otherwise, maybe what you are looking for is called the Trial Balance
> Report.
>
> You can also run a Transaction Report showing all transactions between
> certain dates (presumably opening date and whatever you want your closing
> date to be) for any, all, or certain accounts - all in one report, sorted
> as needed. (by date, or account, or both, one before the other, as desired)
>
> Barring that, the Balance Sheet report itself will show you the ‘ending’
> balances of all accounts. (save that Income and Expense accounts will be
> summarized with a single line in the report called ‘Retained Earnings’ or
> ‘Retained Losses’)
>
> Regards,
> Adrien
>
> > On Mar 16, 2020 w12d76, at 11:29 PM, Christopher Lam <
> christopher@gmail.com> wrote:
> >
> > Try the customer report in the experimental menu.
> >
> > On Tue, 17 Mar 2020, 12:18 pm Adrian Yong, 
> > wrote:
> >
> >> Hi Adrien,
> >>
> >> In other accounting software, the General Ledger gives the ending
> balances
> >> for each of the accounts which are then posted to the Balance Sheet..
> >>
> >> For example, the General Ledger would give details of all transactions
> >> between the opening balance and the ending balance for a particular
> >> customer...
> >>
> >> Otherwise, how would one audit the transactions for a particular
> customer ?
> >>
> >> Regards,
> >> Adrian
> >>
> >>
> >>
> >> On Tue, 17 Mar. 2020, 11:33 Adrien Monteleone, <
> >> adrien.montele...@lusfiber.net> wrote:
> >>
> >>> Is this a duplicate question?
> >>>
> >>> Something very similar appeared on this list just a few days ago.
> >>>
> >>> GnuCash *is* the ‘general ledger’.
> >>>
> >>> Certainly, you can run a transaction report showing whatever you need.
> >>> (among many other reports)
> >>>
> >>> Opening balance transactions are common for people with pre-existing
> >>> accounts.
> >>>
> >>> Closing balance transactions are not necessarily required by GnuCash.
> >>> (unlike other software)
> >>>
> >>> Such a report isn’t *usual* for normal accounting practice.
> >>>
> >>> May I ask, “Why you are interested in such info in this exact form?" It
> >>> seems to be an odd request.
> >>>
> >>> Regards,
> >>> Adrien
> >>>
>  On Mar 16, 2020 w12d76, at 9:54 PM, Adrian Yong <
> >>> adrianyong.88p...@gmail.com> wrote:
> 
>  Hi,
> 
>  I am trying to generate a General Ledger which lists all the
> >> transactions
>  for the period, opening balance and closing balance for each account
> >> and
> >>> or
>  subaccount.
> 
>  Can someone guide me through the General Ledger process to achieve
> >> this,
>  please ?
> 
>  Regards,
>  Adrian
>
>
> ___
> 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] General Ledger

[Adrian Yong]

Thanks Christopher

On Tue, 17 Mar. 2020, 13:19 Christopher Lam, 
wrote:

> If it fits your needs then yes
>
> On Tue, 17 Mar 2020, 12:47 pm Adrian Yong, 
> wrote:
>
>> Hi Christopher,
>>
>> That means I have to generate a report for each of the accounts ie Cash
>> in Bank, Trade Debtors, each customer at a time ?
>>
>> Regards,
>> Adrian
>>
>> On Tue, 17 Mar. 2020, 12:29 Christopher Lam, 
>> wrote:
>>
>>> Try the customer report in the experimental menu.
>>>
>>> On Tue, 17 Mar 2020, 12:18 pm Adrian Yong, 
>>> wrote:
>>>
 Hi Adrien,

 In other accounting software, the General Ledger gives the ending
 balances
 for each of the accounts which are then posted to the Balance Sheet..

 For example, the General Ledger would give details of all transactions
 between the opening balance and the ending balance for a particular
 customer...

 Otherwise, how would one audit the transactions for a particular
 customer ?

 Regards,
 Adrian



 On Tue, 17 Mar. 2020, 11:33 Adrien Monteleone, <
 adrien.montele...@lusfiber.net> wrote:

 > Is this a duplicate question?
 >
 > Something very similar appeared on this list just a few days ago.
 >
 > GnuCash *is* the ‘general ledger’.
 >
 > Certainly, you can run a transaction report showing whatever you need.
 > (among many other reports)
 >
 > Opening balance transactions are common for people with pre-existing
 > accounts.
 >
 > Closing balance transactions are not necessarily required by GnuCash.
 > (unlike other software)
 >
 > Such a report isn’t *usual* for normal accounting practice.
 >
 > May I ask, “Why you are interested in such info in this exact form?"
 It
 > seems to be an odd request.
 >
 > Regards,
 > Adrien
 >
 > > On Mar 16, 2020 w12d76, at 9:54 PM, Adrian Yong <
 > adrianyong.88p...@gmail.com> wrote:
 > >
 > > Hi,
 > >
 > > I am trying to generate a General Ledger which lists all the
 transactions
 > > for the period, opening balance and closing balance for each
 account and
 > or
 > > subaccount.
 > >
 > > Can someone guide me through the General Ledger process to achieve
 this,
 > > please ?
 > >
 > > Regards,
 > > Adrian
 >
 > ___
 > 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] General Ledger

[Adrien Monteleone]

There are no specific ‘ending balances’ except the balance as of the last 
transaction in any account.

The details between that and the opening balances are simply every transaction 
in that account. There is no other ‘detail’ or ’summary’ that is relevant or 
even available in *any* software.

In GnuCash, you can view that by viewing an account register.

If you want a printable report format, open said account, and run an Account 
Report.

Otherwise, maybe what you are looking for is called the Trial Balance Report.

You can also run a Transaction Report showing all transactions between certain 
dates (presumably opening date and whatever you want your closing date to be) 
for any, all, or certain accounts - all in one report, sorted as needed. (by 
date, or account, or both, one before the other, as desired)

Barring that, the Balance Sheet report itself will show you the ‘ending’ 
balances of all accounts. (save that Income and Expense accounts will be 
summarized with a single line in the report called ‘Retained Earnings’ or 
‘Retained Losses’)

Regards,
Adrien

> On Mar 16, 2020 w12d76, at 11:29 PM, Christopher Lam 
>  wrote:
> 
> Try the customer report in the experimental menu.
> 
> On Tue, 17 Mar 2020, 12:18 pm Adrian Yong, 
> wrote:
> 
>> Hi Adrien,
>> 
>> In other accounting software, the General Ledger gives the ending balances
>> for each of the accounts which are then posted to the Balance Sheet..
>> 
>> For example, the General Ledger would give details of all transactions
>> between the opening balance and the ending balance for a particular
>> customer...
>> 
>> Otherwise, how would one audit the transactions for a particular customer ?
>> 
>> Regards,
>> Adrian
>> 
>> 
>> 
>> On Tue, 17 Mar. 2020, 11:33 Adrien Monteleone, <
>> adrien.montele...@lusfiber.net> wrote:
>> 
>>> Is this a duplicate question?
>>> 
>>> Something very similar appeared on this list just a few days ago.
>>> 
>>> GnuCash *is* the ‘general ledger’.
>>> 
>>> Certainly, you can run a transaction report showing whatever you need.
>>> (among many other reports)
>>> 
>>> Opening balance transactions are common for people with pre-existing
>>> accounts.
>>> 
>>> Closing balance transactions are not necessarily required by GnuCash.
>>> (unlike other software)
>>> 
>>> Such a report isn’t *usual* for normal accounting practice.
>>> 
>>> May I ask, “Why you are interested in such info in this exact form?" It
>>> seems to be an odd request.
>>> 
>>> Regards,
>>> Adrien
>>> 
 On Mar 16, 2020 w12d76, at 9:54 PM, Adrian Yong <
>>> adrianyong.88p...@gmail.com> wrote:
 
 Hi,
 
 I am trying to generate a General Ledger which lists all the
>> transactions
 for the period, opening balance and closing balance for each account
>> and
>>> or
 subaccount.
 
 Can someone guide me through the General Ledger process to achieve
>> this,
 please ?
 
 Regards,
 Adrian


___
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] General Ledger

[Christopher Lam]

If it fits your needs then yes

On Tue, 17 Mar 2020, 12:47 pm Adrian Yong, 
wrote:

> Hi Christopher,
>
> That means I have to generate a report for each of the accounts ie Cash in
> Bank, Trade Debtors, each customer at a time ?
>
> Regards,
> Adrian
>
> On Tue, 17 Mar. 2020, 12:29 Christopher Lam, 
> wrote:
>
>> Try the customer report in the experimental menu.
>>
>> On Tue, 17 Mar 2020, 12:18 pm Adrian Yong, 
>> wrote:
>>
>>> Hi Adrien,
>>>
>>> In other accounting software, the General Ledger gives the ending
>>> balances
>>> for each of the accounts which are then posted to the Balance Sheet..
>>>
>>> For example, the General Ledger would give details of all transactions
>>> between the opening balance and the ending balance for a particular
>>> customer...
>>>
>>> Otherwise, how would one audit the transactions for a particular
>>> customer ?
>>>
>>> Regards,
>>> Adrian
>>>
>>>
>>>
>>> On Tue, 17 Mar. 2020, 11:33 Adrien Monteleone, <
>>> adrien.montele...@lusfiber.net> wrote:
>>>
>>> > Is this a duplicate question?
>>> >
>>> > Something very similar appeared on this list just a few days ago.
>>> >
>>> > GnuCash *is* the ‘general ledger’.
>>> >
>>> > Certainly, you can run a transaction report showing whatever you need.
>>> > (among many other reports)
>>> >
>>> > Opening balance transactions are common for people with pre-existing
>>> > accounts.
>>> >
>>> > Closing balance transactions are not necessarily required by GnuCash.
>>> > (unlike other software)
>>> >
>>> > Such a report isn’t *usual* for normal accounting practice.
>>> >
>>> > May I ask, “Why you are interested in such info in this exact form?" It
>>> > seems to be an odd request.
>>> >
>>> > Regards,
>>> > Adrien
>>> >
>>> > > On Mar 16, 2020 w12d76, at 9:54 PM, Adrian Yong <
>>> > adrianyong.88p...@gmail.com> wrote:
>>> > >
>>> > > Hi,
>>> > >
>>> > > I am trying to generate a General Ledger which lists all the
>>> transactions
>>> > > for the period, opening balance and closing balance for each account
>>> and
>>> > or
>>> > > subaccount.
>>> > >
>>> > > Can someone guide me through the General Ledger process to achieve
>>> this,
>>> > > please ?
>>> > >
>>> > > Regards,
>>> > > Adrian
>>> >
>>> > ___
>>> > 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] General Ledger

[Adrian Yong]

Hi Christopher,

That means I have to generate a report for each of the accounts ie Cash in
Bank, Trade Debtors, each customer at a time ?

Regards,
Adrian

On Tue, 17 Mar. 2020, 12:29 Christopher Lam, 
wrote:

> Try the customer report in the experimental menu.
>
> On Tue, 17 Mar 2020, 12:18 pm Adrian Yong, 
> wrote:
>
>> Hi Adrien,
>>
>> In other accounting software, the General Ledger gives the ending balances
>> for each of the accounts which are then posted to the Balance Sheet..
>>
>> For example, the General Ledger would give details of all transactions
>> between the opening balance and the ending balance for a particular
>> customer...
>>
>> Otherwise, how would one audit the transactions for a particular customer
>> ?
>>
>> Regards,
>> Adrian
>>
>>
>>
>> On Tue, 17 Mar. 2020, 11:33 Adrien Monteleone, <
>> adrien.montele...@lusfiber.net> wrote:
>>
>> > Is this a duplicate question?
>> >
>> > Something very similar appeared on this list just a few days ago.
>> >
>> > GnuCash *is* the ‘general ledger’.
>> >
>> > Certainly, you can run a transaction report showing whatever you need.
>> > (among many other reports)
>> >
>> > Opening balance transactions are common for people with pre-existing
>> > accounts.
>> >
>> > Closing balance transactions are not necessarily required by GnuCash.
>> > (unlike other software)
>> >
>> > Such a report isn’t *usual* for normal accounting practice.
>> >
>> > May I ask, “Why you are interested in such info in this exact form?" It
>> > seems to be an odd request.
>> >
>> > Regards,
>> > Adrien
>> >
>> > > On Mar 16, 2020 w12d76, at 9:54 PM, Adrian Yong <
>> > adrianyong.88p...@gmail.com> wrote:
>> > >
>> > > Hi,
>> > >
>> > > I am trying to generate a General Ledger which lists all the
>> transactions
>> > > for the period, opening balance and closing balance for each account
>> and
>> > or
>> > > subaccount.
>> > >
>> > > Can someone guide me through the General Ledger process to achieve
>> this,
>> > > please ?
>> > >
>> > > Regards,
>> > > Adrian
>> >
>> > ___
>> > 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] General Ledger

[Christopher Lam]

Try the customer report in the experimental menu.

On Tue, 17 Mar 2020, 12:18 pm Adrian Yong, 
wrote:

> Hi Adrien,
>
> In other accounting software, the General Ledger gives the ending balances
> for each of the accounts which are then posted to the Balance Sheet..
>
> For example, the General Ledger would give details of all transactions
> between the opening balance and the ending balance for a particular
> customer...
>
> Otherwise, how would one audit the transactions for a particular customer ?
>
> Regards,
> Adrian
>
>
>
> On Tue, 17 Mar. 2020, 11:33 Adrien Monteleone, <
> adrien.montele...@lusfiber.net> wrote:
>
> > Is this a duplicate question?
> >
> > Something very similar appeared on this list just a few days ago.
> >
> > GnuCash *is* the ‘general ledger’.
> >
> > Certainly, you can run a transaction report showing whatever you need.
> > (among many other reports)
> >
> > Opening balance transactions are common for people with pre-existing
> > accounts.
> >
> > Closing balance transactions are not necessarily required by GnuCash.
> > (unlike other software)
> >
> > Such a report isn’t *usual* for normal accounting practice.
> >
> > May I ask, “Why you are interested in such info in this exact form?" It
> > seems to be an odd request.
> >
> > Regards,
> > Adrien
> >
> > > On Mar 16, 2020 w12d76, at 9:54 PM, Adrian Yong <
> > adrianyong.88p...@gmail.com> wrote:
> > >
> > > Hi,
> > >
> > > I am trying to generate a General Ledger which lists all the
> transactions
> > > for the period, opening balance and closing balance for each account
> and
> > or
> > > subaccount.
> > >
> > > Can someone guide me through the General Ledger process to achieve
> this,
> > > please ?
> > >
> > > Regards,
> > > Adrian
> >
> > ___
> > 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] General Ledger

[Adrian Yong]

Hi Adrien,

In other accounting software, the General Ledger gives the ending balances
for each of the accounts which are then posted to the Balance Sheet..

For example, the General Ledger would give details of all transactions
between the opening balance and the ending balance for a particular
customer...

Otherwise, how would one audit the transactions for a particular customer ?

Regards,
Adrian



On Tue, 17 Mar. 2020, 11:33 Adrien Monteleone, <
adrien.montele...@lusfiber.net> wrote:

> Is this a duplicate question?
>
> Something very similar appeared on this list just a few days ago.
>
> GnuCash *is* the ‘general ledger’.
>
> Certainly, you can run a transaction report showing whatever you need.
> (among many other reports)
>
> Opening balance transactions are common for people with pre-existing
> accounts.
>
> Closing balance transactions are not necessarily required by GnuCash.
> (unlike other software)
>
> Such a report isn’t *usual* for normal accounting practice.
>
> May I ask, “Why you are interested in such info in this exact form?" It
> seems to be an odd request.
>
> Regards,
> Adrien
>
> > On Mar 16, 2020 w12d76, at 9:54 PM, Adrian Yong <
> adrianyong.88p...@gmail.com> wrote:
> >
> > Hi,
> >
> > I am trying to generate a General Ledger which lists all the transactions
> > for the period, opening balance and closing balance for each account and
> or
> > subaccount.
> >
> > Can someone guide me through the General Ledger process to achieve this,
> > please ?
> >
> > Regards,
> > Adrian
>
> ___
> 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] General Ledger

[Adrien Monteleone]

I see now this, is indeed, a duplicate question.

You asked it on March 12 @ 6:44pm CDT. I replied with something similar to 
below, 4 minutes later.

Rather than continuing that thread, or answering any requests for more 
clarifying information, or any indication you have determined the included 
reports meet your needs, you simply re-asked the question.

I’d say that is borderline. (there are some serious time stamp discrepancies 
with the original message chain and this one)

Please indicate if what has been provided does not specifically answer your 
question and why, and please answer the requests for more information.

Regards,
Adrien

> On Mar 16, 2020 w12d76, at 10:33 PM, Adrien Monteleone 
>  wrote:
> 
> Is this a duplicate question?
> 
> Something very similar appeared on this list just a few days ago.
> 
> GnuCash *is* the ‘general ledger’.
> 
> Certainly, you can run a transaction report showing whatever you need. (among 
> many other reports)
> 
> Opening balance transactions are common for people with pre-existing accounts.
> 
> Closing balance transactions are not necessarily required by GnuCash. (unlike 
> other software)
> 
> Such a report isn’t *usual* for normal accounting practice.
> 
> May I ask, “Why you are interested in such info in this exact form?" It seems 
> to be an odd request.
> 
> Regards,
> Adrien
> 
>> On Mar 16, 2020 w12d76, at 9:54 PM, Adrian Yong 
>>  wrote:
>> 
>> Hi,
>> 
>> I am trying to generate a General Ledger which lists all the transactions
>> for the period, opening balance and closing balance for each account and or
>> subaccount.
>> 
>> Can someone guide me through the General Ledger process to achieve this,
>> please ?
>> 
>> Regards,
>> Adrian


___
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] General Ledger

[Adrien Monteleone]

Is this a duplicate question?

Something very similar appeared on this list just a few days ago.

GnuCash *is* the ‘general ledger’.

Certainly, you can run a transaction report showing whatever you need. (among 
many other reports)

Opening balance transactions are common for people with pre-existing accounts.

Closing balance transactions are not necessarily required by GnuCash. (unlike 
other software)

Such a report isn’t *usual* for normal accounting practice.

May I ask, “Why you are interested in such info in this exact form?" It seems 
to be an odd request.

Regards,
Adrien

> On Mar 16, 2020 w12d76, at 9:54 PM, Adrian Yong  
> wrote:
> 
> Hi,
> 
> I am trying to generate a General Ledger which lists all the transactions
> for the period, opening balance and closing balance for each account and or
> subaccount.
> 
> Can someone guide me through the General Ledger process to achieve this,
> please ?
> 
> Regards,
> Adrian

___
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] General Ledger

[Adrien Monteleone]

In that sense, GnuCash *is* the General Ledger.

There is a General Journal, which contains all transactions. (most recent 30 
days visible by default)

There is each individual account containing opening balances and all subsequent 
transactions. (closing entries are not required by GnuCash, but are an option)

The Accounts tab can show an overview of the balance (current and YTD pr period 
to date) of every account, and is collapsable, expandable, and you can re-order 
it.

You can also run reports to show you anything else you need.

Does that help?

Regards,
Adrien

> On Mar 12, 2020 w11d72, at 12:17 AM, Adrian Yong  
> wrote:
> 
> Hi,
> 
> Is a General Ledger in GNUcash, the same as for general accounting
> practices where transactions, opening and closing balances are listed for
> every account and subaccounts ?
> 
> Regards,
> Adrian

___
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] General Ledger with Gnucash

[Michael Hendry]

> On 11 Mar 2020, at 20:03, Adrian Yong  wrote:
> 
> Hi Michael,
> 
> I have reading a lot of posts on this issue...
> 
> I have been using QuickBooks for quite a while. 
> 
> I would like to generate a GL like i do in QB..
> 
> The GL should contain all the parent and children accounts...
> 
> In fact, if I got the terminology correct, QB lists only the children 
> accounts but groups then in the order of Assets, Liabilities, and Equity...
> 
> How do I do that in Gnucash ?
> 
> Regards,
> Adrian

Hi, Adrian, and welcome to the Gnucash community.

My first suggestion is that you should always post queries to 
gnucash-user@gnucash.org - you’re more likely to get a quick solution than if 
you choose one contributor.

I have had no experience with QuickBooks.

If what you want is to create a General Journal which mimics the pen-and-ink 
version and lists all transactions you’ve (with optional restrictions) then you 
should go for Tools => General Journal.

Note that (by default) this reports only on the last 30 days, but you can 
adjust this by right-clicking on any of the transactions and choosing “Filter 
By”.

You can also sort the entries so that they appear in Date-of-Entry order (which 
most closely mimics the pen-and-ink version).

You could also create a Transaction report (Reports => Transaction Report) and 
then click on “Edit Report Options” to get a very comprehensive set of options, 
which you will need to experiment with to get what you want. 

Best of luck,

Michael

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