Let us help you tackle any Software issues and optimize your accounting workflow. 

Sage 50 crashes when saving transactions

How to Set Up Employee Working Patterns in Sage Payroll Correctly

Setting up an employee’s working pattern correctly is an important part of managing payroll. If an employee works Monday to Friday, a different combination of weekdays, or a part-time schedule, their working pattern can affect how you record contracted hours, manage absences, and calculate holiday entitlement. Incorrect settings may lead to inaccurate leave balances or confusion when processing payroll.

Sage Payroll provides employee and employment settings that help employers maintain information about working arrangements. However, the available options and exact menu names can differ between Sage Payroll products and versions. A working pattern in Sage Payroll should reflect the employee’s actual contractual arrangement, not simply the days they happened to work during one particular week.

This guide explains how to prepare employee working information, configure common full-time and part-time schedules, update contracted hours, and review holiday entitlement. It also covers the checks to make when an employee’s working arrangements change, so payroll and absence records remain consistent.

What Are Employee Working Patterns in Sage Payroll?

An employee working pattern describes the normal days and hours an employee is expected to work. It provides a reference for managing their employment details and, where supported by the product, absence and holiday calculations.

For example, an employee may work:

  • Five days a week, Monday to Friday.
  • Three fixed days a week, such as Monday, Wednesday, and Friday.
  • Five shorter days instead of the standard full-time hours.
  • Different hours on different weekdays.
  • A rotating or variable schedule that changes according to an agreed rota.

A working pattern is not necessarily the same as the employee’s total contracted hours. Two employees may both work 20 hours per week but have different schedules. One might work four hours every weekday, while another works two full days and one shorter day.

That distinction matters when recording holidays and absences. A system that needs to calculate leave in days or hours must use the appropriate working arrangement and entitlement method.

Information to Prepare Before Setting Up a Working Pattern

Before editing an employee’s record, confirm the details of their employment agreement. This reduces the risk of entering a schedule that does not match the employee’s actual terms.

InformationWhat to confirm
Normal working daysWhich days the employee is contracted to work.
Daily working hoursThe expected hours for each working day.
Weekly contracted hoursThe total hours agreed for a normal week.
Part-time or full-time statusWhether the schedule differs from the standard full-time arrangement.
Effective dateWhen the working pattern starts or changes.
Holiday entitlementThe employee’s annual leave allowance and how it is calculated.
Bank holidaysWhether bank holidays are included in the entitlement or treated separately.
Break arrangementsWhether recorded hours include or exclude unpaid breaks.

Use the employee’s contract, agreed variation, or approved work schedule as the source of truth. Do not estimate contracted hours from recent timesheets if the employee has a different agreed schedule.

How to Set Up Employee Working Patterns in Sage Payroll?

The steps depend on which Sage Payroll product you use. Sage 50 Payroll uses qualifying day patterns for holiday and absence calculations, while Sage Business Cloud Payroll has a Working Pattern tab in the employee record. These features have similar purposes, but their setup screens and options are different. Follow the section that matches your software. Do not use menu instructions from one product in another.

1. Set Up a Working Pattern in Sage 50 Payroll

In Sage 50 Payroll, working day patterns are used to identify an employee’s qualifying and non-qualifying days. The software uses these details when calculating holidays and certain absence-related payments.

The pattern runs from Sunday to Saturday:

  • Q represents a qualifying or working day.
  • N represents a non-qualifying or non-working day.

For example, an employee who works Monday to Friday has this pattern: NQQQQQN Sunday and Saturday are non-working days, while Monday through Friday are working days.

Steps to configure the pattern:

  1. Open Sage 50 Payroll.
  2. Go to Company > Settings.
  3. Select the Absence tab.
  4. Review the available working day patterns.
  5. If the required pattern is not listed, select the last pattern and press Tab to create a new line.
  6. Enter the seven-day pattern, starting with Sunday and ending with Saturday.
  7. Check that each Q and N matches the employee’s agreed schedule.
  8. Save the changes.

For example, if an employee works Tuesday to Saturday, the pattern would be: NQQQQQN is not correct for this schedule. The correct Sunday-to-Saturday pattern is:

N N Q Q Q Q Q Without spaces, enter it as NNQQQQQ. The pattern must reflect the employee’s actual working days. Selecting the wrong days can affect how Sage 50 Payroll calculates holiday and absence durations.

Important: Setting up a pattern in the company settings makes it available for use. You may still need to assign the correct pattern to the employee’s holiday scheme or individual employee record.

2. Assign the Working Pattern to an Employee’s Holiday Settings

After creating or confirming the required pattern, assign it to the employee. This ensures the employee’s holiday calculations use the appropriate working days. In Sage 50 Payroll, you can assign the working day pattern through the employee’s absence and holiday settings.

Steps to assign the pattern:

  1. Open the Employee section.
  2. Double-click the employee whose working pattern you want to update.
  3. Select the Absence tab.
  4. Open Holiday.
  5. Select the Settings tab.
  6. Locate the Working Day Pattern section.
  7. Enter the required pattern or select the finder button to choose an existing pattern.
  8. Enter the Pattern Start Date.
  9. Make sure the start date is the correct Sunday for the pattern.
  10. Select OK, then save the employee record.

If the employee is assigned to a holiday scheme, check whether the scheme already provides a working pattern. Sage applies the scheme’s pattern when it is assigned, but you can edit the pattern on the scheme or in an individual employee’s record where appropriate. Check the result: Reopen the employee’s holiday settings and confirm that the selected pattern and start date are correct. This is especially important before entering new absence records.

3. Create a Custom or Part-Time Working Pattern

Part-time employees do not always work the same days as full-time employees. For example, one employee may work Monday, Wednesday, and Friday, while another works Tuesday through Thursday. In Sage 50 Payroll, create a pattern that matches the employee’s actual working days rather than assigning the standard Monday-to-Friday pattern to everyone.

Here are some examples:

Employee scheduleSunday-to-Saturday pattern
Monday to FridayNQQQQQN
Tuesday to SaturdayNNQQQQQ
Monday, Wednesday, FridayNQNQN NQ
Tuesday, Wednesday, ThursdayNNQQQNN
Monday to ThursdayNQQQQNN

For the Monday, Wednesday, and Friday example, enter the pattern without spaces as NQNQNNQ.

To create a custom pattern:

  1. Open Company > Settings.
  2. Select the Absence tab.
  3. Add a new working day pattern if the required arrangement is not available.
  4. Enter the correct Q and N sequence from Sunday to Saturday.
  5. Save the pattern.
  6. Open the relevant employee record.
  7. Go to Absence > Holiday > Settings.
  8. Assign the new pattern and enter its correct start date.
  9. Save the employee record.

For employees who work variable hours, avoid assuming that a fixed weekly pattern will represent their actual arrangement. If the schedule changes regularly, you may need a suitable entitlement method or further guidance on how to record the employee’s leave.

4. Set Up a Rotating or Multi-Week Working Pattern

Some employees follow a repeating schedule that changes from one week to another. Examples include shift workers, employees working alternating weeks, and employees on rotating schedules. A single seven-day pattern may not represent these arrangements accurately.

Sage 50 Payroll supports working day patterns that can be used for different weeks in a cycle. You should enter the sequence that reflects the employee’s actual rota and set the correct start date. For example, an employee might work three days in one week and four days in the next. Their pattern needs to reflect both weeks rather than repeating the first week’s schedule.

Steps to set up a multi-week pattern:

  1. Review the employee’s agreed rota and identify how many weeks it takes to repeat.
  2. Prepare the working-day sequence for each week.
  3. Open the employee’s holiday settings.
  4. Enter the appropriate working day pattern or patterns.
  5. Set the pattern start date to the first Sunday of the relevant cycle.
  6. Check that the sequence follows the correct order of weeks.
  7. Save the changes.
  8. Review the employee’s holiday calculations to confirm that working and non-working days are being recognized correctly.

For patterns longer than one week, the start date is particularly important. Sage’s guidance specifies that you should use the first occurrence date of the pattern. If the cycle starts on the wrong date, the software may interpret the employee’s working days incorrectly.

Do not change the pattern simply because the employee has swapped a shift for one week. A temporary change should be handled according to your absence and rota procedures, while the permanent working pattern should continue to represent the agreed recurring schedule.

5. Set Up a Working Pattern in Sage Business Cloud Payroll

If you use Sage Business Cloud Payroll, the setup is different from Sage 50 Payroll. The product provides a Working Pattern tab in the employee record. When you create a new employee, the default pattern is Monday to Friday. You can keep this standard pattern or select a custom cycle.

Available pattern types include:

  • Monday–Friday
  • Custom 1 Week
  • Custom 2 Weeks
  • Custom 3 Weeks
  • Custom 4 Weeks

Use a custom option when the employee does not follow a standard Monday-to-Friday schedule.

Steps to set up the employee pattern:

  1. Select Employees from the menu bar.
  2. Choose the relevant employee.
  3. Open the Working Pattern tab.
  4. Select the Working Pattern Type dropdown.
  5. Choose Monday–Friday or the appropriate custom pattern.
  6. In Week Starting On, select the Sunday when the pattern should begin.
  7. Select the days the employee normally works.
  8. Review the selected days carefully.
  9. Select Save.

A working pattern in Sage Business Cloud Payroll always begins on a Sunday. Make sure the selected start date corresponds to the beginning of the employee’s actual schedule. For example, if an employee works Tuesday, Wednesday, and Thursday every week, select Custom 1 Week and mark those three days as working days.

For an employee whose schedule repeats every two weeks, select Custom 2 Weeks and enter the working days for both weeks. Do not use the Sage 50 Payroll Q/N instructions for this screen. The products use different working pattern interfaces.

6. Change an Employee’s Working Pattern or Contracted Schedule

An employee’s working arrangements may change because of a promotion, a move to part-time work, a change in shift allocation, or an agreed flexible working arrangement. When this happens, update the employee’s working pattern from the date the new arrangement takes effect. Avoid overwriting historical information without checking how the change may affect existing holiday and absence records.

For Sage Business Cloud Payroll:

  1. Open Employees.
  2. Select the employee.
  3. Go to the Working Pattern tab.
  4. Review the existing pattern.
  5. Select the appropriate new pattern type.
  6. Choose the Sunday on which the new pattern begins.
  7. Select the correct working days.
  8. Save the updated pattern.

For Sage 50 Payroll:

  1. Open the employee’s record.
  2. Select Absence > Holiday > Settings.
  3. Review the current working day pattern.
  4. Update the pattern to reflect the new arrangement.
  5. Enter the appropriate pattern start date.
  6. Save the changes.

If the employee’s contracted weekly hours also change, review the relevant employment and pay details separately. A working day pattern identifies when the employee normally works; it does not necessarily update their salary, hourly rate, or contracted hours automatically. For example, changing an employee from five working days to three working days does not automatically mean their weekly salary or pay rate has been recalculated. Review the employment agreement and payroll pay elements before processing the next pay run.

Before saving: Check whether the employee has holidays already booked or absence records that overlap the change date. Confirm how those records should be treated under your organization’s policy and the applicable employment rules.

Configure Holiday Entitlement Based on the Working Pattern

Setting up an employee’s working pattern is only part of holiday configuration. You should also check the employee’s holiday scheme to make sure the entitlement is appropriate for their working arrangement.

Sage 50 Payroll supports two main types of holiday schemes:

  • Specified entitlement: Calculates holiday entitlement using a defined number of days, hours, or weeks.
  • Calculated entitlement: Calculates entitlement using the average hours worked over a specified number of weeks.

The appropriate option depends on the employee’s contract and how your organization manages annual leave.

A. Specified Entitlement Holiday Scheme

Use a specified entitlement scheme when the employee has an agreed holiday allowance, such as a fixed number of days or hours. To create the scheme in Sage 50 Payroll:

  1. Select Company > Holidays.
  2. Select New.
  3. Enter a scheme name.
  4. Set the scheme type to Specified Entitlement.
  5. Open the Entitlement tab.
  6. Enter the employee’s entitlement in days, hours, or weeks.
  7. Choose whether holidays accrue daily or calendar monthly.
  8. Review the options for carrying unused entitlement forward or allowing employees to take entitlement in advance.
  9. Select the Settings tab.
  10. Choose the scheme start date.
  11. Enter the working day pattern using Q for working days and N for non-working days.
  12. Enter the first Sunday of the pattern in Pattern Start Date.
  13. Save the scheme.

Once the scheme is created, assign it to the appropriate employee or employees. Check the assigned scheme and individual employee settings before relying on the calculated holiday balance.

B. Calculated Entitlement Holiday Scheme

A calculated entitlement scheme is useful when holiday entitlement needs to be based on the employee’s average hours worked over a specified period. This can be relevant for employees whose hours vary, depending on their working arrangements and the applicable holiday entitlement rules.

In Sage 50 Payroll, the scheme uses the average hours worked over the selected number of weeks. Important setup considerations:

  • Set up the scheme before processing the payroll periods it covers.
  • Enter the appropriate working day pattern.
  • Set the pattern start date to the relevant Sunday.
  • If you calculate holidays in hours, make sure the employee is paid by the hour in Enter Payments.
  • Select Include for Weekly Averages where required so the relevant payments are included in the calculation.

Do not choose a calculated scheme simply because an employee works part-time. The correct holiday entitlement method depends on the employment arrangement and applicable rules, not just the number of working days. If you are unsure how much leave an employee should receive, confirm the entitlement with your payroll adviser or consult the relevant employment guidance before configuring the scheme.

Check Working Hours and Contracted Hours Separately

A working pattern and contracted hours are related, but they are not interchangeable. A working pattern identifies the days an employee normally works. Contracted hours describe the total hours agreed under their employment terms. Depending on the Sage Payroll product, these details may be maintained in different parts of the employee record.

For example:

EmployeeWorking patternWeekly contracted hours
Full-time employeeMonday to Friday37.5
Part-time employeeMonday, Wednesday, Friday18
Short-hours employeeMonday to Thursday20
Flexible employeeVaries by agreed rotaAs contracted

An employee who works three days per week might work six hours each day or eight hours each day. The working pattern alone does not establish the total weekly hours.

When contracted hours change:

  1. Check the employee’s updated contract or approved variation.
  2. Confirm the new working days and daily hours.
  3. Update the working pattern where necessary.
  4. Update the relevant contracted-hours or pay information in the employee record.
  5. Review salary or hourly pay calculations.
  6. Check the holiday scheme and entitlement.
  7. Confirm the effective date before processing payroll.

Do not assume that changing the working pattern automatically changes the employee’s pay. Review the pay details separately and make sure the payroll record matches the agreed employment terms.

Common Working Pattern Setup Mistakes to Avoid

Even when the correct menu is used, small setup mistakes can affect holiday and absence calculations.

Common mistakeHow to avoid it
Selecting the wrong working daysCompare the pattern with the employee’s agreed schedule.
Using the wrong start dateCheck that the pattern begins on the correct Sunday.
Applying a full-time pattern to a part-time employeeCreate or select a pattern that reflects the employee’s actual days.
Ignoring a rotating scheduleConfigure the full cycle rather than only the first week.
Forgetting to assign the patternCheck the employee’s individual holiday or absence settings.
Confusing contracted hours with working daysMaintain hours and working patterns separately where required.
Changing historical information unnecessarilyCheck the effective date and existing absence records first.
Using the wrong Sage product instructionsConfirm whether you use Sage 50 Payroll or Sage Business Cloud Payroll.

One particular mistake is entering a pattern with the correct number of working days but the wrong weekday sequence. For example, an employee who works Monday, Wednesday, and Friday should have the Sunday-to-Saturday pattern NQNQNQN. A pattern with the same number of Q entries but different positions represents a different schedule.

How to Check That the Working Pattern Is Correct?

After saving the pattern, review the employee record and confirm that the information matches the agreed schedule.

Use the following checks:

  • Working days: Confirm that each normal working day is selected and each rest day is excluded.
  • Pattern cycle: If the employee follows a multi-week rota, check every week in the cycle.
  • Start date: Confirm that the pattern begins on the correct Sunday.
  • Holiday settings: Check that the employee’s holiday scheme uses the intended working pattern.
  • Entitlement: Review the holiday allowance and whether it is calculated in days, hours, or weeks.
  • Pay details: Confirm that contracted hours and pay arrangements reflect the employee’s agreement.
  • Absence records: Check that existing and future leave entries are consistent with the updated schedule.

For Sage 50 Payroll, the Employee > Holiday Working Days Pattern report can also help you review employee working patterns.

If an employee’s holiday duration looks incorrect, check the working pattern and holiday scheme before manually changing the entitlement. Correcting the underlying setup may resolve the calculation issue more reliably than adjusting the balance alone.

Conclusion

Setting up employee working patterns in Sage Payroll helps maintain accurate employment, holiday, and absence records. The correct configuration depends on whether the employee works a standard Monday-to-Friday schedule, a part-time arrangement, or a repeating shift pattern.

In Sage 50 Payroll, working day patterns use Q and N entries from Sunday to Saturday and can be assigned through the employee’s holiday settings. In Sage Business Cloud Payroll, you can select a standard or custom one-to-four-week pattern from the employee’s Working Pattern tab.

Remember that working days, contracted hours, pay details, and holiday entitlement are separate pieces of employee information. Review each one when creating or changing a schedule. A carefully configured pattern, correct start date, and suitable holiday scheme help keep payroll and absence calculations consistent.

FAQs of Set Up Employee Working Patterns in Sage Payroll:

How do I set up employee working patterns in Sage Payroll?

The process depends on your Sage product. In Sage 50 Payroll, configure the working day pattern under the absence settings and assign it through the employee’s holiday settings. In Sage Business Cloud Payroll, open the employee record, select the Working Pattern tab, choose the required pattern type, select the working days, and save.

Can I create a custom working pattern for a part-time employee?

Yes. You can configure a pattern that reflects the employee’s normal working days. In Sage 50 Payroll, use a Q and N sequence from Sunday to Saturday. In Sage Business Cloud Payroll, select an appropriate custom pattern and mark the employee’s working days.

How do I change an employee’s working pattern in Sage Payroll?

Open the employee record and locate the working pattern or holiday settings, depending on your product. Select the new schedule, enter the correct effective or start date, and save the changes. Also review contracted hours, pay details, and holiday entitlement separately.

Does changing a working pattern automatically update contracted hours?

Not necessarily. A working pattern identifies the employee’s normal working days, while contracted hours represent the total hours agreed under their employment terms. Update the relevant hours and pay information separately where required.

How do I set up a rotating working pattern in Sage 50 Payroll?

Identify the full rota cycle and configure the working days for each week. Enter the correct pattern start date, using the first occurrence of the cycle. Check that the sequence represents the employee’s complete repeating schedule rather than just the first week.

Does an employee’s working pattern affect holiday entitlement in Sage Payroll?

Yes, it can affect how holidays and absences are calculated. Sage 50 Payroll uses qualifying day patterns to identify working and non-working days. Holiday entitlement also depends on the employee’s assigned scheme and whether entitlement is calculated in days, hours, or weeks.

Why is an employee’s holiday calculation incorrect after changing their working pattern?

The pattern may have the wrong working days, an incorrect start date, or may not be assigned to the employee’s holiday settings. The holiday scheme may also use an unsuitable entitlement method. Review these settings and check existing absence records before manually adjusting the employee’s holiday balance.

Related Articles