Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

Basic GP Project Accounting setup.

Posted on by 75,730

I have been watching several training videos on how to setup GP Project Accounting. They very quickly start to delve into very complicated setups. All I want to do is setup something very similar to the old GPA for DOS. This was a collection of phases and tasks. GL accounts were tied to tasks. All of our projects are labor related. We will sell blocks of hours, then perform a service and finally enter time against those hours.So these projects are a mixture of time and materials and fixed price. What project type should we assign to these projects? Can we send over an invoice for the full block of hours but still be able to enter time against the project? At this point in time all we want to do is create projects, enter time against the project and bill against the project. Everything happens on the fly. There is no work in progress or revenue recognition.

Categories:
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Basic GP Project Accounting setup.

    Nicole, thank you for this thoughtful and lucid explanation. I think my answer lies in this.

    We bill most of our clients for blocks of hours therefore the bills will be fee based.

    We do not bill for any costs but we do want to track time against a project. This is where N/C time entries come into play.

    Our biggest challenge now is to able to produce professional looking invoices(bills). I am sorry to say the ones that come with GP leave a lot to be desired.

  • Nicole Hellerud Profile Picture
    Nicole Hellerud 1,712 on at
    RE: Basic GP Project Accounting setup.

    Hi Richard,

    Thank you for your post. I'd like to start by providing the following information that we have around Project Types, Accounting Methods, and some questions to ask yourself when selecting one for your project. Please let me know what questions linger after reviewing this:

    Project Types:

          1. Time and Materials - The customer is billed for project costs as they are incurred. The amount that the customer is billed is based on billing rates or markup percentages for time, materials, equipment, etc used for the project.
          2. Cost Plus - The customer pays for actual project costs plus a fee. Each billing invoice is for a percentage of the final total that is calculated using forecast budget amounts. As costs rise for the project, your company’s profit remains the same..
          3. Fixed Price - The customer pays a predetermined amount for the entire project. Each billing invoice is for a percentage of the predetermined total billing amount. As costs rise for the project, your company’s profit decreases.

     Accounting methods:

          1. When Billed- Revenue is recognized for a Time and Materials project that uses the When Billed accounting method when you post a billing invoice for the project. The Cost of Goods Sold account will be updated on the Profit and Loss Statement and the Work In Progress account will be updated on the Balance Sheet.
          2. When Performed -Revenue is recognized for a Time and Materials project that uses the When Performed accounting method when you post a cost transaction for the project. The Cost of Goods Sold account will be updated on the Profit and Loss Statement. Unbilled Project Revenue and Unbilled AR accounts are used.
          3. Completed - Revenue is recognized for a Cost Plus or Fixed Price project that uses the Completed accounting method when the project status has been changed to Completed and you post a revenue recognition transaction. The Project Revenue account will be updated on the Profit and Loss Statement.
          4. Cost-to-Cost - Revenue is recognized for a Cost Plus or Fixed Price project that uses the Cost-to-Cost accounting method when you post revenue recognition transactions for the project. Revenue will be determined by comparing total actual project costs to total forecast project costs.
          5. Effort-Expended - Revenue is recognized for a Cost Plus or Fixed Price project that uses the Effort-Expended accounting method when you post revenue recognition transactions for the project. Revenue will be determined by comparing total actual project quantities to total forecast project quantities.
          6. Effort-Expended Labor Only - Revenue is recognized for a Cost Plus or Fixed Price project that uses the Effort-Expended Labor Only accounting method when you post revenue recognition transactions for the project. Revenue will be determined by comparing total actual time quantities entered on timesheets to total forecast time quantities for the project.

      What is the right setup for you?

          1. Questions to ask yourself when deciding how to set up your project:

    Need to bill individual cost transactions

    Need to use rate tables

    Be able to do trade discounts

    Have revenue recognized when the cost transaction is posted or billed

    Be able to use service fees

    Don’t want to have to budget costs

    Need to make cost transactions non-billable (N/B) or no charge (N/C)

    Need to budget in an originating currency

    -- If any of the above are Yes, then you would want to use Time & Materials

    Calculate billing as % of completion

    Be able to use retention fees

    Recognize revenue as a separate process

    -- If any of the above are Yes, then you would want to use Fixed Price/Cost Plus

        1. How can a fee help?

    Often times we get asked for “milestone billing” or billing for a certain % of the total project amount.  For example they want to bill 20% at the start of the project, 40% after 6 months and the final 40% at the completion of the project.  Let’s say the project amount is $12,000. Many people try to set this up as a Fixed Price project because they know the price (project amount of $12,000); however their cost transactions may not follow the 20-40-40 percentages that they want to bill.

    Instead of using Fixed Price, it might make more sense to set up the project is TM and bill using a fee.  Then they would schedule the fee with the appropriate amounts.  For example $2,400 on Feb 1st, $4,800 on August 1st and the remainder when the project is completed.

    I hope this information helps.

    Best Regards,
    Nicole Sutton
    Senior Support Engineer
    Microsoft Dynamics GP

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans