1
Twitter.com/IRAS_SG Facebook.com/irassg www.iras.gov.sg
User Guide for
“Donation Offline Validation
Program”
2
© 2015 Inland Revenue Authority of Singapore. All Rights Reserved.
Contents
1.
About Donation OVP
3
2.
Hardware and Software Requirements
5
3.
Download Donation OVP via
myTax Portal
7
4.
Install Donation OVP
15
5.
Validate Files
File prepared in .txt format
19
–
Error messages and rectification
30
File prepared in .csv format
34
3
© 2015 Inland Revenue Authority of Singapore. All Rights Reserved.
About Donation
Offline Validation Program (OVP)
The Donation OVP is used to validate the file format and data generated in both
.txt and .csv file from IPC own application. It helps to flag out invalid data so that
error(s) can be rectified before the file is transmitted to IRAS.
4
© 2015 Inland Revenue Authority of Singapore. All Rights Reserved.
Contents
1.
About Donation OVP
3
2.
Hardware and Software Requirements
5
3.
Download Donation OVP via
myTax Portal
7
4.
Install Donation OVP
15
5.
Validate Files
File prepared in .txt format
19
–
Error messages and rectification
30
File prepared in .csv format
34
5
© 2015 Inland Revenue Authority of Singapore. All Rights Reserved.
Hardware and Software Requirements
Minimum Hardware and Software Requirements
Pentium II or higher (Pentium III – Class recommended)
Minimum 350MB of free hard disk space (600MB is recommended)
Minimum 128MB RAM
Operating System : Windows Vista, Windows 7
Microsoft .NET Framework v4.0
6
© 2015 Inland Revenue Authority of Singapore. All Rights Reserved.
Contents
1.
About Donation OVP
3
2.
Hardware and Software Requirements
5
3.
Download Donation OVP via
myTax Portal
7
4.
Install Donation OVP
15
5.
Validate Files
File prepared in .txt format
19
–
Error messages and rectification
30
File prepared in .csv format
34
Download Donation OVP via
myTax Portal
Go to IRAS website
https://mytax.iras.gov.sg/ESVWeb/default.aspx
Select
<My Organisation’s/ Business’ Tax Matters>
Download Donation OVP via
myTax Portal
Enter SingPass ID and Password
Click
<Login>
Note: From Jul 2015, SingPass has been enhanced with improved user interface,
mobile-friendly features and stronger security capabilities. SingPass users will need to
Download Donation OVP via
myTax Portal
Perform one-time account update
Update your SingPass account in 3 Steps:
Enter your contact details
Verify your contact details
Set up your security questions
Complete all details and click <Continue> for each step. Click <Submit> after you have
completed step 3. Click <Ok> to redirect back to
myTax Portal
.
Note: If you have not changed your password within the past 2 years, you will be asked to
change your password upon login before performing the one-time account update.
9Download Donation OVP via
myTax Portal
Select the ID type and enter the organisation’s tax reference number
Click
<Login>
Download Donation OVP via
myTax Portal
Click
<Donation>
Download Donation OVP via
myTax Portal
Click
<Download Offline Validation Program>
Download Donation OVP via
myTax Portal
Click
<Offline Validation Program>
Click
<Run>
14
© 2015 Inland Revenue Authority of Singapore. All Rights Reserved.
Contents
1.
About Donation OVP
3
2.
Hardware and Software Requirements
5
3.
Download Donation OVP via
myTax Portal
7
4.
Install Donation OVP
15
5.
Validate Files
–
File prepared in .txt format
19
•
Error messages and rectification
30
–
File prepared in .csv format
34
Install Donation OVP
Click
<Next>
Read the Terms of Use. Select
<I Agree>
and click
<Next>
Install Donation OVP
Browse for the desired folder and click
<Next>
Click
<Next>
to start the installation
Install Donation OVP
Click
<Close>
to exit the installation
18
© 2015 Inland Revenue Authority of Singapore. All Rights Reserved.
Contents
1.
About Donation OVP
3
2.
Hardware and Software Requirements
5
3.
Download Donation OVP via
myTax Portal
7
4.
Install Donation OVP
15
5.
Validate Files
–
File prepared in .txt format
19
•
Error messages and rectification
30
–
File prepared in .csv format
34
Validate Files
Go to Start > Programs > Donation Offline Validation Program v3.1
Validate file with .txt extension
Click
<Next>
Validate file with .txt extension
Click
<Browse>
and select the .txt file to be validated
Click
<Open>
File with Error(s)
Click
<Validate>
Error(s) will be listed for your rectification
File with Error(s)
Save the error list to the desired drive
Save Errors to File
Error list is saved .csv. Double-click to open the file in Excel format
Successful Validation
Once the errors are rectified, proceed to validate the file again
Click
<Next>
if the validation is successful
Summary of File
Verify if the Organisation ID, Year of Donation, No of Records and Total amount of
donation are correct
Click
<Generate .don file>
Note: Each donation record with amount with cents (decimal places) will be rounded up
to the nearest dollar. eg. one record with amount = 100.50, the amount to be
Generate .don File
Save the .don file to your desired drive
Submit File
Click
<Login to Submit>
to upload the .don file to IRAS via
myTax Portal
29
© 2015 Inland Revenue Authority of Singapore. All Rights Reserved.
Contents
1.
About Donation OVP
3
2.
Hardware and Software Requirements
5
3.
Download Donation OVP via
myTax Portal
7
4.
Install Donation OVP
15
5.
Validate Files
–
File prepared in .txt format
19
•
Error messages and rectification
30
–
File prepared in .csv format
34
Error Messages (.txt file)
List of error messages
S/n Error Message Rectification
1 Invalid header record type Header record type must be ‘0’
2 Invalid source The source must be ‘7’
3 Invalid year of Information The year must be in YYYY format and must be the
year of donation records
4 Invalid type of information The type of information must be ‘07’
5 Invalid IPC’s ID type The type of IPC’s ID must be ‘0’
6 Invalid IPC’s ID no IPC’s ID must be valid and both prefix and check
digit must be in CAPS. eg. T01CC1234A
7 Invalid Trailer record type Trailer record type must be ‘2’
8 Total number of records cannot be
reconciled
Total number of records in Trailer must equal to total number of detail records
9 Total amount of donation cannot be
reconciled
Total donation amount in Trailer must equal to total sum of donation amount of detail records
Error Messages (.txt file)
List of error messages
31
S/n Error Message Rectification
10 Invalid Detail record type Detail record type must be ‘1’
11 Invalid. Please ensure both ID Type and ID
no. are given correctly
Both ID type and ID no must be correct. Both prefix and check digit must be in CAPS
12 Name must not be blank Donor’s name must not be blank
ID type ID format
01 (NRIC) SNNNNNNNC, TNNNNNNNC
02 (FIN) FNNNNNNNC, GNNNNNNNC
05 (UEN-Business) NNNNNNNNC (eg. 52912345A)
06 (UEN-Local Co) YYYYNNNNNC (eg. 200312345A)
35 (UEN-Others) TYYPQNNNNX,SYYPQNNNNC, RYYPQNNNNC (PQ = Entity Type, eg. T08LL1234A)
10 (ITR) NNNNNNNNNC (eg. 200112345X)
08 (ASGD) ANNNNNNNC (eg. A2500123J)
C = Check digit, N = Numeric
Error Messages (.txt file)
List of error messages
S/n Error Message Rectification
13 Invalid amount Donation amount must not be blank or zero value
14 Please ensure the year of donation is
matched with year of information in the header record
Year of donation in detail record must be the same as year of information in header record
15 Invalid type of donation The type of donation must be one of the
following and should be in CAPS: O – Outright Cash S – Shares/Unit Trust A – Artifact L – Land/ Building P – Public sculpture C - Computer
16 Invalid naming donation The type of donation must be one of the
following and should be in CAPS: Z – Non-naming donation
N – Name IPC F – Name facility
17 Illegal characters found To remove invalid characters used
33
© 2015 Inland Revenue Authority of Singapore. All Rights Reserved.
Contents
1.
About Donation OVP
3
2.
Hardware and Software Requirements
5
3.
Download Donation OVP via
myTax Portal
7
4.
Install Donation OVP
15
5.
Validate Files
–
File prepared in .txt format
19
•
Error messages and rectification
30
–
File prepared in .csv format
34
Validate Files
Go to Start > Programs > Donation Offline Validation Program v3.1
Validate file with .csv extension
Click
<Next>
Validate file with .csv extension
Click
<Browse>
and select the .csv file to be validated
Click
<Open>
Note: file extension must be in .csv
Files with Error(s)
Click
<Validate>
Error(s) will be listed for your rectification
To save the error list, click
<Save Errors to File>
Save Errors to File
Save the error list to the designated drive
Save Errors to File
Error list is saved in .csv. Double-click to open the file in Excel format
Successful Validation
Once the errors are rectified, proceed to validate the file again
Click
<Next>
once the validation is successful
Summary of File
Verify if the Organisation ID, Year of Donation, No of Records and Total amount of donation
are correct
Proceed to click
<Generate .don file>
Note: Each donation record with amount with cents (decimal places) will be rounded up
to the nearest dollar. eg. one record with amount = 100.50, the amount to be
Generate .don file
Save the .don file to the desired drive
Submit File
Click
<Login to Submit>
to upload the .don file to IRAS via myTax Portal
44
© 2015 Inland Revenue Authority of Singapore. All Rights Reserved.
Contents
1.
About Donation OVP
3
2.
Hardware and Software Requirements
5
3.
Download Donation OVP via
myTax Portal
7
4.
Install Donation OVP
15
5.
Validate Files
–
File prepared in .txt format
19
•
Error messages and rectification
30
–
File prepared in .csv format
34
Error Messages (.csv file)
List of error messages
S/n Error Message Rectification
1 Invalid file format. Please ensure there are
only 6 columns in the header
Column G to N of header record (first row) must be blank
2 Invalid file format. Please ensure there are
only 14 columns in the detail record(s)
There should be only 14 columns (A to N) in the file. Any extra value after column N is to be removed
3 Comma(s) are not allowed. Please remove
from this particular row
To remove comma(s) found in the records
4 Invalid file format. Please ensure there are
only 3 columns in trailer
Column D to N of trailer record (last row) must be blank
5 Invalid header record type Header record type must be ‘0’
6 Invalid source The source must be ‘7’
7 Invalid year of Information The year must be in YYYY format and must be the
year of donation records
8 Invalid type of information The type of information must be ‘7’
9 Invalid IPC’s ID type The type of IPC’s ID must be ‘0’
10 Invalid IPC’s ID no IPC’s ID must be valid and both prefix and check
digit must be in CAPS. eg. T01CC1234A
S/n Error Message Rectification
11 Invalid Trailer record type Trailer record type must be ‘2’
12 Total number of records cannot be
reconciled
Total number of records in Trailer must equal to total number of detail records
13 Total amount of donation cannot be
reconciled
Total donation amount in Trailer must equal to total sum of donation amount of detail records
14 Invalid Detail record type Detail record type must be ‘1’
15 Invalid. Pls ensure both ID Type and ID no.
are given correctly
Both ID type and ID no must be correct. Both prefix and check digit must be in CAPS
Error Messages (.csv file)
List of error messages
46
ID type ID format
01 (NRIC) SNNNNNNNC, TNNNNNNNC
02 (FIN) FNNNNNNNC, GNNNNNNNC
05 (UEN-Business) NNNNNNNNC (eg. 52912345A)
06 (UEN-Local Co) YYYYNNNNNC (eg. 200312345A)
35 (UEN-Others) TYYPQNNNNX,SYYPQNNNNC, RYYPQNNNNC (PQ = Entity Type, eg. T08LL1234A)
10 (ITR) NNNNNNNNNC (eg. 200112345X)
08 (ASGD) ANNNNNNNC (eg. A2500123J)
C = Check digit, N = Numeric
Error Messages (.csv file)
List of error messages
S/n Error Message Rectification
16 Name must not be blank Donor’s name must not be blank
17 Invalid amount Donation amount must not be blank or zero value
18 Please ensure the year of donation is
matched with year of information in the header record
Year of donation in detail record must be the same as year of information in header record
19 Invalid type of donation The type of donation must be one of the
following and should be in CAPS: O – Outright Cash S – Shares/Unit Trust A – Artifact L – Land/ Building P – Public sculpture C - Computer
20 Invalid naming donation The type of donation must be ‘Z’ and should be in
CAPS
21 Illegal characters found To remove invalid characters used
48
© 2015 Inland Revenue Authority of Singapore. All Rights Reserved.
End of User Guide for Donation OVP
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 18 Dec 2015 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 our position accordingly.
