Intacct Dimensions – Items

Screen Shot 2015-10-19 at 8.23.27 PM

A while back I promised a series on Intacct dimensions and different ways to use them. We covered the Customer Dimension in May, now let’s venture through the world of Items.

Items is one of the tougher dimensions that is often mis-used. So let’s approach the explanation of the Item dimension through a real-world example. Imagine we work at Apple in their accounting department and our team has decided to move to Intacct. We’re working on restructuring our chart of accounts and have just been asked what we would like our items to be. (You probably think – why do we need items? What exactly are items? Especially if you’ve never thought of your company as selling “items”). Let’s say your revenue accounts look something like this:

Screen Shot 2015-10-19 at 7.38.51 PM

You’ll notice right off the bat – each account represents a different revenue item. What if you could simplify your chart of accounts? What if every time you add a new product, you wouldn’t have to change your chart of accounts by adding a new account? Those Apple press conferences would be a lot less painful for you as the accountant and you could actually enjoy the cool new products those engineers are coming up with! Intacct helps with this with it’s Item dimension.

I define the Item dimension’s mission as:

The Item dimension allows you to simplify your chart of accounts, while allowing you to still track item differentiations. We leave your chart of accounts with the responsibility of managing the high level umbrella of item categories (revenue streams) and allow your items to specify actual variances of these revenue streams.

In our Apple example, your new Chart of Accounts would look like this:

Screen Shot 2015-10-19 at 7.53.09 PM

Your Items would be:

Screen Shot 2015-10-19 at 8.05.04 PM

Each Item is tagged with a GL group which is then tied to your GL account in the Order Entry Posting Configuration. (If using standard process workflows, it’s directly tied on the item – even easier!).

Then, in reporting you can report on these individual Revenue streams summarized, or you can expand by items showing details. Below, is a sample report which shows sales by customer expanded by items.

Screen Shot 2015-10-19 at 8.19.24 PM

Also, just like the customer dimension you can add custom fields, group items, and create dimension structures with your items.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s