Sage 100 Contractor 1-2 Deposits and Interest
Overview:
Import Deposits and Interest directly into Sage 100 Contractor. Simply download your deposits and interest into Excel, review and apply journal transaction information and import directly into Sage 100 Contractor 1-2 Deposits and Interest.
Are you tired of manually keying in Deposits and Interest one by one into Sage 100 Contractor? Would you rather download your deposits and interest, 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-2 Deposits and Interest data entry form.
Key Features:
- Download Deposits and Interest into Excel
- Edit key journal transaction information in Excel
- Bulk import deposits and interest directly into Sage 100 Contractor
- Supports all native features and functions of the 1-2 Deposits and Interest Entry Form
Import Template Download:
Import File Layout:
Header Layout
| Column | Reference | Data Type | Tab | Example | Description |
| COL1 | Required | GLDI | (File Type Code) | ||
| COL2 | Required | H | (Header Record) | ||
| COL3 | Required | String (20) | Header | 123456 | Deposit Number |
| COL4 | Required | date | Header | 2023-01-05 | Transaction Date |
| COL5 | Required ** | Numeric | Header | 1000 | Ledger Account Recnum |
| COL6 | Required | String (50) | Header | Test Description | Description |
| COL7 | Required | Numeric | Header | 1=Open; 2=Cleared | Status |
| COL8 | String (50) | Header | User Defined 1 | ||
| COL9 | String (50) | Header | User Defined 2 | ||
| COL10 | Text | Header | Notes |
** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor COL: a placeholder must be provided for each column even if no value is provided
Detail Layout
| COL1 | Required | GLCBC | (File Type Code) | ||
| COL2 | Required | D | (Detail Record) | ||
| COL3 | Required | String (20) | Same as header | Journal Number | |
| COL4 | Required ** | Numeric | Detail | Ledger Account Recnum | |
| COL5 | ** | Numeric | Detail | Sub Account Recnum | |
| COL6 | String (50) | Detail | Line Description | ||
| COL7 | Numeric (12,2) | Detail | Credit Amount | ||
| COL8 | String (50) | Detail | User Defined 1 | ||
| COL9 | String (20) | WIP / Direct Exp * | Workorder Number | ||
| COL10 | ** | Numeric | WIP / Direct Exp * | Job Number | |
| COL11 | ** | Numeric | WIP / Direct Exp * | Phase Number | |
| COL12 | String (50) | WIP / Direct Exp * | Description | ||
| COL13 | ** | Numeric (15,3) | WIP / Direct Exp * | Cost Code | |
| COL14 | ** | Numeric | WIP / Direct Exp * | 1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-Utilities; 7-UserDef7; 8-UserDef8; 9-UserDef9 | Cost Type |
| COL15 | Text | WIP / Direct Exp * | Notes | ||
| COL16 | ** | Numeric | Equip Exp ** | Equip Number | |
| COL17 | String (50) | Equip Exp ** | Description | ||
| COL18 | ** | Numeric (15,3) | Equip Exp ** | Cost Code | |
| COL19 | ** | Numeric | Equip Exp ** | 1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-Utilities; 7-UserDef7; 8-UserDef8; 9-UserDef9 | Cost Type |
| COL20 | Text | Equip Exp ** | Notes |
** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor
COL: a placeholder must be provided for each column even if no value is provided
WIP / Direct Exp * - Required if the lgract (Col 4) is assigned to [3 - WIP Assets] or [13 - Direct Expense] account type
Equip Exp** - Required if the lgract (Col 4) is assigned to [14 - Equip/Shop Expense] account type
File Example:
GLDI,H,13502,2021-12-12,1000,"header description",2,"user def1","user def2","notes"
GLDI,D,13502,2250,1156,"detail description",123,"detail user def 1",,,,,,,,,,,,
GLDI,D,13502,1350,,"detail description jc",456,"detail user def 2",,2017503,,"jc description",5000,1,"jc notes",,,,,
GLDI,D,13502,5602,,"detail description eq",789,"detail user def 3",,,,,,,,1,"eq description",11000,3,"eq notes"