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

  • Article Type:
  • How To
  • Last Modified:
  • 05/23/2022

Objectives

To be able to import the trial balance information directly from Microsoft® Excel® into CCH Axcess™ Financial Prep.

Environment

  • CCH Axcess Financial Prep
  • Microsoft Excel

Procedure

This video shows how to Import Trial Balance information directly from Microsoft Excel into CCH Axcess Financial Prep.

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 can be blank or used for header information.
  • Have the following information in the first four to six columns of the worksheet, in this order:
    • Account Number (optional)

      Note: 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.

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

Notes

  • During the trial balance import process, Financial Prep 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 our solution on how to assign or modify groups in CCH Axcess™ Financial Prep.
  Solution Tools
  Attachments
 Solution Id 000102487/000102487
 Direct Link
To provide feedback on this solution, please login.

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