Creating A Data File For 2021-22

Print Friendly, PDF & Email

Payroll Manager stores the payroll information for each tax year in a separate data file on your computer. For example, if your company is called ‘ABC Ltd’, then your payroll information for the period April 2020 to March 2021 would be contained in a file called ‘ABC Ltd’. In order to continue processing payroll for a new tax year (i.e. from April 2021 onward) you need to create a new data file (which will be called ‘ABC Ltd Payroll Manager does this for you and carries forward all of the relevant payroll information from one tax year to the next. This guide takes you through the process of creating your data file for 2021-22.

Creating the new file

1) – Before creating the new file, it is important to ensure that the last pay period in the 2020-21 file is complete to ensure that the correct figures are carried across to the following year for all employees (you don’t need to have filed your final RTI submission at this point, but you do need to make sure that you have finished entering all of the employee pay details).

2) –  From the beginning of April 2021, a red message will appear just above the ‘Pay Details’ screen prompting you to ‘Click here to create a file for next year’. Click on this message when you are ready to create the file for 2021-22 (if you don’t see this red message or if you wish to create the file before April, you can instead click ‘File – New – Create a file for next year’. If you get an error message telling you that this is not possible, then please update your software first by clicking ‘Help – Program Update)’.

click to create

A dialogue box will appear with a reminder to ensure that all pay details for the last period have been entered:-

create new file

3) – When creating the new file for 2021-22, Payroll Manager will automatically carry forward the details of all employees (except those that have been marked as leavers in 2020-21), and would also ‘uplift’ the Tax Code for each employee according to HMRC rules if appropriate.

Calendar items such as Sick, Maternity and Paternity Pay along with holiday details are also carried forward to the new year. Details of Student Loan deductions, Attachments of Earnings Orders and Holiday Fund balances will also be carried forward to the new year, as well the ‘Employment Allowance’ status of the employer.

By default, Payroll Manager will also ‘copy-over’ the pay from the final pay period of last year into the first pay period of the next year. If, for example, an employee has a Basic Pay of £2000 in Month 12 of 2020-21, then Payroll Manager will automatically populate the Basic Pay column in Month 1 of 2021-22 with £2000 (the same rule is applied to weekly, 2-weekly and 4-weekly paid employees). If you wish to proceed on this basis then click ‘OK’, and go straight to Step 5 of this guide.

(In the rare event that you wish to change the way that Payroll Manager copies data from one year to the next click on the button marked ‘Show advanced options’ which will allow you to choose how the data will be copied over.)

4) – The ‘Advanced Options’ screen allows you to choose from the following options for each data type:-

advanced options screen

  • ‘No Copy’ – Does NOT copy the data item from the previous years file.
  • ‘Last to first’ – Copies the data item from the last pay period of 2020-21 into the first pay period of 2021-22.
  • ‘Last to all’ – Copies the data item from the last pay period of 2020-21 into ALL pay periods in 2021-22.
  • ‘Copy all’ – Copies data items from each pay period of 2020-21 into the corresponding pay period of 2021-22.

When you have selected how you wish the data to be copied over, click ‘OK’ to proceed.

5) – Payroll Manager will show the name of the new file (e.g. ABC Ltd 2021-22) and the location in which it will be stored. Click ‘OK’ to save the new file.

save the new file

6) – And that’s it! The new data file for 2021-22 is now open and ready to use!


Q. I need to change my pay dates – how do I do this?

A. If for some reason you know that you have the wrong pay dates set in the software then you should change them immediately after creating the file for the new year. Click ‘Tools – Pay Dates‘ should you need to do so.

Q. I have a credit with HMRC that I wish to claim in the new year – how do I do this?

A. If you have a credit with HMRC from the previous tax year that you wish to set off against PAYE liabilities in the new year then, with the new file open,  click ‘Employer‘ then ‘Previous Year Overpayment to HMRC‘ from the main menu in Payroll Manager and enter the credit amount in the first tax month of the new year.

Q. How do I go back to last years file to print a P60 to give to my employees? 

A. Should you need to access the previous year file (e.g. to file your final RTI submission or to print P60 forms) you can do so by clicking ‘File – Open’ from the main menu.

Was this article helpful?

Related Articles