Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Sales Tax Setup in GP for MN and CA

Posted on by Microsoft Employee

Is there a way to get a sales tax setup format from a current GP user that works well?  We are going to do our conversion soon, and we're hoping not to recreate the wheel while setting up sales tax.  I realize we'll need to assign the appropriate codes/schedules/details to our specific customer ship-to addresses, but is the tax framework out there?  We are based in Minnesota and also have nexus in California.  Thanks in advance for any info.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Tax Setup in GP for MN and CA

    Hi Steve, thanks for your reply.

    Yes, we'll no doubt end up using a tax service, but we're not there yet.  And we're not new to MN or CA sales tax, we get audited every three years by CA and occasionally by MN and come out fine.  Also, I'm not looking for help with the process of getting the taxes set up in GP, simply a code framework that works well with the various city/county/district/state layers.

    Thanks again.

  • steveendow Profile Picture
    steveendow 2,281 on at
    RE: Sales Tax Setup in GP for MN and CA

    I can't offer a documented process for getting the rates setup in GP for MN and CA, but I setup CA sales taxes manually quite a few years ago, so I'm generally familiar with the process.

    If you are going to be managing the sales tax setup yourself, then you'll want to be familiar with the details, regardless of whether you get advice or data from someone.  Ultimately, you are responsible for your sales taxes and you will have to maintain them.

    For CA, I would start by reviewing the CA Board of Equalization web site:

    http://www.boe.ca.gov/sutax/pam71.htm

    http://www.boe.ca.gov/sutax/faqtaxrate.htm

    They provide you with the piles of tax schedules and rates, and you'll probably need to spend several hours reading the various publications, how the tax rates should be applied, and getting familiar with the different layers of taxes (state, county, city, district, etc.).  You may also need to get written guidance from the CA BOE to confirm your specific tax requirements, such as Origin vs. Destination tax rules, which are apparently a mix in CA.

    http://www.boe.ca.gov/pdf/boe8.pdf

    http://blog.taxjar.com/charging-sales-tax-rates/

    Once you do get familiar with the requirements and get them in writing, and start to understand the complexities, and see what it is going to take to setup the various schedules, and then begin to realize that you will also have to be aware of any and all changes that occur to those rates--oh, and don't forget the reporting you will have to do in order to remit those taxes--you will probably then understand why most customers use a service such as Avatax.  

    It could be that your company has very few tax rates to setup, in which case it shouldn't be hard to setup and maintain them in GP--assuming your organization doesn't change or grow.  But if your organization will require tax rates for a dozen or more jurisdictions and if your company is growing to new physical locations and states, then you will want to seriously consider a tax rate service vs. DIY.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans