Complete Accounting Cycle
Train Hard Gym
Background and Facts
Duke Harrison is the owner of Train Hard Gym a gym and fitness business he started several years ago. The business is GST-registered.
Duke provides personal training services, gym memberships and sells to members and other Gyms, protein concentrate products, energy drinks and T-Shirts, that he purchases from manufacturers. He operates the business himself and employs one person full-time to assist him. Train Hard Gym uses a perpetual inventory system and uses FIFO (First In First Out).
The business is operated from a commercial building which was purchased two years ago.
Duke has a variety of clients with whom he has built up a strong relationship. He offers them terms of 30 days in some cases and other clients pay in advance or by direct debit. All memberships of the gym are paid by direct debit. Duke submits his Business Activity Statements (BAS) for GST quarterly to the Australia Taxation Office on an accruals basis.
Currently, the business uses a manual accounting system but plans to test a MYOB accounting system in July.
Train Hard Gym uses the following specialised and general journals to record business transactions.
Sales Journal - to record all invoices issued for sales of inventory
Sales Returns Journal - to record all credit notes issued for returned inventory
Purchases Journal - to record all credit purchases of inventory
Cash Receipts Journal - to record all cash received
Cash Payments Journal - to record all cash payments
General Journal - to record all other transactions
Train Hard Gym uses a general ledger in the form of a 4 column running balance (as described on page 79 Exhibit 2-13 of Custom Text 3rd Ed). An Accounts Receivable and Accounts Payable subsidiary ledger is also used in this format.
Financial Statements are prepared at the end of each month. The accounts are closed off at the end of the each month.
All necessary pro-formas are included and are to be used to complete the manual practice set for June 2014. If you wish to use a T account format then you will need to generate your own forms to fill out. The assignment can be completed either manually using the Excel templates provided or by computer in Excel.
Chart of Accounts
Account Number Account Name Opening Balance
110 Cash at Bank 25,129
120 Accounts receivable 13,797
121 Allowance for Doubtful Debts 869
130 Prepaid Insurance
150 Office Supplies 945
160 Inventory 17,302
170 Gym Equipment 1,20,000
171 Accumulated Deprecation – Gym Equipment 15,000
172 Office Equipment 5,280
173 Accumulated Depreciation – Office Equipment 1,195
181 Accumulated Depreciation – Computer
190 Premises 4,50,000
191 Accumulated Depreciation – Premises 45,000
200 Accounts Payable 9175
210 Unearned Revenue 5,000
220 Wages Payable 241
230 GST Clearing 1,065
240 PAYG Payable 962
250 Superannuation Payable 168.75
280 Bank Loan – Non-current 3,00,000
300 Capital 2,53,777.25
350 Income Summary
410 Sales Revenue
411 Sales Returns and Allowance
412 Sales Discount
413 Discount Received
414 Personal Training Fees
416 Membership Fees
420 Interest Revenue
500 Cost of Sales
510 Advertising Expense
512 Bad and doubtful debts expense
515 Bank Charges
520 Depreciation Expense – Gym Equipment
521 Depreciation Expense – Office Equipment
522 Depreciation expense – Computer
523 Depreciation Expense – Premises
540 Insurance Expense
550 Interest Expense
560 Office Supplies Expense
570 Superannuation expense
580 Telephone and Internet Expense
590 Wages Expense
All account balances at 31st May are normal in nature.
The bank reconciliation for 31st May is shown below.
Balance as per bank Statement 24,812
Add deposits not yet credited 3,123
Less Unpresented cheques
Balance as per Cash at Bank Ledger Account 25,129
Accounts Receivable Subsidiary Ledger
As at 1 June (all balances relate to May credit sales)
Atlas 24 Hour Gym 1,200
AllSports Football Club 3,520
J. Smith – Personal Trainer 5,927
A. Godfrey 3,150
Accounts Payable Subsidiary Ledger
As at 1 June (all balances relate to May credit purchases)
Protein & Fitness Supplies Ltd 8,515
T-Shirts by Design 660
Inventory on Hand
As at 1 June
Units on Hand Cost per Unit Total
Train Hard Protein Blend 2.3kgs Pack 252 56 14,112
Train Hard Energy Drink 138 15 2,070
(sold as a pack of 6)
Train Hard T-Shirts 56 20 1,120
The following transactions relate to the operations of Train Hard Gym during June:
Note: All amounts are GST-inclusive unless otherwise stated.
Credit sales are made on credit terms of 2/10, n30
1. 1 Jun-01 Received in the bank account by Direct Debit the membership fees for June, $22,400.
2. 2 Jun-01 Paid by EFT insurance for 12 months, $2,500.00
3. Jun-03 Sold 5 Train Hard Protein Blend Packs for cash - $467.50
4. 4 Jun-03 Purchased inventory on credit from Protein and Fitness Supplies - $8,800
120 Units of Train Hard Protein Blend Packs
5. Jun-04 Received amount owed by J. Smith for May invoices less applicable discounts as it was received within the relevant discount period.
6. 5 Jun-05 Purchased office supplies for $550 – cheque 55 (use Chart of Account number 150 Office Supplies)
7. Jun-05 Received $1790 cash from clients for Personal Training services
8. 6 Jun-05 Received partial payment from A. Godfrey for May sales - $1,500
No discounts were applicable.
9. 7 Jun-08 Sold 15 T-Shirts to J. Smith on credit for $495 – Invoice # 5112
10. 8 Jun-08 Purchased inventory on credit from T-Shirts by Design - $3,300 (including GST) -
120 Train Hard T-Shirts at $25 each (excluding GST)
11 Jun-09 Received amount owed by Allsports Football Club for May invoices less applicable discount as it was received within the relevant discount period.
12. 1 Jun-10 Paid fortnightly wages of $2,116 – EFT
($1,875 relates to June wages; $241 relates to the wages accrued for May)
PAYG deducted from these wages amounted to $375.
13. 1 Jun-12 Paid FabAb Magazine Ltd for advertising for June $425– cheque 56
14. 1 Jun-15 Purchased Computer for $2,761 from JBHI – cheque 57. The computer has a life of 3 years with no residual value.
15. Jun-15 Sold on account to A Godfrey $ 11,583
120 Train Hard Protein Blend Packs $11,220
15 Train Hard Energy Drink Packs $363 – Invoice 5113
16. 1 Jun-15 Banked the takings from cash sales for the last fortnight –
Items sold 4 T-Shirts $132
52 Train Hard Protein Blend Packs $4,862
10 Train Hard Energy Drink Packs $242
17. 1 Jun-16 Duke Harrison withdraw $500 cash – cheque 58
18. Jun-17 J Smith returned 5 Train Hard T-Shirts which were faulty. CRN (Credit Note) 111 was issued. These T-shirts were from the inventory that cost $20.
19. 1 Jun-18 Paid amount owing from May to Protein and Fitness Supplies - $8,515 cheque 59
No discounts were applicable.
20. Jun-24 Paid fortnightly wages of $1,875 – by EFT
PAYG tax deducted from theses wages amounted to $375.
21. Jun-24 Paid PAYG tax payable for May of $962 by cheque 60
22. Jun-24 Paid superannuation contributions owing from May of $168.75 by BPAY.
23. Jun-29 Paid the monthly telephone account for $768 using BPAY
24. Jun-29 Invoiced Allsports Football Club for June services $10,175
Personal training $5,500
Train Hard Protein Blend Packs $4,675
25. Jun-30 Duke received $1450 from a client in advance for personal training services to be conducted in August.
26. Jun-30 Banked the takings from cash sales for the last fortnight - $2382.60.
Items sold 25 T-Shirts $ 825.00
12 Train Hard Protein Blend Packs $1,122
18 Train Hard Energy Drink Packs $435.60
27. Jun-30 Duke lodged his quarterly Business Activity Statement to the Australian Taxation Office for May together with the GST payable for the May quarter of $1,065 with cheque 61
28. Jun-30 Received interest on bank deposit - $101
This information was obtained by inspecting the Bank Statement
29. Jun-30 Made monthly repayment on bank loan of $2,300. The interest component of the loan is $1,250.
This information was obtained by inspecting the Bank Statement.
Account Name: Train Hard Gym BSB: 026-391
Account number: 5421-6491
Date Particulars Debit Credit Balance
June 1 Balance brought forward 24812Cr
Direct Debit 22400 47212Cr
2 EFT Payless Insurance 2500 44712Cr
3 3123 47835Cr
3 467.5 48302.50Cr
4 5808.46 54110.96Cr
5 1790 55900.96Cr
6 1500 57400.96Cr
8 38 2610 54790.96Cr
10 3449.6 58240.56Cr
10 55 550 57690.56Cr
10 EFT 2116 55574.56Cr
56 425 55149.56Cr
46 57 55092.56Cr
15 5236 60328.56Cr
16 57 2761 57567.56Cr
20 58 500 57067.56Cr
59 8515 48552.56Cr
24 EFT 1875 46677.56Cr
24 BPAY – SuperFund 168.75 46508.81Cr
29 EFT – Teleco 768 45740.81Cr
29 60 962 44778.81Cr
30 Loan 2300 42478.81Cr
30 Interest 101 42579.81Cr
Bank fees 27 42552.81Cr
Instructions for Completion of Practice Set
A. Open all general ledger accounts by inserting the opening balances at 1 June as shown in the Chart of Accounts on page 2. For example, the balance of account 110 - Cash at Bank is $25,129Dr. Write “Opening Balance” in the “Details” column, and place $25,129 in the “Debit” balance column.
B. Open all subsidiary ledger accounts for accounts receivable and accounts payable by inserting the opening balances as at 1 June as shown in the schedule of accounts receivable and accounts payable on page 3. Insert the opening inventory balances into the inventory cards.
Note: For the general ledger, accounts receivable subsidiary ledger and accounts payable subsidiary ledgers, all accounts have normal balances
C. Record the transactions for June noted on page 4 - 5 in the appropriate journals (for general journals explanations/narrations are not required). The journals are provided in the Excel spreadsheet with the file name “Pro Formas TrainHardGym.xlsx”
D. All receipts received by direct credit or EFT are recorded in the Cash Receipts Journal on the day they are received.
E. Payments made by EFT or BPAY are recorded in the Cash Payment journal on the day the payment is made.
F. Use the treatment for Sales Discounts and Discount Received as illustrated in Chapter 7 Accounting Information Systems in the Cash Receipts and Cash Payments Journal.
G. Post entries daily to the accounts receivable and accounts payable subsidiary ledgers and inventory cards.
Post entries daily from the general journal
Note: For posting reference purposes, use the journal page names and numbers. For example, when posting from the sales journal the reference will be SJ1
H. Prepare a bank reconciliation statement as at 30 June. Where possible, clear the outstanding items from the May bank reconciliation and include any uncleared items in the June bank reconciliation. Prepare journal entries for any cashbook adjustments and post to the cash receipts and/or cash payments journal.
I. Total all columns of the special journals. Post from the special journals to the general ledger.
J. Prepare schedules of Accounts Receivable and Accounts Payable. Check that the total of the Schedule of Accounts Receivable equals the Accounts Receivable Control account in the general ledger and that the Schedule of Accounts Payable equals the Accounts Payable account in the general ledger.
K. Using the worksheet provided in the excel spreadsheet, prepare an unadjusted Trial Balance as at 30 June.
L. Using the information in 1-7 below, record the necessary adjusting journal entries at 30 June in the general journal. Post these to the general ledger.
M. Record these adjustments in the adjustments column of the worksheet.
N. Complete the worksheet.
Adjusting entry information as at 30 June
1. Unearned Revenue
On June 30, Duke received payment from client for personal training services to be undertaken in August as noted in the transaction # 25
Duke paid 12 months of insurance as noted in the transaction # 2 on June 1.
Gym equipment is depreciated using the straight-line method.
Existing Gym equipment has a useful life of 10 years with a residual value of $5,000.
Office equipment is depreciated using the straight-line method.
Existing office equipment has a useful life of 5 years with a residual value of $1,200.
On March 15, Duke purchased a computer. It has a useful life of 3 years and a residual value of zero and will be depreciated using the reducing balance method using 3 times the straight line rate.
Premises were purchased 2 years ago. They are depreciated at 5% per annum using the straight-line method.
Note: depreciation is calculated for the month of June only and is to commence from the day after installation of the asset. Round calculations to the nearest dollar.
4. Accrued Wages
Wages owing at 30 June totalled $958.
Superannuation contributions accrued for June total $90.
6. Office Supplies
A stocktake of office supplies was performed on 30 June. It was noted that $860 of supplies remain.
7. Bad Debts
An assessment of bad and doubtful debts at 30 June showed a marked increase in the number of accounts falling into this category. Duke has decided to increase the Allowance for Doubtful Debts to 4% of the accounts receivable balance at June 30.
Instructions for Completion of Practice Set continued
O. Record all closing entries in the general journal and post them to the general ledger.
P. Prepare a Post-closing Trial Balance as at 30 June.
Q. Prepare the Income Statement (functional format), Statement of changes in Equity, and Classified Balance Sheet.
Guidelines for the Timing of Completion
For Seminar 1 in Week 7 students should read the Practice Set and all instructions carefully and bring all pages to the Seminar.
For Seminar 2 in Week 8 students should have completed Instructions A and B and have commenced recording and posting transactions (Instructions C, D, E, F and G).
For Seminar 3 in Week 9 instructions C to J should been completed.
For Seminar 4 in Week 10 Bank Reconciliation and any other outstanding items
After the four Seminars are over, students should follow instructions in order to finish the Practice set by the due date.
Check Figures to help complete the Practice Set Assignment will be released at the end of Week 8.
 Specialised journals will be covered in Lecture 7
 Specialised ledgers will be covered in Lecture 7
 PAYG will be covered in Workshop 2
 Bank reconciliations will be covered in Lecture 8
 Bad and Doubtful debts & Allowance for Doubtful debts will be covered in Lecture 9