Importing Data

Last modified 16:38, 17 Sep 2013

Overview

You can choose to import transactions or trial balances into CCH Accounts Production.

Import a Trial Balance

  1. To import trial balances select Import from the CCH AP Task Bar:

  2. Select the Import Trial Balance, the Mapping Name to use and the Structure Name that relates to the file to be imported. Finally, select the file containing the trial balance to import. On selecting the file it will be loaded and the result displayed in the grid, showing:

From

The nominal codes from the system being imported from.

To

The CCH AP nominal account that the balance will be posted to.

N columns

The remaining data that will be posted to the fields shown in the column headings

  1. If there are any nominal codes in the file to be imported that are not included in the mapping file, they will be shown in the grid but the To field will be blank. To restrict the grid to only show these unmapped lines, use the Show Unmapped Only check box. Enter the missing codes directly into the grid.
  2. Once you have reviewed the contents of the grid, and provided any missing codes, click [Import] to import the data.
    The system will reverse the current balances in the trial balance and generate a journal batch posting the imported balances. Provided the imported data balances it will be posted into the system, otherwise you will receive a message that the data does not balance and the batch will be left unposted so that you can load and correct it before it is committed.

Errors in the Import File

If there is an error in the import file a window is displayed after you select the Import button. The window includes a hyperlink in the final column which will highlight the error in the grid containing the data enabling you to easily adjust the data.

Import Transactions

The process for importing transactions is exactly the same as described for importing a trial balance but with Import transactions selected. In this case, the current trial balance is not reversed but the transactions imported will be appended to the existing transactions in the system. The imported transactions will be dated with the current period end date.

Nominal Debit From

The nominal debit codes from the system being imported from.

Nominal Debit To

The CCH AP 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 AP nominal credit account that the balance will be posted to.

N columns

The remaining data that will be posted to the fields shown in the column headings.

Page statistics
2252 view(s) and 17 edit(s)
Social share
Share this page?

Tags

CCH Accounts Production

Comments

You must to post a comment.

Attachments

 

 | Cookie Policy | Copyright | Privacy Policy Terms of Use | Contact Us |