AutoSave OFF AT3284 Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Arial 10 V A A Insert v ab Wrap Text v General WE 27 or 5 Delete v V Paste B I Uv mov .00 $ v % 9 - Ideas V Merge & Center v Sensitivity Conditional Format Formatting as Table Cell Styles Format v Sort & Filter Find & Select Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No M3 fx A B D E F G H J K L M N O P Q R S 1 2 A Byte of Accounting, Inc. Worksheet For Period Ending June 30, 2020 3 Adjusted Trial Balance Debit Credit Income Statement Debit Credit Balance Sheet Debit Credit 4 5 6 Account Unadjusted Trial Balance 7 Number Name Debit Credit 8 1110 Cash 48,351.00 0.00 9 1120 Accounts Receivable 1,159.00 0.00 10 1130 Prepaid Insurance 5,640.00 0.00 11 1140 Prepaid Rent 6,400.00 0.00 12 1150 Office Supplies 505.00 0.00 13 1211 Office Equip. 161,823.00 0.00 14 1212 Accum. Depr.-Office Equip. 0.00 0.00 15 1311 Computer Equip. 45,310.00 0.00 16 1312 Accum. Depr.-Computer Equip. 0.00 0.00 17 1411 Building Cost 95,000.00 0.00 18 1412 Accum. Depr.-Building 0.00 0.00 19 1510 Land 15,000.00 0.00 20 2101 Accounts Payable 0.00 1,420.00 21 2102 Advanced Payments 0.00 9,500.00 22 2103 Interest Payable 0.00 0.00 23 2105 Salaries Payable 0.00 0.00 25 2201 Mortgage Payable 0.00 100,500.00 26 2202 Notes Payable 0.00 103,500.00 27 3100 Hudson Bloom, Capital 0.00 154,008.00 28 3300 Hudson Bloom, Withdrawals 1,600.00 0.00 29 30 4100 Computer & Consulting Revenue 0.00 16,035.00 31 5010 Rent Expense 0.00 0.00 32 5020 Salary Expense 1,720.00 0.00 33 5030 Advertising Expense 300.00 0.00 34 5040 Repairs & Maint. Expense 1,240.00 0.00 35 5050 Oil & Gas Expense 915.00 0.00 36 5080 Supplies Expense 0.00 0.00 37 5090 Interest Expense 0.00 0.00 38 5100 Insurance Expense 0.00 0.00 39 5110 Depreciation Expense 0.00 0.00 40 41 Total 384,963.00 384,963.00 42 NET INCOME 43 Balance 44 45 46 47 48 Welcome Chart of Accounts Transactions Adjusting Entries Debit Credit 0.00 0.00 9,000.00 0.00 0.00 235.00 0.00 1,600.00 0.00 202.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 212.97 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,600.00 0.00 0.00 0.00 0.00 202.00 212.97 235.00 9,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 11,249.97 11,249.97 General Journal Worksheet Income Statement Changes in Owner's Equity Balance Sheet How to Create a Pivot Table El + 100% AutoSave OFF AT3284 Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Arial 10 V A A Insert v ab Wrap Text v General WE 27 or 5 Delete v V Paste B I Uv mov .00 $ v % 9 - Ideas V Merge & Center v Sensitivity Conditional Format Formatting as Table Cell Styles Format v Sort & Filter Find & Select Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No M3 fx A B D E F G H J K L M N O P Q R S 1 2 A Byte of Accounting, Inc. Worksheet For Period Ending June 30, 2020 3 Adjusted Trial Balance Debit Credit Income Statement Debit Credit Balance Sheet Debit Credit 4 5 6 Account Unadjusted Trial Balance 7 Number Name Debit Credit 8 1110 Cash 48,351.00 0.00 9 1120 Accounts Receivable 1,159.00 0.00 10 1130 Prepaid Insurance 5,640.00 0.00 11 1140 Prepaid Rent 6,400.00 0.00 12 1150 Office Supplies 505.00 0.00 13 1211 Office Equip. 161,823.00 0.00 14 1212 Accum. Depr.-Office Equip. 0.00 0.00 15 1311 Computer Equip. 45,310.00 0.00 16 1312 Accum. Depr.-Computer Equip. 0.00 0.00 17 1411 Building Cost 95,000.00 0.00 18 1412 Accum. Depr.-Building 0.00 0.00 19 1510 Land 15,000.00 0.00 20 2101 Accounts Payable 0.00 1,420.00 21 2102 Advanced Payments 0.00 9,500.00 22 2103 Interest Payable 0.00 0.00 23 2105 Salaries Payable 0.00 0.00 25 2201 Mortgage Payable 0.00 100,500.00 26 2202 Notes Payable 0.00 103,500.00 27 3100 Hudson Bloom, Capital 0.00 154,008.00 28 3300 Hudson Bloom, Withdrawals 1,600.00 0.00 29 30 4100 Computer & Consulting Revenue 0.00 16,035.00 31 5010 Rent Expense 0.00 0.00 32 5020 Salary Expense 1,720.00 0.00 33 5030 Advertising Expense 300.00 0.00 34 5040 Repairs & Maint. Expense 1,240.00 0.00 35 5050 Oil & Gas Expense 915.00 0.00 36 5080 Supplies Expense 0.00 0.00 37 5090 Interest Expense 0.00 0.00 38 5100 Insurance Expense 0.00 0.00 39 5110 Depreciation Expense 0.00 0.00 40 41 Total 384,963.00 384,963.00 42 NET INCOME 43 Balance 44 45 46 47 48 Welcome Chart of Accounts Transactions Adjusting Entries Debit Credit 0.00 0.00 9,000.00 0.00 0.00 235.00 0.00 1,600.00 0.00 202.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 212.97 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,600.00 0.00 0.00 0.00 0.00 202.00 212.97 235.00 9,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 11,249.97 11,249.97 General Journal Worksheet Income Statement Changes in Owner's Equity Balance Sheet How to Create a Pivot Table El + 100%