Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Project Accounting Posting Defaults

Posted on by Microsoft Employee

Project type is Fixed Price. Accounting Method is Cost to Cost.

Does anyone understand the GL postings tht this type of project creates?

For example, set up a project ith some cost categories. Enter some purchase invoices to create actual costs on the project. Then run the first revenue recognition process.

Why does GP post the Revenue Recognised to WIP? I know I can detail what the GL accounts for each posting should be...but I cannot affect the GL Journal make up. The Distribution Types are fixed. (there is a type in here called PROJBILL...is this the same distribution type as PRGJ BLG...which appears in the Billing Journal???)

For me, the journal created by a revenue recognition should be:

  1. CR WIP with the actual cost 
  2. DR COGS with the actual cost
  3. CR Income with the revenue recognised
  4. DR Income in excess of billings

So why does GP do it the way it does? Whats the accounting reason?

WIP should just take distributions for Costs. When the cost is incurred...it Debits WIP...when the cost is recognised (ie during income recognition), WIP is credited and COGS is debited. No other distributions should be hitting WIP.

Any advice or discussions would be appreciated.

Ian.

 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Project Accounting Posting Defaults

    Hi Mark, Thanks for the link. If you could review the below and let me know what you think, I would be very grateful.

    I'm looking at the 'FP-CP Revenue 1st' tab in the XL sheet.

    Journal entry 1 I can understand fine. We incur a cost of $20.00. When the resulting GL journal is posted our WIP account balance is $20.00 - which is perfectly correct - we have incurred costs of $20.00 so far.

    However journal 2, I don't understand. Based on the $20.00 cost incurred, we are going to recognise some revenue. The calculation of the revenue is fine (20% of the Project revenue = $26.00).

    But...when this journal is posted, the balance on our WIP account is now $26.00 (The original $20.00 and the $6 profit.)

    To my mind (and maybe this is where my ideas of project management, and GP's differ)...the balance on the WIP account should be zero. Once we recognise the revenue, the $20.00 in the WIP account should get transferred to the Project Expenses account (or as I call it the Cost of Goods Sold account). This leaves the WIP account at zero - reflecting that all of the costs have been 'recognised' - ie transferred to the P&L.

    There is now no way of knowing what my Project Work In Progress is from the GL. I define Work in Progress as...the total costs incurred that have not been 'recognised' yet - i.e. have not been transferrd to the P&L by way of revenue recognition.

    Whats your take on this?

    Best regards,

  • mpolino Profile Picture
    mpolino on at
    Re: Project Accounting Posting Defaults

    Ian,

    Try this project accounting posting reference from DynamicAccounting.net and see if it helps.

    http://www.box.net/shared/kz4zglkn5g

    Mark

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans