Question

Please provide the answers using EXCEL. I will really appreciate it!

During the Month of December, Business Solutions had the following Transactions

2. Paid $1,025 cash to Hillside Mall for Business Solutions share of mall advertising costs.
3. Paid $500 cash for Minor repairs to the company’s computer.
4. Received $3,950 cash from Alex’s Engineering Co for receivables from November

10. Paid Cash to Lyn Addie for six days of work at the rate of $125 per day

14. Notified by Alex’s Engineering Co that Business Solution’s bid of $7,000 on a proposed project has been accepted. Alex’s paid $1,500 cash advance to Business Solutions
15. Purchased $1,100 of computer supplier on credit from Harris Office Products.
16. Sent a reminder to Gomez Co. to pay its fee for services recorded on November 8^th.

20. Completed a project for Liu Corporation and received $5,625 cash.

28. Received $3,000 cash from Gomez Co. on its receivable
29. Reimbursed S. Rey for business automobile mileage. (Rey drove 600 miles and was reimbursed $0.32 per mile)

31. S. Rey withdrew $1,500 cash from the company for personal use.

Additionally, the following facts are required to make the necessary adjusting entries.

1. The December 31 inventory count of computer supplies shows $580 still available
2. Three months have expired since the 12 month insurance premium was paid in advance
3. As of December 31, Lyn Addie has not been paid for four days of work at $125 per day
4. The computer system, acquired on October 1, is expected to have a four-year life with no salvage value.
5. The office equipment, acquired on October 1, is expected to have a five-year life with no salvage value
6. Three of the four months prepared rent has expired.

REQUIREMENTs:

1. Prepare journal entries to record each of the December transactions and events for Business Solutions. Post those entries to their respective T accounts
2. Prepare adjusting entries to reflect a thru f. Post those entries to their respective T accounts
3. Prepare an adjusted trial balance as of December 31, 2019
4. Prepare an income statement for the three months ended December 31,2019
5. Prepare a statement of owner’s equity for the three months ended December 31, 2019
6. Prepare a balance sheet as of December 31, 2019
7. Record the necessary closing entries as of December 31, 2019
8. Prepare a post-closing trial balance as of December 31, 2019

Business Solution

Trial Balance

As of November 30, 2019

Account Title	Debit	Credit
Cash	$38,264
Accounts Receivable	12,618
Computer Supplies	2,545
Prepaid Insurance	2,220
Prepaid Rent	3,300
Office Equipment	8,000
Accumulated Depreciation - Office Equipment		0
Computer Equipment	20,000
Accumulated Depreciation - Computer Equipment		0
Accounts Payable		0
wages Payable		0
Unearned Computer Services Revenue		0
S. Rey Capital		73,000
S Rey Withdrawals	5,600
Computer Services Revenue		25,659
Depreciation Expense - Office Equipment	0
Depreciation Expense - Computer Equipment	0
Wages Expense	2,625
Insurance Expense	0
Rent Expense	0
Computer Supplies Expense	0
Advertising Expense	1,728
Mileage Expense	704
Miscellaneous Expenses	250
Repairs Expense	805
	$98,659	$98,659

Answer 1

business solution - Microsoft Excel - X Home Insert Page Layout Formulas Data Review View Cut Copy - A DO Custom 1 Wrap Text Merge & Center 1 - 3 Autosum * Times New Rom 11 BI U-23- Font A A- Paste Insert Delete Format Conditional Format Formatting as Table Styles Format Painter Cell Styles Fill 2 Clear Sort & Find & Filter Select Editing Clipboard Alignment Number Cells A197 0 f x Account Title & Explaination A E F G H I J K 2 Cr 1,025.00 1,025.00 500.00 500.00 Business Solutions 3 General Journal Dr 4 Advertisement Expenses $ 5 To Cash 6 Amount of cash paid to hillside Mall for Advertisement) 7 8 Repair Expenses-Computer $ 9 To Cash 10 Amount paid for minor repairs for company's computer) 11 12 Cash 13 To Accounts Receivable 14 Amount received from Alex's Engineering Company) 15 16 Wages Expenses $ To Cash 18 (Amount paid Lynn Addie for six days wages $125*6) 3,950.00 3,950.00 750.00 17 750.00 19 $ 1,500.00 1,500.00 20 Cash 21 To Unearned Service Revenue 22 (Amount received as advance from Alex's Engineering) 23 24 Comuter supplies ► Sheet1 Sheet2 Sheet3 Ready $ 1.100.00 | + OU 100% 0 . 13:41 PAENG 24 27-11-2019 0

business solution - Microsoft Excel - X Home Insert Page Layout Formulas Data Review View Cut Copy - A Custom Times New Rom 11 BI U-23- Font A A- DO Wrap Text Merge & Center Alignment Paste 1 1 , toto comditingl af Table styles -% - 3 insert ba Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles Autosum * 2 Clearn alt inter ser Fill 2 Clear Format Painter Clipboard Sort & Find & Filter Select Editing Number Cells A197 for Account Title & Explaination D E F G H I J K 23 $ 1,100.00 25 1,100.00 24 Comuter supplies To Accounts Payable (Being amount of purchased of Computer supplies from Harris Office 26 Products) No Entry at the date of reminder 28 29 5,625.00 30 Cash 31 To Computer Service Revenue 32 (Being Amount received from Liu Corporation) 5,625.00 33 3,000.00 34 Cash 35 To Accounts Receivable 36 (Being amount received from Gomez Co.) 3,000.00 37 $ 192.00 192.00 38 Mileage Expenses 39 To Cash 40 (Being amount paid to S.Ray for mileage expenses(600*32) 41 42 S.Ray Withdrawal 43 To Cash 44 (Being amount of cash withdrawal) 45 Kar Sheet1 Sheet2 Sheet3 Ready 1,500.00 1,500.00 OU 100% 0 + SA 13:42 E NG 27-11-2019 w

business solution - Microsoft Excel - X Home Insert Page Layout Formulas Data Review View Cut Copy - A DO Custom 1 Wrap Text Merge & Center 1 - 3 Autosum * Times New Rom 11 BI U-23- Font A A- Paste Insert Delete Format Conditional Format Formatting as Table Styles Format Painter Cell Styles Fill 2 Clear Sort & Find & Filter Select Editing Clipboard Alignment Number Cells A197 fax Account Title & Explaination E F G H I J $ 3,065.00 3,065.00 47 Adjusting Entries 48 Computer Supplies Expenses($2545+$1100-$580) 49 To Computer Supplies 50 (Being amount of Computer supplies expenses) 51 52 Insurance ($2220*3/12) 53 To Prepaid Insurance 54 (Being amount of 3 months insurance expired) 555.00 555.00 55 500.00 500.00 56 Wages($125*4) 57 To Wages Payable 58 (Being amount of wages payable) 59 60 Depreciation-Computer Equipment($20000/4)*(3/12) 61 To Accumulated Depreciation-Computer Equipment 62 (Being amount of Depreciation on Equipment) 1.250.00 1,250.00 63 400.00 400.00 64 Depreciation Office Equipment($8000/5)*(3/12) 65 To Accumulated Depreciation Office Equipment 66 (Being amount of Depreciation on Office Equipment) 67 68 Rent($3300*3/4) 69 To Prepaid Rent 70 (Being amount of 3 months Rent) Sheet1 Sheet2 Sheet3 Ready $ 2,475.00 2,475.00 + BOJ 100% 0 - 13:42 gAENG 27 27-11-2019 0

business solution - Microsoft Excel - X Home Insert Page Layout Formulas Data Review View Cut - A Custom 1 1 - 3 Autosum * E Copy Format Painter Paste Times New Rom 11 BI U-23- Font A A- DO Wrap Text Merge & Center Alignment Conditional Format Formatting as Table Styles Cell Styles Insert Delete Format Fill 2 Clear Sort & Find & Filter Select Editing Clipboard Number Cells A197 for Account Title & Explaination B Cash Account D E F G H I J 73 74 Account Head 75 Balance 76 Advertisement 77 Computer Repair 78 Accounts Receivable 79 Wages 80 Unearned Service Revenue 81 Computer Service Revenue 82 Accounts Receivable 83 Mileage Expenses 84 S.Ray withdrawal $ 3,950.00 Balance(DR) $ 38,264.00 1,025.00 $ 37.239.00 500.00 $ 36,739.00 $ 40,689.00 750.00 $ 39,939.00 41,439.00 47,064.00 50,064.00 192.00 $ 49,872.00 1,500.00 $ 48,372.00 $ $ $ 1,500.00 5,625.00 3,000.00 85 Accounts Receivable Dr Cr 86 87 Account Head 88 Opening Balance Cash 90 Cash Balance(DR) 12,618.00 $ 8.668.00 $ 5,668.00 89 Cas 3,950.00 3,000.00 Prepaid Rent Dr Cr 92 93 Account Head 94 Opening Balance 95 Rent Balance(DR) $ 3,300.00 2,475.00$ 825.00 Sheet1 Sheet2 Sheet3 Ready OO op ^ 100% @ U - 13:42 = ENG 27-11-2019 0

business solution - Microsoft Excel - X Home Insert Page Layout Formulas Data Review View Cut - A DO Custom 1 1 Wrap Text Merge & Center - 3 Autosum * E Copy Format Painter Times New Rom 11 BI U-23- Font A A- Paste Conditional Format Formatting as Table Styles Cell Styles Insert Delete Format Fill 2 Clear Sort & Find & Filter Select Editing Clipboard Alignment Number Cells A197 for Account Title & Explaination A D E F G H I J Prepaid Insurance DE Balance(DR) $ 2,220.00 $ 1.665.00 555.00 Rent Expense Dr $ Cr Balance(DR) 2,475.00 2,475.00 Repairs Expense Dr Cr 97 98 Account Head 99 Opening Balance 100 Insurance 101 102 103 Account Head 104 Rent 105 106 107 Account Head 108 Opening Balance 109 Cash 110 111 112 Account Head 113 Opening Balance 114 Prepaid Insurance 115 116 117 Account Head 118 Opening Balance 119 Cash We Sheet1 Sheet2 Ready Balance(DR) 805.00 L 1,305.00 $ 500.00 Insurance Expense Dr Cr Balance(DR) $ 555.00 $ 555.00 Wages Expense Dr Balance(DR) 2,625.00 3,375.00 $ 750.00 Sheet3 OU 100% - 13:42 ENG 27-11-2019 P A 0 W .

business solution - Microsoft Excel - X Home Insert Page Layout Formulas Data Review View Cut - A Custom 1 1 - 3 Autosum * E Copy Format Painter Paste Times New Rom 11 BI U-23- Font A A- DO Wrap Text Merge & Center Alignment Conditional Format Formatting as Table Styles Cell Styles Insert Delete Format Fill 2 Clear Sort & Find & Filter Select Editing Clipboard Number Cells A197 for Account Title & Explaination B Wages Expense E F G H I J 116 Dr | Cr 117 Account Head 118 Opening Balance 119 Cash 120 Wages Payable Balance(DR) $ 2,625.00 3,375.00 $ 3.875.00 $ $ 750.00 500.00 121 Mileage Expense Dr a 122 123 Account Head 124 Opening Balance 125 Cash Balance(DR) $ 704.00 $ 896.00 $ 192.00 126 Depreciation Expense-Computer Equipment Dr $ 1.250.00 Balance(DR) $ 1,250.00 127 128 Account Head 129 Accumulated Depreciation 130 131 132 Account Head 133 Accumulated Depreciation Depreciation Expense-Office Equipment Dr Cr $ 400.00 Balance(DR) $ 400.00 134 Accumulated Depreciation-Computer Equipment Dr Cr $ 1.250.00 Balance(CR) $ 1,250.00 135 136 Account Head 137 Depreciation-Computer Equipment 138 S heet1 Sheet2 Sheet3 Ready H OU 100% - 13:42 ^ = ENG 27-11-2019 gol 0 D.

business solution - Microsoft Excel - X Home Insert Page Layout Formulas Data Review View Cut Copy - A DO Custom 1 Wrap Text Merge & Center 1 - 3 Autosum * Times New Rom 11 BI U-23- Font A A- Paste Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles Format Painter Fill 2 Clear Sort & Filter Editing Find & Select Clipboard Alignment Number Cells A197 - fax Account Title & Explaination A C D E F G H I J K 138 139 Accumulated Depreciation Office Equipment Dr Cr $ 400.00 Balance(CR) $ 400.00 Unearned Computer service Revenue Dr Cr $ 1,500.00 Cash Balance(CR) $ 1,500.00 140 Account Head 141 Accumulated Depreciation 142 143 144 Account Head 145 Balance Cld 146 147 148 Account Head 149 Balance 150 Cash 151 Advertising Expense Dr Cr Balance(DR) $ 1,728.00 2,753.00 $ 1,025.00 152 S.Ray Capital Dr Cr Balance(CR) $ 73,000.00 153 Account Head 154 Opening Balance 155 156 157 158 Account Head 159 Computer Supplies 160 Ke Sheet1 Sheet2 Ready Computer Supplies Expense Dr $ 3.065.00 Cr Balance(DR) $ 3,065.00 Sheet30 OU 100% - 13:42 ^ = ENG 27-11-2019 gol 0 D.

business solution - Microsoft Excel - X Home Insert Page Layout Formulas Data Review View Cut - A DO Custom 1 1 Wrap Text Merge & Center - 3 Autosum * Times New Rom 11 BI U-23- Font A A- E Copy Format Painter Clipboard Paste Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles Fill 2 Clear Sort & Find & Filter Select Editing Alignment Number Cells A197 for Account Title & Explaination E F G H I J 161 Computer Supplies Dr Cr 162 Account Head 163 Opening Balance 164 Accounts Payable 165 Supplies Expenes $ Balance(DR) $ 2,545.00 $ 3,645.00 $ 580.00 1,100.00 3,065.00 166 Accounts Payable Balance(CR) $ 1,100.00 1,100.00 167 168 Account Head 169 Computer Supplies 170 171 172 Account Head 173 Opening Balance 174 Cash S.Rey withdrawal Or Balance(DR) 5,600.00 $ 7,100.00 $ 1,500.00 175 Wages Payable Dr Balance(CR) 500.00 $ 500.00 176 177 Account Head 178 Wages 179 180 181 Account Head 182 Opening Balance 183 Cash H4> Sheet1 Sheet2 Ready Computer Service Revenue Dr Balance(CR) 25,659.00 $ 31.284.00 5,625.00 Sheet3 cm OU 100% U SA 13:42 E NG 27-11-2019 w

business solution - Microsoft Excel - X Home Insert Page Layout Formulas Data Review View Cut - A DO Custom 1 1 Wrap Text Merge & Center - 3 Autosum * Times New Rom 11 BI U-23- Font A A- E Copy Format Painter Clipboard Paste Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles Fill 2 Clear Sort & Find & Filter Select Editing Alignment Number Cells A197 for Account Title & Explaination E F G H I J к 185 Office Equipment Dr Balance(DR) $ 8,000.00 186 Account Head 187 Opening Balance 188 189 190 Account Head 191 Opening Balance Computer Equipment Dr Cr Balance(DR) $ 20,000.00 192 Business Solutions Adjusted Trial Balance 193 194 195 196 197 Account Title & Explaination 198 Cash 199 Accounts Receivable 200 Computer Supplies 201 Prepaid Insurance 202 Prepaid Rent 203 Office Equipment 204 Accumulated Depreciation Office Equipment 205 Computer Equipment 206 Accumulated Depreciation-Computer Equipment 207 Accounts Payable ► Sheet1 Sheet2 Sheet3 Ready $ $ $ $ 48,372.00 5,668.00 580.00 1.665.00 825.00 8,000.00 400.00 $ 20,000.00 1,250.00 1,100.00 son on 200 W Terralla OO 100% U op ^ = ENG 27-11-2019 W 13:42

business solution - Microsoft Excel - X Home Insert Page Layout Formulas Data Review View Cut - A DO Custom 1 1 Wrap Text Merge & Center - 3 Autosum * Times New Rom 11 BI U-23- Font A A- E Copy Format Painter Clipboard Paste Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles Fill 2 Clear Sort & Find & Filter Select Editing Alignment Number Cells A197 for Account Title & Explaination E F G H I J к 185 Office Equipment Dr Balance(DR) $ 8,000.00 186 Account Head 187 Opening Balance 188 189 190 Account Head 191 Opening Balance Computer Equipment Dr Cr Balance(DR) $ 20,000.00 192 Business Solutions Adjusted Trial Balance 193 194 195 196 197 Account Title & Explaination 198 Cash 199 Accounts Receivable 200 Computer Supplies 201 Prepaid Insurance 202 Prepaid Rent 203 Office Equipment 204 Accumulated Depreciation Office Equipment 205 Computer Equipment 206 Accumulated Depreciation-Computer Equipment 207 Accounts Payable ► Sheet1 Sheet2 Sheet3 Ready $ $ $ $ 48,372.00 5,668.00 580.00 1.665.00 825.00 8,000.00 400.00 $ 20,000.00 1,250.00 1,100.00 son on 200 W Terralla OO 100% U op ^ = ENG 27-11-2019 W 13:42

business solution - Microsoft Excel - X Home Insert Page Layout Formulas Data Review View Cut - A Custom 1 1 - 3 Autosum * E Copy Format Painter Paste Times New Rom 11 BI U-23- Font A A- DO Wrap Text Merge & Center Alignment Conditional Format Formatting as Table Styles Cell Styles Insert Delete Format Fill 2 Clear Sort & Find & Filter Select Editing Clipboard Number Cells D E F G H I J K $ $ $ 1.665.00 825.00 8,000.00 400.00 20,000.00 1,250.00 1,100.00 500.00 1,500.00 73,000.00 7,100.00 A197 for Account Title & Explaination А 201 Prepaid Insurance 202 Prepaid Rent 203 Office Equipment 204 Accumulated Depreciation Office Equipment 205 Computer Equipment 206 Accumulated Depreciation-Computer Equipment 207 Accounts Payable 208 Wages Payable 209 Unearned Computer Service Revenue 210 S.Ray Capital 211 S.Ray Drawings 212 Computer Service Revenue 213 Depreciation Expense-Office Equipment 214 Depreciation Expense-Computer Equipment 215 Wages Expense 216 Insurance Expense 217 Rent Expense 218 Computer Supplies Expense 219 Advertising Expense 220 Mileage Expense 221 Miscellaneous Expense 222 Repair Expenses-Computer 223 Total 224 Ke Sheet1 Sheet2 Sheet30 Ready 31,284.00 $ $ $ $ $ $ $ $ $ $ 400.00 1.250.00 3,875.00 555.00 2,475.00 3,065.00 2,753.00 896.00 250.00 1,305.00 1,09,034.00 $ 1,09,034.00 + BOJ 100% - OPAO ENG 0 13:42 27-11-2019 0

business solution - Microsoft Excel - X Home Insert Page Layout Formulas Data Review View Cut ♡ Custom 1 - Wrap Text Merge & Center 1 - 3 LE E Copy Paste Format Painter Clipboard Autosum * Times New Rom 11 - A A BI U PA Font Conditional Format Formatting as Table Styles Cell Styles Insert Delete Format Fill 2 Clear Sort & Find & Filter Select Editing Alignment Number Cells C D E F G H I J K 227 31,284.00 C322 - for B 226 Business Solutions Income Statement 228 For the three months ended December 31st 2019 229 Computer Service Revenue=(A) 230 Expenses 231 Wages Expenses $ 3,875.00 232 Computer Supplies Expenses $ 3,065.00 233 Rent Expenses 2,475.00 234 Insurance Expenses 555.00 235 Advertising Expenses 2,753.00 236 Mileage Expenses 896.00 237 Repair Expenses 1,305.00 238 Depreciation Expenses-Office Equipment $ 400.00 239 Depreciation Expenses-Computer Equipment 1.250.00 240 Miscellaneous Expenses $ 250.00 241 Total Expenses=(B) 242 Net Income(A)-(B) 243 244 Business Solutions 245 Statement of Owner's Equity 246 For the three months ended December 31st, 2019 247 S.Rey Capital 73000 248 Add: Net Income $ 14,460.00 249 Less: S.Rev Withdrawal $ 7.100.00 Sheet1 Sheet2 Sheet30 Ready 16,824.00 14,460.00 OU 100% - OPAO ENG 13:53 27-11-2019 0

business solution - Microsoft Excel - X Home Insert Page Layout Formulas Data Review View Cut Copy ♡ Custom - Wrap Text Merge & Center 1 1 - 3 Autosum * Times New Rom 11 - A A BI U PA Font Paste Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles Format Painter Clipboard Fill 2 Clear Sort & Find & Filter Select Editing Alignment Number Cells B D E F G H I J K 244 $ $ $ 73000 14,460.00 7,100.00 80,360.00 252 253 C322 - fe A Business Solutions 245 Statement of Owner's Equity 246 For the three months ended December 31st,2019 247 S.Rey Capital 248 Add: Net Income 249 Less: S.Rey Withdrawal 250 Ending Balance 251 Business Solutions Balance Sheet 254 December 31st 2019 255 Assets 256 Cash 257 Accounts Receivable 258 Computer Supplies 259 Prepaid Insurance 260 Prepaid Rent 261 Office Equipment 262 Accumulated Depreciation Office Equipment 263 Computer Equipment 264 Accumulated Depreciation-Computer Equipment 265 Total Assets 266 Liabilities & Stockholder's equity 267 Liabilities K Sheet1 Sheet2 Sheet3 Ready $ $ $ $ $ $ 48,372.00 5,668.00 580.00 1,665.00 825.00 8,000.00 400.00 20,000.00 -1,250.00 $ 83,460.00 OU 100% ve 13:54 gAENG 24 27-11-2019 .

business solution - Microsoft Excel - X Home Insert Page Layout Formulas Data Review View Cut Copy ♡ Custom 1 - Wrap Text Merge & Center 1 - 3 LE Paste Format Painter Clipboard Autosum * Times New Rom 11 - A A BI U PA Font Conditional Format Formatting as Table Styles Cell Styles Insert Delete Format Fill 2 Clear Sort & Find & Filter Select Editing Alignment Number Cells C322 o f B D E F G H I J K $ $ $ $ $ $ $ $ 48,372.00 5,668.00 580.00 1,665.00 825.00 8,000.00 400.00 20,000.00 -1,250.00 83,460.00 255 Assets 256 Cash 257 Accounts Receivable 258 Computer Supplies 259 Prepaid Insurance 260 Prepaid Rent 261 Office Equipment 262 Accumulated Depreciation Office Equipment 263 Computer Equipment 264 Accumulated Depreciation-Computer Equipment 265 Total Assets 266 Liabilities & Stockholder's equity 267 Liabilities 268 Accounts Payable 269 Wages Payable 270 Unearned Service Revenue 271 Total Liabilities 272 Stockholder's Equity 273 S.Rey Capital 274 Total Equity 275 Total Liabilities & Stockholder's Equity 276 277 278 Ke Sheet1 Sheet2 Sheet3 Ready $ $ $ 1,100.00 500.00 1,500.00 3,100.00 $ 80,360.00 80,360.00 83,460.00 Business Solutions Post Closing Entries U 1 2 3 ê e 9 SM OO 100% @ OPAO ENG 13:54 o 27-11-2019

business solution - Microsoft Excel - X Home Insert Page Layout Formulas Data Review View Cut Copy ♡ Custom 1 - Wrap Text Merge & Center 1 - 3 LE Paste Format Painter Clipboard Autosum * Times New Rom 11 - A A BI U PA Font Conditional Format Formatting as Table Styles Cell Styles Insert Delete Format Fill 2 Clear Sort & Find & Filter Select Editing Alignment Number Cells C322 fic E F G H I J $ 31,284.00 31,284.00 $ 16,824.00 289 277 Business Solutions 278 Post Closing Entries 279 Computer Service Revenue 280 To Income Summary 281 (Computer service revenue transferred to Income summary account) 282 283 Income Summary 284 To Wages Expense 285 To Advertisement Expense 286 To Computer supplies Expense 287 To Rent Expense 288 To Insurance Expense To Mileage Expense To Miscellaneous Expense To Reapirs Expense 292 To Depreciation Expene-Computer Equipment 293 To Depreciation Expense-Office Equipment 294 (Expenses transferred to Income Summary Account) 295 296 S.Ray Capital 297 TO S.Ray Drawings 298 (Drawings transfer to S.Ray's Capital Account) 299 300 Income Summary Sheet1 Sheet2 Sheet3 0 Ready 3,875.00 2,753.00 3,065.00 2,475.00 555.00 896.00 250.00 1,305.00 400.00 1,250.00 290 291 $ 7,100.00 7,100.00 $ 14,460.00 OU 100% U 13:54a gAENG 24 27-11-2019

business solution - Microsoft Excel - X Home Insert Page Layout Formulas Data Review View Cut Copy ♡ Custom 1 - Wrap Text Merge & Center 1 - 3 LE Paste Format Painter Clipboard Autosum * Times New Rom 11 - A A BI U PA Font Conditional Format Formatting as Table Styles Cell Styles Insert Delete Format Fill 2 Clear Sort & Find & Filter Select Editing Alignment Number Cells C322 C D E F G H I J K 14,460.00 $ 14,460.00 306 Cr 300 Income Summary $ 301 To S.Ray's Capital 302 (Income transferred to S. Ray's Capital account) 303 304 305 Business Solutions Post Closing Trial Balance 307 Account Title & Explaination Dr 308 Cash $ 309 Accounts Receivable $ 310 Computer Supplies $ 311 Prepaid Insurance $ 312 Prepaid Rent $ 313 Office Equipment $ 314 Accumulated Depreciation Office Equipment 315 Computer Equipment 316 Accumulated Depreciation-Computer Equipment 317 Accounts Payable 318 Wages Payable 319 Unearned Computer Service Revenue 320 S.Rey Capital 321 Total $ 322 222 ****Sheet1 Sheet2 Sheet3_02 Ready 48,372.00 5,668.00 580.00 1.665.00 825.00 8,000.00 400.00 20,000.00 1,250.00 1,100.00 500.00 1,500.00 80,360.00 85,110.00 85,110.00 $ OU 100% ve OPAO ENG . 13:54 27-11-2019