FINANCIAL ACCOUNTING
shahew
Archive.zipassignment_pdf_25_MAA261_218130344_ABHISHEKA_GUNAWARDENA_MUDALIGE.doc
Assessment Task
Financial Accounting
Trimester: T1 2018
Company Name: Abcde Pty Ltd
The company began operations as a retailer on 1 July in the current financial year. It buys and sells one inventory item, derrings, from a leased warehouse in the outer suburbs of Melbourne.
The company is registered for GST, which it pays quarterly. Assume GST was last paid on 30 June.
It uses the Moving Weighted Average method and the perpetual inventory recording method.
The company uses the straight line depreciation method for office furniture and computers and the reducing balance method for motor vehicles.
The company employs two people who are rostered over a seven day working week. The employees are paid fortnightly up to and including the day of payment. There are no penalty wages.
The company has one debtor (Debtor1) and one creditor (Creditor1). Terms for all credit sales and purchases are 30 days.
Relevant information
1. The company has the following opening balances as at the 1st of July in the current financial year:
Cash at Bank: $24,075.00
Accounts receivable: $3,504.00
Allowance for doubtful debt: $326.00
Inventory: $11,220.00
Motor vehicle: $22,653.00
Accumulated depreciation motor vehicle: $2,247.00
Accounts payable: $4,094.00
Bank loan owing (due in 20 months): $11,243.00
Telephone payable: $165.00
Office furniture: $11,330.00
Accumulated depreciation office furniture: $1,372.00
Office supplies: $549.00
Share capital: $32,734.00
Retained earnings: balance amount $21,150.00
2. Transactions for the month (all dollar amounts include GST where applicable):
2 July Sales on credit 78 units
© 1
05 July Sales on credit 74 units
11 July Sales on credit 67 units
18 July Sales on credit 79 units
22 July Sales on credit 66 units
29 July Sales on credit 71 units
06 July Customer returned 1 unit(s) in excellent condition for a full refund from the sale on 05 July
15 July Paid wages (ignore PAYG tax) $1,853.00
29 July Paid wages (ignore PAYG tax) $2,068.00
19 July Paid rent for the current month $2,727.00
25 July Paid insurance $2,660.00
17 July Received advertising invoice (due in 30 days) $500.00
02 July Purchased computer on credit $2,432.00
07 July Purchased inventory on credit 20 units at the cost per unit of $25.00
14 July Purchased inventory on credit 29 units at the cost per unit of $27.00
20 July Purchased inventory on credit 26 units at the cost per unit of $24.00
24 July Purchased inventory on credit 23 units at the cost per unit of $25.00
30 July Purchased inventory on credit 29 units at the cost per unit of $28.00
25 July Abcde returned 1 unit(s) to their supplier for a full refund from the purchase on 24 July
01 July Received payment from accounts receivable $807.00
27 July Received payment from accounts receivable $678.00
30 July Received payment from accounts receivable $713.00
18 July Purchased office supplies on credit $512.00
21 July Paid motor vehicle expenses $100.00
04 July Paid accounts payable $1,359.00
14 July Paid accounts payable $1,432.00
25 July Paid accounts payable $1,446.00
23 July Paid outstanding telephone bill in full
3. Additional information:
Selling Price per unit (GST inclusive) $55.00
Insurance commences from the first of the month in which it is paid, and covers 9 months in total.
All asset purchases and expenses except wages include GST.
Cost of opening inventory items per unit $20.00
Depreciation rate for the motor vehicle is 20%
Residual value of the motor vehicle: $2,527.00
Depreciation rate for the office furniture is 20%
Residual value of the office furniture: $636.00
Regardless of purchase date, company policy is to depreciate new assets for 15 days in the month of purchase. Depreciation rate for the computer is 35%
No residual value is expected for computers.
The company counted inventory at the end of the month. They discovered that 8 units were missing and these must be removed from inventory.
Office supplies on hand at end of the month were $267.00
© 2
At the end of the month the company records potential bad debts expense using the percentage of sales method. The business uses 1% of net sales to determine estimated bad debts.
Interest owing on the bank loan at the end of the month is $60.00
© 3
__MACOSX/._assignment_pdf_25_MAA261_218130344_ABHISHEKA_GUNAWARDENA_MUDALIGE.doc
Xero | Dashboard | Abcde Pty Ltd.webarchive
__MACOSX/._Xero | Dashboard | Abcde Pty Ltd.webarchive
MAA261 T1 2018 Individual Assignment.doc
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 there is 30 days until the due date.
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: ABCDE PTY LTD Your name (For example ABCDE PTY LTD Tracey McDowall)
Legal Trading Name: ABCDE PTY LTD Your name (For example ABCDE PTY LTD Tracey McDowall)
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 year-end is
30 June 2018. 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 July (this means you will enter the opening balances based on the 30 June 2017 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. There is no opening balance in the GST clearing account. Make sure the opening balances debits and credits are equal to each other. Save.
A new window will open that requires you to enter the opening balances for individual debtors and then creditors. ABCDE has only one debtor and one creditor. When you setup the debtor and the creditor, assume the date of the invoice was 1 June 2017.
11. 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.
What to submit for Part A and Part B
For Part A the following documents (in word and PDF form) must be submitted:
· Proforma with your completed solution (in word format)
· A copy of your unique assignment (PDF)
For Part B the following documents (in PDF form) must be submitted:
· Trial Balance for July 2017
· Financial Performance (Profit and Loss) for July 2017
· Financial Position (Balance Sheet) for July 2017
Instructions to find and print reports:
1. Go to Settings
2. Select User
3. Click on your name
4. Select “Advisor”
5. Save
6. Select Reports: all reports: Trial Balance for July 2017
Financial Position (Balance Sheet) July 2017 Financial Performance (Profit and Loss) 2017
