Generate TPS Monthly Contributions Reconciliation File
The Generate TPS Monthly Contributions Reconciliation file process generates the archive TPS information, validates the information and generates a txt file.
Perform these steps to generate the MCR Contribution report:
- Use the Submit a Process or Report task. Select your Legislative Data Group and Generate TPS Monthly Contributions Reconciliation file.
- Enter the details as shown here:
Field Description Payroll Statutory Unit Mandatory List of PSUs in the legislative data group.
Effective Date Mandatory
Defaults to last day of the previous calendar month based on system date.
MAT or Payroll Provider Number List of MAT registrations defined at PSU or Legal Employer level, or Payroll Provider registrations defined at PSU Level. Local Authority Number Mandatory
List of local authority numbers defined at PSU, legal employer, and reporting establishment level.
Establishment Number List of Establishment Numbers. Process Configuration Group List of process configuration groups. The parameters from the default group are used if left blank.
The organization names against which identifier is recorded is shown in the parameter:
Mandatory Parameter Mandatory Parameter Optional Parameter Employees Selected ID on MCR HEADER ID for member Payroll Statutory Unit Local Authority Number Members (including members who aren’t in the scheme but are eligible to be in it) in the PSU with the selected Local Authority Number, whether Local Authority is entered at PSU, legal employer, or reporting establishment level. Local authority number from parameter value and Establishment Number from main legal reporting unit (reporting establishment), of PSU Local authority number and establishment number of the reporting establishment they have been assigned, if the local authority number has been entered at this level, or local authority number of the legal employer where the contract is held, and the establishment number of the reporting establishment they have been assigned Payroll Statutory Unit
Local Authority Number MAT or Payroll Provider Number (taken from PSU)
Members (including members who aren’t in the scheme but are eligible to be in it) in the PSU with the selected Local Authority Number, whether Local Authority Number is entered at PSU, legal employer, or reporting establishment level. MAT or Payroll Provider Number from parameter value and Establishment Number from main legal reporting unit (reporting establishment), of PSU Local authority number and establishment number of the reporting establishment they have been assigned, if the local authority number has been entered at this level, or local authority number of the legal employer where the contract is held, and the establishment number of the reporting establishment they have been assigned Payroll Statutory Unit Local Authority Number MAT Number (taken from Legal Employer)
Members (including members who aren’t in the scheme but are eligible to be in it) in the PSU and the legal employer with the selected MAT Number, whether Local Authority Number is entered at PSU, legal employer, or reporting establishment level. MAT Number from parameter value and Establishment Number from main legal reporting unit (reporting establishment), of PSU Legal Employer Local authority number and establishment number of the reporting establishment they have been assigned, if the local authority number has been entered at this level, orlocal authority number of the legal employer where the contract is held, and the establishment number of the reporting establishment they have been assigned Payroll Statutory Unit Local Authority Number Either of the above combinations (MAT or Payroll Provider Number) plus Establishment Number By adding the Establishment Number parameter, only members in that Establishment Number are reported MAT or Payroll Provider Number of main legal entity (PSU or Legal Employer) or from the parameter value if entered, and Establishment Number from parameter value Local authority number and establishment number of the reporting establishment they have been assigned, if the local authority number has been entered at this level, or local authority number of the legal employer where the contract is held, and the establishment number of the reporting establishment they have been assigned Once the Archive TPS Information and Generate TPS Errors and Warnings tasks are complete and free of errors, you will need to mark Review and Confirm TPS Audit Errors and Warnings as Completed. The Generate TPS Monthly Contributions Reconciliation File task status is then also completed and report file is generated.Note: Do not mark the manual task as complete until the archive is complete and error-free.In case of any warning, the flow can continue. In case of errors, the task will stop. Check the errors and warnings detected by the process, correct the errors and retry the archive task.
The MCR flow generates a file that whose name ends csv.txt. To create a file format that’s ready for submission to Teachers’ Pension (or to import into the MCR manual spreadsheet), rename your file to .csv by removing the .txt file extension.
To load the excel file :
- Go to Excel, and from Data tab select ‘New Query’ from the Get and Transform section, or import the .csv file into the MCR template.
- Select From File and then From CSV.
- Select renamed file from folder and click Import.
- Then click Load.