Functionality

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 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,

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.