the Payroll and End of Year
Contents
1. lt Payroll for the tax year amp taxyear H U J K L M N o ES Payroll for the tax year 2015 16 2 3 4 Please select an option to go to the screen 5 s Employer screen Databane T L 8 Internet c My Documents 9 Employee screen 10 Transfer folder c agywin L Control panel 12 Transfer file in 13 a P11 Transfer P60 data in 16 17 P60 Payelink c My Documents 18 19 27 ES Calc irmark 21 Internet use 22 User ID 23 Transfer file out 24 Password 25 26 This is the testing flag 27 If ticked you can only have one employer 28 land one employee 29 Please contact the supplier for the 30 full version 34 L es 7 a 4 4 m Submission Startup Employers Sheet1 Employees Warnings Control panel_ Whatis paid Payslip p11 p32 P60 Paysummary piid Ji Ready 73 E Screens The buttons take you to the appropriate screens and buttons on these screens will guide you through the other options 10 Select the employer button and move to the following screen BYR I A S s PAYE2016 v03 Compatibility Mode Microsoft Excel Le Ses kil Home Insert page Layout Formulas Data Review View Developer Acrobat ox a 72 Record Macro Ge eZ SF Properties E perties j Import 35 12292 Buse Relative References2. r Ga Us e a7 PAYE2016 v03 Compatibility Mode Microsoft Excel elaks 9 Home Inset page Laraut Formulas Data Review View Developer Acrobat 9 8 X E Z Record Macro a EF Properties P 2 12222 Ey Use Relative References OS Q View Code Visual Macros Insert Design Basic Macro Security Mode 3 Run Dialog Code Controls A53 ba fj ann e G D E F G H 1 B K L M N o P 57 58 Please enter the NIC table letters Employee screen 59 60 Starting at NI Contribution 61 month number Table Letter APP 1 2 3 4 5 6 62 63 64 65 66 67 Hours worked for RTI g 1 5 E 69 Irregular payments 70 Used for RTI Please tick if irregular gt 71 72 Director 73 Tick here if director 74 Date appointed CI 75 76 Tick if annual calculation Not used 7 is not to be used for NIC 78 The annual calculation will always be used for the last month 79 of the year or when the NI table code changes 80 81 Scottish Variable Rate 82 not used in 2015 16 83 84 Please enter the details if new this year Go to P45 85 86 Tick here if new employee gt RT R 1 E H Submission Startup _ Employers Sheeti_ Employees Warnings Control panel_ What is paid Payslip p11 _ p32 P60 Paysummary piid ifu Ready 73 EE S Enter the starting month usually 1 and
3. Tax Month 12 0103 2016 to 31 03 2016 29 12 2014 Works Staff no3ross for tayPensionce Pensioner NCce NCer NCtotal Tax Statutory Studian DEOS Net Pay RTI Hash Maternity 5 000 00 0 00 0 00 372 56 596 71 969 27 2 000 00 0 00 319 00 0 00 2 308 44 YAB 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 EUV Robin2 2 500 00 0 00 000 19116 183 24 37440 433 00 000 000 000 1 87584 62 12345678 5000 000 0 00 0 00 0 00 0 00 0 00 0 00 000 000 50 00 LX8 JK 45 3 1 500 00 0 00 0 00 85 16 24 164 40 oo o 0 00 1 114 84 OEA F 905000 0 00 0 0 00 00 319 00 0 00 5 349 12 73 L 300 00 00 648 88 859 19 1 508 07 2 733 00 The report shows department subtotals if appropriate 21 Sundry notes and details You can access other sections of the payroll from the buttons on employee screen The following describes information on the various screens Different pay periods If different employees have different pay periods e g weekly and monthly and work for the same employer you will need to work out pay for each employee in turn not all together This will prepare the P11 please remember to save the employee information to the database Return to the employer screen and choose the P32 option to prepare the P32 for the employer Director previously employee appointed during the year HMRC recommends that a new P11 be started The old P11 will have a leaving date the
4. ut Formulas Data Review View Developer Acrobat ox ss F Properties T Map Properties Import aw Gel View Code Pi Expansion Packs Export Insert Source cg a iode 3 Run Dialog 9 Ref Controls XML sh Data Al MA f Payroll for the tax year amp taxyear B C D E F G H 1 J K L M N o P 115 116 Tick this box to exclude from normal P 117 118 P38 Section 119 120 Tick this box to include in P38A processing 121 122 What is the type of work eg Harvest worker 123 124 Which section A or B 125 A any worker who was paid 112 or more in ar 126 any worker who was taken on for more than a 127 128 B any worker who was paid more than 100 in tota and not listed in Section A or 129 harvest workers see booklet CWG2 Employer Furth r Guide to PAYE and NICs 130 131 Earlier Year Update 132 Tick here to send an earlier year update EYU 133 134 NEST or other pension scheme contributions 135 136 Tick this box if the employee has opted out 137 Cc Cc 139 140 Sort code of recipient s bank 141 142 Rarely used RTI data 143 144 Foreign country i a p m Submission Startup Employers Sheet1 Employees Warnings Control panel What is paid Paysip p11 p32 P60 Paysummary p11d Ready 73 Then on the employer screen select the button Prepare Earlier Year Update button to send the informatio
5. S QA view Code Z Expansion Packs Export Visual Macros s Insert Design Source cg Basic A Macro Security lt ode Run Dialog Refresh Dat Code Controls XML Al RA f lt Payroll for the tax year amp taxyear A B C D E a G 1 J K M N o P Q R S ER Payroll for the tax year 2015 16 2 3 Please use this screen for employers 7 Open employer from Save employer to see era Remove employer Print employer Retrieve employer ee ees a dat employee details from c from last year and save Tidy up database 6 abase database from database information from last year 7 all screens in this year 8 9 Name and address of employer Select the button for 10 Name _ Please enter the name here Go to Employee screen 11 Address Please enter the address here a Prepare P32 Prepare P11D 14 Y 15 Country Go to P32 Go to P11D b 16 Postcode y Lt Prepare P60 for all Prepare Earlier Year 18 HMRC Office amp PAYE referen I L employees Update 19 Please check 20 Contracted out pension scheme 22 using P32 data 23 Your reference SS mnp aps 24 25 For employer s use ED gt Tick if final EPS EJ y 27 T LOOKING BACK No payment for period 28 Accounts office reference _ ___ ___ _ Payment Summary Select the start tax month for a past nil EPS a _ EPS M4 H Submission Startup Employers Sheeti_ Employees Warnings Control panel_ What is paid Payslip pil p32 P60 Paysummary pild J
6. Disclaimer The Supplier shall have no liability in any way arising out of the use of PAYE2000 and the Customer by using the software acknowledges this It is imperative that the user of PAYE2000 understands that it is not a substitute for the knowledge and skill of a payroll practitioner PAYE2000 has been designated to assist the practitioner not to replace him or her and accordingly users should always check the calculations and end of year Return before it is submitted Software Support Telephone support is available to help users solve any questions they have with the functionality of PAYE2000 on the following numbers 01483 429078 Andrew Bolton 01453 761956 Rebecca Benneyworth FCA The Supplier undertakes to respond to messages left on voicemail within eight hours of the call being lodged between the hours of 9 00 am to 4 00 pm Monday to Friday The Supplier will endeavour to respond quickly to any call Any special circumstances which prevent this response time being met at any time will be reported on voicemail The Supplier will provide support for the installation for approximately one hour to assist the customer in using PAYE2000 for no extra charge Any additional training time will be charged at 100 an hour by agreement in writing with the Customer The support will not provide technical tax or payroll advice Enquiries about these subjects should be directed to HMRC Copyright This document represents a limited licence
7. Ready 2 Please remember to select the Remove details button before setting up a new employer You must complete and save at a minimum the following Name Address HMRC office 3 digits PAYE reference Accounts office reference for RTI For the payroll e Whether employees are paid monthly or weekly or any other frequency if weekly the first pay day of the tax year usually the first Friday if monthly the start day of each month usually 1 Lower down confirmation that the employer is part of RTI Data can also be provided for the HMRC office eligibility for small employer s relief entitlement to the employer s allowance 2 000 and departments within the employer Please select the Retrieve employer button to bring forward employer information from the previous tax year and select the Retrieve all employees to bring forward each employee after you have brought forward the employer This will automatically increment the latest tax code if an L code by a fixed amount for 2015 16 this is 60 11 A new employee Select the employee button on the first screen and move to the following screen GAEE GA ITIS PAYE2016 v03 Compatibility Mode Microsoft Excel Soe x a en a a a Developer Acrobat 9 8 gt J Record Macro N Properties erties j Import anes R SS 2 Use Relative References GA View Code 7 Export Vi
8. Allocate payroll history is incomplete 65 Week end Weekly Thispay Daily Weeks 66 Saturday Week Sun Mon Tue Wed Thu Fri Sat Amount period rate remaining 67 20 09 2014 28 68 27 09 2014 27 69 04 10 2014 26 70 11 10 2014 25 z A610904 na a t p Pn a a L M4 m P35 page 2 P35 page 3 P35page4 P35 continuation 1 payslipsort P45 part 14 P45 part 2 P45 pait 3 P38a_ Paymaster SSP Sup Ready 73 E 24 Earnings orders You must provide the following information All orders require Start date End date if appropriate Date of issue used to prioritise different orders Date of receipt used to prioritise different orders Priority and non priority AEOs and DEOs need Initial amount Amount in previous year if appropriate The protected amount may be 0 The normal deduction 25 Real Time Information RTI There are five items day to day processing what you have to do at the end of the tax year interim Employment Payment Summary ad hoc requests and Earlier Year Updates HMRC advises that you make sure employee information is complete accurate and up to date before RTI starts especially that you have correct dates of birth and National Insurance Numbers Day to day RTI processing You must use the control panel option to prepare the payroll and the RTI submission Oa 97T ATS PAYE2016 03 Compatibility Mode Microsoft Excel lelos lt Home Inset Pagelayo
9. are a number of straightforward steps to follow for end of year processing b c d e f g h i 1 pY N 9 az PAYE2016 v03 Compatibility Mode Microsoft Excel Le Ses a Page layout Formulas Data Review View Developer Acrobat C Z Record Macro Re F Properties Map Properties A Import EER yd d A Use Relative References aw QA View Code Z Expansion Packs 7 Export Visual Macros v Insert Design Source cg Basic Macro Security Mode Run Dialog 9 Refresh Data Code Controls XML Al kad E lt _Payroll for the tax year amp taxyear eal B G D E F G H 1 J K L M N 0 P Q R S 9 Name and address of employer Select the button for 10 Name lest for 2015 16 gns Go to Employee screen 11 Address jan address e iz Prepare P32 Prepare P11D 14 Y 15 Country Go to P32 Go to P11D b 16 Postcode a ae 7 P re Earlier Year Prepare P60 for all repai 18 HMRC Office amp PAYE reterencef 999 employees Update 19 20 Contracted out pension scheme 21 ECON E3567891A Prepare EOY Summary Go to Wamings 22 using P32 data E 23 Your reference TA 24 25 For employer s use SUED gt nek nna SPS X 28 4 27 T LOOKING BACK No payment for period 28 Accounts office reference 581pn00229178 Payment Summary Select the start tax month for a past nil EPS EPs 30 HMRC office name ef ___f 31 not required forfhe intemet Your RTI sufmission
10. hab been accepted Select the end tax month for a past nil EPS 32 Address 33 34 LOOKING FORWARD Period of inactivity 35 Select the next tax month for a future nil EPS 36 37 Za 4 4 Employers Sheet mployees Warnings Control panel What is faid Ready Z a Prepare the P32 Go to the P32 to review Go back to the employer screen Prepare P60 for al employees you get an option to print the P60s Prepare EOY Symmary this summarises the payroll totals on the P35 Go to the P35 fo review especially page 3 where you can add any extra recoveries Go back ohe employer screen Tick the Hox for Final EPS Prepare the Employer Payment Summary EPS you must select No for Live and you must confirm that you want to submit the EPS after preparation lower down Select the Press here to record in the database button 28 Interim EPS You can submit an interim EPS if you wish to set off the recovery of statutory payments against your regular tax and NI liability You need to prepare a P32 first to summarise any statutory payments and then select the Prepare EPS button without ticking the final EPS button If you have no recoveries to make and no employee payments in any month then you should submit a NIL interim EPS return please choose the appropriate tax month the looking back option and select the prepare EPS button You must do this after the 5 of the month i e after the end of the tax month thi
11. new P11 will have details of earnings in the previous job i e prior to becoming a director You will need to distinguish the name of the employee e g by adding Director to the name You will prepare two P60s at the end of the year The first will show the tax earnings and NI prior to becoming a director The second will show the cumulative tax and earnings and also show the director s NI Director ceasing to be a director during the year but continuing as a paid employee HMRC recommends that a new P11 be started The situation is the reverse of the above Holiday pay We calculate holiday pay following HMRC s examples for weekly paid employees In particular we use Method B for calculating NICs this uses the whole sum based on the number of weeks it represents We follow the suggested option number apply the 3 weekly lower and upper earnings limits and earnings threshold to the total payment and round the resulting NICs figures to the nearest penny rounding down exact amounts of 2p in the normal way Note that the revised earnings threshold for NIC must be obtained from the annual value and is not just a simple multiple of the weekly value The lower and upper earnings limits are multiples of the weekly values 22 Statutory pay SMP SAP SPP The amount of statutory pay depends on average earnings prior to the period of statutory payment The payroll software calculates the average based on the payroll histor
12. the NIC code The What is paid convention is followed once you have entered a code it is used for the starting month and all subsequent months unless you enter a new month and code underneath the first month Directors Information about directors is included lower down this affects the calculation of NIC New members of staff Information about the previous employment of new members of staff is included below you can check the P45 data or leaving notice for tax already deducted in a previous employment 17 Joiners Move down the employee screen to see not used in 2015 16 Please enter the details if new this year Tick here if new employee gt o First month in this employment H OoOO not used in 2015 16 Please enter the details if new this year Tick here if new employee gt Start First month in this employment H E Tax code from P45 part 1 Please enter tax code Week or month number from P45 part 1 7 week men 1 D Check P45 data Please enter period Total pay to date from P45 part 1 Please enter pay to date Calculated tax Total tax to date from P45 part 1 Please enter tax to date Previous employer HMRC office ang referen
13. 7 B Payments made on behalf of employee 18 Description of payment 19 A 20 Taxon notional payments not borne by employee within 90 days of receipt of each notional payment 21 22 DB vouchers and credit cards Amount made good or 23 Gross amount from which tax deducted Cash cquivalcnt 24 Value of vouchers and payments made using credit cards 0 00 25 26 27 EJ Living accommodation Cash equivalent 28 Cash equivalent of accommodation provided for employee or his her family or household Go to Working Sheet 1 29 30 Ei miteage allowance and passenger payments Taxable amount 4 gt H Startup Employers _ Sheet1_ Employees Warnings Control panel What is paid Payslip pL p32 Ready 723 You can scroll down the screen to access the various HMRC working sheets Standard values such as mileage allowances are Wuilt in to the P11D The screen follows the Revenue s numbering and naming conventions and it is designed to capture information which will be sub nyxfted electronically It is not an approved printed substitute The buttons marked Working Sheets take you to supporting schedules the totals of the schedules are copied back to the appropriate boxes on the main P11D schedule Please remember to save the employee to the database once you have entered the P11D details Once you have added the necessary P11D information for each employee please return to th
14. 9 plid b P35 page Ii Ready 22 You can only useAhese options if you are the employer or an agent with a 64 8 in lace A filin ly agentwill not get any results The P6 and P9 opffons will retrieve tax codes which HMRC has placed in the employer s electronic mailing box The NINO option will retrieve NINOs from previously submitted NINO verification requests or from HMRC s own notifications possibly where you have filed a Full Payment Submission with the wrong employee NINO The results are shown on the Submission screen and can be printed out The changes are not applied automatically it is up to the user to review and make any changes to employees records 31 Earlier Year Updates An Earlier year update is a correction to previously submitted FPS in the tax year after the year of the original submission It is incremental not absolute in other words it is the change positive or negative typically in the pay or tax deducted You need to enter the incremental change on the appropriate employee s P60 deleting any other information and save the employee to the database In addition you need to mark the employee record This should be repeated for all employees who need an update On FEE rE PAYE2016 v03 Compatibility Mode Microsoft Excel E a Home Inset Pag aa a Z Record Macro fH Use Relative Referenc Visual Macros Basic Macro Security Code
15. Payroll and End of Year Processing PAYE2000 2015 16 User Manual and Customer Agreement We accept the terms and conditions set out in this document Signed Dated Capacity in which signed Crown copyright forms are reproduced with the permission of the Controller of Her Majesty s Stationery Office Table of Contents Limited Cen Gases sd ttciare sane aint toa ah Ol cule IE A AAEE an ENEE EAT 3 Whatis PAY E2000 so tt ist aree a EE a etntey oh E a E e EAT 4 Getting started tiers tai En Eayn ak aiated Sagan EAA pian cuss Ea ce ENE EENIA 6 Changing the master spreadsheet essere eee 7 Staring PAY E2016 arae E EA AA pid Evaa EENAA EA 8 R STT the Payroll areetan erp EEE A E e aa aaa 10 Day today payroll ear anaoa a ES 9 A ENEE S Ta 14 Sundry notes und deras essere 2 EST EREE ENAA RAEES I A E EEA NENS 22 Real Time Information RTI see 26 Parlier Year Updates ad fossa see tit aa EE AO E EE meine eases ey oniess 32 PLA Process tt So rren ACS T Ra ointey Susaih ake eck HIE ZERO CESTE r 33 Automatic enrolment and NEST serasa rra RETER ERRER ER TERRE eens 34 Limited Licence The Licence hereby granted to the Customer by Quality Management Software Ltd the Supplier shall take effect in respect of the Payroll End of year Return PAYE2000 for the year of assessment 2015 2016 The Supplier reserves the right to terminate the licence agreement granted forthwith on giving notice to the Customer in writing
16. act the supplier for the 30 full version 31 M 4 m Submission Startup Employers Sheeti_ Employees Warnings Control panel_ What is pand Payslip p11 p32 P60 Paysummary piid J 1 rew me Enter the following information e the location of the database in cell H6 e HMRC user id and password for submitting in year movements and the end of year return by the internet you can change them when you prepare the submissions Remember to save the spreadsheet with File and Save Starting PAY E 20106 Open Microsoft Excel select File Open and choose PAYE2016 from the spreadsheets available Using the database The database contains two main sections the employer and employee information Move to the employer screen and see the display The buttons allow you to retrieve save and delete employers from the database Similarly the employee screen has buttons which allow you to retrieve save and delete employees from the database Any information which is employee related such as P60s is saved with the employee options Information which is employer related such as an RTI submission is saved with the employer options Working with PAY E 2000 Introduction PAYE2016 is a computer system which helps employers and agent prepare payroll and end of year returns PAYE2016 is not a substitute for the knowledge and skill of a payroll practitioner it assists you with the routine tasks of data entry transcribing figures f
17. age 1 P35 page 2 Ready 73 l You must first select a pay period with the up and down arrows and then the button to calculate pay for this period or all periods from the start of the year up to the selected period The payroll process first removes any pay details previously calculated and recalculates the pay The button Prepare payslips and the payroll summary report for all employees works out the pay for the selected period prepares a report and optionally prints the payslips for all employees Please remember to save the current employee first if you have not already done so If you have a mixture of weekly and monthly employees you can use the dropdown to select the appropriate category You must use the Prepare payslips option for RTI FPS submissions HMRC requires that each regular submission includes all employees in the particular category weekly or monthly and must be submitted before the appropriate pay date Payslips The payslips are designed to be printed on special A4 stationery avail window One payslip is printer per page the page is folded in two and the employee s address is visible through the window The stationery is referred to as Mastermailers reference MAILPAD or MAILPADF The latter has a postal franking band and could be posted QMS Ltd and its directors and staff do not have any financial interest in Econoprint 20 A section of the payroll report is as follows
18. ares the RTI submission for the week or month which you have selected as well as the ordinary payslips and the normal summary report for the payroll The option prompts you for the user d and password and whether you want a test or live submission If you choose test vox wI have to run the option again and choose live After the payroll has been prepared you have an optign to submit immediately if you decide not to submit you can submit later using the submit button 26 Notes You can t send P45s and P46s to HMRC You must include the starter and leaving dates in the employee screen before you run the payroll the RTI submission automatically includes the necessary information Re joiners who have left earlier in the tax year an annoying problem at HMRC if you have a re joiner you must provide a new Works Staff number even if artificial HMRC need this to distinguish two separate periods of employment Irregular or infrequent payments please use the tick box on the employee screen if HMRC does not receive any pay record for 13 weeks they will close their record without the irregular flag a subsequent submission will create a second pay record for the same person and may cause complications at the year end 27 The end of the tax year and RTI These steps must be repeated for each employer After you have run the last payroll and submitted the FPS in the tax year 2015 16 please return to the employer screen There
19. ave at a minimum the following e Forename e Surname e Address e Date of birth e Gender And or e National Insurance number We advise you to include the NINO the RTI process needs it For the payroll e Starting period usually 1 and the tax code e Starting period usually 1 and the NIC table letter Data can also be provided for the joiners leavers directors student loans departments Warning messages are shown in red you need to remove the cause of the warning otherwise later processing may not work You can bring forward an individual employee from the previous year by selecting the Retrieve employee button 12 NOTE for RTI users You will not have to submit a P35 and P14s at the end of the year but you still need to go through the process of preparing a P32 We recommend you prepare an EOY summary because it summarises the tax and NI and can be used to reconcile payments to HMRC You do not have to complete at least some of the P35 especially page 4 because this information is no longer required in the final RTI submission of the EPS see the RTI section later 13 Day to day payroll The payroll contains sections for a large number of options which are required for HMRC acceptance tests many of them are not used in normal day to day processing The minimum requirements are as follows and can be reached from the employee screen Please note that references to month also refer to week or any other pay period depen
20. ce Required for P45 part and P46Pen Previous employer leaving date Required for P45 part 3 and P46Pen Tick here if no pay until the ngxt 5 April Job title optional for P45 art 3 or from P46 Tax code used for P46 B or C P46Pen Annual Pension amont Submission Startup Raas Sheetia _Employees ad New employees will either bring a leaving statement with details of earnings or will sign a P46 Enter the appropriate information for the employee or lower down the P46 information 18 NOTE The P45s can be printed on plain A4 stationery following HMRC guidelines the P45 acts as a leaving statement which the employee can show the new employer RTI Users Joining and leaving information is now captured with the start and end dates and included in the first payment details for joiners or the last for leavers Please remember to add the appropriate joining or leaving dates before you run the payroll You can t submit a P45 or P46 electronically However you will need to record a joiner s pay and tax information to date in order to continue calculating tax correctly You will also need to print a leaving statement for leavers HMRC has told us the P45 acts as a leaving statement 19 The Control Panel Selecting the Control Panel button on the employee screen leads to pa F PED PAYE2016 v03 Compatibility Mode Microsoft Excel H
21. day 7 9 Cia PAYE2016 v03 Compatibility Mode Microsoft Excel k lele Home Inset Page layout Formulas Data Review View Developer Acrobat Z Record Macro ga SF Properties T Map Properties Import a Use Relative References GA View Code Z Expansion Packs 7 Export Visual Macros Insert Design Source Basic A Macro Security Mode 3 Run Dialog Refresh Data Code Controls J xM Payroll for the tax year amp taxyear I a a a I H LY PN NY SY POY NEEDY RY ON WY FEY FON FE ON HE Fe Ys YO Y HS 40 Information brought forward 41 A First day of PIW Waiting 1 42 B Date SSP1 change over form issued days in PIW 2 43 C Last day of PIW with you 3 44 Weeks notified on SSP1L 45 Linking letter 46 47 Periods of Incapacity for Work PIW 48 49 Sicknesses PIW Tick if not Avge weekly Pattem of Qualifying Days if different from Monday to Friday or the standard above Calculated 50 Start date End date Start date Enddate entitled including 1B Sun Mon Tue Wed Thu Fri Sat Average Eamings 51 52 3 54 55 56 57 58 59 60 61 62 4 63 Please enter the above if the 64
22. ding on the pay frequency selected on the employer screen Selecting the What is paid button on the employee screen leads to CNCA EE PAYE2016 v03 Compatibility Mode Microsoft Excel lelai a ta Home Insert Page Layout Formulas Data Review View Developer Acrobat o x Ea s Z Record Macro KS A SF Properties E 2 Map Properties 0 Import 2 fH Use Relative References KAJ QA View Code Z Expansion Packs T Export Visual Macros Insert Design Source Basic A Macro Security lt ode Run Dialog 9 Refresh Data Code Controls XML a Al M fe Payroll for the tax year amp taxyear S R B C D E F G H 1 J K L N N o P oja Payroll for the tax year 2015 16 Back to employee screen Employer liest for 2014 15 gns Please use this screen for employee s wages and salary details Work out net to gross Name and address of employee Title Net Forenames Gr 10 Surname 12 What is paid to employee e wia mK Nie 14 Note the same salary 15 continues until you enter 16 ja new week month 17 number and amount 18 19 Salary rate or Salary per month plo Contribution to pension Pension Tick if pension Contribution to pension Pension Tick if on asa l as amount deduction tax deductible as a __ as amount deduction _ strike E STC 9 S a a ZT 9 89 Ready J You must enter the starting month number usually 1 and the basic sala
23. e employer screen and select the Prepare P11D button to prepare and submit the return to HMRC You can review the P11D b summary and print it for your records 33 Automatic enrolment and NEST The payroll software has details which can be used as part of auto enrolment process for pensions We store information which allows you to transfer payments to NEST Each employer must register with The Pensions Regulator TPR and NEST The registration is outside the control of the payroll software As part of the registration process you will receive some information which must be added to the employer screen What you receive is a The NEST reference number used to identify the employer to NEST b The NEST payment source identifier this is usually something simple such as bank NEST has the option to collect payments from a number of sources this is unnecessary for small employers c One or more NEST group identifiers this is used to control groups of payment details typically as monthly or weekly submissions and the simple approach is to call the groups monthly or weekly for the appropriate payroll runs d The staging date from TPR e The deferred auto enrolment date from NEST TPR advise that you should make the best use of the postponement options to allow time to become familiar with auto enrolment and notify all your employees Once you have indicated on the employer screen that it is auto enrolling its em
24. f you are planning to use the database and have copied the database to a directory other than the C directory You should move to the right of the introductory screen and see a display similar to the following Figure 1 BYR 9 BA ZTS PAYE2016 v03 Compatibility Mode Microsoft Excel Se wa Home Inset Pagelayout Formulas Data Review View Developer Acrobat 9 8 X 2 a Z Record Macro ES SF Properties T Map Properties A Import 2 jH Use Relative References KAJ QA View Code Z Expansion Packs 7 Export Visual Macros Insert Design ource coy Basic A Macro Security Mode 3 Run Dialog Refresh Data Code Controls XML Al V f _Payroll for the tax year amp taxyear A B C D E a G H U J K L M N o P Q R sS E l Payroll for the tax year 2015 16 2 3 4 Please select an option to go to the screen 5 s Employer screen Datsbassjc1 8 Internet c My Documents 9 Employee screen 10 Transfer folder cnagywini H Control panel 9 12 E Transfer file in 13 14 i L 15 P11 Transfer P60 data in S 16 7 pen Payelink c My Documents 18 19 zi d _ m 21 Internet use 22 User ID 23 Transfer file out 24 Password 25 26 This is the testing flag 27 If ticked you can only have one employer 28 land one employee 29 Please cont
25. granted to the Customer by the Supplier PAYE2000 may not be reproduced in any way lent or sub let to any other third party without the express permission of the Supplier What is PA Y E 20007 PAYE2000 Quality Management Software Ltd is an Excel spreadsheet that is designed to assist employers and practitioners with payroll and completing end of year Returns It allows the user to quickly and simply complete information on screen as they would on paper It performs the calculation of tax and National Insurance following HMRC s guidelines PAYE2000 includes a database which allows you to keep track of employer and employee information from year to year and to store payroll data and each year s return The database also allows you to monitor the submission of returns to the Revenue Please note the demonstration version includes a built in database which allows one employer and one employee there is no separate database file Before installing PAYE2000 PAYE2000 has a database and you must ensure the appropriate Excel options are installed in order to use it The Setup program in earlier versions of Excel or Microsoft Office includes these options From Office 2000 onwards the options are automatically included You may need your original Office CD or disks Run Setup and choose the Add Remove option Confirm that you have installed the options which allow Excel to use a database These are referred to as Office 97 Data Acces
26. his case you should indicate the standard contribution next tot the salary entry box and lower down the screen include the AVC as a negative adjustment to pay with an appropriate description Both contributions may or may not be deductible for tax and both will appear on the payslip Paying Statutory Sick Pay SSP and cut off day for payments SSP is included in the appropriate weekly payslip for weekly paid employment but only up to a certain day of the week For example if someone is paid on Friday then the days of sickness will be notified typically up to and including Thursday immediately before the Friday You must enter the day of the week in this example Thursday The selected day can be the same as the pay day Any sick days not included in the first week s pay will be included in the following week s pay SSP is included in monthly payslips but only up to a certain number of days before the end of the month This can be zero or you can choose a number such as 5 days i e SSP for sickness in the last 5 days will not be included in the current month but in the next month 23 Sickness periods are entered lower down the SSP screen on the left hand side The payroll program will calculate PIWs waiting days and entitlement to sickness You may need to enter the average weekly salary if there is insufficient payroll history to calculate automatically You can select a different pattern of Qualifying Days the default is Monday to Fri
27. ill to be confirmed by HMRC you must run a separate option to obtain the responses see the next page 30 Please move to employer screen and scroll down to see ia T a nee s PAYE2016 v03 Compatibility Mode Microsoft Excel e Pa jout Formulas Da Ri ew Developer er N e R T e 2 E Z Record Macro M A T Properties S 3 Map Properties S Ke GA View Code 2 H Use Relative References Visual Macros Insert Design Source 5 Basic Macro Security ode Run Dialog 2 pe Code Controls Al oa fe Payroll for the tax year amp taxyear 4 Ee c D E F G H 1 J K L N N 80 81 Cessation Date 1 82 83 NEST or alternative auto enroiment pension scheme B4 85 Tick if the employer makes contributions 86 87 Are the employee contributions are paid net of basic rate tax 88 90 si Paymenteouce J 92 93 Electronic Payments 94 Visit the HMRC website for details 95 about making electronic payments www hmrec gov uk howtopay 96 97 Start date for RTI answers P6 tax codes P9 tax codes NINO results 98 Tax codes NINO Results and General notices 99 101 102 Bank account number 12345678 103 104 Sort Code of Originator s bank 999999 105 15 ung sg Reterenee J 107 108 Please tick when the employer has joined RTI 2 ana RLH Employers Sheeti Employees Warnings _ Contipfpanel_ What is paid p pil p32 P60 Paysummary 811
28. log Refresh Data l Controls XML Payroll for the tax year amp taxyear B G D E F G H 1 J K L M lalaa a O 2 gt Employer Empoyerscreen Knee 4 5 Please use this screen for employees 6 7 Open employee from Save employee to Remove employee Retrieve employee Print employee Remove employee from 8 database base details from screens from last year information database 9 10 Name and address of employee Select the button to move to 11 Title Go to What is paid Go to SSP Remove all old employee 12 Check forenames Forenames OU Gata 2 years ago from neck suas alias Go to Tax codes Go to SMP database 14 Address Please enter the address here H Go to NIC codes Go to SPP A Go to Control panel Go to ShPP ASPP 19 Country Goto P11 Go to SAP 20 Postcode al Go to P60 Eamings Orders 22 Date of birth DOB required tor RTI ______ JOB requ d if no NINO 23 M male Go to P35 P110 24 Gender Required r ne IN F terar 25 Transfer data to P60 for National Insurance Number CO lemer NINO this employee 28 Works Staff Number Cl aban 2 Cc gias 30 Department gt optional used for payroll analysis ME JETS 31 NVR M 4 L m Employers Sheeti Employees Warnings Control panel_ What is paid 62 Lu U Ready 73 T Ejoo y Select this option to submit a request Note you only receive acknowledgment of the submission you do not receive the actual response At some later time st
29. n to HMRC The following link gives more information https www gov uk payroll errors and information about late reporting https www gov uk what happens if you dont report payroll information on time 32 P11D processing We include P11D processing You need to set up employers and employees with a minimum amount of information if you have not used the payroll The payroll information is not sent to the Revenue as part of the P11D process Please choose the P11D button on the employee screen to go to BYR 9 GAT PAYE2016 v03 Compatibility Mode Microsoft Excel ta S Home Insert page Layout Formulas Data Review View Developer Acrobat 2 m Z Record Macro Ge eZ SF Properties S Map Properties Import lt 2 fuse relative References 2N Gel view code Z Expansion Packs 0 Export Visual Macros Insert Design Source w Basic Macro Security Mode Run Dialog 9 Refresh Da Code Controls XML Al x fe P11D Expenses and benefits amp taxyear B c D E F G H 1 J K L M N o P Pl P11D Expenses and benefits 2015 16 E 2 4 5 6 7 8 PAYE Ref 999 A297 Go to Employee screen Name and address of employee x Save employee to ate database 9 Forenames 10 Surname 1 12 EQ Assets transferred cars property goods or other assets 13 Amount made good or 14 Description of assct Cost Market value fromw hich tax deducted Cash equivalent 15 A Hom 16 1
30. ome Inset page Larout Formulas Data Review View Developer Acrobat o x aa ZJ Record Macro Ge 2 Properties S 7 Proper Oi Import Z f Use Relative References Ke Q View code Qj Expansion Packs Export Visual Macros Insert Design Source Basic Macro Security Mode Run Dialog SI Refi ati Code Controls XML Al vq fe Payroll for the tax year amp taxyear i B C D E F G H 1 J K L M N o P Q S F Payroll for the tax year 2015 16 2 Back to employee screen 3 Employer liest for 2014 15 gns R 4 5 Please use this screen to control payroll processing Go to Wamings 6 7 Name and address of employee 8 Title Go to What is paid 9 Forenames 10 Surname S 11 12 Which month do you want to work out pay 13 Start End 14 00 01 1900 00 01 1900 Error too low E les 16 Please select an option Work out pay for this period Remove p11 data for this period 17 only only 18 1 Work out all pay up to and Remove alll p11 data up to and 2 including this period including this period 22 23 Prepare payslips and the Please select the period for the payroll 24 payroll summary report for all only employees with this period will be processed 25 employees sal monthly LS z Submit Full Payment 28 poyrida zs Your RTI submission has been accepted Summary FPS 30 Reason for late submission rarely used Wa Employees Warnings Control panel What is paid Payslip p11 p32 P60 Paysummary plid pild b P35 p
31. onv bene tax nic tax bocoooooo0o0o0o0000000000000 nR E im m mm EI 4 4 L H Submission Startup Employers Sheet Employees Wamings Control panel_ What is pal Paysip p11 092 P60 Paysummary pid ii Ready 23 The description will be printed on the pay slip The adjustment can be positive or negative and can be taxable or not and NICable or not Each adjustment by default is for the starting month and every subsequent month if it is only for the starting month then tick the appropriate box Tick the final box if the adjustment is a benefit it is reported separately in RTI 15 Tax Codes Selecting the tax code button on the employee screen leads to i BWR 9 GA ATS PAYE2016 v03 Compatibility Mode Microsoft Excel Se x Home Inset page larout Formulas Data Review View Developer Acrobat E aA P Record Macro B A EF Properties Map Properties Import Eo E H Use Relative References KAJ QA View Code Z Expansion Packs T Export Visual Macros Insert Design Source g gt Basic Macro Security Mode Run Dialog Refresh Data l Code Controls XML A38 fe Student Loan deduction Plan 1 B C D 2 G H L J K L M N o B 24 Gender Requi
32. ployees then all employees will be included in the NEST calculation unless you mark on the employee screen to exclude an employee The Control panel option Prepare payslips and payroll summary report will automatically prepare a file of contributions which you can submit to NEST The payroll calculates the NEST contributions using the standard percentages for employer and employee contributions The employee contributions can be net or gross of the basic rate of tax We do not apportion contributions in the first pay period you should choose an enrolment date at the start of a pay period 34
33. red if no nno e T female J J 25 enaa number ner nno as ional Insurance Number nter S S 27 25 WorkaStt Number omni en 29 Prepare NINO 30 Department w Optional used for payroll analysis ELE Rapant 31 NVR 32 Employment start es 33 34 Employment end s 35 36 Deceased For P45 37 38 Student Loah deduction Plan 1 Plan2 39 40 Please enter the tax code details and the startin riod at Employee screen 42 Starting at Tick if Week 43 month number Tax Code Month 1 44 45 46 47 48 49 50 51 52 Most recently used information after you have run a pay period lt gt H Submission Startup Employers Sheeti_ Employees Warnings Control panel_ What is paid Payslip p11 p32 P60 Paysummary pild i Ready Z i Enter the starting month usually 1 and the tax code and tick if it is a Week1 Month basis The What is paid convention is followed once you have entered a code it is used for the starting month and all subsequent months unless you enter a new month and code underneath the first month The separate boxes for Tax code and the tick box are updated after you run the payroll they represent the most recently used information 16 National Insurance codes and Directors and Starters Selecting the NIC codes button on the employee screen leads to
34. rom one schedule to another and calculating tax and national insurance What can it do PAYE2016 allows you to enter all the necessary information for an employer s payroll it automatically calculates the tax and national insurance liability and allows you to print payslips reports P11 P32 and P60s It also prepares an employer s RTI submissions for filing online PAYE2016 uses HMRC specifications for calculating tax and national insurance As part of the accreditation process the calculations are checked and agreed to the nearest penny If you enter all sources of income correctly then the tax and national insurance will be correct Real Time Information We have developed the software to prepare Real Time Information RTI for HMRC and gained recognition for the tax year 2015 16 Opening the Payroll A new Employer After opening Excel select File then Open and choose the PAYE2016 spreadsheet This is the first screen you will see Figure 2 TEAC h E PAYE2016 03 Compatibility Mode Microsoft Excel Home Inset PageLayout Formulas Data Review View Developer Acrobat aa a Z Record Macro ge SF Properties F Map Properties Import a S Use Relative References Gel View Code Z Expansion Packs 7 Export Visual Macros v Insert Design Source co Basic A Macro Security Mode Run Dialog i Refresh Data Code Controls ML
35. ry for each period Once you have entered the salary you do not have to enter another unless it changes The month salary is used for each subsequent month If the salary changes say in month 6 enter 6 and the new salary underneath the month figures The extra boxes to the right are for employee and employer pension contributions The on strike tick box is used to restrict tax refunds while on strike Alternatively you can enter the number of hours and a rate per hour the calculated salary will show in the Salary column These details will also show on the payslip 14 Lower down the screen you find the adjustments screen f Ba CE R PAYE2016 v03 Compatibility Mode Microsoft Excel elaks Home Inset page larout Formulas Data Review View Developer Acrobat 9 X a a E Record Macro K S amp Properties Map Properties Import ZE CEZA ey Use netatie References QF view Code Z Expansion Packs 7 Export Visual Macros a Insert Design Source Basic A Macro Security Mode Run Dialog Refresh Data l Code Controls XML Al Me f Payroll for the tax year amp taxyear a a H H H 2 F G H J K L N _N an H 78 79 Adjustments to pay for Tax and National Insurance 80 Tick if for 81 Startingat Amount of Tick if Tick if starting Tick if misa this period this period cumul 82 Description month number adjustment Taxable NIC able month onl benefit taxable nicable dant
36. s Please select all the sub options by selecting the all option or ticking the boxes with the mouse If you have any doubt please contact QMS for advice Getting started What do you need to run PAYE2000 To run PAYE2000 on your PC you should have A Pentium with a minimum of 32 Mb of RAM preferably 64 Mb Windows A copy of Microsoft Excel 2000 or above A knowledge and understanding of payrolls and the end of year Return The Revenue has approved printouts from a HP LaserJet printer Installing PAYE2000 The PAYE2000 spreadsheet should be copied into any suitable folder Insert the PAYE2016 Spreadsheet CD into your CD drive Select the My Computer icon on your desktop Select the CD drive Select the file PAYE2016 xls Select Edit Copy Find and Select the suitable folder Select Edit Paste this action should cause the PAYE2016 spreadsheet to be copied from the installation CD to your PC Installing the database Warning Do not install a fresh empty database if you are bringing forward information from last year Insert the PAYE2000 disk into your a drive Copy the file PAYEDATA from the CD to the C drive in a similar manner to that used for the PAYE2016 spreadsheet You can choose the C directory if you choose another directory Update your master Spreadsheet with the name of the directory see below Changing the master spreadsheet You only need to change the master spreadsheet i
37. s is an HMRC restriction So if there no payments in January then after aTh February you can submit a NIL return for January You can also look forward if you know you have no FPS in the following month s you can select the months for a nil interim EPS Keeping track of submissions PAYE2016 automatically keeps track of internet submissions and responses the replies to earlier submissions in the database Each time you prepare a return the employer s record in the database is updated After the end of year return is processed by HMRC please return to the employer screen and select the button to record the success in the database You can review submissions and responses by clicking the Summarise responses button on the employer screen 29 Ad hoc requests NINO Verification Request NVR You can request confirmation of an employee NINO or provide details of an employee and obtain the NINO Go to the employee screen and see the following d 97 OAS S N PAYE2016 v03 Compatibility Mode Microsoft Excel iN tela Home Insert Pagelayout Formulas Data Review View Developer Acrobat 9 6 X a ZI Record Macro Se eZ EF Properties S F Map Properties Import E Use Relative References QF View Code Z Expansion Packs Export Visual Macros Insert Design Source Basic Macro Security Mode 3 Run Dia
38. sual Macros Insert Design Basic A Macro Security Mode Run Dialog Code Controls AE Payroll for the tax year amp taxyear a C D E F H 1 J K L N N o P 3 Employer Employer screen Go to Wamings 4 5 Please use this screen for employees 6 7 Open employee from Save employee to Remove employee Retrieve employee Print employee Remove employee from B database database details from screens from last year information database 9 10 Name and address of employee Select the button to move to 11 Title Go to What is paid Go to SSP Remove all old employee 12 Check forenames Forenames data 2 years ago from 13 Check surname Surname Go to Tax codes Go to SMP database 14 Address Please enter the address here 18 Go to NIC codes Go to SPP i Check Go to Control panel Go to ShPP ASPP u Png Goto P11 Go to SAP 20 Postcode Al Go to P60 Eamings Orders 22 Date of birth DOB required for RTI ____ DOB requ if no NINO 23 M e Go to P35 PID 24 Gender Required if no nno P fomai 25 National insurance number enter no erae 5 ional Insurance Number nter this employee 28 Works Staff Number C7 mnnc 29 Prepare NINO anaa LH innalana cree teers Verification Request R 1 E H Submission Startup Employers Sheeti_ Employees Warnings Control panel What is paid Payslip p11 p32 P60 Paysummary piid Ji Ready Please remember to select the Remove details button before setting up a new employee You must complete and s
39. ut Formulas Data Review View Devei per Acrobat Eg a Z Record Macro V A EF Properties E S Map Projerties import 2 H Use Relative References Ke QA View Code Z Expansign Packs 7 Export Visual Macros Insert Design Source Basic Macro Security ode f Run Dialog 9 RefreshfData Code Controls ML x f _Payroll for the tax year amp taxyear S C D E F H 1 J K L M N o P Q Back to employee screen Please use this screen to control payroll processing Go to Wamings Name and address of employee Title 9 Forenames 10 Surname Go to What is paid 12 Which month do you want to work out pay 13 Start End 14 J 0101119940 00 01 1900 Error too tow 15 16 Please select an option Work out pay for this pgriod Remove p11 data for this period 17 only only 18 19 Work out all pay up tp and Remove all p11 data up to and 2 including this pera including this period 23 Prepare payslips Wd the Please select the period for the payroll 24 payroll summary report for ali only employees with this period will be processed 25 employees monthly X Submit Full Payment Summary FPS Your RTI submission has been accepted 30 Reason for late submission rarely used R1 E H Employers Sheet _ Employees Warnings Control panel WhatNg paid Paysip p11 p32 P60 Paysummary 6110 plid b P35 page Ready This option prep
40. y using the previous 8 weeks employment record There may be situations where the average cannot be calculated for example where there is an incomplete history or some of the payments were in an earlier year Remember that average earnings can affect the amount of SMP in the first 6 and subsequent weeks You may need to calculate average pay separately and enter the average figure on the appropriate screen SMP SAP SPP If you are backdating a pay rise which affects the calculation of average earnings don t forget to re calculate the average This does not overwrite SMP which has already been paid However SMP still to be paid and recovered will be increased to take account of any past underpayment Employer s departments You have the option to specify departments Please add a department to the list on the employer s screen When you add an employee you can select a department The payroll will be summarised by department enabling you to prepare the appropriate account entries for book keeping purposes If you don t use departments the payroll report will show an overall total Pension contributions The payroll allows you to make straightforward pension contributions either as a lump sum or on a percentage basis These can be ticked as tax deductible or not More complicated scenarios such as when an employee makes standard contributions to a pension scheme and also makes Additional Voluntary Contributions are also possible In t
Download Pdf Manuals
Related Search