Part A: Manual Recording
Specific" "srmation Highway Heaven (ABN 65111177778 ) is owned and operated by Michael Harley. He operates a motor cycle retail business buying motorcycles from importers and selling them in Melbourne. His shop is at 888 Sydney Road, Glenville, 3056. All sales of motor cycles are on credit, unless otherwise stated; customers are required to pay cash for riding lessons. Purchases of motor cycles are on credit and operating expenses are paid in cash. The business charges GST on all inventory sales and riding lessons, and pays GST on inventory purchases and most business expenses. Goods and Services Tax Highway Heaven charges GST of 10% on all sales pays GST on all business expenses, except wages. Non-current asset acquisitions are also taxed at GST of 10%. Employees Michael has two employees, Dirk Davidson and Mae Scooter who are both paid $25 per hour. Wages owing to Dirk and Mai at 31 August is $200 each. Note: Highway Heaven does not use XERO payroll. Wages are recorded as an expense payment. Page 1 of 8 Inventory The following list of closing inventory and the suppliers at 31 August 2022: Each of the above items of inventory are quoted excluding GST. Inventory orders are delivered to Highway Heaven the same day the order is made to the supplier. Highway Heaven maintains perpetual inventory records for all inventory items using F.I.F.O. (First-In-First-Out recording method). Lessons Customers are charged $90 (excluding GST) per hour for riding lessons. All lessons are paid for in cash at the time of the lesson. Lessons revenue is recorded separately from the sale of inventory. Supplier information Supplier balances at 31 August 2022 are: Supplier information Supplier balances at 31 August 2022 are: Each of the above account balances represents deliveries of inventories received on 15 August 2022. All purchases are on terms net 30 days. Customer information Customer balances at 31 August 2022 are: Terms of payment for customers is net 30 days. Bank loan Highway Heaven has a loan payable to Bikers Bank. Each month interest of $330 is paid and $1,000 principal is paid off the loan. Opening balances Trial balance at 31 August 2022. Transactions: September 2022 Sept. 1 Wrote a cheque to All-Technics for a new cash register $3,740 (including GST). [Ref: Cheque 210] The cash register is expected to last for 3 years with a residual value of $160. Depreciation is allocated using the straight-line depreciation method. 1 Wrote a cheque to White Real Estate for shop rent for September, October and November for $8,184. (GST inclusive) [Ref: Cheque 211] 2 Paid a six-month advertising campaign in Bikers World, a monthly magazine sold in news agencies for motorbike enthusiasts. [Ref: Cheque 212] Highway Heaven will have an advertisement in each edition of the magazine. A cheque was written for $2,772 (GST inclusive) for the six months. 3 Cash sale: 1 Coast Cruiser and 4 Big Head helmets (Invoice R301) 4 Two customers each paid for a 3 hour lesson each (Invoice L1) 6 Paid legal fees owing to Dumbar \& Dumbar [Ref:Cheque 213] 8 Paid Hit the Road the balance outstanding at 31 August [Ref: Cheque 214] 10 Michael withdrew $2,500 cash for personal use [Ref: Cheque 215] 10 Cash sales: 5 Big Head helmets, 2 Road Runners and 1 Coast Cruiser (Invoice (R302) 10 Total amount owing at 31 August was paid to Best Bikes [Ref: Cheque 216] 11 Credit sale: 3 Road Runner motorbikes to Kamikaze Couriers. (Invoice CR71); Freiht charges $90. 11 Highway Heaven purchased 10 Big Head helmets on credit. All goods were received the same day. (Ref: P.O. 344) 12 Kamikaze Couriers paid the balance owing at 31 August. 12 Credit purchase of the following items (Ref: P.O. 345) - 5 Road Runners 10 Cash sales: 5 Big Head helmets, 2 Road Runners and 1 Coast Cruiser (Invoice (R302) 10 Total amount owing at 31 August was paid to Best Bikes [Ref: Cheque 216] 11 Credit sale: 3 Road Runner motorbikes to Kamikaze Couriers. (Invoice CR71); Freiht charges $90. 11 Highway Heaven purchased 10 Big Head helmets on credit. All goods were received the same day. (Ref: P.O. 344) 12 Kamikaze Couriers paid the balance owing at 31 August. 12 Credit purchase of the following iterns (Ref: P.O. 345) - 5 Road Runners - 5 Coast Cruisers All goods were received the same day. 12 Paid $561 (GST inclusive) to Evans Garage for motor vehicle expenses. [Ret: Cheque 217] 14 Free Wheelers paid the amount owing at 31 August. 14 Pay day. Dirk was paid for 56 hours, and Mae was paid for 50 hours, which included the wages owing at 31 August. [Ref: Cheques 218 and 219 ]. GST is not applicable. 15 Credit sale of inventory to a new customer, Rangers Bike Club, of 2 Coast Cruisers. Freightdelivery charges were $80 (GST exclusive) (Invoice CR72) New customer details: 110 Melboume Road, Williamsville, 3222, ABN 65111 722545 163 customers paid cash for a 3 hour lesson each. (Invoice L2) 18 Received amount owing from Kamikaze Couriers for 11 September sale. 18 Paid Australian Taxation Office net GST payable at 31 August. [Ret: Cheque 220] 19 Michael introduces a new product for sale. He has purchased T-shirts with the business logo on the back. The supplier is Tommy Tea, 18 Short Street, Tigeriand, 3055. (ABN 84111222 18 Paid Australian Taxation Office net GST payable at 31 August. [Ref: Cheque 220] 19 Michael introduces a new product for sale. He has purchased T-shirts with the business logo on the back. The supplier is Tommy Tea, 18 Short Street, Tigerland, 3055. (ABN 84111222 Page 4 of 8 233). Highway Heaven purchased 100 T-shirts on credit for a list price of $22.00.(GST inclusive). (P.O. 346) Selling price of the T-shirts is $38.50 (GST inclusive). 21 Credit sale: 8 Big Head helmets and 30 T-shirts to Free Wheelers. (Invoice CR73) 21 Paid for stationery supplies of $2,739 (GST inclusive) to Officeworks. [Ref: Cheque 221] 22 Michael withdrew $3,000 cash for personal use. [Ref: Cheque 222] 23 A customer paid cash for a 4 hour lesson (Invoice L3). 23 Credit purchase of inventory (Ref: P.O. 347& P.O. 348): - 16 Big Head helmets - 2 Road Runners - 3 Coast Cruisers The goods were received on the same day. 22 Michael withdrew $3,000 cash for personal use. [Ref: Cheque 222] 23 A customer paid cash for a 4 hour lesson (Invoice L3). 23 Credit purchase of inventory (Ref: P.O. 347 \& P.O. 348): - 16 Big Head helmets - 2 Road Runners - 3 Coast Cruisers The goods were received on the same day. 25 Credit sale of 4 Road Runners to Kamikaze Couriers. (Invoice CR73); freight charges of $90. 25 Cash sale of 1 Coast Cruiser for special price of $4543 (GST inclusive). The customer was particularly good at negotiating a special price for the Coast Cruiser. The customer also purchased 10T-shirts for cash at the normal price (Invoice R303). 26 Paid Best Bikes for inventory purchased on 12 September [Ref: Cheque 223] 26 Returned 10 Big Head helmets to Hit the Road as they were damaged. These items were purchased on 23 September. A credit note was issued by the supplier. 26 Received payment from Rangers Bike Club for bikes purchased on 15 September. 27 Paid 12 months motor vehicle insurance of $1,016.40 (GST inclusive) to Allied Insurance. [Ret: Cheque 224] Note: record this as motor vehicle expenses. 27 Kamikaze Couriers returned 1 Road Runner as it was not required. Michael agreed to give Kamikaze Couriers a full credit refund as the motorbike was returned in perfect condition. 28 Pay day for employees. Dirk was paid for 64 hours and Mae was paid for 58 hours. [Ret: Cheques 225 and 226] 29 Recelved $7,800 from Kamikaze Couriers. 30 Paid monthly loan repayment to Bikers Bank of $1,330 (this includes $330 interest). In addition, Michael decided the business will pay an additional $2,000 off the loan principal. GST is not applicable to this transaction. [Ret: Cheque 227]. 29 Received $7,800 from Kamikaze Couriers. 30 Paid monthly loan repayment to Bikers Bank of $1,330 (this includes $330 interest). In addition, Michael decided the business will pay an additional $2,000 off the loan principal. GST is not applicable to this transaction. [Ref: Cheque 227]. Adjustments at 30 September 2022 Some adjustments are found in the above transactions. Additional adjustments are: - Motor vehicle and shop fumiture \& fixtures are to be depreciated at 15% per year. - Wages owing at 30 April: Dirk 9 hours, Mae 8 hours - The April bank statement included bank fees of $35. - Inventory count on 30 April revealed inventory on hand as: Big Head helmets 16 Road Runner bikes 14 Page 5 of 8 Accounts List Page 6 of 8 Note: Amend, add or delete accounts as required. Accounts with a " cannot be deleted. Required: Part A: manual recording 1. Record the opening balances as at 1 September 2022 in the general joumal and appropriate generij ledger accounts and the opening balances of accounts receivable, accounts payable and inventory in the appropriate subsidiary ledger accounts. 2. Pecord the transactions in the appropriate general or special joumal for September 2022. 3. Record and post all transactions from the general and specialist joumals to the general ledger in accordance with accounting procedures. 4. Prepare schedules of accounts receivable, accounts payable and inventory as at 30 September 2022 and reconcile these with the control accounts in the general ledger. 5. Record end of month adjustments in the general journal and post these to the general ledger. 6. Prepare a Trial Balance after end of month adjustments as at 30 September 2022. 7. Prepare closing entries for September 2022. 8. Prepare a Statement of Financial Performance (Income Statement) for September 2022 and a Statement of Financial Position (Balance Sheet) as at 30 September 2022. 9. Prepare a Trial Balance after closing entries for September 2022. Pro-forma joumals, ledgers, worksheets and reports are available in the assessment folder and must be used to submit part Arthis is an exceel file) Part A: manual recording 1. Record the opening balances as at 1 September 2022 in the general journal and appropriate general ledger accounts and the opening balances of accounts receivable, accounts payable and inventory in the appropriate subsidiary ledger accounts. 2. Record the transactions in the appropriate general or special joumal for September 2022. 3. Record and post all transactions from the general and specialist joumals to the general ledger in accordance with accounting procedures. 4. Prepare schedules of accounts receivable, accounts payable and inventory as at 30 September 2022 and reconcile these with the control accounts in the general ledger. 5. Record end of month adjustments in the general journal and post these to the general ledger. 6. Prepare a Trial Balance after end of month adjustments as at 30 September 2022. 7. Prepare closing entries for September 2022. 8. Prepare a Statemuint of Financial Performance (Income Statement) for September 2022 and a Statement of Financial Position (Balance Sheet) as at 30 September 2022. 9. Prepare a Trial Balance after closing entries for September 2022. Pro-forma joumals, ledgers, worksheets and reports are available in the assessment folder and must be used to submit part A (this is an excel file). (18 marks) Part B Computerised accounts using XERO 1. Click on the link to Highway Heaven XERO which is in an email sent to you from XERO. (Note: You must complete part b of the assignment using the XERO.) 2. In your XERO, click on the business Highway Heaven and complete the organisation details. Highway Heaven conducts a motor cycle retail business. 3. Create an appropriate Chart of Accounts for Highway Heaven (a sample Chart of Accounts is provided on pages 6-7 of the assignment). 4. Enter the conversion (opening) balances as at 1 September 2022. Specific" "srmation Highway Heaven (ABN 65111177778 ) is owned and operated by Michael Harley. He operates a motor cycle retail business buying motorcycles from importers and selling them in Melbourne. His shop is at 888 Sydney Road, Glenville, 3056. All sales of motor cycles are on credit, unless otherwise stated; customers are required to pay cash for riding lessons. Purchases of motor cycles are on credit and operating expenses are paid in cash. The business charges GST on all inventory sales and riding lessons, and pays GST on inventory purchases and most business expenses. Goods and Services Tax Highway Heaven charges GST of 10% on all sales pays GST on all business expenses, except wages. Non-current asset acquisitions are also taxed at GST of 10%. Employees Michael has two employees, Dirk Davidson and Mae Scooter who are both paid $25 per hour. Wages owing to Dirk and Mai at 31 August is $200 each. Note: Highway Heaven does not use XERO payroll. Wages are recorded as an expense payment. Page 1 of 8 Inventory The following list of closing inventory and the suppliers at 31 August 2022: Each of the above items of inventory are quoted excluding GST. Inventory orders are delivered to Highway Heaven the same day the order is made to the supplier. Highway Heaven maintains perpetual inventory records for all inventory items using F.I.F.O. (First-In-First-Out recording method). Lessons Customers are charged $90 (excluding GST) per hour for riding lessons. All lessons are paid for in cash at the time of the lesson. Lessons revenue is recorded separately from the sale of inventory. Supplier information Supplier balances at 31 August 2022 are: Supplier information Supplier balances at 31 August 2022 are: Each of the above account balances represents deliveries of inventories received on 15 August 2022. All purchases are on terms net 30 days. Customer information Customer balances at 31 August 2022 are: Terms of payment for customers is net 30 days. Bank loan Highway Heaven has a loan payable to Bikers Bank. Each month interest of $330 is paid and $1,000 principal is paid off the loan. Opening balances Trial balance at 31 August 2022. Transactions: September 2022 Sept. 1 Wrote a cheque to All-Technics for a new cash register $3,740 (including GST). [Ref: Cheque 210] The cash register is expected to last for 3 years with a residual value of $160. Depreciation is allocated using the straight-line depreciation method. 1 Wrote a cheque to White Real Estate for shop rent for September, October and November for $8,184. (GST inclusive) [Ref: Cheque 211] 2 Paid a six-month advertising campaign in Bikers World, a monthly magazine sold in news agencies for motorbike enthusiasts. [Ref: Cheque 212] Highway Heaven will have an advertisement in each edition of the magazine. A cheque was written for $2,772 (GST inclusive) for the six months. 3 Cash sale: 1 Coast Cruiser and 4 Big Head helmets (Invoice R301) 4 Two customers each paid for a 3 hour lesson each (Invoice L1) 6 Paid legal fees owing to Dumbar \& Dumbar [Ref:Cheque 213] 8 Paid Hit the Road the balance outstanding at 31 August [Ref: Cheque 214] 10 Michael withdrew $2,500 cash for personal use [Ref: Cheque 215] 10 Cash sales: 5 Big Head helmets, 2 Road Runners and 1 Coast Cruiser (Invoice (R302) 10 Total amount owing at 31 August was paid to Best Bikes [Ref: Cheque 216] 11 Credit sale: 3 Road Runner motorbikes to Kamikaze Couriers. (Invoice CR71); Freiht charges $90. 11 Highway Heaven purchased 10 Big Head helmets on credit. All goods were received the same day. (Ref: P.O. 344) 12 Kamikaze Couriers paid the balance owing at 31 August. 12 Credit purchase of the following items (Ref: P.O. 345) - 5 Road Runners 10 Cash sales: 5 Big Head helmets, 2 Road Runners and 1 Coast Cruiser (Invoice (R302) 10 Total amount owing at 31 August was paid to Best Bikes [Ref: Cheque 216] 11 Credit sale: 3 Road Runner motorbikes to Kamikaze Couriers. (Invoice CR71); Freiht charges $90. 11 Highway Heaven purchased 10 Big Head helmets on credit. All goods were received the same day. (Ref: P.O. 344) 12 Kamikaze Couriers paid the balance owing at 31 August. 12 Credit purchase of the following iterns (Ref: P.O. 345) - 5 Road Runners - 5 Coast Cruisers All goods were received the same day. 12 Paid $561 (GST inclusive) to Evans Garage for motor vehicle expenses. [Ret: Cheque 217] 14 Free Wheelers paid the amount owing at 31 August. 14 Pay day. Dirk was paid for 56 hours, and Mae was paid for 50 hours, which included the wages owing at 31 August. [Ref: Cheques 218 and 219 ]. GST is not applicable. 15 Credit sale of inventory to a new customer, Rangers Bike Club, of 2 Coast Cruisers. Freightdelivery charges were $80 (GST exclusive) (Invoice CR72) New customer details: 110 Melboume Road, Williamsville, 3222, ABN 65111 722545 163 customers paid cash for a 3 hour lesson each. (Invoice L2) 18 Received amount owing from Kamikaze Couriers for 11 September sale. 18 Paid Australian Taxation Office net GST payable at 31 August. [Ret: Cheque 220] 19 Michael introduces a new product for sale. He has purchased T-shirts with the business logo on the back. The supplier is Tommy Tea, 18 Short Street, Tigeriand, 3055. (ABN 84111222 18 Paid Australian Taxation Office net GST payable at 31 August. [Ref: Cheque 220] 19 Michael introduces a new product for sale. He has purchased T-shirts with the business logo on the back. The supplier is Tommy Tea, 18 Short Street, Tigerland, 3055. (ABN 84111222 Page 4 of 8 233). Highway Heaven purchased 100 T-shirts on credit for a list price of $22.00.(GST inclusive). (P.O. 346) Selling price of the T-shirts is $38.50 (GST inclusive). 21 Credit sale: 8 Big Head helmets and 30 T-shirts to Free Wheelers. (Invoice CR73) 21 Paid for stationery supplies of $2,739 (GST inclusive) to Officeworks. [Ref: Cheque 221] 22 Michael withdrew $3,000 cash for personal use. [Ref: Cheque 222] 23 A customer paid cash for a 4 hour lesson (Invoice L3). 23 Credit purchase of inventory (Ref: P.O. 347& P.O. 348): - 16 Big Head helmets - 2 Road Runners - 3 Coast Cruisers The goods were received on the same day. 22 Michael withdrew $3,000 cash for personal use. [Ref: Cheque 222] 23 A customer paid cash for a 4 hour lesson (Invoice L3). 23 Credit purchase of inventory (Ref: P.O. 347 \& P.O. 348): - 16 Big Head helmets - 2 Road Runners - 3 Coast Cruisers The goods were received on the same day. 25 Credit sale of 4 Road Runners to Kamikaze Couriers. (Invoice CR73); freight charges of $90. 25 Cash sale of 1 Coast Cruiser for special price of $4543 (GST inclusive). The customer was particularly good at negotiating a special price for the Coast Cruiser. The customer also purchased 10T-shirts for cash at the normal price (Invoice R303). 26 Paid Best Bikes for inventory purchased on 12 September [Ref: Cheque 223] 26 Returned 10 Big Head helmets to Hit the Road as they were damaged. These items were purchased on 23 September. A credit note was issued by the supplier. 26 Received payment from Rangers Bike Club for bikes purchased on 15 September. 27 Paid 12 months motor vehicle insurance of $1,016.40 (GST inclusive) to Allied Insurance. [Ret: Cheque 224] Note: record this as motor vehicle expenses. 27 Kamikaze Couriers returned 1 Road Runner as it was not required. Michael agreed to give Kamikaze Couriers a full credit refund as the motorbike was returned in perfect condition. 28 Pay day for employees. Dirk was paid for 64 hours and Mae was paid for 58 hours. [Ret: Cheques 225 and 226] 29 Recelved $7,800 from Kamikaze Couriers. 30 Paid monthly loan repayment to Bikers Bank of $1,330 (this includes $330 interest). In addition, Michael decided the business will pay an additional $2,000 off the loan principal. GST is not applicable to this transaction. [Ret: Cheque 227]. 29 Received $7,800 from Kamikaze Couriers. 30 Paid monthly loan repayment to Bikers Bank of $1,330 (this includes $330 interest). In addition, Michael decided the business will pay an additional $2,000 off the loan principal. GST is not applicable to this transaction. [Ref: Cheque 227]. Adjustments at 30 September 2022 Some adjustments are found in the above transactions. Additional adjustments are: - Motor vehicle and shop fumiture \& fixtures are to be depreciated at 15% per year. - Wages owing at 30 April: Dirk 9 hours, Mae 8 hours - The April bank statement included bank fees of $35. - Inventory count on 30 April revealed inventory on hand as: Big Head helmets 16 Road Runner bikes 14 Page 5 of 8 Accounts List Page 6 of 8 Note: Amend, add or delete accounts as required. Accounts with a " cannot be deleted. Required: Part A: manual recording 1. Record the opening balances as at 1 September 2022 in the general joumal and appropriate generij ledger accounts and the opening balances of accounts receivable, accounts payable and inventory in the appropriate subsidiary ledger accounts. 2. Pecord the transactions in the appropriate general or special joumal for September 2022. 3. Record and post all transactions from the general and specialist joumals to the general ledger in accordance with accounting procedures. 4. Prepare schedules of accounts receivable, accounts payable and inventory as at 30 September 2022 and reconcile these with the control accounts in the general ledger. 5. Record end of month adjustments in the general journal and post these to the general ledger. 6. Prepare a Trial Balance after end of month adjustments as at 30 September 2022. 7. Prepare closing entries for September 2022. 8. Prepare a Statement of Financial Performance (Income Statement) for September 2022 and a Statement of Financial Position (Balance Sheet) as at 30 September 2022. 9. Prepare a Trial Balance after closing entries for September 2022. Pro-forma joumals, ledgers, worksheets and reports are available in the assessment folder and must be used to submit part Arthis is an exceel file) Part A: manual recording 1. Record the opening balances as at 1 September 2022 in the general journal and appropriate general ledger accounts and the opening balances of accounts receivable, accounts payable and inventory in the appropriate subsidiary ledger accounts. 2. Record the transactions in the appropriate general or special joumal for September 2022. 3. Record and post all transactions from the general and specialist joumals to the general ledger in accordance with accounting procedures. 4. Prepare schedules of accounts receivable, accounts payable and inventory as at 30 September 2022 and reconcile these with the control accounts in the general ledger. 5. Record end of month adjustments in the general journal and post these to the general ledger. 6. Prepare a Trial Balance after end of month adjustments as at 30 September 2022. 7. Prepare closing entries for September 2022. 8. Prepare a Statemuint of Financial Performance (Income Statement) for September 2022 and a Statement of Financial Position (Balance Sheet) as at 30 September 2022. 9. Prepare a Trial Balance after closing entries for September 2022. Pro-forma joumals, ledgers, worksheets and reports are available in the assessment folder and must be used to submit part A (this is an excel file). (18 marks) Part B Computerised accounts using XERO 1. Click on the link to Highway Heaven XERO which is in an email sent to you from XERO. (Note: You must complete part b of the assignment using the XERO.) 2. In your XERO, click on the business Highway Heaven and complete the organisation details. Highway Heaven conducts a motor cycle retail business. 3. Create an appropriate Chart of Accounts for Highway Heaven (a sample Chart of Accounts is provided on pages 6-7 of the assignment). 4. Enter the conversion (opening) balances as at 1 September 2022
