Prepare

Trial Balances in excel sheet $?$

On 1 June 2023, SydGee began trading as a landscape retall material supplier. Tho transactions for tho month of June 2023 were as follows (ignore TRANSACTIONS FOR THE PERIOD MONTH DATE PARTICULARS June 1 dGee transferred Purchased s fitti 000 from his earl retirement savi to his business bank account for cash: dc ueno.431 160 000. Paid June rent 2 Purchased for resale on credit from Altd 30000 3 Cash sales of LHSca materials for all cash are banked . 4 Sold on credit to H Ltd: invoice m 653 5 Purchased for resalefromGLtd. d EFT 800 6 Cash sales totalli 280 7 Purchase offcesu - ies for cash 8 Purchased for resale on credit from B 9 Sold on credit to Mok: Invoice no. 544 9 600 920 10 Purchased offce stati from Bo Ltd: 11 Banked c LB for return of defective 12 Cash sale totalli d EFT 960 that had been rchased for cash 14 Issued C number 433 for Micellaneous ex 1 440 ro for c no. 60 1 360 16 customer for a cash sale returned: idrefund c 17 Purchased for resale on credit from C Ltd 4000 18 Paid fri hton rchased to T Ltd: d EFT on credit to Charles: invoice no 545 240 19 Sold 21 Cash sales 360 22 Internet bank transfer to A ltd in full setlement of 2nd June transaction less a cash discount 3%. AMOUNT 260 ooo $160000 30 ooo 6 880 3040 6 800 3 5 ooo 9600 3920 7 1 440 1 360 24 ooo s 4 40 6360 23 Banked c receivedfrom H Ltd 4th unetransaction in full settlement of its less a 2% discount 24 Internet transfer to auner's account for drawi 26 Paid June salaries interbank transfers totalli 680 30 Paid June electrici bill: C uenumber 435 30 Paid June tel 30 Cash sales totalli The followin additional information Is available: s 8 800 9680 21 omo 1 A physical inventory count held at close of business on 30 June 2023 revealed that the cost price of inventory on hand amounted to $24,000. 2 TtE June salry of a part time sales representative ammounting to $1,600 was paid until 2 July 2023. 3 Depreciation on shop fittings for month of june to be amounted to $1 ,333 4 Su ies on hand at the end of 30 June 2023 was 000. R ulred: usin Excel ro ram Record the above transactions during the month of June 2023 in the appropriate journals for the business of SydGee using the provided Excel spreadsheet (extract). If additional spreadsheet or extention is required you are supposed to incorporate as r uired. a Record ad'ustment entries ina roriate ournals. c. Post all ournal entries to the General Pre e worksheet at 30 June 2023