computerised accounting system | Assignment Freelancers

Course Code and Title	FNS40217 Certificate IV in Accounting and Bookkeeping
Unit/S Code & Title	FNSACC416 – Set up & operate a computerised accounting system
Learner Name:
Trainer Name:
Date:
Mode Of Submission:	 By hand to assessor  By email to assessor  By Austpost to TMG

Instructions for the Learner
• Please complete your details in the table above, including the date and mode of submission.
• You MUST keep a copy of all assignments before submitting them for assessment.
• This form MUST be attached to all submitted written work with all sections completed. An incomplete
form may result in a delay in the assessment decision-making process for the assignment.
• Please securely attach the completed form to your submitted work after signing the declaration
below:

COMPULSORY LEARNER DECLARATION DETAILS:

Plagiarism
Plagiarism is the act of representing as one’s own original work the creative works of another,
without appropriate acknowledgment of the author or source.
Collusion
Collusion is the presentation by a learner of an assignment as his or her own which is in fact
the result in whole or in part of unauthorised collaboration with another person or persons.
Collusion involves the cooperation of two or more learners in plagiarism or other forms of
academic misconduct.
Both collusion and plagiarism can occur in group work. For examples of plagiarism, collusion
and academic misconduct in group work please see the TMG’s policy on Academic
Honesty and Plagiarism www.tmg.edu.au
Plagiarism and collusion constitute cheating. Disciplinary action will be taken against
learners who engage in plagiarism and collusion as outlined in TMG’s policy.
Proven involvement in plagiarism or collusion may be recorded on learners’ academic file
and could lead to disciplinary action.

LEARNER DECLARATION
Please tick to indicate that you understand the following statements:
I declare that:
 This assignment is my own original work, except where I have appropriately cited the original
source (Appropriate citation of original work will vary from discipline to discipline).
 This assignment has not previously been submitted for assessment in this or any other subject.
 I have kept a copy of this assignment.
For the purposes of assessment, I give the assessor of this assignment the permission to:
 Reproduce this assignment and provide a copy to another member of staff; and
 Take steps to authenticate the assignment, including communicating a copy of this
assignment to a checking service (which may retain a copy of the assignment on its database
for future plagiarism checking).
Learner signature __________________________Date _________________________

Learner Name:

Learner ID No:

Instructions
This record is to be completed by the assessor and used as a final record of learner competency for the unit of
competency: FNSACC416 – Set up & operate a computerised accounting system
The Trainer/Assessor is required to complete this assessment task outcome record when:
• the learner has completed and submitted all requirements for the assessment task for this FNSACC416 – Set
up & operate a computerised accounting system of competency
• All assessment tasks submitted by the learner and are retained to establish Competence has been
reviewed and assessed by the Trainer/Assessor as Satisfactory / Not Satisfactory.
• Relevant and detailed feedback has been provided to learner.

Assessment Summary
This section is to be complete once all assessment tasks have been finalised.

Evidence Recorded	Was sufficient evidence recorded for each task (please circle)
Assessment 1	Written Question	Satisfactory / Not Yet Satisfactory
Assessment 2	Project	Satisfactory / Not Yet Satisfactory
Final Assessment Result for FNSACC416 – Set up & operate a computerised accounting system	Competent /Not Yet Competent

Feedback to Learner
Please provide general feedback on the Learner’s performance for the unit/s. Specific tasks related feedback should be
recorded throughout this tool in the provided space within each task.

Learner Signature:	Date:
Assessor Signature:	Date:

ADMINISTRATIVE USE ONLY
Entered onto Learner Management Database

Entered on VETTrack:	Admin Signature:
Date:	Admin Name:

Learner Name	Learner ID
Course Code And Title	FNS40217 Certificate IV in Accounting and Bookkeeping
Unit/s Code & Title	FNSACC416 – set up & operate a computerised accounting system
Trainer/Assessor Name

• This pack includes all the assessment tasks you will need to successfully complete in order
to be competent in the unit/s of competence listed above.
• There are three (3) assessment tasks in this pack. To attain competence in the unit/s you
must:
 Successfully complete all written questions in this assessment pack
 Successfully complete and submit the project outlined in the assessment guide
 Successfully demonstrate skills as directed by your Assessor
• In order to be assessed as competent (C) in this unit, you need to provide evidence that
demonstrates you can perform the required competencies to the required standard.
• Competency depends on consistently demonstrating the skills, attitudes and knowledge
that enable you to complete workplace tasks confidently in a variety of situations.
• You must record your written responses in this assessment pack. You can attach additional
pages if required.
• You are entitled to have two more assessment attempts for each assessment task within a
unit.
• The resources required for these assessment tasks are:
 Officelink Learner Guide
 Computer with internet and printer access
 office equipment and resources
 examples of documentation relating to the project and the practical exercise
 MYOB application
TMG Assessment Coversheet &
Learner Assessment Pack
tmg.edu.au | 1300 888 TMG (1300 888 864)
The Malka Group Pty Ltd Trading as TMG College Australia | Registered Training Organisation #21694 | CRICOS Provider Code 03397E
Document Type: DC-1262 TMG Assessment Coversheet & Learner Assessment Pack
Version 7.3.1 Release Date: May 2019 Page 5 of 38
Unit details: FNSACC416 – set up & operate a computerised accounting system
Assessment Task 1 – Written Questions

Pre Assessment Checklist for Trainer/Assessor to fill:
This checklist is to be completed prior to commencing the assessment. Please discuss this with the Learner and circle yes or no for each question.
Is the Learner ready for assessment?	Yes / No
Have you explained the assessment process and tasks?	Yes / No
Does the Learner understand which evidence is to be collected and how?	Yes / No
Have the Learner’s rights and the appeal system been fully explained?	Yes / No
Have you discussed any special needs or reasonable adjustments to be considered during the assessment?	Yes / No
Does the Learner have access to all required resources?	Yes / No

Due Date:
As per the timetable/ Training Plan
Description of assessment task to be completed:
• This is No. 1 of 3 assessment tasks you need to successfully complete to be
deemed competent in this unit.
• In this assessment you must answer 19 questions on setting up and operating
the computerized accounting system
• This assessment is completed out of class as homework
• You must answer all questions within specified range of 50-100 words
• You must respond to all questions and submit them to your Assessor.
Conditions of assessment:
• This is an individual/group assessment, an open ‘book’ assessment, written
assessment.
• You will need to complete this task independently.
• No marks or grades are allocated for this assessment task. The outcome of the
task will be Satisfactory or Not Satisfactory.
• You are entitled to have two more assessment attempts for each assessment
task within a unit
• You must speak to your Assessor if you have any difficulty in completing this
task and require reasonable adjustments (e.g. can be given as an oral
assessment, how they must submit the assessment e.g. upload to Canvas)
TMG Assessment Coversheet &
Learner Assessment Pack
tmg.edu.au | 1300 888 TMG (1300 888 864)
The Malka Group Pty Ltd Trading as TMG College Australia | Registered Training Organisation #21694 | CRICOS Provider Code 03397E
Document Type: DC-1262 TMG Assessment Coversheet & Learner Assessment Pack
Version 7.3.1 Release Date: May 2019 Page 6 of 38
Unit details: FNSACC416 – set up & operate a computerised accounting system
Written Questions:
1. List the minimum data required to create a company file.

•

2. List the six (6) types of accounts which make up your Chart of Accounts?

•	•
•	•
•	•

3. List three (3) sources of help for your accounting package.

•

4. When would you enter a general journal adjustment in an accounting package?
TMG Assessment Coversheet &
Learner Assessment Pack
tmg.edu.au | 1300 888 TMG (1300 888 864)
The Malka Group Pty Ltd Trading as TMG College Australia | Registered Training Organisation #21694 | CRICOS Provider Code 03397E
Document Type: DC-1262 TMG Assessment Coversheet & Learner Assessment Pack
Version 7.3.1 Release Date: May 2019 Page 7 of 38
Unit details: FNSACC416 – set up & operate a computerised accounting system
5. List four (4) methods you can use to view transactions to check the accuracy.
6. Why is it useful to lock dates for year end?
7. At any time throughout the system, customers, suppliers, employees and the
chart of accounts can be either edited or added to. Circle your choice.

TRUE

FALSE

8. From the reports listed below, which reports indicate the financial performance
of an organisation? Circle your choices.

• Trial Balance	• List of Customer Addresses
• Balance Sheet	• Profit & Loss
• Stock Item Listing	• Tax Invoice
• Inventory Reconciliation Report	• Bank Reconciliation Report

9. If a company must remit GST to the ATO, it can be reported on the Quarterly BAS
statement. Circle your choice.

TRUE

FALSE

TRUE

FALSE

11. Which report is printed as proof that the accounting system reconciles with the
bank statement?
12. List essential actions bookkeepers must take to comply with the Privacy Act when
using an accounting system:
13. How often should you backup your company files and why is the backup
procedure important?
TMG Assessment Coversheet &
Learner Assessment Pack
tmg.edu.au | 1300 888 TMG (1300 888 864)
The Malka Group Pty Ltd Trading as TMG College Australia | Registered Training Organisation #21694 | CRICOS Provider Code 03397E
Document Type: DC-1262 TMG Assessment Coversheet & Learner Assessment Pack
Version 7.3.1 Release Date: May 2019 Page 9 of 38
Unit details: FNSACC416 – set up & operate a computerised accounting system
14. List below the period end type adjustments which an Accountant may ask you
to record. Describe what type of transaction is usually used.
15. When viewing cash and credit source documents, why must you collate and
analyse them first?
16. List key features of desktop and cloud based computerised accounting
software.
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
TMG Assessment Coversheet &
Learner Assessment Pack
tmg.edu.au | 1300 888 TMG (1300 888 864)
The Malka Group Pty Ltd Trading as TMG College Australia | Registered Training Organisation #21694 | CRICOS Provider Code 03397E
Document Type: DC-1262 TMG Assessment Coversheet & Learner Assessment Pack
Version 7.3.1 Release Date: May 2019 Page 10 of 38
Unit details: FNSACC416 – set up & operate a computerised accounting system
17. List key procedures which can be used in a computerised accounting software
package to record a business’s accounts
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
TMG Assessment Coversheet &
Learner Assessment Pack
tmg.edu.au | 1300 888 TMG (1300 888 864)
The Malka Group Pty Ltd Trading as TMG College Australia | Registered Training Organisation #21694 | CRICOS Provider Code 03397E
Document Type: DC-1262 TMG Assessment Coversheet & Learner Assessment Pack
Version 7.3.1 Release Date: May 2019 Page 11 of 38
Unit details: FNSACC416 – set up & operate a computerised accounting system
18. Summarise some of the key pieces of instruction or information that is required in
the organisation procedures to efficiently process a company’s accounts.
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
19. If you were unsure of whether a transaction requires GST to be claimed, where
could you go to ask for assistance? Which legislation could be referenced too?
Use the Internet to research your answer.
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
TMG Assessment Coversheet &
Learner Assessment Pack
tmg.edu.au | 1300 888 TMG (1300 888 864)
The Malka Group Pty Ltd Trading as TMG College Australia | Registered Training Organisation #21694 | CRICOS Provider Code 03397E
Document Type: DC-1262 TMG Assessment Coversheet & Learner Assessment Pack
Version 7.3.1 Release Date: May 2019 Page 12 of 38
Unit details: FNSACC416 – set up & operate a computerised accounting system
TMG Assessment Coversheet &
Learner Assessment Pack
tmg.edu.au | 1300 888 TMG (1300 888 864)
The Malka Group Pty Ltd Trading as TMG College Australia | Registered Training Organisation #21694 | CRICOS Provider Code 03397E
Document Type: DC-1262 TMG Assessment Coversheet & Learner Assessment Pack
Version 7.3.1 Release Date: May 2019 Page 13 of 38
Unit details: FNSACC416 – set up & operate a computerised accounting system
Assessment Task 2 – Project

Pre Assessment Checklist for Trainer/Assessor to fill:
This checklist is to be completed prior to commencing the assessment. Please discuss this with the Learner and circle yes or no for each question.
Is the Learner ready for assessment?	Yes / No
Have you explained the assessment process and tasks?	Yes / No
Does the Learner understand which evidence is to be collected and how?	Yes / No
Have the Learner’s rights and the appeal system been fully explained?	Yes / No
Have you discussed any special needs or reasonable adjustments to be considered during the assessment?	Yes / No
Does the Learner have access to all required resources?	Yes / No

Due Date:
As per the Timetable / Training Plan
Description of assessment task:
• This is No. 2 of 3 assessment tasks you need to successfully complete to be
deemed competent in this unit.
• In this assessment you are required to setup and operate a computerised
accounting software using MYOB.
• You need to read the project scenario and analyse and complete the given
tasks in this project.
• Assessment needs to be undertaken in out of class and submitted to your
Assessor.
• You will be assessed according to the response given based on the Project
Scenario.
Material and resource requirements:
• Computer with MYOB application, internet and printer access.
TMG Assessment Coversheet &
Learner Assessment Pack
tmg.edu.au | 1300 888 TMG (1300 888 864)
The Malka Group Pty Ltd Trading as TMG College Australia | Registered Training Organisation #21694 | CRICOS Provider Code 03397E
Document Type: DC-1262 TMG Assessment Coversheet & Learner Assessment Pack
Version 7.3.1 Release Date: May 2019 Page 14 of 38
Unit details: FNSACC416 – set up & operate a computerised accounting system
Conditions of assessment:
• This is an individual task, Learners can only receive minimum guidance from
their assessor during the project, all the tasks under this project must be
completed satisfactorily to the standard described.
• You will need to complete this task independently.
• No marks or grades are allocated for this assessment task. The outcome of the
task will be Satisfactory or Not Satisfactory.
• You are entitled to have two more assessment attempts for each assessment
task within a unit
• You must speak to your Assessor if you have any difficulty in completing this
task and require reasonable adjustments (e.g. can be given as an oral
assessment, how they must submit the assessment e.g. upload to Canvas,)
TMG Assessment Coversheet &
Learner Assessment Pack
tmg.edu.au | 1300 888 TMG (1300 888 864)
The Malka Group Pty Ltd Trading as TMG College Australia | Registered Training Organisation #21694 | CRICOS Provider Code 03397E
Document Type: DC-1262 TMG Assessment Coversheet & Learner Assessment Pack
Version 7.3.1 Release Date: May 2019 Page 15 of 38
Unit details: FNSACC416 – set up & operate a computerised accounting system
Project Scenario
You will set up your own retail shop which sells condiments for example, jams, sauces
and gift baskets. Please read the company policies and procedures before
commencing the tasks.

Policies and Procedures
Company details – Your Name Shop
Your Name Shop was incorporated on 1st January 2018 as a business that buys and
sells pickles, jams condiments to the public. You are the Director, owning 100% of the
shares. The company has an ABN and is registered for GST reporting quarterly on an
accrual basis. The business reports income tax on an accrual basis and does not take
advantage of the small business income tax concessions. Your company
Accountant is Fred Brae of Brae’s Accounting Solutions – he will assist with any
questions or concerns.
GST Legislation
When updating the chart of accounts, you may be required to link the accounts to
tax codes. You are to access this information from the ATO website or the Company
Accountant to ensure that the legislation is interpreted correctly.
You are required to use the AccountRight Invoice and Purchase order templates for
the respective transactions as these are designed taking into consideration GST
legislative requirements.
Inventory
Perpetual inventory is used for all stock. An item card is set up for each stock item.
There are no standard re-order quantities.
The inventory ledger should be reconciled with the balance sheet control a/c at the
end of each month by printing the inventory value reconciliation report. Any
discrepancies should be identified, and an appropriate adjustment made.
Purchases
1. Every purchase for inventory must be recorded in MYOB AccountRight by using
a supplier card.
2. Orders are generated automatically or keyed in and then printed or emailed
to the supplier.
3. Each purchase order will be numbered consecutively in MYOB AccountRight
and missing purchase order numbers must be accounted for.
4. The purchase order must contain a complete description of the goods

ordered and the price including GST if any, plus the delivery address and any
special delivery instructions.
5. When goods are received, the receiver must check that the goods are in
good order and condition. Goods must be checked against the purchase
order to make sure the correct goods and quantity have been delivered. If a
packing slip or delivery note was sent with the goods, this must be attached to
the purchase order and forwarded to the accounts department. If no packing
slip was received, a “goods received” slip must be completed and signed and
attached to the purchase order.
6. Any discrepancies in the order must be attended to immediately by the
bookkeeper after checking the tax invoice with the purchase order and goods
received slip or packing slip.
7. If goods are to be returned for any reason, a “goods returned” slip should be
completed and forwarded to the accounts department for entry into MYOB
AccountRight.
8. Should there be goods on backorder; a copy of the purchase order must be
kept in the store noting the goods on backorder. When goods are received,
the purchase order is then forwarded to the accounts department.
9. Any invoices received with the goods must be forwarded to the accounts
department immediately. It is the responsibility of the accounts department to
check the prices on the tax invoice and any calculations. The tax invoice is
then attached to the purchase order on file together with the delivery note or
goods received note as proof of delivery of the goods. The purchase order in
MYOB AccountRight should then be changed to a “bill”; at the same time
checking prices, the invoice total and entering the supplier’s tax invoice
number and invoice date.
10 A physical stock take is conducted to check on the accuracy of stock
numbers in the company file.
11. All source documents must be kept for 5 years. They can be archived.
Reconciliations
1. At the commencement of the company file the following accounts are to be
reconciled and any discrepancies are to be reported to the Accountant for
further instructions:
• Bank Account
• Debtors
• Creditors
• Inventory

• GST accounts
2. As a minimum, the Balance Sheet and Trial Balance reports must be sent to the
Accountant at the commencement of the company file and at the end of
each month.
3. When instructions are received from the Accountant to enter adjusting journal
entries, they must be recorded promptly. A Trial Balance should then be
printed and sent to the Accountant for approval.
Backup and Restore
1. When backing up your company file ensure that it is backed up onto an
external device, e.g. a USB stick. It must be named ‘yourname date month
year’, e.g. Phillips shop 010118.
2. You are not allowed to restore company files without the Accountants
permission.

TMG Assessment Coversheet &
Learner Assessment Pack
tmg.edu.au | 1300 888 TMG (1300 888 864)
The Malka Group Pty Ltd Trading as TMG College Australia | Registered Training Organisation #21694 | CRICOS Provider Code 03397E
Document Type: DC-1262 TMG Assessment Coversheet & Learner Assessment Pack
Version 7.3.1 Release Date: May 2019 Page 18 of 38
Unit details: FNSACC416 – set up & operate a computerised accounting system
TASKS
1. Create a company file for a retail condiment shop (e.g. jam, pickles) and name
your file Your Name Shop.myox.
• The file will commence on 01 May 2018 and its financial year is to June.
• Remember to select AccountRight Plus as the software being used and
Australia as the location.
• Use the ABN 34670301111
• Enter a serial number if you have one.
NOTE: If you do not have a serial number you will have only 30 days to use the file. If
this is the case another file is available for you which you can use to complete the
remaining tasks. Continue here to complete the creation of this file and then you will
get instructions on what to do.
2. Start the company file with a starter set of accounts provided by MYOB. Select
Retail as the Industry Classification.
TMG Assessment Coversheet &
Learner Assessment Pack
tmg.edu.au | 1300 888 TMG (1300 888 864)
The Malka Group Pty Ltd Trading as TMG College Australia | Registered Training Organisation #21694 | CRICOS Provider Code 03397E
Document Type: DC-1262 TMG Assessment Coversheet & Learner Assessment Pack
Version 7.3.1 Release Date: May 2019 Page 19 of 38
Unit details: FNSACC416 – set up & operate a computerised accounting system
3. Save the company file locally with the name Your Name Shop in the [My Library]
folder or select Change Location to choose your own storage folder.
4. In the Conclusion window click on the Command Centre button. The Activation
Assistant window will appear.
• The file needs to be activated to verify that you have a legal installation of
MYOB AccountRight. If the file is not activated, you can only record
transactions in the company file for a trial period of 30 days.
5. Activate the file online using the serial number entered earlier if you have one then
continue to the next page
Special Instructions for Students who do not have a serial number.
• So, you can complete this assessment open the following file that your
tutor/assessor will provide for you.
• Your Name Providore.myox
This file is transaction limited. It has had the same settings made as above
and on the previous page, so you can continue the same as if you had
entered a serial number.
• Continue to the next page
TMG Assessment Coversheet &
Learner Assessment Pack
tmg.edu.au | 1300 888 TMG (1300 888 864)
The Malka Group Pty Ltd Trading as TMG College Australia | Registered Training Organisation #21694 | CRICOS Provider Code 03397E
Document Type: DC-1262 TMG Assessment Coversheet & Learner Assessment Pack
Version 7.3.1 Release Date: May 2019 Page 20 of 38
Unit details: FNSACC416 – set up & operate a computerised accounting system
Complete Set up of Data File
6. Once the activation is confirmed you will have full access to the company file.
Click OK to go to the Command Centre, to continue with the company file set up.
7. Open the Company Information window and enter your name and student
number somewhere in the Address so your reports can be identified easily.
8. Access Help and search for a support note that explains how to modify or
edit the account list.
9. Edit your Accounts List as follows:

Number	Old Name	New Name
1-1110	Business Bank Account #1	NAB Business Account
2-2100	Business Loan #1	NAB Business Loan
4-1000	Sales Income #1	Sales
5-1000	Cost of Sales	Purchases

10. Delete these accounts.

Number and Name
2-1130 Amex #1	4-2000 Sales Income #2
2-1140 Visa #2	4-3000 Sales Income #3
2-1150 Mastercard #2	5-2000 Consumables
2-1160 Amex #2	5-3000 Plant Equip….
1-1120 Business bank …#2	1-1130 Business bank …#3

Account Type	Number/Name
Income Header account	4-1000 Sales
Cost of Sales Header account	5-1000 Purchases

11. b) Create New Accounts
Note: Condiments do not attract GST.

Account Type	New Name/Number	Tax Code
Income detail account	4-1100 Jam	FRE
Income detail account	4-1200 Pickles	FRE
Income detail account	4-1300 Gift Baskets	GST
Income detail account	4-1400 Cafe Sales and General	GST
Cost of Sale detail account	5-1100 Jams Purchased	FRE
Cost of Sale detail account	5-1200 Pickles Purchased	FRE
Cost of Sale detail account	5-1300 Gift Baskets	GST
Cost of Sales detail account	5-1400 Café items and general	GST
Expense	6-1350 Bank Merchant Fees	GST

12. Create the following Customer Cards:
Profile tab Selling Details tab

Designation	Company	Sales Layout	Item
Name	Fine Foods	Printed Form	Plain Paper Invoice
Card ID	CUS001	Income Account	4-1100
Address	1 St Kilda Road	Sale Comment	We appreciate your business
City	St Kilda	Credit Limit	$3,000
State	VIC	ABN	55 526 226 584
Postcode	3182	Payment is Due	In a Given No. of Days
Ph 1	03 9888 1111	Balance Due Days	14
Contact	Mary Smith

Designation	Company	Sales Layout	Item
Name	In a Pickle	Printed Form	Plain Paper Invoice
Card ID	CUS002	Income Account	4-1100
Address	1 King Street	Sale Comment	We appreciate your business
City	Melbourne	Credit Limit	$2,000
State	VIC	ABN	44 684 622 625
Postcode	3000	Payment is Due	In a Given No. of Days
Ph 1	03 9555 2222	Balance Due Days	30
Contact	John King

Card Type	Supplier	Purchase Layout	Item
Designation	Company	Printed Form	Plain Paper P.O.
Name	Connies Condiments	Expense Account	5-1100
Card ID	SUP001	ABN	52 365 874 523
Address	21 Sugar Lane Drive	Payment is Due	Day of Month after EOM
City	Tullamarine	Balance Due Date	1st
State	VIC
Postcode	3043
Ph 1	03 9337 2587
Email	[email protected]
Website	www.connies.com.au
Contact	Peter Black

Profile tab Buying Details tab

Card Type	Supplier	Purchase Layout	Item
Designation	Company	Printed Form	Plain Paper P.O.
Name	Food Galore	Expense Account	5-1100
Card ID	SUP002	ABN	54 654 658 522
Address	365 Farm Road	Payment is Due	In a Given No. of Days
City	Olinda	Balance Due Days	14
State	VIC
Postcode	3172
Ph 1	03 9658 2543
Email	[email protected]
Website	www.foodgalore.com.au
Contact	Marion Fowler

1-1110 NAB Business Account	$32,000.00
1-1140 Petty Cash/Cash on Hand	$200.00
1-1310 Trade Debtors	$4,400.00
1-1320 Inventory	$2,040.00
2-1510 Trade Creditors	$2,640.00
2-2100 NAB Business Loan	$26,000.00
3-1000 Owner’s/Shareholder’s Capital	$10,000.00

3. Enter Historical Sales.
You will need to enter unpaid customer invoices which total $4,400.00 on your
conversion date of May 1 2018 (these sales did not incur GST).

15/4/18	Fine Foods	$2,500.00	Invoice # 1
18/4/18	In a Pickle	$1,900.00	Invoice # 2

4. Enter Historical Purchases.
You will need to enter unpaid supplier bills which total $2,640.00 on your
conversion date of May 1 2018 (these purchases did not incur GST).

15/4/18	Connies Condiments	$2200.00	PO No. # 1
29/4/18	Food Galore	$440.00	PO No. # 2

Item	Item
Item Number	STRJAM	PLUJAM
Name	Strawberry Jam 1 kg Jar	Plum Jam 1 kg Jar
I Buy the Item	Yes 5-1100	Yes 5-1100
I sell the item	Yes 4-1100	Yes 4-1100
I inventory the item	Yes 1-1320	Yes 1-1320
Selling details	$20.00	$20.00

Item	Item
Item Number	MARJAM	APRJAM
Name	Marmalade Jam1 kg Jar	Apricot Jam 1 kg Jar
I Buy the Item	Yes 5-1100	Yes 5-1100
I sell the item	Yes 4-1100	Yes 4-1100
I inventory the item	Yes 1-1320	Yes 1-1320
Selling details	$20.00	$20.00

Item	Item
Item Number	FRTPIC	SWTPIC
Name	Fruit Pickles 1kg Jar	Sweet Pickles 1 kg Jar
I Buy the Item	Yes 5-1200	Yes 5-1200
I sell the item	Yes 4-1200	Yes 4-1200
I inventory the item	Yes 1-1320	Yes 1-1320
Selling details	$22.00	$22.00

Item	Item
Item Number	BSKDLX	BSKPRM
Name	Deluxe Basket	Premium Basket
I Buy the Item	Yes 5-1300	Yes 5-1300
I sell the item	Yes 4-1300	Yes 4-1300
I inventory the item	Yes 1-1320	Yes 1-1320
Selling details	$40.00 inc GST	$80.00 inc GST

Item No.	Count	Unit Cost Price	Unit Total
STRJAM	25	$10.00	$250.00
PLUJAM	33	$10.00	$330.00
MARJAM	17	$10.00	$170.00
APRJAM	33	$10.00	$330.00
FRTPIC	15	$12.00	$180.00
SWTPIC	30	$12.00	$360.00
BSKDLX	10	$18.00	$180.00
BSKPRM	6	$40.00	$240.00
Total	$2040.00

7. Now you have completed the company file set up, reconcile your accounts as
at 1 May 2018
a. Reconcile your Bank account. $32,000
b. Reconcile your Debtors/Accounts Receivable $4,400
c. Reconcile your Creditors/Accounts Payable $2,640
d. Reconcile your Inventory $2,040
e. Reconcile your GST accounts (Collected and GST Paid). $0
PRINTOUT 1 – Items List Summary
8. Print an Items List Summary.
PRINTOUT 2 – Inventory Value Reconciliation Report
9. Print an Inventory Value Reconciliation Report for 1 May 2018.
PRINTOUT 3 – Accounts List [Detail]
10. Print an Accounts List [Detail] – include Account Numbers. Report Level to be
Level 4 for May 1 2018
PRINTOUT 4 – Balance Sheet
11. Print a Balance Sheet as at May 1 2018 this year. Check the Report Level to be
Level 4.
PRINTOUT 5 – Trial Balance 1
12. Print a Trial Balance for May 2018 – include Account Numbers.
TMG Assessment Coversheet &
Learner Assessment Pack
tmg.edu.au | 1300 888 TMG (1300 888 864)
The Malka Group Pty Ltd Trading as TMG College Australia | Registered Training Organisation #21694 | CRICOS Provider Code 03397E
Document Type: DC-1262 TMG Assessment Coversheet & Learner Assessment Pack
Version 7.3.1 Release Date: May 2019 Page 27 of 38
Unit details: FNSACC416 – set up & operate a computerised accounting system
Enter Transactions: Spend Money
The following payments have been made.
Business Bank Account
a) Payment method: Bpay
9 May 2018
Power Co
Electricity account
$462 inc GST
b) Payment method: Direct Debit
16 May 2018
Bel Tel Communications
Monthly internet
$220 inc GST
c) Payment Method: EFT to supplier
30 May 2018
Mollymook Matters Inv 12055
Advertising market supplement
$550 inc GST
d) Payment method: Direct Debit
30 May 2018 and 30 June 2018
Public Liability Insurance payment to Providence Insurance for $300.55
The GST component is $292.05, the GST free component is $8.50. Both components
apply to the insurance expense.
Total GST is 26.55.
e) On May 1 2018 you purchased shop equipment from All Things Retail. The
equipment is paid by direct deposit from the main Business bank account. The
invoice totalled $15,000 including GST. The invoice number was 1011.
TMG Assessment Coversheet &
Learner Assessment Pack
tmg.edu.au | 1300 888 TMG (1300 888 864)
The Malka Group Pty Ltd Trading as TMG College Australia | Registered Training Organisation #21694 | CRICOS Provider Code 03397E
Document Type: DC-1262 TMG Assessment Coversheet & Learner Assessment Pack
Version 7.3.1 Release Date: May 2019 Page 28 of 38
Unit details: FNSACC416 – set up & operate a computerised accounting system
Edit all the Account names for Store Fittings to be Shop equipment and use for the
transaction above.
f) Payment method: Bpay
9 June 2018
Power Co
Electricity account
$520.45 inc GST
g) Payment method: EFTPOS
15 June 2018
Officeworks
Stationery
66.00 inc GST
h) Payment method: Direct Debit
16 June 2018
Bel Tel Communications
Monthly internet
$220 inc GST
i) Payment method: Direct Debit
1 May 2018
Seaview Realestate
Business Premises Rent
$352 inc GST
Note: This payment occurs each week so make sure you enter payments for the
following dates: 8 May, 15 May, 22 May, 29 May, 5 June, 12 June, 19 June, 26 June
You will need to Add a New Account – use number 6 – 2650
Credit Card
j) On May 1 2018 Jane also purchased computer equipment from The IT Girl for
$2400 inc GST. The computer equipment was paid for using the Visa Credit
card.
TMG Assessment Coversheet &
Learner Assessment Pack
tmg.edu.au | 1300 888 TMG (1300 888 864)
The Malka Group Pty Ltd Trading as TMG College Australia | Registered Training Organisation #21694 | CRICOS Provider Code 03397E
Document Type: DC-1262 TMG Assessment Coversheet & Learner Assessment Pack
Version 7.3.1 Release Date: May 2019 Page 29 of 38
Unit details: FNSACC416 – set up & operate a computerised accounting system
Enter Invoice Sales to Customers
Enter the following invoices.
a) Invoice Inv-0003
Customer: Fine Foods
Date: 14/5/18
10 of each of the following items:
Apricot Jam
Marmalade Jam
Plum Jam
Strawberry Jam
Total ex GST $800
b) Invoice Inv-0004
Customer: In a Pickle
Date: 20/5/18
5 jars of each of the pickles.
Total ex GST $220
c) Invoice Inv-0005
Customer: In a Pickle
Date: 2/6/18
5 jars of each of the pickles.
Total ex GST $220
d) Invoice Inv-0006
Customer: Fine Foods
Date: 8/6/18
5 Premium Baskets
Total including GST $400
TMG Assessment Coversheet &
Learner Assessment Pack
tmg.edu.au | 1300 888 TMG (1300 888 864)
The Malka Group Pty Ltd Trading as TMG College Australia | Registered Training Organisation #21694 | CRICOS Provider Code 03397E
Document Type: DC-1262 TMG Assessment Coversheet & Learner Assessment Pack
Version 7.3.1 Release Date: May 2019 Page 30 of 38
Unit details: FNSACC416 – set up & operate a computerised accounting system
Receive Payments
(a) 15 May 2018 $3,300 direct deposit from Fine Foods for invoices 001 and 003
(b) 22 May 2018 $1,900 direct deposit from In a Pickle for invoice 002
(c) 15 June 2018 $ 220 direct deposit from In a Pickle for invoice 004
Other Transactions
You need to be aware of the following information.
(a) On 31 May 2018 $150 was transferred to the Petty Cash account
(b) Branch deposits are made each week for sales receipts in the Sunday café
sales. Use the amounts listed on the Bank statements as a guide. They are all
100% GST inclusive.
(c) On 19 June 2018 you paid $2400 off the Visa Credit Card.
TMG Assessment Coversheet &
Learner Assessment Pack
tmg.edu.au | 1300 888 TMG (1300 888 864)
The Malka Group Pty Ltd Trading as TMG College Australia | Registered Training Organisation #21694 | CRICOS Provider Code 03397E
Document Type: DC-1262 TMG Assessment Coversheet & Learner Assessment Pack
Version 7.3.1 Release Date: May 2019 Page 31 of 38
Unit details: FNSACC416 – set up & operate a computerised accounting system
Bank Reconciliation May 31, 2018
1. You are now required to reconcile the bank account using the following
statement:
2. Print the following reports to May 31 2018.
PRINTOUT 6 – Bank Reconciliation Report May 31 2018
PRINTOUT 7 – Balance Sheet Report May 31 2018
PRINTOUT 8 – Profit and Loss Report May 31 2018
PRINTOUT 9 – GST Detail Accrual Report Report May 31 2018

NAB Bank Your Town	Bank Statement
Your Shop Pty Ltd Business Account Account Number: 456456456	From 1 May 2018 To 31 May 2018
Date	Transaction Details	Debit (Withdrawals)	Credit (Deposits)	Balance
1-May-18	Brought forward	32000.00
1-May-18	EFT All things Retail Inv 1011	15000.00
1-May-18	Seaview Real Estate	352.00	16648.00
8-May-18	Seaview Real Estate	352.00
8-May-18	Branch deposit	3650.00	19946.00
9-May-18	Power Co	462.00	19484.00
15-May-18	Seaview Real Estate	352.00
15-May-18	Fine Foods Inv 001 and 003	3300.00
15-May-18	Branch deposit	2100.00	24532.00

16-May-18	Bell Tel Communications	220.00	24312.00
22-May-18	Seaview Real Estate	352.00
22-May-18	Branch deposit	2830.00
22-May-18	In a Pickle Inv 002	1900.00	28690.00
28-May-18	Branch deposit	4200.00	32890.00
29-May-18	Seaview Real Estate	352.00	32538.00
30-May-18	Direct Payment Mollymook Matters	550.00
30-May-18	Providence Insurance	300.55	31687.45
31-May-18	Transfer to Petty Cash	150.00
31-May-18	Bank Fees	12.00
31-May-18	Merchant Fees	145.00	31380.45
Closing Balance	31380.45

NAB Bank Your Town	Bank Statement
Your Name Shop Pty Ltd Business Account Account Number: 456456456	From 1 Jun 2018 To 30 Jun 2018
Date	Transaction Details	Debit (Withdrawals)	Credit (Deposits)	Balance
1-Jun-18	Brought forward	31380.45
4-Jun-18	Branch Deposit	2500.00	33880.45
5-Jun-18	Seaview Real Estate	352.00	33528.45
9-Jun-18	Power Co	520.45	33008.00
12-Jun-18	Seaview Real Estate	352.00
12-Jun-18	Branch deposit	4200.00	36856.00
15-Jun-18	Officeworks	66.00
15-Jun-18	In a pickle Inv004	220.00	37010.00
16-Jun-18	Bell Tel Communications	220.00	36790.00
18-Jun-18	Branch deposit	2830.00	39620.00
19-Jun-18	Credit card	2400.00
19-Jun-18	Seaview Real Estate	352.00	36868.00
25-Jun-18	Branch deposit	2850.00	39718.00

26-Jun-18	Seaview Real Estate	352.00	39366.00
30-Jun-18	Providence Insurance	300.55
30-Jun-18	Bank Fees	12.00
30-Jun-18	Merchant Fees	160.00	38893.45
Closing Balance	38893.45

a. Reconcile your Bank account.
(you have just done this the previous section)

$38893.45

b. Reconcile your Debtors/Accounts Receivable $ 620.00
c. Reconcile your Creditors/Accounts Payable $2,640.00
d. Reconcile your Inventory $1,200.00
e. Reconcile your GST accounts (Collected and GST Paid). $ 187.67
PRINTOUT 11 – Balance Sheet Report June 30 2018
PRINTOUT 12 – Profit and Loss Report June 30 2018
PRINTOUT 13 – GST Detail Accrual Report June 30 2018
PRINTOUT 14 – Accounts Receivable Reconciliation June 30 2018
PRINTOUT 15 – Accounts Payable Reconciliation June 30 2018
PRINTOUT 16 – Inventory Value Reconciliation June 30 2018
PRINTOUT 17 – Tax Information Reconciliation Detail May to June 2018
2. Create a Backup file of your company file before entering any end of year
adjustments – the date for the file name is 30 June 2018 – name the Backup file
Your Name Shop 30062018 Pre Year End Adjustments
3. Enter a Period End Adjustment
TMG Assessment Coversheet &
Learner Assessment Pack
tmg.edu.au | 1300 888 TMG (1300 888 864)
The Malka Group Pty Ltd Trading as TMG College Australia | Registered Training Organisation #21694 | CRICOS Provider Code 03397E
Document Type: DC-1262 TMG Assessment Coversheet & Learner Assessment Pack
Version 7.3.1 Release Date: May 2019 Page 36 of 38
Unit details: FNSACC416 – set up & operate a computerised accounting system
Review your accounts and reports which could be provided to the Accountant.
Enter a purchase tax inclusive General journal entry for the end of period adjustment.
Date the transaction 30 June 2018.
All tax codes are to be N-T.
Change the account Names where necessary.

Account	Name	Debit	Credit
6-5300	Computer Depreciation	133.33
1-2320	Less accumulated depreciation Computer Equipment	133.33
Narration memo: Depreciation 2 months computer equipment
6-5400	Shop Equipment Depreciation	500.00
1-2420	Less accumulated depreciation Shop Equipment	500.00
Narration memo: Depreciation 2 months shop equipment

4. Once the journal entry is made, print a Trial Balance report for June, including
Account Numbers, ready to send the Accountant to confirm the final figures.
PRINTOUT 18 – Trial Balance – End of Year
5. Create a Backup of your company file. Name your file carefully, for example,
Your Name Shop 30062018
6. Exit AccountRight.
7. Collate all reports and copies of the any company files used in this practical
exercise for your Assessor.
PRINTOUT 19 and 20 – Payroll Reports – Clearwater Pty Ltd
1. Open the Clearwater Pty Ltd file on your computer and generate and print the
reports for each period as dated in Unit 2 of the User Guide.
2. Submit them as required.
TMG Assessment Coversheet &
Learner Assessment Pack
tmg.edu.au | 1300 888 TMG (1300 888 864)
The Malka Group Pty Ltd Trading as TMG College Australia | Registered Training Organisation #21694 | CRICOS Provider Code 03397E
Document Type: DC-1262 TMG Assessment Coversheet & Learner Assessment Pack
Version 7.3.1 Release Date: May 2019 Page 37 of 38
Unit details: FNSACC416 – set up & operate a computerised accounting system
Assessment Tasks Outcome Record

Result of Assessment Tasks:	Assessment Task 1 – Written Questions □ Satisfactory □ Not Satisfactory Assessment Task 2 – Project/Observation □ Satisfactory □ Not Satisfactory
Feedback:	Assessment Task 1-Written Questions Assessment Task 2-Project/Observation
Learner Signature:	Date:
Trainer/Assessor Signature:	Date: