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.


Intacct: Financial Report Wizard – The power of Dimensions

This week I got a chance to dive into Financial Reporting (thanks to an awesome Intacct teacher who’s enthusiasm about Intacct is contagious – she was awesome and inspired this idea!). Before going over to consulting, this was part 1 of a report I used to create in Excel and didn’t get a chance to build in Intacct’s Financial Reporting Wizard (I just didn’t have enough time to dedicate to it and to be honest I didn’t completely understand the Financial Report Wizard – it was sort of intimidating. customer groups, dimension groups, account groups, dimensions?! It was a whole new world!).

A lightbulb went off in my head during her class about how Intacct could partially automate this report. So here goes!

Have you ever wanted to create a report that would show you a snapshot of all your customer right this very second? What if you had a report that would show everything from Customer specific details (like sign up date, user quantity, sales reps, location), Item specific details (items purchased, prices, discount) and then compare month by month revenue? This type of report could be useful to get an overall picture of customer demographic and month over month revenue – what items are they buying? what is the variance month over month? when did they sign up? where are they? is there any correlation? Imagine you have thousands of customers – that’s kind of hard, right?

If you didn’t notice I listed a bunch of dimensions (and attributes) up there! And if you haven’t heard yet, well, dimensions are sort of Intacct’s thing. (Talk about simplifying your Chart of Accounts – and on top of that slicing and dicing your reports however you want!).

Here’s a little sneak peak of what the final report looks like in Intacct:

Screen Shot 2015-04-30 at 9.45.54 PM

Looking at the report you’ll see immediately your customer, Kathy, increased revenue month over month by $50 compare to last month. If you look closer, you’ll see it was because she added on a faxing plan in March. Cool, right? Then you could see that the customer, Zabars, doesn’t have faxing or any other add on service, now there’s a great opportunity for an upsell, right? It’s really just a cool report to see all your customers at once and be able to analyze correlations and opportunity for marketing and growth.

So let’s go through the step by step!

Continue reading

Intacct: Dimension Structures

Screen Shot 2015-03-25 at 1.27.32 PM

Remember when I promised we would set up Dimension Structures (groups) in the Intacct: Financial Report Writer post last time? (I know you do, because it’s only been a week! But just in case you need a refresher it’s linked above.) Dimension Structures are what made that last report magically work. If you tried to re-create that report, you probably got to the dimension step and realized something was missing …  these guys:

Screen Shot 2015-03-30 at 12.44.46 PM

So let’s drop some Dimension Structure configuration knowledge, shall we?

A Brief Overview – What are Dimensions and Dimension Structures?

Dimensions allow you to independently tag transactions (AR invoices, AP invoices, etc) and records (customers, vendors, etc). Based on Dimensions you have set up, you can create Dimension Groups/Structures. When setting up a dimension group you define the rule (based on a tag) identifying which members are included. (Dimension Structures, which this post covers, are different than Dimensions).

When would we use Dimension Structures?

Say for example the CFO asks you to build a report that shows last month’s revenue for all customers in Washington. The Dimension, or tag, here would be the Customer’s Billing State (WA). The Dimension Group would include anyone who is tagged with Washington. You could manipulate some reports exported to Excel using vlookups and filters OR you could create a dimension group which includes Washington customers only, and create a custom financial report. Sounds easy, right? So let’s set up the dimension group!

Continue reading

Intacct: Financial Report Writer

Financial Report Wizard 1

Financial reports are the basis of vital business decisions guiding the direction and shaping the future of a company.

Imagine you are the CFO of a company. You noticed in February that revenue didn’t go up as much as sales did. The sales numbers show that new sales were $200,000 monthly, while revenue only increased by $150,000. With these new customers being added, revenue should surely go up by $200,000. That’s the logical conclusion, right? But what if there’s something happening that you don’t see? What if you’re not accounting for cancelations or free months that a sales representative gave a customer to allow them to get on their feet initially. Or maybe customers are dropping products. All of these are possibilities. The hard thing about being a CFO (or any type of manager) is as much as you’d like to be aware of everything that’s happening in the company – it’s impossible amongst all your other responsibilities. So you decide you’d like to have a report that compares customer revenue month by month and identifies variances. That way you’ll be able to see (from a top level) if customers are dropping products, canceling, or receiving free months; thereby allowing you to identify the cause and solve the problem before it’s too late! *Cue Intacct Financial Report Writer*

The Financial Report Writer can also be used to create custom balance sheets, income statements, etc (if you need something different than the stock reports Intacct provides). This example will give you a good overview of the steps and various functions of the report writer at a basic level. Then, in future posts I’ll go over how to set up dimensions and account groups. (This can be a little tricky but easy if you know where to go.)

Now that I’ve built up a bit of anticipation, let’s get started!

Continue reading