{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Overview","Template"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"General Ledger - 1-7 Ledger Accounts "]
[]
[null,"The following template should be used to import one or more GL Ledger Accounts into Sage 100 Contractor.  "]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Header","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required","GLLA",null,"GLLA","GLLA"]
[null,"recnum","Required","Numeric",null,null,"GL Account No"]
[null,"lngnme","Required","String (50)",null,null,"GL Account Name"]
[null,"shtnme","Required","String (30)",null,null,"GL Short Name"]
[null,"acttyp","Required **","Numeric",null,"1-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 Exp","Account Type"]
[null,"sumact","**","Numeric",null,null,"Summary Account"]
[null,"subact","**","Numeric",null,"0=None; 1=Subaccounts; 2=Departments","Subsidiary type (1)"]
[null,"csttyp","**","Numeric",null,"0=None; 1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-UserDef6; 7-UserDef7; 8-UserDef8; 9-UserDef9","Cost Type (2)"]
[null,"jobsub",null,"Numeric",null,"0=No; 1=Yes","Use Job No as subaccount"]
[null,"iscrcd",null,"Numeric",null,"0=No; 1=Yes","Is Credit Card"]
[null,"ntetxt",null,"Text",null,null,"Notes"]
[]
[null,"Required(I) - required for inserts only"]
[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,"(1) Not allowed for 1-Cash Accounts or the following designated accounts [Finance Charge, Discounts Given, Retained Earnings, Discounts Earned and Inventory Offset Account]"]
[null,"(2) Only available [3-WIP Assets, 13-Direct Expense, 14-Equip/Shop Exp]"]
[]
[null,"File Example:"]
[null,"filetype,recnum,lngnme,shtnme,acttyp,sumact,subact,csttyp,jobsub,iscrcd,ntetxt"]
[null,"GLLA,1001,\"Cash Checking\",\"Cash Check\",1,,,,,,\"\""]
[null,"GLLA,2081,\"Loan Payable\",\"Loan Pay\",2,,,,,,\"\""]

{"sheet":"Template","index":1,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sample Template",null,"Note: you may delete any column from this template that is not used or needed other than the Required Columns"]
[]
[]
[null,"Filetype Code","GL Account No","GL Account Name","GL Short Name","Account Type","Summary Account","Subsidiary type","Cost Type","Use Job No as subaccount","Is Credit Card","Notes"]
[null,"GLLA","Numeric","String (50)","String (30)","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Text"]
[]
[]
["First Line of File==>","filetype","recnum","lngnme","shtnme","acttyp","sumact","subact","csttyp","jobsub","iscrcd","ntetxt"]
[null,"GLLA",1001,"Cash Checking","Cash Check",1]
[null,"GLLA",2081,"Loan Payable","Loan Pay",2]