Don't spend your valuable time manually retyping Chart of Accounts or budget data when you don't have to. Get GIC - Import G/L Accounts And Budgets to do it! GIC - Import G/L Accounts And Budgets imports G/L accounts and budgets from other software programs, and prints a control report, if desired. Plus, you get the option to import new accounts and budgets or update existing accounts and budgets.

Notes for Operators:

Before importing, make a backup of General Ledger.

To import accounts and budgets, you must first create a file that conforms to the format explained below. Next, select Maintain Chart of Accounts and press F5 - Import at the Account Number prompt:

+-------------------------------------------------------------------------+
|+=======================================================================+|
||GLMAINT              Maintain Chart of Accounts       COMPANY ID: SP   ||
||07/10/96             Software Professionals, Inc      GENERATION #: 01 ||
|+=======================================================================+|
|                                                                         |
| ACCOUNT NUMBER:      0                                                  |
|                                                                         |
|                                                                         |
|                                                                         |
|                                                                         |
| F1 - Help  F2 - Lookup     F5 - Import    F10 - Done   Shft F10 - Home  |
+-------------------------------------------------------------------------+

Enter the name of file to import, then choose whether to add new accounts and/or update existing accounts:

+-------------------------------------------------------------------------+
|+=======================================================================+|
||GLMAINT              Maintain Chart of Accounts       COMPANY ID: SP   ||
||07/10/96             Software Professionals, Inc      GENERATION #: 01 ||
|+=======================================================================+|
| Import Accounts                                                         |
| File to Import................:                                         |
| Add New Accounts (Y/N)........: Y                                       |
| Update Existing Accounts (Y/N): Y                                       |
|                                                                         |
|                                          F8 - Cancel     F10 - Proceed  |
+-------------------------------------------------------------------------+

Successfully imported accounts will print on the control report, if selected.

Notes for Programmers:

The ASCII file must conform to the following format:

Field Name	Length	Type	Notes
Account Number  5 or 6  Numeric Required entry.  Length depends on set up
                                of company options. If account number
                                already exists, record will be updated
                                IF you asked to update existing accounts.
Account Descr.   25     Alpha
Account Type     1      Numeric Must be a value 1 thru 9, see your
                                Peachtree manual, Using General
                                Ledger, regarding each account type.
Master/Dept      1      Alpha   If Account Type = "2", value can be
                                "M" or "D" if Account Number ends with "00".
Group End       5 or 6  Numeric If Master/Department is "M", Group
                                End must be greater than Account Number.
                                If Master/Department is "D", Group End
                                must be Department 99 of Account Number.
Balance Column   1      Numeric Must be value 0 thru 3, see Peachtree
                                manual, Using General Ledger regarding
                                each option.
Budget Period 1-13 10   Numeric Max. value for each period is 99999999.99,
                                maximum number of periods is determined
                                by setup of the G/L Options file. 

Fields must be separated by commas and must be enclosed in quotes if they contain spaces or commas. All fields may be enclosed in quotes, but quotes are not required unless they contain spaces or commas.

Each account number record starts on a separate line. An example of a new Account Number import record would look like the following:

410000,"Sales Income",2,M,412099,1
411000,"Shop Income",2,,,2,385,315,180,175,220,390,425,475,400,285,325,360
412000,"Storage Income",2,,,3,105,95,92,87,65,45,30,35,40,50,75,95

Import records can make extensive use of default values. If a file contains invalid data, or is only represented by a comma, then the default value will be used.

Following is a list of default values for each field:

Field Name              Default Value
Account Number          No default, required entry
Account Description	Blank
Account Type            "2"
Master/Department	Blank
Group End               Blank unless Master/Department is "M" or "D",
                        then it is Dept. 99 for Acct. No.
Balance Column          "1"
Budget Period 1-13	"0"

An example of an import that updates existing accounts would look like the following:

410000,,,,,,900,900,900,900,900,900,900,900,900,900,900,900
411000,"Retail Shop Income"
412000,,,,,2