[GNC] Fwd: Wrong running balances in reports

Finfort finfort at gmail.com
Thu May 28 04:03:05 EDT 2020


      
  

 Yes I understand. And I have to open this in something like Excel and recalculate it.
  
What is the problem to do this in GNC after   
  

 changing of sort order?
  
  

  
  
>   
> On May 28, 2020 at 10:28,  <David Carlson (mailto:david.carlson.417 at gmail.com)>  wrote:
>   
>   
>   
> Your example had two transactions for the same day.    If they are not sorted in the default sort order, the end-of-day running balance is not the last balance displayed.
>   
>   
>   
> On Thu, May 28, 2020 at 1:16 AM Finfort  <finfort at gmail.com (mailto:finfort at gmail.com)>  wrote:
>   
> >             
> >   
> >   
> >   
> >   
> >   
> >   
> >   
> >   
> >   
> >   
> >     Begin forwarded message:
> >   
> >   
> >   >       
> >   >  From:    Finfort     <finfort at gmail.com (mailto:finfort at gmail.com)  (mailto:finfort at gmail.com)>
> >   >       Date:    May 28, 2020 at 09:13
> >   >       To:    David Carlson     <david.carlson.417 at gmail.com (mailto:david.carlson.417 at gmail.com)  (mailto:david.carlson.417 at gmail.com)>
> >   >       Subject: Re: [GNC] Wrong running balances in reports
> >   >       
> >   >       
> >   >       
> >   >       
> >   >
> >   >    If it is out of sequence - it shows wrong values after some transactions, including the end of the day (in my example).
> >   >       
> >   >  Who needs running balance like that?
> >   >       
> >   >
> >   >       
> >   >       
> >   >
> >   >       
> >   >       
> >   >   >       
> >   >   >  On May 28, 2020 at 02:51,     <David Carlson (mailto:david.carlson.417 at gmail.com)>    wrote:
> >   >   >       
> >   >   >       
> >   >   >       
> >   >   >       
> >   >   >  I forgot the other point I intended to make.       
> >   >   >       
> >   >   >
> >   >   >       
> >   >   >  GnuCash does not necessarily calculate intra-day balances correctly.        It is only correct at the end of the day.        Gnucash may sort same day transactions differently than you or I want it to.
> >   >   >       
> >   >   >       
> >   >   >       
> >   >   >       
> >   >   >  On Wed, May 27, 2020 at 6:44 PM David Carlson     <david.carlson.417 at gmail.com (mailto:david.carlson.417 at gmail.com)  (mailto:david.carlson.417 at gmail.com)>    wrote:
> >   >   >       
> >   >   >   >       
> >   >   >   >       
> >   >   >   >  IIRC, in some views the running total is not shown at all when it is not in sort order.        In other views it is shown out of sequence, but it is correct if the        view including the running totals is re-sorted to the 'correct' sequence.        Thus it is not actually wrong, it is just out of sequence.
> >   >   >   >       
> >   >   >   >
> >   >   >   >       
> >   >   >   >  That is my opinion.
> >   >   >   >           
> >   >   >   >       
> >   >   >   >       
> >   >   >   >  On Wed, May 27, 2020 at 3:33 PM Finfort     <finfort at gmail.com (mailto:finfort at gmail.com)  (mailto:finfort at gmail.com)>    wrote:
> >   >   >   >       
> >   >   >   >   >                           
> >   >   >   >   >       
> >   >   >   >   >       
> >   >   >   >   >           But this is wrong and should be recalculated when changing sort order, isn't it?
> >   >   >   >   >       
> >   >   >   >   >       
> >   >   >   >   >       
> >   >   >   >   >       
> >   >   >   >   >       
> >   >   >   >   >       
> >   >   >   >   >       
> >   >   >   >   >       
> >   >   >   >   >       >               
> >   >   >   >   >       >    On May 27, 2020 at 17:39,           <Derek Atkins (mailto:derek at ihtfp.com)>        wrote:
> >   >   >   >   >       >               
> >   >   >   >   >       >               
> >   >   >   >   >       >               
> >   >   >   >   >       >        Hi, "finfort at gmail.com (mailto:finfort at gmail.com)  (mailto:finfort at gmail.com)"           <finfort at gmail.com (mailto:finfort at gmail.com)  (mailto:finfort at gmail.com)>        writes:           >        Appears in reports when you sorting by date and you have 2           >        transactions of the same date.           >               >        Needs recalculation of running balance.           >               >        Example of General Ledger report:           >               >        VAT Output Dr Cr Running Balance           >               >        31/12/19 O.. LTD €25,080.00-€212,124.82           >               >        31/12/19 R.. GMBH €2,926.00-€187,044.82           >        (should be 215050.82)           >               >        Total For VAT Output €28,006.00           >               >        In this example rows should stay vice versa, like in the editable form           >        to have correct running balance.           >               >        So the form has recalculation of running balance, the report does not have. If you change the sort-order in the register you will also notice the balance is "off" -- the balance is computed based on the default sort order and displayed in whatever view you have. In other words, the balance is ONLY valid in the default sort order, not any other sort order. This is true in reports as well as the register.           >        Please remember to CC this list on all your replies.           >        You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745     derek at ihtfp.com (mailto:derek at ihtfp.com)  (mailto:derek at ihtfp.com)       www.ihtfp.com (http://www.ihtfp.com)  (http://www.ihtfp.com)    Computer and Internet Security Consultant       
> >   >   >   >   >       >
> >   >   >   >   >       >               
> >   >   >   >   >       
> >   >   >   >   >       
> >   >   >   >   >       
> >   >   >   >   >    _______________________________________________
> >   >   >   >   >    gnucash-user mailing list
> >   >   >   >   >       gnucash-user at gnucash.org (mailto:gnucash-user at gnucash.org)  (mailto:gnucash-user at gnucash.org)
> >   >   >   >   >    To update your subscription preferences or to unsubscribe:
> >   >   >   >   >       https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >   >   >   >   >    If you are using Nabble or Gmane, please see     https://wiki.gnucash.org/wiki/Mailing_Lists    for more information.
> >   >   >   >   >    -----
> >   >   >   >   >    Please remember to CC this list on all your replies.
> >   >   >   >   >    You can do this by using Reply-To-List or Reply-All.
> >   >   >   >           
> >   >   >   >       
> >   >   >   >    --
> >   >   >   >       
> >   >   >   >       
> >   >   >   >  David Carlson
> >   >   >   >                   
> >   >   >       
> >   >   >    --
> >   >   >       
> >   >   >       
> >   >   >  David Carlson
> >   >   >                                               
> >  _______________________________________________
> >  gnucash-user mailing list
> >   gnucash-user at gnucash.org (mailto:gnucash-user at gnucash.org)
> >  To update your subscription preferences or to unsubscribe:
> >   https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >  If you are using Nabble or Gmane, please see  https://wiki.gnucash.org/wiki/Mailing_Lists  for more information.
> >  -----
> >  Please remember to CC this list on all your replies.
> >  You can do this by using Reply-To-List or Reply-All.
>     
>   
>  --
>   
>   
> David Carlson
>                


More information about the gnucash-user mailing list