On $1$ June $2023,$ SydGee began trading as a landscape retail material supplier. The transactions for the month of June $2023$ were as follows$($ignore GST$)$:TRANSACTIONS FOR THE PERIODMONTH DATE PARTICULARSJune$1|$SydGee transferred $$260,000$ from his early retirement savings to his business bank account$1$Purchased shop fittings for cash: paid cheque no$.431,$ $$160,000.$ Paid June rent by cheque no$.432,$ $$7,0002|$Purchased goods for resale on credit from A lItd, $$30,000$b$3$Cash sales of Ladscape materials for S$6880($all cash are banked$).$C$4|$Sold goods on credit to H Ltd: invoice no $653,$ $$3040.$le$5|$Purchased good for resale from G Ltd: paid by EFT, $$6,8006|$Cash sales totalling $$3,280$f$7|$Purchase office supplies for cashh$\mathrm{.}8|$Purchased goods for resale on credit from B Ltd$,$ $$9,6009|$sold goods on credit to Mok: Invoice no$.544,$ $$3,92010|$Purchased office stationery from Bo Ltd: paid by EFT, $$96011$ Banked cheque for return of defective goods that had been purchased for cash, $$76012$Cash sale totalling $$7,20014||$ssued Cheque number $433$ for Micellaneous expenses, $$1,44016|$ Refunded a customer for a cash sale returned: paid refund by cheque no $434$ for $$1,36017$Purchased goods for resale on credit from C Ltd$,$ $$24,00018|$Paid frieght on goods purchased to T Ltd: paid by EFT, $$52019|$Sold goods on credit to Charles: invoice no $545$; $$4,24021$ Cash sales $$6,36022$Internet bank transfer to A ltd in full setlement of $2$nd June transaction, less a cash discount of $3\%.$Banked checque received from H Ltd $(4$th june transaction$)$ in full settlement of its account, less a $2\%23|$discount$.$The following additional information is available:$24|$Internet transfer to Sydgee owner's personal account for drawings, $$8,80026|$Paid June salaries by interbank transfers totalling $$9,68030|$ Paid June electricity bill: Cheque number $435,$ $$6002$ The June salry of a part time sales representative ammounting to $$1,600$ was not paid until $2$ July $2023\mathrm{.}30|$Paid June telephone by EFT, $$4483$ Depreciation on shop fittings for the month of june to be recognised amounted to $$1,33330$Cash sales totaling $$21,2004$ Supplies on hand at the end of $30$ June $2023$ was $$4,000.$Required: $($using Excel program$)$Record the above transactions during the month of June $2023$ in the appropriate journals for the businessRecord adjustment entries in approriate journals.Post all journal entries to the General LedgerPrepare worksheet at $30$ June $2023$Prepare unadjusted, adjusted and post$-$closing Trial BalancesPrepare income statement for SydGee for the month of $30$ June $2023.$Record closing entries at the end of $30$ June June $2023.$AMOUNT $($S$)$S $260,000$Prepare the statement of financial position $($Balance Sheet$)$ as at $30$ June $2023.$$$160000$$$7,00030,0006,8803,0406,8001$A physical inventory count held at the close of business on $30$June $2023$ revealed that the cost price of inventory on hand amounted to $$24,$p$00\mathrm{.}3,2805,0009,6003,9209607607,2001\mathrm{.}4401,36024,0005204,240|6,3608,8009,680600448|21,20*$