ACCY231 Accounting Information Systems Assignment Brief Spring 2025

ACCY231 Data and tools required: 

1. Access to the Case Study: 

To complete the first component of the project, students are required to obtain access to the case study published by Harvard Business School Publishing. The lecturer will provide detailed instructions on how access will be granted. 

2. Software Requirements for Part Two (Excel report): 

The second component of the project necessitates the use of Microsoft Excel or Power BI for Windows, both of which are available in the university's computer labs. Students planning to work on personal laptops, particularly Mac devices, must ensure compatibility by opening their files on a lab computer—ideally the one used during tutorials—prior to submission. This step is essential to confirm that all features function correctly. 

3. Dataset Requirement for Part Two (Excel report): 

For the second part of the project, students are required to download a segment-level sales and profit dataset. A sample dataset has been uploaded to Moodle by the lecturer and is available for use. Alternatively, students may opt to select a multinational company (excluding those operating in the financial or real estate sectors) headquartered in either the United States or Australia, and download the relevant sales and profit data for that company. 

4. Software Requirements for Part Three (QuickBooks report): 

The third component of the project involves the use of QuickBooks Online, a cloud-based accounting software. Access to QuickBooks has been provided to all students through a shared subscription. Students are required to use their UOWD email address to register and complete this portion of the assignment. Furthermore, students must grant full access to their QuickBooks accounts, enabling the teaching professor to evaluate their work directly within the application.

ACCY231 INSTRUCTIONS 

(a) General Instructions 

Prepare and submit your assignment on or before the due date/ time and state the number of words towards the end of the assignment. Please make sure your submission is in the format of MS WORD and notPDF. Since this is an individual assignment, you are expected to work independently.

Please ensure that your work demonstrates your effort. At UOWD, plagiarism is considered a serious academic misconduct. Any allegations of that, once substantiated, may lead to a mark deductionor the award of a mark of zero. Plagiarism involves copying from another source and represent that as your own work without proper acknowledgment.

You are required towrite in your own words. Please be reminded that marks will only be awarded if there is a reasonably cogent discussion. Only minimalmarks will be awarded to answers that are presented in bullets, incoherent answers or answers that are hard to understand due to language issues. No marksor minimal marks will be awarded for direct copying and pasting and insufficient paraphrasing.

b) Presenting Written Work for Assessment 

Presenting your academic work professionally is really important. The following is some guidelines relating to the presentation and submission of written assignments.

1. You should include your name and student number in a cover page of your submission. 
2. The file name should take the following form: 12345678-Sharma-PrikshatAbi.docx; with Sharma Prikshat Abibeing the student submitting the assignment. 
3. The assignment is required to be on A4 paper and word-processed in 12 font Times New Roman with a minimum of 1.5 line spacing. 
4. All pages are to be numbered. 
5. Margins should be as follows: Top: 1 inch, Bottom: 1 inch (2.5 cm), Left: 1.25 inches, Right: 1.25 inches (3.2 cm) 
6. Work should be in English (UK) and grammatically correct with careful attention to sentence construction, syntax and spelling (vii) Use APA style referencing. For more information about referencing and citing, please visit this site: https://www.uow.edu.au/student/learning-co-op/referencing-and-citing/.

ACCY231 PART II. EXCEL / POWER BI PROJECT (40%) 

Your manger starts explaining this section of your assignment by emphasizing that the successful completion of this task will play a crucial role in your future career in accounting. As a result, he strongly advised you to meticulously clean, analyze, and visualize the provided dataset using either Microsoft Excel or Power BI.

To carry out this task, you are instructed to use the datasets uploaded to Moodle—namely, ACCY231FinalProjectExcelDataset_Salesand ACCY231FinalProjectExcelDataset_Discount.1After downloading the files, you are required to create an interactive Excel dashboard that provides a clear, visual summary of the company's performance at a glance.

Your manager has highlighted the importance of making the dashboard interactive and visually informative, using appropriate graphical elements such as bar charts, 3-D stacked column charts, pie charts, treemaps, world maps, line graphs, and others. Each visual should be accompanied by clear titles and legends for ease of interpretation. Additionally, your dashboard should incorporate spark lines to illustrate historical trends and use conditional formatting with directional arrows to emphasize changes in performance, thereby enhancing the clarity and impact of the data presentation.

The first step in developing the dashboard involves identifying the most relevant information for analyzing sales and profit data from 2021 to 2025. Once data cleaning is complete, you are expected to visualize key performance indicators (KPIs) critical to business success. Specific KPIs that must be included are outlined in the instruction section provided below. 

ACCY231 Instruction: 

ACCY231 PART III. QUICKBOOKS PROJECT (35%) 

During your initial meeting at Starbucks, your manager began by emphasizing the significance of this project, noting that it serves as a valuable opportunity to develop practical, hands-on experience. The project is designed not only to enhance your technical proficiency with accounting software but also to simulate real-world decision-making and financial management within a business environment.

He added that this component of the project requires you to utilize QuickBooks Online, a cloud- based accounting software, to record accounting transactions and generate financial reports. To complete this assignment, you are expected to establish your own fictitious retail company and create simulated data covering a two-month period—from June 1 to July 30, 2025. 

As the business is operated as a sole proprietorship, you will assume dual responsibilities as both the manager and bookkeeper. Accordingly, you must configure the company's books in QuickBooks Online, process day-to-day transactions, and manage key monthly accounting functions such as report generation, account reconciliation, and sales tax tracking and filing. The business will officially commence on June 1, 2025, with an initial capital investment of AED 5 million, deposited into the business bank account to cover startup expenses. 

Your project should include the following components: 

1.Provide a one-page overview describing the background and nature of your business. 
2.Compile a detailed list of customers, suppliers, products, and services associated with your business. 
3.Prepare a complete list of transactions for the two-month period (June 1 - July 30, 2025). 
4.Configure your organization's details within QuickBooks Online, entering all relevant company information.

5.Set up the GST framework:

• Tax on Purchases: 5% 
• Tax on Sales: 5%
• Tax Exemption: 0% 

6.Update the Chart of Accounts: 

• Delete unnecessary default accounts. 
• Add new accounts as needed. 

7.Configure the invoice settings, including the upload of your business logo and relevant contact details. 
8.Add a minimum of 10 customers and 10 suppliers to your records. 
9.Add at least 6 products and 2 services to your product catalog. 
10.Add at least two bank accounts. 
11.Set up a minimum of 10 tracked inventory items. 
12.Create at least three purchase orders per month. 
13.Record received items using the bill form for each purchase order. 
14.Process bill payments as follows: 

• Pay 50% of suppliers in full at the end of each month. 
• Provide partial payments to 30% of suppliers monthly.
• Defer payments for the remaining 20% to the following month.