Armanino Blog
Article

Dynamics GP Project Tracking with the General Ledger

March 29, 2017

Most companies have at least some requirement to track project related activity for their organizations, whether it's a research and development (R&D) project, an internal construction project, or a customer-specific project. There are several ways to utilize Microsoft Dynamics GP project tracking capabilities. Perhaps the simplest method is to merely use a specific segment in the chart of accounts to identify project activities.

Dynamics GP project tracking is very easy to set up this way. Since it is possible to have up to ten segments in your chart of accounts, just assign one of the segments to track project activities.

In this example I'm using the third segment to identify project activities:

Account Format Setup

With alphanumeric segment values, you can use letters to identify your projects. There are a few essential benefits of using the general ledger to track project activities are:

  • It uses standard functionality that you're already using for the rest of your accounting requirements.
  • It's simple to set up and maintain.
  • The reporting flows naturally from the general ledger.

Here's an example of the standard trial balance report with transactions coded and grouped by project. This offers easy analysis of project activity at a detailed level:

Trial Balance

The above report could even be enhanced by pulling in additional information from the account master file user-defined fields.

You can also use Management Reporter to include budgets and variance calculations in your reports. Since you can have an unlimited number of budgets in Dynamics GP, you can easily use one or more to store project budget information. Here's an example of a multi-year project with actual and budget amounts in Management Reporter:

Total Expenses

For a visual explanation around Dynamics GP project tracking, take a look at this video showing this method of tracking project activity.

 

If it turns out that you want to track project activity at a task and sub-task level you will likely want to use a different method. In that case, the Project Accounting, Analytical Accounting, or a Dynamics GP add-on product would work better. There are many options, so explore the best method for your team.

Contact the Armanino team to learn more about Dynamics GP or to explore an assessment of your current technology systems and create a roadmap for future growth.

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Resources
Related News & Insights
SaaS Market Trends
Webinar
Between the uncertainty of 2022 and the highs of 2021, what will 2023 hold?

December 14, 2022 | 09:00 AM - 10:00 AM PT
Fraud: Current Trends & Hot Topics
Webinar
Don’t let fraud negatively impact your organization.

December 8, 2022 | 11:00 AM - 12:00 PM PT
Year-End Tax Planning for High-Net-Worth Individuals
Webinar
Optimize your tax position before December 31.

December 8, 2022 | 09:00 AM - 10:00 AM PT