Timesheet entry in & out

(0) Share

Report

Posted on by D365UG

Hello experts,

My GL stays with 0 effect from the timesheet entry, I see 2 transactions one IN (debit the expense account) and right away second transaction that credit the same GL.

On what level I missed the offset account? Is it timesheet journal set up (guessing) or GL account used in timesheet entry requires an offset? Is there more than one way?

FYI: when I create a timesheet I do not use the Client field, only Project.

Please share your thoughts.

Many thanks.

Anya

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (1)

Report

Hi Anya,

Can you check the main account settings on the Ledger posting setup page (Project management and accounting > Setup > Posting)?

The main accounts used on the cost should be different from those setup as payroll allocation.

Was this reply helpful? Yes No
Verified answer

Sandeep Chaudhury 3,303 on at

Like (1)

Report

Hi Anya, When a timesheet is posted in D365 F&O, It Debits the Project Cost account. This is typically your "Estimated Cost of goods sold" account for your salaried employees and is a actual COSG accounts for contractors if they are entering timesheets in F&O. The offset to the Project Cost account is the "Payroll allocation account" under Project ledger posting profile. In your case, you seem to have the same account selected for both Project cost and Payroll allocation accounts. Typically for employee costs, you set can these to the same account, so that your net GL impact is 0.00 and when you process employee payroll, you hit the actual COGS account with the actual payroll cost. But I have seen customers where they still want to track the Cost and payroll allocation separately for employee costs when timesheet is posted. If that is your requirement, then you can set the desired account under Payroll allocation section of the project ledger posting profile. See screenshot attached.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Good morning Anya,

Would be great if you could share some screenprints that illustrate the setups that you made.

I would suspect that something has been overlooked/missed.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
D365UG 40 on at

Like (0)

Report

Thank you for your answers, much appreciated.

I followed Sandeep's recommendation - under Project categories ledger posting setup added Ledger account type "Payroll allocation", so now my debit goes to the Cost & Project and the credit side to payable crested under Payroll allocation. Basically now my Project Category has 2 sides of the accounting entry.

Thanks again!

Was this reply helpful? Yes No
Suggested answer

Jesper M Frederiksen 50 on at

Like (0)

Report

Hi Anya.

If you don't want the cost in the General Ledger, but still want to record the hours and standard cost associated with them, then on the project group you can configure hour transactions to not post to the ledger. It's a much cleaner solution.

Was this reply helpful? Yes No