ACC601 Practical Accounting Assignment using XERO Software

This assignment presents a comprehensive general ledger summary and exceptions report for "The Manly Surf and Wellness Shop" from July 1, 2018, to June 30, 2019, including detailed account transactions, debits, credits, and net movements. It includes an aged payables summary, aged receivables summary, a detailed general ledger from April 1 to April 30, 2019, profit and loss statements for April 2019 in both PDF and Excel formats, a balance sheet as of April 30, 2019, also in PDF and Excel, all journals from April 1 to April 30, 2019, and a trial balance for April 2019. The assignment also requires a 200-word report on the company's April 2019 performance, demonstrating the student's ability to use XERO accounting software to generate and interpret financial data.

General Ledger
Summary
General Ledger Report | The Manly Surf and Wellness Shop | 21 April 2019 Page 1 of 2
The Manly Surf and Wellness Shop
From 1 July 2018 to 30 June 2019
Account Debit Credit Net Movement
Accounting Fees (010) 15,460 - 15,460
Advertising (400) 9,000 - 9,000
Cash at Bank (015) 77,904 - 77,904
Cost of Goods Sold (310) 290,500 - 290,500
Electricity (012) 3,215 - 3,215
Freight & Courier (425) 4,520 - 4,520
Historical Adjustment (840) 208,980 - 208,980
Insurance (433) 33,500 - 33,500
Interest Expense (437) 2,250 - 2,250
Inventory (630) 242,100 242,100 -
Less Accumulated Depreciation MV (005) 12,000 - 12,000
Loan to NAB (006) - 40,000 (40,000)
Motor Vehicle Expenses (449) 18,797 - 18,797
Motor Vehicles (004) 45,000 - 45,000
Office Equipment (710) 15,200 - 15,200
Less Accumulated Depreciation on Office Equipment (711) 4,560 - 4,560
Owner A Share Capital (970) - 100,000 (100,000)
Petty Cash (001) 200 - 200
Prepaid Rent (003) 26,500 - 26,500
Rent (469) 15,458 - 15,458
Revenue Yoga lessons (009) - 96,000 (96,000)
Revenue-Surf Lessons (008) - 242,000 (242,000)
Sales revenue- Clothing and merchendise (007) - 515,000 (515,000)
Telephone & Internet (489) 2,456 - 2,456
Wages and Salaries (477) 207,500 - 207,500
Total 1,235,100 1,235,100 -

General Ledger
Exceptions
General Ledger Report | The Manly Surf and Wellness Shop | 21 April 2019 Page 2 of 2
The Manly Surf and Wellness Shop
From 1 July 2018 to 30 June 2019
Date Type Reason Transaction Reference Debit Credit Tax