Import data from the general ledger

This functionality allows you to import general ledger data from your client accounting software into the workpapers. Depending on the software you are using, different instructions apply to import data. Follow the import wizard or the instructions below.

If the Import GL button is not active, go to the Admin Setup page and choose your accounting software from the drop down list. If you do not have access to this page please contact your workpaper administrator.

When using iFirm with Client Accounting, general ledger balances are automatically updated when the workpaper is opened from the clients general ledger.

For specific instructions visit the iFirm help centre: or

Watch video

  1. On the CCH Workpapers ribbon, click the Import GL Data button.
  2. Browse to the client’s XPA file for APS and select it.
  3. Click Get data to import data into the workpapers.

  1. On the CCH Workpapers ribbon, click the Import GL Data button.
  2. To import via client number: select the Enter client no. check box and enter the client number into the box.
  3. To import via file path: click the Browse button to browse to relevant client MYOB AO file and select it.
  4. Click Get data to import data into the workpapers.

If you receive a message stating ‘unable to import data’ for one client and have successfully imported data for others, try clearing the IRD Number check box and import the data again.

  1. On the CCH Workpapers ribbon, click the Import GL Data button.

  2. Enter the client number into the box.

  3. Click Get data to import data into the workpapers.

  1. Export the client trial balance from MYOB AE to an Excel file:
    1. Within MYOB AE, navigate through System Services to Reporter.
    2. Go to Generate Reports and select Detailed Trial Balance.
    3. Select Export with the Save as type set to Excel.
    4. Save the Excel file with the client name to the folder designated to file exported trial balances.
  2. On the CCH Workpapers ribbon, click the Import GL Data button.
  3. Click the browse button.
  4. Browse to the Excel trial balance file saved for your client, and select it.
  5. Click Get data to import data into the workpapers.

  1. On the CCH Workpapers ribbon, click the Import GL Data button.

  2. Click the browse button.

  3. Browse and select your client's Trial Balance Excel file.

  4. Click Get data to import data into the workpapers.

  1. On the CCH Workpapers ribbon, click the Import GL Data button. The Reckon One login screen will appear

  2. Enter login details and click Sign in
  3. Select your client book from the drop down list and click OK

Disconnect

To disconnect (or log the current user out) from Reckon One on your computer,restart Excel.

If you have chosen the Remember My Login option when logging into Reckon One from the workpapers, you may also need to:

  1. Remove permissions for CCH Workpapers from the Reckon permissions page
  2. Restart Excel
  3. Click Import GL data button
  4. Click email address at top left of screen > Log out

The Xero integration process has changed. View our new help file.

  1. Export client trial balance from Xero to Excel file:

    1. Within Xero, navigate through: Accounting > Reports > Accounting > [click the More reports dropdown at the bottom of the section] > Trial Balance.

      This is the old Trial Balance report.

    2. Sort by Account code and click Update.
    3. Export to Excel.
    4. Save the Excel file with the client name to the folder designated to file exported trial balances.
  2. On the CCH Workpapers ribbon, click the Import GL Data button.
  3. Click the browse button.
  4. Browse to the Excel trial balance file saved for your client, and select it.
  5. Click Get data to import data into the workpapers.