Company Info

Sage 100 Contractor 1-7 Ledger Accounts

Overview:

Import Ledger Accounts directly into Sage 100 Contractor. Simply download your ledger accounts into Excel, review and apply ledger account information and import directly into Sage 100 Contractor 1-7 Ledger Accounts.

Are you tired of manually keying in Ledger Accounts one by one into Sage 100 Contractor? Would you rather download your ledger accounts, fill in the blanks in Excel and import the details directly into Sage 100 Contractor? The following integration template allows you to do just that. It mimics every feature and function of the 1-7 Ledger Accounts data entry form.

Key Features:

Import Template Download:

Import File Layout:

HeaderReferenceData TypeTabExampleDescription
filetypeRequiredGLLAGLLAGLLA
recnumRequiredNumericGL Account No
lngnmeRequiredString (50)GL Account Name
shtnmeRequiredString (30)GL Short Name
acttypRequired **Numeric1-Cash Accounts; 2-Current Assets; 3-WIP Assets; 4-Other Assets; 5-Fixed Assets; 6-Depreciation; 7-Current Liab; 8-Long Term Liability; 9-Equity; 10-Owner's Drawing; 11-Operating Income; 12-Other Income; 13-Direct Expense; 14-Equip/Shop Exp; 15-Overhead Exp; 16-Admin Exp; 17-After Tax Inc ExpAccount Type
sumact**NumericSummary Account
subact**Numeric0=None; 1=Subaccounts; 2=DepartmentsSubsidiary type (1)
csttyp**Numeric0=None; 1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-UserDef6; 7-UserDef7; 8-UserDef8; 9-UserDef9Cost Type (2)
jobsubNumeric0=No; 1=YesUse Job No as subaccount
iscrcdNumeric0=No; 1=YesIs Credit Card
ntetxtTextNotes


Required(I) - required for inserts only
** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor
(1) Not allowed for 1-Cash Accounts or the following designated accounts [Finance Charge, Discounts Given, Retained Earnings, Discounts Earned and Inventory Offset Account]
(2) Only available [3-WIP Assets, 13-Direct Expense, 14-Equip/Shop Exp]


File Example:
filetype,recnum,lngnme,shtnme,acttyp,sumact,subact,csttyp,jobsub,iscrcd,ntetxt
GLLA,1001,"Cash Checking","Cash Check",1,,,,,,""
GLLA,2081,"Loan Payable","Loan Pay",2,,,,,,""


REQUEST A DEMO

System Requirements:

Requires the Sage 100 Contractor Data Integration Suite