Creating A Data File For 2020-21

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 2019 to March 2020 would be contained in a file called ‘ABC Ltd 2019-20.pay’. In order to continue processing payroll for a new tax year (i.e. from April 2020 onward) you need to create a new data file (which will be called ‘ABC Ltd 2020-21.pay). 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 2020-21.

Note: The facility to create a file for 2020-21 will become available following a software update during the week following the Chancellor’s budget statement of 11 March 2020.

Creating the new file

1) – Before creating the new file, it is important to ensure that the last pay period in the 2019-20 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 2020, 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 2020-21 (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 file 2020-21

3) – When creating the new file for 2020-21, Payroll Manager will automatically carry forward the details of all employees (except those that have been marked as leavers in 2019-20), and would also ‘uplift’ the Tax Code for each employee according to HMRC rules if appropriate (Note: for 2020-21 the Government have announced that there will be NO uplift in tax codes, so e.g. employees on tax code 1250L in 2019-20 will remain on tax code 1250L in 2020-21).

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. Please be aware that the eligibility criteria for claiming the Employment Allowance (EA) have changed from April 2020, and it is important that you understand these new rules before deciding whether or not you can claim the EA for 2020-21. Please see our updated guide to the Employment Allowance.

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 2019-20, then Payroll Manager will automatically populate the Basic Pay column in Month 1 of 2020-21 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

  • ‘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 2019-20 into the first pay period of 2020-21.
  • ‘Last to all’ – Copies the data item from the last pay period of 2019-20 into ALL pay periods in 2020-21.
  • ‘Copy all’ – Copies data items from each pay period of 2019-20 into the corresponding pay period of 2020-21.

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 2020-21) and the location in which it will be stored. Click ‘OK’ to save the new file.

save file

6) – The eligibility rules for claiming the Employment Allowance (which can be used to reduce an Employers NIC bill) change from April 2020, and a message will appear in Payroll Manager immediately after you have saved the new file. We would encourage you to click on the ‘More Information‘ button and read our updated guide on the Employment Allowance at your earliest convenience.

Employment Allowance

7) – And that’s it! The new data file for 2020-21 is now open and ready to use!

FAQS

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