h1

Financial Pack Consolidations Explained

September 7, 2010

Sage Accpac Intelligence has a built in feature that creates the basis for a consolidated set of reports and it provides a way to do this consolidation manually. In both cases the Connector module is required to perform this consolidation – see my blog on the steps to consolidate. The word consolidated is used here to mean that it will return the GL account and balances from multiple databases and place them beneath each other, ready for consolidation.

What the consolidation feature does not do is aggregate the GL account balances for each unique GL account across companies.  This would be a task for the person designing and creating the Excel template. There are of course many ways to do this and the quality of this design decision can be measured against the ‘less is more’ principle, including the spreadsheet design best practices included in this blog.

One neat way of doing this is to group all unique GL accounts from the different companies together, use a ‘subtotal’ function to aggregate the values and use the grouping feature in Excel to hide the detail.

Craig Juta, Excel Master

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

%d bloggers like this: