Can you please help me create T-Accounts, Thank you very much.

14100 C ***Type in your answers here and then use this spreadsheet to answer the questions in BB. Once you answer the questions in BB follow the instructions on how to upload the spreadsheet into Blackboard. Step 1: Write the journal entries in an Excel spreadsheet. Print out the spreadsheet when finished. Step 2: Use the Excel spreadsheet to answer the questions in Blackboard in the content folder in the corresponding week. Step 3: Once you complete answering the questions in Blackboard, then bring the template to class on the following Monday Step 4: If you have 2 journal entries then just continue on the same line. *Do not enter the information highlighted in yellow into BB. Some transactions will have more then one debitor credit so enter the smallest account first. Do not enter the Transaction # Or Account Dollar Amount or Account Dollar Amount transaction #in BB. Use with or without gridlines, 1 NO JE 2 De 10000 $20,000.00 39003 $20,000.00 31 Dr 14000 $28,000.00 C 10000 2,800.00 4 Dr $600.00 C 10000 $600.00 s Dr 150r $4800.00 21200 4,800.00 6 Or 10000 $5,000.00 21100 $5,000.00 7 Dr 15100 $6,000.00 10000 6,000.00 8 Dr 15000 $180.00 15100 $180.00 10000 $360.00 9 Dr 13100 $500.00 C 10000 $500.00 10 Dr 12000 $6,076.00C 20000 $6,076.00 11 Dr 12100 $882.00 CE 20000 $882.00 12 Dr 560,100.00 $800.00 10000 $800.00 13 NO JE 14 Dr 11000 $4,330.00 23300 $330.00 C 40000 $4,000,000 50000 $2,000.00 CF 12000 $1.700.00 12100 $300.00 15 Dr 13200 $300.00 20000 $300.00 16 Or 12000 $5.390.00 C 20000 $5,390.00 C 20000 $5.390.00 17 Dr 10000 $6,495.00 23300 $495.00 23300 $495.00 G 40000 $6,000.00 Dr 50000 $4,200.00 12000 $3,900.00 Cr 12100 $300.00 18 Dr 20000 $300,00 10000 $300.00 19 NO JE 20 Dr 10000 $4,330.00 11000 $4,330,00 21 Dr 60500 $300.00 10000 $300.00 22 Dr 20000 5882.00 C 10000 S882.00 23 Dr 10000 $7,578,00 Cr 23300 $578.00 Cr 23300 $578.00 CM 40000 $7,000.00 Dr 50000 $4,200.00 12000 $4,000.00 12100 $200.00 24 Dr 20000 $11,466,00 C 10000 $11,466.00 25 Dr 14200 $400.00 C 10000 $400.00 26 Dr 60550 $120.00 23400 $120.00 27 Dr 21200 $800.00 Dr 60700 $48.00 G 10000 $848.00 28 Dr 10000 $3,680.00 C 23300 $280.00 Gr 40000 $3,400.000 50000 $1,250.00 12000 $1,200.00 12100 $50.00 29 Dr 23300 $1,683.00 Cr 10000 $1,683.00 30 Dr 39007 $200.00 C 10000 $200.00 CT CF Template for the Adjusting Journal Entries Transaction # a. b. *Do not enter the information highlighted in yellow into BB. Some transactions will have more then one debit or credit so enter the smallest account first. Do not enter the transaction # in BB. Use with or without gridlines. c. d. Account Dollar Account Dr Number Amount Or Number Dr 60150 $200.00 C 13100 Dr 60200 $225.00 Cr 13200 Dr 60500 $900.00 Cr 14200 Dr 60350 $900.00 Cr 23100 Dr 60675 $51.50 Cr 17100 Dr 60650 $73.00 Cr 17000 Dr 60300 $100.00 CP 14100 Dr 60600 $700.00 Cr 14000 Dr 60700 $25.00 Cr 23200 NO JE Total Dollar Amount $200.00 $225.00 $900.00 $900.00 $51.50 $73.00 $100.00 $700.00 $25.00 e. f. g. h. i. J- $2,674.50 Teddy's Bears & Balloons Accounts Receivable Inventory.Bears 11000 12000 Debit Credit Debit Credit Cash 10000 Debit Credit Inventory-Balloons 12100 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 Debit Credit Fixtures & Shelves 15100 Debit Credit Accumulated Depr. Fixtures & Shelves 17100 Debit Credit Accounts Payable 20000 Debit Credit 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 Expense 60150 Debit Credit Ribbon Supplies Expense 60200 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 Depr. Expense- Fixtures & Shelves 60675 Interest Expense 60700 Bank Service Fee 60750 Depr. Expense Computer Equipment 60650 Debit Credit Debit Credit Debit Credit Debit Credit 14100 C ***Type in your answers here and then use this spreadsheet to answer the questions in BB. Once you answer the questions in BB follow the instructions on how to upload the spreadsheet into Blackboard. Step 1: Write the journal entries in an Excel spreadsheet. Print out the spreadsheet when finished. Step 2: Use the Excel spreadsheet to answer the questions in Blackboard in the content folder in the corresponding week. Step 3: Once you complete answering the questions in Blackboard, then bring the template to class on the following Monday Step 4: If you have 2 journal entries then just continue on the same line. *Do not enter the information highlighted in yellow into BB. Some transactions will have more then one debitor credit so enter the smallest account first. Do not enter the Transaction # Or Account Dollar Amount or Account Dollar Amount transaction #in BB. Use with or without gridlines, 1 NO JE 2 De 10000 $20,000.00 39003 $20,000.00 31 Dr 14000 $28,000.00 C 10000 2,800.00 4 Dr $600.00 C 10000 $600.00 s Dr 150r $4800.00 21200 4,800.00 6 Or 10000 $5,000.00 21100 $5,000.00 7 Dr 15100 $6,000.00 10000 6,000.00 8 Dr 15000 $180.00 15100 $180.00 10000 $360.00 9 Dr 13100 $500.00 C 10000 $500.00 10 Dr 12000 $6,076.00C 20000 $6,076.00 11 Dr 12100 $882.00 CE 20000 $882.00 12 Dr 560,100.00 $800.00 10000 $800.00 13 NO JE 14 Dr 11000 $4,330.00 23300 $330.00 C 40000 $4,000,000 50000 $2,000.00 CF 12000 $1.700.00 12100 $300.00 15 Dr 13200 $300.00 20000 $300.00 16 Or 12000 $5.390.00 C 20000 $5,390.00 C 20000 $5.390.00 17 Dr 10000 $6,495.00 23300 $495.00 23300 $495.00 G 40000 $6,000.00 Dr 50000 $4,200.00 12000 $3,900.00 Cr 12100 $300.00 18 Dr 20000 $300,00 10000 $300.00 19 NO JE 20 Dr 10000 $4,330.00 11000 $4,330,00 21 Dr 60500 $300.00 10000 $300.00 22 Dr 20000 5882.00 C 10000 S882.00 23 Dr 10000 $7,578,00 Cr 23300 $578.00 Cr 23300 $578.00 CM 40000 $7,000.00 Dr 50000 $4,200.00 12000 $4,000.00 12100 $200.00 24 Dr 20000 $11,466,00 C 10000 $11,466.00 25 Dr 14200 $400.00 C 10000 $400.00 26 Dr 60550 $120.00 23400 $120.00 27 Dr 21200 $800.00 Dr 60700 $48.00 G 10000 $848.00 28 Dr 10000 $3,680.00 C 23300 $280.00 Gr 40000 $3,400.000 50000 $1,250.00 12000 $1,200.00 12100 $50.00 29 Dr 23300 $1,683.00 Cr 10000 $1,683.00 30 Dr 39007 $200.00 C 10000 $200.00 CT CF Template for the Adjusting Journal Entries Transaction # a. b. *Do not enter the information highlighted in yellow into BB. Some transactions will have more then one debit or credit so enter the smallest account first. Do not enter the transaction # in BB. Use with or without gridlines. c. d. Account Dollar Account Dr Number Amount Or Number Dr 60150 $200.00 C 13100 Dr 60200 $225.00 Cr 13200 Dr 60500 $900.00 Cr 14200 Dr 60350 $900.00 Cr 23100 Dr 60675 $51.50 Cr 17100 Dr 60650 $73.00 Cr 17000 Dr 60300 $100.00 CP 14100 Dr 60600 $700.00 Cr 14000 Dr 60700 $25.00 Cr 23200 NO JE Total Dollar Amount $200.00 $225.00 $900.00 $900.00 $51.50 $73.00 $100.00 $700.00 $25.00 e. f. g. h. i. J- $2,674.50 Teddy's Bears & Balloons Accounts Receivable Inventory.Bears 11000 12000 Debit Credit Debit Credit Cash 10000 Debit Credit Inventory-Balloons 12100 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 Debit Credit Fixtures & Shelves 15100 Debit Credit Accumulated Depr. Fixtures & Shelves 17100 Debit Credit Accounts Payable 20000 Debit Credit 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 Expense 60150 Debit Credit Ribbon Supplies Expense 60200 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 Depr. Expense- Fixtures & Shelves 60675 Interest Expense 60700 Bank Service Fee 60750 Depr. Expense Computer Equipment 60650 Debit Credit Debit Credit Debit Credit Debit Credit