Please journalize and answer the following questions.
40. Based on the information on the "Bank Reconciliation" sheet prepare the journal entry required to increases cash. 41. Based on the information on the "Bank Reconciliation" sheet prepare the journal entry required to decreases cash. PublicBank Byte of Accounting P.O. Box 5651212, Miami, Florida 33999 123 Speed Lane Ph # (305) 556-1212 Miami, Florida 33999 Previous Balance Account Number Deposits/Credits 33999999 202, 123.80 Statement Date 6/30/202x Checks/Debits 77,465.00 Ending Balance 124,658.80 124,658.80 Activity in date order Date Description Jun 01 Deposit Amount Balance lun 07 90,508.80 190,508.80 Paid check # 5002 -27,000,00 163,508.80 Jun 15 Paid check # 5003 Jun 16 -20,750.00 142.758.80 Deposit 7,520.00 150,278.80 Jun 21 Paid check # 5005 Jun 22 NSF 14,900.00 135,378.80 Jun 22 2,850.00 132,528.80 NSF service charge Jun 22 -25.00 132,503.80 Paid check # 5006 Jun 23 7.500.00 125,003.80 Deposit Jun 24 4,095,00 129,098,80 Paid check # 306 Jun 26 Paid check # 5007 1,400.00 127,698.80 Jun 26 -560.00 127, 138.80 Paid check # 5008 Jun 27 -700.00 126.438.80 Paid check # 5009 Jun 27 1,035,00 125,403.80 Elec Remit AT&T Telephone Jun 27 -225.00 125, 178.80 Paid check # 5010 -475.00 124,703.80 Service Charge- Checks -45.00 Ending Balance 124,658.80 Check # 306 is not our check Our policy is to charge the customer for any charges related to NSF checks The Deposit on Jun 16 was incorrectly recorded by the bank. The Deposit on Jun 23 was correctly recorded by the bank. We do not modify the original journal entry. Company's Books Ending Balance per books Bank Statement 121,465.76 Ending balance per bank 124,658.80 Additions Additions 1. Add to Books Total 2. Add to Bank Total Deductions Deductions Error deposit Jun 16 270.00 3. Deduct from Books 4. Deduct from bank Ending Correct cash balance Ending Correct cash balance 10 Jun 16 10 1110 Cash revenue from service Jun 16 7,250.00 4100 Computer & Consulting Rerevenue from service 7,250.00 21 Jun 23 1110 Cash received account recievable 21 3,845.00 Jun 23 1120 Accounts Receivable received account recievable 3,845.0042. Income taxes are to be computed at the rate of 25 percent of net income before taxes. [IMPORTANT NOTE: Since the income taxes are a percent of the net income you will want to prepare the Income Statements through the Net Income Before Tax line. The worksheet contains all of the accounts and their balances which you can then transfer to the appropriate financial statement.] 39 Jun 30 4100 Computer & Consulting Re close revenue accounts 39 36,645.00 Jun 30 3400 Income Summary close revenue accounts 36,645.00 40 Jun 30 5120 Bad Debt Expense tax expense 40 869.67 Jun 30 2106 Income Taxes Payable tax expense 869.67 41 Jun 30 42 Jun 30 43 Jun 30 Jun 30 3400 Income Summary close expense accounts 15,955.64 Jun 30 5010 Rent Expense close expense account 2,100.00 Jun 30 5020 Salary Expense close expense accounts .171.00 Jun 30 5030 Advertising Expense close expense accounts 325.00 Jun 30 5040 Repairs & Maint. Expense close expense accounts 1.190.00 Jun 30 5050 Oil & Gas Expense close expense accounts 990.00 Jun 30 5080 Supplies Expense close expense accounts 303.00 Jun 30 5090 Interest Expense close expense accounts 1.423.86 Jun 30 5100 Insurance Expense close expense accounts 242.00 Jun 30 5110 Depreciation Expense close expense accounts .814.32 Jun 30 5120 Bad Debt Expense close expense accounts 3.396.46 45 Jun 30 3400 Income Summary close income summary account 10,189.36 Jun 30 3200 Retained Eamings close income summary account 10,189.36 46 Jun 30 3200 Retained Eamings close dividends account 46 1,237.68 Jun 30 3300 Dividends close dividends account 1,237.68A Byte of Accounting, Inc. Worksheet For Period Ending June 30, 2021 Account adjusted Trial Balance Number Name Adjusting Entries Adjusted Trial Balance Debit Credit Income Statement Debit Balance Sheet 1110 Cash Credit Debit Credit 121,465.76 Debit Credit 0.00 Debit 0.00 Credit 1120 Accounts Receivable 0.00 121,465.76 1.250.00 0.00 0.00 19,000.00 0.00 1121 Allowance for Doubtful Accounts 20,250.00 0.00 0.00 0.00 0.00 0.00 1130 Prepaid Insurance 0.00 6.480.00 0.00 0.00 0.00 1140 Prepaid Rent 270.00 6,210.00 0.00 .500.00 0.00 0.00 1150 Office Supplies 2,500.00 5,000.00 1,225.00 0.00 0.00 0.00 369.00 1211 Office Equip. 856.00 0.00 2,040.26 0.00 0.00 0.00 1212 Accum. Depr.-Office Equip 2,040.26 0.00 0.00 0.00 0.00 1311 Computer Equip. 18.34 0.00 196.220.40 18.34 0.00 0.00 0.00 1312 Accum. Depr.-Computer Equip 196,220.40 0.00 0.00 0.00 0.00 1411 Building Cost 3,270.34 0.00 25,000.00 3.270.34 0.00 0.00 0.00 1412 Accum. Depr.-Building 25,000.00 0.00 0.00 0.00 0.00 1510 Land 312.17 0.00 24,000.00 312. 17 0.00 0.00 2101 Accounts Payable 0.00 24,000.00 0.00 0.00 4,755.00 0.00 2102 Advanced Payments 0.00 0,00 0.00 4,755.00 0.00 0.00 2103 Interest Payable 0.00 0.00 0.00 0.00 0.00 0.00 2105 Salaries Payable 1,482.73 0.00 0.00 1.482.73 0.00 0.00 2106 Income Taxes Payable 621.00 0.00 0.00 621.00 0.00 0.00 869.67 2201 Mortgage Payable 0.00 0.00 869.67 134, 100.00 0.00 2202 Notes Payable 0.00 0.00 134, 100.00 0.00 87,250.00 3100 Capital Stock 0.00 0.00 0.00 0.00 252,509.46 87,250.00 0.00 3110 Paid-in Capital in Excess of Par Value 0.00 0.00 0.00 252,509.46 0.00 0.00 3200 Retained Earnings 0.00 0.00 0.00 0.00 0.00 0.00 3300 Dividends 0.00 0.00 0.00 3.713.04 0.00 0.00 0.00 3,713.04 0.00 0.00 0.00 0.00 0.00 4100 Computer & Consulting Revenue 0.00 0.00 0.00 17.645.00 17.645.00 5010 Rent Expense 0.00 0.00 0.00 0.00 0.00 2,500.00 0.00 5020 Salary Expense 2,500.00 0.00 2,070.00 0.00 621.00 5030 Advertising Expense 0.00 2,691.00 475.00 0.00 0.00 0.00 0.00 5040 Repairs & Maint. Expense 475.00 2,580.00 0.00 0.00 0.00 5050 Oil & Gas Expense 0.00 2,580.00 840.00 0.00 0.00 0.00 0.00 5080 Supplies Expense 840.00 1.400.00 0.00 0.00 369.00 0.00 5090 Interest Expense 1.769.00 0.00 0.00 0.00 .482.73 0.00 5100 Insurance Expense 0.00 1.482.73 0.00 0.00 3,870.85 5110 Depreciation Expense 0.00 3,870.85 0.00 0.00 0.00 0.00 5120 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 869.67 0.00 5130 Bank Expense 869.67 0.00 0.00 0.00 0.00 0.00 5140 Telephone Expense 0.00 0.00 0.00 0.00 0.00 5150 Income Taxes Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total 496,259.46 496,259.46 46,358.25 9,713.25 521,833.71 NET INCOME 485, 188.71 Balance