A Byte of Accounting, Inc. Worksheet For Period Ending June 30, 2021 Adjusting Entries Debit Credit - Unadjusted Trial Balance Debit Credit 61079.00 1.140.00 5,976,00 - 4,800.00 505.00 65,928.00 Adjusted Trial Balance Debit Credit 61,079.00 1,140.00 5,976.00 4,800.00 505.00 65 928.00 - - - . - 226,430.00 226.430.00 - - 110,000.00 . 110,000.00 . 21,000.00 . - 21,000.00 505.00 136,000.00 305.00 136,000.00 - - . - - - - - - . 1 5 5 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 Equio 16 1312 Accum. Depr.-Computer Equip 17 1411 Building Cost 18 1412 Accum Depr.Buiding 19 1510 Land 20 2101 Accounts Payable 21 2102 Advanced Payments 22 2103 Interest Payable 23 2105 Salaries Payable 24 2106 Income Taxes Payable 25 2201 Mortgage Payable 26 2202 Notes Payable 27 3100 Capital Stock 28 3200 Retained Eamings 29 3300 Dividends 30 31 4100 Computer & Consulting Revenue 32 5010 Rent Exponse 33 5020 Salary Expenso 34 5030 Advertising Expense 35 5040 Repair & Maint Expenso 36 5050 Ol & Gas Expense 37 50B0 Supplies Expense 38 5090 Interest Expenso 39 5100 Insurance Expense 40 5110 Depreciation Expanse 41 5120 Income Tax Expense 42 43 44 45 46 47 TOTAL 48 118,815.00 118,815.00 20,000.00 26,000.00 123552.00 123,552.00 - . . 16,505.00 . 16,505.00 1.970.00 275.00 1315.00 815.00 1,970.00 275.00 1.315.00 815.00 - - - - . - - 461 305.00 461,305.00 401305.00 461,305.00 Chart of Accounts A Transactions General Joumal Worksheet Income Statement Ready Insert Draw Page Layout Formulas Data Review View y Tell me X Arial V 10 V ' ' = 2 Wrap Text BI UB a. Av Merge & ce rd Font Alignment x V fx 5498 B D E G H A Byte of Accounting, Inc. Income Statement For Month Ending June 30, 2021 Revenues Computer & Consulting Revenue S 16,505.00 Expenses Rent Expense Salary Expense Advertising Expense Repairs & Maint. Expense Oil & Gas Expense Supplies Expense Interest Expense Insurance Expense Depreciation Expense Total Expenses $ 4,800.00 $ 1,970.00 $ 275.00 $ 1,315.00 $ 815.00 9,175.00 Net Income Before Tax $ 7330.00 Income Tax Expense and we dedi 1,832.50 Net Income After Tax $ 5,498.00 BTUA Merge & Center Alignment oard Font . XV fx 202 A E G B Assets H Current Assets Cash Accounts Receivable Prepaid Insurance Prepaid Rent Office Supplies Total $ 202.00 Long-Term Assets Office Equip Accum. Depr.-Office Equip Computer Equip Accum. Depr.-Computer Equip Building Cost Accum. Depr.-Buliding 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 Chart of Accounts Transactions General Journal Worksheet Income Statemen sert Draw Page Layout Rev Arial 10 ' == ab Wrap Text v BIU A. 100 Merge & Center Font Alignment x & fx B D E A Byte of Accounting, Inc. Statement of Changes in Retained Earnings For Month Ending June 30, 2021 Total Balance, Beginning of Period Net Income $ 9.175.00 9,175.00 $ Dividends Balance, End of Period
