[GNC] Projecting the future

Adrien Monteleone adrien.monteleone at lusfiber.net
Mon Aug 6 15:06:17 EDT 2018


Jay,

Have you tackled the Budget module yet?

It works on a ‘period’ basis, but might achieve some of the same info. (you can compare budget to actual, but not the way David does with specific transactions)

You can also budget flows to savings accounts, paying liabilities, etc.

There are some nuances and parts of the workflow is a little cumbersome, but it is overall, useful.

Do be aware I noticed and filed a bug where automatically time-stamped transactions, Specifically posted invoices on the first of the month, are getting the wrong date/time-stamp and the budget report is interpreting them as the prior period throwing off my revenue actual comparisons to budget. (probably some sort of time-zone issue) Other than that I’m happy with it.

The budget window will show you your running budgeted balance at the bottom for each period as you add revenue/income and then budget expenses or paying off liabilities. This was useful for me to budget savings and to budget advancing liability payments.

Regards,
Adrien

> On Aug 6, 2018, at 1:54 PM, David Carlson <david.carlson.417 at gmail.com> wrote:
> 
> My method to predict future bank account balances is to enter scheduled transactions for all large expenditures and incomes, even if they are estimates out to between one and three months in advance.  I flag these estimates with a keyword in the number field, so I can tell if I have replaced the estimated value with a real value.  I also have a couple of miscellaneous aggregates to estimate the effect of the little things like Starbucks.
> 
> This comes close enough to see when my cushion balance is running low.
> 
> David C
> 
> On Mon, Aug 6, 2018 at 1:27 PM, Adrien Monteleone <adrien.monteleone at lusfiber.net> wrote:
> I don’t think there is a way to do these currently, but does the Future Scheduled Transactions Summary report give you something of what you are looking for? (not ideal, I know)
> 
> I too would like to know for example, that what I’ve scheduled will put me ’negative’ on a certain date, something like a date-level budgeting tool. Other money management tools I’ve used had this feature in a graph. Of course, GnuCash isn’t a money management app, it’s a double-entry bookkeeping app.
> 
> Regards,
> Adrien
> 
> > On Aug 5, 2018, at 2:23 PM, J Johnson <jhjhnsn at live.com> wrote:
> > 
> > 
> > As I was playing around with the scheduled transactions, I noticed the running balance is not displayed in the calendar. The calendar is just a visual representation of the table. Is there a way to
> > display the running balance for each day?    Also, is there a way to set the future date of the projected minimum balance?
> > 
> > 
> > Thanks
> > Jay
> > 
> > Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10
> > 
> > _______________________________________________
> > gnucash-user mailing list
> > 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.
> > 
> 
> 
> _______________________________________________
> gnucash-user mailing list
> 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.
> 




More information about the gnucash-user mailing list