I need help with income statement, statement of owner's equity and balance sheet

G31 4 x V fx 2106 A B D E F G H J K M N Income Statement Debit Credit 6 Account 7 Number Name 8 1110 Cash 9 1120 Accounts Receivable 10 1130 Prepaid Insurance 11 1140 Prepaid Rent 12 1150 Office Supplies 13 1211 Office Equip. 14 1212 Accum. Depr.-Office Equip. 15 1311 Computer Equip. 16 1312 Accum. Depr.-Computer Equip. 17 1411 Building Cost 18 1412 Accum. Depr.-Building 19 1510 Land 20 2101 Accounts Payable 21 2102 Advanced Payments 22 2103 Interest Payable 23 2105 Salaries 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 Expense 36 5080 Supplies Expense 5090 Interest Expense 38 5100 Insurance Expense 39 5110 Depreciation Expense 40 41 Total 42 NET INCOME 43 Balance 44 45 46 Unadjusted Trial Balance Debit Credit 70,274.00 0.00 1,156.00 0.00 $ 5,640.00 0.00 5,400.00 0.00 580.00 0.00 2,122.00 0.00 0.00 0.00 228,960.00 0.00 0.00 0.00 120,000.00 0.00 0.00 0.00 23,000.00 0.00 0.00 1,420.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 128,700.00 0.00 116,500.00 0.00 199,392.00 2,300.00 0.00 Adjusting Entries Adjusted Trial Balance Debit Credit Debit Credit 0.00 0.00 70,274.00 5,500.00 0.00 $ 6,656.00 0.00 235.00 5,405.00 0.00 $ 1,800.00 3,600.00 0.00 344.00 236.00 0.00 $ 2,122.00 0.00 $ 19.31 19.31 0.00 0.00 228,960.00 0.00 3,816.00 $ 3,816.00 0.00 0.00 120,000.00 0.00 298.94 $ 298.94 0.00 0.00 $ 23,000.00 0.00 0.00 $ 1,420.00 0.00 0.00 0.00 1,616.48 1,616.48 0.00 486.00 486.00 0.00 0.00 128,700.00 0.00 0.00 116,500.00 0.00 0.00 199,392.00 0.00 0.00 2,300.00 Balance Sheet Debit Credit 70,274.00 6,656.00 5,405.00 3,600.00 236.00 2,122.00 19.31 228,960.00 3,816.00 $ 120,000.00 298.94 23,000.00 1,420.00 1,616.48 486.00 128,700.00 116,500.00 199,392.00 2,300.00 22,820.00 22,820.00 0.00 0.00 1,620.00 350.00 1,090.00 840.00 0.00 0.00 0.00 0.00 17,320.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,800.00 486.00 0.00 0.00 0.00 344.00 1,616.48 235.00 4,134.25 5,500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,800.00 2,106.00 350.00 1,090.00 840.00 344.00 1,616.48 235.00 4,134.25 1,800.00 2,106.00 350.00 1,090.00 840.00 344.00 1,616.48 235.00 4,134.25 37 463,332.00 463,332.00 14, 115.73 14, 115.73 475,068.73 475,068.73 22,820.00 462,553.00 12,515.73 10,304.27 22,820.00 452,248.73 10,304.27 462,553.00 22,820.00 462,553.00 Welcome Chart of Accounts Transactions General Journal Worksheet Income Statement Changes in Owner's Equity Balance Sheet How to Create a Pivot Table Ready BI + 125% 1 2 A Byte of Accounting Income Statement For Month Ending June 30, 2020 3 4 Revenues Computer Revenue $ 22,820.00 Expenses Rent Expense Salary Expense Advertising Expense Repairs & Maint. Expense Oil & Gas Expense Supplies Expense Interest Expense Insurance Expense Depreciation Expense Total $ 1,800.00 $ 2,106.00 $ 350.00 $ 1,090.00 $ 840.00 $ 344.00 $ 1,616.48 $ 235.00 $ 4,134.25 $ 12,515.73 Net Income $ 10,304.27 5 6 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 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 Welcome Chart of Accounts Transactions General Journal Worksheet P Income Statement Changes in Owner's Equity Balance Sheet How to Create a Pivot Table + Ready . 100% 1 2 A Byte of Accounting Statement of Owner's Equity For Month Ending June 30, 2020 3 4 5 Total $ Balance, Beginning of Period Investment Net Income Withdrawals Balance, End of Period 6 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 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 Welcome Chart of Accounts Transactions A General Journal Worksheet Income Statement Changes in Owner's Equity Balance Sheet How to Create a Pivot Table | + Ready B + 100% B D E F G H 1 J K L M N o P Q R S T U V A Byte of Accounting Balance Sheet As of June 30, 2020 Assets Current Assets Cash Accounts Receivable Prepaid Insurance Prepaid Rent Office Supplies Total Long-Term Assets Office Equip. Accum. Depr.-Office Equip. Computer Equip. Accum. Depr.-Computer Equip. Building Cost Accum. Depr.-Building Land Total Total Assets Liabilities Current Liabilities Accounts Payable Advanced Payment Interest Payable Salaries Payable Total Long-Term Liabilities Mortgage Payable Notes Payable Total Total Liabilities Owner's Equity Hudson Bloom, Capital Total Liabilities and Owner's Equity Welcome Chart of Accounts Transactions General Journal Worksheet Income Statement Changes in Owner's Equity Balance Sheet How to Create a Pivot Table Ready 100%