QB POS Help – Sales Reports

Probably one of the best QB POS tools available for management of the retail operation is the report center.  QuickBooks allows for almost complete customization of reports. QB POS has a robust reporting system. It enables the manager to run a large variety of reports needed to make managerial decisions. QuickBooks Reports also allow you to customize the reports almost exactly to the level you need, of course, with a few exceptions.

Matching Items Sold with Existing Inventory

Before we learn about what it can do, let’s talk a bit about what it cannot do. While the QuickBooks POS allows the user to customize reports very specifically, one thing that it will not do is run a report that places the item’s quantity in stock along side the same item’s quantity sold. This type of report is sometimes needed for procurement, so data manipulation in either MS Excel or, preferably, MS Access is required. Unfortunately, matching data in Excel is cumbersome; however, MS Access will provide a better alternative due to the ability of Access to run reports on key field such as UPC codes.

Return to QB POS Menu



Sales Reports

The various reports that QuickBooks POS can run outweigh by far the number of reports that it cannot run. The following reports are just a glimpse of the reports that are possible in QuickBooks POS when the database is setup correctly:

  • Wine Sales
  • Beer Sales
  • Tobacco Sales
  • Spirit Sales
  • Specific Product Sales
  • Best Sellers
  • Worst Sellers
  • Time Reports
  • Sales by Department
  • Many other customizable reports

This section identifies the reports that can be run quickly. It also helps the user recognize the methods used within QuickBooks POS that allow the user to run customized reports. Let’s start with basic sales reports that can be created without customization.

Sales Reports

Sales reports help management make decisions about what products to purchase and what products to avoid in the future. The most detailed sales report is the “Item Summary,” which shows all the product sales over the period specified by you. Sometimes, however, this report is too detailed when management is attempting to make a quick assessment regarding products. When this is the case, there are a number of other reports that can be run without major customizations that will allow you to find the detail that you need for making the right management decisions.     

Best and Worst Sellers

The best and worst sellers report is a quick method for discovering the products that are doing the best and worst in the organization. To run a Best and Worst Seller report, do the following:

1.   Select “Reports” and hold your mouse over “Sales.”

2.   Select “Best and Worst Sellers.” The following screen will appear:

3.   The best and worst sellers report is generated; however, there may be some modifications that you’ll need to make after you’ve generated this report. First, let’s look at the report:

4.   From the report, we may find that the date range is too long.

5.   To change the date, either click in the textbox and change the date or click on the calendar to make adjustments to the date according to the calendar, as shown below:

6.   After you’ve selected the new date range, select “Apply date range.” You will notice that one of the columns in the report has a green arrow. The column, in which this arrow is located, is the column that has been sorted. In this case the sorted column is on the quantity sold. If you would like to sort on another column, simply click that column header and the columns will sort automatically.

7.   One last thing you might need in the report is a new column with the UPC. Having the UPC allows management to use that particular UPC to assess how that specific product is doing. Click on “Modify” in order to add or filter data.

8.   After selecting “Modify,” a window will appear. Select “Add or Remove Columns” and as shown below.

9.   If you would like to add the UPC column to the report, select UPC from the list and click on “Save.”

10.  One you click on “Save,” the previous window will be active; you’ll need to click “Run” in order to generate the report with the required fields. After the report is generated, you may want to rearrange the columns so that some appear before others. To do this, select the column header that you like to move (in this case, we’ll move the UPC column over):

11.  When you click on the column and begin dragging it from one location to another, a little red arrow will appear on the screen that indicates where the column would appear after you release the mouse, as shown below:

Latest News

How easily can your members get in touch with you?


Read More

AEA Portal Set to Launch Website Services

After four years of planning and development, AEA Portal will begin offering its website services and associated applications to Eligible

Read More

Breaking out of the Glass

AEA Portal helps employee associations break the glass walls of localized service. If you are an association General Manager, contact

Read More

View All News