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.”
    
3. For the Behavior property, click the drop-down menu and choose “Calculated”
    
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:
    

5. Click OK.
6. Click Apply.

The mapping should now look like this:

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