General Ledger Imports - Chart of Accounts

Knowledge Base · Importing Data

Applies to: All Supported Versions  |  Platform: macOS, Windows, Connected on Demand

ARTICLE CONTENTS

1. Overview
2. Preparing Connected
3. Preparing the Spreadsheet
4. Importing
5. Possible Errors
6. Related Articles

1. Overview

Use this function to reduce the time entering your chart of accounts or to transfer an existing chart from another software package.

2. Preparing Connected

Before importing the chart of accounts you must have completed the following:

• Entered your Company Information in the General Setup screen.
• Defined your Profit Centers and Departments if appropriate.

There are certain fields that are essential for the import; they are indicated with red labels and show in the following Accounts Import screen.

3. Preparing the Spreadsheet

Before importing data, you will need to review and prepare your spreadsheet according to the import order and field requirements. The following reviews the field requirements for the Accounts import.

1. Account No - Must appear as xxxxx-xx-xx. If Profit Centers and Departments are not active, please ensure that the Account No. appears as xxxxx-00-00. This is a numeric field.
2. Description - Alphanumeric field. Maximum length 30 characters.
3. Category- Select from the following shown in the screen below (case sensitive). The category labels can be changed to fit individual company needs and therefore they should be reviewed prior to importing.
   

4. Importing

To import Accounts into the General Ledger:

1. Select Import from the File menu and choose Accounts. The Accounts Import window appears.
   
2. Click Start Import and choose the file that you want to import from the selection window. If you have not placed it into the same folder as your data file, you will have to navigate through your folders/directories to find it.
3. A final warning message will appear reminding you to make sure that you have a backup before proceeding. Click Yes to continue or No to cancel.
4. When the import is complete, an OK message will appear indicating how many successful records.

5. Possible Errors

• Invalid Account No. - Does not match xxxxx-xx-xx
• Invalid Account No. - Invalid Profit Center code
• Invalid Account No. - Invalid Department code
• Invalid category code - (Case sensitive)
• Duplicate Account No.

6. Related Articles

• G/L Transactions (aka Journal Entries) Import
• Quick Invoice Import for E-Commerce Transactions
• Importing Account Invoices and/or Credit Memos
• Importing to Add or Update A/R Sales Taxes
• Adding a General Ledger Account
• Connected 10.2 Change Log - September 2020
• General Ledger: Trial Balance Report
• My Reports