can I please get some help with this template? I don't know how to do this! this is due at 12:00 clock tonight.

P5-1A Journalize purchase and sales transactions under a perpetual inventory system Powell's Book Warehouse distributes hardcover books to retail stores and extend credit terms of 2/10, n/30 to al At the end of May, Powell's inventory consisted of books purchased for $1,800. During June, the following merch occurred. June 1 3 6 9 15 17 20 24 26 28 30 Purchased books on account for $1,600 from Kline Publishers, FOB destination, terms 2/10, n/30. The appropriate party also made a cash payment of $50 for the freight on this date. Sold books on account to Reading Rainbow for $2,500. The cost of the books sold was $1,440. Received $100 credit for books returned to Kline Publishers. Paid Kline Publishers in full, less discount. Received payment in full from Reading Rainbow. Sold books on account to Blanco Books for $1,800. The cost of the books sold was $1,080. Purchased books on account for $1,500 from Dietz Publishers, FOB destination, terms 2/15,n/30. The appropriate party also made a cash payment of $50 for the freight on this date. Received payment in full from Blanco Books. Paid Dietz Publishers in full less discount. Sold books on account to Reddy Bookstore for $1,400. The cost of the books sold was $850. Granted Reddy Bookstore $120 credit for books returned costing $72. Powell's Book Warehouse's chart of accounts includes the following: No.101 Cash, No.112, Accounts Receivable No.120 Inventory, No. 201 Accounts Payable, No. 401 Sales Revenue, No.412 Sales Returns and Allowances, N Sales Discounts, and No. 595 Cost of Goods Sold. Instructions Journalize the transactions for the month of June for Powell's Book Warehouse using a perpetual inventory syste NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?" June 1 3 Account Account Value Account Account Value Value Value ` 3 6 9 15 Account Account Value Account Account Value Account Account Account Value Account Value Value Value Value Value Account 17 17 20 24 26 28 28 30 ' 30 Value Account Account Value Account Account Value Account Account Value Account Account Account Value Value Account Account Account Value Account Account Value Account Account Value Account Account Value Account Account Value Value Value Value Value Value Value Value Value Value Value credit terms of 2/10, n/30 to all of its customers. uring June, the following merchandising transactions stination, terms 2/10, n/30. on this date. books sold was $1,440. ks sold was $1,080. stination, terms 2/15,n/30. on this date. books sold was $850. No.112, Accounts Receivable, es Returns and Allowances, No. 414 ng a perpetual inventory system. a formula in cells with a "?"