Docstoc

Stock Count Spreadsheet

Document Sample
Stock Count Spreadsheet Powered By Docstoc
					                                                Croydon Council                                                                 version 6
                                              Using the Spreadsheet                                                             4/1/2010


        just a few tips about how to use and move around the spreadsheet

        You will only be able to enter data in the cream cells

        Additional lines can be inserted in the middle of the cream shaded areas. Inserting any extra
         lines in the middle, rather than at the top or the bottom will ensure that the totals on each
         schedule are calculated correctly.




        To insert an extra row here > select the whole row by clicking on the grey box with 11 in > click
         insert on the menu bar above > choose Rows
                                                                                                       hyperlink
        All the figures on the Balance Sheet feed in from other schedules. The relevant schedules can
         be accessed from the Balance Sheet by clicking the hyperlink next to the relevant box on the
         Balance Sheet.                                                                                Sch1 Balance Sheet'!A1

        Use the hyperlinks on the other schedules to return to the Balance Sheet

        On each of the Schedules the value in the box bordered in a double line is the value that will
         appear on the Balance sheet.

        You can also use the arrows in the bottom left hand corner of the screen to navigate between
         the tabs for each schedule




41e192d3-a962-4e41-8f38-4ec5ed413af9.xls Using the Spreadsheet 8/18/2011
                                                                       Croydon Council
                                                                    Completing the Schedules


               Schools are required to complete the areas shaded in cream. The completed file together with a preliminary CFR return in XML format should be
               emailed from the school's e mail address to
                                                                              schools.finance@croydon.gov.uk

               Signed copies of the following documents should be scanned, then emailed as an attachment to:-
                                                                              schools.finance@croydon.gov.uk
                If you are unable to scan then please FAX to CYPL Finance (Schools) Team, 020 8633 9577

               Schedule 1      Balance Sheet
               Schedule 1A     Statement of Internal Control checklist
               Schedule 1B     Statement of Internal Control
               Schedule 2      Analysis of Balances
               Schedule 3      Receipt of Funding


               A preliminary CFR return should be emailed by midday on Thursday 21st April 2011. A final CFR return should be emailed by Friday 24th June 2011.
               A signed final CFR is also required by this date. You will be advised if there are any issues after validation checks have been completed on the
               preliminary CFR return/balance sheet. If you have not heard anything by May half term at the latest, you can assume it is safe to submit your final
               CFR return to the LA.

                                                                                             DfE No
                                      FIND YOUR SCHOOL



Schedule 1
               The Balance Sheet categorises the schools assets, liabilities and reserve balances, as at the 31st March, in the conventional way. However, schools are
               required to show separately any assets and liabilities arising from payments to or from the Local Authority e.g. VAT, payment demand, accruals and deferrals
               of funding (see schedules 3 and 4). This information is for consolidation of the schools accounts with those of the LA and does not necessarily mean that any
               cash payment is due to or from the school.

               Under CFR the reserve balances held by schools must be split into capital and revenue balances. Details of how to calculate the revenue balances B01 and
               B02 are outlined in Schedule 2. For details of how to categorise the capital balances please\refer to the CFR guidance published by the DfE.

               The Balances shown on the balance sheet in B01, B02, B03, B04, B05 and B06 must be the same as the balances reported on the CFR Return.

Schedule 1A Statement of Internal Control (SIC) checklist: is designed to accompany the CFR return, before signing the SIC the finance committee should complete the
Schedule 1B Statement of Internal Control (SIC) Audit is an opportunity for the finance committee to reflect on the items identified in the last audit report and to comment
Schedule 1C The Statement of Internal Control (SIC) is designed to give the reader of the Financial Summaries, for example a parent, a donor or the s151 Officer at the
            local authority, reasonable assurance that all funds managed by a school have been properly controlled and accounted for. The act of signing it is
            confirmation that the head teacher and members of the governing body accept responsibility for financial management. Further information is available from
            documents R15, R15a and R15b on the following website:
               http://www.fmsis.info//index.asp

Schedule 2     Analysis of Balances: Enter details of the B01 committed balance that will appear on the CFR Return and on the Balance Sheet . Please refer to the
               Scheme for Financing Schools for further details of items to be included in this category. Items listed in Section 4 should be supported by appropriate
               documentation e.g. governing body minutes, School Improvement Plan. The LA may require sight of these documents.
               Link to Scheme for Financing Schools
Schedule 3
               Receipt of Funding: Please confirm receipt of the monies transferred to the school that relate to funding shown on the final funding sheet for 2009-10.

Schedule 4
               Funding Reconciliation: This is a reconciliation of the funding shown on the final funding sheet to the funding included in the school income and expenditure
               statement for the year i.e. the CFR Return. Please identify for each category of funding any amounts that have been deferred or accrued.

Schedule 5     Bank Reconciliation: District Audit require evidence that the school bank account has been fully reconciled with the cash book balance in the school financial
               system as at 31 March 2011. Central Finance also now require us to itemise separately any cheques that are outstanding to the LA, particularly where these
               relate to payment demands for non RBS Bank schools. Please include details of all unreconciled transactions.

               The figures entered on schedules A - M feed in to the Balance Sheet.
Schedule A     Croydon Local Authority Debtors
Schedule B     Croydon Local Authority Creditors
Schedule C     Non Croydon Local Authority Creditors
Schedule D     Non Croydon Local Authority Debtors
Schedule E     Accrued Income Not LA
Schedule F     Accrued Expenditure Not LA
Schedule G     Prepaid Income ALL
Schedule H     Prepaid Expenditure ALL
Schedule J     Stock
Schedule K     VAT
Schedule L     Aged Creditors - non Local Authority
Schedule M     Aged Debtors - non Local Authority

               Schedules N - T are blank worksheets for pasting in copies of reports exported from the school financial system.
Schedule N     Cost Centre summary (FMS6) or Budget v Actual v Committed (RM Accounts)
Schedule O     Trial Balance (FMS6) or income and expenditure analysis sheets from the Financial Summary (RM Accounts)
Schedule P     Unreconciled Bank Items as at 31/03/11
Schedule Q     Balances and Reserves (FMS6) or Financial Summary Report (RM Accounts)
Schedule R     CFR Return - LA use only
Schedule S     Private Accounts
Schedule T     Contracts




41e192d3-a962-4e41-8f38-4ec5ed413af9.xls Completing the Schedules 8/18/2011
                                               FIND YOUR SCHOOL
                                         Balance Sheet as at 31 March 2011


Current Assets                                             2010-11 £          Click link below to go to schedule
     Stock                                                             0.00   SchJ Stock'!A1
     Debtors                                                           0.00   SchM Aged Debtors'!A1
     VAT claims outstanding (may be credit)                            0.00   SchK VAT'!A1
     Prepaid Expenditure                                               0.00   SchH Prepaid Expenditure'!A1
     Accrued Income                                                    0.00   SchE Accrued Income not LA'!A1
     Bank and Cash                                                     0.00   Sch5 Bank Reconciliation'!A1
     Outstanding Income                                                0.00   Sch5 Bank Reconciliation'!A1
     LA Debtor/prepayment/accrued income                               0.00   SchA Croydon LA Debtors'!A1

TOTAL CURRENT ASSETS (z)                                               0.00

Current Liabilities
     Creditors                                                         0.00   SchL Aged Creditors'!A1
     LA Payment Demands                                                0.00   SchB Croydon LA Creditors'!A1
     Prepaid Income                                                    0.00   SchG Prepaid Income'!A1
     Accrued Expenditure                                               0.00   SchF Accrued Expenditure not LA'!A1
     Unpresented Cheques                                               0.00   Sch5 Bank Reconciliation'!A1
     LA Creditor/accrual/deferred income/loan                          0.00   SchB Croydon LA Creditors'!A1

TOTAL CURRENT LIABILITIES (y)                                          0.00

NET CURRENT ASSETS (x=z-y)                                             0.00

Represented by:
     B01 Committed Revenue Balances                                    0.00   Sch2 Analysis of Balances'!A1
     B02 Uncommitted Revenue Balances                                  0.00   Sch2 Analysis of Balances'!A1

TOTAL REVENUE BALANCES (w)                                             0.00

    B03 Devolved Formula Capital                                       0.00   Sch2 Analysis of Balances'!D54
    B04 Other Standards Fund Capital                                   0.00   Sch2 Analysis of Balances'!D61
    B05 Other Capital                                                  0.00   Sch2 Analysis of Balances'!D68

TOTAL CAPITAL BALANCES (v)                                             0.00

       B06 Community Focused Balance                                   0.00   Sch2 Analysis of Balances'!D76


CFR BALANCE (u=w+v)                                                    0.00



We confirm that these figures and the supporting figures as detailed in the electronic return are a
true representation of the balances held by the school as at 31st March 2011.




Signed

Head

Date



Signed

Governor (Chair/Finance)

Date
                Statement of Internal Control - Pre-Certification Checklist for Governors

The Statement of Internal Control (SIC) is designed to accompany the DfE Consistent Financial Reporting (CFR) Return
and Financial Summary, and so relates to the same completed financial year. The internal controls it refers to are those
required as best practice by the Financial Management Standard in Schools (FMSiS).

The issues for governors and the head teacher to consider before authorising their representatives to the sign the SIC fall
into two categories:-
 Specific actions and more general control processes that should have occurred during the financial year in question;
    and
 Specific actions needed after the year end when the CFR Return is available.

The questions are split into these two categories for ease of consideration. That consideration is probably best achieved as
a group, perhaps at the finance committee meeting that approves the CFR Return, and needs to be formally recorded. The
questions are structured so that:-
    A “yes” answer to every question would allow the SIC to be signed without any amendment ; and
    A “no” answer to any question will require either further action or explanation in the SIC .

               Controls that should have operated
               during the financial year
               Question                                      Agreed   Implication of the Answer
                                                             Yes or
                                                             No?
               Did we set the school budget in line with              If yes, no action.
               the priorities detailed in the school                  If no, paragraph 4 should disclose this
               development plan either before the                     weakness. Paragraph 5 should
               beginning of the financial year (1st April)            explain the steps being taken to
               or as soon as possible thereafter?                     ensure next year’s budget is set on
                                                                      time and reflects the school’s
                                                                      priorities.
               Did we see regular reports on the                      If yes, no action.
               school’s financial position during the
               year, did the head teacher and bursar                  If no, paragraph 4 should disclose the
               answer all the questions raised with them              inadequate base financial records as
               and were we satisfied that materially                  a weakness. Paragraph 5 should
               accurate records have been maintained                  explain the steps being taken to
               throughout the year? (Regular in this                  rectify the position.
               context would refer to termly reports as a
               minimum and possibly more frequent in
               larger schools.)
               Did we take appropriate action on all                  If yes, no action.
               significant matters raised in reports from             If no, ensure this decision is justified.
               the internal auditor?                                  If, after reflection, it is considered that
                                                                      some action needs to be taken,
                                                                      describe this briefly in paragraph 5.
               Did we review a risk assessment and                    If yes, no action.
               taken appropriate steps to manage the                  If no, the need to conduct a
               risks identified including the introduction            comprehensive risk assessment
               of internal controls and/or external                   should be noted in paragraph 4.
               insurance cover where required?                        Paragraph 5 should explain the steps
                                                                      being taken.
 Question                                                   Agreed Yes Implication of the Answer
                                                            or No?
 Control activities required after the end of the financial year
 Has the head teacher confirmed that he/she has                        If yes, no action.
 seen a reconciliation of the schools’ base financial
 records with the latest CFR Return (Has the head                      If no, to the first question, make arrangements for
 teacher confirmed that he/she has seen a                              the head teacher to complete/review the
 reconciliation of the school’s either prepared from the               reconciliation before the SIC is signed and
 school’s own system or by the local authority) and                    published.
 Financial Summary that shows they are:
  a complete record of the School’s transactions for                  If no to the second question, the non-compliance
    the year and that the two documents are                            should be noted at paragraph 4 as a weakness.
    consistent with each other?                                        Paragraph 5 should explain the steps being taken
  based on financial records that have met the                        to rectify the position.
    requirements of the DfE’s Consistent Financial
    Reporting (CFR) framework?
 Have we received a report from the internal auditor                   If yes to either question, no action.
 giving us assurance that the systems of internal                      If no to both questions, either:
 financial control operated satisfactorily during the
 year?
                                                                          delay signing the statement until you have
 OR                                                                        received the report or undertaken the self-
 Have we undertaken a thorough self-evaluation of                          evaluation
 the internal control systems in operation during the                  OR
 year and did not find any weaknesses that needed to
                                                                        if the report or the self-evaluation has
 be addressed as a high priority?
                                                                          identified weaknesses that need to be
                                                                          addressed as a high priority, list them at
                                                                          paragraph 4 and briefly explain in paragraph
                                                                          5, the action planned to rectify them.
 Are we confident that there are no significant                        If yes, no action.
 litigation, liabilities or commitments that have arisen               If no, consider if the accounts need adjusting in
 after the year-end, and are not referred to or                        order to be complete, or whether a Contingent
 accounted for in the published financial summaries?                   Liability or Gain disclosure note should be added
                                                                       and the Local Authority Finance Department
                                                                       informed.
 Have we been advised that there has been no actual                    If yes, no action.
 or potential non-compliance with laws, regulations
 and codes of practice that could reduce the school’s                  If no, add the appropriate disclosure notes to the
 ability to meet its objectives or cause the school to                 income and expenditure account before it is
 incur a financial loss, and is this supported by our                  signed and published.
 own knowledge of the school and its activities?


Notes:
 Given the s151 officer has ultimate responsibility for the internal control systems of the whole authority it will be
   necessary to report the details of any “No” answers to him or her or more realistically to a representative of the s151
   Officer.
 The completed internal controls self-evaluation should be copied to the Local Authority internal audit section to inform
   its risk assessment and audit planning processes
Schools need to look at all the factors that affect the operation of their finances in order to complete the Statement of internal
controls (SIC)
One major activity that looks at the school systems etc is when the school has an audit. All schools are audited approximately
every 3 years
Schools are asked to look at their last audt report and to paste in the recommendations and then comment on how the school
has tackled this.

           Date of last audit (month and year)

           Audit assurance                                     choose assurance level from drop down menu

           FMSiS assessment                                    choose assessment result

           Please complete the following table

           Recommendation from last audit report. Just         Action and other comments about how this
           copy in main heading of recommendation              recommendation has been addressed. Eg is it still an
                                                               issue, how quickly was it resolved etc.how has it
                                                               affected the SIC?
                                  Statement of Internal Control for the Year Ended 31st March 2011
                                                        FIND YOUR SCHOOL

   The governing body is responsible for ensuring that the school:


        keeps proper accounting records during the year which will disclose, with reasonable accuracy and at any time, the financial
   position of the school, have been drawn up in accordance with the DfE Consistent Financial Reporting guidelines, and will enable
   it to prepare an annual income and expenditure statement that complies with DfE guidelines

      maintains and operates an effective system of internal control to safeguard all the resources delegated, granted or otherwise
   entrusted to the school and ensure they are used cost effectively
   The system of internal control has been developed and is co-ordinated by the head teacher. It aims to provide as much
   assurance as is reasonably possible (not absolute assurance) that assets are safeguarded, transactions are properly authorised
   and recorded and that material errors or irregularities are either prevented or can be detected promptly
   Our review of the effectiveness of the systems of internal control is informed by:
    our regular scrutiny of financial and other performance monitoring data
    regular reports from the head teacher and other managers to the governing body
    the most recent report of the school’s internal auditor dated (insert date of last report )
    our most recent self-evaluation of the internal controls undertaken (insert date )


   We are, therefore, satisfied that the internal control systems in operation at the school during the year were adequate and
   effective except for -
   YOU MUST COMPLETE THIS SECTION EVEN IF EVERYTHING IS FINE

   List any notable weaknesses here i.e. those rated as requiring remedial action as a high priority




   We propose over the coming year to take the following steps to address the weaknesses noted above.
   This paragraph should provide either brief details of the action taken, or proposed, to rectify weaknesses in the system of internal
   control, or a short explanation of why corrective action has not been considered necessary.




   Signed

   Head

   Date




   Signed

   Governor (Chair/Finance)

   Date




41e192d3-a962-4e41-8f38-4ec5ed413af9.xls Sch1C SIC 8/18/2011
                                                      Analysis of Balances as at 31 March 2011
                                                                FIND YOUR SCHOOL

           Summary of Balances
           B01 Committed Revenue Balance (ie needs to be assigned to particular items, not just a contingency)                      0.00
           B02 Uncommitted Revenue Balance NB unallocated deficits will be offset against B01 on Sch1                               0.00
           B03 Devolved Formula capital                                                                                             0.00
           B04 Other Standards Fund Capital                                                                                         0.00
           B05 Other Capital                                                                                                        0.00
           B06 Extended Schools Community Focused                                                                                   0.00
           Enter the total balance from the school financial system/CFR return for the year ended 31 March 2011                     0.00

           Revenue Balances>B01>Section 1>unspent earmarked grants included in CFR balance
              CFR Category     Please give details of individual grants                       Balance to be spent by: Unspent Amount £
                  I05          TSF Primary/Secondary Strategy                                       8/31/2011
                  I05          TSF Aim Higher                                                       8/31/2011
                  I05          TSF Chartered London Teacher Status
                  I15          Extended Schools (Pupil Focused)




                                                                                                                                    0.00


           Revenue Balances>B01>Section 3>percentage of school budget share 2010-11                                         0
             CFR Category Please give details of individual grants                                    100% £             Amount £
                 I01a       Delegated                                                                             0.00              0.00
                 I01c       Personalised Learning                                                                 0.00              0.00
                 I02a       LSC Sixth Form Funding                                                                0.00              0.00
                 I03a       SEN                                                                                   0.00              0.00
                 I03b       SEN resource bases                                                                    0.00              0.00
                 I03c       SEN individual pupils                                                                 0.00              0.00
                                                                                                                                    0.00
                                                                                                                                    0.00
                                                                                                                                    0.00
                                                                                                                                    0.00

           Revenue Balances>B01>Section 4>other
           Please give details of individual grants                                           Balance to be spent by: Unspent Amount £
           Use of Revenue balances for Capital projects - these should be agreed and
           minuted at an earlier governors meeting




                                                                                                                                    0.00

           Capital Balances>B03>Devolved Formula Capital
           Please give details of individual grants                                           Balance to be spent by: Unspent Amount £




                                                                                                                                    0.00

           Capital Balances>B04>Other Standards Fund Capital
           Please give details of individual grants                                           Balance to be spent by: Unspent Amount £




                                                                                                                                    0.00

           Capital Balances>B05>Other Capital
           Please give details of individual grants                                           Balance to be spent by: Unspent Amount £




                                                                                                                                    0.00


           Extended Schools Community Focused Balance>B06
           Please give details of individual grants                                           Balance to be spent by: Unspent Amount £
           Children's Centre


                                                                                                                                    0.00

           Although the DfE have said that LA's do not have to have a clawback mechanism in place from April 2011, the LA will
           continue to review balances and could still clawback money if it feels that schools have excessive balances.

           We confirm that these figures and the supporting details are a true representation of the balances held
           by the school as at 31st March 2011 and the schools intentions regarding the future use of these balances.


           Signed

           Head

           Date




           Signed

           Governor (Chair/Finance)

           Date




41e192d3-a962-4e41-8f38-4ec5ed413af9.xls Sch2 Analysis of Balances 8/18/2011
                                                                                                             Funding Received 1 April 2010 - 31 March 2011
                                                                                                                        FIND YOUR SCHOOL

         Funding received analysed by CFR area
                                                                                                                                                                                                                                                  Balance of cash
         Funding sheet as        April Cash         May Cash         June Cash        July Cash      August Cash      Sept Cash        Oct Cash       Nov Cash        Dec Cash      Jan Cash      Feb Cash      Mar Cash                           owed to/(by)
           at 31/03/11           Transfers          Transfers         Transfers       Transfers       Transfers       Transfers        Transfers      Transfers       Transfers     Transfers     Transfers     Transfers      Total Cash Rec'd       school
                  £                   £                   £              £                £              £               £                 £             £               £             £             £             £                  £                 £
ACI01a            -                                                                                                                                                                                                                       0.00               0.00
ACI01b            -                                                                                                                                                                                                                       0.00               0.00
 AI01a            -                                                                                                                                                                                                                       0.00               0.00
 AI01b            -                                                                                                                                                                                                                       0.00               0.00
 AI01c            -                                                                                                                                                                                                                       0.00               0.00
 AI01d            -                                                                                                                                                                                                                       0.00               0.00
 AI01e            -                                                                                                                                                                                                                       0.00               0.00
 AI01f            -                                                                                                                                                                                                                       0.00               0.00
 AI01g            -                                                                                                                                                                                                                       0.00               0.00
 AI02a            -                                                                                                                                                                                                                       0.00               0.00
 AI03a            -                                                                                                                                                                                                                       0.00               0.00
 AI03b            -                                                                                                                                                                                                                       0.00               0.00
 AI03c            -                                                                                                                                                                                                                       0.00               0.00
 AI03d            -                                                                                                                                                                                                                       0.00               0.00
 AI04a            -                                                                                                                                                                                                                       0.00               0.00
 AI04b            -                                                                                                                                                                                                                       0.00               0.00
 AI04c            -                                                                                                                                                                                                                       0.00               0.00
 AI05a            -                                                                                                                                                                                                                       0.00               0.00
 AI05b            -                                                                                                                                                                                                                       0.00               0.00
 AI05c            -                                                                                                                                                                                                                       0.00               0.00
 AI06a            -                                                                                                                                                                                                                       0.00               0.00
 AI06c            -                                                                                                                                                                                                                       0.00               0.00
 AI14a            -                                                                                                                                                                                                                       0.00               0.00
AI15b             -                                                                                                                                                                                                                       0.00               0.00
AI16a             -                                                                                                                                                                                                                       0.00               0.00
AI16b             -                                                                                                                                                                                                                       0.00               0.00
Total                  0.00               0.00                0.00            0.00            0.00            0.00           0.00              0.00            0.00          0.00          0.00          0.00           0.00             0.00                0.00
                #N/A          Error if this cell is red                                                                                                                                                                        Roundings adj                 0.00
                                                                                                                                                                                                                               Sch A or B                    0.00

         I/We confirm that the sum of                                        £0.00 was received by the school in respect of the 2010-11 funding allocation.


         Signed                                                                                                                     Signed

         Head                                                                                                                       Governor (Chair/Finance)

         Date                                                                                                                       Date




         41e192d3-a962-4e41-8f38-4ec5ed413af9.xls Sch3 Funding Rec'd 8/18/2011
                                                                              Reconciliation of Funding Received to CFR Funding
                                                                                             FIND YOUR SCHOOL

                                                                                                 Enter figures as either plus or minus as appropriate
                                 Minus             Plus               Plus               Minus
                                                                                        Less funds on
                             Less 10/11 funds Add funds deferred Add funds accrued      10/11 funding    Add other grants
          Funding sheet as   accrued for use in from 09/10 to be from 11/12 for use    sheets deferred    Rec'd - not on                        Total shown on
            at 31/03/11           09/10           used in 10/11       in 10/11           until 11/12      funding sheets    Other Adjustments    CFR Return           Please give details of adjustments shown
                 £                  £                   £                 £                    £                £                   £                  £               Some possible examples shown below
   I01               0.00                                                                                                                                 0.00 EY adjustment Spring Term
   I02               0.00                                                                                                                                 0.00
   I03               0.00                                                                                                                                 0.00 SEN Statemented adjustment
   I04               0.00                                                                                                                                 0.00
   I05               0.00                                                                                                                                 0.00
   I06               0.00                                                                                                                                 0.00
   I14               0.00                                                                                                                                 0.00
   I15               0.00                                                                                                                                 0.00 Pupil Focused Hub School (deferred)
   I16               0.00                                                                                                                                 0.00
  CI01               0.00                                                                                                                                 0.00
                     0.00                0.00              0.00               0.00                0.00               0.00               0.00              0.00 Balance shown on CFR Return
                                                                  Sched A             Sched B




41e192d3-a962-4e41-8f38-4ec5ed413af9.xls Sch4 Funding CFR 8/18/2011
                               Bank Reconciliation as at 31 March 2011
                                       FIND YOUR SCHOOL

Bank Balance per statement 1 as at 31st March 2011                                   0.00
Bank Balance per statement 2 as at 31st March 2011                                   0.00
Bank Balance per statement 3 as at 31st March 2011                                   0.00
Bank Balance per statement 4 as at 31st March 2011                                   0.00
Petty Cash - cash in hand balance                                                    0.00
Total Bank and Cash Balance                                                          0.00


Less unpresented cheques                                     Ref:         Amount £
Items in cash book but not on bank statement

If summarising cheques, please use a new line
for each separate bank account




                                                                                     0.00

Less unpresented cheques to Croydon LA
Items in cash book but not on bank statement

You may like to highlight your unreconciled list in
a different colour, to denote whether cheques are
to Croydon LA or a school within Croydon LA                                          0.00

Less unpresented cheques to schools within
Croydon LA
Items in cash book but not on bank statement


                                                                                     0.00

Add outstanding income
Items in cash book but not on bank statement




                                                                                     0.00


Less unrecorded Income
                                                                                     0.00




Add unrecorded expenditure
                                                                                     0.00

Local Finance System ledger (cash book) Balance                                      0.00




41e192d3-a962-4e41-8f38-4ec5ed413af9.xls Sch5 Bank Reconciliation 8/18/2011
                                   Croydon Local Authority Debtors as at 31 March 2011
                                                  FIND YOUR SCHOOL

Payment Demands - enter debtor balances re payment demands as negative amounts on Schedule B

Funding                                                                                            Amount £
Funding owed to school by Croydon LA re 2010-11 funding - see Schedule 4                                  0.00

Funding (Cash only)                                                                                Amount £
Cash owed to school by Croydon LA re 2010-11 funding - see Schedule 3                                     0.00


Other - Receipts due from Croydon LA Departments - these should not be included in Schedule D
                Cost Centre/
  LA Service       Budget      Ledger/ Analysis
   Provider       Account           Code         Details incl Invoice No                           Amount £
Youth Service             140              66910 Community Use Subsidy (if not paid in March PD)




                                                                                                          0.00




41e192d3-a962-4e41-8f38-4ec5ed413af9.xls SchA Croydon LA Debtors 8/18/2011
                                    Croydon Local Authority Creditors as at 31 March 2011
                                                   FIND YOUR SCHOOL

Payment Demands                                                                                      Amount £
Period 12 Payment Demand
Other Payment Demand - please specify
No PAYE/NI balances here - see Schedule C
                                                                                                            0.00
Funding                                                                                              Amount £
Funding owed by school to Croydon LA re 2010-11 funding - see Schedule 4                                    0.00

Funding (Cash only)                                                                                  Amount £
Cash owed by school to Croydon LA re 2010-11 funding - see Schedule 3                                       0.00


Other - Invoices from Croydon LA Departments - these should not be included in Schedule C
                    Cost Centre/
    LA Service        Budget      Ledger/ Analysis
     Provider         Account           Code         Details incl Invoice No                         Amount £
Photocopying                                         Central Contract charges (Croydon)
Finance SLA                                          Additional Hours (Schools Finance SLA only)
Music Agency                                         Soundstart (Croydon)
HR charges                                           CRB's etc (Croydon HR only)
Grounds                                              Spring Term (only Croydon Gardening Services)
Literacy Centre                                      Spring Term (Croydon Literacy Centre)
The above are a small number of possible examples

Do not include Energy/Water or any Interserve/Veolia Charges - see Schedule F


                                                                                                            0.00




41e192d3-a962-4e41-8f38-4ec5ed413af9.xls SchB Croydon LA Creditors 8/18/2011
Click here to return to Balance Sheet
Sch1 Balance Sheet'!A1

                          Non Croydon LA Creditors as at 31 March 2011
                                     FIND YOUR SCHOOL

Other expenditure - incl non Croydon Payroll liabilities                 Amount £
Payroll - PAYE/NI (Strictly Ed etc)




                                                                                    0.00
Click here to return to Balance Sheet
Sch1 Balance Sheet'!A1

                            Non Croydon LA Debtors as at 31 March 2011
                                      FIND YOUR SCHOOL

Other expenditure - incl non Croydon Payroll Assets in PY01 or similar   Amount £
Payroll queries with provider in PY01




                                                                                    0.00
                           Accrued Income NOT Croydon LA/Croydon Schools as at 31 March 2011
                                                 FIND YOUR SCHOOL

                                                                                 Cost Centre/
                                                                                   Budget          Ledger/
Details of items over £200 - please add to the list below as required.            Account       Analysis Code   Amount £
Staff Insurance Claims
Other Insurance Claims
Lettings Income
Pupil Paid Meals (non Parent Pay)




                                                                                Grand Total                            0.00




41e192d3-a962-4e41-8f38-4ec5ed413af9.xls SchE Accrued Income not LA 8/18/2011
                          Accrued Expenditure NOT Croydon LA/Croydon Schools as at 31 March 2011
                                                   FIND YOUR SCHOOL

                                                                                 Cost Centre/
                                                                                   Budget          Ledger/
Details of items over £200 - please add to the list below as required.            Account       Analysis Code   Amount £
Back pay re upper pay scales/leadership points
Telecommunications
Photocopying - Non LA
Supply cover (DE)
Supply teachers (Agency)
Additional staff hours
Pupil Paid Meals (non Parent Pay)
Electricity
Gas
Fuel Oil
Water

Late invoices re goods & services rec'd in 10/11 - please list
Incl Interserve/Veolia where applicable




                                                                               Grand Total                             0.00




41e192d3-a962-4e41-8f38-4ec5ed413af9.xls SchF Accrued Expenditure not LA 8/18/2011
                            Prepaid Income NOT Croydon LA/Croydon Schools as at 31 March 2011
                                                  FIND YOUR SCHOOL

                                                                            Cost Centre/
                                                                              Budget          Ledger/
Details of items over £200 - please add to the list below as required.       Account       Analysis Code   Amount £
School Journey 11/12
Lettings paid in advance




                                                                           Total                                  0.00



                                        Prepaid Income Croydon LA as at 31 March 2011
                                                     FIND YOUR SCHOOL

                                                                            Cost Centre/
                                                                              Budget          Ledger/
Details of items over £200 - please add to the list below as required.       Account       Analysis Code   Amount £
LA service provider

This section does not include prepaid LA funding - see Schedule B




                                                                           Total                                  0.00



                                   Prepaid Income Croydon LA Schools as at 31 March 2011
                                                   FIND YOUR SCHOOL

                                                                            Cost Centre/
                                                                              Budget          Ledger/
Details of items over £200 - please add to the list below as required.       Account       Analysis Code   Amount £
School Name




                                                                           Total                                  0.00

                                                             Grand Total   Total                                  0.00




41e192d3-a962-4e41-8f38-4ec5ed413af9.xls SchG Prepaid Income 8/18/2011
                         Prepaid Expenditure NOT Croydon LA/Croydon Schools as at 31 March 2011
                                                  FIND YOUR SCHOOL

                                                                               Cost Centre/
                                                                                 Budget          Ledger/
Details of items over £200 - please add to the list below as required.          Account       Analysis Code   Amount £
Insurance Premiums
Equipment Leases
Broadband charges
School Journey 11/12 (Deposit)




                                                                              Grand Total                            0.00



                                     Prepaid Expenditure Croydon LA as at 31 March 2011
                                                   FIND YOUR SCHOOL

                                                                               Cost Centre/
                                                                                 Budget          Ledger/
Details of items over £200 - please add to the list below as required.          Account       Analysis Code   Amount £
LA Service provider




                                                                              Grand Total                            0.00



                                 Prepaid Expenditure Croydon LA Schools as at 31 March 2011
                                                    FIND YOUR SCHOOL

                                                                               Cost Centre/
                                                                                 Budget          Ledger/
Details of items over £200 - please add to the list below as required.          Account       Analysis Code   Amount £
School Name




                                                                              Grand Total                            0.00


                                                           Grand Total        Total                                  0.00




41e192d3-a962-4e41-8f38-4ec5ed413af9.xls SchH Prepaid Expenditure 8/18/2011
                                             Stock Count/Valuation as at 31 March 2011
                                                      FIND YOUR SCHOOL


                                                  Ledger/Analysis     Cost Centre/             Cost / NRV
Item Details                                          Code           Budget Account      No.     each     Total Cost £
School Uniform                                                                                                    0.00
                                                                                                                  0.00
This is not intended to be a count of all stock                                                                   0.00
in school as at 31/03/11. We do however                                                                           0.00
advise including school uniform here.                                                                             0.00
                                                                                                                  0.00
                                                                                                                  0.00
                                                                                                                  0.00
                                                                                                                  0.00
                                                                                                                  0.00
                                                                                                                  0.00
                                                                                                                  0.00
                                                                                                                  0.00
                                                                                                                  0.00
                                                                                                                  0.00
                                                                    Grand Total                                   0.00




41e192d3-a962-4e41-8f38-4ec5ed413af9.xls SchJ Stock 8/18/2011
                                  VAT Reconciliation as at 31 March 2011
                                         FIND YOUR SCHOOL

                                                                           £
Enter the net balance of the VAT accounts from the trial balance               0.00 A

VAT owed to/(by) school:
Unpaid claim re March 2011                                                     0.00
Unpaid claim re February 2011                                                  0.00
Unpaid claim re January 2011                                                   0.00
VAT April 2011 already processed through accounts                              0.00
Other - please specify                                                         0.00
Other - please specify                                                         0.00
Other - please specify                                                         0.00
Unidentified amount (should be zero)                                           0.00
                                                                               0.00 B
                                                                                    B must equal A




41e192d3-a962-4e41-8f38-4ec5ed413af9.xls SchK VAT 8/18/2011
                                  Aged Creditors NON Croydon LA/CroydonSchools as at 31 March 2011
                                                        FIND YOUR SCHOOL

                                                                                    Up to 30      30-60      60-90      over 90
Creditor Details                Comments                                             days £       days £     days £     days £
                                Invoices entered on FMS but not paid




Total                                                                        0.00         0.00        0.00       0.00        0.00


                                                                         0
                                              Aged Creditors Croydon LA as at 31 March 2011
                                                          FIND YOUR SCHOOL

                                                                                    Up to 30      30-60      60-90      over 90
Creditor Details                Comments                                             days £       days £     days £     days £
                                Invoices entered on FMS but not paid




Total                                                                        0.00         0.00        0.00       0.00        0.00


                                                                         0
                                          Aged Creditors Croydon LA Schools as at 31 March 2011
                                                           FIND YOUR SCHOOL

                                                                                    Up to 30      30-60      60-90      over 90
Creditor Details                Comments                                             days £       days £     days £     days £
                                Invoices entered on FMS but not paid




Total                                                                        0.00         0.00        0.00       0.00        0.00



Grand Total                                                                                                                  0.00




41e192d3-a962-4e41-8f38-4ec5ed413af9.xls SchL Aged Creditors 8/18/2011
                                  Aged Debtors NON Croydon LA/Croydon Schools as at 31 March 2011
                                                       FIND YOUR SCHOOL

                                                                                   Up to 30        30-60       60-90       over 90
Debtor Details                  Comments                                            days £         days £      days £      days £
                                Accounts Receivable Schools




Total                                                                       0.00            0.00        0.00        0.00        0.00


                                                                       0
                                              Aged Debtors Croydon LA as at 31 March 2011
                                                         FIND YOUR SCHOOL

                                                                                   Up to 30        30-60       60-90       over 90
Debtor Details                  Comments                                            days £         days £      days £      days £
                                Accounts Receivable Schools




Total                                                                       0.00            0.00        0.00        0.00        0.00

                                                                       0
                                          Aged Debtors Croydon LA Schools as at 31 March 2011
                                                         FIND YOUR SCHOOL

                                                                                   Up to 30        30-60       60-90       over 90
Debtor Details                  Comments                                            days £         days £      days £      days £
                                Accounts Receivable Schools




Total                                                                       0.00            0.00        0.00        0.00        0.00

Grand Total                                                                                                                     0.00




41e192d3-a962-4e41-8f38-4ec5ed413af9.xls SchM Aged Debtors 8/18/2011
Click here to return to Balance Sheet
Sch1 Balance Sheet'!A1
                                     FIND YOUR SCHOOL
                                    Private School Accounts




Each school is to provide a list of the accounts held by or associated with the school. This information to relate to
the last complete financial year for account. This should end at some date in the year financial year 2009/2010. If
the account is registered with the Charity Commission then please complete Table A otherwise complete table B.

Table A for accounts registered with the Charity Commission
Name of account                  Managing group                                 Charity Commission registration Audit arrangements
                                                                                     number if appropriate
Table B for all accounts not registered with the Charity Commission.
Name of account                   Managing group                             Financial year         Audit arrangements   balance into year   income during year expenditure during balance out of year
                                                                                                                                                                      year
                                                                       Start Date        End Date
Click here to return to Balance Sheet
Sch1 Balance Sheet'!A1
                            FIND YOUR SCHOOL
                              School Contracts




    All schools to provide on an annual basis, a complete list of all contracts, leases, service agreements or similar ongoing
commitments, together with some other basic information about each of them. This information to be submitted at the same time
             as the initial budget plan for the new year (ie by 1 May) but also included in the end of year accounts.



  Title of agreement,      Brief description of    Name of contractor or     Start date of contract,   End date of contract,      Can the contract/lease        What are the        Annual cost   Contact for further   What supporting   Any other info
        contract,         arrangement, activity          supplier                   lease etc               lease etc            be extended? If so what   arrangements for early                    information        documentation
                                                                                                                                  are the arrangements?          closure?                                                 available?

				
DOCUMENT INFO
Description: Stock Count Spreadsheet document sample