Caseware: Use calculated mappings with Connector


CaseWare Connector has become an indispensible tool for many of us. In addition to financial statements, I’ve used it for audit workpapers, materiality calculations, and more. Until a colleague shared his tip with me, I only had experience connecting individual mapping numbers, group numbers, and individual accounts. Then I was shown how to create a “calculated mapping” for even more flexibility.

As an example, here is how to create a calculated mapping for total assets:

  1. In CaseWare, go to Account –> Assign Mapping Numbers
  2. On the left side of the screen, right-click on an existing mapping number and choose “Properties” or right-click to create a new one. In this example, I have a title mapping called “Assets.”
     SS-2011.02.08-08.09.40
  3. For the Behavior property, click the drop-down menu and choose “Calculated”
     SS-2011.02.08-08.12.04
  4. In the calculation box, enter the range of mapping numbers needed for this calculation in this format:

    [map1]..[map2]

    For this example, I will use mapping number 10110 through 10330 (all of the assets). So the calculation box should look like this:
     SS-2011.02.08-08.15.23

  5. Click OK.
  6. Click Apply.

The mapping should now look like this:

SS-2011.02.08-08.16.53

Now in Excel, you can use the connector to link a cell to this calculated mapping number.

Advertisements
  1. #1 by Michael Hsu on May 11, 2011 - 5:05 pm

    Holy goodness Caseware…. haha. have not touched this thing for 2 years but definitely remember the years of pioneering it. Good knowledge share – all the RSM network firms should read your blog.

  2. #2 by George Roach on July 15, 2013 - 11:57 am

    Tim, I have been looking for help in implementing Caseware. You seem to be the only one out there that knows much about the software. My office is in the NW suburbs of Chicago. Would love to talk to you about Caseware and some ideas on where to get help. thanks George

  3. #3 by Asset Connectors on October 5, 2014 - 9:29 am

    Thanks Asset
    Asset Connectors is one of the top choices utilized to locate owners with our state-of-the-art location tools which successfully locate individual owners, and business contacts for business. connectors

  4. #4 by Maria Fernandez on May 12, 2017 - 10:23 am

    I find this new tool easy to work with because it has many features like Accounting/Bookkeeping (including VAT accounting), Budgeting (current year and long term planning tool (for making figures for business plans) and Analysis (Profitability, Solidity / Finance structure and Cashflow). Download https://www.excel-accounting-budget-analysis.com/

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: