Forum Replies Created
20th November 2017 at 10:24 am in reply to: Startup Cash Flow Projection Template – help please #2479
Hi Tope, the sheets are password protected, but you shouldn’t need to edit the sheets. Enter your company information on the ‘Info’ tab and set your startup forecast settings there. Then enter your data on the ‘Data’ tab.
After that, go to the report tabs like the 12 month cash flow forecast and you’ll have your forecast ready to print.
I hope this helps.
Firstly, apologies for not responding to this question sooner – I missed the support question, sorry.
Actually the new version has just that. The macro to suppress the blank lines on the cash flow and profit forecast reports has been updated. So now when you press ‘Ctrl’ and the ‘n’ key the years that you don’t want are hidden.
In the settings on the ‘Info’ tab, change the forecast period to the number of months you want to forecast for, e.g. 12 months; 24 months; or 36 months etc., before your action the macro, and this will restrict the report to whatever forecast period you select.
So for example, if you set the forecast period to 36 months a 3 year forecast report will be shown on each of the reports.
Hello again Richard,
I just realised, if having a report that is for 7 months only – you can use the ‘Monthly’ profit and loss report to produce a profit and loss specifically for the 7 months of your profit forecast. This will also provide you with the balance sheet as at the end of the 7 months too.
I hope this helps.
Hello Richard, firstly thank you for your recent purchase of Cash Forecaster.
The shortest period for the software is 12 months, so this can’t be done at present in the current version.
Are you able to add the extra 5 months to your forecast to make use of the 12 month period?
Sorry about that.
Thank you Paul
Thank you for taking the time to give your feedback, this is very much appreciated.
I think your ideas are good and I will give them some thought of how to best integrate them. One of my core principles is to keep the software as easy to use as possible, so with this in mind and your kind feedback, I will get to adding these into the current rebuild I’m doing.
Please if you wouldn’t mind popping over to the Cash Forecaster page and scoring it too that would be very much appreciated too. Here’s the link to make it easy for you https://www.bowraven.com/product/cash-forecaster-software/
Thank you and let me know if there’s any more help you need.
- This reply was modified 3 weeks, 6 days ago by bowraven.
Yes you can – if you go to the ‘Info’ tab and scroll down to the ‘Headings’ section and then in that to the ‘Profit and loss main headings’ section. You’ll see all the headings you can change there. Simply type in the green cell next to the heading you want to change.
That’s great you’ve sorted it. But the other way would have been to set up a loan or hire purchase too.
How are you finding the software, as a review would be very much appreciated here https://www.bowraven.com/product/cash-forecaster-software/
Thank you for your question about software users.
Within the same company you can have as many users as you like, there’s no limit.25th September 2017 at 4:51 pm in reply to: Stock and building stock not to be included in cash flows #2307
Hi Paul – I have posted your emailed question on the forum, as this helps other users/future users with support questions.
The cash flow forecasts will account for stock correctly.
If you enter the stock build-up at the end of each month under the stock entry on the “Data” sheet, this will prevent the cost being entered on the profit and loss.
– Purchases in month 1 – £1000 – Stock entry at the end of month 1 £1000
– Purchases in month 2 – £1500 – Stock entry at the end of month 2 £2500
– Purchases in month 3 – £2500 – Stock entry at the end of month 3 £5000
Regarding the cash flow, what you need to do is to set the payment for the stock to be however many months forward the payment is made, so that it will then appear in the cash flow accordingly.
I hope this helps.
Please let me know of any follow up questions.
Hi Joe – we have updated the Cash Forecaster you sent, so that you can now format the columns and rows. It has been returned back to you to the same email address.
Thank you for your feedback on support though.
We may still add the paid for support option, so people have the choice of free support here, versus a paid-for ‘immediate’ telephone support service.
Thank you for your custom and I hope that whatever you need these Cash Flow Forecasts for, this all works out well for you.
Hi Joe – I confirm your email has been received – I cannot remove the protection, but I will change the protection to allow you to change the column widths – is there anything else you’d like to be able to do too.
Hi Joe, Thank you for your message, sorry I miss-read your first message – the only sheets where the password protection is blank are the reports – all the others are password protected and I don’t give out that password, sorry.
Send your working sheet to info(at)bowraven(dot)com and I will change the way these sheets work for you – but I take on board what you’ve said and will change the ‘protection’ to allow for these types of ‘minor’ change in the way you describe.
Also, the reason for support on this forum in this way is because it’s free and the idea is for others to benefit from questions (like yours) and find the answers.
I apologise for any inconvenience caused to you.
I have been thinking about offering an annual fee-charging type support – would you be happy to pay for this service?
Hi Joe, on the report sheets the password is blank, so just press enter on this. Just be careful not to amend or touch any on the formulas. Always keep a master copy of Cash Forecaster, just in case.17th May 2017 at 10:06 pm in reply to: Not all populated rows are appearing on Reports on screen or when printed #2224
Please will you let me know which version of Cash Forecaster you are running, as this will help to work out what the problem is here.
Are you saying that these rows are not there from the start – have you run the macro to hide rows for printing? I’m not quite clear on the question, sorry.
Have you tried to run the macro to show all rows and then re-hide the rows – if I’m understanding the question correctly
- This reply was modified 6 months, 1 week ago by bowraven.