{"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":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,3,0,4]]}
[null,null,null,"Version: 2024-11-04"]
[]
[null,"General Ledger - 1-7 Ledger Accounts Budgets"]
[]
[null,"The following template should be used to import one or more GL Ledger Account Budgets into Sage 100 Contractor.  "]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Header","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required","GLLAB",null,"GLLAB","GLLAB"]
[null,"lgract","Required **","Numeric",null,null,"Ledger Account"]
[null,"subact","**","Numeric",null,null,"Sub Account"]
[null,"postyr","Required **","Numeric",null,2020,"Budget Year (1)"]
[null,"actprd","Required **","Numeric",null,"[1 - 12]","Accounting Period"]
[null,"budget","Required","Numeric",null,null,"Budget Amount"]
[]
[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) The budget year must already exist and be set up in Sage. To create or manage periods go to 1-6 Period/Fiscal Year Management"]
[]
[]
[null,"File Example:"]
[null,"filetype,lgract,subact,postyr,actprd, budget"]
[null,"GLLAB,1001,,2017,1,10000"]
[null,"GLLAB,1001,,2017,2,10000"]
[null,"GLLAB,1001,,2017,3,10000"]

{"sheet":"Template","index":1,"n_rows":32,"n_cols":7,"rows_kept":32,"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,"GLLAB","Ledger Account","Sub Account","Budget Year (1)","Accounting Period","Budget Amount"]
[null,"GLLAB","Numeric","Numeric","Numeric","Numeric","Numeric"]
[]
[]
["First Line of File==>","filetype","lgract","subact","postyr","actprd","budget"]
[null,"GLLAB",7900,null,2017,1,4000]
[null,"GLLAB",7900,null,2017,2,3000]
[null,"GLLAB",7900,null,2017,3,2000]
[null,"GLLAB",7900,null,2017,4,2000]
[null,"GLLAB",7900,null,2017,5,2000]
[null,"GLLAB",7900,null,2017,6,2000]
[null,"GLLAB",7900,null,2017,7,10000]
[null,"GLLAB",7900,null,2017,8,10000]
[null,"GLLAB",7900,null,2016,9,10000]
[null,"GLLAB",7900,null,2016,10,10000]
[null,"GLLAB",7900,null,2016,11,10000]
[null,"GLLAB",7900,null,2016,12,10000]
[null,"GLLAB",7900,1,2017,1,5500]
[null,"GLLAB",7900,1,2017,2,5500]
[null,"GLLAB",7900,1,2017,3,5500]
[null,"GLLAB",7900,1,2017,4,5500]
[null,"GLLAB",7900,1,2017,5,1000]
[null,"GLLAB",7900,1,2017,6,1000]
[null,"GLLAB",7900,1,2017,7,5500]
[null,"GLLAB",7900,1,2017,8,5500]
[null,"GLLAB",7900,1,2017,9,5500]
[null,"GLLAB",7900,1,2017,10,5500]
[null,"GLLAB",7900,1,2017,11,5500]
[null,"GLLAB",7900,1,2017,12,5500]