This case study is designed to introduce you to using double entry computer accounting software for a small business. It covers many of the common transactions of everyday business, including GST. It is not meant to be a data entry exercise, but you are required to carefully record each transaction, understand how the software records these transactions in both the general and subsidiary ledgers and create reports.
The Athlete’s Store
The Athlete’s Store is a sports store located within the grounds of the Bundoora Sports & Aquatic Centre. The centre boasts an 8 lane Olympic size lap pool, an international standards athletic track as well as 6 Plexicushion tennis courts (official surface of the Australian Open). The centre also encompasses a gym, physiotherapy consultation rooms as well as a café.
The Athlete’s Store specialises in sales of elite sporting gear such as track footwear, swimwear, and tennis equipment. These items are sold to the general public as well as in bulk to sporting clubs and schools. The business also offers elite fitness training by their qualified personal training instructor, Stefan.
The store is owned by Jack Massi who has been operating the store for 3 years. He invested $50,000 of his own money into the business when he started operating. He is the General Manager of the store and also it’s only shareholder.
Jack’s customers are those who use the facilities or participate in the fitness classes regularly and as such know him quite well. He also sells stock in larger quantities to sports clubs and elite private schools who have the resources to purchase the products on behalf of their student sports teams.
Jack’s business also provides fitness training classes which are conducted within the sports complex. The classes run three times per week; Tuesday night is an athletic track class, Thursday night is an aqua fitness class and Saturday morning is a cardio tennis class. This structure is very popular with customers as it keeps their exercise routine interesting and varied as opposed to repetitive and uninspiring. For use of the facilities to run these classes three times per week the business is charged a small hire fee by centre management on a monthly basis.
Jack has operated the business using a manual accounting system since 2013. This year you were hired as his accountant and you discovered that Jack was writing everything down in books using a pencil and a ruler. He had kept a good record of everything but the process is tedious and outdated. Jack is hesitant to move to a computerised accounting system as he argues that if he has to learn the new system it will not save him time. You argue back and forth until you convince him that it will cost him less in accounting fees in the long run because once set up it will be faster to produce reports. He finally agrees and allows you to gather what you need to start the MYOB process.
You gather the following information that will help you set up the company in MYOB:
Company name: The Athlete’s Store
ABN: 97 968 969 969
Address: 31a Plenty Road, Bundoora VIC 3083
Phone: 9444 4444
Current Financial Year: 2018
Financial Reporting period: 1 July 2017 to 30 June 2018
Conversion Month: October
Accounting Periods: Twelve
This information is necessary to create the company file in MYOB
Trial Balance as at September 30th, 2017
This list below can be used to create an accounts list with the account opening balances.
|General Ledger Accounts||YTD Debit||YTD Credit|
|Office Equipment – Accumulated Depreciation||480|
|Loan AXZ Bank||30,000|
|PAYG Withholding Payable||1,860|
|Legal & Accounting Fees||300|
|Electricity & Gas||330|
|Wages & Salaries||6,360|
|Income Tax Expense||0|
Goods and Services Tax: Sales and Purchases
Jack charges GST on all sales and is charged 10% GST on all purchases of inventory. For all business expenses other than bank charges, wages and superannuation, Jack pays GST of 10%.
Customer account balances as at 30 September 2017
|Name||Address||Date Last Invoice||Account Balance|
|Dolphins Swimming Club||5 Maloney Drive, Mernda
ABN: 23 234 543 654
|September 2nd , 2017||$1,900|
|Bundoora East Primary School||9 Power Street,
Bundoora East, VIC 3083
A.B.N 34 588 868 565
|September 9th, 2017||$2,200|
|Bundoora West Primary School||29 Edwards Street,
Bundoora West, VIC 3083
A.B.N 85 959 093 282
|August 12th, 2017||$1,800|
|623 Thompsons Rd
ABN: 34 567 765 876
|September 15th, 2017||$4,580|
|Plenty Park Little Athletics||43 Blossom Drive
ABN: 87 987 987 543
|September 24th, 2017||$3,400|
These are the customers that bought inventory from Jack on credit and are still owing as at 30th September 2017. To receive payment for these customers that are billed on account you need to use the Receive Payments window.
All in-store sales are either EFTPOS, Credit Card or Cash. As there is an express AXZ Bank facility located next door to the store the cash can be banked everyday via the bank’s express deposit facility which can be operated 24 hours per day, 7 days per week. This policy of banking all takings each day is implemented for security reasons so as no money is left in the store overnight. This means that all income received from in-store sales can be entered into MYOB’s bank account immediately after each transaction. Therefore, use Enter Sales window for store sales and receive the payment in the Paid Today field at the bottom of the sale screen.
Fitness Training Price List: as at 30 September 2017
|Session||Price charged per hour inc GST||Session running time|
|Track Training||$33||1 hour|
|Swim Training||$33||1 hour|
|Cardio Tennis||$33||1 hour|
Ensure that these items are set up as inventory items that are only sold (link account to Service Sales) not purchased or inventoried.
The above prices include GST. All training revenue is strictly cash based, where customers pay before the service is performed. These training sessions are usually paid for immediately before the class however some clients pay for all three classes for the week on the day of the first class as they believe it will encourage them to show up to all three sessions.
The Fitness Training income is entered into the Enter Sales window using created customer card
Fitness Training Customers. You will also need to create inventory items called ‘Track Training’, ‘Swim Training’ and ‘Cardio Tennis Training’. Payment is received on the same window in the Paid Today field below.
Supplier account balances as at 30 September 2017
|Name||Address||Supplier Terms||Account Balance|
|Swimmart Imports Pty
|Unit 12/301 Airport
Drive, Tullamarine VIC
ABN: 65 567 763 555
|Tennis Warehouse||5/11 Park Place, East
Melbourne VIC 3005
ABN: 45 544 555 888
|Atletico European Imports||56 Alexander Way, Port
Melbourne VIC 3090
ABN: 87 987 555 232
These are the suppliers from which Jack purchased inventory and still had amounts owing as at 30th September 2017.
Jack has one full time employee and one casual employee. He also cites himself as an employee as the store’s General Manager. The business operates a 5 day week as the store is closed on Sunday’s and Monday’s. The employee details are:
|Name||Address||Employment||Wages & Salaries|
D.O.B 15 Jan 1981
|5 Crissi Drive,
Mernda VIC 3940
TFN: 234 543 654
|Managing Director – Permanent Full Time
|Annual Salary of $60,000 – paid monthly on the 15th|
D.O.B 28 Feb 1993
|623 Thomas Rd
Balwyn VIC 3409
TFN: 567 765 876
|Retail Assistant – Casual||$21 per hour – paid monthly on the 15th|
D.O.B 19 Mar 1990
|43 Hibiscus Drive,
Doncaster VIC 3545
TFN: 987 987 543
|Fitness Trainer and
Retail Assistant –
Permanent Full Time
|Annual Salary of $50,000 – paid monthly on the 15th|
Full time employees are paid two weeks in arrears and two weeks in advance on the 15th of each month. Casual employees are paid for the hours they worked for the month.
Employees are paid the obligatory 9.25% superannuation which is calculated and paid to their nominated super fund each month by the 21st in the following month. As at 30 September $1,300 was due to be paid to Every Super Ltd in October for September’s wages.
Ensure that the Superannuation Guarantee is used and that the accounts linked are Superannuation Expense for the incursion of expenses and Superannuation Payable for the employer liability.
THE PAYROLL YEAR IS 2018****
Inventory: as at 30 September 2017
The following is a list of inventory on hand and the suppliers at the above date:
This list is entered into the Items List so as to have items ready to load when creating Sales and Purchase entries.
|Quantity on hand||Item code||Description||Cost Price||Sale Price||Supplier|
|22||124||Track Trainers||42.50||85.00||Atletico European Imports|
|6||125||Gym Bags||15.00||30.00||Atletico European Imports|
Imports Pty Ltd
Imports Pty Ltd
|45||132||Tennis Ball Packs||4.00||8.00||Tennis
Each of the above items of inventory are quoted net of GST. On each item, an additional 10% GST is charged on the sales price and 10% GST paid on the cost price.
Sales of the above items are recorded via the Enter Sales window using the Item Invoice layout.
Bank Loan Information:
Jack has a business loan with the AXZ Bank. Jack pays $1,240.50 per month off the loan on the 22nd of each month. This payment includes interest and principle where the monthly interest is $340.50.
Prepaid Rent Information:
On July 1st 2017, Jack paid $5,940 Inc. GST for 6 month’s rent in advance to the Bundoora Sports & Aquatic Centre.
Transactions during October 2017:
|1 Tue||In-store sales were for 6 trainers, 8 swim goggles, 4 tennis racquets|
|1 Tue||15 customers paid for Tuesday’s Track Fitness Class. Of those customers 4 customers paid for all three of the weeks classes in advance.|
|2 Wed||Purchased 45 swim caps (new inventory item cost $6 each, sale price $12 each excluding GST) and 5 swimming goggles from Swimmart. Invoice #57|
|2 Wed||Tennis Warehouse had a promotion for the new children’s program TennisKids. Jack purchased 30 Junior Tennis Racquets (new inventory item for $12.50 each to be sold for $25 each excluding GST). Invoice #322|
|2 Wed||Sold 25 Junior Tennis racquets and 20 packs of tennis balls to Bundoora West Primary School on account. Invoice #300|
|3 Thu||12 customers paid for Thursdays Swim Fitness Class. Use Invoice# TC (training customers)|
|3 Thu||Paid the cleaner cash of $95 for store cleaning from the Petty Cash tin.|
|4 Fri||Sold 35 swim caps to a new customer, Bundoora Girls Grammar School (ABN 23 454 654 567 Plenty Road Bundoora) Swim Team. Invoice #301|
|4 Fri||Purchased 10 pairs of track sports shoes from Atletico European Imports. Invoice #98|
|4 Fri||After opening the shoe boxes, Jack noticed that two pairs of track shoes had missing spikes underneath. He organised a return of 2 pairs of faulty track sports shoes to Atletico European Imports for a credit off the account. Credit #98C|
|4 Fri||Jack decided to purchase ball machines for his store. As they are rather expensive and Jack is not sure whether they will sell easily, he decides to purchase only 3 machines from Tennis Warehouse. They cost $2,500 each and sell for $5,000 each excluding GST. Invoice #633.|
|5 Sat||10 customers paid for Saturday Morning’s Cardio Tennis|
|5 Sat||Jack ran out of printer ink as he was printing invoices. He sent Sophie to Bundoora Stationery Store with money from the Petty Cash tin for office supplies including printer ink. She spent $83.50 in cash.|
|5 Sat||In-store sales were for 8 trainers and 4 gym bags|
|8 Tue||14 customers paid for Tuesday’s Track Fitness Class. Of those customers 3 customers paid for all three of the weeks classes in advance.|
|8 Tue||Sold 2 tennis ball machine to Bulleen Tennis Academy on account. Invoice #302|
|8 Tue||Paid BPay for electricity bill to City Electric of $126.40|
|9 Wed||Received payment from Bulleen Tennis academy for amounts owing from September 2016.|
|9 Wed||Received payment for Invoice #300 from Bundoora West Primary School.|
|10 Thu||Purchased 12 gym bags ($65 excluding GST cost price) from new supplier Champion
Sports Imports (ABN 86 579 684 676, Factory 4/11 International Drive, Airport West 3098). Their terms are Net 30 days with no early payment discount offered. Invoice #888
|10 Thu||Bundoora Girls Grammar returned 5 faulty swim caps. Credit note #305C. They argued that the store room should be checked for mice as the holes in the caps look like mice bites. On the same day they paid the balance of their account.|
|10 Thu||11 customers paid for Thursday’s Swim Fitness Class|
|11 Fri||In-store sales were for 7 pairs of trainers and 5 gym bags|
|12 Sat||In-store sales were for 8 swimsuits|
|12 Sat||9 customers paid for Saturday Morning’s Cardio Tennis|
|15 Tue||18 customers paid for Tuesday’s Track Fitness Class|
|15 Tue||Paid Wages for October. Jack and Stefano received full monthly salary (net $4003 and $3455.67 respectively), Sophie worked 65 hours for September/October for $1365 net.|
|17 Thu||13 customers paid for Thursday’s Swim Fitness Class|
|18 Fri||A new customer, Natasha Karilovinokova (ABN 76 545 664 755, Russian Consulate), ordered 7 trainers in a women’s size 11(!) for the visiting Russian women’s basketball team. As the large size was not available in store Jack put the trainers on back order for the customer. Sales Order #310.|
|19 Sat||Paid Superannuation payable for the previous month to EasySuper. Cheque #42|
|19 Sat||After seeing Australian Jimmy Carter win Wimbledon, 22 customers paid for Saturday Morning’s Cardio Tennis.|
|22 Tue||Paid the monthly repayment for the business loan.|
|22 Tue||8 customers paid for Tuesday’s Track Fitness Class.|
|23 Wed||A Jamaican just broke the 100meter world record. In anticipation of a surge in customers wanting to use this as inspiration to train harder, Jack places an order for 45 pairs of track shoes from Atletico for the upcoming summer athletics season. Purchase Order #PO123.|
|24 Thu||12 customers paid for Thursday’s Swim Fitness Class|
|24 Thu||After an attempted break in, Jack purchased $4400 inc. GST worth of surveillance and security equipment for the store. The equipment was paid for with a loan given to him by his concerned mother. He promised he will pay her back when he can. The equipment is depreciated using the straight line method over its four year useful life. Record the purchase of the equipment and the loan to his mother using a General Journal. You will have to create an asset account and a liability account for each.|
|25 Fri||Paid $375 for advertising in the Sun Newspaper Health Guide. Cheque # 43|
|25 Fri||The stock ordered on 18th has been shipped to customer. Charged freight on delivery of $45.|
|26 Sat||5 customers paid for Saturday Morning’s Cardio Tennis|
|29 Tue||After torrential rain flooded the track and tennis courts, all fitness training was suspended for the last week of October.|
|29 Tue||Received a phone call from Bundoora East Primary School saying that we sent them an invoice with Bundoora West Primary School listed as the customer. After some investigating it was found that Sophie accidently entered the incorrect customer on the invoice. Jack needs to delete the original sales invoice from the 2nd October and the payment on the 9th October and re-enter a new one with the correct customer Bundoora East Primary School.|
|30 Wed||The order which was placed on the 23rd October was delivered to the store. Invoice #211|
|31 Thu||Monthly bank statement received from AXZ Bank showed the following transactions on the 31st October:
Bank Charges $15
Interest Income $23
Balance Day adjustments at 31st October 2017
- Depreciation for all non-current assets are to be recorded for the month of October 2017. The Office Equipment which was purchased on 1st June 2017 is to continue to depreciate using the straight-line method over a 4 year useful life with no residual value. Calculate depreciation for 1 month and enter it using a General Journal Entry.
- Calculate depreciation on security cameras for 7 days (i.e. 24th Oct -31st October) and enter using a General Journal Entry.
- Jack has used up 1 more month in prepaid rent. Enter the expensed amount in a General Journal Entry.
Once you have read through the assignment complete the following tasks in order and produce the following reports
- Enter the business information including name, address, ABN and company preferences.
- Establish a chart of account based upon the trial balance and enter the opening balances correctly. Produce a PDF of the Accounts List as at 1/10/2017
- Record the supplier and customer details as well as their opening balances – apply the amounts to corresponding sales and purchases. Produce a PDF of the Customer Card List and the Supplier Card List as at 1/10/2017
- Enter the employee information. Produce a PDF of the Employee Card List as at 1/10/2017
- Enter inventory item details and enter opening balances for each item. Produce a PDF of the Inventory on Hand List as at 1/10/2017.
- Record the transactions for October 2017
- Calculate and record adjusting entries for the month of October 2017
- Produce a Transaction Journal List for 1/10/2017 – 31/10/2017
Prepare the following reports for 31st October 2017:
- Trial Balance
- Aged Debtors Report
- Aged Creditors Report iv. Income Statement for October 2017
- Balance Sheet
- The General Ledger accounts for Cash at Bank, Inventory and GST Collected, GST Paid.
Here is a list of things you can do in order to attempt to gain full marks.
- Start the assignment early and finish early so that you have plenty of time to go back over your work and find any errors.
- Keep regular copies of your files
- Set regular times to complete the tasks and set deadlines that you can realistically achieve.
- Compare your work with as many other students as possible before you hand it in. If you find that you have recorded things differently, you both can’t be right, or you can both be wrong, so discuss it and make the necessary corrections.
- Check your spreadsheets carefully after you have exported your files.
Students have traditionally made the same predictable mistakes. Some common mistakes include (but are not limited to) the following:
- Incorrect amounts entered into the opening balances in the chart of accounts. Check to ensure that the amounts entered are positive except for the contra accounts.
- Wrong amounts recorded – eg Incorrect sales/purchases amounts
- Enter an order incorrectly as an invoice
- Transactions recorded twice
- Entering freight into the incorrect screen
- Entering expense payments into supplier purchases command centre GST missing or applied where it shouldn’t be. Missing end of month adjusting entries.
Assignments with NO MYOB solution file (Myo. Format) will be granted a zero mark. All files must be saved based on your student ID number. All the following reports and files must be submitted to the assignment submission box.
|1||Account list [Summary] – PDF format|
|2||Aged payables [Summary] – PDF format|
|3||Aged Receivables [Summary] – PDF format|
|4||Employee Employment Details – PDF format|
|5||General ledger [Detail]
1/10/2017 to 31/10/2017 – PDF format
|6||Item list [Summary] – PDF format|
|7||Profit & loss statement
October 2017 – PDF format
As of October 2017 – PDF format
1/10/2017 to 31/10/2017 – PDF format
October 2017 – PDF format
|11||MYOB solution file – Myo. Format|
Click on Buy Solution and make payment. All prices shown above are in USD. Payment supported in all currencies. Price shown above includes the solution of all questions mentioned on this page. Please note that our prices are fixed (do not bargain).
After making payment, solution is available instantly.Solution is available either in Word or Excel format unless otherwise specified.
If your question is slightly different from the above question, please contact us at firstname.lastname@example.org with your version of question.