Question

Task 1.3 - Prepare a depreciation schedule for 30/6/2019 Using the information that you prepared in your assets registers please compie depreciation schedule for the year ended 30/6/2019, located in the excel file u depreciation Sch tab ted in the excel file under the When you have finished, save the file. Part 2 - Preparation of final accounts For Part 2 of this case study you are provided with the following excel spreadsheet file BSBFIA401 Part 2 Final Accounts You are required to complete a series of tasks to produce the final BSBFIA401 part 2 final accounts excel file. Use the appropriate templates. This excel file will be emailed to you through your student email account. The following Trial Balance was extracted from the records of Micro Systems, for the year ended 30th June 2019. Required Task 2.1 - Prepare the General Ledgers by entering the opening balances from the Trial Balance provided on the next page Task 2.2 - Prepare General Journal entries to record the balance day adjustments as at 30th June 2019 and post to the General Ledger, Task 2.3 - Prepare General Journal entries to close the relevant ledgers on 30th June 2019 and post to the General Ledger. Task 2.4 - Prepare a post-closing Trial Balance as at 30th June 2019

task 2.1. prepare the general ledger by enetring the opening balanc from trial balane

Answer 1

prepare the general ledger by entering the opening balance from the trial balance.

Accumulated Depreciation-Equipment				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance		$2,160		$2,160
Accumulated Depreciation-Motor vehicle				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance		$7,000		$7,000
Advertising				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance	$3,000		$3,000
Allowance for doubtful debts				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance		$100		$100
Sales				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance		$130,695		$130,695
Capital-John Franklin				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance		$31,600		$31,600
Cash at bank				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance	$8,400		$8,400
Accounts payable				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance		$4,500		$4,500
Accounts receivable				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance	$9,000		$9,000
Drawings-John Franklin				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance	$5,400		$5,400
Equipment at cost				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance	$32,200		$32,200
GST Collected				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance		$3,560		$3,560
GST paid				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance	$2,165		$2,165
Residential rent received				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance		$11,500		$11,500
Loan to Martha stewart				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance	$10,000		$10,000
Motor vehicle-at cost				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance	$22,000		$22,000
Provision for Annual Leave				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance		$500		$500
Purchases of inventory				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance	$54,000		$54,000
Insurance				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance	$2,600		$2,600
repair and maintenace cost				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance	$1,450		$1,450
Stock of inventory				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance	$5,000		$5,000
Office expense				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance	$6,400		$6,400
Wages				Balance
Date	Item	Debit	Credit	Dr	Cr
	Beg. Balance	$30,000		$30,000