How to Create an Automatic Payment Voucher in Excel l Learn Accounting Pro Studio

How to Create an Automatic Payment Voucher in Excel l Learn Accounting Pro Studio

Welcome to Learn Accounting Pro Studio!

Still creating payment vouchers manually in Excel? In this video, you’ll learn how to build a fully automated payment voucher system connected to a live database.

We start by creating a structured cash payment database, then automate voucher numbers so they only appear when data is entered. After that, we build a running balance system to track transactions accurately and convert the entire dataset into a dynamic Excel table.

Next, we design a professional payment voucher format from scratch, including proper layout, borders, and a clean print-ready structure. Then we connect the voucher to the database using VLOOKUP, so entering a voucher number instantly pulls all related details like date, party name, amount, and account description.

You’ll also learn how to:
• Display amount inside a formatted shape
• Convert numbers into words using VBA
• Automate voucher selection using a spin button
• Format voucher numbers with leading zeros
• Create a clean, professional, real-world voucher system

By the end of this video, you’ll have a complete Excel-based voucher system that saves time, reduces errors, and works like a real accounting tool.

📥 Download the Excel template from the link in the description and follow along.

🆓 DOWNLOAD Free Excel Template for this video:
https://www.mediafire.com/file/tr0f1xdirgv8z3v/Automatic_Payment_Voucher_in_Excel.xlsx/file

🆓 DOWNLOAD Free (Spell Number) VBA Code for this video:
https://www.mediafire.com/file/rllr858l80tpwpr/VBA_Code_for_SpellNumber_in_Excel.txt/file

Thanks for Watching. For more free Excel & Accounting tutorials, you can Subscribe to our YouTube channel "Learn Accounting Pro Studio".

🔥 Learn Accounting Pro Studio Top Playlist:

✅ Automate Accounting Bookkeeping in Excel
https://youtu.be/gxmXbhUXQO4
✅ Inventory Management in Excel
https://youtu.be/cthGsV9AmWs
✅ How to create an Automated Payment Voucher in Excel
https://youtu.be/WkDPo-eMRZE
✅ How to create Professional Invoice Template in Excel
https://youtu.be/BDOzH_oX3ek

Chapters:
0:00 Intro
0:27 Create Cash Payment Database
1:37 Serial Number Automation
3:06 Database Sheet Automation
5:59 Create Automated Payment Voucher Sheet
12:44 Connect Database using VLOOKUP Function
22:39 Save as Excel Macro Enabled Workbook
23:19 Summary

#excelpaymentvoucher
#Paymentvoucherinexcel
#excelautomation
#excelforbeginners
#excel
#microsoftexcel
#exceltips
#exceltutorial
#excelformula
#exceltraining
#accountingvouchercreation

Видео How to Create an Automatic Payment Voucher in Excel l Learn Accounting Pro Studio канала Learn Accounting Pro Studio