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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Payroll Clearing Account
Microsoft Dynamics AX (Archived)

Payroll Clearing Account

(0) ShareShare
ReportReport
Posted on by ahmed.kimo 536

Hi,

I have an issue that i have added payroll clearing account in payroll parameters form , but while posting the pay statement system not taking the worker dimensions with this account , How i can force system to take this account with the worker financial dimensions ?

PayrollParm.jpg   

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Payroll Clearing Account is one of the temporary accounts containing amount which need to be transferred in another in account. In Payroll's case the amount get transferred to Payroll Vendor account on the submission of Pay Statement. So dimensions are not required for the clearing accounts.

  • ahmed.kimo Profile Picture
    ahmed.kimo 536 on at

    Dear Yasir Ansari,


    Thank you for your kind suggestion but my point is like that :

    Posting the pay-statements for 2 employees each of them has 1000 USD in his salary so system will create the following entries

    DR : Expenses (With employee1 dimension) 1000
    CR : Payroll Clearing account 1000
    --------------------------------------------------------
    DR : Expenses (With employee2 dimension) 1000
    CR : Payroll Clearing account 1000


    Now i'm going to submit the first pay-statement so system will create the following entries

    DR : Payroll Clearing account (Through vendor account type) 1000
    CR : Bank 1000


    Now in the "Payroll Clearing account" i can see that still unbalanced by 1000 USD my question how i know that 1000 USD whether for the first employee or for the second employee ?


    you can take the same example but for 3500 worker / Labors

     

  • Community Member Profile Picture
    Community Member on at

    I think there is some understanding issue. As per your example at the time of posting following transactions will happen,

    DR: Expenses (With employee 1 dimension)     1000

    DR: Expenses (With employee 2 dimension)     1000

    CR: Payroll Clearing Account                                        2000

    On Submission following Transactions will happen,

    DR: Payroll Clearing Account                            2000

    CR: Payroll Vendor Account                                          2000

    On Payment Journal Posting following transactions will happen,

    DR: Payroll Vendor Account                             2000

    CR: Bank                                                                        2000

    Now tell me where you want to see dimensions wise?

  • ahmed.kimo Profile Picture
    ahmed.kimo 536 on at

    Dear Yasir,

    I think we are touching the same point with little differences

    i agree with what you have mentioned in your reply but i'm requesting you to do the following 

    1- Post paystatment for 2 employees 

    2- Submit the first paystatment only 

    Can you please provide the financial impact with the mentioned flow if you did that you will find the payment done in GL level without referring to particular worker in this case the GL account is posting as a lump-sum please check and verify.

  • Community Member Profile Picture
    Community Member on at

    Posting Pay statements

    DR: Expenses (With employee 1 dimension)     1000

    DR: Expenses (With employee 2 dimension)     1000

    CR: Payroll Clearing Account                                        2000

    On Submission following Transactions will happen,

    DR: Payroll Clearing Account                            1000

    CR: Payroll Vendor Account                                          1000

    On Payment Journal Posting following transactions will happen,

    DR: Payroll Vendor Account                             1000

    CR: Bank                                                                        1000

    This will be the result.

  • ahmed.kimo Profile Picture
    ahmed.kimo 536 on at

    Dear Yasir,

    Thanks for your efforts appreciated,

    in your correct example i have mentioned the same ,  That the statement of the payroll accrual will be

    Posting2 Paytatements -2000

    Submit one of them   +1000

    ---------------------------

    Balance of payroll accrual = -1000

    i think now it's clear for you this (-1000) for which worker ?  

    Again take the example for 3500 employees/Labors

  • Community Member Profile Picture
    Community Member on at

    This can be viewed through Pay Statements list page by applying the following filters,

    - Pay Period

    - Posted = "Posted"

    - Payment Statement Status = "Sent to Payment Journal"

    Through this you'll get all the pay statements which are sent for payment.

  • ahmed.kimo Profile Picture
    ahmed.kimo 536 on at

    Hi,

    This is the easiest way anybody can do but it's not helping the finance team including the auditors for the analytic accounting , 

    The main purpose of this post to get the financial statement.

    In addition to be understandable for finance prospective , Suppose you used one account for fist quarter of a fiscal year and another account for the rest of quarters, the filtration will not help  to get the exact statements for the changes happened in the trial balance specially for B&L Ledgers if you need more information about analytic accounting you can check with the finance team in your organization it will be better to understand the exact issue .

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans