Blog Posts Process Management

What are the benefits of the Analytical Accounting module in Dynamics GP?

Blog: Professional advantage - BPM blog

Analytical Accounting is a tool within Microsoft Dynamics GP that allows users to further analyse their financial data at a granular level, in more detail than the general ledger and chart of accounts.

During data entry, transactions can be assigned an analytical accounting code to further analyse the value into additional dimensions.

Examples of travel expenses analysed by region:

Let us take a travel expense as an example. In the chart of accounts we have one general ledger account assigned to Travel Expenses. We also want to be able to analyse the total travel expenditure by state or region. Analytical Accounting codes are set up for each of the regions we want to analyse. When an accounts payable or another expense transaction type is keyed into Dynamics GP, the user allocates specific amounts to different regions set up as analytical accounting codes. At the general ledger level, the total is all being allocated to the same account.

The benefits of AA module in GP

In this payables transaction, although the total expense of $500 is allocated to one General Ledger account 000-6410-00, the $500 can be allocated or split as follows: $200 to Analysis Codes NSW and $300 to Analysis Codes VIC.

The use of analytical accounting codes during data entry offers greater reporting flexibility without the need to create multiple general ledger accounts and added complexity to the chart of accounts.

The benefits of Analytical Accounting:

What are some common use cases for Analytical Accounting?

Analytical Accounting is very versatile and can be adapted to suit different transactional analysis requirements. The following are examples of some use cases:

Are you considering adding Analytical Accounting to your Dynamics GP deployment?

Learn how to analyse Dynamics GP Analytical Accounting data with Power BI in this upcoming webinar. Click below to register.

Webinar Using Power BI to unlock Dynamics GP

The post What are the benefits of the Analytical Accounting module in Dynamics GP? appeared first on Enterprise Software Blog – Professional Advantage.

Leave a Comment

Get the BPI Web Feed

Using the HTML code below, you can display this Business Process Incubator page content with the current filter and sorting inside your web site for FREE.

Copy/Paste this code in your website html code:

<iframe src="" frameborder="0" scrolling="auto" width="100%" height="700">

Customizing your BPI Web Feed

You can click on the Get the BPI Web Feed link on any of our page to create the best possible feed for your site. Here are a few tips to customize your BPI Web Feed.

Customizing the Content Filter
On any page, you can add filter criteria using the MORE FILTERS interface:

Customizing the Content Filter

Customizing the Content Sorting
Clicking on the sorting options will also change the way your BPI Web Feed will be ordered on your site:

Get the BPI Web Feed

Some integration examples