About the File Preparation Utility

FPU is a stand alone application which can be installed on a PC and will enable the User to create the monthly contribution file. The user need not prepare the complete file every time. For subsequent uploads, the intermediate file may be used after modification in relevant fields. FPU will also provide facility to open such files and edit at a later time for preparing subsequent months file.

Menus & Buttons

File - Open

This option can be used to open an intermediate file. On selection of this option system will display browser window to select the file stored at any location on the PC. Shortcut key to select the option is Ctrl + O

File - Save

This option can be used to save the digitised records as intermediary file. Shortcut key to select this function is Ctrl + S

File - Save As

This function can be used to save open file with another name at desired location.

Edit - Cut OR Edit - Copy & Edit - Paste

This series of functions can be used to Cut or Copy selected records from any line and than paste on desired line. Shortcut Keys for these functions are as follows: Edit : Cut : Ctrl + X Edit : Copy : Ctrl + C Edit : Paste : Ctrl + V Edit : Delete This function can be used to clear selection area Edit - Find A Find search function enables to search the entire records for specific keyword. This function can be accessed using shortcut key Ctrl + F Edit - Replace/Replace All This function search for the value specified and replaces it with the new value specified by user. Shortcut key for this function is Ctrl + R To replace one common field like month or Year in the file in the single run the user can use the Replace all option for replacing that common field. Edit - Paste from Excel This function is used to Paste the data selected from MS Excel. Copy the data from the excel sheet and select the place in the contribution file where the data to be pasted. Shortcut key for this function is Ctrl + Space

Command Button Create File

This button is to be used to create a Contribution File (.txt) and save the same at desired location

Command Button Add Rows

This button can be used to add specified no. of rows to the existing file

Command Button Delete a Row

This option can be used to delete specified row

Quitting the Application

To quit the File Preparation Utility user can select option File ? Exit or directly close the application using shortcut key Alt + F4

FIELD DESCRIPTION

Tab 1: PAO & Contribution File Details

Type of Contribution File

This is the drop-down option to select the type of file to be created. Two options are available namely Regular and Correction

Transaction ID

This field would be activated only if the option Correction is selected for field Type of Contribution File as mentioned above in point no. 2.1.1. In this field user shall enter
the Transaction Number of the previous file.

Pay & Accounts Office Reg. No.

User shall enter PAO Reg. No. provided by CRA. This is an mandatory field to create the file

Pay & Accounts Office Name

User shall enter PAO Office Name which is an optional field

Total DDO Count

Application will display total count of no. of DDOs present in the file. This is an auto generated field

Total Subscriber Records

Application will display count of total subscriber’s records. This is an auto generated field

Govt. Contribution

Application will display control total of Govt. Contribution field shown in Subscriber Details

Subscribers Contribution

Application will display control total of Subscriber’s. Contribution field shown in Subscriber Details

Tab 2: Subscriber Details

Select DDO Reg. No.

This is the drop-down option to select the particular DDO Reg. No. to view other details such as Total Subscribers records, Total Govt. Contribution etc. pertaining to that
DDO Id.

Subscriber Records in DDO

This is an auto generated number which will show total count of Subscriber Records for particular DDO if selected else count will be displayed for entire records

Govt. Contribution

This is an auto generated number which will show control total of Govt. Contribution Amount for particular DDO if selected else total will be displayed for entire records

Subscribers Contribution

This is an auto generated number which will show control total of Subscribers Contribution Amount for particular DDO if selected else total will be displayed for entire
records

Sr. No

This is a default line number or serial number of a record displayed at leftmost side. To delete a row user shall specify this number pertaining to the record For the columns below, the column numbers are indicated in brackets.

DDO Reg. No. (1)

User shall enter DDO Reg. No. allotted by CRA. This is a mandatory field to create the file

PRAN (2)

User shall enter Permanent Retirement Account Number allotted by CRA to each Subscriber. This is a mandatory field to create the file

Subscriber Name (3)

User shall enter Name of the Subscriber under this column. However, this field is optional.

Govt. Contribution (4)

User shall enter Amount of Govt. Contribution matching to the Subscribers Contribution for particular PRAN. This is a mandatory field.

Subscribers Contribution (5)

User shall enter Amount of Subscribers Contribution matching to the Govt. Contribution for particular PRAN. This is a mandatory field.

Pay Month (6)

User shall select Pay Month from drop-down list provided in the application. This is a Mandatory Field

Pay Year (7)

User shall select Pay Year from drop-down list provided in the application. This is a Mandatory Field

Contribution Type (8)

User shall select Contribution Type from drop-down list provided in the application. There are two options namely Regular and Arrears are provided. This is a mandatory field

Remarks (9)

User shall enter remarks if any. This field is mandatory in case where contribution type is Arrears