{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Guide","Data Entry","All Records","Income Statement","Cash Flow","Zakat"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":2,"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":"Guide","index":0,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Business Name:"]
[null,"Month:"]
[null,"Year:",null,null,null,"How to use Muhaf Accounting for Small Business Owner"]
[null,null,null,null,1,"Please fill in you Company name in 'Business Name' column"]
[null,"Year","Period",null,2,"Please choose your selected 'month' and 'year'"]
[null,2016,"January",null,3,"Go to 'Data Entry' tab. Key in your daily transaction. "]
[null,2017,"February",null,4,"Key in your date, description, amount and choose type of trnasaction from drop down menu (Sales, Purchase or Expenses)"]
[null,2018,"March",null,5,"Once key in, Click 'save'"]
[null,2019,"April",null,6,"You will see the transaction appear in 'All Records' tab"]
[null,2020,"May",null,7,"To key in new transaction, go to 'Data Entry' tab again and click 'Clear' to start fresh OR you may edit directly to the sheet"]
[null,2021,"June",null,8,"After month end, you may save you 'All Records' transaction into pdf. Clikc 'Save to PDF' OR "]
[null,2023,"July",null,9,"You may save you 'All Records' transaction into another excel if you want the data to be in excel. Clikc 'Export to another excel'"]
[null,2024,"August",null,10,"Before start new month transaction, click 'Clear Ledger Transactions'"]
[null,2025,"September",null,11,"You can go to 'Income Statement' tab to see monitor your current month sales. And you may save to pdf by clicking at 'Save to PDF'"]
[null,2026,"October",null,12,"You can also monitor your cash balance & cash flow at 'Cash Flow' tab. Before start new month, make sure your opening cash balance same as per your bank statement"]
[null,2027,"November",null,13,"You may aslo save the cash flow statement by clicking at 'Save to PDF'"]
[null,2028,"December",null,14,"You can also check on zakat shoud be paid by your business by go to 'Zakat' tab. Make sure the Opening Bank Balance is correct"]
[null,null,null,null,15,"You may also print zakat statement  by clicking at 'Save to pdf'"]
[null,null,null,null,16,"Zakat normally woul be charged yearly. When calculating your zakat payable, insert your December ending cash & Bank balance amount for last year zakat calculation"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"MUHAF ACCOUNTING FOR SMALL BUSINESS OWNER @ 2018"]
[]
[]
[]
[null,"*This accounting system version best used for cash basis accounting",null,null,null,"MUHAF ACCOUNTING FOR SMALL BUSINESS OWNER @ 2018"]

{"sheet":"Data Entry","index":1,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,1,18,1]]}
[]
[{"$f":"Guide!C2","v":0}]
[]
[]
[]
[]
[null,"Date","Description","Amount (RM)","Type",null,null,null,"Type","Explanation"]
["Right clik to use date picker",null,null,null,null,null,null,null,"Sales","If you sell your products and receive money in return"]
[null,null,null,null,null,null,null,null,"Purchase","If you buy something for preparing the products (Ex: If you are a baker, you buy icing)"]
[null,null,null,null,null,null,null,null,"Expenses","If you have to pay something for your business. Not directly related to your product (Ex: Poslaju fee)"]
[]
[]
[]
[]
[]
[]
[]
[null,"Date Picker","Excel 2016: need to install date picker first"]
[null,null,"Excec older version: Enable deveoper tab and enable 'Microsoft date picker\"",null,null,null,null,null,"MUHAF ACCOUNTING FOR SMALL BUSINESS OWNER @ 2018"]

{"sheet":"All Records","index":2,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"Date","Description","Amount (RM)","Type"]
[null,null,null,null,null,null,"Reference List"]
[null,null,null,null,null,null,"Sales"]
[null,null,null,null,null,null,"Purchase"]
[null,null,null,null,null,null,"Expenses"]

{"sheet":"Income Statement","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"Guide!C2","v":0}]
[null,null,{"$f":"Guide!C4","v":0}]
[null,"Income Statement ",{"$f":"Guide!C3","v":0}]
[null,null,"(RM)"]
[null,"Sales",{"$f":"SUMIF('All Records'!E:E,'All Records'!G3,'All Records'!D:D)","v":0}]
[null,"(-) Purchase",{"$f":"-SUMIF('All Records'!E:E,'All Records'!G4,'All Records'!D:D)","v":0}]
[null,"Gross Profit",{"$f":"SUM(C6:C7)","v":0}]
[]
[null,"(-) Expenses",{"$f":"-SUMIF('All Records'!E:E,'All Records'!G5,'All Records'!D:D)","v":0}]
[null,"Net Profit",{"$f":"SUM(C8:C10)","v":0}]

{"sheet":"Cash Flow","index":4,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"Guide!C2","v":0}]
[null,null,{"$f":"Guide!C4","v":0}]
[null,"Cash Flow Statement",{"$f":"Guide!C3","v":0}]
[null,null,"(RM)"]
[null,"Opening Balance",10000,"(insert your bank balance here)"]
[]
[null,"Cash Inflow"]
[null,"Cash Inflow from Sales",{"$f":"SUMIF('All Records'!E:E,'All Records'!G3,'All Records'!D:D)","v":0}]
[null,"CASH INFLOW",{"$f":"SUM(C9)","v":0}]
[]
[null,"Cash Outflow"]
[null,"Purchases",{"$f":"-SUMIF('All Records'!E:E,'All Records'!G4,'All Records'!D:D)","v":0}]
[null,"Expenses",{"$f":"-SUMIF('All Records'!E:E,'All Records'!G5,'All Records'!D:D)","v":0}]
[null,"CASH OUTFLOW",{"$f":"SUM(C13:C14)","v":0}]
[]
[null,"Cash Balance",{"$f":"C6+C9+C15","v":10000}]

{"sheet":"Zakat","index":5,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"Guide!C2","v":0},{"$f":"Guide!C4","v":0}]
[null,null,{"$f":"Guide!C3","v":0}]
[null,"Zakat Calculation"]
["(+)","CURRENT ASSET","RM",null,null,null,"How to use:"]
[null,"Cash Balance in Bank/Cash in Hand",{"$f":"'Cash Flow'!C17","v":10000},null,null,1,"Key in your stock (in RM) amount"]
[null,"Stock (in RM)",0,null,null,2,"Key in acoount payable amount if you have any amount owed to others while making business"]
[null,"Debtors/Account Receivable","Not applicable for this version",null,null,3,"Key in acoount payable amount if you have any expenses amount such as unpaid tnb bills, etc"]
[null,null,{"$f":"SUM(C6:C7)","v":10000},null,null,4,"Key in acoount payable amount if you have any current tax payable amount that still not paid"]
[]
["(-)","CURRENT LIABILITIES"]
[null,"Account Payable (Amount owed to others on business",0]
[null,"Expenses payable (expenses not yet paid)",0]
[null,"Current Tax Payable (Company Tax not yet paid)",0]
[null,null,{"$f":"SUM(C12:C14)","v":0}]
[]
[null,"Amount Chargebale to Zakat",{"$f":"C9-C15","v":10000}]
[]
[null,"Zakat Payable(2.5%)",{"$f":"0.025*C17","v":250}]