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.

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

  1. On the CCH BFNZWorkpapers 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 BFNZWorkpapers 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 BFNZWorkpapers 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.

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

  1. Select Xero as System name on Setup sheet
  2. In the field below the System name, browse to folder you wish to download trial balance report to (usually downloads folder)
  3. Export client trial balance from Xero to Excel file:

    1. Within Xero, navigate through: Reporting > All reports > Select the Trial Balance report

    2. Export to Excel and save to the designated folder
  4. On the CCH BFNZWorkpapers ribbon, click the Import GL Data button.
  5. Click the browse button.
  6. Browse to the Excel trial balance file saved for your client, and select it.
  7. Click Get data to import data into the workpapers.