Task (a) For this task you will need to design and develop the spreadsheet with the following: Main Heading - General Journal of Bell Floral Designs REF: GJ1 Create a table with the following columns headings: Date, Particulars, Folio, Debit , Credit Once you have created the spreadsheet prepare the General Journal entry for the commencement of business based on the following information. Ashleigh commenced the business on 1 August with the following assets: Cash at Bank $5,000 Inventory $5,000 Furniture and fittings $5,000 Equipment $3,000 $18,000 cash invested by Ashleigh On 31 August, Ashleigh withdrew $500 for personal use. Prepare the General Journal entry to record this transaction. This task must be completed within one week to meet the deadline set by Ashley (refer case study) Task (b) For this activity you will need to d esign and develop the spreadsheet which will have two tables in the one sheet, using the following information. Make sure you use the same work book and label the sheet Task (b): Main Heading - Purchases Journal of Bell Floral Designs REF: PJ1 Create a table with the following columns: Date, Inv no., Particulars, Folio, Purchases, GST paid, Accounts payable Main Heading - Purchase Returns Journal of Bell Floral Designs REF: PR1 Create a table with the following columns: Date, Credit note no., Particulars, Folio, Purchase returns, GST paid, Accounts payable Apply the sum formulas to calculate the totals of each column in both tables. (Your assessor will check this when you have submitted your workbook) Once you have created the spreadsheet you need to prepare the Purchase Journal & purchase returns journal entries for the commencement of business using the following information.
top of page
bottom of page