Re: [GNC] Does anyone produce a "UK balance sheet" (FRS 102) ?

[Adrian Yong]

Apologies, my complaint was about General Leger...

On Sat, Dec 11, 2021 at 5:02 PM Adrian Yong 
wrote:

> Hi David,
>
> I asked for the same thing but was told that since entries are made using
> the double entry system, Assets = Liability + Proprietorship is complied
> with...
>
> I download the transaction report and used that as a basis to generate my
> balance sheet using excel... Those accounts without transactions in the
> accounting period will have their balances brought forward ie. Equity...
>
> Regards,
> Adrian
>
> On Sat, 11 Dec. 2021, 11:42 Dr. David Kirkby, <
> drkir...@kirkbymicrowave.co.uk> wrote:
>
>> I realise this is not something the developers can realistically do, but I
>> wonder if anyone has configured GnuCash to produce a balance sheet that
>> looks like one that would be submitted to Companies House in the UK? (I
>> attached a copy of mine, without obfuscating it, since the data can be
>> found online at Companies House).
>>
>> Whenever I pick up a book on accounting, it normally shows something like
>> this.
>>
>> 1) Adds up all the fixed assets, and gives a total for fixed assets.
>> 2) Adds up all the current assets, and gives a total for current assets
>> 3) Adds the fixed and current assets to get a total of *all *assets
>>
>> That all seems very logical to me.
>>
>> *But a balance sheet submitted to Companies House does not show the total
>> assets.* One would have to get a calculator out to work them out, by
>> adding
>> the fixed assets and current assets.  I thought this very weird, and
>> perhaps just a bizarre way my accountant produces the balance sheet, so I
>> checked another UK company. That was exactly the same. The balance sheet
>> is
>> prepared in accordance with FRS 102. That's a 404 page document
>>
>>
>> https://www.frc.org.uk/getattachment/69f7d814-c806-4ccc-b451-aba50d6e8de2/FRS-102-FRS-applicable-in-the-UK-and-Republic-of-Ireland-(March-2018).pdf
>>
>> with numerous amendments (some related to coronavirus). Realistically,
>> that's only going to be readable by someone with a good knowledge of
>> accounting - not an engineer/scientist like me. So I did not bother
>> looking
>> at that.
>>
>> Looking down the balance sheet for my company I see the following in order
>>
>> 1) Tangible Fixed Assets
>> 2) Current Assets
>> 3) Creditors amounts falling due within one year.
>> 4) Net current liabilities (that's equal to #2 - #3)
>> 5) Total assets less current liabilities (that's #1 + #2 - #3)
>> 6) Provision for liabilities  - I can't work out how that's calculated,
>> but
>> I see it is of uncertain timing and amounts. I guess I should ask my
>> accountant how he came up with the figure. (*With the usual disclaimers,
>> does anyone know whether that would be sensibly listed in GnuCash as a
>> liability, despite its only an estimate?*)
>> 7) Net assets (I can't work out how that's arrived at)
>> 8) Shareholders - same as net assets.
>>
>> I think I will write myself a computer program, that tries every
>> combination of figures to arrive at others. I think if I add every
>> combination, I will get there eventually. I have a computer with two
>> 26-core CPUs and 384 GB RAM, so I should just about have enough computer
>> power. 
>>
>> I'm thinking there's a good chance that someone in the UK has decided to
>> make his/her balance sheet the same, despite it seems rather obscure.
>>
>> Dave
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Does anyone produce a "UK balance sheet" (FRS 102) ?

[Adrian Yong]

Hi David,

I asked for the same thing but was told that since entries are made using
the double entry system, Assets = Liability + Proprietorship is complied
with...

I download the transaction report and used that as a basis to generate my
balance sheet using excel... Those accounts without transactions in the
accounting period will have their balances brought forward ie. Equity...

Regards,
Adrian

On Sat, 11 Dec. 2021, 11:42 Dr. David Kirkby, <
drkir...@kirkbymicrowave.co.uk> wrote:

> I realise this is not something the developers can realistically do, but I
> wonder if anyone has configured GnuCash to produce a balance sheet that
> looks like one that would be submitted to Companies House in the UK? (I
> attached a copy of mine, without obfuscating it, since the data can be
> found online at Companies House).
>
> Whenever I pick up a book on accounting, it normally shows something like
> this.
>
> 1) Adds up all the fixed assets, and gives a total for fixed assets.
> 2) Adds up all the current assets, and gives a total for current assets
> 3) Adds the fixed and current assets to get a total of *all *assets
>
> That all seems very logical to me.
>
> *But a balance sheet submitted to Companies House does not show the total
> assets.* One would have to get a calculator out to work them out, by adding
> the fixed assets and current assets.  I thought this very weird, and
> perhaps just a bizarre way my accountant produces the balance sheet, so I
> checked another UK company. That was exactly the same. The balance sheet is
> prepared in accordance with FRS 102. That's a 404 page document
>
>
> https://www.frc.org.uk/getattachment/69f7d814-c806-4ccc-b451-aba50d6e8de2/FRS-102-FRS-applicable-in-the-UK-and-Republic-of-Ireland-(March-2018).pdf
>
> with numerous amendments (some related to coronavirus). Realistically,
> that's only going to be readable by someone with a good knowledge of
> accounting - not an engineer/scientist like me. So I did not bother looking
> at that.
>
> Looking down the balance sheet for my company I see the following in order
>
> 1) Tangible Fixed Assets
> 2) Current Assets
> 3) Creditors amounts falling due within one year.
> 4) Net current liabilities (that's equal to #2 - #3)
> 5) Total assets less current liabilities (that's #1 + #2 - #3)
> 6) Provision for liabilities  - I can't work out how that's calculated, but
> I see it is of uncertain timing and amounts. I guess I should ask my
> accountant how he came up with the figure. (*With the usual disclaimers,
> does anyone know whether that would be sensibly listed in GnuCash as a
> liability, despite its only an estimate?*)
> 7) Net assets (I can't work out how that's arrived at)
> 8) Shareholders - same as net assets.
>
> I think I will write myself a computer program, that tries every
> combination of figures to arrive at others. I think if I add every
> combination, I will get there eventually. I have a computer with two
> 26-core CPUs and 384 GB RAM, so I should just about have enough computer
> power. 
>
> I'm thinking there's a good chance that someone in the UK has decided to
> make his/her balance sheet the same, despite it seems rather obscure.
>
> Dave
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] General Ledger amounts missing

[Adrian Yong]

Hi All,

I have raised this detail before...

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

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

Regards,
Adrian

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

> Sharon, not sure, but the simple answer seems to be that under "edit
> report options" you didn't change the start and end dates.  The reports
> default to the current accounting period and you need the start and end of
> the year.  Hope this helps.
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com   email
>
> 
> From: gnucash-user  on
> behalf of sydnorbill...@bellsouth.net 
> Sent: Thursday, November 4, 2021 7:05 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] General Ledger amounts missing
>
> Relative newbie, even though using gnucash for four years, but only use it
> once a year to prepare for tax filing and by the next time filing comes
> around the following year I forget a lot of how it worked.
>
>
>
> In trying to print out a General Ledger report, after selecting reports and
> General Ledger under Assets & Liabilities, then going to options and
> selecting the obvious under GENERAL, then DISPLAY, and ACCOUNTS when I
> click
> OK, the report that comes up has NO AMOUNTS on it?
>
>
>
> What simple item am I missing?
>
>
>
> Sharon
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Big problem GC 4.6 wiping history list? Mac OS Big Sur

[Adrian Yong]

Hi Anita,

That is my greatest fear... Hope you managed to resolve the issues.. Please
share your experience...

Regards,
Adrian

On Wed, Jun 30, 2021 at 12:07 PM Anita Graves 
wrote:

> Please see the attached screenshot:
>
> I don’t know what to do but I refuse to delete the file I need to work
> with, or any of the other files in the history list.  This all happened to
> me when I installed GC 4.6.  Before I was using 4.1.  Now, when I try to
> import a log file it gives the same screen.   Then GC crashes!
>
> I am afraid to wipe all my history and all my work!
>
> Thanks for your help and suggestions.
>
> Anita
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] GnuCash 4.6 Released

[Adrian Yong]

Hi,

I am using v3.7. Is there a *procedure *for me to upgrade to v4.6 without
risk loss of data ? Like, can I run two versions of GNUcash on the same
data files until I am certain that the updated version is running properly ?

Thank you.

Regards,
Adrian

On Mon, Jun 28, 2021 at 9:41 PM Fross, Michael  wrote:

> Absolutely. The generosity is humbling and very much appreciated.
>
> On Mon, Jun 28, 2021 at 4:41 AM Mahon Finbar  wrote:
>
> > +1
> >
> > On 28/06/2021 03:29, Stan Brown wrote:
> > > On 2021-06-27 14:51, John Ralls wrote:
> > >> The GnuCash development team announces GnuCash 4.6, the sixth release
> > in the stable 4.x series
> > >> Between 4.5 and 4.6, the following bugfixes were accomplished:
> > > ...
> > >
> > > It's change logs like this that remind me what a massive effort GnuCash
> > > is. My thanks to you and all the development team -- your work is very
> > > much appreciated!
> > >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] GnuCash v3.7 - Trial Balance giving zeros

[Adrian Yong]

Hi,

I am using v3.7 and for FY ending 2020; I am getting zeros in my Trial
Balance. It was ok for 2019.

Any advice on what I should do ?

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] Gnucash 4.1

[Adrian Yong]

Hi All,

If I download a version which doesn't start; I can simply download another
version provided my files stays in the desktop folder (by default) ?

I am running V3.7 and thinking upgrading V 4.1. Can I do that in one shot
or do I have to upgrade to V 3.9 and then 4.1 ?

Thanks...

Regards,
Adrian

On Wed, 5 Aug. 2020, 07:51 David H,  wrote:

> Hi John,
>
> Go to gnucash.org and click the Download GnuCash 4.1 Apple macOS >= 10.13
> :High Sierra" link if you are on High Sierra 10.13 or later, see pic
> below...
>
> Direct link is
>
> https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/4.1/Gnucash-Intel-4.1-2.dmg/download
>
> Regards David H.
>
>
> On Wed, 5 Aug 2020 at 09:38, John Donnee  wrote:
>
> > My problem might be that I downloaded the PC version. I did not see a
> .dmg
> > file.
> >
> > Thanks
> >
> > John
> >
> > On Tue, Aug 4, 2020 at 5:40 PM David H  wrote:
> >
> >> Hi John,
> >>
> >> So you said you're on an iMac previously so you presumably hopefully
> >> downloaded Gnucash-Intel-4.1-1.dmg.  Double clicking on that shows the
> >> contents of the dmg.  What I typically do is select all the files, 6 in
> >> this case, and simply drag and drop them into my Applications/GnuCash
> >> folder and they overwrite the previous version. While I've got the
> >> Applications/GnuCash folder open I double click on the Gnucash.app to
> open
> >> Gnucash just to check it's going to open ok and also check the version
> >> details on the Gnucash splash screen.  After that I revert to using the
> >> Gnucash shortcut in my dock.
> >>
> >> Cheers David H.
> >>
> >>
> >> On Wed, 5 Aug 2020 at 01:49, John Donnee  wrote:
> >>
> >>> Gents, I downloaded the 4.1 folder from SourceForge and when I open the
> >>> folder I do not see an “Install” icon.
> >>>
> >>> What an I missing.
> >>>
> >>> Thanks
> >>> John Donnee
> >>>
> >>> 910.622.8111
> >>> 317 Mount Eden Place
> >>> <
> https://www.google.com/maps/search/317+Mount+Eden+Place+%0D%0ACary,+NC+27518?entry=gmail=g
> >
> >>> Cary, NC 27518
> >>> <
> https://www.google.com/maps/search/317+Mount+Eden+Place+%0D%0ACary,+NC+27518?entry=gmail=g
> >
> >>>
> >>> ___
> >>> gnucash-user mailing list
> >>> gnucash-user@gnucash.org
> >>> To update your subscription preferences or to unsubscribe:
> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>> If you are using Nabble or Gmane, please see
> >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>> -
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >>>
> >> --
> > John J Donnee
> >
> > 317 Mount Eden Place
> > Cary, NC 27518
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Potential regression: PDFs generated using "Make PDF" have a superfluous blank page

[Adrian Yong]

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


On Tue, Jun 30, 2020 at 2:47 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> I can confirm this on 3.906 (4.0 beta) using various methods of printing
> invoices. (it doesn’t seem to matter if it is ‘easy’ invoice or not)
>
> I also tried exporting to HTML and then printing to PDF, but that too
> generates an extra page.
>
> I haven’t yet tested with 3.5–3.7 to see what the differences in the HTML
> are.
>
> While I did find some minor syntax issues with the HTML and CSS,
> correcting them didn’t resolve the issue. There doesn’t appear to be
> anything at first glance in the HTML itself that would generate the extra
> page.
>
> Note, GnuCash has a BugZilla instance at https://bugs.gnucash.org
>
> Please create an account and file the bug there.
>
> Regards,
> Adrien
>
> > On Jun 29, 2020 w27d181, at 5:31 AM, Yves-Eric Martin <
> yem_lists.gnucash@filter.yve.net> wrote:
> >
> > Hi all,
> >
> > (Full bug report below)
> >
> > I am having a PDF issue trying to upgrade from 3.7 to 4.0, but traced the
> > problem back to 3.8. The invoice PDFs generated using "Make PDF" have a
> > superfluous blank page. I first thought the problem may be with my
> heavily
> > customized CSS, but I was able to reproduce the issue with the
> > vanilla invoices (Easy / Printable / Fancy).
> >
> > Any idea what introduced this change? Is a fix needed?
> >
> > And short of manually editing the PDFs, is there a workaround to remove
> > that extra blank page on the GnuCash side, maybe editing some SCM files?
> > Thank you.
> >
> >
> > Full bug report:
> >
> > GnuCash versions: tested all stable from 3.5 to 4.0
> >
> > OS: MacOS Catalina (10.15.5)
> >
> > Problem: Invoice PDFs generated using "Make PDF" have a superfluous blank
> > page.
> >
> > Versions not affected: 3.5, 3.6, 3.7
> >
> > Versions affected: 3.8, 3.9, 3.10, 3.11, 4.0
> >
> > Steps to reproduce:
> > 1) Create a dummy invoice with a single line
> > 2) Create an Easy Invoice: Reports > Business > Easy Invoice
> > 3) Select the dummy invoice: Edit > Report Options > General > Invoice
> > Number > Select the dummy invoice
> > 4) Make Pdf
> >
> > Expected behavior: The generated PDF has only 1 page.
> >
> > Current behavior (since 3.8): The generated PDF has a superfluous blank
> > page.
> >
> > Comparison of various invoice PDFs, generated with 3.7 and 3.8:
> >
> https://www.dropbox.com/sh/h8hwhy43uiz9c8m/AADslcR3uJtfXy5Q7GTn6FqVa?dl=0
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] QUESTION: transaction classes (tags) like QuickBooks?

[Adrian Yong]

Thanks Liz..

Very valid point... I don't have much problems with GNUcash...

On Tue, Jun 23, 2020 at 4:33 PM Liz Dodd  wrote:

> On Mon, 22 Jun 2020 20:06:05 +0800
> Adrian Yong  wrote:
>
> > As Gnucash is still under development,
>
> This is a place to point out a difference in view points.
>
> Lots of software is still under development. Most commercial software
> is, so that they can sell you a new version, rather than just an offer
> to give you new features.
>
> Gnucash for Android is not under development, and that's not a good
> thing, as it appears to be abandoned, and no updates will come.
>
> Every time there are updates, some users have some problems. For many
> that marks the first time they come to this mailing list for advice.
> You already know about us, and can ask what you need to know.
>
> 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.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] QUESTION: transaction classes (tags) like QuickBooks?

[Adrian Yong]

Hi Zi,

I was a QB user as well and have recently switched to Gnucash...

I have tried splitting expenses claims like Quit Rent & Assessment as an
expense claim but split into Quit Rent and Assessment as separate Expenses
in P & L...

The one thing which I have trouble with is the General Ledger which QB
lists the opening and closing balances and all the transactions in between
for individual ledger accounts... In Gnucash, you won't get that but the
argument is we enter data using a double entry procedure, so *assuming that
the transactions are entered correctly,* the opening and closing balance
should be reflected in the Account Tree or Balance Sheet...

As I am not super confident that the transactions are entered correctly, I
do have a problem with this...

As Gnucash is still under development, there are a lot of updates and I am
hearing of people having difficulties in locating their files after
updating... I think the current version is 3.10 and I am on 3.x... I have
this fear of updating to 3.10... Maybe I will do it after my auditors
confirmed that they have got everything they need...

Regards,
Adrian

On Mon, 22 Jun. 2020, 17:52 Zi via gnucash-user, 
wrote:

> Hi
>
> I've used QuickBooks for years and am seriously considering finding a
> (*non*web based) alternative. GnuCash looks very promising, but here's the
> million-dollar question (and yes, I browsed the whole site, the manual, the
> FAQ, etc. trying to find an answer to this question!)
>
> In addition to the accounts and sub-accounts that inform reconciliation
> and P type reporting, is there a way to *class* transactions the way
> QuickBooks does? In other words, can one, while entering a transaction,
> enter something like the following:
>
> (vendor) Local Electricity Provider
> (amount) $ total amount of bill
> (split line one account) "utilities" AND THEN
> (*class*) address of investment property and unit #
> (split $ amount for this property)
> (split line two account) "utilities"
> (*class*) address of *other* investment property and unit #
> (split $ amount for *that* property)
> etc.
> thus allowing a property manager to show expenditures around *each
> particular* property.
>
> OR for instance one travels sometimes, and needs to record the expenses.
> Like, the appropriate transaction accounts for such would include "meals",
> "lodging", etc. and the CLASS for each could be "Las Vegas 2020", or
> "Phoenix 2019" thus giving one a way to show the expenditures for a
> *particular* trip.
>
> If GnuCash provides this functionality, I will likely switch over to it!
> If, however, it does not, Intuit must, sadly, still win.
>
> Thanks so much!
>
> Sent from ProtonMail mobile
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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]

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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

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

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

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