Forum Replies Created
Hello Peter, thank you for your question and I apologise for my delayed response.
Yes you can do this, but the data is set up to only allow whole numbers to avoid any unnecessary small differences.
To do this you can use the ‘Round’ function.
Just in case you are not familiar with this Excel function here is an example:
– Where the ‘Cell’ = the cell you want to work out the cost of sale percentage, which would be where your sales line is.
– Where the COS% = the Cost of Sales percent, which can be represented as 0.40 where the cost of sale percent is 40% etc.
I hope this makes sense, let me know if you have any further questions in this, or if you need further explanation.
Thank you, and a Happy New Year to you.
Hi Ian, when you are entering the asset enter the purchase month as for example, 24 for two years, or 18 for 1 year and 6 months and so on.
Hello Ian, okay let me know how you get on with reducing them down.
You’ve given me an idea, if I produced an optional overhead report without the sub headings, I could get more on the report without the text looking too small. However, it is set up with the sub-headings to correspond with the profit and loss report, and this would need some re-thinking too, as it’s important they correspond.
Let me know and we can go from there, but I’d be concerned at having 32 expense headings as this is another 9. The text would be very small and hard to read.
Hi Ian, at present the software only caters for 120 day payment terms, sorry.
The new version which is being worked on will cater for 12 months forward, but I can’t promise when this will be ready. Probably early 2017.
Hello Ian, the 48 headings on the ‘Info’ tab are so you can add new ones, to then select them from the drop down list on the ‘Data’ tab, rather than over type the existing ones.
What you select on the ‘Data’ tab for each expense heading is what shows up on the ‘Overheads’ report, which has been restricted to the 23 headings, as this is what would fit on the page, otherwise the text would be too small to read.
Out of interest how many expense headings were you looking for for your business. The trouble is that too many will make the text too small to read.
Are you able to combine some of your expense headings in any way?
I hope this answers your questions.
Thank you for your message.
At present the way it is set up is to apply a percentage across all sales. So for example if 80% of your sales were ID applicable you enter this as your percentage. You then enter the percentage of that amount that will be advanced from the Invoice Discounting company.
I am working on an upgraded version which addresses this, but this may take some time to finalise.
At present the new version will probably be able to cope with different ID advance rates too.
Sorry this may not be the answer you were looking for.
If you have any further questions, please let me know.
Thank you for the file – as I confirmed in the email, I’m not quite sure how this happened, as I couldn’t replicate the error in the original Cash Forecaster Software, but I have corrected all the dates in the reports and this all works fine again for you.
Hi actually you are on version 4.1.2. If you send me your file I will take a look for you cheers
- This reply was modified 12 months ago by bowraven.
Hello Simon, please will you confirm which version you have and I’ll take a look. Also, if you send a copy of the file you are working on to firstname.lastname@example.org I will see if there is anything I can do on your file to correct it for you. Thank you
Yes it looks like we are talking at cross purposes here – sorry about that.
The Balance Sheet tab is set up to show the closing balance sheet position at the end of each year end rather than at the end of each month.
You are able to produce a monthly report for each month end using the “Monthly” tab, but as you say this will take some time based upon what you want to do.
We are working on version 5.1 of the Cash Flow Software, and it could be that I incorporate this “Monthly Balance Sheet” report into this new version. However, this will be a while in production yet.
Looking at the numbers and the sheets in Cash Forecaster plus how the balance sheet report is compiled it looks like this can be done relatively easily. Although it will take a bit of time to do for you.
If this is important to you and you are not able to wait for Version 5.1 I could do an interim upgrade for you. However, as this is a special one off I will have to charge for this. The fee would be £75 plus VAT.
Please let me know what you would like to do.
The monthly balance sheet is headed up “As at Month Year” as per this image link here: .
You adjust the “Month” and “Year” at the top of the tab so that the profit and loss will show the period from and to which ever dates you enter and the balance sheet the end of the period.
So I’m confused – are you sure you are not looking at the “Balance Sheet” tab?
Regarding your “Actuals” as I explained Cash Forecaster does not have this feature right now. But as the balance sheet is a summary of your profit and loss and cash flow entries you could do a work around, as follows:
1. Enter your sales/cost of sales/overheads as actuals as each month passes so that your profit and loss is now showing your actual profit for the month.
2. Make sure any of your entries in the month which directly affect “Cash Flow” are made to actual numbers. For instance asset purchases etc.
3. Add an additional expense heading in your profit and loss and label it “Cash flow variance to actual” or such other wording that suits you.
4. Enter the amount by which your cash flow is different in the relevant month. This will make sure your closing bank balance is corrected to the actual figure. Therefore your opening bank balance for the following forecast month will be the actual bank balance too.
5. Enter the same number you entered in “4.” above in either accruals or prepayments as an opposite amount to effectively “Zero-out” the effect on your profit and loss account.
6. This should give you a corrected actual cash flow report, your profit and loss will be actual, all be it with and “In” and an “Out” to adjust for differences between what you projected versus what actually happened with cash flows. This should result in an “Actual” balance sheet at each month end. But you will be able to check this off against your management accounts figures.
I appreciate the end balance sheet will not be exactly as per your management accounts due to differences on your trade debtors and trade creditors – so you could enter both an accrual and a prepayment entry with each one reflective of the corresponding difference to either trade creditors or trade debtors. So when you add your trade creditors figure and the accruals figure together on the “Actual” balance sheet, these would net to the trade creditors figure on your monthly management accounts. The same would apply for trade debtors and the prepayments adjustment.
The net of the accrual and prepayment adjustments would then equal the extra profit and loss entry per “3.” above.
Please give this a go. I don’t know the details of your business and whether this will work and I’m trying to think of what other entries will need to be adjusted but please let me know. As I write this I am trying also to think about how I go about including this as a feature and how easy or difficult this might be.
The report pages are fixed and should not be changed. These are designed to present the data you’ve entered from the various data screens.
If the monthly balance sheet report problem is not clear please send a pdf copy of what yours looks like to email@example.com. Please note that any information received this way is treated with the strictest of confidence.
Thank you and if you have any further questions please ask.
1. There is a monthly balance sheet which is on the “Monthly” tab.
2. There isn’t a specific way to input actuals for months past other than to overwrite what has already been put in. However, this is a good idea as an upgrade so we will look at this in the upgrade we are working on right now. (this will not be available right away though)
3. You can’t switch the tables to £M or £000 at the switch of a button – if you want to work in £M though you could set your currency up as £M instead for the reports. Then enter all your numbers as £M in all the tables instead.
4. You should be able to put further tabs on any cash flow you are working on quite easily. Once set up simply add a link in the cell of the table you are looking to link to it. However, make sure that the final cell on the tab you are linking to is rounded to no decimals using the =round(“xyzcell”,0) formula.
5. not sure why it is slow at your end – is it the whole site being slow for you or certain parts? It seems to be working fine for me.
If you have any further questions please do not hesitate to ask.
Hello again Grace, I hope you are getting on okay with our cash flow software. We have just released a new version, which now includes the feature to both have an override of how customers pay, as per the version you have bought, but also now the ability to set the debtor days per sales type line.
This is not the only upgrade to Cash Forecaster, for a bit more detail I have written a blog here: https://www.bowraven.com/cash-flow-software-download-upgraded/
If you would like to upgrade to this version I am more than happy to email this to you for free, thank you.
Hello Grace, thank you for your question.
The way the debtors are set up is on the ‘Information Tab’ and will apply to all the sales. The default setting is 100% cash. If say 100% of your customers paid in 30 days, enter 100% in this cell. But if for example, say 10% is cash; 60% pay in 30 days and 30% in 60 days, you would enter 60% in the 30-day cell, 30% in the 60-day, which would leave 10% cash as the balance.
I hope that makes sense.
Hello Barry, and thank you for your question.
Yes that is correct, you will have to enter each amount individually. although you could enter a formula to enter the amounts, by either doing that in the cells themselves and copying this across the months, or you could add an additional sheet with your data and then link these to the data cells.
If you do this, you must make sure that the amounts are without decimals, so use the rounding formula: +round(‘your formula’,0).
The last cash flow forecast I did, I needed add details regarding our payroll and used an added sheet with quite complicated data on it, then simply linked the totals to the cash flow data sheet.
I hope that answers your question.