Built from inside practice. Built by Mr H Hammad FCCA, ACA, ICAEW Chartered Accountant with over 20 years in practice.
ProductFor ClientsClient PortalResourcesWhy BalansixPricingAcademySupportFree practice guideBook a demoLogin
BalansixPractical guides

Check net wages against a payroll summary

Understand the Balansix net wages calculation, directors’ salary split and deduction fields before completing a payroll review.

Intermediate6 minute guidePayroll & CIS

The short answer

Check Gross wages and employee deductions against the final payroll summary. On Excel or CSV import, Balansix calculates net wages from those values; the supplied net-pay figure is a source check.

How the calculation works

Net wages are Gross wages less Employee PAYE, Employee NI, Employee pension, Student loan, Postgraduate loan and Other employee deductions. Employer NI and Employer pension are additional employer costs, so they are not deducted when calculating employees' net pay.

Directors' salaries are already included in Gross wages. The separate field identifies that portion for accounting purposes; adding it again overstates gross payroll.

Check that the report is the final payroll summary for the correct employer and period. A pension report alone does not provide the gross and deduction figures needed for this calculation.

Check the record in this order

  1. Open the client and Payroll & CIS. Find the relevant period and reference.
  2. Review the row's classification, dates, status and validation notes against the source document.
  3. Compare Gross wages with the total before employee deductions. Confirm the directors' portion is included once.
  4. Check each employee deduction in its own field. Look for a total deduction entered in addition to its individual components.
  5. Compare the calculated net wages with the final payroll report. Resolve the source or field difference before completing the review.

On a manually maintained record, also check the entered Net wages. For a posted record, establish the existing posting and follow the appropriate reviewed correction process before changing figures.

Example

Gross wages of £5,000 include £1,000 directors' salaries. Employee PAYE is £700, NI £300, pension £200 and student loan £100. Expected net wages are £3,700.

If a source file says £3,900, check whether the £200 pension deduction is included in that file's net-pay basis. Do not remove a genuine deduction merely to obtain agreement. Compare both figures with the final authorised payroll output.

What a completed check looks like

The gross amount, deductions and net figure agree to one final payroll summary. The record identifies the correct period, and the reviewer can explain any difference from an earlier version. Check net wages payments separately against the wages control; paying staff does not alter the original payroll arithmetic.

Keep the source summary and a short note of the conclusion. If the remaining question concerns how payroll itself was calculated, ask the payroll preparer for the corrected source first.

If you need help with the record

Provide the period, reference, current status, validation wording and the gross, deduction and net totals. A cropped, redacted screenshot of the relevant fields is usually enough to explain the comparison. Exclude employee identifiers, bank details and unrelated personal information.

Related help and learning