Trial Balance Import Wizard (Custom CSV)

You will now be guided through the custom CSV import process with our Import Wizard. For your convenience, we have summarised the three key steps below:

Step 1 - Open the Trial Balance Import Wizard

1. Open the Trial Balance in your file and Select Import Trial Balance.
   
   

2. Select the Custom CSV import option.

   

3. Click on the Choose File button;

   
   
   

4. Browse through your local computer to find the saved trial balance;

5. Click on the trial balance to select it;

6. Click Open;

7. Click on the blue Upload button.
   

    

Step 2 - Specifying the Trial Balance columns

1. Select the header line of the trial balance;
   
   

2. Select the appropriate Account Code, Account, Debit, Credit columns and Quantity of the trial balance using the drop down menus;
   

3. Tick the appropriate import properties boxes;
   
   
   Note: If Reset previously mapped values is ticked, codes & account descriptions will remain but all previous values including prior year data will be removed. However, if delete existing imported data is ticked it will remove everything including name, code, tickmarks, and comments.

1. Click Next.

Step 3 - Trial Balance check

1. Ensure the Account #, Accounts, Debit and Credit columns are correctly specified to the trial balance being imported;
   
   

2. Ensure the debits and credits of the trial balance agree at the bottom of the screen;

3. Select the period being imported, being either interim or initial;
   
   

4. Click Import.

5. Click OK to confirm the period being imported is correct;
   
   

6. Your trial balance has now been successfully imported into MyWorkpapers and is ready for mapping.