ACC601: Practical Trial Balance for Manly Surf and Wellness Shop

This practical accounting assignment focuses on the financial performance of The Manly Surf and Wellness Shop for the month of April 2019, as part of the ACC601 course at the International College of Management, Sydney. The assignment requires students to generate and analyze various financial reports using Xero software. The solution includes a detailed trial balance, aged payables and receivables reports, a general ledger, profit and loss statements (in both PDF and Excel formats), a balance sheet (in both PDF and Excel formats), all journals, and a short report summarizing the company's performance. The trial balance provides a comprehensive overview of the shop's financial position, including assets, liabilities, equity, revenues, and expenses. The assignment aims to assess students' understanding of accounting principles and their ability to apply these principles in a practical setting using accounting software. The provided solution offers a complete set of financial statements and analysis for the given period, providing a valuable resource for students studying accounting and finance.

Trial Balance The Manly Surf and Wellness Shop
Trial Balance
The Manly Surf and Wellness Shop
As at 30 April 2019
ACCOUNT CODE ACCOUNT ACCOUNT TYPE DEBIT CREDIT 29 APR 2019
001 Petty Cash Current Asset 115.00 115.00
002 Prepaid Insurance Current Asset 11,167.00 -
003 Prepaid Rent Current Asset 13,250.00 26,500.00
004 Motor Vehicles Fixed Asset 45,000.00 45,000.00
005 Less Accumulated
Depreciation MV Fixed Asset 12,000.00 (12,000.00)
015 Cash at Bank Bank 201,826.60 202,016.60
018 Allowances for doubt ful
debt Current Asset 615.45 -
610 Accounts Receivable Current Asset 41,030.00 41,030.00
620 Prepayments Current Asset 30,000.00 30,000.00
630 Inventory Current Asset 186,275.00 186,275.00
710 Office Equipment Fixed Asset 18,700.00 18,700.00
711
Less Accumulated
Depreciation on Office
Equipment
Fixed Asset 4,560.00 (4,560.00)
006 Loan to NAB Liability 52,000.00 (40,000.00)
800 Accounts Payable Current Liability 63,910.00 (63,910.00)
820 Sales Tax Current Liability 9,195.23 (9,195.23)
970 Owner A Share Capital Equity 100,000.00 (100,000.00)
007 Sales revenue- Clothing and
merchendise Sales 637,850.00 (637,850.00)
008 Revenue-Surf Lessons Revenue 269,630.00 (269,630.00)
009 Revenue Yoga lessons Revenue 98,060.00 (98,060.00)
270 Interest Income Revenue 75.00 -
010 Accounting Fees Expense 15,460.00 15,460.00
012 Electricity Expense 3,602.64 3,602.64
016 Council Rates Expense 340.91 340.91
017 Bad Debt Expense Expense 615.45 -
310 Cost of Goods Sold Direct Costs 357,425.00 357,425.00
400 Advertising Expense 9,000.00 9,000.00
404 Bank Fees Expense 15.00 -
408 Cleaning Expense 259.08 259.08
425 Freight & Courier Expense 4,520.00 4,520.00
433 Insurance Expense 22,333.00 33,500.00
437 Interest Expense Expense 14,500.00 2,250.00
449 Motor Vehicle Expenses Expense 18,796.67 18,796.67
469 Rent Expense 28,708.33 15,458.33
473 Repairs and MaintenanceExpense 15,000.00 15,000.00
477 Wages and Salaries Expense 207,500.00 207,500.00
489 Telephone & Internet Expense 2,456.00 2,456.00
Total 1,247,895.681,247,895.68 -