Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The following additional information is available: 1 A physical inventory count held at the close of business on 3 0 June 2 0 2 3
The following additional information is available:
A physical inventory count held at the close of business on June revealed that the cost price of inventory on hand amounted to $
The June salrv of a part time sales representative ammountina to $ was not paid until Julv
Depreciation on shop fittinas for the month of iune to be recognised amounted to $
Supplies on hand at the end of June was $
Required: using Excel program
tableatableRecord the above transactions during the month of June in the appropriate journals for the businessof SydGee using the provided Excel spreadsheet extract If additional spreadsheet or extention isrequired you are supposed to incorporate as required.bRecord adjustment entries in approriate journals.,cPost all joumal entries to the General Ledqer,dPrepare worksheet at June ePrepare unadjusted, adjusted and postclosing Trial Balances,fPrepare income statement for SydGee for the month of June qRecord closing entries at the end of June June hPrepare the statement of financial position Balance Sheet as at June
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started