Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Setting up Canadian sales taxes

Posted on by Microsoft Employee

I am trying to set up Canadian Sales Taxes in Dynamics 365 Business Central. I have set up my Tax Posting Group, Tax Product Posting Groups, everything I can find to set up. But, because they are sales taxes not VAT, I cannot set up accounts on the Tax Posting Group. It keeps telling me to set up the account on the tax jurisdiction line. I cannot find this line in the Tax Posting Group setup! I do have accounts on my Tax Jurisdiction setup. 

What am I missing? I have searched through support here in the Community as well as the Business Central help files and nothing is giving me direction. 

Thank you. 

Categories:
  • MarilynG Profile Picture
    MarilynG 70 on at
    RE: Setting up Canadian sales taxes

    Ok, I've answered myself.  I just realized that there is a QST Registration number field in the Tax section of the Company Information page...

  • MarilynG Profile Picture
    MarilynG 70 on at
    RE: Setting up Canadian sales taxes

    Hi!

    I'm implementing BC in Quebec / Canada.  My customer need to print is GST and QST number on there invoice.

    Do I only have to create a new field in the company Information Card for the QST number?

    Any better way to acheive this?

    Thanks!

  • Alaa Ramadan Profile Picture
    Alaa Ramadan 4,084 on at
    RE: Setting up Canadian sales taxes

    Hi Tom, 

    I'm also using the Canadian version of Business Central. I have already setup the sales taxes including(group/jurisdiction/detail/area).

    My question what's the need of setting up the VAT posting group in that case?

    Thanks

  • Suggested answer
    TWBlaisdell Profile Picture
    TWBlaisdell on at
    RE: Setting up Canadian sales taxes

    Hello Kendra,

    Thank you for posting your question related to setting up Sales Tax in Dynamics 365 Business Central.

    The following link to Microsoft Dynamics 365 Business Central Docs site will hopefully provide further details related to setting up Sales Tax for Canada:

    https://docs.microsoft.com/en-us/dynamics365/business-central/localfunctionality/canada/ca-sales-tax

    I will highlight some key points below that will hopefully provide some initial direction and clarification. 

    1) Tax Posting Setup in Canada and the United States will actually only be used to establish that Sales Tax is the tax to be charged. The full Tax Posting Setup is used primarily in VAT environments only.  As shown below, you will have a single line with Sales Tax defined as the Tax Calculation Type. 

    pastedimage1582296919923v1.png

    2) Once Sales Tax is defined as the relevant tax, you may either use the Assisted Setup for Sales Tax or setup Sales Tax directly.

    The assisted setup video is found at the following: https://www.youtube.com/watch?v=qMs4BoSytN8&index=13&list=PLcakwueIHoT8K1m148oMqo7amR2a7Bz-8

    To setup directly, it will include setting up Tax Area Codes, Tax Jurisdictions, Tax Groups, and Tax Details. These are discussed in the Microsoft Docs link above. 

    The fundamentals of the setup are:

    Tax Jurisdictions in Canada are the Federal GST along with each Province being a Tax Jurisdiction. The Jurisdictions are then grouped into a Tax Area Codes.   The Tax Area Code is assigned to each Customer and Vendor based on their region/Province.  There is also a Tax Liable flag that indicates for example whether the customer is liable for Sales Tax. This is particularly important if a Customer has a Tax Area for where the customer resides but then the customer is a charitable or non-profit organization where the customer is not subject to Sales Tax. The Tax Liable flag on the Sales and Purchase Lines is defaulted based on the default in the Header of the document that defaults from the Customer card.  Note: The Tax Jurisdiction is where different G/L Accounts are setup to manage the posting of the accrued Sales Tax liability.

    Tax Groups are created and then assigned to each product that is bought and sold, so it can be Items of Inventory, G/L Accounts, or Resources as the primary master records that are assigned Tax Groups. The Tax Group could simply be TAXABLE and NONTAXABLE to manage the various products sold. Or, if the products have varying tax rates, it may require setting up multiple product groupings for TAXABLE for the different rates. This is primarily in the US where some states/counting may have different tax rate on certain product types. The Tax Group field can be shown on the lines so that it can be modified if a particular sale should have a different rate for the transaction

    Finally, the Tax Details table is where the Tax Jurisdiction is matched with each Tax Group and assigned a tax rate. This Table is where the Tax Rates are defined instead of in the Tax Posting Setup.

    Hopefully, the information will help clarify some of the questions you presented and give you direction moving forward.

    Have a great day.

    Best Regards

    Tom

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans