Purpose
This section explains how to view detailed information and formulas for each financial metric in Metrics Studio. Understanding these details helps users interpret metric outputs, assess calculation logic, and validate data sources.
Procedure
- Access Metrics Studio
- Log in to the Auditoria platform.
- Select Metrics Studio from the Insights menu.
- Locate the Desired Metric
- Browse or search for the metric using either Card View or List View.
- In Card View, scroll through the grid of metric cards.
- In List View, scan the table or use the search box to filter metrics by name or keyword.
- Browse or search for the metric using either Card View or List View.
- View Metric Details
- In Card View:
- Each card displays the metric name, confidence indicator, a description, and the full calculation formula.
- The formula section often includes logic and field names used in the calculation.
- In List View:
- Each row includes columns for the metric title, description, and calculation formula.
- The formula column shows the logic used to compute the metric (for example, "AVERAGE(Vendor_Bill_Total_Amount)").
- Review the confidence indicator to understand the reliability of data for each metric.
- In Card View:
Table 1. Metrics Studio List View Column Descriptions
| Column | Description |
|---|---|
| Title | The name of the financial metric. This is a concise identifier, such as “Active Vendors” or “Average Bill Amount.” |
| Description | A brief, plain-language summary explaining what the metric measures or represents. |
| Formula | The calculation logic or expression used to generate the metric’s value. Typically shown as a function using field names, such as AVERAGE(Vendor_Bill_Total_Amount). |
| Confidence Score | An indicator that reflects the system’s assessment of how reliable and complete the data is for this metric—examples include “High Confidence,” “Medium Confidence,” or “Low Confidence.” |
Table 2. Viewing Metric Details and Formulas
Title | Description | Formula | Confidence Score |
| Active Vendors | Current count of active vendor relationships | COUNT(DISTINCT Vendor_Bill_Vendor_Id) | High |
| Adjustment Bills | Count and total amount of adjustment/correction invoices | COUNT(Vendor_Bill_Number) WHERE Vendor_Bill_Is_Adjustment = TRUE | High |
| Aggressive Forecast | Risk-adjusted high cash forecast scenario | SUM(Vendor_Bill_Open_Amount × 1.10) WHERE Vendor_Bill_Due_Date >= CURRENT_DATE | High |
| Average Bill Amount | Mean invoice amount by vendor | AVERAGE(Vendor_Bill_Total_Amount) | High |
| Average Days from Due Date | Mean timing of payments relative to due date (negative=early positive=late) | AVERAGE(Payment_Date - Vendor_Bill_Due_Date) | High |
| Average Days Overdue | Mean number of days invoices are past due date | AVERAGE(CURRENT_DATE - Vendor_Bill_Due_Date) WHERE Vendor_Bill_Due_Date < CURRENT_DATE | High |
| Average Days to Accounting | Mean time from receipt to accounting entry | AVERAGE(Vendor_Bill_Accounting_Date - Vendor_Bill_Received_Date) | High |
| Average Days to Pay (Enterprise) | Company-wide average payment cycle time | AVERAGE(Payment_Date - Vendor_Bill_Date) | High |
| Average Days to Payment | Mean time from invoice receipt to payment | AVERAGE(Payment_Date - Vendor_Bill_Date) | High |
| Average Days to Payment (End-to-End) | Complete invoice-to-payment cycle time | AVERAGE(Payment_Date - Vendor_Bill_Date) | High |
| Average Days to Receipt | Mean time from invoice date to system receipt | AVERAGE(Vendor_Bill_Received_Date - Vendor_Bill_Date) | High |
| Average Days Until Due | Forward-looking metric showing average days until bills become due | AVERAGE(Vendor_Bill_Due_Date - CURRENT_DATE) WHERE Vendor_Bill_Due_Date >= CURRENT_DATE | High |
| Average Days Until Due (Forecast) | Average payment timing across forecasted bills | AVERAGE(Vendor_Bill_Due_Date - CURRENT_DATE) WHERE Vendor_Bill_Due_Date >= CURRENT_DATE | High |
| Average Line Amount | Mean amount per line item by category | AVERAGE(Line_Item_Line_Amount) | High |
| Average Payment Amount | Mean payment transaction size | AVERAGE(Payment_Amount) | High |
| Average Payment Size | Mean payment transaction size by method | AVERAGE(Payment_Amount) | High |
| Average Payment Terms | Mean contractual payment terms across all vendors | AVERAGE(Vendor_Bill_Payment_Terms_Days) | High |
| Average Processing Days | Mean time to process payment by method | AVERAGE(Payment_Date - Payment_Transaction_Date) | High |
| Average Unit Cost | Mean cost per unit by category | AVERAGE(Line_Item_Unit_Cost) | High |
| Base Forecast | Expected cash requirement (most likely scenario) | SUM(Vendor_Bill_Open_Amount) WHERE Vendor_Bill_Due_Date >= CURRENT_DATE | High |
| Bill Count by Status | Distribution of bills across different statuses (Draft, Posted, Paid, etc.) | COUNT(Vendor_Bill_Number) GROUPED BY Vendor_Bill_Status | High |
| Bills Due Next 7 Days | Near-term payment obligations | COUNT(Vendor_Bill_Number) WHERE Vendor_Bill_Due_Date IS IN [CURRENT_DATE, CURRENT_DATE + 7] | High |
| Bills on Hold | Count and amount of bills currently on hold requiring action | COUNT(Vendor_Bill_Number) WHERE Vendor_Bill_Is_On_Hold = TRUE | High |
| Bills with PO | Count of invoices linked to purchase orders (PO coverage) | COUNT(DISTINCT Vendor_Bill_Number) (Joined with PO Bridge) | High |
| Category % of Total Spend | Percentage of total spend by category (spend concentration) | (SUM(Line_Item_Line_Amount) BY Category ÷ SUM(Line_Item_Line_Amount) Total) × 100 | High |
| Conservative Forecast | Risk-adjusted low cash forecast scenario | SUM(Vendor_Bill_Open_Amount × 0.90) WHERE Vendor_Bill_Due_Date >= CURRENT_DATE | High |
| Currency Count | Number of currencies used per payment method | COUNT(DISTINCT Payment_Currency) | High |
| Current (Not Due) | Amount and count of invoices not yet due for payment | SUM(Vendor_Bill_Open_Amount) WHERE Vendor_Bill_Due_Date >= CURRENT_DATE | High |
| Current Percentage | Percentage of AP balance that is current (not yet due) | (SUM(Vendor_Bill_Open_Amount) WHERE Vendor_Bill_Due_Date >= CURRENT_DATE ÷ SUM(Vendor_Bill_Open_Amount)) × 100 | High |
| Days Payable Outstanding | Average days to pay suppliers (DPO - working capital metric) | SUM(Vendor_Bill_Open_Amount) ÷ (SUM(Vendor_Bill_Total_Amount) ÷ 90) | High |
| Discount by Vendor | Total discount amount captured per vendor | SUM(Vendor_Bill_Discount_Taken_Reporting) GROUPED BY Vendor_Bill_Vendor_Id | High |
| Discount Capture Rate | Percentage of available discounts that were successfully captured | (SUM(Vendor_Bill_Discount_Taken_Reporting) ÷ SUM(Vendor_Bill_Total_Amount)) × 100 | High |
| Discount Count | Number of discount opportunities successfully captured | COUNT(Vendor_Bill_Number) WHERE Vendor_Bill_Is_Discount_Taken = TRUE | High |
| Early Payment Count | Number of payments made before due date | COUNT(Payment_Number) WHERE Payment_Date < Vendor_Bill_Due_Date | High |
| Fully Paid Bills | Count of completely paid invoices by vendor | COUNT(Vendor_Bill_Number) WHERE Vendor_Bill_Open_Amount = 0 | High |
| Invoice Hold Rate | Percentage of invoices currently on hold | (COUNT(Vendor_Bill_Number) WHERE Vendor_Bill_Is_On_Hold = TRUE ÷ COUNT(Vendor_Bill_Number)) × 100 | High |
| Invoice Match Rate | Percentage of invoices successfully matched (3-way match) | (COUNT(Vendor_Bill_Number) WHERE Vendor_Bill_Match_Status = 'Matched' ÷ COUNT(Vendor_Bill_Number)) × 100 | High |
| Invoices Per Payment | Average number of invoices consolidated per payment | SUM(Payment_Invoices_Paid_Count) ÷ COUNT(Payment_Number) | High |
| Late Payment Count | Number of payments made after due date | COUNT(Payment_Number) WHERE Payment_Date > Vendor_Bill_Due_Date | High |
| Line Item Count | Total number of line items by category | COUNT(Line_Item_Record_Ext_Id) | High |
| Line Items per Bill | Average number of line items per invoice by vendor | SUM(Vendor_Bill_Line_Item_Count) ÷ COUNT(Vendor_Bill_Number) | High |
| Matched vs Unmatched Cycle Time | Comparison of cycle times for matched vs unmatched invoices | (AVERAGE(Payment_Date - Vendor_Bill_Date) WHERE Vendor_Bill_Match_Status != 'Matched') - (AVERAGE(Payment_Date - Vendor_Bill_Date) WHERE Vendor_Bill_Match_Status = 'Matched') | High |
| Median Days to Payment | Typical cycle time excluding outliers (50th percentile) | MEDIAN(Payment_Date - Vendor_Bill_Date) | High |
| Monthly Bill Spend | Total spend trends by month | SUM(Vendor_Bill_Total_Amount) GROUPED BY Month(Vendor_Bill_Date) | High |
| Monthly Bill Volume | Total invoice volume trends by month | COUNT(Vendor_Bill_Number) GROUPED BY Month(Vendor_Bill_Date) | High |
| Monthly Cash Forecast | 30-day cash requirement forecast | SUM(Vendor_Bill_Open_Amount) WHERE Vendor_Bill_Due_Date IS IN [CURRENT_DATE, CURRENT_DATE + 30] | High |
| Monthly Discount Trend | Savings trend over time by month | SUM(Vendor_Bill_Discount_Taken_Reporting) GROUPED BY Month(Vendor_Bill_Date) | High |
| MTD Discounts Captured | Current month's discount savings to date | SUM(Vendor_Bill_Discount_Taken_Reporting) WHERE Vendor_Bill_Date IS IN [Current Month] | High |
| MTD Spend | Month-to-date total spend | SUM(Vendor_Bill_Total_Amount) WHERE Vendor_Bill_Date IS IN [Current Month] | High |
| On-Time Payment Count | Number of payments made exactly on due date | COUNT(Payment_Number) WHERE Payment_Date = Vendor_Bill_Due_Date | High |
| On-Time Payment Rate | Percentage of payments made by due date | (COUNT(Payment_Number) WHERE Payment_Date <= Vendor_Bill_Due_Date ÷ COUNT(Payment_Number)) × 100 | High |
| On-Time Payment Rate (Cycle) | Payment timeliness rate from cycle time perspective | (COUNT(Vendor_Bill_Number) WHERE Payment_Date <= Vendor_Bill_Due_Date ÷ COUNT(Vendor_Bill_Number)) × 100 | High |
| Open Amount by Bill | Remaining unpaid balance for each invoice | Vendor_Bill_Open_Amount | High |
| Outstanding Payables | Current balance of unpaid invoices | SUM(Vendor_Bill_Open_Amount) | High |
| Outstanding Payables (KPI) | Current accounts payable balance from executive dashboard | SUM(Vendor_Bill_Open_Amount) | High |
| Overall On-Time Rate | Enterprise-wide on-time payment compliance percentage | (COUNT(Payment_Number) WHERE Payment_Date <= Vendor_Bill_Due_Date ÷ COUNT(Payment_Number)) × 100 | High |
| Overdue 1-30 Days | Amount and count of invoices 1-30 days past due date | SUM(Vendor_Bill_Open_Amount) WHERE (CURRENT_DATE - Vendor_Bill_Due_Date) BETWEEN 1 AND 30 | High |
| Overdue 31-60 Days | Amount and count of invoices 31-60 days past due date | SUM(Vendor_Bill_Open_Amount) WHERE (CURRENT_DATE - Vendor_Bill_Due_Date) BETWEEN 31 AND 60 | High |
| Overdue 61-90 Days | Amount and count of invoices 61-90 days past due date | SUM(Vendor_Bill_Open_Amount) WHERE (CURRENT_DATE - Vendor_Bill_Due_Date) BETWEEN 61 AND 90 | High |
| Overdue 90+ Days | Amount and count of invoices more than 90 days past due | SUM(Vendor_Bill_Open_Amount) WHERE (CURRENT_DATE - Vendor_Bill_Due_Date) > 90 | High |
| Overdue Payables | Total amount of past-due invoices requiring immediate attention | SUM(Vendor_Bill_Open_Amount) WHERE Vendor_Bill_Due_Date < CURRENT_DATE | High |
| Overdue Payables (KPI) | Current overdue balance from executive dashboard | SUM(Vendor_Bill_Open_Amount) WHERE Vendor_Bill_Due_Date < CURRENT_DATE | High |
| Overdue Percentage | Percentage of AP balance that is past due | (SUM(Vendor_Bill_Open_Amount) WHERE Vendor_Bill_Due_Date < CURRENT_DATE ÷ SUM(Vendor_Bill_Open_Amount)) × 100 | High |
| P90 Days to Payment | 90th percentile cycle time (performance outlier threshold) | PERCENTILE(90, Payment_Date - Vendor_Bill_Date) | High |
| Partially Paid Bills | Count of invoices with partial payments and remaining balance | COUNT(Vendor_Bill_Number) WHERE Vendor_Bill_Open_Amount > 0 AND Vendor_Bill_Open_Amount < Vendor_Bill_Total_Amount | High |
| Payment Amount by Type | Total value by payment method | SUM(Payment_Amount) GROUPED BY Payment_Type | High |
| Payment by Category | Payment distribution by expense category | SUM(Payment_Amount) GROUPED BY Payment_Category | High |
| Payment Complete Rate | Percentage of successfully completed payments | (COUNT(Payment_Number) WHERE Payment_Status = 'Complete' ÷ COUNT(Payment_Number)) × 100 | High |
| Payment Count by Type | Distribution of payments by payment method | COUNT(Payment_Number) GROUPED BY Payment_Type | High |
| Payment Status Distribution | Overall distribution of payment statuses across all bills | COUNT(Vendor_Bill_Number) GROUPED BY Status (Paid, Partially Paid, Unpaid) | High |
| Payments by Bank Account | Payment distribution across bank accounts | SUM(Payment_Amount) GROUPED BY Payment_Bank_Account_Name | High |
| Reconciliation Rate | Percentage of payments successfully reconciled | (COUNT(Payment_Number) WHERE Payment_Reconciliation_Status = 'Reconciled' ÷ COUNT(Payment_Number)) × 100 | High |
| Same Day Receipt Rate | Percentage of invoices received same day as invoice date | (COUNT(Vendor_Bill_Number) WHERE (Vendor_Bill_Received_Date - Vendor_Bill_Date) <= 1 ÷ COUNT(Vendor_Bill_Number)) × 100 | High |
| Spend by Account | Total spend by GL account | SUM(Line_Item_Line_Amount) GROUPED BY Line_Item_Account | High |
| Spend by Category | Total spend breakdown by expense category | SUM(Line_Item_Line_Amount) GROUPED BY Line_Item_Spend_Category | High |
| Spend by Cost Center | Total spend allocation by cost center | SUM(Line_Item_Line_Amount) GROUPED BY Line_Item_Cost_Center | High |
| Spend by Currency | Multi-currency spend analysis across different currencies | SUM(Vendor_Bill_Total_Amount) GROUPED BY Vendor_Bill_Base_Currency | High |
| Tax-Only Bills | Count of special tax-only invoice transactions | COUNT(Vendor_Bill_Number) WHERE Vendor_Bill_Is_Tax_Only_Invoice = TRUE | High |
| Total Amount Paid (KPI) | Total disbursement volume from executive dashboard | SUM(Payment_Amount) | High |
| Total Billed Amount | Aggregate sum of all bill amounts | SUM(Vendor_Bill_Total_Amount) | High |
| Total Billed by Vendor | Total amount billed by each vendor over time period | SUM(Vendor_Bill_Total_Amount) GROUPED BY Vendor_Bill_Vendor_Id | High |
| Total Bills by Vendor | Invoice volume per vendor over specified time period | COUNT(Vendor_Bill_Number) GROUPED BY Vendor_Bill_Vendor_Id | High |
| Total Discounts Captured | Total dollar amount of early payment discounts realized | SUM(Vendor_Bill_Discount_Taken_Reporting) | High |
| Total Outstanding | Complete AP balance across all aging buckets | SUM(Vendor_Bill_Open_Amount) | High |
| Total Paid Amount | Total dollar value of all disbursements made | SUM(Payment_Amount) | High |
| Total Payments Made | Total count of payment transactions processed | COUNT(Payment_Number) | High |
| Total Payments Made (KPI) | Payment activity from executive dashboard | COUNT(Payment_Number) | High |
| Total Quantity Purchased | Total volume of items purchased by category | SUM(Line_Item_Quantity) | High |
| Total Tax Amount | Aggregate tax liability from vendor bills | SUM(Vendor_Bill_Tax_Amount) | High |
| Total Tax by Category | Total tax liability by spend category | SUM(Line_Item_Line_Tax_Amount) GROUPED BY Line_Item_Spend_Category | High |
| Unpaid Bills | Count of invoices with no payments made | COUNT(Vendor_Bill_Number) WHERE Vendor_Bill_Open_Amount = Vendor_Bill_Total_Amount | High |
| Vendor Concentration | Payment concentration by vendor count | COUNT(DISTINCT Vendor_Bill_Vendor_Id) WHERE Vendor_Bill_Due_Date >= CURRENT_DATE | High |
| Vendor Count by Category | Number of unique vendors by spend category | COUNT(DISTINCT Line_Item_Vendor_Id) GROUPED BY Line_Item_Spend_Category | High |
| Weekly Cash Forecast | 7-day cash requirement forecast | SUM(Vendor_Bill_Open_Amount) WHERE Vendor_Bill_Due_Date IS IN [CURRENT_DATE, CURRENT_DATE + 7] | High |
| Weighted Avg Days Overdue | Amount-weighted average days overdue (larger invoices weighted more) | SUM(Vendor_Bill_Open_Amount × (CURRENT_DATE - Vendor_Bill_Due_Date)) ÷ SUM(Vendor_Bill_Open_Amount) WHERE Vendor_Bill_Due_Date < CURRENT_DATE | High |
| YTD Invoice Volume | Year-to-date total invoice count | SUM(Vendor_Bill_Number) WHERE Vendor_Bill_Date IS IN [Current Year] | High |