USA Excel VBA in accounting

[Gappi]

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]

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]

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]

I think bklynboy said it all. Great advice.