How do I import trial balance information from Microsoft® Excel® into CCH Axcess™ Engagement?

  • Article Type:
  • How To
  • Last Modified:
  • 07/20/2023


  • To be able to import the trial balance information directly from Microsoft Excel into CCH Axcess Engagement.


  • CCH Axcess Engagement
  • Microsoft Excel


To successfully import a trial balance from an Excel file, your import spreadsheet must:

  • Be a Microsoft Excel 2013 or newer .XLSX file that contains only one worksheet.
  • Begin your accounts on Row 2 of the worksheet. Row 1 must be blank or used for header information.
  • Have the following information in the first 4 to 6 columns of the worksheet, in this order:
    • Account Number (optional)
      • If you do not use account numbers, then leave column A blank.
    • Account Name (required)
    • Current Period Debit Balance (required)
    • Current Period Credit Balance (required)
    • Prior Period Debit Balance (optional)
    • Prior Period Credit Balance (optional)
  • Have no subtotals or extraneous information below or to the right of the data.
  • Have only one instance of each account number and account name.
  • Any accounts with a zero balance, the cells should remain blank.

To perform your import, do the following:

  1. Click the engagement on the Engagement List page.
  2. Do one of the following:
    • For a non-consolidated engagement, click on the navigation bar and select Trial Balance.
    • For a consolidated engagement, click View next to the subsidiary you want to work with. You can also click  on the navigation bar and select Trial Balance, then clickin the gray navigation bar and select the entity you want to work with.
  3. Click Microsoft Excel and browse to the file.
  4. Select the Excel file, and then click Open.

Additional Information


  • During the trial balance import process, Axcess Engagement will apply intelligent groupings that will look at the account descriptions and try to map the account accordingly.
  • Any groups that are not mapped will highlight in red at the top of the trial balance.
For information on assigning a group, see below.
  Solution Tools
 Solution Id 000219516/000219516
 Direct Link
To provide feedback on this solution, please login.

Your feedback about this article will help us make it better. Thank you!