Question

I am needing help with the general ledger portion of this problem. Also, please check my work on the journal portion. I am struggling with the unadjusted and adjusted trial balance so i want to make sure the ledger is correct.

Project Data: Taylor Scott owns and operates a consulting firm called Scott Consulting. The business began operating in October 2019. Transactions for October and November 2019 have been recorded and posted. Scott Consulting had the following transactions in December 2019. Dec 2 provided $3,450 of consulting services to Nelson Company on account 3 paid $1,130 cash to Global Mall for Scott Consulting's share of mall advertising posts. 4 Paid $375 cash for minor repairs to the company's computer. 110 Purchased $1,100 of computer supplies on credit from Graham Office Products. 14 paid cash to employee for five days of work at the rate of $155 per day. 15 Notified by True Engineering Co, that Scott Consulting's bid of $6,750 on a proposed project has been accepted. True paid a $1,200 cash advance to Scott Consulting 20 Completed a project for Olympus Corporation and received $5,235 cash. 128 Received $2,600 cash from Nelson Company on its receivable. 29 Reimbursed T. Scott $187 for business automobile mileage. 31 T. Scott withdrew $1,300 cash from the company for personal use. Pane 3. 16

Answer 1

Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View - 12 - A = = = General Arial BIU A A Wrap Text Merge & Center 1 * Cut La Copy Format Painter Clipboard - AutoSumA Paste - Conditional Format Formatting as Table Styles Cell Styles Insert Delete Format 2 Clear Sort & Filter Editing Find & Select Font Alignment Number Cells Cash A/C-101 A1 - А | 72 73 Date Explanation 1-Dec Bal 3-Dec 4-Dec 14-Dec 15-Dec 20-Dec 28-Dec 29-Dec 82 31-Dec 1,130.00 375.00 775.00 Balance 43,173.00 $ 42,043.00 $ 41,668.00 $ 40,893.00 42,093.00 47,328.00 $ 49,928.00 $ 49,741.00 $ 48,441.00 $ $ $ 1,200.00 5,235.00 2,600.00 187.00 1,300.00 83 ལསྔ| ༩ ༠ ༤ ཐ ༩ ཚེ ཝ @ a ཆ a @ ཡི ཉི ཚེa@ན་ Accounts Receivable-106 85 Date Explanation 86 1-Dec Opening Balance 87 2-Dec 88 28-Dec 89 Balance $ $ $ $ 3,450.00 5,208.00 8,658.00 6,058.00 2,600.00 90 Computer Supplies Expenses-652 Dr Balance $ $ 3,215.00 3,215.00 91 Date Explanation 92 31-Dec 93 94 Sheet1 Sheet2 Sheet3 Ready 100% 0 12:49 Type here to search 29-02-2020 W

Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View Cut Copy - 12 - A = = = General - Σ AutoSum' ΑΥΤΟ Arial BIU A A Wrap Text Merge & Center Paste Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles Format Painter Clipboard 2 Clear Sort & Filter Editing Find & Select Font Alignment Number Cells A1 A G H Prepaid Rent-131 94 95 96 Date Explanation 97 1-Dec Opening Balance 98 31-Dec or Balance $ $ 3,300.00 1,650.00 1,650.00 99 100 Prepaid Insurance-128 101 Date Explanation 102 1 -Dec Opening Balance 103 31-Dec Balance $ 740.00 $ 2,220.00 1,480.00 104 105 Office Equipment-163 Dr Cr Balance 20,000.00 Computer Equipment-167 Dr 106 Date Explanation 107 1-Dec Opening Balance 108 109 110 Date Explanation 111 1 -Dec Opening Balance 112 113 114 Date Explanation 115 31-Dec Balance $ 8,000.00 Accumulated Depreciation Expense-Computer Equipment-168 Dr Cr $ 1,000.00 Balance $ 1,000.00 116 Sheet1 Sheet2 Sheet3 Hot Ready 80 ^ 100% 0 u 12:49 E ENG 29-02-2020 s. Type here to search

Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View Cut Copy - 12 - A = = = General LE Paste Format Painter Clipboard Arial BIU A A Wrap Text Merge & Center - 1 Formatting style ble " styles Conditional Format Formatting as Table Styles Cell Styles Insert Delete Format AutoSumA 2 clear rede format 2 Clear Sort & Filter Editing secret de Find & Select Font Alignment Number Cells F G H I J A1- А 117 118 Date Explanation 119 31-Dec 120 c Accumulated Depreciation Office Equipment-164 Dr Cr $ 500.00 Balance $ 500.00 121 Accounts Payable-201 Dr Cr 122 Date Explanation 123 31-Dec Computer Supplies 1,100.00 Balance $ 1,100.00 124 Wages Payable-210 125 126 Date Explanation 127 31-Dec or Balance 620.00 $ 620.00 128 HHH 129 130 Date Explanation 131 31-Dec Balance C/d 132 Unearned Consulting Revenue-236 Drar $ 1,200.00 Cash Balance $ 1,200.00 133 T.Scott Capital-301 Balance $ 73,000.00 $ T.Scott Withdrawal-302 134 Date Explanation 135 31-Dec Opening Balance 136 137 138 Date Explanation 139 1-Dec Opening Balance Sheet1 Sheet2 Sheet3 Ready Balance $ 2,000.00 OO 100% @ U 12:50 Type here to search N 29-02-2020 W

Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View Cut Copy - 12 - A = = = General Arial BIU A A Wrap Text Merge & Center 1 - AutoSumA Paste Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles Format Painter Clipboard 2 Clear Sort & Filter Editing Find & Select Font Alignment Number Cells F G H I J T.Scott Capital-301 or cr Balance $ 73,000.00 T.Scott Withdrawal-302 Balance A1- А | 133 134 Date Explanation 135 31-Dec Opening Balance 136 137 138 Date Explanation 139 1-Dec Opening Balance 140 31-Dec 141 142 143 Date Explanation 144 1-Dec Opening Balance 145 2-Dec 146 14-Dec 147 148 2,000.00 3,300.00 $ 1,300.00 $ Consulting Revenue-403 Dr Cr Balance $ 14,641.00 $ 18,091.00 $ 23,326.00 3,450.00 5,235.00 149 Rent Expenses-640 Dr $ 150 Date Explanation 151 31-Dec Rent Balance 1,650.00 1,650.00 152 153 154 Date Repair Expense-Computer-684 Dr Cr Balance 155 Explanation 1-Dec Opening Balance Sheet1 Sheet2 Sheet3 Ready 0 100% ENG N 12:50 Type here to search A O 29-02-2020 W Q

Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View Cut Copy = = = * General Arial BIU 1 LE Paste Format Painter Clipboard Wrap Text Merge & Center - AutoSumA - 12 - A À A Font Conditional Format Formatting as Table Styles Cell Styles Insert Delete Format 2 Clear Sort & Filter Editing Find & Select Alignment Number Cells A1 F G H I J K 151 31-Dec Rent $ 1,650.00 1,650.00 152 153 Repair Expense-Computer-684 Dr Cr Balance 155 $ 375.00 375.00 154 Date Explanation 1-Dec Opening Balance 156 3-Dec 157 158 159 Date Explanation Explanation 160 1-Dec Opening Balance 161 31-Dec Insurance Expenses-637 Dr Cr Balance $ 740.00 $ 740.00 162 163 Wages Expense-623 Dr Cr 164 Date Explanation 165 1-Dec Opening Balance 166 10-Dec Cash 167 31-Dec Balance $ $ $ $ $ 775.00 620.00 875.00 1,650.00 2,270.00 168 169 Mileage Expense- 170 Date Explanation 171 1-Dec Opening Balance 172 29-Dec Balance $ $ 187.00 s 320.00 507.00 173 Sheet1 Sheet2 Sheet3 Ready OO 100% @ U Type here to search 12:50 O E ENG 29-02-2020 a

Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View Cut Copy - 12 - A = = = - General Σ AutoSum' ΑΥΤΟ Arial BIU A A Wrap Text Merge & Center LE Paste Format Painter Clipboard " Fill tt Z Conditional Format Formatting as Table Styles Cell Styles Insert Delete Format 2 Clear Sort & Filter Editing Find & Select Font Alignment Number Cells TE TF G H F G H I J K A1- А 174 175 Date Explanation 176 31-Dec C Depreciation Expense-Computer Equipment Dr $ 1,000.00 Cr Balance $ 1,000.00 Depreciation Expense-Office Equipment Dr $ 500.00 178 179 Date Explanation 180 31-Dec 181 Cr Balance $ 500.00 Advertising Expense-655 Dr 184 Date Explanation Cr Balance 186 31-Dec $ 1,130.00 $ 1,130.00 187 Computer Supplies Expense-126 Dr 188 189 190 Date Explanation 191 1-Dec Opening Balance 10-Dec 193 31-Dec Balance $ $ $ 192 $ 1,100.00 2,545.00 3,645.00 430.00 3,215.00 194 195 196 SC Unadjusted Trial Balance Sheet1 Sheet2 Sheet3 Ready OO ^ 100% @ U E ENG 29-02-2020 Type here to search

Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View * Cut Copy ♡ General 1 - AutoSumA - Wrap Text a Merge & Center Calibri 11 - A A BIU - DA Font Paste Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles Format Painter Clipboard 2 Clear Sort & Filter Editing Find & Select Alignment Number Cells F207 fic А F G H I J Unadjusted Trial Balance November 31st, 2019 202 194 195 196 197 198 Acc. No. Account Title & Explaination 199 101 Cash 200 106 Accounts Receivable 126 Computer Supplies 128 Prepaid Insurance 131 Prepaid Rent 163 Office Equipment 167) Computer Equipment 301 Common Stock 302 Dividends 403 Computer Service Revenue 623 Wages Expense 676 Mileage Expense Total Dr $ $ $ $ $ $ $ 43,173.00 5,208.00 2,545.00 2,220.00 3,300.00 20,000.00 8,000.00 203 205 206 73,000.00 $ 2,000.00 208 14,641.00 209 210 $ $ $ 875.00 320.00 87,641.00 $ 211 87,641.00 212 SC December 31st, 2019 213 214 215 S.NO 216 217 Credit Account Name 101 Cash 106) Accounts Receivable Sheet1 Sheet2 Sheet3 Debit $ 48,441.00 $ 6,058.00 Ready 100% 0 Luc 12:51 ENG 29-02-2020 Type here to search A E - W

Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View * Cut Copy General 1 - AutoSumA Paste Calibri 11 - A A BIU - DA Font ♡ - Wrap Text a Merge & Center Alignment Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles Format Painter Clipboard 2 Clear Sort & Filter Editing Find & Select Number C Cells F207 foc F G H I J K 213 214 215 S.NO 216 217 Debit Credit $ 48,441.00 $ 6,058.00 $ 430.00 $ 1,480.00 $ 1,650.00 $ 20,000.00 219 220 500.00 $ 8,000.00 224 SC December 31st, 2019 Account Name 101 Cash 106 Accounts Receivable 126 Computer Supplies 128 Prepaid Insurance 131 Prepaid Rent 163 Office Equipment 164 Accumulated Depreciation Office Equipment 167 Computer Equipment 168 Accumulated Depreciation-Computer Equipment 201 Accounts Payable 210 Wages Payable 236 Unearned Computer Service Revenue 301 T.Scott's capital 302| T.Scott's Withdrawal 403) Computer Service Revenue 612 Depreciation Expense-Office Equipment 613 Depreciation Expense-Computer Equipment 623 Wages Expense 637 Insurance Expense 640 Rent Expense 652) Computer Supplies Expense Sheet1 Sheet2 Sheet3 1,000.00 1,100.00 620.00 1,200.00 73,000.00 $ 3,300.00 23,326.00 232 234 235 236 $ $ $ $ $ $ 500.00 1,000.00 2,270.00 740.00 1,650.00 3,215.00 Ready OO 100% @ U 12:51 Type here to search N 29-02-2020

Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View * Cut Copy ♡ General 1 - AutoSumA - Wrap Text a Merge & Center Calibri 11 - A A BIU - DA Font Paste Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles Format Painter Clipboard 2 Clear Sort & Filter Editing Find & Select Alignment Number Cells F207 fic LE F G H I J K 219 $ $ $ $ с 430.00 1,480.00 1,650.00 20,000.00 221 500.00 $ 8,000.00 225 1,000.00 1,100.00 620.00 1,200.00 73,000.00 229 126 Computer Supplies 128 Prepaid Insurance 131 Prepaid Rent 163 Office Equipment 164| Accumulated Depreciation Office Equipment 167) Computer Equipment 168) Accumulated Depreciation-Computer Equipment 201 Accounts Payable 210 Wages Payable 236 Unearned Computer Service Revenue 301 T.Scott's capital 302T.Scott's Withdrawal 403 Computer Service Revenue 612 Depreciation Expense-Office Equipment 613 Depreciation Expense-Computer Equipment 623 Wages Expense 637 Insurance Expense 640 Rent Expense 652) Computer Supplies Expense 655| Advertising Expense 676 Mileage Expense 684 Repair Expenses-Computer Total $ 3,300.00 23,326.00 $ $ $ 234 500.00 1,000.00 2,270.00 740.00 1,650.00 3,215.00 1,130.00 507.00 375.00 1,00,746.00 $ $ $ $ $ $ 237 238 239 $ 1,00,746.00 $ 240 241 Sheet1 Sheet2 Sheet3 Ready 90 100% 0 12:51 Type here to search N 29-02-2020