ACCOUNTING PRACTICE SET
The objective of the Accounting Practice Set is to provide students with a “hands on” approach to
measuring, recording, and communicating accounting infor
users in the form of financial statements.
This Accounting Practice Set consists of completing the accounting cycle for a sole trading service
entity for one month using EXCEL
and confirming your results by using the accounting software
On completion of this Accounting Practice Set you should have d
achieved the following Assurance of Learning Goals:
Have knowledge and skills pertinent to a particular discipline (KS)
Integrate and apply discipli
nary theory and skills to practical situations
Incorporate the use of technology appropriate to the discipline and context
Be a critical thinker and effective problem solver (CTA)
Identify, research and critically analyse information relevan
t to a business problem or
issue, be able to synthesise that information in order to evaluate potential solutions, make
recommendations or otherwise effectively address the problem or issue
You are required to complete and submit your accounting practice set in EXCEL using the template
provided on Blackboard.
You will confirm your results from the manual EXCEL system by also using
Practice Set Excel
ile must contain
on the first page (Chart of Accounts)
footer which you
create containing your name and
tudent number. Do not handwrite this
you must enter
the details using Excel.
sign the declaration on the first page
of the Excel file
that the practice set is your own
When you have completed the accounting practice set, you are required to print off the
EXCEL files and hand in that printed copy to your lecturer.
In the Print function, select Entire Workbook (th
ere should be
pages from the Chart of
Accounts to the Post Closing Balance)
Print three (3)
formula pages with row and column headings
(see top of next page):
Your final printed copy
o print formulas with rows and columns, press ‘Ctrl ~’ to show formulas. Then click on
Page Layout, Print Titles, and tick Row and Column Headings. Click on Print button to
The pro forma document provided should not be altered in any way; there i
s no need to add
rows or columns to the spreadsheet. Please follow the printing instructions precisely. Please
note that in the past some students have had difficulty printing from a Mac. If any student uses
a Mac to complete the practice set, it is the
student’s responsibility to ensure they can correctly
print out the assignment. Penalties apply if the printing instructions are not followed. The
university provides computer access for you to complete and print your practice set
assignment. If you ha
ve any printing issues, please contact the IT Help Desk as lecturers are
not able to assist with printer or printing errors.
Use only Microsoft Excel, do not attempt to transfer the document to any other spreadsheet
You will be able to start w
orking on the practice set after the lecture for Topic 5 when we cover GST
and Special Journals.
When you have completed the
Excel spreadsheet the transactions, including adjustments, are to be
journalised in QuickBooks and
an adjusted trial balance
it and Loss Statement and Balance Sheet
Late submission penalties
will apply to students who fail to submit their practice set by the due
date and who have not been granted an extension.
Faculty policy is that a 10% penalty applies
each day late (or part thereof).
will only be granted in
circumstances. To be on the safe side, start the
practice set as soon as Topic 5 is completed
do not leave it until the week in which it is due.
ALL REQUESTS FOR EX
TENSIONS OR DEFERRED SITTINGS OF THE QUIZ
IN ACCORDANCE WITH THE INSTRUCTIONS ON
BLACKBOARD IN THE ASSESSMENT ITEM 2 FOLDER
The total mark
for the Practice Set
This consists of 1
% for completion of the
, including the
and 10% for
the quiz, which demonstrates your
understanding and interpretation of the Practice Set.
% for completion
of the Practice Set is assessed by your lecturer checking off
of the Pra
. When you print the Practice Set, you will have a total of 1
the Chart of Accounts and Opening Balances.
Each of the
worth one mark each. If
complete each page then you will receive one mark for each pag
marks will be allocated to the correct use of formulas. Failure to follow instructions regarding
the insertion of the appropriate formulas in cells will result in loss of marks.
10 marks will be awarded for the correctness of the Quickbooks
, Profit and
Loss Statement, and Balance Sheet.
Total Marks = 30
divided by 2 to get the
Note 1: if you have not fully completed a page, then only part marks will be awarded for that
the mark for Page 1 is for
Note 3: if you have not signed the declaration on the first page, the Practice Set will not
10% for understanding and interpretation
is assessed by way of a 20 question
At the start of the lecture when you hand
in the Accounting Practice Set, you will be given a
about items in the Practice Set. You will
have the Practice Set with you when you answer the Quiz. Each question is worth one mark. The
Quiz will be ma
rked out of 20 and then divided by 2 to give a percent out of
What is the total
revenue for the month?
What is the total of the non
current assets at 1
on the Comparative Balance Sheet?
the formula fo
of the Cash Receipts Journal
More practice quiz questions will be provided for you on the Blackboard site.
ACCOUNTING PRACTICE SET C
: Note that this is the correct order of
performing the steps for the Practice Set
Use the fo
llowing CHECKLIST to ensure that you have fully completed the Practice Set.
Tick each item as you complete it.
COMPLETE THESE 8 STEPS. Do
insert or delete any rows/columns in the spreadsheet.
Record the transactions in the appropriate journal
s. (Narrations are not required)
the subsidiary ledgers
the general journal.
journal columns are posted at month end.
Include posting references where indicated
Total and rule off all special journals. Po
st from the
journals to the general
Include posting references where indicated
Prepare Schedules of Accounts Receivable and Accounts Payable
control accounts reconcile with their subsidiary ledgers.
Prepare the Unadjusted
Trial Balance as at
the worksheet. Complete the worksheet using the adjusting entry information.
the adjusting entries in the general journal and post to the general ledger
Record closing entries in the
general journal and post to the general ledger.
Prepare the Income Statement (not classified), Statement of Changes in Equity and
Classified Comparative Balance Sheet. (A comparative balance sheet contains the
and for 1
repare from the
ledger, a Post Closing Trial Balance as at
How can I make sure my practice set is correct?
elow are the correct
you should obtain.
If you don’t, please check your work again.
THE SET ACCURATELY:
Total of the Cash at Bank column in the Cash Payments Journal
Total of the Wages Expense column in the Cash Payments Journal
Total of the Cash at Bank column in the Cash Receipts Journal
Balance of the Accounts Receivable Account at
Balance of the Accounts Payable Account at
Balance of GST Clearing account at
Balance of the PAYG Tax Payable Account in the Unadjusted Trial B
column of the Worksheet
Balance of the Superannuation Expense Account in the Unadjusted Trial
Balance column of the worksheet
Total of the Unadjusted Trial Balance Columns of the Worksheet
Total of the Adjustments C
olumns of the Worksheet
Total of the Adjusted Trial Balance Columns of the Worksheet
Net profit for
BACKGROUND AND FACTS
Kelda Murphy is the owner of Advertising
Revolution, an advertising business that she
established several years ago, after graduating from QUT. She operates the business as a
She provides advertising services to clients in a broad range of industries and has received
try awards for her professional services. She currently employs a full
graduate and utilises other casual staff when she needs additional personnel.
The business is operated from rented office space in West End where she has a 5 year lease.
has a variety of clients and she offers them different payment terms depending on the
size and industry of the client as well as the size of the work that is to be undertaken. Some
established clients are offered either 14 or 30 days credit. Other client
s are required to pay
50% deposit before the work is commenced. For new clients, Kelda insists on the entire
balance being received by cheque before the work is undertaken.
Some years ago, she borrowed money from ANZ bank to upgrade the office and comp
equipment and to develop a website to advertise her services. The loan of $60,000 is
repayable over 10 years and the interest rate is 8.5% payable monthly. The portion of the
loan repayable within 12 months is classified as a Current Liability on th
e Balance Sheet and
the remainder of the loan owing is classified as a Non
Kelda submits her Business Activity Statements quarterly on a cash basis.
PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT 🙂
Compelling correspondence is essential to the achievement all things considered but since of the changing idea of the present working environments, successful correspondence turns out to be more troublesome, and because of the numerous impediments that will permit beneficiaries to acknowledge the plan of the sender It is restricted. Misguided judgments.In spite of the fact that correspondence inside the association is rarely completely open, numerous straightforward arrangements can be executed to advance the effect of these hindrances.
Concerning specific contextual analysis, two significant correspondence standards, correspondence channel determination and commotion are self-evident. This course presents the standards of correspondence, the act of general correspondence, and different speculations to all the more likely comprehend the correspondence exchanges experienced in regular daily existence. The standards and practices that you learn in this course give the premise to additionally learning and correspondence.
This course starts with an outline of the correspondence cycle, the method of reasoning and hypothesis. In resulting modules of the course, we will look at explicit use of relational connections in close to home and expert life. These incorporate relational correspondence, bunch correspondence and dynamic, authoritative correspondence in the work environment or relational correspondence. Rule of Business Communication In request to make correspondence viable, it is important to follow a few rules and standards. Seven of them are fundamental and applicable, and these are clear, finished, brief, obliging, right, thought to be, concrete. These standards are frequently called 7C for business correspondence. The subtleties of these correspondence standards are examined underneath: Politeness Principle: When conveying, we should build up a cordial relationship with every individual who sends data to us.
To be inviting and polite is indistinguishable, and politeness requires an insightful and amicable activity against others. Axioms are notable that gracious “pay of graciousness is the main thing to win everything”. Correspondence staff ought to consistently remember this. The accompanying standards may assist with improving courtesy:Preliminary considering correspondence with family All glad families have the mystery of progress. This achievement originates from a strong establishment of closeness and closeness. Indeed, through private correspondence these cozy family connections become all the more intently. Correspondence is the foundation of different affiliations, building solid partners of obedient devotion, improving family way of life, and assisting with accomplishing satisfaction (Gosche, p. 1). In any case, so as to keep up an amicable relationship, a few families experienced tumultuous encounters. Correspondence in the family is an intricate and alluring marvel. Correspondence between families isn’t restricted to single messages between families or verbal correspondence.
It is a unique cycle that oversees force, closeness and limits, cohesiveness and flexibility of route frameworks, and makes pictures, topics, stories, ceremonies, rules, jobs, making implications, making a feeling of family life An intelligent cycle that makes a model. This model has passed ages. Notwithstanding the view as a family and family automatic framework, one of the greatest exploration establishments in between family correspondence centers around a family correspondence model. Family correspondence model (FCP) hypothesis clarifies why families impart in their own specific manner dependent on one another ‘s psychological direction. Early FCP research established in media research is keen on how families handle broad communications data. Family correspondence was perceived as an exceptional scholastic exploration field by the National Communications Association in 1989. Family correspondence researchers were at first impacted by family research, social brain science, and relational hypothesis, before long built up the hypothesis and began research in a family framework zeroed in on a significant job. Until 2001, the primary issue of the Family Communication Research Journal, Family Communication Magazine, was given. Family correspondence is more than the field of correspondence analysts in the family. Examination on family correspondence is normally done by individuals in brain science, humanism, and family research, to give some examples models. However, as the popular family correspondence researcher Leslie Baxter stated, it is the focal point of this intelligent semantic creation measure making the grant of family correspondence special. In the field of in-home correspondence, correspondence is normally not founded on autonomous messages from one sender to one beneficiary, yet dependent on the dynamic interdependency of data shared among families It is conceptualized. The focal point of this methodology is on the shared trait of semantic development inside family frameworks. As such, producing doesn’t happen in vacuum, however it happens in a wide scope of ages and social exchange.
Standards are rules end up being followed when performing work to agree to a given objective. Hierarchical achievement relies significantly upon compelling correspondence. So as to successfully impart, it is important to follow a few standards and rules. Coming up next are rules to guarantee powerful correspondence: clearness: lucidity of data is a significant guideline of correspondence. For beneficiaries to know the message plainly, the messages ought to be sorted out in a basic language. To guarantee that beneficiaries can without much of a stretch comprehend the importance of the message, the sender needs to impart unmistakably and unhesitatingly so the beneficiary can plainly and unquestionably comprehend the data.>