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 |
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 |
Sample
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article