{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Debtors, Creditors & GL","Debtors Only"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Debtors, Creditors & GL","index":0,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Transaction Entries and their Reversing Journal Types"]
["Debtors Module (Client Accounts / Accounts Receivable)"]
[null,"Original Entry","Tran Type","Action","Reversing Journal Type","Effect on Balance Owed","Sign of GL Control Acct","Default Control Acct","Sign of Other Acct","Other GL Acct to Specify"]
[null,"Invoice","INV","enter",null,"increase","debit","Debtors","credit","Sales"]
[null,null,null,"reverse","CN / WO / JCR","decrease","credit","Debtors","debit","Sales"]
[null,"Credit Note","CN","enter",null,"decrease","credit","Debtors","debit","Sales"]
[null,null,null,"reverse","JDR","increase","debit","Debtors","credit","Sales"]
[null,"Payment","PAY","enter",null,"decrease","credit","Debtors","debit","Bank"]
[null,"(Cash Jnl to reverse)",null,"reverse","RF / JDR","increase","debit","Debtors","credit","Bank"]
[null,"Discount Given","DIS","enter",null,"decrease","credit","Debtors","debit","Sales"]
[null,null,null,"reverse","JDR","increase","debit","Debtors","credit","Sales"]
[null,"Interest ","INT","enter",null,"increase","debit","Debtors","credit","Interest Revenue"]
[null,"(Calculated)",null,"reverse","JCR","decrease","credit","Debtors","debit","Interest Revenue"]
[null,"WriteOff","WO","enter",null,"decrease","credit","Debtors","debit","Bad Debts"]
[null,null,null,"reverse","JDR","increase","debit","Debtors","credit","Bad Debts"]
[null,"Refund","RF","enter",null,"increase","debit","Debtors","credit","Bank"]
[null,"(Cash Jnl to reverse)",null,"reverse","PAY / JCR","decrease","credit","Debtors","debit","Bank"]
[null,"Credit Interest","CIN","enter",null,"decrease","credit","Debtors","debit","Interest Expense"]
[null,null,null,"reverse","JDR","increase","debit","Debtors","credit","Interest Expense"]
[null,"Journal Credit","JCR","enter",null,"decrease","credit","Debtors","debit","Sales or Bank"]
[null,null,null,"reverse","JDR","increase","debit","Debtors","credit","Sales or Bank"]
[null,"Journal Debit","JDR","enter",null,"increase","debit","Debtors","credit","Sales or Bank"]
[null,null,null,"reverse","JCR","decrease","credit","Debtors","debit","Sales or Bank"]
[null,"Opening Balance","OB","enter",null,"increase","debit","Debtors","credit","Sales"]
[null,null,null,"reverse","WO / JCR","decrease","credit","Debtors","debit","Sales"]
[]
["Creditors (Suppliers / Accounts Payable)"]
[null,"Original Entry","Tran Type","Action","Reversing Journal Type","Effect on Balance Owed","Sign of GL Control Acct","Default Control Acct","Sign of Other Acct","Other GL Acct to Specify"]
[null,"Invoice","INV","enter",null,"increase","credit","Creditors","debit","Expense"]
[null,null,null,"reverse","CN / WO / JDR","decrease","debit","Creditors","credit","Expense"]
[null,"Credit Note","CN","enter",null,"decrease","debit","Creditors","credit","Expense"]
[null,null,null,"reverse","JCR","increase","credit","Creditors","debit","Expense"]
[null,"Payment","PAY","enter",null,"decrease","debit","Creditors","credit","Bank"]
[null,"(Cash Jnl to reverse)",null,"reverse","RF / JCR","increase","credit","Creditors","debit","Bank"]
[null,"Discount","DIS","enter",null,"decrease","debit","Creditors","credit","Expense"]
[null,"Received",null,"reverse","JCR","increase","credit","Creditors","debit","Expense"]
[null,"Penalty Interest ","INT","enter",null,"increase","credit","Creditors","debit","Interest Expense"]
[null,null,null,"reverse","JDR","decrease","debit","Creditors","credit","Interest Expense"]
[null,"WriteOff","WO","enter",null,"decrease","debit","Creditors","credit","Expense"]
[null,null,null,"reverse","JCR","increase","credit","Creditors","debit","Expense"]
[null,"Refund","RF","enter",null,"increase","credit","Creditors","debit","Bank"]
[null,"(Cash Jnl to reverse)",null,"reverse","PAY / JDR","decrease","debit","Creditors","credit","Bank"]
[null,"Credit Interest","CIN","enter",null,"decrease","debit","Creditors","credit","Interest Recd"]
[null,null,null,"reverse","JCR","increase","credit","Creditors","debit","Interest Recd"]
[null,"Journal Credit","JCR","enter",null,"increase","credit","Creditors","debit","Expense or Bank"]
[null,null,null,"reverse","JDR","decrease","debit","Creditors","credit","Expense or Bank"]
[null,"Journal Debit","JDR","enter",null,"decrease","debit","Creditors","credit","Expense or Bank"]
[null,null,null,"reverse","JCR","increase","cred","Creditors","debit","Expense or Bank"]
[null,"Opening Balance","OB","enter",null,"increase","credit","Creditors","debit","Expense"]
[null,null,null,"reverse","WO / JDR","decrease","debit","Creditors","credit","Expense"]
[null," "]
[null," "]

{"sheet":"Debtors Only","index":1,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Transaction Entries and"]
["their Reversing Journal Types"]
["Debtors Module (Client Accounts / Accounts Receivable)"]
[null,"Original Entry","Tran Type","Action","Reversing Journal Type","Effect on Balance Owed"]
[null,"Invoice","INV","enter",null,"increase"]
[null,null,null,"reverse","CN / WO / JCR","decrease"]
[null,"Credit Note","CN","enter",null,"decrease"]
[null,null,null,"reverse","JDR","increase"]
[null,"Payment","PAY","enter",null,"decrease"]
[null,"(Cash Jnl to reverse)",null,"reverse","RF / JDR","increase"]
[null,"Discount Given","DIS","enter",null,"decrease"]
[null,null,null,"reverse","JDR","increase"]
[null,"Interest ","INT","enter",null,"increase"]
[null,"(Calculated)",null,"reverse","JCR","decrease"]
[null,"WriteOff","WO","enter",null,"decrease"]
[null,null,null,"reverse","JDR","increase"]
[null,"Refund","RF","enter",null,"increase"]
[null,"(Cash Jnl to reverse)",null,"reverse","PAY / JCR","decrease"]
[null,"Credit Interest","CIN","enter",null,"decrease"]
[null,null,null,"reverse","JDR","increase"]
[null,"Journal Credit","JCR","enter",null,"decrease"]
[null,null,null,"reverse","JDR","increase"]
[null,"Journal Debit","JDR","enter",null,"increase"]
[null,null,null,"reverse","JCR","decrease"]
[null,"Opening Balance","OB","enter",null,"increase"]
[null,null,null,"reverse","WO / JCR","decrease"]
[null," "]
[null," "]