web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Sales Tax Reporting in Canada

(0) ShareShare
ReportReport
Posted on by 15,529

Hi

I have found this article but it is not provide method to how get these files and report

https://learn.microsoft.com/en-us/dynamics365/business-central/localfunctionality/canada/sales-tax-goods-services

Also in F&O we have the following option to settle sales tax https://learn.microsoft.com/en-us/dynamics365/finance/general-ledger/tasks/create-sales-tax-payment

Does BC has similar function? 

Any info can help a lot

Thanks 

I have the same question (0)
  • Suggested answer
    Valentin Castravet Profile Picture
    31,396 Super User 2025 Season 2 on at

    most companies I know go straight to the G/L account(s) setup for sales tax to get the amounts from there. Its fairly simple to get the number you want using the filters in the Chart of Accounts Page. I don't really know anyone generating the file from your link out of BC. There is also a 'Sales Tax Collected' report that can be used as an alternative rather than getting the numbers from the Chart of Accounts Page.

  • MahGah Profile Picture
    15,529 on at

    Thanks Valentin

    I am totally new to Tax in Canada. Looks like in Canada companies are required to send collected tax from each customer to government. What is the best report to do this in BC?

    Also, how you pay the tax to government? I mean what is your recommendation here? Do you create one vendor as government then  do manual purchase invoice? or other methods are available?

    Thanks for your help here

  • Verified answer
    Valentin Castravet Profile Picture
    31,396 Super User 2025 Season 2 on at

    I am simplifying it quite a lot, but for GST/HST you would essentially have two G/L accounts

    • GST/HST Collected on Sales
    • GST/HST Paid on Purchases

    You would setup the BC tax engine to calculate sales tax on purchase/sales documents and the tax entries from a purchase invoice or a sales invoice would go to those two accounts. Every month/quarter/year depending on when you have to submit your info to the CRA you would net the balances of those two accounts and if you collected more tax on sales than you paid on purchases you would have to remit that difference to the CRA. To do both of those 2 things you would simply use the balances of the two G/L accounts or the Sales Tax Collected Report. The balances of the G/L Accounts is the easiest way. You would take the balances and go to the CRA site and enter them in their form on there. 

    To record the remittance of tax you would simply do a Journal Entry where the debit is a G/L Account and the credit is the Bank Account Card. If you get a refund the debit/credit are simply reversed. A vendor/purchase invoice is not used. For PST tax its a similar process, however, you would only typically register the tax collected and remit that.  

  • MahGah Profile Picture
    15,529 on at

    Thanks Valentin . You did an amazing job explaining the tax for me. Really appreciate it. I wish you could right a blog about this since not many guideline available here. Thanks again for taking time to explain the process for me.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,010

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,270 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,085 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans