Creating A Data File For 2023-24

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

Creating the new file

1) – Before creating the new file, it is important to ensure that the last pay period in the 2022-23 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 2023, 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 2023-24 (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’ ).

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

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

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 2022-23, then Payroll Manager will automatically populate the Basic Pay column in Month 1 of 2023-24 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:-

• ‘No Copy’ – Does NOT copy the data item from the previous year’s file.
• ‘Last to first’ – Copies the data item from the last pay period of 2022-23 into the first pay period of 2023-24.
• ‘Last to all’ – Copies the data item from the last pay period of 2022-23 into ALL pay periods in 2023-24.
• ‘Copy all’ – Copies data items from each pay period of 2022-23 into the corresponding pay period of 2023-24.

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

6) – And that’s it! The new data file for 2023-24 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 year’s 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.

Q. I wish to change the pay frequency of an employee how do I do this? 

A. If you have not yet paid anyone in tax year 2023-24 then you can change their pay frequency from the ‘Employees – Employee Details – Payment‘ screen of the 2023-24 payroll file. You will need to delete any pay that may be on the ‘Pay Details’ screen in 2023-24 for such employees before doing so, otherwise this section will be ‘greyed-out’.