Just need a journal entry, trial balance, worksheet, general journal, financial statement, and closing entry to do this on excel

DATETRANSACTIONS Oct. Issued Check 601 for $4,200 to pay City Properties the monthly rent 1Signed a three-month radio advertising contract with Cable Station KOTU for $4,800 issued Check 602 to pay the full amount in advance. 2 Received $520 from Megan Greening, a credit customer, in payment of her account 2 Issued Check 603 for $17,820 to remit the sales tax owed for July through September to the State Tax Commission 2 Issued Check 604 for $7,673.40 to A Fashion Statement, a creditor, in payment of Invoice 9387 ($7,830), less a cash discount ($156.60) 3 Sold merchandise on credit for $2,480 plus sales tax of S124 to Dimitri Sayegh, Sales Slip 241 4 Issued Check 605 for $1,050 to BMX Supply Co. for supplies. 4 Issued Check 606 for $8,594.60 to Today's Woman, a creditor, in payment of Invoice 5671 ($8,770), less a cash discount ($175.40) 5 Collected $1,700.00 on account from Emily Tran, a credit customer 5 Accepted a return of merchandise from Dimitri Sayegh. The merchandise was originally sold on Sales Slip 241, dated October 3; issued Credit Memorandum 18 for $630, which includes sales tax of $30 5 Issued Check 607 for $1,666 to Classy Threads, a creditor, in payment of Invoice 3292 ($1,700), less a cash discount ($34) 6 Had cash sales of $18,600 plus sales tax of $930 during October 1-6 8 Received a check from James Helmer, a credit customer, for $832 to pay the balance he owes 8 Issued Check 608 for $1,884 to deposit social security tax ($702), Medicare tax ($162), and federal income tax withholding ($1,020) from the September payroll. 9Sold merchandise on credit for $2,050 plus sales tax of $102.50 to Emma Maldonado, Sales Slip 242 10 Issued Check 609 for $1,445 to pay The City Daily for a newspaper advertisement that appeared in October 11 Purchased merchandise for $4,820 from A Fashion Statement, Invoice 9422, dated October 8; the terms are 2/10, n/30 12 Issued Check 610 for $375 to pay freight charges to Ace Freight Company, the trucking company that delivered merchandise from A Fashion Statement on September 27 and October 11 13 Had cash sales of S12,300 plus sales tax of $615 during October 8-13. 15 Sold merchandise on credit for $1,940 plus sales tax of $97 to James Helmer, Sales Slip 243. 16 |Purchased discontinued merchandise from Acme Jobbers; paid for it immediately with Check 611 for $6,420 16 Received $510 on account from Dimitri Sayegh, a credit customer. 16 Issued Check 612 for $4,723.60 to A Fashion Statement, a creditor, in payment of Invoice 9422 ($4,820.00), less cash discount ($96.40) 18 Issued Check 613 for $7,200 to Teresa Lojay as a withdrawal for personal use. 20 Had cash sales of $13.500 plus sales tax of $675 during October 15-20. 22 Issued Check 614 to City Utilities for $1,112 to pay the monthly electric bill. 24 Sold merchandise on credit for $820 plus sales tax of $41 to Megan Greening, Sales Slip 244 25 Purchased merchandise for $3,380 from Classy Threads, Invoice 3418, dated October 23; the terms are 2/10, n/30. I Telephone for $780 to pay the monthly telephone bill. 26 Issued Check 615 to Regional 27 Had cash sales of $14,240 plus sales tax of $712 during October 22-27. 29 Received Credit Memorandum 175 for $430 from Classy Threads for defective goods that were returned. The original purchase was recorded on October 25. 29 Sold merchandise on credit for $3,120 plus sales tax of $156 to Emily Tran, Sales Slip 245 29 Recorded the October payroll. The records prepared by the payroll service show the following totals: earnings, $10,800; social security, $702.00; Medicare, $162.00 income tax, $1,020; and net pay, $8,916. The excess withholdings corrected an error made in withholdings in September 29 Recorded the employer's payroll taxes, which were calculated by the payroll service: social security, $702; Medicare, $162; federal unemployment tax, $118: and state unemployment tax, $584. This, too, reflects an understatement of taxes recorded in September and corrected in this month 30 Purchased merchandise for $4,020 from Today's Woman, Invoice 5821, dated October 26; the terms are 1/10, n/30 31 Issued Checks 616 through 619, totaling $8,916.00, to employees to pay October payroll. 31 Issued Check 620 for $475 to Handy Janitors for October janitorial services. 31 Had cash sales of $1,700 plus sales tax of $85 for October 29-31 The Fashion Rack Chart of Accounts Assets Liabilities 101 Cash 203 Accounts Payable Accounts Receivable 221 Social Security Tax Payable 222 112 Allowance for Doubtful Accounts Medicare Tax Payable 121 Merchandise Inventory 223 Employee Income Tax Payable 131 Supplies 225 Federal Unemployment Tax Payable 133 Prepaid Insurance 227 State Unemployment Tax Payable 135 Prepaid Advertising 229 Salaries Payable 141 Equipment 231 Sales Tax Payable 142 Accumulated Depreciation-Equipment Owner's Equity Expenses 301 Teresa Lojay, Capital 611 Advertising Expense 302 Teres Lojay, Drawing 614 Depreciation Expense-Equipment 617 Insurance Expense 399 Income Summary Revenues 620 Uncollectible Accounts Expense Revenues 620 Uncollectible Accounts Expense 401 Sales 623 Janitorial Services Expense 402 Returns and Allowances 626 Payroll Taxes Expense Cost of Goods Sold 629 Rent Expense 501 Purchases 632 Salaries Expense 502 Freight In 635 Supplies Expense 503 Purchases Returns and Allowances 638 Telephone Expense 504 Purchases Discounts 644 Utilities Expense 5. Check the accuracy of the subsidiary ledgers by preparing a schedule of accounts receivable and a schedule of accounts payable as of October 31, 2019. Compare the totals with the balances of the Accounts Receivable account and the Accounts Payable account in the general ledger 6. Check the accuracy of the general ledger by preparing a trial balance in the first two columns of a 10-column worksheet. Make sure that the total debits and the total credits are equal 7. Complete the Adjustments section of the worksheet. Use the following data. Identify each adjustment with the appropriate letter. 7. Complete the Adjustments section of the worksheet. Use the following data. Identify each adjustment with the appropriate letter During October, the firm had net credit sales of $9,810. From experience with similar businesses, the previous accountant had estimated that 1.0 percent of the firm's net credit sales would result in uncollectible accounts. Record an adjustment for the expected loss from uncollectible accounts for the month of October. On October 31, an inventory of the supplies showed that items costing $3,240 were on hand. Record an adjustment for the supplies used in October On September 30, 2019, the firm purchased a six-month insurance policy for $8,400. Record an adjustment for the C. expired insurance for October. On October 1, 2019, the firm signed a three-month advertising contract for $4,800 with a local cable television station and paid the full amount in advance. Record an adjustment for the expired advertising for October. On April 1, 2019, the firm purchased equipment for $83,000. The equipment was estimated to have a useful life of five d. e. years and a salvage value of $12,500. Record an adjustment for depreciation on the equipment for October f. Based on a physical count, ending merchandise inventory was determined to be $81,260. 8. Complete the Adjusted Trial Balance section of the worksheet. 9. Determine the net income or net loss for October and complete the worksheet. 10. Prepare a classified income statement for the month ended October 31, 2019. (The firm does not divide its operating expenses into selling and administrative expenses.) 11. Prepare a statement of owner's equity for the month ended October 31, 2019 12. Prepare a classified balance sheet as of October 31, 2019 13. Journalize and post the adjusting entries using general journal page 17 14. Prepare and post the closing entries using general journal page 18 15. Prepare a postclosing trial balance DATETRANSACTIONS Oct. Issued Check 601 for $4,200 to pay City Properties the monthly rent 1Signed a three-month radio advertising contract with Cable Station KOTU for $4,800 issued Check 602 to pay the full amount in advance. 2 Received $520 from Megan Greening, a credit customer, in payment of her account 2 Issued Check 603 for $17,820 to remit the sales tax owed for July through September to the State Tax Commission 2 Issued Check 604 for $7,673.40 to A Fashion Statement, a creditor, in payment of Invoice 9387 ($7,830), less a cash discount ($156.60) 3 Sold merchandise on credit for $2,480 plus sales tax of S124 to Dimitri Sayegh, Sales Slip 241 4 Issued Check 605 for $1,050 to BMX Supply Co. for supplies. 4 Issued Check 606 for $8,594.60 to Today's Woman, a creditor, in payment of Invoice 5671 ($8,770), less a cash discount ($175.40) 5 Collected $1,700.00 on account from Emily Tran, a credit customer 5 Accepted a return of merchandise from Dimitri Sayegh. The merchandise was originally sold on Sales Slip 241, dated October 3; issued Credit Memorandum 18 for $630, which includes sales tax of $30 5 Issued Check 607 for $1,666 to Classy Threads, a creditor, in payment of Invoice 3292 ($1,700), less a cash discount ($34) 6 Had cash sales of $18,600 plus sales tax of $930 during October 1-6 8 Received a check from James Helmer, a credit customer, for $832 to pay the balance he owes 8 Issued Check 608 for $1,884 to deposit social security tax ($702), Medicare tax ($162), and federal income tax withholding ($1,020) from the September payroll. 9Sold merchandise on credit for $2,050 plus sales tax of $102.50 to Emma Maldonado, Sales Slip 242 10 Issued Check 609 for $1,445 to pay The City Daily for a newspaper advertisement that appeared in October 11 Purchased merchandise for $4,820 from A Fashion Statement, Invoice 9422, dated October 8; the terms are 2/10, n/30 12 Issued Check 610 for $375 to pay freight charges to Ace Freight Company, the trucking company that delivered merchandise from A Fashion Statement on September 27 and October 11 13 Had cash sales of S12,300 plus sales tax of $615 during October 8-13. 15 Sold merchandise on credit for $1,940 plus sales tax of $97 to James Helmer, Sales Slip 243. 16 |Purchased discontinued merchandise from Acme Jobbers; paid for it immediately with Check 611 for $6,420 16 Received $510 on account from Dimitri Sayegh, a credit customer. 16 Issued Check 612 for $4,723.60 to A Fashion Statement, a creditor, in payment of Invoice 9422 ($4,820.00), less cash discount ($96.40) 18 Issued Check 613 for $7,200 to Teresa Lojay as a withdrawal for personal use. 20 Had cash sales of $13.500 plus sales tax of $675 during October 15-20. 22 Issued Check 614 to City Utilities for $1,112 to pay the monthly electric bill. 24 Sold merchandise on credit for $820 plus sales tax of $41 to Megan Greening, Sales Slip 244 25 Purchased merchandise for $3,380 from Classy Threads, Invoice 3418, dated October 23; the terms are 2/10, n/30. I Telephone for $780 to pay the monthly telephone bill. 26 Issued Check 615 to Regional 27 Had cash sales of $14,240 plus sales tax of $712 during October 22-27. 29 Received Credit Memorandum 175 for $430 from Classy Threads for defective goods that were returned. The original purchase was recorded on October 25. 29 Sold merchandise on credit for $3,120 plus sales tax of $156 to Emily Tran, Sales Slip 245 29 Recorded the October payroll. The records prepared by the payroll service show the following totals: earnings, $10,800; social security, $702.00; Medicare, $162.00 income tax, $1,020; and net pay, $8,916. The excess withholdings corrected an error made in withholdings in September 29 Recorded the employer's payroll taxes, which were calculated by the payroll service: social security, $702; Medicare, $162; federal unemployment tax, $118: and state unemployment tax, $584. This, too, reflects an understatement of taxes recorded in September and corrected in this month 30 Purchased merchandise for $4,020 from Today's Woman, Invoice 5821, dated October 26; the terms are 1/10, n/30 31 Issued Checks 616 through 619, totaling $8,916.00, to employees to pay October payroll. 31 Issued Check 620 for $475 to Handy Janitors for October janitorial services. 31 Had cash sales of $1,700 plus sales tax of $85 for October 29-31 The Fashion Rack Chart of Accounts Assets Liabilities 101 Cash 203 Accounts Payable Accounts Receivable 221 Social Security Tax Payable 222 112 Allowance for Doubtful Accounts Medicare Tax Payable 121 Merchandise Inventory 223 Employee Income Tax Payable 131 Supplies 225 Federal Unemployment Tax Payable 133 Prepaid Insurance 227 State Unemployment Tax Payable 135 Prepaid Advertising 229 Salaries Payable 141 Equipment 231 Sales Tax Payable 142 Accumulated Depreciation-Equipment Owner's Equity Expenses 301 Teresa Lojay, Capital 611 Advertising Expense 302 Teres Lojay, Drawing 614 Depreciation Expense-Equipment 617 Insurance Expense 399 Income Summary Revenues 620 Uncollectible Accounts Expense Revenues 620 Uncollectible Accounts Expense 401 Sales 623 Janitorial Services Expense 402 Returns and Allowances 626 Payroll Taxes Expense Cost of Goods Sold 629 Rent Expense 501 Purchases 632 Salaries Expense 502 Freight In 635 Supplies Expense 503 Purchases Returns and Allowances 638 Telephone Expense 504 Purchases Discounts 644 Utilities Expense 5. Check the accuracy of the subsidiary ledgers by preparing a schedule of accounts receivable and a schedule of accounts payable as of October 31, 2019. Compare the totals with the balances of the Accounts Receivable account and the Accounts Payable account in the general ledger 6. Check the accuracy of the general ledger by preparing a trial balance in the first two columns of a 10-column worksheet. Make sure that the total debits and the total credits are equal 7. Complete the Adjustments section of the worksheet. Use the following data. Identify each adjustment with the appropriate letter. 7. Complete the Adjustments section of the worksheet. Use the following data. Identify each adjustment with the appropriate letter During October, the firm had net credit sales of $9,810. From experience with similar businesses, the previous accountant had estimated that 1.0 percent of the firm's net credit sales would result in uncollectible accounts. Record an adjustment for the expected loss from uncollectible accounts for the month of October. On October 31, an inventory of the supplies showed that items costing $3,240 were on hand. Record an adjustment for the supplies used in October On September 30, 2019, the firm purchased a six-month insurance policy for $8,400. Record an adjustment for the C. expired insurance for October. On October 1, 2019, the firm signed a three-month advertising contract for $4,800 with a local cable television station and paid the full amount in advance. Record an adjustment for the expired advertising for October. On April 1, 2019, the firm purchased equipment for $83,000. The equipment was estimated to have a useful life of five d. e. years and a salvage value of $12,500. Record an adjustment for depreciation on the equipment for October f. Based on a physical count, ending merchandise inventory was determined to be $81,260. 8. Complete the Adjusted Trial Balance section of the worksheet. 9. Determine the net income or net loss for October and complete the worksheet. 10. Prepare a classified income statement for the month ended October 31, 2019. (The firm does not divide its operating expenses into selling and administrative expenses.) 11. Prepare a statement of owner's equity for the month ended October 31, 2019 12. Prepare a classified balance sheet as of October 31, 2019 13. Journalize and post the adjusting entries using general journal page 17 14. Prepare and post the closing entries using general journal page 18 15. Prepare a postclosing trial balance