+1 650 491 3131

India Payment Voucher Tool

18 Hours

Before Automation

40 Minutes

After VBA Automation

17.33 Hours

Time Saved per month

  • Industry:
  • Professional services, Technology services

Company Profile: It is a global management consulting and professional services firm that provides strategy, consulting, digital, technology, and operations services. A Fortune Global 500 company, incorporated in Dublin, Ireland.

  • Department:
  • Operations
  • Tool(s) Used:
  • Microsoft Excel VB Programming (Macro)

Need for Automation:

Preparing payment voucher for India entity, is a weekly task for us – every Friday – consuming 18 man-hours, for all our suppliers. We will get the invoices list and booking of the month. Based on the Invoice list, voucher template needs to be populated along with invoices backup sheet – to be prepared in a prescribed format. The bookings file comes with 28 columns whereas the back up sheet needs to be prepared only with 17 columns, which are not in order and also every week on an average 90-100 invoice needs to be bifurcated for 10-15 suppliers. This is completely manual, time-consuming and tedious at times. Since it is a weekly affair, during month close it becomes challenging to manage both month-ends and this task. Automation of this process will enable the team to perform it in no time and month-end activities can be managed in a better way.

Cost-Benefit Analysis (Post Macro Implementation)

Before Automation – Manual After Automation Total Saving
Week Average Number of Suppliers Average Time Total Hours Week Average Number of Suppliers Average Time Total Hours Saving
4 10 27 Minutes 18 Hrs 4 10 30 Secs 20 Mins 17 Hrs 40 Min

Before Automation – Manual

Week

4

Average Number of Suppliers

10

Average Time

27 Minutes

Total Hours

18 Hrs

Before Automation – Manual

Week

4

Average Number of Suppliers

10

Average Time

30 Secs

Total Hours

20 Mins

Total Saving

Saving

17 Hrs 40 Min

Join our 10-day online session and learn how to automate your Excel Reports and Processes using VBA Programming. No prior programming experience needed!.

Upcoming Schedule:

  • Date:
  • Sunday, July 11
  • Time:
  • 10:00 AM - 12:30 PM (ET)

Proficiency with Excel formulas is a prerequisite. Not sure about your skills? Schedule a pre-assessment at 650-491-3131 to evaluate your Excel proficiency.

Explore 90+ practical scenarios, delve into 7 case studies, and complete a live VBA project.

Ready to learn Excel VBA Macro?