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

{"sheet":"Instructions","index":0,"n_rows":41,"n_cols":2,"rows_kept":41}
[]
[]
[]
[null,"How to prepare a Customer Adjustment Import to Infusion"]
[]
[null,"Instructions"]
[null,"Use this template to prepare for an import of Customer Adjustments into Infusion Software."]
[]
[null,"Required fields: Customer, GL Account, Cost Centre, Date, GST rate"]
[]
[null,"READY TO IMPORT? \n"]
[null,"On the Template worksheet, go to File > Download > Comma-separated values (csv, current sheet). \nThe sheet will download as a .csv and is ready to import into Infusion."]
[]
[null,"Field Requirements"]
[]
[null,"Customer"]
[null,"REQUIRED; Enter the Customer ID for the customer that is having the adjustment applied"]
[null,"Customer ID is also known as Customer Account number."]
[]
[null,"GL Account"]
[null,"REQUIRED; Reference the GL Account the adjustment applies to."]
[null,"The default GL codes are provided in the GL Accounts column on the Lists worksheet. If you are using different GL codes, replace the codes in this list."]
[]
[null,"Cost Centre"]
[null,"REQUIRED; Cost Centre is under development. Until it is released, use 'Default'."]
[]
[null,"Date"]
[null,"REQUIRED;  required format is DD-MM-YYYY"]
[]
[null,"Reference"]
[null,"OPTIONAL; update any references to invoices or payments that the adjustment applies to"]
[]
[null,"Description"]
[null,"OPTIONAL; provide additional details to provide explanation for the adjustment"]
[]
[null,"GST Rate"]
[null,"REQUIRED; Apply the appropriate GST rate for the adjustment."]
[null,"The default GST options are provided in the GST Rate column on the Lists worksheet. Update this list if you have Alternative GST Rates."]
[]
[null,"GST Exclusive ($)  /  GST Inclusive ($)"]
[null,"OPTIONAL; use either the Exclusive or Inclusive column to enter the adjustment amount. Use a '+' amount to issue a credit to the customer and a '-' amount to issue a debit."]

{"sheet":"Template","index":1,"n_rows":1,"n_cols":9,"rows_kept":1}
["Customer","GL Account","Cost Centre","Date","Reference","Description","GST rate","GST Exclusive ($)","GST Inclusive ($)"]

{"sheet":"Lists","index":2,"n_rows":88,"n_cols":3,"rows_kept":88}
["GL Account","Cost Centre","GST rate"]
[1020,null,"Customs"]
[1030,null,"Exempt"]
[1040,null,"Standard"]
[1050,null,"Zero-rated"]
[1060]
[1070]
[1080]
[2100]
[2110]
[2120]
[2130]
[2200]
[3110]
[3120]
[3130]
[3140]
[3150]
[3160]
[3170]
[3180]
[3190]
[3210]
[3220]
[3230]
[3240]
[3250]
[3260]
[3270]
[3280]
[3290]
[3300]
[3320]
[3360]
[3410]
[3420]
[3430]
[3440]
[3450]
[3460]
[3470]
[3480]
[3510]
[3520]
[3530]
[3540]
[3610]
[3620]
[3630]
[3640]
[3710]
[3720]
[3730]
[3810]
[3820]
[3910]
[3920]
[3930]
[7010]
[7050]
[7060]
[8010]
[8020]
[8035]
[8040]
[8050]
[8060]
[8070]
[8075]
[8080]
[8110]
[8120]
[8210]
[8220]
[8310]
[8320]
[8410]
[8420]
[9000]
[9010]
[9015]
[9020]
[9025]
[9040]
[9050]
[9060]
[9110]
[9910]