{"id":9169,"date":"2020-12-02T16:57:59","date_gmt":"2020-12-02T11:27:59","guid":{"rendered":"https:\/\/payu.in\/blog\/?p=9169"},"modified":"2026-01-14T12:51:40","modified_gmt":"2026-01-14T07:21:40","slug":"sending-payouts-through-your-excel-sheet-via-payu-as-easy-as-1-2-3","status":"publish","type":"post","link":"https:\/\/payu.in\/blog\/sending-payouts-through-your-excel-sheet-via-payu-as-easy-as-1-2-3\/","title":{"rendered":"How to Make Bulk Payouts Using Excel in 3 Easy Steps"},"content":{"rendered":"<p><strong>Use your MS Excel File to make bulk payouts in 3 easy steps without any API Integration<\/strong><\/p>\n<p>API integration might be the smoothest way to do payouts, but it is certainly not the quickest. Imagine that you\u2019ve run an online competition and you want to distribute rewards to 500 winners. Or, you need to make weekly payouts to your vendors or delivery partners. You know their bank account and\/or UPI details, but who has the time to initiate thousands of transactions one by one! This is where PayU\u2019s <a href=\"https:\/\/blog.payumoney.com\/disburse-bulk-payments-in-minutes-with-payu-payouts\/\" target=\"_blank\" rel=\"noopener\">bulk payout<\/a> feature comes to the rescue. It doesn\u2019t require any API integration; it doesn\u2019t need you to provide beneficiary details one by one. Just dump the data in an Excel file, upload it on PayU dashboard and voila! The payouts are processed within seconds.<\/p>\n\n\n<p> Want to streamline payouts in your business? <a href=\"https:\/\/onboarding.payu.in\/app\/account\/\">Sign up to get started! <\/a><\/p>\n\n\n\n<p><strong>Make Bulk Payouts in 3 simple steps<\/strong><\/p>\n\n\n\n<ol>\n<li>Open your Payouts Dashboard and Click on \u201cMake a transfer\u201d.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"438\" src=\"https:\/\/payu.in\/blog\/wp-content\/uploads\/2026\/01\/a-1-1024x560-1.jpg\" alt=\"\" class=\"wp-image-14401\"\/><\/figure>\n\n\n\n<p>Do ensure you have sufficient balance before you initiate payouts! Go to \u201cAdd Money\u201d for steps to update balance.<\/p>\n\n\n\n<p>2. Download Sample Template from the Dashboard and add your data<\/p>\n\n\n\n<ul>\n<li>This file will contain all the column headers with sample data\n<ul>\n<li>Replace the sample data with the details of your beneficiaries and amounts to be paid:\n<ul>\n<li>MerchantReferenceID (Mandatory) \u2013 This is a unique ID to identify each transaction. This is a must so that you can refer to this payout at a later stage. Please make sure that this is unique at a transaction level, otherwise the payout won\u2019t get processed<\/li>\n\n\n\n<li>BatchID (Mandatory) \u2013 This has to be provided by you so that you can identify the batch of bulk upload. Again, it is recommended that this should be unique at a file level; however there are no checks from our side on this<\/li>\n\n\n\n<li>Amount (Mandatory) \u2013 This is the amount which needs to be transferred <\/li>\n\n\n\n<li>beneficiaryName (Not Mandatory) \u2013 This is the name of the beneficiary <\/li>\n\n\n\n<li>beneficiaryMobile (Not Mandatory) \u2013 This is the mobile number of beneficiary <\/li>\n\n\n\n<li>beneficiaryEmail (Not Mandatory) \u2013 This is the email ID of beneficiary <\/li>\n\n\n\n<li>paymentType (Mandatory) \u2013 This is the mode with which Payout is to be triggered. It can be IMPS, NEFT, UPI, etc<\/li>\n\n\n\n<li>beneficiaryAccountNumber (Mandatory if mode is IMPS, NEFT, RTGS) \u2013 This is Bank Account Number of the beneficiary <\/li>\n\n\n\n<li>beneficiaryIFSC (Mandatory if mode is IMPS, NEFT, RTGS) \u2013 This is the IFSC code of the beneficiary\u2019s bank account <\/li>\n\n\n\n<li>BeneficiaryVPA (Mandatory if mode is UPI) \u2013 This is the UPI ID of the beneficiary <\/li>\n\n\n\n<li>Purpose (Mandatory) \u2013 The information entered in this column will reflect in the bank statement of the beneficiary  <\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul>\n<li>Ensure\nthat the Excel file is in the right format\n<ul>\n<li>Do\nnot remove the column headers<\/li>\n\n\n\n<li>Once\nyou have filled in all the details, select the entire sheet and change the\nformat to \u201cText\u201d<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"588\" src=\"https:\/\/payu.in\/blog\/wp-content\/uploads\/2020\/12\/b-1024x588.png\" alt=\"\" class=\"wp-image-9171\" srcset=\"https:\/\/payu.in\/blog\/wp-content\/uploads\/2020\/12\/b-1024x588.png 1024w, https:\/\/payu.in\/blog\/wp-content\/uploads\/2020\/12\/b-150x86.png 150w, https:\/\/payu.in\/blog\/wp-content\/uploads\/2020\/12\/b-300x172.png 300w, https:\/\/payu.in\/blog\/wp-content\/uploads\/2020\/12\/b-768x441.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><br><\/figcaption><\/figure><\/div>\n\n\n3. Upload the Excel file\n\n\n\n<ul>\n<li>Maximum file size can be 10 mb and maximum number of rows can be 1000<\/li>\n\n\n\n<li>Payouts will be queued for the rows in proper format. Such transactions can be viewed in the Payouts tab of the Dashboard. Once the transaction is successful, a UTR number can be found corresponding to every transaction<\/li>\n\n\n\n<li>In case of any errors, check them in the error file from the dashboard. For all the failed transactions, error details will be mentioned against each error file.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"562\" src=\"https:\/\/payu.in\/blog\/wp-content\/uploads\/2020\/12\/c-1024x562.png\" alt=\"\" class=\"wp-image-9172\" srcset=\"https:\/\/payu.in\/blog\/wp-content\/uploads\/2020\/12\/c-1024x562.png 1024w, https:\/\/payu.in\/blog\/wp-content\/uploads\/2020\/12\/c-150x82.png 150w, https:\/\/payu.in\/blog\/wp-content\/uploads\/2020\/12\/c-300x165.png 300w, https:\/\/payu.in\/blog\/wp-content\/uploads\/2020\/12\/c-768x421.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>Still doing your payouts manually? Start using <a href=\"https:\/\/payu.in\/payment-solutions\/payouts\">PayU Payouts<\/a> and make your disbursements instant and easy.<\/p>\n\n\n\n<p><em><a href=\"https:\/\/payu.in\/blog\/what-are-payouts-meaning-types-examples\/\">Read more &#8211; What Are Payouts? Meaning, Examples, Types<\/a><\/em><\/p>\n\n\n\n<p><strong>Conclusion:<\/strong><\/p>\n\n\n\n<p>Payouts to\nmultiple recipients on a regular or need basis are a routine and important part\nof any business. You can streamline and track your outflows by using the Excel sheet\nPayout feature on PayU. Automation will not only save you time and eliminate\nhuman errors,&nbsp; but also free up your\nmind-space for other critical business activities that you alone can do best! The\nPayU Bulk Payouts feature also offers a great customer experience, and\nultimately helps you grow your business. So, get started today!<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/onboarding.payu.in\/app\/account\/\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"82\" src=\"https:\/\/payu.in\/blog\/wp-content\/uploads\/2020\/08\/signup-v2-1.png\" alt=\"\" class=\"wp-image-8905\" srcset=\"https:\/\/payu.in\/blog\/wp-content\/uploads\/2020\/08\/signup-v2-1.png 300w, https:\/\/payu.in\/blog\/wp-content\/uploads\/2020\/08\/signup-v2-1-150x41.png 150w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/figure><\/div>","protected":false},"excerpt":{"rendered":"<p>Use your MS Excel File to make bulk payouts in 3 easy steps without any API Integration API integration might be the smoothest way to do payouts, but it is&#8230;<\/p>\n","protected":false},"author":41,"featured_media":14399,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[583],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Make Bulk Payouts Using Excel in 3 Easy Steps - PayU Blog<\/title>\n<meta name=\"description\" content=\"Explore how to simplify bulk payouts using Excel. Find how businesses can automate payouts, avoid manual errors, and save time without API integration.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/payu.in\/blog\/sending-payouts-through-your-excel-sheet-via-payu-as-easy-as-1-2-3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Make Bulk Payouts Using Excel in 3 Easy Steps - PayU Blog\" \/>\n<meta property=\"og:description\" content=\"Explore how to simplify bulk payouts using Excel. Find how businesses can automate payouts, avoid manual errors, and save time without API integration.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/payu.in\/blog\/sending-payouts-through-your-excel-sheet-via-payu-as-easy-as-1-2-3\/\" \/>\n<meta property=\"og:site_name\" content=\"PayU Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/PayUind\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-02T11:27:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-14T07:21:40+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/10.10.164.133\/wp-content\/uploads\/2020\/12\/Payouts-excel-1250x1000-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1250\" \/>\n\t<meta property=\"og:image:height\" content=\"1000\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Prabhav Tanay\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@payuind\" \/>\n<meta name=\"twitter:site\" content=\"@payuind\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prabhav Tanay\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/10.10.164.133\/sending-payouts-through-your-excel-sheet-via-payu-as-easy-as-1-2-3\/\",\"url\":\"http:\/\/10.10.164.133\/sending-payouts-through-your-excel-sheet-via-payu-as-easy-as-1-2-3\/\",\"name\":\"How to Make Bulk Payouts Using Excel in 3 Easy Steps - PayU Blog\",\"isPartOf\":{\"@id\":\"https:\/\/payu.in\/blog\/#website\"},\"datePublished\":\"2020-12-02T11:27:59+00:00\",\"dateModified\":\"2026-01-14T07:21:40+00:00\",\"author\":{\"@id\":\"https:\/\/payu.in\/blog\/#\/schema\/person\/ce1d6cb00e2fee9552bbc79ac9fae82f\"},\"description\":\"Explore how to simplify bulk payouts using Excel. Find how businesses can automate payouts, avoid manual errors, and save time without API integration.\",\"breadcrumb\":{\"@id\":\"http:\/\/10.10.164.133\/sending-payouts-through-your-excel-sheet-via-payu-as-easy-as-1-2-3\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/10.10.164.133\/sending-payouts-through-your-excel-sheet-via-payu-as-easy-as-1-2-3\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/10.10.164.133\/sending-payouts-through-your-excel-sheet-via-payu-as-easy-as-1-2-3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/payu.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Product &amp; Features\",\"item\":\"https:\/\/payu.in\/blog\/category\/products-features\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Make Bulk Payouts Using Excel in 3 Easy Steps\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/payu.in\/blog\/#website\",\"url\":\"https:\/\/payu.in\/blog\/\",\"name\":\"PayU Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/payu.in\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/payu.in\/blog\/#\/schema\/person\/ce1d6cb00e2fee9552bbc79ac9fae82f\",\"name\":\"Prabhav Tanay\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/payu.in\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3961378ee053a19c17a0cc1db2abada?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3961378ee053a19c17a0cc1db2abada?s=96&d=mm&r=g\",\"caption\":\"Prabhav Tanay\"},\"url\":\"https:\/\/payu.in\/blog\/author\/prabhav-tanay\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Make Bulk Payouts Using Excel in 3 Easy Steps - PayU Blog","description":"Explore how to simplify bulk payouts using Excel. Find how businesses can automate payouts, avoid manual errors, and save time without API integration.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/payu.in\/blog\/sending-payouts-through-your-excel-sheet-via-payu-as-easy-as-1-2-3\/","og_locale":"en_US","og_type":"article","og_title":"How to Make Bulk Payouts Using Excel in 3 Easy Steps - PayU Blog","og_description":"Explore how to simplify bulk payouts using Excel. Find how businesses can automate payouts, avoid manual errors, and save time without API integration.","og_url":"https:\/\/payu.in\/blog\/sending-payouts-through-your-excel-sheet-via-payu-as-easy-as-1-2-3\/","og_site_name":"PayU Blog","article_publisher":"https:\/\/www.facebook.com\/PayUind\/","article_published_time":"2020-12-02T11:27:59+00:00","article_modified_time":"2026-01-14T07:21:40+00:00","og_image":[{"width":1250,"height":1000,"url":"http:\/\/10.10.164.133\/wp-content\/uploads\/2020\/12\/Payouts-excel-1250x1000-1.png","type":"image\/png"}],"author":"Prabhav Tanay","twitter_card":"summary_large_image","twitter_creator":"@payuind","twitter_site":"@payuind","twitter_misc":{"Written by":"Prabhav Tanay","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/10.10.164.133\/sending-payouts-through-your-excel-sheet-via-payu-as-easy-as-1-2-3\/","url":"http:\/\/10.10.164.133\/sending-payouts-through-your-excel-sheet-via-payu-as-easy-as-1-2-3\/","name":"How to Make Bulk Payouts Using Excel in 3 Easy Steps - PayU Blog","isPartOf":{"@id":"https:\/\/payu.in\/blog\/#website"},"datePublished":"2020-12-02T11:27:59+00:00","dateModified":"2026-01-14T07:21:40+00:00","author":{"@id":"https:\/\/payu.in\/blog\/#\/schema\/person\/ce1d6cb00e2fee9552bbc79ac9fae82f"},"description":"Explore how to simplify bulk payouts using Excel. Find how businesses can automate payouts, avoid manual errors, and save time without API integration.","breadcrumb":{"@id":"http:\/\/10.10.164.133\/sending-payouts-through-your-excel-sheet-via-payu-as-easy-as-1-2-3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/10.10.164.133\/sending-payouts-through-your-excel-sheet-via-payu-as-easy-as-1-2-3\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/10.10.164.133\/sending-payouts-through-your-excel-sheet-via-payu-as-easy-as-1-2-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/payu.in\/blog\/"},{"@type":"ListItem","position":2,"name":"Product &amp; Features","item":"https:\/\/payu.in\/blog\/category\/products-features\/"},{"@type":"ListItem","position":3,"name":"How to Make Bulk Payouts Using Excel in 3 Easy Steps"}]},{"@type":"WebSite","@id":"https:\/\/payu.in\/blog\/#website","url":"https:\/\/payu.in\/blog\/","name":"PayU Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/payu.in\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/payu.in\/blog\/#\/schema\/person\/ce1d6cb00e2fee9552bbc79ac9fae82f","name":"Prabhav Tanay","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/payu.in\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3961378ee053a19c17a0cc1db2abada?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3961378ee053a19c17a0cc1db2abada?s=96&d=mm&r=g","caption":"Prabhav Tanay"},"url":"https:\/\/payu.in\/blog\/author\/prabhav-tanay\/"}]}},"_links":{"self":[{"href":"https:\/\/payu.in\/blog\/wp-json\/wp\/v2\/posts\/9169"}],"collection":[{"href":"https:\/\/payu.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/payu.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/payu.in\/blog\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/payu.in\/blog\/wp-json\/wp\/v2\/comments?post=9169"}],"version-history":[{"count":11,"href":"https:\/\/payu.in\/blog\/wp-json\/wp\/v2\/posts\/9169\/revisions"}],"predecessor-version":[{"id":14402,"href":"https:\/\/payu.in\/blog\/wp-json\/wp\/v2\/posts\/9169\/revisions\/14402"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/payu.in\/blog\/wp-json\/wp\/v2\/media\/14399"}],"wp:attachment":[{"href":"https:\/\/payu.in\/blog\/wp-json\/wp\/v2\/media?parent=9169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/payu.in\/blog\/wp-json\/wp\/v2\/categories?post=9169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/payu.in\/blog\/wp-json\/wp\/v2\/tags?post=9169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}