Bulk link creation

Bulk link creation is suitable when you need to create a large volume of payment links at once. It allows you to streamline the process and save time.

Interactive demo

Steps

Visit https://go.gov.sg/paysg-csv-template to download a CSV template.
Fill in the CSV template with the necessary information for generating the payment links in bulk, namely the payment reference, name, address, identifier, email address, amount, payment details and due date (optional).
Save the file and upload it to the ‘Bulk create links’ section on the payment service page.
PaySG will perform basic checks on the CSV file to ensure its integrity and accuracy (Note: Refer to the next section on ‘Data Verification for Bulk Upload’).
Any columns outside of the required fields will be added as custom information for each payment link.
If there are any errors in the CSV file, PaySG will add them to the file and return it to you for correction.
Once the CSV file passes the verification checks, PaySG will create the payment links in bulk.

Data Verification for Bulk Uploads

The following are potential error reasons you may be prompted with; do ensure you verify the data accuracy, integrity and formats accordingly for a successful bulk upload:

Payment Reference: In Microsoft Excel, numbers are limited to 11 digits of precision. If your 'Payment Reference' field is populated with a number of 12 digits or more, Excel automatically converts the data to scientific notation as a way to conform to that limit and it will be uploaded to PaySG in the same format (e.g. 1.04E+11). To prevent this, ensure that your cell is formatted as 'Text', or use a leading apostrophe (') before the data to ensure that Excel treats it as text, rather than a number.
'Payer Identifier must be less than 10 characters long': If payment will be made by an individual citizen, enter NRIC. NRIC is alphanumeric and consists of nine letters/digits. If payment will be made by a company, enter UEN. Unique Entity Number (UEN) is a 9- or 10-digit identification number.
'Email must be a valid email': The data verification process checks that the email domain is valid, e.g. johndoe@domain.com.sg.
'Amount must be at least 0.50. Amount must be less than 999,999.99. Must be a valid whole number or a number with 2 decimal places': To prevent possible error(s), ensure that all amounts entered are displayed with two decimal places. To prevent, for example, "40.10" automatically converting to "40.1" by Excel, ensure that your cell is formatted as 'Text', or use a leading apostrophe (') before the data to ensure that Excel treats it as text, rather than a number.
’Due Date must be a date string in the format DD-MMM-YYYY and must be between years 2021 and 2025., e.g. 01-Jan-2023': To prevent possible error(s), ensure that your cell is formatted as 'Text', or use a leading apostrophe (') before the data to ensure that Excel treats it as text, rather than reformatting the date.

PreviousSingle link creation NextSend payment links

Last updated 3 months ago

Steps

Visit https://go.gov.sg/paysg-csv-template to download a CSV template.

Fill in the CSV template with the necessary information for generating the payment links in bulk, namely the payment reference, name, address, identifier, email address, amount, payment details and due date (optional).

Save the file and upload it to the ‘Bulk create links’ section on the payment service page.

PaySG will perform basic checks on the CSV file to ensure its integrity and accuracy (Note: Refer to the next section on ‘Data Verification for Bulk Upload’).

Any columns outside of the required fields will be added as custom information for each payment link.

If there are any errors in the CSV file, PaySG will add them to the file and return it to you for correction.

Once the CSV file passes the verification checks, PaySG will create the payment links in bulk.

Data Verification for Bulk Uploads

The following are potential error reasons you may be prompted with; do ensure you verify the data accuracy, integrity and formats accordingly for a successful bulk upload:

Payment Reference: In Microsoft Excel, numbers are limited to 11 digits of precision. If your 'Payment Reference' field is populated with a number of 12 digits or more, Excel automatically converts the data to scientific notation as a way to conform to that limit and it will be uploaded to PaySG in the same format (e.g. 1.04E+11). To prevent this, ensure that your cell is formatted as 'Text', or use a leading apostrophe (') before the data to ensure that Excel treats it as text, rather than a number.

'Payer Identifier must be less than 10 characters long': If payment will be made by an individual citizen, enter NRIC. NRIC is alphanumeric and consists of nine letters/digits. If payment will be made by a company, enter UEN. Unique Entity Number (UEN) is a 9- or 10-digit identification number.

'Email must be a valid email': The data verification process checks that the email domain is valid, e.g. johndoe@domain.com.sg.

'Amount must be at least 0.50. Amount must be less than 999,999.99. Must be a valid whole number or a number with 2 decimal places': To prevent possible error(s), ensure that all amounts entered are displayed with two decimal places. To prevent, for example, "40.10" automatically converting to "40.1" by Excel, ensure that your cell is formatted as 'Text', or use a leading apostrophe (') before the data to ensure that Excel treats it as text, rather than a number.

’Due Date must be a date string in the format DD-MMM-YYYY and must be between years 2021 and 2025., e.g. 01-Jan-2023': To prevent possible error(s), ensure that your cell is formatted as 'Text', or use a leading apostrophe (') before the data to ensure that Excel treats it as text, rather than reformatting the date.