{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sheet1","Chart of Accounts","General Journal","Adjusting Journal","General Ledger"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Sheet1","index":0,"n_rows":101,"n_cols":10,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Name"]
["                    ",null,"Create a new sheet and add the headings as shown (the date is a variable)"]
[null,null,"In the General Ledger normal balances for accounts are shown in black."]
[null,null,"Create a macro, attached to two buttons, one on the top of the General Journal and the other on top of the Adjusting Journal, that:"]
[null,null,1,"Clears the General Ledger sheet below the headings"]
[null,null,null,"Save the file everytime the report is started, Last name date and time"]
[null,null,2,"Imports the General Journal and the Adjusting Journal entries"]
[null,null,3,"Sorts by account number  and then by transaction number"]
[null,null,4,"Skips lines between each account"]
[null,null,5,"Add \"Balance\"  and holding places "]
[null,null,6,"Loop for all Accounts"]
[null,null,7,"Calculate and dispay a running balance and the ending balance of each account"]
[null,null,8,"Display the account balance of each account in \"I\""]
[null,null,9,"If the balance ever goes negitive change the font to red"]
[null,null,10,"If the account’s balance is not its normal balance, see chart of accounts,  add an error message."]
[]
[]
[]
[]
[null,"A Byte of Accounting"]
[null,"General Ledger"]
[null,"For the Period Ending June 30"]
[]
["Date","Transaction","Account","Name","Description","Debit","Credit","Balance"]
["2008-06-01",1,1110,"Cash","Jeremy's Investment",22260,null,22260]
["2008-06-01",2,1110,"Cash","Courtney's Investment",40950,null,63210]
["2008-06-01",3,1110,"Cash","Mark's Investment",63000,null,126210]
["2008-06-02",4,1110,"Cash","Computer Equip.",null,31000,95210]
["2008-06-10",7,1110,"Cash","Computer Equip.",null,23750,71460]
["2008-06-14",8,1110,"Cash","Insurance",null,6312,65148]
["2008-06-16",9,1110,"Cash","Revenue",7000,null,72148]
["2008-06-16",10,1110,"Cash","Housing Facility",null,13700,58448]
["2008-06-17",11,1110,"Cash","Rent",null,4800,53648]
["2008-06-21",14,1110,"Cash","Fax Machine",null,650,52998]
["2008-06-21",15,1110,"Cash","A/P",null,320,52678]
["2008-06-22",16,1110,"Cash","Newspaper Ad",null,275,52403]
["2008-06-22",18,1110,"Cash","Wages",null,1010,51393]
["2008-06-23",19,1110,"Cash","Revenue",3605,null,54998]
["2008-06-29",22,1110,"Cash","Revenue",5400,null,60398]
["2008-06-29",23,1110,"Cash","Repairs",null,1165,59233]
["2008-06-29",24,1110,"Cash","Wages",null,1010,58223]
["2008-06-30",26,1110,"Cash","Dividends",null,1535.39,56687.61]
["Balance",null,1110,"Cash",null,null,null,null,56687.61]
[]
["2008-06-21",13,1120,"Accounts Receivable","Revenue",4500,null,4500]
["2008-06-23",19,1120,"Accounts Receivable","Collection",null,4750,-250]
["2008-06-28",21,1120,"Accounts Receivable","Revenue",5700,null,5450]
["2008-06-29",22,1120,"Accounts Receivable","Collection",null,5650,-200]
["Balance",null,1120,"Accounts Receivable",null,null,null,null,-205,"  NOT A NORMAL BALANCE"]
[]
[]
["2008-06-04",5,2101,"Accounts Payable","Office Equip. ",null,400,400]
["2008-06-08",6,2101,"Accounts Payable","Office Equip. ",80,null,320]
["2008-06-17",12,2101,"Accounts Payable","Newspaper Ad",null,275,595]
["2008-06-21",15,2101,"Accounts Payable","A/P",320,null,275]
["2008-06-22",16,2101,"Accounts Payable","Newspaper Ad",375,null,-100]
["Balance",null,2101,"Accounts Payable",null,null,null,null,-100,"  NOT A NORMAL BALANCE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,""]

{"sheet":"Chart of Accounts","index":1,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Number","Name","Normal Balance",null,null,"Error #","Message"]
[1110,"Cash","Debit",null,null,1,"Debit And Credit On Same Line"]
[1120,"Accounts Receivable","Debit",null,null,2,"Debit Before Credit"]
[1130,"Prepaid Insurance","Debit",null,null,4,"Need An Account Number"]
[1140,"Prepaid Rent","Debit",null,null,8,"Round To Two Decimal Places"]
[1150,"Office Supplies","Debit",null,null,16,"Need a Description"]
[1211,"Office Equip.","Debit",null,null,32,"Need a Date"]
[1212,"Accum. Depr.-Office Equip.","Credit",null,null,64]
[1311,"Computer Equip.","Debit",null,null,128]
[1312,"Accum. Depr.-Computer Equip.","Credit",null,null,256]
[1411,"Building Cost","Debit",null,null,512]
[1412,"Accum. Depr.-Building","Credit",null,null,1024]
[1510,"Land ","Debit"]
[2101,"Accounts Payable","Credit"]
[2102,"Advanced Payments","Credit"]
[2103,"Interest Payable","Credit"]
[2105,"Salaries Payable","Credit"]
[2106,"Income Taxes Payable","Credit"]
[2201,"Mortgage Payable","Credit"]
[2202,"Notes Payable","Credit"]
[3100,"Capital Stock","Credit"]
[3200,"Retained Earnings","Credit"]
[3300,"Dividends","Debit"]
[3400,"Income Summary","Credit"]
[4100,"Computer & Consulting Revenue","Credit"]
[5010,"Rent Expense","Debit"]
[5020,"Salary Expense","Debit"]
[5030,"Advertising Expense","Debit"]
[5040,"Repairs & Maint. Expense","Debit"]
[5050,"Oil & Gas Expense","Debit"]
[5080,"Supplies Expense","Debit"]
[5090,"Interest Expense","Debit"]
[5100,"Insurance Expense","Debit"]
[5110,"Depreciation Expense","Debit"]
[5120,"Income Tax Expense","Debit"]

{"sheet":"General Journal","index":2,"n_rows":204,"n_cols":8,"rows_kept":204,"cut":false,"hidden":false,"merged":[]}
["A Byte of Accounting, Inc."]
["General Journal"]
[null,""]
["Transaction","Date","Account","Name","Description","Debit","Credit","Total Balance"]
["",null,null,null,""]
[1,"2016-06-01",1110,"Cash","Lauren's Investment",71400]
[1,"2016-06-01",3100,"Capital Stock","Lauren's Investment",null,71400]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[2,"2016-06-01",1110,"Cash","Sasha Irshad's Common Stock",23100]
[2,"2016-06-01",1311,"Computer Equip.","Sasha Irshad's Common Stock",31080]
[2,"2016-06-01",3100,"Capital Stock","Sasha Irshad's Common Stock",null,54180]
["","",null,"",""]
["",null,null,null,""]
[3,"2016-06-01",1110,"Cash","Courtney's Investment",45150]
[3,"2016-06-01",1311,"Computer Equip.","Courtney's Investment",12180]
[3,"2016-06-01",1211,"Office Equip.","Courtney's Investment",1050]
[3,"2016-06-01",3100,"Capital Stock","Courtney's Investment",null,58380]
["",null,null,null,""]
[4,"2016-06-02",1311,"Computer Equip.","Computer Down Payment",175000]
[4,"2016-06-02",2202,"Notes Payable","Computer Down Payment",null,140000]
[4,"2016-06-02",1110,"Cash","Computer Down Payment",null,35000]
["","",null,"",""]
["",null,null,null,""]
[5,"2016-06-04",1211,"Office Equip.","Office Equipment on Credit",500]
[5,"2016-06-04",2101,"Accounts Payable","Office Equipment on Credit",null,500]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[6,"2016-06-08",2101,"Accounts Payable","Return Office Equipment",100]
[6,"2016-06-08",1211,"Office Equip.","Return Office Equipment",null,100]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[7,"2016-06-10",2202,"Notes Payable","Computer Equipment",26750]
[7,"2016-06-10",1110,"Cash","Computer Equipment",null,26750]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[8,"2016-06-14",1130,"Prepaid Insurance","Pay for Insurance",6480]
[8,"2016-06-14",1110,"Cash","Pay for Insurance",null,6480]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[9,"2016-06-16",1110,"Cash","Consulting Revenue",6500]
[9,"2016-06-16",4100,"Computer & Consulting Revenue","Consulting Revenue",null,6500]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[10,"2016-06-16",1411,"Building Cost","Purchased Building and Land",95000]
[10,"2016-06-16",1510,"Land ","Purchased Building and Land",18000]
[10,"2016-06-16",1110,"Cash","Purchased Building and Land",null,11300]
[10,"2016-06-16",2201,"Mortgage Payable","Purchased Building and Land",null,101700]
["",null,null,null,""]
[11,"2016-06-17",1140,"Prepaid Rent","Pay for Rent",3400]
[11,"2016-06-17",1110,"Cash","Pay for Rent",null,3400]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[12,"2016-06-17",5030,"Advertising Expense","Newspaper Advertising Expense",250]
[12,"2016-06-17",2101,"Accounts Payable","Newspaper Advertising Expense",null,250]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[13,"2016-06-21",2101,"Accounts Payable","Paid for Accounts Payable",400]
[13,"2016-06-21",1110,"Cash","Paid for Accounts Payable",null,400]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[14,"2016-06-21",1211,"Office Equip.","Purchased Fax Machine",675]
[14,"2016-06-21",1110,"Cash","Purchased Fax Machine",null,675]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[15,"2016-06-21",1120,"Accounts Receivable","Consulting Services",4200]
[15,"2016-06-21",4100,"Computer & Consulting Revenue","Consulting Services",null,4200]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[16,"2016-06-22",5020,"Salary Expense","Equipment Operators Salaries",860]
[16,"2016-06-22",1110,"Cash","Equipment Operators Salaries",null,860]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[17,"2016-06-22",5040,"Repairs & Maint. Expense","Computer Equipment Repair Service",1165]
[17,"2016-06-22",2101,"Accounts Payable","Computer Equipment Repair Service",null,1165]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[18,"2016-06-22",2101,"Accounts Payable","Newspaper Advertising Expense",250]
[18,"2016-06-22",1110,"Cash","Newspaper Advertising Expense",null,250]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[19,"2016-06-23",1150,"Office Supplies","Purchased Office Supplies",555]
[19,"2016-06-23",2101,"Accounts Payable","Purchased Office Supplies",null,555]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[20,"2016-06-23",1110,"Cash","Billings",3365]
[20,"2016-06-23",1120,"Accounts Receivable","Billings",null,3365]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[21,"2016-06-28",1120,"Accounts Receivable","Bill for services performed",5385]
[21,"2016-06-28",4100,"Computer & Consulting Revenue","Bill for services performed",null,5385]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[22,"2016-06-29",2101,"Accounts Payable","Pay for Repairs to Computer Equipment",1165]
[22,"2016-06-29",1110,"Cash","Pay for Repairs to Computer Equipment",null,1165]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[23,"2016-06-29",1110,"Cash","Billings",5101]
[23,"2016-06-29",1120,"Accounts Receivable","Billings",null,5101]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[24,"2016-06-29",5020,"Salary Expense","Equipment Operators Salaries",860]
[24,"2016-06-29",1110,"Cash","Equipment Operators Salaries",null,860]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[25,"2016-06-30",5050,"Oil & Gas Expense","Bill from Oil and Gas Company",790]
[25,"2016-06-30",2101,"Accounts Payable","Bill from Oil and Gas Company",null,790]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[26,"2016-06-30",1110,"Cash","Test",5000]
[26,"2016-06-30",5020,"Salary Expense","Test",null,5000]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[27,null,null,""]
["","",null,"",""]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[28,null,null,""]
["","",null,"",""]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[29,null,null,""]
["","",null,"",""]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[30,null,null,""]
["","",null,"",""]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[31,null,null,""]
["","",null,"",""]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[32,null,null,""]
["","",null,"",""]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[33,null,null,""]
["","",null,"",""]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[34,null,null,""]
["","",null,"",""]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[35,null,null,""]
["","",null,"",""]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[36,null,null,""]
["","",null,"",""]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[37,null,null,""]
["","",null,"",""]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[38,null,null,""]
["","",null,"",""]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[39,null,null,""]
["","",null,"",""]
[null,"",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[40,null,null,""]
["","",null,"",""]
[null,"",null,"",""]
["","",null,"",""]

{"sheet":"Adjusting Journal","index":3,"n_rows":179,"n_cols":7,"rows_kept":179,"cut":false,"hidden":false,"merged":[]}
["A Byte of Accounting, Inc."]
["Adjusting  Journal"]
[null,""]
["Transaction","Date","Account","Name","Description","Debit","Credit"]
["",null,null,null,""]
[101,"2016-06-30",3300,"Dividends","Paid Cash Dividend to Shareholders",1401.6]
[101,"2016-06-30",1110,"Cash","Paid Cash Dividend to Shareholders",null,1401.6]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[102,"2016-06-30",5010,"Rent Expense","Rent for June",1700]
[102,"2016-06-30",1140,"Prepaid Rent","Rent for June",null,1700]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[103,"2016-06-30",5080,"Supplies Expense","Office Supplies Remaining",330]
[103,"2016-06-30",1150,"Office Supplies","Office Supplies Remaining",null,330]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[104,"2016-06-30",5090,"Interest Expense","Interest on Mortgage",339]
[104,"2016-06-30",2103,"Interest Payable","Interest on Mortgage",null,339]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[105,"2016-06-30",5100,"Insurance Expense","Half of June's Insurance",270]
[105,"2016-06-30",1130,"Prepaid Insurance","Half of June's Insurance",null,270]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[106,"2016-06-30",1120,"Accounts Receivable","Unbilled Revenues",5000]
[106,"2016-06-30",4100,"Computer & Consulting Revenue","Unbilled Revenues",null,5000]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[107,"2016-06-30",5110,"Depreciation Expense","Depreciation for June",3888.5]
[107,"2016-06-30",1412,"Accum. Depr.-Building","Depreciation for June",null,231.48]
[107,"2016-06-30",1312,"Accum. Depr.-Computer Equip.","Depreciation for June",null,3637.67]
[107,"2016-06-30",1212,"Accum. Depr.-Office Equip.","Depreciation for June",null,19.350000000000001]
["",null,null,null,""]
[108,"2016-06-30",5020,"Salary Expense","Unpaid Salaries Owed",516]
[108,"2016-06-30",2105,"Salaries Payable","Unpaid Salaries Owed",null,516]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[109,"2016-06-30",5090,"Interest Expense","Interest on Five Year Note",1128.33]
[109,"2016-06-30",2103,"Interest Payable","Interest on Five Year Note",null,1128.33]
["","",null,"",""]
["","",null,"",""]
["",null,null,null,""]
[110,"2016-06-30",5120,"Income Tax Expense","Income Taxes",2247.04]
[110,"2016-06-30",2106,"Income Taxes Payable","Income Taxes",null,2247.04]
["","",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,"",""]
["","",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,"",""]
["",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,null,null,""]
[""]
[""]
["","",null,"",""]
["","",null,"",""]

{"sheet":"General Ledger","index":4,"n_rows":227,"n_cols":10,"rows_kept":227,"cut":false,"hidden":false,"merged":[]}
["Cordova","A Byte of Accounting"]
[{"$f":"NOW()","v":"2017-06-15T19:03:00.950"},"General Ledger"]
[{"$f":"A1&TEXT(A2,\" yyy mm dd hh.mm.ss\")","v":"Cordova 2017 06 15 19.03.01"},"For the Period Ending June 30"]
[]
["Transaction","Date","Account","Name","Description","Debit","Credit","Balance"]
[1,"2016-06-01",1110,"Cash","Lauren's Investment",71400,null,71400]
[2,"2016-06-01",1110,"Cash","Sasha Irshad's Common Stock",23100,null,94500]
[3,"2016-06-01",1110,"Cash","Courtney's Investment",45150,null,139650]
[4,"2016-06-02",1110,"Cash","Computer Down Payment",null,35000,104650]
[7,"2016-06-10",1110,"Cash","Computer Equipment",null,26750,77900]
[8,"2016-06-14",1110,"Cash","Pay for Insurance",null,6480,71420]
[9,"2016-06-16",1110,"Cash","Consulting Revenue",6500,null,77920]
[10,"2016-06-16",1110,"Cash","Purchased Building and Land",null,11300,66620]
[11,"2016-06-17",1110,"Cash","Pay for Rent",null,3400,63220]
[13,"2016-06-21",1110,"Cash","Paid for Accounts Payable",null,400,62820]
[14,"2016-06-21",1110,"Cash","Purchased Fax Machine",null,675,62145]
[16,"2016-06-22",1110,"Cash","Equipment Operators Salaries",null,860,61285]
[18,"2016-06-22",1110,"Cash","Newspaper Advertising Expense",null,250,61035]
[20,"2016-06-23",1110,"Cash","Billings",3365,null,64400]
[22,"2016-06-29",1110,"Cash","Pay for Repairs to Computer Equipment",null,1165,63235]
[23,"2016-06-29",1110,"Cash","Billings",5101,null,68336]
[24,"2016-06-29",1110,"Cash","Equipment Operators Salaries",null,860,67476]
[26,"2016-06-30",1110,"Cash","Test",5000,null,72476]
[101,"2016-06-30",1110,"Cash","Paid Cash Dividend to Shareholders",null,1401.6,71074.399999999994]
[]
[null,null,"Balance"]
[]
[15,"2016-06-21",1120,"Accounts Receivable","Consulting Services",4200,null,4200]
[20,"2016-06-23",1120,"Accounts Receivable","Billings",null,3365,835]
[21,"2016-06-28",1120,"Accounts Receivable","Bill for services performed",5385,null,6220]
[23,"2016-06-29",1120,"Accounts Receivable","Billings",null,5101,1119]
[106,"2016-06-30",1120,"Accounts Receivable","Unbilled Revenues",5000,null,6119]
[]
[null,null,"Balance",null,null,null,null,null,6119]
[]
[8,"2016-06-14",1130,"Prepaid Insurance","Pay for Insurance",6480,null,6480]
[105,"2016-06-30",1130,"Prepaid Insurance","Half of June's Insurance",null,270,6210]
[]
[null,null,"Balance",null,null,null,null,null,6210]
[]
[11,"2016-06-17",1140,"Prepaid Rent","Pay for Rent",3400,null,3400]
[102,"2016-06-30",1140,"Prepaid Rent","Rent for June",null,1700,1700]
[]
[null,null,"Balance",null,null,null,null,null,1700]
[]
[19,"2016-06-23",1150,"Office Supplies","Purchased Office Supplies",555,null,555]
[103,"2016-06-30",1150,"Office Supplies","Office Supplies Remaining",null,330,225]
[]
[null,null,"Balance",null,null,null,null,null,225]
[]
[3,"2016-06-01",1211,"Office Equip.","Courtney's Investment",1050,null,1050]
[5,"2016-06-04",1211,"Office Equip.","Office Equipment on Credit",500,null,1550]
[6,"2016-06-08",1211,"Office Equip.","Return Office Equipment",null,100,1450]
[14,"2016-06-21",1211,"Office Equip.","Purchased Fax Machine",675,null,2125]
[]
[null,null,"Balance",null,null,null,null,null,2125]
[]
[107,"2016-06-30",1212,"Accum. Depr.-Office Equip.","Depreciation for June",null,19.350000000000001,19.350000000000001]
[]
[null,null,"Balance",null,null,null,null,null,19.350000000000001]
[]
[2,"2016-06-01",1311,"Computer Equip.","Sasha Irshad's Common Stock",31080,null,31080]
[3,"2016-06-01",1311,"Computer Equip.","Courtney's Investment",12180,null,43260]
[4,"2016-06-02",1311,"Computer Equip.","Computer Down Payment",175000,null,218260]
[]
[null,null,"Balance",null,null,null,null,null,218260]
[]
[107,"2016-06-30",1312,"Accum. Depr.-Computer Equip.","Depreciation for June",null,3637.67,3637.67]
[]
[null,null,"Balance",null,null,null,null,null,3637.67]
[]
[10,"2016-06-16",1411,"Building Cost","Purchased Building and Land",95000,null,95000]
[]
[null,null,"Balance",null,null,null,null,null,95000]
[]
[107,"2016-06-30",1412,"Accum. Depr.-Building","Depreciation for June",null,231.48,231.48]
[]
[null,null,"Balance",null,null,null,null,null,231.48]
[]
[10,"2016-06-16",1510,"Land ","Purchased Building and Land",18000,null,18000]
[]
[null,null,"Balance",null,null,null,null,null,18000]
[]
[5,"2016-06-04",2101,"Accounts Payable","Office Equipment on Credit",null,500,500]
[6,"2016-06-08",2101,"Accounts Payable","Return Office Equipment",100,null,400]
[12,"2016-06-17",2101,"Accounts Payable","Newspaper Advertising Expense",null,250,650]
[13,"2016-06-21",2101,"Accounts Payable","Paid for Accounts Payable",400,null,250]
[17,"2016-06-22",2101,"Accounts Payable","Computer Equipment Repair Service",null,1165,1415]
[18,"2016-06-22",2101,"Accounts Payable","Newspaper Advertising Expense",250,null,1165]
[19,"2016-06-23",2101,"Accounts Payable","Purchased Office Supplies",null,555,1720]
[22,"2016-06-29",2101,"Accounts Payable","Pay for Repairs to Computer Equipment",1165,null,555]
[25,"2016-06-30",2101,"Accounts Payable","Bill from Oil and Gas Company",null,790,1345]
[]
[null,null,"Balance",null,null,null,null,null,1345]
[]
[104,"2016-06-30",2103,"Interest Payable","Interest on Mortgage",null,339,339]
[109,"2016-06-30",2103,"Interest Payable","Interest on Five Year Note",null,1128.33,1467.33]
[]
[null,null,"Balance",null,null,null,null,null,1467.33]
[]
[108,"2016-06-30",2105,"Salaries Payable","Unpaid Salaries Owed",null,516,516]
[]
[null,null,"Balance",null,null,null,null,null,516]
[]
[110,"2016-06-30",2106,"Income Taxes Payable","Income Taxes",null,2247.04,2247.04]
[]
[null,null,"Balance",null,null,null,null,null,2247.04]
[]
[10,"2016-06-16",2201,"Mortgage Payable","Purchased Building and Land",null,101700,101700]
[]
[null,null,"Balance",null,null,null,null,null,101700]
[]
[4,"2016-06-02",2202,"Notes Payable","Computer Down Payment",null,140000,140000]
[7,"2016-06-10",2202,"Notes Payable","Computer Equipment",26750,null,113250]
[]
[null,null,"Balance",null,null,null,null,null,113250]
[]
[1,"2016-06-01",3100,"Capital Stock","Lauren's Investment",null,71400,71400]
[2,"2016-06-01",3100,"Capital Stock","Sasha Irshad's Common Stock",null,54180,125580]
[3,"2016-06-01",3100,"Capital Stock","Courtney's Investment",null,58380,183960]
[]
[null,null,"Balance",null,null,null,null,null,183960]
[]
[101,"2016-06-30",3300,"Dividends","Paid Cash Dividend to Shareholders",1401.6,null,1401.6]
[]
[null,null,"Balance",null,null,null,null,null,1401.6]
[]
[9,"2016-06-16",4100,"Computer & Consulting Revenue","Consulting Revenue",null,6500,6500]
[15,"2016-06-21",4100,"Computer & Consulting Revenue","Consulting Services",null,4200,10700]
[21,"2016-06-28",4100,"Computer & Consulting Revenue","Bill for services performed",null,5385,16085]
[106,"2016-06-30",4100,"Computer & Consulting Revenue","Unbilled Revenues",null,5000,21085]
[]
[null,null,"Balance",null,null,null,null,null,21085]
[]
[102,"2016-06-30",5010,"Rent Expense","Rent for June",1700,null,1700]
[]
[null,null,"Balance",null,null,null,null,null,1700]
[]
[16,"2016-06-22",5020,"Salary Expense","Equipment Operators Salaries",860,null,860]
[24,"2016-06-29",5020,"Salary Expense","Equipment Operators Salaries",860,null,1720]
[26,"2016-06-30",5020,"Salary Expense","Test",null,5000,-3280]
[108,"2016-06-30",5020,"Salary Expense","Unpaid Salaries Owed",516,null,-2764]
[]
[null,null,"Balance",null,null,null,null,null,-2764,"NOT A NORMAL BALANCE"]
[]
[12,"2016-06-17",5030,"Advertising Expense","Newspaper Advertising Expense",250,null,250]
[]
[null,null,"Balance",null,null,null,null,null,250]
[]
[17,"2016-06-22",5040,"Repairs & Maint. Expense","Computer Equipment Repair Service",1165,null,1165]
[]
[null,null,"Balance",null,null,null,null,null,1165]
[]
[25,"2016-06-30",5050,"Oil & Gas Expense","Bill from Oil and Gas Company",790,null,790]
[]
[null,null,"Balance",null,null,null,null,null,790]
[]
[103,"2016-06-30",5080,"Supplies Expense","Office Supplies Remaining",330,null,330]
[]
[null,null,"Balance",null,null,null,null,null,330]
[]
[104,"2016-06-30",5090,"Interest Expense","Interest on Mortgage",339,null,339]
[109,"2016-06-30",5090,"Interest Expense","Interest on Five Year Note",1128.33,null,1467.33]
[]
[null,null,"Balance",null,null,null,null,null,1467.33]
[]
[105,"2016-06-30",5100,"Insurance Expense","Half of June's Insurance",270,null,270]
[]
[null,null,"Balance",null,null,null,null,null,270]
[]
[107,"2016-06-30",5110,"Depreciation Expense","Depreciation for June",3888.5,null,3888.5]
[]
[null,null,"Balance",null,null,null,null,null,3888.5]
[]
[110,"2016-06-30",5120,"Income Tax Expense","Income Taxes",2247.04,null,2247.04]
[]
[null,null,"Balance",null,null,null,null,null,2247.04]
[]
["","",71074.399999999994,"",""]
["","",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,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,"",""]