Exercise for Accounts Payable and Receivable Templates

Moon Co$,$ created some financial transactions in accounts payable and receivable in the year $2023($the period from January to June$)$ as the following:

On $\frac{1}{2}\frac{?}{2023},$ Moon Co sold $1,000$ items valued at $$10$ each in selling invoice number $234$ to Ali Company. Ali's company paid $$2,000$ upfront and agreed to pay the rest of the balance within four months.

On $15/2/2023,$ Moon Co bought a new machine which cost $$150,000$ from Zahid group $($invoice number A$365).$ Therefore, Moon Co$.$ agreed with Zahid Group to pay $$50,000$ now which is the remaid amount within five months of payment $(\%20$ each payment$).$

On $\frac{1}{3}\frac{?}{2023},$ Ali Company paid $$2,000.$

Moon Co paid the first installment to Zahid Group on $15/3/2023.$

On $20/3/2023,$ Moon Co purchased $3500$ items valued at $$6$ each from Savola Group $($invoice number $896).$ The agreement mentioned that Moon Co must pay $\%50$ of the purchase order as soon as the goods are received, while $\%25$ after two months, and the last payments will be three months after the first payment.

On $\frac{1}{4}\frac{?}{2023},$ Ali Company paid $$2,000.$

Moon Co paid the second installment to Zahid Group on $15/4/2023.$

Ali Company paid Moon Co $$2,000$ on $\frac{1}{5}\frac{?}{2023}.$

On $15/5/2023,$ Moon Co paid the third installment to Zahid Group.

On $\frac{1}{6}\frac{?}{2023},$ Ali Company paid the rest of the balance.

On $15/6/2023,$ Moon Co paid the fourth installment to Zahid Group.

On $\frac{18}{6}\frac{?}{2023},$ Moon Co sold the land for $$650,000$ to Aldrees Company in selling invoice number $786.$ Adress Co agreed to pay $$450,000$ now while the rest of the balance after two months.

Requirements:

Create accounts payable and receivable template in Excel sheet.

Record the necessary financial transactions for accounts payable and receivable and find the total due balance of accounts payable and receivable in the end of the period.