Documentation
Test environmentLive environmentStatusContact us
  • Overview
    • Get started
    • Resource guides
      • For business users
      • For finance teams
      • For integration teams
    • Stripe onboarding
    • Live use cases
      • Usage overview
  • Start using the dashboard
    • Access
    • Payment services
    • Collaborators and access control
    • One-time payment links
      • Single link creation
      • Bulk link creation
      • Send payment links
      • Payment link page
      • Payment receipt email
    • Subscriptions
      • Set-up
      • View subscriptions
      • Manage subscriptions
    • Payments and refunds
      • Payment methods
      • Dashboard
      • Refunds
    • Payouts
    • Reports
    • Payment workflows with Plumber
      • Set-up
      • Testing
    • Payment forms
      • Set-up
      • Testing
      • Resources
  • Start an API integration
    • Get started
    • Endpoints
    • Integrating with your e-services
    • Errors
    • Idempotency
    • Pagination
    • Go-live checklist
  • API RESOURCES
    • Events
      • The event object
      • Types of events
    • Payments
      • Create a payment
      • Retrieve payments
      • Send email for payment
      • Cancel a payment
      • Refund a payment
      • Get all payments from payment service
  • WEBHOOKS
    • Introduction
    • Set-up
      • Events
      • Best practices
  • FAQ
    • Access
    • Costs
    • Timeline
    • API keys
    • API integration
    • Payments
    • Payment methods
    • Payouts and transaction fees
    • Refunds
    • Security and compliance
    • Downtime and maintenance
  • Policies
    • Privacy Policy
    • Terms of Use
Powered by GitBook
On this page
  • Interactive demo
  • Steps
  • Data Verification for Bulk Uploads

Was this helpful?

  1. Start using the dashboard
  2. One-time payment links

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.

PreviousSingle link creationNextSend payment links

Last updated 1 month ago

Was this helpful?

Interactive demo

Steps

  1. Fill in the CSV template with the required columns:

    1. Payment reference

    2. Payer name

    3. Amount

    4. About payment

  2. 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.

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

    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.

  4. 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.

Visit to download a CSV template.

PaySG will perform basic checks on the CSV file to ensure its integrity and accuracy (Note: Refer to the ).

https://go.gov.sg/paysg-csv-template
next section on ‘Data Verification for Bulk Upload’
Bulk creation CSV template