Please Create A Excel Table

Ali Co. uses a sales journal, purchases journal, cash receipts journal, cash payments journal, and journal. Prepare a cash receipts journal like the one in Exhibit 7.7. Journalize the following transactions that should be recorded in the cash receipts journal. general The company purchased $3,200 of merchandise on credit from Hart Co., terms n/20. 7 Nov. 3 The company sold merchandise costing $840 to J. Than for $1,000 on credit, subject to a $20 sales discount if paid by the end of the month. The company borrowed $3,750 cash by signing a note payable to the bank. 13 J. Ali, the owner, contributed $5,000 cash to the company The company sold merchandise costing $250 to B. Cox for $330 cash. The company paid Hart Co. $3,200 cash for the merchandise purchased on November 3. The company received $980 cash from J. Than in payment of the November 7 purchase. The company paid salaries of $1,650 in cash. 18 22 27 30

Chapter 7 Homework Accounting Information System Ali Co. uses a sales joumal, a purchases johumal, a cash receipts joumal, a cash payments joumal, and a general joumal. The following transactions occur in the month of November: Nov 3 Purchased $4,300 of merchandise on credit from Hart Co, terms n/20. Nov 7 The company sold merchandise costing $840 to J. Than for $1,100 on credit, subject to a $22 sales discount if paid by the end of the month. Nov 9 The company borrowed $4,000 cash by signing a note payable to the bank. Nov 13 J. Ali, the owner, contributed \$2,000 cash to the company. Nov 18 The company sold merchandise costing $300 to B. Cox for $450 cash. Nov 22 The company paid Hart Co. $4,300 for the merchandise purchased on November 3. Nov 27 The company received $1,078 from J. Than in payment of the November 7 purchase. Nov 30 The company paid salaries of $1,550 in cash. Joumalize the November transactions that should be recorded in the cash receipts journal assuming the perpetual inventory system is used. FINT: Your excel iournal should be setcup as follows: \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & & & Cash R & ipts Journal & & & \\ \hline Date & \begin{tabular}{l} Account \\ credited \end{tabular} & Cash Dr. & \begin{tabular}{l} Sales \\ Disc. Dr. \end{tabular} & \begin{tabular}{l} Accounts \\ Receiv. Cr. \end{tabular} & Sales Cr. & \begin{tabular}{c} Other \\ Accounts \end{tabular} & \begin{tabular}{l} Cof GS Dr. \\ Inventory Cr. \end{tabular} \\ \hline \end{tabular}