{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Overview","Deposits and Interest Form","Grid Sample","misc"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":20,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Overview","index":0,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"version: 2024-01-31"]
[]
[null,"General Ledger 1-2 Deposits and Interest"]
[null,"The following template should be used to import Deposits and Interest into Sage 100 Contractor.  "]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Header Layout"]
[]
[null,"Column","Reference","Data Type","Tab","Example","Description"]
[null,"COL1","Required",null,null,"GLDI","(File Type Code)"]
[null,"COL2","Required",null,null,"H","(Header Record)"]
[null,"COL3","Required","String (20)","Header",123456,"Deposit Number"]
[null,"COL4","Required","date","Header","2023-01-05","Transaction Date"]
[null,"COL5","Required **","Numeric","Header",1000,"Ledger Account Recnum"]
[null,"COL6","Required","String (50)","Header","Test Description","Description"]
[null,"COL7","Required","Numeric","Header","1=Open; 2=Cleared","Status"]
[null,"COL8",null,"String (50)","Header",null,"User Defined 1"]
[null,"COL9",null,"String (50)","Header",null,"User Defined 2"]
[null,"COL10",null,"Text","Header",null,"Notes"]
[]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[null,"COL: a placeholder must be provided for each column even if no value is provided"]
[]
[]
[null,"Detail Layout"]
[null,"COL1","Required",null,null,"GLCBC","(File Type Code)"]
[null,"COL2","Required",null,null,"D","(Detail Record)"]
[null,"COL3","Required","String (20)",null,"Same as header","Journal Number"]
[null,"COL4","Required **","Numeric","Detail",null,"Ledger Account Recnum"]
[null,"COL5","**","Numeric","Detail",null,"Sub Account Recnum"]
[null,"COL6",null,"String (50)","Detail",null,"Line Description"]
[null,"COL7",null,"Numeric (12,2)","Detail",null,"Credit Amount"]
[null,"COL8",null,"String (50)","Detail",null,"User Defined 1"]
[null,"COL9",null,"String (20)","WIP / Direct Exp *",null,"Workorder Number"]
[null,"COL10","**","Numeric","WIP / Direct Exp *",null,"Job Number"]
[null,"COL11","**","Numeric","WIP / Direct Exp *",null,"Phase Number"]
[null,"COL12",null,"String (50)","WIP / Direct Exp *",null,"Description"]
[null,"COL13","**","Numeric (15,3)","WIP / Direct Exp *",null,"Cost Code"]
[null,"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"]
[null,"COL15",null,"Text","WIP / Direct Exp *",null,"Notes"]
[null,"COL16","**","Numeric","Equip Exp **",null,"Equip Number"]
[null,"COL17",null,"String (50)","Equip Exp **",null,"Description"]
[null,"COL18","**","Numeric (15,3)","Equip Exp **",null,"Cost Code"]
[null,"COL19","**","Numeric","Equip Exp **","1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-Utilities; 7-UserDef7; 8-UserDef8; 9-UserDef9","Cost Type"]
[null,"COL20",null,"Text","Equip Exp **",null,"Notes"]
[]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[null,"COL: a placeholder must be provided for each column even if no value is provided"]
[null,"WIP / Direct Exp * - Required if the lgract (Col 4) is assigned to [3 - WIP Assets] or [13 - Direct Expense] account type"]
[null,"Equip Exp** - Required if the lgract (Col 4) is assigned to [14 - Equip/Shop Expense] account type"]
[]
[null,"File Example:"]
[null,"GLDI,H,13502,2021-12-12,1000,\"header description\",2,\"user def1\",\"user def2\",\"notes\""]
[null,"GLDI,D,13502,2250,1156,\"detail description\",123,\"detail user def 1\",,,,,,,,,,,,"]
[null,"GLDI,D,13502,1350,,\"detail description jc\",456,\"detail user def 2\",,2017503,,\"jc description\",5000,1,\"jc notes\",,,,,"]
[null,"GLDI,D,13502,5602,,\"detail description eq\",789,\"detail user def 3\",,,,,,,,1,\"eq description\",11000,3,\"eq notes\""]

{"sheet":"Deposits and Interest Form","index":1,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,2,3,3],[4,2,4,3],[6,2,6,3],[5,2,5,3],[15,14,15,18],[15,7,15,13],[9,2,9,3],[10,2,10,3],[12,2,12,3]]}
[null,"Sample Deposits and Interest Form"]
[]
[]
[null,"Deposit Number: *",123456789]
[null,"Date: *","01/15/2024"]
[null,"Account: *",1000]
[null,"Description: *","Test DI"]
[null,"Status:",1]
[]
[null,"User Def 1:"]
[null,"User Def 2:"]
[]
[null,"Notes:","notes"]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F18:F153)","v":400},null,"Use if the Ledger Acct is a [3 - WIP Assets] or [13 - Direct Exp] account type ",null,null,null,null,null,null,"Use if the Ledger Acct is a [14 - Equip/Shop Exp] account type "]
[null,null,"Ledger Acct Recnum *","Sub Account Recnum","Line Description","Credit Amount *","User Defined 1","Workorder Number","Job Number *","Phase Number","Job Description *","Job Cost Code *","Job Cost Type *","Job Notes","Equip Number *","Equip Description *","Equip Cost Code *","Equip Cost Type *","Equip Notes"]
[null,null,1000,null,"DI Line 1",-100]
[null,null,6002,null,"DI Line 2",100]
[null,null,6002,null,"DI Line 3",100]
[null,null,6014,null,"DI Line 4",100]
[null,null,5003,null,"JC Line 1",50,null,null,2017008,null,"Test DI 1","2120.000",4]
[null,null,5001,null,"JC Line 2",50,null,null,2017008,null,"Test DI 2","2120.000",4]
[null,null,5601,null,"EQ Line 1",50,null,null,null,null,null,null,null,null,1,"Test DI 1","2030.000","3"]
[null,null,5602,null,"EQ Line 2",50,null,null,null,null,null,null,null,null,2,"Test DI 2","2040.000","3"]

{"sheet":"Grid Sample","index":2,"n_rows":10,"n_cols":21,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"Sample Deposits and Interest Template"]
[]
[]
[null,"Col 1","Col 2","Col 3","Col 4","Col 5","Col 6","Col 7","Col 8","Col 9","Col 10","Col 11","Col 12","Col 13","Col 14","Col 15","Col 16","Col 17","Col 18","Col 19","Col 20"]
[null,"GLCBC","H","Check Number","Check Date","Ledger Account Recnum","Description","Status","User Defined 1","User Defined 2","Notes"]
[null,"GLCBC","D","Journal Number","Ledger Account Recnum","Sub Account Recnum","Line Description","Credit Amount","User Defined 1","Workorder Number","Job Number","Phase Number","Description","Cost Code","Cost Type","Notes","Equipment Number","Description","Cost Code","Cost Type","Notes"]
[]
[null,"GLCBC","H",123456789,"2017-07-20",1000,"Test DI",0]
[null,"GLCBC","D",123456789,1000,null,"DI Line 1",100]
[null,"GLCBC","D",123456789,6040,null,"DI Line 2",200]

{"sheet":"misc","index":3,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["1 - Open"]
["2 - Cleared"]