journalize in excel format and make adjusting entries

Tom Smith opened Smith's Window Washing Inc. on July 1, 2018. During July, the following transactions were completed. 1) July 1 - Tom Smith purchased 1,000 common stock for $12,000 cash. 2) July 1- Truck was purchased for $6,000, paying $3,000 cash and the balance on a note payable. The note payable is considered long term because it does not mature until December 31, 2019 3) July 3-cleaning supplies were purchased for $1,300 on account. These supplies represent a resource available to the company to help earn revenue. 4) July 5-purchased a one-year insurance policy effective July 1, 2018 for $6,000. 5) July 12- billed customer $2,500 for cleaning services provided 6) July 18 - paid $1,000 cash on amount owed on truck and $800 on amount owed on cleaning supplies 7) July 20 paid $1,200 cash for employee salaries 8) July 22 - collected cash from customers billed on July 12 9) July 25- billed customers $3,000 for cleaning services provided 10) July 28 - paid gas and oil bill for the month on the truck in the amount of $200 11) July 31 - Paid a dividend to Tom Smith in the amount of $900 12) July 31 - Collected $1,200 in advance from a customer for services to be provided in August, 2018 Adjusting entry transactions: 1) Services provided but unbilled and uncollected at July 31 were $1,500 2) Depreciation on equipment for the month was $200. 3) One-twelfth of the insurance expired. 4) An inventory count shows $600 of cleaning supplies on hand at July 31 5) Accrued but unpaid employee salaries were $600