Purchase Items Report Overview

Purchase Items Report Overview

What Is Purchase Item Report?

The Purchase Item Report shows a detailed list of each of your Inventory Items sold. See the time, place, employee, comps, and more that are associated with the item at the time of sale. The report is highly customizable offering many filters and expanded options. This article provides a brief overview of the Purchase Item report. 

Prerequisites
  1. To view this report in Arryved Portal, you must be a Portal Super Admin or an Admin with one of the following Portal Permissions:
    1. REPORTING
    2. ALL ACCESS
    3. FULL ADMIN

Limitations

  • Depending on how much data you are generating in the report, it may take a few extra seconds to load. If you aren’t using any filters, and searching the report over multiple days, there will likely be a lot of data, slowing down the report. 

  • The report lists items sold with the timestamp of order. This means that sales of the same item are not totaled together. For example, if you sold 48 pints of your IPA in a day, the report will list the sale of that beer roughly 48 times (unless multiples were ordered at the same time on the same tab).

  • In Arryved reporting, Flights are recorded as a single Item when sold. The individual child Items sold within the Flight are also individually reported. Keep this in mind and beware of double-reporting on Flights in your taxes. 

How It Works

Find The Report

  1. Head to your Arryved Portal with the proper Permissions.

  2. From the left side navigation, click Reporting.

  3. Click Sales.

  4. Click Purchase Items.

  5. Use the filters, if desired.

  6. Use the calendars to select a range of days to view the report. 

  7. Click Preview or one of the Download options. 

Filters

The Purchase Item report is one of the most customizable reports we offer. If you choose no filters, the report will list the details of every single Inventory Item sold during the time period the report is showing. To narrow your search to your specific needs, you can use any number of the filters offered at the top of the report. 



In this example image, by using filters, you can see how many Tacos you comped for Father’s Day on the Patio!

Basic Filters

  • Venue

  • Item Types

  • Category

  • Item Tags (Tags assigned to Inventory Items in Arryved Portal)

  • Item Size (Unit Size)

  • Tab Tags (Tags added to tabs in Arryved Service)

  • Comp Types

Other Filter Options

  • Show

    • From the “Show” filter, choose Promo, Non-Promo, or All. 

    • The default is All if no filter is selected. 

    • Promo = any item that was $0 at the time of payment. This includes 100% Item Comps, 100% Tab Comps, or Items redeemed with Offers or Rewards from Arryved Insider. 

      • Flights are also listed here because the Flight as a whole is a $0 item and the price is attached to the individual items in the flight. 

  • Report on 

    • From this filter, there is one choice, “Type.” Select Type to show the Item Type and Category of each Inventory Item on the report.

  • Show Detail

    • Check this box to add additional columns to this report including:

      • Employee: The employee who sold the item.

      • Note: Any notes added to the order screen. This is a hand-typed modifier. 

      • Tab Description: The name on the tab. 

      • SKU: If the Inventory Item has a SKU, that will show in this column.

      • COGS: Cost of Goods Sold. COGS are entered manually to Inventory Items in Arryved Portal. COGS is not available in Portal by default. Contact Arryved Support for more information. 

  • Hide

    • Check the “Hide” box next to any filter to exclude that filter from the report rather than filter by it. 

  • Remove

    • To remove a filter, open the dropdown, scroll to the bottom of the list of options for that filter and click REMOVE.

Report Columns

These are the default columns in the report without checking the “Show Detail” box or adding the “Type” columns from the “Report On” filter. 


Description

  • Name of the Inventory Item.

External ID

  • The "Conversion ID" for this Item and Unit Size. Conversion IDs are used for certain Arryved integrations.

Venue

  • Which Venue the item was ordered from. 

Size

  • The Unit Size of the item sold. 

Check

  • The check # of the tab that the item was ordered on. 

Time

  • The time that the item was ordered. 

Item Cost

  • Price of the item on your menu. 

Quantity

  • Quantity of that item ordered at that same time on the same tab. 

Item Comps

  • If the item itself had a Comp applied. 

Tab Comps

  • If there was a Comp on the entire tab from which the item was ordered.

Item Amount

  • Price of the item minus any Item Comps applied. 

Amount Less Tab Comps

  • Price of the item minus any Tab Comps applied. 

Included Tax

  • If the Item has Inclusive tax, the tax amount is shown here. 

Add-on Tax

  • If the Item has add-on tax, the tax amount is shown here. 

Deposit/+Tax

  • Any Deposit money or Use Tax collected on the item. 

Tab Tag

  • Any Tab Tags applied to the tab that the item was ordered from. 

Item Tags

  • Any Item Tags applied to the Inventory Item in Arryved Portal. 

Applied Comps

  • The name of any Comps applied. 

SKU

  1. If any of the Inventory Items has a SKU associated with them, that will appear here. 

Related Articles

Sales Activity Report Overview

Category Sales Report

Item Type Sales Report

 

 



    • Related Articles

    • Daily Item Size - Quick Report Overview

      What Is The Daily Item Size Report? The Daily Item Size report is one of the Quick Reports available in Arryved Service. This report shows the quantity of each item sold by their individual Unit Sizes. The report is useful for seeing if you may need ...

    • Added Modifiers Report Overview

      What Is The Added Modifiers Report? By searching for a date or range of days, the Added Modifiers report shows a list of all Item Modifiers or Forced Modifiers added to orders through the Arryved POS modalities during that time. The report will ...

    • How To Create Inventory Items

      What Is Inventory In The Arryved Portal? In the Arryved Portal, you will create all of your possible menu items as Inventory Items. Inventory Items can be any menu offering from food, drinks, beverages on draft, merchandise, etc. This article will ...

    • Altered Tab Forensics Report Overview

      What Is Altered Tab Forensics? Altered Tab Forensics is a report that records any voided payments or orders with items removed. This article provides an overview of the report. Prerequisites To view this report in Arryved Portal, you must be a Super ...

    • Category Sales Report Overview

      What Is The Category Sales Report? The Category Sales report shows a summary of your Inventory Items sold broken down by Category. Categories are preset from Arryved and assigned to your unique Item Types. For Example, if you have an Item type called ...