SD Inventory Variance Overview
Overview of the Titan Cloud Edge core inventory reconciliation module including basic setup and configuration overview.
Written by Jess Hamilton
Updated at March 10th, 2026
Table of Contents
The SD Inventory Variance module calculates daily tank system-level inventory movement and variance by reconciling sales, deliveries, and inventory readings. These calculations provide a standardized method for monitoring fuel inventory accuracy and operational performance.
The module supports multiple downstream capabilities, including:
- Daily Inventory & Sales Variance Report
- NEO export reporting
- Data reporting for external systems (VMI feeds)
- Financial and operational reconciliation workflows
When configured, the module produces daily tank system-level records that include sales activity, inventory movement, and calculated variance values. These records can then be consumed through reporting or integration workflows.
The resulting data supports:
- External vendor system integrations
- ERP and finance workflows
- Operational variance analysis
- Compliance Variance Reporting Requirements (North America)
Note: This resource outlines the initial setup required to establish SD Inventory Variance data flow to reporting and export workflows. Additional configuration is required to support data visibility within the SD Inventory Variance screens, compliance-related reporting, and the Neo data export supporting SIR analysis.
Setup & Configuration
Proper configuration of the SD Inventory Variance module is required before variance reporting or integrations can be used.
Tip: Tank manifolds must be configured, as SD Inventory Variance and SIR reporting are calculated at the tank system level. Incorrect or missing manifold configuration may prevent accurate variance calculations or reporting. This is completed at the Facility > Tank level.
Fueling Position configuration may be required depending on the source data mappings.
- Fueling Position Product Mapping must be configured when product mappings are not present in the source data. this mapping is required for any reporting related to sales transactions.
- Fueling Position Tank Association is only required for SD Inventory Variance screen data visibility, associated compliance reporting, and data exports.
Learn more: Meter Calibration Setup
Note: In order for Fueling Position setup to be visible, the Flow Rate subscription must be enabled by a Titan Admin in Account Settings.
Enable Inventory Variance Data Import
Configure Inventory Variance Setup
Learn More: Client Level Inventory Variance Setup
Learn More: Facility Level Inventory Variance Setup
Inventory Variance Data Source Options
| Data Source Type | Description | Details |
|---|---|---|
| Manual Entry | All data used in variance calculations is entered manually by users. |
No automated system integration exists.
Data is maintained through manual reconciliation workflows. |
| BIR (*ATG Data) | Business Inventory Reconciliation (BIR) is polled directly from the ATG. | Site has Veeder-Root gauge with BIR capabilities |
| BVR (*ATG Data) | Book Variance Reconciliation (BVR) is polled directly from the ATG. | This configuration is commonly required for Canadian regulatory environments where BVR reporting is standard. |
| API |
Variance data is received from an external system via API integration.
|
External systems calculate or provide inventory data
Titan receives data through automated API calls. |
| Daily Shift Totals w/ Sales & Deliveries (*File Import) |
Variance calculations use two imported files:
|
Reference File Formats: |
| Daily Shift Totals w/Sales (*File Import) and ATG Deliveries | Sales data is imported from a PDI FIE data feed, while deliveries are sourced from ATG readings. |
Reference File Formats: |
| Daily Shift Totals w/Sales (*File Import) and BOL Deliveries | Sales data is imported from a PDI FIE data feed, and deliveries are calculated using BOL file imports. |
Reference File Formats: |
| Perfect Gallon Standard (Meter Sales) |
Calculations are based on:
|
Uses meter-level sales data |
| DEX/Cloud BIR | A proprietary POS integration used by 7-Eleven. | Sales and variance data are integrated through the DEX/Cloud BIR workflow. |
| Perfect Gallon Standard (Daily Sales)* |
Inventory data is sourced from the ATG.
Sales data comes from an external system feed. |
|
| Perfect Gallon High Definition* | Uses data from the legacy PGHD (Perfect Gallon High Definition) solution, aggregated and scaled to a daily reporting level. | |
| Perfect Gallon Meter Sales and BOL Deliveries (*File Import)* |
Sales transactions from data ingest or ATG
BOL records from data ingest
Inventory readings from ATG |
Perfect Gallon Meter Sales and BOL Deliveries File Import Specifications |
An additional setting is needed to ingest sales data required for Perfect Gallon-based variance calculations. This flag must be enabled for Perfect Gallon data source options to appear in the Inventory Variance Setup configuration.
To enable: Navigate to: Account Settings → Enable flag: Import data from Perfect Gallon?
Summary
To complete SD Inventory Variance Setup:
- Configure Tank Manifolds so tanks are grouped correctly for system-level variance calculations
- Enable Import data from Perfect Gallon (if applicable)
- Select the appropriate Inventory Variance Data Source
- Configure any required file imports, integrations, or ATG polling settings
Once configured, the SD Inventory Variance module will generate the daily variance calculations used by reporting, compliance monitoring, and external integrations.
Learn More: Inventory Variance Reporting (SD)