Future balance question

Ian X Waddington iwaddox at gmail.com
Tue Nov 23 17:19:11 EST 2010


David

Thank you.

I would have thought that everyone and every business doing any sort of
financial planning had a requirement for some level of future balance
reporting, perhaps I am mistaken.

As you say adding the transactions to the account in advance would be one
way of getting what I need but this seems a little excessive. Why would I
want to add my weekly scheduled ATM transaction to my account in advance
then have to remember to delete or amend then as required, this seems like a
recipe for disaster and I'm sure not good accounting practice.

Also, currently, as per another post I made yesterday I do not seem to be
able to add any of the scheduled transactions in advance of their due date
anyway so this make the above impossible anyway.

I'm certain somebody must have addressed my question in the past.

Regards

Ian

-----Original Message-----
From: David T. [mailto:sunfish62 at yahoo.com] 
Sent: 23 November 2010 18:33
To: gnucash-user at gnucash.org; Ian Waddington
Subject: Re: Future balance question

Well, I haven't tried this (my ability to track money seems to be limited at
best to what I have right now, and usually to what I had two or three days
ago...), but as I understand it, Gnucash has limited abilities to do future
balances. This is because (again, as I understand it) future scheduled
transactions don't actually exist in the data file. Therefore, your trend
lines won't reflect the scheduled transactions unless or until you actually
create them. Again, as I understand it, you can create these transactions
ahead of time and track the information, but if the transactions actually
change, you'd need to alter them.

Personally, I'd give that a try and see how it works with the net worth
chart.

HTH,
David

--- On Tue, 11/23/10, Ian Waddington <iwaddox at gmail.com> wrote:

> From: Ian Waddington <iwaddox at gmail.com>
> Subject: Future balance question
> To: gnucash-user at gnucash.org
> Date: Tuesday, November 23, 2010, 5:43 AM Hi
> 
> Thank you to everyone who has helped me so far, I am making great 
> progress with my learning of GNUcash and have just about worked out 
> how I can do everything I currently do in MS-Money, however, one area 
> of MS-Money I use a lot is the future balance forecast for my current 
> account.  I use it to determine how much I should transfer at the 
> month end to savings without risk of going overdrawn during the next 
> month.
> 
> The future balance or forecast takes into account
> 
>    - Transactions already entered into the current account
>    - Scheduled transactions for the current account
>    - Budgeted transactions (not really interested in these though)
> 
> It uses the above the produce a graph and a transaction based running 
> balance report for any future period specified, this can be a 
> preselected next month, 90, day or 12 months etc or you can specify 
> custom dates.
> 
> It is possible to do something similar with GNUcash? Or to ask the 
> question another way, how do I monitor the balance of my current 
> account to ensure I do not go overdrawn whilst at the same time not 
> having a high balance of cash which should be earning interest in a 
> savings account?
> 
> Thank you for your help
> Ian
> (I am using 2.3.17)
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.
> 


      



More information about the gnucash-user mailing list