Chart of Accounts Import Template

Use the Chart of Accounts Import Template in conjunction with the Import Setup Data screen function to import the accounts that form your general ledger. The Chart of Accounts Import Template contains the following worksheets:

Each worksheet corresponds directly to a tab of the related entry screen in ProContractor. Required fields in a worksheet are highlighted yellow; fields that are required only under certain conditions are highlighted gray. Viewpoint suggests formatting all values as text in the Excel template.

Include the primary information for the records you want to import on the first worksheet, ensuring that that each record has unique values in the key fields for the import type. For most import types, the first worksheet is the only worksheet that is required. If there are additional worksheets in the template, use the additional worksheets as needed to provide record details. When importing, ProContractor uses the key fields for the import type to prevent duplicate records and to link detail records to primary records.

For example, the key fields for the Chart of Accounts import type are Company and Account. In the Chart of Accounts import template, include a record for each new account in the Account worksheet, ensuring that each record has unique values in the Company and Account fields. If needed, include details for those accounts in the Division, Subaccount, and UDF worksheets.

Account worksheet


	Company	Account	Account Name	Account Type	Normal Balance	Status	Division Posting Level	Use Subaccounts
1	05	1001	Petty Cash	Cash Account	Debit	Active	Both Corporate and Divisional	Yes
2	05	1007	Checking	Cash Account	Debit	Active	Corporate Only	No

Division worksheet


	Company	Account	Division	Allow Posting
1	05	1001	HOME	Yes
2	05	1001	NW	Yes
3	05	1001	SW	Yes

Subaccount worksheet


	Company	Account	Subaccount	Name	Status
1	05	1001	50	Petty Cash: Middletown	Active

UDF worksheet


	Company	Account	UDF_01	UDF_02	UDF_03
1	05	1001	01/22/2023	Yes	23,345.65

If a detail record does not match a primary record based on key field values, ProContractor marks the detail record as "orphaned" during the validation process. If you continue with the import without correcting orphaned records in the import file, you must manually enter the orphaned records into the system.

Importing the chart of accounts is the first step in importing setup data and is done during the IInitial Setup of ProContractor. Before importing the chart of accounts, you must complete the following setup:

Companies and divisions (manual entry only)
Tax authorities (manual entry only)

Help voor Trimble producten

Chart of Accounts Import Template