B 9 50 01 02 03 04 05 06 107 108 109 110 111 112 113 114 115 116 117 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. 42. 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.] Closing Entries 43. Close the revenue accounts. 44. Close the expense accounts. 45. Close the income summary account. unt 46. Close the dividends account. 99 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 40 40 41 41 43 43 42 Jun 30 42 Jun 30 44 44 44 44 44 44 44 44 44 44 44 44 45 45 Jun 30 Jun 30 46 46 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 1110 Cash 1120 Accounts Receivable 1120 Accounts Receivable. 1110 Cash 5150 Income Tax Expense 2106 Income Taxes Payable 4100 Computer & Consulting 3400 Income Summary 5100 Insurance Expense 5110 Depreciation Expense 5150 Income Tax Expense 5120 Bad Debt Expense 3400 Income Summary 3200 Retained Eamings deposti wrongly recorded deposti wrongly recorded 3200 Retained Eamings 3300 Dividends NSF Check and charges NSF Check and charges 3400 Income Summary 5010 Rent Expense 5020 Salary Expense 5030 Advertising Expense 5040 Repairs & Maint. Expense 5050 Oil & Gas Expense 5080 Supplies Expense 5090 Interest Expense Need a Description ReClosing entry Closing entry Closing entry Closing entry Closing entry Closing entry Closing entry Closing entry Closing entry Closing entry Closing entry Closing entry Closing entry Closing entry Closing entry Closing entry Closing entry Closing entry 50.00 3,275.00 3,964.53 35,085.00 23.191.41 11,893.59 1,075.68 50.00 3,275.00 3,964.53 35,085.00 2,100.00 2,496.00 475.00 1,100.00 840.00 2,390.00 1,212.97 214.00 7,607 21 3,964.53 701.70 11,893.59 1.075.68 B Previous Balance PublicBank P.O. Box 5551212, Mami, Florida 33999 Ph # (305) 555-1212 Ending Balance Activity in date order Date Jun 01 Jun 07 Jun 15 Jun 16 Jun 21 Jun 22 Jun 22 Jun 22 Jun 23 Jun 24 Jun 26 Jun 26 Jun 27 Jun 27 Jun 27 Jun 29 D Deposits/Credits Checks/Debits Description Deposit - Paid check # 5002 Paid check # 5003 Deposit Paid check #5005 NSF NSF service charge Paid check #5006 Deposit Paid check # 306 Paid check # 5007 Paid check # 5008 E Paid check # 5009 Elec Remit AT&T Telephone Paid check # 5010 Service Charge- Checks Ending Balance F 196,805.00 73,760.00 123,045.00 123,045.00 G H Byte of Accounting 123 Speed Lane Miami, Florida 33999 Account Number Statement Date Amount 186,800.00 -28,000.00 -21,500.00 6,510.00 -10,700.00 3,250.00 -25.00 -6,300.00 3,495.00 -1,300.00 -240.00 -725.00 -960.00 -240.00 475.00 45.00 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 comectly recorded by the bank. We do not modify the original joumal entry. 33999999 6/30/200x Balance 186,800.00 158,800.00 137,300.00 143,810.00 133,110.00 129,860.00 129,835.00 123,535.00 127,030.00 125,730.00 125.490.00 124,765.00 123,805.00 123.565.00 123,090.00 123,045.00 123,045.00 K L 40 50 51 53 50 54 54 56 50 57 SB 58 50 60 61 21 62 M 83 A 06 #T 47 68 60 M 70 11 M 87 M 60 20 90 A 91 m 10 M 10 16 97 w 20 P 100 101 102 109 104 105 106 107 108 109 110 111 10 10 11 11 11 12 12 13 13 14 14 151 15 16 100 17 17 16 18 19 20 23 21 21 Jun 14 Jun 15 An 15 Jun 15 An 15 An 15 Jun 1 Jun 17 Jun 17 Jun 21 21 an 21 An 21 An 21 Am 21 An 22 2n 22 be 22 he 20 Jun 25 An 2 An 2 An 23 Jun 20 1110 Cash 1110mb Bev for come corp 4100 Computer & Consulting Rev Rev for como const 1411 Bulding 1510 Land 1110 Cash 2201 Martanas Pavable 1140 Prepaid Ret 1110 Cash 5000 Advertsing Expense 2101 Accourts Payable 2121 Accounts Payable 1110 Cash 1215 Omce Earp 5020 Salary Expens 1150 Cab Soaps & Mart Expense 2100 Accounts Pecable 2521 Accourts Partie 1150 Cash 1150 PREFI 2101 Accourts Payable 1 year prepaid insurance 1118 Cash 1120 Accounts Receivable 1120 Accounts Receratre etcuntomers for conting services 4100 Computer & Commuting Reveted customers fr.com Welcome Acquisition of Land and Building Acquisition of Land and Building Acquisition of Land and Building Acquisition of Land and Building Rent for regal Ret for brey.agal Advertising expense Advertising expense Account Proble Account Perable Fax Machine Fax Machine C Care sper Computer perts repair Computer perts re Padresing from bare 17 Per advertising from bre 17 Pershine of office ALM Amount recehad on billing Amount recebred on billing Chart of Accounts A1000 90,000.00 17.000.00 Transactions 6.300.00 475.00 775.00 4.300.00 900.00 1.190.00 475.00 1.000.00 3.445.00 4.col ADM 0.150.00 96,300.00 6.300.00 725.00 4.300.00 1.390.00 475.00 1.445.00 General Journal Bank Reconcilation Worksheet Income Str Format -Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? fx 07 07 1 08 08 2 54 65 66 8588RENFERRER 67 68 69 70 71 09 Jun 14 09 Jun 14 29 3333 22 72 73 74 10 10 75 76 B 77 78 Jun 08 Jun 08 11 11 11 Jun 10 Jun 10 11 12 Jun 16 Jun 16 13 13 Jun 17 12 Jun 17 14 14 Jun 16 Jun 16 Jun 16 Jun 16 C 15 15 1150 Office Supplies 2101 Accounts Payable Jun 17 Jun 17 D 2202 Notes Payable 1110 Cash Jun 21 Jun 21 Jun 21 Jun 21 1130 Prepaid Insurance 1110 Cash 1411 Building 1510 Land 1110 Cash 2201 Mortgage Payable 1140 Prepaid Rent 1110 Cash 5030 Advertising Expense 2101 Accounts Payable 1110 Cash Rev for comp consult 4100 Computer & Consulting Ri Rev for comp consult 2101 Accounts Payable 1110 Cash office Supplies office Supplies 1211 Office Equip 1110 Cash Payment balance of Computer equip Payment balance of Computer equip 1 year prepaid insurance 1 year prepaid insurance E Acquisition of Land and Building Acquisition of Land and Building Acquisition of Land and Building Acquisition of Land and Building Rent for june, july, august Rent vor june, july, august Advertising expense Advertising expense Account Payable Account Payable Fax Machine Fax Machine General Journal 6 Bank Reconcilation F 2,000.00 21,500.00 5,136.00 6,150.00 90,000.00 17,000.00 6,300.00 475.00 240.00 725.00 Worksheet 2,000.00 21,500.00 G 5,136.00 6,150.00 10,700.00 96,300.00 6,300.00 475.00 725.00 240.00 Income Statoi MacBook Unsaved Workbooks. We were able to x fx 18 18 19 19 3 4 151 16 17 18 119 20 20 120 121 122 123 124 B 125 126 21 21 Jun 22 Jun 22 127 128 129 130 Jun 22 Jun 22 22 22 Jun 23 Jun 23 23 23 24 Jun 23 Jun 23 24 C Jun 28 Jun 28 25 25 Jun 29 Jun 29 5040 Repairs & Maint. Expense Computer parts repair 2101 Accounts Payable Computer parts repair Jun 29 Jun 29 D 2101 Accounts Payable 1110 Cash Jun 29 Jun 29 #REF! 1150 2101 Accounts Payable 1110 Cash 1120 Accounts Receivable 2101 Accounts Payable 1110 Cash 1110 Cash 1120 Accounts Receivable 5020 Salary Expense 1110 Cash 1120 Accounts Receivable Services perfomed 4100 Computer & Consulting RServices perfomed + Cash received for billings Cash received for billings SODO & Can Exonone E Pay advertising from june 17 Pay advertising from june 17 Purchase of office supplies Purchase of office supplies Amount received on billing Amount received on billing Cash received for billings Cash received for billings equip operator salaries Jequip operator salaries Till for red ant General Journal 6 Bank Reconcilation 1,190.00 F 475.00 1,000.00 3,445.00 5,385.00 1,190.00 5,101.00 960.00 840.00l B Worksheet 1,190 1,000.00 5,101.00 G 475.0 3,445.00 5,385.00 960.00 1.190.00 MacBo