The lines on the BFRO form from 700 onwards cannot be extracted directly from one report from the Finance system and will instead require a little further analysis.
For line 700 Cash at bank and in hand - you should be able to derive your actuals from a Trial Balance and then use the recently released Cashflow Template on BPS to forecast up until August.
For the depreciation section, you must manually separate the in-year charge between buildings, assets donated and assets owned.
Loans and provisions will need to be manually analysed to include the movement in year within the return.
Any new academies to a trust (or academies leaving the trust) will need to include their assets transferred values included within lines 572, 573 and 639.
Balances per academy for lines 800-899 can be found in your management accounts.
As with last year s return, you will need to analyse your balance sheet creditors and debtors as at 31 March. You will need to run a Trial Balance report with a criteria showing periods between 17/18 00 and 17/18 07 (up to March on FMS). You can then find your debtors/creditors in the list.
Trusts will need to analyse whether a value is for less than or more than one year for the BFRO form