Excel VBA in accounting

USA Discussion in 'Career and Jobs' started by Gappi, Sep 3, 2018.

  1. Gappi

    Gappi

    Joined:
    May 14, 2018
    Messages:
    12
    Likes Received:
    0
    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
     
    Gappi, Sep 3, 2018
    #1
    1. Advertisements

  2. Gappi

    Steve-LevelUp VIP Member

    Joined:
    Jul 18, 2016
    Messages:
    293
    Likes Received:
    41
    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.
     
    Steve-LevelUp, Sep 4, 2018
    #2
    1. Advertisements

  3. Gappi

    bklynboy VIP Member

    Joined:
    Oct 12, 2011
    Messages:
    487
    Likes Received:
    80
    Location:
    NYC
    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.
     
    bklynboy, Sep 4, 2018
    #3
  4. Gappi

    kirby VIP Member

    Joined:
    May 12, 2011
    Messages:
    1,380
    Likes Received:
    187
    I think bklynboy said it all. Great advice.
     
    kirby, Sep 5, 2018
    #4
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.