Purchase Detail (Legacy)

Modified on Tue, Feb 13 at 3:36 PM

Report Title: Purchase Detail

Category: General

Available to: All users

Pricing Package: Basic

Overview

The Purchase Detail report is essentially a data dump of all purchasing data including items, GL accounts, purchase quantities, and prices all broken out by invoice.

Purchase Detail can answer most questions a user might have about their spend including:

What is my total spend month week over week?
What is my spend by GL Account for a given time period?
What is my spend by Vendor?
How many invoices do I get per period?
etc.

Best practices for this report include filtering and pivot tables in Excel / Google Sheets.

How to use Filters in: Excel / Google Sheets
How to use Pivot Tables in: Excel / Google Sheets

Dashboard View

Filters

Filter	Meaning
Group	Group of locations to run the report on. To run the report on all locations, leave this blank.
Location	To run a report for a single location, select the location's Group, and choose the location from the dropdown.
Invoice Date Range	A date must be selected, so either choose a pre-filled Date Range including today's date, yesterday, the last 7 days, month to date, last 30 days, last 3 months, last 1 year, or a custom Date Range.
Invoice Date	Mandatory date field that is pre-populated if a Date Range is selected, or can be manually populated by entering a start and end date. These dates are inclusive, meaning 06/01/19 will return data from June 1st as well.
Vendor	To view invoices from a particular vendor
Email	Pre-populated with the user's email address. Additional emails can be included by appending other comma-separated emails.

Data

Column	Meaning
Location	Location of the invoice
Account Number	GL Account # that the item is mapped to
Account Name	GL Account Name that the item is mapped to
Category Name	Item's category. Note: Categorization can come from either (a) a user or (b) Plate IQ. User categories are saved at the Location-level, and take precedence over Plate IQ-created categories. Plate IQ does not guarantee categorization, but we do our best.
Invoice Number	Invoice number, as it's read on the invoice
Invoice Date	Invoice date, as it's read on the invoice
Exported Date	Date the invoice was exported from Plate IQ
Created Date	Date the invoice was uploaded to Plate IQ
Vendor Name	Vendor, as it's read on the invoice
Accounting Vendor ID	The ID for this vendor found in your Accounting System
Item ID	Plate IQ ID for this item. Since not all items have SKUs, you can use this ID as a primary key for the item for your reporting needs
Item Name	Item name, as it's read on the invoice
Item SKU	SKU (Stock Keeping Unit), as it's read on the invoice
Unit	Unit, as it's read on the invoice
Pack Size Label	Pack Size Label, as it's read on the invoice
Price	Price, as it's read on the invoice
Quantity	Quantity, as it's read on the invoice
Amount	Price * Quantity
Tax	If item is taxable, then (Price * Quantity) * tax rate
Total Amount	Amount + Tax