can someone make this myob assignment on which is due next week on 5th october.

QUEENSLAND UNIVERSITY OF TECHNOLOGY QUT Business School School of Accountancy AYB221 Accounting Systems and Technologies SEMESTER 2 2016 MYOB Assignment (Weighting Total - 20%) Due: Submission: Type: Length: 5th October 2016 by 8pm Electronic Submission before due date and time Individual See Submission requirements below This assessment item assesses the following learning outcomes: KS Knowledge & Skills (Technology) KS 1.2 Incorporate the use of technology appropriate to the discipline and content. Assessment Purpose This assignment is an individual assessment that aims to assess your learning from the MYOB tutorials and Pabst & Perrin text by asking you to complete a further month of transactions for the e-Generation organisation for February 2015. Accuracy of accounting information is the important to the assignment and marking will be based on correct journal entries and reports figures. Please refer to the criteria sheet on blackboard & the detailed submission requirements at the back of this document to ensure you meet the full requirements of this task. Submission Requirements: 1. Your final MYOB data (.myo) file and PDF versions of your reports will be uploaded into AYB221 Blackboard site via the electronic assignment submission process; (see report requirement details at back of assignment). 2. You will undertake two short quizzes online once you have submitted your reports & .myo file. Further details of this process will be provided closer to the due date. Tips for the Assignment Read the background to the business in the Pabst & Perrin book on p.8 before you commence the assignment. This will help to determine whether e-generation does reversing entries and the organisation's depreciation & amortisation methods. Work out each transaction type before starting to record transactions (ie credit purchases, cash sales, sales return etc).Look at how each transaction type is processed in Pabst & Perrin text and apply this same processing to the assignment Add new accounts where needed and use your accounting skills from prior units to assist you with entries Backup every few transactions to ensure you don't have to re-enter all transactions again if you make a mistake In relation to accounting for GST on Sales and Purchases, process these transactions in the same manner as January. Accept the next purchase order and invoice number displayed. Remember to tick the Tax Inclusive box for Cash Sales as is done in January. You may need to add new customers and or new terms for credit sales Refer to the bank statement as you enter your entries Late Assessment and Extensions If special circumstances prevent you from meeting the assessment due date, you can apply for an extension. Application for an extension must be received by the due date. If you don't have an extension submit the work you have completed at the due date and time. MYOB Assignment Semester 2 2016 Page 1 THE ASSIGNMENT Transactions for e-Generation for the month of February 2015 are: Date Feb Transaction 1 Record any reversing entries if e-Generation uses this method. 2 Received Invoice # RB2/15 from Glenelg Realty for Rent of $1,320.00 (inclusive of GST). The rent was paid at this date by Cheque # 1223. 3 Pickwick & Partners presented us with a cheque for the final balance owing on their account. This cheque was banked later in the month. 5 Received all the items ordered from Manx Ltd on 30/01/15 together with their invoice # 6487 for $5,544.00 A freight charge of $40.00 Plus $4.00 GST was included in the invoice amount. 5 Received a cheque from Viking Insurance Brokers for $1,000 as part-payment of Invoice 1783. The cheque was banked by close of business the next day. Sent a purchase order (#898) to Manx Ltd for: 6 18 x Blueberry Smartphone (BBS) @ $250.00 each (Plus GST). 6 Cash sale at standard price - 1 x ePad Power Adaptor (EPA) and 3 x ePad (EPD). The customer paid using cash. 6 Superannuation payable to date of $227.00 was paid to Good Super by Cheque # 1224. 6 Deposited $13,350.25 (cheques and cash) in the Bank of Adelaide cheque account. Hint this includes a number of receipts which have not been banked until now. 8 Emma Tomlinson received Cheque # 1225 for $602.00, to pay her net wages for the two weeks (Gross wages $650 and PAYG Withholding $48). Cash sale (paid by EFTPOS) at standard price: 11 3 x Smart Cover Leather (SCL), 1 x ePhone (EPN), and 2 x ePod Classic (EPC) 11 Credit sale to Glenview High School (PO # GHS6090) of 5 x ePad (EPD) at a special price of $440.00 each (Plus GST). 13 Received all the items ordered from Manx Ltd from Feb 6 together with their invoice # 6488 for $5,005.00. A Freight charge of $50.00 plus $5.00 GST is included in the Invoice. 14 Purchased stationary from Officeworks amounting to $198 (inclusive of GST). The purchase was made using Mastercard. 14 Placed an order for 5 ePad Power Adaptor (EPA) items from Accessorise for $50 (plus GST). The adaptors and invoice # 232 arrived by close of business. 15 Sent Cheque # 1226 for $9,548.00 to Visual Corporation in payment of the amount owing to them. MYOB Assignment Semester 2 2016 Page 2 15 Credit sale on terms net 7 days to Seaside Art Gallery, 29 Marine Terrace, Glenelg SA 5045 (PO # 4364): ABN 91007690690 at standard prices (plus GST) 4 x ePan Camera USB (EPU), 10 x Earphones (EAR), 2 x ePod Shuttle (EPS) 15 Paid Manx Ltd with cheque # 1227, clearing the amount/s owing to this supplier less prompt payment discount where applicable. 18 Purchased a Van for $66,000 (inclusive of GST), E-generation was successful with their bank loan application to fund this purchase. The bank paid the full purchase price directly to the motor vehicle vendor. Hint add any new accounts you need to process this transaction 21 Seaside Art Gallery returned 2 x Earphones (EAR) items. We accepted this return from one of new customers. Prepare and send them adjustment note # 1790 for these items. 22 Wrote cheque # 1228 today to Emma Tomlinson to pay two weeks' net wages. Emma's pay was the same as last fortnight. 22 Received a cheque for $869.00 from Seaview Medical Practice. The cheque was banked by close of business. 23 Received the electricity bill from Eagle Power for $770.00 (inclusive of GST). This was paid on the same day with Cheque # 1229 24 The owner withdrew $2,000 for personal use. Cheque #1230 Cash sales at the standard price: 1 x ePod Classic (EPC), and 2 x ePod Shuttle (EPS) 24 The cash from this sale did not get banked by close of business and was kept in the safe overnight and banked the next day. Feb 25 Mt Gilmore Mining Corp paid their outstanding balance in full. The cheque from Mt Gilmore was banked together with the cash in the safe on the same day. 27 Complete the bank reconciliation for February. Use the necessary information provided to you in this assignment. 28 Record the following adjusting entries and include your calculations in the memo field of each entry. Note: Calculations for depreciation and amortisation are to the nearest dollar (round up for 50 cents) , and for superannuation and interest it is to the nearest cent (round up for cent). Base calculations on months, not days except for items that have been purchased during the month. The remaining prepaid insurance was consumed during the month. Wages are paid fortnightly on Friday for the fortnight just worked (up to and including the Friday). The next wages payment will be made on 6th March, 2015. Calculate the amount of wages payable at the end of February. Depreciation of Furniture & Equipment for the month is calculated using the straight line method and a rate of 15% per annum. Depreciation is calculated on the historic cost. Hint use months to calculate this figure not days. MYOB Assignment Semester 2 2016 Page 3 Interest on the bank loan is 6.5% pa. Calculate and record the interest on the loan for the month (GST free). Note any repayments occurred after the interest was charged by the bank. Hint use months to calculate this figure not days. The calculation of amortisation of leasehold improvements for the month is based on the term of the lease which is 5 years. Hint use months to calculate this figure not days Interest on the Van loan is 9% p.a. Calculate and record the interest on the loan for the month (GST free). The interest on the loan is calculated on a daily rate for the number of days left in February since the loan commenced. Hint: Include the day the loan was taken out and the last day of the month. e.g. if the loan was taken out on the 25th and the last day of the month is the 28th then this is 4 days. Depreciation on the Van is calculated using a Straight Line method and a rate of 20% per annum. The depreciation for February is based on the number of days the Van was owned in the month of February. Superannuation is accrued at 9.5% of the gross salaries paid for the month of February. Bank of Adelaide ABN 25 289 475 123 e-Generation 720 Anzac Highway Glenelg SA 5045 BSB No: 610-110 Account No: 346790 Page: 1 of 1 Statement Date: Debit 1/02/2015 2/02/2015 3/02/2015 4/02/2015 6/02/2015 8/02/2015 10/02/2015 11/02/2015 16/02/2015 20/02/2015 22/02/2015 23/02/2015 24/02/2016 25/02/2016 Opening balance Cheque 1220 Bank Fees Cheque 1223 Deposit Cheque 1224 Cheque 1225 Deposit Cheque 1226 Cheque 1227 Deposit Cheque 1228 Cheque 1230 Deposit 28 February 2015 Credit 12,390.00 10.00 1,320.00 13,350.25 227.00 602.00 1,149.50 9,548.00 10,338.02 869.00 602.00 2,000.00 7,282.00 33,907.66 21,517.66 21,507.66 20,187.66 33,537.91 33,310.91 32,708.91 33,858.41 24,310.41 13,972.39 14,841.39 14,239.39 12,239.39 19,521.39 28/02/2015 Van Loan repayment 2,000.00 17,521.39 28/02/2015 Bank Loan Repayment 1,000.00 16,521.39 MYOB Assignment Semester 2 2016 Page 4 ASSIGNMENT SUBMISSION REQUIREMENTS You are required to submit the following before 8:00pm on Wednesday 5 October 2016. When you upload this file at the electronic submission point on blackboard you will be agreeing that: Please refer to the criteria sheet on blackboard to ensure you meet the full requirements of this assessment. The file submitted is your own work and that you have not colluded or collaborated in the completion of this assignment, nor have you provided any material or assistance in the completion of another's assignment. You must have used your own UserID during the January & February transactions for e-generation and you must have turned on the Audit tracking at the start of the MYOB work. If you have not done this you will be penalised in the second criteria on the criteria sheet. Submit at the BB submission point: 1. A pdf version of the following MYOB reports (each report should be submitted separately) Tip: MYOB reports can be produced in PDF by choosing \"send to pdf\" button when you display a report. Report 1: Trial Balance as at 28th February, 2015 Report 2: Reconciliation Report for the Bank of Adelaide Cheque Account, as at 28th February Report 3: Detailed Ledger for Undeposited Funds account ONLY for February, 2015 Report 4: Transaction Report for General Journal for February (choose from reports/accounts) The Memo field for each entry should show how the figures were calculated. Report 5: January Trial Balance Report 6: Audit Trail Report from 1/1/2010 until 1/12/2016 o Select Reports Accounts Audit Trail Audit Trail Report and select Customise to enter the date range Print TIPs re: creating reports Don't include accounts with zero balances Don't include additional reports Print in Portrait orientation Dates must be in Australian format (dd/mm/yy) Amounts must be in $ 2. Your final MYOB data file This file should be the final .MYO data file that represents the reports that you are submitting for this assignment. Please note penalties apply for a submitting an incorrect file or no file 3. In the MYOB assignment Folder there will be two quizzes you will need to undertake once you have submitted your reports and .myo file to the blackboard submission point. Further details on the quizzes will be provided prior to the submission date. MYOB Assignment Semester 2 2016 Page 5