| 1.Complete the posting of 20X2 special journals manually. |
| 2.Prepare an unadjusted trial balance using the adjustment worksheet for 20X2. |
| 3.Prepare the required 20X2 adjusting journal entries on the designated excel sheet |
| 4.Post the adjusting entries to the adjustment worksheet for 20X2. |
| 5.Prepare and adjusted trial balance using the adjustment worksheet for 20X2. |
| 6.Prepare an Income Statement for 20x2 on the designated excel sheet. |
| 7.Prepare a Statement of Shareholders' Equity on the designated excel sheet. |
| 8.Prepare a Balance Sheet on the designated excel sheet. |
| 9.Prepare two Statement of Cash Flows on the designated excel sheet. One using the direct method and the second using the indirect method. |
| 10.Prepare the closing entries for 20X2 on the designated excel sheet. |
Ensure that your beginning balances for this assignment tie to the amounts below. If they do not, journalize a correcting entry in the general journal and post it to the general ledger. Credit Debit 288,050 17,460 570 250 1,320 33,600 Cash Accounts receivable Office supplies Kitchen supplies Prepaid insurance Automobile Accumulated depreciation Computer Accumulated depreciation Copier Accumulated depreciation Accounts payable Taxes payable Professional services payable Dividends payable Common stock Additional paid-in capital Retained earnings 4,200 2,670 534 3,540 708 840 2,710 380 1,480 74,000 259,000 3,608 347,460 347,460 The Board of Directors declared dividends as follows Date Dividend per Share Payment Date 30-Jun $ 30-Oct $ 0.05 0.05 15-Jul 15-Nov Sales Journal for 20X2 Date Customer Number 14-Jan Customer 1013 15-Feb Customer 1014 2-Mar Customer 1015 6-Apr Customer 1016 9-May Customer 1017 1-Jun Customer 1018 14-Jul Customer 1019 20-Aug Customer 1020 3-Sep Customer 1021 11-Oct Customer 1022 7-Nov Customer 1023 25-Nov Customer 1024 9-Dec Customer 1025 12,810 13,530 3,970 11,130 12,730 4,060 10,620 13,550 12,740 13,760 14,520 4,260 11,930 139,610 Total Cash Receipts for 20X2 Customer Number Cash 6-Jan Customer 1012 3,600 3,000 5,600 5,260 21-Jan Customer 1012 21-Jan Customer 1011 11-Feb Customer 1012 13-Feb Customer 1013 3-Mar Customer 1013 17-Mar Customer 1014 24-Mar Customer 1013 1-Apr Customer 1015 4-Apr Customer 101 19-Apr Customer 1015 25-Apr Customer 1014 6-May Customer 1016 10-May Customer 1015 24-May Customer 1016 8-Jun Customer 1017 14-Jun Customer 1016 26-Jun Customer 1017 1-Jul Customer 1018 17-Jul Customer 1017 19-Jul Customer 1018 9-Aug Customer 1018 13-Aug Customer 1019 31-Aug Customer 1019 19-Sep Customer 1020 21-Sep Customer 1019 3-0ct Customer 1021 7-Oct Customer 1020 21-Oct Customer 1021 28-0ct Customer 1020 10-Nov Customer 1022 11-Nov Customer 1021 4,100 1,200 6,030 3,300 1,770 2,800 3,800 5,030 3,200 5,730 1,000 1,860 3,200 2,700 4,100 3,800 3,200 6,050 4,100 5,740 3,400 4,400 6,260 1,300 3,600 135,660 28-Nov Customer 1022 7-Dec Customer 1023 19-Dec Customer 1022 25-Dec Customer 1024 25-Dec Customer 1023 Purchases Journal for 20X2 Kitchen Supplies* Due Date Vendor Date 4-Feb 27-Feb 21-Mar 5-Apr 1-May 25-May 16-Jun 5-Jul 5-Aug 5-Sep 4-Oct 14-Nov 3-Jan 14-Jan 610 130 580 630 780 740 440 190 800 510 60 80 840 880 7,270 5-Jan Costco 28-Jan Costco 19-Feb Costco 6-Mar Costco 1-Apr Costco 25-Apr Costco 17-May Costco 5-Jun Costco 6-Jul Costco 6-Aug Costco 4-Sep Costco 15-Oct Costco 4-Dec Costco 15-Dec Costco Total *Classify the purchases of kitchen supplies as kitchen supplies expense Cash Disbursements Journal for 20X2 Utilities Salaries Accts Payable 1,980 Check Number 1,440 1,980 Computer 1.077 Lusy Landlord 4,200 Copier 1480 Dividends 4,200 380 Professional services 3,400 Alison the Architect 087 Huge Utility Company 1,440 20X1 tax liability 710 2710 Big Phone Company 1,093 Alison the Architect 3,400 3,400 1,900 1,900 3,262 Insurance ce supplies Phone Com 3,400 1,900 1,440 04 Big Phone Company 3,400 3,400 1,900 1106 Huge Utility Company 1,440 880 Insurance 740 3,400 Estimated tax payment 3,150 1,116 Internal Revenue Service 1118 Big Phone Company 3,400 3,400 1,900 1,440 1,900 Huge Utility Company 190 1,122 Costco Visa 3,700 Dividends 3,700 450 Big Phone Comp 3,400 1.900 1.126 Huge Utility Company Utilities Phone Rent Salaries Accts Payable Date Check Number 450 3.400 1,900 1,130 Alison the Architect 1,900 510 150 Estimated tax payment 1,133 Costco Visa 3,400 1,136 Alison the Architect 1,900 1,440 3,430 Insurance 1,139 Insurance for office 450 1,142 Alison the Architect 3,400 1,900 1,900 1,146 Shareholders 3,700 Dividends 1,620 1,149 Alison the Architect 3,400 3,400 1,153 Alison the Architect 1,154 Huge Utility Company 1,900 22,800 131,542 390 40,800 17,280 5,400 ,300 33,572 Classify supplies as office supplies on hand Insurance for automobile is prepayment for 8 months "Insurance for office is a prepayment for 7 months Information for adjustments Ending office s Ending kitchen supplies on hand Accrue professional service costs Dividends per share declared December 31 Ensure that your beginning balances for this assignment tie to the amounts below. If they do not, journalize a correcting entry in the general journal and post it to the general ledger. Credit Debit 288,050 17,460 570 250 1,320 33,600 Cash Accounts receivable Office supplies Kitchen supplies Prepaid insurance Automobile Accumulated depreciation Computer Accumulated depreciation Copier Accumulated depreciation Accounts payable Taxes payable Professional services payable Dividends payable Common stock Additional paid-in capital Retained earnings 4,200 2,670 534 3,540 708 840 2,710 380 1,480 74,000 259,000 3,608 347,460 347,460 The Board of Directors declared dividends as follows Date Dividend per Share Payment Date 30-Jun $ 30-Oct $ 0.05 0.05 15-Jul 15-Nov Sales Journal for 20X2 Date Customer Number 14-Jan Customer 1013 15-Feb Customer 1014 2-Mar Customer 1015 6-Apr Customer 1016 9-May Customer 1017 1-Jun Customer 1018 14-Jul Customer 1019 20-Aug Customer 1020 3-Sep Customer 1021 11-Oct Customer 1022 7-Nov Customer 1023 25-Nov Customer 1024 9-Dec Customer 1025 12,810 13,530 3,970 11,130 12,730 4,060 10,620 13,550 12,740 13,760 14,520 4,260 11,930 139,610 Total Cash Receipts for 20X2 Customer Number Cash 6-Jan Customer 1012 3,600 3,000 5,600 5,260 21-Jan Customer 1012 21-Jan Customer 1011 11-Feb Customer 1012 13-Feb Customer 1013 3-Mar Customer 1013 17-Mar Customer 1014 24-Mar Customer 1013 1-Apr Customer 1015 4-Apr Customer 101 19-Apr Customer 1015 25-Apr Customer 1014 6-May Customer 1016 10-May Customer 1015 24-May Customer 1016 8-Jun Customer 1017 14-Jun Customer 1016 26-Jun Customer 1017 1-Jul Customer 1018 17-Jul Customer 1017 19-Jul Customer 1018 9-Aug Customer 1018 13-Aug Customer 1019 31-Aug Customer 1019 19-Sep Customer 1020 21-Sep Customer 1019 3-0ct Customer 1021 7-Oct Customer 1020 21-Oct Customer 1021 28-0ct Customer 1020 10-Nov Customer 1022 11-Nov Customer 1021 4,100 1,200 6,030 3,300 1,770 2,800 3,800 5,030 3,200 5,730 1,000 1,860 3,200 2,700 4,100 3,800 3,200 6,050 4,100 5,740 3,400 4,400 6,260 1,300 3,600 135,660 28-Nov Customer 1022 7-Dec Customer 1023 19-Dec Customer 1022 25-Dec Customer 1024 25-Dec Customer 1023 Purchases Journal for 20X2 Kitchen Supplies* Due Date Vendor Date 4-Feb 27-Feb 21-Mar 5-Apr 1-May 25-May 16-Jun 5-Jul 5-Aug 5-Sep 4-Oct 14-Nov 3-Jan 14-Jan 610 130 580 630 780 740 440 190 800 510 60 80 840 880 7,270 5-Jan Costco 28-Jan Costco 19-Feb Costco 6-Mar Costco 1-Apr Costco 25-Apr Costco 17-May Costco 5-Jun Costco 6-Jul Costco 6-Aug Costco 4-Sep Costco 15-Oct Costco 4-Dec Costco 15-Dec Costco Total *Classify the purchases of kitchen supplies as kitchen supplies expense Cash Disbursements Journal for 20X2 Utilities Salaries Accts Payable 1,980 Check Number 1,440 1,980 Computer 1.077 Lusy Landlord 4,200 Copier 1480 Dividends 4,200 380 Professional services 3,400 Alison the Architect 087 Huge Utility Company 1,440 20X1 tax liability 710 2710 Big Phone Company 1,093 Alison the Architect 3,400 3,400 1,900 1,900 3,262 Insurance ce supplies Phone Com 3,400 1,900 1,440 04 Big Phone Company 3,400 3,400 1,900 1106 Huge Utility Company 1,440 880 Insurance 740 3,400 Estimated tax payment 3,150 1,116 Internal Revenue Service 1118 Big Phone Company 3,400 3,400 1,900 1,440 1,900 Huge Utility Company 190 1,122 Costco Visa 3,700 Dividends 3,700 450 Big Phone Comp 3,400 1.900 1.126 Huge Utility Company Utilities Phone Rent Salaries Accts Payable Date Check Number 450 3.400 1,900 1,130 Alison the Architect 1,900 510 150 Estimated tax payment 1,133 Costco Visa 3,400 1,136 Alison the Architect 1,900 1,440 3,430 Insurance 1,139 Insurance for office 450 1,142 Alison the Architect 3,400 1,900 1,900 1,146 Shareholders 3,700 Dividends 1,620 1,149 Alison the Architect 3,400 3,400 1,153 Alison the Architect 1,154 Huge Utility Company 1,900 22,800 131,542 390 40,800 17,280 5,400 ,300 33,572 Classify supplies as office supplies on hand Insurance for automobile is prepayment for 8 months "Insurance for office is a prepayment for 7 months Information for adjustments Ending office s Ending kitchen supplies on hand Accrue professional service costs Dividends per share declared December 31
