Adrien, Yes, that’s formally correct. As I’ve said repeatedly in this thread, GnuCash has long had a design feature that one can get a balanced Balance Sheet report without closing one’s book. The Balance Sheet report does that by summing up the expense and income accounts’ balances and reporting the total in a “Retained Earnings” line. If one has closed one’s book in the past and so has a “Retained Earnings” account, the Balance Sheet report will have two lines called “Retained Earnings”.
Regards, John Ralls > On Aug 12, 2018, at 10:26 PM, Adrien Monteleone > <adrien.montele...@lusfiber.net> wrote: > > Are not Retained Earnings part of Equity? And then, that account would only > be used in a close books process, not without it. Closing the books should > zero the income and expense accounts TO Retained Earnings. > > Regards, > Adrien > >> On Aug 13, 2018, at 12:04 AM, Christopher Lam <christopher....@gmail.com >> <mailto:christopher....@gmail.com>> wrote: >> >> Hi Jralls >> >> So just wish to double check my understanding of gnucash's data format for a >> balance-sheet on date X >> >> There are two possibilities for displaying the right-hand-side >> >> 1. Liabilities + Equity + Retained Earnings + Trading Balances >> 2. Liabilities + Equity + Retained Earnings + Unrealized Gains >> >> "Retained Earnings" should be NULL if the user has properly closed the books >> on the balance sheet date X. >> >> In my understanding, "Trading Balances" and "Unrealized Gains" are one and >> the same -- in balance-sheet.scm the unrealized-gain-collector is only >> populated if book->trading-accounts setting is disabled. (btw this causes a >> 'bug' whereby a book with 'enable-trading-accounts', but was later switched >> to 'disable-trading-accounts' will then add both the >> unrealized-gain-collector and the trading-balance the right-hand-side). >> >> This seems to be deconstruct current balance-sheet? >> >> (I can't seem to find any unrealized-gain issue... from using different >> price-sources... perhaps this is beyond my understanding.) >> >> >> On 11/08/18 22:41, John Ralls wrote: >>> Chris, >>> >>> Remember that we’ve long advised users that they need not close their >>> books, they can run a balance sheet report for any day. IMO removing that >>> capability would be a major breakage. >>> >>> I suspect that you needed to use trading accounts because you didn’t book >>> the trading gains and losses as income. Users should do that regardless of >>> using trading accounts and doing so should make it unnecessary for the >>> balance sheet report to include trading accounts. >>> >>> Unrealized gains are another matter entirely and are a result of using >>> prices from the price database instead of actual cost from the transaction >>> data. IMO the balance sheet report shouldn’t be taking prices from the >>> price db and shouldn’t be able to see unrealized gains, but if price source >>> is going to be an option then an unrealized gains line flows from that so >>> that users don’t waste a bunch of time chasing an imbalance caused by price >>> differences. >>> >>> https://bugs.gnucash.org/show_bug.cgi?id=775368 >>> <https://bugs.gnucash.org/show_bug.cgi?id=775368> is related because that’s >>> currently how the balance sheet report gets the “actual” costs. >>> >>> Regards, >>> John Ralls >>> >>>> On Aug 10, 2018, at 11:40 PM, Christopher Lam <christopher....@gmail.com >>>> <mailto:christopher....@gmail.com> <mailto:christopher....@gmail.com >>>> <mailto:christopher....@gmail.com>>> wrote: >>>> >>>> Hi John >>>> >>>> I've managed to make the left-side (activa?) match the right-side >>>> (passiva?) >>>> >>>> https://screenshots.firefox.com/RNvkjaxnYyxpGkYn/null >>>> >>>> 1) it does require closing books on the balance-sheet date >>>> >>>> 2) it does require adding trading-accounts >>>> >>>> The existing balsheet introduces/calculates the "Retained Earnings", >>>> "Trading Gains" and "Unrealized Gains", whereas the current iteration of >>>> new-balsheet will not. >>>> >>>> To me this is the easiest method to ensure both sides produce the same >>>> total, and is now technically correct - if the user has not closed their >>>> books, the balance sheet won't balance. >>>> >>>> This is giving me a headache :( >>>> >>>> Should a new balsheet calculate and report these '(fake) retained >>>> earnings', and 'unrealized gains' ??? >>>> >>>> C >>>> >>>> >>>> On 09/08/18 08:32, John Ralls wrote: >>>>> >>>>>> On Aug 8, 2018, at 8:51 AM, Geert Janssens <geert.gnuc...@kobaltwit.be> >>>>>> wrote: >>>>>> >>>>>> I haven't been following every detail of this. However I note on most >>>>>> balance >>>>>> sheets the total assets doesn't match total net worth (or >>>>>> liabilities/equity). >>>>>> In most, this is fixed by including the retained earnings. >>>>>> >>>>>> I believe at least in most European countries the "left hand side" >>>>>> (Assets, >>>>>> Active) and "right hand side" (Passive or liabilities + equity) of the >>>>>> multicolumn view should balance (it's called balance sheet for a reason). >>>>>> That would suggest retained earnings does have to be part of the balance >>>>>> sheet. >>>>>> >>>>>> However I'm not an accountant and perhaps your book is slightly >>>>>> contrived so I >>>>>> don't know the exact answer here. >>>>>> >>>>>> As for the "multi-column" vs one column debate, both present the same >>>>>> data. >>>>>> The only difference is visual representation or style. >>>>>> >>>>>> As of recently I have become a strong proponent of separating structure >>>>>> (or >>>>>> accounting functionality in a different context) from style, I think this >>>>>> should be delegated to the realm of css. This particular layout >>>>>> variation can >>>>>> IMO be handled by making divs for each large group and either let them >>>>>> follow >>>>>> normal flow or use float to move them next to each other. If you will >>>>>> you can >>>>>> have a European style sheet and an American one, or an Australian or >>>>>> whatever. >>>>>> >>>>>> As for "categories", I read Frank's earlier reply as if he agreed that at >>>>>> least for now the account organization is something to be done in the >>>>>> CoA, not >>>>>> in report code. >>>>> The Balance Sheet is indeed supposed to balance, but in normal practice >>>>> it balances only when the book is “closed”, i.e. when all of the income >>>>> and expense accounts are summed up and added to Equity. In US corporate >>>>> books the cumulative total of income and expenses lives in an Equity >>>>> account called “Retained Earnings”. >>>>> >>>>> In the pen-and-paper days a “Trial Balance” was computed outside of the >>>>> books before closing as a way to catch errors before making the closing >>>>> entries and writing the formal Balance Sheet. >>>>> >>>>> GnuCash's existing Balance Sheet Report creates the “Retained Earnings” >>>>> line so that one need not close the books (Tools>Close Book) in order to >>>>> get a balanced report. Removing that feature might be more formally >>>>> correct but it would mean that users would have to close their book >>>>> before running a balance sheet. That would be a big change and I don’t >>>>> think that we want to do it. On the other hand “Retained Earnings” isn’t >>>>> the right term for many cases, so it would be a useful improvement to >>>>> make it configurable. >>>>> >>>>> There’s a second problem with the current report as well: If the user >>>>> does close their books periodically they’ll have an account for the >>>>> accumulation that may well be called “Retained Earnings”. The Balance >>>>> Sheet Report will dutifully report the contents of that account and, if >>>>> there are income and expenses after the last close, add a second >>>>> “Retained Earnings” line. That looks a bit odd and might be confusing; >>>>> ISTR we’ve had comments on the user list about just that. >>>>> >>>>> Regards, >>>>> John Ralls >>>>> >>>>> _______________________________________________ >>>>> gnucash-devel mailing list >>>>> gnucash-devel@gnucash.org >>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel >>>> >>>> _______________________________________________ >>>> gnucash-devel mailing list >>>> gnucash-devel@gnucash.org >>>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel >>> >> >> _______________________________________________ >> gnucash-devel mailing list >> gnucash-devel@gnucash.org <mailto:gnucash-devel@gnucash.org> >> https://lists.gnucash.org/mailman/listinfo/gnucash-devel >> <https://lists.gnucash.org/mailman/listinfo/gnucash-devel> > > > _______________________________________________ > gnucash-devel mailing list > gnucash-devel@gnucash.org <mailto:gnucash-devel@gnucash.org> > https://lists.gnucash.org/mailman/listinfo/gnucash-devel > <https://lists.gnucash.org/mailman/listinfo/gnucash-devel> _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel