Accounting System and Process: Financial Accounting and Reporting

This report provides a comprehensive overview of accounting systems and processes, covering key areas such as spreadsheet applications, inventory management, bank reconciliation, and the management of bad debt. The spreadsheet section discusses the advantages and disadvantages of using spreadsheets in accounting, differentiating between data and report sections, and demonstrating IF functions. The inventory management section compares perpetual and periodic inventory systems, applying FIFO, LIFO, and average cost methods to a case study. The bank reconciliation section explains items affecting bank and cash balances, presents an adjusted bank reconciliation, and provides relevant journal entries. Finally, the report examines Coca-Cola Amatil's bad debt management using the allowance method and analyzes the company's financial performance through ratio analysis. This document is available on Desklib, offering students a valuable resource for understanding complex accounting principles and practices with access to similar documents and study tools.

Running head: ACCOUNTING SYSTEM AND PROCESS
Accounting system and process
Subject code
Subject name
Student Name
Student ID
Assignment task number
Author note
DECLARATION: THE WORK IN THIS ASSIGNMENT IS MY OWN WORK, AND HAS NOT
BEEN PLAGIARISED

ACCOUNTING SYSTEM AND PROCESS
Table of Contents
Part A – Spreadsheet............................................................................................................................2
Part B – Inventory management..........................................................................................................5
Part C – Bank reconciliation..............................................................................................................12
Part D – Management of bad debt and financial decision.................................................................13
Reference...........................................................................................................................................16
Student name
Student ID Page 1

ACCOUNTING SYSTEM AND PROCESS
Part A – Spreadsheet
Answer 1
Spreadsheet is the sheet that reveals the accounting data or other data in columns and rows.
This is a computer programme application that replicates the physical spreadsheet through
capturing, manipulating and displaying the data arranged in columns and rows. It is one of the most
popular used in personal computer. It is a valuable tool to collect and calculate all types of data.
Apart from arithmetical uses spreadsheet can be used for creating concise and clear report that can
be updated and sorted just with the click of button. Spreadsheet are used for the below mentioned
uses –
 Lists – any type of lists like material list, employee list and delivery lists can be created
through using the spreadsheet. Further, the sorting power of the spreadsheet is more
evidential while any additional data is entered. Moreover, maintaining business data allows
the user to sort it by each field.
 Accounting – apart from above spreadsheet is used for making valuable calculations.
Through entering appropriate formula and mathematical function into any cell the user can
turn simple spreadsheet into accounting page. Debits can be entered in one column and
credits in another. Further the auto sum function can be used for fast calculation and can be
set up for maintaining the running totals. Further, data from any location in workbook can
be used in the calculation. Adding the additional worksheet allows the user to organize the
information as per requirement (Okamura & Dohi, 2013).
 Time sheets – apart from additions and calculations spreadsheet can also be used for making
calculations on the basis of time numbers. Formatting the cells for reflecting the data as
time allows using the sheet as time sheet. Hence, the user can add description for assorted
functions of job, names of employees which in turn enable sorting those data as per the time
incurred for the selected field.
Disadvantages associated with spreadsheet use are as follows –
 Vulnerable to the fraud – this limitation associated with the spreadsheet is most damaging
among all. It takes place owing to inherent control lack that enables any person to alter the
data or alter the formula, value or the dependencies without detection.
 Human error – while fraud is considered as threat to the spreadsheet more significant threat
areas are there in the spreadsheet that may make the spreadsheet useless. For instance, the
spreadsheet is highly susceptible to human errors. If input data is not entered correctly it
will make the entire calculation and analysis wrong (Weygandt, Kimmel & Kieso, 2015).
Answer 2
Data section and report section in the excel spreadsheet are differentiated for presenting the
sheet in more clear and meaningful manner. Data section presents unprocessed data while the
report section presents processed data. Hence, segregation of report area and data area enable the
user to take valuable decisions (Miller-Nobles, Mattison & Matsumura, 2016).
Answer 3
IF function –
Normal view
Student name
Student ID Page 2

ACCOUNTING SYSTEM AND PROCESS
Formula view
Negative number within bracket
Normal view
Student name
Student ID Page 3

ACCOUNTING SYSTEM AND PROCESS
Formula view
Names to the reference cell
Normal view
Student name
Student ID Page 4

ACCOUNTING SYSTEM AND PROCESS
Formula view
Part B – Inventory management
Difference between perpetual system and periodic system of inventory
Under perpetual inventory method each transaction for outflow and inflow of the stocks are
updated constantly through POS (point of sale) system. Under this method records are maintained
for keeping complete record for issue and receipts of inventory. Conversely, under periodic
inventory method the inventory method is recorded at regular interval only after taking the physical
Student name
Student ID Page 5

ACCOUNTING SYSTEM AND PROCESS
verification of the stock (Myrelid & Olhager, 2015). Under this method physical count for the stock
is carried out and thereafter the inventory records are updated after adjustments, if any.
Major differences between 2 methods are –
 Under perpetual system inventories are recorded on the basis of real time of issues and
receipts. On the other hand, under periodic system inventory movement details are tracked
at the periodic interval.
 Perpetual system is based on the book records while the periodic system considers the
physical verification as the base (Chołodowicz & Orłowski, 2015).
 Under perpetual system no interference in regular workflow at stock taking time and at the
time of verification. On the other hand, under periodic system, regular business operation
maybe required to be stopped.
 Under perpetual system loss of the goods are included under the closing inventory whereas
periodic system includes the same under COGS.
 Under perpetual system continuous updating are made for the inventories that are whenever
the transaction related to stock takes place. Conversely, in periodic system records are not
updated on continuous basis rather it is carried out in a gap of time.
 In periodic system information for COGS and cost of sales are provided whereas under
perpetual system information for COGS and inventories are provided (Golyagina &
Valuckas, 2016).
 Inventory purchases under perpetual system are included in raw material account or
merchandise account whereas in periodic method purchases are recorded in asset purchase
account.
Fashion Haven opened retail clothing store in Australia. Company is recently considering
using the most appropriate inventory method for its stock among periodic system and perpetual
system. It is found from the given details that for the month of May the company have 3 purchase
transactions and some sales. Therefore, it can be stated that owing to the nature of its business,
Fashion Haven generally has number of purchases and sales. Hence, it is suggested to the company
to use perpetual method for inventories. It will enable it to record the inventories on real time basis.
Further it will enable it to update the inventories whenever there will take place any purchase or
sales transactions.
Computation of closing inventory and COGS for May
Normal view –
FIFO method –
Student name
Student ID Page 6

ACCOUNTING SYSTEM AND PROCESS
LIFO method
Student name
Student ID Page 7

ACCOUNTING SYSTEM AND PROCESS
Average cost method
Student name
Student ID Page 8

ACCOUNTING SYSTEM AND PROCESS
Formula view –
FIFO method –
Student name
Student ID Page 9

ACCOUNTING SYSTEM AND PROCESS
LIFO method
Student name
Student ID Page 10

ACCOUNTING SYSTEM AND PROCESS
Average method
Under the FIFO approach that is first in first out cost allocated to goods are measured on the
basis of the goods bought 1st. To be more specific, the entity assumes that the goods purchased first
will be sold first. Conversely, as per LIFO (last in first out) method the items purchased last are
sold first. Under average method average quantity of goods purchased and their average price is
considered (Bragg, 2013).
Computation of gross profit
Particulars FIFO LIFO Average method
Sales revenue $ 10,800.00 $ 10,800.00 $ 10,800.00
Less: COGS $ 5,815.00 $ 5,975.00 $ 5,917.11
Gross profit $ 4,985.00 $ 4,825.00 $ 4,882.89
Looking into the nature of Fashion Haven’s business and increasing trend of purchase price
it is recommended that the company shall use FIFO method. Reason for selecting this method is
that it will give better indication for ending inventory’s value. Further as the prices for its
purchases are in increasing trend selling the goods those were purchased first will help in
maintaining profitability. Moreover, as per the calculation it can be identified that under FIFO
method the company will be able to earn highest amount profit as compared to other 2 methods
(Lwiki et al. 2013).
Student name
Student ID Page 11