ACC566 Account System And Process Assignment Help

ACC566 Account System And Process Assignment Help

ACC566 Account System And Process Assignment Help

Question 1 Plagiarism

Plagiarism is an act of falsification done while demonstrating the particular assignment as original while in fact, it is taking someone else's composition or even though & displaying it as its own task (Karabag & Berggren, 2012). This incorporates data from various internet sources, articles, works of art or some other source of acquiring information. However while quoting someone else’s data in the individual assignment of the researcher, it is important to demonstrate the wellspring of the data information with the help of appropriate references of the sources of  data information. Simply quoting the reference at the end of the assignment is not sufficient; quoting through the use of proper citation is relevantly required at the place where information is used. Sometimes it is observed that in spite of the original document of the analyst it coincidently matches with any of the existing documents or research of some other writer (Shahabuddin, 2009).  This will hamper the grades of the student as originality of document is affected.

Question 2 Pasting spreadsheets in Word Document files

While pasting the excel jobs into the word file there are certain ways of doing it. The way in which analyst wants spread sheet data into the word file decides the method to be utilised for doing the same (Westerheim, 2011). For instance, if the analyst wants to bring certain changes into the word file it can subsequently utilise the copy - paste method or the object method. On the other hand, a document writer can also go for snapshot approach in which data is posted in the word file as a picture document. The details of the various method of insertion of spread sheet data into word file is bulleted below

Copy Paste technique– In this technique, it begins with copying the document from the excel spread sheet while selecting the required database and then pasting the same in the required word file.

ACC566 Account System And Process Assignment Help

Copying through excel file using Control + C command.

ACC566 Account System And Process Assignment Help

Paste in Word file using Control + V command in the word file.

Object insertion technique- In this particular approach in the word document Move to the insert tab, and select object from the drop-down list. Share appropriate links of the excel document in the pop – up box that is showcased after the above activity. This will add the excel document to the word file. Using this technique provides an additional benefit that on making any changes in the excel file it will automatically make amendments in the word document accordingly.

ACC566 Account System And Process Assignment Help

ACC566 Account System And Process Assignment Help

Question 3 Accounting resources on the Internet

No.

Accounting resources websites

Relevancy with accounting

1.

Quick Books

Web link - https://www.quickbooks.in

It is a cloud computing based online website which enhances the support to businesses generally in the small segment. It support business group in various ways such as –

  • Creation of invoices and helps in general accounting of business
  • Support online banking transactions.
  • Support email and receivable management system.

2.

ZOHO

Web link - https://www.zoho.com

Similar to Quick books it provides the online accounting and expenditure management system. Tracks receivable and payables management. Shows data in form of trend lines and pictorial graphs.

3.

Morningstar

Web link - http://www.morningstar.com/

Shows the complete data and information of the different organisation while presenting their financial statements, ratio analysis, and comparative analysis. This further support to investment decisions of the various users of the company.

4.

Australian Accounting Standards Board(AASB)

http://www.aasb.gov.au/

This provides support to the business organsiation in utilising the relevant standards as required by the law in presenting their financial statements.

Question 4 Professional accounting bodies

The Professional body which is responsible and works as a professional accounting body of Australia is Institute of Chartered Accountants in Australia (ICCA). It was formed way back in the year 1928 as a chartered body. This body is responsible for preparing the professional chartered accountants as per the Australian legal compliance and knowledge base. At present, there are around 61,000 members associated with the group. At present, there are more than around 12,000 students studying the relevant course of the chartered accountancy. This body is associated with certified practicing accountants (CPA Australia) whose main aim and objective to develop and strengthen the accountancy norms in the complete regions. These bodies focus that the organisation in particular geographical region do practice their accounting policies ethically and record them in books of accounts as per relevant accounting standards applicable to them. 

Question 5 Work Integrated Assessment

The ERP software used in the last organisation was Fenwick Software. This enabled the organisation in enhancing its business capabilities as incorporates apart from basic accounting functions it supported the business group in generating the variety of information utilised for internal and external purposes. It is operated at all level of management whether it is at a lower level for inputting of the actual transaction or at the top level for monitoring of final performance. In this particular  ERP software, it connects the internet network base. With the help of same, it collects and records the transaction of the business branches situating at the different geographical location and convert them into meaning full summarised information for the management purposes. It has the further benefit of getting it customised as per the user’s requirement. It is software which simplifies all the troubles of business at one place. The task performed by the relevant ERP in the organsiation are detailed below –

Supply chain management

The Fenwick Software helped the organisational structure to manage and control the supply chain and logistic system. By maintaining the schedules of delivery in terms of time taken, a method of delivery of goods and better maintenance of supply chain system will enable the firm to sustain economic order quantity in the business (Tambovcevs & Tambovceva, 2013).

1.Inventory and receivables management

2.Human resource, Labour, payroll system management

This ERP software keeps the records of employees pay records, their personal informations and another database of employees. This will enable the firm in better management & utilise the human resource in most appropriate manner.

Customer Relationship management

Keeping track records of the customers of the business, their sales patterns, choices and preferences, Fenwick software helped the business firm in marinating the relationship with the customer. For instance, if the customer makes any complaint regarding any service issue or quality of the product then this software automatically records it in its database and generates the service request number (Zeng, et. al., 2012). This query after getting it entered into the ERP system has certain deadlines and if it is not resolved in certain period time it will get escalated to the senior management on its own.

1.Transaction management

2.Financial accounting and presentation

ACC566 Account System And Process Assignment Help

Question 6 ABC Learning and ethics - ABC Learning Case Study

Business Report

1.Introduction

ABC learning centers was an Australian company trading in Australia with an aim and objective of providing early childhood education services to the children mainly in the geographical regions of Australia & New Zealand. It was founded way back in 1988 with its headquarters in Queensland. Later on, it expanded its health care operations in the USA and Asian regions. The respective company was later on liquidated due to increase in debts in the organisation. Later on, it was purchased by the Good start early learning group. For the year 2006, the ABC learning achieved the benchmark of being the largest group in the particular largest education provider segment. Through this report, an analyst described the major issues that got associated with the company that is responsible for its liquidation activity.

2.Issues that rose in ABC learning firm.

The share costs of the organization fell startlingly in the second half year 2007 because of the significant decrease in benefits by 42% and absence of limit to meet out its obligation commitments which are around $1.8 billion standing in liability column of company’s balance sheet. There was an issue of financial window dressing witnessed over the period of time which enhances the share prices in a biased way. Therefore, the organization went into managerial receivership. The key lessons which can be taken in by different organizations from the fall of ABC Learning incorporate abstaining from taking the undue favourable position of expense refunds for making benefits, appropriate consistency with material laws and controls. Apart from the above issues increasing debt position of the company is the major reason for its failure. In spite of selling the groups equity to Morgan Stanley to put a control over its debt position, the ABC learning founds difficult to stop its liquidation process. In mid 2006 the company witnessed the failure to fulfil its disclosure obligation commitments due to which it was fined by a court of law by $ 1300. This not only affected the monetary position of the company but also placed an impact on the brand image of the group.

3.Major reports issued by ABC learning –

The financial reports are the final summary of numerous data which supports the managing and other business stakeholders in taking decisions. The various reports presented by the management of ABC learning are tabulated below –

No.

Reports

Contents of reports

1.

Reports of financial statements and Income statement

This includes income statement which is comprised of all the incomes and expenses of ABC learning group incurred during an accounting period. This helps to ascertain profitability and loss position of the business enterprise (Jesswein, 2011). Apart from income statement report a financial statement or Balance sheet is prepared which is needed to know the actual financial position of the business at a particular point of time in terms of its assets and liabilities.

2.

Reports of cash flow statement

This statement helps to management the liquidity position of the business group. It helps to know about the fact that in which segment movement of cash is flowing during an accounting period (Sharma & Saha, 2016). This movement of cash position in further segmented into operational financial and investing aspect.

3.

Auditors report

External auditors report describes the accuracy and integrity of the various financial statement presented by the management of the firm. An auditor presents its true and fair view on the financial reports without any biases and unethical approach (Norman, et. al., 2010). 

4.

Board of director report

Future business plans and various operations are disclosed in this report by the directors while addressing it to company’s stakeholders.

4.Why are profits important? Why is cash flow important

Profits are the blood and bone for any business organisation. It is a motivating factor which stimulates the management and other stakeholders to perform in the positive direction. It is basic for the growth and development of any firm. For instance, an organisation planning to expand their business activities seek future profitability and present funds which are attained through increasing profitability. The savings or reserves are created by the firm through regular profit attained by them over the period of time (Vranceanu, 2014). These reserves are then channelized or routed towards a productive use. This will enhance the reputation of business enterprise and this can be witnessed through development in brand value of the group.

Liquidity or the ultimate cash is the basic need for an organisational sustainability. From the routine day to day business operations, repayment of loans or to make an additional investment in the firm’s capital requirements this all require cash. This statement is prepared with the aim and objective of knowing the flow and movement of cash operations in business. Cash flow management was the basic issue which was witnessed in the management of the company. This in turns resulted in the overall downfall of the organisation. Not making proper maintenance of the debt structure of the company there are defaults witnessed in credit repayments which in turn resulted in the downfall of the organsiation.

5.Ethical issues from the case

The fundamental issue that is faced by the ABC Learning which the major reason was for its fall was misappropriation in the presentation of its annual financial statements. This was supported by the unethical behaviour of the auditor by giving the reports in favour of management. There has been an issue of not mentioning the relative party disclosures and payment of low wages to the workers with the company. Concurrently the presentation of financial information in complex approach raised the difficulties of the business. While reducing the quality of the services by lowering the wages of workforce raised the dissatisfaction among the customer base of the firm. 

6.Summary

The above report on ABC Learning collapse showcased the need of importance of ethical accounting as it is important for any organisation sustainability. Along with issues that were aroused in the company various segmented reports presented by the company were also discussed. The importance and relevance of the cash flow statement are analysed in the above group reports.

Question 7 PALER

No.

Trial Balance Expense

Amount

Type of Account

1

Owner investment at the end of the year

15000

Proprietorship

2

Loan Payable

17,300

Liability

3

Rent Expense

23,000

Expense

4

Cash

4,600

Asset

5

Office Supplies

3,300

Expense

6

Salary expense

49,000

Expense

7

Salaries payable

3,400

Liability

8

Property tax expense

1,700

Expense

9

Prepaid expense

8,000

Asset

10

Office Furniture

28,000

Asset

11

Electricity and gas expense

6,500

Expense

12

Accounts payable

2,400

Liability

13

Davis capital

35,000

Proprietorship

14

Service Revenue

155,800

Revenue

15

Accounts Receivable

9,200

Asset

16

Supplies Expense

33,600

Expense

17

Investments

5,000

Asset

Income statement of Bruce Design Studio for the year ended 31st December 2016

ACC566 Account System And Process Assignment Help

Final accounts of Bruce Design studio as on 31st December 2016

ACC566 Account System And Process Assignment Help

The below-mentioned data is summarised from the above-mentioned tables

No.

Particulars

Amount (in $)

  1.  

Net profit earned by the company from business operation is

42,000

  1.  

Drawings made by the proprietor during the financial year

10,700

Question 8 Balance Sheet

ACC566 Account System And Process Assignment Help

No.

Item

Code

Case

Calculation approach

1.

Revenue

K

2

= Net profit + business expenses – Other incomes

2.

Dividends declared

Q

3

= opening balance of retained earnings – closing balance of retained earnings

3.

Net income

E, P

1,3

= Total revenue – Total expenses

4.

Retained earnings (at end of the year)

D,J

1,2

= Opening balance of retained earning – Dividends paid

5.

Paid in capital (at beginning of year)

N

3

= Total capital at the end – additional investments + capital withdrawn

6.

Paid in capital (at end of year)

C,H

1,2

= opening capital – capital withdrawn + additional investments

7.

Total assets (at beginning of year)

F,L

2,3

= Opening ( total liabilities + retained earnings + paid up capital)

8.

Total assets (at end of year)

M

3

= Closing ( total liabilities + retained earnings + paid up capital)

9.

Total liabilities (at beginning of year)

A

1

= Opening ( total liabilities + retained earnings + paid up capital)

10.

Total liabilities (at end of year)

B,G

1,2

= Closing ( total liabilities + retained earnings + paid up capital)

Question 9 Debit and credit balances

 

Accounts with Debit balances

Accounts with Credit balances

1.

Rent expense

Capital balances

2.

Investment account

Payables balances

3.

Receivables balances

Bank and mortgage loans

4.

Cash and bank balances

Debentures

5.

Land and building account

Revenue and income balances

Question 10 Trial balance

ACC566 Account System And Process Assignment Help

ACC566 Account System And Process Assignment Help

Excel formulae presentations

ACC566 Account System And Process Assignment Help

Amended Trial Balance

ACC566 Account System And Process Assignment Help

Question 11 Crossword

Blank Copy

            
            
            
            
            
            
            
            
            

Across

1.Fund invested by the proprietor of shareholder of the business (7 words)

2.Amount paid to the labour as direct expenses (5 words)

3.Profits shared among the shareholders of the company (9 words)

4.Amount withdrew by the proprietor or partner of the firm for personal use (8 words)

Down

1.Resource required for smooth flow of business organisation ( 5 words)

2.Financial obligation that an organsiation need to pay to outsiders ( 9 words)

C

A

P

I

T

A

L

 

 

 

 

 

 

S

 

 

 

 

I

 

 

 

 

 

 

S

 

 

 

W

A

G

E

S

 

 

 

E

 

 

 

 

B

 

 

 

 

 

 

T

 

D

I

V

I

D

E

N

D

S

 

 

 

 

 

 

L

 

 

 

 

 

 

 

D

R

A

W

I

N

G

S

 

 

 

 

 

 

 

 

T

 

 

 

 

 

 

 

 

 

 

 

Y

 

 

 

 

 

Question 12 Types of adjusting entries

Adjustment entries are made after the closure of books of accounts and at the end of financial year. Due to such factor adjusting entries are also referred to as closing business entries. The accounting period in the particular case can be month quarter or a year end. The various example of adjustment entries are detailed below –

Date

Particulars

 

Amount (Dr.)

Amount (Cr.)

1.

Depreciation a/c                                                          

Dr.

9,560

 

 

To Machinery  a/c

Cr.

 

9,560

 

(amount of depreciation charged to the machinery account)

 

 

 

 

 

 

 

 

2.

Prepaid insurance expense  a/c

Dr.

10,400

 

 

To Insurance charges a/c

Cr.

 

10,400

 

(amount of insurance paid in advance which is not relevant to specific accounting year)

 

 

 

 

 

 

 

 

3.

Rent a/c

Dr.

8,800

 

 

To outstanding rent a/c

Cr.

 

8,800

 

(amount of rent outstanding at the year end which is related to the relevant accounting period but still not paid)

 

 

 

4.

Bad debts a/c

Dr.

19,100

 

 

To provision for doubt full debts

Cr.

 

19,100

 

(added certain provision of doubtful debts at the year-end)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Question 13 Current and non-current assets

Basis

Current assets

Non – current assets

Meaning

Current assets are those assets which are meant for short term and are converted into cash within a short duration of time, generally one year. Current assets are generally part of working capital of the firm

These are the asset which is basic for smooth working of business operations and are held by the business organisation for a longer duration

Examples

  1. Cash and bank balances
  2. Debtors and other receivables
  3. Short term investments
  4. Payment in advance
  5. Stock balances

 

  1. Plant & machinery
  2. Furniture and fixtures
  3. Land and building
  4. Long term investments
  5. Loans & business advances

Question 14 Ratios

Ratios are the financial proportion which is needed to analyze and evaluate the financial performance of the organisation in different segments. It is needed to evaluate the performance in terms of profitability, debt, efficiency & liquidity aspects.

Current ratio – This ratio showcase the fact that how much cover that an organisation does have in form of its current assets to repay its current liability on a timely basis. It is a part of liquidity ratios of the firm. The formula of current ratio is equal to current assets / current liability. The ideal ratio in general scenario is 2: 1.

 

Particulars

Amount of $

1

Current asset

8000

2

Current liability

5000

 

Current ratio = Current assets / Current liability

1.6 : 1

Debt ratio – This ratio showcase the proportion of organisational total debt out of total assets of the company. It defines the leverage position of the business group. Total debt here includes the long-term debt as well the current liability of the business firm. The similar to current ratio ideal debt ratio in a firm is 2:1.

 

Particulars

Amount in $

1

Debt (total assets – equity)

6000

2

Total asset

3000

 

Debt ratio = Total debt / Total asset

2 : 1

Question 15 Worksheet and financial reports

ACC566 Account System And Process Assignment HelpNormal Calculation presentation

ACC566 Account System And Process Assignment Help

Excel Calculation presentations

ACC566 Account System And Process Assignment Help

References

1.Jesswein, K., 2011, “Analyzing financial statements with potentially misreported cost of goods sold figures”, Journal of Finance and Accountancy, 6, p.1. Available at –

2.Karabag, S.F. and Berggren, C., 2012, “Retraction, dishonesty and plagiarism: analysis of a crucial issue for academic publishing, and the inadequate responses from leading journals in economics and management disciplines”. Available at - http://files.eric.ed.gov/fulltext/EJ909069.pdf

3.Norman, C.S., Rose, A.M. and Rose, J.M., 2010, “Internal audit reporting lines, fraud risk decomposition, and assessments of fraud risk”, Accounting, Organizations and Society. Available at - http://econpapers.repec.org/article/eeeaosoci/v_3a35_3ay_3a2010_3ai_3a5_3ap_3a546-557.htm

4.Shahabuddin, S., 2009, “Plagiarism in Academia”, International Journal of Teaching and Learning in Higher Education. Available at - http://www.diva-portal.org/smash/get/diva2:582178/FULLTEXT01.pdf

5.Sharma, R.K. and Saha, A., 2016, “A study on impact of cash flow reporting on the individual shareholders’ investment decision making”, Management Insight, 11(2). Available at - http://www.inflibnet.ac.in/ojs/index.php/MI/article/viewFile/3814/3010

6.Tambovcevs, A. and Tambovceva, T., 2013, “ERP system implementation: benefits and economic effectiveness”. Available at - http://www.europment.org/library/2013/rhodes/bypaper/SCSI/SCSI-32.pdf

7.Vranceanu, R., 2014, “Corporate profit, entrepreneurship theory and business ethics”, Business Ethics: A European Review. Available at - https://hal.archives-ouvertes.fr/hal-00823521/document

8.Westerheim A., 2011, “How to Insert an Excel Spreadsheet into Word 2010”. Available at - http://www.ekaru.com/blog/bid/59474/How-to-Insert-an-Excel-Spreadsheet-into-Word-2010

9.Zeng, Y., Lu, Y. and Skibniewski, M., 2012, “Enterprise resource planning systems for project-based firms: benefits, costs & implementation challenges”, Journal for the Advancement of Performance Information & Value, 4(1). Available at -