user guide commission offline validation program€¦ · the commission offline validation program...

1

User Guide

Commission Offline Validation Program

Guide on Commission Offline Validation Program

2

Contents

About Commission Offline Validation Program (OVP) ................................................................................................. 3

Hardware and Software Requirements ............................................................................................................................... 4

Step 1: Download Commission OVP .................................................................................................................................... 5

Step 2: Install Commission OVP ............................................................................................................................................. 7

Step 3: Preparation .................................................................................................................................................................... 9

Step 4: Submission ................................................................................................................................................................... 13

List of Common Error Messages .......................................................................................................................................... 18


3

About Commission Offline Validation Program (OVP)

1. The Commission Offline Validation Program (OVP) is a free software provided by IRAS for commission-paying

organisations to prepare and submit their commission earners’ commission information to IRAS electronically.

2. It allows commission-paying organisations to validate files (.xml) generated from their customised payroll

software before submitting to IRAS.


4

Hardware and Software Requirements

Ensure your computer fulfils the minimum hardware/ software requirements:

Operating System

Windows 7 and above

Hardware Requirements

Minimum 350 MB of free hard disk space (600 MB is recommended)

Software Requirements

Microsoft .NET Framework 4.0

Microsoft Excel 2007, 2010 and above


5

Step 1: Download Commission OVP

Click <e-Submission of

Commission>.

3. Preparation 4. Submission 1. Download Commission OVP

Click <Commission-Paying

Organisations>.

At IRAS’ website www.iras.gov.sg,

Select <e-Services>, <Businesses>.

2. Install Commission OVP

http://www.iras.gov.sg/


6

Scroll down and click <Submit

Commission Records>.

Under Submit with Customised

Software section, click

<Commission Application Version

2.0> to download and install the

application.

A dialog box will appear, click

<Run> to begin the download. If

you are using Google Chrome, click

<Keep>.

3. Preparation 4. Submission 1. Download Commission OVP 2. Install Commission OVP


7

Step 2: Install Commission OVP

Click <Next>.


To install to a different folder, click

<Browse>.

Click <Next>.


8

Click <Next> to start the

installation.

Once the installation is completed,

click close to exit the installation.

Read the Terms of Use. Select

<I Agree> and click <Next>.



9

Step 3: Preparation

Launch the application via Start >

All Programs > IRAS Commission

Application v2.0 or the shortcut on

your desktop. You can also launch

the application from the

designated folder where the

application was installed.

If you encounter the security

warning message upon the

launching the Commission

Application, click <Enable

Content>.

Note:

If the macro settings have been enabled

in your computer, you need not perform

the above step.

Click <Commission Offline

Validation Program> to proceed.

Click <Next>.



10

Select Batch Indicator accordingly.

- <Original File>: For yearly

submission of Commission

Records to IRAS.

- <Amendment File>: For

adjustment to the original

submission.

Click <Browse>.

Note:

Refer to User Guide for Amend

Submitted Records on how to prepare

and submit an amendment file.


Select the relevant file to validate.

Click <Open>.

Note:

The file generated should be in

Extensible Markup Language (.xml) file

format.

Click <Validate>. You can monitor

the validation progress through the

Validation Progress & Results status

bar.

If errors are detected:

Errors will be listed. Rectify the error(s)

within your customised payroll software

before re-generating a new file for

validation.

To save the list of errors in

spreadsheet for easy reference, click

<Export list to Excel>.

Note:

Refer to the file specification and contact

your vendor or IT department if you

need help to rectify the error(s).

C:\Users\Users\Desktop\Commission (2017).xml

https://www.iras.gov.sg/irashome/uploadedFiles/IRASHome/e-Services/Businesses/Commission-paying_Companies/User%20Guide%20for%20Preparing%20of%20Commission%20Amendment%20Records.pdf

https://www.iras.gov.sg/irashome/uploadedFiles/IRASHome/e-Services/Businesses/Commission-paying_Companies/User%20Guide%20for%20Preparing%20of%20Commission%20Amendment%20Records.pdf

https://www.iras.gov.sg/irashome/uploadedFiles/IRASHome/e-Services/Businesses/Commission-paying_Companies/File%20Specification_v3.0.pdf


11

If no error is detected

The application will display ‘File

validation is successful’.

Click <Next> to proceed to

summary page.


zzzzzzzzzz



Ensure Organisation’s Information, Year

of information, No. of Records and Total

amount of Gross Commission are

correct.

To print the summary, click <Print

Summary>.

Click <Generate .comm file> if all

information have been correctly

entered.

zzzzzzzzzz


12



zzzzzzzzzz

Browse and save the .comm file to

the desired location on your

computer and click <OK>.

zzzzzzzzzz

Click <Login to Submit> to upload

file for submission.

Note:

Your computer needs to be connected

to the internet. C:\Users\Users\Desktop\196900291N_1701022018COMM454241.comm


13

Step 4: Submission

At myTax Portal,

Select Log in for <Business Tax

Matters with CorpPass>.

Note:

Only staff authorised with ‘Approver’

role for the “SUBMISSION OF

COMMISSION RECORDS” e-Service will

be able to submit file to IRAS.

Authorisation must be done via

CorpPass. Learn how to authorise staff

via the CorpPass systems.


Enter <UEN/ENTITY ID>,

<CORPPASS ID> and <Password>.

Click <Login>.

https://mytax.iras.gov.sg/ESVWeb/default.aspx

https://www.corppass.gov.sg/

https://www.iras.gov.sg/irashome/uploadedFiles/IRASHome/e-Services/Businesses/Commission-paying_Companies/CorpPass%20Authorisation%20User%20Guide%20for%20Commission.pdf

https://www.iras.gov.sg/irashome/uploadedFiles/IRASHome/e-Services/Businesses/Commission-paying_Companies/CorpPass%20Authorisation%20User%20Guide%20for%20Commission.pdf


14

Mouse over to <More>.

Click <Submit Commission

Records>.


Organisations logging in for the first

time will need to update their contact

details.

Fill in the particulars.

Click <SAVE>.


15

Click <COMMISSION MAIN

MENU>.

2. Install Donation OVP 3. Preparation 4. Submission 3. Preparation 4. Submission 1. Download Commission OVP 2. Install Commission OVP

Under the Submission section, click

<UPLOAD FILE>.

Click <SELECT FILE>.


16


Select the ‘.comm’ file that was

generated from the OVP and click

<Open>.

You will be returned to ‘Upload

Commission File’ page. The selected file

will now be displayed for upload.

Ensure that you have selected the

correct year of information.

Click <UPLOAD> to submit the file.

Ensure that you have selected the

correct file for submission to IRAS.

Click <YES> to proceed.


17

How do I view submission status?

An acknowledgement page will be

displayed once you have successfully

submitted the commission records to

IRAS. Note the Submission Ref No. for

future reference.

You may click <COMMISSION MAIN

MENU> to return to Submit

Commission Records page.

ES18010218COMM537766518 01 FEB 2018 11:05 AM

To view your submission status, click

<VIEW> at the Submit Commission

Records page.

Select the year of Commission

derived in.

Click <SEARCH>. List of files

submitted will be displayed.

2. Install Donation OVP 3. Preparation 4. Submission 3. Preparation 4. Submission 1. Download Commission OVP 2. Install Commission OVP

196900291N_17010218COMM454241.comm

ES18010218COMM537766518 01 FEB 2018 11:05 AM


18

List of Common Error Messages

SN

Error Message Rectification

1 "Invalid Basis Year" The year must be in YYYY format.

This is the year in which income is accrued.

e.g. if the commission information is for the year of assessment (YA)

2018, the basis year is 2017.

Basis year can be up to 2 back years, 1 current year and 1 advance

year.

2 "Organisation Type must be 1 or 2" The Organisation Type must be '1' or ‘2’.

1 = Non-Stock Broking

2 = Stock Broking

3 "Incorrect Organisation ID Type and/or

ID No."

The Organisation ID Type must be one of the following:

7 = UEN-BUSINESS

8 = UEN-LOCAL CO

U = UEN-OTHERS

A = ASGD

I = ITR

Organisation ID must be valid and both prefix and check digit must

be in CAPS. E.g.: T01CC1234A

4 "Invalid Batch Date" The Batch Date must be in 'YYYYMMDD' format

This is the date when the file is created.

5 "Total number of records cannot be

reconciled"

Total number of records in Trailer must equal to total number of detail

records.

6 "Total Amount of Gross Commission

cannot be reconciled"

Total Gross Commission amount in Trailer must equal to total sum of

Gross Commission amount of detail records.

7 "Total Contra Loss Offset amount

cannot be reconciled"

Total Contra Loss Offset Amount in Trailer must equal to total sum of

Contra Loss Offset amount of detail records.

8 "Total Net Brokerage cannot be

reconciled"

Total Net Brokerage Amount in Trailer must equal to total sum of Net

Brokerage amount of detail records.

9 "Total Amount of Retention Money

Deducted cannot be reconciled"

Total Retention Money Deducted Amount in Trailer must equal to

total sum of Retention Money Deducted Amount of detail records.

10 "Invalid Nationality Code" The commonly used nationality codes are as follows:

301 = Singapore Citizen

303 = Indonesian

304 = Malaysian

305 = Filipino

306 = Thai


19

SN

Error Message Rectification

331 = Japanese

334 = Taiwanese

336 = Chinese (China)

110 = British

503 = American

701 = Australian

705 = New Zealander

Refer to IRAS’ website for the full list of nationality codes.

11 "Invalid Designation Code" Must be one of the following:

1 = Remisier

2 = Real Estate Agent

3 = Insurance Agent

4 = Distributor

5 = Financial Advisor

6 = Instructor

7 = Therapist

8 = Singapore Pools Retailers

9 = Others

12 "Invalid Date of Birth" The Date must be in 'YYYYMMDD' format.

13 "Invalid Amount of Gross Commission" Must be numeric and must not be blank nor contain space(s).

14 "Negative value is not allowed in

Original File"

Must not have negative amount entered in the Original File.

15 "Invalid Period of Payment Date From" The Date must be in 'YYYYMMDD' format.

16 "Invalid Period of Payment Date To" The Date must be in 'YYYYMMDD' format.

17 Period of payment must be in the same

year as the basis year in header

Year of commission in detail record must be the same as basis year

in header record.

18 "Invalid Net Brokerage Income" Amount must be numeric and must not have space(s).

19 "Invalid Contra Loss offset amount" Amount must be numeric and must not have space(s).

20 "Invalid Amount of retention money

deducted"

Amount must be numeric and must not have space(s).

21 "Illegal character found at <TagName>

in line no X."

To remove the invalid characters in the file.

Refer to IRAS’ website for list of acceptable characters.




20

Contact Information

For enquiries on this user guide, please call 1800 356 8015 or email [email protected].

Published by

Inland Revenue Authority of Singapore

Published on 12 Oct 2018

The information provided is intended for better general understanding and is not intended to

comprehensively address all possible issues that may arise. The contents are correct as at 12 Oct 2018 and

are provided on an “as is” basis without warranties of any kind. IRAS shall not be liable for any damages,

expenses, costs or loss of any kind however caused as a result of, or in connection with your use of this user

guide.

While every effort has been made to ensure that the above information is consistent with existing policies

and practice, should there be any changes, IRAS reserves the right to vary its position accordingly.

© Inland Revenue Authority of Singapore

mailto:[email protected]

user guide commission offline validation program€¦ · the commission offline validation program...

Documents