Certify Purchasing has a large set of reports which enable administrators and managers to analyze spend data. The Spending Report is a permission based report which allows you to view spend totals by product category, and vendor. By having this level of spend visibility, users may perform leverage buying with their vendors while analyzing expense trends.
This article will show you, an Accounts Payable Administrator, how to access and run the Spending Report.
Step 1: On your Certify homepage, click the Purchasing tab.
Step 2: Click Go to Purchasing.
Step 3: This is your Purchasing dashboard. Click the Reporting tab.
Step 4: In the Spending Reports box, click Spending.
Step 5: First choose the Report Type by picking Vendor or Product Category.
Step 6: Choose a Date Range for the report by choosing a date from the drop-down menus.
Step 7: Choose your Department from the drop-down menu.
Please Note: By checking Consolidate Child Departments, you will be aggregating spend for the chosen department, as well as any child departments within it. By checking Consolidate Categories, you will be aggregating spend on the product category level.
Step 8: When finished entering the report criteria, click Run Report.
Step 9: The report will show below. To view the spend totals month by month, click Expand Totals by Month.
Step 10: Click Export to Microsoft Excel to save the report to your computer.
Step 11: To move from vendor level to product category level, click on a Vendor name.
Step 12: To move from the product category to the product detail level, click the product category.
Step 13: The product details will show below.