代写 FNSACC406A accounting system assignment

  • 100%原创包过,高质量代写&免费提供Turnitin报告--24小时客服QQ&微信:273427
  •  代写 FNSACC406A accounting system assignment


    Assessment Task 1- Project
     
    Assessor Task Instructions
    These instructions must be followed when assessing the student in this unit.  The checklist on the following page is to be completed for each student.  Please refer to separate mapping document for specific details relating to alignment of this task to the unit requirements.
    Date: Assessor to advise
    Duration: 3.0 Hours
    Location:        Baxter Institute level 2, 228 flinders St, in a designated class room. 
     
    Assessor to give the following tasks to students
     
    The month for this exercise is July 2013.
     
    1. Create a new company file.
     
    Use the Setup menu, Company Information item and change the business address to:
    ‘Your full name—Assessment HL01’.
     
    The Goods and Services Tax (GST) is set at 10%. The tax code is GST (unless otherwise stated). Note: ALL GOODS AND SERVICES in this exercise are taxable.
     
    Below is the balance sheet for Sam’s Technology as at 1 July 2013. You will need to record these details as opening balances in your MYOB data file:
     
    Assets
             Current Assets
                       Cash on Hand
                                South Bank        44 750.75
                       Accounts Receivable
                                Accounts Receivable         5 520.00
                       Prepayments              200.00
                       Prepaid Workcover Insurance  5 000.00
                       Inventory 16 755.66
             Non Current Assets
                       Office Equipment
                                Office Equipment at Cost  4 500.00
                                Office Equipment Accum. Dep’n                 –750.00
                       Computer Equipment
                                Computer Equipment at Cost     7 850.00
                                Computer Equipment Accum. Dep’n –1 355.00
                       Motor Vehicles
                                Motor Vehicles at Cost      21 500.00
                                Motor Vehicles Accum. Dep’n   –15 500.00
    Total Assets                                            $88 471.41
     
    Liabilities
             Current Liabilities
                       Accounts Payable                        23 985.00
                       GST Liabilities
                                GST Collected   1 201.00
                                GST Paid   –4 764.59
                       Total GST Liabilities   –-3 563.59
             Non Current Liabilities
                       Bank Loans        35 000.00         
    Total Liabilities                              $55 421.41
    Net Assets                                               $33 050.00
     
    Equity
             Capital                                   33 050.00
    Total Equity                                             $33 050.00
     
    2. General Journal: Post a general journal entry to record the additional capital contributed by the owner on 15/7/2013. This comprised a motor vehicle with a value of $30 000 and office equipment valued at $5000.
     
    3. Create the following cards.
     
    Customer
    Rooftop Computers (Card ID: Cust03)
    Address for both billing and delivery: 123 Splash Street, Mt Riverview NSW 2754. Telephone number is: (02) 9555 1419 and fax number is (02) 9555 2255. Salutation is Robyn and the contact person is R. Banks. No e-mail address. Credit terms are 30 days from date of invoice with a credit limit of $40 000 and 2% discount for early payment within 7 days. Sales layout: Service. Printed form: ‘Tax Inclusive Plain Paper Invoice’. Tax code (& Freight) = GST. ABN 40 901 198 611.
     
    Supplier
    Alleyway Components Ltd (Card ID: Supp01)
    No second address or e-mail address: 111 Woodstock Parade, Bollard Vic 3223.
    Telephone (03) 9555 3321, Fax (03) 9555 5571. Salutation is Ms Tree. Identifier is ‘T’. The credit limit is $85 000. Credit terms are net 30 days after end of month. ABN 85 854 290 290. Tax code: GST.
     
    Where necessary, create cards (with the only detail being the name) in order to record the following balances and transactions:
     
    Enter the following historical customer balances at 1 July 2013 (Tax code = GST):
    Blindfold Computers INV # 3909 13/4/2013 $125.00
    Zap Electronics INV # 5122 29/5/2013 $1 486.50
    Zap Electronics INV # 5134 28/6/2013 $2 480.80
    Rooftop Computers INV # 5135 29/6/2013 $1 427.70
     
    Enter the following historical supplier balances at 1 July 2013 (Tax code = GST):
    Telegraph Enterprises PO # 3000 1/6/2013 $2 037.00
    Twigg Technology PO # 3021 14/6/2013 $9 268.00
    Boom Components PO # 3010 6/6/2013 $12 680.00
     
    Using the ‘Service’ invoice layout, record the following sales (all amounts are tax inclusive):
    代写 FNSACC406A accounting system assignment
    Note: For all of the following invoices, select the appropriate income account for each item sold. For example, computer systems sales, use the income account ‘4-1100 Sales—Computers’ and for software sales, use ‘4-1200 Sales—Software’.
     
    Invoice #5136 dated 6 July 2013 to Zap Electronics. Their P.O. #1228. The sale was for a Computer System $4235 incl. GST together with bundled software $638.00 incl. GST. These goods were picked up (no freight charges).
     
    Invoice #5137 dated 20 July 2013 to Rooftop Computers. Their P.O. #11256. The sale was for a Computer System $4200 incl. GST. The carrier was International Freight: $35.00 incl. GST.
     
    Invoice #5138 dated 29 July 2013 to Zap Electronics. Their P.O. #1231. The sale was for two Computer Systems at $4235 each incl. GST plus with bundled software $1,276.00 incl. GST. These goods were picked up.
     
    Invoice #5139 dated 31 July 2013 is a Cash Sale. No P.O. number. Use account ‘4-1300 Sales—Other’ for all of the following items. The sale was for a HP Printer CP2000 and Cables $187 incl. GST. A box of black toner for CP2000 $55 incl. GST as well as a box of colour toner $71.50 incl. GST. Goods were picked up and the total of the invoice was paid in cash. Enter the total in the field ‘Paid Today’.
     
    4. Write off the outstanding balance by Blindfold Computers.
     
    Issue a credit note for the outstanding unpaid balance of this customer. Debit ‘Bad Debts’ account—ignore the warning. Use the ‘Miscellaneous’ layout for this credit note:
     
    Reminder: Enter all amounts for credit notes as negative!
     
    Customer C/Note # Date Amount Tax Apply to
    Blindfold Computers CN1 1/7/2013 $125.00 GST Inv. #3909
     
    After applying this credit note to invoice 3909, access the customer’s card and make it inactive.
     
    Issue the following credit notes to record the correction of overcharges for the outstanding unpaid balance of these customers.
     
    Use a ‘Service’ layout for these credit notes. Record these amount against ‘4-1100 Sales—Computers’.
     
    Customer C/Note # Date Amount Tax Apply to
    Zap Electronics CN2 10/7/2013 $97.46 GST Inv. #5136
    Rooftop Computers CN3 29/7/2013 $66.00 GST Inv. #5135
    (credit to be refunded)
     
    Remember to record the refund for this credit note (cheque number 301629 dated 29/07/2013).
     
    5. Record the following receipts from customers:
     
    Note: All receipts are paid by cheque. Cheque details have not been provided as they are not required for this exercise. Ensure that the finance charge is $0.00 for each receipt. Enter dates correctly to automatically calculate the discount. Use the undeposited funds account to group receipts on the same date and then prepare a single bank deposit to the bank. All other deposits can be recorded directly to the bank account.
    Customer Date Amount Apply to inv. # Discount
    Zap Electronics 9/7/2013 2480.80 5134 0.00
    Rooftop Computers 9/7/2013 1427.70 5135 0.00
    Zap Electronics 15/7/2013 1486.50 5122 0.00
    Zap Electronics 21/7/2013 4775.54 5136 0.00
    Rooftop Computers 22/7/2013 4150.30 5137 84.70
             
    6. Enter the following purchases:
     
    Purchase # 3031 dated 3 July 2013 from Daye Solutions. Their invoice # is 3221. Details are ‘Supply computer components as per specifications’. The amount is $5489 (incl. $499.00 GST). Debit ‘5-2000 Purchases’.
     
    Purchase # 3032 dated 10 July 2013 from Silt Solutions. Their invoice # is G210. Details are ‘Supply computer cases as per specifications’. The amount is $5005 (incl. $455.00 GST). Debit ‘5-2000 Purchases’. This will be ‘paid today’. After recording this purchase, click OK to accept the advice about the cheque number).
     
    Purchase # 3033 dated 17 July 2013 from Papers ‘R Us Supplies Pty Ltd. Their invoice # is 4426. Details are ‘Stationery supplies as per order’. The amount is $748 (incl. $68.00 GST). Debit ‘6-1500 Office supplies’.
     
    Purchase # 3034 dated 20 July 2013 from Highwater Movers Pty Ltd. Their invoice # is I443. Details are ‘Supply computer packaging as per specifications’. The amount is $5854.09 (incl. $532.19 GST). Debit ‘5-2000 Purchases’.
     
    Purchase # 3035 dated 26 July 2013 from Alleyway Components Ltd. Their invoice # is 21030. Details are ‘Supply assorted cables as per order’. The amount is $5489 (incl. $499.00 GST). Debit ‘5-2000 Purchases’.
     
     
    7. Record the following payments to suppliers:
     
    Date Payee Amount Cheque # For:
    8/7/2013 Twigg Technology 9268.00 301624 Purchase 3021 dated 14/6/2013
    9/7/2013 Daye Solutions 5379.22 301625 Purchase 3031 dated 3/7/2013
    15/7/2013 Boom Components 12680.00 301626 Purchase 3010 dated 6/6/2013
    22/7/2013 Telegraph Enterprises 2037.00 301627 Purchase 3000 dated 1/6/2013
    26/7/2013 Highwater Movers 5854.09 301628 Purchase 3034 dated 20/7/2013
    31/7/2013 Papers ‘R Us 594.00 301630 Payment on account
     
    Record the following debit notes (credit notes received from suppliers and apply them as instructed):
    Date Supplier Amount Debit note # Applied to:
    20/7/2013 Silt Solutions 462.00 112 Order 3021 dated 10/7/2013 for overcharge. Note: We have also received a refund cheque for this.
    Record the refund date as 20/7/2013 on the credit note received.
     
    29/7/2013 Papers ‘R Us 154.00 113 Return of stationery incorrectly supplied on purchase 3033
    29/7/2013 Daye Solutions 109.78 114 Discount received (account 8-2000) applied to purchase 3031
     
     
    8. Prepare and attach the following printouts to this assessment:
    •  Card list detail for Rooftop Computers.
    •  Trial balance as at 31st July 2013.
    •  Sales invoices 5137 and 5138 as plain paper tax inclusive invoices.
    •  Aged receivables detail at 31st July 2013 including 0.00 balances.
    •  Statements for Zap and Rooftop; select Activity type statements from 1/5/2013 to 31/7/2013 including customers with
        zero balances using the form ‘MYOB Plain paper Statement’.
    •  The following transaction journals for July 2013:
             –  Sales and receivables
             –  Cash receipts
             –  Cash disbursements
             –  Purchases and payables journal.
    •  Purchase number 3034 (MYOB plain paper).
    •  Aged payables detail at 31 July 2013 including 0.00 balances.
    •  A detailed report for Silt Solutions account for July 2013 (use Find Transactions/Card select supplier, enter date range and
        print).
    ·       Back up the data and exit MYOB
    ·       Restore the data on another computer to check if the back up is working
     
     
    Suggested Answers:
     
    is given in a separate file on the LMS under trainers resources under file name “Assessment 1-Solutions(MYOB file).myo
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
    Assessment Task 2- Project
     
    Assessor Task Instructions
    These instructions must be followed when assessing the student in this unit.  The checklist on the following page is to be completed for each student.  Please refer to separate mapping document for specific details relating to alignment of this task to the unit requirements.
    Date: Assessor to advise
    Duration: 3.0 Hours
    Location:        Baxter Institute level 2, 228 flinders St, in a designated class room. 
     
    Assessor to give the following tasks to students
     
     
    L Bowjoint is the owner of ‘Round the Bend Irrigation Supplies’. L Bowjoint wishes to convert the company’s existing manual accounting system to a computerised system (MYOB) to start on 1 July 2013 (financial year 2014).
     
    1. Create a new MYOB Database using the following information.
    Company Details:                Round the Bend Irrigation Supplies - Your Name
      10 Flower Road
    GARDEN CITY VIC  3207
                                                   ABN: 82 999 333 124
     
    Choose an existing MYOB account list using:
             Industry classification:          Other
    Type of business:                  Sole Proprietor
     
    2. Set up the general ledger and, using a general journal, enter the account opening balances using the Trial Balance as at 1 July 2013 as below:
     
    Round the Bend Irrigation Supplies
    Trial Balance as at 1 July 2013
    Account No. Account Name DR CR
    1-1110 South Bank—Cheque Account 14 000  
    1-1200 Accounts Receivable 4 400  
    1-1300 Inventory 18 400  
    1-2200 Pre-paid Expenses—Advertising 1 080  
    1-3110 Business Equipment at Cost 21 000  
    1-3120 Business Equipment Accumulated Depreciation   6 328
    2-1200 Accounts Payable   4 125
    2-1310 GST Collected   400
    2-1330 GST Paid 375  
    2-1800 Bank Loan   15 250
    3-1100 Capital—L Bowjoint   38 280
    3-1200 Drawings—L Bowjoint 25 000  
    4-1100 Sales Connectors   25 000
    4-1200 Sales Tower units—Riser units   45 000
    4-1300 Sales—25 m hose lengths   14 000
    4-3300 Commissions Received   600
    5-1100 Cost of Sales—Connectors 13 000  
    5-1200 Cost of Sales—Tower units/Riser units 22 000  
    5-1300 Cost of Sales—25 m hose lengths 7 000  
    6-1000 Advertising 540  
    6-1150 Bank Charges 23  
    6-1200 Delivery Vehicle Expenses 2 340  
    6-2330 Wages and Salaries 19 200  
    6-2700 Telephone 625  
    TOTAL   148 983 148 983
     
     
    3. Set up the Sales Module using the following information:
    ·         Item invoices are used to process sales transactions.
    ·         Credit terms for ALL customers as follows:
    Credit Limit:  $20 000    Tax Code:          GST
    Freight Tax Code:  GST            Payment Method:     Cheque
    Payment due 30 days from date of invoice
    No prompt payment discount
    ·         Account for customer receipts is Undeposited Funds as Round the Bend Irrigation Supplies deposits fund daily to South Bank.
     
    Enter the following customer details:
     
    Name Address Postcode ABN
    Greener Gardens 123 Hume Highway, GRASSBLADE 3482 77 222 666 888
    Lawn Lovers 92 Las Tmai Way, MOWTOWN 3109 11 999 222 111
    Nomore Hosing 77  Sunset Strip, BRANCHVILLE 3642 22 333 444 555
    Dust Settlers 742 Evergreen Terrace, SPRINGFIELD 3307 66 777 888 999
     
     
    Set up ‘Cash Sales’ as a customer so that an invoice can be created for Cash Sales. Terms for Cash Sales are Credit Limit $0.00 and payment COD by cash.
     
    Enter the following outstanding customer balance details:
                01/07/13 Inv# 381   Order# 605       Dust Settlers               $4400
     
    4. Set up the Purchases Module using the following information.
    ·         Item invoices are used to process purchase transactions.
    ·         Credit terms for ALL suppliers as follows:
    Credit limit:   $20 000    Tax code:           GST
    Freight tax code:   GST   Payment method:     Cheque
    Payment due 30 days from date of invoice
    No prompt payment discount.
     
    Enter the following supplier details:
     
    No. Name Address Postcode ABN
    1 Goode Connections 43 Cherry Street, LANGLEY FALLS 3111 98 765 432 111
    2 Rose’s Hoses 4222 Clinton Way, BRADYTOWN 3516 58 428 456 777
    3 Plumbed by Bob 21 Pinoak Court, VERMONT SOUTH 3209 34 567 891 222
    4 Fine Fittings 698 Sycamore Road, SANDPEBBLES 3760 12 345 678 999
     
     
    Enter the following Supplier outstanding balance details:
                01/07/13 Order# 499       Inv# 6758 Plumbed by Bob        $4,125
     
     
    5. Set up the Inventory Module. Access help feature available within MYOB to see the procedure to add new inventory.
     
    Set up the following inventory items and enter the opening inventory.
    Item No. Name Selling price
    (ex-GST)
    Buy/sell tax code Buy/sell units Minimum level Reorder qty Qty on hand Total
    value
    $
    Cost per unit
    201 Connectors $10 GST Each 200 100 760 $3 800    5.00
    202 Riser units $20 GST Each 100 100 740 $7 400   10.00
    203 Tower units $25 GST Each 100 100 500 $6 000   12.00
    204 25 m hose lengths $15 GST Each 50 50 150 $1 200    8.00
                    $18 400  
     
     
    6. Enter Transactions for July 2013: Note: All Sales and Purchases are subject to GST.
     
    3/7/13                   Invoice no. 400 credit sale to Nomore Hosing on order no. 242
                                    100  Connectors
    110  Riser units
     
    4/7/13                   Purchase order no. 500 credit purchase from Goode Connections on Invoice no. 234
                                    20 × 25 m hose lengths @ $8 each (excl. GST)
     
    5/7/13                   Invoice no. 401 credit sale to Greener Gardens on order no. 603  - 20 Connectors
     
    8/7/13                   Cheque number 2344 for $484 (including GST) L Bowjoint (owner) pays home electricity account to Sparkpower
     
    9/7/13                   Purchase order no. 501 purchase return to Goode Connections on CRN # 45 (reference purchase no. 500) 2 × 25 m hose lengths—damaged in transit
     
    11/7/13                 Cheque number 2345 for $3200 (incl. GST) For purchase of new computer system from Sam’s Technology
     
    14/7/13                 Receipt number CR000001 for $3344.  Cheque payment received from Nomore Hosing for inv # 400 after discount allowed AND Receipt number CR000002 $550 (incl. GST)
    Cheque received from Dishe & Spoone for commission received
     
    15/7/13                 Invoice no 403 sales return from Greener Gardens refer invoice no 401, order no 603
    5 connectors—wrong size supplied
     
    19/7/13                 Memo: delete supplier account—Fine Fittings
     
    23/7/13                 Cheque no. 2346 for $320 (incl. GST)
    Paid Phonetel monthly telephone account


    25/7/13                 Purchase no. 502 credit purchase from Rose’s Hoses on invoice no. 338

    100 Tower units @ $12 each (excl. GST)
     
    29/7/13                 Invoice no. 404 credit sale to Lawn Lovers on order no. 538

    50 Riser units
    75 Tower units
     
    30/7/13                 Cheque no. 2347 payment to Goode Connections for balance owing
     
    31/7/13                 Receipt no. CR000003 cheque payment received from Greener Gardens for balance owing
    AND

    Invoice no. 405 Cash Sales
    5 Connectors
    3 Riser units
     
    31/7/13                 Memos:
    ·         A review of the accounts after converting to MYOB revealed that the end-of-period adjustment entered 30/6/11 for prepaid advertising had not been reversed 1/7/13. Enter the following general journal to correct the error:
    Dr    6-1000 Advertising                               $1080
             Cr 1-2200 Prepaid Expenses—Advertising                  $1080
     
    ·         Write off Dust Settlers account balance as a bad debt.
            
    7. Complete July end-of-month stock take. Stocks on hand as per physical stock take:
     
    Item no. Quantity
    on hand
    Value
    201 639 $3195
    202 577 $5770
    203 525 $6300
    204 167 $1336
     
     
    8. Reconcile the Cheque Account using the end-of-month bank statement shown below:
        (a) After reconciling take a back up
        (b) Restore the back up to another computer to check if the back up file is working
     
    SOUTH BANKING CORPORATION

    STATEMENT OF ACCOUNT


     
    Round the Bend Irrigation Supplies
    10 Flower Road
    GARDEN CITY VIC  3207
                   Account:    86753-09523
                       Date:      31/07/2013
    Date Particulars Debit Credit Balance
    01-JUL-2013 Brought Forward     14 000.00 CR
    02-JUL-2013 Account Keeping Fee 5.00   13 995.00 CR
      Transaction Fee 6.07   13 988.93 CR
    09-JUL-2013 2344 484.00   13 504.93 CR
    11-JUL-2013 2345 3 200.00   10 304.93 CR
    19-JUL-2013 Deposit   3 894.00 14 197.93 CR
    30-JUL-2013 2346 320.00   13 878.93 CR
    31-JUL-2013 Deposit   286.00 14 164.93 CR
      Interest   3.02 14 167.95 CR
    Proceeds of cheques will not be available until cleared. Please check all entries promptly and notify the Bank immediately of any errors
     
     
     
     
     
    9. Print the following reports:
     
    (a)  Bank Reconciliation Statement 31/7/13
    (b)  Trial Balance as at 31/7/13 (customise to show account numbers)
    (c)  Aged Receivables—Detail for 31/7/13
    (d)  Aged Payables—Detail for 31/7/13
    (e)  Card List—Summary (customised to show suppliers only)
    (f)   Items List—Detail (customise to include reorder and min. level fields)
    (g)  Balance Sheet as at 31/7/13
    (h)  Transaction Journal for ALL Journals (1/7/13–‑31/7/13)
     
     
    Suggested Answers:
    代写 FNSACC406A accounting system assignment