Issuing payments using PayU via Excel sheet - easy and simple, just 1-2-3 steps! :- www.deekpay.com

Use your MS Excel files to make bulk payments without API integration in 3 easy steps.

API integration may be the smoothest way to execute payments, but it's certainly not the fastest. Imagine you run an online contest and need to distribute rewards to 500 winners. Or, you need to make weekly payments to your supplier or distribution partner. You know their bank account and/or UPI details, but who has the time to initiate thousands of transactions one after the other! This is where PayU's bulk payment feature comes in handy. It doesn't require any API integration; nor does it require you to provide beneficiary details one by one. Simply import the data into an Excel file, upload it to the PayU console, and voila! The payment will be processed in seconds.

Want to optimise your business' payment process? Sign up today to get started!

3 Easy Steps to Batch Payments:

1. Open your payment console and click on "Initiate Transfer".

Before initiating a payment, please make sure your balance is sufficient! Go to "Top Up" for steps to update your balance.

2. Download the sample template from the console and add your data

This file will contain all column headings and example data. Replace the example data with your beneficiary information and payment amount:MerchantReferenceID (required) - this is the unique ID used to identify each transaction.This is required so that you can look up this payment later. Please ensure that this is unique at the transaction level or the payment will not be processed.BatchID (required) - this is required from you so that you can identify batches for bulk uploads. Again, uniqueness at the file level is recommended, but we don't check on this aspect. amount (required) - this is the amount to be transferred. beneficiaryName (not required) - this is the name of the beneficiary. beneficiaryMobile (optional) - this is the beneficiary's mobile phone number. beneficiaryEmail (optional) - this is the beneficiary's email address. paymentType (Required) - This is the method that triggered the payment. It can be IMPS, NEFT, UPI, etc. beneficiaryAccountNumber (required if the method is IMPS, NEFT, RTGS) - this is the beneficiary's bank account number. beneficiaryIFSC (required if the method is IMPS, NEFT, RTGS (required if mode is IMPS, NEFT, RTGS) - this is the IFSC code of the beneficiary's bank account. beneficiaryVPA (required if mode is UPI) - this is the beneficiary's UPI ID. Purpose (required) - The information entered in this column will appear on the beneficiary's bank statement.

Ensure that the Excel file is formatted correctly and do not delete column headings. After filling in all the details, select the entire worksheet and change the format to "Text".

3. Uploading of Excel files

The maximum file size is 10MB and the maximum number of lines is 1000. Correctly formatted rows will be queued for processing. Such transactions can be viewed in the Payments tab of the console. Once the transaction is successful, each transaction will have a corresponding UTR number. If there are any errors, you can view them in the Error File in the console. For all failed transactions, the error details will be listed in each error file.

Still making payments manually? Start using PayU Payments to make your distribution instant and easy.

Conclusion:

Making regular or on-demand payments to multiple payees is a regular and important part of any business. You can optimise and track your spending by using the Excel sheet payment feature on PayU. Automation will not only save you time and reduce human error, it will also allow you to focus on other key business activities that only you can do best.PayU's batch payment feature will also provide a superior customer experience and ultimately help you grow your business. So, take action today!