Sage 100 Contractor 1-1 Checks and Bank Charges
Overview:
Import Checks and Bank Charges directly into Sage 100 Contractor. Simply download your checks and bank charges into Excel, review and apply journal transaction information and import directly into Sage 100 Contractor 1-1 Checks and Bank Charges.
Are you tired of manually keying in Checks and Bank Charges one by one into Sage 100 Contractor? Would you rather download your checks and bank charges, 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-1 Checks and Bank Charges data entry form.
Key Features:
- Download Checks and Bank Charges into Excel
- Edit key journal transaction information in Excel
- Bulk import checks and bank charges directly into Sage 100 Contractor
- Supports all native features and functions of the 1-1 Checks and Bank Charges Entry Form
Import Template Download:
Import File Layout:
Header Layout
| Column | Reference | Data Type | Tab | Example | Description |
| COL1 | Required | GLCBC | (File Type Code) | ||
| COL2 | Required | H | (Header Record) | ||
| COL3 | Required | String (20) | Header | 123456 | Check Number |
| COL4 | Required | date | Header | 2023-01-05 | Check 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; 3=Void | Status |
| COL8 | ** | String (20) | Header | Purchase Order Number | |
| COL9 | ** | Numeric | Header | Vendor Recnum | |
| COL10 | String (50) | Header | Payee | ||
| COL11 | String (50) | Header | Payee2 | ||
| COL12 | String (50) | Header | Address 1 | ||
| COL13 | String (50) | Header | Address 2 | ||
| COL14 | String (50) | Header | City | ||
| COL15 | String (2) | Header | State | ||
| COL16 | String (10) | Header | Zip | ||
| COL17 | String (50) | Header | User Defined 1 | ||
| COL18 | String (50) | Header | User Defined 2 | ||
| COL19 | 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 | Debit 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 ** | Equipment 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:
GLCBC,H,13502,2021-12-12,1000,"header description",2,"order number",231,"Sample Company","","123456 West State Road","Suite #13","Davie","FL","33324","user def1","user def2","notes"
GLCBC,D,13502,2250,1156,"detail description",123,"detail user def 1",,,,,,,,,,,,
GLCBC,D,13502,1350,,"detail description jc",456,"detail user def 2",,2017503,,"jc description",5000,1,"jc notes",,,,,
GLCBC,D,13502,5602,,"detail description eq",789,"detail user def 3",,,,,,,,1,"eq description",11000,3,"eq notes"