You are able to import trial balances or transactions into CCH Accounts Production from .csv (comma delimited) files.

Set up

The standard structure of a .csv(comma delimited) file for a trial balance file to be imported is 3 or 4 columns for a single year dependent upon whether the debit/credit figures are in one column (credit will be entered as negative and debit as positive) or if they are split into two columns.

For example: column A = external code, column B = external description and column C = TB figures to be imported. 

If you wish to use an alternative structure, before you use the import option, you need to setup the structure of the file to import and optionally a nominal mapping so that CCH Accounts Production understands how to import the data.  The Mapping and File Structure areas are found under File > Maintenance > Accounts > Import/Export Definition and allow you to save the structure and mappings once created.

Importing a Trial Balance

  1. To import trial balances select Import from the Task Bar to the left of the screen.

    Accounts_Production_Data-Entry-Task-Bar_Transactions_Import_1.png
     
  2. From CSV File click on the ellipsis button ... to browse and select the file to import (the file must be a .csv (comma delimited) file and must be closed).  If your source file has headers, check this box and enter the number of rows.  These will then be ignored when the import is processed.
  3. Import type click on the drop down arrow to select Trial Balance, selecting this will reverse any existing trial balance for the period.
  4. Mapping Name click on the drop down arrow to select the relevant mapping or leave as none if using CCH nominal codes.
  5. Structure Name choose the structure that relates to the file to be imported.
  6. Click Preview to show the details.
  7. Check the box Show Unmapped Only to show any unmapped items and map these directly in the grid.  For the unmapped item the row under the column header To will be blank, click into this blank cell and enter the code or description, if the code does not exist press F10 will allow a new code to be created, if you have permission.  Uncheck the Show Unmapped Only box to show all rows.
  8.  Import button to the right Once you have reviewed all contents, click the Import button to the right of the screen to import the data. 

    Provided the imported data balances it will be posted, otherwise you will receive a message that the data does not balance and the batch will not be posted, you will need to make any corrections and re-import.

Accounts_Production_Data-Entry-Task-Bar_Transactions_Import_2.png

From: the nominals codes from the system being imported from, e.g. a 3rd party software.

Description: the 3rd party software / external description

To: The CCH Accounts Production nominal code

Amount: the current year's figures being imported, credits are shown as negative and debits as positive.  Prior years will then follow to the right if applicable.

Importing Transactions

The process is similar to that described for importing a trial balance, the differences being:

  1.  Import type chooseTransactions, the transactions imported will be appended to the existing transactions in the system and will be dated with the current period end date.
  2. Structure Name choose Transaction Listing (unless any others have been created within your organisation).
  3. You may only import transactions into the current year.

Accounts_Production_Data-Entry-Task-Bar_Transactions_Import_3.png

Nominal Debit From:  The nominal debit codes from the system being imported from.

Nominal Debit To:       The CCH Accounts Production nominal debit account that the balance will be posted to.

Nominal Credit From: The nominal credit codes from the system being imported from.

Nominal Credit To:      The CCH Accounts Production nominal credit account that the balance will be posted to.

Amount:                         All amounts are shown as positive as the nominal determines whether a debit or credit entry

Ribbon

Accounts_Production_Data-Entry-Task-Bar_Transactions_Import_4.png

Print generates a formatted report of the trial balance(s) or transactions which may then be printed or exported to Excel, PDF, Html or Email.

Export allows you to export the trial balance(s) or list of transactions displayed to Excel.

Related documents

CCH Accounts Production 2026.3: Release Notes
Release Notes for CCH Accounts Production 2026.3
Financial statements - all entities
This document provides a comprehensive overview of financial statement management within a CCH entity. It details functionalities such as searching, filtering, and reordering pages and notes. Users can validate entries, generate print options, and customize the inclusion of specific pages. It outlines features for previewing and downloading financial statements in various formats, and includes management and lead schedules relevant to the entity. Additionally, it describes options for displaying draft messages and exporting documents to different formats. Overall, it serves as a guide for efficiently managing financial statements.
Statutory Database Access and Navigation
The document provides instructions for accessing and navigating the statutory database within the Financial Reporting folder. It describes the tree structure of the database, including how to expand and collapse folders. Key features include a search function for locating terms and reference codes, options to filter active nodes, and custom paragraphs. The document also discusses using various lookup functions from the ribbon, allowing users to reference named ranges, compliance terms, and statutory data. Users are advised to check custom paragraphs after year-end and avoid opening the statutory database multiple times.
Statutory Database Selections and Data Entry
The document provides a guide on using the Statutory Database for reporting under FRS 102, specifically for Limited entities. It outlines methods for direct browsing of database nodes, making client-specific choices (like audit exemptions), selecting and editing paragraphs, reverting to master paragraphs, and entering data into grids. Key features include customizable paragraphs and grid functionality for various financial metrics. The document emphasizes user navigation and the importance of making accurate selections in line with company size and reporting requirements. Screenshots illustrate the process throughout, enhancing clarity.
FRS 102 Group Accounts User Guide
This user guide details the CCH Accounts Production FRS 102 Consolidation formats, specifically for preparing group financial statements under FRS 102. It emphasizes the prerequisites, application, and setup of group accounts, noting the need for compliant financial statements from subsidiaries. The guide outlines key procedures for integrating parent and subsidiary entities, adjustments for mixed entities and non-controlling interests, and nuances in reporting. It also highlights important updates in Master Pack 46, including the 2024 Periodic Review and essential practices for preparing consolidated accounts, ensuring users can generate accurate and compliant financial reports.