Data Explorer
      Back to home
      1. Knowledge Base
      2. Reporting and Data
      3. Data Explorer

      Using the Unfavorable Item Variance Report

      Variance between Order Item and linked Bill Item prices

      Table of Contents

      1. Viewing the report
      2. Information covered in the report


      Available with any of the following subscriptions, except where noted:

      icon-procure-to-pay    Procure-to-Pay

      The Unfavorable Item Variance Report offers valuable insights into the financial differences between the Orders created in CureMint and the Bills received from Vendors. You always have the option to approve and pay bills with exceptions, knowing that the variance calculation will be available for you to dispute bills with vendors in more efficient and aggregated way. This data empowers you to approach vendors with a summary of any overcharges accumulated over a specific period, allowing you to dispute and potentially receive credit notes and refunds.

      Viewing the report

      The Unfavorable Item Variance Report is a custom report located in the Data Explorer.

      • In your CureMint account, navigate to Data Explorer > Explore.
      • In the drop down select Custom Reports
      • Navigate the enabled custom reports for your organization and select the Unfavorable Item Variance Report

      • By default the date range of the report is Year-to-Date but you can adjust the date range using the Date Range filter.

      Please Note: The Date Range filter is tied to the CureMint Posting Date.

      • The report will show a preview of the report
      • Select Export to Email to receive the full report
        • The report will be sent to your email address
        • You can also download it from CureMint by navigating to Data Explorer > My Exports

      Please Note: Export times may vary depending on the report's size. All exports will be in .csv file format.

      Information covered in the report

      • The report includes a row for each Bill Item that meet the following criteria:
        • Bill items that are linked to an Order Item
        • Bill items that have a unit price greater than the unit price of the linked Order Item

      Caution: Not all variances and exceptions will be included in this report. Exceptions such as unlinked bill items and quantity issues will be excluded. Additionally, selecting the update PO button on a bill will remove the variance between the linked item.

      • The following data will be included in the report

      Vendor
      • The vendor linked to both the bill and order.

      Order Number
      • The order number uniquely identifies the order to which the linked order item belongs.

      Bill Number
      • The bill number serves as a unique identifier for the bill that the bill item is associated with.

      Bill Stage

      CureMint Posted Date
      • The date in which the bill was posted into CureMint.

      Bill Date
      • The date designated to when the vendor created the bill.

      Due Date
      • The date designated by the vendor of when the balance is due.

      Bill Item Chart of Accounts
      • The chart of accounts to which the bill item is assigned.

      Bill Item Location
      • The location to which the bill item is assigned.

      Bill Item Number
      • The SKU or item number associated with the bill item.

      Bill Item Description
      • The description of the bill item.

      Bill Item Unit Price
      • The cost assigned by the vendor to each individual unit of the bill item.

      Bill Item Quantity
      • The number of units purchased of the bill item.

      Bill Item Total
      • The total dollar amount owed for each bill item.

      Order Item Number
      • The SKU or item number associated with the order item.

      Order Item Description
      • The description of the order item.

      Order Item Unit Price
      • The price for this item listed on the order.

      Order Item Quantity
      • The number of units purchased of the order item.

      Linked Order Item Quantity
      • The number of units linked to the bill item.

      Linked Order Item Total
      • The total dollar amount of each order item that is linked to the bill item

      Unfavorable Item Unit Price Variance
      • The difference in unit price between the bill item and the linked order item.

      Unfavorable Item Total Variance
      • The total amount by which the total of the bill item exceeds the total of the linked order item.

      Tip: In Microsoft excel or Google Sheets, create a pivot table on the vendor to highlight the total variance per vendor.

      This article is used for documentation feedback only. For more help email help.me@curemint.io