Unbelievable! Generate Custom Excel QR Code Generator ( 2025 )

Are you tired of paying transaction fees to payment gateways like Razorpay? Do you need a faster way to receive payments from clients? Then you are in the right place! This article will show you how to build your own Excel QR Code Generator and automate payment requests directly within Excel.

This project was created by Prasad Gaonkar, a Senior Manager in Accounts and MIS, who spent 17 days crafting this solution. And the best part? He’s sharing it with you! This project converts hours of work into seconds.

Why an Excel QR Code Generator?

Prasad understood a common frustration: current payment methods are slow and costly. Traditional methods like NEFT and RTGS can take hours, and payment gateways charge fees. In fast-paced industries, instant payments are a must. As Prasad says, “In the share market, rates change every second!”

Here’s the problem this solution solves:

• High Transaction Fees: Payment gateways deduct a percentage for instant payments.
• Delayed Payments: Waiting for payments to clear can impact cash flow.
• Inconvenience: Manually entering bank details is time-consuming and prone to errors.

The Solution: Instant Payments with Custom QR Codes

This Excel QR Code Generator lets you create customized QR codes for each client, pre-filled with the exact payment amount.

Here’s how it works:

• Generate: Excel generates a unique QR code for each client.
• Send: Send the QR code to your client via email (directly from Excel!).
• Receive: The client scans the QR code with their UPI app (Google Pay, PhonePe, etc.).
• Instant Payment: The payment is instantly credited to your account!

How to Use the Excel QR Code Generator (Step-by-Step)

Here’s a simple guide to get you started:

1. Download the File: Download the Excel file provided in the video description (link below!).
2. Unblock the File: Right-click on the downloaded file, go to “Properties,” and click “Unblock.” (This is important because it contains VBA code.)
3. Open the File: Open the Excel file.
4. Enter Client Data: Fill in the Excel sheet with your client’s information:
   • Account Code
   • Client Name
   • Payment Amount
   • Email Address
5. Process: Click the “Process” button. This will generate the QR codes and create individual emails for each client in Outlook.
6. Review and Send: Review the emails in Outlook and click “Send.”

Customizing Your Excel QR Code Generator

The beauty of this solution is its flexibility. You can customize it to fit your specific needs.

1. Change your UPI ID: Update the VBA code with your own UPI ID (the receiver’s UPI) so the payment will be received by you.
   • Go to the Developer tab.
   • Click on Visual Basic. (Or press ALT + F11)
   • In the Visual Basic Editor, find the correct module where the UPI ID is stored. (Module 3)
   • Replace the existing UPI ID with your own.
2. Customize the Email Message: Modify the email body with your own personalized message.
3. Automate Sending: Adjust the VBA code to automatically send the emails instead of reviewing them in Outlook (use with caution!).

Here’s how to access the VBA code:

1. Enable the “Developer” tab in Excel (File > Options > Customize Ribbon > Check “Developer”).
2. Click on the “Developer” tab and then click “Visual Basic.”
3. Find the module containing the code (usually in “Module 3”).

Important: Be careful when editing the VBA code. If you’re not comfortable with VBA, only change the customizable messages as indicated in the comments.

Turning the Idea into Reality: Prasad’s Inspiration

Prasad was inspired to create this Excel QR Code Generator during a meeting where the team was discussing the high costs of payment gateways. He realized that most people were already using QR codes for payments in their daily lives, so why not leverage that for business?

The goal was to create a system that:

• Reduced transaction fees
• Enabled instant payments
• Integrated with existing systems

By combining his Excel skills with VBA programming, Prasad created a solution that saved his company time and money.

Key Skills for Today’s Professionals

Prasad, with his 15 years of experience in accounts and MIS, emphasizes the importance of continuous learning and automation. He recommends focusing on these key skills:

• Excel Mastery: Learn advanced Excel functions and formulas.
• Data Analysis: Develop skills in data analysis and visualization.
• VBA Programming: Learn VBA to automate tasks and create custom solutions.
• Power BI: Master Power BI for data analysis and reporting.

He suggests dedicating time each day to self-learning and exploring new technologies. “If you keep doing the same work every day, you won’t grow,” he says. “Automate your tasks to free up time for learning and innovation.”

Need Help? Get a Custom Solution

Prasad also offers project-based services to companies looking to automate their processes. If you have a specific automation project in mind, you can contact him for a consultation. Google the keywords from the title and connect with Prasad Sir.

Conclusion

This Excel QR Code Generator is a powerful tool for small businesses and freelancers looking to streamline their payment process and save money on transaction fees. By following this tutorial and customizing the code to your needs, you can create your own instant payment solution.

Download the file, experiment with the code, and start automating your payments today!

Learn SAP FICO Course