Can someone set this up in excel please, thank you

The following journals should be included in your accounting for the company: - Sales Journal - Cash Receipts Journal - Purchases Journal - Cash Payments Journal - General Joumal The trial balance for November is included. The accounts receivable and accounts payable ledgers for November are also included. Cash sales are recorded at the end of each week. All sales on account are subject to terms of 2/10,n/30. All purchases on account are subject to terms of 3/15,n/30.Totals of the Special Journals should be posted to the General Ledger weekly. Instructions 1. Post the balances from the trial balance to the appropriate General Ledger accounts. 2. Post the balances from the accounts receivable and accounts payable totals for Nov. to the ledgers. 3. Post all transactions for December to the appropriate joumals and ledgers. 4. Prepare a trial balance for December. 5. Prepare a schedule of accounts receivable and accounts payable for the end of December. 6. Journalize and post the adjusting entries based on the following information. 7. a. Allowance for Doubtful accounts should be 10% of total accounts receivable for the year. b. Inventory at December 31st is: - Computers - Other computer equipment - Office supplies - Store supplies c. Insurance expired December 31st d. Depreciation is straight line - Building - Office Equipment - Store Equipment e. Accrued Salaries: - Sales Salaries - Officers' Salaries - Office Salaries $123.879.41 97,359.22 539.42 2,768.39 3,275.00 16,750.00 3,111.00 247.00 3,147.00 1,500.00 220.00 8. Prepare financial statements for year end 9. Joumalize and post-closing entries 10.Prepare a post-closing trial balance Trial Balance November 30,20XX \begin{tabular}{|c|c|c|} \hline Cash & $149,372.55 & \\ \hline Petty Cash & 400.00 & \\ \hline Accounts Receivable & 21,761.00 & \\ \hline Allowance for Doubtful Accounts & & 1,232.00 \\ \hline Inventory - Computers & 150,732.00 & \\ \hline Inventory - Other Computer Equipment & 100,997.47 & \\ \hline Store Supplies & 1,502.00 & \\ \hline Office Supplies & 273.00 & \\ \hline Prepaid Insurance & 10,373.00 & \\ \hline Land & 40,000.00 & \\ \hline Building & 150,000.00 & \\ \hline Accumulated Depreciation - Building & & 22,479.00 \\ \hline Office Equipment & 10,964.22 & \\ \hline Accumulated Depreciation - Office Equipment & & 4,792.00 \\ \hline Store Equipment & 1,562.00 & \\ \hline Accumulated Depreciation - Store Equipment & & 947.00 \\ \hline Accounts Payable & & 9,444.00 \\ \hline \multicolumn{3}{|l|}{ Salaries Payable } \\ \hline \multicolumn{3}{|l|}{ Federal Income Tax Payable } \\ \hline \multicolumn{3}{|l|}{ FICA Tax Payable } \\ \hline \multicolumn{3}{|l|}{ State Unemployment Tax Payable } \\ \hline \multicolumn{3}{|l|}{ Federal Unemployment Tax Payable } \\ \hline \multicolumn{3}{|l|}{ Cash Dividend Payable } \\ \hline Notes Payable & & 50,000.00 \\ \hline Common Stock, \$10 PAR & & 270,000.00 \\ \hline Preferred Stock, \$100 PAR & & 80,000.00 \\ \hline Paid In Excess - Common Stock & & 50,000.00 \\ \hline \multicolumn{3}{|l|}{ Paid In Excess - Preferred Stock } \\ \hline Retained Earnings & & 46,206.75 \\ \hline Cash Dividends & 14,700.00 & \\ \hline Sales - Computers & & 379,374.00 \\ \hline Sales - Other Computer Equipment & & 422,978.00 \\ \hline Sales - Computer Services & & 110,947.00 \\ \hline Sales Returns \& Allowances & 398.53 & \\ \hline Sales Discounts & 1,957.63 & \\ \hline Purchases - Computers & 397,532.97 & \\ \hline Purchases - Other Computer Equipment & 214,125.79 & \\ \hline Purchase Returns and Allowances & & 273.00 \\ \hline Purchase Discounts & & 975.42 \\ \hline Freight Expense & 943.47 & \\ \hline Sales Salaries Expense & 63,753.00 & \\ \hline Officers' Salaries Expense & 44,000.00 & \\ \hline Office Salaries Expense & 12,870.00 & \\ \hline Advertising Expense & 22,473.00 & \\ \hline \end{tabular} December Transactions Record each of the following transactions in the appropriate journal. Received a check for $3,136.00 from Shore Properties, Inc. in payment of our invoice of Nov 22 for $3,200.00, less discount. Sold merchandise on account to McBooks Bookstore, Invoice \# 707 ; computers, $749.00; peripherals, $675.00. Issued check \#1102 for $1,989.40 to Southeast Computers in payment of their Nov invoice of $2,030 for computers. Purchased store supplies on account from Chung Store Supplies \& Equipment Co., for \$395. Issued check \#1103 for $360 to Jefferson Insurance Agency for the premium on a $40,000 policy for one year beginning December 1 . Issued check \#1104 for $1,397 to Bellevue Advertising for store advertising materials. Issued check \#1105 for $3,275 to the Orlando Tabloid for newspaper advertising for the month of Nov. Sold computers on account to Botero Exporters, Inc., invoice \#708, for \$5,475. Issued check \#1106 for $9,349 to Joe's Furniture for the purchase of new office equipment for the office. Received an invoice for $747 from Wee, Cheatum \& Howe, Attomeys for legal services. Purchased computers on account for $7,449 from Southeast Computers. Purchased peripherals on account from Computer Supply, Inc. for $3,468. Cash sales for Dec 13 were as follows: peripherals, $10,432; computers, $7,357. Received a check for \$2,058 from Kenya \& Sons Developers in payment of our invoice of Nov. 25 for $2,100, less discount Sold computers on account to Shore Properties Inc., Invoice #709, for $979. Declared dividends, payable on Dec 20, to stockholders of record on Dec 13, as follows: a. Quarterly cash dividends of $1.00 per share on common stock outstanding b. Quarterly cash dividends of $3.00 per share on preferred stock outstanding. Issued check \#1107 for $7,483 to Hal Computers for the purchase of computers. Purchased \$865 of office supplies and \$1,234 of store supplies on account from Office Staples. Issued check \#1108 for $842 to Larry's Roofing, Inc. for roof repair and maintenance. Received a check for $4,108 from Silk Preparatory School in payment of our invoice of Nov 29 for $4,100, less discount. Completed servicing and installing computers for Ortega Investments and billed them $12,493, Invoice \#710, for professional services. Received a check for $5,586 from Johnson Construction Company in payment of our invoice of Nov 30 for $5,700, less discount. Dec8 Sold computers on account to McBoolss Bookstore, invoice #711, for $1,550. Dec 8 Issued check #1109 for $279 to Nhung Tran for plumbing repair. Dec 9 Received a check for $749 from Orlando Professional Plaza in payment of our invoice of Nov 14. Dec 9 Received a check for $130 from Office Staples for the retum of office supplies previously purchased for cash. Dec 9 Sold computer servicing services on account to Page \& Associates, Invoice \#712, for \$1,542. Dec 9 Issued check \#1110 for $675 to Arthur Gotts for accounting Services for the month of Nov. Dec 10 Record the biweekly payroll in the general joumal, details as follows: \begin{tabular}{lc} Sales Salaries & $3,590 \\ Office Salaries & 585 \\ Officers' Salaries & 2,000 \\ Income Tax withheld & 1,850 \\ FICA tax withheld & 432.25 \end{tabular} Dec 10 Issued check \#1111 for $3,892.75 to Payroll Bank Account in payment of the net payroll. Dec 10 Record the employer's payroll taxes: \begin{tabular}{lc} FICA tax & $432.25 \\ SUTA tax & 168.22 \\ FUTA tax & 19.42 \end{tabular} Dec10 Issued check \#1112 to the Metro National Bank in payment of payroll taxes: \begin{tabular}{ll} FICA tax & $864.50 \\ Employees' FIT & 1,850 \end{tabular} Dec 10 Cash sales for the week ended Dec 10 were as follows: computers, $6,947; peripherals, $783; servicing, $947. Dec 12 Received a check for $1,737 from Mark Taylor, JD in payment of our invoice of Nov 15 for $1,737. Dec 12 Received a check for $1,395.52 from McBoolss Bookstore in payment of our invoice for $1,424, less discount. Dec 12 Received a check for $5,365.50 from Botero Exports in payment of our invoice for $5,475, less discount. Dec 12 Sold computers on account to Kenya \& Sons, invoice \#713, for $4,319. Dec 13 Issued check \#1113 for $373.22 to Orlando Power and Light for electricity. Dec 14 Sold an additional 10,000 shares of common stock for $230,000. Dec 14 Purchased computers on account from Southeast Computers for $9,310. Dec 14 Issued check \#1114 for \$132.22 to Bell Telephone Company. Dec 15 Issued check \#1115 for $63.22 to Orlando Water for water and sewer charges. Dec 17 Received a check for $979 from Shore Properties, Inc. in payment of our invoice, no discount. Dec 17 Cash sales for the week ended Dec 17 were as follows: computers, $7,492; peripherals, $1,532; servicing, $737. Dec18 Dec19 Dec 20 Dec 24 Dec 24 Dec 24 Dec 24 Dec 24 Dec 31 Dec 31 Received a check for $1,519 from McBoolss Bookstore in payment of our invoice for $1,550, less discount. Issued check \#1116 for \$175 to Sam's Janitorial Services for cleaning. Issued check \#1117 to the Metro National Bank for the cash dividends previously declared. Record the biweekly payroll, details as follows: \begin{tabular}{lr} Sales Salaries & $3,674 \\ Office Salaries & 585 \\ Officers' Salaries & 2,000 \\ FIT withheld & 1,422 \\ FICA withheld & 434 \end{tabular} Issued check \#1118 for $4,403 to Payroll Bank Account in payment of net payroll. Record the employer's payroll taxes: \begin{tabular}{lc} FICA Tax & $434 \\ SUTA Tax & 92.75 \\ FUTA Tax & 13.42 \end{tabular} Issued check \#1119 to the Metro National Bank in payment of payroll taxes: FICA taxes $868 Employees' FIT 1,422 Cash sales for the week ended Dec 24 were as follows: computers, $6,421; peripherals, $1,327. Cash sales for the week ended Dec 31 were as follows: computers, $1,573; peripherals, $679. Issued check \#1120 for $312.49 to replenish the petty cash fund. Payments from the fund are as follows: Store Supplies, \$142.99; Office Supplies, \$152.27; Freight In, \$17.23. The following journals should be included in your accounting for the company: - Sales Journal - Cash Receipts Journal - Purchases Journal - Cash Payments Journal - General Joumal The trial balance for November is included. The accounts receivable and accounts payable ledgers for November are also included. Cash sales are recorded at the end of each week. All sales on account are subject to terms of 2/10,n/30. All purchases on account are subject to terms of 3/15,n/30.Totals of the Special Journals should be posted to the General Ledger weekly. Instructions 1. Post the balances from the trial balance to the appropriate General Ledger accounts. 2. Post the balances from the accounts receivable and accounts payable totals for Nov. to the ledgers. 3. Post all transactions for December to the appropriate joumals and ledgers. 4. Prepare a trial balance for December. 5. Prepare a schedule of accounts receivable and accounts payable for the end of December. 6. Journalize and post the adjusting entries based on the following information. 7. a. Allowance for Doubtful accounts should be 10% of total accounts receivable for the year. b. Inventory at December 31st is: - Computers - Other computer equipment - Office supplies - Store supplies c. Insurance expired December 31st d. Depreciation is straight line - Building - Office Equipment - Store Equipment e. Accrued Salaries: - Sales Salaries - Officers' Salaries - Office Salaries $123.879.41 97,359.22 539.42 2,768.39 3,275.00 16,750.00 3,111.00 247.00 3,147.00 1,500.00 220.00 8. Prepare financial statements for year end 9. Joumalize and post-closing entries 10.Prepare a post-closing trial balance Trial Balance November 30,20XX \begin{tabular}{|c|c|c|} \hline Cash & $149,372.55 & \\ \hline Petty Cash & 400.00 & \\ \hline Accounts Receivable & 21,761.00 & \\ \hline Allowance for Doubtful Accounts & & 1,232.00 \\ \hline Inventory - Computers & 150,732.00 & \\ \hline Inventory - Other Computer Equipment & 100,997.47 & \\ \hline Store Supplies & 1,502.00 & \\ \hline Office Supplies & 273.00 & \\ \hline Prepaid Insurance & 10,373.00 & \\ \hline Land & 40,000.00 & \\ \hline Building & 150,000.00 & \\ \hline Accumulated Depreciation - Building & & 22,479.00 \\ \hline Office Equipment & 10,964.22 & \\ \hline Accumulated Depreciation - Office Equipment & & 4,792.00 \\ \hline Store Equipment & 1,562.00 & \\ \hline Accumulated Depreciation - Store Equipment & & 947.00 \\ \hline Accounts Payable & & 9,444.00 \\ \hline \multicolumn{3}{|l|}{ Salaries Payable } \\ \hline \multicolumn{3}{|l|}{ Federal Income Tax Payable } \\ \hline \multicolumn{3}{|l|}{ FICA Tax Payable } \\ \hline \multicolumn{3}{|l|}{ State Unemployment Tax Payable } \\ \hline \multicolumn{3}{|l|}{ Federal Unemployment Tax Payable } \\ \hline \multicolumn{3}{|l|}{ Cash Dividend Payable } \\ \hline Notes Payable & & 50,000.00 \\ \hline Common Stock, \$10 PAR & & 270,000.00 \\ \hline Preferred Stock, \$100 PAR & & 80,000.00 \\ \hline Paid In Excess - Common Stock & & 50,000.00 \\ \hline \multicolumn{3}{|l|}{ Paid In Excess - Preferred Stock } \\ \hline Retained Earnings & & 46,206.75 \\ \hline Cash Dividends & 14,700.00 & \\ \hline Sales - Computers & & 379,374.00 \\ \hline Sales - Other Computer Equipment & & 422,978.00 \\ \hline Sales - Computer Services & & 110,947.00 \\ \hline Sales Returns \& Allowances & 398.53 & \\ \hline Sales Discounts & 1,957.63 & \\ \hline Purchases - Computers & 397,532.97 & \\ \hline Purchases - Other Computer Equipment & 214,125.79 & \\ \hline Purchase Returns and Allowances & & 273.00 \\ \hline Purchase Discounts & & 975.42 \\ \hline Freight Expense & 943.47 & \\ \hline Sales Salaries Expense & 63,753.00 & \\ \hline Officers' Salaries Expense & 44,000.00 & \\ \hline Office Salaries Expense & 12,870.00 & \\ \hline Advertising Expense & 22,473.00 & \\ \hline \end{tabular} December Transactions Record each of the following transactions in the appropriate journal. Received a check for $3,136.00 from Shore Properties, Inc. in payment of our invoice of Nov 22 for $3,200.00, less discount. Sold merchandise on account to McBooks Bookstore, Invoice \# 707 ; computers, $749.00; peripherals, $675.00. Issued check \#1102 for $1,989.40 to Southeast Computers in payment of their Nov invoice of $2,030 for computers. Purchased store supplies on account from Chung Store Supplies \& Equipment Co., for \$395. Issued check \#1103 for $360 to Jefferson Insurance Agency for the premium on a $40,000 policy for one year beginning December 1 . Issued check \#1104 for $1,397 to Bellevue Advertising for store advertising materials. Issued check \#1105 for $3,275 to the Orlando Tabloid for newspaper advertising for the month of Nov. Sold computers on account to Botero Exporters, Inc., invoice \#708, for \$5,475. Issued check \#1106 for $9,349 to Joe's Furniture for the purchase of new office equipment for the office. Received an invoice for $747 from Wee, Cheatum \& Howe, Attomeys for legal services. Purchased computers on account for $7,449 from Southeast Computers. Purchased peripherals on account from Computer Supply, Inc. for $3,468. Cash sales for Dec 13 were as follows: peripherals, $10,432; computers, $7,357. Received a check for \$2,058 from Kenya \& Sons Developers in payment of our invoice of Nov. 25 for $2,100, less discount Sold computers on account to Shore Properties Inc., Invoice #709, for $979. Declared dividends, payable on Dec 20, to stockholders of record on Dec 13, as follows: a. Quarterly cash dividends of $1.00 per share on common stock outstanding b. Quarterly cash dividends of $3.00 per share on preferred stock outstanding. Issued check \#1107 for $7,483 to Hal Computers for the purchase of computers. Purchased \$865 of office supplies and \$1,234 of store supplies on account from Office Staples. Issued check \#1108 for $842 to Larry's Roofing, Inc. for roof repair and maintenance. Received a check for $4,108 from Silk Preparatory School in payment of our invoice of Nov 29 for $4,100, less discount. Completed servicing and installing computers for Ortega Investments and billed them $12,493, Invoice \#710, for professional services. Received a check for $5,586 from Johnson Construction Company in payment of our invoice of Nov 30 for $5,700, less discount. Dec8 Sold computers on account to McBoolss Bookstore, invoice #711, for $1,550. Dec 8 Issued check #1109 for $279 to Nhung Tran for plumbing repair. Dec 9 Received a check for $749 from Orlando Professional Plaza in payment of our invoice of Nov 14. Dec 9 Received a check for $130 from Office Staples for the retum of office supplies previously purchased for cash. Dec 9 Sold computer servicing services on account to Page \& Associates, Invoice \#712, for \$1,542. Dec 9 Issued check \#1110 for $675 to Arthur Gotts for accounting Services for the month of Nov. Dec 10 Record the biweekly payroll in the general joumal, details as follows: \begin{tabular}{lc} Sales Salaries & $3,590 \\ Office Salaries & 585 \\ Officers' Salaries & 2,000 \\ Income Tax withheld & 1,850 \\ FICA tax withheld & 432.25 \end{tabular} Dec 10 Issued check \#1111 for $3,892.75 to Payroll Bank Account in payment of the net payroll. Dec 10 Record the employer's payroll taxes: \begin{tabular}{lc} FICA tax & $432.25 \\ SUTA tax & 168.22 \\ FUTA tax & 19.42 \end{tabular} Dec10 Issued check \#1112 to the Metro National Bank in payment of payroll taxes: \begin{tabular}{ll} FICA tax & $864.50 \\ Employees' FIT & 1,850 \end{tabular} Dec 10 Cash sales for the week ended Dec 10 were as follows: computers, $6,947; peripherals, $783; servicing, $947. Dec 12 Received a check for $1,737 from Mark Taylor, JD in payment of our invoice of Nov 15 for $1,737. Dec 12 Received a check for $1,395.52 from McBoolss Bookstore in payment of our invoice for $1,424, less discount. Dec 12 Received a check for $5,365.50 from Botero Exports in payment of our invoice for $5,475, less discount. Dec 12 Sold computers on account to Kenya \& Sons, invoice \#713, for $4,319. Dec 13 Issued check \#1113 for $373.22 to Orlando Power and Light for electricity. Dec 14 Sold an additional 10,000 shares of common stock for $230,000. Dec 14 Purchased computers on account from Southeast Computers for $9,310. Dec 14 Issued check \#1114 for \$132.22 to Bell Telephone Company. Dec 15 Issued check \#1115 for $63.22 to Orlando Water for water and sewer charges. Dec 17 Received a check for $979 from Shore Properties, Inc. in payment of our invoice, no discount. Dec 17 Cash sales for the week ended Dec 17 were as follows: computers, $7,492; peripherals, $1,532; servicing, $737. Dec18 Dec19 Dec 20 Dec 24 Dec 24 Dec 24 Dec 24 Dec 24 Dec 31 Dec 31 Received a check for $1,519 from McBoolss Bookstore in payment of our invoice for $1,550, less discount. Issued check \#1116 for \$175 to Sam's Janitorial Services for cleaning. Issued check \#1117 to the Metro National Bank for the cash dividends previously declared. Record the biweekly payroll, details as follows: \begin{tabular}{lr} Sales Salaries & $3,674 \\ Office Salaries & 585 \\ Officers' Salaries & 2,000 \\ FIT withheld & 1,422 \\ FICA withheld & 434 \end{tabular} Issued check \#1118 for $4,403 to Payroll Bank Account in payment of net payroll. Record the employer's payroll taxes: \begin{tabular}{lc} FICA Tax & $434 \\ SUTA Tax & 92.75 \\ FUTA Tax & 13.42 \end{tabular} Issued check \#1119 to the Metro National Bank in payment of payroll taxes: FICA taxes $868 Employees' FIT 1,422 Cash sales for the week ended Dec 24 were as follows: computers, $6,421; peripherals, $1,327. Cash sales for the week ended Dec 31 were as follows: computers, $1,573; peripherals, $679. Issued check \#1120 for $312.49 to replenish the petty cash fund. Payments from the fund are as follows: Store Supplies, \$142.99; Office Supplies, \$152.27; Freight In, \$17.23