So I need help figuring out these pages I've gotten up to the journal ledgers but the unadjusted trial balance never balances out so I'm not sure what I'm doing wrong. I will also include what I have so far, but some of it may need work (i.e.Jul 2 - I'm not sure if it is just equipment and note payable or if I need to include interest payable as well). Overall I really just want to make sure any mistakes are corrected and that the unadjusted trial balances total add up.

Jul 30 Bullet Withdrawals 310 7,200 Cash 101 7,200 Money withdrawn for personal use Page 2 Date Account Title and Explanation PR DR CR 2022 Bank Loan 220 1,000 Jul 31 Interest Expense 520 360 Cash 101 1,360 Paid in cash for a bank loan including principle and interest\fAccount: Accounts Payable GL No: 200 Date Description PR DR CR Balance (DR or CR) 2022 Opening Balance $12,500 CR Jul 5 Travel expense paid later J1 $12,450 $24,950 CR Jul 15 Paid to reduce accounts payable 11 $6,250 $18,700 CR Account: Interest Payable GL No: 205 Date Description PR DR CR Balance (DR or CR) 2022 Opening Balance Account: Salary Payable GL No: 210 Date Description PR DR CR Balance (DR or CR) 2022 Opening Balance $0 CR SO CR Account: Unearned Revenue GL No: 215 Date Description PR DR CR Balance (DR or CR) 2022 Opening Balance $9,000 CR Jul 26 Customers paid for services in advance J1 $24,500 $33,500 CR Account: Bank Loan GL No: 220 Date Description PR DR CR Balance (DR or CR) 2022 Opening Balance $36,000 CR Jul 31 Paid principle of bank loan J1 $1,000 $35,000 CR Jul 31 Account: Note Payable GL No: 225 Date Description PR DR CR Balance (DR or CR) 2022 Opening Balance Note payable for equipment J1 10,000 $10,000 CR Account: Bullet Capital GL No: 300 Date Description PR DR CR Balance (DR or CR) 2022 Opening Balance $13,060 CR Jul 1 Owner invested money and equipment 1 $14,300 $27,360 CR\fAccount: Interest Expense GL No: 520 Date Description PR DR CR Balance (DR or CR) 2022 Jul 31 Paid for interest on bank loan $36 $360 DR Account: Salaries Expense GL No: 545 Date Description PR DR CR Balance (DR or CR) 2022 Jul 23 Paid employee salaries $7,560 $7,560 DR Account: Telephone Expense GL No: 550 Date Description PR DR CR Balance (DR or CR) 2022 Jul 20 Telephone bill received $56 $560 DR Account: Travel Expense GL No: 555 Date Description PR DR CR Balance (DR or CR) 2022 Jul 5 Travel expense to be paid later $12,450 $12,450 DR Account: Rent Expense GL No: 560 Date Description PR DR CR Balance (DR or CR) 2022 Jul 1 Paid for rent for the month $2,100 $2,100 DRLand & Sky Travel and Tours Worksheet July 31, 2022 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Account Titles OR CR DR CR DR CR DR CR DR Cash $60,350 Accounts Receivable 11,180 Prepaid Insurance 7,200 Equipment 37,700 Accumulated Depreciation 6,700 Accounts Payable $18,700 Interest Payable Salary Payable Unearned Revenue 33,500 Bank Loan 35,000 Note Payable 10,000 Bullet Capital 27,360 Bullet Withdrawals 7,200 Service Revenue 38,400 Advertising Expense 3,560 Depreciation Expense Insurance Expense Interest Expense 360 Salaries Expense 7,560 Telephone Expense 560 Travel Expense 12,450 Rent Expense 2,100 Total $150,220 $169,660 Net Income TotalJournal Page 1 Date Account Title and Explanation PR DR CR 2022 Jul 1 Cash 101 8,600 Equipment 120 5,700 Bullet Capital 300 14,300 Owner invested money and equipment into the business Jul 1 Prepaid Insurance 110 7,200 Cash 101 7,200 Prepaid Insurance advance for one year Jul 1 Rent Expense 560 2,100 Cash 101 2,100 Paid for rent for the month of July 2-Ju Cash 101 32,000 Accounts Recievable 105 6,400 Service Revenue 400 38,400 Received $32000 for service rendered, the rest $6400 will be Jul 2 Equipment 120 10,000 Note Payable 220 10,000 To record note payable Jul 5 Travel Expense 555 12,450 Accounts payable 200 12,450 Travel expenses to be paid the next month Jul 15 Accounts payable 200 6,250 Cash 101 6,250 Paid in cash to reduce accounts payable Jul 18 Cash 101 4,780 Accounts receivable 105 4,780 Money received from services provided the previous month Jul 20 Telephone Expense 550 560 Accounts payable 200 560 Telephone bill to be paid next month Jul 23 Salaries Expense 545 7,560 Cash 101 7,560 Paid in cash for employees salaries Jul 26 Cash 101 24,500 Unearned Revenue 215 24,500 Services paid for one month in advance Jul 29 Advertising Expense 500 3,560 Cash 101 3,560 Paid for advertisement with cashCase Accounting Cycle Land & Sky Travel and Tours is a travel agency that offers international and local travel packages. The company is owned and operated by William Bullet. The closing balances at the end of June 2022 and the chart of accounts are shown below. Land & Sky Travel and Tours Balance Sheet As at June 30, 2022 Assets Liabilities Cash $25,700 Accounts Payable $12,500 Accounts Receivable $9,560 Unearned Revenue $9,000 Prepaid Insurance $0 Bank Loan $36,000 Equipment $42,000 Note Payable Accumulated Depreciation $6,700 Total Liabilities $57,500 Bullet Capital $13,060 Total Assets $70,560 Total Liabilities & Owners' Equity $70,560 Account Description Account # Account Description Account # ASSETS REVENUE Cash 101 Service Revenue 400 Accounts Receivable 105 EXPENSES Prepaid Insurance 110 Advertising Expense 500 Equipment 120 Depreciation Expense 510 Accumulated Depreciation 125 Insurance Expense 515 LIABILITIES Interest Expense 520 punts Pa 200 Salaries Ex 545 Interest Payable 205 Telephone Expense 650 Salary Payable 210 Travel Expense 655 Unearned Revenue 215 Rent Expense 560 Bank Loan 220 Note Payable 220 OWNER'S EQUITY Bullet Capital 300 Bullet Withdrawals 310 Income Summary 315 For the month of July 2022, Land & Sky Travel and Tours had the following transactions: Jul 1 William invested $8,600 cash and equipment valued at $5,700 into the business. Jul 1 Prepaid $7,200 for insurance for one year. Jul 1 Paid $2,100 cash for July's rent. Jul 2 Provided travel services to group of travellers; they paid $32,000 now and will pay $6,400 later. Purchase equipment by signing a Note Payable for $10,000, due in 2 years plus accrued Jul 2 interest at 12% Jul 5 Recorded travel expenses for $12,450 to be paid next month. Jul 15 Paid $6,250 cash to reduce the balance of accounts payable. Jul 18 Received $4,780 cash from customers for the travel services provided last month. Jul 20 Received a telephone bill for $560 which will be paid next month Jul 23 Paid $7,560 cash for employee's salaries. Received $24,500 cash in advance from travellers for travel services to be provided next Jul 26 month. Paid $3,560 advertising expense for the promotion of the travel and tours in the month Jul 29 of July.Jul 30 The owner withdrew $7,200 cash for personal use. Jul 31 Paid $1,360 cash for the bank loan which included $1,000 principle and $360 interest. At the end ofJuly, the following adjustment had to be journalized to properly report the balances of the company's accounts: Jul 31 $28,500 of the balance of unearned revenue, still remains unearned. Jul 31 One month of o-reaid insurance worth 5600 has been used. Jul 31 Monthly depreciation on the equipment was 5450. Jul 31 Accrued salary expense of 53,780 for an employee. Jul 31 Accrued interest on the Note Payable amounts to $100. Required: a) Enter the opening balances from the June 2022 balance sheet into the general ledger accounts. b) Prepare the journal entries for the month ofJuly and post them to the appropriate general ledger accounts. c) Create the trial balance in the worksheet, and then complete the remaining section of the worksheet. d) Create the income statement, statement of owner's equity and the classified balance sheet. e] Prepare the journal entries for the adjustments and post them to the appropriate general ledger accounts. f] Prepare the journal entries to close the books for the month ofJuly 2022 {use the income summary account), and post the journal entries to the appropriate general ledger accounts. g) Create the post-closing trial balance