On $1$ June $2023,$ SydGee began trading as a landscape retail material supplier. The transactions for the month of June $2023$ were asfollows $($ignore GST$)$:TRANSACTIONS FOR THE PERIODMONTH DATE PARTICULARSJune$10$a$11$b$\mathrm{.}12$df$.$hSydGee transferred $$260\mathrm{.}000$ frPurchased shop fittings for cash: paid cheque no$.431,$ $$160,000.$ Paid June rent by cheque no$,432,$ $$7\mathrm{.}000.$ased goods for resale on creditPuroCash sales of Ladscape materials for S$6880($all cash are banked$).$Sold goods on credit to H Ltd: invoice no $653.$ $$3040.$Purchased good for resale from G Ltd: paid by EFT, $$6,800$Cash sales totalling $$3,280$Purchase office supplies for cash$2630$Purchased goods for resale on credit from B Ltd$,$ $$9.\mathrm{.}600$k: Invoice no$.544,$ $$3,920$Purchased office stationery from Bo Ltd: paid by EFT, $$960$Sold oo$0$dS oBanked cheque for return of defective goods that had been purchased for cash, $$760$Cash sale totalling $$7,20014$ Issued 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\mathrm{.}000$early retirement savings to his business bank account$18$ Paid frieght on goods purchased to T Ltd: paid by EFT,. $$52019$ Sold goods on credit to Charles: invoice no $545$; $$4\mathrm{.}2406022$ Internet bank transfer to A Itd 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\%$discount$\mathrm{.}24$ Intenet transfer to Sydaee owner's personal account for drawings. $$8,800$The following additional information is available:Paid June salaries by interbank transfers totalling $$9,680$Paid June electricity bill: Cheque number $435,$ $$60030$Paid June telephone by EFT, $$4483$ Depreciation on shop fittings for the month of june to be recognised amounted to $$1,333$Sunolies on hand at the end of $30$ June $2023$ was $$4\mathrm{.}00030$ Cash sales totalling $$21,200$Required: $($using Excel program$)$Record the above transactions during the month of June $2023$ in the appropriate journals for the business ofSydGee using the provided Excel spreadsheet $($extract$).$ If additional spreadsheet or extention is requiredMOL aro sunnnsed to incarnorate as reauirodRecord adjustment entries in approriate journals.Post all iournal entries to the General LedaerPrepare worksheet at $30$ June $2023$Prepare unadiusted, adiusted 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$)$$ $260,000$Prepare the statement of financial position $($Balance Sheet$)$ as at $30$ June $2023$$$$160000$$$7\mathrm{.}00030,0006,8803,0406,8003\mathrm{.}280$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,000\mathrm{.}2$ The June salry of a part time sales representative ammounting to $$1,600$ was not paid until $2$ July $2023\mathrm{.}5,0009\mathrm{.}6003\mathrm{.}9209607607\mathrm{.}2001\mathrm{.}4401\mathrm{.}36024\mathrm{.}000520,2406\mathrm{.}360$$ $8\mathrm{.}8009\mathrm{.}68060021\mathrm{.}2/$dit from A Itd, $$30\mathrm{.}00021$cash. $.$make excel sheet for general journal,adjus adjustment journal $,$ chart of account, general ledger, worksheet, trial balances, income statement, closing enteries, balance sheet.