Report Title: Spend Analysis by GL
Category: GL
Available to: All users
Pricing Package: Basic
Overview
Spend Analysis by GL is a summary of the Purchase Detail report. It simply aggregates the total amount spent grouped by GL Account.
This report is commonly used to summarize spend across a user-defined set of accounting categories (General Ledgers).
Dashboard View
Filters
Filter | Meaning |
---|---|
Group | Group of locations to run the report on. To run the report on all location, 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. |
After Export Date | If chosen, the report will include only invoices that were exported after a given date. This is commonly used for historical accruals. |
Vendor | To view un-accrued 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 |
---|---|
Account Number | General Ledger Account # as it exists within Plate IQ. This only appears in the Spend Analysis by GL report if spend for this GL Account is > 0. |
Account Name | GL Account Name that the Account Number corresponds to |
Amount | Sum of the spend for the above GL Account, less tax |
Tax | Sum of tax spent for the above GL Account |
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