ACCT 1100 Comprehensive Problem #1

On June 1, 2017, Carl Kluber started his CPA firm, Carl Kluber, CPA Inc. The firm is a service company, but also sells proprietary tax software, along with hardware, that has been very successful and is used by many CPAs. The following transactions occurred during the company's first month. Carl Kluber, CPA Inc. uses a perpetual inventory system.

It is a long problem with many parts that I have to put into an excel document. Any help would be greatly appreciated.