Re: [GNC] Accounts not appearing in General Ledger

[David Carlson]

Are you referring to the window that we call the Accounts window rather
than the General Journal register window that many also call the General
Ledger?

That indeed is a mystery but you might check the View settings to be sure
that all accounts are selected to be shown, including Zero value and unused.



On Fri, Jul 28, 2023 at 10:00 AM James Wilde  wrote:

> I am using an account list in general use in Sweden, such that account
> number 8400 is a holding number for accounts for interest payments from
> the entity being recorded.  I can not get account 8400 to appear in the
> general ledger although two subaccounts, 8422, interest payments to
> suppliers and 8428 for interest paid to collectors both have sums posted.
>
> I have now changed these three accounts such that the parent account is
> now 6400, and the other two are 6422 and 6428.  Now the account number
> 6428 appears in the general ledger, but not the 6422 account.
>
> I'd like to know why, so that I can fix it, and hopefully don't need to
> go through the entire general ledger to make sure that all other
> accounts are included.
>
> TIA for any help.
>
> James Wilde
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


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

[GNC] Accounts not appearing in General Ledger

[James Wilde]

I am using an account list in general use in Sweden, such that account 
number 8400 is a holding number for accounts for interest payments from 
the entity being recorded.  I can not get account 8400 to appear in the 
general ledger although two subaccounts, 8422, interest payments to 
suppliers and 8428 for interest paid to collectors both have sums posted.


I have now changed these three accounts such that the parent account is 
now 6400, and the other two are 6422 and 6428.  Now the account number 
6428 appears in the general ledger, but not the 6422 account.


I'd like to know why, so that I can fix it, and hopefully don't need to 
go through the entire general ledger to make sure that all other 
accounts are included.


TIA for any help.

James Wilde
___
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] Description from Bill/Invoice not Posting on General Ledger Memo Field (GNU Cash V4.5)

[Adrien Monteleone]

By 'Descriptions' I'm guessing you mean the descriptions for the 
individual line items. (there is no generic 'description' field for a 
bill/invoice)


The only way to see that is to uncheck the 'accumulate splits' box when 
posting. (alternatively, under Preferences > Business > General > 
'Accumulate Splits on Post' should be unchecked to change the default)


Now each of your line items will show up when looking at any affected 
register (in either Split/Auto-Split/Transaction Journal mode) or Tools 
> General Journal. (which is fixed to Transaction Journal mode)


Regards,
Adrien

On 6/9/21 10:57 AM, Toby O wrote:

Hi,
I don't see the descriptions from the Invoice / Bill section on the General
Ledger section.
So for example I'll have a Bill with Description as follows :-
Black Box

When I go look at the general ledger, there is no description. It is just
blank. This has me very puzzled and confused.

Has someone had a similar issue as me? Please advise. If so, how did you
get around to solving it?


___
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

[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<mailto:gmccol...@gyleshomes.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<mailto:gmccol...@gyleshomes.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<mailto:gmccol...@gyleshomes.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<mailto:gmccol...@gyleshomes.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.

[GNC] General Ledger amounts missing

[sydnorbilling]

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.

[GNC] Description from Bill/Invoice not Posting on General Ledger Memo Field (GNU Cash V4.5)

[Toby O]

Hi,
I don't see the descriptions from the Invoice / Bill section on the General
Ledger section.
So for example I'll have a Bill with Description as follows :-
Black Box

When I go look at the general ledger, there is no description. It is just
blank. This has me very puzzled and confused.

Has someone had a similar issue as me? Please advise. If so, how did you
get around to solving it?
___
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] Unable to Export General Ledger (was: Potential regression: PDFs generated using "Make PDF" have a superfluous blank page)

[Adrien Monteleone]

That’s probably a different issue entirely.

I just ran the General Ledger Report, and used both ‘Export' (which is HTML) 
and ‘Make PDF’ both of which worked fine without extra blank pages. (I’m now on 
3.906 on MacOS 10.15.5) I haven’t yet jumped to 4.x but will tonight. I’ll see 
if I can test with 3.7, but I can report that at least as of 3.906 it works 
properly.

If you want to export to a spreadsheet you have a few options for ‘General 
Ledger’

1. Run the report then export to html, then open the html file in your 
spreadsheet app of choice.
2. Run the report, copy/paste the contents from the GnuCash window to your 
spreadsheet app.

Or, when viewing the General Journal (a register form of the ledger report):

3. File > Export > Active Account Register to CSV
4. Reports > Account Report > (and then proceed with either of steps 1 or 2 
above)

Any of those methods will get you ALL transactions into a spreadsheet.

You can also use File > Export > Export Transactions to CSV.

The advantage with the General Journal register or General Ledger report is 
that you can do some filtering first if you like.

You can do the same #1 & #2 above for any report or #3 & #4 for any open 
register, including a search results register.

--

What steps (exactly) did you take to do your export? (there is no xlsx format 
supported that I am aware of) You can’t export and just choose a different file 
name to get a different format.

Regards,
Adrien


> On Jun 29, 2020 w27d181, at 6:35 PM, Adrian Yong 
>  wrote:
> 
> Hi Adrien,
> 
> After speaking to you the last time, I tried exporting documents (ie. General 
> Ledger) to pdf and xlsx formats and I got gibberish...
> 
> I am using version 3.7...
> 
> 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]

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
>> 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, 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.montel

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

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

[GNC] General Ledger

[Adrian Yong]

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.

[GNC] General Ledger

[Adrian Yong]

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.

Re: [GNC] searching in General Ledger View

[Geert Janssens]

Op zaterdag 15 september 2018 09:31:00 CEST schreef David Carlson:
> Alas, I keep going further down the rabbit hole.  Now I discovered that the
> General Ledger view had somehow been corrupted and none of the standard
> register menu functions were available.  So I saved the file, then it was
> possible to see that the View > Filter by status was still set to start one
> month before the date that was today when the view was opened, but the view
> actually contained every transaction back to the beginning of time.  It was
> again possible to do other things like jumping to another account
> register.  It must be time for bed.
> 
> David C

I suspect this is also fixed.

Geert


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

[David Carlson]

Alas, I keep going further down the rabbit hole.  Now I discovered that the
General Ledger view had somehow been corrupted and none of the standard
register menu functions were available.  So I saved the file, then it was
possible to see that the View > Filter by status was still set to start one
month before the date that was today when the view was opened, but the view
actually contained every transaction back to the beginning of time.  It was
again possible to do other things like jumping to another account
register.  It must be time for bed.

David C


On Sat, Sep 15, 2018 at 2:16 AM David Carlson 
wrote:

> One more detail: in the General Ledger, when changing the criteria to
> matches regex, entering .* for the regex and changing  type to add results
> to current search, the new result is not filtered by date as it was
> originally. In fact, the View > Filter By menu item is greyed out and
> unavailable.   I did not test the condition where the filter setting may
> have been saved at the beginning of the trial.
>
> David
>
> On Fri, Sep 14, 2018 at 8:35 PM David Carlson 
> wrote:
>
>> The help manual Chapter 8 section 8.1 fails to point out that the find
>> assistant [Split Search] Type of Search defaults to New search when started
>> from the main accounts hierarchy page, but it defaults to Refine current
>> search when started from a normal Account Register window or from the
>> General Ledger window.  Further, the results are presented in a new window
>> when started from the main accounts hierarchy page or from a normal Account
>> Register window, but  the results are presented in the *same window when
>> started from the General Ledger window*.  This is probably designed to
>> respect the View >Filter By option in the Account register view and in the
>> General Ledger view.
>>
>> The Delete results from current search type is apparently intended to
>> delete transactions that match the newly chosen criteria from the current
>> search result rather than to undo the last search refinement or
>> modification.
>>
>> Finally, John Ralls' answer to my original question was interesting.  In
>> the General Ledger window, at least, it is possible to return to the
>> un-searched view by changing Search Criteria " ... contains to matches
>> regex and enter .* for the regex. And check "add results to current search"
>> in the search type radio box."
>>
>> I hope that we can get all of that into the help manual.
>>
>> David C
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On Fri, Sep 14, 2018 at 6:31 PM D  wrote:
>>
>>> I think you just close the search tab.
>>>
>>> On September 14, 2018, at 6:13 PM, David Carlson <
>>> david.carlson@gmail.com> wrote:
>>>
>>>  While I happen to be using release 2.6.19 or so, I think my problem is
>>> still current. I opened a general ledger view then I searched for
>>> transactions containing certain text in the description. This left the
>>> results in the general ledger view. How do I return to the general ledger
>>> view before the search?
>>>
>>> David C
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> 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] searching in General Ledger View

[David Carlson]

One more detail: in the General Ledger, when changing the criteria to
matches regex, entering .* for the regex and changing  type to add results
to current search, the new result is not filtered by date as it was
originally. In fact, the View > Filter By menu item is greyed out and
unavailable.   I did not test the condition where the filter setting may
have been saved at the beginning of the trial.

David

On Fri, Sep 14, 2018 at 8:35 PM David Carlson 
wrote:

> The help manual Chapter 8 section 8.1 fails to point out that the find
> assistant [Split Search] Type of Search defaults to New search when started
> from the main accounts hierarchy page, but it defaults to Refine current
> search when started from a normal Account Register window or from the
> General Ledger window.  Further, the results are presented in a new window
> when started from the main accounts hierarchy page or from a normal Account
> Register window, but  the results are presented in the *same window when
> started from the General Ledger window*.  This is probably designed to
> respect the View >Filter By option in the Account register view and in the
> General Ledger view.
>
> The Delete results from current search type is apparently intended to
> delete transactions that match the newly chosen criteria from the current
> search result rather than to undo the last search refinement or
> modification.
>
> Finally, John Ralls' answer to my original question was interesting.  In
> the General Ledger window, at least, it is possible to return to the
> un-searched view by changing Search Criteria " ... contains to matches
> regex and enter .* for the regex. And check "add results to current search"
> in the search type radio box."
>
> I hope that we can get all of that into the help manual.
>
> David C
>
>
>
>
>
>
>
>
>
> On Fri, Sep 14, 2018 at 6:31 PM D  wrote:
>
>> I think you just close the search tab.
>>
>> On September 14, 2018, at 6:13 PM, David Carlson <
>> david.carlson@gmail.com> wrote:
>>
>>  While I happen to be using release 2.6.19 or so, I think my problem is
>> still current. I opened a general ledger view then I searched for
>> transactions containing certain text in the description. This left the
>> results in the general ledger view. How do I return to the general ledger
>> view before the search?
>>
>> David C
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> 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] searching in General Ledger View

[David Carlson]

The help manual Chapter 8 section 8.1 fails to point out that the find
assistant [Split Search] Type of Search defaults to New search when started
from the main accounts hierarchy page, but it defaults to Refine current
search when started from a normal Account Register window or from the
General Ledger window.  Further, the results are presented in a new window
when started from the main accounts hierarchy page or from a normal Account
Register window, but  the results are presented in the *same window when
started from the General Ledger window*.  This is probably designed to
respect the View >Filter By option in the Account register view and in the
General Ledger view.

The Delete results from current search type is apparently intended to
delete transactions that match the newly chosen criteria from the current
search result rather than to undo the last search refinement or
modification.

Finally, John Ralls' answer to my original question was interesting.  In
the General Ledger window, at least, it is possible to return to the
un-searched view by changing Search Criteria " ... contains to matches
regex and enter .* for the regex. And check "add results to current search"
in the search type radio box."

I hope that we can get all of that into the help manual.

David C









On Fri, Sep 14, 2018 at 6:31 PM D  wrote:

> I think you just close the search tab.
>
> On September 14, 2018, at 6:13 PM, David Carlson <
> david.carlson@gmail.com> wrote:
>
>  While I happen to be using release 2.6.19 or so, I think my problem is
> still current. I opened a general ledger view then I searched for
> transactions containing certain text in the description. This left the
> results in the general ledger view. How do I return to the general ledger
> view before the search?
>
> David C
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 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] searching in General Ledger View

[D via gnucash-user]

I think you just close the search tab.

On September 14, 2018, at 6:13 PM, David Carlson  
wrote:

 While I happen to be using release 2.6.19 or so, I think my problem is
still current. I opened a general ledger view then I searched for
transactions containing certain text in the description. This left the
results in the general ledger view. How do I return to the general ledger
view before the search?

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

[GNC] searching in General Ledger View

[David Carlson]

 While I happen to be using release 2.6.19 or so, I think my problem is
still current. I opened a general ledger view then I searched for
transactions containing certain text in the description. This left the
results in the general ledger view. How do I return to the general ledger
view before the search?

David C
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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: General Ledger

[Leo Bolta]

Thanks for your comments Wm.  I actually purchased the 1882 bookkeeping text
book in a Value Village second hand store for just over $5.  Recently I also
purchased an old King James Bible from 1840's but when I consulted an
antique book dealer about these purchases he told me that they had no real
monetary value hence, I entered them in gnc as 'expense:books.  My
handwriting is so bad that I myself cannot read it so stick to printing by
caps only.


Original Message-
From: gnucash-user
[mailto:gnucash-user-bounces+lbolta=rogers@gnucash.org] On Behalf Of Wm
via gnucash-user
Sent: March-03-18 4:45 AM
To: gnucash-u...@lists.gnucash.org
Subject: Re: General Ledger

On 02/03/2018 16:22, Leo Bolta wrote:
> Not to keep the thread alive but these are photos of select pages of 
> the
> 1882 High School bookkeeping text book, I referred to earlier and 
> promised to distribute.  Several of the previous commenter's may have 
> been quite accurate in regards to the historical progression but these 
> pages are just for those who might be interested on how it was 
> expressed before the turn of the last century.

Thank you for sharing that.  Have you got the books under

Assets:Chattels:Books

in your gnc ? :)


 >  Also take note of the penmanship from the personal notes
> of the student included in the last attachment...today's penmanship is 
> a shame by comparison.

My father can write like that, I'd have been a failure if it wasn't for
computers by comparison.

>  My apologies for portions of text which are slightly blurred.

Don't apologise, I found it interesting, the slightly blurred bits didn't
spoil the view for me.

--
Wm

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

[Stan Brown]

On 2018-03-04 09:33, Geert Janssens wrote:
> Op zondag 4 maart 2018 15:09:35 CET schreef Stan Brown:
>> On 2018-03-03 09:54, Wm via gnucash-user wrote:
>>> On 03/03/2018 13:47, Stan Brown wrote:
>>>> On 2018-03-02 13:47, Wm via gnucash-user wrote:
>>>> There is a checkbox, "Save filter", in the filter-defining window.  What
>>>> is that meant to do?
>
> It's meant to save the filter configuration such that when you reopen your 
> book at a later time, the same filter settings would be applied automatically 
> again to the General Journal. This works for all normal account registers, ut 
> for the General Ledger this was missed.
> 
>>
>> And if it's not doing what it's meant to, has a bug report been entered?
> 
> https://bugzilla.gnome.org/show_bug.cgi?id=714708

Great -- thanks! It works for me as you describe it -- individual
account registers do stay with that filter if I tick the box, and
General Ledger does not.

-- 
Regards,
Stan Brown
Tompkins County, New York, USA
http://BrownMath.com
http://OakRoadSystems.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
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: General Ledger

[Geert Janssens]

Op zondag 4 maart 2018 15:09:35 CET schreef Stan Brown:
> On 2018-03-03 09:54, Wm via gnucash-user wrote:
> > On 03/03/2018 13:47, Stan Brown wrote:
> >> On 2018-03-02 13:47, Wm via gnucash-user wrote:
> >> There is a checkbox, "Save filter", in the filter-defining window.  What
> >> is that meant to do?
> > 
> > I think what it is *meant* to do is fairly obvious and I may be wrong
> > but I don't think that is stored or saved.
> 
> What it's meant to do is not obvious to me, or I wouldn't have asked the
> question. Could you enlighten me, please?

It's meant to save the filter configuration such that when you reopen your 
book at a later time, the same filter settings would be applied automatically 
again to the General Journal. This works for all normal account registers, ut 
for the General Ledger this was missed.

> 
> And if it's not doing what it's meant to, has a bug report been entered?

https://bugzilla.gnome.org/show_bug.cgi?id=714708

Geert


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

[Stan Brown]

On 2018-03-03 09:54, Wm via gnucash-user wrote:
> On 03/03/2018 13:47, Stan Brown wrote:
>>
>> On 2018-03-02 13:47, Wm via gnucash-user wrote:
>> There is a checkbox, "Save filter", in the filter-defining window.  What
>> is that meant to do?
> 
> I think what it is *meant* to do is fairly obvious and I may be wrong
> but I don't think that is stored or saved.

What it's meant to do is not obvious to me, or I wouldn't have asked the
question. Could you enlighten me, please?

And if it's not doing what it's meant to, has a bug report been entered?

-- 
Regards,
Stan Brown
Tompkins County, New York, USA
http://BrownMath.com
http://OakRoadSystems.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
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: General Ledger

[Wm via gnucash-user]

On 03/03/2018 13:47, Stan Brown wrote:


On 2018-03-02 13:47, Wm via gnucash-user wrote:

On 23/02/2018 12:52, Adrien Monteleone wrote:

And unfortunately, this filter change is not sticky. You’ll have to
reset it each time you load the GL. This is already a filed bug.


AdrienM, it is not a bug if you have many years of tx, promise. I
like the narrow time window.

There is a checkbox, "Save filter", in the filter-defining window.  What
is that meant to do?


I think what it is *meant* to do is fairly obvious and I may be wrong 
but I don't think that is stored or saved.


--
Wm


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

[Wm via gnucash-user]

On 26/02/2018 18:16, Greg Feneis wrote:

I keep seeing this email subject line and imagine you guys are discussing a
lesser known war hero



Thank you, Mr Feneis, I'm not sure what this thread is really about 
either but commend your humour.


It doesn't really matter what the damn thing is called so long as you 
know what is in it and what it is for.


Remember: a good proportion of people will be seeing whatever it gets 
called in translation anyway so stop picking at the scab!


--
Wm

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

[Wm via gnucash-user]

On 02/03/2018 16:22, Leo Bolta wrote:

Not to keep the thread alive but these are photos of select pages of the
1882 High School bookkeeping text book, I referred to earlier and promised
to distribute.  Several of the previous commenter's may have been quite
accurate in regards to the historical progression but these pages are just
for those who might be interested on how it was expressed before the turn of
the last century. 


Thank you for sharing that.  Have you got the books under

Assets:Chattels:Books

in your gnc ? :)


>  Also take note of the penmanship from the personal notes

of the student included in the last attachment...today's penmanship is a
shame by comparison.


My father can write like that, I'd have been a failure if it wasn't for 
computers by comparison.



 My apologies for portions of text which are slightly
blurred.


Don't apologise, I found it interesting, the slightly blurred bits 
didn't spoil the view for me.


--
Wm

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

[Adrien Monteleone]

It doesn’t work on this particular register, hence the bug report.

If I’m not mistaken, one of the bug comments even mentions this was an 
oversight when the dialog was updated some time ago.

Note, the bug isn’t that the date window is too small by default. The bug is 
that you can’t save your preference for it being a different time frame like 
you can on any other register.

Regards,
Adrien

> On Mar 3, 2018, at 7:47 AM, Stan Brown  wrote:
> 
> 
> On 2018-03-02 13:47, Wm via gnucash-user wrote:
>> On 23/02/2018 12:52, Adrien Monteleone wrote:
>>> And unfortunately, this filter change is not sticky. You’ll have to
>>> reset it each time you load the GL. This is already a filed bug.
>> 
>> AdrienM, it is not a bug if you have many years of tx, promise. I 
>> like the narrow time window.
> There is a checkbox, "Save filter", in the filter-defining window.  What
> is that meant to do?
> 
> -- 
> Regards,
> Stan Brown
> Tompkins County, New York, USA
> http://BrownMath.com
> http://OakRoadSystems.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
> 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: General Ledger

[Stan Brown]

On 2018-03-02 13:47, Wm via gnucash-user wrote:
> On 23/02/2018 12:52, Adrien Monteleone wrote:
>> And unfortunately, this filter change is not sticky. You’ll have to
>> reset it each time you load the GL. This is already a filed bug.
>
> AdrienM, it is not a bug if you have many years of tx, promise. I 
> like the narrow time window.
There is a checkbox, "Save filter", in the filter-defining window.  What
is that meant to do?

-- 
Regards,
Stan Brown
Tompkins County, New York, USA
http://BrownMath.com
http://OakRoadSystems.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
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: General Ledger

[Wm via gnucash-user]

On 23/02/2018 21:52, Buddha Buck wrote:

I suspect that GnuCash terminology regarding journals and ledgers is
somewhat confused and non-standard.


yeah, they are convenience terms


My basic understanding of classical accounting is that transactions were
first entered into journals, and then posted into ledgers, one per account.
The collection of ledger books was the "general ledger", while the nominal
time-ordered collection of journal entries was the "general journal" (or
the "general journal" was the journal in which transactions which didn't
belong in the sales journal, purchase journal, etc were recorded).


that has varied between countries historically

in some it was
"everything goes in the big book and you pull out the sales"
and in others it was
"you enter everything in the sales book and then transfer it to the big 
book"


gnc and other transaction streams supersede those views.


In GnuCash terms, a classical account ledger would correspond to a GnuCash
account register. And the classic general journal would correspond to
GnuCash's general ledger. The classic general ledger might even be a
GnuCash book as a whole.


Depending on where you learned your accounting :)


I don't know what GnuCash is calling a general
journal.


C'mon GnuCash is a transaction stream application with a few tweaks.  It 
isn't calling anything.


--
Wm




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

[Wm via gnucash-user]

On 23/02/2018 12:52, Adrien Monteleone wrote:

And unfortunately, this filter change is not sticky. You’ll have to reset it 
each time you load the GL. This is already a filed bug.


AdrienM, it is not a bug if you have many years of tx, promise.  I like 
the narrow time window.


--
Wm

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

[Liz]

On Mon, 26 Feb 2018 10:16:06 -0800
Greg Feneis  wrote:

> I keep seeing this email subject line and imagine you guys are
> discussing a lesser known war hero
> 
> 
> Kind regards,
> 
> Greg Feneis

Yes, he/she fought against Manuel Labour.

Liz
___
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: General Ledger

[Greg Feneis]

I keep seeing this email subject line and imagine you guys are discussing a
lesser known war hero


Kind regards,

Greg Feneis



On Mon, Feb 26, 2018 at 9:08 AM, Mike or Penny Novack <
stepbystepf...@dialup4less.com> wrote:

> On 2/26/2018 7:34 AM, Buddha Buck wrote:
>
>> It's not an Australian accounting thing, unless I managed to grab
>> Australian book out of my small-city upstate New York library system some
>> 30 years ago...
>>
>> Or me, more like 50 years ago, and the books would have been my dad's
> from a generation earlier than that.
>
> 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.
>
___
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: General Ledger

[Dale Alspach]

The reference I have distinguishes journal from ledger based on entry
time and purpose. A journal is a historical record of first entry of
complete transactions (splits, notes, etc.). A ledger is a final or
secondary record of changes to an account.

The term general journal seems to have two uses. In a small business
every transaction would be entered in time order in the general journal.
In a larger enterprise there may be many special journals (sales,
purchases, etc.) and the general journal would be for entries not in a
special journal.

As Michael Novak pointed out these notions originate in paper accounting
and for small business and personal accounting may not have much use.
With an electronic system such as gnucash and only one book the system
is ledger oriented. One can see the journal entries affecting one
account by selecting Transaction Journal under View. The General Ledger
under Tools shows what is like a journal except that some history is
lost because the entries may be changed without the use of a correcting
journal entry. With that in mind and the distinction noted above, this
seems to be a general ledger rather than a general journal unless one
uses strict accounting practice (once a transaction is entered it is
forever; the effect is changed by a new correcting transaction.) Some
transaction oriented systems have an audit trail which is equivalent to
a general journal.

Dale

On 02/26/2018 09:08 AM, Leo Bolta wrote:
> I never majored in accounting but I can still remember "General Journal"
> being a standard term often used in Canadian high school accounting about 50
> years ago.  Recently I picked up an Ontario, Canada bookkeeping text book
> from 1882.  It makes a distinction between what are called "Day Books,
> Journals and Ledgers".  I'll try to photograph some relative pages in the
> next few days and attach them in a post.
> Leo
> 
> -Original Message-
> From: gnucash-user
> [mailto:gnucash-user-bounces+lbolta=rogers@gnucash.org] On Behalf Of
> Buddha Buck
> Sent: February-26-18 7:34 AM
> To: elvis
> Cc: gnucash-user@gnucash.org
> Subject: Re: General Ledger
> 
> It's not an Australian accounting thing, unless I managed to grab Australian
> book out of my small-city upstate New York library system some 30 years
> ago...
> 
> 
> On Mon, Feb 26, 2018 at 5:38 AM elvis <el...@dogonfire.com> wrote:
> 
>> On 25/02/18 07:54, Dave H wrote:
>>> Well from my point of view that is confusing.  Nobody in my world 
>>> refers
>> to
>>> a "General Journal" we refer to the "General Ledger" and we do 
>>> journals
>>> :-)  I've never actually heard the term general journal used 
>>> anywhere before until this discussion over the weekend !!!
>>
>> You weren't in my accounting class where we got the use of the general 
>> journal beaten into us :-) I can still remember it 30 years later. 
>> Maybe it's an Australian accounting thing.
>>> Cheers Dave H.
>>>
>>> On 24 February 2018 at 19:58, Geert Janssens 
>>> <geert.gnuc...@kobaltwit.be
>>>
>>> wrote:
>>>
>>>
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: General Ledger

[Adrien Monteleone]

Everyone is correct.

It’s a matter of perspective.

I too was taught ‘General Journal’. The ‘Ledger’ was step 2.

But our textbooks, and likely the focus of any accounting class, were primarily 
for *business* and from the perspective of a larger corporation or what we 
would distinguish today as an ‘enterprise', not small/medium business, not a 
mom & pop or an individual. (the same goes for econ classes by the way)

So the terminology taught to us makes perfect sense from the perspective of the 
‘main books’ of said enterprise. I’d bet the intro or the first chapter even 
qualifies the text accordingly.


Regards,
Adrien

> On Feb 26, 2018, at 6:34 AM, Buddha Buck <blaisepas...@gmail.com> wrote:
> 
> It's not an Australian accounting thing, unless I managed to grab
> Australian book out of my small-city upstate New York library system some
> 30 years ago...
> 
> 
> On Mon, Feb 26, 2018 at 5:38 AM elvis <el...@dogonfire.com> wrote:
> 
>> On 25/02/18 07:54, Dave H wrote:
>>> Well from my point of view that is confusing.  Nobody in my world refers
>> to
>>> a "General Journal" we refer to the "General Ledger" and we do journals
>>> :-)  I've never actually heard the term general journal used anywhere
>>> before until this discussion over the weekend !!!
>> 
>> You weren't in my accounting class where we got the use of the general
>> journal beaten into us :-) I can still remember it 30 years later. Maybe
>> it's an Australian accounting thing.
>>> Cheers Dave H.
>>> 
>>> On 24 February 2018 at 19:58, Geert Janssens <geert.gnuc...@kobaltwit.be
>>> 
>>> wrote:
>>> 
>>> 
>> 
>> ___
>> 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: General Ledger

[Leo Bolta]

I never majored in accounting but I can still remember "General Journal"
being a standard term often used in Canadian high school accounting about 50
years ago.  Recently I picked up an Ontario, Canada bookkeeping text book
from 1882.  It makes a distinction between what are called "Day Books,
Journals and Ledgers".  I'll try to photograph some relative pages in the
next few days and attach them in a post.
Leo

-Original Message-
From: gnucash-user
[mailto:gnucash-user-bounces+lbolta=rogers@gnucash.org] On Behalf Of
Buddha Buck
Sent: February-26-18 7:34 AM
To: elvis
Cc: gnucash-user@gnucash.org
Subject: Re: General Ledger

It's not an Australian accounting thing, unless I managed to grab Australian
book out of my small-city upstate New York library system some 30 years
ago...


On Mon, Feb 26, 2018 at 5:38 AM elvis <el...@dogonfire.com> wrote:

> On 25/02/18 07:54, Dave H wrote:
> > Well from my point of view that is confusing.  Nobody in my world 
> > refers
> to
> > a "General Journal" we refer to the "General Ledger" and we do 
> > journals
> > :-)  I've never actually heard the term general journal used 
> > anywhere before until this discussion over the weekend !!!
>
> You weren't in my accounting class where we got the use of the general 
> journal beaten into us :-) I can still remember it 30 years later. 
> Maybe it's an Australian accounting thing.
> > Cheers Dave H.
> >
> > On 24 February 2018 at 19:58, Geert Janssens 
> > <geert.gnuc...@kobaltwit.be
> >
> > wrote:
> >
> >
>
> ___
> 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: General Ledger

[elvis]

On 25/02/18 07:54, Dave H wrote:

Well from my point of view that is confusing.  Nobody in my world refers to
a "General Journal" we refer to the "General Ledger" and we do journals
:-)  I've never actually heard the term general journal used anywhere
before until this discussion over the weekend !!!


You weren't in my accounting class where we got the use of the general 
journal beaten into us :-) I can still remember it 30 years later. Maybe 
it's an Australian accounting thing.

Cheers Dave H.

On 24 February 2018 at 19:58, Geert Janssens <geert.gnuc...@kobaltwit.be>
wrote:




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

[Mike or Penny Novack]

On 2/25/2018 2:06 PM, Dave H wrote:

Thanks for explaining the distinction Michael.

So I take from all this that the General Journal/General Ledger 
distinction is an historical distinction no longer in real use with 
the advent of computerised accounting software.


No, that wasn't quite what I said. Look at it again.

Even with computerized accounting software might want/need this 
distinction. Might WANT the books partitioned.


For example, in an enterprise of some size (not all that big) you MIGHT 
want (for example)
a) The office manager to have a small fund (petty cash) for things it 
was decided could just be purchased without going through the purchasing 
department.
b) Each sales location to be entering individual sales with only the 
daily totals going to main books.

etc.
Not JUST reducing the work load on the main enterprise bookkeeper. Not 
JUST reducing clutter and unnecessary detail in the main books. Not JUST 
that lower level employees can lack access to look at more than they 
need to (do you want EVERYBODY who needs access to be able to enter data 
to look at, for example, payroll to see what somebody else is getting 
paid. Note that with something like that reduced risk that the office 
manager or somebody in a sales office, etc. could do more than limited 
embezzlement on their own.


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

[Dave H]

Thanks for explaining the distinction Michael.

So I take from all this that the General Journal/General Ledger distinction
is an historical distinction no longer in real use with the advent of
computerised accounting software.  It still doesn't explain for me why the
intent is to rename everything that says General Ledger to General Journal
when General Ledger appears to be the more widely used terminology, at
least in my world.  I work in a large organisation with multiple branches
and many system users having a large Finance Section using dedicated
financial software who will only refer to the "General Ledger", hence my
confusion :-)

Cheers Dave H.


On 26 February 2018 at 02:34, Mike or Penny Novack <
stepbystepf...@dialup4less.com> wrote:

> On 2/24/2018 4:54 PM, Dave H wrote:
>
>> Well from my point of view that is confusing.  Nobody in my world refers
>> to
>> a "General Journal" we refer to the "General Ledger" and we do journals
>> :-)  I've never actually heard the term general journal used anywhere
>> before until this discussion over the weekend !!!
>>
>> Cheers Dave H.
>>
>
> Old time distinction (not that long ago, within my lifetime)
>
> In the really old days (hundreds of years ago) there would be just one
> journal into which all transactions of the enterprise would have been
> entered in chronological order. But as enterprises grew in size and
> complexity, this became burdensome. Can you imagine a merchant enterprise
> that might have thousands of sales a day (perhaps spread over a dozen
> stores). How could some poor bookkeeper get those entered into a single
> journal.
>
> Imagine a solution where at each store was a journal to record the sales
> transaction (a subsidiary journal) while at company headquarters a main
> journal maintained by the company bookkeeper. Call that journal the
> "general journal". So at the agreed time interval (every day, every week,
> etc.) the bookkeeper at each store would transmit a single transaction to
> headquarters (total receipts, total sales) and the head bookkeeper would
> enter those transactions into the "general journal". Things like "petty
> cash" might have their own journal (and ledger) and once a month a
> transaction to "general journal" to the totals of each account and the
> replenishment of cash. Notice that this also allowed restriction of access
> to the main books. The clerks in each store only could access the local
> books.
>
> The term "general journal" (and "general ledger") refer to the MAIN books.
> The confusion for you is that most of us using gnucash are doing so for
> small enough enterprises that we don't need to partition the books this
> way. The only ledger IS the "general ledger" (no subsidiary ledgers) and
> the journal is virtual in any case. We do enter the transaction (and then
> post it) but in effect enter it on already posted form in the ledger an the
> computer can figure out what would have been the journal entry that
> resulted in this. The developers COULD have chosen to have us enter
> transactions into a journal and have the computer auto post those to the
> ledger, but most of us would have found that less direct in terms of
> looking at stuff.
>
> BUT (and this is an important but) perhaps many who are asking for
> "multiple people simultaneously accessing gnucash books" are doing so
> because "too much work for one person" don't know the history, how this WAS
> handled with subsidiary books and gnucash could easily handle it that way.
> With the added benefits that the "local bookkeepers" (the clerks in the
> stores, etc.) can enter the transactions without having access to the main
> books and that main books can avoid the clutter of unnecessary details.
>
> Michael D Novack
>
> 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: General Ledger

[Mike or Penny Novack]

On 2/24/2018 4:54 PM, Dave H wrote:

Well from my point of view that is confusing.  Nobody in my world refers to
a "General Journal" we refer to the "General Ledger" and we do journals
:-)  I've never actually heard the term general journal used anywhere
before until this discussion over the weekend !!!

Cheers Dave H.


Old time distinction (not that long ago, within my lifetime)

In the really old days (hundreds of years ago) there would be just one 
journal into which all transactions of the enterprise would have been 
entered in chronological order. But as enterprises grew in size and 
complexity, this became burdensome. Can you imagine a merchant 
enterprise that might have thousands of sales a day (perhaps spread over 
a dozen stores). How could some poor bookkeeper get those entered into a 
single journal.


Imagine a solution where at each store was a journal to record the sales 
transaction (a subsidiary journal) while at company headquarters a main 
journal maintained by the company bookkeeper. Call that journal the 
"general journal". So at the agreed time interval (every day, every 
week, etc.) the bookkeeper at each store would transmit a single 
transaction to headquarters (total receipts, total sales) and the head 
bookkeeper would enter those transactions into the "general journal". 
Things like "petty cash" might have their own journal (and ledger) and 
once a month a transaction to "general journal" to the totals of each 
account and the replenishment of cash. Notice that this also allowed 
restriction of access to the main books. The clerks in each store only 
could access the local books.


The term "general journal" (and "general ledger") refer to the MAIN 
books. The confusion for you is that most of us using gnucash are doing 
so for small enough enterprises that we don't need to partition the 
books this way. The only ledger IS the "general ledger" (no subsidiary 
ledgers) and the journal is virtual in any case. We do enter the 
transaction (and then post it) but in effect enter it on already posted 
form in the ledger an the computer can figure out what would have been 
the journal entry that resulted in this. The developers COULD have 
chosen to have us enter transactions into a journal and have the 
computer auto post those to the ledger, but most of us would have found 
that less direct in terms of looking at stuff.


BUT (and this is an important but) perhaps many who are asking for 
"multiple people simultaneously accessing gnucash books" are doing so 
because "too much work for one person" don't know the history, how this 
WAS handled with subsidiary books and gnucash could easily handle it 
that way. With the added benefits that the "local bookkeepers" (the 
clerks in the stores, etc.) can enter the transactions without having 
access to the main books and that main books can avoid the clutter of 
unnecessary details.


Michael D Novack

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

[Dave H]

Well from my point of view that is confusing.  Nobody in my world refers to
a "General Journal" we refer to the "General Ledger" and we do journals
:-)  I've never actually heard the term general journal used anywhere
before until this discussion over the weekend !!!

Cheers Dave H.

On 24 February 2018 at 19:58, Geert Janssens <geert.gnuc...@kobaltwit.be>
wrote:

> Op zaterdag 24 februari 2018 00:46:07 CET schreef David Carlson:
> > This thread seems like deja vu to me.  I thought this was discussed
> before
> > and the result was that GnuCash changed the name of one or the other in
> > release 2.6.18 or thereabouts.
> >
> > Am I dreaming?
> >
> > David C
> >
>
> You're not dreaming. This has been discussed before and there was even a
> bugreport for it:
> https://bugzilla.gnome.org/show_bug.cgi?id=122895
>
> I have personally applied all the required changes to use "General Journal"
> consistently in GnuCash. This fix was applied in February 2015. However as
> this affected many translatable strings, I decided back then to fix this
> only
> on master (to become 3.0 soon). So gnucash 2.6 will still use the term
> "General Ledger".
>
> And looking further I have found I then mixed things up in October 2015:
> after
> some discussion I have started changing the term in the stable
> documentation
> as well (2.6.x). So we're now in the unfortunate situation the application
> still uses the term General Ledger and the associated documentation uses
> the
> term General Journal.
>
> I have reverted these unintended corrections on the 2.6 documentation so
> the
> last 2.6.x release will still consistently use the old "General Ledger"
> term
> and 3.0 will consistently switch to "General Journal".
>
> Sorry for the confusion this created.
>
> Regards,
>
> Geert
>
> > On Fri, Feb 23, 2018 at 3:52 PM, Buddha Buck <blaisepas...@gmail.com>
> wrote:
> > > I suspect that GnuCash terminology regarding journals and ledgers is
> > > somewhat confused and non-standard.
> > >
> > > My basic understanding of classical accounting is that transactions
> were
> > > first entered into journals, and then posted into ledgers, one per
> > > account.
> > > The collection of ledger books was the "general ledger", while the
> nominal
> > > time-ordered collection of journal entries was the "general journal"
> (or
> > > the "general journal" was the journal in which transactions which
> didn't
> > > belong in the sales journal, purchase journal, etc were recorded).
> > >
> > > In GnuCash terms, a classical account ledger would correspond to a
> GnuCash
> > > account register. And the classic general journal would correspond to
> > > GnuCash's general ledger. The classic general ledger might even be a
> > > GnuCash book as a whole. I don't know what GnuCash is calling a general
> > > journal.
> > >
> > >
> > >
> > >
> > > On Fri, Feb 23, 2018 at 1:43 PM Adrien Monteleone <
> > >
> > > adrien.montele...@gmail.com> wrote:
> > > > Stan,
> > > >
> > > > No I knew you were referring to the Ledger and I think David did also
> > > > though he linked to the help on the Journal.
> > > >
> > > > Unfortunately, it seems the Help file needs a tweak. (or the
> software)
> > >
> > > The
> > >
> > > > link he gives describes in fact, the General Ledger. The terminology
> on
> > >
> > > the
> > >
> > > > title and within the help article are inconsistent with the naming in
> > > > the
> > > > software. (though Journal is probably the more historically correct
> > > > term,
> > > > the two might be interchangeable)
> > > >
> > > > In the software, the General Journal is a report you can run that
> shows
> > > > ALL transactions. (under the Assets & Liabilities sub-menu) You can’t
> > >
> > > enter
> > >
> > > > anything into it. There is no date selector in the options, and the
> > >
> > > Filter
> > >
> > > > By… in View is not available.
> > > >
> > > > Since I don’t close books I see everything when I look at either.
> > > > Perhaps
> > > > someone who uses that procedure might see only the current accounting
> > > > period - I’m not sure.
> > > >
> > > > To add to t

Re: General Ledger

[Geert Janssens]

Op zaterdag 24 februari 2018 00:46:07 CET schreef David Carlson:
> This thread seems like deja vu to me.  I thought this was discussed before
> and the result was that GnuCash changed the name of one or the other in
> release 2.6.18 or thereabouts.
> 
> Am I dreaming?
> 
> David C
> 

You're not dreaming. This has been discussed before and there was even a 
bugreport for it:
https://bugzilla.gnome.org/show_bug.cgi?id=122895

I have personally applied all the required changes to use "General Journal" 
consistently in GnuCash. This fix was applied in February 2015. However as 
this affected many translatable strings, I decided back then to fix this only 
on master (to become 3.0 soon). So gnucash 2.6 will still use the term 
"General Ledger".

And looking further I have found I then mixed things up in October 2015: after 
some discussion I have started changing the term in the stable documentation 
as well (2.6.x). So we're now in the unfortunate situation the application 
still uses the term General Ledger and the associated documentation uses the 
term General Journal.

I have reverted these unintended corrections on the 2.6 documentation so the 
last 2.6.x release will still consistently use the old "General Ledger" term 
and 3.0 will consistently switch to "General Journal".

Sorry for the confusion this created.

Regards,

Geert

> On Fri, Feb 23, 2018 at 3:52 PM, Buddha Buck <blaisepas...@gmail.com> wrote:
> > I suspect that GnuCash terminology regarding journals and ledgers is
> > somewhat confused and non-standard.
> > 
> > My basic understanding of classical accounting is that transactions were
> > first entered into journals, and then posted into ledgers, one per
> > account.
> > The collection of ledger books was the "general ledger", while the nominal
> > time-ordered collection of journal entries was the "general journal" (or
> > the "general journal" was the journal in which transactions which didn't
> > belong in the sales journal, purchase journal, etc were recorded).
> > 
> > In GnuCash terms, a classical account ledger would correspond to a GnuCash
> > account register. And the classic general journal would correspond to
> > GnuCash's general ledger. The classic general ledger might even be a
> > GnuCash book as a whole. I don't know what GnuCash is calling a general
> > journal.
> > 
> > 
> > 
> > 
> > On Fri, Feb 23, 2018 at 1:43 PM Adrien Monteleone <
> > 
> > adrien.montele...@gmail.com> wrote:
> > > Stan,
> > > 
> > > No I knew you were referring to the Ledger and I think David did also
> > > though he linked to the help on the Journal.
> > > 
> > > Unfortunately, it seems the Help file needs a tweak. (or the software)
> > 
> > The
> > 
> > > link he gives describes in fact, the General Ledger. The terminology on
> > 
> > the
> > 
> > > title and within the help article are inconsistent with the naming in
> > > the
> > > software. (though Journal is probably the more historically correct
> > > term,
> > > the two might be interchangeable)
> > > 
> > > In the software, the General Journal is a report you can run that shows
> > > ALL transactions. (under the Assets & Liabilities sub-menu) You can’t
> > 
> > enter
> > 
> > > anything into it. There is no date selector in the options, and the
> > 
> > Filter
> > 
> > > By… in View is not available.
> > > 
> > > Since I don’t close books I see everything when I look at either.
> > > Perhaps
> > > someone who uses that procedure might see only the current accounting
> > > period - I’m not sure.
> > > 
> > > To add to the confusion, there is also a General Ledger report located
> > > in
> > > that same menu. However, it seems to be the same as the Transaction
> > 
> > Report
> > 
> > > and is much more versatile than the General Journal report.
> > > 
> > > For the record, I don’t see any separate ‘tool’ or ‘register’ called
> > > General Journal at least not in my copy of 2.6.19.
> > > 
> > > Regards,
> > > Adrien
> > > 
> > > > On Feb 23, 2018, at 9:42 AM, Stan Brown <the_stan_br...@fastmail.fm>
> > > 
> > > wrote:
> > > > Thanks, Adrien.
> > > > 
> > > > Please note that I asked about the general ledger, not the general
> > > 
> > > journal, but I see that the filter works the same way (now that I know
> > &

Re: General Ledger

[David Carlson]

This thread seems like deja vu to me.  I thought this was discussed before
and the result was that GnuCash changed the name of one or the other in
release 2.6.18 or thereabouts.

Am I dreaming?

David C

On Fri, Feb 23, 2018 at 3:52 PM, Buddha Buck <blaisepas...@gmail.com> wrote:

> I suspect that GnuCash terminology regarding journals and ledgers is
> somewhat confused and non-standard.
>
> My basic understanding of classical accounting is that transactions were
> first entered into journals, and then posted into ledgers, one per account.
> The collection of ledger books was the "general ledger", while the nominal
> time-ordered collection of journal entries was the "general journal" (or
> the "general journal" was the journal in which transactions which didn't
> belong in the sales journal, purchase journal, etc were recorded).
>
> In GnuCash terms, a classical account ledger would correspond to a GnuCash
> account register. And the classic general journal would correspond to
> GnuCash's general ledger. The classic general ledger might even be a
> GnuCash book as a whole. I don't know what GnuCash is calling a general
> journal.
>
>
>
>
> On Fri, Feb 23, 2018 at 1:43 PM Adrien Monteleone <
> adrien.montele...@gmail.com> wrote:
>
> > Stan,
> >
> > No I knew you were referring to the Ledger and I think David did also
> > though he linked to the help on the Journal.
> >
> > Unfortunately, it seems the Help file needs a tweak. (or the software)
> The
> > link he gives describes in fact, the General Ledger. The terminology on
> the
> > title and within the help article are inconsistent with the naming in the
> > software. (though Journal is probably the more historically correct term,
> > the two might be interchangeable)
> >
> > In the software, the General Journal is a report you can run that shows
> > ALL transactions. (under the Assets & Liabilities sub-menu) You can’t
> enter
> > anything into it. There is no date selector in the options, and the
> Filter
> > By… in View is not available.
> >
> > Since I don’t close books I see everything when I look at either. Perhaps
> > someone who uses that procedure might see only the current accounting
> > period - I’m not sure.
> >
> > To add to the confusion, there is also a General Ledger report located in
> > that same menu. However, it seems to be the same as the Transaction
> Report
> > and is much more versatile than the General Journal report.
> >
> > For the record, I don’t see any separate ‘tool’ or ‘register’ called
> > General Journal at least not in my copy of 2.6.19.
> >
> > Regards,
> > Adrien
> >
> > > On Feb 23, 2018, at 9:42 AM, Stan Brown <the_stan_br...@fastmail.fm>
> > wrote:
> > >
> > > Thanks, Adrien.
> > >
> > > Please note that I asked about the general ledger, not the general
> > journal, but I see that the filter works the same way (now that I know to
> > try it).
> > >
> > > As the documentation mentions only the general journal, maybe "and
> > general ledger" should be added, for the benefit of folks who are
> searching
> > for it?
> > >
> > > --
> > > Stan Brown
> > > the_stan_br...@fastmail.fm
> > > http://BrownMath.com
> > > http://OakRoadSystems.com/
> > >
> > > On Fri, Feb 23, 2018, at 7:52 AM, Adrien Monteleone wrote:
> > >> And unfortunately, this filter change is not sticky. You’ll have to
> > >> reset it each time you load the GL. This is already a filed bug.
> > >>
> > >>> On Feb 23, 2018, at 5:47 AM, David T. via gnucash-user <
> > gnucash-user@gnucash.org> wrote:
> > >>> "The General Journal defaults to showing only the previous month of
> > transactions. This is changeable by using the "Filter By..." on the View
> > menu."
> > >>>
> > >>>> On Feb 23, 2018, at 4:27 PM, Stan Brown <the_stan_br...@fastmail.fm
> >
> > wrote:
> > >>>>
> > >>>> There doesn't seem to be any documentation of Tools » General
> Ledger,
> > >>>> neither in the Help Manual nor in the Concepts Tutorial. (I couldn't
> > >>>> find an answer in the FAQ or Using GnuCash either.)
> > >>>>
> > >>>> I have transactions entered from 2017-12-31 though 2018-01-31. But
> for
> > >>>> some reason, the General Ledger shows only 2018-01-23 through
> > >>>> 2018-01-31. ...
> &

Re: General Ledger

[Adrien Monteleone]

Stan,

No I knew you were referring to the Ledger and I think David did also though he 
linked to the help on the Journal.

Unfortunately, it seems the Help file needs a tweak. (or the software) The link 
he gives describes in fact, the General Ledger. The terminology on the title 
and within the help article are inconsistent with the naming in the software. 
(though Journal is probably the more historically correct term, the two might 
be interchangeable)

In the software, the General Journal is a report you can run that shows ALL 
transactions. (under the Assets & Liabilities sub-menu) You can’t enter 
anything into it. There is no date selector in the options, and the Filter By… 
in View is not available.

Since I don’t close books I see everything when I look at either. Perhaps 
someone who uses that procedure might see only the current accounting period - 
I’m not sure.

To add to the confusion, there is also a General Ledger report located in that 
same menu. However, it seems to be the same as the Transaction Report and is 
much more versatile than the General Journal report.

For the record, I don’t see any separate ‘tool’ or ‘register’ called General 
Journal at least not in my copy of 2.6.19.

Regards,
Adrien

> On Feb 23, 2018, at 9:42 AM, Stan Brown <the_stan_br...@fastmail.fm> wrote:
> 
> Thanks, Adrien.
> 
> Please note that I asked about the general ledger, not the general journal, 
> but I see that the filter works the same way (now that I know to try it). 
> 
> As the documentation mentions only the general journal, maybe "and general 
> ledger" should be added, for the benefit of folks who are searching for it?
> 
> -- 
> Stan Brown
> the_stan_br...@fastmail.fm
> http://BrownMath.com
> http://OakRoadSystems.com/
> 
> On Fri, Feb 23, 2018, at 7:52 AM, Adrien Monteleone wrote:
>> And unfortunately, this filter change is not sticky. You’ll have to 
>> reset it each time you load the GL. This is already a filed bug.
>> 
>>> On Feb 23, 2018, at 5:47 AM, David T. via gnucash-user 
>>> <gnucash-user@gnucash.org> wrote:
>>> "The General Journal defaults to showing only the previous month of 
>>> transactions. This is changeable by using the "Filter By..." on the View 
>>> menu."
>>> 
>>>> On Feb 23, 2018, at 4:27 PM, Stan Brown <the_stan_br...@fastmail.fm> wrote:
>>>> 
>>>> There doesn't seem to be any documentation of Tools » General Ledger,
>>>> neither in the Help Manual nor in the Concepts Tutorial. (I couldn't
>>>> find an answer in the FAQ or Using GnuCash either.)
>>>> 
>>>> I have transactions entered from 2017-12-31 though 2018-01-31. But for
>>>> some reason, the General Ledger shows only 2018-01-23 through
>>>> 2018-01-31. ...
>>>> 
>>>> Please note: I'm talking about the General Ledger _tool_, not the
>>>> report. I want the ability to correct transactions that I get in the tool.
> 

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

[Stan Brown]

Thanks, Adrien.

Please note that I asked about the general ledger, not the general journal, but 
I see that the filter works the same way (now that I know to try it). 

As the documentation mentions only the general journal, maybe "and general 
ledger" should be added, for the benefit of folks who are searching for it?

-- 
Stan Brown
the_stan_br...@fastmail.fm
http://BrownMath.com
http://OakRoadSystems.com/

On Fri, Feb 23, 2018, at 7:52 AM, Adrien Monteleone wrote:
> And unfortunately, this filter change is not sticky. You’ll have to 
> reset it each time you load the GL. This is already a filed bug.
> 
> > On Feb 23, 2018, at 5:47 AM, David T. via gnucash-user 
> > <gnucash-user@gnucash.org> wrote:
> > "The General Journal defaults to showing only the previous month of 
> > transactions. This is changeable by using the "Filter By..." on the View 
> > menu."
> > 
> >> On Feb 23, 2018, at 4:27 PM, Stan Brown <the_stan_br...@fastmail.fm> wrote:
> >> 
> >> There doesn't seem to be any documentation of Tools » General Ledger,
> >> neither in the Help Manual nor in the Concepts Tutorial. (I couldn't
> >> find an answer in the FAQ or Using GnuCash either.)
> >> 
> >> I have transactions entered from 2017-12-31 though 2018-01-31. But for
> >> some reason, the General Ledger shows only 2018-01-23 through
> >> 2018-01-31. ...
> >> 
> >> Please note: I'm talking about the General Ledger _tool_, not the
> >> report. I want the ability to correct transactions that I get in the tool.

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

[Adrien Monteleone]

And unfortunately, this filter change is not sticky. You’ll have to reset it 
each time you load the GL. This is already a filed bug.


> On Feb 23, 2018, at 5:47 AM, David T. via gnucash-user 
> <gnucash-user@gnucash.org> wrote:
> 
> Try https://www.gnucash.org/docs/v2.6/C/gnucash-help/general-journal.html 
> <https://www.gnucash.org/docs/v2.6/C/gnucash-help/general-journal.html>
> 
> "The General Journal defaults to showing only the previous month of 
> transactions. This is changeable by using the "Filter By..." on the View 
> menu."
> 
>> On Feb 23, 2018, at 4:27 PM, Stan Brown <the_stan_br...@fastmail.fm> wrote:
>> 
>> There doesn't seem to be any documentation of Tools » General Ledger,
>> neither in the Help Manual nor in the Concepts Tutorial. (I couldn't
>> find an answer in the FAQ or Using GnuCash either.)
>> 
>> I have transactions entered from 2017-12-31 though 2018-01-31. But for
>> some reason, the General Ledger shows only 2018-01-23 through
>> 2018-01-31. I know that earlier transactions are there, because I can
>> get to them from the Accounts register. But I want the nice overview
>> that the General Ledger tool provides. How can I unlock its date range?
>> There doesn't seem to be anything in Preferences.
>> 
>> Please note: I'm talking about the General Ledger _tool_, not the
>> report. I want the ability to correct transactions that I get in the tool.
>> 
>> -- 
>> Regards,
>> Stan Brown
>> Tompkins County, New York, USA
>> http://BrownMath.com
>> http://OakRoadSystems.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
>> 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.



Regards,
Adrien

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

Re: General Ledger

[David T. via gnucash-user]

Try https://www.gnucash.org/docs/v2.6/C/gnucash-help/general-journal.html 
<https://www.gnucash.org/docs/v2.6/C/gnucash-help/general-journal.html>

"The General Journal defaults to showing only the previous month of 
transactions. This is changeable by using the "Filter By..." on the View menu."

> On Feb 23, 2018, at 4:27 PM, Stan Brown <the_stan_br...@fastmail.fm> wrote:
> 
> There doesn't seem to be any documentation of Tools » General Ledger,
> neither in the Help Manual nor in the Concepts Tutorial. (I couldn't
> find an answer in the FAQ or Using GnuCash either.)
> 
> I have transactions entered from 2017-12-31 though 2018-01-31. But for
> some reason, the General Ledger shows only 2018-01-23 through
> 2018-01-31. I know that earlier transactions are there, because I can
> get to them from the Accounts register. But I want the nice overview
> that the General Ledger tool provides. How can I unlock its date range?
> There doesn't seem to be anything in Preferences.
> 
> Please note: I'm talking about the General Ledger _tool_, not the
> report. I want the ability to correct transactions that I get in the tool.
> 
> -- 
> Regards,
> Stan Brown
> Tompkins County, New York, USA
> http://BrownMath.com
> http://OakRoadSystems.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
> 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: General Ledger

[Derek Atkins]

Look in the View menu.

-derek
Sent using my mobile device. Please excuse any typos.



On February 23, 2018 6:28:00 AM Stan Brown <the_stan_br...@fastmail.fm> wrote:


There doesn't seem to be any documentation of Tools » General Ledger,
neither in the Help Manual nor in the Concepts Tutorial. (I couldn't
find an answer in the FAQ or Using GnuCash either.)

I have transactions entered from 2017-12-31 though 2018-01-31. But for
some reason, the General Ledger shows only 2018-01-23 through
2018-01-31. I know that earlier transactions are there, because I can
get to them from the Accounts register. But I want the nice overview
that the General Ledger tool provides. How can I unlock its date range?
There doesn't seem to be anything in Preferences.

Please note: I'm talking about the General Ledger _tool_, not the
report. I want the ability to correct transactions that I get in the tool.

--
Regards,
Stan Brown
Tompkins County, New York, USA
http://BrownMath.com
http://OakRoadSystems.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
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.

General Ledger

[Stan Brown]

There doesn't seem to be any documentation of Tools » General Ledger,
neither in the Help Manual nor in the Concepts Tutorial. (I couldn't
find an answer in the FAQ or Using GnuCash either.)

I have transactions entered from 2017-12-31 though 2018-01-31. But for
some reason, the General Ledger shows only 2018-01-23 through
2018-01-31. I know that earlier transactions are there, because I can
get to them from the Accounts register. But I want the nice overview
that the General Ledger tool provides. How can I unlock its date range?
There doesn't seem to be anything in Preferences.

Please note: I'm talking about the General Ledger _tool_, not the
report. I want the ability to correct transactions that I get in the tool.

-- 
Regards,
Stan Brown
Tompkins County, New York, USA
http://BrownMath.com
http://OakRoadSystems.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
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: Copying transactions from an account to the general ledger

[Mike or Penny Novack]

On 2/6/2018 12:15 PM, Mike Donovan wrote:

Having recorded many transactions to the cash account, I would like to copy 
these to the GL (which has no transactions currently) and then use the GL for 
recording all future transactions. Can this be done? Thanks.

Sent from Mail for Windows 10

Review the intro to double entry bookkeeping.

a) The cash account IS a ledger account.
b) Each transaction you entered (entering from the cash account) had 
ANOTHER (at least one other) account associated with it, the other side 
of the transactions. If you did not specify that other account, gnucash 
used the account "Imbalance" as a (temporary) default account. You need 
to FIX each of these (change to the correct account)
c) Gnucash only has a ledger. The journal is virtual (you can run a 
report that will show it to you).


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: Copying transactions from an account to the general ledger

[Mike Donovan]

Adrien:

Thanks again. Geert’s recommendation regarding the filter solved my problem.

Regards,
Mike

Sent from Mail for Windows 10

From: Adrien Monteleone
Sent: Tuesday, February 6, 2018 3:43 PM
To: gnucash-user
Subject: Re: Copying transactions from an account to the general ledger

Mike,

See the replies by Geert and John.

The GL by default only shows the last 30 days of transactions. If the 
transactions you entered previously were dated more than 30 days ago, you won’t 
see them. Turn off the default filter first as they mentioned.

As John noted, be wary of entering directly in the GL. You CAN do so, but it’s 
not necessarily the best practice. Unlike other registers, it is not an 
account, merely a view of all accounts. Entering from another register, you can 
default to a split containing the account you are in holding the balance. The 
GL has no such option since it isn’t an account, you’ll have to be careful to 
enter both debit and credit lines before entering out of the transaction or 
you’ll have a mess of unbalanced entries to clean up.

For example, if I’m entering an expense paid with cash, I open the cash account 
register, enter my debit expense split and the register includes the matching 
split as a credit to cash already there for me. I also don’t have the option of 
deleting that cash split since it would ‘un-link’ the transaction to that 
register. This helps me enter transactions properly without mistakes. Normally, 
I use Transaction Journal view by default, but this is even more important if 
using Basic view which only shows one account split.

Also, please copy the list on all replies so others can benefit from the 
exchange.

Regards,
Adrien

> On Feb 6, 2018, at 1:42 PM, Mike Donovan <donovan.michae...@gmail.com> wrote:
> 
> Adrien,
>  
> Thanks for your reply. When I go to Tools> General Ledger, I show a new line 
> waiting for transaction entry. No other transactions are shown. Is it 
> possible that I need to change a setting to get your (favorable) result?
>  
> Regards,
> Mike
>  
> Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10
>  
> From: Adrien Monteleone <mailto:adrien.montele...@gmail.com>
> Sent: Tuesday, February 6, 2018 12:59 PM
> To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
> Subject: Re: Copying transactions from an account to the general ledger
>  
> Mike,
>  
> There’s no copying anything to the General Ledger. The GL is simply a 
> consolidated view of all accounts. Your transactions should be there. I just 
> did a test with a fresh book, entered some transactions in Cash, opened the 
> GL and the transactions were all there. I presume you are going to Tools > 
> General Ledger right?
>  
> Certainly you can enter transactions in the GL only if you prefer. 
> Personally, I like to enter them in the account the money is coming from to 
> keep my entries straight. (some enter their credit card charges as expenses 
> from the card liability account for the same reason)
>  
>  
> Regards,
> Adrien
>  
> > On Feb 6, 2018, at 11:15 AM, Mike Donovan <donovan.michae...@gmail.com> 
> > wrote:
> > 
> > Having recorded many transactions to the cash account, I would like to copy 
> > these to the GL (which has no transactions currently) and then use the GL 
> > for recording all future transactions. Can this be done? Thanks.
> > 
> > Sent from Mail for Windows 10
> > 
> > 
> > 
> > ---
> > This email has been checked for viruses by Avast antivirus software.
> > https://www.avast.com/antivirus
> > ___
> > 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 <mailto:gnucash-user@gnucash.org>
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists 
> <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: Re: Copying transactions from an account to the general ledger

[Mike Donovan]

Geert:

Thanks for your helpful reply. I can now see all transactions.

Best Wishes,
Mike

Sent from Mail for Windows 10



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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: Copying transactions from an account to the general ledger

[Adrien Monteleone]

Mike,

See the replies by Geert and John.

The GL by default only shows the last 30 days of transactions. If the 
transactions you entered previously were dated more than 30 days ago, you won’t 
see them. Turn off the default filter first as they mentioned.

As John noted, be wary of entering directly in the GL. You CAN do so, but it’s 
not necessarily the best practice. Unlike other registers, it is not an 
account, merely a view of all accounts. Entering from another register, you can 
default to a split containing the account you are in holding the balance. The 
GL has no such option since it isn’t an account, you’ll have to be careful to 
enter both debit and credit lines before entering out of the transaction or 
you’ll have a mess of unbalanced entries to clean up.

For example, if I’m entering an expense paid with cash, I open the cash account 
register, enter my debit expense split and the register includes the matching 
split as a credit to cash already there for me. I also don’t have the option of 
deleting that cash split since it would ‘un-link’ the transaction to that 
register. This helps me enter transactions properly without mistakes. Normally, 
I use Transaction Journal view by default, but this is even more important if 
using Basic view which only shows one account split.

Also, please copy the list on all replies so others can benefit from the 
exchange.

Regards,
Adrien

> On Feb 6, 2018, at 1:42 PM, Mike Donovan <donovan.michae...@gmail.com> wrote:
> 
> Adrien,
>  
> Thanks for your reply. When I go to Tools> General Ledger, I show a new line 
> waiting for transaction entry. No other transactions are shown. Is it 
> possible that I need to change a setting to get your (favorable) result?
>  
> Regards,
> Mike
>  
> Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10
>  
> From: Adrien Monteleone <mailto:adrien.montele...@gmail.com>
> Sent: Tuesday, February 6, 2018 12:59 PM
> To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
> Subject: Re: Copying transactions from an account to the general ledger
>  
> Mike,
>  
> There’s no copying anything to the General Ledger. The GL is simply a 
> consolidated view of all accounts. Your transactions should be there. I just 
> did a test with a fresh book, entered some transactions in Cash, opened the 
> GL and the transactions were all there. I presume you are going to Tools > 
> General Ledger right?
>  
> Certainly you can enter transactions in the GL only if you prefer. 
> Personally, I like to enter them in the account the money is coming from to 
> keep my entries straight. (some enter their credit card charges as expenses 
> from the card liability account for the same reason)
>  
>  
> Regards,
> Adrien
>  
> > On Feb 6, 2018, at 11:15 AM, Mike Donovan <donovan.michae...@gmail.com> 
> > wrote:
> > 
> > Having recorded many transactions to the cash account, I would like to copy 
> > these to the GL (which has no transactions currently) and then use the GL 
> > for recording all future transactions. Can this be done? Thanks.
> > 
> > Sent from Mail for Windows 10
> > 
> > 
> > 
> > ---
> > This email has been checked for viruses by Avast antivirus software.
> > https://www.avast.com/antivirus
> > ___
> > 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 <mailto:gnucash-user@gnucash.org>
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists 
> <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.
>  
> 
>  
> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=icon>
>   Virus-free. www.avast.com 
> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=link>
___

Re: Copying transactions from an account to the general ledger

[John Ralls]

> On Feb 6, 2018, at 9:15 AM, Mike Donovan <donovan.michae...@gmail.com> wrote:
> 
> Having recorded many transactions to the cash account, I would like to copy 
> these to the GL (which has no transactions currently) and then use the GL for 
> recording all future transactions. Can this be done? Thanks.

GnuCash doesn’t have a GL as a separate account. There’s a General Ledger 
register view (Tools>General Ledger; afterwards use View>Filter By... to select 
the date range displayed)
that shows all transactions sorted by date and in split view; this is the same 
view that you get if you run Edit>Find... from the Accounts page.

Assuming that the transactions that you recorded in the cash account were in 
fact cash transactions and that you want to track your cash balance (GnuCash’s 
“common accounts” template includes a “Cash in Wallet” account for this 
purpose) then you’re doing the right thing.

You don’t want a GL account that isn’t associated with a particular actual 
account or physical location of currency (e.g. cash in my wallet, cash in 
wife’s wallet, cash in wall safe, etc.); you’ll just wind up with an 
unbalanceable mess.

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: Copying transactions from an account to the general ledger

[Adrien Monteleone]

Mike,

There’s no copying anything to the General Ledger. The GL is simply a 
consolidated view of all accounts. Your transactions should be there. I just 
did a test with a fresh book, entered some transactions in Cash, opened the GL 
and the transactions were all there. I presume you are going to Tools > General 
Ledger right?

Certainly you can enter transactions in the GL only if you prefer. Personally, 
I like to enter them in the account the money is coming from to keep my entries 
straight. (some enter their credit card charges as expenses from the card 
liability account for the same reason)


Regards,
Adrien

> On Feb 6, 2018, at 11:15 AM, Mike Donovan <donovan.michae...@gmail.com> wrote:
> 
> Having recorded many transactions to the cash account, I would like to copy 
> these to the GL (which has no transactions currently) and then use the GL for 
> recording all future transactions. Can this be done? Thanks.
> 
> Sent from Mail for Windows 10
> 
> 
> 
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> 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: Copying transactions from an account to the general ledger

[Geert Janssens]

Op dinsdag 6 februari 2018 18:15:35 CET schreef Mike Donovan:
> Having recorded many transactions to the cash account, I would like to copy
> these to the GL (which has no transactions currently) and then use the GL
> for recording all future transactions. Can this be done? Thanks.
> 
> Sent from Mail for Windows 10

*All* transactions are in the general ledger automatically.

If you don't see them there, that's probably because the general ledger is by 
default filtered to the transactions of the past 30 days.

Try View/Filter By... to remove this filter. Unfortunately it's not retained 
so you'll have to do it each time you open the GL.

Regards,

Geert


___
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: Copying transactions from an account to the general ledger

[Anthony Hepple]

Hi Mike

The easiest way I know of, to move ALL the transactions from one
account to an empty account, is to simply rename the account!

On 6 February 2018 at 17:15, Mike Donovan  wrote:
> Having recorded many transactions to the cash account, I would like to copy 
> these to the GL (which has no transactions currently) and then use the GL for 
> recording all future transactions. Can this be done? Thanks.

-- 
Anthony Hepple
01704 227828 / 07931 504049
http://www.dhdevelopment.co.uk
___
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: export general ledger

[Geert Janssens]

Op dinsdag 19 december 2017 15:58:38 CET schreef Adrien Monteleone:
> Thanks Geert,
> 
> Good to know if I ever need this, export is not the way to go.
> 
> Out of curiosity, could you shed light on why the limitation to export only
> one account type at a time?
> 
> Regards,
> Adrien

I believe this stems from the state of import/export at the time this feature 
was added. Csv import was primarily intended to import bank statements and 
with that limited scope had limited functionality. The csv export was written 
as an inverse operation for this csv import, and in that mindset it was never 
considered to export the GL as the csv import wouldn't be able to import it 
anyway (support for roundtrip export-import was taken in consideration but not 
properly implemented).

In 2.7 the csv importer has been made much more flexible and I believe it 
would even be able to import GL like transaction data now.

The csv exporter has not (yet) gotten the same attention in 2.7 so GL export 
is still not available. It would make more sense now though to line it up with 
the improved csv importer.

Is there an enhancement request for this ? If not, feel free to file one.

Regards,

Geert
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: export general ledger

[Adrien Monteleone]

Thanks Geert,

Good to know if I ever need this, export is not the way to go.

Out of curiosity, could you shed light on why the limitation to export only one 
account type at a time?

Regards,
Adrien

> On Dec 19, 2017, at 2:16 AM, Geert Janssens <geert.gnuc...@kobaltwit.be> 
> wrote:
> 
> Op dinsdag 19 december 2017 02:55:14 CET schreef Adrien Monteleone:
>> Sorry if my understanding of the GC General Ledger was off.
>> 
>> By combining the files, I meant the exported csv files. So a simple: “cat *
>>> gnucash.csv” after those 4 exports would do the trick.
>> 
> You'd probably end up with lots of duplicate transactions rather than a 
> properly exported general ledger...
> 
> Geert

___
gnucash-user mailing list
gnucash-user@gnucash.org
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: export general ledger

[Geert Janssens]

Op dinsdag 19 december 2017 02:55:14 CET schreef Adrien Monteleone:
> Sorry if my understanding of the GC General Ledger was off.
> 
> By combining the files, I meant the exported csv files. So a simple: “cat *
> > gnucash.csv” after those 4 exports would do the trick.
> 
You'd probably end up with lots of duplicate transactions rather than a 
properly exported general ledger...

Geert
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: export general ledger

[Adrien Monteleone]

Jeff,

If you have piles of invoices, and you like data entry spreadsheet/text style, 
you can set up an import csv for them instead and bring them in all at once.

There’s a few threads here about the format not too long ago. (within the year)

Regards,
Adrien

> On Dec 18, 2017, at 1:06 PM, Jeff Abrahamson <j...@p27.eu> wrote:
> 
> Thanks, Adrien.  In the end, as long as I can automate this, I'll be
> happy.  (I haven't fully followed on on the python solution, but it sure
> looks like it will work fine, so I've chalked it up as future work for
> me rather than potential workflow blocking today.  Always good to have a
> project over Christmas.)
> 
> Ultimately, it's a user experience issue, and I don't have any vision at
> all of what gnucash users expect.  The accounting software I've used
> previously was geared towards professional accountants, and some of the
> features (like journal entry rather than account entry) I found really
> convenient once I got used to them.  Faced with a pile of bills, for
> example, it was great to be able to enter them all from their respective
> a/p to their respective expense accounts without a single mouse click,
> just a steady stream of typing bill numbers, descriptions, amounts, and
> debit and credit account numbers.
> 
> Again, my perspective is keeping the books for a rowing club.  I'm sure
> that matters in terms of what I find convenient or not.
> 
> Jeff
> 
> 
> On 18/12/17 19:13, Adrien Monteleone wrote:
>> Jeff,
>> 
>> If I recall correctly from other discussion, the General Ledger is not it’s 
>> own entity. It’s a ‘view’ of the separate account ledgers all rolled into 
>> one. This is probably why there is no export option for it.
>> 
>> GnuCash takes the opposite approach from paper books.
>> 
>> With paper, you enter everything in a General Journal and then later post 
>> the proper amounts to T-accounts.
>> 
>> With GnuCash, you skip the Journal and enter directly to the accounts.
>> 
>> The General Ledger was provided for the benefit of those who were used to 
>> the paper method and wanted the option to see all transactions in 
>> chronological order regardless of accounts used.
>> 
>> But I don’t see why you can’t combine the files after the fact. That’s an 
>> easy concatenation command.
>> 
>> It is curious that you can’t export ‘all’ transactions and have to choose 
>> only one hierarchy at a time.
>> 
>> Regards,
>> Adrien
>> 
>>> On Dec 17, 2017, at 1:31 PM, Jeff Abrahamson <j...@p27.eu> wrote:
>>> 
>>> I'd like to export the general ledger to a csv file.  When I use File ->
>>> Export, however, I'm offered a choice of exporting income, expenses,
>>> assets, or liabilities.  But I'd like to have all transactions in the
>>> csv file.
>>> 
>>> I think I see how to do this using python (the example script
>>> account_analysis.py in the examples is instructive).  But this seems so
>>> basic I suspect I'm missing something.
>>> 
>>> Many thanks for any pointers.
>>> 
>>> -- 
>>> 
>>> Jeff Abrahamson
>>> +33 6 24 40 01 57
>>> +44 7920 594 255
>>> 
>>> http://p27.eu/jeff/
>>> 
>>> 
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> 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
>> 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.
> 
> -- 
> 
> Jeff Abrahamson
> +33 6 24 40 01 57
> +44 7920 594 255
> 
> http://p27.eu/jeff/
> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
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: export general ledger

[Adrien Monteleone]

Sorry if my understanding of the GC General Ledger was off.

By combining the files, I meant the exported csv files. So a simple: “cat * > 
gnucash.csv” after those 4 exports would do the trick.

Regards,
Adrien

> On Dec 18, 2017, at 1:17 PM, Wm via gnucash-user <gnucash-user@gnucash.org> 
> wrote:
> 
> On 18/12/2017 18:13, Adrien Monteleone wrote:
>> Jeff,
>> If I recall correctly from other discussion, the General Ledger is not it’s 
>> own entity. It’s a ‘view’ of the separate account ledgers all rolled into 
>> one. This is probably why there is no export option for it.
> 
> You recall incorrectly.  The general ledger is (as the name suggests) 
> actually about as pure a view as the UI gives of the entirety of a gnc set of 
> accounts as is available.
> 
> gnc does not actually have separate account ledgers at all, it belongs to the 
> stream of transactions accounting family.
> 
>> GnuCash takes the opposite approach from paper books.
> 
> that may be correct or incorrect, depending on where you learned accounting.
> 
>> With paper, you enter everything in a General Journal and then later post 
>> the proper amounts to T-accounts.
> 
> Not in UK accounting you don't.  In UK accounting you do it the other way :)
> 
>> With GnuCash, you skip the Journal and enter directly to the accounts.
>> The General Ledger was provided for the benefit of those who were used to 
>> the paper method and wanted the option to see all transactions in 
>> chronological order regardless of accounts used.
> 
> 
> Bollocks.
> 
>> But I don’t see why you can’t combine the files after the fact. That’s an 
>> easy concatenation command.
> 
> Oh, for fuck's sake.  There are no separate files, it is a stream of 
> transactions.
> 
>> It is curious that you can’t export ‘all’ transactions and have to choose 
>> only one hierarchy at a time.
> 
> Yes, that is a bit weird, but it is probably like that because someone had 
> the same misunderstanding as you about separate account ledgers 15 or more 
> years ago.
> 
> -- 
> Wm
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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.