Income tax automation

(0) Share

Report

Posted on by Community member

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)

All responses (3)

Answers (2)

Verified answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

Hi,

Allocation works with each and every lines, you can't summarize in allocation.

Was this reply helpful? Yes No
Verified answer

Kevin Xia Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community member 8 on at

Like (0)

Report

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?

Was this reply helpful? Yes No

Join the conversation

Community site session details

Income tax automation

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Income tax automation

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates