Overview
Below please find a breakdown on how the FS3, FS5 and FS7 reports are calculated.
Contents
Permissions
You need to have 'Manage Payroll' permission to generate the below documents.
FS3
An FS3 is a document aggregating an individual employee's gross salary earned, and any taxes and social security paid. To learn how to generate an FS3, click on this link for detailed instructions.
The below shows where the figures within reports and FSS documents are derived from.
FS3 Gross | basic amount + special rate amount + leave amount + overtime amount + pre-tax adjustments (excluding CATs) + leave payoffs |
Taxable Fringe Benefits | CAT1 Car Cash allowance taxable + CAT1 Use of Car taxable + CAT2 taxable amount + CAT3 taxable amount |
Sections in the document:
A1 |
FS3 year |
A2 |
Employee Tax Number |
A3 |
Employee NI Number |
A4 |
Employee Spouse Id Card number if married |
B1 |
FS3 Start date |
B2 |
FS3 End date |
C1 |
FS3 Gross "Formula" + (part-time excess of income as mentioned in C2) |
C2 |
FS3 Gross "Formula" (capped at 10,000 per employee) |
C3 | Taxable Fringe Benefits "Formula" |
C3a | Share Options |
C4 | C1 + C2 + C3 + C3a |
Cat 1 C5 | CAT1 Car Cash allowance (taxable + non-taxable) + CAT1 Use of Car |
Cat 2 C6 | CAT2 |
Cat 3 C7 |
CAT3 |
C8 |
CAT1 Car Cash allowance non-taxable |
D1 | tax + (part-time tax excess of income as mentioned in C2) |
D2 |
Tax
|
D3 |
Tax arrears |
D3a | Tax on share options (tax on C3a) |
D4 | D1 + D2 + D3 + D3a |
E | Social Security |
F | Payer information. This information can be inputted here. |
FS5
An FS5 is a document aggregating a company's payslips for a period. Through this document, the company may pay any taxes and social security due to the government. To learn how to generate an FS5, click on this link for detailed instructions.
The below shows where the figures within reports and FSS documents are derived from.
FSS Gross | basic amount + special rate amount + leave amount + overtime amount + pre-tax adjustments (excluding CATs) + leave payoffs |
Taxable Fringe Benefits | CAT1 Car Cash allowance taxable + CAT1 Use of Car taxable + CAT2 taxable amount + CAT3 taxable amount |
Sections in the document:
A1 |
PE Number |
A2 |
Payroll payment date |
B1 |
Sum of Main Job (part-time & full time) Employees |
B2 |
Sum of employees who are paid at 15% tax rate who are part-time as mentioned in C2 |
C1 |
FS5 Gross "Formula" + (part-time excess of income as mentioned in C2) |
C2 |
FS5 Gross "Formula" (capped at 10,000 per employee)
|
C3 | Taxable Fringe Benefits "Formula" |
C4 | C1 + C2 + C3 + C3a |
D1 | tax + (part-time tax excess of income as mentioned in C2) |
D2 |
Tax
|
D3 |
Tax arrears |
D4 | D1 + D2 + D3 |
D5 |
Employee SSC + Employer SSC |
D5a |
D5a: Maternity leave fund |
D6 |
D6: D4 + D5 + D5a |
E1 | D6 |
Date of Payment |
Payroll payment date |
FS7
An FS7 is a yearly report of FS5 totals which means that FS7 sums up each column's totals of the respective column in FS5. For information on how to generate this, click here.
The below shows where the figures within reports and FSS documents are derived from.
FSS Gross | basic amount + special rate amount + leave amount + overtime amount + pre-tax adjustments (excluding CATs) + leave payoffs |
Taxable Fringe Benefits | CAT1 Car Cash allowance taxable + CAT1 Use of Car taxable + CAT2 taxable amount + CAT3 taxable amount |
Sections in the document:
A1 | Year |
A2 |
PE number |
A3 |
Tax number |
B1 |
Number of FS3s issued |
C1 |
FS5 Gross "Formula" + (part-time excess of income as mentioned in C2) |
C1a |
Overtime |
C1b |
Director's Fees |
C2 |
FS5 Gross "Formula" (capped at 10,000 per employee)
|
C3 | Taxable Fringe Benefits "Formula" |
C3a | Share Options |
C4 | C1 + C2 + C3 + C3a |
D1 | tax + (part-time tax excess of income as mentioned in C2) |
D2 |
Tax
|
D3 |
Tax arrears |
D3a |
Tax on Share options (15%) |
D4 | D1 + D2 + D3 + D3a |
E1 | Social Security (Payer + Payee) |
E2 | Maternity Fund |
F |
Payments made during the year |