Migrating Trial Balances from Keytime Compac

The migration of Trial Balance data from Keytime Compac to IRIS Elements consists of three steps:

Download your client Trial Balances from Keytime Compac

  1. In Keytime Compac, navigate to your client accounts.

  2. Go to Trial Balance and open the Current TB.

  3. Select Menu F4 and then CSV file. Your CSV file is now saved to the default location to your computer.

  4. Repeat this for each client you want to migrate to IRIS Elements.

Map your data to IRIS Elements

  1. Download this example CSV file.

    The trial balance CSV import file must be structured as: Account,Description,Year End dd/mm/YYYY. For more information, go to Manually create a trial balance CSV file.

  2. Reorder your data so it matches the example file format. Open your saved file from the previous step and make the following changes:

    • Apply a negative value to Column F

    • Concatenate Columns E and F

    • Remove Columns C and D

  3. Download this mapping file.

  4. Apply the mapping code to your data.

    For example, where the Compac Accounts chart code was 12, in IRIS Elements it is 130.

    If you are experienced with using Excel, you can speed up this process by temporarily adding another column to your file with the IRIS codes in it and then performing a vlookup. Remember to remove this added column once you have mapped the codes.

Create your clients and import their Trial Balance data to IRIS Elements

  1. Open IRIS Elements and create your clients. For information on how to do this, go to Add clients.

  2. Import your trial balance data for each client. For information on how to do this, go to Import trial balance data from a CSV file.

We also have a video to show you how to import: Manually enter or import trial balances.