2 A Byte of Accounting, Inc. General Journal Note: You can only enter data into the yellow filled cells. 3 Account Transaction Date Name Description Debit Credit 52,000.00 01 01 Jun 01 Jun 01 1110 Cash 3100 Capital Stock Issue of common stock Issue of common stock 52,000.00 02 02 02 Jun 01 Jun 01 Jun 01 1110 Cash 1311 Computer Equip. 3100 Capital Stock Issue of common stock Issue of common stock Issue of common stock 27,820.00 39,000.00 66,820.00 03 03 03 03 Jun 01 Jun 01 Jun 01 Jun 01 1110 Cash 1311 Computer Equip. 1211 Office Equip. 3100 Capital Stock Issue of common stock Issue of common stock Issue of common stock Issue of common stock 50,700.00 15.080.00 910.00 66,690.00 135,000.00 131313H 041 041 04 Jun 02 Jun 02 Jun 02 1311 Computer Equip. 1110 Cash 2202 Notes Payable purchase of computer equipment purchase of computer equipment purchase of computer equipment 27,000.00 108,000.00 . 5 3 7 3 3 0 1 2 3 4 5 6 7 7 8 8 9 O 1 2 3 3 4 5 6 7 7 8 9 0 -1 2 2 3 4 5 6 7 8 9 0 1 1 2 3 4 5 5 6 7 300.00 05 05 Jun 04 Jun 04 1211 Office Equip. 2101 Accounts Payable purchase of computer equipment purchase of computer equipment 300.00 60.00 06 06 Jun 08 Jun 08 2101 Accounts Payable 1211 Office Equip. return office equipment return office equipment 60.00 20,750.00 07 07 Jun 10 Jun 10 2202 Notes Payable 1110 Cash payment of computer equipment payment of computer equipment 20,750.00 5,976.00 08 08 Jun 14 Jun 14 1130 Prepaid Insurance 1110 Cash computer insurance computer insurance 5,976.00 7,000.00 09 09 Jun 16 Jun 16 1110 Cash computer consultancy revenue 4100 Computer & Consulting computer consultancy revenue 7,000.00 F G H J J K L M N O Q R S U V W A B D E A Byte of Accounting, Inc. General Journal Note: You can only enter data into the yellow filled cells. Debit Transaction Date Name Account Credit 10 10 10 10 16,000.00 85,000.00 Jun 16 Jun 16 Jun 16 Jun 16 1510 Land 1411 Building Cost 1110 Cash 2201 Mortgage Payable Description purchase of land & building purchase of land & building purchase of land & building purchase of land & building 10,100.00 90.900.000 11 11 7,200.00 Jun 17 Jun 17 1140 Prepaid Rent 1110 Cash payment of rent payment of rent 7,200.00 350.00 12 12 Jun 17 Jun 17 5030 Advertising Expense 2101 Accounts Payable advertising expense advertising expense 350.00 240.00 13 13 Jun 21 Jun 21 2101 Accounts Payable 1110 Cash payment of accounts payable payment of accounts payable 240.00 800.00 141 141 Jun 21 Jun 21 1211 Office Equip. 1110 Cash purchase of fax machine purchase of fax machine 800.00 4,700.00 15 15 Jun 21 Jun 21 1120 Accounts Receivable consulting revenue 4100 Computer & Consulting consulting revenue 4,700.00 985.00 16 16 Jun 22 Jun 22 5020 Salary Expense 1110 Cash salary payment salary payment 985.00 17 17 1,240.00 Jun 22 Jun 22 5040 Repairs & Maint. Expen computer repairing fee 2101 Accounts Payable computer repairing fee 1,240.00 18 18 350.00 Jun 22 Jun 22 2101 Accounts Payable 1110 Cash payment of advertising expense payment of advertising expense 350.00 1 2 A Byte of Accounting, Inc. General Journal Note: You can only enter data into the yellow filled cells. 3 Account Debit 4 Transaction Date Name Credit 19 19 580.00 Jun 23 Jun 23 Description purchase of office supplies purchase of office supplies 1150 Office Supplies 2101 Accounts Payable 580.00 3,765.00 20 20 Jun 23 Jun 23 1110 Cash 1120 Accounts Receivable receive payment receive payment 3,765.00 5,385.00 21 21 Jun 28 Jun 28 1120 Accounts Receivable accounts recievable 4100 Computer & Consulting accounts recievable 5,385.00 1,240.00 22 22 Jun 29 Jun 29 2101 Accounts Payable 1110 Cash payment of computer repair payment of computer repair 1,240.00 5,101.00 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 23 23 Jun 29 Jun 29 1110 Cash 1120 Accounts Receivable receive payment receive payment 5,101.00 #REFI 985.00 24 24 Jun 29 Jun 29 5020 1110 Cash salary payment Debit And Credit On Same Line 985.00 965.00 25 25 Jun 30 Jun 30 5050 Oil & Gas Expense 2101 Accounts Payable oil & gas expense oil & gas expense 965.00 1,141.60 26 26 Jun 30 Jun 30 3300 Dividends 1110 Cash Idividends paid dividends paid 1,141.60 27 27 Jun 30 Jun 30 2.400.00 5010 Rent Expense 1140 Prepaid Rent rent expense recognised rent expense recognised 2,400.00 A Byte of Accounting, Inc. General Journal Note: You can only enter data into the yellow filled cells. Debit Transaction Date Account Credit 28 28 Name 5080 Supplies Expense 1150 Office Supplies Jun 30 Jun 30 344.00 Description supplies expense supplies expense 344.00 284.06 29 29 Jun 30 Jun 30 5090 Interest Expense 2103 Interest Payable interest adjustment interest adjustment 284.06 Discover more about your data 249.00 30 30 Jun 30 Jun 30 5100 Insurance Expense 1130 Prepaid Insurance insurance adjustment insurance adjustment 249.00 5,625.00 31 31 Jun 30 Jun 30 1120 Accounts Receivable unbilled revenue 4100|Computer & Consulting unbilled revenue 5,625.00 3,372.76 32 32 32 32 Jun 30 Jun 30 Jun 301 Jun 30 5110 Depreciation Expense depreciation expense 1312 Accum. Depr.-Computer #REF! 1212 Accum. Depr.-Office Egl #REF! 1412 Accum. Depr.-Building #REF! 202.38 3,151.331 19.05 591.00 33 33 Jun 30 Jun 30 5020 Salary Expense 2105 Salaries Payable salary expense salary expense 591.00 34 34 Jun 30 Jun 30 869.67 2103 Interest Payable 5090 Interest Expense interest adjustment #REF! 869.67 2,518.63 35 35 Jun 30 Jun 30 5120 Income Tax Expense income tax expense 2106 Income Taxes Payable income tax expense 2,518.63 22,710.00 36 36 Jun 30 Jun 30 4100 Computer & Consulting closing revenue 3400 Income Summary #REF! #REF 22,710.00 A Byte of Accounting, Inc. General Journal Note: You can only enter data into the yellow filled cells. Credit Transaction Date Account Name Description #REFI Debit 15,154.00 37 371 37 37 37 37 37 37 37 37 37 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 #37 Not in Balance by-3.12 3400 Income Summary closing expense 5010 Rent Expense closing expense 5020 Salary Expense closing expense 5030 Advertising Expense closing expense 5040 Repairs & Maint. Expen closing expense 5050 Oil & Gas Expense closing expense 5080 Supplies Expense closing expense 5090 Interest Expense closing expenso 5100 Insurance Expense closing expense 5110 Depreciation Expense closing expense 5120 Income Tax Expense closing expense 2,400.00 2,561.00 350.00 1,240.00 965.00 344.00 1,153.73 249.00 3,372.76 2,518.63 7,555.88 38 38 Jun 30 Jun 30 3400 Income Summary 3200 Retained Eamings closing income summary closing income summary 7,555.88 1,141.60 39 391 Jun 30 Jun 30 3200 #REFI 3300 Dividends closing dividends closing dividends 1.141.60 B C D E H J M N 0 Q R S T F G A Byte of Accounting, Inc. Worksheet For Period Ending June 30, 2021 Adjusting Entries Debit Credit Income Statement Debit Credit 5,625.00 Unadjusted Trial Balance Debit Credit 69.618.40 1.219.00 5,976.00 7,200.00 580.00 - 1,950.00 249.00 2,400.00 344.00 Adjusted Trial Balance Debit Credit 69,618.40 6,844.00 - 5,727.00 4,800.00 - 236.00 1,950.00 3.151.33 189,080.00 202.38 85,000.00 19.05 16,000.00 1,545.00 Balance Sheet Debit Credit 69,618.40 6.844.00 5,727.00 4,800.00 236.00 1,950.00 19.05 189,080.00 3,151.33 16,000.00 85,000.00 202.38 1.545.00 3,151.33 189,080.00 202.38 85,000.00 - 19.05 16,000.00 1,545.00 - 585.61 585.61 591.00 2,518.63 - - 1 2 3 4 5 6 Account 7 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 24 2106 Income Taxes Payable 25 2201 Mortgage Payable 26 2202 Notes Payable 27 3100 Capital Stock 28 3200 Retained Earnings 29 3300 Dividends 30 31 4100 Computer & Consulting Revenue 32 5010 Rent Expense 33 5020 Salary Expense 34 5030 Advertising Expense 35 5040 Repairs & Maint. Expense 36 5050 Oil & Gas Expense 37 5080 Supplies Expense 38 5090 Interest Expense 39 5100 Insurance Expense 40 5110 Depreciation Expense 41 5120 Income Tax Expense 42 43 44 45 46 47 TOTAL 48 NET INCOME 49 50 L 1,153.73 591.00 2,518.63 90,900.00 87,250.00 185,510.00 591.00 2,518.63 90,900.00 87,250.00 185,510.00 90,900.00 87,250.00 185,510.00 - 1,141.60 1,141.60 1,141.60 17,085.00 5,625.00 22,710.00 22,710.00 2,400.00 591.00 - - 1,970.00 350.00 1,240.00 965.00 2,400.00 2,561.00 350.00 1,240.00 965.00 344.00 - - - 2,400.00 2.561.00 350.00 1,240.00 965.00 344.00 1,153.73 249.00 3,372.76 2,518.63 344.00 585.61 585.61 249.00 3,372.76 2,518.63 249.00 3,372.76 2,518.63 382,290.00 382,290.00 15,686.00 15,686.00 394,983.00 394,983.00 22,710.00 15,154.12 7,555.88 380,397.00 372,841.12 7,555.88 A B F G . J K L M N O P Q R S T U A Byte of Accounting, Inc. Income Statement For Month Ending June 30, 2021 Revenues Computer & Consulting Revenue $ 22,710.00 Expenses Rent Expense Salary Expense Advertising Expense Repairs & Maint. Expense Oil & Gas Expense Supplies Expense Interest Expense Insurance Expense Depreciation Expense Total Expenses $ 2,400.00 $ 2,561.00 $ 350.00 $ 1,240.00 $ 965.00 $ 344.00 $ 1,153.73 $ 249.00 $ 3,372.76 12,635.49 Net Income Before Tax $ 10,074.51 Income Tax Expense (Round to two decimal places) 2,518.63 Net Income After Tax 7,555.88 A D K L M N O Q S T 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 B M 1 2 A Byte of Accounting, Inc. Balance Sheet As of June 30, 2021 3 4 Assets 6 7 8 9 10 11 12 13 14 15 16 17 18 Current Assets Cash Accounts Receivable Prepaid Insurance Prepaid Rent Office Supplies Total 20 21 Long-Term Assets Office Equip Accum. Depr.-Office Equip Computer Equip Accum. Depr.-Computer Equip. Building Cost Accum. Depr.-Building Land Total Total Assets 23 24 Liabilities 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 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