Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Fill in and answer transactions numbers 40, 41, 42, 43 in the general journal. Please also balance the worksheet (income statement x balance sheet). Fill
Fill in and answer transactions numbers 40, 41, 42, 43 in the general journal. Please also balance the worksheet (income statement x balance sheet). Fill in bank reconciliation and worksheet. All materials needed are attatched
A Byte of Accounting General Journal Note: You can only enter data into the yellow filled cells. Transaction Date Account Name Description Debit Credit 01 Jun 01 01 110 Cash Lauryn's common stock purchase Jun 01 3100 Capital Stock 157,552.00 Lauryn's common stock purchase 157,552.00 Jun 01 02 1110 Cash Jun 01 Wiktor Invests in Byte for Common Stock 1311 Computer Equip 32,410.80 021 Wiktor Invests in Byte for Common Stock Jun 01 3100 Capital Stock 45,615.20 Wiktor Invests in Byte for Common Stock 78,026.00 03 Jun 01 1110 Cash Jun 01 Courtney's invests in Byte for Common Stock 1311 Computer Equip 546.00 Jun 01 Courtney's invests in Byte for Common Stock 1211 Office Equip. 15,605.20 Jun 01 Courtney's invests in Byte for Common Stock 3100 Capital Stock 780.26 Courtney's invests in Byte for Common Stock 16,931.46 Jun 02 1311 Computer Equip Jun 02 2202 Notes Payable Check #5002 Down Payment on Computer Equipment invoice 76542 135,000.00 Jun 02 1110 Cash Check #5002 Down Payment on Computer Equipment invoice 76542 108,000.00 Check #5002 Down Payment on Computer Equipment invoice 76542 27,000.00 05 Jun 04 1211 Office Equip. computer equipment purchased invoice 98432 Jun 04 2101 Accounts Payable 700.00 computer equipment purchased invoice 98432 700.00 06 Jun 08 2101 Accounts Payable 06 office equipment returned Jun 08 1211 Office Equip 140.00 office equipment returned 140.00 07 Jun 08 5080 Supplies Expense 07 to record on account purchase Jun 08 07 1150 Office Supplies 1,400.00 to record on account purchase Jun 08 2101 Accounts Payable 350.00 to record on account purchase 1,750.00 08 Jun 10 2202 Notes Payable 08 check #5003 to Royca as payment Jun 10 1110 Cash 20,750.00 check #5003 to Royca as payment 20,750.00 09 Jun 14 1 130 Prepaid Insurance 09 paid for a year- check #5004- Seth's insurance Jun 14 1110 Cash 6,480.00 paid for a year- check #5004- Seth's insurance 6,480.00 10 Jun 16 1110 Cash 10 revenue from service Jun 16 4100 Computer & Consulting Frevenue from service 7,250.00 7,250.00 Jun 16 1510 Land purchased land & building Jun 16 1411 Building 24,000.00 purchased land & building Jun 16 1110 Cash 125,000.00 purchased land & building Jun 16 2201 Mortgage Payable purchased land & building 14,900.00 134,100.00 12 Jun 17 1140 Prepaid Rent 12 paid for rent check #5006 Jun 17 1110 Cash 7.500.00 paid for rent check #5006 7,500.00 13 Jun 17 5030 Advertising Expense 13 advertising expense Jun 17 2101 Accounts Payable 475.00 advertising expense 475.00 14 Jun 21 2101 Accounts Payable payments to account payables Jun 21 1110 Cash 560.00 payments to account payables 560.00 Jun 21 151 1211 Office Equip. Jun 21 purchase of equipment by cash 1110 Cash 700.00 purchase of equipment by cash 700.00 16 Jun 21 16 1 120 Accounts Receivable service revenue on account Jun 21 4100 Computer & Consulting Aservice revenue on account 4,800.00 4,800.00 17 Jun 22 5020 Salary Expense 17 paid Salary Jun 22 1110 Cash 1,035.00 paid Salary 1,035.00 18 Jun 22 18 5040 Repairs & Maint. Expens receipt of bill for computer repair Jun 22 2101 Accounts Payable 1,290.00 receipt of bill for computer repai 1,290.0018 Jun 22 5040 Repairs & Maint. Expens receipt of bill for computer repair 18 1,290.00 Jun 22 2101 Accounts Payable receipt of bill for computer repair 1.290.00 19 Jun 22 2101 Accounts Payable payment of advertising payable 19 475.00 Jun 22 1110 Cash payment of advertising payable 475.00 20 un 23 1150 Office Supplies purchase of supplies on account 20 875.00 Jun 23 2101 Accounts Payable purchase of supplies on account 875.00 21 Jun 23 1110 Cash received account recievable 21 3,845.00 Jun 23 1120 Accounts Receivable received account recievable 3,845.00 22 Jun 28 1120 Accounts Receivable service revenue on accoun 22 5,595.00 Jun 28 4100 Computer & Consulting Fservice revenue on account 5,595.00 23 Jun 29 5040 Repairs & Maint. Expens payment of repairs payable 23 1,290.00 Jun 29 1110 Cash payment of repairs payable 1,290.00 24 Jun 29 1110 Cash received account recievable 24 5,300.00 Jun 29 1120 Accounts Receivable received account recievable 5,300.00 Jun 29 5020 Salary Expense paid Salary 1,035.00 Jun 29 1110 Cash paid Salary 1,035.00 26 Jun 30 5050 Oil & Gas Expense O&G Oil and Gas Company utility payable 26 840.00 Jun 30 2101 Accounts Payable O&G Oil and Gas Company utility payable 840.00 27 Jun 30 3300 Dividends payment of dividend Lauryn, a shareholder 27 1,237.68 Jun 30 1110 Cash payment of dividend Lauryn, a shareholder 1,237.68 28 Jun 30 3300 Dividends paymnet of dividend Courtney, a shareholder 28 1,237.68 Jun 30 1110 Cash paymnet of dividend Courtney, a shareholder 1,237.68 29 Jun 30 3300 Dividends 29 payment of dividend Wiktor Figiel, a shareholder 1,237.68 Jun 30 1110 Cash payment of dividend Wiktor Figiel, a shareholder 1,237.68 30 Jun 30 5010 Rent Expense expired rent for the month -1/3rd 30 2,500.00 Jun 30 1 140 Prepaid Rent expired rent for the month -1/3rd 2,500.00 31 Jun 30 5080 Supplies Expense 31 physical inventory expense 369.00 Jun 30 1150 Office Supplies physical inventory expense 369.00 32 Jun 30 5090 Interest Expense 32 mortgage expense 419.06 Jun 30 2103 Interest Payable mortgage expense 419.06 33 Jun 30 5100 Insurance Expense 33 insurance expense 270.00 Jun 30 1130 Prepaid Insurance insurance expense 270.00 34 Jun 30 1120 Accounts Receivable unbilled revenues 34 19,000.00 Jun 30 4100 Computer & Consulting Funbilled revenues 19,000.00 Jun 30 5100 Insurance Expense building, equipment depreciation 330.51 Jun 30 1412 Accum. Depr.-Building building, equipment depreciation 312.17 Jun 30 1212 Accum. Depr.-Office Equ building, equipment depreciation 18.34 36 Jun 30 5100 Insurance Expense 36 computer equipment depreciation 3,270.34 Jun 30 1312 Accum. Depr.-Computer computer equipment depreciation 3,270.34 37 Jun 30 5020 Salary Expense 37 June 28-30 salaries 621.00 Jun 30 2105 Salaries Payable June 28-30 salaries 621.0037 Jun 30 5020 Salary Expense 37 28-30 salaries Jun 30 2105 Salaries Payable 621.00 June 28-30 salaries 621.00 38 Jun 30 5090 Interest Expense 38 note interest Jun 30 1,063.67 2103 Interest Payable note interest 1,063.67 39 Jun 30 39 4100 Computer & Consulting Fclose revenue accounts Jun 30 3400 Income Summary 36.645.00 close revenue accounts 36,645.00 40 Jun 30 5120 Bad Debt Expense 40 tax expense Jun 30 869.67 2106 Income Taxes Payable tax expense 869.67 41 Jun 30 42 Jun 30 43 Jun 30 44 Jun 30 3400 Income Summary close expense accounts 44 Jun 30 15,955.64 5010 Rent Expense close expense accounts Jun 30 5020 Salary Expense 2,100.00 close expense accounts Jun 30 5030 Advertising Expense 2,171.00 close expense accounts Jun 30 325.00 5040 Repairs & Maint. Expens close expense account Jun 30 5050 Oil & Gas Expense 190.00 close expense accounts Jun 30 5080 Supplies Expense 90.00 close expense accounts Jun 30 5090 Interest Expense 303.00 close expense account Jun 30 5100 Insurance Expense 1.423.86 close expense accounts Jun 30 5110 Depreciation Expense 242.00 close expense accounts Jun 30 5120 Bad Debt Expense 3,814.32 close expense accounts 3,396.46 45 Jun 30 3400 Income Summary 45 close income summary account Jun 30 10,189.36 3200 Retained Earnings close income summary account 10,189.36 Jun 30 3200 Retained Earnings close dividends account 46 Jun 30 3300 Dividends 1,237.68 close dividends account 1,237.68PublicBank Byte of Accounting P.O. Box 5551212, Miami, Florida 33999 123 Speed Lane Ph # (305) 555-1212 Miami, Florida 33999 Previous Balance Account Number 33999999 Deposits/Credits 202, 123.80 Statement Date Checks/Debits 6/30/202x 77,465.00 Ending Balance 124,658.80 124,658.80 Activity in date order Date Description lun 01 Amount Balance Deposit 190,508.80 un 07 Paid check # 5002 190,508.80 27,000.00 Jun 15 Paid check # 5003 163,508.80 20,750.00 un 16 142,758.80 Deposit Jun 21 Paid check # 5005 7,520.00 150,278.80 Jun 22 14,900.00 135 , 378 .8 NSF 2,850.00 Jun 22 NSF service charge 132,528.80 -25.00 132,503.80 Jun 22 Paid check # 5006 Deposit -7,500.00 125,003.80 Jun 23 4,095.00 129,098.80 Jun 24 Paid check # 306 -1,400.00 Jun 26 127,698.80 Paid check # 5007 -560.00 Jun 26 Paid check # 5008 127, 138.80 -700.00 126,438.80 Jun 27 Paid check # 5009 Jun 27 Elec Remit AT&T Telephone 1,035.00 125,403.80 -225.00 125, 178.80 Jun 27 Paid check # 5010 -475.00 Jun 29 Service Charge- Checks 124,703.80 -45.00 Ending Balance 124,658.80 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 Bank Statement Ending Balance per books 121, 465.76 Ending balance per bank 124, 658. 80 Additions Additions 1. Add to Books Total . Add to Bank Total Deductions Deductions Error deposit Jun 16 270.00 3. Deduct from Books 1. Deduct from bank Ending Correct cash balance Ending Correct cash balanceA Byte of Accounting, Inc. Worksheet For Period Ending June 30, 2021 Account Unadjusted Trial Balance Adjusting Entries Adjusted Trial Balance Income Statement Balance Sheet Number Name Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit 1110 Cash 121,465.76 0.00 0.00 0.00 121,465.76 0.00 121,465.76 1120 Accounts Receivable 1,250.00 0.00 19,000.00 .00 20,250.00 0.00 20,250.00 1121 Allowance for Doubtful Accounts 0.00 0.00 .00 0.00 0.00 0.00 1130 Prepaid Insurance 6,480.00 0.00 .00 270.00 6,210.00 0.00 6,210.00 1 140 Prepaid Rent 7,500.00 0.00 0.00 2,500.00 5,000.00 0.00 ,000.00 1 150 Office Supplies ,225.00 0.00 0.00 369.00 856.00 0.00 856.00 Office Equip. 2,040.26 0.00 0.00 0.00 2,040.26 0.00 2,040.26 1212 Accum. Depr.-Office Equip. 0.00 0.00 .0 8.34 .00 8.34 18.34 1311 Computer Equip. 196,220.40 0.00 0.00 0.00 196,220.40 0.00 196,220.40 1312 Accum. Depr.-Computer Equip. 0.00 0.00 .00 3,270.34 0.00 3,270.34 3,270.34 1411 Building Cost 125,000.00 0.00 0.00 0.00 125,000.00 0.00 125,000.00 412 Accum. Depr.-Building 0.00 0.00 ).0 312.17 0.00 312.17 312.17 1510 Land 24,000.00 0.00 0.00 0.00 24,000.00 0.00 24,000.00 2101 Accounts Payable 0.00 4,755.00 .00 .00 0.0 4,755.00 4,755.00 2102 Advanced Payments 0.00 0.00 0.00 0.00 0.00 0.00 2103 Interest Payable 0.00 0.00 .0 1,482.73 .00 1,482.73 1,482.73 2105 Salaries Payable 0.00 0.00 0.00 621.00 0.00 621.00 621.00 2106 Income Taxes Payable 0.00 0.00 0.00 869.67 .0 869.67 869.67 2201 Mortgage Payable 0.00 134, 100.00 0.00 0.00 134, 100.00 134, 100.00 2202 Notes Payable 0.00 87,250.00 .0 0.00 .00 87,250.00 87,250.00 3100 Capital Stock 0.00 252,509.46 0.00 0.00 0.00 252,509.46 252,509.46 3110 Paid-in Capital in Excess of Par Value 0.00 0.00 0.00 0.00 0.001 0.00 3200 Retained Earnings 0.00 0.0 0.00 0.00 0.00 0.00 3300 Dividends 3,713.04 0.00 .00 0.00 3,713.04 0.00 0.00 0.00 .00 0.00 0.00 0.00 4100 Computer & Consulting Revenue 0.00 17,645.00 7,645.00 0.00 .00 0.00 17,645.00 5010 Rent Expense 0.00 0.00 2,500.00 0.00 2,500.00 0.0 2,500.00 5020 Salary Expense 2,070.00 0.00 621.00 0.00 2,691.00 0.00 2,691.00 5030 Advertising Expense 475.00 0.00 .00 0.00 175.00 0.00 475.00 5040 Repairs & Maint. Expense 2,580.00 0.00 0.00 0.00 2,580.00 0.00 2,580.00 5050 Oil & Gas Expense 840.00 0.0 0.00 0.00 840.00 0.0 840.00 5080 Supplies Expense 1,400.00 0.00 369.00 0.00 1,769.00 0.00 1,769.00 5090 Interest Expense 0.00 0.00 1,482.73 0.00 1,482.73 0.00 1,482.73 5100 Insurance Expense 0.00 0.00 3,870.85 0.00 3,870.85 0.00 3,870.85 5110 Depreciation Expense 0.00 0.0 0.00 0.0 0.00 0.00 5120 Bad Debt Expense 0.00 0.00 869.67 0.00 869.67 0.00 869.97 5130 Bank Expense 0.00 0.00 ).0 0.00 0.00 0.00 5140 Telephone Expense 0.00 0.00 0.00 0.00 0.00 0.001 5150 Income Taxes Expense 0.00 0.00 .00 0.00 0.00 0.00 Total 496,259.46 496,259.46 46,358.25 9,713.25 521,833.71 485, 188.71 17,645.00 NET INCOME Balance40. 41. 42. 43. Based on the information on the "Bank Reconciliation" sheet prepare the journal entry required to increases cash. Based on the information on the "Bank Reconciliation" sheet prepare the journal entry required to decreases cash. 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 Close the revenue accountsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started