To the of the drop down menu, cells K1 and K2 perform another check to reconcile the number of pupils on the Tab to the number of pupils on the ‘Pupils’ Tab. If there is a difference between the two figures then the cells will ‘Reconciliation’ turn RED. This may be because the school has intentionally left pupils on the Tab that ‘Pupils’ are expected to be included in the next Monthly Statement. If this is the case then no further investigation is needed and cells K1 and K2 will remain red until an updated Monthly Statement is received the following month Once the pupil numbers match the red highlights will disappear. However, there could be a situation whereby a school is incorrectly funded for an additional pupil (and therefore has an extra pupil on the Statement’ Tab and ‘Monthly ‘Reconciliation’ Tab) but also has a pupil for which they are awaiting funding (and have left the pupil on the Tab). In this situation, the red highlights on cells K1 and K2 would ‘Pupils’ disappear as the discrepancies cancel each other out. However, the extra pupil on the Statement’ Tab would be highlighted in red and the additional pupil on ‘Monthly the Tab would have an orange highlight in Column A so the users eye should ‘Pupils’ still be drawn to these discrepancies. Check the to date’ column (Column K) and the variance column for the ‘Variance month to which you are reconciling. In the example below there is a variance of £176.37 against one of the pupils (pupil Key 7070_071) and this is shown in both column K (variance to date) and column N (April variance column). To investigate any differences, check the data for the relevant pupil on the Tab and compare it to the data on the Tab. ‘Reconciliation’ ‘Pupils’ In this example is a variance due to a mismatch between the placement start date on the Statement’ Tab (1/9/2010) and the date on the Tab ‘Monthly ‘Pupils’ (15/5/16).
To the of the drop down menu, cells K1 and K2 perform another check to reconcile the number of pupils on the ‘Pupils’ Tab to the number of pupils on the ‘Reconciliation’ Tab. If there is a difference between the two figures then the cells will turn RED. This may be because the school has intentionally left pupils on the ‘Pupils’ Tab that are expected to be included in the next Monthly Statement. If this is the case then no further investigation is needed and cells K1 and K2 will remain red until an updated Monthly Statement is received the following month Once the pupil numbers match the red highlights will disappear. However, there could be a situation whereby a school is incorrectly funded for an additional pupil (and therefore has an extra pupil on the ‘Monthly Statement’ Tab and ‘Reconciliation’ Tab) but also has a pupil for which they are awaiting funding (and have left the pupil on the ‘Pupils’ Tab). In this situation, the red highlights on cells K1 and K2 would disappear as the discrepancies cancel each other out. However, the extra pupil on the ‘Monthly Statement’ Tab would be highlighted in red and the additional pupil on the ‘Pupils’ Tab would have an orange highlight in Column A so the users eye should still be drawn to these discrepancies. Check the ‘Variance to date’ column (Column K) and the variance column for the month to which you are reconciling. In the example below there is a variance of £176.37 against one of the pupils (pupil Key 7070_071) and this is shown in both column K (variance to date) and column N (April variance column). To investigate any differences, check the data for the relevant pupil on the ‘Reconciliation’ Tab and compare it to the data on the ‘Pupils’ Tab. In this example is a variance due to a mismatch between the placement start date on the ‘Monthly Statement’ Tab (1/9/2010) and the date on the ‘Pupils’ Tab (15/5/16).