Bulk Upload File🔗
You must use the Sample Template to create payouts using the Bulk Upload feature. This template is only for .csv
files. For customers using spreadsheets in .xls
format, click here to create payouts.
Watch Out!
• Before uploading the file for bulk upload, ensure that the cell data type is converted to plain text (if not already in plain text). Sometimes, sheets created using Google Sheets or other such applications are converted to scientific format, and such text is not accepted by the system.
• CSV uploads are recommended for files that contain more than 10,000 rows. Excel files that contain more than 10,000 rows are not processed.
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 RazorpayX Dashboard.
Handy Tips
Ensure the account number format is not changed when uploading the file.- Pass your virtual account number if you want money to be deducted from your virtual account.
- 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 ₹369.05.
Minimum ₹1 to be paid out. Only 2 decimals allowed.
Payout Currency
mandatory-
string
The currency in which the payout is being made. Here, it has to beINR
. 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 = vpa
useUPI
.account_type = bank_account
:NEFT
RTGS
IMPS
Payout Purpose
mandatory-
string
The purpose of the payout that is being created.Handy Tips
- This field is case-sensitive.
- Additional purposes for payouts can be created via the RazorpayX Dashboard, if required.
The following classifications are available in the system by default:
refund
cashback
payout
salary
utility bill
vendor 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 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. 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_account
vpa
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
.Handy Tips
Additional classifications can be created via the Dashboard, if required.The following classifications are available in the system by default:
vendor
customer
employee
self
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 40 characters.
notes[example text]
optional-
string
Notes for the details being imported. You can replace theexample 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.