create a statement of changes in retained earning and balance sheet and pivot table.

$ 26,090.00 Byte of Accounting, Inc. For the month ending June 30, 2020 Income Statement Revenues Computer Consultation Revenue Expenses: Rent expense Salary expense Advertising expense Repairs & maintenance expense Oil & gas expense Supplies expense Interest expense Insurance expense Depreciation expense Total Expenses $1,800.00 $ 2,366.00 $ 350.00 $1,290.00 $ 940.00 $ 316.00 $1,352.33 $ 235.00 $3,767.56 $12,416.89 Net Income before taxes Income Tax Expense @ 25% Net Income $ 13,673.11 $ 3,418.28 13673.11*25% $ 10,254.83 Income Statement Debit Credit - Byte of Accounting Inc Accounts Cash Accounts Receivable Prepaid Insurance Prepaid Rent Office Supplies Office Equipment Accum. Depr. - Office Equipment Computer Equipment Accum. Depr. - Computer Equipment Land Building Accum. Depr. - Building Accounts Payable Advanced Payment Interest Payable Salaries Payable Income tax Payable Mortgage Payable Note Payable Capital Stock Retained Earnings Dividends Income Statement Computer Consultation Revenue Rent expense Salary expense Advertising expense Repairs & maintenance expense Oil & gas expense Supplies expense Interest expense Insurance expense Depreciation expense Income tax expense Total NET INCOME Total Unadjusted TB Debit Credit $ 79,992.08 $ 1,204.00 $ 5,640.00 $ 5,400.00 $ 530.00 $ 1,954.00 $ $ 211,840.00 $ $ 17,000.00 $ 90,000.00 $ $ 1,470.00 $ $ $ $ $ 96,300.00 $ 103,500.00 $ 201,024.00 $ $ 1,423.92 Adjusting entries Adjusted TB Debit Credit Debit Credit $ 79,992.08 $ 9,000.00 $ 10,204.00 $ 235.00 $ 5,405.00 $ 1,800.00 $ 3,600.00 $ 316.00 $ 214.00 $ 1,954.00 $ 17.31 $ 17.31 $ 211,840.00 $ 3,530.67 $ 3,530.67 $ 17,000.00 $ 90,000.00 $ 219.58 $ 219.58 $ 1,470.00 $ $ $ 1,352.33 $ 1,352.33 $ 546.00 $ 546.00 $ 3,418.28 $ 3,418.28 $ 96,300.00 $ 103,500.00 $ 201,024.00 $ $ 1,423.92 Balance Sheet Debit Credit $ 79,992.08 $ 10,204.00 $ 5,405.00 $ 3,600.00 $ 214.00 $ 1,954.00 $ 17.31 $ 211,840.00 $ 3,530.67 $ 17,000.00 $ 90,000.00 $ 219.58 $ 1,470.00 $ $ 1,352.33 $ 546.00 $ 3,418.28 $ 96,300.00 $ 103,500.00 $ 201,024.00 $ $ 1,423.92 $ 17,090.00 $ 9,000.00 $ $ 1,800.00 $ 1,820.00 $ 546.00 $ 350.00 $ 1,290.00 $ 940.00 $ $ 316.00 $ $ 1,352.33 $ $ 235.00 $ $ 3,767.56 $ $ 3,418.28 $ 419,384.00 $ 419,384.00 $ 20,435.17 $ 20,435.17 $ 26,090.00 $ 1,800.00 $ 2,366.00 $ 350.00 $ 1,290.00 $ 940.00 $ 316.00 $ 1,352.33 $ 235.00 $ 3,767.56 $ 3,418.28 $ 437,468.17 $437,468.17 $ 26,090.00 $ 1,800.00 $ 2,366.00 $ 350.00 $ 1,290.00 $ 940.00 $ 316.00 $ 1,352.33 $ 235.00 $ 3,767.56 $ 3,418.28 $ 15,835.17 $26,090.00 $421,633.00 $ 411,378.17 $ 10,254.83 $ 10,254.83 $ 26,090.00 $ 26,090.00 $421,633.00 $421,633.00 $ 437,468.17 $437,468.17 A Byte of Accounting, Inc. Statement of Changes in Retained Earnings For Month Ending June 30, 2021 Total Balance, Beginning of Period Net Income Dividends Balance, End of Period A Byte of Accounting, Inc. Balance Sheet As of June 30, 2021 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 Income Taxes Payable Total Long-Term Liabilities Mortgage Payable Notes Payable Total Total Liabilities Stockholder's Equity Capital Stock Retained Earnings Total Total Liabilities and Stockholder's Equity