Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Tax - On account project invoice in fixed price project

(0) ShareShare
ReportReport
Posted on by 53
Hi Experts,
 
Is there any way to do the reverse calculation of tax on project invoice? Similar to the option as we have on Journals (tax is included in the amount itself). I need similar option for on account transaction invoice on a fixed price project in D365 Finance & operations.
 
Your response will be highly appreciated.
 
Regards
Mukesh
  • Mukesh Sinwer Profile Picture
    Mukesh Sinwer 53 on at
    Tax - On account project invoice in fixed price project
    Hi Andre,
     
    Thanks for looking into my question. The accounting entry shall be like as below for an on-account transaction created with sales price = EUR 99.
     
                                                        DR        CR
    project invoiced on-account                    90
    Customer                                     99 
    Sales Tax payable                                      9
     
    May be my question is not clear, let me clarify a bit more what am looking for.
     
    What is happening today:
     
    Sales price at on-account amount = EUR 99
    TAX = 10%
    Tax calculation on project invoice proposal/invoice = 99*10% = 9.9.  Tax is calculated on top of sales price.
     
    What we want to achieve:
     
    Sales price at on-account amount = EUR 99
    TAX = 10%
    Tax calculation on project invoice proposal/invoice = 90*10% = 9.  Tax is already included in the sales price. I want to calculate it in reverse direction.
     
    Basically, the milestones are created including tax amount.
     
    Regards
    Mukesh
  • Mukesh Sinwer Profile Picture
    Mukesh Sinwer 53 on at
    Tax - On account project invoice in fixed price project
    Hi Andre,
     
    Thanks for looking into my question. The accounting entry shall be like as below for an on-account transaction created with sales price = EUR 99.
     
                                                        DR        CR
    project invoiced on-account                    90
    Customer                                     99 
    Sales Tax payable                                      9
     
    May be my question is not clear, let me clarify a bit more what am looking for.
     
    What is happening today:
     
    Sales price at on-account amount = EUR 99
    TAX = 10%
    Tax calculation on project invoice proposal/invoice = 99*10% = 9.9.  Tax is calculated on top of sales price.
     
    What we want to achieve:
     
    Sales price at on-account amount = EUR 99
    TAX = 10%
    Tax calculation on project invoice proposal/invoice = 90*10% = 9.  Tax is already included in the sales price. I want to calculate it in reverse direction.
     
    Basically, the milestones are created including tax amount.
     
    Regards
    Mukesh
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,160 Super User 2025 Season 1 on at
    Tax - On account project invoice in fixed price project
    Hi Mukesh,
     
    Can you provide an example of the required outcome (accounting entries)?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,160 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans