I only need assisantce with the Worksheet and Financial Statements
ACCT 2301 - JW's Lock & Key Background JW's Lock & Key is owned and operated by Jake Walters and is located in Odessa, TX. Jake is a locksmith and provides locksmith services and has a store that ses everything from keys to safes. You have just been hired as the accountant as of December 1, 2020 Required 1. The general ledger contains the current balances for all accounts as of November 30, 2020. The subsidiary ledgers for A'R and A/P also contain the current balances as of November 30, 2020. Review the information in these accounts before beginning the project. Do NOT delete these balances. You need them. 2. Journaize the December transactions in the general journal. Descriptions are not required. Be sure that the account names used are the same as on the Chart of Accounts tab and the customer or vendor name are included in AR & AP transactions (ex: AP. Brinks Co.) Also, be sure to indent credit entries and note the account numbers in the Post Reference column 3. Post daily to the Accounts Receivable Subsidiary Lodger and the Accounts Payable Subsidiary Ledger Place a checkmark in the Post Reference column of the General Ledger next to the GL account number; i 2018. The checkmark denotos that you have posted to the Subsidiary Ledger account. On December 31, poat to the General Ledger 4. Prepare an Unadjusted Trial Balance using the worksheet Complete the worksheet using the following adjustment information for December Office supplios on hand on December 31 are $1,338 A physical count of inventory showed an ending inventory cost of $44.500 Recorded depreciation on equiment for the month $4200 insurance expired during December is $300 Eamed $2,457 worth of the unearned service revenue Sales refunds estimated for the year $10,000 Conto estimated returns for the year $2,000 S. Journalize and post the ADJUSTING entries in the GJ Ledger and subsidiary lodgers. Journalize and post the CLOSING entries in the GJ, Ledger and subsidiary lodgers. 7. Prepare JWs Lock & Key's financial statements for the year ended December 31, 2020. The breakouts on the Chart of Accounts may help categorizing and making sure all accounts are used on the financial statements. Additionally, please ensure to use the proper formatting indentation underlines, S signs, etc.) Note: Jake Walter's Capital at December 1, 2020 was $262,643 8. Prepare a Post-Closing Trial Balance Check Figures Unadjusted Trial Balance: 911,822 Cash Account Balance: 168,891 Net Income (Loss): 205,092 9. Be sure that all entries, the worksheet financial statements and the post-closing trial balance have been dated Dec. 1 Pald December's rent, check 1 6287 $2,175. 2 Paid annual premiums on property and casually insurance policies, check # 6288. $1,967. 3 Performed locksmith services on new house, sent involoe #601 to the homeowner, Sam Mason, $2,200. 4 Issued Invoice #602 to Hastings who purchased a new safe on account, $3.700. Cost of Merchandise Sold was $1,250. 5 Purchased office supplies, check #6289. 8620 6 Purchased inventory from Key Supplies Co., $6.500, tors 1/10, n/30 7 Pald UPS $258 cash for delivery of the inventory purchased on December 6. 7 Jake deposited an additional $8.500 cash in the business 8 Retumed damaged inventory to Kay Supplies Co., $500 8 Received $2.500 cash, an advance payment for locksmith services. 9 Unlocked a safe for a customer and received $1,000 cash, Bought a new comouter equipment) ftom Office Depot on account, 31.857A 10 Sold 2 safes and teceled cash. 2.200. Cost of Merchandise Sold was $800. 11 Purchased 5 sates to restock inventory on account from Brinks Co $4.573 tams, 2/5. n/45 12 Customer retumed one of the safes purchased on December 10, rotunded the customer $1.000 cash Cost of Merchandise Sold was $475 13 Paid Verizon for wireless telephone services $394. check 6290. 14 Paid Key Supplies Go for the purchase on December 6, less retum and discount, check 5291. 14 Received cash on account, $1,500. From Nathan Dean, Dean did not pay his November invoice #590 within the crede terms 2/10. The discount was forfeited 15 Recorded cash sales for the store from the 1st to the 15th. $14.351. Cost of Merchandise Sold was $4.783 16 Received $1.825 from Hastings on account 17 Paid Office Depot on account, $500, check # 6292 15 18 Performed locksmith services on account for Larry Contractor $700. 17 19 Paid electricity bid for December, check # 6293. $1,792 49 19 Paid for Domino's pizza delivery for the December office party, check #6294 $175 51 20 Jake withdrew $8,350 for a vacation 53 25 Paid the water ble for December, check # 6295, $120. 25 Paid Beinks Co. on account, $2,500, check 6296. 57 26 Paid part time employees the salary, $2.550 59 27 Received cash on account from Larry Contractor. $700. 51 30 Recorded cash sales for the store from the 16th to the 30th, 435. Cost of Merchandise Sold was $2.784 63 64 66 66 67 The 53 vu The adjustment data for December is as follows: a. b. C. d. Office supplies on hand on December 31 are $1,338. A physical count of inventory showed an ending inventory cost of $44,500. Recorded depreciation on equipment for the month, $4,200. Insurance expired during December is $300. Eamed $2,457 worth of the uneamed service revenue. Sales refunds estimated for the year $10,000 Cost of estimated retums for the year $2,000 e. 1. g. JW's Lock & Key Chart of Accounts 201 203 205 Liabilities Accounts Payable Refunds Payable Uneamed Service Revenue Assets 101 Cash 105 Accounts Receivable 110 Inventory 112 Estimated Returns Inventory 115 Office Supplies 117 Prepaid Insurance 120 Equipment 121 Accum. Depreciation - Equipment 301 311 Owner's Equity Jake Walters, Capital Jake Walters, Withdrawal 401 405 410 Revenues Service Revenue Sales Revenue Sales Discounts Forfeited Expenses 501 Cost of Merchandise Sold 502 Advertising Expense 505 Depreciation Expense 507 Insurance Expense 508 Office Supplies Expense 509 Salary Expense 511 Rent Expense 512 Telephone Expense 513 Utilities Expenso 525 Miscellaneous Expense Other Misc Income Summary 999 B H Cash ACCOUNT 2020 DATE ITEM POST REF DEBIT CREDIT ACCOUNT NO 101 BALANCE DEBIT CREDIT 154,931 Nov 30 Bat 105 ACCOUNT Accounts Receivable 2020 ITEM POST DATE REF Noy 30 Bal DEBIT CREDIT ACCOUNT NO BALANCE DEBIT CREDIT 4.108 Instruction Triations Oran of Account GJ Ledger AR sub Ready H POST RER DEBIT ACCOUNT Inventory 2020 ITEM DATE Noy 30. Bal CREDIT ACCOUNT NO 110 BALANCE DEBIT CREDIT 46,525 ACCOUNT Estimated Returns Inventory 2020 POST ITEM DATE REF Nov 30 Bal DEBIT CREDIT ACCOUNT NO 112 BAEANCE DEBIT CREDIT 700 ACCOUNT 2020 DATE NON 30 Office Supplies ITEM DEBIT POSTI REF u CREDIT ACCOUNT NO 115 BALANCE DEBIT CREDIT 1235 Bat Instructions Thansadena Chor or Accounts ell Ledger ARS 110 B G H 3 ACCOUNT 4 2020 DATE 0 E Prepaid Insurance ITEM POST REF DEBIT CREDIT ACCOUNT NO 117 BALANCE DEBIT CREDIT 300 NOV 30 Bat POST REF DEBIT OG ACCOUNT Equipment 07 2020 ITEM OH DATE 9 Nov 30 Bal 10 CREDET ACCOUNT NO 120 BALANCE DEBIT CREDIT 265,000 HE 17 2020 CREDIT 19 ACCOUNT Accumulated Depreciation - Equipment 120 POST 121 ITEM DATE DEBIT REF 22 Nov 30 Bal 123 124 ACCOUNT NO 121 BALANCE DEBIT CREDIT 115.500 126 127 126 120 130 193 ACCOUNT Accounts Payable 2020 ITEM POST 133 DATE REF Noy 30 B 135 132 DEBIT CREDIT ACCOUNT NO 201 BALANCE DERIT CREDIT 3.433 lostructions oriental Conto Accounts GU Ledger AR SUD Paste Copy Format BIU INI THI M 110 B C D G H 150 ACCOUNT NO 203 BALANCE DEBIT CREDIT DEBIT CREDIT 149 ACCOUNT Refunds Payable 2020 POST 151 DATE ITEM REF 152 Nov 30 Bat 153 154 500 158 100 ACCOUNT Uneared Service Revenue 161 2020 ITEM POST 162 DATE REF 103 Nov 30 lat DEBAT CREDIT ACCOUNT NO 205 BALANCE DEBIT CREDIT 500 163 169 170 171 72 ACCOUNT Jake Walters, Capital 178 ITEM POST 175 DATE REF 175 Nov 30 Bal 170 177 2020 DEBIT CREDIT ACCOUNT NO 301 BALANCE DEBIT CREDIT 262.643 175 170 180 DEBIT CREDIT 182 183 ACCOUNT Jake Walters, Withdrawal 184 2020 POST ITEM 188 DATE REF 13 Ney 30 Bal 187 188 ACCOUNT NO HALANCE DEBIT CREDIT 112.000 110 191 Instructions Trombochon Chat of Accounts GU Ledger AR 0 A B G H 1 ACCOUNT 2020 DATE Now 30 Depreciation Expense ITEM POST REF sal DEBIT CREDIT ACCOUNT NO 505 BALANCE DEBIT CREDIT 38.500 ACCOUNT Insurance Expense 2020 POST DATE ITEM REF Now 30 Bal. DEBIT CREDIT ACCOUNT NO 507 BALANCE DEBIT CREDIT 3,500 ACCOUNT Office Supplies Expense 20xx POST ITEM DATE REF Nov 30 Bal DEBIT CREDIT ACCOUNT NO 508 BALANCE DEBIT CREDIT 3.280 ACCOUNT Salary Expense 2020 ITEM DATE 30HBRE POST REF DEBIT CREDIT ACCOUNT NO 509 BALANCE DEBIT CREDIT 37.500 Nov Format li 1 = . B D H ACCOUNT Rent Expense 2020 ITEM DATE Nov 20 Bal POST REF DEBIT CREDIT ACCOUNT NO 511 BALANCE DEBIT CREDIT 27,500 ACCOUNT Telephone Expense 2020 ITEM POST DATE REF Now 30 Bal DEBIT CREDIT ACCOUNT NO 512 BALANCE DEBIT CREDIT 4.770 ACCOUNT Uslities Expense 2020 POST ITEM DATE REF Nov 30 Bal IN DEBIT CREDIT ACCOUNT NO 513 BALANCE DEBIT CREDIT 6.725 ACCOUNT Miscellaneous Expense 2020 DATE ITEM POST REF Noy. 30 Bal DEBIT CREDIT ACCOUNT NO 525 BALANCE DEBIT CREDIT 3,465 ner H 8 E Accounts Payable Subsidiary Ledger ITEM POST REF DEBIT CCOUNT Lowes 2020 DATE ov 30 Bal CREDIT BALANCE DEBIT CREDIT 756 ROCOUNT 2020 DATE Lock Supply Cs TEM POST REF DEBIT CREDIT BALANCE CREDIT DEBIT 30 Bal 2,677 ACCOUNT 2020 ITEM DATE POST REF DEBET CREDIT BALANCE DEBIT CREDIT AOCOUNT 2020 DATE ITEM POST DEBIT REF CREDIT BALANCE CREDIT DEBIT ACCOUNT 2020 DATE TEM ITEM POST REF DEBIT CREDIT BALANCE DEBIT CREDIT H 8 E Accounts Payable Subsidiary Ledger ITEM POST REF DEBIT CCOUNT Lowes 2020 DATE ov 30 Bal CREDIT BALANCE DEBIT CREDIT 756 ROCOUNT 2020 DATE Lock Supply Cs TEM POST REF DEBIT CREDIT BALANCE CREDIT DEBIT 30 Bal 2,677 ACCOUNT 2020 ITEM DATE POST REF DEBET CREDIT BALANCE DEBIT CREDIT AOCOUNT 2020 DATE ITEM POST DEBIT REF CREDIT BALANCE CREDIT DEBIT ACCOUNT 2020 DATE TEM ITEM POST REF DEBIT CREDIT BALANCE DEBIT CREDIT - IWnLock & Key Work Sheet 2 Account Unad Trial Balance Debt Credit Adjustments Dobit Credit Adi Trustce Dob Credi Income Statement Dobil Crede Balance Sheet Debe Credit 8 Cash 7 Accounts Receivable Inventory Estimated Returns Inventory to Office Supplies 11 Prepaid urance 12 Far 13 Accum. DeprecioFou 14 Accounts Payable 15 Refund Payable 16 Lund Service Revue 17 kWater Cape 18 Jake War West 10 Service Revenue 20 a Rover 21 fas Decorated 2 Cont of Merchandise 2 Avertising 94 Desain 25 rawatan 2 Office Supplies par 27 Say Expense 25 Rent Expense 29 Telephone Expense 30 Uhr Expanse 21 Mincellaneous 2 TOTALS 33 NET INCOME (LO) 34 96 30 37 0 0 D 0 0 0 0 0 0 0 wwe Aky Income Statement Dec 2020 WAK ce Sheet Service Revenue CAN Me Gross San Pelu Awe Mat Sales Account Reca Une Service Total LCOME one To Current Talantes Owe There Ooperating an ng Eleponas Depression par Lace Free Office Supply Capente Salary RE Tone Copens cies Expand Moderne Tell Assets We key Salamattum Post-Closing TB AP sub WS Fin Statements AR sub 2 D E PAGE 37 CREDIT DATE 1-Dec General Journal Accounts & Explanation RENT EXPENSE CASH PAYMENT OF RENT CK#6287 PR 511 101 DEBIT 2175 2175 2 Dec PREPAID INSURANCE CASH PAYMENT OF ANNUAL INS CK #6288 117 101 1.967 1,967 3-Dec ACCOUNTS RECEIVABLE SERVICE REVENUE INV #601 FOR HOMEOWNER SAM MASON 105 401 2200 2200 4-Dec 3,700 ACCOUNTS RECEIVABLE SALES REVENUE COST OF MERCHANDISE SOLD INVENTORY INV #602 HASTINGS- NEW SAFE 105 401 501 110 1250 1250 620 5-Dec OFFICE SUPPLIES CASH CK 16289 115 TOT 620 NOSENSIBERARE 6-Dec INVENTORY ACCOUNTS PAYABLE 110 201 5500 5,500 525 258 7-Dec MISCELLANEOUS EXPENSE CASH UPS DELIVERY OF SUPPLIES FROM DEC 6 101 258 7-Dec CASH JAKE WALTERS, CAPITAL 101 301 8500 8500 8-Dec ESTIMATED RETURNS INVENTORY INVENTORY RETURN TO KEY SUPPLIES CO 112 110 500 500 8-Dec CASH UNEARNED REVENUE LOCKSMITH SERVICES 101 205 2,500 2.500 9.DocCASH SERVICE REVENUE UNLOCKED SAFE 101 401 1000 1000 + 49 DATE 9.Dec No Explanation EQUIPMENT ACCOUNTS PAYABLE NEW COMPUTER PAGE 30 ACREDIT PR 120 201 DEBIT 1867 1857 Gonction Chinn D E 54 2.200 101 405 501 110 2,200 10-Dec CASH SALES REVENUE COST OF MERCHANDISE SOLD INVENTORY SOLD 2 SAFES 56 57 BDO 800 011-Dec INVENTORY ACCOUNTS PAYABLE-BRINKS CO PURCHASED 5 NEW SAFES 110 201 4573 4.573 12-Dec. ESTIMATED RETURNS INVENTORY COST OF MERCHANDISE SOLD REFUNDS PAYABLE CUSTOMER RETURN OF ONE SAFE 112 501 203 525 475 1000 394 13-Dec TELEPHONE EXPENSE CASH CK #6290 512 101 394 14-Dec ACCOUNTS PAYABLE (5500 55) CASH (5500 x 0.01) CK6291 KEY SUPPLIES CO LESS DISCOUNT 201 101 5445 5445 ETE 1,500 14-Dec CASH SALES REVENUE SALES DISCOUNT FORFEITED NATHAN DEAN INV# 590 101 405 410 1470 30 14.351 15-Dec CASH SALES REVENUE COST OF MERCHANDISE SOLD INVENTORY CASH SALES DEC 1ST-15TH 101 405 501 110 14,351 4,783 4.783 5.825 16-Dec ACCOUNTS RECEIVABLE SALES REVENUE HASTINGS INV17602 105 405 1825 500 17-DOC ACCOUNTS PAYABLE CASH OFFICE DEPOT-CK06292 201 101 500 700 18-Dec ACCOUNTS RECEIVABLE SERVICE REVENUE LARRY CONTRACTOR 105 401 700 TD 19.DOC UTILITIES EXPENSE CASH 1792 513 101 1792 B89 SALES REVENUE FA B E CK # 6293 175 19-Dec MISCELLANEOUS EXPENSE CASH CK# 6294-DOMINOS PIZZA - OFFICE PARTY 525 101 175 8,350 20 Dec JAKE WALTERS, WITHDRAWAL CASH VACATION 311 101 8,350 ALLANISHISHES 120 25 Dec UTILITIES EXPENSE CASH CK# 6295 513 101 120 25-Dec ACCOUNTS PAYABLE CASH CK# 6296-BRINKS CO 201 101 2,500 2,500 26 Dec SALARY EXPENSE CASH 2,550 509 101 2,550 700 27-Dec CASH ACCOUNTS RECEIVABLE LARRY CONTRACTOR 101 105 700) HE 8,735 30-Dec CASH SALES REVENUE COST OF MERCHANDISE SOLD INVENTORY 101 405 501 110 8,735 2,784 2,784 O H ACCOUNT Cash 2020 ITEM DATE Nov 30 Bal DEC POST REF DEBIT CREDIT 5 ACCOUNT NO 101 BALANCE DEBIT CREDIT 154,831 152.756 150,789 150.169 6 7 2 2,175 1.067 15 5 620 258 10 8 5.500 2,500 149.911 158,411 160,911 165,911 9 1.00 2,200 13 394 14 5.445 14 15 1500! 14351 163.717 158.272 159 772 1174123 173,623 1741831 17 500 1792 019 19 175 8,350 20 25 25 120 26 2.500 2.550 163,00 163.186 160,688 9158, 136 158,836 1675ZE 27 -30 TOO 8,735 PER ACCOUNT Accounts Receivable 2020 ITEM POST DATE REF Nav 30 TL DEBIT CREDIT ACCOUNT NO 105 BULANCE DEBIT CREDIT 4,100 DEC 3 5006 4 2.200 3.700 1,825 10,000 10 18 700 12.533 22 700 11.833 H POST REF DEBIT ACCOUNT Inventory 2020 DATE ITEM Nov 30 IBA DEC 4 CREDIT ACCOUNT NO 110 BALANCE DEBIT CREDIT 46, 525 1.250 45,275 6 5,500 SOO 800 10 50.775 50.775 49.475 54,048 15 30 4783 49,265 46.481 2784 DESET CREDIT ACCOUNT Estimated Returns Inventory 2020 ITEM POST DATE REF Now 30 Bal. DEC 12 ACCOUNT NO 112 BALANCE DEBIT CREDIT 200 1.200 1,725 SOO 525 ACCOUNT 2020 DATE Office Supplies ITEM POST DEBIT CREDIT Now DEC 30 Bar 5 ACCOUNT NO 115 BALANCE DEBIT CREDIT 1.235 1.855 620 ACCOUNT Prepaid Insurance POST ITEM REF DATE DESIT CREDIT H ACCOUNT NO 117 BALANCE DEBIT CREDIT 300 2.267 30 Bal 16 97 Nov DEC 2 1967 3 99 DO ACCOUNT Equipment 2020 ITEM DATE Nov 30 B DEC 9 POST REF DEBIT CREDIT ACCOUNT NO 120 BALANCE DEBIT CREDIT 265.000 266.857 1.852 20 ACCOUNT 2020 Accumulated Depreciation - Equipment POST ITEM DEBIT REF DATE CREDIT ACCOUNT NO BALANCE DEBIT CREDIT 115.500 NON ACCOUNT Accounts Payable 2020 POST ITEM DATE REF NE 30 ON DEC 16 DEBIT CREDIT ACCOUNT NO 201 BALANCE DEBIT CREDIT 3.433 5.500 1857 1 8.833 1020 15.6 4.573 14 1445 9,918 2418 as Hatics 2500 Contacto BU GU edgen ACCOUNT 2020 DATE Refunds Payable ITEM POST REF DEBIT CREDIT ACCOUNT NO 203 BALANCE DEBIT CREDIT Nov 30 BAL DEC 12 500 1.500 1.000 DEBIT ACCOUNT Unearned Service Revenue 2020 POST ITEM DATE REF Nov 30 Bali DEC ACCOUNT NO 205 BALANCE DEBIT CREDIT CREDIT 3,000 DEBIT CREDIT ACCOUNT NO 301 BALANCE DEBIT CREDIT ACCOUNT Jake Walters, Capital POST ITEM DATE REF 115 Nov 30 Ball N 17 DEC 7 13 262643 271143 8SOO 175 179 180 18 182 ACCOUNT Jake Walter's Withdrawal 2020 ITEM POST DATE REF Nov 30 Bal DEC 20 DEBIT CREDIT ACCOUNT NO 311 BALANCE DEBIT CREDIT 112.000 8.350 JACINT 346 2 B D G H 3 ACCOUNT Service Revenue 2020 TEM DATE Now 30 Bar POST REF DEBIT CREDIT ACCOUNT NO 401 BALANCE DEBIT CREDIT 167,050 169,250 172,950 173,950 DEC 2,200 3.700 1.000 18 200 174,650 ACCOUNT Sales Revenue 2020 DATE ITEM NOW 30 Bad DEC 10 POST REF DEBIT CREDIT ACCOUNT NO 405 BALANCE DEBIT CREDIT 312.000 2,200 1.470 14 15 14,351 1.825 315.fo 316 570 330.924 222,746 341,481 16 30 8.735 ACCOUNT Sales Discounts Forfeited 2020 BATE POST TEM REF 30 BM DEC 14 DEBIT CREDIT ACCOUNT NO 410 BALANCE DEBIT GHEOIT 2450 2.480 10 B D E G H DEBIT CREDIT ACCOUNT Cost of Merchandise Sold 2020 POST ITEM DATE REF Nov. 30 Bal N DEC 4 ACCOUNT NO 501 BALANCE DEBIT CREDIT 145,687 10 1250 800 475 12 15 146,937 147.737 148,212 152.995 155,779 4,783 30 2,784 ACCOUNT Advertising Expense 8 2020 POST ITEM DATE REF NOW 30 Bal DEBIT CREDIT ACCOUNT NO 502 BALANCE DEBIT CREDIT 9,250 250 269 275 DATE DEBIT CREDIT 272 273 274 ACCOUNT Depreciation Expense 275 2020 POST 270 ITEM REF 277 Now 30 Bal 278 279 2.80 201 ACCOUNT NO SOS BALANCE DEBIT CREDIT 38,500 203 2A 235 ACCOUNT Insurance Expense 2020 POST DATE ITEM REF w Now 30 20 DEBIT CREDIT ACCOUNT NO 807 BALANCE DEBIT CREDIT 2.500 21 H ACCOUNT Office Supplies Expense 20cx POST ITEM DATE REF Nov. 30 Bal DEBIT CREDIT ACCOUNT NO 508 BALANCE DEBIT CREDIT 0 3.280 1 POST REF DEBIT ACCOUNT Salary Expense 2020 ITEM DATE INOV 30 Bal DEC 26 CREDIT ACCOUNT NO 509 BALANCE DEBIT CREDIT 371.500 2.550 10.050 3 ACCOUNT Rent Expense 2020 ITEM DATE 30 Bal POST REF DEBIT CREDIT ACCOUNT NO 511 BALANCE DEBET CREDIT 27.500 29.675 DEC 2.375 DEBIT CREDIT ACCOUNT Telephone Expense 2020 ITEM POST DATE REF Noy 30 Bal N DEC 13 ACCOUNT NO 512 BALANCE DEBETI CREDIT 4.770 5164 394 POST REF DEBIT CREDIT ACCOUNT Utilities Expense 2020 ITEM DATE Nov. 130 DEC 19 25 ACCOUNT NO 513 BALANCE DEBIT CREDIT 6,725 8,517 1,702 120 8,637 Ch ACOUNT Miscellaneous Expense 2020 POST ITEM DATE REF I'NON 30 Bar DEBIT CREDIZ ACCOUNT NO 525 BALANCE DEBIT CREDIT 3465 DEC 258 3.223 19 128 3,898 ACCOUNT 2020 DATE Income Summary POST ITEM ACCOUNTINO 999 BALANCE DEBIT CREDIT DEBILI GRE DET REF 363 370 37 DATE 1-Dec AGE RENT EXPENSE DEBIT 27 101 2015 PAYMENT OF RENT CK 27 2 Dec PREPAID INSURANCE CASH PAYMENT OF ANNUAL INS CK 230 117 101 1867 165 AR-SAMMASON SERVICEHEVENUE INVOT 105 4-Dec AR - HASTINGS SALES REVENUE COST OF MERCHANDISE SOLD INVENTORY INVB TE 110 620 5-Dec OFFICE SUPPLIES CASH CK 16289 1115 101 110 6-Dec INVENTORY AP-KEY SUPPLIES CO 7. Dec MISCELLANEOUS EXPENSE CASH UPS DELIVERY OF SUPPLIES FROM DECO 525 100 7-Dec CAH JAK: WALTERS, CAPITAL 501 502 8-Dec ESTIMATED RETURNS INVENTORY INVENTORY RETURN TO KEY SUPPLIES CO 112 110 552 H-Dec 2200 CASH UNEAHNEDTREVENUE LOCKSMITH SERVICES 2200 9-Dec CASH SERVICE REVENUE UNLOCKED SAFE 101 401 1000 9000 General DATE C EQUIPMENT AP-OFFICE DEPOT NEW COMPUTER 120 201 2200 101 005 2230 10-Dect CASH SALES REVENUE COST OF MERCHANDISE SOLD INVENTORY SOLD 2 SAFES 4573 11-Dec INVENTORY AP - BRINKS CO PURCHASED S NEW SAFES 201 12-Dec ESTIMATED RETURNS INVENTORY COST OF MERCHANDISELE OLD REFUNDS PAYABLE CUSTOMER RETURN OF ONE SAFE 301 AS 13-Dec TELEPHONE EXPENSE CASH CK 6280 101 14-Dec AP-KEY SUPPLES COT:500-55) CASH (5560 X 0:01 G231 LESS DISCOUNT 100 16-Dec CASH SALES REVENUE SALES DISCOUNT FORSLITED NATHAN DEAN INV590 101 400 310 1473 101 14.351 14.351 15-Dec CASH SALES REVENUE COST OF MERCHANDISE SOLD INVENTORY CASH SALES DEC 1ST-15TH 405 501 110 4,783 4.783 1,825 16-Dec AR - HASTINGS SALES REVENUE INV #602 105 405 1825 500 17-Dec AP - OFFICE DEPOT CASH CK#6292 201 101 500 700 18-Dec AR - LARRY CONTRACTOR SERVICE REVENUE LARRY CONTRACTOR 105 401 700 1792 19-Dec UTILITIES EXPENSE CASH CK # 6293 513 101 1.792 175 19-Dec MISCELLANEOUS EXPENSE CASH CK# 6294 - DOMINOS PIZZA - OFFICE PARTY 525 101 175 8,350 20-Dec JAKE WALTERS, WITHDRAWAL CASH VACATION 311 101 8,350 120 25-Dec UTILITIES EXPENSE CASH CK# 6295 513 101 120 2,500 25-Dec AP - BRINKS CO CASH CK# 6296 201 101 2,500 2.550 26-Dec SALARY EXPENSE CASH 509 101 2,550 27-Dec CASH AR - LARRY CONTRACTOR LARRY CONTRACTOR 101 105 700 700 8.735 8,735 30-Dec CASH SALES REVENUE COST OF MERCHANDISE SOLD INVENTORY 101 405 501 110 2.784 2,784 ITEM POST REF DET ACCOUNT Cash 2020 DATE Nov 30 Bl. DEC CREDIT ACCOUNT NO 03 BALANCE DEBIT CREDIT 154931 152750 150 2.115 1967 150.160 19911 7 8.500 8411 6011 . 2.500 1.000 1911 154,111 2.200 10 13 14 5.45 14 1500 163.717 136272 15.772 114123 173.623 14351 500 15 17 19 19 175 171.SE 120 2.500 153306 163156 16060 2.550 25 20 27 30 700 158 136 158.836 167.571 DEBIT CREDIT ACCOUNT Accounts Receivable 2000 POST DATE ITEM REF Nov 20 B DEC 3 2.200 3.700 ACCOUNT NO BALANCE DEBIT 4 100 6300 10.DO TO 0533 16 700 27 700 POST REF DEBIT ACCOUNT NO 10 BALANGE DEBIT 45.525 41273 ACCOUNT Inventory DATE ITEM Nov 30 DEC 4 6 . 10 11 15 5.500 50775 50.175 500 800 4.15 54048 4573 4780 2754 Estimated Returns Inventory ITEM POST REF DEBIT ACCOUNT 2020 DATE Nov 30 6 CREDIT ACCOUNT NO 112 BALANCE DEBIT CHEOIT 700 1.200 DEC 50 525 12 1. Office Supplies POST REF DEBIT ACCOUNT 2030 DATE NOV DEC 5 CREDIT ACCOUNT NO 115 HALANCE DET CREDIT 0.30 165 ACCOUNT Prepaid Insurance ITEM POST REF DEBIT CREDIT DATE Nov 30 DEC 2 ACCOUNT NO 117 BALANCE DEBIT CREOL 300 1967 2207 ACCOUNT Equipment ITEM POST REF DEBIT CREDIT DATE 30 ACCOUNT NO 120 BALANCE DEBIT CREDIT 265.000 DEC . AST 2017 ACCOUNT Accumulated Depreciation - Equipment 2020 ITEM POST DATE DEBIT REF Nov 30 B CREDIT ACCOUNT NO BALANCE DEBIT CREDIT 1150 ACCOUNT Accounts Payable ACCOUNT NO PALACE 201 DEBIT ACCOUNT Accounts Payable 2020 POST ITEM DATE REF Nov 20 B DEC 5 ACCOUNT NO 201 BALANCE DEBIT CREDIT CREDIT 5.500 3903 10790 11 4,573 17 500 9.90 2.458 sta 25 2.500 Refunds Payable ITEM POST REF ACCOUNT 2020 DATE Nov 30 DEC 12 ACCOUNT NO 200 BALANCE DEBIT CREDIT DEBIT CREDIT 1 000 DEBIT CREDIT ACCOUNT Uneamed Service Revenue 2020 ITEM POST DATE REF Nov 30 S DEC 8 ACCOUNT NO 206 BALANCE DEBIT CREDIT 500 3.000 2.500 ACCOUNT NO 301 BALANCE DEBIT CROT DESIT ACCOUNT Jake Walters, Capital POST DATE ITEM REF Nov 30 Bal DEC 7 CREDIT 8.500 2010 DEBIT CREDIT ACCOUNT Jake Walters. Withdrawal 2000 POST ITEM DATE REF Nov 30 M DEC 20 ACCOUNT NO 312 BALANCE DEBIT CREDIT 12000 120350 8.350 ACCOUNT 2020 DATE Service Revenue ITEM POST DES ACCOUNT NO 451 BALANCE DEBIT CREDIT POST REF DEBIT ACCOUNT Service Revenue 2020 ITEM DATE Now 30 Bal DEC CREDIT ACCOUNT NO BALANCE DEBIT CREDIT 700.250 172360 173.960 174.650 1000 700 POST REF DEBIT ACCOUNT Sales Revenue DATE ITEM 30 S DEC 10 CREDIT ACCOUNT NO 406 BALANCE DEBIT CREDIT 312.900 315.100 3150 33.925 332.74 341481 SE35 15 16 30 ACCOUNT 2020 DATE Now 30 DEC Sales Discounts Forened ITEM POST REF DEBIT ACCOUNT NO 410 BALANCE DEBIT CREDIT 2.450 2.480 ACCOUNT Cost of Merchandise Sold ITEM POST REF DEBIT CREDIT DATE Now 30 DEC 4 10 1.250 800 ACCOUNT NO 501 BALANCE DEBIT CREDIT AST 148937 147727 148.212 15:05 15 30 4.783 2.754 155.779 ACCOUNT Advertising Experise ACCOUNT NO DATE ITEM DEBIT CREDIT ACCOUNT ACCOUNT ANS POST REF DET DATE ACCOUNT ACCOUNT 00 DATE Insurance Expense POST DERIT CREDIT ACCOUNT Office Supplies Expense PODE AGOON DANCE DET CREDIT DATE ACCOUNT Salary Espen ACCOUNT MAUNGE POST REF DET CREAT DATE T500 DEC ACCOUNT ACCOUNTINO Reports ITEM POST DATE DEST DEO ACCOUNT ACCOUNT Telephone ITEM DES REF DATE 30 INCOTAT ACCOUNT POST REF DEBIT ACCOUNT Utilities Expense 2020 ITEM DATE Nov. 30 Bal. DEC 19 CREDIT ACCOUNT NO 513 BALANCE DEBIT CREDIT 6,725 8,517 1,792 25 120 8,637 DEBIT CREDIT ACCOUNT Miscellaneous Expense 2020 POST ITEM DATE REF Nov. 30 Bal. DEC 7 ACCOUNT NO 525 BALANCE DEBIT CREDIT 3,465 3,723 258 19 1751 3,898 999 ACCOUNT 2020 DATE Income Summary ITEM POST REF DEBIT CREDIT ACCOUNT NO BALANCE DEBIT CREDIT POST REF DEBIT CREDIT ACCOUNT: Nathan Dean 2020 ITEM DATE Nov 30 Bal DEC 14 NATHAN DEAN BALANCE CREDIT DEBIT 2.675 1.500 1,500 Jillian Roberts ACCOUNT: 2020 DATE ITEM POST REF DEBIT CREDIT BALANCE CREDIT DEBIT Nov 30 Bal 1.433 POST REF DEBIT CREDIT DEBIT ACCOUNT Larry Contractor 2020 ITEM DATE Nov 30 Bal DEC 18 27 BALANCE CREDIT 0 700 0 700 700 SAM MASON ACCOUNT 2020 DATE ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 2,000 DEC 3 2,000 HASTINGS ACCOUNT 2020 DATE ITEM POST REF DEBIT CREDIT BALANCE CREDIT DEBIT DEC 3,700 3.700 16 1.825 1.875 ACCOUNT Lowes 2020 DATE Nov 30 Bal ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 756 ACCOUNT: Lock Supply Co 2020 DATE ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 2.677 Nov 30 Bal. KEY SUPPLIES CO ACCOUNT: 2020 DATE ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 5,500 DEC 6 5.500 14 5,445 5,445 BRINKS CO ACCOUNT 2020 DATE ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 4.573 DEC 11 4,573 OFFICE DEPOT ACCOUNT: 2020 DATE DEC ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 1.857 9 1,857 17 500 1,357 DATE CREDIT AGE RENT EXPENSE DEBI 27 PAYMENT OF RENT CK 27 2 Dec PREPAID INSURANCE CASH PAYMENT OF ANNUAL INS CK 230 117 101 2200 3-Dec ARSAM MASON SERVICEHEVENUE INVOT BELLISEL 4-Dec AR - HASTINGS SALES REVENUE COST OF MERCHANDISE SOLD INVENTORY INV 110 OFFICE SUPPLIES CASH CK 16289 115 101 6-Dec INVENTORY AP-KEY SUPPLIESTCO 20 7 Dec MISCELLANEOUS EXPENSE CASH UPS DELIVERY OF SUPPLIES FROM DECO 525 100 7-Dec CAH JAKE WALTERS, CAPITAL 198 500 8-Dec ESTIMATED RETURNS INVENTORY INVENTORY RETURN TO KEY SUPPLIES CO 112 110 500 101 2800 H-Dec CASH UNLAHNEDTREVENUE LOCKSMITH SERVICES 9-Dec CASH SERVICE REVENUE UNLOCKED SAFE 101 401 1000 9000 Geral PAGE GATE SUBC EQUIPMENT AP-OFFICE DEPOT NEW COMPUTER TU 201 2200 101 105 2230 10-Dec1 CASH SALES REVENUE COST OF MERCHANDISE SOLD INVENTORY SOLD 2 SAFES 00 BUITEN 4575 11-Dec INVENTORY AP - BRINKS CO PURCHASED 5 NEW SAFES 110 201 12-Dec ESTIMATED RETURNS INVENTORY CUSTOF MERCHANDISE SOLD REFUNDS PAYABLE CUSTOMER RETURN OF ONE SAFE 390 13-Dec TELEPHONE EXPENSE CASH CK BOZO 512 101 14.DC AP-KEY SUPPLIES COT500-657 CASH (6560 X 0.011 LESS DISCOUNT 100 18-Dec CASH SALES REVENUE SALES DISCOUNT FOR LITED NATHAN DEAN INV500 103 400 31 1473 ITEM POST REF DET CREDIT ACCOUNT Cash 2020 DATE Nov 30 B DEC 1 2 ACCOUNT NO SOS BALANCE DEBIT CREDIT 154.93 2175 1.967 620 150 150.160 19911 7 B. 411 6011 2.500 1.000 1911 10 2.200 154,111 182.17 394 5.45 18272 14 14 1500 15.772 174123 14351 15 17 19 500 173.625 17131 1719 19 175 120 2.500 25 25 20 27 153306 163156 1606 15 16 158.00 167.571 2550 700 2.735 Accounts Receivable ITEM POST REF DEBIT ACCOUNT 2006 DATE Nov 20 DEC 3 CREDIT ACCOUNT NO BALANCE DEBIT 4 100 6300 10.00 TRU 2,200 3.700 25 700 533 27 200 POST REF DEBIT ACCOUNT Inventory 2000 DATE ITEM Nov 30 DEC CREDIT ACCOUNT NO 110 BALANCE DEBIT CREDIT 45.525 61271 50.775 50.175 4.415 54048 5.500 500 800 10 11 4573 4780 40.265 15 20 Estimated Returns Inventory ITEM POST REF DEBIT ACCOUNT 2020 DATE Nov 20 $ CREDIT ACCOUNT NO 112 BALANCE DET CHEOIT 700 1.200 DEC 590 12 525 1. Office Supplies ACCOUNT 2030 DATE POST ACCOUNT NO 115 PALANCE DEUT CREDIT DEBIT CREDIT DEC 5 070 1.55 ACCOUNT Prepaid insurance ITEM POST REF DEBIT CREDIT DATE Nov 30 DEC 2 ACCOUNT NO 117 BALANCE DEBIT CREDIT 300 1967 227 ACCOUNT Equipment ITEM POST REF DEBIT CREDIT DATE Nov ACCOUNT NO 120 BALANCE DEBIT CREDIT 205.000 2017 DEC . AST ACCOUNT 2020 DATE Nov 30 Accumulated Depreciation - Equipment POST ITEM DEBIT REF CREDIT AOCOUNT NO BALANCE DEBIT CREDIT 1150 ACCOUNT Accounts Payable 201 ACCOUNT NO PATATE POST REF DEBIT CREDIT ACCOUNT Nathan Dean 2020 DATE ITEM Nov 30 Bal DEC 14 NATHAN DEAN BALANCE CREDIT DEBIT 2.675 1,500 1,500 Jillian Roberts ACCOUNT 2020 DATE ITEM POST REF DEBIT CREDIT BALANCE CREDIT DEBIT Nov 30 Bal 1.433 POST REF DEBIT CREDIT BALANCE CREDIT DEBIT ACCOUNT: Larry Contractor 2020 ITEM DATE Nov 30 Bal. DEC 18 27 0 700 700 700 0 SAM MASON ACCOUNT 2020 DATE ITEM POST REF DEBIT CREDIT BALANCE CREDIT DEBIT DEC 3 2,000 2,000 HASTINGS ACCOUNT 2020 DATE ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 3.700 DEC 4 3,700 16 1,825 1.875 ACCOUNT Lowes 2020 DATE Nov 30 Bal. ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 756 ACCOUNT: Lock Supply Co 2020 DATE ITEM POST REF DEBIT CREDIT BALANCE CREDIT DEBIT Nov 30 Bal 2,677 KEY SUPPLIES CO ACCOUNT 2020 DATE ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 5,500 DEC 6 5,500 14 5,445 5,445 BRINKS CO ACCOUNT 2020 DATE ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 4,573 DEC 11 4,573 OFFICE DEPOT ACCOUNT 2020 DATE DEC ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 1,857 9 1,857 17 500 1,357 ACCT 2301 - JW's Lock & Key Background JW's Lock & Key is owned and operated by Jake Walters and is located in Odessa, TX. Jake is a locksmith and provides locksmith services and has a store that ses everything from keys to safes. You have just been hired as the accountant as of December 1, 2020 Required 1. The general ledger contains the current balances for all accounts as of November 30, 2020. The subsidiary ledgers for A'R and A/P also contain the current balances as of November 30, 2020. Review the information in these accounts before beginning the project. Do NOT delete these balances. You need them. 2. Journaize the December transactions in the general journal. Descriptions are not required. Be sure that the account names used are the same as on the Chart of Accounts tab and the customer or vendor name are included in AR & AP transactions (ex: AP. Brinks Co.) Also, be sure to indent credit entries and note the account numbers in the Post Reference column 3. Post daily to the Accounts Receivable Subsidiary Lodger and the Accounts Payable Subsidiary Ledger Place a checkmark in the Post Reference column of the General Ledger next to the GL account number; i 2018. The checkmark denotos that you have posted to the Subsidiary Ledger account. On December 31, poat to the General Ledger 4. Prepare an Unadjusted Trial Balance using the worksheet Complete the worksheet using the following adjustment information for December Office supplios on hand on December 31 are $1,338 A physical count of inventory showed an ending inventory cost of $44.500 Recorded depreciation on equiment for the month $4200 insurance expired during December is $300 Eamed $2,457 worth of the unearned service revenue Sales refunds estimated for the year $10,000 Conto estimated returns for the year $2,000 S. Journalize and post the ADJUSTING entries in the GJ Ledger and subsidiary lodgers. Journalize and post the CLOSING entries in the GJ, Ledger and subsidiary lodgers. 7. Prepare JWs Lock & Key's financial statements for the year ended December 31, 2020. The breakouts on the Chart of Accounts may help categorizing and making sure all accounts are used on the financial statements. Additionally, please ensure to use the proper formatting indentation underlines, S signs, etc.) Note: Jake Walter's Capital at December 1, 2020 was $262,643 8. Prepare a Post-Closing Trial Balance Check Figures Unadjusted Trial Balance: 911,822 Cash Account Balance: 168,891 Net Income (Loss): 205,092 9. Be sure that all entries, the worksheet financial statements and the post-closing trial balance have been dated Dec. 1 Pald December's rent, check 1 6287 $2,175. 2 Paid annual premiums on property and casually insurance policies, check # 6288. $1,967. 3 Performed locksmith services on new house, sent involoe #601 to the homeowner, Sam Mason, $2,200. 4 Issued Invoice #602 to Hastings who purchased a new safe on account, $3.700. Cost of Merchandise Sold was $1,250. 5 Purchased office supplies, check #6289. 8620 6 Purchased inventory from Key Supplies Co., $6.500, tors 1/10, n/30 7 Pald UPS $258 cash for delivery of the inventory purchased on December 6. 7 Jake deposited an additional $8.500 cash in the business 8 Retumed damaged inventory to Kay Supplies Co., $500 8 Received $2.500 cash, an advance payment for locksmith services. 9 Unlocked a safe for a customer and received $1,000 cash, Bought a new comouter equipment) ftom Office Depot on account, 31.857A 10 Sold 2 safes and teceled cash. 2.200. Cost of Merchandise Sold was $800. 11 Purchased 5 sates to restock inventory on account from Brinks Co $4.573 tams, 2/5. n/45 12 Customer retumed one of the safes purchased on December 10, rotunded the customer $1.000 cash Cost of Merchandise Sold was $475 13 Paid Verizon for wireless telephone services $394. check 6290. 14 Paid Key Supplies Go for the purchase on December 6, less retum and discount, check 5291. 14 Received cash on account, $1,500. From Nathan Dean, Dean did not pay his November invoice #590 within the crede terms 2/10. The discount was forfeited 15 Recorded cash sales for the store from the 1st to the 15th. $14.351. Cost of Merchandise Sold was $4.783 16 Received $1.825 from Hastings on account 17 Paid Office Depot on account, $500, check # 6292 15 18 Performed locksmith services on account for Larry Contractor $700. 17 19 Paid electricity bid for December, check # 6293. $1,792 49 19 Paid for Domino's pizza delivery for the December office party, check #6294 $175 51 20 Jake withdrew $8,350 for a vacation 53 25 Paid the water ble for December, check # 6295, $120. 25 Paid Beinks Co. on account, $2,500, check 6296. 57 26 Paid part time employees the salary, $2.550 59 27 Received cash on account from Larry Contractor. $700. 51 30 Recorded cash sales for the store from the 16th to the 30th, 435. Cost of Merchandise Sold was $2.784 63 64 66 66 67 The 53 vu The adjustment data for December is as follows: a. b. C. d. Office supplies on hand on December 31 are $1,338. A physical count of inventory showed an ending inventory cost of $44,500. Recorded depreciation on equipment for the month, $4,200. Insurance expired during December is $300. Eamed $2,457 worth of the uneamed service revenue. Sales refunds estimated for the year $10,000 Cost of estimated retums for the year $2,000 e. 1. g. JW's Lock & Key Chart of Accounts 201 203 205 Liabilities Accounts Payable Refunds Payable Uneamed Service Revenue Assets 101 Cash 105 Accounts Receivable 110 Inventory 112 Estimated Returns Inventory 115 Office Supplies 117 Prepaid Insurance 120 Equipment 121 Accum. Depreciation - Equipment 301 311 Owner's Equity Jake Walters, Capital Jake Walters, Withdrawal 401 405 410 Revenues Service Revenue Sales Revenue Sales Discounts Forfeited Expenses 501 Cost of Merchandise Sold 502 Advertising Expense 505 Depreciation Expense 507 Insurance Expense 508 Office Supplies Expense 509 Salary Expense 511 Rent Expense 512 Telephone Expense 513 Utilities Expenso 525 Miscellaneous Expense Other Misc Income Summary 999 B H Cash ACCOUNT 2020 DATE ITEM POST REF DEBIT CREDIT ACCOUNT NO 101 BALANCE DEBIT CREDIT 154,931 Nov 30 Bat 105 ACCOUNT Accounts Receivable 2020 ITEM POST DATE REF Noy 30 Bal DEBIT CREDIT ACCOUNT NO BALANCE DEBIT CREDIT 4.108 Instruction Triations Oran of Account GJ Ledger AR sub Ready H POST RER DEBIT ACCOUNT Inventory 2020 ITEM DATE Noy 30. Bal CREDIT ACCOUNT NO 110 BALANCE DEBIT CREDIT 46,525 ACCOUNT Estimated Returns Inventory 2020 POST ITEM DATE REF Nov 30 Bal DEBIT CREDIT ACCOUNT NO 112 BAEANCE DEBIT CREDIT 700 ACCOUNT 2020 DATE NON 30 Office Supplies ITEM DEBIT POSTI REF u CREDIT ACCOUNT NO 115 BALANCE DEBIT CREDIT 1235 Bat Instructions Thansadena Chor or Accounts ell Ledger ARS 110 B G H 3 ACCOUNT 4 2020 DATE 0 E Prepaid Insurance ITEM POST REF DEBIT CREDIT ACCOUNT NO 117 BALANCE DEBIT CREDIT 300 NOV 30 Bat POST REF DEBIT OG ACCOUNT Equipment 07 2020 ITEM OH DATE 9 Nov 30 Bal 10 CREDET ACCOUNT NO 120 BALANCE DEBIT CREDIT 265,000 HE 17 2020 CREDIT 19 ACCOUNT Accumulated Depreciation - Equipment 120 POST 121 ITEM DATE DEBIT REF 22 Nov 30 Bal 123 124 ACCOUNT NO 121 BALANCE DEBIT CREDIT 115.500 126 127 126 120 130 193 ACCOUNT Accounts Payable 2020 ITEM POST 133 DATE REF Noy 30 B 135 132 DEBIT CREDIT ACCOUNT NO 201 BALANCE DERIT CREDIT 3.433 lostructions oriental Conto Accounts GU Ledger AR SUD Paste Copy Format BIU INI THI M 110 B C D G H 150 ACCOUNT NO 203 BALANCE DEBIT CREDIT DEBIT CREDIT 149 ACCOUNT Refunds Payable 2020 POST 151 DATE ITEM REF 152 Nov 30 Bat 153 154 500 158 100 ACCOUNT Uneared Service Revenue 161 2020 ITEM POST 162 DATE REF 103 Nov 30 lat DEBAT CREDIT ACCOUNT NO 205 BALANCE DEBIT CREDIT 500 163 169 170 171 72 ACCOUNT Jake Walters, Capital 178 ITEM POST 175 DATE REF 175 Nov 30 Bal 170 177 2020 DEBIT CREDIT ACCOUNT NO 301 BALANCE DEBIT CREDIT 262.643 175 170 180 DEBIT CREDIT 182 183 ACCOUNT Jake Walters, Withdrawal 184 2020 POST ITEM 188 DATE REF 13 Ney 30 Bal 187 188 ACCOUNT NO HALANCE DEBIT CREDIT 112.000 110 191 Instructions Trombochon Chat of Accounts GU Ledger AR 0 A B G H 1 ACCOUNT 2020 DATE Now 30 Depreciation Expense ITEM POST REF sal DEBIT CREDIT ACCOUNT NO 505 BALANCE DEBIT CREDIT 38.500 ACCOUNT Insurance Expense 2020 POST DATE ITEM REF Now 30 Bal. DEBIT CREDIT ACCOUNT NO 507 BALANCE DEBIT CREDIT 3,500 ACCOUNT Office Supplies Expense 20xx POST ITEM DATE REF Nov 30 Bal DEBIT CREDIT ACCOUNT NO 508 BALANCE DEBIT CREDIT 3.280 ACCOUNT Salary Expense 2020 ITEM DATE 30HBRE POST REF DEBIT CREDIT ACCOUNT NO 509 BALANCE DEBIT CREDIT 37.500 Nov Format li 1 = . B D H ACCOUNT Rent Expense 2020 ITEM DATE Nov 20 Bal POST REF DEBIT CREDIT ACCOUNT NO 511 BALANCE DEBIT CREDIT 27,500 ACCOUNT Telephone Expense 2020 ITEM POST DATE REF Now 30 Bal DEBIT CREDIT ACCOUNT NO 512 BALANCE DEBIT CREDIT 4.770 ACCOUNT Uslities Expense 2020 POST ITEM DATE REF Nov 30 Bal IN DEBIT CREDIT ACCOUNT NO 513 BALANCE DEBIT CREDIT 6.725 ACCOUNT Miscellaneous Expense 2020 DATE ITEM POST REF Noy. 30 Bal DEBIT CREDIT ACCOUNT NO 525 BALANCE DEBIT CREDIT 3,465 ner H 8 E Accounts Payable Subsidiary Ledger ITEM POST REF DEBIT CCOUNT Lowes 2020 DATE ov 30 Bal CREDIT BALANCE DEBIT CREDIT 756 ROCOUNT 2020 DATE Lock Supply Cs TEM POST REF DEBIT CREDIT BALANCE CREDIT DEBIT 30 Bal 2,677 ACCOUNT 2020 ITEM DATE POST REF DEBET CREDIT BALANCE DEBIT CREDIT AOCOUNT 2020 DATE ITEM POST DEBIT REF CREDIT BALANCE CREDIT DEBIT ACCOUNT 2020 DATE TEM ITEM POST REF DEBIT CREDIT BALANCE DEBIT CREDIT H 8 E Accounts Payable Subsidiary Ledger ITEM POST REF DEBIT CCOUNT Lowes 2020 DATE ov 30 Bal CREDIT BALANCE DEBIT CREDIT 756 ROCOUNT 2020 DATE Lock Supply Cs TEM POST REF DEBIT CREDIT BALANCE CREDIT DEBIT 30 Bal 2,677 ACCOUNT 2020 ITEM DATE POST REF DEBET CREDIT BALANCE DEBIT CREDIT AOCOUNT 2020 DATE ITEM POST DEBIT REF CREDIT BALANCE CREDIT DEBIT ACCOUNT 2020 DATE TEM ITEM POST REF DEBIT CREDIT BALANCE DEBIT CREDIT - IWnLock & Key Work Sheet 2 Account Unad Trial Balance Debt Credit Adjustments Dobit Credit Adi Trustce Dob Credi Income Statement Dobil Crede Balance Sheet Debe Credit 8 Cash 7 Accounts Receivable Inventory Estimated Returns Inventory to Office Supplies 11 Prepaid urance 12 Far 13 Accum. DeprecioFou 14 Accounts Payable 15 Refund Payable 16 Lund Service Revue 17 kWater Cape 18 Jake War West 10 Service Revenue 20 a Rover 21 fas Decorated 2 Cont of Merchandise 2 Avertising 94 Desain 25 rawatan 2 Office Supplies par 27 Say Expense 25 Rent Expense 29 Telephone Expense 30 Uhr Expanse 21 Mincellaneous 2 TOTALS 33 NET INCOME (LO) 34 96 30 37 0 0 D 0 0 0 0 0 0 0 wwe Aky Income Statement Dec 2020 WAK ce Sheet Service Revenue CAN Me Gross San Pelu Awe Mat Sales Account Reca Une Service Total LCOME one To Current Talantes Owe There Ooperating an ng Eleponas Depression par Lace Free Office Supply Capente Salary RE Tone Copens cies Expand Moderne Tell Assets We key Salamattum Post-Closing TB AP sub WS Fin Statements AR sub 2 D E PAGE 37 CREDIT DATE 1-Dec General Journal Accounts & Explanation RENT EXPENSE CASH PAYMENT OF RENT CK#6287 PR 511 101 DEBIT 2175 2175 2 Dec PREPAID INSURANCE CASH PAYMENT OF ANNUAL INS CK #6288 117 101 1.967 1,967 3-Dec ACCOUNTS RECEIVABLE SERVICE REVENUE INV #601 FOR HOMEOWNER SAM MASON 105 401 2200 2200 4-Dec 3,700 ACCOUNTS RECEIVABLE SALES REVENUE COST OF MERCHANDISE SOLD INVENTORY INV #602 HASTINGS- NEW SAFE 105 401 501 110 1250 1250 620 5-Dec OFFICE SUPPLIES CASH CK 16289 115 TOT 620 NOSENSIBERARE 6-Dec INVENTORY ACCOUNTS PAYABLE 110 201 5500 5,500 525 258 7-Dec MISCELLANEOUS EXPENSE CASH UPS DELIVERY OF SUPPLIES FROM DEC 6 101 258 7-Dec CASH JAKE WALTERS, CAPITAL 101 301 8500 8500 8-Dec ESTIMATED RETURNS INVENTORY INVENTORY RETURN TO KEY SUPPLIES CO 112 110 500 500 8-Dec CASH UNEARNED REVENUE LOCKSMITH SERVICES 101 205 2,500 2.500 9.DocCASH SERVICE REVENUE UNLOCKED SAFE 101 401 1000 1000 + 49 DATE 9.Dec No Explanation EQUIPMENT ACCOUNTS PAYABLE NEW COMPUTER PAGE 30 ACREDIT PR 120 201 DEBIT 1867 1857 Gonction Chinn D E 54 2.200 101 405 501 110 2,200 10-Dec CASH SALES REVENUE COST OF MERCHANDISE SOLD INVENTORY SOLD 2 SAFES 56 57 BDO 800 011-Dec INVENTORY ACCOUNTS PAYABLE-BRINKS CO PURCHASED 5 NEW SAFES 110 201 4573 4.573 12-Dec. ESTIMATED RETURNS INVENTORY COST OF MERCHANDISE SOLD REFUNDS PAYABLE CUSTOMER RETURN OF ONE SAFE 112 501 203 525 475 1000 394 13-Dec TELEPHONE EXPENSE CASH CK #6290 512 101 394 14-Dec ACCOUNTS PAYABLE (5500 55) CASH (5500 x 0.01) CK6291 KEY SUPPLIES CO LESS DISCOUNT 201 101 5445 5445 ETE 1,500 14-Dec CASH SALES REVENUE SALES DISCOUNT FORFEITED NATHAN DEAN INV# 590 101 405 410 1470 30 14.351 15-Dec CASH SALES REVENUE COST OF MERCHANDISE SOLD INVENTORY CASH SALES DEC 1ST-15TH 101 405 501 110 14,351 4,783 4.783 5.825 16-Dec ACCOUNTS RECEIVABLE SALES REVENUE HASTINGS INV17602 105 405 1825 500 17-DOC ACCOUNTS PAYABLE CASH OFFICE DEPOT-CK06292 201 101 500 700 18-Dec ACCOUNTS RECEIVABLE SERVICE REVENUE LARRY CONTRACTOR 105 401 700 TD 19.DOC UTILITIES EXPENSE CASH 1792 513 101 1792 B89 SALES REVENUE FA B E CK # 6293 175 19-Dec MISCELLANEOUS EXPENSE CASH CK# 6294-DOMINOS PIZZA - OFFICE PARTY 525 101 175 8,350 20 Dec JAKE WALTERS, WITHDRAWAL CASH VACATION 311 101 8,350 ALLANISHISHES 120 25 Dec UTILITIES EXPENSE CASH CK# 6295 513 101 120 25-Dec ACCOUNTS PAYABLE CASH CK# 6296-BRINKS CO 201 101 2,500 2,500 26 Dec SALARY EXPENSE CASH 2,550 509 101 2,550 700 27-Dec CASH ACCOUNTS RECEIVABLE LARRY CONTRACTOR 101 105 700) HE 8,735 30-Dec CASH SALES REVENUE COST OF MERCHANDISE SOLD INVENTORY 101 405 501 110 8,735 2,784 2,784 O H ACCOUNT Cash 2020 ITEM DATE Nov 30 Bal DEC POST REF DEBIT CREDIT 5 ACCOUNT NO 101 BALANCE DEBIT CREDIT 154,831 152.756 150,789 150.169 6 7 2 2,175 1.067 15 5 620 258 10 8 5.500 2,500 149.911 158,411 160,911 165,911 9 1.00 2,200 13 394 14 5.445 14 15 1500! 14351 163.717 158.272 159 772 1174123 173,623 1741831 17 500 1792 019 19 175 8,350 20 25 25 120 26 2.500 2.550 163,00 163.186 160,688 9158, 136 158,836 1675ZE 27 -30 TOO 8,735 PER ACCOUNT Accounts Receivable 2020 ITEM POST DATE REF Nav 30 TL DEBIT CREDIT ACCOUNT NO 105 BULANCE DEBIT CREDIT 4,100 DEC 3 5006 4 2.200 3.700 1,825 10,000 10 18 700 12.533 22 700 11.833 H POST REF DEBIT ACCOUNT Inventory 2020 DATE ITEM Nov 30 IBA DEC 4 CREDIT ACCOUNT NO 110 BALANCE DEBIT CREDIT 46, 525 1.250 45,275 6 5,500 SOO 800 10 50.775 50.775 49.475 54,048 15 30 4783 49,265 46.481 2784 DESET CREDIT ACCOUNT Estimated Returns Inventory 2020 ITEM POST DATE REF Now 30 Bal. DEC 12 ACCOUNT NO 112 BALANCE DEBIT CREDIT 200 1.200 1,725 SOO 525 ACCOUNT 2020 DATE Office Supplies ITEM POST DEBIT CREDIT Now DEC 30 Bar 5 ACCOUNT NO 115 BALANCE DEBIT CREDIT 1.235 1.855 620 ACCOUNT Prepaid Insurance POST ITEM REF DATE DESIT CREDIT H ACCOUNT NO 117 BALANCE DEBIT CREDIT 300 2.267 30 Bal 16 97 Nov DEC 2 1967 3 99 DO ACCOUNT Equipment 2020 ITEM DATE Nov 30 B DEC 9 POST REF DEBIT CREDIT ACCOUNT NO 120 BALANCE DEBIT CREDIT 265.000 266.857 1.852 20 ACCOUNT 2020 Accumulated Depreciation - Equipment POST ITEM DEBIT REF DATE CREDIT ACCOUNT NO BALANCE DEBIT CREDIT 115.500 NON ACCOUNT Accounts Payable 2020 POST ITEM DATE REF NE 30 ON DEC 16 DEBIT CREDIT ACCOUNT NO 201 BALANCE DEBIT CREDIT 3.433 5.500 1857 1 8.833 1020 15.6 4.573 14 1445 9,918 2418 as Hatics 2500 Contacto BU GU edgen ACCOUNT 2020 DATE Refunds Payable ITEM POST REF DEBIT CREDIT ACCOUNT NO 203 BALANCE DEBIT CREDIT Nov 30 BAL DEC 12 500 1.500 1.000 DEBIT ACCOUNT Unearned Service Revenue 2020 POST ITEM DATE REF Nov 30 Bali DEC ACCOUNT NO 205 BALANCE DEBIT CREDIT CREDIT 3,000 DEBIT CREDIT ACCOUNT NO 301 BALANCE DEBIT CREDIT ACCOUNT Jake Walters, Capital POST ITEM DATE REF 115 Nov 30 Ball N 17 DEC 7 13 262643 271143 8SOO 175 179 180 18 182 ACCOUNT Jake Walter's Withdrawal 2020 ITEM POST DATE REF Nov 30 Bal DEC 20 DEBIT CREDIT ACCOUNT NO 311 BALANCE DEBIT CREDIT 112.000 8.350 JACINT 346 2 B D G H 3 ACCOUNT Service Revenue 2020 TEM DATE Now 30 Bar POST REF DEBIT CREDIT ACCOUNT NO 401 BALANCE DEBIT CREDIT 167,050 169,250 172,950 173,950 DEC 2,200 3.700 1.000 18 200 174,650 ACCOUNT Sales Revenue 2020 DATE ITEM NOW 30 Bad DEC 10 POST REF DEBIT CREDIT ACCOUNT NO 405 BALANCE DEBIT CREDIT 312.000 2,200 1.470 14 15 14,351 1.825 315.fo 316 570 330.924 222,746 341,481 16 30 8.735 ACCOUNT Sales Discounts Forfeited 2020 BATE POST TEM REF 30 BM DEC 14 DEBIT CREDIT ACCOUNT NO 410 BALANCE DEBIT GHEOIT 2450 2.480 10 B D E G H DEBIT CREDIT ACCOUNT Cost of Merchandise Sold 2020 POST ITEM DATE REF Nov. 30 Bal N DEC 4 ACCOUNT NO 501 BALANCE DEBIT CREDIT 145,687 10 1250 800 475 12 15 146,937 147.737 148,212 152.995 155,779 4,783 30 2,784 ACCOUNT Advertising Expense 8 2020 POST ITEM DATE REF NOW 30 Bal DEBIT CREDIT ACCOUNT NO 502 BALANCE DEBIT CREDIT 9,250 250 269 275 DATE DEBIT CREDIT 272 273 274 ACCOUNT Depreciation Expense 275 2020 POST 270 ITEM REF 277 Now 30 Bal 278 279 2.80 201 ACCOUNT NO SOS BALANCE DEBIT CREDIT 38,500 203 2A 235 ACCOUNT Insurance Expense 2020 POST DATE ITEM REF w Now 30 20 DEBIT CREDIT ACCOUNT NO 807 BALANCE DEBIT CREDIT 2.500 21 H ACCOUNT Office Supplies Expense 20cx POST ITEM DATE REF Nov. 30 Bal DEBIT CREDIT ACCOUNT NO 508 BALANCE DEBIT CREDIT 0 3.280 1 POST REF DEBIT ACCOUNT Salary Expense 2020 ITEM DATE INOV 30 Bal DEC 26 CREDIT ACCOUNT NO 509 BALANCE DEBIT CREDIT 371.500 2.550 10.050 3 ACCOUNT Rent Expense 2020 ITEM DATE 30 Bal POST REF DEBIT CREDIT ACCOUNT NO 511 BALANCE DEBET CREDIT 27.500 29.675 DEC 2.375 DEBIT CREDIT ACCOUNT Telephone Expense 2020 ITEM POST DATE REF Noy 30 Bal N DEC 13 ACCOUNT NO 512 BALANCE DEBETI CREDIT 4.770 5164 394 POST REF DEBIT CREDIT ACCOUNT Utilities Expense 2020 ITEM DATE Nov. 130 DEC 19 25 ACCOUNT NO 513 BALANCE DEBIT CREDIT 6,725 8,517 1,702 120 8,637 Ch ACOUNT Miscellaneous Expense 2020 POST ITEM DATE REF I'NON 30 Bar DEBIT CREDIZ ACCOUNT NO 525 BALANCE DEBIT CREDIT 3465 DEC 258 3.223 19 128 3,898 ACCOUNT 2020 DATE Income Summary POST ITEM ACCOUNTINO 999 BALANCE DEBIT CREDIT DEBILI GRE DET REF 363 370 37 DATE 1-Dec AGE RENT EXPENSE DEBIT 27 101 2015 PAYMENT OF RENT CK 27 2 Dec PREPAID INSURANCE CASH PAYMENT OF ANNUAL INS CK 230 117 101 1867 165 AR-SAMMASON SERVICEHEVENUE INVOT 105 4-Dec AR - HASTINGS SALES REVENUE COST OF MERCHANDISE SOLD INVENTORY INVB TE 110 620 5-Dec OFFICE SUPPLIES CASH CK 16289 1115 101 110 6-Dec INVENTORY AP-KEY SUPPLIES CO 7. Dec MISCELLANEOUS EXPENSE CASH UPS DELIVERY OF SUPPLIES FROM DECO 525 100 7-Dec CAH JAK: WALTERS, CAPITAL 501 502 8-Dec ESTIMATED RETURNS INVENTORY INVENTORY RETURN TO KEY SUPPLIES CO 112 110 552 H-Dec 2200 CASH UNEAHNEDTREVENUE LOCKSMITH SERVICES 2200 9-Dec CASH SERVICE REVENUE UNLOCKED SAFE 101 401 1000 9000 General DATE C EQUIPMENT AP-OFFICE DEPOT NEW COMPUTER 120 201 2200 101 005 2230 10-Dect CASH SALES REVENUE COST OF MERCHANDISE SOLD INVENTORY SOLD 2 SAFES 4573 11-Dec INVENTORY AP - BRINKS CO PURCHASED S NEW SAFES 201 12-Dec ESTIMATED RETURNS INVENTORY COST OF MERCHANDISELE OLD REFUNDS PAYABLE CUSTOMER RETURN OF ONE SAFE 301 AS 13-Dec TELEPHONE EXPENSE CASH CK 6280 101 14-Dec AP-KEY SUPPLES COT:500-55) CASH (5560 X 0:01 G231 LESS DISCOUNT 100 16-Dec CASH SALES REVENUE SALES DISCOUNT FORSLITED NATHAN DEAN INV590 101 400 310 1473 101 14.351 14.351 15-Dec CASH SALES REVENUE COST OF MERCHANDISE SOLD INVENTORY CASH SALES DEC 1ST-15TH 405 501 110 4,783 4.783 1,825 16-Dec AR - HASTINGS SALES REVENUE INV #602 105 405 1825 500 17-Dec AP - OFFICE DEPOT CASH CK#6292 201 101 500 700 18-Dec AR - LARRY CONTRACTOR SERVICE REVENUE LARRY CONTRACTOR 105 401 700 1792 19-Dec UTILITIES EXPENSE CASH CK # 6293 513 101 1.792 175 19-Dec MISCELLANEOUS EXPENSE CASH CK# 6294 - DOMINOS PIZZA - OFFICE PARTY 525 101 175 8,350 20-Dec JAKE WALTERS, WITHDRAWAL CASH VACATION 311 101 8,350 120 25-Dec UTILITIES EXPENSE CASH CK# 6295 513 101 120 2,500 25-Dec AP - BRINKS CO CASH CK# 6296 201 101 2,500 2.550 26-Dec SALARY EXPENSE CASH 509 101 2,550 27-Dec CASH AR - LARRY CONTRACTOR LARRY CONTRACTOR 101 105 700 700 8.735 8,735 30-Dec CASH SALES REVENUE COST OF MERCHANDISE SOLD INVENTORY 101 405 501 110 2.784 2,784 ITEM POST REF DET ACCOUNT Cash 2020 DATE Nov 30 Bl. DEC CREDIT ACCOUNT NO 03 BALANCE DEBIT CREDIT 154931 152750 150 2.115 1967 150.160 19911 7 8.500 8411 6011 . 2.500 1.000 1911 154,111 2.200 10 13 14 5.45 14 1500 163.717 136272 15.772 114123 173.623 14351 500 15 17 19 19 175 171.SE 120 2.500 153306 163156 16060 2.550 25 20 27 30 700 158 136 158.836 167.571 DEBIT CREDIT ACCOUNT Accounts Receivable 2000 POST DATE ITEM REF Nov 20 B DEC 3 2.200 3.700 ACCOUNT NO BALANCE DEBIT 4 100 6300 10.DO TO 0533 16 700 27 700 POST REF DEBIT ACCOUNT NO 10 BALANGE DEBIT 45.525 41273 ACCOUNT Inventory DATE ITEM Nov 30 DEC 4 6 . 10 11 15 5.500 50775 50.175 500 800 4.15 54048 4573 4780 2754 Estimated Returns Inventory ITEM POST REF DEBIT ACCOUNT 2020 DATE Nov 30 6 CREDIT ACCOUNT NO 112 BALANCE DEBIT CHEOIT 700 1.200 DEC 50 525 12 1. Office Supplies POST REF DEBIT ACCOUNT 2030 DATE NOV DEC 5 CREDIT ACCOUNT NO 115 HALANCE DET CREDIT 0.30 165 ACCOUNT Prepaid Insurance ITEM POST REF DEBIT CREDIT DATE Nov 30 DEC 2 ACCOUNT NO 117 BALANCE DEBIT CREOL 300 1967 2207 ACCOUNT Equipment ITEM POST REF DEBIT CREDIT DATE 30 ACCOUNT NO 120 BALANCE DEBIT CREDIT 265.000 DEC . AST 2017 ACCOUNT Accumulated Depreciation - Equipment 2020 ITEM POST DATE DEBIT REF Nov 30 B CREDIT ACCOUNT NO BALANCE DEBIT CREDIT 1150 ACCOUNT Accounts Payable ACCOUNT NO PALACE 201 DEBIT ACCOUNT Accounts Payable 2020 POST ITEM DATE REF Nov 20 B DEC 5 ACCOUNT NO 201 BALANCE DEBIT CREDIT CREDIT 5.500 3903 10790 11 4,573 17 500 9.90 2.458 sta 25 2.500 Refunds Payable ITEM POST REF ACCOUNT 2020 DATE Nov 30 DEC 12 ACCOUNT NO 200 BALANCE DEBIT CREDIT DEBIT CREDIT 1 000 DEBIT CREDIT ACCOUNT Uneamed Service Revenue 2020 ITEM POST DATE REF Nov 30 S DEC 8 ACCOUNT NO 206 BALANCE DEBIT CREDIT 500 3.000 2.500 ACCOUNT NO 301 BALANCE DEBIT CROT DESIT ACCOUNT Jake Walters, Capital POST DATE ITEM REF Nov 30 Bal DEC 7 CREDIT 8.500 2010 DEBIT CREDIT ACCOUNT Jake Walters. Withdrawal 2000 POST ITEM DATE REF Nov 30 M DEC 20 ACCOUNT NO 312 BALANCE DEBIT CREDIT 12000 120350 8.350 ACCOUNT 2020 DATE Service Revenue ITEM POST DES ACCOUNT NO 451 BALANCE DEBIT CREDIT POST REF DEBIT ACCOUNT Service Revenue 2020 ITEM DATE Now 30 Bal DEC CREDIT ACCOUNT NO BALANCE DEBIT CREDIT 700.250 172360 173.960 174.650 1000 700 POST REF DEBIT ACCOUNT Sales Revenue DATE ITEM 30 S DEC 10 CREDIT ACCOUNT NO 406 BALANCE DEBIT CREDIT 312.900 315.100 3150 33.925 332.74 341481 SE35 15 16 30 ACCOUNT 2020 DATE Now 30 DEC Sales Discounts Forened ITEM POST REF DEBIT ACCOUNT NO 410 BALANCE DEBIT CREDIT 2.450 2.480 ACCOUNT Cost of Merchandise Sold ITEM POST REF DEBIT CREDIT DATE Now 30 DEC 4 10 1.250 800 ACCOUNT NO 501 BALANCE DEBIT CREDIT AST 148937 147727 148.212 15:05 15 30 4.783 2.754 155.779 ACCOUNT Advertising Experise ACCOUNT NO DATE ITEM DEBIT CREDIT ACCOUNT ACCOUNT ANS POST REF DET DATE ACCOUNT ACCOUNT 00 DATE Insurance Expense POST DERIT CREDIT ACCOUNT Office Supplies Expense PODE AGOON DANCE DET CREDIT DATE ACCOUNT Salary Espen ACCOUNT MAUNGE POST REF DET CREAT DATE T500 DEC ACCOUNT ACCOUNTINO Reports ITEM POST DATE DEST DEO ACCOUNT ACCOUNT Telephone ITEM DES REF DATE 30 INCOTAT ACCOUNT POST REF DEBIT ACCOUNT Utilities Expense 2020 ITEM DATE Nov. 30 Bal. DEC 19 CREDIT ACCOUNT NO 513 BALANCE DEBIT CREDIT 6,725 8,517 1,792 25 120 8,637 DEBIT CREDIT ACCOUNT Miscellaneous Expense 2020 POST ITEM DATE REF Nov. 30 Bal. DEC 7 ACCOUNT NO 525 BALANCE DEBIT CREDIT 3,465 3,723 258 19 1751 3,898 999 ACCOUNT 2020 DATE Income Summary ITEM POST REF DEBIT CREDIT ACCOUNT NO BALANCE DEBIT CREDIT POST REF DEBIT CREDIT ACCOUNT: Nathan Dean 2020 ITEM DATE Nov 30 Bal DEC 14 NATHAN DEAN BALANCE CREDIT DEBIT 2.675 1.500 1,500 Jillian Roberts ACCOUNT: 2020 DATE ITEM POST REF DEBIT CREDIT BALANCE CREDIT DEBIT Nov 30 Bal 1.433 POST REF DEBIT CREDIT DEBIT ACCOUNT Larry Contractor 2020 ITEM DATE Nov 30 Bal DEC 18 27 BALANCE CREDIT 0 700 0 700 700 SAM MASON ACCOUNT 2020 DATE ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 2,000 DEC 3 2,000 HASTINGS ACCOUNT 2020 DATE ITEM POST REF DEBIT CREDIT BALANCE CREDIT DEBIT DEC 3,700 3.700 16 1.825 1.875 ACCOUNT Lowes 2020 DATE Nov 30 Bal ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 756 ACCOUNT: Lock Supply Co 2020 DATE ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 2.677 Nov 30 Bal. KEY SUPPLIES CO ACCOUNT: 2020 DATE ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 5,500 DEC 6 5.500 14 5,445 5,445 BRINKS CO ACCOUNT 2020 DATE ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 4.573 DEC 11 4,573 OFFICE DEPOT ACCOUNT: 2020 DATE DEC ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 1.857 9 1,857 17 500 1,357 DATE CREDIT AGE RENT EXPENSE DEBI 27 PAYMENT OF RENT CK 27 2 Dec PREPAID INSURANCE CASH PAYMENT OF ANNUAL INS CK 230 117 101 2200 3-Dec ARSAM MASON SERVICEHEVENUE INVOT BELLISEL 4-Dec AR - HASTINGS SALES REVENUE COST OF MERCHANDISE SOLD INVENTORY INV 110 OFFICE SUPPLIES CASH CK 16289 115 101 6-Dec INVENTORY AP-KEY SUPPLIESTCO 20 7 Dec MISCELLANEOUS EXPENSE CASH UPS DELIVERY OF SUPPLIES FROM DECO 525 100 7-Dec CAH JAKE WALTERS, CAPITAL 198 500 8-Dec ESTIMATED RETURNS INVENTORY INVENTORY RETURN TO KEY SUPPLIES CO 112 110 500 101 2800 H-Dec CASH UNLAHNEDTREVENUE LOCKSMITH SERVICES 9-Dec CASH SERVICE REVENUE UNLOCKED SAFE 101 401 1000 9000 Geral PAGE GATE SUBC EQUIPMENT AP-OFFICE DEPOT NEW COMPUTER TU 201 2200 101 105 2230 10-Dec1 CASH SALES REVENUE COST OF MERCHANDISE SOLD INVENTORY SOLD 2 SAFES 00 BUITEN 4575 11-Dec INVENTORY AP - BRINKS CO PURCHASED 5 NEW SAFES 110 201 12-Dec ESTIMATED RETURNS INVENTORY CUSTOF MERCHANDISE SOLD REFUNDS PAYABLE CUSTOMER RETURN OF ONE SAFE 390 13-Dec TELEPHONE EXPENSE CASH CK BOZO 512 101 14.DC AP-KEY SUPPLIES COT500-657 CASH (6560 X 0.011 LESS DISCOUNT 100 18-Dec CASH SALES REVENUE SALES DISCOUNT FOR LITED NATHAN DEAN INV500 103 400 31 1473 ITEM POST REF DET CREDIT ACCOUNT Cash 2020 DATE Nov 30 B DEC 1 2 ACCOUNT NO SOS BALANCE DEBIT CREDIT 154.93 2175 1.967 620 150 150.160 19911 7 B. 411 6011 2.500 1.000 1911 10 2.200 154,111 182.17 394 5.45 18272 14 14 1500 15.772 174123 14351 15 17 19 500 173.625 17131 1719 19 175 120 2.500 25 25 20 27 153306 163156 1606 15 16 158.00 167.571 2550 700 2.735 Accounts Receivable ITEM POST REF DEBIT ACCOUNT 2006 DATE Nov 20 DEC 3 CREDIT ACCOUNT NO BALANCE DEBIT 4 100 6300 10.00 TRU 2,200 3.700 25 700 533 27 200 POST REF DEBIT ACCOUNT Inventory 2000 DATE ITEM Nov 30 DEC CREDIT ACCOUNT NO 110 BALANCE DEBIT CREDIT 45.525 61271 50.775 50.175 4.415 54048 5.500 500 800 10 11 4573 4780 40.265 15 20 Estimated Returns Inventory ITEM POST REF DEBIT ACCOUNT 2020 DATE Nov 20 $ CREDIT ACCOUNT NO 112 BALANCE DET CHEOIT 700 1.200 DEC 590 12 525 1. Office Supplies ACCOUNT 2030 DATE POST ACCOUNT NO 115 PALANCE DEUT CREDIT DEBIT CREDIT DEC 5 070 1.55 ACCOUNT Prepaid insurance ITEM POST REF DEBIT CREDIT DATE Nov 30 DEC 2 ACCOUNT NO 117 BALANCE DEBIT CREDIT 300 1967 227 ACCOUNT Equipment ITEM POST REF DEBIT CREDIT DATE Nov ACCOUNT NO 120 BALANCE DEBIT CREDIT 205.000 2017 DEC . AST ACCOUNT 2020 DATE Nov 30 Accumulated Depreciation - Equipment POST ITEM DEBIT REF CREDIT AOCOUNT NO BALANCE DEBIT CREDIT 1150 ACCOUNT Accounts Payable 201 ACCOUNT NO PATATE POST REF DEBIT CREDIT ACCOUNT Nathan Dean 2020 DATE ITEM Nov 30 Bal DEC 14 NATHAN DEAN BALANCE CREDIT DEBIT 2.675 1,500 1,500 Jillian Roberts ACCOUNT 2020 DATE ITEM POST REF DEBIT CREDIT BALANCE CREDIT DEBIT Nov 30 Bal 1.433 POST REF DEBIT CREDIT BALANCE CREDIT DEBIT ACCOUNT: Larry Contractor 2020 ITEM DATE Nov 30 Bal. DEC 18 27 0 700 700 700 0 SAM MASON ACCOUNT 2020 DATE ITEM POST REF DEBIT CREDIT BALANCE CREDIT DEBIT DEC 3 2,000 2,000 HASTINGS ACCOUNT 2020 DATE ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 3.700 DEC 4 3,700 16 1,825 1.875 ACCOUNT Lowes 2020 DATE Nov 30 Bal. ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 756 ACCOUNT: Lock Supply Co 2020 DATE ITEM POST REF DEBIT CREDIT BALANCE CREDIT DEBIT Nov 30 Bal 2,677 KEY SUPPLIES CO ACCOUNT 2020 DATE ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 5,500 DEC 6 5,500 14 5,445 5,445 BRINKS CO ACCOUNT 2020 DATE ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 4,573 DEC 11 4,573 OFFICE DEPOT ACCOUNT 2020 DATE DEC ITEM POST REF DEBIT CREDIT DEBIT BALANCE CREDIT 1,857 9 1,857 17 500 1,357