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 :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Accrual of Withheld sales tax/VAT

(1) ShareShare
ReportReport
Posted on by 65
  1. Withholding of sales Tax/VAT

The scenario would be client receive a vendor invoice against supplies/service which include sales tax. However, client have to accrue some portion of tax. For Example

Particular

 Amount

Invoice Amount

25,000.00

Sales/Vat @ 17% (Receivable)

4,250.00

Total Credit to Vendor

29,250.00

Now we have to accrue 20% of sales tax credit the sales tax payable.

Total sales Tax/VAT

4,250.00

20% of sales tax/VAT (Payable)

850.00

 

Incorporation of entry in Legacy System by Client.

Client in legacy system is incorporating the following general entry.

Particular

Debit

Credit

Expense/Asset Account

25,000.00

Sales Tax (VAT) Receivable @ 17.00%

4,250.00

Vendor

29,250.00

Vendor

850.00

Withheld Sales tax Payable @ 20%

850.00

 Total

30,100

30,100

Can any one help me on this scenario?

I have the same question (0)
  • Suggested answer
    Gaurangkumar Jani Profile Picture
    4,534 User Group Leader on at

    Hi Mushtaq,

    Can you provide additional details, such as :

    For which country you are implementing this process.

    Did you tried selection of multiple tax rate in one group, example 1, normal tax @17% and 2. TAX on Tax @20%.

    I'm assuming in above case you're vendor is credited by 30,100.00

    Right?

    If yes, I would suggest go with 2nd code as tax calculation as percentege on tax value.

    Let us know if it works for you.

    Thanks,

    Gaurangkumar Jani

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi,

    Is the tax that you withhold deducted at the time you make the (partial) payment to your vendor?

    Best regards,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    301,035 Super User 2025 Season 2 on at

    Hi Mushtaq,

    I'm not familiar myself with this requirement as I never did setup a system in a country where this regulation was required.

    There are some blogs with help how to setup withholding tax. Probably these can help you.

    d365tracks.wordpress.com/.../

    exploredynamics365.home.blog/.../

  • Mushtaq Ahmed Profile Picture
    65 on at

    Hi Ludwig

    Thanx for reply.

    Actually this tax will accrued at the time of vendor invoice journal

    Best Regards

    Mushtaq

  • Mushtaq Ahmed Profile Picture
    65 on at

    Hi Gaurangkumar Jani

    This scenario is pertaining to Pakistan Tax.

    I have design this solution as you mention above to accommodate this issue as per following.

    I have created two tax code

    a. VAT Code for input tax

    b. VAT Code for output tax with negative sales tax value

    II. I have assigned both codes to a tax group named as “Purchase”

    III. That is working fine but there is only one problem for this general entry i.e. it nett of vendor balance as per following;

    Particular                                  Debit                   Credit

    Expense/Assets Account          25,000.00

    Sales tax/VAT Receivable          4,250.00

    Sales tax/Vat Payable                                           850.00  

    Vendor                                                                28,400.00

    Total                                          29,250.00          29,250.00

    But problem with this transaction is that system netting of  vendor balance, but we want separate entry for sales payable as per following;

    Particular                                 Debit                               Credit

    Expense/Assets Account               25,000.00

    Sales tax/VAT Receivable                4,250.00

    Vendor                                                                           29,250.00

    Sales tax/Vat Payable                          850.00

    Vendor                                                                                850.00

    Total                                                30,100.00               30,100.00

  • Mushtaq Ahmed Profile Picture
    65 on at

    Hi André Arnaud

    d365tracks.wordpress.com/

    This blog seems helpful but problem is that option mention in this blog are not available in my country Pakistan.

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    301,035 Super User 2025 Season 2 on at

    The withholding tax if applicable in a country can have different requirements. Microsoft does not maintain the localizations for Pakistan. That might be the reason that some features are not available.

    You can contact Systems Limited who offer a localization Add-on for Pakistan including support for withholding tax: appsource.microsoft.com/.../systemslimited.taxation-for-pakistan-localization-dynamics365fo

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Mushtag Ahmed,

    Did you have a look at the app that Andre shared, which focuses specifically on tax in Pakistan?

    Currently, the standard application does not have a specific tax solution for Pakistan available meaning that you can either use the available app or that you make the modifications needed yourself.

    Best regards,

    Ludwig

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 544 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans