User Roles AdminStaff contributor ✗External contributor ✗Pulse user 

The Payroll account reconciliation template is an account template, assigned directly to a nominal ledger account rather than a reconciliation text with its own separate working paper. It doesn't reconcile anything itself: whenever it is assigned to one of the PAYE/NIC, wages or pension control accounts, or to a payroll cost account, it looks up whichever of the Payroll reconciliation BS or Payroll reconciliation PnL templates has that account mapped, and shows the same reconciled or unreconciled status and difference directly against the account, with a link through to the underlying working paper.

It is genuinely distinct from those two templates: it is their account-level counterpart, not a duplicate of either.

Table of contents 

When should I use this template?

Assign it to any nominal account that is one of the PAYE/NIC, wages/net pay, or pension control accounts mapped within the Payroll reconciliation BS template, or one of the payroll cost accounts mapped within the Payroll reconciliation PnL template. These accounts typically carry this template by default.

Using it means that opening an individual payroll account shows its reconciliation status without you having to redo the reconciliation there.

Before you start

Complete the account mapping and reconciliation in the Payroll reconciliation BS template (Social Insurance, Wages and Pension controls) and/or the Payroll reconciliation PnL template first. This template has no data entry of its own and simply displays what has already been reconciled there.

Check that the account range for each control in those templates actually includes the account you are looking at.

Background

Payroll liabilities and costs are already reconciled in full within the Payroll reconciliation BS and Payroll reconciliation PnL templates. This template therefore avoids asking for the same reconciliation twice at the individual account level, and simply surfaces the existing result.

Steps

Step 1: Social insurance control accounts

If the account is one of those mapped for PAYE/NIC in the Payroll reconciliation BS template, a row appears labelled Reconciled via payroll workings, linking to the Payroll reconciliation BS template, alongside a reconciled or unreconciled indicator and the outstanding difference, if any. The default range covers the standard UK codes, but you can change this in the Payroll reconciliation BS template.

Step 2: Wages control accounts

The same behaviour applies for accounts mapped as the wages/net pay accrual control in the Payroll reconciliation BS template.

Step 3: Pension control accounts

The same behaviour applies for accounts mapped as the pension contributions control in the Payroll reconciliation BS template.

Step 4: Payroll profit and loss accounts

If the account is instead one mapped within the Payroll reconciliation PnL template's account range, a similar row appears linking to the Payroll reconciliation PnL template, again with its own reconciled or unreconciled indicator and difference.

Step 5: Accounts not mapped anywhere

If the account isn't mapped in any of the above, the template shows a message explaining that it wasn't selected in either the Payroll reconciliation BS or the Payroll reconciliation PnL template, and that you should either select it there or change the account template being used. The account is left showing as unreconciled until it is mapped in one of those two templates.

What flows through to the rest of the accounts/workflow?

Nothing is generated by this template. It purely displays reconciliation results already produced in the Payroll reconciliation BS and Payroll reconciliation PnL templates. Those two templates carry the actual balance sheet and profit and loss reconciliation into the accounts.

What rolls forward next year?

There is nothing to roll forward on this template. The account mappings and reconciliation data all live in, and roll forward within, the Payroll reconciliation BS and Payroll reconciliation PnL templates.

Where the data comes from

The account mapping and reconciliation status or difference held in the Payroll reconciliation BS template (Social Insurance, Wages and Pension controls) and the Payroll reconciliation PnL template, for the account currently being viewed.

Frequently asked questions

Why is this account still showing as unreconciled even though I've completed the payroll templates?

Check that the account's code is within the mapped range for the relevant control in the Payroll reconciliation BS template, or within the mapped range in the Payroll reconciliation PnL template. If it isn't included there, this template has nothing to display and leaves the account unreconciled.

Do I need to enter anything on this template?

No. It has no data entry of its own. All the payroll figures and account mapping are entered in the Payroll reconciliation BS and/or Payroll reconciliation PnL templates.

How is this different from the Payroll reconciliation BS and PnL templates?

Payroll reconciliation BS and Payroll reconciliation PnL hold the actual payroll workings and do the reconciliation. This is an account template that simply reflects, at the level of an individual account, whichever of those two reconciliations already covers it.