How to add modify remove Map Flip Settings

How to add modify remove Map Flip Settings

CaseWare templates are designed to automatically flip accounts to the opposite side of the ledger, based on their imported sign.

For example, if cash at bank account was once credit in the prior year but is now a debit (bank overdraft) this year, CaseWare will automatically (flip) the amount to the opposite sign (being current liabilities).
However, for certain instances, we might need to have credit balance accounts consolidated with debit balances (or vice versa). We are able to stop CaseWare from automatically flipping by removing the Map Number flip account.

For example, cash will automatically flip to Interest Bearing Liabilities / Bank Overdraft. In order to remove this please follow the steps below.
Open the CaseWare Engagement File. 
1. From the Navigation Toolbar, select Trial Balance. The Working Trial Balance will open.

2. Locate the Map No Column heading and right click on the heading. The appropriate right-click menu will appear. 

3. From the right-click menus, select Show|Map No (Flip). The appropriate column will appear.



4. For the account which you do not wish to flip, delete the Numbers from the Map No (Flip) column, corresponding to the account (in this example it will be the Map no (Flip) corresponding to cash - these map numbers will be for Bank overdraft).
Note: There are also flips contained within L/S. In order to remove these, you need to repeat steps 2) through to 5) replacing Map No with L/S and Map No (Flip) with L/S (Flip).
Adding / Modifying Flip Account settings
All flip properites are added/modified following the steps below:
1. From the ribbon, select Account tab | in the Assign area | Assign Mapping Numbers. The appropriate screen will open.

2. Click the Flip button.
​
3. Assign accounts to the opposite area, the same way you would map an account. 


 


    • Related Articles

    • Cloud Financials Process Map

      The Cloud Financials process map attached below provides Caseware Cloud Financials users with an efficient and effective step-by-step approach to generating a set of financial statements. To go alongside the process map, we have a series of FAQs to ...

    • Why is my Trial balance balancing in Excel but not in CaseWare

      If your trial balance in Microsoft Excel is balancing well, but not in CaseWare it is likely that there are existing duplicated account numbers within your Excel Spreadsheet. CaseWare Working Papers will only allow unique account numbers to be ...

    • Firm settings for Caseware Sherlock

      Processing Messages The Processing Messages report displays information about the numerous data extraction processes that occur each day. To view the Processing Messages report: Ensure that you have the Settings Admin role or equivalent privileges. ...

    • Agile Audit Process Map

      The Agile Audit process map attached in this FAQ below illustrate the best methodology to use our CaseWare Agile Audit for an audit engagement. To go alongside the process map, a series of FAQs are below to provide details on parts of the process ...

    • How do I Change the Colour of the Working Trial Balance

      Users can change the colour scheme of the Working Trial Balance. To do this: 1. From the Tools tab, select Options to display the 'Options' dialog. 2. From the 'Properties' menu select General. 3. From the 'Colour Scheme' picklist select from the ...