The short answer
Use the Payroll Upload template for pension-only evidence. A report containing employee and employer pension contributions can be reviewed as a Pension report without inventing gross wages or creating a second payroll accrual.
Choose the document’s purpose
A payroll summary supplies pay, deductions and employer costs for the payroll posting. A pension report supports the contributions due to the pension provider. A bank payment supports the settlement. Keep these purposes clear even when all three records relate to the same month.
If your document contains only pension contributions, review it as pension evidence. If it contains the full payroll, use the payroll classification and verify the complete summary. The populated amounts matter as well as the column headings.
Prepare the pension evidence
- Open Payroll & CIS and use the Payroll Upload Excel template.
- Remove or replace the completed example row. Keep the template headings.
- Enter the actual period, reference and employee and employer pension contributions supported by the report.
- Leave unrelated payroll amounts empty when the document does not supply them. Do not invent gross wages or net pay to make it resemble a full payroll.
- Upload and review the resulting classification, dates, figures and validation notes.
Balansix can recognise pension-only data in the shared workbook. Confirm that the reviewed record represents the document you intended to upload.
Compare it with the payroll and payment
Suppose the pension report shows £200 employee contributions and £150 employer contributions. The total contribution is £350. Compare those two components with the corresponding payroll summary, then compare the £350 liability with the provider payment.
A pension report is not evidence that the provider has been paid. Equally, a £350 payment does not prove the split between employee and employer contributions. Keep the report and payment references together for the control-account review.
Check the coverage dates before concluding that two totals differ. A payroll month and a provider collection can cover different dates or include an adjustment.
What to expect
Pension-only evidence is accepted without requiring a gross-pay figure. Posting a payroll accrual requires the payroll summary. Review the Pension Control alongside that summary and any payments, rather than posting the same contributions again from the supporting report.
If a payroll record is already posted and the evidence changes the required amounts, ask the authorised reviewer to assess the existing posting and available correction workflow. Retain the reason for the change.
Information for a focused review
Keep the report period, payroll reference, contribution split, payment reference and record status. If you need support, provide those details with the relevant validation wording. Redact employee identifiers and bank information from screenshots.