Russell Bowyer
Forum Replies Created
-
Posts
-
Hello Richard,
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 protected]. 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.
Hello Richard,
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: http://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.
.