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:
- In CaseWare, go to Account –> Assign Mapping Numbers
- 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.”
- For the Behavior property, click the drop-down menu and choose “Calculated”
- In the calculation box, enter the range of mapping numbers needed for this calculation in this format:
For this example, I will use mapping number 10110 through 10330 (all of the assets). So the calculation box should look like this:
- Click OK.
- 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.