Defined benefits pension scheme mapping guidelines
Use the following map codes to provide full disclosure in the notes:
At end of Balance Sheet net assets section:
If your pension scheme is a liability overall (N.B. These codes are repeated for each scheme):
F20.01.00.01 Pension liability b/fwd - scheme 1
F20.01.00.02 Pension liability - current service cost - scheme 1
F20.01.00.03 Pension liability - past service cost - scheme 1
F20.01.00.04 Pension liability - prev unrec surp deducted scheme 1
F20.01.00.05 Pension liability - gains/losses on sett/curtail - scheme 1
F20.01.00.10 Pension liability - contributions - scheme 1
F20.01.00.11 Pension liability - finance income - scheme 1
F20.01.00.20 Pension liability - actuarial gain/loss - scheme 1
F20.01.00.30 Pension liability - def tax on act gain/loss - scheme 1
F20.01.00.40 Pension liability - derecognition of surplus - scheme 1
If your pension scheme is an asset overall (N.B. These codes are repeated for each scheme):
F20.11.00.01 Pension asset b/fwd - scheme 1
F20.11.00-.02 Pension asset - current service cost - scheme 1
F20.11.00.03 Pension asset - past service cost - scheme 1
F20.11.00.04 Pension asset - prev unrec surp deducted scheme 1
F20.11.00.05 Pension asset - gains/losses on sett/curtail - scheme 1
F20.11.00.10 Pension asset - contributions - scheme 1
F20.11.00.11 Pension asset - finance income - scheme 1
F20.11.00.20 Pension asset - actuarial gain/loss - scheme 1
F20.11.00.30 Pension asset - def tax on act gain/loss - scheme 1
F20.11.00.40 Pension asset - derecognition of surplus - scheme 1
Within P & L Reserves section
(N.B. These codes are repeated for each scheme)
H03.11.00.01 P/L a/c - Pens reserves balance b/fwd - Scheme 1
H03.11.00.21 P/L a/c - Pens res diff between exp/actual ret on assets - Sch 1
H03.11.00.22 P/L a/c - Pens res expected gains/losses on scheme liabs - Sch 1
H03.11.00.23 P/L a/c - Pens res effects of chngs in actuarial assumpts - Sch 1
H03.11.00.30 P/L a/c - Pens res deferred tax on actuarial gain/loss - Sch 1
H03.11.00.50 P/L a/c - Pension reserve - prior year adjustment - Sch 1
H03.11.00.60 P/L a/c - Pension reserve - derecognition of surplus - Sch 1
Within P & L section:
M02.82.00.03 CoS – Staff pension current service costs
M02.82.00.04 CoS - Staff pension past service costs
M02.82.00.05 CoS - Staff pension prev'ly unrecognised surplus deducted
M02.82.00.06 CoS - Staff pension gain/loss on settlement/curtailment
M03.85.00.03 CoS - Directors pension current service costs
M03.85.00.04 CoS - Directors pension past service costs
M03.85.00.05 CoS - Directors pension prev'ly unrecog'd surplus deducted
M03.85.00.06 CoS - Directors pension gain/loss on settlement/curtailmnt
P02.82.00.03 Selling - Staff pension current service costs
P02.82.00.04 Selling - Staff pension past service costs
P02.82.00.05 Selling - Staff pension prev'ly unrecn surplus deducted
P02.82.00.06 Selling - Staff pension gain/loss on set'ment/curtailment
Q02.82.00.03 Distrib - Staff pension current service costs
Q02.82.00.04 Distrib - Staff pension past service costs
Q02.82.00.05 Distrib - Staff pension prev'ly unrecn surplus deducted
Q02.82.00.06 Distrib - Staff pension gain/loss on set'ment/curtailmnt
R01.85.00.12 Admin - Directors pension current service costs
R01.85.00.22 Admin - Directors pension past service costs
R01.85.00.32 Admin - Directors pension prev'ly unrecn surplus deducted
R01.85.00.42 Admin - Directors pension gain/loss on set'ment/curtailmnt
R02.82.00.12 Admin – Staff pension current service costs
R02.82.00.22 Admin - Staff pension past service costs
R02.82.00.32 Admin - Staff pension prev'ly unrecn surplus deducted
R02.82.00.42 Admin - Staff pension gain/loss on set'ment/curtailmnt
U03-01-00.02 Net interest on pension scheme liabilities
Add the following bookkeeping entries in the Working TB:
Number |
Description |
Dr |
Cr |
1. |
Opening pension liability |
|
F20.01.00.01 |
|
P/L a/c - Pens reserve – brought forward |
H03.11.00.01 |
|
|
Opening value of pension scheme liability(If asset, reverse the postings to above map codes) |
|
|
|
|
|
|
2. |
Current service cost of pens - staff |
P/Q/R02.82.00.12 |
|
|
Current service cost of pens - directors |
R01.85.00.12 |
|
|
Pension liability– current service cost |
|
F20.01.00.02 |
|
Cost of pension benefits earned by employees during period |
|
|
|
|
|
|
3. |
Past service cost of pens - staff |
P/QR02.82.00.22 |
|
|
Past service cost of pens - directors |
R01.85.00.22 |
|
|
Pension liability– past service cost |
|
F20.01.00.03 |
|
Cost of providing higher level of benefits than promised during period |
|
|
|
|
|
|
4. |
Prev. unrecognised surplus deducted |
P/QR02.82.00.32 |
|
|
Pens liability- Prev. unrec. surplus ded'd |
|
F20.01.00.04 |
|
|
|
|
5. |
Gain/loss on settlement or curtailment |
P/QR02.82.00.42 |
|
|
Pens liability - gain/loss on sett't/curtailment |
|
F20.01.00.04 |
|
|
|
|
6. |
Net interest on pension scheme liabilities |
|
U03.01.00.02 |
|
Net finance income |
F20.01.00.11 |
|
|
Net finance income on scheme liabilities |
|
|
|
|
|
|
7. |
Contributions paid |
F20.01.00.10 |
|
|
Trf from pension contributions accounts |
|
R02.82.00.02 |
|
Contributions paid to the scheme by the company during the year |
|
|
|
|
|
|
8. |
Pens liability- actuarial gain/loss |
F20.01.00.20 |
|
|
Pen res act'l ret'n less exp. ret'n on assets |
|
H03.11.00.21 |
|
Pen res experience gains |
H03.11.00.22 |
|
|
Pen res changes in assumptions |
H03.11.00.23 |
|
|
Net actuarial gain/loss on scheme during period as determined by actuarial valuation |
|
|
|
|
|
|
9. |
Pens liability– Def tax movement |
|
F20.01.00.30 |
|
Pens res def tax on actuarial gain/loss |
H03.11.00.30 |
|
|
Current year deferred tax |
W02.01.00.01 |
|
|
Deferred tax attributable to movement in surplus/deficit |
|
|
|
|
|
|
10. |
Pens liability– Derecognition of surplus |
|
F20.01.00.30 |
|
Pens res derecognition of surplus |
H03.11.00.60 |
|
|
Pension surplus not recognised |
|
|
Once you have made all of the above entries, the relevant notes and disclosures will display in the accounts.
There will then be a user input requirement in the notes to analyse out various other disclosures.
- Related template: Charity/Academy, FRS101/102/105 LLP
- Software platform: Working Papers 2022, Working Papers 2023