BFA507 – The Accounting Framework
Group Assignment Information Sheet – Semester One 2020
Meg’s Magic Rugs Ltd
https://thumbs.dreamstime.com/b/magic-flying-carpet-2-12800054.jpg
The objective of this assignment is for you to become familiar with the process of
entering transaction data into a manual accounting system, and to test your understanding
of accounting concepts and practice. To undertake this assignment, you need to enter the
transaction data from the Company Information Sheet (below) into the appropriate
journals and ledgers provided, and prepare the requested reports. In addition, you will be
required to complete a journal of your experience as you undertake the assignment
including some conceptual questions.
Working in groups
You are required to work in groups of two on the assignment. You need to register your
assignment group on MyLO and once you do that you will be assigned a group
discussion board and a group submission dropbox will automatically appear on MyLO.
Your completed assignment needs to be uploaded to your group assignment submission
dropbox on MyLO by Friday 22 May at midnight.
Please contact the unit coordinator by Friday 1 May if you have any problems finding a
group or signing up to a group on MyLO. Both group members need to complete ALL
parts of the assignment, so I suggest you work together on Zoom or similar, and share
your screen as you take turns to complete parts of the assignment in the template. Thus,
both group members should have input into all parts of the assignment. If it is drawn to
my attention that a member of a group is not making a reasonable contribution, then that
person will be required to submit an individual assignment and will be subject to the late
penalty.
Marking Scheme
The assignment will be marked out of 40. Part A is worth 30 marks and Part B is worth
10 marks. Part A involves entering transaction data into the manual accounts in groups of
two. Each group should submit only one copy of Part A. Part B involves completing a
journal including some discussion of the transaction data provided, and the financial
reports you have prepared. Each student should submit one reflective journal.
| Part A – Manual Accounting Required: |
(30 Marks) |
In your group, complete the following tasks for the month of June 2019 for Meg’s Magic
Rugs Ltd in the following order:
Step 1.
Read the Company Information Sheet carefully and look through the blank accounts
Step 2.
Review the GST information available on MyLO and work through the practice activity
Step 3.
Enter the transactions into the appropriate journals – you are expected to use the general
and the special journals provided ie: Sales, Purchases, Cash Receipts and Cash Payments
journals. You should put the monthly transactions through the special journals ie: sales
will go into the Sales Journal, Purchases in the Purchases journal and so forth. The
general journal can be used for any transactions that don’t fit naturally into one of the
special journals.
Step 4.
Balance the special journals and post the balances for the month from the journals to the
subsidiary ledgers, and to the general ledger T accounts. Balance the accounts and
prepare a trial balance to check your work. The sum of the debit balance accounts should
equal the sum of the credit balance accounts.
Step 5.
Prepare a bank reconciliation at the end of the month, and enter any necessary journal
entries to record adjustments to the company records. These entries can be entered into
the general journal then posted to the General Ledger accounts.
Step 6.
Complete any other adjusting entries in the general journal then post them to the general
ledger accounts. Ignore GST for all adjusting entries. Balanced the general ledger
accounts again, and prepare a pre-closing trial balance.
Step 7.
Prepare closing entries in the general journal then post them to the general ledger
accounts. Prepare a post-closing trial balance at 30 June 2019.
Step 8.
Reconcile the control account balances with the subsidiary ledgers.
Step 9
Prepare an Income Statement (Statement of Financial Performance) for the year ending
30 June 2019 and a Balance Sheet (Statement of Financial Position) as at 30 June 2019.
Please Note:
Each group should submit one copy of Part A to your group submission box on
MyLO
Please provide a brief narration for all entries entered in the general journal and a
description for entries in all other journals, as this is what you would do in the real
world.
Each transaction should be entered in ONE journal type ONLY. DO NOT enter
transaction in both a special journal and the general journal. Use the general
journal for any entries you think don’t fit neatly into one of the special journals.
GST is included in this assignment to provide you with an opportunity to learn
how GST is accounted for when entering transactions in the accounts. You are
not expected to know everything about GST, just how to account for transactions
with a GST component.
Marks for Part A will be earned or not according to the extent to which you have
the correct final account balances shown in the trial balances, prepared the
required financial reports, and completed all the other tasks as required.
It will not be possible to mark your assignment unless you submit all of the
required reports. You can submit the parts of the assignment as separate files in
Word, Excel or PDF format, but make sure that you check your file(s) before
submission, to ensure the accounts and all required reports are readable. DO NOT
compress your files before uploading.
Please submit the following for Part A:
When you have entered all transaction data, you should prepare and submit the following
reports:
All journals and the full set of general ledger T accounts.
Pre-Closing Trial balances as at 30 June 2019
Post-Closing Trial Balance as at 30 June 2019
Income Statement (Statement of Financial Performance) for the year ended 30 June
2019
Balance Sheet (Statement of Financial Position) as at 30 June 2019
Bank Reconciliation as at as at 30 June 2019
A stock-card to show the movement of inventory in June 2019
Part B – Reflective Journal [Total 10 Marks]
Every student must complete one (1) reflective journal each and submit it to the
individual reflective journal submission box on MyLO
Please complete your reflective journal AS you work through the assignment
(using the template below)
You will get lose marks if you do not consistently complete the journal each time
you work on the assignment
Your journal will be marked based on evidence that you have participated in all
parts of the assignment process through regular journal entries outlining;
o when you met/worked with your team members
o which tasks you worked on
As you work through the assignment comment on the following:
o how you found the experience of using the different journals
o was it useful to complete a trial balance at different points in the process?
o anything you learnt about the business by preparing the accounts
The length of the journal is entirely up to you, but I would expect the journal to be
at least two typed pages
You will receive full marks for completing the journal in your own words over the
time it take you to complete the assignment
You will not be judged on your language in this part of assignment
You must use your own words, if your journal is found to be the same as another
team members you can both be reported for academic misconduct. The purpose
of the journal is for you to reflect on the processes you undertook
I expect you to use your own words. Thus, you probably won’t need to provide
any references. However, if you do use any other resources in preparing your
answer you will need to acknowledge these sources as a reference using the
guidelines set out on the UTAS Library website (available at:
https://www.utas.edu.au/accounting-communication-matters/writing-an-essay-orreport/referencing)
Reflective Journal (one per student)
| Student Name: Student ID: | ||
| Date and duration |
Task undertaken | What you learnt/experienced/discovered |
Company Information Sheet – Meg’s Magic:
Meg’s Magic Ltd is a local retail business that sells rugs. The business was set up
by Meg who registered the company on 1 July 2014 and issued 150 000 shares.
The Financial year for the company ends on 30 June.
Meg’s Magic Ltd use sales, purchases, cash receipts, cash payments journals and
a general journal, along with a general ledger and subsidiary ledgers for debtors
and creditors. The majority of their customers pay in cash but they do offer credit
to a handful of valued customers. Credit sales are on the terms: 3/10, n/30.
Meg’s Magic Ltd rent a local warehouse paying rent of $1 650 each month
(including GST).
The business uses a perpetual inventory system and applies the LIFO inventory
flow assumption. Opening inventory is made up of 75 rugs @ $1 000 each.
The company’s warehouse fittings are being depreciated over 10 years with an
estimated residual value of $6 500. The company has two delivery vans which
are being depreciated over 6 years with an estimated combined residual value of
$8 500.
The loan was taken out on the 31st May and loan payments of $2 000 per month
plus interest will be made monthly with the first payment due on the 1st July 2019.
Interest is to be paid at a rate of 11% per annum. The first month’s interest is to be
calculated on the full value of the loan of $60 000.
Provision for doubtful debts is always adjusted at the end of each month to equal
5% of the value of debtors at that time.
The company account for GST on an accrual basis and reconcile and pay GST
every quarter. All figures are GST inclusive unless otherwise stated, thus you
will need to divide each figure by 11 to identify the GST component.
GST was last paid in April 2019 and was next due to be paid in July 2019 thus
you DO NOT need to reconcile or pay GST at the end of June 2019 for the
quarter. This will be done by the accountant in July.
Gross wages represent the total wages expense. Tax taken from wages needs to be
treated as “Tax Payable” ie: Gross wages = net wages paid + PAYG Tax Payable
Round all amounts to the nearest dollar.
The trial balance of the company at 31 May 2019 was as follows:
Meg’s Magic Ltd
Trial Balance
as at 31 May 2019
| DR | CR | |
| 100 | Cash at bank | 160 550 |
101 Debtors control 14 800
102 Provision for doubtful debts 270
103 Inventory 75 000
104 Warehouse Fittings 80 300
105 Accumulated depreciation – W/H Fittings 14 145
106 Motor Vehicles (Delivery Vans) 62 500
107 Accumulated depreciation –m/vehicles 9 000
200 Creditors control 16 200
250 Accrued Expenses 7 980
260 Loan 60 000
300 Share capital 150 000
310 Retained profits 90 575
400 Sales Revenue 620 540
401 Sales returns 3 900
402 Discount revenue 5 850
500 Cost of goods sold 300 500
501 Depreciation Expense – W/H Fittings 6 765
502 Depreciation Expense – M/V 8 250
503 Discount expense 2 620
504 Electricity expense 11 200
505 Income Tax expense 85 000
506 Interest expense 4 125
507 Motor Vehicle expenses 6 200
508 Rent expense 16 500
509 Sundry expenses 1 650
510 Telephone expense 2 250
511 Wages expense 135 000
600 GST Collected 9 100
610 GST Paid 6 550
| $983 660 | $983 660 | |
| Schedule of Debtors as at 31 May 2019 Rose Ltd Amaze Ltd Just Ltd Waffle Ltd |
Schedule of Creditors as at 31 May 2019 |
2 400 3 200 1 700 7 500 $14 800 |
| Malt Ltd Pump Ltd Pines Ltd Yaze Ltd |
1 300 7 600 1 900 5 400 |
|
| $16 200 |
The following transactions occurred in June 2019:
(All figures are inclusive of GST unless otherwise stated)
June 1 Received a cheque for $2 200 from Rose Ltd (no discount allowed) as part
payment of their account, and deposited it in the bank account [Hint: GST
does not need to be considered when you record this transaction, as GST
received would have been recorded at the time of the original sale]
2 Sold 3 rugs for $6 000 (before discount) to Just Ltd on credit, the
company was also given a trade discount of $500, then the normal credit
terms) [Hint: Sale = $5 000; GST Collected = $500; COGS/Inventory =
$3 000]
4 Purchased 10 rugs on credit from Pines $12 100 (no discount allowed).
5 Paid Yaze $5 200 in full settlement of amount owing, chq no. 252(the
business was given a settlement discount for the difference)
8 Received and deposited payment in full from Waffle Ltd (no discount
allowed)
11 Sold 10 rugs on credit to Waffle for $22 000
12 Paid Pines Ltd $3 495, being part payment of account owing to date, chq
no. 253
12 Paid telephone account of $825, chq no. 254
14 Received a cheque for $5 500 from Waffle Ltd in part payment of their
account (no discount allowed)
14 Banked cash sales of 25 rugs sold for a total of $51 150
14 Withdrew cash from the bank account to pay wages of $3 900(after PAYG
tax, gross wages were $5 900 (wages before tax).
17 Paid $462 for plastic bags and stationery items, chq no.255
18 Sold 2 rugs credit to Amaze Ltd $3 564
23 Paid Malt Ltd $ 1 300, chq no. 256
27 Paid sundry expenses of $250, chq no. 257
28 Wrote off the balance of the account owed by Rose Ltd as a bad debt
28 Deposited Cash from sales of 15 rugs of $30 800
29 Withdrew cash from the bank to pay wages of $4 300, gross wages were
$6 200.
29 Purchased 4 rugs on credit from Pines Ltd of $5 380 (before discount) The
business was allowed a trade discount of $100 and terms of 1/10, n/30
30 Banked cash sales from the sale of 3 rugs for a total of $7 700
30 Amaze Ltd paid their debt in full by cash (no discount allowed).
30 Paid the rent for June, chq 258
Additional information at the end of the month:
Ignore GST for all adjusting entries.
Gross wages owing at the end of the month total $3 500 (no PAYG tax
payable)
Electricity owing for the month of June is $350 (no GST)
Advertising owing for the month was $500 (no GST)
Income tax for the month of June 2019 is estimated to be $8 200 (no GST)
On the last day of the month (30 June) the business traded both of the
delivery vans in for two larger vans worth $120 000 in total(GST free – no
GST). They were given a trade in of $50 000 on the old vans, with the
balance to be paid in 30 days. The new vans depreciation rate and residual
value have not yet been determined
No entries had been made in the accounts to allow for any of these items
The bank statement received at the end of June shows the following information:
Bank Statement
Meg’s Magic Ltd
| Debit | Credit | |
| Balance | ||
| Deposit | 4 800 | |
| Deposit Chq.no. 200 |
2 200 | 3500 |
| Chq.no. 201 | 750 | |
| Chq. no. 252 Deposit Chq. no. 253 Deposit |
5 200 | |
| 7 500 | ||
| 3 495 | ||
| 5 500 | ||
| Deposit Chq. no. 254 |
51 150 | 825 |
| Cash withdrawal | 3 900 | |
| Chq. no. 255 | 462 | |
| Chq. no. 256 Deposit Cash withdrawal |
1 300 | 30 800 |
| 4 300 | ||
| Bank fees/charges Dividend Received |
35 | 1 500 |
At 31 May 2019 there were two outstanding cheques – cheque no. 200 for $3 500 and
cheque no. 201 $750 and an outstanding deposit for $4 800.
General Journal GJ1
| Date | Particulars | Ref | Debit | Credit |
General Journal GJ2
| Date | Particulars | Ref | Debit | Credit |
Purchases Distribution Journal PDJ:
| Date | Tax Inv. No. |
Accounts Payable and/or Particulars | Ref | Inventory | GST Paid | Accounts Payable Total |
| DR | DR | CR |
Sales Distribution Journal SDJ:
| Date | Tax Inv. No. |
Accounts Receivable and/or Particulars |
Ref | Sales | GST Collected |
Other | Accounts Receivable Total |
COGS/ Inventory |
| CR | CR | DR | DR./CR |
Cash Payments Journal CPJ:
| Date | Chq. No. |
Particulars | Ref | Cash at Bank |
Tax Payable |
Discount Revenue |
GST Paid |
Accounts Payable |
Rent Expense |
Wages Expense |
Other |
| CR | CR | CR | DR | DR | DR | DR | DR |
Cash Receipts Journal CRJ:
| Date | Rec. No. |
Particulars | Ref | Cash at Bank | Discount Expense | GST Collected | Accounts Receivable | Sales | COGS/ Inventory |
| DR | DR | CR | CR | CR | DR/CR |
General Ledger ‘T’ Accounts:
Account Name: Cash at Bank – Cheque Account Acct #: 100
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Accounts Receivable – Debtors Control Acct #: 101
| Date | Particulars | Ref | Amoun t |
Date | Particulars | Ref | Amount |
Account Name: Provision for Doubtful Debts 102
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Inventory Acct #: 103
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Warehouse Fittings Acct #: 104
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Acc Depreciation – Warehouse Fittings Acct #: 105
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Motor Vehicles (Delivery Vans) Acct #: 106
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Acc Depreciation – Motor Vehicles Acct #: 107
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Accounts Payable – Creditors Control Acct #: 200
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Accrued Expenses Acct #: 250
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Loan Acct #: 260
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Share Capital Acct #: 300
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Retained Profits Acct #: 310
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: GST Paid Acct #: 610
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: GST Collected Acct #: 600
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Acct #:
Account Name: Acct #:
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Acct #:
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Acct #:
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Acct #:
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Acct #:
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Acct #:
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Acct #:
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Acct #:
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Acct #:
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Acct #:
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Account Name: Acct #:
| Date | Particulars | Ref | Amount | Date | Particulars | Ref | Amount |
Trial Balance as at . . . . . . . . . . . .
| Account Name | Folio | Debit | Credit |
| Totals |
Income Statement for the period ended . . . . . . . . . . . .
| Account Name | $ | $ | $ |
| Totals |
Balance Sheet as at . . . . . . . . . . . .
| Particulars | $ | $ | $ | $ |
Bank Reconciliation as at
| Particulars | $ | $ | $ | $ |
Accounts Receivable (Debtors) Subsidiary Ledger
Account Name: Acct #:
| Date | Description | Ref | Debit | Credit | Balance |
Account Name: Acct #:
| Date | Description | Ref | Debit | Credit | Balance |
Account Name: Acct #:
| Date | Description | Ref | Debit | Credit | Balance |
Accounts Receivable (Debtors) Subsidiary Ledger
Account Name: Acct #:
| Date | Description | Ref | Debit | Credit | Balance |
Account Name: Acct #:
| Date | Description | Ref | Debit | Credit | Balance |
Account Name: Acct #:
| Date | Description | Ref | Debit | Credit | Balance |
Accounts Payable (Creditors) Subsidiary Ledger
Account Name: Acct #:
| Date | Description | Ref | Debit | Credit | Balance |
Account Name: Acct #:
| Date | Description | Ref | Debit | Credit | Balance |
Account Name: Acct #:
| Date | Description | Ref | Debit | Credit | Balance |
Accounts Payable (Creditors) Subsidiary Ledger
Account Name: Acct #:
| Date | Description | Ref | Debit | Credit | Balance |
Account Name: Acct #:
| Date | Description | Ref | Debit | Credit | Balance |
Account Name: Acct #:
| Date | Description | Ref | Debit | Credit | Balance |
Schedule of Debtors Balances
| Debtor Name | Amount $ |
| Total $ |
Schedule of Creditors Balances
| Creditor Name | Amount $ |
| Total $ |
Stock-card:
| Date | Details | Inward | Outward | Balance | Balance $ |
| 31/5/19 | Balance | 75 rugs @ $1 000 each |
75 000 |
The post BFA507 – The Accounting Framework appeared first on My Assignment Online.