web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Income tax automation
Finance | Project Operations, Human Resources, ...
Answered

Income tax automation

(0) ShareShare
ReportReport
Posted on by Community member 8
Dear All,

I am trying to automate monthly income tax calculation and recording of journals in D365 using the Allocation journal type. For our requirements, we take 30% of PBT and record 30% income tax as Debit to P&L Income tax expense account and credit to the balance sheet Income Tax provision account (if there is profit before tax).

Using Allocation, I was able to successfully calculate, create and record the journal based on the account series of the P&L accounts (profit before tax, PBT).

The issue I am seeking help for is that the journal that is created is at each account level i.e. if I have 100 accounts that make up PBT, the income tax journal created through allocation is 200 lines (100 for P&L and 100 for Balance Sheet).

Is there a way that I can create and summarise it to only 2 lines i.e. 1 for P&L and 1 for Balance Sheet?
 
I have the same question (0)
  • Community member Profile Picture
    Community member 8 on at
    Income tax automation
    Thanks Ramit, so other than custom development that Kevin suggested, is there any other solution from which I can calculated tax and record the journal?
  • Verified answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Income tax automation
    Hi,
    There is currently no such standard feature that meets your requirements. However, you can achieve your goals with custom development. Handle the generation of the income tax journal through custom code or scripting, where after creating the journal, you can calculate and consolidate accounts of the same type to summarize the journal into fewer lines. This would involve some development work and may require collaboration with the Dynamics 365 F&O development team.
    Best regards,
    Kevin
  • Verified answer
    Ramit Paul Profile Picture
    Ramit Paul 22,782 Most Valuable Professional on at
    Income tax automation
    Hi,
     
    Allocation works with each and every lines, you can't summarize in allocation.
     
     
     
     
     

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 775 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 634 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

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

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans