tag:infinitekind.tenderapp.com,2009-01-14:/discussions/suggestions/13140-cashflow-forecastingInfinite Kind: Discussion 2020-07-26T17:50:23Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/481731712020-03-21T13:51:52Z2020-03-21T13:51:52ZCashFlow Forecasting<div><p>Hi Rich,</p>
<p>Take a look at the Money Foresight extension listed under Moneydance's Extensions > Manage Extensions menu.</p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/481731712020-03-21T17:03:41Z2020-03-21T17:03:41ZCashFlow Forecasting<div><p>Thanks Kevin<br>
I have looked at it - the free extension is ok but not fantastic - obviously not tried the paid one yet ..it would be good if there was a free trial for that as well - unless I am missing something</p></div>Rich Wtag:infinitekind.tenderapp.com,2009-01-14:Comment/481731712020-03-21T20:00:26Z2020-03-21T20:00:26ZCashFlow Forecasting<div><p>Hi Rich,</p>
<p>Are you sure that you 'really, truly looked at it' because "not fantastic" is <em>not</em> how I would describe it.</p>
<p>Give it another go and make sure to look into all of it's features including the Money Foresight Review included with it.</p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/481731712020-03-21T23:40:53Z2020-03-21T23:40:53ZCashFlow Forecasting<div><p>Hi Rich,</p>
<p>The free version of Money Foresight is fully-featured apart from not being able to adjust the future period. It is stuck on one month.</p>
<p>Once you purchase you'll be able to do all the things you requested in your original post.</p>
<p>Let me know if you have any more questions about features.</p>
<p>Regards,<br>
Kevin</p></div>Kevin Stembridgetag:infinitekind.tenderapp.com,2009-01-14:Comment/481731712020-03-22T16:51:35Z2020-03-22T16:51:35ZCashFlow Forecasting<div><p>Thanks Kevin.<br>
I will review what options I can do now and assess whether this matches the need I have and I’ll let you know if I identify any additional suggestions.</p></div>Rich Wtag:infinitekind.tenderapp.com,2009-01-14:Comment/481731712020-05-08T15:18:43Z2020-05-08T17:30:09ZCashFlow Forecasting<div><p>Kevin<br>
To clarify I have once again looked at the forecast tool including all the options not just the summary page which I tried to configure before and I apologise and say that it does have more function than I initially had managed to configure. There is one thing that I specifically would benefit from your assistance with though...</p>
<p>Ive attached an example of what I am trying to do. I have managed to get the reminders and transactions showing which is a good thing, but am struggling on a third point linking the budget planning element so your advice in how I can use the Money Foresight tool to do this and achieve a similar outcome would be amazing.</p>
<p>In the attached example it shows 90 days hence (which i know I can get from the full version), but it shows a profile of my balance taking into account transactions that are made on the account, reminders upcoming and also budgeted projections. This way I can see a profile of my account balance as the time moves forward.</p>
<p>I look forward to your advice and recommendations</p></div>Rich Wtag:infinitekind.tenderapp.com,2009-01-14:Comment/481731712020-05-09T00:55:46Z2020-05-09T00:55:46ZCashFlow Forecasting<div><p>Hi Rich,<br>
My advice is to ignore the budgeting features in Moneydance. Anything that you can represent in a Budget you can instead represent as a Transaction Reminder and there are a few benefits in doing so. I explain in more detail on this page.<br>
<a href="http://moneyforesight.com/features/budgeting">http://moneyforesight.com/features/budgeting</a></p>
<p>Once you've got everything in Transaction Reminders you can use the forecast view to see your future cashflow and you can look at the Money Foresight Review to see how your past spending compares with what you expected it to be (just like in a budget).</p>
<p>Give that a try and give me a shout if you still need any help.</p>
<p>Regards,<br>
Kevin</p></div>Kevin Stembridgetag:infinitekind.tenderapp.com,2009-01-14:Comment/481731712020-05-09T11:11:28Z2020-05-09T11:11:28ZCashFlow Forecasting<div><p>Kevin<br>
I am looking at this as an option in MoneyForesight (MF) , so I need to understand the logic in more detail I am afraid.</p>
<p>Firstly to say - I have existing transaction reminders which come out of my account (Account A) each month e.g. Phone Bill, water bill, electric bill etc. - These are fixed and known and feed into the forecast as categories and I know which account (Account A) they come from - thats understood.</p>
<p>I need to add a more generic category - Shopping - Groceries.. I don't know how much its going to be - lets say £50 per week - So I think we are saying I add a reminder called Shopping - Groceries (category Shopping - Groceries - £50) as a "New Transaction Reminder", not "New General reminder" in MoneyDance and then fill in Frequency (Weekly Monday) and Category £50 and I assume I use the account to be the Account (Account A) it comes from.. - My confusion is that I assume in the actual Account Transaction list for Account A, each monday a new transaction called Shopping Groceries will appear to be confirmed and I will have to delete it, or edit it should a REAL ONE actually be made .. is that what you are saying, or is there a way to set the transaction reminder so it appears in the Transaction Reminders section so can be used for your forecasting but doesn't actually get added to my real account (Account A) at all - In the Budget planner that is obviously not how that works because the budget is running in parallel to the account which in my example above isn't happening here. If I am right, then I was thinking i maybe create these 'Budget' transactions in a separate clone account (Account B) which could be included in the MF graphing options (Account A and Account B) but the I think it would appear as 2 graphs and not one merged one so that also wouldn't work ?? - Am i confused what you are saying ? - your advice as always is very much appreciated.</p></div>Rich Wtag:infinitekind.tenderapp.com,2009-01-14:Comment/481731712020-05-09T14:27:38Z2020-05-09T14:27:38ZCashFlow Forecasting<div><p>Hi Rich,</p>
<p>When you create or edit a Transaction Reminder, you can choose if you want it to auto-commit or not. This means a transaction will automatically appear in your account register. For reminders that don't auto commit they will appear in the home page as overdue reminders. You can configure Money Foresight to take overdue reminders into account when it generates a forecast.</p>
<p>I think auto-commit doesn't make a lot of sense for an irregular expense such as groceries but you should definitely create a transaction reminder for it based on your average spending. Then when it becomes overdue you will have to select it in the Reminders view on the home page and choose 'skip'.</p>
<p>To make sure that your guess at an average grocery bill is accurate, keep an eye on the Money Foresight Review window.</p>
<p>Hope this helps,<br>
Kevin</p></div>Kevin Stembridgetag:infinitekind.tenderapp.com,2009-01-14:Comment/481731712020-05-09T14:51:56Z2020-05-09T14:51:56ZCashFlow Forecasting<div><p>Thank you Kevin<br>
That makes sense. I will set up a test and let you know how it goes.<br>
Rich</p></div>Rich Wtag:infinitekind.tenderapp.com,2009-01-14:Comment/481731712020-05-17T11:25:07Z2020-05-17T11:25:07ZCashFlow Forecasting<div><p>Hello Kevin<br>
I have followed the instructions that you provided and have set up the Budget Forecast Transaction reminders as you have said - It does work as you described for MoneyForecast and I can see how this can is a benefit - I have set up separate Budget Forecast Categories so they can be segregated and this helps me as I have now set them to Inactive so they don't show when I am adding real transactions in the Transaction register which is great.</p>
<p>The biggest 'issue' as we have mentioned that I have is the fact that the MoneyDance Reminders are recording as Overdue as the date has past - This is fine for MF as I have unticked the Include Overdue Reminders -but the only way to remove the them is as you say is to SKIP TRANSACTION which is a pain as you can only do it once at a time as far as I can see.<br>
I have raised a suggestion in MoneyDance to see if its possible to exclude categories or reminder transactions .. but I doubt they'll do it as they wont see it as a problem for their tool - as they have their own Budget tool.</p></div>Rich Wtag:infinitekind.tenderapp.com,2009-01-14:Comment/481731712020-07-26T17:50:20Z2020-07-26T17:50:20ZCashFlow Forecasting<div><p>Closing case. Nothing else to be done unless suggestion is take up by MD development</p></div>Rich W