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

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 546

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 546 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 546 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 546 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 546 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans