Follow

ID893 - Financial Model Mapping Application

ID893 is a custom application we built to allow you to "map" your chart of accounts to the Global Model. This enables you to to run a report that will display your numbers based on the Global chart of accounts without having to change yours. This is a one time exercise and will only need to be updated if you add additional accounts. Our process also allows for multiple "models" if you want your own customized version. We expect this one time exercise to take less than a half day.

See THIS LINK for Employee Mapping within ID893.

Once ID893 is installed, we will email whomever subscribed and include the link to our application. It will be installed on our "JuiceBox" and to launch it please open Internet Explorer and go to http://juicebox:8888 (replacing juicebox with the name of the server our software is installed on).

Please note reports are located at http://juicebox/reports.

Can't access the app or report and the web address is correct? SEE HERE

**Note only IE is supported, don't use Chrome, Firefox, Safari etc.  If you are getting an error the site may be blocked by your firewall, add the URL as a safe site to prevent this.

Click on the link to Financial - Mapping:

Login: user

Password: map

Steps:

The Model (1) for SBA dealer members will always be SBA2015 (we haven't needed to change it so far!), we suggest a sort by Account Number (2) and then filter by whatever accounts you want to map 1st.

 

ScreenClip.png

Step 1:

Adding Mapping Rule:

Nothing_mapped__start_here.png

Active accounts appear first and are followed by inactive accounts:

ScreenClip.png

2. Add Mapping Rule:

  1. Use All Depts (will not include transactions with no dept) or pick specific dept via "Add GL Depts 2.
  2. ALWAYS select ALL Branches
  3. ALWAYS select all divisions

Add__mapping_rule.png

3. Select the Division - this corresponds to the SBA Survey, for example Imaging corresponds to equipment

 

Selection_Division_-_four_sections_of_SBA_Survey__example-_Imaging_corresponds_to_equip_.png

4. Select Bucket

**The Bucket and Department MUST relate, for example Equipment Bucket to Equipment Department (often the same)

Select_Bucket__amp__Department___must_relate__so_Equip_Bucket__Equip_Dept_-_often_the_same_except_fo.png

5. Select Department

**The Bucket and Department MUST relate, for example Equipment Bucket to Equipment Department (often the same). EXCEPTION: (1) Service Supplies Departments correspond to After Market (Sup + Svc) Bucket and (2) MNS Departments correspond to IT Products and IT Service  Buckets 

Select_Dept.png

6. Select Account

**We recommend printing out your list of available accounts to have alongside you as you map accounts (see below screen shot):

Select_Account_-_reference_print_out__screen_shot_below_.png

Print this page accessed under Accounts at top of screen to reference for Select Account mapping. This shows you a breakdown of all the accounts and what generally is placed in those accounts.:

Print_this_page_to_reference_for_Select_Account_when_mapping__screen_shot_above_.png

7. Once mapped you can see your mapping rules in place:

**(1) be sure to add *Include trans with no dept at 100% if you choose to do so via Mapping Rule

Completed_Mapping_Sample.png

Sample multiple mapping for one GL account, diff departments allocated to different accounts:

Sample_multiple_mapping_for_one_GL_account__diff_depts_alocated_to_diff_accounts.png

 

******************************************************************************

Of special note:

We give you the option to Include or exclude all departments (1), GL Branches and GL Divisions. Once you have your selection complete then chose where in the model the selection gets allocated to (2), then click Add Allocation (3).

To map one account to different departments with different allocations, do one complete mapping first to one department (or as many as you wish that are the same), choose save, then add additional mapping rule and map the next department with a different allocation.

Remember if you exclude certain departments you must FIRST go to Included and check All

 

For situations where you might have a set of revenue accounts that have a matching set of cost of goods accounts we allow you to "clone" the mapping.

ScreenClip.png 

NOTE, CLONING COULD SAVE YOU A LOT OF TIME ON THIS PROJECT! 

You can edit a mapping to make changes

ScreenClip.png

ScreenClip.png

Note that you can choose to allocate just a percentage but if your total allocations do not add up to 100% then the results will be highlighted red.

ScreenClip.png

 

It's also a good idea to refer directly to your current SBA Survey to assist with mapping, as in the example below if you are unsure of what bucket to place a MNS account between product or services

mns.PNG 

******************************************************************************

8. When you are finished mapping, or just want to see what the results look like, click the Update Mapped link:

ScreenClip.png

9. Then hit Update Mapped Data:

 ScreenClip.png

Wait for the message to say update complete:

ScreenClip.png

Once mapped you will want to run ID900 to see how the results look, details here.

 

 

 

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk