only need part 3 all transactions with adjusted balances entered in T -accounts on excel

ACCOUNTING SOCIETY Blackboard Instructions Part One Instructions: Enter all journal entries into the Practice Set. Once they are entered into the Practice Set, enter them into Blackboard. In blackboard no account name will be used, however you will state if it is a Dr or Cr then the account number and the amounts. If there is more than one debitor credit in the transaction list the smaller account number first. If it is a sale then list the sale first then the inventory and if more than one credit or debit then the smallest account number first. Example: On a transaction for a sale you would enter the sale first followed by the COGS and Inventory: Dr 10000 $2,200.00 Cr 23000 $200.00 CR 40000 $2,000.00 Dr 50000 $1,500.00 Cr 12000 $800.00 12100 $700.00 A regular transaction would be: Dr 10000 $5,300.00 Cr 11000 $5,300.00 Notice how the Dr or Cr comes first then the account number then the dollar amounts. You must enter Dror Cr before each account number. For all dollar amounts include the dollar sign, comma and the period followed by the cents even if the cents is zero you MUST include it. Please follow these instructions carefully. There is no period after Dr or Cr. Part Two Instructions: Enter all the adjusting journal entries into the practice set. After they are entered into the Practice Set then record your answers in blackboard. Follow the same procedures as listed above. Part Three Instructions: Enter the account balances for each account in the practice set. Make sure all transactions are entered into the T-Accounts and then enter your balances into Blackboard. State the normal balance of each account first then followed by the account number and the dollar amount as shown below. Once completed, staple the T-Account balances to the inside back cover of the practice set. Dr 10000 $3,450.23 Part Four Instructions In this part of the practice set, the student will prepare a Bank Reconciliation for the month of June using an Excel spreadsheet. Use the ending balance in your cash account for the cash for your books. Requirements 1. Correct Errors: Correct any errors that you made on the journal entries. Both the debits and the credits must equal each other. 10 Page SOCIETY General Journal Debit Account Name NO JE Credit 46.000 45,000 9.000 Commen stood Prepal Real cish Prepeld insurace Cash computer egusement Nole Payille-Office mert 3,600 3,600 2,700 13700 Make Paple - Wells Perso # Date Account No. 1 7102 z oz 10000 139003 3 7703 11000 10000 IN 7200 14100 10000 51763 15000 |21200 16.7/05 | 10 000 21100 7 7/05 10000 15100 18 17/05/1000 1510 9 770G 70000 | GECO 10 7206 looco 114200 los Izooo Zecco 12 7/08 zivo locco 13/7/1360100 | 13,000 Befaserole | 13,000 25,000 Delivery Van | 26.000 12,200 Acher Fishs Eprensa 1,200 300 300 lupat advertising Inventory Fruit 2400 Accounts Payable ZOO 2000 2000 Veoco 14 7/14 NO JE 15 Page ACCOUNTING SOCIETY Account Name Credit Debit $50 850 uoco Date Account No. 15 7/1413100 coce 16 T/M 11000 40000 Sooco | 12000 2100 17 1/16 12cco 14000 12,756 2500 250 15,500 Scoobies Accounts Payable Accurls Rceleille Sales Cost of Gads sold Joventry Fruit Inventary-bestet Inventory-froid Accunt Reyelle Accounts Payable Cash Advertising and Prometen exerse Jouentay. Fruit In ventry-bonhect Cash Accents recsenoble Crent card. expenses 5,500 - 850 1625 COO 25 400 | 18 7/2 20000 (occo 19 7/23 60500 120co 12100 100/1/23, 10000 1000 1 7/200400 | loco 72 710512100 10000 73 76316000 Locco nooo 1675 615 Invertery- Basket 400 2400 | 10260 900 760 13850 23 773 Sales Soles toy parable Cost of gods sold Inventory - frost Inventory Bertots Aceconds Peycle 3000 330 21900 27/23 | 21900 cesh 16 Page SOCIETY Debit Credit Account No. Account Name # Date 25 7/25 cash 200 240 Solos tax pay ccgs 2000 1 700 300 26 7/28 250 Inventory froit Inverter-Baslecks expece Utilit payable Not Pay-of the Mart Interest expense 1250 27 7/31 | 2050 Cash 1922,50 287/31 1960 18 7/31 Sales Sales tex per Cogs Investor fick Inventore Beakol 2915 280 297731 11360 1360 cash Diudends Cash BO 17 Page M ACCOUNTING re SOCIETY Date Account No. Adjusted entries Account Name Supplies expense Credit Debit 855 Wupplies 15700 4196 40 mm HOS Wases_expense flases peyable Vereelchonecas Acamdated deprehet en-impoter Accmeleted depreciation - Refrist for . Acumulated depredaltan - Van Prepeld Insorence Interest expenses Internet pyeble Rent expense Drepold cent Advadisies expense Prepaid advertising Intorst expense Interest peyeble 120 120 400 9000 275 275 2250 zz.50 18 Page ACCOUNTING OCTETY Template of T-Accounts for Fran's Fruit Basket 10000 12000 12100 13100 Cash Debit Credit 11000 Accounts Receivable Debit Credit Inventory-Fruit Debit Credit Inventory-Baskets Debit Credit Supplies Debit Credit 14000 14100 14200 15000 17000 Accumulated Depr. Computer Equipment Debit Credit Prepaid Rent Debit Credit Prepaid Insurance Debit Credit Cash Computer Equipment Debit Credit Prepaid Advertising Debit Credit 01 0 17100 20000 21100 21200 23100 Accumulated Depr. Delivery Van Debit Credit Accounts Payable Debit Credit Note Payable- Wells Fargo Debit Credit Note Payable- Office Mart Debit Credit Wages Payable Debit Credit 0 0 23300 23400 27000 27100 39003 Sales Tax Payable Debit Credit Utilities Payable Debit Credit Mortgage Payable Debit Credit Note Payable Debit Credit Common Stock Debit Credit 13 Page ACCOUNTING SOCIETY 39007 40000 50000 60100 60150 Dividends Debit Credit Sales Debit Credit COGS Debit Credit Legal Expense Debit | Credit Supples Expense Debit Credit 60200 60300 60350 60400 60450 I I13555555SSSSSS Shipping Supplies Expense Insurance Expense Debit Credit Wages Expense Debit Credit Credit Card Expense Debit Credit Delivery Expense Debit Credit 60550 Utility Expense Debit Credit 60600 Rent Expense Debit Credit 60650 Depreciation Expense Debit Credit 60700 Interest Expense Debit Credit 60750 Bank Service Fee Debit Credit **This is only a template and some accounts that are on here may not be in your Chart of Accounts and some accounts may not be here that need to be added such as supplies, refrigerator, accumulated depreciation-refrigerator, Delivery Van and Accumulated Depreciation Delivery Van. Please refer to the Chart of Accounts in the practice set and make sure that there is a T-Account with an ending balance for all accounts. 14 Page JUHLI