How do I enter and edit Payroll Tables in Sage 50 Forecasting?

Summary

If you setup your Wages records to use the Employee List entry method, Sage 50 Forecasting automatically calculates the following payroll costs:

  • PAYE
  • Employees’ and Employers’ National Insurance Contributions
  • Employees’ and Employers’ Pension Contributions (if applicable)

Sage 50 Forecasting calculates the above payroll deductions using Payroll Tables. It is important to ensure that you have set up the Payroll Tables correctly before automatically calculating wages values.

 Answer

These are the basic steps that explain how to enter Payroll Tables. They include:

Payroll Tables overview

To set up PAYE Tables

To set up Employer’s and Employee’s NI Tables

To set up Pension Schemes

To delete Payroll Tables

Note: Quick steps provide the minimum amount of information you need. For further information, please refer to the Detailed steps or Useful info tabs.

 Payroll Tables overview

A Payroll Table consists of four tabs:

  • PAYE Tables
  • Employee’s NI Tables
  • Employers NI Tables
  • Pension Tables.

These each consist of the following:

Name drop-down list This drop-down list contains the names of the tables you can use to calculte your Payroll values.
Add New Table To add more tables into the list, click Add New Table.
Rename Table Click to rename a table.
Delete Table Click to delete a table.
Bands Select the number of bands your table needs to have. A band is represented by a row on the table that appears below.
Table Bandwidths The table displays the number of bands selected. For each band you need to enter a percentage value that applies to the upper and lower limits specified.
Table Date Range To specify the date from which you want the table to apply to the forecast data, enter the date range in the Table Date Range. This allows you to use different band sets at different times in the forecast year or for different years if you are forecasting for more than one year.

To set up PAYE Tables

1. Options > Payroll Tables > Add New Table > enter a name for the table > Save.

2. Bands > specify the required number of bands.

3. Enter the percentage values for each of the bands > enter the upper limits for these percentages.

Note: For current rates, please refer to the HMRC website at http://www.hmrc.gov.uk/paye/rates-thresholds.htm#1 The final band of the table calculates the limit automatically.

4. Choose the date range for the table > Save.

To set up Employer’s and Employee’s NI Tables

1. Options > Payroll Tables > Employer’s NI Tables tab > Add New Table > enter a name > Save.

2. Bands > specify the number of bands > enter the percentage values for each band > enter the upper limits for these percentages.

Note: For current rates, please refer to the HMRC website at http://www.hmrc.gov.uk/paye/rates-thresholds.htm#1

3. Choose the date range for the table.

Note: If the period you select is not the final period in the forecast, an additional row appears to set up the next period.

4. Employee NI Tables tab > Add New Table > repeat steps 4 to 6 for the Employee’s NI tables > Save.

To set up Pension Schemes

Note: Before you can apply a pension scheme to employee records, the scheme must be set up here. You first set up the Pension Scheme, then set up the number of tables that you want to associate with the scheme. A pension scheme can only be applied if you use the Employee List entry method within a Wages record.

1. Options > Payroll Tables > Pension Tables tab > Add New Pension Scheme.

2. Table drop-down list > select the required table or click Add New Table.

3. Bands > specify the number of bands > enter the pension percentage value for each of band> enter the upper limit these percentages apply to.

4. To set up another table > Add New Table > repeat steps 3 to 5 > choose the date range for this table.

Note: If the period you select is not the final period in the forecast, an additional row appears. To apply a different pension table from any period during your forecast, from the additional drop-down list, choose the required date range.

5. To set up the Employee Pension Tables, repeat steps 2 to 7 for the Employee Pension Tables section > Save.

To delete Payroll Tables

Note: There must always be one table in the drop-down list. You can’t delete all tables.

  • Options > Payroll Tables > click the relevant tab > Table drop-down list > choose the table you want to remove > Delete Table.

The following detailed steps contain everything you need to help you enter Payroll Tables.

Payroll tables overview

Name drop-down list This drop-down list contains the names of the tables you can use to calculte your Payroll values.
Add New Table To add more tables into the list, click Add New Table.
Rename Table Click to rename a table.
Delete Table Click to delete a table.
Bands Select the number of bands your table needs to have. A band is represented by a row on the table that appears below.
Table Bandwidths The table displays the number of bands selected. For each band you need to enter a percentage value that applies to the upper and lower limits specified.
Table Date Range To specify the date from which you want the table to apply to the forecast data, enter the date range in the Table Date Range. This allows you to use different band sets at different times in the forecast year or for different years if you are forecasting for more than one year.

Version

v5, v12

For further advice or technical queries

Please contact us on:

01603 516350

enquiry@mintmis.com

www.mintMIS.com

Download the above article in PDF for FREE below