{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Template","Lists"],"not_rendered":{"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":98,"n_cols":2,"rows_kept":98}
[]
[]
[null,"How to prepare a GL Account Import to Infusion"]
[]
[null,"Instructions"]
[null,"Use this template to prepare for an import of GL Codes to Infusion Software."]
[]
[null,"Drop-down lists have been created for fields that have specific input requirements, refer to the Lists worksheet."]
[]
[null,"Required fields: ID, Name, Function, Default GST Rate, GST Inclusive, Bank Account / Credit Card, Consolidate by Branch."]
[null,"As the GL ID Code is entered in column 1, required cells will highlight."]
[null,"Dependent fields: Year end roll account, Closing inventory account, Inventory account, Account number, Card number"]
[null,"Requires information depending on selections made in other cells; cells will highlight as required. "]
[]
[null,"Numeric formatting"]
[null,"Cells requiring numbers have been formatted to default to Infusion format settings. Refer column headers for layout details."]
[]
[null,"Header notes"]
[null,"Refer for more information about the fields and requirements in column headers. "]
[]
[]
[null,"READY TO IMPORT? "]
[null,"Save as a .csv file to import into Infusion."]
[]
[]
[null,"Field Requirements"]
[null,"ID"]
[null,"REQUIRED; Enter the GL Code ID reference"]
[]
[null,"Name"]
[null,"REQUIRED; Enter the GL Code name"]
[]
[null,"Function"]
[null,"REQUIRED; Choose from the list to set the function."]
[null,"Note - Depending on the Function selected, further fields will become mandatory. These will highlight to indicate data is required."]
[]
[null,"Financial settings accounts"]
[null,"Don't use. Doesn't update and has been set at the time of set up."]
[]
[null,"Default GST rate"]
[null,"REQUIRED; Choose from the drop down list, no free text allowed."]
[]
[null,"GST Inclusive"]
[null,"REQUIRED; Choose from the drop down list, no free text allowed."]
[]
[null,"Year end roll account"]
[null,"DEPENDENT; Use for 'Transaction' Function accounts. Update the required GL Account ID."]
[null,"Note - if a 'Transaction' Function account is used, the 'Year end roll account' will highlight with a message. Delete to make a blank field if not known."]
[]
[null,"Closing inventory account"]
[null,"DEPENDENT; GL ID Code is required if Function field is 'Expense - Opening Inventory', otherwise leave blank"]
[null,"Note - the field will highlight advising it is now a required field to complete"]
[]
[null,"Inventory account"]
[null,"DEPENDENT; GL ID Code is required if Function field is 'Income - Closing Inventory', otherwise leave blank"]
[null,"Note - the field will highlight advising it is now a required field to complete"]
[]
[null,"Export account ID"]
[null,"OPTIONAL; free text field"]
[]
[null,"Notes"]
[null,"OPTIONAL; free text field, update any internal notes for reference against the GL account"]
[]
[null,"Bank Account/ Credit card"]
[null,"REQUIRED; \nNon-Banking - use for GL Accounts that are not a bank account\nBank account - use for GL Accounts that are a bank account\nCredit card- use for GL Accounts that are a credit card"]
[]
[null,"Consolidate by branch"]
[null,"REQUIRED; Set to 'Always' if consolidating or 'Never' if not"]
[]
[null,"Account number"]
[null,"DEPENDENT; If 'Bank Account / Credit Card' is set to Bank account update the bank account number"]
[null,"Note - a valid Bank Account number must be used, a 'dummy' bank account number will not import\nFormat must follow 12-3456-1234567-123 OR 12-3456-1234567-12"]
[null,"Note - the field will highlight advising it is now a required field to complete"]
[]
[null,"Opening bank rec balance"]
[null,"OPTIONAL; Enter as a number (no symbols or $ sign), to maximum two decimal places"]
[null,"Format must follow 123456.78"]
[]
[null,"Direct debit authority no"]
[null,"OPTIONAL; Enter if known"]
[]
[null,"Company identifier"]
[null,"OPTIONAL; Enter if known"]
[]
[null,"Overdraft limit"]
[null,"OPTIONAL; Enter as a number (no symbols or $ sign), to maximum two decimal places"]
[null,"Format must follow 123456.78"]
[]
[null,"Interest rate %"]
[null,"OPTIONAL; Enter as a number (no symbols or % sign), to maximum two decimal places"]
[]
[null,"Card number (last 4 digits)"]
[null,"DEPENDENT; If 'Bank Account / Credit Card' is set to Credit card, update the last four digits of the credit card"]
[null,"Note - the field will highlight advising it is now a required field to complete"]
[]
[null,"Credit limit"]
[null,"OPTIONAL; Enter as a number (no symbols or $ sign), to maximum two decimal places"]
[null,"Format must follow 123456.78"]

{"sheet":"Template","index":1,"n_rows":1,"n_cols":21,"rows_kept":1}
["ID","Name","Function","Financial settings accounts","Default GST rate","GST Inclusive","Year end roll account","Closing inventory account","Inventory account","Export account ID","Notes","Bank Account/ Credit card","Consolidate by branch","Account number","Opening bank rec balance","Direct debit authority no","Company identifier","Overdraft limit","Interest rate %","Card number (last 4 digits)","Credit limit"]

{"sheet":"Lists","index":2,"n_rows":19,"n_cols":6,"rows_kept":19}
["Function","Financial settings accounts","Default GST rate","GST Inclusive","Bank Account/ Credit Card","Consolidate by branch"]
["Income - Transaction","Customer Control","Standard","Yes","Non banking","Always"]
["Income - Closing Inventory","Customer Discounts","Exempt","No","Bank Account","Never"]
["Expense - Transaction","Undeposited Funds","Customs",null,"Credit Card"]
["Expense - Opening Inventory","Finance Charges","Zero-rated"]
["Current Asset - Transaction","Freight Inward"]
["Current Asset - Year End","Freight Outward"]
["Intangible Asset - Transaction","Rounding"]
["Intangible Asset - Year End","Default Sales"]
["Fixed Asset - Transaction","Default Purchases"]
["Fixed Asset - Year End","Default Closing"]
["Current Liability - Transaction","GST Income"]
["Current Liability - Year End","GST Expense"]
["Term Liability - Transaction","GST Payment"]
["Term Liability - Year End","Supplier Control"]
["Equity - Transaction","Supplier Discounts"]
["Equity - Year End","Unexported Direct Credits"]
["Equity - Retained Earnings"]
["Equity - Current Earnings"]