USA Excel VBA in accounting

Joined
May 14, 2018
Messages
19
Reaction score
0
Country
United States
Is it worth the time investment to learn VBA for accounting to differentiate yourself from others or will it be a waste of time? what are the pros and cons of macro vba in excel? how do people use it to their advantage in accounting
 

Steve-LevelUp

VIP Member
Joined
Jul 18, 2016
Messages
315
Reaction score
43
Country
Canada
I have never used it very much and I have not known many that have had expertise in it. Need commonly drives these kinds of tools and I don't think I've come across a good use case in my career. Others may have a different experience.
 

bklynboy

VIP Member
Joined
Oct 12, 2011
Messages
595
Reaction score
112
Country
United States
I find it very helpful to automate routine processes. Its not had to learn and those that use it get ahead than their peers at least until they make manager when their duties change. Biggest con I see is maintenance since the macro will inevitably break and unless others know how to fix, you end up being the one to fix it no matter how far you advance. We use it to automate journals, reconciliations and pull data from external systems. Biggest advice I can give is keep it simple and easy so that it doesnt turn into a sort of Excel application on its own that only you can maintain.
 

kirby

VIP Member
Joined
May 12, 2011
Messages
2,445
Reaction score
332
Country
United States
I think bklynboy said it all. Great advice.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top