Forum Replies Created
I have posted your question on the support forum – The best way to send reports is not to send the program, as the person who receives it will then have the program without having paid for it.
The best way to achieve what you are looking to achieve, which is “How to Save Multiple Excel Reports to One PDF File” is to do the following:
1. Blank the sheets you don’t want to print by using the in-built macro to close off black lines.
2. Select the first sheet you want to print, for example, Forecast profit and loss.
3. Either hold the ‘Shift’ key and select the further most report you want to print, or hold the ‘Ctrl’ key and select individually each of the reports you want to print.
4. Click ‘File’ and ‘Print’ and make sure you do a print preview to make sure you have selected all that you want.
5. Select the option to Print to PDF and save the file.
6. Send the PDF file to your client.
I hope this helps.
If you have any further questions, please post them here.
Thank you.16th January 2018 at 1:58 pm in reply to: Other income titles and long term liabilities make up #2774
Regarding your first question about ‘Other income titles – I have just corrected this in Version 5.1.4. this was a bug.
Thank you for noticing.
Regarding the long term liabilities – are you looking for a schedule of how these are calculated?
There isn’t a schedule for this. However, this is calculated as the total of the loan outstanding at any balance sheet end, less the capital repayments due in the following 12 months, i.e. due in less than one year.
If that wasn’t your question, please ask further.
I will send you a copy of the latest version with the ‘Other income’ fix included.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 months 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?