Plate IQ's Spend Analysis report provides insight into your expenses over time by putting them into categories that make it easy to see where your money is going. Understanding how Spend Analysis works will help you make better decisions when using the report's data.
In this article:
Spend Analysis provides a historical view of your expenses. It groups SKUs (items) into intelligent hierarchies to provide insights at both the line item level and across all your purchases.
Spend Analysis automatically updates with every invoice processed.
You can find Spend Analysis by clicking the Reports tab at the top of the screen and selecting Spend Analysis under Interactive Reports.
Unlike your custom chart of accounts (COA), the Spend Analysis report relies on categories. Plate IQ automatically assigns items to these categories and places them into intelligent hierarchies based on common item groupings:
You can adjust an item's categorization by adding a subcategory (e.g., "Meyer Lemons") or by clicking the X on one or more of the existing categories.
Note: Clicking the X on a category will remove it and any subcategories beneath it. For example, clicking the X on "Produce" would remove Produce, Fruits, and Lemons.
If you have removed a category in error, you can re-add it by entering the category in the Add a Category field.
Categories allow your Spend Analysis report to operate independently of the GL (general ledger) codes you use for accounting, often providing greater detail about your expenses. For example, it may make sense for you to code all food purchases to a Food GL. But catch-all categories don't provide enough detail to know how much produce—or more specifically, avocados—contributes to your spend.
Spend Analysis provides powerful insights into your expenses. The data it provides is essential for understanding where your restaurant's money goes and how you can optimize costs to improve your bottom line.
Filtering the data
Filters let you focus the Spend Analysis report on a specific location, vendor, category, and/or timeframe. Set these filters by using the Location filter at the top left or the Filters on the left sidebar:
When you apply a filter, the report adjusts accordingly, providing detailed information about your expenses. The images below illustrate the difference filters can make:
The image on the left is only filtered by timeframe. The image on the right has filters applied for vendor and category along with timeframe. They're both accurate pictures of a restaurant's expenses, but provide different views into spend.
Spend Analysis reports have three main elements: the pie chart, the bar graph, and the item list. Each provides different insights into your expenses.
The pie chart shows how different categories contribute to your overall spend. To explore a category, click a wedge on the pie chart at the top. The report will update to show the various subcategories that contribute to that category:
The bar graph shows your weekly spend, while the orange line is the average spend for that period. Hovering over one of the bars will show you the total and gives you the option to drill into that timeframe:
The item list shows the individual items purchased during a period. Along with the item name, vendor, and categorization, the item list shows the current and last unit price, the total spent, the cost impact, and the percentage change:
At the core, Spend Analysis focuses on where your money has gone. But there are several options for how you can manipulate the Spend Analysis report to answer specific questions. Examples of questions you might ask include:
- How much money did I spend last week?
- How much did I spend last month with a specific vendor?
- How much did I spend on produce last quarter?
- How has the price of a particular item changed over time?