AutoSave . JWs Proj 2020 - Student Project Workbook(1).xIs - Compatibility Mode Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Lav & cut Arial 10 B Wrap Text v General Normal Bad Good Neutral X v Paste LG Copy Fill Format BIUV Merge & Center v v % " Conditional Format Calculation Check Cell Explanatory T... Followed Hyp... Insert Delete Format Sort & Find & Ideas Sensitivity Formatting as Table Clear v Filter Select M38 fx C D E F G H M N O P Q U V W AA AB AC AD AE AF AG AH Al AJ Comprehensive Project Grading Sheet Name Participation Grade Group members Assemble the items as listed below. Points will be given based on accuracy and completeness. 1. Financial Statements 2. Post-Closing Trial Balance 40 Points 3. Worksheet 10 Points 10 Points 4. General Journal 50 Points 5. General Ledger 40 Points 5. Participation 10 Points Check Figures: Unadjusted Trial Balance: $907,503 Cash Account Balance Not Income (Loss): $161,398 $203,356 Accounting 2301 Instructions Transactions Chart of Accounts GJ Ledger AR sub AP sub WS Fin Statements Post-Closing TB +AutoSave . #3JWs Proj 2020 - Student Project Workbook(1).xIs - Compatibility Mode Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Lav & cut Arial 10 B Wrap Text v General Normal Bad Good Neutral Paste LG Copy Fill v Format BIUV A Merge & Center v v % " Conditional Format Calculation Check Cell Explanatory T... Formatting as Table Followed Hyp... Insert Delete Format Clear v Sort & Find & Ideas Sensitivity Filter Select E13 fx JW's Lock & Key had the follow W AA nsactions in December. AB AC AD AE Dec. 1 Paid December's rent, check # 6287, $2,800. 2 Paid annual prem $3,600. d casualty insurance policies, check # 6288, Performed locksmith services on new h Mason, $2,000. sent invoice # 601 to the h Issued Invoice # 602 to Hastings who purch of Merchandise Sold was $1,250. new safe on account, $3,800. Cost 5 Purchased office supplies, check # 6289, $620. 6 Purchase from Key Supplies Co., $5,500. terms 1/10, n/30 7 Paid UPS $216 cash for delivery of the inventory purchased on December 6. Jake deposited an ad nal $5,000 cash in the business. B Returned damaged im ry to Key Supplies Co., $500 8 Rec elived $2,500 cash, an advance payment for locksmith services. 9 Unlocked a safe for a cus ceived $1,000 cash. 9 Bought a new computer (equipment) from Office Depot on account, $1,967. 10 Sold 2 safes and receive chandise Sold was $800. 1 Purchased 5 safes to restock inventory on account from Brinks Co, $4,187 terms, 2/5. 2 Customer returned one of the safes purchased on December 10, refunded the customer $1,000 cash. Cost of Merchandise Sold was $475. 13 Paid Verizon for wireless telephone services, $482, check # 6290. 14 Paid Key Supplies Co for the purchase on December 6, less return and discount, check # 6291. 14 Received cash on account, $1,500, From Nathan Dean. Dean did not pay his November Invoice #590 within the credit terms 2/10. The discount was forfeited. 15 Recorded cash sales for the store from the 1st to the 15th, $13,908. Cost of Merchandise Sold was $4,783. 16 Received $1,900 from Hastings on account. 17 Paid Office unt, $500, check # 6292. 18 Performed locksmith services on account for Larry Contractor, $700. 19 Paid electricity bill for December, check # 6293, $1,763 19 Paid for Domino's pizza delivery for the December office party, check #6294, $175 20 Jake withdrew $10,000 for a vacation 25 Paid the water bill for December, check # 6295, $120. 25 Paid Brinks Co. on account, $2,500, check # 6296 26 Paid part time employees their salary, $2,250. 27 Received cash on account from Larry Contractor, $700. 30 Recorded cash sales for the store from the 16th to the 30th, $8,735. Cost of Merchandise Sold was $2,784. the adjustment data for December is as follows: b. Office supplies on hand on December 31 are $1,058. 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. Earned $1,500 worth of the unearned service revenue. Sales refunds estimated for the year $10,000 Cost of estimated returns for the year $2,000 Instructions Transactions Chart of Accounts GJ Ledger AR sub AP sub WS Fin Statements Post-Closing TB + 90%AutoSave #3JWs Proj 2020 - Student Project Workbook(1).xIs - Compatibility Mode Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Lav a cut Arial 10 B Wrap Text v General Normal Bad Good Neutral X v Paste LG Copy BIUV A Merge & Center v v % " Conditional Format Calculation Check Cell Explanatory T... Followed Hyp... Insert Delete Fill v Format Sort & Find & Ideas Sensitivity Format Formatting as Table Clear v Filter Select J11 fx B C D G M P Q R U W AA AB AC AD AE AF AG . NOU A W N - JW's Lock & Key Chart of Accounts Assets 101 Cash Liabilities 105 Accounts Receivable 201 Accounts Payabl 203 Refunds Payable 110 Inventory 205 Uneamed Service Revenue 112 Estimated Returns Inventory 115 Office Supplies 117 Prepaid Insurance Owner's Equity Equipment 301 Jake Walters, Capital 121 Accum. Depreciation - Equipment 311 Jake Walters, Withdrawal Revenues 401 Service Revenue Expenses 501 Cost of Merchandise Sold Sales Revenue 502 Advertising Expense 410 Sales Discounts Forfeited 505 Depreciation Expense 507 Insurance Expense 508 Office Supplies Expense Other Misc 509 Salary Expense 999 Income Summary 511 Rent Expense 512 Telephone Expense 513 525 Utilities Expense Miscellaneous Expense Instructions Transactions Chart of Accounts GJ Ledger AR sub AP sub WS Fin Statements Post-Closing TB + 100%AutoSave . JWs Proj 2020 - Student Project Workbook(1).xIs - Compatibility Mode Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Liv & cut Arial 10 B Wrap Text v General Normal Bad Good Neutral Paste LG Copy X v Fill Format BIUV A Merge & Center v v % " 00 Conditional Format Calculation Check Cell Explanatory T... Followed Hyp... Insert Delete Format Clear v Sort & Find & Ideas Formatting as Table Sensitivity Filter Select B3 fx B C D E G M N 0 P Q R V W AA AB AC AD W N - General Journal PAGE 37 DATE Accounts & Explanations PR DEBIT CREDIT DATE General Joumal Accounts & Explanations PAGE 38 DEBIT CREDIT Instructions Transactions Chart of Accounts GJ Ledger AR sub AP sub WS Fin Statements Post-Closing TB + 100%AutoSave . JWs Proj 2020 - Student Project Workbook(1).xIs - Compatibility Mode Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Lav & cut Arial 10 Paste LG Copy B Wrap Text v General Normal Bad Good Neutral X v Format BIUV A Merge & Center v v % " 00 Conditional Format Calculation Check Cell Explanatory T... Followed Hyp... Insert Delete Format Fill Formatting as Table Clear v Sort & Find & Ideas Sensitivity Filter Select B3 fx B C D E G M N 0 P Q R V W AA AB AC AD DATE General Journal Accounts & Explanations DEBIT PAGE 38 CREDIT Instructions Transactions Chart of Accounts GJ Ledger AR sub AP sub WS Fin Statements Post-Closing TB + 100%AutoSave . JWs Proj 2020 - Student Project Workbook(1).xIs - Compatibility Mode Q Home Insert Draw Page Layout Formulas Data Review View Tell me Liv & cut Share Comments Arial 10 LG Copy B Wrap Text v General Normal Bad Good Neutral Paste X v Format BIUV A Merge & Center v v % " 00 Conditional Format Calculation Check Cell Formatting as Table Explanatory T... Followed Hyp... Insert Delete Format Fill Clear v Sort & Find & Ideas B3 fx Filter Select Sensitivity B C D E G M N 0 P Q R V W AA AB AC AD DATE General Journal Accounts & Explanations DEBIT PAGE 40 CREDIT Instructions Transactions Chart of Accounts GJ Ledger AR sub AP sub WS Fin Statements Post-Closing TB + 100%AutoSave . #3JWs Proj 2020 - Student Project Workbook(1).xIs - Compatibility Mode Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Lav d cut Arial 10 LG Copy B Wrap Text v General Normal Bad Good Neutral X v Paste Format BIUV A Merge & Center v v % " Conditional Format Calculation Check Cell Formatting as Table Explanatory T... Followed Hyp... Insert Delete Format Fill v Clear v Sort & Find & Ideas Sensitivity Filter Select 0178 fx A B C D G H ACCOUNT Cash Q ACCOUNT NO W 2020 101 AA AB AC AD AE AF AG AH Al AJ AK AL DATE ITEM POST DEBIT CREDIT BALANCE DEBIT 30 Bal. CREDIT Nov 154,931 ACCOUNT 2020 Accounts Receivable ITEM ACCOUNT NO 105 DATE REF DEBIT CREDIT 30 Bal. DEBIT BALANCE CREDIT Nov 4, 108 ACCOUNT 2020 Inventory DATE POST ACCOUNT NO ITEM DEBIT CREDIT BALANCE 110 DEBIT CREDIT Nov 30 Bal. 46,525 Instructions Transactions Chart of Accounts GJ Ledger AR sub AP sub WS Fin Statements Post-Closing TB + 90%AutoSave . #3JWs Proj 2020 - Student Project Workbook(1).xIs - Compatibility Mode Q Home Insert Draw Page Layout Formulas Data Review View Tell me Lav d cut Share Comments Arial 10 LG Copy B Wrap Text v General Normal Bad Good Neutral Paste X v Format BIUV A Merge & Center v v % " Conditional Format Calculation Check Cell Formatting as Table Explanatory T... Followed Hyp... Insert Delete Format Fill v Clear v Sort & Find & Ideas Select Sensitivity 0178 Filter fx A C D G ACCOUNT Inventory ACCOUNT NO 110 Q W AA AB AC 2020 AD AE AF AG AH Al AK DATE ITEN POST AJ DEBIT CREDIT BALANCE AL DEBIT CREDIT Nov 30 Bal 46,525 ACCOUNT Estimated Returns Inventory 2020 ACCOUNT NO POST 112 DATE ITEM REF DEBIT CREDIT BALANCE DEBIT Nov 30 Bal. CREDIT 700 ACCOUNT 2020 Office Supplies 115 DATE ITEM POST ACCOUNT NO DEBIT CREDIT BALANCE 30 Bal. DEBIT CREDIT Nov 1,235 ACCOUNT Prepaid Insurance 2020 POST ACCOUNT NO 117 DATE ITEM REF DEBIT CREDIT BALANCE 30 DEBIT CREDIT 300 Instructions Transactions Chart of Accounts GJ Ledger AR sub AP sub WS Fin Statements Post-Closing TB + 90%AutoSave . #3JWs Proj 2020 - Student Project Workbook(1).xIs - Compatibility Mode Q Home Insert Draw Page Layout Formulas Data Review View Tell me Lav d cut Share Comments Arial 10 LG Copy B Wrap Text v General Normal Bad Good Neutral Paste X v Format BIUV A Merge & Center v v % " Conditional Format Calculation Check Cell Formatting as Table Explanatory T... Followed Hyp... Insert Delete Format Fill v Clear v Sort & Find & Ideas Select Sensitivity Filter 0178 fx A B C D G H ACCOUNT Q Estimated Returns Inventory W ACCOUNT NO AA AB 112 AC AD AE AF AG AH Al AJ AK AL 2020 DATE ITEN POST DEBIT CREDIT BALANCE 30 DEBIT CREDIT 700 ACCOUNT 2020 Office Supplies ITEM POST DEBIT CREDIT ACCOUNT NO BALANCE 115 DATE DEBIT CREDIT 1,235 ACCOUNT 2020 Prepaid Insurance DATE ITEM POST DEBIT CREDIT ACCOUNT NO BALANCE 117 30 Bal. DEBIT CREDIT Nov ACCOUNT 2020 Equipment ACCOUNT NO DATE ITEM POST 120 DEBIT CREDIT BALANCE 30 Bal DEBIT CREDIT Nov 265,000 ACCOUNT Accumulated Depreciation - Equipment ACCOUNT NO 121 Instructions Transactions Chart of Accounts GJ Ledger AR sub AP sub WS Fin Statements Post-Closing TB + 90%AutoSave . #3JWs Proj 2020 - Student Project Workbook(1).xIs - Compatibility Mode Home Insert Page Layout Q Draw Formulas Data Review View Tell me Liv & cut Share Comments Arial 10 LG Copy B Wrap Text v General Normal Bad Good Neutral Paste Format BIUV X v A Merge & Center v v % " Conditional Format Calculation Formatting as Table Check Cell Explanatory T... Followed Hyp... Insert Delete Format Fill v Clear v Sort & Find & Ideas Sensitivity 0178 fx Filter Select G Q W AA AB ACCOUNT AC AD AE AF AG AH Al AJ AK AL 2020 Equipment ITEM ACCOUNT NO 120 DATE REF DEBIT CREDIT BALANCE Nov 30 Bal. DEBIT CREDIT 265,000 ACCOUNT 2020 Accumulated Depreciation - Equipment ITEM POST ACCOUNT NO BALANCE 121 DATE REF DEBIT CREDIT Nov 30 Bal DEBIT CREDIT 115.500 ACCOUNT Accounts Payable 2020 ACCOUNT NO ITEM POST DEBIT CREDIT BALANCE 201 DATE Nov 30 B DEBIT CREDIT 3.433 ACCOUNT 2020 Refunds Payable DATE ITEM POST DEBIT ACCOUNT NO CREDIT BALANCE 203 30 Bal. DEBIT Nov. CREDIT 500 Instructions Transactions Chart of Accounts GJ Ledger AR sub AP sub WS Fin Statements Post-Closing TB + 90%AutoSave . #3JWs Proj 2020 - Student Project Workbook(1).xIs - Compatibility Mode Q Home Insert Draw Page Layout Formulas Data Review View Tell me Lav d cut Share Comments Arial 10 Paste LG Copy B Wrap Text v General Normal Bad Good Neutral X v Format BIUV A Merge & Center v v % " Conditional Format Calculation Check Cell Delete Format Fill v Formatting as Table Explanatory T... Followed Hyp... Insert Clear v Sort & Find & Ideas Sensitivity Filter 0178 fx Select A C D G H ACCOUNT Unearned Service Revenue Q ACCOUNT NO W AA AB 205 AC AD AE AF AG AH Al AJ AK AL 2020 DATE ITEM POST DEBIT CREDIT DEBIT BALANCE CREDIT Nov 30 B ACCOUNT 2020 Jake Walters, Capital ACCOUNT NO DATE ITEM POST DEBIT CREDIT BALANCE 301 DEBIT Nov 30 B CREDIT 262,643 ACCOUNT 2020 Jake Walters, Withdrawal DATE ITEM POST ACCOUNT NO DEBIT BALANCE 311 REE CREDIT Nov 30 Bal. DEBIT CREDIT 112,000 ACCOUNT 2020 Service Revenue ACCOUNT NO DATE ITEM POST REF DEBIT CREDIT DEBIT BALANCE 401 Nov. CREDIT 167.050 ACCOUNT 2020 Sales Revenue ACCOUNT NO 405 DATE ITEM REF DEBIT CREDIT BALANCE Nov. 30 Bal DEBIT CREDIT 312,900 Instructions Transactions Chart of Accounts GJ Ledger AR sub AP sub WS Fin Statements Post-Closing TB + 90%AutoSave . #3JWs Proj 2020 - Student Project Workbook(1).xIs - Compatibility Mode Q Home Insert Draw Page Layout Formulas Data Review View Tell me Lav d cut Share Comments Arial 10 LG Copy B Wrap Text v General Normal Bad Good Neutral Paste X v Format BIUV A Merge & Center v v % " Conditional Format Calculation Check Cell Formatting as Table Explanatory T... Followed Hyp... Insert Delete Format Fill v Clear v Sort & Find & Ideas Sensitivity Filter 0178 fx Select C G H Q ACCOUNT Sales Revenue W AA AB ACCOUNT NO AC AD AE AF AG 405 AH Al AJ AK AL 2020 DATE ITEN POST DEBIT CREDIT BALANCE Nov. 30 Ba DEBIT CREDIT 312,900 ACCOUNT 2020 Sales Discounts Forfeited ITEM POST DEBIT CREDIT ACCOUNT NO BALANCE 410 DATE Nov. 30 Bal DEBIT CREDIT 2,450 ACCOUNT 2020 Cost of Merchandise Sol ACCOUNT NO DATE ITEM DEBIT CREDIT BALANCE 501 REE Nov 30 Bal DEBIT CREDIT 145.687 ACCOUNT 2020 Advertising Expense POST ACCOUNT NO 502 DATE ITEM DEBIT CREDIT BALANCE Nov. 30 DEBIT CREDIT 9,250 Instructions Transactions Chart of Accounts GJ Ledger AR sub AP sub WS Fin Statements Post-Closing TB + 90%AutoSave . #3JWs Proj 2020 - Student Project Workbook(1).xIs - Compatibility Mode Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Liv & cut Arial 10 LG Copy ab Wrap Text v General Normal Bad Good Neutral X v Paste Format BIUV A Merge & Center v v % " Conditional Format Calculation Check Cell Delete Fill v Formatting as Table Explanatory T... Followed Hyp... Insert Format Clear v Sort & Find & Ideas Filter Select Sensitivity 0178 G Q W AA AB AC AD AE AF AG AH Al AJ AK AL ACCOUNT Cost of Merchandise Sold 2020 ACCOUNT NO DATE ITEM POST DEBIT CREDIT BALANCE 501 Nov. 30 Bal DEBIT CREDIT 145,687 ACCOUNT 2020 Advertising Expense ITEM POST ACCOUNT NO 502 DATE DEBIT CREDIT BALANCE Nov 30 Bal DEBIT CREDIT 9,250 ACCOUNT 2020 Depreciation Expense ACCOUNT NO 505 ITEM CREDIT Nov. REF DEBIT BALANCE DEBIT CREDIT 38,500 ACCOUNT 2020 Insurance Expense POST ACCOUNT NO 507 DATE ITEM DEBIT CREDIT BALANCE DEBIT Nov. 30 Bal. CREDIT 3,500 ACCOUNT 20xx Office Supplies Expense 508 DATE POST ACCOUNT NO ITEM REF DEBIT CREDIT BALANCE DEBIT CREDIT Instructions Transactions Chart of Accounts GJ Ledger AR sub AP sub WS Fin Statements Post-Closing TB + 90%AutoSave . #3JWs Proj 2020 - Student Project Workbook(1).xIs - Compatibility Mode Home Insert Draw Page Layout Q Formulas Data Review View Tell me Liv & cut Share Arial Comments 10 LG Copy B Wrap Text v General Normal Bad Good Neutral Paste Format BIUV X v A Merge & Center v v % " Conditional Format Calculation Formatting as Table Check Cell Explanatory T... Followed Hyp... Insert Delete Format Fill v Sort & Find & Ideas Sensitivity 0178 fx Clear v Filter Select C D G H Q ACCOUNT Office Supplies Expense W AA AB AC AD AE AF AG AH Al AJ AK AL 20xx ITEM POST ACCOUNT NO BALANCE 508 DATE DEBIT CREDIT Nov. 30 Ball DEBIT CREDIT 3,280 ACCOUNT 2020 Salary Expense ACCOUNT NO 509 DATE ITEM REF DEBIT CREDIT BALANCE Nov. 30 DEBIT CREDIT 37.500 ACCOUNT 2020 Rent Expense ACCOUNT NO DATE ITEM POST DEBIT CREDIT BALANCE 511 Nov. DEBIT CREDIT 27.500 ACCOUNT 2020 Telephone Expense ITEM ACCOUNT NO 512 DATE REF DEBIT CREDIT BALANCE Nov 30 Bal. DEBIT CREDIT 4,770 ACCOUNT 2020 Utilities Expense ACCOUNT NO 513 DATE ITEM REF DEBIT CREDIT BALANCE Nov. 30 Bal DEBIT CREDIT 6,725 ACCOUNT Miscellaneous Expense 2020 ITEM POST ACCOUNT NO 525 DATE REF DEBIT CREDIT BALANCE Nov. 30 Bal. DEBIT CREDIT 3,465 Instructions Transactions Chart of Accounts GJ Ledger AR sub AP sub WS Fin Statements Post-Closing TB + 90%AutoSave . #3JWs Proj 2020 - Student Project Workbook(1).xIs - Compatibility Mode Q Home Insert Draw Page Layout Formulas Data Review View Tell me Lav & cut Share Comments Arial 10 B Wrap Text v General Bad Good Neutral Paste LG Copy Normal X v Format BIUV A Merge & Center v v % " Conditional Format Calculation Check Cell Formatting as Table Explanatory T... Followed Hyp... Insert Delete Format Fill v 0178 fx Clear v Sort & Find & Ideas Select Sensitivity Filter C G H Q W ACCOUNT Utilities Expense AA AB AC AD AE AF AG ACCOUNT NO AH 513 Al AJ AK AL 2020 DATE ITEM POST DEBIT CREDIT DEBIT BALANCE Nov. 30 B CREDIT 6,725 ACCOUNT 2020 Miscellaneous Expense ITEM POST ACCOUNT NO BALANCE 525 DATE DEBIT CREDIT Nov 30 B DEBIT CREDIT 3.465 ACCOUNT 2020 Income Summary ACCOUNT NO 999 DATE ITEM REE DEBIT CREDIT BALANCE DEBIT CREDIT Instructions Transactions Chart of Accounts GJ Ledger AR sub AP sub WS Fin Statements Post-Closing TB + 90%AutoSave. JWs Proj 2020 - Student Project Workbook(1).xIs - Compatibility Mode Q Home Insert Draw Page Layout Formulas Data Review View Tell me Lav & cut Share Comments Arial 10 ab Wrap Text v General Normal Bad Good Neutral Paste LG Copy X v Format BIUV A Merge & Center v v % " Conditional Format Calculation Check Cell Formatting as Table Explanatory T... Followed Hyp... Insert Delete Format Fill v Clear v Sort & Find & Ideas Filter Select Sensitivity P15 fx C D G H 0 Accounts Receivable Subsidiary Ledger P Q U W AA AB AC AD AE AF AG AH ACCOUNT: Nathan Dean 2020 DATE ITEM POST REE DEBIT CREDIT DEBIT BALANCE CREDIT Now 30 Bal. 2,675 ACCOUNT: Jillian Roberts 2020 DATE ITEM POST REF. DEBIT CREDIT BALANCE DEBIT CREDIT Nov 30 Bal. 1,433 ACCOUNT: 2020 Larry Contractor DATE ITEM POST REF. DEBIT CREDIT DEBIT BALANCE 25 NOV 30 Bal. CREDIT 26 27 28 ACCOUNT 2020 DATE ITEM POST. REF. DEBIT CREDIT DEBIT BALANCE CREDIT 36 ACCOUNT: 2020 DATE ITEM POST REF. DEBIT CREDIT 45 DEBIT BALANCE CREDIT 46 Instructions Transactions Chart of Accounts GJ AR sub AP sub WS Fin Statements Post-Closing TB + 100%AutoSave. JWs Proj 2020 - Student Project Workbook(1).xIs - Compatibility Mode Q Home Insert Draw Page Layout Formulas Data Review View Tell me Lav & cut Share Comments Arial 10 ab Wrap Text v General Normal Good Neutral Paste LG Copy Bad X v Format BIUV A Merge & Center v v % " Conditional Format Calculation Check Cell Formatting as Table Explanatory T... Followed Hyp... Insert Delete Format Fill v Clear v Sort & Find & Ideas Filter Select Sensitivity fx C D E G H O P Q Accounts Payable Subsidiary Ledger U W AA AB AC AD AE AF AG AH ACCOUNT: Lowes 2020 DATE ITEM POST REE DEBIT CREDIT 30 Bal. DEBIT BALANCE CREDIT I Now 756 ACCOUNT: Lock Supply Co 2020 DATE ITEM POST REF. DEBIT CREDIT BALANCE DEBIT Nov 30 Bal. CREDIT 2,677 ACCOUNT: 2020 DATE ITEM POST DEBIT CREDIT BALANCE 25 REF . DEBIT CREDIT 26 27 28 ACCOUNT 2020 DATE ITEM POST REF. DEBIT CREDIT DEBIT BALANCE CREDIT 36 37 ACCOUNT: 2020 DATE ITEM POST REF. DEBIT CREDIT DEBIT BALANCE 45 CREDIT 46 Instructions Transactions Chart of Accounts GJ Ledger AR sub AP sub WS Fin Statements Post-Closing TB + 100%AutoSave . JWs Proj 2020 - Student Project Workbook(1).xIs - Compatibility Mode Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Lav & cut Arial 10 B Wrap Text v General Normal Bad Good Neutral Paste LG Copy Fill Format BIUV A Merge & Center v v % " Conditional Format Calculation Check Cell Explanatory T... Followed Hyp... Insert Delete Format Formatting as Table Clear v Sort & Find & Ideas Sensitivity Filter Select 015 fx B C D E G H M N 0 Q R S U W AA AB AC AD JW's Lock & Key Work Sheet Account Unadj. Trial Balance Debit Credit Adjustments Debit Credit Adj. Trial Balance Debit Credit Income Statement Debit Credit Balance Sheet Debit Credit Cash Accounts Receivable Inventory Estimated Returns Inventory 10 Office Supplies Prepaid Insurance Equipment Accum. Depreciation - Equip. 4 Accounts Payable Refunds Payable 6 Unearned Service Revenue 7 Jake Walters, Capital Jake Walters, Withdrawal 19 Service Revenue 10 Sales Revenue Sales Discounts Forfeited 22 Cost of Merchandise Sold 23 Advertising Expense Depreciation Expense Insurance Expense 26 Office Supplies Expense Salary Expense 28 Rent Expense 29 Telephone Expense Utilities Expense 31 Miscellaneous Expense $2 TOTALS NET INCOME (LOSS) 3 8 89 Instructions Transactions Chart of Accounts GJ Ledger AR sub AP sub WS Fin Statements Post-Closing TB + 100%AutoSave . #3JWs Proj 2020 - Student Project Workbook(1).xIs - Compatibility Mode Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Lay a cut Arial 10 B Wrap Text v General Normal Bad Good Neutral AutoSum v Paste LG Copy Conditional Format Calculation Check Cell Explanatory T... Followed Hyp... Insert Delete Format Fill v Format BIUV A Merge & Center v v % " Clear v Sort & Find & Ideas Sensitivity Formatting as Table Filter Select R41 fax B C D G H M N O Q R S U W JW's Lock & Key JW's Lock & Ke Income Statement Balance Sheet JW's Lock & Key Statement of Owner's Equity Instructions Transactions Chart of Accounts GJ Ledger AR sub AP sub WS Fin Statements Post-Closing TB + 98%AutoSave . JWs Proj 2020 - Student Project Workbook(1).xIs - Compatibility Mode Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Lav & cut Arial 10 B Wrap Text v Number Normal Bad Good Neutral Paste LG Copy Fill v Format BIUV A Merge & Center v v % " 00 20 Conditional Format Calculation Check Cell Explanatory T... Followed Hyp... Insert Delete Format Clear v Sort & Find & Ideas Formatting as Table Sensitivity Filter Select B8 V fx =Ledger!H42 B C D G H M N O P Q R S U W AA AB AC Cash Accounts Receivable Inventory 0 Estimated Returns Inventory Office Supplies 12 Prepaid Insurance Equipment Accumulated Depreciation-Equipment Accounts Payable Refunds Payable 17 Unearned Service Revenue 8 Jake Walters, Capital Totals Instructions Transactions Chart of Accounts GJ Ledger AR sub AP sub WS Fin Statements Post-Closing TB + 100%