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

1. Visit https://go.gov.sg/paysg-csv-template to download a CSV template.
2. Fill in the CSV template with the required columns:

   1. Payment reference

   2. Payer name

   3. Amount

   4. About payment

3. The following fields are optional:

   1. Address

   2. Identifier

   3. Email: Include the payer's email address if you require a payment email to be automatically sent after payment.

   4. Due date: For display only. Payment links will not automatically be cancelled after the due date.

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

5. 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’).

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

   2. Any errors in the CSV file will be added and available for download. Please refer to the error message to correct the errors before re-uploading for verification.

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

Bulk creation CSV template

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. [e-mail].

• '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.