"SOCIETY Part Three Instructions Before preparing the T-Accounts make sure that all journal entries are corrected so that the ending balance in the T-Accounts will be correct. Find the ending balance for each account. Do this by creating a T-account for each account in an Excel Spreadsheet as shown in the template after the instructions here. Put all debits and credits in each account and calculate the ending balance. All accounts that were used in the Chart of Accounts should be included and if the account has a zero balance place the zero on the normal balance side. Once you finish preparing all the balances in each account, use the spreadsheet to answer the questions in Blackboard. In Blackboard the question will be the same for each account. "What is the balance in Account number 10000 (or whatever account it asks) and what is the normal balance. Since it asked for account number 10000 that is cash so type in Dr $10,500.00 You will do this for each account. Again notice that there is no period after Dr and the dollar amount always includes the cents. Step 1: Create an Excel spreadsheet with all the T-Accounts and input the numbers from the transactions into the proper account and calculate the ending balance in each account and input the balance on the normal balance side. Step 2: Use the Excel spreadsheet to answer the questions in Blackboard. Step 3: Print out the Spreadsheet and turn it in. A template for the T-Accounts follows. Some accounts such as cash will require more space than other accounts. Requirements 1. Correct Errors: Correct any errors that you made on the journal and adjusting journal entries before entering the information into the T-Accounts. 2. Account Balances: Once you have completed entering the transactions then prepare the ending balance in each account. Teddy's Bears & Balloons Accounts Receivable Inventory Bears 11000 12000 Debit Credit Debit Credit Inventory-Balloons 12100 Debit Credit Cash 10000 Debit Credit 0 0 Office Supplies 13100 Debit Credit Ribbon Supplies 13200 Debit Credit Prepaid Rent 14000 Debit Credit Prepaid Insurance 14100 Debit Credit Prepaid Advertising 14200 Debit Credit Computer Equipment 15000 Debit Credit Accumulated Depr. Computer Equipment 17000 Fixtures & She 15100 Debit Accumulated Depr. Fixtures & Shelves 17100 Debit Credit Accounts Payable 20000 Debit Credit Debit Credit 11 Page Note Payable Western Bank 21100 Debit Credit Note Payable Office Mart 21200 Debit Credit Wages Payable 23100 Debit Credit Interest Payable 23200 Debit Credit Sales Tax Payable 23300 Debit Credit Utility Payable 23400 Debit Credit Common Stock 39003 Debit Credit Retained Earnings 39005 Debit Credit Dividends 39007 Debit Credit Sales 40000 Debit Credit COGS 50000 Debit Credit Legal Expense 60100 Debit Credit Office Supplies Trib Ribbon Supplies Expense Expense 60150E60200 Debit Credit Debit Credit Insurance Expense 60300 Debit Credit Wage Expense 60350 Debit Credit Credit Card Expense 60400 Advertising Expense 60500 Debit Credit Utility Expense 60550 Debit Credit Rent Expense 60600 Debit Credit Debit Credit 12 Pag OCIETY Depr. Expense Fixtures & Shelves 60675 Depr. Expense Computer Equipment 60650 Debit Credit Interest Expense 60700 Bank Service Fee 60750 Debit Credit Debit Credit Debit Credit 131 Page Chart of Accounts: use the account numbers listed below in the journal entries. Stockholders' Equity 39003 Common Stock 39005 Retained Earnings 39007 Dividends Current Assets 10000 Cash 11000 Accounts Receivable 12000 Inventory.Bears 12100 Inventory-Balloons 13100 Office Supplies 13200 Ribbon Supplies 14000 Prepaid Rent 14100 Prepaid Insurance 14200 Prepaid Advertising Revenue 40000 Sales Long-Term Assets 15000 Computer Equipment 17000 Accumulated Depreciation -Computer Equipment 15100 Office Fixtures 17100 Accumulated Depreciation Office Fixtures Expenses 50000 60100 60150 60200 60300 60350 60400 60500 60550 60600 60650 Cost of Goods Sold Legal Expense Office Supplies Expense Ribbon Supplies Expense Insurance Expense Wages Expense Credit Card Expense Advertising Expense Utility Expense Rent Expense Depreciation Expense-Computer Equipment Depreciation Expense-Office Fixtures Interest Expense Bank Service Fee 60675 Current Liabilities 20000 Accounts Payable 21100 Note Payable - Wells Fargo Bank 21200 Note Payable - Office Mart 23100 Wages Payable 23200 Interest Payable 23300 Sales Tax Payable 23400 Utilities Payable 60700 60750 Long-Term Liabilities 27000 Mortgage Payable 27100 Notes Payable 20,000.00 2,800.00 600.00 4,800.00 5,000.00 6,000.00 360.00 500.00 6,076.00 882.00 800.00 4,000.00 330.00 1 NO JE 2 Dr 10000 $ 20,000.00 C 39003 S 3 Dr 14000 $ 2,800.00 CE 10000 $ 4 Dr 14100 S 600.00 C 10000 $ 5 Dr 15000 $ 4,800.00 C 21200 S 6 Dr 10000 $ 5,000.00 C 21100 $ 7 Dr 15100 S 6,000.00 CE 10000 $ 8 Dr 15000 $ 180.00 Dr 15100 $ 180.00 Cr 10000 $ 9 Dr 13100 $ 500.00 Cr 10000 $ 10 Dr 12000 $ 6,076.00 20000 $ 11 Dr 12100 $ 882.00 CE 20000 $ 12 Dr 60100 $ B00.00 Cr 10000 $ 13 NO JE NO JE 14 Dr 11000 S 4,330.00 40000 $ 23300 S Dr 50000 $ 2,000.00 12000 $ Cr 12100 S 15 Dr 13200 $ 300.00 C 20000 $ 16 Dr 12000 $ 5,390.00 C 20000 $ 17 Dr 10000 S 6,495.00 Dr 50000 S 4,200.00 40000 $ 23300) $ 12000 $ 12100 S 18 Dr 20000 $ 300.00 Gr 10000 $ 19 NO JE NO JE 20 Dr 10000 $ 4,330.00 C 11000 $ 21 Dr 60500 $ 300.00 C 10000 $ 22 Dr 20000 $ 882.00 Cr 10000 S 23 Dr 10000 $ 7,578.00 Dr 50000 $ 4,200.00 C 40000 $ Gr 23300 $ Cr 12000 $ Cr 12100 $ 24 Dr 20000 $ 11,466.00 C 10000 $ 25 Dr 14200 s 400.00 C 10000 $ 26 Dr 60550 $ 120.00 C 23400 $ 27 Dr 21200 $ 800.00 Dr 60700 S 48.00 Cr 10000 $ 28 Dr 10000 $ 3,680.00 Dr 50000 $ 1,250.00 Cr 40000 $ Cr 23300 S Cr 12000 $ Cr 12100 $ 29 Dr 23300 $ 1,683.00 C 10000 $ 30 Dr 39007 $ 200.00 10000 $ Instructions Part 1 Template JE 1,700.00 300.00 300.00 5,390.00 6,000.00 495.00 3,900.00 300.00 300.00 4,330.00 300.00 882.00 7,000.00 578.00 40,000.00 200.00 11,466.00 400.00 120.00 848.00 55555 3,400.00 280.00 1,200.00 50.00 1.683.00 200.00 + Adjusting journal Entries Dr. Dr. 200 225 Dr. 400 Dr. 900 207 208 209 210 a) 211 b) 212 c) 213 d) 214) 215 f) 216 g) 217 h) 218 i) 219)) 220 221 222 Dr. Dr. Dr. Dr. 60150 60200 60500 60350 60675 60650 60300 60600 60700 NO JE 51.50 73.00 100 700 Cr. Cr. Cr. Cr. 13100 13200 14100 23100 17100 17000 14100 14000 23200 200 (500-300) 225 (300-75) 400 (600-200) 900 51.50 (6000+180-0)/10*1/12 73.00 (4800+180-600)/5*1/12 100 (600/6) 700 (2800/4) 25 (5000*6%*1/12) Dr. 25 Cr