INSTRUCTIONS

hong SI Xot Create Share Credit Debit 7 258 12,650 3,458 3,600 6,000 12,000 + Add to ter 2 Trial Balance 3 4 Accounting Solutions Co. 5 Unadjusted Trial Balance 6 12/31/2020 7 Acct # Account Name 8 101 Cash 9 106 Accounts Receivable 10 126 Supplies 11 128 Prepaid Insurance 12 163 Office Furniture 13 164 Accumulated Depreciation - Office Furniture 14 167 Computer Equipment 15 168 Accumulated Depreciation - Computer Equipment 16 201 Accounts Payable 17 210 Wages Payable 18 236 Unearned Revenue 19 301 S. Martin, Capital 20 302 S. Martin, Withdrawals 21 403 Accounting Services Revenue 22 612 Depreciation Expense - Office Furniture 23 613 Depreciation Expense - Computer Equipment 24 623 Wages Expense 25 637 Insurance Expense 26 640 Rent Expense 27 652 Supplies Expense 28 655 Advertising Expense 29 676 Mileage Expense 30 677 Miscellaneous Expense 31 32 Totals 8.221 6,350 16,500 . 1.913 83,508 42,685 16,850 3,125 1,850 3,190 114,579 114,579 GENERAL LEDGER Cash P.R. DEBIT Explanation ACCOUNT NO CREDIT Bal-Debit 7,258 101 Bal-Credit Explanation Accounts Receivable P.R. DEBIT ACCOUNT NO. CREDIT Bal-Debit 12.650 106 Bal-Credit Explanation Supplies P.R. ACCOUNT NO CREDIT Bal-Debit 3.458 126 Bal-Credit DEBIT Prepaid Insurance P.R. DEBIT Explanation ACCOUNT NO CREDIT Bal-Debit 3,600 128 Bal-Credit Explanation Office Furliture P.R DEBIT 5 7 Date 8 31-Dec 9 10 11 12 13 Date 14 31-Dec 15 16 17 18 19 Date 20 31-Dec 21 22 23 24 25 Date 26 31-Dec 27 28 29 30 31 Date 32 31-Dec 33 34 35 36 Date 37 31-Dec 38 39 40 41 42 Date 43 31-Dec 44 45 46 47 48 Date 49 31-Dec 50 51 52 53 54 Date 55 31-Dec 56 57 58 ACCOUNT NO CREDIT Bal-Debit 6.000 163 Bal-Credit &m Accumulated Depreciation - Office Furniture ACCOUNT NO Explanation P.R. DEBIT CREDIT Bal-Debit 164 Bal-Credit Computer Equipment Explanation P.R. DEBIT ACCOUNT NO. CREDIT Bal-Debit 12,000 167 Bal-Credit Accumulated Depreciation - Computer Equipment ACCOUNT NO Explanation P.R. DEBIT CREDIT Bal-Debit 158 Bal-Credit Accounts Payable P.R DEBIT ACCOUNT NO CREDIT Bal-Debit Explanation 201 Bal-Credit 8.221 Wages Payable P.R. DEBIT 898889 ACCOUNT NO CREDIT Bal-Debit 210 Bal-Credit 60 Date 61 62 53 Explanation 4 88 GENERAL LEDGER Uneamed Revenue PR DEBIT Explanation ACCOUNT NO CREDIT Bal-Debit 235 Bal-Credit 6,350 Explanation S Martin Capital PR DEBIT ACCOUNT NO CREDIT Bal-Debit 56 Date 57 31-Dec 68 59 70 71 72 Date 73 31-Dec 74 75 75 77 78 Date 79 31-Dec 80 31 32 301 Bal Credit 16,500 Explanation S Martin, Withdrawals PR DEBIT ACCOUNT NO CREDIT Bal-Debit 1.913 302 Bal-Credit Accounting Services Revenue Explanation P.R. DEBIT ACCOUNT NO CREDIT Bal-Debit 400 Bal-Credit 83,508 Depreciation Expense - Office Furniture ACCOUNT NO. Explanation PR DEBIT CREDIT Bal-Debit 612 Bal Credit 04 Date 85 31-Dec 86 87 88 39 90 Date 91 92 93 94 95 96 Date 97 98 99 100 101 102 Date 103 31-Dec 104 105 Depreciation Expense - Computer Equipment ACCOUNT NO Explanation P.R DEBIT CREDIT Bal-Debit 613 Bal-Credit Explanation Wages Expense PR DEBIT ACCOUNT NO CREDIT Bal-Debit 42,685 623 Bal-Credit 106 Insurance Expense P.R DEBIT Explanation ACCOUNT NO CREDIT Bal-Debit 637 Bal-Credit Rent Expense P.R. DEBIT Explanation 107 108 Date 1090 110 111 112 113 114 Date 115 31-Dec 116 117 118 119 120 Date 121 31-Dec 122 93 ACCOUNT NO CREDIT Bal-Debit 16,850 640 Bal-Credit Explanation Supplies Expense P.R. DEBIT ACCOUNT NO. CREDIT Bal-Debit 652 Bal-Credit Explanation Advertising Expense P.R. DEBIT ACCOUNT NO. CREDIT Bal-Debit 3.125 656 Bal-Credit 127 Mileage Expense P.R. DEBIT Explanation ACCOUNT NO. CREDIT Bal-Debit 1,850 676 Bal-Credit 125 126 Date 31-Dec 128 129 130 131 132 Date 133 31-Dec 134 135 136 137 138 Date 139 31-Dec 140 141 142 143 144 Date 145 146 147 1481 Miscellaneous Expense Explanation P.R. DEBIT ACCOUNT NO. CREDIT Bal-Debit 3,190 677 Bal-Credit Income Summary P.R. DEBIT ACCOUNT NO. CREDIT Bal-Debit 801 Bal-Credit Explanation Date Account Names Post Ref Debit Credit 31-Dec 613 Depreciation Expense - Computer Equipment Accumulated Depreciation - Computer Equipment 4,000 4,000 7 Debit Credit 4 5 Accounting Solutions Co. Adjusted Trial Balance 6 12/31/2020 7 Acct # Account Name 8 101 Cash 9 106 Accounts Receivable 10 126 Supplies 11 128 Prepaid Insurance 12 163 Office Furniture 13 164 Accumulated Depreciation - Office Furniture 14 167 Computer Equipment 15 168 Accumulated Depreciation - Computer Equipment 16 201 Accounts Payable 17 210 Wages Payable 18 236 Unearned Revenue 19 301 S. Martin, Capital 20 302 S. Martin, Withdrawals 21 403 Accounting Services Revenue 22 612 Depreciation Expense - Office Furniture 23 613 Depreciation Expense - Computer Equipment 24 623 Wages Expense 25 637 Insurance Expense 26 640 Rent Expense 27 652 Supplies Expense 28 655 Advertising Expense 9 676 Mileage Expense 0 677 Miscellaneous Expense 1 2 Totals Wurther unadjusted Tralasca RE CL Asments RE Adjusted That Balance DI Income Statement AL alance Sheet Sesto Change Owens SE ERRER Accounting Solutions Co. Income Statement For Year Ended December 31, 2020 Accounting Solutions Co. Balance Sheet December 31, 2020 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 81 2 -3 4 5 6 7 3 photos + A 2 General Journal 3 > 36 4 GENERAL JOURNAL Page: CJ1 Date Account Names Post Ref Debit Credit 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 8 9 3 th Accounting Solutions Co. Post-Closing Trial Balance December 31, 2020 Account Name Acct # Debit Credit 5 6 7 8 9 10 11 12. 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Totals Data and Instructions Sandra Martin owns and operates Accounting Solutions Co., a first-year service business. The beginning balances for all accounts on January I was zero (SO). The accompanying Excel template file includes the Unadjusted Trial Balance for the company as of 12/31/2020. This information is included on the "Unadjusted TB-Dec2020" tab in the Excel workbook The balances in each account in the Unadjusted Trial Balance on December 31, represents the ending balance for and represents all of the activity for the year. As such, the detail of all of the individual transactions for the year is omitted. Unadjusted Trial Balance information is already included in the "GL" tab through cell reference links. Use this information in the "Unadjusted TB-Dec2020" and "GL" tabs as the starting point for your work. The following additional facts were collected for use in making adjusting journal entries prior to preparing financial statements for the year ended 12/31/2020. a. The December 31 inventory count of supplies shows $700 still available. b. Six months have expired since the 12-month insurance premium of $3,600 was paid in advance. c. As of December 31, three employees have not been paid for 2 days of work at $400 per person per day. d. The company's computers, purchased on January 2nd, are expected to have a three-year life with no salvage value. e. The office furniture, also purchased on January 2nd, is expected to have a six-year life with no salvage value. f. The company earned $3,000 of their unearned revenue during the year. Data and Instructions Sandra Martin owns and operates Accounting Solutions Co., a first-year service business. The beginning balances for all accounts on January 1 was zero (SO). The accompanying Excel template file includes the Unadjusted Trial Balance for the company as of 12/31/2020. This information is included on the "Unadjusted TB-Dec2020" tab in the Excel workbook The balances in each account in the Unadjusted Trial Balance on December 31, represents the ending balance for and represents all of the activity for the year. As such, the detail of all of the individual transactions for the year is omitted. Unadjusted Trial Balance information is already included in the "GL" tab through cell reference links. Use this information in the "Unadjusted TB-Dec2020" and "GL"tabs as the starting point for your work The following additional facts were collected for use in making adjusting journal entries prior to preparing financial statements for the year ended 12/31/2020, a. The December 31 inventory count of supplies shows $700 still available. b. Six months have expired since the 12-month insurance premium of $3,600 was paid in advance. c. As of December 31, three employees have not been paid for 2 days of work at $400 per person per day d. The company's computers, purchased on January 2nd, are expected to have a three-year life with no salvage value. e. The office furniture, also purchased on January 2nd, is expected to have a six-year life with no salvage value. f. The company earned $3,000 of their unearned revenue during the year. hong SI Xot Create Share Credit Debit 7 258 12,650 3,458 3,600 6,000 12,000 + Add to ter 2 Trial Balance 3 4 Accounting Solutions Co. 5 Unadjusted Trial Balance 6 12/31/2020 7 Acct # Account Name 8 101 Cash 9 106 Accounts Receivable 10 126 Supplies 11 128 Prepaid Insurance 12 163 Office Furniture 13 164 Accumulated Depreciation - Office Furniture 14 167 Computer Equipment 15 168 Accumulated Depreciation - Computer Equipment 16 201 Accounts Payable 17 210 Wages Payable 18 236 Unearned Revenue 19 301 S. Martin, Capital 20 302 S. Martin, Withdrawals 21 403 Accounting Services Revenue 22 612 Depreciation Expense - Office Furniture 23 613 Depreciation Expense - Computer Equipment 24 623 Wages Expense 25 637 Insurance Expense 26 640 Rent Expense 27 652 Supplies Expense 28 655 Advertising Expense 29 676 Mileage Expense 30 677 Miscellaneous Expense 31 32 Totals 8.221 6,350 16,500 . 1.913 83,508 42,685 16,850 3,125 1,850 3,190 114,579 114,579 GENERAL LEDGER Cash P.R. DEBIT Explanation ACCOUNT NO CREDIT Bal-Debit 7,258 101 Bal-Credit Explanation Accounts Receivable P.R. DEBIT ACCOUNT NO. CREDIT Bal-Debit 12.650 106 Bal-Credit Explanation Supplies P.R. ACCOUNT NO CREDIT Bal-Debit 3.458 126 Bal-Credit DEBIT Prepaid Insurance P.R. DEBIT Explanation ACCOUNT NO CREDIT Bal-Debit 3,600 128 Bal-Credit Explanation Office Furliture P.R DEBIT 5 7 Date 8 31-Dec 9 10 11 12 13 Date 14 31-Dec 15 16 17 18 19 Date 20 31-Dec 21 22 23 24 25 Date 26 31-Dec 27 28 29 30 31 Date 32 31-Dec 33 34 35 36 Date 37 31-Dec 38 39 40 41 42 Date 43 31-Dec 44 45 46 47 48 Date 49 31-Dec 50 51 52 53 54 Date 55 31-Dec 56 57 58 ACCOUNT NO CREDIT Bal-Debit 6.000 163 Bal-Credit &m Accumulated Depreciation - Office Furniture ACCOUNT NO Explanation P.R. DEBIT CREDIT Bal-Debit 164 Bal-Credit Computer Equipment Explanation P.R. DEBIT ACCOUNT NO. CREDIT Bal-Debit 12,000 167 Bal-Credit Accumulated Depreciation - Computer Equipment ACCOUNT NO Explanation P.R. DEBIT CREDIT Bal-Debit 158 Bal-Credit Accounts Payable P.R DEBIT ACCOUNT NO CREDIT Bal-Debit Explanation 201 Bal-Credit 8.221 Wages Payable P.R. DEBIT 898889 ACCOUNT NO CREDIT Bal-Debit 210 Bal-Credit 60 Date 61 62 53 Explanation 4 88 GENERAL LEDGER Uneamed Revenue PR DEBIT Explanation ACCOUNT NO CREDIT Bal-Debit 235 Bal-Credit 6,350 Explanation S Martin Capital PR DEBIT ACCOUNT NO CREDIT Bal-Debit 56 Date 57 31-Dec 68 59 70 71 72 Date 73 31-Dec 74 75 75 77 78 Date 79 31-Dec 80 31 32 301 Bal Credit 16,500 Explanation S Martin, Withdrawals PR DEBIT ACCOUNT NO CREDIT Bal-Debit 1.913 302 Bal-Credit Accounting Services Revenue Explanation P.R. DEBIT ACCOUNT NO CREDIT Bal-Debit 400 Bal-Credit 83,508 Depreciation Expense - Office Furniture ACCOUNT NO. Explanation PR DEBIT CREDIT Bal-Debit 612 Bal Credit 04 Date 85 31-Dec 86 87 88 39 90 Date 91 92 93 94 95 96 Date 97 98 99 100 101 102 Date 103 31-Dec 104 105 Depreciation Expense - Computer Equipment ACCOUNT NO Explanation P.R DEBIT CREDIT Bal-Debit 613 Bal-Credit Explanation Wages Expense PR DEBIT ACCOUNT NO CREDIT Bal-Debit 42,685 623 Bal-Credit 106 Insurance Expense P.R DEBIT Explanation ACCOUNT NO CREDIT Bal-Debit 637 Bal-Credit Rent Expense P.R. DEBIT Explanation 107 108 Date 1090 110 111 112 113 114 Date 115 31-Dec 116 117 118 119 120 Date 121 31-Dec 122 93 ACCOUNT NO CREDIT Bal-Debit 16,850 640 Bal-Credit Explanation Supplies Expense P.R. DEBIT ACCOUNT NO. CREDIT Bal-Debit 652 Bal-Credit Explanation Advertising Expense P.R. DEBIT ACCOUNT NO. CREDIT Bal-Debit 3.125 656 Bal-Credit 127 Mileage Expense P.R. DEBIT Explanation ACCOUNT NO. CREDIT Bal-Debit 1,850 676 Bal-Credit 125 126 Date 31-Dec 128 129 130 131 132 Date 133 31-Dec 134 135 136 137 138 Date 139 31-Dec 140 141 142 143 144 Date 145 146 147 1481 Miscellaneous Expense Explanation P.R. DEBIT ACCOUNT NO. CREDIT Bal-Debit 3,190 677 Bal-Credit Income Summary P.R. DEBIT ACCOUNT NO. CREDIT Bal-Debit 801 Bal-Credit Explanation Date Account Names Post Ref Debit Credit 31-Dec 613 Depreciation Expense - Computer Equipment Accumulated Depreciation - Computer Equipment 4,000 4,000 7 Debit Credit 4 5 Accounting Solutions Co. Adjusted Trial Balance 6 12/31/2020 7 Acct # Account Name 8 101 Cash 9 106 Accounts Receivable 10 126 Supplies 11 128 Prepaid Insurance 12 163 Office Furniture 13 164 Accumulated Depreciation - Office Furniture 14 167 Computer Equipment 15 168 Accumulated Depreciation - Computer Equipment 16 201 Accounts Payable 17 210 Wages Payable 18 236 Unearned Revenue 19 301 S. Martin, Capital 20 302 S. Martin, Withdrawals 21 403 Accounting Services Revenue 22 612 Depreciation Expense - Office Furniture 23 613 Depreciation Expense - Computer Equipment 24 623 Wages Expense 25 637 Insurance Expense 26 640 Rent Expense 27 652 Supplies Expense 28 655 Advertising Expense 9 676 Mileage Expense 0 677 Miscellaneous Expense 1 2 Totals Wurther unadjusted Tralasca RE CL Asments RE Adjusted That Balance DI Income Statement AL alance Sheet Sesto Change Owens SE ERRER Accounting Solutions Co. Income Statement For Year Ended December 31, 2020 Accounting Solutions Co. Balance Sheet December 31, 2020 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 81 2 -3 4 5 6 7 3 photos + A 2 General Journal 3 > 36 4 GENERAL JOURNAL Page: CJ1 Date Account Names Post Ref Debit Credit 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 8 9 3 th Accounting Solutions Co. Post-Closing Trial Balance December 31, 2020 Account Name Acct # Debit Credit 5 6 7 8 9 10 11 12. 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Totals Data and Instructions Sandra Martin owns and operates Accounting Solutions Co., a first-year service business. The beginning balances for all accounts on January I was zero (SO). The accompanying Excel template file includes the Unadjusted Trial Balance for the company as of 12/31/2020. This information is included on the "Unadjusted TB-Dec2020" tab in the Excel workbook The balances in each account in the Unadjusted Trial Balance on December 31, represents the ending balance for and represents all of the activity for the year. As such, the detail of all of the individual transactions for the year is omitted. Unadjusted Trial Balance information is already included in the "GL" tab through cell reference links. Use this information in the "Unadjusted TB-Dec2020" and "GL" tabs as the starting point for your work. The following additional facts were collected for use in making adjusting journal entries prior to preparing financial statements for the year ended 12/31/2020. a. The December 31 inventory count of supplies shows $700 still available. b. Six months have expired since the 12-month insurance premium of $3,600 was paid in advance. c. As of December 31, three employees have not been paid for 2 days of work at $400 per person per day. d. The company's computers, purchased on January 2nd, are expected to have a three-year life with no salvage value. e. The office furniture, also purchased on January 2nd, is expected to have a six-year life with no salvage value. f. The company earned $3,000 of their unearned revenue during the year. Data and Instructions Sandra Martin owns and operates Accounting Solutions Co., a first-year service business. The beginning balances for all accounts on January 1 was zero (SO). The accompanying Excel template file includes the Unadjusted Trial Balance for the company as of 12/31/2020. This information is included on the "Unadjusted TB-Dec2020" tab in the Excel workbook The balances in each account in the Unadjusted Trial Balance on December 31, represents the ending balance for and represents all of the activity for the year. As such, the detail of all of the individual transactions for the year is omitted. Unadjusted Trial Balance information is already included in the "GL" tab through cell reference links. Use this information in the "Unadjusted TB-Dec2020" and "GL"tabs as the starting point for your work The following additional facts were collected for use in making adjusting journal entries prior to preparing financial statements for the year ended 12/31/2020, a. The December 31 inventory count of supplies shows $700 still available. b. Six months have expired since the 12-month insurance premium of $3,600 was paid in advance. c. As of December 31, three employees have not been paid for 2 days of work at $400 per person per day d. The company's computers, purchased on January 2nd, are expected to have a three-year life with no salvage value. e. The office furniture, also purchased on January 2nd, is expected to have a six-year life with no salvage value. f. The company earned $3,000 of their unearned revenue during the year