by rwalliker » Wed Jan 17, 2018 1:31 pm
Cashflow The cashflow report is calculated from movements on the statutory PL and Balance Sheet together with other key information The whole report is created from a template xls file 4CastPLStat.xls which resides on the server which can be amended by us if required.
The “Download xls” button allows you to download the cashflow report to your desktop. You can unhide hidden rows and columns to see the full calculations behind the cashflow report
The cashflow report is derived mathematically from the actual/forecast balance sheets The balance sheet can forecast itself semi automatically by: 1)Setting debtor days and creditor days or profiles to calculate trade debtors and trade creditors 2)Setting VAT %'s 3)Setting up fixed asset and depreciation account relationships 4)Setting up loan accounts 5)Setting up stock methods for forecasting stock balances 6)Setting up methods to calculate accruals/prepayments and provisions etc (See Methods section of Help under Forecasting for a full look at Methods and their cashflow implications) 7)Setting up factoring/invoice discounting 8)Setting up and forecasting corporation tax and dividend provisions and payments 9)Setting other accounts as REPEAT method eg Share Capital (unless changes are anticipated) 10)Selecting any other set-up options like 'Depreciate in month of purchase' or 'Apply 60 day VAT creditor'
Any changes to forecast Sales/Costs should then reflect through onto the balance sheet and cashflow by hiting the 'Recalc' button