In this assessment task, you will be required to complete the Bean's Coffee's Business Activity Statement (BAS) ready for Mr Beans' to sign and lodge. You will be provided with a separate Excel data file (FNSTBP401A_DataFile) with the relevant information; and beginning and end of quarter trial balances. This task has two parts. Read the following instructions and completed the tasks as required. Part a: As a Company Specific organisational requirements need you to (in order of); a) Calculate and prepare end of the quarter cash position of the company b) Discuss and confirm the trial balance data with your manger (trainer/assessor role play) to ensure that company has the required cash flow to pay its BAS instalment c) You will see that the Trial Balance as at 30 June 2012 is not balanced. Find and fix the errors and show the corrected copy to your manager (trainer/assessor role play) for approval before proceeding d) Save your data file as a new version on your USB or a designated location Complete general journal f) Post final entries to the general ledger Prepare an Income (Profit & Loss) Statement in the given data sheet h) Complete the GST summary reports (accrual) and expected payment/refund i) Download and complete BAS Calculation Worksheet from ATO website (www.ato.gov.au) Download and complete a sample BAS from ATO website k) Verify the data between GST summary reports created in Excel (data file) and the BAS Calculation Worksheet Reconcile the BAS form to journal entries, profit and loss statement, and GST summary m) Correct errors, if any and make note of the corrections n) In the data file, complete the lodgement schedule and process according to ATO requirements ) Submit the final BAS with accompanying worksheet for signature to your manager (trainer/assessor role play)