File Specification for Payroll Software ROS

Document Sample
File Specification for Payroll Software ROS Powered By Docstoc
					P2C File Specification for Payroll Software 2006 to 2011
The file format is outlined below.

This file specification is applicable to Tax Years from 2006 to 2011 inclusive.
If you wish to receive tax credit certificates through the Revenue On-Line Service
register for ROS here


Tax Credit Header Record for Tax Year 2006 et seq

Field     Field Description   Size Location           Field           Notes
 No.                                                  Type
1       Record Type           2       1-2           Fixed     Value is HC
2       Tax Year              4       3-6           Numeric CCYY e.g. 2006
3       Employer Number       8       7-14          Text      e.g. 0000001B
4       Employer Name         30      15-44         Text
5       Date                  6       45-50         Numeric Format
                                                            DDMMYY
6       Label Year            4       51-54         Numeric CCYY e.g. 2006
7       Employer Unit Number 3        55-57         Numeric Zeros for 2004
                                                            onwards
8       Filler                188 58-245            Text      Not Used
        Total Length          245




Tax Credit Detail Record for Tax Year 2006 et seq

Field        Field      Size Location         Field             Notes
 No.      Description                         Type
1       Record Type     2     1-2           Fixed       Value is PC
2       PPS Number      9     3-11          Text        Format is 7 numerics
                                                        (including leading
                                                        zeros) check character
                                                        & Return Level - Space,
                                                        W, T or X
3       Standard Rate   6     12-17         Numeric Point at which
        Cut-Off Point                               Employer should start
                                                    deducting Tax at 42%.
                                                    Euro
4       Monthly Cut-    7     18-24         Numeric Point at which
        Off Point                                   Employer should start
                                                    deducting Tax at Higher
                                                    Rate of Tax. Euro and
                                                    cent
5       Weekly Cut-Off 6       25-30     Numeric Point at which
        Point                                    Employer should start
                                                 deducting Tax at Higher
                                                 Rate of Tax. Euro and
                                                 cent
6       Works            12    31-42     Text
        Number/Staff
        Number
7       Total Tax        6     43-48     Numeric Euros
        Credits
8       Monthly Tax      7     49-55     Numeric Euros and cent
        Credit
9       Weekly Tax       6     56-61     Numeric Euro and cent
        Credit
10      Date on which    6     62-67     Numeric Format DDMMYY
        Certificate
        Begins
11      Date on which    6     68-73     Numeric Format DDMMYY
        Certificate Ends
12      Week1 /          1     74        Numeric 1 = Week-one/Month-
        Month1                                   one or 0
        Indicator
13      Date of          6     75-80     Numeric Format DDMMYY
        Certificate
14      Surname          20    81-100    Text
15      First Name       20    101-120   Text
16      Address Line 1   30    121-150   Text
Field        Field       Size Location    Field           Notes
 No.      Description                     Type
17      Address Line 2   30    151-180   Text
18      Address Line 3   30    181-210   Text
19      Total Pay to     15    211-225   Numeric Euros and cent
        Date
20      Total Tax to     15    226-240   Numeric Euros and cent
        Date
21      Exemption        1     241       Text     Y/N
        Indicator
22      Standard Rate    2     242-243   Numeric Percentage
        of Tax
23      Higher Rate of   2     244-245   Numeric Percentage
        Tax
        Total Length     245
Tax Credit Trailer Record for Tax Year 2006 et seq

Field Field Description Size Location    Field           Notes
 No.                                     Type
1    Record Type         2     1-2      Fixed     Value is TC
2    Employer Number     8     3-10     Text      e.g. 0000001B
3    Total Standard     10     11-20    Numeric   Euro only
     Rate Cut-Off Point
4    Total Monthly       12    21-32    Numeric   Euro and cent
     Standard Cut-Off
     Point
5    Total Weekly        12    33-44    Numeric   Euro and cent
     Standard Cut-Off
     Point
6    Total Tax Credits   10    45-54    Numeric   Euro
7    Total Monthly Tax 12      55-66    Numeric   Euro and cent
     Credit
8    Total Weekly Tax    12    67-78    Numeric   Euro and cent
     Credit
9    Number of           5     79-83    Numeric
     Records
10   Filler              162 84-245     Text      Not Used
     Total Length        245

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:9/26/2012
language:Unknown
pages:3