Sandra Martin owns and operates Accounting Solutions. The attached Excel file includes the unadjusted trial balance for 12/31/2018.

The following additional facts are collected for use in making adjusting entries prior to preparing financial statements for the year ended 12/31/2018.

1. Post the adjusting entries to the accounts in the general ledger. Use the General Ledger tab in the Excel workbook. (6 points)
2. Prepare a balance sheet as of December 31, 2018. Use the SOE & Balance Sheet tab in the Excel workbook. (5 points)
3. Record and post the necessary closing entries for Accounting Solutions Co. (4 points)
   1. Prepare the closing entries for the company. Use the General Journal-Closing Entry tab in the Excel workbook.
   2. Post the closing entries to the accounts in the general ledger. Use the General Ledger tab in the Excel workbook.
4. Prepare a post-closing trial balance as of December 31, 2018. Use the Post Closing TB tab in the Excel workbook. (5 points)
5. Add show how to get the Retained Earnings

GENERAL LEDGER 3 4 5 6 Cash P.R. Date Explanation DEBIT CREDIT ACCOUNT NO. 101 Bal-Debit Bal-Credit 9,870 31-Decl 7 8 9 10 11 12 13 Accounts Receivable P.R. DEBIT Date Explanation CREDIT ACCOUNT NO. 106 Bal-Debit Bal-Credit 8,540 31-Dec 14 15 16 17 18 Supplies P.R. 19 Explanation DEBIT CREDIT Date 31-Dec ACCOUNT NO. 126 Bal-Debit Bal-Credit 2,725 20 21 22 23 24 Prepaid Insurance P.R. DEBIT 25 Explanation CREDIT Date 31-Dec ACCOUNT NO. 128 Bal-Debit Bal-Credit 5,400 26 27 28 29 30 81 32 33 34 35 Office Furniture P.R. DEBIT Date Explanation CREDIT ACCOUNT NO. 163 Bal-Debit Bal-Credit 7,000 31-Dec Accumulated Depreciation - Office Furniture Explanation P.R. DEBIT CREDIT ACCOUNT NO. 164 Bal-Debit Bal-Credit 36 Date 31-Dec 87 38 39 10 11 Computer Equipment P.R. DEBIT 12 Explanation CREDIT Date 31-Dec ACCOUNT NO. 167 Bal-Debit Bal-Credit 9,000 13 14 15 Accumulated Depreciation - Computer Equipment Explanation P.R. DEBIT CREDIT ACCOUNT NO. 168 Bal-Debit Bal-Credit 3 Date 31-Dec 2 1 2. 3 Accounts Payable P.R. DEBIT ACCOUNT NO. 201 Bal-Debit Bal-Credit 7 Explanation CREDIT Date 31-Dec 6,825 5 5 7 3 3 Wages Payable P.R. DEBIT ACCOUNT NO. 210 Bal-Debit Bal-Credit Date Explanation CREDIT 1 3 4 5 5. Unearned Revenue P.R. DEBIT Explanation CREDIT Date 31-Dec ACCOUNT NO. 236 Bal-Debit Bal-Credit 4,750 7 3 S Martin, Capital P.R. DEBIT 2 Explanation CREDIT Date 31-Dec ACCOUNT NO. 301 Bal-Debit Bal-Credit 15,000 3 4 5 5 7 S Martin, Withdrawals P.R. DEBIT 3 Explanation CREDIT Date 31-Dec ACCOUNT NO. 302 Bal-Debit Bal-Credit 2,100 1 2 3 Accounting Services Revenue Explanation P.R. DEBIT CREDIT Date 31-Dec ACCOUNT NO. 403 Bal-Debit Bal-Credit 76,820 5 5 7 3 ACCOUNT NO. 612 Bal-Debit Bal-Credit ACCOUNT NO. 613 Bal-Debit Bal-Credit ACCOUNT NO. 623 Bal-Debit Bal-Credit 34,250 103 ACCOUNT NO. 637 Bal-Debit Bal-Credit OO 89 Depreciation Expense - Office Furniture 90 Date Explanation P.R. DEBIT CREDIT 91 92 93 94 95 Depreciation Expense - Computer Equipment 96 Date Explanation P.R. DEBIT CREDIT 97 98 99 100 101 Wages Expense 102 Date Explanation P.R. DEBIT CREDIT 31-Dec 104 105 106 107 Insurance Expense 108 Date Explanation P.R. DEBIT CREDIT 109 Year end JE 110 111 112 113 Rent Expense 114 Date Explanation P.R. DEBIT CREDIT 115 31-Dec 116 117 118 119 Supplies Expense 120 Date Explanation P.R. DEBIT CREDIT 121 31-Dec 122 123 124 125 Advertising Expense 126 Date Explanation P.R. DEBIT CREDIT 127 31-Dec 128 129 ACCOUNT NO. 640 Bal-Debit Bal-Credit 14,400 ACCOUNT NO. 652 Bal-Debit Bal-Credit 3,250 ACCOUNT NO. 655 Bal-Debit Bal-Credit 2,675 130 130 131 Mileage Expense P.R. DEBIT 132 Explanation CREDIT Date 31-Dec ACCOUNT NO. 676 Bal-Debit Bal-Credit 2,160 133 134 135 136 137 Miscellaneous Expense P.R. DEBIT Explanation CREDIT Date 31-Dec ACCOUNT NO. 677 Bal-Debit Bal-Credit 2,025 138 139 140 141 142 143 Income Summary P.R. DEBIT ACCOUNT NO. 801 Bal-Debit Bal-Credit 144 Date Explanation CREDIT 31-Dec 145 146 147 148 149 150 A B D E F Statement of Owner's Equity and Balance Sheet Accounting Solutions Statement of Changes in Owner's Equity For Month Ended December 31, 2018 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 BO Accounting Solutions Balance Sheet December 31, 2018 Name 2 General Journal 3 GENERAL JOURNAL 5 6 Date Account Titles and Explanation P. R. Debit Credit 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Company Name Post-Closing Trial Balance Date, Year Debit Credit 2 3 1 5 s 2 1 B . 5 7 B Totals 2 GENERAL LEDGER 3 4 5 6 Cash P.R. Date Explanation DEBIT CREDIT ACCOUNT NO. 101 Bal-Debit Bal-Credit 9,870 31-Decl 7 8 9 10 11 12 13 Accounts Receivable P.R. DEBIT Date Explanation CREDIT ACCOUNT NO. 106 Bal-Debit Bal-Credit 8,540 31-Dec 14 15 16 17 18 Supplies P.R. 19 Explanation DEBIT CREDIT Date 31-Dec ACCOUNT NO. 126 Bal-Debit Bal-Credit 2,725 20 21 22 23 24 Prepaid Insurance P.R. DEBIT 25 Explanation CREDIT Date 31-Dec ACCOUNT NO. 128 Bal-Debit Bal-Credit 5,400 26 27 28 29 30 81 32 33 34 35 Office Furniture P.R. DEBIT Date Explanation CREDIT ACCOUNT NO. 163 Bal-Debit Bal-Credit 7,000 31-Dec Accumulated Depreciation - Office Furniture Explanation P.R. DEBIT CREDIT ACCOUNT NO. 164 Bal-Debit Bal-Credit 36 Date 31-Dec 87 38 39 10 11 Computer Equipment P.R. DEBIT 12 Explanation CREDIT Date 31-Dec ACCOUNT NO. 167 Bal-Debit Bal-Credit 9,000 13 14 15 Accumulated Depreciation - Computer Equipment Explanation P.R. DEBIT CREDIT ACCOUNT NO. 168 Bal-Debit Bal-Credit 3 Date 31-Dec 2 1 2. 3 Accounts Payable P.R. DEBIT ACCOUNT NO. 201 Bal-Debit Bal-Credit 7 Explanation CREDIT Date 31-Dec 6,825 5 5 7 3 3 Wages Payable P.R. DEBIT ACCOUNT NO. 210 Bal-Debit Bal-Credit Date Explanation CREDIT 1 3 4 5 5. Unearned Revenue P.R. DEBIT Explanation CREDIT Date 31-Dec ACCOUNT NO. 236 Bal-Debit Bal-Credit 4,750 7 3 S Martin, Capital P.R. DEBIT 2 Explanation CREDIT Date 31-Dec ACCOUNT NO. 301 Bal-Debit Bal-Credit 15,000 3 4 5 5 7 S Martin, Withdrawals P.R. DEBIT 3 Explanation CREDIT Date 31-Dec ACCOUNT NO. 302 Bal-Debit Bal-Credit 2,100 1 2 3 Accounting Services Revenue Explanation P.R. DEBIT CREDIT Date 31-Dec ACCOUNT NO. 403 Bal-Debit Bal-Credit 76,820 5 5 7 3 ACCOUNT NO. 612 Bal-Debit Bal-Credit ACCOUNT NO. 613 Bal-Debit Bal-Credit ACCOUNT NO. 623 Bal-Debit Bal-Credit 34,250 103 ACCOUNT NO. 637 Bal-Debit Bal-Credit OO 89 Depreciation Expense - Office Furniture 90 Date Explanation P.R. DEBIT CREDIT 91 92 93 94 95 Depreciation Expense - Computer Equipment 96 Date Explanation P.R. DEBIT CREDIT 97 98 99 100 101 Wages Expense 102 Date Explanation P.R. DEBIT CREDIT 31-Dec 104 105 106 107 Insurance Expense 108 Date Explanation P.R. DEBIT CREDIT 109 Year end JE 110 111 112 113 Rent Expense 114 Date Explanation P.R. DEBIT CREDIT 115 31-Dec 116 117 118 119 Supplies Expense 120 Date Explanation P.R. DEBIT CREDIT 121 31-Dec 122 123 124 125 Advertising Expense 126 Date Explanation P.R. DEBIT CREDIT 127 31-Dec 128 129 ACCOUNT NO. 640 Bal-Debit Bal-Credit 14,400 ACCOUNT NO. 652 Bal-Debit Bal-Credit 3,250 ACCOUNT NO. 655 Bal-Debit Bal-Credit 2,675 130 130 131 Mileage Expense P.R. DEBIT 132 Explanation CREDIT Date 31-Dec ACCOUNT NO. 676 Bal-Debit Bal-Credit 2,160 133 134 135 136 137 Miscellaneous Expense P.R. DEBIT Explanation CREDIT Date 31-Dec ACCOUNT NO. 677 Bal-Debit Bal-Credit 2,025 138 139 140 141 142 143 Income Summary P.R. DEBIT ACCOUNT NO. 801 Bal-Debit Bal-Credit 144 Date Explanation CREDIT 31-Dec 145 146 147 148 149 150 A B D E F Statement of Owner's Equity and Balance Sheet Accounting Solutions Statement of Changes in Owner's Equity For Month Ended December 31, 2018 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 BO Accounting Solutions Balance Sheet December 31, 2018 Name 2 General Journal 3 GENERAL JOURNAL 5 6 Date Account Titles and Explanation P. R. Debit Credit 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Company Name Post-Closing Trial Balance Date, Year Debit Credit 2 3 1 5 s 2 1 B . 5 7 B Totals 2