{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Overview","Journal Entry 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":68,"n_cols":7,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,3,0,4]]}
[null,null,null,"Version: 2024-12-17"]
[]
[null,"General Ledger - 1-3 Journal Transactions "]
[null,"The following template should be used to import Journal Entries into Sage 100 Contractor.  "]
[]
[null,"File Layout Specification"]
[]
[null,"Header Layout"]
[]
[null,"Column","Reference","Data Type","Tab","Example","Description"]
[null,"COL1","Required",null,null,"GLJE","(File Type Code)"]
[null,"COL2","Required",null,null,"H","(Header Record)"]
[null,"COL3","Required","String (20)",null,"123_abc","Journal Number"]
[null,"COL4","Required","date",null,"2018-01-05","Journal Accounting Date"]
[null,"COL5","Required","String (50)",null,"Test Journal Entry","Journal Description"]
[null,"COL6","Required","Numeric",null,"1=Open; 2=Cleared","Journal Status"]
[null,"COL7","**","String (20)",null,null,"Purchase Order Number"]
[null,"COL8","**","Numeric",null,"0=Adjust;1=Check;2=Dep","Bank Category"]
[null,"COL9","**","Numeric",null,null,"Vendor Recnum"]
[null,"COL10",null,"String (50)",null,null,"Payee"]
[null,"COL11",null,"String (50)",null,null,"Payee2"]
[null,"COL12",null,"String (50)",null,null,"Address 1"]
[null,"COL13",null,"String (50)",null,null,"Address 2"]
[null,"COL14",null,"String (50)",null,null,"City"]
[null,"COL15",null,"String (2)",null,null,"State"]
[null,"COL16",null,"String (10)",null,null,"Zip"]
[null,"COL17",null,"String (50)",null,null,"User Defined 1"]
[null,"COL18",null,"String (50)",null,null,"User Defined 2"]
[null,"COL19",null,"Text",null,null,"Notes"]
[null,"COL20","(1)","Date",null,null,"Posting Period"]
[]
[null,"** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor"]
[null,"COL: a placeholder must be provided for each column even if no value is provided"]
[null,"(1) If posting period is left blank then the Journal Accounting Date will be used as the posting period"]
[]
[null,"Detail Layout"]
[null,"COL1","Required",null,null,"GLJE","(File Type Code)"]
[null,"COL2","Required",null,null,"D","(Detail Record)"]
[null,"COL3","Required","String (20)",null,null,"Journal Number"]
[null,"COL4","Required **","Numeric",null,null,"Ledger Acct Recnum"]
[null,"COL5","**","Numeric",null,null,"Sub Account Recnum"]
[null,"COL6",null,"String (50)",null,null,"Line Description"]
[null,"COL7",null,"Numeric",null,null,"Debit Amount"]
[null,"COL8",null,"Numeric",null,null,"Credit Amount"]
[null,"COL9",null,"String (50)",null,null,"User Defined 1"]
[null,"COL10",null,"String (20)","WIP / Direct Exp *",null,"Work Order Number"]
[null,"COL11","**","Numeric","WIP / Direct Exp *",null,"Job Number"]
[null,"COL12","**","Numeric","WIP / Direct Exp *",null,"Phase Number"]
[null,"COL13",null,"String (50)","WIP / Direct Exp *",null,"Description"]
[null,"COL14","**","Numeric","WIP / Direct Exp *",null,"Cost Code"]
[null,"COL15","**","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,"COL16",null,"Text","WIP / Direct Exp *",null,"Notes"]
[null,"COL17","**","Numeric","Equip Exp **",null,"Equip Number"]
[null,"COL18",null,"String (50)","Equip Exp **",null,"Description"]
[null,"COL19","**","Numeric","Equip Exp **",null,"Cost Code"]
[null,"COL20","**","Numeric","Equip Exp **","1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-Utilities; 7-UserDef7; 8-UserDef8; 9-UserDef9","Cost Type"]
[null,"COL21",null,"Text","Equip Exp **",null,"Notes"]
[]
[null,"** Validated Field - value is either restricted to a defined list of values or exists in the fields 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,"GLJE,H,123,2018-01-05,\"Test, Journal Entry \",1,,,,,,,,,,,,,,,"]
[null,"GLJE,D,123,1,2001,,500.00,,,,,,,,,,,,,,"]
[null,"GLJE,D,123,2,5001,,,250.00,,,2017504,\"test line\",,2030.000,2,,,,,,"]
[null,"GLJE,D,123,2,5601,,,250.00,,,,,,,,,1,test,2030.000,1,"]

{"sheet":"Journal Entry Form","index":1,"n_rows":34,"n_cols":20,"rows_kept":34,"cut":false,"hidden":false,"merged":[[24,15,24,19],[24,8,24,14],[18,2,18,3],[19,2,19,3],[20,2,20,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[10,2,10,3],[3,2,3,3],[5,2,5,3],[8,2,8,3],[11,2,11,3],[12,2,12,3]]}
[null,"Sample Journal Entry Form"]
[]
[]
[null,"Journal Number: *","TJE 101"]
[null,"Journal Date: *","05/15/2017"]
[null,"Journal Description: *","Test JE 101"]
[null,"Status:",1]
[]
[null,"Purchase Order:"]
[null,"Bank Category:",1]
[null,"Vendor No:"]
[null,"Payee 1:"]
[null,"Payee 2:"]
[null,"Addrs 1:"]
[null,"Addrs 2:"]
[null,"City :"]
[null,"State:"]
[null,"Zip:"]
[null,"User Def 1:"]
[null,"User Def 2:"]
[null,"Notes:"]
[null,"Posting Period:"]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F27:F162)","v":500},{"$f":"SUM(G27:G162)","v":500},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","Debit\nAmount *","Credit\nAmount *","User Defined 1","Work Order Number","Job No *","Phase No","Job Description *","Job Cost Code *","Job Cost Type *","Job Notes","Equip No *","Equip Description *","Equip Cost Code *","Equip Cost\nType *","Equip Notes"]
[null,null,1000,null,"JE Line 1",null,500]
[null,null,6002,null,"JE Line 2",100]
[null,null,6002,null,"JE Line 3",100]
[null,null,6014,null,"JE Line 4",100]
[null,null,5003,null,"JC Line 1",50,null,null,null,2017008,null,"Test JE 101","2120.000",4]
[null,null,5001,null,"JC Line 2",50,null,null,null,2017008,null,"Test JE 101","2120.000",4]
[null,null,5601,null,"EQ Line 1",50,null,null,null,null,null,null,null,null,null,1,"Test JE 101","2030.000","3"]
[null,null,5602,null,"EQ Line 2",50,null,null,null,null,null,null,null,null,null,2,"Test JE 101","2040.000","3"]

{"sheet":"Grid Sample","index":2,"n_rows":11,"n_cols":22,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"Sample Journal Entry 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","Col 21"]
[null,"GLJE","H","Journal Number","Journal Accounting Date","Journal Description","Journal Status","Purchase Order Number","Bank Category","Vendor Recnum","Payee","Payee2","Address 1","Address 2","City","State","Zip","User Defined 1","User Defined 2","Notes"]
[null,"GLJE","D","Journal Number","Ledger Acct Recnum","Sub Account Recnum","Line Description","Debit Amount","Credit Amount","User Defined 1","Work Order Number","Job Number","Phase Number","Description","Cost Code","Cost Type","Notes","Equip Number","Description","Cost Code","Cost Type","Notes"]
[]
[]
[null,"GLJE","H","JE #1","2017-07-20","Test JE #1",1,null,0]
[null,"GLJE","D","JE #1",1000,null,"Record Meal Reimb",null,25000]
[null,"GLJE","D","JE #1",6040,null,"Record Meal Reimb",25000]

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