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

  • Article Type:
  • How To
  • Last Modified:
  • 07/24/2019

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 import trial balance information from Microsoft® Excel® into CCH Financial Prep, do the following:
  1. Within CCH Financial Prep, open the client.
  2. On the left navigation panel, click Trial Balance.
  3. In the 'Import trial balance from' field, click Microsoft Excel.
    • Note: This will open the browse window to locate the file being imported.
  4. Browse to the file location and select the appropriate file being imported.
  5. 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/How-do-I-import-trial-balance-information-from-Microsoft-Excel-into-CCH-Axcess-Financial-Prep
 Direct Link
To provide feedback on this solution, please login.

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