Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Financial Accounting Expert

1: Comprehend accounting as a language of business

2: Understand the nature of the accounting information systems; record transactions in journals and ledgers; incorporate end of the year adjustments; and prepare financial statements of small and medium scale business organisations.

3: Record business transactions and prepare financial statements using an accounting software (XERO), in small and medium scale business organisations.

Requirements
1. Please monitor CloudDeakin for any instructions/announcements.

2. This assignment is in two parts, a manual set of financial records (Part A) and a set of financial records compiled using Xero software (Part B). Part A must be completed on the individual PROFORMA provided. The PROFORMA is located in the ‘assessment 2 folder'. Part B must be completed using Xero, a computerised accounting package. You are required to create the Xero file.

3. All figures in the manual set of financial records can be recorded to the nearest whole dollar.

4. Any questions related to this assignment must be placed on CloudDeakin. Do not email the unit chair, lecturer or your tutor directly. This ensures all students have access to the same information.

Part A: Manual Preparation of Financial Records

Use the MAA261 Toys n Games Factory Pro Forma Journals and Ledgers file to complete Part A of the assignment. This file contains the journals, ledgers, Adjusted Trial Balance, Statement of Changes in Equity, Statement of Financial Performance and Statement of Financial Position. Note that this file is supplied in "word" format so that you can adjust the columns or add ledgers if you wish to do so.

1. Using the information provided record all transactions for the month of January in the appropriate:

a. General Journal and then

b. The general ledger (note it is optional to complete subsidiary ledgers, however it is recommended as they will assist you)

2. Please acquire a thorough understanding about the recording process before you enter transactions (please refer the relevant lecture and tutorial material and the text book for further information).

3. You are then required to record the end of month balance day adjustments in the general journal and post to the relevant general ledger accounts.

4. Prepare an adjusted trial balance as at 31st January 2017, i.e. after posting all balance day adjustments. If the trial balance does not balance do not proceed until it does.

5. You are required to prepare and closing entries.

6. Prepare an Income Statement for the month ended 31st January 2017, Statement of Changes in Equity for the month ended 31st January 2017, and a Statement of Financial Position as at 31st January 2017.

Part B: Preparation of Financial Records Using Xero

In part B you process the same transactions using Xero. Xero is a cloud-based computerised accounting package. There are detailed video instructions on creating your Xero file and recording transactions in Xero available on CloudDeakin. It is highly recommended that you watch these before undertaking Part B.

Please note: you will have a free 30 day access to Xero. Do not create your Xero file until 11th March 2017.

1. Using your internet browser click on https://www.xero.com/au/teaching-accounting/

2. Complete the required information.

3. Xero will send you an email which allows you to activate your account.

4. Once you log onto Xero, Select Settings, General Setting, Organisation Setting

5. Complete the following information:

Display Name: Toys n Games Factory Your name (For example Toys n Games Factory Elka Johansson)
Legal Trading Name: Toys n Games Factory Your name (For example Toys n Games Factory Elka Johansson)
Line of business: Retail Organisation type: Sole Trader ABN: leave blank
The reminder of the form does not need to be completed for the purposes of the assignment.

6. Return to General Setting, click Chart of Accounts. Xero has suggested a range of accounts for your use. The account names may be slightly different to those in your manual set of accounts. This is okay, you do not need to standardise the names. Additional accounts will need to be added. To add new accounts, Click on new accounts and complete the necessary information.

7. Return to General Settings and select financial settings. Check that the financial yearend is 30 June. The tax defaults for both sales and purchases should read "tax inclusive". Change these details if necessary.

8. Return to general settings.

9. Select Conversion Balances. Click on conversion date and change the month to January (this means you will enter the opening balances based on the 31 December closing balances). Save.

10. Click on Add Comparative Balances (if necessary click on "Show all accounts"). Enter the opening balances by account from the opening Statement of Financial Position in the appropriate debit/credit column. Xero operates with only one GST account - "GST Clearing", a current

liability. Please net the GST Receivable and GST Payable account when entering the opening balances in Xero. Make sure the opening balances debits and credits are equal to each other. Save.

11. A new window will open that requires you to enter the opening balances for individual debtors and then creditors. Enter each debtor, the amount owning and the date of the transaction. Repeat for creditors. There is no need to enter the inventory, just add the total amount.

12. Go to Accounts, Select inventory. Click on Add new item and create each inventory account. Then import opening inventory balances using the wizard available in Xero.

You are now ready to start entering the transaction data into Xero. You should record transactions in date order. This is critically important for any inventory transactions (sales and purchases) as Xero calculates the value of inventory using the moving weighted average method. It is easiest to enter sales, purchases and cash transactions through the dashboard.

Attachment:- Assessment.rar

Financial Accounting, Accounting

  • Category:- Financial Accounting
  • Reference No.:- M92247550

Have any Question?


Related Questions in Financial Accounting

Assessment 1develop complex spreadsheetsthis is an

Assessment 1 Develop Complex Spreadsheets This is an assessment that may be worked on in study time and as homework. Assessment presentation should be completed in a manner that is appropriate to professional business re ...

Accounting for decision makingquestion discuss the five key

Accounting for decision making. Question: Discuss the five key forces to consider when analyzing an industry. How do these forces impact the balanced scorecard? Reply to the discussion which are attached. Discussion: For ...

Accounting financial assignment -question - in recent years

Accounting Financial Assignment - Question - In recent years a number of companies have gone into liquidation (been 'wound up') because they have not been able to meet their liabilities when they fell due. In Australia, ...

The ipl just signed sachin to a contract consisting of

The IPL just signed Sachin to a contract consisting of eight, end-of-year payments worth $9 million each, with the first payment precisely one year from today. On the other hand, Dhoni recent deal calls for six annual pa ...

Comprehensive problem - lou barlow a divisional manager for

Comprehensive Problem - Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division's ...

Consider the following account starting balances and

Consider the following account starting balances and transactions involving these accounts. Use T-accounts to record the starting balances and the offsetting entries for the transactions. The starting balance of Cash is ...

In its first year of operations cullumber company

In its first year of operations, Cullumber Company recognized $31,800 in service revenue, $6,600 of which was on account and still outstanding at year-end. The remaining $25,200 was received in cash from customers. The c ...

Finance final exam -answer the following questions based on

FINANCE Final Exam - Answer the following questions based on the course presentation, text, and any outside relevant sources. Use citations and show your work where applicable. 1. Strategic and Financial Planning a. Defi ...

Budgets and managerial responsibilitythis module explores

Budgets and Managerial Responsibility This module explores budgets and the benefits of creating budgets. In recent years, many organizations faced one of the hardest economic conditions with the recession. Many organizat ...

Assessment -part a -saturn petcare australia and new

Assessment - Part A - Saturn Petcare Australia and New Zealand is Australia's largest manufacturer of pet care products. Saturn have been part of the Australian and New Zealand pet care landscape since opening their firs ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As