settingupthe cash flow forecast- r m education（settingupthe现金流预测- r m教育）.docVIP

Setting up the Cash Flow Forecast Excel Work Book Document needed: First Step Saving the documents: Please make sure all saved documents are named as written in these instructions. This may mean that when you are saving from the grid it will say ‘copy of’ or have numbers at the end eg _00 these will need to be deleted. Create a folder called Cash Flow Forecast on the schools drive eg E: - this may change from school to school as you may have a different drive/letter for finance. Within the Cash Flow Forecast folder Save the Cash Flow forecast Excel worksheet. () this will be your Master copy, and the Excel Work sheet you will need to import the FMS report into. If you are importing from The Grid you will need to put the spaces in between Cash Flow Forecast Master. Please open the Cash Flow Forecast Master and select the Start here tab. Click on the grey ‘Import your data’ to start the macro. The first time you see this it will give you a error message and ask you to debug. Please select. The macro screen will appear. Please change Please change this to the drive that has the Cash Flow forecast Folder(e.g. E:) Once you have changed the E: to the correct letter please save. Next go to file close and return to Microsoft excel. Then Ok This will bring you back to the start page in your Cash Flow Forecast Master. Save once more. Next step is to open FMS. Setting up the User Defined Cash Flow Forecast Report Setting up the FMS6 report Reports – General Ledger – User defined Reports Add Enter the Name ‘Cash Flow Forecast’ Within Row Set enter through the looking glass. Add a new row set. This will be on the right hand side of the screen. Select All Cost Centre Groups as Individual Rows, with Grand Total. Then Ok Enter Row Set name as Cash Flow Forecast Cost Groups Scroll down and find the line with F- Contingency Highlight the row yellow Delete this line from the UDR. Pleas