{"text_format":"1","workbook":"xlsx","n_sheets":34,"sheets":["INSTRUCTIONS","9 REPORTS GRADER","CH9 TB","CH9 ADJ","EX9.1.3 CKS","EX9.2.3 DEP","EX9.3.2 TB","EX9.3.4 ADJ","EX9.3.5 ADJTB","EX9.4.2 GL","EX9.4.3 PL","EX9.4.3 BS","EX9.4.3 SCF","EX9.6.2 COA","EX9.6.3 CUST","EX9.6.4 VEN","EX9.6.5 ITEM","EX9.6.7 CKS","EX9.6.7 DEP","EX9.6.8 JOUR","EX9.6.9 ADJTB","EX9.6.9 GL","EX9.6.9 PL","EX9.6.9 BS","EX9.6.9 SCF","PR9.3 DEP","PR9.4 CKS","PR9.5 TB","PR9.6 ADJ","PR9.7 ADJTB","PR9.8 GL","PR9.9 PL","PR9.10 BS","PR9.11 SCF"],"not_rendered":{"charts":0,"images":44,"macros":1,"external_links":0,"defined_names":2180,"comments":0,"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":"INSTRUCTIONS","index":0,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[[31,0,31,2]]}
[null,null,"Computer Accounting with QuickBooks 2015 by Donna Kay"]
[null,null,"Go Digital Reports"]
[null,null,"Save your QuickBooks reports using the following steps. "]
[]
[null,"Step 1","Go to www.My-QuickBooks.com."]
[null,"Step 2","Select QB 2015."]
[null,"Step 3","Download the Go Digital Excel REPORTS template for the assignment you are completing (Chapter or Case)."]
[null,"Step 4","Open the Excel workbook. Select File > Save As."]
[null,"Step 5","Rename the Excel file: IMPORTANT! To receive credit for your work, use the filename: [YourLastName FirstName] [CH/CASE][No] REPORTS. Example: YourLastName FirstName CH1 REPORTS"]
[null,"Step 6","Close your Excel workbook."]
[null,"Step 7","When your Computer Accounting with QuickBooks text asks you to print or export a report, use the Report Center to display the report on your screen. "]
[null,"Step 8","With the report displayed onscreen, select Excel. "]
[]
[]
[null,"Step 9","Select Create New Worksheet. "]
[null,"Step 10","Select Replace an existing worksheet. "]
[]
[null,"Step 11","Browse for the Excel REPORTS template with your name in the filename."]
[null,"Step 12","Select the correct sheetname from the drop-down list."]
[null,"Step 13","Select Advanced. "]
[null,"Step 14","Uncheck Space between columns."]
[null,"Step 15","Uncheck  Include QuickBooks Export Guide worksheet with helpful advice. "]
[null,"Step 16","Select Show report header:  On printed report and screen."]
[null,"Step 17","Click OK."]
[null,"Step 18","Click Export."]
[null,"Step 19","If the Export Report Alert window appears, select Do not display this message in the future. "]
[]
[null,"Step 20","Select Yes to continue. Excel software should open on your screen with your QuickBooks report inserted into the correct sheet. "]
[null,"Step 21","On the REPORTS sheet, check the reports that you have completed with an \"x\". Failure to check the completed reports may result in a score of -0-."]
[null,"Step 22","Save your Excel workbook using the appropriate file name. Select File > Save As. IMPORTANT! To receive credit for your work, use the filename: [YourLastName FirstName] [CH/CASE][No] REPORTS. Example: YourLastName FirstName CH1 REPORTS (Note: With some Excel versions, you must close the workbook before inserting the next report.)"]
[null,"Step 23","Ask your instructor if you should email the Excel spreadsheet or upload to your courseware . "]

{"sheet":"9 REPORTS GRADER","index":1,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Computer Accounting with QuickBooks 2015 by Donna Kay"]
[null,null,null,"Chapter 9 Reports"]
[null,null,null,"Chapter 9  ","Sheetname"]
[null,"x","*","Trial Balance","CH9 TB"]
[null,"x","*","Adjusting Entry","CH9 ADJ"]
[null,null,null,"Exercise 9.1"]
[null,"x","*","Task 3: Check Detail","EX9.1.3 CKS"]
[null,null,null,"Exercise 9.2"]
[null,"x","*","Task 3: Deposit Detail","EX9.2.3 DEP"]
[null,null,null,"Exercise 9.3"]
[null,"x","*","Task 2: Trial Balance ","EX9.3.2 TB"]
[null,"x","*","Task 4: Adjusting Entries ","EX9.3.4 ADJ"]
[null,"x","*","Task 5: Adjusted Trial Balance ","EX9.3.5 ADJTB"]
[null,null,null,"Exercise 9.4"]
[null,"x","*","Task 2: General Ledger","EX9.4.2 GL"]
[null,"x","*","Task 3: Profit & Loss ","EX9.4.3 PL"]
[null,"x","*","Task 3: Balance Sheet ","EX9.4.3 BS"]
[null,"x","*","Task 3: Statement of Cash Flows","EX9.4.3 SCF"]
[null,null,null,"Exercise 9.6"]
[null,"x","*","Task 2: Chart of Accounts","EX9.6.2 COA"]
[null,"x","*","Task 3: Customer List","EX9.6.3 CUST"]
[null,"x","*","Task 4: Vendor List","EX9.6.4 VEN"]
[null,"x","*","Task 5: Item List","EX9.6.5 ITEM"]
[null,"x","*","Task 7: Check Detail","EX9.6.7 CKS"]
[null,"x","*","Task 7: Deposit Detail","EX9.6.7 DEP"]
[null,"x","*","Task 8: Journal","EX9.6.8 JOUR"]
[null,"x","*","Task 9: Adjusted Trial Balance","EX9.6.9 ADJTB"]
[null,"x","*","Task 9: General Ledger","EX9.6.9 GL"]
[null,"x","*","Task 9: Profit & Loss","EX9.6.9 PL"]
[null,"x","*","Task 9: Balance Sheet","EX9.6.9 BS"]
[null,"x","*","Task 9: Statement of Cash Flows ","EX9.6.9 SCF"]
[]
[]
[]
[null,null,null,"Project 9 Reports"]
[null,null,null,"Project 9 ","Sheetname"]
[null,"x","*","Deposit Detail","PR9.3 DEP"]
[null,"x","*","Check Detail","PR9.4 CKS"]
[null,"x","*","Trial Balance ","PR9.5 TB"]
[null,"x","*","Adjusting Entries","PR9.6 ADJ"]
[null,"x","*","Adjusted Trial Balance","PR9.7 ADJTB"]
[null,"x","*","General Ledger ","PR9.8 GL"]
[null,"x","*","Profit & Loss","PR9.9 PL"]
[null,"x","*","Balance Sheet","PR9.10 BS"]
[null,"x","*","Statement of Cash Flows ","PR9.11 SCF"]

{"sheet":"CH9 TB","index":2,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["YourName Chapter 9 Paint Palette"]
["Trial Balance"]
["As of December 31, 2020",null,null,"Accrual Basis"]
[null,null,"Dec 31, 20"]
[null,null,"Debit","Credit"]
[null,"Checking",7200]
[null,"11000 · Accounts Receivable",0]
[null,"12000 · Undeposited Funds",0]
[null,"14100 · Computer:14200 · Computer Cost",1500]
[null,"14400 · Equipment:14500 · Equipment Cost",500]
[null,"21000 · Accounts Payable",0]
[null,"30000 · Opening Balance Equity",null,6000]
[null,"47900 · Sales",null,3400]
[null,"64800 · Paint Supplies Expense",0]
[null,"67100 · Rent Expense",200]
["TOTAL",null,{"$f":"ROUND(SUM(C6:C15),5)","v":9400},{"$f":"ROUND(SUM(D6:D15),5)","v":9400}]

{"sheet":"CH9 ADJ","index":3,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["YourName Chapter 9 Paint Palette"]
["Journal Entries Entered/Modified Today"]
["December 31, 2020",null,null,null,null,null,null,null,null,null,null,""]
[null,"Trans #","Type","Entered/Last Modified","Date","Num","Adj","Name","Memo","Account","Debit","Credit"]
[null,11,"General Journal","2014-10-19T18:39:16","2020-12-31","ADJ1","Ö",null,null,"65300 · Depr Expense Computer",500]
[null,null,null,null,null,null,"Ö",null,null,"14300 · Accumulated Depr Computer",null,500]
[" ",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(K5:K6),5)","v":500},{"$f":"ROUND(SUM(L5:L6),5)","v":500}]
["TOTAL",null,null,null,null,null,null,null,null,null,{"$f":"K7","v":500},{"$f":"L7","v":500}]

{"sheet":"EX9.1.3 CKS","index":4,"n_rows":90,"n_cols":9,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.1 Paint Palette"]
["Check Detail"]
["January through December 2020",null,null,null,null,null,null,null,""]
[null,"Type","Num","Date","Name","Item","Account","Paid Amount","Original Amount"]
[" "]
[null,"Check","501","2020-01-01","Cornell Technologies",null,"Checking",null,-1500]
[" "]
[null,null,null,null,null,null,"14200 · Computer Cost",-1500,1500]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H7:H8),5)","v":-1500},{"$f":"ROUND(SUM(I7:I8),5)","v":1500}]
[" "]
[null,"Bill Pmt -Check","502","2020-02-04","Brewer Paint Supplies",null,"Checking",null,-800]
[" "]
[null,"Bill",null,"2020-01-03","Beneficio, Katrina:Dining Room",null,"64800 · Paint Supplies Expense",-300,300]
[null,"Bill",null,"2020-01-04",null,null,"14500 · Equipment Cost",-500,500]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H12:H14),5)","v":-800},{"$f":"ROUND(SUM(I12:I14),5)","v":800}]
[" "]
[null,"Bill Pmt -Check","503","2020-02-04","Hartzheim Leasing",null,"Checking",null,-200]
[" "]
[null,"Bill",null,"2020-01-04",null,null,"67100 · Rent Expense",-200,200]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H18:H19),5)","v":-200},{"$f":"ROUND(SUM(I18:I19),5)","v":200}]
[" "]
[null,"Bill Pmt -Check","504","2020-02-28","Hartzheim Leasing",null,"Checking",null,-200]
[" "]
[null,"Bill",null,"2020-02-01",null,null,"67100 · Rent Expense",-200,200]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H23:H24),5)","v":-200},{"$f":"ROUND(SUM(I23:I24),5)","v":200}]
[" "]
[null,"Bill Pmt -Check","505","2020-03-30","Hartzheim Leasing",null,"Checking",null,-200]
[" "]
[null,"Bill",null,"2020-03-01",null,null,"67100 · Rent Expense",-200,200]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H28:H29),5)","v":-200},{"$f":"ROUND(SUM(I28:I29),5)","v":200}]
[" "]
[null,"Bill Pmt -Check","506","2020-04-30","Brewer Paint Supplies",null,"Checking",null,-50]
[" "]
[null,"Bill",null,"2020-04-04",null,null,"64800 · Paint Supplies Expense",-50,50]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H33:H34),5)","v":-50},{"$f":"ROUND(SUM(I33:I34),5)","v":50}]
[" "]
[null,"Bill Pmt -Check","507","2020-04-30","Hartzheim Leasing",null,"Checking",null,-200]
[" "]
[null,"Bill",null,"2020-04-01",null,null,"67100 · Rent Expense",-200,200]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H38:H39),5)","v":-200},{"$f":"ROUND(SUM(I38:I39),5)","v":200}]
[" "]
[null,"Bill Pmt -Check","508","2020-05-30","Hartzheim Leasing",null,"Checking",null,-200]
[" "]
[null,"Bill",null,"2020-05-01",null,null,"67100 · Rent Expense",-200,200]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H43:H44),5)","v":-200},{"$f":"ROUND(SUM(I43:I44),5)","v":200}]
[" "]
[null,"Bill Pmt -Check","509","2020-06-30","Hartzheim Leasing",null,"Checking",null,-200]
[" "]
[null,"Bill",null,"2020-06-01",null,null,"67100 · Rent Expense",-200,200]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H48:H49),5)","v":-200},{"$f":"ROUND(SUM(I48:I49),5)","v":200}]
[" "]
[null,"Bill Pmt -Check","510","2020-07-30","Brewer Paint Supplies",null,"Checking",null,-100]
[" "]
[null,"Bill",null,"2020-07-01",null,null,"64800 · Paint Supplies Expense",-100,100]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H53:H54),5)","v":-100},{"$f":"ROUND(SUM(I53:I54),5)","v":100}]
[" "]
[null,"Bill Pmt -Check","511","2020-07-30","Hartzheim Leasing",null,"Checking",null,-200]
[" "]
[null,"Bill",null,"2020-07-01",null,null,"67100 · Rent Expense",-200,200]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H58:H59),5)","v":-200},{"$f":"ROUND(SUM(I58:I59),5)","v":200}]
[" "]
[null,"Bill Pmt -Check","512","2020-08-30","Hartzheim Leasing",null,"Checking",null,-200]
[" "]
[null,"Bill",null,"2020-08-01",null,null,"67100 · Rent Expense",-200,200]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H63:H64),5)","v":-200},{"$f":"ROUND(SUM(I63:I64),5)","v":200}]
[" "]
[null,"Bill Pmt -Check","513","2020-09-30","Brewer Paint Supplies",null,"Checking",null,-75]
[" "]
[null,"Bill",null,"2020-09-02",null,null,"64800 · Paint Supplies Expense",-75,75]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H68:H69),5)","v":-75},{"$f":"ROUND(SUM(I68:I69),5)","v":75}]
[" "]
[null,"Bill Pmt -Check","514","2020-09-30","Hartzheim Leasing",null,"Checking",null,-200]
[" "]
[null,"Bill",null,"2020-09-01",null,null,"67100 · Rent Expense",-200,200]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H73:H74),5)","v":-200},{"$f":"ROUND(SUM(I73:I74),5)","v":200}]
[" "]
[null,"Bill Pmt -Check","515","2020-10-30","Hartzheim Leasing",null,"Checking",null,-200]
[" "]
[null,"Bill",null,"2020-10-01",null,null,"67100 · Rent Expense",-200,200]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H78:H79),5)","v":-200},{"$f":"ROUND(SUM(I78:I79),5)","v":200}]
[" "]
[null,"Bill Pmt -Check","516","2020-11-30","Hartzheim Leasing",null,"Checking",null,-200]
[" "]
[null,"Bill",null,"2020-11-01",null,null,"67100 · Rent Expense",-200,200]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H83:H84),5)","v":-200},{"$f":"ROUND(SUM(I83:I84),5)","v":200}]
[" "]
[null,"Bill Pmt -Check","517","2020-12-30","Hartzheim Leasing",null,"Checking",null,-200]
[" "]
[null,"Bill",null,"2020-12-01",null,null,"67100 · Rent Expense",-200,200]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H88:H89),5)","v":-200},{"$f":"ROUND(SUM(I88:I89),5)","v":200}]

{"sheet":"EX9.2.3 DEP","index":5,"n_rows":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.2 Paint Palette"]
["Deposit Detail"]
["January through December 2020",null,null,null,null,null,""]
[null,"Type","Num","Date","Name","Account","Amount"]
[" "]
[null,"Deposit",null,"2020-01-01",null,"Checking",6000]
[" "]
[null,null,null,null,"YourName","30000 · Opening Balance Equity",-6000]
["TOTAL",null,null,null,null,null,{"$f":"ROUND(SUM(G7:G8),5)","v":-6000}]
[" "]
[null,"Deposit",null,"2020-02-04",null,"Checking",3700]
[" "]
[null,"Payment","555","2020-02-04","Beneficio, Katrina:Dining Room","12000 · Undeposited Funds",-3700]
["TOTAL",null,null,null,null,null,{"$f":"ROUND(SUM(G12:G13),5)","v":-3700}]
[" "]
[null,"Deposit",null,"2020-03-15",null,"Checking",3440]
[" "]
[null,"Payment","675","2020-03-15","Beneficio, Katrina:Dining Room","12000 · Undeposited Funds",-3440]
["TOTAL",null,null,null,null,null,{"$f":"ROUND(SUM(G17:G18),5)","v":-3440}]
[" "]
[null,"Deposit",null,"2020-04-15",null,"Checking",3360]
[" "]
[null,"Payment","690","2020-04-15","Beneficio, Katrina:Dining Room","12000 · Undeposited Funds",-3360]
["TOTAL",null,null,null,null,null,{"$f":"ROUND(SUM(G22:G23),5)","v":-3360}]
[" "]
[null,"Deposit",null,"2020-05-15",null,"Checking",3200]
[" "]
[null,"Payment","432","2020-05-15","Whalen, Tom:Foyer","12000 · Undeposited Funds",-3200]
["TOTAL",null,null,null,null,null,{"$f":"ROUND(SUM(G27:G28),5)","v":-3200}]
[" "]
[null,"Deposit",null,"2020-06-15",null,"Checking",3000]
[" "]
[null,"Payment","455","2020-06-15","Whalen, Tom:Foyer","12000 · Undeposited Funds",-3000]
["TOTAL",null,null,null,null,null,{"$f":"ROUND(SUM(G32:G33),5)","v":-3000}]
[" "]
[null,"Deposit",null,"2020-07-15",null,"Checking",4000]
[" "]
[null,"Payment","733","2020-07-15","Beneficio, Katrina:Vaulted Kitchen","12000 · Undeposited Funds",-4000]
["TOTAL",null,null,null,null,null,{"$f":"ROUND(SUM(G37:G38),5)","v":-4000}]
[" "]
[null,"Deposit",null,"2020-08-15",null,"Checking",3600]
[" "]
[null,"Payment","750","2020-08-15","Beneficio, Katrina:Vaulted Kitchen","12000 · Undeposited Funds",-3600]
["TOTAL",null,null,null,null,null,{"$f":"ROUND(SUM(G42:G43),5)","v":-3600}]
[" "]
[null,"Deposit",null,"2020-09-15",null,"Checking",3680]
[" "]
[null,"Payment","782","2020-09-15","Beneficio, Katrina:Vaulted Kitchen","12000 · Undeposited Funds",-3680]
["TOTAL",null,null,null,null,null,{"$f":"ROUND(SUM(G47:G48),5)","v":-3680}]
[" "]
[null,"Deposit",null,"2020-11-15",null,"Checking",3400]
[" "]
[null,"Payment","685","2020-11-15","Whalen, Tom:Screen Porch","12000 · Undeposited Funds",-3400]
["TOTAL",null,null,null,null,null,{"$f":"ROUND(SUM(G52:G53),5)","v":-3400}]
[" "]
[null,"Deposit",null,"2020-12-15",null,"Checking",3480]
[" "]
[null,"Payment","725","2020-12-15","Whalen, Tom:Screen Porch","12000 · Undeposited Funds",-3480]
["TOTAL",null,null,null,null,null,{"$f":"ROUND(SUM(G57:G58),5)","v":-3480}]

{"sheet":"EX9.3.2 TB","index":6,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.3 Paint Palette"]
["Trial Balance"]
["As of December 31, 2020",null,null,"Accrual Basis"]
[null,null,"Dec 31, 20"]
[null,null,"Debit","Credit"]
[null,"Checking",35935]
[null,"11000 · Accounts Receivable",0]
[null,"12000 · Undeposited Funds",0]
[null,"14100 · Computer:14200 · Computer Cost",1500]
[null,"14100 · Computer:14300 · Accumulated Depr Computer",null,500]
[null,"14400 · Equipment:14500 · Equipment Cost",500]
[null,"21000 · Accounts Payable",null,50]
[null,"30000 · Opening Balance Equity",null,6000]
[null,"47900 · Sales",null,34560]
[null,"64800 · Paint Supplies Expense",275]
[null,"65300 · Depr Expense Computer",500]
[null,"67100 · Rent Expense",2400]
["TOTAL",null,{"$f":"ROUND(SUM(C6:C17),5)","v":41110},{"$f":"ROUND(SUM(D6:D17),5)","v":41110}]

{"sheet":"EX9.3.4 ADJ","index":7,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.3 Paint Palette"]
["Adjusting Journal Entries"]
["December 31, 2020",null,null,null,null,null,null,"Accrual Basis"]
[null,"Date","Num","Name","Memo","Account","Debit","Credit"]
[null,"2020-12-31","ADJ1",null,null,"65300 · Depr Expense Computer",500]
[null,null,null,null,null,"14300 · Accumulated Depr Computer",null,500]
[" ",null,null,null,null,null,{"$f":"ROUND(SUM(G5:G6),5)","v":500},{"$f":"ROUND(SUM(H5:H6),5)","v":500}]
[null,"2020-12-31","ADJ2",null,null,"65600 · Depr Expense Equipment",100]
[null,null,null,null,null,"14600 · Acc Depr Equipment",null,100]
[" ",null,null,null,null,null,{"$f":"ROUND(SUM(G8:G9),5)","v":100},{"$f":"ROUND(SUM(H8:H9),5)","v":100}]
["TOTAL",null,null,null,null,null,{"$f":"ROUND(G7+G10,5)","v":600},{"$f":"ROUND(H7+H10,5)","v":600}]

{"sheet":"EX9.3.5 ADJTB","index":8,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.3 Paint Palette"]
["Adjusted Trial Balance"]
["December 31, 2020",null,null,null,null,null,null,"Accrual Basis"]
[null,null,"Unadjusted Balance",null,"Adjustments",null,"Adjusted Balance"]
[null,null,"Debit","Credit","Debit","Credit","Debit","Credit"]
[null,"Checking",35935,null,null,null,35935]
[null,"11000 · Accounts Receivable",0,null,null,null,0]
[null,"12000 · Undeposited Funds",0,null,null,null,0]
[null,"14100 · Computer:14200 · Computer Cost",1500,null,null,null,1500]
[null,"14100 · Computer:14300 · Accumulated Depr Computer",null,null,null,500,null,500]
[null,"14400 · Equipment:14500 · Equipment Cost",500,null,null,null,500]
[null,"14400 · Equipment:14600 · Acc Depr Equipment",null,null,null,100,null,100]
[null,"21000 · Accounts Payable",null,50,null,null,null,50]
[null,"30000 · Opening Balance Equity",null,6000,null,null,null,6000]
[null,"47900 · Sales",null,34560,null,null,null,34560]
[null,"64800 · Paint Supplies Expense",275,null,null,null,275]
[null,"65300 · Depr Expense Computer",null,null,500,null,500]
[null,"65600 · Depr Expense Equipment",null,null,100,null,100]
[null,"67100 · Rent Expense",2400,null,null,null,2400]
["TOTAL",null,{"$f":"ROUND(SUM(C6:C19),5)","v":40610},40610,600,600,41210,41210]

{"sheet":"EX9.4.2 GL","index":9,"n_rows":174,"n_cols":14,"rows_kept":174,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.4 Paint Palette"]
["General Ledger"]
["As of December 31, 2020",null,null,null,null,null,null,null,null,null,null,null,null,"Accrual Basis"]
[null,null,null,null,"Type","Date","Num","Adj","Name","Memo","Split","Debit","Credit","Balance"]
[null,"Checking",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Deposit","2020-01-01",null,null,null,"Deposit","30000 · Opening Balance Equity",6000,null,6000]
[null,null,null,null,"Check","2020-01-01","501",null,"Cornell Technologies","2002","14200 · Computer Cost",null,1500,4500]
[null,null,null,null,"Bill Pmt -Check","2020-02-04","502",null,"Brewer Paint Supplies",null,"21000 · Accounts Payable",null,800,3700]
[null,null,null,null,"Bill Pmt -Check","2020-02-04","503",null,"Hartzheim Leasing","2003","21000 · Accounts Payable",null,200,3500]
[null,null,null,null,"Deposit","2020-02-04",null,null,null,"Deposit","12000 · Undeposited Funds",3700,null,7200]
[null,null,null,null,"Bill Pmt -Check","2020-02-28","504",null,"Hartzheim Leasing","2003","21000 · Accounts Payable",null,200,7000]
[null,null,null,null,"Deposit","2020-03-15",null,null,null,"Deposit","12000 · Undeposited Funds",3440,null,10440]
[null,null,null,null,"Bill Pmt -Check","2020-03-30","505",null,"Hartzheim Leasing","2003","21000 · Accounts Payable",null,200,10240]
[null,null,null,null,"Deposit","2020-04-15",null,null,null,"Deposit","12000 · Undeposited Funds",3360,null,13600]
[null,null,null,null,"Bill Pmt -Check","2020-04-30","506",null,"Brewer Paint Supplies",null,"21000 · Accounts Payable",null,50,13550]
[null,null,null,null,"Bill Pmt -Check","2020-04-30","507",null,"Hartzheim Leasing","2003","21000 · Accounts Payable",null,200,13350]
[null,null,null,null,"Deposit","2020-05-15",null,null,null,"Deposit","12000 · Undeposited Funds",3200,null,16550]
[null,null,null,null,"Bill Pmt -Check","2020-05-30","508",null,"Hartzheim Leasing","2003","21000 · Accounts Payable",null,200,16350]
[null,null,null,null,"Deposit","2020-06-15",null,null,null,"Deposit","12000 · Undeposited Funds",3000,null,19350]
[null,null,null,null,"Bill Pmt -Check","2020-06-30","509",null,"Hartzheim Leasing","2003","21000 · Accounts Payable",null,200,19150]
[null,null,null,null,"Deposit","2020-07-15",null,null,null,"Deposit","12000 · Undeposited Funds",4000,null,23150]
[null,null,null,null,"Bill Pmt -Check","2020-07-30","510",null,"Brewer Paint Supplies",null,"21000 · Accounts Payable",null,100,23050]
[null,null,null,null,"Bill Pmt -Check","2020-07-30","511",null,"Hartzheim Leasing","2003","21000 · Accounts Payable",null,200,22850]
[null,null,null,null,"Deposit","2020-08-15",null,null,null,"Deposit","12000 · Undeposited Funds",3600,null,26450]
[null,null,null,null,"Bill Pmt -Check","2020-08-30","512",null,"Hartzheim Leasing","2003","21000 · Accounts Payable",null,200,26250]
[null,null,null,null,"Deposit","2020-09-15",null,null,null,"Deposit","12000 · Undeposited Funds",3680,null,29930]
[null,null,null,null,"Bill Pmt -Check","2020-09-30","513",null,"Brewer Paint Supplies",null,"21000 · Accounts Payable",null,75,29855]
[null,null,null,null,"Bill Pmt -Check","2020-09-30","514",null,"Hartzheim Leasing","2003","21000 · Accounts Payable",null,200,29655]
[null,null,null,null,"Bill Pmt -Check","2020-10-30","515",null,"Hartzheim Leasing","2003","21000 · Accounts Payable",null,200,29455]
[null,null,null,null,"Deposit","2020-11-15",null,null,null,"Deposit","12000 · Undeposited Funds",3400,null,32855]
[null,null,null,null,"Bill Pmt -Check","2020-11-30","516",null,"Hartzheim Leasing","2003","21000 · Accounts Payable",null,200,32655]
[null,null,null,null,"Deposit","2020-12-15",null,null,null,"Deposit","12000 · Undeposited Funds",3480,null,36135]
[null,null,null,null,"Bill Pmt -Check","2020-12-30","517",null,"Hartzheim Leasing","2003","21000 · Accounts Payable",null,200,35935]
[null,"Total Checking",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L5:L33),5)","v":40860},{"$f":"ROUND(SUM(M5:M33),5)","v":4925},{"$f":"N33","v":35935}]
[null,"11000 · Accounts Receivable",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Invoice","2020-01-31","1",null,"Beneficio, Katrina:Dining Room",null,"-SPLIT-",3700,null,3700]
[null,null,null,null,"Payment","2020-02-04","555",null,"Beneficio, Katrina:Dining Room",null,"12000 · Undeposited Funds",null,3700,0]
[null,null,null,null,"Invoice","2020-02-28","2",null,"Beneficio, Katrina:Dining Room",null,"47900 · Sales",3440,null,3440]
[null,null,null,null,"Payment","2020-03-15","675",null,"Beneficio, Katrina:Dining Room",null,"12000 · Undeposited Funds",null,3440,0]
[null,null,null,null,"Invoice","2020-03-31","3",null,"Beneficio, Katrina:Dining Room",null,"47900 · Sales",3360,null,3360]
[null,null,null,null,"Payment","2020-04-15","690",null,"Beneficio, Katrina:Dining Room",null,"12000 · Undeposited Funds",null,3360,0]
[null,null,null,null,"Invoice","2020-04-30","4",null,"Whalen, Tom:Foyer",null,"47900 · Sales",3200,null,3200]
[null,null,null,null,"Payment","2020-05-15","432",null,"Whalen, Tom:Foyer",null,"12000 · Undeposited Funds",null,3200,0]
[null,null,null,null,"Invoice","2020-05-31","5",null,"Whalen, Tom:Foyer",null,"47900 · Sales",3000,null,3000]
[null,null,null,null,"Payment","2020-06-15","455",null,"Whalen, Tom:Foyer",null,"12000 · Undeposited Funds",null,3000,0]
[null,null,null,null,"Invoice","2020-06-30","6",null,"Beneficio, Katrina:Vaulted Kitchen",null,"47900 · Sales",4000,null,4000]
[null,null,null,null,"Payment","2020-07-15","733",null,"Beneficio, Katrina:Vaulted Kitchen",null,"12000 · Undeposited Funds",null,4000,0]
[null,null,null,null,"Invoice","2020-07-31","7",null,"Beneficio, Katrina:Vaulted Kitchen",null,"47900 · Sales",3600,null,3600]
[null,null,null,null,"Payment","2020-08-15","750",null,"Beneficio, Katrina:Vaulted Kitchen",null,"12000 · Undeposited Funds",null,3600,0]
[null,null,null,null,"Invoice","2020-08-31","8",null,"Beneficio, Katrina:Vaulted Kitchen",null,"47900 · Sales",3680,null,3680]
[null,null,null,null,"Payment","2020-09-15","782",null,"Beneficio, Katrina:Vaulted Kitchen",null,"12000 · Undeposited Funds",null,3680,0]
[null,null,null,null,"Invoice","2020-10-31","9",null,"Whalen, Tom:Screen Porch",null,"47900 · Sales",3400,null,3400]
[null,null,null,null,"Payment","2020-11-15","685",null,"Whalen, Tom:Screen Porch",null,"12000 · Undeposited Funds",null,3400,0]
[null,null,null,null,"Invoice","2020-11-30","10",null,"Whalen, Tom:Screen Porch",null,"47900 · Sales",3480,null,3480]
[null,null,null,null,"Payment","2020-12-15","725",null,"Whalen, Tom:Screen Porch",null,"12000 · Undeposited Funds",null,3480,0]
[null,"Total 11000 · Accounts Receivable",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L35:L55),5)","v":34860},{"$f":"ROUND(SUM(M35:M55),5)","v":34860},{"$f":"N55","v":0}]
[null,"12000 · Undeposited Funds",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Payment","2020-02-04","555",null,"Beneficio, Katrina:Dining Room",null,"11000 · Accounts Receivable",3700,null,3700]
[null,null,null,null,"Deposit","2020-02-04","555",null,"Beneficio, Katrina:Dining Room","Deposit","Checking",null,3700,0]
[null,null,null,null,"Payment","2020-03-15","675",null,"Beneficio, Katrina:Dining Room",null,"11000 · Accounts Receivable",3440,null,3440]
[null,null,null,null,"Deposit","2020-03-15","675",null,"Beneficio, Katrina:Dining Room","Deposit","Checking",null,3440,0]
[null,null,null,null,"Payment","2020-04-15","690",null,"Beneficio, Katrina:Dining Room",null,"11000 · Accounts Receivable",3360,null,3360]
[null,null,null,null,"Deposit","2020-04-15","690",null,"Beneficio, Katrina:Dining Room","Deposit","Checking",null,3360,0]
[null,null,null,null,"Payment","2020-05-15","432",null,"Whalen, Tom:Foyer",null,"11000 · Accounts Receivable",3200,null,3200]
[null,null,null,null,"Deposit","2020-05-15","432",null,"Whalen, Tom:Foyer","Deposit","Checking",null,3200,0]
[null,null,null,null,"Payment","2020-06-15","455",null,"Whalen, Tom:Foyer",null,"11000 · Accounts Receivable",3000,null,3000]
[null,null,null,null,"Deposit","2020-06-15","455",null,"Whalen, Tom:Foyer","Deposit","Checking",null,3000,0]
[null,null,null,null,"Payment","2020-07-15","733",null,"Beneficio, Katrina:Vaulted Kitchen",null,"11000 · Accounts Receivable",4000,null,4000]
[null,null,null,null,"Deposit","2020-07-15","733",null,"Beneficio, Katrina:Vaulted Kitchen","Deposit","Checking",null,4000,0]
[null,null,null,null,"Payment","2020-08-15","750",null,"Beneficio, Katrina:Vaulted Kitchen",null,"11000 · Accounts Receivable",3600,null,3600]
[null,null,null,null,"Deposit","2020-08-15","750",null,"Beneficio, Katrina:Vaulted Kitchen","Deposit","Checking",null,3600,0]
[null,null,null,null,"Payment","2020-09-15","782",null,"Beneficio, Katrina:Vaulted Kitchen",null,"11000 · Accounts Receivable",3680,null,3680]
[null,null,null,null,"Deposit","2020-09-15","782",null,"Beneficio, Katrina:Vaulted Kitchen","Deposit","Checking",null,3680,0]
[null,null,null,null,"Payment","2020-11-15","685",null,"Whalen, Tom:Screen Porch",null,"11000 · Accounts Receivable",3400,null,3400]
[null,null,null,null,"Deposit","2020-11-15","685",null,"Whalen, Tom:Screen Porch","Deposit","Checking",null,3400,0]
[null,null,null,null,"Payment","2020-12-15","725",null,"Whalen, Tom:Screen Porch",null,"11000 · Accounts Receivable",3480,null,3480]
[null,null,null,null,"Deposit","2020-12-15","725",null,"Whalen, Tom:Screen Porch","Deposit","Checking",null,3480,0]
[null,"Total 12000 · Undeposited Funds",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L57:L77),5)","v":34860},{"$f":"ROUND(SUM(M57:M77),5)","v":34860},{"$f":"N77","v":0}]
[null,"14100 · Computer",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"14200 · Computer Cost",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Check","2020-01-01","501",null,"Cornell Technologies","2002","Checking",1500,null,1500]
[null,null,"Total 14200 · Computer Cost",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L80:L81),5)","v":1500},{"$f":"ROUND(SUM(M80:M81),5)","v":0},{"$f":"N81","v":1500}]
[null,null,"14300 · Accumulated Depr Computer",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"General Journal","2020-12-31","ADJ1","Ö",null,null,"65300 · Depr Expense Computer",null,500,-500]
[null,null,"Total 14300 · Accumulated Depr Computer",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L83:L84),5)","v":0},{"$f":"ROUND(SUM(M83:M84),5)","v":500},{"$f":"N84","v":-500}]
[null,"Total 14100 · Computer",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L82+L85,5)","v":1500},{"$f":"ROUND(M82+M85,5)","v":500},{"$f":"ROUND(N82+N85,5)","v":1000}]
[null,"14400 · Equipment",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"14500 · Equipment Cost",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Bill","2020-01-04",null,null,"Brewer Paint Supplies",null,"21000 · Accounts Payable",500,null,500]
[null,null,"Total 14500 · Equipment Cost",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L88:L89),5)","v":500},{"$f":"ROUND(SUM(M88:M89),5)","v":0},{"$f":"N89","v":500}]
[null,null,"14600 · Acc Depr Equipment",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"General Journal","2020-12-31","ADJ2","Ö",null,null,"65600 · Depr Expense Equipment",null,100,-100]
[null,null,"Total 14600 · Acc Depr Equipment",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L91:L92),5)","v":0},{"$f":"ROUND(SUM(M91:M92),5)","v":100},{"$f":"N92","v":-100}]
[null,"Total 14400 · Equipment",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L90+L93,5)","v":500},{"$f":"ROUND(M90+M93,5)","v":100},{"$f":"ROUND(N90+N93,5)","v":400}]
[null,"21000 · Accounts Payable",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Bill","2020-01-03",null,null,"Brewer Paint Supplies",null,"64800 · Paint Supplies Expense",null,300,-300]
[null,null,null,null,"Bill","2020-01-04",null,null,"Brewer Paint Supplies",null,"14500 · Equipment Cost",null,500,-800]
[null,null,null,null,"Bill","2020-01-04",null,null,"Hartzheim Leasing","Van lease","67100 · Rent Expense",null,200,-1000]
[null,null,null,null,"Bill","2020-02-01",null,null,"Hartzheim Leasing","Van lease","67100 · Rent Expense",null,200,-1200]
[null,null,null,null,"Bill Pmt -Check","2020-02-04","502",null,"Brewer Paint Supplies",null,"Checking",800,null,-400]
[null,null,null,null,"Bill Pmt -Check","2020-02-04","503",null,"Hartzheim Leasing","2003","Checking",200,null,-200]
[null,null,null,null,"Bill Pmt -Check","2020-02-28","504",null,"Hartzheim Leasing","2003","Checking",200,null,0]
[null,null,null,null,"Bill","2020-03-01",null,null,"Hartzheim Leasing","Van lease","67100 · Rent Expense",null,200,-200]
[null,null,null,null,"Bill Pmt -Check","2020-03-30","505",null,"Hartzheim Leasing","2003","Checking",200,null,0]
[null,null,null,null,"Bill","2020-04-01",null,null,"Hartzheim Leasing","Van lease","67100 · Rent Expense",null,200,-200]
[null,null,null,null,"Bill","2020-04-04",null,null,"Brewer Paint Supplies",null,"64800 · Paint Supplies Expense",null,50,-250]
[null,null,null,null,"Bill Pmt -Check","2020-04-30","506",null,"Brewer Paint Supplies",null,"Checking",50,null,-200]
[null,null,null,null,"Bill Pmt -Check","2020-04-30","507",null,"Hartzheim Leasing","2003","Checking",200,null,0]
[null,null,null,null,"Bill","2020-05-01",null,null,"Hartzheim Leasing","Van lease","67100 · Rent Expense",null,200,-200]
[null,null,null,null,"Bill Pmt -Check","2020-05-30","508",null,"Hartzheim Leasing","2003","Checking",200,null,0]
[null,null,null,null,"Bill","2020-06-01",null,null,"Hartzheim Leasing","Van lease","67100 · Rent Expense",null,200,-200]
[null,null,null,null,"Bill Pmt -Check","2020-06-30","509",null,"Hartzheim Leasing","2003","Checking",200,null,0]
[null,null,null,null,"Bill","2020-07-01",null,null,"Brewer Paint Supplies",null,"64800 · Paint Supplies Expense",null,100,-100]
[null,null,null,null,"Bill","2020-07-01",null,null,"Hartzheim Leasing","Van lease","67100 · Rent Expense",null,200,-300]
[null,null,null,null,"Bill Pmt -Check","2020-07-30","510",null,"Brewer Paint Supplies",null,"Checking",100,null,-200]
[null,null,null,null,"Bill Pmt -Check","2020-07-30","511",null,"Hartzheim Leasing","2003","Checking",200,null,0]
[null,null,null,null,"Bill","2020-08-01",null,null,"Hartzheim Leasing","Van lease","67100 · Rent Expense",null,200,-200]
[null,null,null,null,"Bill Pmt -Check","2020-08-30","512",null,"Hartzheim Leasing","2003","Checking",200,null,0]
[null,null,null,null,"Bill","2020-09-01",null,null,"Hartzheim Leasing","Van lease","67100 · Rent Expense",null,200,-200]
[null,null,null,null,"Bill","2020-09-02",null,null,"Brewer Paint Supplies",null,"64800 · Paint Supplies Expense",null,75,-275]
[null,null,null,null,"Bill Pmt -Check","2020-09-30","513",null,"Brewer Paint Supplies",null,"Checking",75,null,-200]
[null,null,null,null,"Bill Pmt -Check","2020-09-30","514",null,"Hartzheim Leasing","2003","Checking",200,null,0]
[null,null,null,null,"Bill","2020-10-01",null,null,"Hartzheim Leasing","Van lease","67100 · Rent Expense",null,200,-200]
[null,null,null,null,"Bill Pmt -Check","2020-10-30","515",null,"Hartzheim Leasing","2003","Checking",200,null,0]
[null,null,null,null,"Bill","2020-11-01",null,null,"Hartzheim Leasing","Van lease","67100 · Rent Expense",null,200,-200]
[null,null,null,null,"Bill Pmt -Check","2020-11-30","516",null,"Hartzheim Leasing","2003","Checking",200,null,0]
[null,null,null,null,"Bill","2020-12-01",null,null,"Hartzheim Leasing","Van lease","67100 · Rent Expense",null,200,-200]
[null,null,null,null,"Bill","2020-12-20",null,null,"Brewer Paint Supplies",null,"64800 · Paint Supplies Expense",null,50,-250]
[null,null,null,null,"Bill Pmt -Check","2020-12-30","517",null,"Hartzheim Leasing","2003","Checking",200,null,-50]
[null,"Total 21000 · Accounts Payable",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L95:L129),5)","v":3425},{"$f":"ROUND(SUM(M95:M129),5)","v":3475},{"$f":"N129","v":-50}]
[null,"30000 · Opening Balance Equity",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Deposit","2020-01-01","1001",null,"YourName","Invested $6,000 in business.","Checking",null,6000,-6000]
[null,"Total 30000 · Opening Balance Equity",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L131:L132),5)","v":0},{"$f":"ROUND(SUM(M131:M132),5)","v":6000},{"$f":"N132","v":-6000}]
[null,"47900 · Sales",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Invoice","2020-01-31","1",null,"Beneficio, Katrina:Dining Room","-MULTIPLE-","11000 · Accounts Receivable",null,3400,-3400]
[null,null,null,null,"Invoice","2020-02-28","2",null,"Beneficio, Katrina:Dining Room","Labor: Mural Painting","11000 · Accounts Receivable",null,3440,-6840]
[null,null,null,null,"Invoice","2020-03-31","3",null,"Beneficio, Katrina:Dining Room","Labor: Mural Painting","11000 · Accounts Receivable",null,3360,-10200]
[null,null,null,null,"Invoice","2020-04-30","4",null,"Whalen, Tom:Foyer","Labor: Faux Painting","11000 · Accounts Receivable",null,3200,-13400]
[null,null,null,null,"Invoice","2020-05-31","5",null,"Whalen, Tom:Foyer","Labor: Faux Painting","11000 · Accounts Receivable",null,3000,-16400]
[null,null,null,null,"Invoice","2020-06-30","6",null,"Beneficio, Katrina:Vaulted Kitchen","Labor: Mural Painting","11000 · Accounts Receivable",null,4000,-20400]
[null,null,null,null,"Invoice","2020-07-31","7",null,"Beneficio, Katrina:Vaulted Kitchen","Labor: Mural Painting","11000 · Accounts Receivable",null,3600,-24000]
[null,null,null,null,"Invoice","2020-08-31","8",null,"Beneficio, Katrina:Vaulted Kitchen","Labor: Mural Painting","11000 · Accounts Receivable",null,3680,-27680]
[null,null,null,null,"Invoice","2020-10-31","9",null,"Whalen, Tom:Screen Porch","Labor: Mural Painting","11000 · Accounts Receivable",null,3400,-31080]
[null,null,null,null,"Invoice","2020-11-30","10",null,"Whalen, Tom:Screen Porch","Labor: Mural Painting","11000 · Accounts Receivable",null,3480,-34560]
[null,"Total 47900 · Sales",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L134:L144),5)","v":0},{"$f":"ROUND(SUM(M134:M144),5)","v":34560},{"$f":"N144","v":-34560}]
[null,"64800 · Paint Supplies Expense",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Bill","2020-01-03",null,null,"Beneficio, Katrina:Dining Room",null,"21000 · Accounts Payable",300,null,300]
[null,null,null,null,"Invoice","2020-01-31","1",null,"Beneficio, Katrina:Dining Room",null,"11000 · Accounts Receivable",null,300,0]
[null,null,null,null,"Bill","2020-04-04",null,null,"Brewer Paint Supplies",null,"21000 · Accounts Payable",50,null,50]
[null,null,null,null,"Bill","2020-07-01",null,null,"Brewer Paint Supplies",null,"21000 · Accounts Payable",100,null,150]
[null,null,null,null,"Bill","2020-09-02",null,null,"Brewer Paint Supplies",null,"21000 · Accounts Payable",75,null,225]
[null,null,null,null,"Bill","2020-12-20",null,null,"Brewer Paint Supplies",null,"21000 · Accounts Payable",50,null,275]
[null,"Total 64800 · Paint Supplies Expense",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L146:L152),5)","v":575},{"$f":"ROUND(SUM(M146:M152),5)","v":300},{"$f":"N152","v":275}]
[null,"65300 · Depr Expense Computer",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"General Journal","2020-12-31","ADJ1","Ö",null,null,"14300 · Accumulated Depr Computer",500,null,500]
[null,"Total 65300 · Depr Expense Computer",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L154:L155),5)","v":500},{"$f":"ROUND(SUM(M154:M155),5)","v":0},{"$f":"N155","v":500}]
[null,"65600 · Depr Expense Equipment",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"General Journal","2020-12-31","ADJ2","Ö",null,null,"14600 · Acc Depr Equipment",100,null,100]
[null,"Total 65600 · Depr Expense Equipment",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L157:L158),5)","v":100},{"$f":"ROUND(SUM(M157:M158),5)","v":0},{"$f":"N158","v":100}]
[null,"67100 · Rent Expense",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Bill","2020-01-04",null,null,"Hartzheim Leasing","Van lease","21000 · Accounts Payable",200,null,200]
[null,null,null,null,"Bill","2020-02-01",null,null,"Hartzheim Leasing","Van lease","21000 · Accounts Payable",200,null,400]
[null,null,null,null,"Bill","2020-03-01",null,null,"Hartzheim Leasing","Van lease","21000 · Accounts Payable",200,null,600]
[null,null,null,null,"Bill","2020-04-01",null,null,"Hartzheim Leasing","Van lease","21000 · Accounts Payable",200,null,800]
[null,null,null,null,"Bill","2020-05-01",null,null,"Hartzheim Leasing","Van lease","21000 · Accounts Payable",200,null,1000]
[null,null,null,null,"Bill","2020-06-01",null,null,"Hartzheim Leasing","Van lease","21000 · Accounts Payable",200,null,1200]
[null,null,null,null,"Bill","2020-07-01",null,null,"Hartzheim Leasing","Van lease","21000 · Accounts Payable",200,null,1400]
[null,null,null,null,"Bill","2020-08-01",null,null,"Hartzheim Leasing","Van lease","21000 · Accounts Payable",200,null,1600]
[null,null,null,null,"Bill","2020-09-01",null,null,"Hartzheim Leasing","Van lease","21000 · Accounts Payable",200,null,1800]
[null,null,null,null,"Bill","2020-10-01",null,null,"Hartzheim Leasing","Van lease","21000 · Accounts Payable",200,null,2000]
[null,null,null,null,"Bill","2020-11-01",null,null,"Hartzheim Leasing","Van lease","21000 · Accounts Payable",200,null,2200]
[null,null,null,null,"Bill","2020-12-01",null,null,"Hartzheim Leasing","Van lease","21000 · Accounts Payable",200,null,2400]
[null,"Total 67100 · Rent Expense",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L160:L172),5)","v":2400},{"$f":"ROUND(SUM(M160:M172),5)","v":0},{"$f":"N172","v":2400}]
["TOTAL",null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L34+L56+L78+L86+L94+L130+L133+L145+L153+L156+L159+L173,5)","v":119580},{"$f":"ROUND(M34+M56+M78+M86+M94+M130+M133+M145+M153+M156+M159+M173,5)","v":119580},{"$f":"ROUND(N34+N56+N78+N86+N94+N130+N133+N145+N153+N156+N159+N173,5)","v":0}]

{"sheet":"EX9.4.3 PL","index":10,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.4 Paint Palette"]
["Profit & Loss"]
["January through December 2020",null,null,null,null,"Accrual Basis"]
[null,null,null,null,null,"Jan - Dec 20"]
[null,"Ordinary Income/Expense"]
[null,null,null,"Income"]
[null,null,null,null,"47900 · Sales",34560]
[null,null,null,"Total Income",null,{"$f":"ROUND(SUM(F6:F7),5)","v":34560}]
[null,null,"Gross Profit",null,null,{"$f":"F8","v":34560}]
[null,null,null,"Expense"]
[null,null,null,null,"64800 · Paint Supplies Expense",275]
[null,null,null,null,"65300 · Depr Expense Computer",500]
[null,null,null,null,"65600 · Depr Expense Equipment",100]
[null,null,null,null,"67100 · Rent Expense",2400]
[null,null,null,"Total Expense",null,{"$f":"ROUND(SUM(F10:F14),5)","v":3275}]
[null,"Net Ordinary Income",null,null,null,{"$f":"ROUND(F5+F9-F15,5)","v":31285}]
["Net Income",null,null,null,null,{"$f":"F16","v":31285}]

{"sheet":"EX9.4.3 BS","index":11,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.4 Paint Palette"]
["Balance Sheet"]
["As of December 31, 2020",null,null,null,null,"Accrual Basis"]
[null,null,null,null,null,"Dec 31, 20"]
["ASSETS"]
[null,"Current Assets"]
[null,null,"Checking/Savings"]
[null,null,null,"Checking",null,35935]
[null,null,"Total Checking/Savings",null,null,{"$f":"ROUND(SUM(F7:F8),5)","v":35935}]
[null,"Total Current Assets",null,null,null,{"$f":"ROUND(F6+F9,5)","v":35935}]
[null,"Fixed Assets"]
[null,null,"14100 · Computer"]
[null,null,null,"14200 · Computer Cost",null,1500]
[null,null,null,"14300 · Accumulated Depr Computer",null,-500]
[null,null,"Total 14100 · Computer",null,null,{"$f":"ROUND(SUM(F12:F14),5)","v":1000}]
[null,null,"14400 · Equipment"]
[null,null,null,"14500 · Equipment Cost",null,500]
[null,null,null,"14600 · Acc Depr Equipment",null,-100]
[null,null,"Total 14400 · Equipment",null,null,{"$f":"ROUND(SUM(F16:F18),5)","v":400}]
[null,"Total Fixed Assets",null,null,null,{"$f":"ROUND(F11+F15+F19,5)","v":1400}]
["TOTAL ASSETS",null,null,null,null,{"$f":"ROUND(F5+F10+F20,5)","v":37335}]
["LIABILITIES & EQUITY"]
[null,"Liabilities"]
[null,null,"Current Liabilities"]
[null,null,null,"Accounts Payable"]
[null,null,null,null,"21000 · Accounts Payable",50]
[null,null,null,"Total Accounts Payable",null,{"$f":"ROUND(SUM(F25:F26),5)","v":50}]
[null,null,"Total Current Liabilities",null,null,{"$f":"ROUND(F24+F27,5)","v":50}]
[null,"Total Liabilities",null,null,null,{"$f":"ROUND(F23+F28,5)","v":50}]
[null,"Equity"]
[null,null,"30000 · Opening Balance Equity",null,null,6000]
[null,null,"Net Income",null,null,31285]
[null,"Total Equity",null,null,null,{"$f":"ROUND(SUM(F30:F32),5)","v":37285}]
["TOTAL LIABILITIES & EQUITY",null,null,null,null,{"$f":"ROUND(F22+F29+F33,5)","v":37335}]

{"sheet":"EX9.4.3 SCF","index":12,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.4 Paint Palette"]
["Statement of Cash Flows"]
["January through December 2020",null,null,null,null,""]
[null,null,null,null,null,"Jan - Dec 20"]
[null,null,"OPERATING ACTIVITIES"]
[null,null,null,"Net Income",null,31285]
[null,null,null,"Adjustments to reconcile Net Income"]
[null,null,null,"to net cash provided by operations:"]
[null,null,null,null,"21000 · Accounts Payable",50]
[null,null,"Net cash provided by Operating Activities",null,null,{"$f":"ROUND(SUM(F5:F6)+F9,5)","v":31335}]
[null,null,"INVESTING ACTIVITIES"]
[null,null,null,"14100 · Computer:14200 · Computer Cost",null,-1500]
[null,null,null,"14100 · Computer:14300 · Accumulated Depr Computer",null,500]
[null,null,null,"14400 · Equipment:14500 · Equipment Cost",null,-500]
[null,null,null,"14400 · Equipment:14600 · Acc Depr Equipment",null,100]
[null,null,"Net cash provided by Investing Activities",null,null,{"$f":"ROUND(SUM(F11:F15),5)","v":-1400}]
[null,null,"FINANCING ACTIVITIES"]
[null,null,null,"30000 · Opening Balance Equity",null,6000]
[null,null,"Net cash provided by Financing Activities",null,null,{"$f":"ROUND(SUM(F17:F18),5)","v":6000}]
[null,"Net cash increase for period",null,null,null,{"$f":"ROUND(F10+F16+F19,5)","v":35935}]
["Cash at end of period",null,null,null,null,{"$f":"F20","v":35935}]

{"sheet":"EX9.6.2 COA","index":13,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.6 Alexandra LLC"]
["Account Listing"]
["All Transactions",null,null,null,null,null,""]
[null,"Account","Type","Balance Total","Description","Accnt. #","Tax Line"]
[null,"Checking","Bank",0,null,null,"<Unassigned>"]
[null,"13000 · Cleaning Supplies","Other Current Asset",0,"Cleaning Supplies","13000","<Unassigned>"]
[null,"14400 · Cleaning Equipment","Fixed Asset",0,"Cleaning Equipment","14400","<Unassigned>"]
[null,"14400 · Cleaning Equipment:14500 · Cleaning Equipment Cost","Fixed Asset",0,"Cleaning Equipment Cost","14500","<Unassigned>"]
[null,"14400 · Cleaning Equipment:14600 · Acc Depr Cleaning Equipment","Fixed Asset",0,"Acc Depr Cleaning Equipment","14600","<Unassigned>"]
[null,"15000 · Furniture and Equipment","Fixed Asset",0,"Furniture and equipment with useful life exceeding one year","15000","<Unassigned>"]
[null,"17000 · Accumulated Depreciation","Fixed Asset",0,"Accumulated depreciation on equipment, buildings and improvements","17000","<Unassigned>"]
[null,"21000 · Accounts Payable","Accounts Payable",0,"Accounts Payable","21000","<Unassigned>"]
[null,"30000 · Opening Balance Equity","Equity",0,"Opening balances during setup post to this account. The balance of this account should be zero after completing your setup","30000","<Unassigned>"]
[null,"30700 · Members Draw","Equity",0,"Monies taken out of the business by the member","30700","<Unassigned>"]
[null,"32000 · Members Equity","Equity",null,"Monies invested in the business by the member, and profits kept in company accounts","32000","<Unassigned>"]
[null,"47900 · Sales","Income",null,"Gross receipts from services","47900","Schedule C: Gross receipts or sales"]
[null,"60000 · Advertising and Promotion","Expense",null,"Advertising, marketing, graphic design, and other promotional expenses","60000","Schedule C: Advertising"]
[null,"60200 · Automobile Expense","Expense",null,"Fuel, oil, repairs, and other automobile maintenance for business autos","60200","Schedule C: Car and truck expenses"]
[null,"60400 · Bank Service Charges","Expense",null,"Bank account service fees, bad check charges and other bank fees","60400","Schedule C: Other business expenses"]
[null,"61700 · Computer and Internet Expenses","Expense",null,"Computer supplies, off-the-shelf software, online fees, and other computer or internet related expenses","61700","Schedule C: Other business expenses"]
[null,"62400 · Depreciation Expense","Expense",null,"Depreciation on equipment, buildings and improvements","62400","<Unassigned>"]
[null,"63300 · Insurance Expense","Expense",null,"Insurance expenses","63300","Schedule C: Insurance, other than health"]
[null,"63400 · Interest Expense","Expense",null,"Interest payments on business loans, credit card balances, or other business debt","63400","Schedule C: Interest expense, other"]
[null,"64300 · Meals and Entertainment","Expense",null,"Business meals and entertainment expenses, including travel-related meals (may have limited deductibility)","64300","Schedule C: Meals and entertainment"]
[null,"64800 · Supplies Expense","Expense",null,"Supplies Expense","64800","Schedule C: Supplies (not from COGS)"]
[null,"64900 · Office Supplies","Expense",null,"Office supplies expense","64900","Schedule C: Office expenses"]
[null,"66700 · Professional Fees","Expense",null,"Payments to accounting professionals and attorneys for accounting or legal services","66700","Schedule C: Legal and professional fees"]
[null,"67100 · Rent Expense","Expense",null,"Rent paid for company offices or other structures used in the business","67100","Schedule C: Rent/lease vehicles, equip."]
[null,"67200 · Repairs and Maintenance","Expense",null,"Incidental repairs and maintenance of business assets that do not add to the value or appreciably prolong its life","67200","Schedule C: Repairs and maintenance"]
[null,"68100 · Telephone Expense","Expense",null,"Telephone and long distance charges, faxing, and other fees Not equipment purchases","68100","Schedule C: Utilities"]
[null,"68400 · Travel Expense","Expense",null,"Business-related travel expenses including airline tickets, taxi fares, hotel and other travel expenses","68400","Schedule C: Travel"]
[null,"68600 · Utilities","Expense",null,"Water, electricity, garbage, and other basic utilities expenses","68600","Schedule C: Utilities"]
[null,"80000 · Ask My Accountant","Other Expense",null,"Transactions to be discussed with accountant, consultant, or tax preparer","80000","<Unassigned>"]

{"sheet":"EX9.6.3 CUST","index":14,"n_rows":6,"n_cols":41,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.6 Alexandra LLC"]
["Customer & Job List"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Active Status","Customer","Balance","Balance Total","Company","Mr./Ms./...","First Name","M.I.","Last Name","Primary Contact","Main Phone","Fax","Alt. Phone","Secondary Contact","Job Title","Main Email","Bill to 1","Bill to 2","Bill to 3","Bill to 4","Bill to 5","Ship to 1","Ship to 2","Ship to 3","Ship to 4","Ship to 5","Customer Type","Terms","Rep","Sales Tax Code","Tax item","Resale Num","Account No.","Credit Limit","Job Status","Job Type","Job Description","Start Date","Projected End","End Date"]
[null,"Active","Dent, Thomas",0,0,null,null,"Thomas",null,"Dent",null,"415-555-4242",null,null,null,null,null,"Thomas Dent","36 Penny Lane","Bayshore, CA 94326",null,null,null,null,null,null,null,"Residential","Net 15",null,null,null,null,"1005"]
[null,"Active","Dent, Thomas:Oriental Rugs",0,0,null,null,"Thomas",null,"Dent",null,"415-555-4242",null,null,null,null,null,"Thomas Dent","36 Penny Lane","Bayshore, CA 94326",null,null,null,null,null,null,null,"Residential","Net 15",null,null,null,null,"1005",null,"Pending","Residential","Oriental rug cleaning"]

{"sheet":"EX9.6.4 VEN","index":15,"n_rows":5,"n_cols":26,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.6 Alexandra LLC"]
["Vendor List"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Active Status","Vendor","Balance","Balance Total","Company","Mr./Ms./...","First Name","M.I.","Last Name","Bill from 1","Bill from 2","Bill from 3","Bill from 4","Bill from 5","Ship from 1","Ship from 2","Ship from 3","Ship from 4","Ship from 5","Primary Contact","Job Title","Main Phone","Fax","Alt. Phone","Secondary Contact"]
[null,"Active","Blumer Cleaning Supplies",0,0,"Blumer Cleaning Supplies",null,"Charlie",null,"Blumer","Blumer Cleaning Supplies","Charlie Blumer","72 St. Charles Blvd","Bayshore, CA 94326",null,null,null,null,null,null,null,null,"415-555-7272"]

{"sheet":"EX9.6.5 ITEM","index":16,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.6 Alexandra LLC"]
["Item Listing"]
["January 1, 2020",null,null,null,null,null,null,""]
[null,"Item","Description","Type","Cost","Price","Sales Tax Code","Preferred Vendor"]
[null,"Rug Cleaning","Oriental Rug Cleaning","Service",0,0]
[null,"Rug Cleaning:3x5 Rug Cleaning","3x5 Oriental Rug Cleaning","Service",0,50]
[null,"Rug Cleaning:5x7 Rug Cleaning","5x7 Oriental Rug Cleaning","Service",0,100]
[null,"Rug Cleaning:8x10 Rug Cleaning","8x10 Oriental Rug Cleaning","Service",0,150]

{"sheet":"EX9.6.7 CKS","index":17,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.6 Alexandra LLC"]
["Check Detail"]
["All Transactions",null,null,null,null,null,null,null,""]
[null,"Type","Num","Date","Name","Item","Account","Paid Amount","Original Amount"]
[" "]
[null,"Check","5001","2020-01-02","Blumer Cleaning Supplies",null,"Checking",null,-900]
[" "]
[null,null,null,null,null,null,"14500 · Cleaning Equipment Cost",-900,900]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H7:H8),5)","v":-900},{"$f":"ROUND(SUM(I7:I8),5)","v":900}]
[" "]
[null,"Bill Pmt -Check","5002","2020-01-20","Blumer Cleaning Supplies",null,"Checking",null,-100]
[" "]
[null,"Bill",null,"2020-01-05",null,null,"64800 · Supplies Expense",-100,100]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H12:H13),5)","v":-100},{"$f":"ROUND(SUM(I12:I13),5)","v":100}]

{"sheet":"EX9.6.7 DEP","index":18,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.6 Alexandra LLC"]
["Deposit Detail"]
["January 2020",null,null,null,null,null,""]
[null,"Type","Num","Date","Name","Account","Amount"]
[" "]
[null,"Deposit",null,"2020-01-01",null,"Checking",5000]
[" "]
[null,null,null,null,"Alexandra Simon","30000 · Opening Balance Equity",-5000]
["TOTAL",null,null,null,null,null,{"$f":"ROUND(SUM(G7:G8),5)","v":-5000}]
[" "]
[null,"Deposit",null,"2020-01-29",null,"Checking",1000]
[" "]
[null,"Payment","580","2020-01-29","Dent, Thomas:Oriental Rugs","12000 · Undeposited Funds",-1000]
["TOTAL",null,null,null,null,null,{"$f":"ROUND(SUM(G12:G13),5)","v":-1000}]

{"sheet":"EX9.6.8 JOUR","index":19,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.6 Alexandra LLC"]
["Journal"]
["January 2020",null,null,null,null,null,null,null,null,null,""]
[null,"Trans #","Type","Date","Num","Adj","Name","Memo","Account","Debit","Credit"]
[null,1,"Deposit","2020-01-01",null,null,null,"Deposit","Checking",5000]
[null,null,null,null,null,null,"Alexandra Simon","Deposit","30000 · Opening Balance Equity",null,5000]
[" ",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(J5:J6),5)","v":5000},{"$f":"ROUND(SUM(K5:K6),5)","v":5000}]
[null,2,"Check","2020-01-02","5001",null,"Blumer Cleaning Supplies","2004","Checking",null,900]
[null,null,null,null,null,null,"Blumer Cleaning Supplies","2004","14500 · Cleaning Equipment Cost",900]
[" ",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(J8:J9),5)","v":900},{"$f":"ROUND(SUM(K8:K9),5)","v":900}]
[null,3,"Bill","2020-01-05",null,null,"Blumer Cleaning Supplies",null,"21000 · Accounts Payable",null,100]
[null,null,null,null,null,null,"Blumer Cleaning Supplies",null,"64800 · Supplies Expense",100]
[" ",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(J11:J12),5)","v":100},{"$f":"ROUND(SUM(K11:K12),5)","v":100}]
[null,4,"Invoice","2020-01-09","1",null,"Dent, Thomas:Oriental Rugs",null,"11000 · Accounts Receivable",1000]
[null,null,null,null,null,null,"Dent, Thomas:Oriental Rugs","-MULTIPLE-","47900 · Sales",null,1000]
[" ",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(J14:J15),5)","v":1000},{"$f":"ROUND(SUM(K14:K15),5)","v":1000}]
[null,5,"Bill Pmt -Check","2020-01-20","5002",null,"Blumer Cleaning Supplies","2004","Checking",null,100]
[null,null,null,null,null,null,"Blumer Cleaning Supplies","2004","21000 · Accounts Payable",100]
[" ",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(J17:J18),5)","v":100},{"$f":"ROUND(SUM(K17:K18),5)","v":100}]
[null,6,"Payment","2020-01-29","580",null,"Dent, Thomas:Oriental Rugs",null,"12000 · Undeposited Funds",1000]
[null,null,null,null,null,null,"Dent, Thomas:Oriental Rugs",null,"11000 · Accounts Receivable",null,1000]
[" ",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(J20:J21),5)","v":1000},{"$f":"ROUND(SUM(K20:K21),5)","v":1000}]
[null,7,"Deposit","2020-01-29",null,null,null,"Deposit","Checking",1000]
[null,null,null,null,null,null,"Dent, Thomas:Oriental Rugs","Deposit","12000 · Undeposited Funds",null,1000]
[" ",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(J23:J24),5)","v":1000},{"$f":"ROUND(SUM(K23:K24),5)","v":1000}]
[null,8,"General Journal","2020-01-31","ADJ1","Ö",null,null,"62400 · Depreciation Expense",25]
[null,null,null,null,null,"Ö",null,null,"14600 · Acc Depr Cleaning Equipment",null,25]
[" ",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(J26:J27),5)","v":25},{"$f":"ROUND(SUM(K26:K27),5)","v":25}]
["TOTAL",null,null,null,null,null,null,null,null,{"$f":"ROUND(J7+J10+J13+J16+J19+J22+J25+J28,5)","v":9125},{"$f":"ROUND(K7+K10+K13+K16+K19+K22+K25+K28,5)","v":9125}]

{"sheet":"EX9.6.9 ADJTB","index":20,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.6 Alexandra LLC"]
["Adjusted Trial Balance"]
["January 31, 2020",null,null,null,null,null,null,"Accrual Basis"]
[null,null,"Unadjusted Balance",null,"Adjustments",null,"Adjusted Balance"]
[null,null,"Debit","Credit","Debit","Credit","Debit","Credit"]
[null,"Checking",5000,null,null,null,5000]
[null,"11000 · Accounts Receivable",0,null,null,null,0]
[null,"12000 · Undeposited Funds",0,null,null,null,0]
[null,"14400 · Cleaning Equipment:14500 · Cleaning Equipment Cost",900,null,null,null,900]
[null,"14400 · Cleaning Equipment:14600 · Acc Depr Cleaning Equipment",null,null,null,25,null,25]
[null,"21000 · Accounts Payable",0,null,null,null,0]
[null,"30000 · Opening Balance Equity",null,5000,null,null,null,5000]
[null,"47900 · Sales",null,1000,null,null,null,1000]
[null,"62400 · Depreciation Expense",null,null,25,null,25]
[null,"64800 · Supplies Expense",100,null,null,null,100]
["TOTAL",null,{"$f":"ROUND(SUM(C6:C15),5)","v":6000},6000,25,25,6025,6025]

{"sheet":"EX9.6.9 GL","index":21,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.6 Alexandra LLC"]
["General Ledger"]
["As of January 31, 2020",null,null,null,null,null,null,null,null,null,null,null,null,"Accrual Basis"]
[null,null,null,null,"Type","Date","Num","Adj","Name","Memo","Split","Debit","Credit","Balance"]
[null,"Checking",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Deposit","2020-01-01",null,null,null,"Deposit","30000 · Opening Balance Equity",5000,null,5000]
[null,null,null,null,"Check","2020-01-02","5001",null,"Blumer Cleaning Supplies","2004","14500 · Cleaning Equipment Cost",null,900,4100]
[null,null,null,null,"Bill Pmt -Check","2020-01-20","5002",null,"Blumer Cleaning Supplies","2004","21000 · Accounts Payable",null,100,4000]
[null,null,null,null,"Deposit","2020-01-29",null,null,null,"Deposit","12000 · Undeposited Funds",1000,null,5000]
[null,"Total Checking",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L5:L9),5)","v":6000},{"$f":"ROUND(SUM(M5:M9),5)","v":1000},{"$f":"N9","v":5000}]
[null,"11000 · Accounts Receivable",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Invoice","2020-01-09","1",null,"Dent, Thomas:Oriental Rugs",null,"-SPLIT-",1000,null,1000]
[null,null,null,null,"Payment","2020-01-29","580",null,"Dent, Thomas:Oriental Rugs",null,"12000 · Undeposited Funds",null,1000,0]
[null,"Total 11000 · Accounts Receivable",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L11:L13),5)","v":1000},{"$f":"ROUND(SUM(M11:M13),5)","v":1000},{"$f":"N13","v":0}]
[null,"12000 · Undeposited Funds",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Payment","2020-01-29","580",null,"Dent, Thomas:Oriental Rugs",null,"11000 · Accounts Receivable",1000,null,1000]
[null,null,null,null,"Deposit","2020-01-29","580",null,"Dent, Thomas:Oriental Rugs","Deposit","Checking",null,1000,0]
[null,"Total 12000 · Undeposited Funds",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L15:L17),5)","v":1000},{"$f":"ROUND(SUM(M15:M17),5)","v":1000},{"$f":"N17","v":0}]
[null,"14400 · Cleaning Equipment",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"14500 · Cleaning Equipment Cost",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Check","2020-01-02","5001",null,"Blumer Cleaning Supplies","2004","Checking",900,null,900]
[null,null,"Total 14500 · Cleaning Equipment Cost",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L20:L21),5)","v":900},{"$f":"ROUND(SUM(M20:M21),5)","v":0},{"$f":"N21","v":900}]
[null,null,"14600 · Acc Depr Cleaning Equipment",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"General Journal","2020-01-31","ADJ1","Ö",null,null,"62400 · Depreciation Expense",null,25,-25]
[null,null,"Total 14600 · Acc Depr Cleaning Equipment",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L23:L24),5)","v":0},{"$f":"ROUND(SUM(M23:M24),5)","v":25},{"$f":"N24","v":-25}]
[null,"Total 14400 · Cleaning Equipment",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L22+L25,5)","v":900},{"$f":"ROUND(M22+M25,5)","v":25},{"$f":"ROUND(N22+N25,5)","v":875}]
[null,"21000 · Accounts Payable",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Bill","2020-01-05",null,null,"Blumer Cleaning Supplies",null,"64800 · Supplies Expense",null,100,-100]
[null,null,null,null,"Bill Pmt -Check","2020-01-20","5002",null,"Blumer Cleaning Supplies","2004","Checking",100,null,0]
[null,"Total 21000 · Accounts Payable",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L27:L29),5)","v":100},{"$f":"ROUND(SUM(M27:M29),5)","v":100},{"$f":"N29","v":0}]
[null,"30000 · Opening Balance Equity",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Deposit","2020-01-01",null,null,"Alexandra Simon","Deposit","Checking",null,5000,-5000]
[null,"Total 30000 · Opening Balance Equity",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L31:L32),5)","v":0},{"$f":"ROUND(SUM(M31:M32),5)","v":5000},{"$f":"N32","v":-5000}]
[null,"47900 · Sales",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Invoice","2020-01-09","1",null,"Dent, Thomas:Oriental Rugs","-MULTIPLE-","11000 · Accounts Receivable",null,1000,-1000]
[null,"Total 47900 · Sales",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L34:L35),5)","v":0},{"$f":"ROUND(SUM(M34:M35),5)","v":1000},{"$f":"N35","v":-1000}]
[null,"62400 · Depreciation Expense",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"General Journal","2020-01-31","ADJ1","Ö",null,null,"14600 · Acc Depr Cleaning Equipment",25,null,25]
[null,"Total 62400 · Depreciation Expense",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L37:L38),5)","v":25},{"$f":"ROUND(SUM(M37:M38),5)","v":0},{"$f":"N38","v":25}]
[null,"64800 · Supplies Expense",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Bill","2020-01-05",null,null,"Blumer Cleaning Supplies",null,"21000 · Accounts Payable",100,null,100]
[null,"Total 64800 · Supplies Expense",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L40:L41),5)","v":100},{"$f":"ROUND(SUM(M40:M41),5)","v":0},{"$f":"N41","v":100}]
["TOTAL",null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L10+L14+L18+L26+L30+L33+L36+L39+L42,5)","v":9125},{"$f":"ROUND(M10+M14+M18+M26+M30+M33+M36+M39+M42,5)","v":9125},{"$f":"ROUND(N10+N14+N18+N26+N30+N33+N36+N39+N42,5)","v":0}]

{"sheet":"EX9.6.9 PL","index":22,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.6 Alexandra LLC"]
["Profit & Loss"]
["January 2020",null,null,null,"Accrual Basis"]
[null,null,null,null,"Jan 20"]
[null,"Ordinary Income/Expense"]
[null,null,"Income"]
[null,null,null,"47900 · Sales",1000]
[null,null,"Total Income",null,{"$f":"ROUND(SUM(E6:E7),5)","v":1000}]
[null,null,"Expense"]
[null,null,null,"62400 · Depreciation Expense",25]
[null,null,null,"64800 · Supplies Expense",100]
[null,null,"Total Expense",null,{"$f":"ROUND(SUM(E9:E11),5)","v":125}]
[null,"Net Ordinary Income",null,null,{"$f":"ROUND(E5+E8-E12,5)","v":875}]
["Net Income",null,null,null,{"$f":"E13","v":875}]

{"sheet":"EX9.6.9 BS","index":23,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.6 Alexandra LLC"]
["Balance Sheet"]
["As of January 31, 2020",null,null,null,"Accrual Basis"]
[null,null,null,null,"Jan 31, 20"]
["ASSETS"]
[null,"Current Assets"]
[null,null,"Checking/Savings"]
[null,null,null,"Checking",5000]
[null,null,"Total Checking/Savings",null,{"$f":"ROUND(SUM(E7:E8),5)","v":5000}]
[null,"Total Current Assets",null,null,{"$f":"ROUND(E6+E9,5)","v":5000}]
[null,"Fixed Assets"]
[null,null,"14400 · Cleaning Equipment"]
[null,null,null,"14500 · Cleaning Equipment Cost",900]
[null,null,null,"14600 · Acc Depr Cleaning Equipment",-25]
[null,null,"Total 14400 · Cleaning Equipment",null,{"$f":"ROUND(SUM(E12:E14),5)","v":875}]
[null,"Total Fixed Assets",null,null,{"$f":"ROUND(E11+E15,5)","v":875}]
["TOTAL ASSETS",null,null,null,{"$f":"ROUND(E5+E10+E16,5)","v":5875}]
["LIABILITIES & EQUITY"]
[null,"Equity"]
[null,null,"30000 · Opening Balance Equity",null,5000]
[null,null,"Net Income",null,875]
[null,"Total Equity",null,null,{"$f":"ROUND(SUM(E19:E21),5)","v":5875}]
["TOTAL LIABILITIES & EQUITY",null,null,null,{"$f":"ROUND(E18+E22,5)","v":5875}]

{"sheet":"EX9.6.9 SCF","index":24,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["YourName Exercise 9.6 Alexandra LLC"]
["Statement of Cash Flows"]
["January 2020",null,null,null,""]
[null,null,null,null,"Jan 20"]
[null,null,"OPERATING ACTIVITIES"]
[null,null,null,"Net Income",875]
[null,null,"Net cash provided by Operating Activities",null,{"$f":"ROUND(SUM(E5:E6),5)","v":875}]
[null,null,"INVESTING ACTIVITIES"]
[null,null,null,"14400 · Cleaning Equipment:14500 · Cleaning Equipment Cost",-900]
[null,null,null,"14400 · Cleaning Equipment:14600 · Acc Depr Cleaning Equipment",25]
[null,null,"Net cash provided by Investing Activities",null,{"$f":"ROUND(SUM(E8:E10),5)","v":-875}]
[null,null,"FINANCING ACTIVITIES"]
[null,null,null,"30000 · Opening Balance Equity",5000]
[null,null,"Net cash provided by Financing Activities",null,{"$f":"ROUND(SUM(E12:E13),5)","v":5000}]
[null,"Net cash increase for period",null,null,{"$f":"ROUND(E7+E11+E14,5)","v":5000}]
["Cash at end of period",null,null,null,{"$f":"E15","v":5000}]

{"sheet":"PR9.3 DEP","index":25,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["YourName Project 9 Dominic Consulting"]
["Deposit Detail"]
["January 2020",null,null,null,null,null,""]
[null,"Type","Num","Date","Name","Account","Amount"]
[" "]
[null,"Deposit",null,"2020-01-01",null,"Checking",5000]
[" "]
[null,null,null,null,"Dominic Leonardo","30000 · Opening Balance Equity",-5000]
["TOTAL",null,null,null,null,null,{"$f":"ROUND(SUM(G7:G8),5)","v":-5000}]
[" "]
[null,"Deposit",null,"2020-01-20",null,"Checking",800]
[" "]
[null,"Payment","589","2020-01-20","Redeker Bed & Breakfast","12000 · Undeposited Funds",-800]
["TOTAL",null,null,null,null,null,{"$f":"ROUND(SUM(G12:G13),5)","v":-800}]
[" "]
[null,"Deposit",null,"2020-01-22",null,"Checking",650]
[" "]
[null,"Payment","935","2020-01-22","Etzkin Realty","12000 · Undeposited Funds",-650]
["TOTAL",null,null,null,null,null,{"$f":"ROUND(SUM(G17:G18),5)","v":-650}]
[" "]
[null,"Deposit",null,"2020-01-23",null,"Checking",500]
[" "]
[null,"Payment","1245","2020-01-23","Holcomb Health Foods","12000 · Undeposited Funds",-500]
["TOTAL",null,null,null,null,null,{"$f":"ROUND(SUM(G22:G23),5)","v":-500}]
[" "]
[null,"Deposit",null,"2020-01-28",null,"Checking",900]
[" "]
[null,"Payment","876","2020-01-28","Etzkin Realty","12000 · Undeposited Funds",-900]
["TOTAL",null,null,null,null,null,{"$f":"ROUND(SUM(G27:G28),5)","v":-900}]

{"sheet":"PR9.4 CKS","index":26,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["YourName Project 9 Dominic Consulting"]
["Check Detail"]
["January 2020",null,null,null,null,null,null,null,""]
[null,"Type","Num","Date","Name","Item","Account","Paid Amount","Original Amount"]
[" "]
[null,"Bill Pmt -Check","101","2020-01-01","Pitts Leasing",null,"Checking",null,-800]
[" "]
[null,"Bill",null,"2020-01-01",null,null,"67100 · Rent Expense",-800,800]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H7:H8),5)","v":-800},{"$f":"ROUND(SUM(I7:I8),5)","v":800}]
[" "]
[null,"Bill Pmt -Check","102","2020-01-20","Jackson Computer Services",null,"Checking",null,-100]
[" "]
[null,"Bill",null,"2020-01-20",null,null,"64900 · Office Supplies",-100,100]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H12:H13),5)","v":-100},{"$f":"ROUND(SUM(I12:I13),5)","v":100}]
[" "]
[null,"Bill Pmt -Check","103","2020-01-24","Jackson Computer Services",null,"Checking",null,-200]
[" "]
[null,"Bill",null,"2020-01-24",null,null,"64900 · Office Supplies",-200,200]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H17:H18),5)","v":-200},{"$f":"ROUND(SUM(I17:I18),5)","v":200}]
[" "]
[null,"Bill Pmt -Check","104","2020-01-31","Jackson Computer Services",null,"Checking",null,-2100]
[" "]
[null,"Bill",null,"2020-01-02",null,null,"15000 · Furniture and Equipment",-2100,2100]
["TOTAL",null,null,null,null,null,null,{"$f":"ROUND(SUM(H22:H23),5)","v":-2100},{"$f":"ROUND(SUM(I22:I23),5)","v":2100}]

{"sheet":"PR9.5 TB","index":27,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["YourName Project 9 Dominic Consulting"]
["Trial Balance"]
["As of January 31, 2020",null,null,"Accrual Basis"]
[null,null,"Jan 31, 20"]
[null,null,"Debit","Credit"]
[null,"Checking",4650]
[null,"11000 · Accounts Receivable",1520]
[null,"12000 · Undeposited Funds",0]
[null,"15000 · Furniture and Equipment",2650]
[null,"20000 · Accounts Payable",null,550]
[null,"30000 · Opening Balance Equity",null,5000]
[null,"47900 · Sales",null,4370]
[null,"64900 · Office Supplies",300]
[null,"67100 · Rent Expense",800]
["TOTAL",null,{"$f":"ROUND(SUM(C6:C14),5)","v":9920},{"$f":"ROUND(SUM(D6:D14),5)","v":9920}]

{"sheet":"PR9.6 ADJ","index":28,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["YourName Project 9 Dominic Consulting"]
["Adjusting Journal Entries"]
["January 31, 2020",null,null,null,null,null,null,"Accrual Basis"]
[null,"Date","Num","Name","Memo","Account","Debit","Credit"]
[null,"2020-01-31","ADJ1",null,null,"62400 · Depreciation Expense",87.5]
[null,null,null,null,null,"17000 · Accumulated Depreciation",null,87.5]
[" ",null,null,null,null,null,{"$f":"ROUND(SUM(G5:G6),5)","v":87.5},{"$f":"ROUND(SUM(H5:H6),5)","v":87.5}]
[null,"2020-01-31","ADJ2",null,null,"62400 · Depreciation Expense",15.28]
[null,null,null,null,null,"17000 · Accumulated Depreciation",null,15.28]
[" ",null,null,null,null,null,{"$f":"ROUND(SUM(G8:G9),5)","v":15.28},{"$f":"ROUND(SUM(H8:H9),5)","v":15.28}]
[null,"2020-01-31","ADJ3",null,null,"13000 · Office Supplies on Hand",60]
[null,null,null,null,null,"64900 · Office Supplies",null,60]
[" ",null,null,null,null,null,{"$f":"ROUND(SUM(G11:G12),5)","v":60},{"$f":"ROUND(SUM(H11:H12),5)","v":60}]
["TOTAL",null,null,null,null,null,{"$f":"ROUND(G7+G10+G13,5)","v":162.78},{"$f":"ROUND(H7+H10+H13,5)","v":162.78}]

{"sheet":"PR9.7 ADJTB","index":29,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["YourName Project 9 Dominic Consulting"]
["Adjusted Trial Balance"]
["January 31, 2020",null,null,null,null,null,null,"Accrual Basis"]
[null,null,"Unadjusted Balance",null,"Adjustments",null,"Adjusted Balance"]
[null,null,"Debit","Credit","Debit","Credit","Debit","Credit"]
[null,"Checking",4650,null,null,null,4650]
[null,"11000 · Accounts Receivable",1520,null,null,null,1520]
[null,"12000 · Undeposited Funds",0,null,null,null,0]
[null,"13000 · Office Supplies on Hand",null,null,60,null,60]
[null,"15000 · Furniture and Equipment",2650,null,null,null,2650]
[null,"17000 · Accumulated Depreciation",null,null,null,102.78,null,102.78]
[null,"20000 · Accounts Payable",null,550,null,null,null,550]
[null,"30000 · Opening Balance Equity",null,5000,null,null,null,5000]
[null,"47900 · Sales",null,4370,null,null,null,4370]
[null,"62400 · Depreciation Expense",null,null,102.78,null,102.78]
[null,"64900 · Office Supplies",300,null,null,60,240]
[null,"67100 · Rent Expense",800,null,null,null,800]
["TOTAL",null,{"$f":"ROUND(SUM(C6:C17),5)","v":9920},9920,162.78,162.78,10022.780000000001,10022.780000000001]

{"sheet":"PR9.8 GL","index":30,"n_rows":83,"n_cols":13,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
["YourName Project 9 Dominic Consulting"]
["General Ledger"]
["As of January 31, 2020",null,null,null,null,null,null,null,null,null,null,null,"Accrual Basis"]
[null,null,null,"Type","Date","Num","Adj","Name","Memo","Split","Debit","Credit","Balance"]
[null,"Checking",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Deposit","2020-01-01",null,null,null,"Deposit","30000 · Opening Balance Equity",5000,null,5000]
[null,null,null,"Bill Pmt -Check","2020-01-01","101",null,"Pitts Leasing","2002","20000 · Accounts Payable",null,800,4200]
[null,null,null,"Bill Pmt -Check","2020-01-20","102",null,"Jackson Computer Services","2001","20000 · Accounts Payable",null,100,4100]
[null,null,null,"Deposit","2020-01-20",null,null,null,"Deposit","12000 · Undeposited Funds",800,null,4900]
[null,null,null,"Deposit","2020-01-22",null,null,null,"Deposit","12000 · Undeposited Funds",650,null,5550]
[null,null,null,"Deposit","2020-01-23",null,null,null,"Deposit","12000 · Undeposited Funds",500,null,6050]
[null,null,null,"Bill Pmt -Check","2020-01-24","103",null,"Jackson Computer Services","2001","20000 · Accounts Payable",null,200,5850]
[null,null,null,"Deposit","2020-01-28",null,null,null,"Deposit","12000 · Undeposited Funds",900,null,6750]
[null,null,null,"Bill Pmt -Check","2020-01-31","104",null,"Jackson Computer Services","2001","20000 · Accounts Payable",null,2100,4650]
[null,"Total Checking",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(K5:K14),5)","v":7850},{"$f":"ROUND(SUM(L5:L14),5)","v":3200},{"$f":"M14","v":4650}]
[null,"11000 · Accounts Receivable",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Invoice","2020-01-06","1",null,"Redeker Bed & Breakfast",null,"-SPLIT-",800,null,800]
[null,null,null,"Invoice","2020-01-08","2",null,"Etzkin Realty",null,"-SPLIT-",650,null,1450]
[null,null,null,"Invoice","2020-01-10","3",null,"Holcomb Health Foods",null,"47900 · Sales",500,null,1950]
[null,null,null,"Invoice","2020-01-15","4",null,"Etzkin Realty",null,"47900 · Sales",900,null,2850]
[null,null,null,"Payment","2020-01-20","589",null,"Redeker Bed & Breakfast",null,"12000 · Undeposited Funds",null,800,2050]
[null,null,null,"Invoice","2020-01-22","5",null,"Redeker Bed & Breakfast",null,"47900 · Sales",600,null,2650]
[null,null,null,"Payment","2020-01-22","935",null,"Etzkin Realty",null,"12000 · Undeposited Funds",null,650,2000]
[null,null,null,"Payment","2020-01-23","1245",null,"Holcomb Health Foods",null,"12000 · Undeposited Funds",null,500,1500]
[null,null,null,"Invoice","2020-01-27","6",null,"Holcomb Health Foods",null,"-SPLIT-",920,null,2420]
[null,null,null,"Payment","2020-01-28","876",null,"Etzkin Realty",null,"12000 · Undeposited Funds",null,900,1520]
[null,"Total 11000 · Accounts Receivable",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(K16:K26),5)","v":4370},{"$f":"ROUND(SUM(L16:L26),5)","v":2850},{"$f":"M26","v":1520}]
[null,"12000 · Undeposited Funds",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Payment","2020-01-20","589",null,"Redeker Bed & Breakfast",null,"11000 · Accounts Receivable",800,null,800]
[null,null,null,"Deposit","2020-01-20","589",null,"Redeker Bed & Breakfast","Deposit","Checking",null,800,0]
[null,null,null,"Payment","2020-01-22","935",null,"Etzkin Realty",null,"11000 · Accounts Receivable",650,null,650]
[null,null,null,"Deposit","2020-01-22","935",null,"Etzkin Realty","Deposit","Checking",null,650,0]
[null,null,null,"Payment","2020-01-23","1245",null,"Holcomb Health Foods",null,"11000 · Accounts Receivable",500,null,500]
[null,null,null,"Deposit","2020-01-23","1245",null,"Holcomb Health Foods","Deposit","Checking",null,500,0]
[null,null,null,"Payment","2020-01-28","876",null,"Etzkin Realty",null,"11000 · Accounts Receivable",900,null,900]
[null,null,null,"Deposit","2020-01-28","876",null,"Etzkin Realty","Deposit","Checking",null,900,0]
[null,"Total 12000 · Undeposited Funds",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(K28:K36),5)","v":2850},{"$f":"ROUND(SUM(L28:L36),5)","v":2850},{"$f":"M36","v":0}]
[null,"13000 · Office Supplies on Hand",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"General Journal","2020-01-31","ADJ3","Ö",null,null,"64900 · Office Supplies",60,null,60]
[null,"Total 13000 · Office Supplies on Hand",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(K38:K39),5)","v":60},{"$f":"ROUND(SUM(L38:L39),5)","v":0},{"$f":"M39","v":60}]
[null,"15000 · Furniture and Equipment",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Bill","2020-01-02",null,null,"Jackson Computer Services",null,"20000 · Accounts Payable",2100,null,2100]
[null,null,null,"Bill","2020-01-03",null,null,"Jackson Computer Services",null,"20000 · Accounts Payable",550,null,2650]
[null,"Total 15000 · Furniture and Equipment",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(K41:K43),5)","v":2650},{"$f":"ROUND(SUM(L41:L43),5)","v":0},{"$f":"M43","v":2650}]
[null,"17000 · Accumulated Depreciation",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"General Journal","2020-01-31","ADJ1","Ö",null,null,"62400 · Depreciation Expense",null,87.5,-87.5]
[null,null,null,"General Journal","2020-01-31","ADJ2","Ö",null,null,"62400 · Depreciation Expense",null,15.28,-102.78]
[null,"Total 17000 · Accumulated Depreciation",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(K45:K47),5)","v":0},{"$f":"ROUND(SUM(L45:L47),5)","v":102.78},{"$f":"M47","v":-102.78}]
[null,"20000 · Accounts Payable",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Bill","2020-01-01",null,null,"Pitts Leasing",null,"67100 · Rent Expense",null,800,-800]
[null,null,null,"Bill Pmt -Check","2020-01-01","101",null,"Pitts Leasing","2002","Checking",800,null,0]
[null,null,null,"Bill","2020-01-02",null,null,"Jackson Computer Services",null,"15000 · Furniture and Equipment",null,2100,-2100]
[null,null,null,"Bill","2020-01-03",null,null,"Jackson Computer Services",null,"15000 · Furniture and Equipment",null,550,-2650]
[null,null,null,"Bill","2020-01-20",null,null,"Jackson Computer Services",null,"64900 · Office Supplies",null,100,-2750]
[null,null,null,"Bill Pmt -Check","2020-01-20","102",null,"Jackson Computer Services","2001","Checking",100,null,-2650]
[null,null,null,"Bill","2020-01-24",null,null,"Jackson Computer Services",null,"64900 · Office Supplies",null,200,-2850]
[null,null,null,"Bill Pmt -Check","2020-01-24","103",null,"Jackson Computer Services","2001","Checking",200,null,-2650]
[null,null,null,"Bill Pmt -Check","2020-01-31","104",null,"Jackson Computer Services","2001","Checking",2100,null,-550]
[null,"Total 20000 · Accounts Payable",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(K49:K58),5)","v":3200},{"$f":"ROUND(SUM(L49:L58),5)","v":3750},{"$f":"M58","v":-550}]
[null,"30000 · Opening Balance Equity",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Deposit","2020-01-01","432",null,"Dominic Leonardo","Deposit","Checking",null,5000,-5000]
[null,"Total 30000 · Opening Balance Equity",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(K60:K61),5)","v":0},{"$f":"ROUND(SUM(L60:L61),5)","v":5000},{"$f":"M61","v":-5000}]
[null,"47900 · Sales",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Invoice","2020-01-06","1",null,"Redeker Bed & Breakfast","-MULTIPLE-","11000 · Accounts Receivable",null,800,-800]
[null,null,null,"Invoice","2020-01-08","2",null,"Etzkin Realty","-MULTIPLE-","11000 · Accounts Receivable",null,650,-1450]
[null,null,null,"Invoice","2020-01-10","3",null,"Holcomb Health Foods","Internet Marketing Consulting","11000 · Accounts Receivable",null,500,-1950]
[null,null,null,"Invoice","2020-01-15","4",null,"Etzkin Realty","Social Network Marketing Consulting","11000 · Accounts Receivable",null,900,-2850]
[null,null,null,"Invoice","2020-01-22","5",null,"Redeker Bed & Breakfast","Internet Marketing Consulting","11000 · Accounts Receivable",null,600,-3450]
[null,null,null,"Invoice","2020-01-27","6",null,"Holcomb Health Foods","-MULTIPLE-","11000 · Accounts Receivable",null,920,-4370]
[null,"Total 47900 · Sales",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(K63:K69),5)","v":0},{"$f":"ROUND(SUM(L63:L69),5)","v":4370},{"$f":"M69","v":-4370}]
[null,"62400 · Depreciation Expense",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"General Journal","2020-01-31","ADJ1","Ö",null,null,"17000 · Accumulated Depreciation",87.5,null,87.5]
[null,null,null,"General Journal","2020-01-31","ADJ2","Ö",null,null,"17000 · Accumulated Depreciation",15.28,null,102.78]
[null,"Total 62400 · Depreciation Expense",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(K71:K73),5)","v":102.78},{"$f":"ROUND(SUM(L71:L73),5)","v":0},{"$f":"M73","v":102.78}]
[null,"64900 · Office Supplies",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Bill","2020-01-20",null,null,"Jackson Computer Services",null,"20000 · Accounts Payable",100,null,100]
[null,null,null,"Bill","2020-01-24",null,null,"Jackson Computer Services",null,"20000 · Accounts Payable",200,null,300]
[null,null,null,"General Journal","2020-01-31","ADJ3","Ö",null,null,"13000 · Office Supplies on Hand",null,60,240]
[null,"Total 64900 · Office Supplies",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(K75:K78),5)","v":300},{"$f":"ROUND(SUM(L75:L78),5)","v":60},{"$f":"M78","v":240}]
[null,"67100 · Rent Expense",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Bill","2020-01-01",null,null,"Pitts Leasing",null,"20000 · Accounts Payable",800,null,800]
[null,"Total 67100 · Rent Expense",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(K80:K81),5)","v":800},{"$f":"ROUND(SUM(L80:L81),5)","v":0},{"$f":"M81","v":800}]
["TOTAL",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(K15+K27+K37+K40+K44+K48+K59+K62+K70+K74+K79+K82,5)","v":22182.78},{"$f":"ROUND(L15+L27+L37+L40+L44+L48+L59+L62+L70+L74+L79+L82,5)","v":22182.78},{"$f":"ROUND(M15+M27+M37+M40+M44+M48+M59+M62+M70+M74+M79+M82,5)","v":0}]

{"sheet":"PR9.9 PL","index":31,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["YourName Project 9 Dominic Consulting"]
["Profit & Loss"]
["January 2020",null,null,null,"Accrual Basis"]
[null,null,null,null,"Jan 20"]
[null,"Ordinary Income/Expense"]
[null,null,"Income"]
[null,null,null,"47900 · Sales",4370]
[null,null,"Total Income",null,{"$f":"ROUND(SUM(E6:E7),5)","v":4370}]
[null,null,"Expense"]
[null,null,null,"62400 · Depreciation Expense",102.78]
[null,null,null,"64900 · Office Supplies",240]
[null,null,null,"67100 · Rent Expense",800]
[null,null,"Total Expense",null,{"$f":"ROUND(SUM(E9:E12),5)","v":1142.78}]
[null,"Net Ordinary Income",null,null,{"$f":"ROUND(E5+E8-E13,5)","v":3227.22}]
["Net Income",null,null,null,{"$f":"E14","v":3227.22}]

{"sheet":"PR9.10 BS","index":32,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["YourName Project 9 Dominic Consulting"]
["Balance Sheet"]
["As of January 31, 2020",null,null,null,null,"Accrual Basis"]
[null,null,null,null,null,"Jan 31, 20"]
["ASSETS"]
[null,"Current Assets"]
[null,null,"Checking/Savings"]
[null,null,null,"Checking",null,4650]
[null,null,"Total Checking/Savings",null,null,{"$f":"ROUND(SUM(F7:F8),5)","v":4650}]
[null,null,"Accounts Receivable"]
[null,null,null,"11000 · Accounts Receivable",null,1520]
[null,null,"Total Accounts Receivable",null,null,{"$f":"ROUND(SUM(F10:F11),5)","v":1520}]
[null,null,"Other Current Assets"]
[null,null,null,"13000 · Office Supplies on Hand",null,60]
[null,null,"Total Other Current Assets",null,null,{"$f":"ROUND(SUM(F13:F14),5)","v":60}]
[null,"Total Current Assets",null,null,null,{"$f":"ROUND(F6+F9+F12+F15,5)","v":6230}]
[null,"Fixed Assets"]
[null,null,"15000 · Furniture and Equipment",null,null,2650]
[null,null,"17000 · Accumulated Depreciation",null,null,-102.78]
[null,"Total Fixed Assets",null,null,null,{"$f":"ROUND(SUM(F17:F19),5)","v":2547.2199999999998}]
["TOTAL ASSETS",null,null,null,null,{"$f":"ROUND(F5+F16+F20,5)","v":8777.2199999999993}]
["LIABILITIES & EQUITY"]
[null,"Liabilities"]
[null,null,"Current Liabilities"]
[null,null,null,"Accounts Payable"]
[null,null,null,null,"20000 · Accounts Payable",550]
[null,null,null,"Total Accounts Payable",null,{"$f":"ROUND(SUM(F25:F26),5)","v":550}]
[null,null,"Total Current Liabilities",null,null,{"$f":"ROUND(F24+F27,5)","v":550}]
[null,"Total Liabilities",null,null,null,{"$f":"ROUND(F23+F28,5)","v":550}]
[null,"Equity"]
[null,null,"30000 · Opening Balance Equity",null,null,5000]
[null,null,"Net Income",null,null,3227.22]
[null,"Total Equity",null,null,null,{"$f":"ROUND(SUM(F30:F32),5)","v":8227.2199999999993}]
["TOTAL LIABILITIES & EQUITY",null,null,null,null,{"$f":"ROUND(F22+F29+F33,5)","v":8777.2199999999993}]

{"sheet":"PR9.11 SCF","index":33,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["YourName Project 9 Dominic Consulting"]
["Statement of Cash Flows"]
["January 2020",null,null,null,null,""]
[null,null,null,null,null,"Jan 20"]
[null,null,"OPERATING ACTIVITIES"]
[null,null,null,"Net Income",null,3227.22]
[null,null,null,"Adjustments to reconcile Net Income"]
[null,null,null,"to net cash provided by operations:"]
[null,null,null,null,"11000 · Accounts Receivable",-1520]
[null,null,null,null,"13000 · Office Supplies on Hand",-60]
[null,null,null,null,"20000 · Accounts Payable",550]
[null,null,"Net cash provided by Operating Activities",null,null,{"$f":"ROUND(SUM(F5:F6)+SUM(F9:F11),5)","v":2197.2199999999998}]
[null,null,"INVESTING ACTIVITIES"]
[null,null,null,"15000 · Furniture and Equipment",null,-2650]
[null,null,null,"17000 · Accumulated Depreciation",null,102.78]
[null,null,"Net cash provided by Investing Activities",null,null,{"$f":"ROUND(SUM(F13:F15),5)","v":-2547.2199999999998}]
[null,null,"FINANCING ACTIVITIES"]
[null,null,null,"30000 · Opening Balance Equity",null,5000]
[null,null,"Net cash provided by Financing Activities",null,null,{"$f":"ROUND(SUM(F17:F18),5)","v":5000}]
[null,"Net cash increase for period",null,null,null,{"$f":"ROUND(F12+F16+F19,5)","v":4650}]
["Cash at end of period",null,null,null,null,{"$f":"F20","v":4650}]