PC.3.A.7 - Sales Summaries
- 38 steps
ProAdvisor Challenge
This exercise is a ProAdvisor Challenge provided by Intuit. To find the original, log in to your QuickBooks Online Accountant (QBOA) account, then follow this path:
- In the left navigation bar, hover over ProAdvisor, then click **Training**.
- Click the **Training Library** tab.
- Click **QuickBooks Online** to expand (it may already be expanded).
- Click on the **Sales & customers** tile.
- Click **Advanced Skills** to expand, if necessary.
- Click on the **7. Sales summaries** section.
The exercise can be found towards the bottom of the page, under ProAdvisor Challenge.
*Note: You may need to click through some buttons as you scroll down and answer the Knowledge Check before having access to the ProAdvisor Challenge section.*
The Sample Company
1
To complete this exercise, you must be in the Sample company. To get into it, click on the Gear icon on the top right corner of the screen, then select Sample company.
Note that you will be logged out of your current account. If you are sure, click "Continue" to confirm.
Hands On Practice
Now let's get started with the exercise. As a reminder, here is the scenario:
Craig has started selling items online, and he asked you to help him record a summary of his daily sales into QuickBooks Online from his online reports which include total sales for the day for each individual product.
**Here’s what you need to do:**
- Download the [Products and Services spreadsheet](https://live.intuittrainingplatform.com/filestore/documents/PandS_Spreadsheet.xls) and review it
- Set up any additional accounts needed, such as a clearing account
- Import the Products and Services list in Craig’s QuickBooks Online file
- Record the sales for today, based on the [z-tape report](https://live.intuittrainingplatform.com/filestore/documents/Z-Out.xlsx)
**IMPORTANT:** to complete this exercise, you must download the spreadsheet and report (see links above).
Import
First, we need to import the Products and Services spreadsheet into Craig's QBO.
2
Click the "Gear icon".
3
Click "Import data".
4
In the Select record type field, click the "down arrow".
5
Click "Products and Services".
6
Click "Import".
7
Click "Browse".
On your computer, locate the file "PandS_Spreadsheet.xls" (this will likely be in your downloads folder). Select it and click Open. Once you do, the file will show up like it is in the box below.
8
Click "Next".
Before the file imports, QBO shows you what fields/headings in your file are matching to the fields in QBO. This can always be adjusted, but for the purposes of this exercise, everything is mapping properly and we can move on to the next screen.
9
Click "Next".
One final screen will appear before the import, showing all the details of the file being imported. This can always be adjusted if necessary.
Note that there are red boxes in the QTY fields for MasterCard and Visa, indicating an error. Since these are not products and there are no quantities, this is fine. If they were products, you would want to take a closer look at them before importing.
Everything is good so we can now import the file.
