Financial Reports

 

Run this report...
To see this data...
Financial Analysis ReportLists invoice spend by supplier. Analyze spend by supplier to find suppliers who sell to different business units within your company at different prices, and aggregate total spend into one contract. This report displays financial transaction data for reference document line amount, invoiced amount, and received amount for suppliers, transaction dates, supplier IDs, supplier locations, event types, transaction document numbers, transaction document line numbers, transaction document line unit prices, transaction document line quantities, reference document currencies, reference document numbers, reference document line numbers, reference document split line numbers, reference document line quantities, commodity IDs, account IDs, department IDs, and reference document line amounts in detail view. Drill down or filter data further by transaction date. By default, the report only displays transactions that were carried out in the past 6 months.

Best Practice Tip


Review your
metrics and use
them to guide
your decisions.


With your metrics in
place, you can tell which
strategies are working
and which aren't. If you
make a change, you use
the metrics to tell you
whether the change
improved things or not.

Picture3.png

 

Payment Analysis

 

Run this report...
To see this data...
Lost Payment Discount by SupplierLists invoice payments and lost discounts for suppliers. Gain visibility into your top vendors where your company has missed most of the available payment discounts. Link the discount lost to the respective vendor's invoicing performance to diagnose the potential causes of such losses by analyzing total invoice amount, invoice exception count and early payment discount lost with that supplier within this single report. This report displays invoice spend, invoice payment paid amount, invoice exception invoice count, and discount lost for suppliers in aggregate view. Drill down or filter data further
by supplier and calendar accounting date.
Payment Discount Earned vs. LostLists maximum possible discount and actual earned discount for invoice payments. Track whether vendor early payment discounts have been effectively captured during payment process by analyzing the maximum payment discounts available and the actual discount amount captured. Report also provides details on whether the discounts are earned within terms specified or outside terms. This report displays invoice payment maximum discount and earned discount for discount terms in aggregate view. Drill down or filter data further by discount term, calendar payment date, and supplier. By default,
this report excludes data for the No Discount Available and To Be Paid discount terms.
Payment ForecastLists on hold, pending, and scheduled payments by amount, available discount, and invoice count. Track future payments and discounts by analyzing the to pay amount an the maximum payment discount available (by terms), especially with the ability to forecast pending payments and discounts for invoices that have not yet been approved. This report displays invoice payment amount, maximum discount, and invoice count for payment status by payment created quarter in aggregate view. Drill down or filter data further by payment status, created date, discount terms, net terms, payable status, calendar payment date, and supplier. By default, this report excludes payments with Paid status.
Payment PerformanceLists payment amounts per net term by payment date. Monitor overall vendor payment performance over time by analyzing payments that are made within net terms and payments that are outside net terms. Further drill down by supplier to identify opportunities to improve vendor relations by paying vendors on time. This report displays invoice payment amounts for payment terms by calendar payment date in aggregate view. Drill down or filter data further by payment date, terms, payable status, status, and supplier.

 

P Card Reports

 

Run this report...
To see this data...
P Card Best Practice Tips
Charges Load ReportPurchase card charge loads, grouped by loaded date, purchase card number, and reconcile approvable. This report displays a detail view of purchase card charge load base amounts with loaded date, PCard number, reconcile approvable ID, supplier name, approvable type, charge status, transaction date, PCard holder, and charge ID.
                    1. Secure senior management support while involving key players.
                    2. Establish checks and balances.
                    3. Establish consistent policies across the organization.
                    4. Mandate training for cardholders and card managers before a card is issued.
                    5. Establish protective controls up front.
                    6. Use technology to streamline back-end auditing.
                    7. Audit beyond the traditional.
                    8. Foster positive relationships with cardholders.
                    9. Conduct periodic peer reviews before official audits occur.
                    10. Network to gain new ideas.
                    *Based upon JPMorgan PCard Survey
                    PCard Charge Reconciliation ReportApprovable purchase card charge amounts, grouped by PCO # and reconcile
                    approvable status. This report displays a detail view of purchase card charge amount and tax amounts with PCO #, reconcile approvable status, reconcile approvable ID, reconcile approvable ID line number, PCard number, transaction date, loaded date, and description. Drill down or filter data further by approvable type and reconcile approvable ID; by default, the report only displays PCard charges of type Procure.

                     

                    Procurement Content Reports

                     

                     

                    Run this report...
                    To see this data...
                    Best Proactice Tip for e-Catalog Success
                    Catalog AggregationA summary of catalog content by supplier and commodity. This report displays an aggregate view of catalog item count for suppliers and top-level commodity categories.
                    • A successful catalog technical lead will need to have the skills required to understand content requirements, educate suppliers on these requirements, cleanse and manipulate large amounts of catalog data, and troubleshoot technical errors that may occur during the enablement.

                     

                    • Depending on your industry, services can be one of the largest spend categories and is often overlooked.

                     

                    • According to Aberdeen, Best-in-class organizations do at least 74 percent of their buying through an eCatalog.

                     

                    • The time from catalog upload to availability in production is less than three days at a best-in-class organization.
                    Checkout SummaryA summary of checkout requisition data for catalog items. This report displays a detail view of requisition quantity, unit price, and spend by supplier, top-level commodity category, and manufacturer, with unit of measure, cost center or department, description, requisition line number, and requester. Drill down or filter data further by business unit ID.
                    Catalog vs. Non-Catalog ItemsA comparison of catalog and non-catalog checked out commodities at the requisition line level. This report displays a detail view of requisition spend and line count by line type and top-level commodity category with unit of measure, cost center or department, requisition line number, requisition ID, and requisition date. Drill down or filter data further by business unit ID, supplier, and manufacturer
                    Top Items Purchased by PunchOut vs. ContainedA comparison of how many requisition lines are for punched out versus contained items, with details of those requisition lines. This report displays a detail view of requisition line counts for punched out and contained items and top level commodity categories with unit of measure, cost center or department, description, requisition ID, and requisition date. Drill down or filter data further by business unit ID, supplier, and manufacturer.
                    Total Number of Items PurchasedAn overview of the number of requisition lines for each commodity, with details of those requisition lines. This report displays a detail view of requisition line counts by top level commodity category with unit of measure, cost center or department, description, requester, requisition ID, requisition line number, and requisition date. Drill down or filter data further by business unit ID, supplier, and manufacturer.

                     

                    Purchase Order Reports

                     

                    Run this report...
                    To see this data...
                    Catalog vs. Non-Catalog Ordered ItemsA comparison of catalog and non-catalog commodities in purchase orders. This report displays a detail view of purchase order spend and line counts by line type and top-level commodity category with unit of measure, cost center or department, description, PO line number, PO status, PO ID, user, and ordered date. Drill down or filter data further by
                    business unit ID, supplier, and manufacturer.
                    Order Details by Commodity and SupplierPurchase orders, grouped by commodity, supplier, and purchasing business unit. Identifies what items your company is ordering, from which suppliers, and which parts of the company are placing the orders. This report displays a detail view of PO unit price, quantity, and spend by top-level (L1) commodity category, supplier, and business unit ID, with unit of measure, department or cost center, description, PO line number, PO status, ordered date, and PO ID.
                    Order Summary by CommodityPurchase orders, grouped by commodity and supplier. Provides a basic view of what commodities your company is ordering and from which suppliers. This report displays a detail view of PO spend by top-level (L1) commodity categories and suppliers, with ordered date, description, PO status, and PO ID. Drill down or filter data further by business unit ID.
                    Order Summary by Contract and CommodityPurchase orders, grouped by contract and commodity. Provides a basic view of the contracts your company is purchasing against and what items are being ordered. This report displays a detail view of PO spend by contract ID and top-level (L1)
                    commodity category, with ordered date, description, PO status, PO ID, and supplier.
                    Order Summary by Contract and Department or Cost CenterPurchase orders, grouped by contract and department or cost center. Provides a basic view of the contracts your company is purchasing against and which parts of your company are placing the orders. This report displays a detail view of PO spend by contract and department or cost center, with ordered date, PO status, PO ID, and supplier. Drill down or filter data further by business unit ID.
                    Order Summary by Department or Cost CenterPurchase orders, grouped by department or cost center, commodity, and supplier. Provides a basic view of which parts of your company are placing orders, what items they are purchasing, and from which suppliers. This report displays a detail view of PO spend by department or cost center, top-level (L1) commodity category, and supplier, with ordered date, PO status, and PO ID. Drill down or filter data further by business unit ID.
                    Order Summary by SupplierPurchase orders, grouped by supplier, department or cost center, and commodity. Provides a basic view of which suppliers your company is purchasing from, which parts of your company are placing the orders, and what items they are purchasing. This report displays a detail view of PO spend by supplier, department or cost center, and top-level
                    (L1) commodity category, with ordered date, PO status, and PO ID. Drill down or filter data further by business unit ID.
                    Orders by Commodity and DepartmentPurchase orders grouped by commodity and department or cost center. Provides a detailed view of what items your company is purchasing and which parts of the company are placing the orders. This report displays a detail view of PO quantity, unit price, and spend by top-level (L1) commodity category and department or cost center, with unit of measure, supplier, description, PO line number, ordered date, PO status, and PO ID. Drill down or filter data further by business unit ID.
                    Orders OverviewPurchase orders, grouped by supplier. Provides a high-level overview of the purchase orders placed with each supplier. This report displays an aggregate view of PO count, spend, and average spend by supplier. Drill down or filter data further by purchasing company business unit ID.
                    PCard Order DetailsPurchase orders, grouped by PCard number and holder. Identifies which PCards are responsible for purchase orders and who holds those cards. This report displays a detail view of PO spend by PCard number and holder, with PCard expiration date, PO ID, PO status, ordered date, supplier, PO line number, and department or cost center.
                    Purchase Order ActivityPurchase orders, grouped by line type. Provides a high-level view of catalog vs. noncatalog purchase order spend; drill down and filter data further to identify where the non-catalog purchase order spend is coming from. This report displays an aggregate view of PO spend, counts, and line counts by line type (catalog vs. non-catalog). Drill down or filter data further by business unit ID and ordered date. Use the detail view to examine PO ID, ordered date, requester, ERP supplier, account ID, account, department or cost center ID, department or cost center, accounting company GL business unit, and
                    business unit ID.
                    Purchase Price Variance by CommodityCommodities and price variance data, to help you understand the impact of price variance on your company’s spend. This report displays an aggregate view of PO spend, price variance cost and percentage, and PO count for top-level commodity
                    categories. Drill down or filter data further by commodity, ordered date, supplier, company, account, company code, part name, unit of measure, contract, IsPunchOut Item, and line type.
                    Requisition Total by SupplierPurchase orders, grouped by supplier. Provides a high-level view of purchase order spend with each supplier. This report displays an aggregate view of PO spend and line counts by supplier. Drill down or filter data further by business unit ID.
                    Spend Concentration Analysis by CommodityAn overview of how many purchase order lines account for spend on each part in commodity categories. This report displays an aggregate view of PO total line count and average spend per part by top-level commodity category. Drill down or filter data further by supplier, company code, part name, contract, IsPunchOut Item, and line type.
                    Spend Penetration by CommodityAn overview of commodity spend by quarter. This report displays an aggregate view of PO spend by top-level commodity category for the past eight quarters. Drill down or filter data further by ordered date, supplier, company code, account, part name, unit of measure, contract, IsPunchOut Item, and line type.
                    Top Items Ordered by PunchOut vs. ContainedA comparison of how many purchase order lines are for PunchOut versus contained items, with details of those purchase order lines. This report displays a detail view of purchase order line counts for punched out and contained items and top level commodity categories with unit of measure, cost center or department, description, PO line number, PO status, ordered date, and PO ID. Drill down or filter data further by business unit ID, supplier, and manufacturer.
                    Total Number of Items OrderedAn overview of the number of purchase order lines for each commodity, with details of those purchase order lines. This report displays a detail view of purchase order line counts by top level commodity category with unit of measure, cost center or department, description, PO line number, PO status, ordered date, and user. Drill down or filter data further by business unit ID, supplier, and manufacturer.

                     

                    Requisition Reports

                     

                    Run this report...
                    To see this data...
                    Commodity DetailsRequisitions, grouped by commodity. Provides a detailed view of what items your company is requisitioning. This report displays a detail view of requisition quantity, unit price, and spend by top-level (L1) commodity category, with unit of measure and requisition ID.
                    Department or Cost Center DetailsRequisitions, grouped by business unit, department or cost center, and commodity. Provides a detailed view of which parts of your company are generating requisitions and what items they are requisitioning. This report displays a detail view of requisition quantity, unit price, and spend by business unit ID, department or cost center, and top-level (L1) commodity, with unit of measure and department or cost center.
                    Requisition DetailA list of requisitions with both header and line item information. Provides a detailed view of all of your company’s requisitions. Filter on any of the non-total columns to narrow down the data the report displays. This report displays a detail view of requisition quantity, unit price, and spend with unit of measure, department or cost center, supplier, description, PO ID, requisition line number, requisition date, requisition status, requester, requisition title, and requisition ID.
                    Requisition SummaryA list of requisitions. Provides a basic view of all of your company’s requisitions. Filter on any of the non-total columns to narrow down the data the report displays. This report displays a detail view of requisition spend with requisition status, requisition date, requisition title, preparer, requester, and requisition ID.
                    Supplier DetailsRequisitions, grouped by supplier and commodity. Provides a detailed view of which suppliers your company is generating requisitions with and what items they are for. This report displays a detail view of requisition quantity, unit price, and spend by supplier and top-level (L1) commodity category, with unit of measure, description, and requisition ID.
                    Requisition Approval Cycle Time
                    Requesters with the Longest Approval TimeRequests, grouped by requester. Identifies the requesters whose requisitions take the longest to approve or deny requests. This report displays a detail view of request approval time, count, number of approvers, and approver approval time by requester, with request ID, type, status, and submitted date. Drill down or filter data further by approved/denied date and status; by default, the report only displays requests with Approved or Denied status.
                    Requisition Approval Time by Originating DocumentApproval data for requests. Identifies which departments are taking the longest to approve or deny requests. This report displays an aggregate view of request approval time, approver approval time, number of approvers, request count, and average requisition amount. Drill down or filter data further by requesting management or users, status, and type. Use the detail view to examine request ID, type, status, and submitted date. By default, the report only display requests with Approved or Denied status.
                    Requisition Approval Time by Size of RequisitionApproval data for requests. Provides an overview of requisition approval efficiency and helps you determine whether the size of a requisition is related to its approval cycle time. This report displays an aggregate view of request approval time, number of approvers, approver approval time, and request count. Drill down or filter data further by approved/denied date, requesting management or users, status, and type. Use the detail view to examine request ID, type, status, and submitted date.
                    User Activity
                    Active Approvers by Month (XLS)The number of users approving requests in each month. You can export this report with the associated Excel template. This report displays an aggregate view of the number of users by submitted/approved month. Drill down or filter data further by activity type, document type, and user. Use the detail view to examine users, submitted/approved date, document type, and activity type. By default, the report only displays data for the Approved activity type.
                    Active Requisitioners by MonthThe number of users submitting requisitions in each month. You can export this report with the associated Excel template. This report displays an aggregate view of the number of submitters by submitted/approved month. Drill down or filter data further by activity type, document type, and user. Use the detail view to examine users, submitted/approved date, document type, and activity type. By default, the report only displays data for the Submitted activity type and the Requisition document type.

                     

                    Picture3.png

                    Link to part 1 of this post below.

                    Ariba Procurement Reporting Part 1

                    ___________________________________________________________________

                     

                    This has been another Knowledge Nugget post brought to you by Beverly Dunn.

                    For more information or details please feel free to contact me!