Refresh GL balances after posting journals

Once you have uploaded your journals into your accounting software, you have the ability to refresh the general ledger balances in the workpapers. Depending on the software you are using, different instructions apply to import data. Follow the onscreen prompts or the instructions below.

There are two options for refreshing data from the iFirm general ledger:

  • Save and close your workpaper and wait for “Workpaper Saved” message from your iFirm tray app to appear, Reopen the workpaper from iFirm GL and select option to Update Ledger Data.
  • If you want to update the trial balance data but do not want to close and re-open the Workpaper file, follow these steps:
  1. Open the relevant client ledger in Client Accounting.
  2. On the General Ledger tab, click the green arrow next to the Reports button .
  3. Click Refresh Workpaper Balances - this exports a CSV file in the format required by the workpaper.
  4. Open the B1 sheet in the Excel worksheet.
  5. Click Refresh data.
  6. Browse and select the CSV file that was downloaded from iFirm and click Open.

To save time browsing for the CSV file, use the field provided on B1 to create a hyperlink base. See B1 Review Summary to learn more.

Watch video

On the CCH Workpapers ribbon, click the Refresh GL Data button. General ledger balances have now been updated.

On the CCH Workpapers ribbon, click the Refresh GL Data button.General ledger balances have now been updated.

  1. On the CCH Workpapers ribbon, click the Refresh GL Data button.General ledger balances have now been updated.

  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 Refresh Data button.
  3. Click the browse button.
  4. Browse to the Excel trial balance file saved for your client, and select it.

  1. Export the client's trial balance from MYOB AE (Common Ledger) to an Excel file.
  2. On the CCH Workpapers ribbon, click the Refresh GL Data button.
  3. Click the browse button.
  4. Browse to the trial balance Excel file saved for your client, and select it.

  1. On the CCH Workpapers ribbon, click the Refresh GL Data button.General ledger balances have now been updated.

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: Reports > All reports > Trial Balance.
    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 Refresh 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.