{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["COA, Calendar, and Ledger","Business Units","Companies and Legal Entities","Natural Accounts","LoB","LOV's","Hierarchies Validaton Report","Validation Report","CostCenter","Product","Intercompany","Financial Sequences","Preview Report","Additional Segment Template"],"not_rendered":{"charts":0,"images":18,"macros":1,"external_links":1,"defined_names":10,"comments":9,"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":"COA, Calendar, and Ledger","index":0,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Chart of Accounts, Calendar, and Ledger"]
[null,"* Required"]
[null,"*Name","QS"]
[null,"Currency"]
[null,"*Period Frequency","Monthly"]
[null,"*Adjusting Periods","Once at year end"]
[null,"*Fiscal Year Start Date","01/01/2018"]
[]
[]
[null,"Chart of Accounts"," "]
[null,"*Segment","Segment Label","*Short Prompt","*Display Width"]
[null,"Company","Primary Balancing Segment","Co","4"]
[null,"LoB","Second Balancing Segment","LoB","2"]
[null,"Account","Natural Account Segment","Acct","5"]
[null,"CostCenter","Cost Center Segment","CC","3"]
[null,"Product",null,"Prod","4"]
[null,"Intercompany",null,"IC","4"]

{"sheet":"Business Units","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Business Units"]
[]
[null,"Name","Default Legal Entity Name"]
[null,"SG QS HQ BU1","QS SG Legal Entity"]
[null,"SG QS BU2","QS SG Legal Entity"]
[null,"SG QS BU3","QS SG Legal Entity"]
[null,"MY QS BU1","QS MY Legal Entity"]
[null,"MY QS BU2","QS MY Legal Entity"]

{"sheet":"Companies and Legal Entities","index":2,"n_rows":13,"n_cols":23,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,3,10],[2,11,4,11],[2,12,2,22],[3,21,4,21],[3,22,4,22],[3,15,3,20],[3,12,4,12],[3,13,4,13],[3,14,4,14]]}
[null,"Companies and Legal Entities",null,null,null,null,null,null,null,null,null,null,"Note"]
[null,"* Required"]
[null,"*Value",null,null,null,null,null,null,null,null,null,"*Company Description","Legal Entity"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Name","*Identifier","*Country","Address",null,null,null,null,null,"*Registration Number","*Reporting Unit Registration Number"]
[null,"Parent9","Parent8","Parent7","Parent6","Parent5","Parent4","Parent3","Parent2","Parent1","Child",null,null,null,null,"*Address Line","City","State","County","Province","Postal Code"]
[null,null,null,null,null,null,"5000",null,null,null,null,"Total QS Companies"]
[null,null,null,null,null,null,null,"3000",null,null,null,"QS Singapore"]
[null,null,null,null,null,null,null,null,null,null,"3777","SG QS HQ BU1","QS SG Legal Entity","QSSG","Singapore","Singapore","Singapore",null,null,null,"50566","QSSG","QSSG12345"]
[null,null,null,null,null,null,null,null,null,null,"3888","SG QS BU2"]
[null,null,null,null,null,null,null,null,null,null,"3999","SG QS BU3"]
[null,null,null,null,null,null,null,"4000",null,null,null,"QS Malaysia"]
[null,null,null,null,null,null,null,null,null,null,"4888","MY QS BU1","QS MY Legal Entity","QSMY","Malaysia","Malaysia","Malaysia",null,null,null,"50566","QSMY","QSMY12345"]
[null,null,null,null,null,null,null,null,null,null,"4999","MY QS BU2"]

{"sheet":"Natural Accounts","index":3,"n_rows":438,"n_cols":15,"rows_kept":438,"cut":false,"hidden":false,"merged":[[2,14,4,14],[2,11,4,11],[2,12,4,12],[2,13,4,13],[2,1,3,10]]}
[null,"Natural Accounts",null,null,null,null,null,null,null,null,null,null,"Note"]
[null,"* Required"]
[null,"*Value",null,null,null,null,null,null,null,null,null,"*Description","*Account Type","Financial Category","Additional Information"]
[]
[null,"Parent9","Parent8","Parent7","Parent6","Parent5","Parent4","Parent3","Parent2","Parent1","Child"]
[null,null,null,null,"88888",null,null,null,null,null,null,"Net Assets and Owners Equity","Asset"]
[null,null,null,null,null,"32000",null,null,null,null,null,"Net Assets","Asset"]
[null,null,null,null,null,null,null,null,null,null,"00000","Default","Asset"]
[null,null,null,null,null,null,"19999",null,null,null,null,"Total Assets","Asset"]
[null,null,null,null,null,null,null,"10000",null,null,null,"Total Cash","Asset"]
[null,null,null,null,null,null,null,null,"11000",null,null,"Total Cash- Checking","Asset"]
[null,null,null,null,null,null,null,null,null,null,"11010","Cash Checking- BA","Asset - Cash","Cash","Cash deposited in bank accounts and other cash or cash equivalent holdings."]
[null,null,null,null,null,null,null,null,null,null,"11015","Cash Clearing","Asset - Cash Clearing","Cash","Temporary account used to record cash related transactions before they are cleared, for example when processing checks received or checks sent."]
[null,null,null,null,null,null,null,null,null,null,"11016","Cash Checking- Citi","Asset"]
[null,null,null,null,null,null,null,null,null,null,"11017","Cash Checking- HSBC","Asset"]
[null,null,null,null,null,null,null,null,null,null,"11018","Cash Checking- Barclays","Asset"]
[null,null,null,null,null,null,null,null,null,null,"11020","Cash Checking - Wells Fargo","Asset"]
[null,null,null,null,null,null,null,null,"11100",null,null,"Total Cash- Savings","Asset"]
[null,null,null,null,null,null,null,null,null,null,"11110","Cash Savings - BA","Asset"]
[null,null,null,null,null,null,null,null,null,null,"11116","Cash Savings- Citi","Asset"]
[null,null,null,null,null,null,null,null,null,null,"11117","Cash Savings- HSBC","Asset"]
[null,null,null,null,null,null,null,null,null,null,"11118","Cash Savings- Barclays","Asset"]
[null,null,null,null,null,null,null,null,null,null,"11120","Cash Savings - Wells Fargo","Asset"]
[null,null,null,null,null,null,null,"12000",null,null,null,"Total Investments","Asset"]
[null,null,null,null,null,null,null,null,null,null,"12010","Investments Winery","Asset"]
[null,null,null,null,null,null,null,null,null,null,"12011","Investments Dairy","Asset"]
[null,null,null,null,null,null,null,null,null,null,"12013","Investments Retail","Asset"]
[null,null,null,null,null,null,null,null,null,null,"12018","Investments Agricultural Research","Asset"]
[null,null,null,null,null,null,null,"13999",null,null,null,"Total Receivables","Asset"]
[null,null,null,null,null,null,null,null,"13000",null,null,"Total Current Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13005","Accounts Receivable","Asset - Accounts Receivable","Accounts receivable","Balance owed by customers for services performed or products sold."]
[null,null,null,null,null,null,null,null,null,null,"13060","Bad Debt Reserve","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13065","Interest Receivable","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13070","Unbilled Accounts Receivable","Asset - Unbilled Receivables","Accounts receivable","Tracks items that need to be billed as accounts receivable."]
[null,null,null,null,null,null,null,null,null,null,"13071","Auto Invoice Clearing","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13072","Receipt Confirmation","Asset - Confirmed Receipts","Accounts receivable","Certain types of automated payment receipts require confirmation from the customer before they can be released and remitted for payment are recorded in this account."]
[null,null,null,null,null,null,null,null,null,null,"13073","Remittance","Asset - Remitted Receipts","Accounts receivable","Customer payments that need to be deposited or remitted to the bank.  When the transaction clears the bank, this account is credited and the appropriate cash account is debited."]
[null,null,null,null,null,null,null,null,null,null,"13074","Unapplied Receipt","Asset - Unapplied Cash","Accounts receivable","Funds held in a temporary account until final application of cash is made to the trade receivables."]
[null,null,null,null,null,null,null,null,null,null,"13075","Rent Receivable","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13076","Factored Receipts","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13077","Short Term Debt Receivable","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13078","Refund","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13079","Unidentified Receipt","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13080","On Account Receipt","Asset - On Account Payments","Accounts receivable","Advance payments by a customer recorded on the customer account and applied against future invoices."]
[null,null,null,null,null,null,null,null,null,null,"13120","Late Charges Receivable","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13121","Finance Charges Receivable","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13122","Non-Recoverable Earned Discounts Receivable","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13123","Non-Recoverable Unearned Discounts Receivable","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13124","Non-Recoverable Adjustment Receivable","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13125","Tax Recoverable Receivable","Asset - Tax Recoverable Account","Accounts receivable","Tracks transaction taxes recoverable from tax authorities.  This account is needed when the tax is configured as Recoverable in the Tax module."]
[null,null,null,null,null,null,null,null,null,null,"13150","Credit Card Refund","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13160","Credit Card Chargeback","Asset"]
[null,null,null,null,null,null,null,null,"13010",null,null,"Total Intercompany Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13011","Intercompany Revenue Receivables","Asset - Intercompany Receivable","Accounts receivable","Tracks receivables due from other companies in the group."]
[null,null,null,null,null,null,null,null,null,null,"13012","Intercompany Rent Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13013","Intercompany Travel Expense Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13014","Intercompany Labor Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13015","Intercompany Warehouse Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13016","Intercompany Shipping Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13017","Intercompany Freight Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13018","Intercompany I/T Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13019","Intercompany Trade Show Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13020","Intercompany Marketing Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13021","Intercompany Outreach Programs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13022","Intercompany Promotion Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13023","Intercompany RandD Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13024","Intercompany Telecom Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13025","Intercompany Consulting Fees Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13026","Intercompany Accountants' Fees Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13027","Intercompany Legal Fees Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13028","Intercompany Interest Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13029","Intercompany Professional Fees Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13030","Intercompany Convention Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13031","Intercompany Insurance Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13032","Intercompany Trade Group Fees Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13033","Intercompany Repair and Maintenance Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13034","Intercompany Entertainment Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13035","Intercompany Employee Programs Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13036","Intercompany Transportation Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13037","Intercompany Tax Expense Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13038","Intercompany Packaging Design Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13039","Intercompany Administrative Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13040","Intercompany Employee Training Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13041","Intercompany Vintner's Associations Fees Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13042","Intercompany Patent Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13043","Intercompany Trade Publications Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13044","Intercompany Print Media Advertising Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13045","Intercompany Radio Advertising Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13046","Intercompany TV Advertising Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13047","Intercompany Internet Advertising Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13048","Intercompany Brand Development Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13049","Intercompany Employee Benefits Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13050","Intercompany Publicity Expenses Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13051","Intercompany Education Program Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13052","Intercompany Public Relations Agency Fees Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13053","Intercompany Channel Development Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13054","Intercompany Rebate Programs Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13055","Intercompany Facility Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13056","Intercompany International Trade Fairs Costs Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13057","Intercompany Recruitment Fees Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13058","Intercompany Research Grants  Receivables","Asset"]
[null,null,null,null,null,null,null,null,null,null,"13059","Intercompany University Programs Costs Receivables","Asset"]
[null,null,null,null,null,null,null,"14000",null,null,null,"Total Inventory","Asset"]
[null,null,null,null,null,null,null,null,null,null,"14010","Inventory - Raw Materials and Supplies","Asset"]
[null,null,null,null,null,null,null,null,null,null,"14020","Inventory - for Resale","Asset"]
[null,null,null,null,null,null,null,null,null,null,"14030","Inventory - Red Wines","Asset"]
[null,null,null,null,null,null,null,null,null,null,"14040","Inventory - White Wines","Asset"]
[null,null,null,null,null,null,null,null,null,null,"14050","Inventory - Domestic Cheeses","Asset"]
[null,null,null,null,null,null,null,null,null,null,"14060","Inventory - Imported Cheeses","Asset"]
[null,null,null,null,null,null,null,"16000",null,null,null,"Total Other Current Assets","Asset"]
[null,null,null,null,null,null,null,null,"15000",null,null,"Total Prepaid Items","Asset"]
[null,null,null,null,null,null,null,null,null,null,"15010","Prepaid Rent","Asset"]
[null,null,null,null,null,null,null,null,null,null,"15015","Prepayments","Asset - Prepayments","Other assets","Records supplier invoices for products or services which have not yet been delivered, or expenses that have not yet been incurred."]
[null,null,null,null,null,null,null,null,null,null,"15020","Prepaid Insurance","Asset"]
[null,null,null,null,null,null,null,null,null,null,"15451","Prepayment Tax Difference","Asset"]
[null,null,null,null,null,null,null,null,null,null,"15452","Bonus Reserve","Asset"]
[null,null,null,null,null,null,null,"18000",null,null,null,"Total Non-Current Assets","Asset"]
[null,null,null,null,null,null,null,null,null,null,"16010","Proceeds of Fixed Assets Sale Clearing","Asset - Proceeds of Fixed Assets Sale Clearing","Property, plant, and equipment","Clearing account used to account for the receipt of the proceeds from a sale of fixed assets.  Only required if using the Assets module."]
[null,null,null,null,null,null,null,null,"17000",null,null,"Total Capital Assets","Asset"]
[null,null,null,null,null,null,null,null,null,null,"17100","Land","Asset"]
[null,null,null,null,null,null,null,null,null,null,"17200","Site Improvements","Asset"]
[null,null,null,null,null,null,null,null,null,null,"17290","Accumulated Depreciation - Site Improvements","Asset"]
[null,null,null,null,null,null,null,null,null,null,"17300","Furniture","Asset"]
[null,null,null,null,null,null,null,null,null,null,"17390","Accumulated Depreciation - Furniture","Asset"]
[null,null,null,null,null,null,null,null,null,null,"17400","Buildings","Asset"]
[null,null,null,null,null,null,null,null,null,null,"17490","Accumulated Depreciation - Buildings","Asset"]
[null,null,null,null,null,null,null,null,null,null,"17500","Leasehold Improvements","Asset"]
[null,null,null,null,null,null,null,null,null,null,"17590","Accumulated Depreciation - Leasehold Improvements","Asset"]
[null,null,null,null,null,null,null,null,null,null,"17600","Machinery and Equipment","Asset"]
[null,null,null,null,null,null,null,null,null,null,"17690","Accumulated Depreciation - Machinery and Equipment","Asset"]
[null,null,null,null,null,null,null,null,null,null,"17700","Other Capital Assets","Asset"]
[null,null,null,null,null,null,null,null,null,null,"17710","Asset Clearing","Asset - Asset Clearing","Property, plant, and equipment","Clearing account used to reconcile the fixed asset acquisition cost with the source system.  Only required if using the  Assets module."]
[null,null,null,null,null,null,null,null,null,null,"17790","Accumulated Depreciation - Other Capital Assets","Asset"]
[null,null,null,null,null,null,null,null,null,null,"17800","Vehicles","Asset"]
[null,null,null,null,null,null,null,null,null,null,"17810","Computers","Asset"]
[null,null,null,null,null,null,null,null,null,null,"17830"," Depreciation Reserve Adjustment","Asset"]
[null,null,null,null,null,null,null,null,null,null,"17890","Accumulated Depreciation - Vehicles","Asset"]
[null,null,null,null,null,null,null,null,null,null,"17899","Accumulated Depreciation - Computers","Asset"]
[null,null,null,null,null,null,null,null,null,"17900",null,"Construction in Progress","Asset"]
[null,null,null,null,null,null,null,null,null,null,"17910","CIP Cost","Asset"]
[null,null,null,null,null,null,null,null,null,null,"17920","CIP Clearing","Liability - Cost of Fixed Asset Removal Clearing","Property, plant, and equipment","Clearing account used to account for payment of the cost incurred to remove fixed assets.  Only required if using the Assets module."]
[null,null,null,null,null,null,"25000",null,null,null,null,"Total  Liabilities","Liability"]
[null,null,null,null,null,null,null,"21000",null,null,null,"Total Current Liabilities","Liability"]
[null,null,null,null,null,null,null,null,"21001",null,null,"Total Trade Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21010","Accounts Payable","Liability - Accounts Payable","Accounts payable","Amount due to suppliers for products or services purchased on credit."]
[null,null,null,null,null,null,null,null,null,null,"21060","Contracts Payable","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21070","Bills Payable","Liability"]
[null,null,null,null,null,null,null,null,"21049",null,null,"Total Accrued Employee Expenses","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21011","Accounts Payable- Adjustments","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21020","Accrued Salaries and Wages","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21021","Accrued Vacation","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21022","Accrued Bonuses","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21030","Accrued Payroll Taxes","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21040","Employer's Share of Employee Benefits Current Payables","Liability"]
[null,null,null,null,null,null,null,null,"21075",null,null,"Total Other Current Liabilities","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21050","Short Term Debt Payable","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21140","Deferred Revenue","Liability - Unearned Revenue","Deferred sales revenue","Tracks unearned revenue for invoices that have been billed in advance of when revenue can be recognized."]
[null,null,null,null,null,null,null,null,null,null,"21145","Interest Payable","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21150","Rent Payable","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21155","Prepaid Revenue","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21160","Customer Advance","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21170","Lease Payable","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21175","Expense Accrual Account","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21176","Cost of Removal Clearing","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21177","Non-Recoverable Earned Discounts Payable","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21178","Non-Recoverable Unearned Discounts Payable","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21179","Non-Recoverable Adjustment Payable","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21180","Employee Payable","Liability - Employees Payable","Accounts payable","Balance due to employees for expense reports.  Only required if using the Expenses module. "]
[null,null,null,null,null,null,null,null,null,null,"24990","Other Current Liabilities","Liability"]
[null,null,null,null,null,null,null,null,"21080",null,null,"Total Intercompany Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21081","Intercompany Purchase Payables","Liability - Intercompany Payable","Accounts payable","Tracks payables due from other companies in the group."]
[null,null,null,null,null,null,null,null,null,null,"21082","Intercompany Rent Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21083","Intercompany Travel Expense Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21084","Intercompany Labor Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21085","Intercompany Warehouse Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21086","Intercompany Shipping Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21087","Intercompany Freight Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21088","Intercompany I/T Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21089","Intercompany Trade Show Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21090","Intercompany Marketing Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21091","Intercompany Outreach Programs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21092","Intercompany Promotion Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21093","Intercompany RandD Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21094","Intercompany Telecom Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21095","Intercompany Consulting Fees Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21096","Intercompany Accountants' Fees Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21097","Intercompany Legal Fees Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21098","Intercompany Interest Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21099","Intercompany Professional Fees Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21100","Intercompany Convention Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21101","Intercompany Insurance Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21102","Intercompany Trade Group Fees Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21103","Intercompany Repair and Maintenance Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21104","Intercompany Entertainment Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21105","Intercompany Employee Programs Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21106","Intercompany Transportation Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21107","Intercompany Tax Expense Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21108","Intercompany Packaging Design Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21109","Intercompany Administrative Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21110","Intercompany Employee Training Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21111","Intercompany Vintner's Associations Fees Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21112","Intercompany Patent Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21113","Intercompany Trade Publications Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21114","Intercompany Print Media Advertising Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21115","Intercompany Radio Advertising Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21116","Intercompany TV Advertising Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21117","Intercompany Internet Advertising Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21118","Intercompany Brand Development Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21119","Intercompany Employee Benefits Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21120","Intercompany Publicity Expenses Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21121","Intercompany Education Program Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21122","Intercompany Public Relations Agency Fees Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21123","Intercompany Channel Development Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21124","Intercompany Rebate Programs Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21125","Intercompany Facility Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21126","Intercompany International Trade Fairs Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21127","Intercompany Recruitment Fees Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21128","Intercompany Research Grants  Payables","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21129","Intercompany University Programs Costs Payables","Liability"]
[null,null,null,null,null,null,null,null,"21500",null,null,"Total Taxes payable","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21510","Federal Income Taxes Payable","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21511","State Income Taxes Payable","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21520","Property Taxes Payable","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21525","Automatic Withholding Tax","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21526","Tax Recoverable Payable","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21527","Interim Tax Payable","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21528","Tax Recoverable Payable- Tax Recovery Rate","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21529","Finance Charge Tax Payable","Liability"]
[null,null,null,null,null,null,null,null,null,null,"21530","Sales and Use Taxes Payable","Liability - Tax Payable","Tax liability","Tax liability account for collected sales tax or self-assessed tax."]
[null,null,null,null,null,null,null,null,null,null,"29999","Deferred Depreciation Reserve","Liability"]
[null,null,null,null,null,"31000",null,null,null,null,null,"Total Equity","Owner's Equity"]
[null,null,null,null,null,null,"31005",null,null,null,null,"Total Investor's Equity","Owner's Equity"]
[null,null,null,null,null,null,null,null,null,null,"31001","Common Stock","Owner's Equity"]
[null,null,null,null,null,null,null,null,null,null,"31002","Paid in Capital","Owner's Equity"]
[null,null,null,null,null,null,"31009",null,null,null,null,"Total Retained Earnings","Owner's Equity"]
[null,null,null,null,null,null,null,null,null,null,"31010","Retained Earnings","Owner's Equity - Retained Earnings","Retained earnings","Tracks accumulated earnings that have not been disbursed as dividends to investors."]
[null,null,null,null,null,null,null,null,null,null,"31020","Current Year Operating Income","Owner's Equity"]
[null,null,null,null,null,null,null,null,null,null,"31030","Minority Interest","Owner's Equity"]
[null,null,null,null,null,null,null,null,null,null,"31040","Cumulative Translation Adjustment","Owner's Equity"]
[null,null,null,null,null,null,null,null,null,null,"39999","Temporary Closing Account","Owner's Equity"]
[null,null,null,null,"99999",null,null,null,null,null,null,"Net Income","Revenue"]
[null,null,null,null,null,"REV",null,null,null,null,null,"Total Revenues","Revenue - Top Revenues Parent Account","Sales revenue","The top level revenues parent account value along with its descendants will be referenced in sample financial reports automatically created by the system based on this Rapid Implementation configuration."]
[null,null,null,null,null,null,"40001",null,null,null,null,"Wine","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"40110","White Wine Revenue","Revenue - Revenue","Sales revenue","Revenue meeting accounting standards and recognized as earned income for goods sold or services provided for the accounting period."]
[null,null,null,null,null,null,null,null,null,null,"40111","Red Wine Revenue","Revenue"]
[null,null,null,null,null,null,"40002",null,null,null,null,"Cheese","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"40114","Domestic Cheese Revenue","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"40115","Imported Cheese Revenue","Revenue"]
[null,null,null,null,null,null,"40003",null,null,null,null,"Wine Rooms","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"40031","Tastings Fee","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"40032","Gift Shop Revenue","Revenue"]
[null,null,null,null,null,null,"40004",null,null,null,null,"Tabletop","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"40041","Linens Revenue","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"40042","Serving Ware Revenue","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"40043","Glass Ware Revenue","Revenue"]
[null,null,null,null,null,null,"40005",null,null,null,null,"Kitchenwares","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"40051","Stovetop and Oven Ware","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"40052","Kitchen Equipment Revenue","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"40053","Cooking Utensils Revenue","Revenue"]
[null,null,null,null,null,null,"40006",null,null,null,null,"Catering","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"40061","Food Service Revenue","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"40062","Event Planning Revenue","Revenue"]
[null,null,null,null,null,null,"40007",null,null,null,null,"Revenue Adjustments","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"40116","Discounts","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"40117","Adjustments","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"40118","Finance Charges","Revenue"]
[null,null,null,null,null,null,"40008",null,null,null,null,"Intercompany Revenues","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"41110","Intercompany Revenue","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"41120","Intercompany Rent","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"41130","Intercompany Interest","Revenue"]
[null,null,null,null,null,null,"40009",null,null,null,null,"Other Income","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"41140","Interest Income","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"41150","Investment Income","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"41160","Freight Income","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"41210","Gain on Sale of Capital Assets","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"42101","Late Fees Charged","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"42102","Penalties Charged","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"42103","Surcharges","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"42104","Special Charges","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"42120","Autoinvoice Clearing","Revenue - Autoinvoice Clearing","Sales revenue","Clearing account for differences between the specified revenue amount and the selling price times the quantity for imported invoice lines. "]
[null,null,null,null,null,null,null,null,null,null,"42121","Unallocated Revenue","Revenue"]
[null,null,null,null,null,null,null,null,null,null,"42125","Miscellaneous Revenue","Revenue"]
[null,null,null,null,null,"EXP",null,null,null,null,null,"Total Expenses","Expense"]
[null,null,null,null,null,null,"50000",null,null,null,null,"Total Cost of Goods Sold","Expense - Top Cost of Sales Parent Account","Cost of goods sold","The top level cost of goods sold parent account value along with its descendants will be referenced in sample financial reports automatically created by the system based on this Rapid Implementation configuration."]
[null,null,null,null,null,null,null,null,null,null,"52146","Freight","Expense - Freight","Freight expenses","Freight charges incurred for transporting goods."]
[null,null,null,null,null,null,null,null,null,null,"52147","Variances","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52148","Discounts Given","Expense - Discounts Given","Other sales expenses","Collection discounts given to customers against the gross invoice amount."]
[null,null,null,null,null,null,null,null,null,null,"52149","Conversion Rate Variance","Expense - Conversion Rate Variance Gain/Loss","Cost of goods sold","Gain or loss that results due to difference in exchange rates at which the invoice and receipt or purchase order are recorded. This variance is calculated only for inventory  or expense items which accrue on receipt."]
[null,null,null,null,null,null,null,"52125",null,null,null,"Total Cost of Goods Sold- Wine","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52110","Cost of Goods Sold- Red Wines","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52120","Cost of Goods Sold- White Wines","Expense"]
[null,null,null,null,null,null,null,"52145",null,null,null,"Total Cost of Goods Sold- Cheese","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52130","Cost of Goods Sold- Domestic Cheeses","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52140","Cost of Goods Sold- Imported Cheeses","Expense"]
[null,null,null,null,null,null,null,"52157",null,null,null,"Total Cost of Goods Sold- Wine Rooms Revenues","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52158","Cost of Goods Sold- Wine Tastings","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52159","Cost of Goods Sold- Gift Shop","Expense"]
[null,null,null,null,null,null,null,52160,null,null,null,"Total Cost of Goods Sold- Tabletop Revenues","Expense"]
[null,null,null,null,null,null,null,null,null,null,52161,"Cost of Goods Sold- Linens","Expense"]
[null,null,null,null,null,null,null,null,null,null,52162,"Cost of Goods Sold- Serving Ware","Expense"]
[null,null,null,null,null,null,null,null,null,null,52163,"Cost of Goods Sold- Glass Ware","Expense"]
[null,null,null,null,null,null,null,52170,null,null,null,"Total Cost of Goods Sold- Kitchenware Revenues","Expense"]
[null,null,null,null,null,null,null,null,null,null,52171,"Cost of Goods Sold- Stovetop and Oven Ware","Expense"]
[null,null,null,null,null,null,null,null,null,null,52172,"Cost of Goods Sold- Kitchen Equipment","Expense"]
[null,null,null,null,null,null,null,null,null,null,52173,"Cost of Goods Sold- Cooking Utensils","Expense"]
[null,null,null,null,null,null,null,52180,null,null,null,"Total Cost of Goods Sold- Catering Revenue","Expense"]
[null,null,null,null,null,null,null,null,null,null,52181,"Cost of Goods Sold- Food Service","Expense"]
[null,null,null,null,null,null,null,null,null,null,52182,"Cost of Goods Sold- Event Planning","Expense"]
[null,null,null,null,null,null,"51000",null,null,null,null,"Total Operating Expenses","Expense - Top Operating Expenses Parent Account","Other operating expenses","The top level operating expenses parent account value along with its descendants will be referenced in sample financial reports automatically created by the system based on this Rapid Implementation configuration."]
[null,null,null,null,null,null,null,"51100",null,null,null,"Employees","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52150","Manufacturing Salaries","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52151","Sales Salaries","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52152","General Administration Salaries","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52153","Other Employee Costs","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52154","Bonus Expense","Expense"]
[null,null,null,null,null,null,null,null,null,null,"58430","Recruiting Expenses","Expense"]
[null,null,null,null,null,null,null,"51200",null,null,null,"Facilities","Expense"]
[null,null,null,null,null,null,null,null,"52300",null,null,"Total Rent and Services Expenses","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52200","Property Landscaping Services","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52210","Cleaning Services","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52220","Repairs and Maintenance - Manufacturing Equipment","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52221","Repairs and Maintenance - Office Equipment","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52231","Rent- Buildings","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52232","Rent- Equipment and Vehicles","Expense"]
[null,null,null,null,null,null,null,null,"53200",null,null,"Total Utility Costs","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53210","Water","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53220","Natural Gas","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53230","Electricity","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53250","Oil","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53260","Gasoline","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53310","Sewage","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53320","Waste Disposal","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52310","Insurance","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52320","Public Relations Services","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52330","Advertising","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52340","Printing and Binding","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52350","Temp Services","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52360","Dues and Fees","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52370","Education and Training","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52380","Licenses","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52385","Contract Labor","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53110","General Supplies and Materials","Expense"]
[null,null,null,null,null,null,null,"51300",null,null,null,"Communication","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53331","Land Phone Charges","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53332","Mobile Phone Charges","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53410","Internet Expenses","Expense"]
[null,null,null,null,null,null,null,"51400",null,null,null,"Travel","Expense"]
[null,null,null,null,null,null,null,null,"53450",null,null,"Total Domestic and International Travel","Expense"]
[null,null,null,null,null,null,null,null,null,"53430",null,"Travel - Domestic","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53431","Domestic Accommodation","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53432","Domestic Airfare","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53433","Domestic Car Rental","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53434","Domestic Trains/Trams/Ferry","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53435","Domestic Taxi","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53436","Domestic Toll","Expense"]
[null,null,null,null,null,null,null,null,null,"53440",null,"Travel - Overseas","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53442","International Accommodation","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53443","International Airfare","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53444","International Car Rental","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53445","International Car Rental","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53446","International Taxi","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53447","International Telephone Charges","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53448","International Trains/Trams/Ferry","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52386","Mileage Reimbursement","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52387","Employee Meals","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52388","Entertainment","Expense"]
[null,null,null,null,null,null,null,null,null,null,"52390","Employee Rideshare Commute Incentive Program","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53455","Parking","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53456","Travel Advance Return","Expense"]
[null,null,null,null,null,null,null,"51500",null,null,null,"Depreciation","Expense"]
[null,null,null,null,null,null,null,null,"55000",null,null,"Total Amortization","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56001","Goodwill Amortization","Expense"]
[null,null,null,null,null,null,null,null,"56000",null,null,"Total Depreciation","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56010","Buildings Depreciation","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56011","Site Improvements Depreciation","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56012","Furniture Depreciation","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56013","Leasehold Improvements Depreciation","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56014","Machinery and Equipment Depreciation","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56015","Other Capital Assets Depreciation","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56016","Vehicles Depreciation","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56017","Computers Depreciation","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56018","Unplanned Depreciation Expense","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56019","Deferred Depreciation Expense","Expense"]
[null,null,null,null,null,null,null,"56100",null,null,null,"Total Equipment Disposal Gain/Loss","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56020","Equipment Scrapping","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56110","Proceeds of Sale Gain","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56111","Proceeds of Sale Loss","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56112","Cost of Removal Loss","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56113","Cost of Removal Gain","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56120","Net Book Value Retired Gain","Expense - Gain/Loss On Fixed Asset Disposal","Other income","Gain or loss on the disposal of fixed assets by sale, retirement, or removal.  Only required if using the Assets module."]
[null,null,null,null,null,null,null,null,null,null,"56121","Net Book Value Retired Loss","Expense"]
[null,null,null,null,null,null,null,"51600",null,null,null,"Taxes","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56510","Federal Taxes","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56511","State Taxes","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56520","Local Taxes","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56530","Property Taxes","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56540","Sales Taxes","Expense"]
[null,null,null,null,null,null,null,"58200",null,null,null,"Interest","Expense"]
[null,null,null,null,null,null,null,null,"57000",null,null,"Total Discounts","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56550","Earned Discounts","Expense - Discount Taken","Other operating expenses","Discounts received for early payments made to suppliers as part of previously agreed payment terms."]
[null,null,null,null,null,null,null,null,null,null,"56551","Unearned Discounts","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56552","Expenses Adjustment","Expense"]
[null,null,null,null,null,null,null,null,"58100",null,null,"Total Debt and Lease Interests","Expense"]
[null,null,null,null,null,null,null,null,null,null,"56553","Finance Charges","Expense"]
[null,null,null,null,null,null,null,null,null,"58000",null,"Total Leasing Expenses","Expense"]
[null,null,null,null,null,null,null,null,null,null,"57990","Leasing Service Charges","Expense"]
[null,null,null,null,null,null,null,null,null,null,"58110","Bond Interest Payments","Expense"]
[null,null,null,null,null,null,null,null,null,null,"58410","Bond Issuance Costs","Expense"]
[null,null,null,null,null,null,null,null,null,null,"58420","Penalties and Late Fees","Expense"]
[null,null,null,null,null,null,null,null,"53420",null,null,"Bank Charges","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53421","Bank Charges","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53422","Cash Reconciliation Difference","Expense - Cash Reconciliation Difference","Miscellaneous operating expenses","Tracks differences that arise from reconciling a cash account and its bank statement."]
[null,null,null,null,null,null,null,"60000",null,null,null,"Other","Expense"]
[null,null,null,null,null,null,null,null,null,null,"75555","Bad Debt Expense","Expense"]
[null,null,null,null,null,null,null,null,"53500",null,null,"Small Tools and Equipment Expenses","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53510","Irrigation Expenses","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53520","Small Tools Expenses","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53530","Tractor Tires","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53550","Vine Trellis Materials","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53610","Equipment Repairs","Expense"]
[null,null,null,null,null,null,null,null,"59000",null,null,"Total Customer Reward Programs","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53426","Customer Gifts","Expense"]
[null,null,null,null,null,null,null,null,null,null,"53427","Customer Awards","Expense"]
[null,null,null,null,null,null,null,null,null,null,"58440","Customer Appreciation Gala","Expense"]
[null,null,null,null,null,null,null,null,"60001",null,null,"Total Petty Cash Disbursements","Expense"]
[null,null,null,null,null,null,null,null,null,null,"60002","Office Supplies","Expense"]
[null,null,null,null,null,null,null,null,null,null,"60003","Postage Expense","Expense"]
[null,null,null,null,null,null,null,null,null,null,"60004","Delivery Tips","Expense"]
[null,null,null,null,null,null,null,null,null,"60050",null,"Miscellaneous Charges","Expense"]
[null,null,null,null,null,null,null,null,null,null,"60041","Miscellaneous Expenses","Expense - Miscellaneous Expenses","Miscellaneous operating expenses","Small and sundry expenses like loading or unloading charges incurred during the purchase of materials or services."]
[null,null,null,null,null,null,null,null,null,null,"60042","Suspense","Expense"]
[null,null,null,null,null,null,null,null,null,null,"60043","Header Rounding Account","Expense"]
[null,null,null,null,null,null,null,null,null,null,"60044","Cross Currency Rounding Account","Expense - Rounding Difference and Balancing Adjustments","Other operating expenses","Tracks adjustments to offset imbalances from rounding differences, conversion of foreign currency denominated transactions or unbalanced journal entries."]
[null,null,null,null,null,null,null,null,"60060",null,null,"Total Exchange Rates Gain/Loss","Expense"]
[null,null,null,null,null,null,null,null,null,null,"60061","Realized Exchange Rate Gain","Expense - Realized Gain/Loss on Foreign Currency Conversions","Other income","Gain or loss due to exchange rate variances between invoices and payments."]
[null,null,null,null,null,null,null,null,null,null,"60062","Realized Exchange Rate Loss","Expense"]
[null,null,null,null,null,null,null,null,null,null,"60063","Exchange Rate Variance Gain","Expense"]
[null,null,null,null,null,null,null,null,null,null,"60064","Exchange Rate Variance Loss","Expense"]

{"sheet":"LoB","index":4,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,3,10],[2,11,4,11]]}
[null,"LoB",null,null,null,null,null,null,null,null,null,null,"Note"]
[null,"* Required"]
[null,"*Value",null,null,null,null,null,null,null,null,null,"*Description"]
[]
[null,"Parent9","Parent8","Parent7","Parent6","Parent5","Parent4","Parent3","Parent2","Parent1","Child"]
[null,null,null,null,null,null,null,null,"99",null,null,"Total SS LOB"]
[null,null,null,null,null,null,null,null,null,null,"10","None"]
[null,null,null,null,null,null,null,null,null,null,"20","Oracle"]
[null,null,null,null,null,null,null,null,null,null,"30","SAP"]
[null,null,null,null,null,null,null,null,null,null,"40","Microsoft"]
[null,null,null,null,null,null,null,null,null,null,"50","Netsuite"]
[null,null,null,null,null,null,null,null,null,null,"60","Tally"]
[null,null,null,null,null,null,null,null,null,null,"70","Ramco"]

{"sheet":"LOV's","index":5,"n_rows":253,"n_cols":24,"rows_kept":253,"cut":false,"hidden":true,"merged":[]}
[null,null,"TRANSACTION_NAME","TRANSACTION_CODE",null,"CURRENCY_CODE",null,"TERRITORY_SHORT_NAME",null,"ACCOUNT_TYPE","EXT_ACCOUNT_TYPE","ADDITIONAL_INFORMATION","DETERMINANT_TYPE","ACCOUNT_NAME","FINANCIAL_CATEGORY","DEV_MODE",null,null,"ACCOUNT_TYPE","EXT_ACCOUNT_TYPE","ADDITIONAL_INFORMATION","DETERMINANT_TYPE","ACCOUNT_NAME","FINANCIAL_CATEGORY"]
[null,"Yes","Payables Invoices","AP_INVOICES",null,"USD",null,"Afghanistan",null,"Asset","Asset",null,null,null,null,true,null,null,"Asset","Asset"]
[null,"No","Payments","AP_PAYMENTS",null,"GBP",null,"Aland Islands",null,"Liability","Liability",null,null,null,null,null,null,null,"Liability","Liability"]
[null,null,"Receivables Invoices","AR_INVOICES",null,"EUR",null,"Albania",null,"Owner's Equity","Owner's Equity",null,null,null,null,null,null,null,"Owner's Equity","Owner's Equity"]
[null,"Validation Type","Receivables Credit Memos","AR_CREDIT_MEMOS",null,"CAD",null,"Algeria",null,"Revenue","Revenue",null,null,null,null,null,null,null,"Revenue","Revenue"]
[null,"Independent","Receivables Adjustment Activities","AR_ADJ_ACTIVITIES",null,"JPY",null,"American Samoa",null,"Expense","Expense",null,null,null,null,null,null,null,"Expense","Expense"]
[null,"Format Only","Subledger Journals","Subledger Journals",null,"INR",null,"Andorra",null,"Asset","Asset - Accounts Receivable","Balance owed by customers for services performed or products sold.","BU",null,"Accounts receivable",null,null,null,"Asset","Asset - Accounts Receivable","Balance owed by customers for services performed or products sold.","BU",null,"Accounts receivable"]
[null,"Dependent ","General Ledger Journals","General Ledger Journals",null,"ADP",null,"Angola",null,"Asset","Asset - Asset Clearing","Clearing account used to reconcile the fixed asset acquisition cost with the source system.  Only required if using the  Assets module.","COA",null,"Property, plant, and equipment",null,null,null,"Asset","Asset - Asset Clearing","Clearing account used to reconcile the fixed asset acquisition cost with the source system.  Only required if using the  Assets module.","COA",null,"Property, plant, and equipment"]
[null,null,null,null,null,"AED",null,"Anguilla",null,"Asset","Asset - Cash","Cash deposited in bank accounts and other cash or cash equivalent holdings.","Legal Entity",null,"Cash",null,null,null,"Asset","Asset - Cash","Cash deposited in bank accounts and other cash or cash equivalent holdings.","Legal Entity",null,"Cash"]
[null,null,null,null,null,"AFA",null,"Antarctica",null,"Asset","Asset - Cash Clearing","Temporary account used to record cash related transactions before they are cleared, for example when processing checks received or checks sent.","Legal Entity",null,"Cash",null,null,null,"Asset","Asset - Cash Clearing","Temporary account used to record cash related transactions before they are cleared, for example when processing checks received or checks sent.","Legal Entity",null,"Cash"]
[null,null,null,null,null,"AFN",null,"Antigua and Barbuda",null,"Asset","Asset - Confirmed Receipts","Certain types of automated payment receipts require confirmation from the customer before they can be released and remitted for payment are recorded in this account.","BU",null,"Accounts receivable",null,null,null,"Asset","Asset - Confirmed Receipts","Certain types of automated payment receipts require confirmation from the customer before they can be released and remitted for payment are recorded in this account.","BU",null,"Accounts receivable"]
[null,null,null,null,null,"ALL",null,"Argentina",null,"Asset","Asset - Intercompany Receivable","Tracks receivables due from other companies in the group.","COA",null,"Accounts receivable",null,null,null,"Asset","Asset - Intercompany Receivable","Tracks receivables due from other companies in the group.","COA",null,"Accounts receivable"]
["#","START_OF_SEGMENT_CODES",null,null,null,"AMD",null,"Armenia",null,"Asset","Asset - On Account Payments","Advance payments by a customer recorded on the customer account and applied against future invoices.","BU",null,"Accounts receivable",null,null,null,"Asset","Asset - On Account Payments","Advance payments by a customer recorded on the customer account and applied against future invoices.","BU",null,"Accounts receivable"]
[null,null,null,null,null,"ANG",null,"Aruba",null,"Asset","Asset - Prepayments","Records supplier invoices for products or services which have not yet been delivered, or expenses that have not yet been incurred.","BU",null,"Other assets",null,null,null,"Asset","Asset - Prepayments","Records supplier invoices for products or services which have not yet been delivered, or expenses that have not yet been incurred.","BU",null,"Other assets"]
[null,"Primary Balancing Segment",null,null,null,"AOA",null,"Australia",null,"Asset","Asset - Proceeds of Fixed Assets Sale Clearing","Clearing account used to account for the receipt of the proceeds from a sale of fixed assets.  Only required if using the Assets module.","COA",null,"Property, plant, and equipment",null,null,null,"Asset","Asset - Proceeds of Fixed Assets Sale Clearing","Clearing account used to account for the receipt of the proceeds from a sale of fixed assets.  Only required if using the Assets module.","COA",null,"Property, plant, and equipment"]
[null,"Second Balancing Segment",null,null,null,"AOK",null,"Austria",null,"Asset","Asset - Remitted Receipts","Customer payments that need to be deposited or remitted to the bank.  When the transaction clears the bank, this account is credited and the appropriate cash account is debited.","BU",null,"Accounts receivable",null,null,null,"Asset","Asset - Remitted Receipts","Customer payments that need to be deposited or remitted to the bank.  When the transaction clears the bank, this account is credited and the appropriate cash account is debited.","BU",null,"Accounts receivable"]
[null,"Third Balancing Segment",null,null,null,"AON",null,"Azerbaijan",null,"Asset","Asset - Tax Recoverable Account","Tracks transaction taxes recoverable from tax authorities.  This account is needed when the tax is configured as Recoverable in the Tax module.","BU",null,"Accounts receivable",null,null,null,"Asset","Asset - Tax Recoverable Account","Tracks transaction taxes recoverable from tax authorities.  This account is needed when the tax is configured as Recoverable in the Tax module.","BU",null,"Accounts receivable"]
[null,"Second Balancing and Cost Center Segment",null,null,null,"ARA",null,"Bahamas",null,"Asset","Asset - Unapplied Cash","Funds held in a temporary account until final application of cash is made to the trade receivables.","BU",null,"Accounts receivable",null,null,null,"Asset","Asset - Unapplied Cash","Funds held in a temporary account until final application of cash is made to the trade receivables.","BU",null,"Accounts receivable"]
[null,"Intercompany Segment",null,null,null,"ARS",null,"Bahrain",null,"Asset","Asset - Unbilled Receivables","Tracks items that need to be billed as accounts receivable.","BU",null,"Accounts receivable",null,null,null,"Asset","Asset - Unbilled Receivables","Tracks items that need to be billed as accounts receivable.","BU",null,"Accounts receivable"]
[null,"Local Use Segment",null,null,null,"ATS",null,"Bangladesh",null,"Liability","Liability - Accounts Payable","Amount due to suppliers for products or services purchased on credit.","BU",null,"Accounts payable",null,null,null,"Liability","Liability - Accounts Payable","Amount due to suppliers for products or services purchased on credit.","BU",null,"Accounts payable"]
[null,"Natural Account Segment",null,null,null,"AUD",null,"Barbados",null,"Liability","Liability - Cost of Fixed Asset Removal Clearing","Clearing account used to account for payment of the cost incurred to remove fixed assets.  Only required if using the Assets module.","COA",null,"Property, plant, and equipment",null,null,null,"Liability","Liability - Cost of Fixed Asset Removal Clearing","Clearing account used to account for payment of the cost incurred to remove fixed assets.  Only required if using the Assets module.","COA",null,"Property, plant, and equipment"]
[null,"Cost Center Segment",null,null,null,"AWG",null,"Belarus",null,"Liability","Liability - Employees Payable","Balance due to employees for expense reports.  Only required if using the Expenses module. ","BU",null,"Accounts payable",null,null,null,"Liability","Liability - Employees Payable","Balance due to employees for expense reports.  Only required if using the Expenses module. ","BU",null,"Accounts payable"]
["#","END_OF_SEGMENT_CODES",null,null,null,"AZM",null,"Belgium",null,"Liability","Liability - Intercompany Payable","Tracks payables due from other companies in the group.","COA",null,"Accounts payable",null,null,null,"Liability","Liability - Intercompany Payable","Tracks payables due from other companies in the group.","COA",null,"Accounts payable"]
[null,null,null,null,null,"AZN",null,"Belize",null,"Liability","Liability - Tax Payable","Tax liability account for collected sales tax or self-assessed tax.","BU",null,"Tax liability",null,null,null,"Liability","Liability - Tax Payable","Tax liability account for collected sales tax or self-assessed tax.","BU",null,"Tax liability"]
[null,null,null,null,null,"BAM",null,"Benin",null,"Liability","Liability - Unearned Revenue","Tracks unearned revenue for invoices that have been billed in advance of when revenue can be recognized.","BU",null,"Deferred sales revenue",null,null,null,"Liability","Liability - Unearned Revenue","Tracks unearned revenue for invoices that have been billed in advance of when revenue can be recognized.","BU",null,"Deferred sales revenue"]
[null,null,null,null,null,"BBD",null,"Bermuda",null,"Owner's Equity","Owner's Equity - Retained Earnings","Tracks accumulated earnings that have not been disbursed as dividends to investors.","Ledger",null,"Retained earnings",null,null,null,"Owner's Equity","Owner's Equity - Retained Earnings","Tracks accumulated earnings that have not been disbursed as dividends to investors.","Ledger",null,"Retained earnings"]
["#","START_OF_3PARTY_ACCTS",null,null,null,"BDT",null,"Bhutan",null,"Revenue","Revenue - Autoinvoice Clearing","Clearing account for differences between the specified revenue amount and the selling price times the quantity for imported invoice lines. ","BU",null,"Sales revenue",null,null,null,"Revenue","Revenue - Autoinvoice Clearing","Clearing account for differences between the specified revenue amount and the selling price times the quantity for imported invoice lines. ","BU",null,"Sales revenue"]
[null,null,null,null,null,"BEF",null,"Bolivia",null,"Revenue","Revenue - Revenue","Revenue meeting accounting standards and recognized as earned income for goods sold or services provided for the accounting period.","BU",null,"Sales revenue",null,null,null,"Revenue","Revenue - Revenue","Revenue meeting accounting standards and recognized as earned income for goods sold or services provided for the accounting period.","BU",null,"Sales revenue"]
[null,"Customer",null,null,null,"BGL",null,"Bosnia and Herzegovina",null,"Revenue","Revenue - Top Revenues Parent Account","The top level revenues parent account value along with its descendants will be referenced in sample financial reports automatically created by the system based on this Rapid Implementation configuration.","BU",null,"Sales revenue",null,null,null,"Expense","Expense - Cash Reconciliation Difference","Tracks differences that arise from reconciling a cash account and its bank statement.","Legal Entity",null,"Miscellaneous operating expenses"]
[null,"No",null,null,null,"BGN",null,"Botswana",null,"Expense","Expense - Cash Reconciliation Difference","Tracks differences that arise from reconciling a cash account and its bank statement.","Legal Entity",null,"Miscellaneous operating expenses",null,null,null,"Expense","Expense - Conversion Rate Variance Gain/Loss","Gain or loss that results due to difference in exchange rates at which the invoice and receipt or purchase order are recorded. This variance is calculated only for inventory  or expense items which accrue on receipt.","BU",null,"Cost of goods sold"]
[null,"Restrict Manual Journals",null,null,null,"BHD",null,"Bouvet Island",null,"Expense","Expense - Conversion Rate Variance Gain/Loss","Gain or loss that results due to difference in exchange rates at which the invoice and receipt or purchase order are recorded. This variance is calculated only for inventory  or expense items which accrue on receipt.","BU",null,"Cost of goods sold",null,null,null,"Expense","Expense - Discount Taken","Discounts received for early payments made to suppliers as part of previously agreed payment terms.","BU",null,"Other operating expenses"]
[null,"Supplier",null,null,null,"BIF",null,"Brazil",null,"Expense","Expense - Discount Taken","Discounts received for early payments made to suppliers as part of previously agreed payment terms.","BU",null,"Other operating expenses",null,null,null,"Expense","Expense - Discounts Given","Collection discounts given to customers against the gross invoice amount.","BU",null,"Other sales expenses"]
[null,"Yes",null,null,null,"BMD",null,"British Indian Ocean Territory",null,"Expense","Expense - Discounts Given","Collection discounts given to customers against the gross invoice amount.","BU",null,"Other sales expenses",null,null,null,"Expense","Expense - Freight","Freight charges incurred for transporting goods.","BU",null,"Freight expenses"]
["#","END_OF_3PARTY_ACCTS",null,null,null,"GHS",null,"Brunei Darussalam",null,"Expense","Expense - Freight","Freight charges incurred for transporting goods.","BU",null,"Freight expenses",null,null,null,"Expense","Expense - Gain/Loss On Fixed Asset Disposal","Gain or loss on the disposal of fixed assets by sale, retirement, or removal.  Only required if using the Assets module.","COA",null,"Other income"]
[null,null,null,null,null,"GIP",null,"Bulgaria",null,"Expense","Expense - Gain/Loss On Fixed Asset Disposal","Gain or loss on the disposal of fixed assets by sale, retirement, or removal.  Only required if using the Assets module.","COA",null,"Other income",null,null,null,"Expense","Expense - Miscellaneous Expenses","Small and sundry expenses like loading or unloading charges incurred during the purchase of materials or services.","BU",null,"Miscellaneous operating expenses"]
[null,null,null,null,null,"GMD",null,"Burkina Faso",null,"Expense","Expense - Miscellaneous Expenses","Small and sundry expenses like loading or unloading charges incurred during the purchase of materials or services.","BU",null,"Miscellaneous operating expenses",null,null,null,"Expense","Expense - Realized Gain/Loss on Foreign Currency Conversions","Gain or loss due to exchange rate variances between invoices and payments.","BU",null,"Other income"]
["#","START_OF_YES_NO",null,null,null,"GNF",null,"Burundi",null,"Expense","Expense - Realized Gain/Loss on Foreign Currency Conversions","Gain or loss due to exchange rate variances between invoices and payments.","BU",null,"Other income",null,null,null,"Expense","Expense - Rounding Difference and Balancing Adjustments","Tracks adjustments to offset imbalances from rounding differences, conversion of foreign currency denominated transactions or unbalanced journal entries.","BU",null,"Other operating expenses"]
[null,null,null,null,null,"GRD",null,"Cabo Verde",null,"Expense","Expense - Rounding Difference and Balancing Adjustments","Tracks adjustments to offset imbalances from rounding differences, conversion of foreign currency denominated transactions or unbalanced journal entries.","BU",null,"Other operating expenses"]
[null,"No",null,null,null,"GTQ",null,"Cambodia",null,"Expense","Expense - Top Operating Expenses Parent Account","The top level operating expenses parent account value along with its descendants will be referenced in sample financial reports automatically created by the system based on this Rapid Implementation configuration.","BU",null,"Other operating expenses"]
[null,"Yes",null,null,null,"GWP",null,"Cameroon",null,"Expense","Expense - Top Cost of Sales Parent Account","The top level cost of goods sold parent account value along with its descendants will be referenced in sample financial reports automatically created by the system based on this Rapid Implementation configuration.","BU",null,"Cost of goods sold"]
["#","END_OF_YES_NO",null,null,null,"GYD",null,"Canada"]
[null,null,null,null,null,"HKD",null,"Cayman Islands"]
[null,null,null,null,null,"HNL",null,"Central African Republic"]
["#","START_OF_FIN_CATEGORY",null,null,null,"HRD",null,"Chad"]
[null,null,null,null,null,"HRK",null,"Chile"]
[null,"Accounts payable",null,null,null,"HTG",null,"China"]
[null,"Accounts receivable",null,null,null,"HUF",null,"Christmas Island"]
[null,"Accrued liabilities",null,null,null,"IDR",null,"Cocos (Keeling) Islands"]
[null,"Accumulated depreciation",null,null,null,"IEP",null,"Colombia"]
[null,"Cash",null,null,null,"ILS",null,"Comoros"]
[null,"Common stock",null,null,null,"INR",null,"Congo"]
[null,"Contracting expenses",null,null,null,"IQD",null,"Congo, The Democratic Republic of the"]
[null,"Cost of goods sold",null,null,null,"IRR",null,"Cook Islands"]
[null,"Deferred cost of goods sold",null,null,null,"ISK",null,"Costa Rica"]
[null,"Deferred sales revenue",null,null,null,"ITL",null,"Cote d'Ivoire"]
[null,"Depreciation expenses",null,null,null,"JMD",null,"Croatia"]
[null,"Employee benefits related expenses",null,null,null,"JOD",null,"Cuba"]
[null,"Employee overtime",null,null,null,"JPY",null,"Curacao"]
[null,"Employee support and cafeteria expenses",null,null,null,"KES",null,"Cyprus"]
[null,"Finished goods inventory",null,null,null,"KGS",null,"Czech Republic"]
[null,"Freight expenses",null,null,null,"KHR",null,"Denmark"]
[null,"General administrative and payroll expense",null,null,null,"KMF",null,"Djibouti"]
[null,"Goodwill",null,null,null,"KPW",null,"Dominica"]
[null,"Income tax",null,null,null,"KRW",null,"Dominican Republic"]
[null,"Interest expenses",null,null,null,"KWD",null,"Ecuador"]
[null,"Long term debt",null,null,null,"KYD",null,"Egypt"]
[null,"Marketing payroll",null,null,null,"KZT",null,"El Salvador"]
[null,"Miscellaneous operating expenses",null,null,null,"LAK",null,"Equatorial Guinea"]
[null,"Miscellaneous travel and entertainment expenses",null,null,null,"LBP",null,"Eritrea"]
[null,"Other assets",null,null,null,"LKR",null,"Estonia"]
[null,"Other current assets",null,null,null,"LRD",null,"Eswatini"]
[null,"Other current liabilities",null,null,null,"LSL",null,"Ethiopia"]
[null,"Other equity related",null,null,null,"LTL",null,"Falkland Islands (Malvinas)"]
[null,"Other income",null,null,null,"LUC",null,"Faroe Islands"]
[null,"Other liabilities",null,null,null,"LUF",null,"Fiji"]
[null,"Other marketing expenses",null,null,null,"LUL",null,"Finland"]
[null,"Other operating expenses",null,null,null,"LVL",null,"France"]
[null,"Other research and development expenses",null,null,null,"LVR",null,"French Guiana"]
[null,"Other sales expenses",null,null,null,"LYD",null,"French Polynesia"]
[null,"Preferred stock",null,null,null,"MAD",null,"French Southern Territories"]
[null,"Prepaid expenses",null,null,null,"MDL",null,"Gabon"]
[null,"Product variance expenses",null,null,null,"MGA",null,"Gambia"]
[null,"Property, plant, and equipment",null,null,null,"BND",null,"Georgia"]
[null,"Purchasing",null,null,null,"BOB",null,"Germany"]
[null,"Raw material costs",null,null,null,"BOV",null,"Ghana"]
[null,"Raw material inventory",null,null,null,"BRC",null,"Gibraltar"]
[null,"Research and development payroll",null,null,null,"BRL",null,"Greece"]
[null,"Retained earnings",null,null,null,"BSD",null,"Greenland"]
[null,"Sales payroll",null,null,null,"BTN",null,"Grenada"]
[null,"Sales revenue",null,null,null,"BUK",null,"Guadeloupe"]
[null,"Short term borrowing",null,null,null,"BWP",null,"Guam"]
[null,"Tax liability",null,null,null,"BYB",null,"Guatemala"]
[null,"Travel and entertainment expenses",null,null,null,"BYR",null,"Guernsey"]
[null,"WIP inventory",null,null,null,"BZD",null,"Guinea"]
["#","END_OF_FIN_CATEGORY",null,null,null,"CAD",null,"Guinea-Bissau"]
[null,null,null,null,null,"CDF",null,"Guyana"]
["#","START_OF_ACCOUNT_TYPE",null,null,null,"CHE",null,"Haiti"]
[null,null,null,null,null,"CHF",null,"Heard Island and McDonald Islands"]
[null,"Asset",null,null,null,"CHW",null,"Holy See (Vatican City State)"]
[null,"Expense",null,null,null,"CLF",null,"Honduras"]
[null,"Liability",null,null,null,"CLP",null,"Hong Kong"]
[null,"Owner's Equity",null,null,null,"CNY",null,"Hungary"]
[null,"Revenue",null,null,null,"COP",null,"Iceland"]
[null,null,null,null,null,"COU",null,"India"]
[null,null,null,null,null,"CRC",null,"Indonesia"]
["#","END_OF_ACCOUNT_TYPE",null,null,null,"CSK",null,"Iran, Islamic Republic of"]
[null,null,null,null,null,"CUP",null,"Iraq"]
["#","START_OF_COMMENT",null,null,null,"CVE",null,"Ireland"]
[null,null,null,null,null,"CYP",null,"Isle of Man"]
[null,"#",null,null,null,"CZK",null,"Israel"]
["#","END_OF_COMMENT",null,null,null,"DEM",null,"Italy"]
[null,null,null,null,null,"DJF",null,"Jamaica"]
[null,null,null,null,null,"DKK",null,"Japan"]
[null,"+",null,null,null,"DOP",null,"Jersey"]
[null,"-",null,null,null,"DZD",null,"Jordan"]
[null,"*",null,null,null,"ECS",null,"Kazakhstan"]
[null,"!",null,null,null,"ECV",null,"Kenya"]
[null,".",null,null,null,"EEK",null,"Kiribati"]
[null,"=",null,null,null,"EGP",null,"Korea, Democratic People's Republic of"]
[null,":",null,null,null,"ERN",null,"Korea, Republic of"]
[null,"^",null,null,null,"ESB",null,"Kosovo"]
[null,"~",null,null,null,"ESP",null,"Kuwait"]
[null,null,null,null,null,"ETB",null,"Kyrgyzstan"]
[null,null,null,null,null,"EUR",null,"Lao People's Democratic Republic"]
[null,null,null,null,null,"FIM",null,"Latvia"]
[null,null,null,null,null,"FJD",null,"Lebanon"]
[null,"None",null,null,null,"FKP",null,"Lesotho"]
[null,"Once at beginning of year and once at end of the year",null,null,null,"FRF",null,"Liberia"]
[null,"Once mid year and once at year end",null,null,null,"GBP",null,"Libya"]
[null,"Once at year end",null,null,null,"GEK",null,"Liechtenstein"]
[null,"Quarterly",null,null,null,"GEL",null,"Lithuania"]
[null,null,null,null,null,"GHC",null,"Luxembourg"]
[null,null,null,null,null,"SHP",null,"Macao"]
[null,null,null,null,null,"SIT",null,"Madagascar"]
[null,"Monthly",null,null,null,"SKK",null,"Malawi"]
[null,"4/4/5",null,null,null,"SLL",null,"Malaysia"]
[null,"4/5/4",null,null,null,"SOS",null,"Maldives"]
[null,"4 Week",null,null,null,"SRD",null,"Mali"]
[null,"5/4/4",null,null,null,"SRG",null,"Malta"]
[null,"Annually",null,null,null,"STAT",null,"Marshall Islands"]
[null,"Monthly",null,null,null,"STD",null,"Martinique"]
[null,"Never",null,null,null,"SUR",null,"Mauritania"]
[null,null,null,null,null,"SVC",null,"Mauritius"]
[null,null,null,null,null,"SYP",null,"Mayotte"]
[null,null,null,null,null,"SZL",null,"Mexico"]
[null,null,null,null,null,"THB",null,"Micronesia, Federated States of"]
[null,null,null,null,null,"TJR",null,"Moldova"]
[null,null,null,null,null,"TJS",null,"Monaco"]
[null,null,null,null,null,"TMM",null,"Mongolia"]
[null,null,null,null,null,"TND",null,"Montenegro"]
[null,null,null,null,null,"TOP",null,"Montserrat"]
[null,null,null,null,null,"TPE",null,"Morocco"]
[null,null,null,null,null,"TRL",null,"Mozambique"]
[null,null,null,null,null,"TRY",null,"Myanmar"]
[null,null,null,null,null,"TTD",null,"Namibia"]
[null,null,null,null,null,"TWD",null,"Nauru"]
[null,null,null,null,null,"TZS",null,"Nepal"]
[null,null,null,null,null,"UAH",null,"Netherlands"]
[null,null,null,null,null,"UAK",null,"Netherlands Antilles"]
[null,null,null,null,null,"UGS",null,"New Caledonia"]
[null,null,null,null,null,"UGX",null,"New Zealand"]
[null,null,null,null,null,"USD",null,"Nicaragua"]
[null,null,null,null,null,"USN",null,"Niger"]
[null,null,null,null,null,"USS",null,"Nigeria"]
[null,null,null,null,null,"UYI",null,"Niue"]
[null,null,null,null,null,"UYP",null,"Norfolk Island"]
[null,null,null,null,null,"UYU",null,"North Macedonia"]
[null,null,null,null,null,"UZS",null,"Northern Mariana Islands"]
[null,null,null,null,null,"VEB",null,"Norway"]
[null,null,null,null,null,"VEF",null,"Oman"]
[null,null,null,null,null,"VND",null,"Pakistan"]
[null,null,null,null,null,"VUV",null,"Palau"]
[null,null,null,null,null,"WST",null,"Palestine, State of"]
[null,null,null,null,null,"XAF",null,"Panama"]
[null,null,null,null,null,"XAG",null,"Papua New Guinea"]
[null,null,null,null,null,"XAU",null,"Paraguay"]
[null,null,null,null,null,"XB5",null,"Peru"]
[null,null,null,null,null,"XBA",null,"Philippines"]
[null,null,null,null,null,"XBB",null,"Pitcairn"]
[null,null,null,null,null,"XBC",null,"Poland"]
[null,null,null,null,null,"XBD",null,"Portugal"]
[null,null,null,null,null,"XCD",null,"Puerto Rico"]
[null,null,null,null,null,"XDR",null,"Qatar"]
[null,null,null,null,null,"XEU",null,"Reunion"]
[null,null,null,null,null,"XFO",null,"Romania"]
[null,null,null,null,null,"XFU",null,"Russian Federation"]
[null,null,null,null,null,"XOF",null,"Rwanda"]
[null,null,null,null,null,"XPD",null,"Saint Barthelemy"]
[null,null,null,null,null,"XPF",null,"Saint Helena, Ascension and Tristan da Cunha"]
[null,null,null,null,null,"XPT",null,"Saint Kitts and Nevis"]
[null,null,null,null,null,"XTS",null,"Saint Lucia"]
[null,null,null,null,null,"XXX",null,"Saint Martin (French part)"]
[null,null,null,null,null,"YDD",null,"Saint Pierre and Miquelon"]
[null,null,null,null,null,"YER",null,"Saint Vincent and the Grenadines"]
[null,null,null,null,null,"YUD",null,"Samoa"]
[null,null,null,null,null,"YUM",null,"San Marino"]
[null,null,null,null,null,"YUN",null,"Sao Tome and Principe"]
[null,null,null,null,null,"ZAL",null,"Saudi Arabia"]
[null,null,null,null,null,"ZAR",null,"Senegal"]
[null,null,null,null,null,"ZMK",null,"Serbia"]
[null,null,null,null,null,"ZRN",null,"Seychelles"]
[null,null,null,null,null,"ZRZ",null,"Sierra Leone"]
[null,null,null,null,null,"ZWD",null,"Singapore"]
[null,null,null,null,null,"MGF",null,"Slovakia"]
[null,null,null,null,null,"MKD",null,"Slovenia"]
[null,null,null,null,null,"MMK",null,"Solomon Islands"]
[null,null,null,null,null,"MNT",null,"Somalia"]
[null,null,null,null,null,"MOP",null,"South Africa"]
[null,null,null,null,null,"MRO",null,"South Georgia and the South Sandwich Islands"]
[null,null,null,null,null,"MTL",null,"South Sudan"]
[null,null,null,null,null,"MUR",null,"Spain"]
[null,null,null,null,null,"MVR",null,"Sri Lanka"]
[null,null,null,null,null,"MWK",null,"Sudan"]
[null,null,null,null,null,"MXN",null,"Suriname"]
[null,null,null,null,null,"MXP",null,"Svalbard and Jan Mayen"]
[null,null,null,null,null,"MXV",null,"Sweden"]
[null,null,null,null,null,"MYR",null,"Switzerland"]
[null,null,null,null,null,"MZM",null,"Syrian Arab Republic"]
[null,null,null,null,null,"MZN",null,"Taiwan"]
[null,null,null,null,null,"NAD",null,"Tajikistan"]
[null,null,null,null,null,"NGN",null,"Tanzania, United Republic of"]
[null,null,null,null,null,"NIC",null,"Thailand"]
[null,null,null,null,null,"NIO",null,"Timor-Leste"]
[null,null,null,null,null,"NLG",null,"Togo"]
[null,null,null,null,null,"NOK",null,"Tokelau"]
[null,null,null,null,null,"NPR",null,"Tonga"]
[null,null,null,null,null,"NZD",null,"Trinidad and Tobago"]
[null,null,null,null,null,"OMR",null,"Tunisia"]
[null,null,null,null,null,"PAB",null,"Turkey"]
[null,null,null,null,null,"PEI",null,"Turkmenistan"]
[null,null,null,null,null,"PEN",null,"Turks and Caicos Islands"]
[null,null,null,null,null,"PGK",null,"Tuvalu"]
[null,null,null,null,null,"PHP",null,"Uganda"]
[null,null,null,null,null,"PKR",null,"Ukraine"]
[null,null,null,null,null,"PLN",null,"United Arab Emirates"]
[null,null,null,null,null,"PLZ",null,"United Kingdom"]
[null,null,null,null,null,"PTE",null,"United States"]
[null,null,null,null,null,"PYG",null,"United States Minor Outlying Islands"]
[null,null,null,null,null,"QAR",null,"Uruguay"]
[null,null,null,null,null,"ROL",null,"Uzbekistan"]
[null,null,null,null,null,"RON",null,"Vanuatu"]
[null,null,null,null,null,"RSD",null,"Venezuela"]
[null,null,null,null,null,"RUB",null,"Viet Nam"]
[null,null,null,null,null,"RUR",null,"Virgin Islands, British"]
[null,null,null,null,null,"RWF",null,"Virgin Islands, U.S."]
[null,null,null,null,null,"SAR",null,"Wallis and Futuna"]
[null,null,null,null,null,"SBD",null,"Western Sahara"]
[null,null,null,null,null,"SCR",null,"Yemen"]
[null,null,null,null,null,"SDD",null,"Zambia"]
[null,null,null,null,null,"SDG",null,"Zimbabwe"]
[null,null,null,null,null,"SDP"]
[null,null,null,null,null,"SEK"]
[null,null,null,null,null,"SGD"]

{"sheet":"Hierarchies Validaton Report","index":6,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
["Sheet","Field","Error"]

{"sheet":"Validation Report","index":7,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
["Sheet","Field","Error"]

{"sheet":"CostCenter","index":8,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,3,10],[2,11,4,11]]}
[null,"CostCenter",null,null,null,null,null,null,null,null,null,null,"Note"]
[null,"* Required"]
[null,"*Value",null,null,null,null,null,null,null,null,null,"*Description"]
[]
[null,"Parent9","Parent8","Parent7","Parent6","Parent5","Parent4","Parent3","Parent2","Parent1","Child"]
[null,null,null,null,null,null,"999",null,null,null,null,"Total SS Cost Centers"]
[null,null,null,null,null,null,null,null,null,null,"000","None"]
[null,null,null,null,null,null,null,null,null,null,"110","Finance and Accounting"]
[null,null,null,null,null,null,null,null,null,null,"111","Sales"]
[null,null,null,null,null,null,null,null,null,null,"112","HR"]
[null,null,null,null,null,null,null,null,null,null,"113","SCM"]
[null,null,null,null,null,null,null,null,null,null,"114","Marketing"]

{"sheet":"Product","index":9,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,3,10],[2,11,4,11]]}
[null,"Product",null,null,null,null,null,null,null,null,null,null,"Note"]
[null,"* Required"]
[null,"*Value",null,null,null,null,null,null,null,null,null,"*Description"]
[]
[null,"Parent9","Parent8","Parent7","Parent6","Parent5","Parent4","Parent3","Parent2","Parent1","Child"]
[null,null,null,null,null,null,null,null,"9999",null,null,"SS Total Products"]
[null,null,null,null,null,null,null,null,null,null,"0000","None"]
[null,null,null,null,null,null,null,null,null,"1000",null,"Consulting"]
[null,null,null,null,null,null,null,null,null,null,"1111","Implementation"]
[null,null,null,null,null,null,null,null,null,null,"1211","Support"]
[null,null,null,null,null,null,null,null,null,null,"1311","Enhancement"]
[null,null,null,null,null,null,null,null,null,null,"1411","Resourcing"]

{"sheet":"Intercompany","index":10,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,3,10],[2,11,4,11]]}
[null,"Intercompany",null,null,null,null,null,null,null,null,null,null,"Note"]
[null,"* Required"]
[null,"*Value",null,null,null,null,null,null,null,null,null,"*Description"]
[]
[null,"Parent9","Parent8","Parent7","Parent6","Parent5","Parent4","Parent3","Parent2","Parent1","Child"]
[null,null,null,null,null,null,"5000",null,null,null,null,"Total QS Companies"]
[null,null,null,null,null,null,null,null,null,null,"0000","None"]
[null,null,null,null,null,null,null,"3000",null,null,null,"QS Singapore"]
[null,null,null,null,null,null,null,null,null,null,"3777","SG QS HQ BU1"]
[null,null,null,null,null,null,null,null,null,null,"3888","SG QS BU2"]
[null,null,null,null,null,null,null,null,null,null,"3999","SG QS BU3"]
[null,null,null,null,null,null,null,"4000",null,null,null,"QS Malaysia"]
[null,null,null,null,null,null,null,null,null,null,"4888","MY QS BU1"]
[null,null,null,null,null,null,null,null,null,null,"4999","MY QS BU2"]

{"sheet":"Financial Sequences","index":11,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Sequences"]
[]
[null,"Transactions","*Restart","*Initial Value"]
[null,"Payables Invoices","Monthly",1]
[null,"Payments","Annually",1]
[null,"Receivables Invoices","Never",1]
[null,"Receivables Credit Memos","Monthly",1]
[null,"Receivables Adjustment Activities","Monthly",1]
[null,"Subledger Journals","Never",1]
[null,"General Ledger Journals","Never",1]

{"sheet":"Preview Report","index":12,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":true,"merged":[[27,16,27,17],[30,16,30,17],[20,16,20,17],[4,2,4,13],[5,2,5,13],[6,2,6,13],[7,2,7,11],[17,16,17,17]]}
[]
[]
[]
[null,"Financial Reporting Sample Report",null,null,null,null,null,null,null,null,null,null,null,null,null,"Revenues Account Group Sample Infolet"]
[null,null,"Rolling Quarterly Income Statement"]
[null,null,"InFusion Ledger"]
[null,null,"Period Ending Qtr4-YY"]
[]
[null,null,null,"Qtr1-YY",null,"Qtr2-YY",null,"Qtr3-YY",null,"Qtr4-YY",null,"Total"]
[null,null,"41000-Total Net Trade Revenue",999999999,null,999999999,null,999999999,null,999999999,null,999999999]
[null,null,"41100-Total Intercompany Revenues",999999999,null,999999999,null,999999999,null,999999999,null,999999999]
[null,null,"41200-Total Other Income",999999999,null,999999999,null,999999999,null,999999999,null,999999999]
[null,null,"REV-Total Revenues",999999999,null,999999999,null,999999999,null,999999999,null,999999999]
[]
[null,null,"53500-Small Tools and Equipment Expenses",999999999,null,999999999,null,999999999,null,999999999,null,999999999]
[null,null,"59000-Total Customer Reward Programs",999999999,null,999999999,null,999999999,null,999999999,null,999999999]
[null,null,"60001-Total Petty Cash Disbursements",999999999,null,999999999,null,999999999,null,999999999,null,999999999]
[null,null,"60000-Total Other Expenses",999999999,null,999999999,null,999999999,null,999999999,null,999999999,null,null,null,null,"Miscellaneous"]
[]
[null,null,"Net Income",999999999,null,999999999,null,999999999,null,999999999,null,999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Othe"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Inte"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Net "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"End"]

{"sheet":"Additional Segment Template","index":13,"n_rows":5,"n_cols":13,"rows_kept":5,"cut":false,"hidden":true,"merged":[[2,11,4,11],[2,1,3,10]]}
[null,"Additional Segment Name",null,null,null,null,null,null,null,null,null,null,"Note"]
[null,"* Required"]
[null,"*Value",null,null,null,null,null,null,null,null,null,"*Description"]
[]
[null,"Parent9","Parent8","Parent7","Parent6","Parent5","Parent4","Parent3","Parent2","Parent1","Child"]