Question

1 Approved Answer

Posted on Jul 20, 2024

Can someone please help with the adjusted trial balance, income statement, and balance sheet for the debit and credit columns. I already tried to do

image text in transcribed Can someone please help with the adjusted trial balance, income statement, and balance sheet for the debit and credit columns. I already tried to do some of it and the totals, but i don't know if it's right or how to do the rest in yellow. Anything would help. Thank you!

Home Insert Draw Page Layout Formulas Data Review View A Share 1 Arial 10 AA M General Conditional Formatting Format as Table Insert X Delete ! Format Paste ZY B AY E + $%1 20 Cell Styles X Sort & Filter Fine Sel N30 y XVfx D EF GH 10 Income Statement Debit Credit B 4 5 6 Account 7 Number Nante a 1110 Cash 0 1120 Accounts Recalvable 10 1130 Prepaid Insurancs 11 1140 Prepaid Rent 12 1150 Office Supplies 13 1 1211 Office Equip 14 1212 Accum. Depr.-Office Equip. .- 15 1310|Computer Equip 18 1312 Accum. Depr.-Computer Equip 17 1411 Building Cost 18 1412 Acum Der Building 19 1510 Land 20 2101 Accounts Payable 21 2102 Advanced Payments 22 2103 Interest Payable 23 2105 Salarios Payable 25 2201 Mortgage Payable 26 2202 Notes Payable 27 3100 Hudson Bloom, Capital 28 3300 Hudson Bloom Withdrawals 29 30 4100 Computer & Consulting Revenue 31 5010 Rent Expense 32 5020 Salary Expense 33 5030 Advertising Expense 34 5040 Repairs & Maint. Expense 35 5050 Oil & Gas Expanse 36 5080 Supplies Expense 37 5090 Interest Expense 38 5100 Insurancu Expense 39 5110 Depreciation Expense 40 Total 42 NET INCOME 43 Balance 44 45 FAQ A Welcorrie Unadjusted Trial Balance Debit Credit 64,314.00 0.00 1 160.00 0.00 5,976.00 0.00 5,400.00 0.00 480.00 0.00 2.147.00 0.00 0.00 0.00 229,880.00 0.00 0.00 0.00 115,000.00 0.00 0.00 0.00 22,000.00 0.00 0.00 1,295.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 123,300.00 0.00 113,250.00 0.00 197,932.00 2,000.00 0.00 Adjusting Entries Adjusted Trial Balance Debit Credit Debit Credit 0.00 0.00 64,314.00 8,750.00 0.00 9.910.00 0.00 249.00 5.727.00 0.00 1,800.00 3,600.00 0.00 289.00 1191.00 0.00 0.00 2 143.00 0.00 21.391 21.29 0.00 0.00 229,880,00 0.00 3,831.33 3,831.33 0.00 0.00 115,000.00 0.00 285.71 285.71 0.00 0.00 22,000.00 0.00 0.00 1,295.00 0.00 0.00 0.00 1,518.64 1,513.64 10.00 576.00 576.00 0.00 0.00 123,300,00 0.00 0.00 113,250.00 0.00 0.00 197,932.00 0.00 0.00 2.000.00 Balance Sheet Debit Credit 64,314.00 9,910.00 5,727.00 3,600.00 191.00 2.147.00 21.39 229,880.00 3831.33 115,000.00 285.71 22.000.00 1 295.00 1.513.64 576.00 123,300 po 113,250.00 197.932.00 $2,000.00 25.805.00 25,695.00 0.00 0.00 1.920.00 275.00 1.265.00 815.00 0.00 0.00 0.00 0.00 16,855.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,800.00 676.00 0.00 0.00 0.00 289.00 1.513.64 249.00 4,138.43 8,750.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,800.00 2,496.00 275.00 1,265.00 315.00 299.00 1.513.64 249.00 4.135.43 1,800.00 2.496.00 275.00 1.285.00 815.00 289.00 1,513.64 249.00 4.138.43 452,632.00 452 632.00 17,315.07 17,316.07 467,610.07 467,610.07 12,841.07 25,895.0012454.769.00 442,005.07 25,605.00454.78 Chart of Accounts Transactions General Journal Worksheet Income Statement Changes in Owner's Eq Home Insert Draw Page Layout Formulas Data Review View A Share 1 Arial 10 AA M General Conditional Formatting Format as Table Insert X Delete ! Format Paste ZY B AY E + $%1 20 Cell Styles X Sort & Filter Fine Sel N30 y XVfx D EF GH 10 Income Statement Debit Credit B 4 5 6 Account 7 Number Nante a 1110 Cash 0 1120 Accounts Recalvable 10 1130 Prepaid Insurancs 11 1140 Prepaid Rent 12 1150 Office Supplies 13 1 1211 Office Equip 14 1212 Accum. Depr.-Office Equip. .- 15 1310|Computer Equip 18 1312 Accum. Depr.-Computer Equip 17 1411 Building Cost 18 1412 Acum Der Building 19 1510 Land 20 2101 Accounts Payable 21 2102 Advanced Payments 22 2103 Interest Payable 23 2105 Salarios Payable 25 2201 Mortgage Payable 26 2202 Notes Payable 27 3100 Hudson Bloom, Capital 28 3300 Hudson Bloom Withdrawals 29 30 4100 Computer & Consulting Revenue 31 5010 Rent Expense 32 5020 Salary Expense 33 5030 Advertising Expense 34 5040 Repairs & Maint. Expense 35 5050 Oil & Gas Expanse 36 5080 Supplies Expense 37 5090 Interest Expense 38 5100 Insurancu Expense 39 5110 Depreciation Expense 40 Total 42 NET INCOME 43 Balance 44 45 FAQ A Welcorrie Unadjusted Trial Balance Debit Credit 64,314.00 0.00 1 160.00 0.00 5,976.00 0.00 5,400.00 0.00 480.00 0.00 2.147.00 0.00 0.00 0.00 229,880.00 0.00 0.00 0.00 115,000.00 0.00 0.00 0.00 22,000.00 0.00 0.00 1,295.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 123,300.00 0.00 113,250.00 0.00 197,932.00 2,000.00 0.00 Adjusting Entries Adjusted Trial Balance Debit Credit Debit Credit 0.00 0.00 64,314.00 8,750.00 0.00 9.910.00 0.00 249.00 5.727.00 0.00 1,800.00 3,600.00 0.00 289.00 1191.00 0.00 0.00 2 143.00 0.00 21.391 21.29 0.00 0.00 229,880,00 0.00 3,831.33 3,831.33 0.00 0.00 115,000.00 0.00 285.71 285.71 0.00 0.00 22,000.00 0.00 0.00 1,295.00 0.00 0.00 0.00 1,518.64 1,513.64 10.00 576.00 576.00 0.00 0.00 123,300,00 0.00 0.00 113,250.00 0.00 0.00 197,932.00 0.00 0.00 2.000.00 Balance Sheet Debit Credit 64,314.00 9,910.00 5,727.00 3,600.00 191.00 2.147.00 21.39 229,880.00 3831.33 115,000.00 285.71 22.000.00 1 295.00 1.513.64 576.00 123,300 po 113,250.00 197.932.00 $2,000.00 25.805.00 25,695.00 0.00 0.00 1.920.00 275.00 1.265.00 815.00 0.00 0.00 0.00 0.00 16,855.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,800.00 676.00 0.00 0.00 0.00 289.00 1.513.64 249.00 4,138.43 8,750.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,800.00 2,496.00 275.00 1,265.00 315.00 299.00 1.513.64 249.00 4.135.43 1,800.00 2.496.00 275.00 1.285.00 815.00 289.00 1,513.64 249.00 4.138.43 452,632.00 452 632.00 17,315.07 17,316.07 467,610.07 467,610.07 12,841.07 25,895.0012454.769.00 442,005.07 25,605.00454.78 Chart of Accounts Transactions General Journal Worksheet Income Statement Changes in Owner's E