代写 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