I need to use this data to do the entire accounting cycle
At June 30, 2020, the end of its most recent fiscal year, Martinez Computer Consultants post-closing trial balance was as follows: Debit Credit Cash 64.7 10 Accounts receivable 1080 Supplies 420 Accounts payable $380 Uneamed service revenue 1.010 Owner's capital 5.040 56.410 $6.410 The company underwent a major expansion in July. New staff was hired and more financing was obtained. Martinez conducted the following transactions during July 2020, and adjusts its accounts monthly. July 1 |Purchased equipment, paying $3,600 cash and signing a 2-year note payable for $18,000. The equipment has a 4-year useful life. The note has a 6%% interest rate which is payable on the first day of each following month Owner invested $45,000 cash in the company. 3 Paid $3.000 cash for a 12-month insurance policy effective July 1. 3 Paid the first 2 (July and August 2020) months' rent for an annual lease of office space for $3.600 per month. Paid $3.400 for supplies. 9 Visited client offices and agreed on the terms of a consulting project. Martinez will bill the client, Connor Productions, on the 20th of each month for services performed. 10 Collected $1,080 cash on account from Milani Brothers. This client was billed in June when Martinez performed the service. 13 Performed services for Fitzgerald Enterprises. This client paid $1.010 in advance last month. All services relating to this payment are now completed. 14 Paid $360 cash for a utility bill. This related to June utilities that were accrued at the end of June 16 Met with a new client, Thunder Bay Technologies, Received $10,800 cash in advance for future services to be performed. 18 Paid semi-monthly salaries for $9.900. 20 Performed services worth $25.200 on account and billed customers 20 Received a bill for $2.000 for advertising services received during July. The amount is not due until August 15. 23 Performed the first phase of the project for Thunder Bay Technologies. Recognized $9,000 of revenue from the cash advance received July 16. 27 Received $13.500 cash from customers billed on July 20 Adjustment data: Adjustment of prepaid insurance Adjustment of prepaid rent. 3. Supplies used. $1.150. 4. Equipment depreciation. $450 per month Accrual of interest on note payable. Salaries for the second half of July, $9,900, to be paid on August 1. 7. Estimated utilities expense for July, $720 [invoice will be received in August). B. Income tax for July, $1,080, will be paid in August