To create payouts in bulk, you must first upload the all payout details such as the account number, payout amount, currency, mode, and so on to the
.To process bulk payouts, you must:
- Download the .
- Fill in the data as per the .
- Upload the file using available on RazorpayX.
Watch Out!
Before you upload the file using Bulk Upload, ensure that the cell data type is converted to plain text. Sometimes, sheets created using Google Sheets or other such applications are converted to scientific format, which is not accepted by the system.
Find the sample templates for .csv and .xls file types below.
Watch Out!
.xls files that contain more than 10,000 rows are not processed.
| File Type | Sample Template |
|---|---|
.csv (> 10,000 rows) | |
.xls (< 10,000 rows) |
The table below lists the various required fields in the template and gives a brief description of each field.
RazorpayX Account Number
mandatory
string The account from which you want to make the payout. For example, 7878780080316316.
Account details can be found on the
Handy Tips
Ensure the account number format is not changed when uploading the file.
- Pass your customer identifier if you want money to be deducted from your RazorpayX Lite.
- Pass your Current Account number if you want money to be deducted from your Current Account.
Payout Amount
mandatory
number The amount, in INR, to be transferred from the business account to the contact's Fund account.
- Enter 369.05 to create a payout for the amount ₹369.05.
- You cannot pay any amount less than ₹1.
- Only upto 2 decimals is allowed. If your amount reads 1.495, round it off to the nearest value to retain only two decimals.
Payout Currency
mandatory
string The currency in which the payout is being made. Here, it has to be INR.
Payout Mode
mandatory
string The mode that should be used to make the payout.
Watch Out!
The payout modes are case sensitive. When creating payouts using APIs, ensure payout modes are entered in upper case.
account_type = vpauseUPI.account_type = bank_account:NEFTRTGSIMPS
Payout Purpose
mandatory
string The purpose of the payout that is being created.
Handy Tips
- This field is case-sensitive.
- Additional via the , if required.
The following classifications are available in the system by default:
refundcashbackpayoutsalaryutility billvendor bill
Payout Narration
optional
string This is a custom note that also appears on the bank statement.
Maximum length 30 characters. Allowed characters are: a-z, A-Z. 0-9 and space.
Handy Tips
- If no value is passed for this parameter, it defaults to the Merchant Billing Label.
- Ensure the most important text in the first 9 characters as banks may truncate the rest as per their standards.
Payout Reference Id
optional
string A user-generated reference given to the payout. For example, Acme Transaction ID 12345.
Maximum length is 40 characters.
You can use this field to store your own transaction id, if any.
Fund Account Id
conditionally mandatory
string The unique id linked to a Fund account. For example, fa_00000000000001.
Handy Tips
This field is mandatory if you want to make a payout to an existing Fund account. This way you do not need to provide other Fund account and contact details. Know more about
.Fund Account Type
mandatory if Fund Account id not given
string The type of account to be linked to the customer id. Possible values:
bank_accountvpa
Fund Account Name
mandatory if Fund Account id not given and Fund Account Type = bank_account
string Name of the account holder as per bank records.
For example, Gaurav Kumar.
Fund Account Ifsc
mandatory if Fund Account id not given and Fund Account Type = bank_account
string Bank IFSC of the account number.
For example, HDFC0000053.
Fund Account Number
mandatory if Fund Account id not given and Fund Account Type = bank_account
string Beneficiary account number.
For example, 765432123456789.
Fund Account Vpa
mandatory if Fund Account id not given and Fund Account Type = vpa
string The virtual payment address. For example, gauravkumar@upi.
Contact Type
mandatory if Fund Account id not given
string The classification of contact that is being created. For example, employee.
The following classifications are available in the system by default:
vendorcustomeremployeeself
Contact Name
mandatory if Fund Account id not given
string Name of the contact. For example, Gaurav Kumar.
Contact Email
optional
string Email address for the contact.
For example, gaurav.kumar@example.com
Contact Mobile
optional
string. Phone number for the contact. For example, 9123456789.
Contact Reference Id
optional
string A user-generated reference given to the contact. For example, Acme Contact ID 12345.
Maximum length is 40 characters.
notes[example text]
optional
string Notes for the details being imported. You can replace the example text in the header with text of your choice. You can add up to 15 notes. Text in the header is the title and text in the cell is the value for the note.