ACC-360 QuickBooks Assignment 2 (QB2)
Be sure to complete the steps required in the ACC-360 QuickBooks Student Registration Instructions document. Note that there is an additional requirement (enable projects) for this class that has not been used in any other class before.
PURPOSE:
The purpose of this assignment is to have students become familiar with an accounting software package that accommodates budgeting. Students will set up accounts, enter an annual budget, and produce budget related output reports in QuickBooks.
STEP ONE:
Set up accounts.
Go to QuickBooks and login to your company. Choose the “Accounting” menu from the left-hand side of the screen and select “Chart of Accounts.” Click “New” (green button on the upper right side of the screen).
Enter the “Account Type,” “Detail Type,” and “Name” for each of the following six accounts. Enter “Save and New” to enter another account, “Save and Close” when you have entered all accounts.
Name | Account Type | Detail Type |
Equipment Revenues | Income | Sales of Product Income |
Maintenance Contract Revenues | Income | Service/Fee Income |
Marketing Expenses | Expenses | Advertising/Promotional |
Distribution Expenses | Expenses | Shipping, Freight & Delivery |
Customer Maintenance Costs | Expenses | Other Business Expenses |
Administrative Costs | Expenses | Office/General Administrative Expenses |
These accounts should now be shown on your Chart of Accounts. Please note that Cost of Goods Sold should already be on your Chart of Accounts.
STEP TWO:
Prepare a budget.
Using the information provided below, determine the budgeted revenue and expense items for your company for 2022.
The company’s annual income statement for 2021, which is used as a basis for preparing the 2022 budget, is below (shown in thousands):
Additional information to be used in preparing the budget for 2022 are as follows:
1. Selling prices of equipment are expected to increase by 10% as the economic recovery begins. The selling price of each maintenance contract is expected to remain unchanged from 2021.
2. Equipment sales in units are expected to increase by 6%, with a corresponding 6% growth in units of maintenance contracts.
3. Cost of each unit sold is expected to increase by 5% to pay for the necessary technology and quality improvements.
4. Marketing costs are expected to increase by $290,000, but administration costs are expected to remain at 2021 levels.
5. Distribution costs vary in proportion to the number of units of equipment sold.
6. Two maintenance technicians are to be hired at a total cost of $160,000, which covers wages and related travel costs. The objective is to improve customer service and shorten response time.
7. There is no beginning or ending inventory of equipment.
STEP THREE:
Go to QuickBooks and login to your company. Create the budget by clicking on the settings cog at the upper right-hand side of the screen and selecting “Budgeting” under the “Tools” list. Click “Add Budget” and create the budget as a yearly (annual) budget (FY2022). QBs will automatically divide the budget items by 12 to evenly spread over the months in the year. Name the budget “ACC360 QB2.”
Click the “Next” button to enter the budgeted amounts that you calculated in Step Two. After entering all amounts, click “Save.” You will now see a list of budgets that includes the one you just created. From the drop-down menu in the “Action” column select “Run Budget Overview report.” Save your Budget Overview Report for 2022 into a pdf file named “LastnameFirstinitial.ACC360.QB2.”
STEP FOUR:
Submit your pdf file in the digital classroom.
Congratulations! You have completed your assignment.
Data included herein is adapted from problem 6-38 of your textbook.
© 2021. Grand Canyon University. All Rights Reserved.
