Home

RTI - User Guide - Advanced Connect

1. Title Mr E Contact Code AB Forename lan Surname brown Email a browntisyzemail co pa Telephone Mo Late Reason Late Reason None Report Options 27 7 gt N gt gt Ne Sari Doc Version 2 3 Page 67 OP v8 14 3 User Guide RTI User Guide 10 1 1 RTI File Tab File Details 7 Real Time Information Extract ls leas ATI File Agent Details Payments Declarations Scheme Ceased Employees File Details ATI Class MINO Venfication Request Ma Live Test in Live File Name MVWA_PSE 85 2017404 LIVE 2017402251251 46 xml gt RTI Class From the dropdown list select NINO Verification Request as displayed above gt File Type An optional Test in Live file can be created and sent to HMRC If this option is used it is imperative that a separate Live file is also created and sent Live or TIL will be an integral part of the file name gt File Name The filename is a read only field and is generated based on the RTI class selected the PAYE Reference payroll number the tax year and month whether the file being submitted is test or live and a date and time stamp In the above example the file name is NVR_PAE2 85 201404 LIVE_20140225125148 xml If Test in Live was selected the filename would be NVR_PAE2_85_ 201404 TIL_20140225125148 xml PAYE Reference Payroll Section HAYE Reference Payro
2. Doc Version 2 3 Page 84 OP v8 14 3 User Guide y RTI User Guide Advanced Busness Solutions 12 3 3 RTI EYU Exception Report Doc Version 2 3 If there are any validation errors the EYU extract will NOT be created An EYU Exception report as shown below will be output detailing the reasons for failure r 3 EYU Exception_Rpt txt Notepad File Edit Format View Help Report PY A version 1 0 RTI EYU Exception Report Page 1 a Run Date MON JUL 9 2012 11 49 Tax Year 2012 13 Report options Format RTI EYU Exception Report Operator ID System PAYE Ref G7070 Time DATE Requested 11 49 09 07 2012 HMRC Office 491 Time DATE Printed 11 49 09 07 2012 T 473PQ11214673 THE FILE HAS NOT BEEN CREATED DUE TO THE FOLLOWING FAILED VALIDATION Payroll 1 Monthly 25 Monthly 00000001 1234 Birth Date The Date of Birth must be today or earlier 00000033 5014 NI Number Invalid NI Number Page 85 OP v8 14 3 User Guide RTI User Guide 3 13 RTI Gateway Submission EYU 13 1 Submitting the EYU After the EYU XML file has been created it must be submitted to HMRC This is done using the RTI Gateway Submission program An EYU for the previous tax year can only be submitted on or after the 20 April of the current tax year Select RTI Gateway Submission from the menu The following screen will be displayed 42 RTI Gateway Submission Messages Submission Fies
3. Page 21 OP v8 14 3 User Guide 2 RTI User Guide Advanced Date FPS Submitted Date FPS Submitted 04 09 2012 When a Full Payment Submission is successfully submitted this field will automatically be populated with the date on which the FPS XML file was submitted 5 1 4 Tax NI Tab 2 Employee Masterfile Maintenance 9 R Hawkins Personal 1 Personal 2 ATI Tax NI Pension SE Pay Details Employment Analysis Analysis E Elements Stat Accums Other Accums Lele 83 National Insurance NI Number 4MO345714 Overseas National Awaiting NI Number NI Code 4 Age Verified Effective From gt NI Adjustment Created Tax Code Type Normal y OT 01 OT W14M1 Pension Pension No Pension Scheme gt ECON E3123456F E E1234567F SCON 51234567N E 51234567N Miscellaneous OSP Scheme gt OMP Scheme 7 Work Pattern y Default T S required L P11D L Timelink Director Expat C Nor ndividual rr Back l Next y Apply Cancel The following fields are included on the FPS Extract Doc Version 2 3 gt NI Number When the NI Number is added for the first time or subsequently modified the user is asked to re enter the NI Number as follows MI Number Confirmation Re enter HI Humber If the re entered NI Number does not match the NI Number already entered the following error message will be displayed Page 22 OP v8 14 3 User Gui
4. Doc Version 2 3 Page 47 OP v8 14 3 User Guide RTI User Guide en Advanced Busness Solutions 7 2 4 RTI FPS Gateway Submission HMRC Response An HMRC Response report in format returned by HMRC showing the FPS XML file was rejected will also be output to Print Manager as shown below Report py23SrepXML Version 1 00 RTI FPS Gateway Submission HMRC Response Run Date WED JUN 6 2012 14 06 13 Report Options Correlation ID 7E87F834E7904E918FEGEDDIADEC80S5D Operator ID Sender ID Isvis Time DATE Requested 14 06 06 06 2012 PAYE Reference 67070 Time DATE Printed 14 06 06 06 2012 Filename X oprtitestOE101C rtisubmissions FPS FPS 01 _201203_LIVE_20120606113948 xml lt xml version 1 0 2 gt lt GovTalkMessage xmlns gti http www govtalk gov uk CM envelope xmlns erp http w govtalk gov uk CM errorresponse xmins ht tp www govtalk gov uk CM envelope gt lt EnvelopeVersion gt 2 0 lt EnvelopeVersion gt lt Header gt lt MessageDetails gt lt Class gt HMRC PAYE RTI FPS lt Class gt lt Qualifier gt error lt Qualifier gt lt Function gt submit lt Function gt lt TransactionID gt lt CorrelationID gt 7E87F834E7904E918 FEGEDDIADEC805D lt CorrelationID gt lt ResponseEndPoint PolliInterval 10 gt https secure dev gateway gov uk poll lt ResponseEndPoint gt lt Transformation gt XMI lt Transformation gt lt GatewayTimestamp gt 2012 04 16T13 06 07 497 lt GatewayTimestamp gt lt M
5. Payroll 1 Advanced Monthly Processing Mode Normal Current Period 9 2 012 Next Period E T Clear down audit records No employees paid this period Next Payslip Date 26 09 2012 gt Next BACS Processing Date 47 05 2012 gt Next Period End Date 30 03 2012 gt A warning message is displayed when the No employees paid this period field is selected as shown below Page 92 OP v8 14 3 User Guide RTI User Guide e Advanced Busness Solutions Warning i Only tick if no employees paid and no Full Payment Submission is submitted When the Period End has been processed successfully the Date FPS Submitted field will be cleared from all employee records ready for processing the next pay period Note an employee s employment status will remains as New until they have received their first payment and an FPS has been submitted to HMRC This is due to HMRC requesting that they are only informed about new employees at the point when the first payment is made 14 6 1 Period End Employee Validation Report As RTI is reliant on valid data being sent to HMRC every period it is important that employee data in OpenPeople is valid To assist with this the Employee Validation Report is automatically output during the Period End routine as shown below A Report Viewer gcspool 18051451 prt o O leas Report gt PY80 C Version 1 02 Employee Validation Report A
6. Statutory payment recovery It is also used to inform HMRC that no employees have been paid in the current tax month This file must be created and submitted to HMRC once per tax month per PAYE Reference It is run after the Period End has been processed for each payroll within the PAYE Reference Doc Version 2 3 Page 10 OP v8 14 3 User Guide 2 RTI User Guide Doc Version 2 3 NI Number Verification Request this is an ad hoc extract used to verify or obtain NI Numbers for new or existing employees HMRC will return information via the PAYE Online facility Earlier Year Update this allows any year to date totals Submitted in the final FPS for the previous tax year to be corrected It only applies to years after RTI information has been sent No EYU submission can be made before the 2012 13 tax year Corrections should be made after 19 April relating to previous year Page 11 OP v8 14 3 User Guide RTI User Guide 3 RTI System Record 3 1 RTI System Parameter Maintenance Click on the RTI System Parameter Maintenance program to set the appropriate RTI processing parameters 22 RTI System Parameter Maintenance Le JE leas Parameter Properties ATI System Parameter Maintenance Enable Statutory Recover Comp Entry E Std 18 BACS File C Opt Out of Run FPS after BACS Extract F Disable NI Number Confirmation Enable Submit File 20 Contact Code Table Enable Correlation ID Generat
7. to generate the FPS file The file can be created from the RTI File tab or from the Agent Details tab Doc Version 2 3 Page 34 OP v8 14 3 User Guide RTI User Guide 6 1 3 Creating the FPS Extract for Individual Employees The Full Payment Submission Individual option is available for the submission of an FPS for an individual employee or employees A Full Payment Submission Individual is typically used for e Reporting adjustments following submission of main FPS e g reporting over or under payments that have been reported in previous FPS in the current period e Reporting employees who are to be paid before the main payroll run for example a leaver being paid early If an adjustment is made after the main payment run then the new payment date should be entered on the Individual Employees tab against selected employee Note the Individual FPS file created will show full this period values for the employee i e not just the adjusted figures Creating a file From the RTI Class menu the Full Payment Submission Individual should be selected 59 Real Time Information Extract lo RTI File Agent Details Payments Declarations Scheme Ceased Employees File Details ATI Class Live Test in Live File Name FPSINDY 67070 11 207301 LIVE 2073092909321 5 xml The process for creating the file is the same as for the full FPS as described previously
8. HMAC Office 423 BAC Sender ID 154156 CMS DEO pel HAYE Payment References Payment Ref 4 3PU11214b 3 Small Employer Helier BACS No 23423 Bacs Processing Date Dest Bank Sort 01 00 51 gt HAT WEST BANK PLE Bank Account 39993939 BACUP Source Bank Sort 01 00 37 e HAT WEST BANK PLE Source Bank dec 11111111 TRAFFORD PARE THIRD AVENUE Source Acc Holder Monthly Ltd Source B Soc Ret HAYE Pension Reference ECON E3123456F e El 23456F SECON 51234567H Ba 51234567N Apply Help The Source Bank Sort Code Source Bank Account Number and Source Acc Holder are mandatory fields The Source B Soc Ref is optional Doc Version 2 3 Page 26 OP v8 14 3 User Guide RTI User Guide y 6 Full Payment Submission FPS The FPS contains details about an employee s pay and deductions including tax and NI plus starter and leaver details An FPS must be created and submitted for every payroll each pay period The FPS will include details of all employees paid in the current pay period and also employees not paid in the current period but who have the Irregular Payment Indicator set to yes Note the FPS replaces the In Year Movements processing i e P45s and P45s will no longer be submitted to HMRC If on the RTI System Parameter Maintenance program the Std18 BACS File option is ticked and Opt Out of Run FPS after BACS Extract is NOT ticked the RTI Extract program will automatically open as soon as
9. If employees to be included on the individual FPS are paid by BACS a BACS Extract Should be run for the individual employee s in the normal way There is an option on the BACS Extract program to select individual employees from the drop down menu on the Print Order field select Individual Employees and this will enable the Employees tab The Employees tab will list all employees to whom the user has access from where appropriate employees should be selected If the relevant RTI system parameter option is enabled see section 3 1 the RTI Extract program will open up automatically as soon as the BACS file has been created The RTI Class of Full Payment Submission Individual will have been pre selected The file name is read only and will have INDV inserted after FPS to identify it as an Individual FPS file Doc Version 2 3 Page 35 OP v8 14 3 User Guide RTI User Guide e Advanced The Employees tab will be enabled and the employee s that have previously been processed by the BACS Extract will be automatically selected 75 Real Time Information Extract ATI File Agent Details Payments Declarations Scheme Ceased Employees Ka Number Name Status Late Reason Paymt Date Selected A 2 Ledger Mr H Live 3 Cruise Mr T Live A Gyllenhaal Mr Live 7 Pitt Mir B Live 10 Depp Mr J Live 12 Johansson Miss 5 Live 13 Portman Mrs M Leaving this Pe 14 Carter Miss HE Live 16 Aniston Ms J Live 17 Bery M
10. c oplive rti_eyu_spool RTI_EYU_G7070_LIVE_20121004120159 xml EarlierYearupdate Employee EmployeeDetai1s Birthbate The Date of Birth must be today or earlier Note the XML response file received from HMRC can be viewed in Print Manager 13 2 4 RTI EYU Gateway Submission HMRC Response An HMRC Response report showing the EYU XML file was rejected will also be output to Print Manager Doc Version 2 3 Page 88 OP v8 14 3 User Guide RTI User Guide y 14 Where RTI sits in the Normal Processing Cycle 14 1 Processing Overview It is important that processing is undertaken in the correct order OpenPeople has in built checks to ensure that specific routines are processed in sequence The sequence can be summarised as follows Every pay period for each payroll gt Period End gt Normal period input and maintenance of employee records gt PAE Assessment if PAE staging date has been reached gt Payroll Calculation gt Control Totals gt BACS Extract must be processed before FPS Extract where employees paid by BACS gt RTI Creation of FPS Extract gt RTI Gateway Submission Submission of FPS Extract gt Costing and Nominal if applicable gt Period Reports gt Period End Every tax month for each PAYE Reference gt RTI Creation of EPS Extract every tax month after ALL Period Ends have been processed for each payroll within the PAYE Reference that the EPS is being created f
11. 10 3 RTI System RECOlO ssiosicinninanscinsinacida incaico 12 3 1 RTI System Parameter Maintenance cs ee e ccc ccc e K e K KKK 12 4 Contact AGent Detail mass 14 Al Go gas ce Bo gt ae robe ee E er ee ee ee eee eee ee ee ee eee 14 c E A e e o o A OE 15 gt RII Data CGMS cian 16 Jed EMPOYEG RTI PISOS cicetecetnaedaceaiestdonnetautasiasbidecncrsnmeesesattecnedsucetinosteentacetateedehidenusetanten 16 Oe ee Personal E TAD sacan icon E AEE E E 16 lt e 4 Terre Wa T E E T E A T E E E E E E T seis 17 A RU E AAA e on O E seaeeseeoadace 18 A e UE E eaumace socter es eonte lade cenoenens 22 ME AAA o Ag PU oa 24 5 2 Additional Statutory Paternity Pay Data o oocccccccccccccncccccnnnnnnnnnnnnnnnn nr r rra rr 25 A A o O cae eusanioasnaaeeeeemsecdannsd 25 e e AS PP AO aUe rra dis afecte 25 E ETIE ceccen a a E cacent A 26 S3 Company Bank DELAS io 26 6 Full Payment Submission FPS css sss sss sss sss ess essen sss nnan rnnnnnnnnnnnnnnna 27 6 1 Creating ie FPS a Le ee derey isani o OO EA 28 SN on e oo UE OE EE 29 AE e e AAA e A rn 34 6 1 3 Creating the FPS Extract for Individual EMplOyeeS cccceeeeeee eee eeeeeeeeneeees 35 Bice Bl COMES SO unenidesbrulnloloeircioine pido leida ata pepe ccloiode 38 LTP REPO O io En e EEE neeeu era eet E 38 6 22 RU FPS NI EXC REDO Eseccasins ninia dis artes uta decerona po dente eps 38 6 2 2 RTI FPS Employee Payments Extract Report eee 39 6 2 3 RTI FPS Employee YTDs Extract Repo
12. 7 Full Payment Submission IR Je sumak Files 5 Employer Payment Summary i l NINO Verification Request A Earlier Year Update Data Request Select the Earlier Year Update radio button Click on the Files button to browse to the EYU XML file to be submitted This will automatically open the appropriate EYU folder Select the relevant EYU XML file and click on the Submit button The program will start submitting the date to the Government Gateway If user tries to submit EYU for a previous tax year before the 20 of April of the current tax year E g EYU 2012 13 submitted before 20 April 2013 an error message will be displayed and no submission will be allowed EYU for tax year lt yyyy gt can only be submitted after 20 April lt yyyy 1 gt Doc Version 2 3 Page 86 OP v8 14 3 User Guide RTI User Guide 9 Advanced 13 1 1 Sent Folder The successfully submitted EYU XML file will automatically be moved into a Sent folder rtisubmissions eyu sent If the Sent folder does not exist the system will create one 4 Je rtisubmissions y de eas gt de eps 4 1 evu de sent 13 1 2 Exiting During Submission See 7 3 Doc Version 2 3 Page 87 OP v8 14 3 User Guide RTI User Guide Busness Solutions H Advanced 13 2 EYU Submission Reports When the EYU XML file is submitted reports as defined in this section are output to the Print Manager 13 2 1 RTI EYU Gateway Submission Acceptance
13. FOC ee ee nore Mate ee ee ere err eet mee eet nce 71 Ll 2 NV RSUDMISSION Re DOI Serisi ane tan cestciees 72 11 2 1 RTI NVR Gateway Submission Acceptance Report cce e essen eee eeeeees 72 11 2 2 RTI NVR Gateway Submission HMRC Re SPONSE cccc cece e e e eK 72 11 2 3 RTI NVR Gateway Submission Rejection Report occcccccccccnnnncncnccnnnnacccannnn 73 11 2 4 RTI NVR Gateway Submission HMRC Re SPONSE ccc cece ee e e eK 73 Le EXEN DUNO SUDIMISSION A dees perc aaee tenants 73 12 Earlier Year Update Extract EYU sssssnnnnunnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn 74 12 Era tino aM EY UB Aten rotar bi a A AENEA 74 12 1 1 EYU Amendments Screen FUnctIOnS sse ee ee eee ee 74 12 2 Creating the EVEX ACE cicesmicculacth tdnthataueneemenindaa aca 82 12 2 L Pile arar tai sway ial eet daa 83 Doc Version 2 3 OP v8 14 3 User Guide RTI User Guide 1222 AO CIE Detalls TAD aimara telas 83 BD Ove CREDO a AN 84 12 3 1 RTI EYU Amendments Report TTT 84 1223 2 RI S EYU Nana Valles Report ii 84 12 33 RITES EYU Exception Repo Essalud 85 13 RTI Gateway Submission EYU ss sss sss sss essen esen sannan nnan nanna Renee 86 Ll SUBAN O E 9 YU aaa aa 86 Lil SONES A 87 13 12 Exiting DUFING SUDMISSION ase E 87 1322 E YUsSUDMISSION Repo Stata a 88 13 2 1 RTI EYU Gateway Submission Acceptance Report cce 88 13 2 2 RTI EYU Gateway Submission HMRC Response ee e e e e e e eK
14. Guide 12 Earlier Year Update Extract EYU An EYU return is submitted to HMRC to report changes amendments to tax NI and other statutory fields for previous tax years An EYU can only be submitted for amendments associated with the previous tax year on or after the 20 April 12 1 Creating an EYU Batch An EYU Batch Is created using the EYU Amendments program py266 The amendments can either be manually entered or imported via a file The batch is then submitted using the EYU option on the RTI Extract program 12 1 1 EYU Amendments Screen Functions EYU Batch tab 59 EYU Amendments EYU Batch Employee EYU Batch Tax Year 2013 Payroll Monthly Demo Payroll EYU Batch EYU_01_2075_ 005 EYU Import Create and save import template Save Template Filename EYU Amendment of Elem amp ccum EYU Batch a gt Tax Year Tax Year drop down box will display the last 6 tax years The user can choose which tax year they wish to submit an EYU for but only years where RTI has been processed can be selected gt Payroll Read only displays name of current payroll Doc Version 2 3 Page 74 OP v8 14 3 User Guide Doc Version 2 3 E RTI User Guide gt EYU Batch Read only auto populates as follows when Tax Year is selected EYU_ lt current_payroll number gt _ lt tax_year gt _ lt sequence number gt Sequence number starts at 001 if there are no previous batches for that tax yea
15. Mr H Ledger NS124578D 15 Last Knight Street 15 10 1968 M No Gotham City AB2 2BA 00000003 Mr T Cruise NS569569D 10 Top Gun Road 10 10 1958 M 657893231 Penelope Cruz No Aberdeen AB3 3BA 00000004 Mr C Bale NS265214D 1 Hidden Cave 12 12 1945 M Yes Gotham City GCL 1CG 00000005 Mr J Gyllenhaal NS759658D 15 Dream Street 03 12 1985 M No Hairy Scarey AB4 4BA Doc Version 2 3 Page 41 OP v8 14 3 User Guide Adva nced Busness Solutions 6 2 6 RTI FPS Exception Report RTI User Guide If there are any validation errors the FPS extract will NOT be created An FPS Exception report as shown below will be output detailing the reasons for failure Corrections should be made and the file recreated A Report Viewer gcspool 25157963 prt Report gt PYSS A Version 1 0 RTI FPS Exception Report Run Date TUE MAY 1 2012 16 06 Operator ID dm Format gt RTI FPS Exception Report Time Date Printed PAYE Ref gt 67070 Tax Year Period HMRC Office 491 Payment Date 20 Ref gt 473PQ11214673 Employee Field Description Reason 00000001 5013 Tax Code Invalid Tax Code 00000002 5013 Tax Code Invalid Tax Code 00000017 5013 Tax Code Invalid Tax Code Time Date Requested 01 05 2012 z 01 05 2012 2012 02 31 05 2012 4 mW 6 2 7 RTI FPS Excluded Employees Report If there are any employees who have been excluded from the Full FPS they will be reported on the FPS Excl
16. P110 and P11D 6 are due Are you a Service Company and have operated the Intermedianes legislation chapter 8 of part 2 of TERA sometimes known as ASS Contirmation Please tick to confirm that each of the declarations above have been considered gt Questions and Declarations The questions and declarations should be ticked if applicable Confirmation If no selections are made in the Questions and Declarations section the Confirmation section must still be selected to confirm that each have been considered carefully Page 61 OP v8 14 3 User Guide RTI User Guide nced Busness Solutions r Adva L H 8 2 EPS Reports When the EPS XML file is created several reports are output to Print Manager as detailed in the following sections 8 2 1 EPS Extract Report Doc Version 2 3 When the No employees paid this month check box is left unticked on the Payments tab and the EPS XML file is successfully created the EPS Extract report will be created in Print Manager as shown below PYSS A Version 1 34 TUE APR 1 2014 15 06 Report RTI EPS Extract Report Run Date Operator ID pay Time Date Requested 01 04 2014 15 06 Format gt RTI EPS Extract Report Time Date Printed z 01 04 2014 15 06 PAYE Ret z 67070 Tax Year z 2014 HMRC Office 452 Tax Month B2 AO Ref gt 473PQ11214673 Payroll File name C AdvancedOP814 oplive rtisubmissions EPS EPS G7070 2
17. Page Run Date FRI MAR 30 2012 14 17 Payroll a E Monthly Period 1 30 04 2012 Operator ID dm Time Date Requested 14 17 30 03 2012 Format Time Date Printed z 14 17 30 03 2012 NO RECORDS FOUND THAT PRODUCED AN ERROR MESSAGE BECAUSE OF DUPLICATE OR INVALID EMPLOYEE PAYROLL NOTE OR SID NUMBERS Report gt PY80 C Version 1 02 Employee Validation Report Page Run Date FRI MAR 30 2012 14 17 Payroll 1 Monthly Period 1 30 04 2012 Failure Messages IT IS IMPORTANT THAT ALL FAILURE MESSAGES ARE CORRECTED Employee Surname Company Name Field Description Current Value Failure Message 3 Cruise Monthly 5126 ECON E3324152E ECON entry not required Warning Messages CORRECT EACH WARNING MESSAGE AS NECESSARY Employee Surname Company Name Field Description Current Value Warning Message 1 Smith Monthly 5014 Nat Ins No NS235689D Duplicate NI Number 2 Ledger Monthly 5014 Nat Ins No NS124578D Duplicate NI Number 3 Cruise Monthly 5014 Nat Ins No NS569569D Duplicate NI Number 4 Bale Monthly 5014 Nat Ins No NS265214D Duplicate NI Number 5 Gyllenheel Monthly 5014 Nat Ins No NS759658D Duplicate NI Number Connory Monthly 5014 Nat Ins No NS362563D Duplicate NI Number 7 Pitt Monthly 5014 Nat Ins No NS541253D Duplicate NI Number 8 Butler Monthly 5014 Nat Ins No NS541247D Duplicate NI Number 9 Dicaprio Monthly 5014 Nat Ins No NS695327D Duplicate NI Number 9 Dicaprio Monthly 5015 NI Code J Certificate of Deferment required 10 Depp Monthly 501
18. Print program from where the relevant P45s can be printed 2 P45 Print Report Print Employees Print Parameters Format P45 Online Mail Merge Print Order Employee Template File File Output File File Open Output File To View Selection Parameters Employee From To 99999999 If you do not wish to print P45s at this stage simply exit out of the program Doc Version 2 3 Page 45 OP v8 14 3 User Guide RTI User Guide Advanced 7 1 1 Sent Folder The successfully submitted FPS XML file will automatically be moved into a Sent folder rtisubmissions fps sent If the Sent folder does not exist the system will create one 4 Je rtisubmissions gt Ji eas de eps di eyu gt Le firstfps a l fps di sent 7 2 FPS Submission Reports When the FPS XML file is submitted reports as defined in this section will be output to Print Manager 7 2 1 RTI FPS Gateway Submission Acceptance Report When the FPS XML file is successfully submitted an FPS Gateway Submission Acceptance report will be output to Print Manager as shown below Report Viewer gcspool 18058495 prt Report gt py235rep Version 1 00 RTI FPS Gateway Submission Acceptance Report Run Date FRI MAR 30 2012 16 14 55 Report Options Correlation ID BD62D4E2A7C84B9B99B89556177DE1DF Operator ID Sender ID gt ISV156 Time DATE Requested 16 14 30 03 2012 PAYE Reference G7070 Time DATE Printed z 16 14 30 03
19. Ref G7070 Time DATE Requested 11 49 09 07 2012 HMRC Office 491 Time DATE Printed 11 49 09 07 2012 AO Ref 473PQ11214673 File name P oplive RTISubmissions EYU EYU_01_2012_LIVE_20120907114959 xml Empl No Name Taxable Tax Paid s Loan SSP SMP OSPP SAP ASPP 00000001 Mr John steel gt gt gt gt gt gt gt gt 9 99 gt gt gt gt gt gt gt gt gt 9 99 gt gt gt gt 9 00 gt gt gt gt 9 99 gt gt gt gt gt 9 99 gt gt gt gt gt 9 99 gt gt gt gt gt 9 99 gt gt gt gt gt 9 99 00000005 Mrs Mary Rushden 0 00 0 00 0 00 34 34 0 00 0 00 0 00 0 00 12 3 2 RTI EYU NI and Values Report This report shows the NI Category Amendments against each employee in the EYU XML file S 7 EYU NI and Values txt Notepad File Edit Format View Help Report PY A Version 1 0 RTI EYU Submission NI and values Page 1 a Run Date MON JUL 9 2012 11 4 Tax Year 2012 13 Report Options Format RTI EYU Submission NI and Values Operator ID System PAYE Ref G7070 Time DATE Requested 11 49 09 07 2012 HMRC Office 491 Time DATE Printed 11 49 09 07 2012 473PQ11214673 P oplive RTISubmissions EYU EYU_G7070_LIVE_20120907114959 xml ATLEL LELtoPT PTTOUAP UAPTOUEL Mr John steel gt gt gt 9 00 gt gt gt 9 99 gt gt gt gt 9 99 gt gt gt gt 9 99 gt gt gt gt gt gt gt gt 9 99 gt gt gt gt gt gt gt gt 9 99 Mrs Mary Rushden A 0 00 0 00 0 00 0 00 0 00 33 15 Yes
20. Report When the EYU XML file is successfully submitted an EYU Gateway Submission Acceptance report will be output to Print Manager as shown below F ewe 3 EYU_AcceptanceRpt txt Notepad t File Edit Format View Help Report py999rep a version 1 00 PAYE Reference G7070 Run Date MON JUL 9 2012 14 33 RTI EYU Acceptance Report Report Options Correlation ID B9CDDFSDA26E45B2BE15E0788C9053BC Operator ID System Sender ID ISV156 Time DATE Requested 14 33 09 07 2012 Time DATE Printed 14 33 09 07 2012 Filename c oplive rti_eyu_spool RTI_EYU_G7070_LIVE_20120704120159 xml ERERERERERRR This RTI EYU file has been successfully sent to HMRC NOTE To check the progress of this submission run the RTI Gateway Review 13 2 2 RTI EYU Gateway Submission HMRC Response An HMRC Response report showing the EYU XML file was successfully accepted will be output to Print Manager 13 2 3 RTI EYU Gateway Submission Rejection Report E EYU_RejectionRpt txt Notepad oje File Edit Format View Help Report py999rep a version S PAYE Reference G7070 Run Date MON JUL 9 2012 14 33 RTI EYU Rejection Report Report Options Correlation ID B9CDDFSDA26E45B2BE15E0788C9053BC Operator ID System Sender ID 1ISV156 Time DATE Requested 14 33 09 07 2012 Time DATE Printed 14 33 09 07 2012 Filename
21. been submitted within an FPS an additional FPS needs to be submitted with corrected YTD figures as at 5 April for the previous tax year If errors are discovered on or after 20 April in the following tax year an Earlier Year Update needs to be submitted EYU can be used to correct data for 2012 13 and later tax years EYU can only be used for tax years that are operating PAYE RTI Doc Version 2 3 Page 94 OP v8 14 3 User Guide RTI User Guide E Advanced 15 Appendix A 15 1 RTI Statutory Elements The statutory RTI elements that will be included in the FPS are numbered within the range 1070 1081 These are automatically created by the system The following table lists the RTI element number element description and a detailed description Element Element Detailed Number Description Description 1070 Net Payments Value of payments not subject to tax or NICs in pay period 1071 Net Deducts Value of deductions from Net Pay in pay period after statutory deductions other than pension payments If an employee is paid into 2 bank accounts the smaller of these payments is added to this element Similarly if an employee is paid by cash or cheque the full net payment is added here 1072 Pay Post T N Pay after statutory deductions 1073 Taxable Bens Value of benefits taxed via the payroll in pay period 1076 Std Pen Cont Value of employee pension contributions paid under the Net Pay arrangements in pay period 1077 NI Non T
22. contact codes have been defined then details should be manually entered as follows gt Title The title of the person who is primary point of contact for RTI purposes should be entered here The Title field is a mandatory field and is bold to signify this The maximum field length is 4 characters Forename The forename of the person who is primary point of contact for RTI purposes should be entered here The Forename field is a mandatory field and is bold to signify this The maximum field length is 35 characters Surname The surname of the person who is primary point of contact for RTI purposes Should be entered here The Surname field is a mandatory field and is bold to signify this The maximum field length is 35 characters Email The user can enter the email address of the primary point of contact for RTI purposes The Email field is an optional field Telephone Number The user can enter the telephone number of the primary point of contact for RTI purposes The Telephone Number field is an optional field The maximum field length is 35 characters Excluded Employees RTI File Agent Detail Payments Declarations Scheme Ceased Excluded Employees gt Excluded Employees If employee s are to be excluded from the full FPS e g because it is known when the main FPS is being created that an employee s is to receive their payment late then use the Excluded Employees tab to select the
23. employee s that are to be excluded All employees other than those selected here will be included on the main FPS The employees excluded can then be included on a later FPS by selecting the Individual FPS option at run time Page 32 OP v8 14 3 User Guide Doc Version 2 3 z RTI User Guide Advanced Report Options Report Options Output bo Print ka gt Output To The Output to field defaults to Print but also gives the user the option to output the report to File If Output to File is selected the printer will automatically default to Spreadsheet Please note that if this option is selected it is recommended that the user saves the spreadsheet for future reference Creating the File Click Create File to generate the FPS file Report Options Output to Print Submit File Create File Exit Help Note if the Enable Submit File is ticked against the RTI System Record see section 3 1 then on creation of the FPS file the Submit File button will be enabled This will automatically open the RTI Gateway Submission program with file details pre populated Alternatively the Exit button can be used and the FPS file submitted in the usual way at a later time Page 33 OP v8 14 3 User Guide Z RTI User Guide 6 1 2 Agent Details Tab If any option other than Employer is selected on the RTI File tab the Agent Details tab is enabl
24. ez ATAPQUIZIA ET Fayroll t 1 r E TE Lode opt EDE L DER CE eubeieeicae Fee TPS FRNT Paro GL 301404 TIL 2014962412185394 ssi Late Aaa Ron Payee DETE 2200007 Five Ke B H AN ppaonooio Depp Hr J H 2105 1d Doc Version 2 3 Page 43 OP v8 14 3 User Guide y RTI User Guide 7 RTI Gateway Submission FPS 7 1 Submitting the FPS After the FPS XML file has been created it must be submitted to HMRC This is done using the RTI Gateway Submission program The FPS file can be sent either directly from the RTI Extract program or by selecting RTI Gateway Submission from the menu If the Enable Submit File is ticked against the RTI System Record see section 3 1 then on creation of the FPS file the Submit File button will become enabled as shown below This will automatically open the RTI Gateway Submission program with file details pre populated Report Options Whether the RTI Gateway Submission program is opened via the menu or using the Submit File on the RTI Extract program the following screen will be displayed 22 RTI Gateway Submission Messages Submission it C MAdvanced oplive tisubmissions FPS FPS_G O070_11_201 Fi Full Payment Submission File To Submit E ancedsoplivesrhsubmissions 2 ii BE e Pe Ea NINO Verification Request Earlier Year Update Data Request pas La Est Hep If the Submit File option was used on the RTI Extract program then the Full Pay
25. here as shown below gt SMP Recovered This field is automatically populated with the total Statutory Maternity Pay value to be recovered for all payrolls included in the PAYE Reference The value shown is the year to date value OSPP Recovered This field is automatically populated with the total Ordinary Statutory Paternity Pay value to be recovered for all payrolls included in the PAYE Reference The value shown is the year to date value SAP Recovered This field is automatically populated with the total Statutory Adoption Pay value to be recovered for all payrolls included in the PAYE Reference The value shown is the year to date value ASPP Recovered This field is automatically populated with the total Additional Statutory Paternity Pay value to be recovered for all payrolls included in the PAYE Reference The value shown is the year to date value Page 56 OP v8 14 3 User Guide Doc Version 2 3 2 RTI User Guide SMP Compensation This field is automatically populated with the total Statutory Maternity Pay compensation value for all payrolls included in the PAYE Reference The value shown is the year to date value OSPP Compensation This field is automatically populated with the total Ordinary Statutory Paternity Pay compensation value for all payrolls included in the PAYE Reference The value shown is the year to date value SAP Compensation This field is automatically populated with the total Sta
26. one of the following new started declarations must be selected o This is my first job since 6 April The Emergency Tax Code on a cumulative basis will be applied o This is currently my only job The Emergency Tax Code on a W1 M1 basis will be applied o I have another job or pension Basic Rate on a cumulative basis will be applied If the employee does not provide the above details l have another job or pension will be automatically selected and a tax code of OT W1 M1 will be applied gt Student Loan Indicator This field should be selected if the employee has a Student Loan to be repaid gt Information Confirmed This field is automatically selected if the user has manually selected one of the above statements It is disabled if Seconded or OccPen Indicator is ticked Occupational Pension Occupational Pension Recently Bereaved Spouse Civil Farner Dependant Annual Pension 0 00 gt OccPen Indicator If Recently Bereaved Spouse Civil Partner Dependant is ticked or Annual Pension entered the system will automatically tick OccPen Indicator gt Recently Bereaved Spouse Civil Partner Dependant This will indicate that the person in receipt of a pension is a recently bereaved dependant gt Annual Pension The annual value of the Occupational Pension being paid should be entered This is mandatory if the Recently Bereaved Spouse Civil Partner Dependant is ticked
27. the BACS file has been created and the RTI Class of Full Payment Submission will have been pre selected 42 RTI System Parameter Maintenance lo Parameter Properties ATI System Parameter Maintenance Enable Statutory Recovery Comp Entry Std 18 BACS File Opt Out of Run FPS after BACS Extract Disable NI Number Confirmation Enable Submit File 20 Contact Code Table Enable Correlation ID Generation U Employer Scheme Reference If the Std18 BACS File option is not ticked or Opt Out of Run FPS after BACS Extract is ticked then the RTI Extract program must be manually selected from the menu Doc Version 2 3 Page 27 OP v8 14 3 User Guide RTI User Guide 98 Advanced 6 1 Creating the FPS Extract The FPS file is created using the RTI Extract program RTI File Agent Details Payments Declarations Scheme Ceased E scluded Employee File Details ATI Class Full Payment Submission ka O Live 6 Test in Live File Name FHE EU 201404 TIL_20140624105911 vrm Sender Details Adjustment ________________ HAYE Reference Payroll l Parrollk DEA Monthly Payment Date Forename Sumame Brown o Email Telephone No Report Options _ __ 24 outs a O o Contact Details Tie Me enre lt Doc Version 2 3 Page 28 OP v8 14 3 User Guide RTI User Guide 98 Ad vanced 6 1 1 RTI File Tab File Details E Real Time Information Extract S RTI
28. the tax month within the PAYE Reference about to be processed If selected all the Statutory Payments Year to Date fields are zeroised Employment Allowance The Employment Allowance is available from 6 April 2014 and allows employers to reduce their employer Class 1 NICs by 2000 every tax year The 2000 can only be claimed against one PAYE reference The reduction in payment is a manual task for the employer ie they simply reduce the physical payment being made to HMRC If there is insufficient Class 1 NICs in a tax month then the partial deductions can be made until 2000 is used up again this would be controlled by the employer gt Submit Claim This field is ticked to indicate that the employer wishes to claim the 2000 EA The indicator is only set once allowing subsequent annual reduction in Class 1 NICs to be made The date that the EPS has been successfully submitted will be written to the ER PAYE Reference Maintenance program on the RTI tab in a new field Claim Submitted Stop Claim This field is ticked to indicate that the employer is no longer entitled or wishes to stop paying The date that the EPS has been successfully submitted will be written to the ER PAYE Reference Maintenance program on the RTI tab tn a new field Claim Stopped Statutory Payments Year to Date If any Statutory Payments have been made in the previous tax month the recovery and compensation values will be automatically displayed
29. to signify that it is a mandatory field and must be populated Sender The Sender field defaults to Employer The other options are as follows o Bureau o Partnership o Trust o Government o Acting in Capacity o Other Adjustments Adjustments Late Reason None Va Payment Date 25 07 2014 gt Late Reason If the actual payment date is before the date the FPS is submitted then an FPS must be created with a late reason output to the FPS file The late reason should be selected here Note HMRC require that an FPS must be sent on or before the date that employees are paid Acceptable reasons are o Correction to earlier submission o Reasonable excuse o No requirement to maintain a deductions working sheet or impractical to report work done on day o Micro employer using temporary on or before relaxation o Payment subject to Class 1A NICs but P11D P9D for tax Page 30 OP v8 14 3 User Guide Doc Version 2 3 RTI User Guide Advanced o Notional Payment Other o Notional Payment Employment related security o Notional Payment Payment to expat by third party or overseas employer If you are unsure of reason to use please refer to HMRC website for guidance Payment Date The Payment Date written to the FPS file will default to the current period payslip date from the current period plan record This is the date that payment has been made to employees If employees were not pai
30. 001 Mr W Iam 3919 88 0 00 842 67 2809 33 0 00 Pre Tax NIable Non After Tax Student Tax Normal Hours Pen Conts Taxable Pen Conts Loan Ded Deducted worked Tax Code 270 83 0 00 0 00 258 00 783 80 C BR Taxable Non Tax NI Net Pay Pay After Taxable Employee Name Pay Payments Deductions Stat Deducts Benefits 00000002 Mr H Ledger 1971 58 0 00 1215 30 1519 38 0 00 Pre Tax NIable Non After Tax Student Tax Normal Hours Pen Conts Taxable Pen Conts Loan Ded Deducted worked Tax Code 0 00 0 00 0 00 58 00 394 20 D BR Taxable Non Tax NI Net Pay Pay After Taxable Employee Name Pay Payments Deductions Stat Deducts Benefits 00000003 Mr T Cruise 21404 67 0 00 0 00 12131 00 0 00 Pre Tax NIable Non After Tax Student Tax Normal Hours Pen Conts Taxable Pen Conts Loan Ded Deducted worked Tax Code gt Taxable Pay taxable pay for the employee in the current period gt Non Tax NI Payments this is the combined value of all net payments the employee has received i e payments made against elements that are set up as non taxable and non Nlable gt Net Pay Deductions this is the total value of all deductions from pay after Tax and NI This does not include before tax pension deductions i e those made under Net Pay Arrangements If an employee s pay is split over 2 bank accounts then the smaller of the two payments will be added here Similarly if an employee is paid by cash or cheque the full net payment will be added gt Pay After St
31. 01401 LIVE 20140401150153 xml SMP Recovered OSPP Recovered SAP Recovered ASPP Recovered NIC Compensation on SMP NIC Compensation on OSPP NIC Compensation on SAP NIC Compensation on ASPP CIS Deduction Suffered B B B B B B B B B DIE O E T ee o o Employment Allowance Claim submitted Period of Inactivity From To Scheme Ceased No Date Scheme Ceased Final Submission No The report will also provide a breakdown of totals per payroll When the No employees paid this month check box is ticked on Payments tab the following report is output Report PY9S A Version 1 34 RTI EPS Extract Report Page 1 Run Date TUE APR 1 2014 15 08 ee ass OS _ _ __ _ __ ____ _ Operator ID Z pay Time Date Requested 01 04 2014 15 08 Format z RTI EPS Extract Report Time Date Printed z 01 04 2014 15 08 PAYE Ret 67070 Tax Year z 2014 HMRC Office 491 Tax Month S 01 AO Ref 473PQ11214673 Payroll ae File name C AdvancedOP814 oplive rtisubmissions EPS EPS G7070_ 201401 LIVE 20140401150153 xml Employment Allowance Claim stopped No Payment For Period From 2014 04 06 To 2014 05 05 Report z PYSS A Version 1 34 RTI EPS Extract Report Page 2 Run Date TUE APR 1 2014 15 08 Payroll 1 Gotham Weekly Page 62 OP v8 14 3 gt m User Guide D RTI User Guide Advanced Busness Solutions 8 2 2 EPS Exception Report If there is any validation errors an EPS Exception spool
32. 10 21 PAYE Ref gt 67070 Tax Year Period 2012 02 HMRC Office 491 Payment Date z 31 05 2012 AO Ret z 473PQ11214673 A File name C YearEndIinstallshieldTest oplive rtisubmissions FPS FPS 01 201202 LIVE 20120501102145 xml K Employee Name Taxable YTD Tax Paid YTD S Loan YTD SSP YID SMP YTD OSPP YTD SAP YTD ASPP YTD 00000001 Mr W Smith 4444 94 2222 00 308 00 0 00 0 00 0 00 0 00 0 00 00000002 Mr H Ledger 3943 16 1576 80 116 00 0 00 0 00 0 00 0 00 0 00 00000003 Mr T Cruise 43351 14 17406 33 0 00 0 00 0 00 0 00 0 00 541 80 00000004 Mr C Bale 6666 66 1084 00 0 00 0 00 0 00 0 00 0 00 0 00 00000005 Mr J Gyllenhaal 9386 84 2110 33 606 00 0 00 0 00 0 00 0 00 0 00 00000006 Mr S Connory 10420 16 4168 00 0 00 0 00 0 00 0 00 0 00 0 00 00000007 Mr B Pitt 1666 66 333 20 0 00 0 00 0 00 0 00 0 00 0 00 00000008 Mr G Butler 11110 25 4444 00 0 00 0 00 0 00 0 00 0 00 677 25 00000009 Mr L Dicaprio 3065 84 0 00 0 00 0 00 0 00 0 00 0 00 0 00 00000010 Mr J Depp 2087 66 0 00 0 00 0 00 0 00 0 00 0 00 0 00 00000011 Ms A Jolie 7093 84 1193 13 0 00 0 00 0 00 0 00 0 00 0 00 Font Scan Scan For DK l Help Doc Version 2 3 Page 40 OP v8 14 3 User Guide RTI User Guide n Advanced Busness Solutions 6 2 4 RTI FPS Starter Leaver Extract Report This report displays all new employees that have been paid and any leavers processed in the current period The report is broken down into 2 separate sections gt New Starters gt L
33. 12 10 22 PAYE Ref gt G7070 Tax Year Period 2012 02 HMRC Office 491 Payment Date 31 05 2012 20 Ret 473PQ11214673 File name gt C YearEndInstallshieldTest oplive rtisubmissions FPS FPS_01_ 201202 LIVE_20120501102145 xml Payroll 1 Monthly ER NI ER NI EE NI EE NI Dir Wk Mth Dir Employee Name National Insurance This Period Yr to Date This Period Yr To Date Calc Appoint 00000001 Mr W Smith NI Letter D 471 55 471 55 332 68 332 68 NIable Pay 4748 95 Earn up to LEL 464 00 Earn from LEL to PT 170 00 Earn from PT to UAP 2703 00 Earn from UAP to UEL 203 00 00000002 Mr H Ledger NI Letter 2 185 97 371 94 160 51 321 02 Nlable Pay 1971 58 Earn up to LEL 928 00 Earn from LEL to PT 340 00 Earn from PT to UAP 2675 16 Earn from UAP to UEL 0 00 00000003 Mr T Cruise NI Letter A 2942 49 5810 21 716 85 1422 86 NIable Pay 21946 47 Earn up to LEL z 928 00 Earn from LEL to PT lt 340 00 Earn from PT to UAP lt 5406 00 Earn from UAP to UEL 406 00 Font Scan Scan For OK Help The FPS Reports as described in the following sections will be produced and available to view through the Print Manager or to Excel The file is now available for submission via the RTI Gateway submission If a late reason was entered at run time it will be displayed in the header section of the report Page 38 OP v8 14 3 User Guide RTI User Guide Busness Solutions Advanced Report gt PY95 A V
34. 2012 Filename C YearEndInstallshieldTest oplive rtisubmissions fps FPS 01 201202 LIVE 20120501161000 xml Font Scan Scan For Doc Version 2 3 Page 46 OP v8 14 3 User Guide RTI User Guide a Advanced Busness Solutions 7 2 2 RTI FPS Gateway Submission HMRC Response An HMRC Response report in format returned by HMRC showing the FPS XML file was successfully accepted will also be output to Print Manager as shown below py235repXML Version 1 00 RTI FPS Gateway Submission HMRC Response FRI MAR 30 2012 16 14 54 Report Options Correlation ID BD6 2D4E2A7C84B9B99B89556177DE1DF Operator ID Sender ID ISV156 Time DATE Requested 16 14 30 03 2012 PAYE Reference G7070 Time DATE Printed 16 14 30 03 2012 Filename C YearEndInstallshieldTest oplive rtisubmissions fps FPS_01 201202 LIVE 20120501161000 xml lt xml version 1 0 2 gt lt GovTalkMessage xmlns gti http ww govtalk gov uk CM envelope xmlns erp http ww govtalk gov uk CM errorresponse xmlins ht tp www govtalk gov uk CM envelope gt lt EnvelopeVersion gt 2 0 lt EnvelopeVersion gt lt Header gt lt MessageDetails gt lt Class gt HMRC PAYE RTI FPS lt Class gt lt Qualifier gt response lt Qualifier gt lt Function gt submit lt Function gt lt TransactionID gt lt AuditID gt lt CorrelationID gt BD62D4E2A7C84B9B99B89556177DE1DF lt CorrelationID gt lt ResponseEndPoint Pollinterval 10 gt https secure d
35. 4 Nat Ins No NS545952D Duplicate NI Number 11 Jolie Monthly 5014 Nat Ins No NM235262D Duplicate NI Number b 4 p j Doc Version 2 3 Page 93 OP v8 14 3 User Guide RTI User Guide gt Advanced 14 7 Creating Submitting the EPS Extract The EPS is processed outside of the individual payroll cycle The timing of when the EPS is created and submitted is determined by the end user however it should be made before payment of PAYE NIC is made to HMRC for the relevant tax month i e before 19 of following month OpenPeople will only allow an EPS to be created for the latest tax month where ALL payrolls associated with the PAYE Reference for which the file is being created have had Period Ends processed The Processed flag is checked against each relevant Period Plan record If the Processed flag is set to yes this indicates that the period end has been processed for that payroll Period Tax Month Start Date End Date PAP Start Date PRP End Date Cut off date Papelip Date BACS Date No of PRP Periods Processed 2820842013 1409 2013 28 08 201 842013 201320 207305 01708 2013 14082013 15 08 2013 28 06 2013 14708 2013 16 08 2013 15708 2013 1 Yes 14 8 Creating Submitting the NVR Extract This is an ad hoc extract and can therefore be created and submitted at any time 14 9 Creating Submitting the EYU Extract If errors are discovered on or before 19 April following the end of a tax year that have not
36. 5546 xml lt xml version 1 0 2 gt lt GovTalkMessage xmlns gti http ww govtalk gov uk CM envelope xmlns erp http ww govtalk gov uk CM errorresponse xmlns ht tp www govtalk gov uk CM envelope gt lt EnvelopeVersion gt 2 0 lt EnvelopeVersion gt lt Header gt lt MessageDetails gt lt Class gt HMRC PAYE RTI NVR lt Class gt lt Qualifier gt error lt Qualifier gt lt Function gt submit lt Function gt lt TransactionID gt lt CorrelationID gt 87B07798074047C188CD827CD8B7E49D lt CorrelationID gt lt ResponseEndPoint Pollinterval 10 gt https secure dev gateway gov uk poll lt ResponseEndPoint gt lt Transformation gt XML lt Transformation gt lt GatewayTimestamp gt 2012 04 19T09 03 44 278 lt GatewayTimestamp gt lt MessageDetails gt lt SenderDetails gt lt Header gt lt GovTalkDetails gt lt Keys gt lt GovTalkErrors gt lt Error gt lt RaisedBy gt Department lt RaisedBy gt lt Number gt 3001 lt Number gt lt Type gt business lt Type gt lt Text gt The submission of this document has failed due to departmental specific business logic in the Body tag lt Text gt lt Error gt lt GovTalkErrors gt lt GovTalkDetails gt lt Body gt lt ErrorResponse SchemaVersion 2 0 xmlns auto nsl http www govtalk gov uk CM envelope xmlns http www govtalk gov uk 11 3 Exiting During Submission See 7 3 Doc Version 2 3 Page 73 OP v8 14 3 User Guide RTI User
37. 88 13 2 3 RTI EYU Gateway Submission Rejection Report cce ee e 88 13 2 4 RTI EYU Gateway Submission HMRC Response ee e e e e e e eK 88 14 Where RTI sits in the Normal Processing Cycle ssssnsnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn 89 14D PROCESSINO OVE VIC Wisin aos 89 14 2 Payroll Calculator iii 90 14 3 Control TO tal uscar Ha aE Ka Na EA iaa ideada 90 SE A BAC A e E Eee ceaatest 90 14 5 Greating Submitting the FPS Extra Esinaine a A A E A NT A 91 GIPER E N TTT TTT 91 14 6 1 Period End Employee Validation Report cce eee 93 14 7 Creatng submitting the EPS EXT a CE torito dol a 94 14 8 Creating Submitting the NVR EXtract ii ad 94 14 9 Creati ng Submitting the EYU EXtratt iriiri ji 94 LS Append Aena N E A 95 LOs lr RENS tatutory Elements ica an 95 15 2 Element Set Up Pension amp Benefit INdicCators ocooocccccccccccccnnncccnnnnnrn cnn nnn nan 96 Doc Version 2 3 OP v8 14 3 User Guide RTI User Guide 1 Introduction 1 1 Overview Real Time Information RTI aims at improving the operation of Pay As You Earn PAYE It will make the system better for individuals and easier for employers and HM Revenue Customs HMRC to operate It also supports the introduction of Universal Credits Currently employers and pension providers send information about tax National Insurance contributions NICs and other payroll deductions to HMRC after the end of each tax year The result
38. 9 Live Test in Live File Name EPS P amp E 201212 LIVE 201 30920182 7 24 xml gt RTI Class From the RTI class field select Employer Payment Summary from the drop down list gt File Type An optional Test in Live file can be created and sent to HMRC If this option is used it is imperative that a separate Live file is also created and sent Live or TIL will be an integral part of the file name gt File Name The filename is a read only field and is generated based on the RTI class selected the PAYE Reference the tax year and month whether the file being sent is a test or live file and a date and time stamp In the above example the file name is EPS PAE 201212 LIVE 20130920182734 xml If Test in Live was selected the filename would be EPS PAE 201212 TIL_20130920182734 xml Doc Version 2 3 Page 53 OP v8 14 3 User Guide RTI User Guide PAYE Reference Payroll HAYE Refterence Payroll PAYE Ref PAE se HMAC Office 961 Centre 1 gt PAYE Reference The PAYE Reference displayed will default to the PAYE Reference that the current payroll is linked to in Payroll Parameter Maintenance This field is read only The user can select other available PAYE References from the dropdown to the right hand side of the field gt HMRC Office The HMRC Office number and description defined against the PAYE Reference selected with be displayed This field is read only For information
39. Employer Payment Summary Previous Live Test in Live File Name ATI File Agent Details Payments Prev EPS Declarations Scheme Ceased Employees Tax Year Tas Year 2013 12 Statutory Paprerit E Amaun La SSP Recovered 0 00 SMP Recovered SAP Recovered SMP Compensation SAF Compensation CIS Deductions Suffered Modify confirm the values entered are correct for all recovenez for the Tax ear Submit File Create File Exit Hek Doc Version 2 3 Page 58 OP v8 14 3 User Guide Doc Version 2 3 gt RTI User Guide Advanced gt Filename The filename created is the same format as for current EPS Once the user selects the previous tax year the filename will be auto generated as follows EPS PAYERef_TaxYear and TaxMonth12_LIVE or TIL depending on whether live or test in live file date and time stamp xml e g EPS G7070 201212 LIVE_20120528150359 xml or for a test in live file EPS G7070 201212 TIL_20120528150359 xml where date is 28 5 2012 and time is 15 03 59 Tax Year The user is able to select the previous tax year that they require to re submit A maximum of 6 previous tax years will be held starting from tax year 2012 13 The tax year is displayed as YYYY 12 as tax month 12 and will hold the final EPS figures for that tax year Those will be the figures that were submitted to HMRC If the tax year selected is changed after
40. File Agent Details Payments Declarations Scheme Ceased Excluded Employees File Details ATI Class Full Payment Submission ka Live Jest in Live File Mame FPS EU 201404 TIL 2014062410581 1 ml gt RTI Class The Full Payment Submission option should be selected gt File Type An optional Test in Live file can be created and sent to HMRC If this option is used it is imperative that a separate Live file is also created and sent Live or TIL will be an integral part of the file name gt File Name The filename is a read only field and is generated based on the RTI class selected PAYE Reference payroll number the tax year and month whether file is test or live and a date and time stamp PAYE Reference Payroll PATE Reference Payrall Payrol DEA Monthly gt Payroll The current payroll description will be displayed by default Doc Version 2 3 Page 29 OP v8 14 3 User Guide Doc Version 2 3 2 RTI User Guide Sender Details Section Sender Details Sender ID 1547156 sender Employer ka gt SenderID If the Sender ID has been linked to the PAYE Reference selected then the Sender ID will be automatically populated and the field is read only If the Sender 1D has not been linked to the PAYE Reference then the Sender ID will be blank and the user must select the appropriate Sender ID from the drop down to the right hand side of the field The field is in bold
41. NVR Gateway Submission Acceptance report will be output to Print Manager as shown below FSA Z Report Viewer gcspool 21941381 prt Report py235rep Version 1 00 RTI NVR Gateway Submission Acceptance Report Page 1 Run Date THU APR 19 2012 11 29 41 q q lt A _ ____________ _ _z______ _ Reo Options _ _ _ _ _ _ _ __ _ gt Correlation ID SEQESE791B844163AE870B180D81688E Operator ID dm Sender ID gt ISvise Time DATE Requested 11 29 19 04 2012 PAYE Reference 67070 Time DATE Printed 11 29 19 04 2012 Filename C 1YearEndInstallshieldTesttoplivelrtisubmissionsinvriNVR_01_201202_LIVE_20120419111051 xml 90499909999 This RTI NVR file has been successfully sent to HMRC 2240430044 NVR Gateway Submission HMRC Response An HMRC Response report showing that the NVR XML file was successfully accepted will be output to Print Manager as shown below gt py235repXML Version 1 00 RII NVR Gateway Submission HMRC Response THU APR 19 2012 11 29 40 Report Options Correlation ID 5E0E9E791B844163AE870B180D81688E Operator ID Sender ID ISV156 Time DATE Requested 11 29 19 04 2012 PAYE Reference G7070 Time DATE Printed 11 29 19 04 2012 Filename C 1YearEndInstallshieldTesttoplivelrtisubmissionsinvriNVR_01 201202 LIVE 20120419111051 xml lt xml version 1 0 gt lt GovTalkMessage xmins gti http www govtal
42. Oro Ra yments Tabs rssnoda dro ladera le desc 55 0 14 Previous EPS Ta THT Gees aumbanrsiacceusacumennetneetawst cannes 58 0 15 Scheme Ceased TAD wwiaheetari teen aeaa lane lad te aredeumedy tagte we aeaa 60 0150 Declarations Tab atras 61 OZ EPS RODO S is dosel cd ciod arenes ace eeues 62 S2 L EPS R Eel REDOLE PIAR COM o o EnA tek ater TNA EN E E N 62 0 232 EPS EXCODUON REDO Esso 63 9 RTI Gateway Submission EPS cssss sss sss sss sss sss essen aran nanna nenen enes 64 Sa ENG EPS rega eE a a A ines A aes 64 C n e Sent FOCI iaei E ENTE A tute E A 64 9 2 EPS SUDMISSION REPOM Suar E Aa R Aa 65 9 2 1 RTI EPS Gateway Submission Acceptance Report cce eee 65 9 2 2 RTI EPS Gateway Submission HMRC Response ee e e e e e e e e 65 9 2 3 RTI EPS Gateway Submission Rejection Report cce e eee eeeeeseeeeeeeeeeeeees 66 93 Exiting DUNING SUDMISSION autotest ios 66 10 NINO Verification Request NVR sssssssssssss esse sss essea essen essa s nanna ass 67 TO Creating Ne NN Rana ci AEE manera Aa 67 Ean ls RH FIE Taba A i Seana Dialed Chae dia 68 10 12 Agent Detalls Ta a OO 69 TOOL EMDIOYeeS TaDr tsiodra lors 69 Ea NVR ee A e el 70 LO 23 RTS NVR a Le REO DO lasosaripetos a cota A a teeteciets 70 10 22 RT NVR Exception REDO ataron cdt ciualotentectvinehiemi vous 70 11 RTI Gateway Submission NVR ccccceessssssscsssseeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeneeenenes 71 RIS N SUBMIT tae NV TTT 71 BI ead CNE
43. PS XML file will automatically be moved into a Sent folder rtisubmissions eps sent If the Sent folder does not exist the system will create one 4 di rtisubmissions gt de eas 4 Li eps de sent Doc Version 2 3 Page 64 OP v8 14 3 User Guide RTI User Guide n Adva nced Busness Solutions 9 2 EPS Submission Reports When the EPS XML file is submitted to the Government Gateway reports as detailed in this section are created within Print Manager 9 2 1 RTI EPS Gateway Submission Acceptance Report When the EPS XML file is successfully submitted an EPS Gateway Submission Acceptance report will be output to Print Manager as shown below Report py235rep Version 1 00 RTI EPS Gateway Submission Acceptance Report Page a Run Date FRI MAR 30 2012 16 40 34 E E ETA Report Options Correlation ID 08AC454DA9D2475596851FD778926FFA Operator ID dm Sender ID z Isvise Time DATE Requested 16 40 30 03 2012 PAYE Reference 67070 Time DATE Printed z 16 40 30 03 2012 Filename C YearEndInstallshieldTest oplive rtisubmissions eps EPS_G7070_201202_LIVE_20120330163516 xml XXX This RTI EPS file has been successfully sent to HMRC EPS DATA m Advance Received 0 00 SSP Recovery 0 00 SMP Recovery 0 00 OSPP Recovered E 0 00 SAP Recovery 0 00 ASPP Recovery S 623 07 NIC Compensation on SMP 0 00 NIC Compensation on OSPP 0 00 NIC C
44. TI tab to reflect removal of SSP Recovered and NICs Holiday Wording updated to reflect Section 8 1 5 Updated wording on EPS screen Declarations tab Section 10 1 updated NVR screen to reflect Late Reason although disabled for NVR Section 12 UYU updated to reflect NI abel earnings per NI category and SCON Section 15 1 updated list of RTI elements New section 15 2 defining elements as type Pension or Benefit 31 3 2014 Graeme Walker Added Employment Allowance to EPS section 26 6 2014 Graeme Walker 26 9 2014 Graeme Walker Doc Version 2 3 Updated following sections 6 1 and 6 1 x Added Late Reason and Payment Date entry fields and new Excluded Employees tab to main FPS screen 6 2 7 new FPS Excluded Employees report 6 2 8 new FPSINDIV reports 6 2 9 new FPSINDIV Employee Late Reason report Updated following sections 8 1 4 new function allowing EPS to be created for previous years Note RTI screens in other sections have not been updated to reflect the additional Prev EPS tab 12 1 amended EYU section to include new import function OP v8 14 3 User Guide RTI User Guide Contents TINTO da CLON acti io Sean bees eeae cuca teen eaestuseeeusebessenmis 9 LI WOW CI IOWY scons E im PEO Eo 9 1 2 IMPORTANT Employee Re nUMbering cccccccceee cece ee eee eeeeeeeeeeeeteeeeeeeeeggaunenees 9 2 FEFMINOLOY ssscmisiianinenacanantnaionspicnncr nani ii
45. User Guide RTI User Guide OP v8 14 3 Prepared by Graeme Walker Advanced Business Solutions Excel Centre Exploration Drive Bridge of Don Aberdeen AB23 8HZ Tel 44 0 8451 606162 k 44 0 1224 825504 va Adva nced Web www advancedcomputersoftware com abs Business Solutions Date 26 9 2014 Document Version 2 3 User Guide RTI User Guide Copyright Advanced Business Software and Solutions Ltd 2014 Whilst Advanced Business Software and Solutions Ltd endeavours to ensure that the information in this document is correct it does not accept any liability for errors or omissions or any liability arising out of its use The software described in this document is supplied under licence and may be used or copied only in accordance with the terms of such a licence Issue of this document does not entitle the recipient to access or use the software described The development of Advanced Business Software and Solutions Ltd software is continuous and the published information may not reflect the current status Any particular release of the software may not contain all of the facilities described and or may contain facilities not described aaa Histor Issued By changes e 1 0 Graeme Walker Document reviewed and updated Version for v8 13 release 24 2 2013 Graeme walker Clarification added on when FirstFPS should be used see Section 2 Terminology Correction made to section 6 1 4 as to when Scheme Cea
46. alysis Analysis 2 Elements Stat Accums Other Accums Employee 9 Surname Hawkins Title Mr Initials F Prev Name Forename Richard Forename 2 Known As Richard Birth Date 06 09 1973 Age 29 Yrs 5 Months Sex 0 Male O Female Marital Stat D Divorced Nationality S Ethnic Orig o l Passport Number 33246758 Disabled The following fields will be output to the Full Payment Submission FPS extract The FPS is submitted to HMRC for each payroll every pay period gt Surname gt Forenames 1 and 2 Nicknames or shortened names must NOT be used gt Birth Date gt Passport Number HMRC have requested that employers where possible record passport details It is not however mandatory to record this information The Passport Number is an alpha numeric field which can hold up to 35 characters Doc Version 2 3 Page 16 OP v8 14 3 User Guide RTI User Guide n Advanced Busness Solutions 5 1 2 Personal 2 Tab 2 Employee Masterfile Maintenance 9 R Hawkins Le LS ss Personal 1 Personal 2 AT Tax NI Pension AE Pay Details Employment Analysis Analysis E Elements Stat Accums Other Accums Address Details Address 1 34 High Street West Address 2 Aberdeen Address 3 Address 4 Address 5 Post Code 4B12 60H Foreign Country Contact Details Telephone E Mail Mobile E Mail Fax E Form Details eP6D Opt In Opt Out P
47. ame Helen Surname James Emai helen james yahooo com Telephone Mo 01776171814 Mandatory fields are highlighted in bold Doc Version 2 3 Page 14 OP v8 14 3 User Guide RTI User Guide e Adval ced ness Solution 4 2 Agent Details This program will allow agent details to be created meaning the agent details do not have to be entered each time RTI extracts are generated 7 Agent Details Maintenance Details Notes Code Description E45613 B2b Payroll Services Geach S OOOO S l CODE Click Add to create new agent i Agent Properties Mew Details Notez Agent Details Agent ID E7665 Agent Company Mbs Accountants Address Line 1 16 High Street Address Line e Address Line 3 Perthshire Address Line 4 Uk Post Code PH33 3011 Ema mbsaccsemail com Mandatory fields are highlighted in bold Doc Version 2 3 Page 15 OP v8 14 3 User Guide RTI User Guide gt Advanced 5 RTI Data Items HMRC require a large number of data items to be reported each pay period through the RTI FPS Full Payment Submission return The full list of data items can be found at http www hmrc gov uk softwaredevelopers rti data item guide pdf 5 1 Employee RTI Fields 5 1 1 Personal 1 Tab 2 Employee Masterfile Maintenance 9 R Hawkins Personal 1 Personal 2 ATI Tax NI Pension AE Pay Details Employment An
48. an EAS file the ALIGNMENT parameter must be set against the RTI Extract program py95 First Full Payment Submission details about an employee s pay tax and NI plus starter and leaver details The FirstFPS is only sent once per payroll i e in the first period of RTI The FirstFPS will include all current year employees i e will include employees who have resigned during the current tax year It will also include employees who may not have been paid during the tax year but are still live on the system The FirstFPS is created per payroll To create and submit an FirstFPS file the ALIGNMENT parameter must be set against the RTI Extract program py95 Only employers who have participated in the RTI pilot pre April 2013 or those employers who have special dispensation from HMRC to join RTI later in the 2013 14 tax year should create a FirstFPS All employers joining RTI in April 2013 should create a normal FPS instead of a FirstFPS Full Payment Submission the content of the extract is exactly the same as the FirstFPS i e details about an employee s pay and deductions The key difference is that the FPS only contains details about employees paid in the current pay period The FPS must be run every pay period separately for each payroll The ALIGNMENT parameter must not be set against the RTI Extract program Employer Payment Summary this file is used to report a reduction in the amount that is to be paid to HMRC e g
49. an integral part of the file name gt File Name The filename is a read only field and is generated by the RTI class selected the payroll number tax year whether the file being sent Is live or test in live and a date and time stamp gt EYU Batch When user clicks on Drop down box it displays all EYU Batch names related to the current payroll Select the EYU Batch name to be used to generate the EYU XML extract for HMRC submission PAYE Reference Payroll HAYE Reterence Payroll Payroll Monthly Ltd gt Payroll Current payroll is displayed For information on Sender Details Contact Details and Report Options see section 4 1 12 2 2 Agent Details Tab See section 4 2 Doc Version 2 3 Page 83 OP v8 14 3 User Guide RTI User Guide Busness Solutions Advanced 12 3 EYU Reports When the EYU XML file is successfully created several spool reports are automatically output as detailed in the following sections 12 3 1 RTI EYU Amendments Report The EYU Amendments report shows the amendment amounts entered for tax and Statutory payments S a RTLEYU Amendments txt Notepad File Edit Format View Help Report PY A Version 1 0 RTI EYU Amendments Report Page 1 a Run Date MON JUL 9 2012 11 49 Tax Year 2012 13 Report Options Format RTI EYU Submission Employee YTDs Operator ID System PAYE
50. assword Password Reminder eLetters Opt In Opt Out Manual Override Email Password Back Next Apply Cancel The following fields are included on the FPS extract gt Address lines 1 to 4 gt Post Code gt Foreign Country An entry should be made in this field if the employee s address is outside the UK Channel Islands or the Isle of Man This field can contain up to 35 alpha characters Note if the employee has a UK postcode no entry can be made in this field Doc Version 2 3 Page 17 OP v8 14 3 User Guide 5 1 3 RTI Tab 2 RTI User Guide Advanced Doc Version 2 3 2 Employee Masterfile Maintenance 9 R Hawkins ola 23 Personal 1 Personal2 ATI Tax NI Pension AE Pay Details Employment Analysis Analysis 2 Elements Stat Accums Other Accums Previous Employment Details PE Entry Date P45 Received 25 02 2014 w Date Left Prev Employ Y Tax Code At Leaving Date Normal Z 567L 5671 P6 Entry Week Number O Month Number O P45 Pay to Date 0 00 P45 Tax to Date 0 00 Check Tas P11 Tax Override Seconded to work in UK from abroad Seconded EPME Modified Scheme Stay in UK for 183 days or more European Economic Area Citizen Stay in UK for less than 183 days Work both in out of UK but live abroad Information Confirmed New Starter Declaration This is my first job since 6th April _ Student Loan Indicator V This is currently my only job have another job or pensio
51. at Deducts the value of pay after Tax NI and Student Loan repayments have been deducted gt Taxable Benefits total value of all taxable benefits paid gt Pre Tax Pen Cons the value of pre tax pension deductions gt Nlable Non Taxable this is the total value of all NI able but non taxable payments gt After Tax Pen Cons the value of post tax pension deductions Doc Version 2 3 Page 39 OP v8 14 3 User Guide RTI User Guide Advanced Busness Solutions gt Student Loan Ded the value of Student Loan deductions gt Tax Deducted the value of tax deductions gt Normal Hours Worked one of the following bandings is output according to the employees hours per week from the employee record o Upto 15 99 hours o 16 to 23 99 hours o 24 to 29 99 hours o 30 hours or more o Other This will be output if 0 00 hours are held against the employee record gt Tax Code outputs the employee s tax code 6 2 3 RTI FPS Employee YTDs Extract Report This report displays employees statutory year to date values with a summary Showing the payroll totals at the bottom of the report g A Report Viewer Agcspool25137319 prt o leal Report gt PY9S A Version 1 0 RTI FPS Employee YTDs Extract Report Page 1 A Run Date TUE MAY 1 2012 10 21 Operator ID dm Time Date Requested 01 05 2012 10 21 Format gt RTI FPS Employee YTDs Extract Report Time Date Printed z 01 05 2012
52. ate Level U aom Heb Pension If the element is used for making an employee pension contribution then the RTI Type Pension field should be ticked Note this should not be ticked for elements that are pensionable only for the actual employee pension contribution element If the pension scheme is a salary sacrifice arrangement then the Pension indicator should not be set for the actual salary sacrifice element negative allowance as there is no actual employee contribution i e the employer effectively makes full contribution Benefit Where an element is a payrolled benefit then the Benefit indicator should be ticked This would be the case where the benefit is not actually being paid through the payroll but PAYE NI is being applied i e through a benefit payment and associated offset arrangement Any benefit that appears on the P11D would have the relevant element ticked Doc Version 2 3 Page 96 OP v8 14 3
53. ault to today s date The Start Time and End Time will show a range up to the current time Enter a date and time range which will cover when the XML file was submitted Click on Submit to check progress of XML files submitted during the time range entered When the Data Request is completed a Gateway Submission Data Request spooled report will be output as shown below Z Report Viewer gcspool 17858374 prt o leas Report gt py235rep Version 1 00 RTI EAS Gateway Submission Data Request Report Page Run Date WED MAR 28 2012 16 12 54 Operator ID dm Time DATE Requested 16 12 28 03 2012 Sender ID Isvise Time DATE Printed 16 12 28 03 2012 Start Time Stamp Correlation ID Status 28 03 2012 14 59 36 C8r0A4496B864BDC9DA381D87257940C SUBMISSION RESPONSE Font Scan Scan For B OK Help This will show the Correlation ID which can then be used by the RTI Gateway Review program to review the progress of the XML file Doc Version 2 3 Page 50 OP v8 14 3 User Guide RTI User Guide e Ad vanced 7 3 2 RTI Gateway Review If the RTI Gateway Submission program was exited during the polling stage the Gateway will continue to submit the RTI file to HMRC The RTI Gateway Review program allows progress of the RTI submission to be reviewed at any time Select RTI Gateway Review from the menu The following screen will be displayed 42 RTI Ga
54. ax Items subject to Class 1 NIC but not taxed under PAYE regulations excluding pension contributions in the pay period 1078 Post Tax Pen Value of employee pension contributions that are not paid under a net pay arrangement 1079 TrivalCommA Trivial Commutation Lump sums TCLS Manual timesheet entry against element 1079 1080 TrivialCommB Small pot lump sum payments from personal pension schemes Manual timesheet entry against element 1080 1081 TrivialCommC Small pot lump sum payments from occupational pension schemes Manual timesheet entry against element 1081 Doc Version 2 3 Page 95 OP v8 14 3 User Guide RTI User Guide 9 Ad vanced 15 2 Element Set Up Pension amp Benefit I ndicators As pension and benefit information is to now to be reported to HMRC through the FPS elements should be flagged as a Pension or Benefit type element as appropriate The Payroll Calculation will use these indicators in order to calculate values that are to be submitted to HMRC 9 Element Properties PENSION Le 5 meza Man Calculation Court Bank Notes Main Details Flement 1500 Pension Element Type Deduction Fiscal Ind Before Tax Calculation Type Percentage ka Permanent Yes Pension W Benefit ATI Type Optional Details Batch Total Mone Deduction Sequence History Child Maint Order Pro Rata Hold Bank Details Clear Down Security Enquiry Level U Upd
55. bmitting the NVR After the NVR XML file has been created it must be submitted to HMRC This is done using the RTI Gateway Submission program Select RTI Gateway Submission from the menu 42 RTI Gateway Submission Messages Submission File To Submit C M4dyvanced oplive rtisubmissions avesent hyA_O1_ 20120 P Sac ee a 6 NINO Yerntication Request o Earlier Year Update Data Request Select the NINO Verification Request radio button as shown above Click on the Files button to browse to the NVR XML file to be submitted This will automatically open the appropriate NVR folder Select the relevant NVR XML file and click on the Submit button The program will start submitting the file to HMRC 11 1 1 Sent Folder The successfully submitted NVR XML file will automatically be moved into a Sent folder rtisubmissions nvr sent If the Sent folder does not exist the system will create one 4 de rtisubmissions gt de eas gt dd e di eyu gt firstfps gt Je fps 4 de nwt sent Doc Version 2 3 Page 71 OP v8 14 3 User Guide Advanced Busness Solutions 11 2 NVR Submission Reports 11 2 1 RTI 11 2 2 RTI Doc Version 2 3 When the NVR XML file is submitted to the Government Gateway several reports are created within Print Manager as detailed in the following sections NVR Gateway Submission Acceptance Report When the NINO Verification Request XML file is successfully submitted an
56. code entered from the P45 will be applied when the user saves the record or moves to another screen Tax codes BR OT DO and D1 cumulative or non cumulative will default to I have another job or pension Page 18 OP v8 14 3 User Guide Doc Version 2 3 E RTI User Guide All other tax codes will default to This is currently my only job Seconded to work in UK from abroad Seconded to work in UE from abroad Seconded EPMEB Modified Scheme Stay in UE for 183 days or more European Economic Area Citizen Stay in UK for less than 183 days Work both inout of UE but live abroad Information Confirmed gt Seconded A seconded employee includes o Individuals working wholly or partly in the UK for a UK resident employer on assignment whilst remaining employed by an overseas employer o Individuals assigned to work wholly or partly in UK at a recognised branch of their own employer s business o All individuals included by an employer within a dedicated expatriate scheme or within an expatriate modified PAYE scheme Where an employee falls into any of the above categories the Seconded field should be selected If this field is selected the Previous Employment Details section will be disabled Please note when Seconded is selected the New Starter Declaration section will be disabled and Statement B This is currently my only job will be automatically selected Selecting Se
57. conded will enable the following three fields one of which must also be selected If the details are not entered the following error message will be displayed Please complete the Seconded details section br r2 More If the information has not been supplied the user must still make a selection to the best of their knowledge gt Stay in UK for 183 days or more Select if your employee intends to work in the UK for 183 days or more The Emergency Tax Code on a cumulative basis will be applied gt Stay in UK for less than 183 days Select if your employee Intends to work in the UK for less 183 days The Emergency Tax Code on a W1 M1 basis will be applied gt Work both in out of UK but live abroad Select if your employee is working both inside and outside of the UK but will be living abroad The Emergency Tax Code on a W1 M1 basis will be applied Page 19 OP v8 14 3 User Guide Doc Version 2 3 gt RTI User Guide Advanced Once completed the following message will be displayed Question 9 Seconded details have been selected Have the employee s present L circumstances been confirmed The user must then select Yes or No If Yes is selected the appropriate tax code will be applied as detailed above and the Information Confirmed field will be auto selected If No is selected tax code OT W1 M1 will be automatically applied Selecting Seconded will also enable two optiona
58. d on that date the actual date they were paid should be entered here If the date entered is before today and a late reason has not been entered the following message will be displayed Question Press HELP to view stack trace E As the payment date has already passed this submission will be late Do you want to enter a Late Reason It is advisable to select Yes and choose a late reason before creating the file If entering a late reason for the full FPS then this means that ALL employees have been paid late so you may incur a penalty for the whole payroll If just one or two individuals are being processed late then exclude those from the initial full FPS and then use the Individual FPS option to create an FPS for the selected employees This means a late reason can be chosen for the individual employees As per request from HMRC a warning is output if a late reason is selected for a whole payroll Warning Press HELP to view stack trace The Late Reason selected will be applied across the entire payroll and A not just an individual employee OR Help Page 31 OP v8 14 3 User Guide Doc Version 2 3 2 RTI User Guide Contact Details Contact Details Title Mr Contact Code AB R Forename Alan Surname Brown Email a browntasyzemail co pa Telephone No Click on the Contact Code drop down to auto populate contact details on screen The details can be overwritten if necessary If no
59. de Doc Version 2 3 RTI User Guide Advanced Error Press HELP to view stack trace ee NI Code Tax Code SCON If an employee is on a NI code D E or La SCON must be included within the FPS file If a SCON has been defined against the current payroll but not against appropriate employee the FPS file will not be created and a rejection report output to Print Manager detailing problem employee s The employee s should be updated with relevant SCON If there are employees located with an NI code of D E or L and there is no SCON defined against the payroll a default SCON of S2769999P will be output against each employee who has an NI category of D E or L Note the default SCON of S2769999P has been allocated by HMRC They will then contact you to ensure a correct SCON is used in future Expat indicator Non I ndividual indicator Page 23 OP v8 14 3 User Guide gt RTI User Guide Advanced 5 1 5 Employment Tab 2 Employee Masterfile Maintenance 9 R Hawkins lo ES Personal 1 Personal 2 ATI Tax NI Pension AE Pay Details Employment Analysis Analysis 2 Elements Stat Accums Other Accums Employment Details Employ Stat Live hd Start Date 04 04 2012 Service O Yrs 10 Months Cont Start Date x Cont Service Contract Type Permanent o Full Time Part Time Irregular Payment Indicator Personnel No 9 Hours Hrs per Day 0 00 Hrs p
60. displays a pop up window allowing amendments to be added per NI category 42 NI Category Amendments NI Cat NI Values NiCode 4 SCON o Gross Earnings for NICs 250 00 FE WIC 25 00 Upto LEL 105 00 ER NIC 30 35 LEL to PT 145 00 PT to WAP ST UAF to UEL 0 00 Valid NI Codes are A B C D E J Lor xX If NI Code X then all values must be 0 00 If NI Code C then Employee NICs must be 0 00 Clicking Create will apply all amendments on that screen against the same NI Code The applied changes are displayed on the browse at the bottom of the screen Doc Version 2 3 Page 77 OP v8 14 3 User Guide RTI User Guide A maximum of 4 occurrences of NI Category Amendments can be made per Employee If NI category is D E or L the associated SCON should also be entered if Tax Year selected gt 2014 gt Create button Clicking Create on the Employee tab adds the amendment entry to the list on the screen gt Modify button The user can select an entry on the list and click Modify to edit the Amount column of the entry if necessary gt Remove button User can select an entry on the list and click Remove to remove the entry On the Employee tab if user selects a NI Category Amendment entry in the list and clicks Remove all entries with the same NI Code will be deleted 12 1 1 1 Example Manual Batch Entry If the wrong NI category letter had been submitted o
61. e actual RTI EYU file to be submitted to HMRC is created from the RTI Extract program Select RTI Extract from the menu ATI File Agent Details Payments Declarations Scheme Ceased Employees File Details ATI Class Earlier Year Update W O Live Test in Live File Mame EYU 40 2013 007 TIL 201406241 22829 xml EYU Batch EvU_40 2013 007 w PAVE RefterencesPayroll Payroll Ml examples Sender Detal _ _ Sender ID 15756 Sender Employer Adustments __ _____ Late Heason Mone Payment Date Forename Surname Brown o E mail Telephone No o O Report Options _ _ re a O Contact Details mme N enrage Doc Version 2 3 Page 82 OP v8 14 3 User Guide RTI User Guide 9 12 2 1 RTI File Tab File Details 7 Real Time Information Extract a RTI File Agent Details Payments Declarations Scheme Ceased Employees File Details ATI Class Earlier Year Update tl Live Test in Live File Name EYTU_40_2073_001_TIL_ 201406241 228 23 xml EYU Batch EYU_40 2013 001 w gt RTI Class From the RTI Class field select Earlier Year Update from the drop down list gt File Type An optional Test in Live file can be created and sent to HMRC If this option is used it is imperative that a separate Live file is also created and sent Live or TIL will be
62. e box on the Employee screen Tax NI tab Enable Submit File If ticked the Submit File button on the RTI Extract program will be enabled This will allow the FPS file to be submitted immediately after creating the FPS file i e without exiting the RTI Extract program Contact Code Table Enter the code table that will be used to hold contact details in relation to the sending of RTI returns to HMRC Enable Correlation ID Generation This should only be ticked if directed to do so by HMRC This will auto generate a specific correlation ID within any RTI extract that is created It is only relevant for specified Government Departments where sensitive RTI data is being submitted to HMRC via the Enterprise RTI Customer Channel Service Employer Scheme Reference This must be populated if Enable Correlation ID Generation is ticked Page 13 OP v8 14 3 User Guide RTI User Guide E Advanced 4 Contact amp Agent Details 4 1 Contact Details This program will allow contact details to be added which will mean contact details do not have to be entered when RTI extracts are entered at run time E Contact Details Maintenance Contacts Hotes Description John Smith A Peters Enc Robertson Seach FF l CODE Click Add to create new contact 42 Contact Properties New Details Hotes Contact Details Contact Code H Title Ms Foren
63. eavers PYSS A Version 1 0 RTI FPS Starter Leaver Extract Report 2012 10 21 Operator ID dm Time Date Requested 01 05 2012 RTI FPS Starter Leaver Extract Report Time Date Printed 01 05 2012 67070 Tax Year Period 2012 02 491 Payment Date 31 05 2012 473PQ11214673 C YearEndInstallshieldTest oplive rtisubmissions FPS FPS_01_ 201202 LIVE _20120501102145 xml Format PAYE Ref HMRC Office 20 Ref Leo 4 4 T Payroll 1 Monthly New Start Starter St Work Annual Loan Status Pension 12 05 2012 No Not Seconded 20 000 00 Leave Date 21 05 2012 4444 94 6 2 5 RTI FPS Employee Details Extract Report The FPS Employee Details Extract report shows employee static data that has been included in the FPS XML file Report gt PY9S A Version 1 0 RTI FPS Employee Details Extract Report Page k A Run Date TUE MAY 1 2012 10 21 Operator ID dm Time Date Requested 01 05 2012 10 21 Format gt RTI FPS Employee Details Extract Report Time Date Printed gt 01 05 2012 10 21 PAYE Ref gt 67070 Tax Year Period gt 2012 02 HMRC Office 491 Payment Date 31 05 2012 20 Ref gt 473PQ11214673 File name C YearEndInstallshieldTest oplive rtisubmissions FPS FPS 01 201202 LIVE 20120501102145 xml ASPP Previous Irreg Employee Neme NI Number Address Birth Date Gender Passport No Partner Details Emp No Pay 00000001 Mr W Smith NS235689D The Mansion 14 10 1959 M 123456789 Yes Bell Air 00000002
64. ed and the user must complete the following details a Real Time Information Extract msn ATI File Agent Details Payments Declarations Scheme Ceased Employees Agent Details Agent ID E45613 L Agent Company Bb Payroll Services Click Address Line 1 Johnstone House Address Line 2 Selkirk Address Line 3 Scotland Address Line 4 Post Code 5512 4RR Emai b2ebpayralltemail com on the Agent ID drop down to auto populate the pre defined agent details These details can be overwritten if necessary If no agent codes have been defined then details should be manually entered as follows gt Agent I D This identifier is for the agent s own reference and is not the same as any agent s credentials that might be used to identify the agent to the Government Gateway The Agent ID field is an optional field The maximum field length is 35 characters Agent Company The agent company name should be entered This is an optional field The maximum field length is 35 characters Address Lines 1 4 The agent company address should be entered These are optional fields The maximum field length is 35 characters per line Post Code The agent post code should be entered This is an optional field The maximum field length is 8 characters Email The agent email address should be entered This is an optional field This Should be in a valid email address format Creating the File Click Create File
65. ed report will be output as shown below PYSS A Version 1 0 RTI EPS Exception Report THU APR 19 2012 09 44 Operator ID Time Date Requested 19 04 2012 09 44 Format gt RTI EPS Exception Report Time Date Printed 19 04 2012 09 44 PAYE Ref 67071 Tax Year 2012 HMRC Office 491 gt 473PQ11214673 HAS NOT BEEN CREATED DUE TO THE FOLLOWING FAILED VALIDATION Field Description Reason 0000 SMP Compensation SMP Compensation is greater than SMP Recovered Doc Version 2 3 Page 63 OP v8 14 3 User Guide RTI User Guide Advanced 9 RTI Gateway Submission EPS 9 1 Submitting the EPS After the EPS XML file has been created it must be submitted to HMRC This is done using the RTI Gateway Submission program Select RTI Gateway Submission from the menu The following screen will be displayed 42 RTI Gateway Submission Massages Submission lP i i resl O Full Payment Submission File To Submit C vadvanced oplivefrtisubmissionssepssEPS_GFO70_ 201203 ras C NINO Venfication Request 0 Earlier ear Update Data Request Select the Employer Payment Summary radio button as shown above Click on the Files button to browse to the EPS XML file to be submitted This will automatically open the EPS folder Select the relevant EPS XML file and click on the Submit button The program will start submitting the file to HMRC 9 1 1 Sent Folder The successfully submitted E
66. een and enter a late reason If the date entered is not in the current tax year the following error will be output Invalid Payment Date this date must be in current tax year Click Create File to generate the FPS Individual file Page 37 OP v8 14 3 User Guide y RTI User Guide Advanced 6 1 4 File Compression If a parameter of COMPRESS is set against the RTI Extract program py95 the FPS file will be created in a compressed format This will create the compressed FPS file that should be submitted to HMRC and an additional EmpData xml file which provides details of the employees included within the compressed file Compressed FPS files may have to be sent where there are a very large number of employees included within the FPS Contact Payroll Support for details 6 2 FPS Reports 6 2 1 RTI Doc Version 2 3 When the FPS XML file is successfully created several spool reports are automatically output as detailed in the following sections FPS NI Extract Report This report will list all employees and employers National Insurance values for the current period and also year to date values A Report Viewer gcspool 25137321 prt o lleas Report PYSS A Version 1 0 RTI FPS NI Extract Report Page 1 a Run Date TUE MAY 1 2012 10 22 SS SSS pel E nnani Mm Operator ID dm Time Date Requested 01 05 2012 10 22 Format RTI FPS NI Extract Report Time Date Printed z 01 05 20
67. en the NVR XML file is produced reports as detailed in this section are output to Print Manager 10 2 1 RTI NVR Extract Report When the NVR XML file is successfully created an NVR Extract report will be output to Print Manager as shown below PY9S A Version 1 0 RTI NVR Extract Report THU APR 19 2012 10 02 Report Options RTI NVR Extract Report Operator ID gt G7071 Time Date Requested 19 04 2012 10 02 HMRC Office 491 Time Date Printed 19 04 2012 10 02 AO Ref 473PQ11214673 X oprtitestOE101C rtisubmissions NVR NVR_O2_ 201202 LIVE 20120419100234 xml Birth Date Country 00000148 Mrs E Paterson WE987654A 234 Union Street 13 04 1978 South Africa Aberdeen 10 2 2 RTI NVR Exception Report If there are any validation errors an NVR Exception spooled report will be output as shown below PYSS A Version 1 0 RTI NVR Exception Report THU APR 19 2012 09 56 Operator ID Time Date Requested 19 04 2012 09 56 Format RTI NVR Exception Report Time Date Printed z 19 04 2012 09 56 PAYE Ref z 67070 Tax Year Period z 2012 03 HMRC Office 491 Payment Date z 29 06 2012 gt 473PQ11214673 THE FILE HAS NOT BEEN CREATED DUE TO THE FOLLOWING FAILED VALIDATION Payroll 4 Accreditation NI Tests Monthly Field Description 00111111 5013 Tax Code Invalid Tax Code Doc Version 2 3 Page 70 OP v8 14 3 User Guide 3 RTI User Guide Advanced 11 RTI Gateway Submission NVR 11 1 Su
68. ename X optestOE101C rtisubmissions eps EPS G7070 201311 LIVE 201309181 60725 xml ewww This RTI EPS file is still polling to HMRC s The Gateway Review program must be run to check the progress of the submission Note the report shown here is for an EPS The user can then use the Correlation ID detailed in the Report Options section of the report to check the progress of the submission via the Gateway Review program We recommend that you do not exit the program and that the submission is left to complete Page 49 OP v8 14 3 User Guide RTI User Guide E Advanced 7 3 1 Data Request The Data Request option in the RTI Gateway Submission program can be used to check the progress of an XML file submission which was exited before the polling process was completed 3 RTI Gateway Submission Messages Submission Date Request Response Received Process Finished Sending Data Request to HTI Gateway https secure dev gateway gov uk submission Collating information for submission to the RII Gateway S Subt Z Full Payment Submission Employer Payment Summary Sender ID 154756 E MINO Verfication Request Start Date 13 02 2013 End Date 13 02 2013 Earlier Year Update Start Time 08 30 00 End Time 16 25 11 fee rer Select the appropriate Sender ID from the drop down and also the RTI class that was submitted The Start Date and End Date fields will def
69. ent Value 1003 Natins Emper 57 971 29 1009 Gross Nlable 755 885_42 1014 Up to LEL 241 744 00 1015 LEL to PT 64 382 57 1016 PT to UAP 404 617 00 1017 UAP to UEL 3 495 34 1018 Dir Niable 1 050 65 1042 NetP Taxtrd 598 892 03 1071 Net Deducts 10 665 B4 1072 Pay Post T N 09 564 87 The Control Totals will give details of employees starting and leaving in the current period 14 4 BACS Extract Doc Version 2 3 A key feature of RTI is the association made between the RTI data being sent to HMRC and the payment made into an employee s bank account e through the BACS submission The link is made through what is known as the RTI BACS hash This payment information will assist with the Department of Work and Pension s administration of Universal Credits A change has been made to the standard BACS Extract program to generate a 4 character string if the BACS file is in the Standard 18 format A sample of the BACS file with the string as shown below 01005112523652000 0000000 BT2P0000315065Advanced Business Mr ow smith 01036653612485095 DO00000b PINPODOOSSO2S2Adwanced Business Mr T cruise 01033256451235099 pogode EVMGOOOd2 rL Adwanced Business Mr y Brynner 01041487512384000 00000000 MIrRPO0OD 9641 34cvanced Business Mr J Gyllenhaal 01004352455514000 00000000 MM P00002 2191 2acdvanced Business Mrs Connory he eae DD AAAA E Bowe ooeeachtanecad Bite 3 nac c Mr B Ditt Page 90 OP v8 14 3 User Guide RTI User Guide 3 A co
70. er Week 37 50 Hrs per Mth 9 00 Tax Periods Last Tax Per 4 Curr Tax Per 5 Leave Details Leave Date ed Leave Reason Back Next Apply Cancel The following fields are included on the FPS Extract gt Doc Version 2 3 Start Date This is only output to the FPS with the employee s first FPS i e when the receive their first payment Irregular Payment I ndicator This field should be selected for each employee paid on an irregular basis or less frequently than monthly For example casual seasonal employees or employees on maternity leave long term sick or leave of absence HMRC will automatically cease an employment if an FPS has not been submitted within a 3 month period for a particular employee This field should therefore be ticked to prevent HMRC from ceasing the employment of someone who is not paid regularly Note HMRC will NOT advise the employer that an employment has been automatically ceased Hours per Week Normal hours per week are to be reported in the FPS rather than actual hours per week The value held against this field will be reported on the FPS extract in bands of Up to 15 99 16 to 23 99 or 24 to 29 99 30 and over If there is a zero contract worker e g casual employee hours will be reported to HMRC as Other Page 24 OP v8 14 3 User Guide E RTI User Guide Advanced 5 2 Additional Statutory Paternity Pay Data With the intr
71. ersion 1 08 RTI FPS Employee Details Extract Report Page 1 Run Date FRI MAY 17 2013 11 18 Operator ID System Time Date Requested 17 05 2013 11 18 Format RTI FPS Employee Details Extract Report Time Date Printed z 17 05 2013 11 18 PAYE Ref 8129072 Tax Year Period z 2013 01 HMRC Office 961 Payment Date z 25 04 2013 AO Ref 961PB08129072 Payroll 2 File name X opliveOE102B rtisubmissions FPS FPS 8129072 02 201301 LIVE _20130517111826 xml 6 2 2 RTI FPS Employee Payments Extract Report This report details employee current period values There is a section at the foot of the report displaying payroll totals which will assist with the reconciling of values r 3 52252920 prt Notepad File Edit Format View Help Report PY95 A Version 1 08 RTI FPS Employee Period Extract Report Page 1 a Run Date MON OCT 22 2012 14 41 Report Options a Operator ID System Time Date Requested 22 10 2012 14 41 3 Format RTI FPS Employee Period Extract Report Time Date Printed 22 10 2012 14 41 PAYE Ref G7070 Tax Year Period 2013 01 HMRC Office 491 Payment Date 30 04 2013 AO Ref 473PQ11214673 Payroll sd File name Y optestoE101c rtisubmissions FPS FPS_0O1_201301_LIVE_20121022144139 xml Payroll 1 Monthly Taxable Non Tax NI Net Pay Pay After Taxable Employee Name Pay Payments Deductions Stat Deducts Benefits 00000
72. essageDetails gt lt SenderDetails gt lt Header gt lt GovTalkDetails gt lt Keys gt lt GovTalkErrors gt lt Error gt lt RaisedBy gt Department lt RaisedBy gt lt Number gt 3001 lt Number gt lt Type gt business lt Type gt lt Text gt The submission of this document has failed due to departmental specific business logic in the Body tag lt Text gt lt Error gt lt GovTalkErrors gt lt GovTalkDetails gt Doc Version 2 3 Page 48 OP v8 14 3 User Guide RTI User Guide ness Solutions e Advanced 7 3 Exiting During Submission Doc Version 2 3 If the user was to click on the Exit button during the submission the program will close however the FPS file will continue to submit to HMRC in the background The following message will be displayed Information 7 Clicking Exit will exit the RTI Gateway Submission program however polling to the HMRC will continue on your behalf To check the progress of this submission run the RTI Gateway Review Select OK A Gateway Submission Acknowledgement Report will be produced in the Print Manager as shown below Report py235rep Version 1 00 RTI EPS Gateway Submission Progress Report Run Date WED SEP 18 2013 16 08 30 Report Options Correlation ID 81264EC68AB8435BA8FC48609203C6F1 Operator ID Sender ID z ISvise Time DATE Requested 16 08 18 09 2013 PAYE Reference E7070 Time DATE Printed 16 08 18 09 2013 Fil
73. ev gateway gov uk poll lt ResponseEndPoint gt lt Transformation gt XML lt Transformation gt lt GatewayTest gt 1 lt CatewayTest gt lt GatewayTimestamp gt 2012 03 30T15 13 38 479 lt GatewayTimestamp gt lt MessageDetails gt lt SenderDetails gt lt Header gt lt GovTalkDetails gt lt Keys gt lt GovTalkDetails gt lt Body gt lt SuccessResponse xmlns auto nsl http www govtalk gov uk CM envelope xmlns http w inlandrevenue gov uk SuccessResp onse gt lt IRmarkReceipt gt lt dsig Signature xmlins dsig http www w3 org 2000 09 xmldsig gt m 7 2 3 RTI FPS Gateway Submission Rejection Report If the FPS XML file is rejected an FPS Gateway Submission Rejection report will be output to Print Manager as shown below Report gt py235rep Version 1 00 RTI FPS Gateway Submission Rejection Report Run Date WED JUN 2012 14 06 15 Report Options Correlation ID 7E87F834E7904E918FEGEDDIADEC80SD Operator ID System Sender ID Isvis Time DATE Requested 14 06 06 06 2012 PAYE Reference G7070 Time DATE Printed 14 06 06 06 2012 Filename X oprtitestOE101C rtisubmissions FPS FPS_ 01 201203 LIVE 20120606113948 xml business hd GovTalkMessage 1 hd Body 1 rti IRenvelope 1 zrti RTI 1 rti FullPaymentSub The LEAVINGDATE cannot be earlier than 6 April of the previous tax year Pleas e check Note the XML response file received from HMRC can be viewed in Print Manager
74. from existing batches including those that have been previously imported 2 EYU Amendments EYU Batch Employee Employee Employee 4000 5 Potter Mr H Amendment Amount 0 00 NI Category NI CAT A Amendments Create Seg Num Employee NI CAT SCON Amendment Amount E 4000 Student Loan Tax paid Remove Modify gt Employee Select employee that is to be amended from drop down gt Amendment Click on the Amendment drop down and select the field that is to be amended Available fields are e Tax Paid e Taxable Pay e Benefits Taxed via Payroll e EE Pen Net Pay Arrangements Before Tax e EE Pen Relief at Source After Tax e Trivial Commutation A Page 76 OP v8 14 3 User Guide RTI User Guide a Advanced e Trivial Commutation B e Trivial Commutation C e Student Loan e SSP e SMP e OSPP e SAP e ASPP gt Amount The amount that must be entered is the difference that is to be reported to HMRC E g if Taxable Pay T d submitted to HMRC in the final FPS of the tax year was 1000 00 but should only have been 750 00 then the amended value that should be entered is 250 00 Note if a further change is to be made after for the same field after the EYU has been submitted then both the original FPS value and subsequent EYU value should be taken into account when entering the new adjusted value gt NI Category Amendments Clicking the NI CAT button
75. hat do not conform to the specified format the import will be rejected and a Warnings Rejections spool report will be created detailing the errors in the file Continuing with the example the following rows should be entered on the Batch file using Employee No 1070 for the example column Row 1 Headey Row2 Row3 C AU Table student Loan T SSP Benefits Taxed via Payroll ee EE Pen Net Pay Arrangements Before Tax EE Pen Relief at Source a After Tax Trivial Comm Payment A Trivial Comm panen 8 Trivial Comm Payment SSCON o d Gross Earnings for MIES x upturn The file should then be saved as either a csv or txt file and the file can then be selected on the EYU Batch tab using the Filename field or Files directory Click the Import button and the data from the Batch file should be imported to the list on the Employee tab Rows can then be Modified or Deleted on screen and additional amendments can be added using the Manual Batch Entry method Once a Batch is complete selecting OK will save all changes to the current batch The batch can then be selected from the EYU Batch lookup at a later date if further changes need to be made Clicking Cancel will prompt a warning message warning that if the user continues they will lose all changes to the current batch Doc Version 2 3 Page 81 OP v8 14 3 User Guide RTI User Guide Di Advanced 12 2 Creating the EYU Extract Th
76. hich must be included within the FPS that IS Subsequently submitted to HMRC 14 6 Period End The Period End cannot be processed until the FPS for the current payroll has been Submitted to HMRC If any employees are found that should have had an FPS processed i e they have been processed in the current pay period but have a blank Date FPS Submitted an error message will be displayed as follows Information Full Payment Submission has not been submitted to HMRC for Payroll 1 The Period End error report will also inform the user that a FPS has not been Submitted to HMRC as shown below Doc Version 2 3 Page 91 OP v8 14 3 User Guide Doc Version 2 3 L d RTI User Guide 9 Business Solutions r x B Report Viewer gcspool 42740050 prt o amp amp Report py80 E Version 3 22 End of Period Error Report Page 1 Run Date MON AUG 27 2012 pd Bed Payroll 1 Advanced Business Solutions Period 5 31 08 2012 SS Se A A eee Operator ID System Time Date Requested 11 07 27 08 2012 Time Date Printed z 11 07 27 08 2012 Error Messages THE PERIOD END HAS FAILED Full Payment Submission has not been submitted to HMRC for Payroll 1 Font Scan Scan For S OK Help If no employees have been paid in the current period and therefore no FPS is Submitted the No employees paid this period field should be selected as shown below 52 Period End Mairi
77. int gt lt Transformation gt XML lt Transformation gt lt GatewayTest gt 1 lt GatewayTest gt lt GatewayTimestamp gt 2012 03 30T15 40 10 510 lt GatewayTimestamp gt lt MessageDetails gt lt SenderDetails gt lt Header gt lt GovTalkDetails gt lt Keys gt lt GovTalkDetails gt lt Body gt lt SuccessResponse xmlns auto nsl http ww govtalk gov uk CM envelope xmlns http ww inlandrevenue gov uk SuccessResp onse gt lt IRmarkReceipt gt lt dsig Signature xmlns dsig http ww w3 org 2000 09 xmldsigi gt lt dsig SignedInfo gt 4 IH L Doc Version 2 3 Page 65 OP v8 14 3 User Guide Adva nced Busness Solutions 9 2 3 RTI EPS Gateway Submission Rejection Report RTI User Guide If the EPS XML file is rejected an EPS Gateway Submission Rejection report will be output to Print Manager detailing the reason for rejection Report gt py235rep 7862 business Version 1 00 RTI EPS Gateway Submission Rejection Report Page 1 a Run Date THU APR 19 2012 09 53 59 pnan L o nanna Correlation ID 81AFDFBO6S89492F8FF B19F8D4FCFC1 Operator ID System Sender ID gt Isvise Time DATE Requested 09 53 19 04 2012 PAYE Reference G7070 Time DATE Printed z 09 53 19 04 2012 Filename X oprtitest0E101C rtisubmissions EPS EPS G7 070 201202 LIVE _20120419095053 xml hd GovTalkMessage 1 hd Body 1 rti IRenvelope 1 rti RTI 1 rti EmployerPaymen There mu
78. ion U Employer Scheme Reference gt Enable Statutory Recovery Comp Entry This allows EPS Employer Payment Summary information i e statutory recovery and compensation values to be manually entered overwritten at run time This must be ticked if payrolls attached to the same PAYE Reference are processed across different databases This should also be ticked if payrolls attached to the same PAYE Reference are processed externally e g by an Agent gt Std 18 BACS File If employees are paid by BACS i e the user has a Service User Number SUN and the BACS file used is Standard 18 format then this must be ticked If payment to employees is made via internet or telephone banking or CHAPS this should not be ticked Further details regarding BACS processing can be found later in this document gt Opt out of Run FPS after BACS The default is for the RTI extract program to open automatically with the FPS option pre selected ready for processing immediately after the BACS file has been created The user is able to opt out of this by going into the RTI System Parameter Maintenance screen and ticking the Opt Out of Run FPS after BACS Extract check box The opt out should however only be ticked if employees are not paid by BACS Doc Version 2 3 Page 12 OP v8 14 3 User Guide Doc Version 2 3 E RTI User Guide Disable NI Number Confirmation If ticked this will disable the NI Number Confirmation dialogu
79. is that HMRC cannot correct mistakes until the employer sends this information However under RTI employers and pension providers will tell HMRC about tax NICs and other deductions when or before the payments are made RTI aims to Make the PAYE process simpler for employers Reduce costs for HMRC and enable it to deal with non compliance such as late payment and debt collection more effectively Support the payment of Universal Credits Make PAYE more accurate for individuals over time reducing the number of bills and repayments sent after the end of the tax year Reduce tax credits error and fraud Y VV VW Employers and pension providers will send this information to HMRC Online 1 2 MPORTANT Employee Re numbering It is imperative that the correct employee numbers are submitted to HMRC within the Full Payment Submission FPS extract Where there has been a change of employee number the previous and new numbers MUST immediately be notified to HMRC via the FPS If HMRC are not immediately advised of the old employee number duplicate employee records will be automatically created in the HMRC back end systems This is absolutely critical where employees who have previously been submitted to HMRC on an FPS by another payroll software package are now being added manually or imported into OpenPeople Care therefore needs to be exercised for new customers implementing OpenPeople or existing customers who are taking ove
80. ise H Live tg Select Select All Search Number To enter a late reason highlight the employee and right click on the line This will open a box from where a late reason can be selected E Late Reason O Late Reason Code Description Correction to earlier submission Reasonable excuse No need for Deductions Work Sheet Impractical to report Micro Employer using temporary on or before relaxation Payment subject to Class 1 NICe but P110 P9D for tas Other Employment related security Payment to Expat by third party or overseas employer D 0 Im a Lancel Help Doc Version 2 3 Page 36 OP v8 14 3 User Guide Doc Version 2 3 RTI User Guide Advanced ATI File Agent Details Payments Declarations Scheme Ceased Employees Number Name Status Late Reason Papmt Date Selected gt 2 Ledger Mr H Live 3 Cruise Mr T Live 5 Gyllenhaal MrJ Live 7 Pitt Mr B Live Selected 10 Depp Mr Live 12 Johansson Miss 5 Live 13 Portman Mrs N Leaving this Pe 14 Carter Miss HB Live 16 Aniston Mz J Live 17 Bery Miss H Live If no payment date is entered the current period payslip date will be written to the FPS file As with the Full FPS if the payment date entered is before today a message will be displayed asking the user to enter a late reason As the payment date already passed this submission will be late Do you want to enter a Late Reason Select Yes to return to the scr
81. k gov uk CM envelope xmlns erp http ww govtalk gov uk CM errorresponse xmlns ht tp www govtalk gov uk CM envelope gt lt EnvelopeVersion gt 2 0 lt EnvelopeVersion gt lt Header gt lt MessageDetails gt lt Class gt HMRC PAYE RTI NVR lt Class gt lt Qualifier gt response lt Qualifier gt lt Function gt submit lt Function gt lt TransactionID gt lt AuditID gt lt CorrelationID gt SE0E9E791B844163AE870B180D81688E lt CorrelationID gt lt ResponseEndPoint Pollinterval 10 gt https secure dev gateway gov uk poll lt ResponseEndPoint gt lt Transformation gt XML lt Transformation gt lt GatewayTest gt 1 lt GCatewayTest gt lt GatewayTimestamp gt 2012 04 19T10 29 32 273 lt GatewayTimestamp gt lt MessageDetails gt lt SenderDetails gt lt Header gt lt GovTalkDetails gt lt Keys gt lt GovTalkDetails gt lt Body gt lt SuccessResponse xmlns auto nsl http w govtalk gov uk CM envelope xmlns http ww inlandrevenue gov uk SuccessResp onse gt lt IRmarkReceipt gt lt dsig Signature xmlns dsig http ww w3 org 2000 09 xmldsigi gt lt dsig Signedinfo gt lt dsig CanonicalizationMethod Algorithr http ww w3 org TR 2001 REC xml c14n 20010315 gt lt dsig SignatureMethod Algorithr http ww w3 org 2000 09 xmldsigirsa shal gt Page 72 OP v8 14 3 RTI User Guide User Guide RTI User Guide gt Advanced Busness Solutions 11 2 3 RTI NVR Gate
82. l fields as detailed below EPM6 Modified Scheme A special arrangement must be in place with HMRC before this scheme Should be selected If selected the following message will be displayed Warning i A special arrangement should be in place with HMRC before this A scheme should be selected European Economic Area Citizen This field should be selected if the employee is from a country in the EEA As shown above the user will be required to confirm that the employee s present circumstances have been confirmed If Yes is selected the Emergency Tax Code on a cumulative basis will be applied and the Information Confirmed field will be auto selected If No is selected tax code OT W1 M1 will be automatically applied Information Confirmed This field is automatically selected if the employee s present circumstances have been confirmed Page 20 OP v8 14 3 User Guide Doc Version 2 3 2 RTI User Guide New Starter Declaration New Starter Declaration This is my first job since 6th April Student Loan Indicator This ts currently my only job have another job or pension Information Confirmed If Seconded or OccPen Indicator is ticked the New Starter Declaration section will be disabled Any boxes that have been ticked before will be un ticked Only the Student Loan Indicator will be left active If Seconded and OccPen Indicator are both false and a new employee is added then
83. ll Payroll Monthly Ltd gt Payroll The current payroll description will be displayed by default For information on Sender Details Contact Details and Report Options see section 4 1 1 Doc Version 2 3 Page 68 OP v8 14 3 User Guide RTI User Guide 98 Advanced 10 1 2 Agent Details Tab See section 4 2 10 1 3 Employees Tab When creating an NVR XML file the Employees tab is enabled and the user must select an employee as shown below A Real Time Information Extract ATI File Agent Details Payments Declarations Scheme Ceased Employees Number Mame Status Late Reason Parmt Date Selected 20 T A New 111 Smith Mr H 112 T T New 1000002 Susep E N ew 1000003 Hmew Y N ew 1000000 Wilson gt New 10000007 Paterson Mr SG Hew Select Select All All employees with an employment status of NEW will be displayed by default If the user needs to verify the NI Number of any existing employees then they can do so by using the query icon Highlight the employee s to be included in the XML file and either double click to select or use the Select button Selected will appear in the appropriate column of the screen Click on Create File to generate the NVR file Note the Late Reason and Payment Date columns are only enabled for FPS Doc Version 2 3 Page 69 OP v8 14 3 User Guide 7 RTI User Guide Advanced Busness Solutions 10 2 NVR Reports Wh
84. mbination of the random string the originating and destination sort codes and the actual payment being made is then used to generate a 64 character RTI hash code This hash code updates the payslip record and is submitted to HMRC via the FPS extract This provides HMRC with the facility to validate RTI data by cross referencing the hashes generated by VocaLink once the BACS payment has been made The BACS Extract must be processed prior to creating each FPS XML file If an individual employee is recalculated which results in a new Net Pay then the BACS Extract must be reprocessed in order that a further RTI hash code can be generated Please check with your BACS supplier whether the BACS file you submit is a Std 18 BACS file and also whether they are supporting Real Time Information 14 5 Creating Submitting the FPS Extract When the FPS Extract is being processed a check will be done to ensure that the BACS Extract has been processed for the current payroll This must be submitted prior to running the Period End It will update an indicator against the employee RTI screen to flag that the FPS has been submitted Date FPS Submitted 29 09 2013 S If the Std 18 option is set against the RTI System Parameter Maintenance program see section 3 1 OpenPeople will not allow the FPS Extract to be created until the BACS file has been generated This is because it is the BACS Extract that is responsible for generating the RTI hash w
85. ment Submission radio button will have been automatically selected and file details will be pre populated If the Submit File option was not used on the RTI Extract runtime screen then select the Full Payment Submission radio option and then click on the Files button to browse to the relevant FPS XML file to be submitted Select the relevant FPS XML file and click on the Submit button The program will start submitting the date to the Government Gateway Check Print Manager for relevant reports Doc Version 2 3 Page 44 OP v8 14 3 User Guide D RTI User Guide Advanced Busness Solutions If Enable Submit File is ticked on the RTI System Record Maintenance program and there are employees included within the FPS that has been submitted with a status of Leaving This Period then on successful submission of the FPS file the P45 button will be enabled 3 RTI Gateway Submission Messages Submission Deleting RII Gateway messages ACCEPTED BY HMRC Polling for Response 20 09 2013 15 04 49 The Government Gateway has received the RII FPS return end is submitting it to HMRC on your behalf Please wait for a response or exit and review your submission later File To Submit C 4dvancedLOCAL Naov opliveltisubmissions FPS4FPS_Gi Files Full Payment Submission Employer Payment Summary NINO Verntication Request Earlier Year Update Data Request Click on the P45 button to open the P45
86. n Information Confirmed Occupational Pension OccPen Indicator Recently Bereaved Spouse Civil Partner Dependant Annual Pension 9 00 Date FPS Submitted 7 Back Next Apply Cancel The RTI tab is only available after the RTI system record has been set up Fields in the seconded new starter declaration and occupational pension sections are only enabled if the employee has an employment status of New This is because HMRC only want new starter information sent on an FPS along with the employee s first payment Previous Employment Details Previous Employment Details S Date P45 Recerved Date Left Prey Employ Tax Code At Leaving Date Moral U DU 0 Month Number U P45 Tax to Date 0 00 Week Number U P45 Pay to Date 0 00 F11 Tax Override Check Tax The fields detailed here are standard P45 3 fields If an employer receives a P45 3 from a new employee the previous employment details should be completed i e as they are currently When the Previous Employment Details section is completed the Seconded to work in UK from abroad section will be disabled After completing the Previous Employment Details section a statement must also be selected in the New Starter Declaration section based on information supplied by the employee Should the employee not supply the new starter declaration information along with the P45 3 default statements according to the tax
87. n an FPS for a particular employee then to correct this through an EYU submission the values for the original NI category should be negated and the new NI category and associated values added FPS was submitted in Tax Year 2012 with NI Cat Letter A but should have been letter C NI Cat Letter A ER NIC 535 00 EE NIC 456 00 Up to LEL 2320 00 LEL to PT 850 00 PT to UAP 3830 00 On EYU Batch tab select Tax Year 2012 On Employee tab select Employee then click on the NI Cat button to open the NI Category Amendments screen Doc Version 2 3 Page 78 OP v8 14 3 User Guide RTI User Guide Entries should be made as follows for both NI category A and C Always submit the difference and not the actual amount NI Cat Letter A ER NIC 535 00 EE NIC 456 00 Up to LEL 2320 00 LEL to PT 850 00 PT to UAP 3830 00 As Cat Letter is C EE NIC is 0 00 NI Cat Letter C ER NIC 535 00 Up to LEL 2320 00 LEL to PT 850 00 PT to UAP 3830 00 After amendments created for both NI Categories A and C they will be displayed in the list on the Employee tab Existing rows can be Modified or Deleted on screen and if required additional amendments can be added Once a Batch is complete selecting OK will save all changes to the current batch The batch can then be selected from the EYU Batch lookup at a later date if further changes need to be made Clicking Cancel will prompt a warning me
88. oduction of RTI there is now a requirement for mother or partner details to be reported if an employee is in receipt of ASPP Birth or ASPP Adoption If mother or partner details are not present the whole FPS file will be rejected The Forename 1 and Surname fields are mandatory in both screens shown below 5 2 1 ASPP Birth The Details of Mother tab has been amended as follows gt ASPP Birth Mr N McGregor ASPP Details Certification Details Details of Mother Notes Personal Details Work Details Forename 1 FENDER Employer s Name Forename 2 Address Sumame Address MI Number Apply 5 2 2 ASPP Adoption The Details of Principal Adopter tab has been amended as follows 3 ASPP Adoption New ASPP Details Certification Details Details of Principal Adopter Notes Personal Details Work Details Forename 1 Sally Employer s Mame Forename 2 Address Sumame Ford Address MI Number Doc Version 2 3 Page 25 OP v8 14 3 User Guide RTI User Guide 98 Advanced 5 3 EPS Data Items 5 3 1 Company Bank Details HMRC require bank account details used for payment of PAYE NI to be included within the EPS file These are held against the E R PAYE Reference program and are mandatory fields i e the EPS file will get rejected if bank details are not included 52 E R PAYE Ref Properties PAYE Pension AE RTI Notes HAYE References EXA PAYE Ref PAES PAE
89. ompensation on SAP S 0 00 NIC Compensation on ASPP 0 00 CIS Deduction Suffered z 0 00 Final Submission No ECON z HT 9 2 2 RTI EPS Gateway Submission HMRC Response An HMRC Response report showing the EPS XML file was successfully accepted will also be output to Print Manager as shown below m Report Viewer gcspool 18060032 prt r Report py23SrepXML Version 1 00 RTI EPS Gateway Submission HMRC Response Page Ja Run Date FRI MAR 30 2012 16 40 32 a a A A ee ee Correlation ID 08AC454DA9D2475596851FD778926FFA Operator ID dm Sender ID gt ISV156 Time DATE Requested 16 40 30 03 2012 PAYE Reference 67070 Time DATE Printed z 16 40 30 03 2012 m Filename C YearEndInstallshieldTest oplive rtisubmissions eps EPS_G7070_201202_LIVE_20120330163516 xml lt xml version 1 0 gt lt GovTalkMessage xmlns gti http www govtalk gov uk CM envelope xmlns erp http www govtalk gov uk CM errorresponse xmlns ht tp www govtalk gov uk CM envelope gt lt EnvelopeVersion gt 2 0 lt EnvelopeVersion gt lt Header gt lt MessageDetails gt lt Class gt HMRC PAYE RTI EPS lt Class gt lt Qualifier gt response lt Qualifier gt lt Function gt submit lt Function gt lt TransactionID gt lt AuditID gt lt CorrelationID gt 08AC454DA9D2475596851FD778926FFA lt CorrelationID gt lt ResponseEndPoint Pollinterval 10 gt https secure dev gateway gov uk poll lt ResponseEndPo
90. on Sender Details Contact Details and Report Options see section 4 1 8 1 2 Agent Details Tab See section 4 2 Doc Version 2 3 Page 54 OP v8 14 3 User Guide RTI User Guide 9 Ad vanced 8 1 3 Payments Tab When creating an EPS XML file the Payments tab is enabled as follows A Real Time Information Extract Le leas ATI File Agent Details Payments Declarations Scheme Ceased Employees Payments Tas Year hd ont 2014 01 z No employees paid this tax month Employment Allowance Submit Claim Y Stop Claim Statutory Payments Year to Date SMP Recovered OSPP Recovered SAF Recovered ASPF Recovered SMP Compensation OSPP Compensation SAP Compensation ASPP Compensation CIS Deductions Suffered Pernod of Inactivity From Final Submission For Tas ear Submit File Create File Exit Help Note SSP Recovered and NICs Holiday have been removed as of first 2014 EPS Submission Payments gt Tax Year Month The Tax Year Month displays the last period processed This is the last period that every payroll attached to the PAYE Reference that is to be processed has had the Period End processed i e where the Processed flag is set to yes against the period plan records Doc Version 2 3 Page 55 OP v8 14 3 User Guide Doc Version 2 3 gt 2 RTI User Guide No employees paid this tax month This should only be selected if no employees have been paid in
91. or Submitted before 19 of the month gt RTI Gateway Submission Submission of EPS Extract Ad Hoc gt RTI Creation of NVR Extract not mandatory Annual if appropriate gt RTI Creation of EYU Extract for previous year amendments gt RTI Gateway Submission Submission of EYU Extract not before 20 April Doc Version 2 3 Page 89 OP v8 14 3 User Guide 2 RTI User Guide 14 2 Payroll Calculation The Payroll Calculation is run in the normal manner i e one full Payroll Calculation must be processed per payroll per tax period Any number of full or individual Payroll Calculations may be processed in a particular pay period The only change to the actual Payroll Calculation logic is around the calculation of the new RTI statutory elements If a change is made to an employee after the full FPS has been submitted to HMRC for a particular pay period an individual FPS can be submitted or alternatively the latest figures can be submitted with the next available FPS HMRC preference is for the adjustments to be sent with next available full FPS e in the following pay period 14 3 Control Totals The Control Totals report will display the calculated values of RTI elements 1070 to 1081 Element values if appropriate will be output to the Costing and Memo section of the report In the example below elements 1071 Net Deducts and 1072 Pay Post T N are displayed A A Cost I NG E MEMO oo o Elem
92. ployer Payment Summary option within the RTI Gateway Submission program 8 1 5 Scheme Ceased Tab If RTI Class selected is EPS then Scheme Ceased tab is enabled 5 Real Time Information Extract ATI File Agent Details Payments Declarations Scheme Ceased Employees Scheme Ceased Scheme Ceased Scheme Date Ceased gt Scheme Ceased This is Optional The tick box should only be selected if a company stops trading during the current tax year gt Scheme Date Ceased Date must be entered if Scheme Ceased is ticked Doc Version 2 3 Page 60 OP v8 14 3 User Guide 2 RTI User Guide 8 1 6 Declarations Tab Doc Version 2 3 When Scheme Ceased is ticked the Declarations tab becomes enabled All fields on the Declarations tab are unticked and optional Confirmation tick must be true before Create File button is available 2 Real Time Information Extract P ATI File Agent Details Payments Declarations Scheme Ceased Employees Questions and Declarations Free of tas payments have been made to an employee Did anyone else pay expenses on in any way provide vouchers or benefits to any of your employees while they were employed by you during the pernod Did anyone employed by a person or company outside the LIK work for wou in the UK for 30 days or more in a row Have pou paid any of an employee s pay to someone other than the employee Completed forms
93. r If there are previous batches the system automatically increments the number by one each time Save Template Generates a template file in the correct format that can then be saved and used to make it easier to create an extract for subsequent import Filename Can manually enter filename of saved Batch file or select from Files button Import Actions Batch Import of data from selected Batch file EYU Batch Clicking on EYU Batch displays a lookup screen containing a list of all previously created EYU Batch names that match the current payroll on the OP session for the last 6 RTI years The user can select the EYU Batch name to update entries Entries are displayed in the list in Employee tab The user can select an EYU Batch name and click Delete to delete all entries under that EYU Batch name A dialogue box will pop up to confirm the deletion If the user clicks Yes the selected EYU Batch name and its related entries are deleted Page 75 OP v8 14 3 User Guide Doc Version 2 3 e RTI User Guide Advanced Employee tab Where updates to previous year s data are to be made for individual employees or to a small number of employees the screen below can be used to manually enter data to be reported on the EYU If there are changes to be reported for previous years relating to large number of employees the import function may be more suitable This screen is also be used to modify values
94. r the processing of PAYE References from elsewhere e g payroll bureau to ensure that old and new employee numbers are IDENTICAL or that the previous number is also notified via the FPS Please note the employee number format used by HMRC is an alpha rather than numeric format This means that an employee number that appears to be the Same across systems may actually be different For example an employee number of 1234 is different to an employee number of 00001234 OpenPeople will always output the full 8 digit number to the FPS extract i e including any leading zeros Where employees have changed employee number through the Employee Transfer program the old and current number will be automatically included within the FPS For additional information see PY0079 Import Previous PAYID doc available in the docs folder If you have any queries please contact Payroll Support for assistance Doc Version 2 3 Page 9 OP v8 14 3 User Guide RTI User Guide 2 Terminology Employer Alignment Submission extract of employee data which is submitted to HMRC for the purposes of aligning employee records with information held by HMRC This is a one off extract created and submitted per PAYE Reference The EAS must be submitted to HMRC before a FPS is created for any payroll within that PAYE Reference All employers must create and submit an EAS for each PAYE Reference regardless of number of employees To create and submit
95. rt eee 40 6 2 4 RTI FPS Starter Leaver Extract Report c see 41 6 2 5 RTI FPS Employee Details Extract Report see 41 6 20 RU PRS Exception REPO rnpicrcnana orar reta cibabs 42 6 2 7 RTI FPS Excluded Employees Report ccccccccce cess eeeeeeeeeeeeeeeeeeeeseeeeeauneeees 42 6 2 6 RTI FPSINDIV Reports ciccctcsccecieisedecatsnre A A ei sees 42 6 2 9 RTI FPSINDIV Employee Late Reason Report cccceeseeeeeeeeeeeeeeeeeeneneeees 43 7 RTI Gateway SUBMISSION FPS csssess esse sss ss esse ss ess sss sss sassa s assan sannan senenn ee 44 FS RT Is ar salts TNO access cen O er El O nn A 44 Tale Sent Olite 46 Doc Version 2 3 OP v8 14 3 User Guide RTI User Guide 122 FPS SUDMISSION RODOS vse sania aa tacetn ce eile a Men eed re iw akl one Makati da iiatie ee e a ee 46 7 2 1 RTI FPS Gateway Submission Acceptance Report eee 46 7 2 2 RTI FPS Gateway Submission HMRC Response ccccceeeeee eee eeeeeeeeeeeeeeeeeees 47 7 2 3 RTI FPS Gateway Submission Rejection Report cce e eee eeeeseeeeeeeeeeeeees 47 7 2 4 RTI FPS Gateway Submission HMRC Response c se e c e e e e e e e KeK 48 Ze REXIN DUNNO SUBMIS Ot caldeado 49 Lal Data Request E toe aE a 50 723 2 Gateway REVIEW E tia ias 51 8 Employer Payment Summary EPS sss sss sss sss sss ess esse sss esse sss rr rr rr 53 SPEEN e Er dolo dois 53 Oo Ll Re AAA nn A E EEE EEN 53 81 2 AYent Detalla id is Dios 54
96. s the relevant xml file is moved to the sent folder e g rtisubmission eps sent Doc Version 2 3 Page 51 OP v8 14 3 User Guide RTI User Guide 3 Note if the files being submitted to HMRC are compressed e the COMPRESS parameter is set against the RTI Extract program py95 then when the FPS extract IS run 2 separate files are generated the FPS file and an EmpData xml file It is the FPS file that should be selected in the Submitted File field When the successful Gateway Review Acceptance is received for a compressed file both the FPS and EmpData xml will be moved to the sent folder Doc Version 2 3 Page 52 OP v8 14 3 User Guide RTI User Guide 8 Employer Payment Summary EPS The EPS is generated outside the normal payroll processing cycle It must be created once per tax month per PAYE Reference It should be submitted to HMRC before the payment of Tax and NI is made over to HMRC i e by 19 of the month An EPS should be generated and submitted to HMRC in order to claim recovery of statutory payments NICs compensation on statutory payments or Construction Industry Scheme CIS deductions suffered An EPS is also to be used to advise HMRC that there have been no employees paid in the PAYE Reference in the relevant tax month 8 1 Creating the EPS 8 1 1 RTI File Tab gt Real Time Information Extract lo RTI File Agent Details Payments Declarations Scheme Ceased Employees
97. sed tab was available Removed section 4 1 3 re Scheme Ceased 26 3 2013 1 2 Graeme Walker Update guidance on when to create an EPS see section 6 29 9 2013 1 3 Graeme Walker 8 13 3 Updates e Added warning about notifying HMRC of old and new employee numbers section 1 3 New Enable Submit File and Contact table options on RTI System Record Maintenance 3 1 Ability to enter Contact and Agent Details and for these to be auto populated at run time 4 1 amp 4 2 New FPS compression option 6 Individual FPS option 6 1 3 RTI wizard Links added between RTI Extract RTI Gateway Submission and P45 Print programs 6 1 1 amp 7 1 RTI Gateway Review requirement to enter filename 7 3 2 Minor rewording around Processing Overview section 14 1 Doc Version 2 3 OP v8 14 3 User Guide RTI User Guide 25 2 2014 Graeme Walker Updated for OpenPeople 8 14 e Section 3 1 updates to RTI System Record Maintenance Section 5 1 3 updates to employee RTI screen and associated wording re fields enabled when employee is not New Section 5 1 4 updated Tax NI screen and associated wording re SCON Section 5 1 5 updated wording re new hours per week bandings New section 5 3 requirement for company bank details to be included within EPS Section 6 all RTI screens updated to reflect new Late Reason drop down Added wording around Late Reason Section 8 1 3 updated EPS screen R
98. ssage warning that if the user continues they will lose all changes to the current batch Doc Version 2 3 Page 79 OP v8 14 3 User Guide y RTI User Guide 12 1 1 2 Example Batch mport Note this is the same example as for the Manual Batch Entry example above If the wrong NI category letter had been submitted on an FPS for a particular employee then to correct this through an EYU submission the values for the original NI category should be negated and the new NI category and associated values added FPS was submitted in Tax Year 2012 with NI Cat Letter A but should have been letter C ER NIC 535 00 EE NIC 456 00 Up to LEL 2320 00 LEL to PT 850 00 PT to UAP 3830 00 On EYU Batch tab select Tax Year 2012 Then click Save Template button and create a batch file with the necessary NI Category amendments Template file will be created with the following descriptions as a header row and values can be entered in the specified formats otumn Description L COMET IO LG COME Ir EY J nens Ted vis Pero 999 EE Pen Net Pay Arrangements 9 9 99 Before Tax CN EE Pen Relief at Source After 9 9 99 Tax Tm rental Comm PaymentA aaa In rial Comm Payments 900 amaenn Payment o aaia ICON CT o o sew o E R Gross Earnings for nics aaa Doc Version 2 3 Page 80 OP v8 14 3 User Guide RTI User Guide column Description Foma UAP to UEL 9 5 99 If any values are entered t
99. st be an entry in at least one of ADVANCERECEIVEDFROMHMRC SSPRECOVER ED SMPRECOVERED OSPPRECOVERED SAPRECOVERED ASPPRECOVERED NICCOMPE NSATIONONSMP NICCOMPENSATIONONOSPP NICCOMPENSATIONONSAP NICCOMPENSATION ONASPP CISDEDUCTIONSSUFFERED or NICSHOLIDAY if PAYMENTFORPERIOD is prese nt Please check Note the XML response file received from HMRC can be viewed in Print Manager 9 3 Exiting During Submission Doc Version 2 3 See 7 3 Page 66 m OP v8 14 3 User Guide RTI User Guide gt Advanced 10 NINO Verification Request NVR The NINO Verification Request NVR XML file allows employers to validate or obtain National Insurance Numbers for their employees This can be run at any time during the payroll process Employers can request up to 100 National Insurance Numbers in a single Submission This is an HMRC restriction 10 1 Creating the NVR Select RTI Extract from the menu The following screen will be displayed 9 Real Time Information Extract lo Ez RTI File Agent Details Payments Declarations Scheme Ceased Employees File Details ATI Class NINO Verfication Request al Live 5 Test in Live File Hame MWR OPAES 85 201404 LIVE 207 40225124457 srl HAYE Reference Payroll Payroll Monthly Ltd Sender Details Sender ID 115441 Ab gt Sender Employer Contact Details
100. teway Review Messages Gateway Response Full Payment Submission Sender ID 5196 Employer Payment Summary Correlation ID 4E2BDAE 73446 47664610420 703BFFE4L O NINO Verification Request l Mii a TETE i gt Earlier Year Update Submitted File C vadvanced oplive tisubmissions fps FPS_G FOF File gt Select relevant RTI class i e FPS EPS NVR or EYU gt Select the appropriate Sender ID using the drop down gt Copy paste the Correlation ID from the Gateway Submission Acknowledgement Report or the Gateway Submission Data Request Report gt Click on the File button and select the relevant file from the corresponding RTI class directory Click on Submit to check progress of the XML file with this Correlation ID The RTI Gateway Review will commence polling to the Gateway to check the progress of the Correlation ID entered When the review is complete a message will be displayed on screen to advise that the XML submission has been accepted or rejected and a report created in Print Manager py236rep Version 1 00 RTI EPS Gateway Review Acceptance Report WED SEP 18 2013 16 09 30 Report Options Correlation ID 81264EC68AB8435BA8FC48609203C6F1 Operator ID Sender ID Time DATE Requested 16 09 18 09 2013 Time DATE Printed 16 09 18 09 2013 This RTI EPS file has been successfully sent to HMRC When a successful Gateway Review Acceptance is received for any RTI clas
101. tutory Adoption Pay compensation value for all payrolls included in the PAYE Reference The value shown is the year to date value ASPP Compensation This field is automatically populated with the total Additional Statutory Paternity Pay compensation value for all payrolls included in the PAYE Reference The value shown is the year to date value CIS Deductions Suffered This field should be manually completed if there are any CIS Deductions Period of Inactivity This should only be completed if payrolls within the PAYE Reference are not being processed for a period of time It will advise HMRC that no FPS s will be submitted over the date range entered The maximum period of inactivity that can be entered is 12 months gt From If entered this should be start of the next tax month To Enter date that period of inactivity finishes Final Submission gt From Tax Year This gets auto ticked in the final period of the tax year Page 57 OP v8 14 3 User Guide RTI User Guide Advanced Busness Solutions 8 1 4 Previous EPS Tab When RTI class Employer Payment Summary Previous is selected the Prev EPS tab will be enabled From this tab an EPS can be recreated relating to a previous tax year An EPS can be submitted to HMRC in the required format for up to the previous 6 years RTI File Agent Details Payments Prev EPS Declarations Scheme Ceased Employees File Details ATI Class
102. uded Employees report Bap rt 7 wera Version 1 36 ATI Fre Esployes Excluded Report Fage 1 re Mun Data 1 IUE JUW 24 2014 12 15 SE A mm 5 HEPOIT Opricon DAA A A A A A A A A A A A A Cparator IG 19 Time Dare aquesta 1 24D CUA 12716 Fa a BII FES Le lavas Exclietied Seaport iia Dite Printed 2d DO as 12 55 PAYE Saf S 67079 Tex Tear Period 3201404 RARE office 451 Payment Cate 1 BLOT ITA MO at APPO ETS Payrol E File mama CGT Li vee Opa eee Ce BrE oe eons TER EEE 9707001 2004048 TEL 201406 4171458 1 Late Season HA Payroll Keethly E jlayaa Hisa 655800839 Pise H E bb Depp Hr J Ll Fon Scan Scan For J DK Helo 6 2 8 RTI FPSINDIV Reports These are the same as 6 2 1 to 6 2 6 but for ease of identification are specific reports for individual FPS Doc Version 2 3 Page 42 OP v8 14 3 User Guide RTI User Guide Advanced 6 2 9 RTI FPSINDIV Employee Late Reason Report The FPSINDIV Employee Late Reason report shows the individual employees with their late reason and payment dates that have been entered on screen aeons FYESIA Version 1 36 ETI FRSINGY Employee Lace Basson Report an Bata THE JON fa 2014 12 15 ee E PI EI A A A ee o K a a P Gperacer 16 44 Tite Dace 26 mugarad 24 0 2014 12 13 Formar r RTI FPSS Enployas Late Beeson Raport Time Data Prince 3404 3014 13 15 FATE Ral ro E7070 Tas Years Period r 4910701 HSG Office Payee Data 1407 2014 AD
103. updates have been made to any of the statutory payment entries on the list the following warning message will be displayed Question Press HELP to view stack trace O Statutory payment entries have been modified for EPS 2013 Changing tax year will lose all changes Do you wish to continue If Yes is selected then all changes made will be removed If the user clicks No then the user will be reverted back to the previously selected tax year and the changes made will be retained Statutory Payments YTD When a tax year is selected the values for the relevant statutory payments YTD will be populated Depending on the tax year the respective statutory payments will be populated on screen Modify Highlighting the required Statutory Payment and then clicking on the Modify button will allow that value to be updated to the required value Once all necessary entries have been made the tick box I confirm the values entered are correct for all recoveries for the Tax Year must be selected the Create File button will be disabled until user ticks this check box Page 59 OP v8 14 3 User Guide RTI User Guide 9 Ad vanced gt Create File When selecting Create File an EPS XML extract for the selected tax year will be created in the format for that particular year The file should be Submitted in the usual manner either directly from the Submit File button or at a later time via the Em
104. way Submission Rejection Report If the NVR XML file is rejected an NVR Gateway Submission Rejection report will be output to Print Manager as shown below Report py235rep Version 1 00 RTI NVR Gateway Submission Rejection Report Run Date THU APR 19 2012 10 04 26 Report Options Correlation ID 87B07798074047C188CD827CD8B7E49D Operator ID Sender ID ISV156 Time DATE Requested 10 04 19 04 2012 PAYE Reference 67070 Time DATE Printed 10 04 19 04 2012 Filename C YearEndInstallshieldTest oplive rtisubmissions nvr NVR_04 201203 LIVE 20120419095546 xml hd GovTalkMessage 1 hd Body 1 rti IRenvelope 1 rti RTI 1 rti NINOverificati Value fl12chi doesn t have the correct format hd GovTalkMessage 1 hd Body 1 rti IRenvelope 1 rti RTI 1 rti NINOverificati Invalid content found at element Line Note the XML response file received from HMRC can be viewed in Print Manager 11 2 4 RTI NVR Gateway Submission HMRC Response An HMRC Response report showing that the NVR XML file was rejected will also be output to Print Manager as shown below py235repXML Version 1 00 RTI NVR Gateway Submission HMRC Response THU APR 19 2012 10 04 25 Report Options Correlation ID 87B07798074047C188CD827CD8B7E49D Operator ID Sender ID ISV156 Time DATE Requested 0 04 19 04 2012 PAYE Reference 7070 Time DATE Printed 0 04 19 04 2012 Filename C 1YearEndInstallshieldTestroplivelrtisubmissionsinvriNVR_04 201203 LIVE 2012041909

RTI - User Guide - Advanced Connect

Contents

Download Pdf Manuals

Related Search

Related Contents