Facility Level Inventory Variance Setup
Configure data sources and tank profiles for the Inventory Variance module for an individual site.
Written by Jess Hamilton
Updated at March 10th, 2026
Table of Contents
Step 1: Access
Log in and open the desired facility. Select Inventory Variance and Inventory Variance Setup in the facility menu to begin site setup.
Tip: If you're not seeing Inventory Variance options in the facility level side menu, make sure Inventory Variance/BIR is enabled on the Release Detection Setup page.
Step 2: Site Setup
Select Source
Select a Source of Inventory Variance Data from the list available.
| 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?
Perfect Gallon options also require a Perfect Gallon Shift Number selection. Options include Shifts 1-4 or first inventory of the day.
Note: If data is being exported from PDI or another platform directly into Titan Cloud, the applicable vendor identifier must be added to the Facility Profile.
From the Facility Info screen, click the Misc Information tab and scroll down to the Data Vendor Mapping section. Click the pencil edit icon to make updates, then click Save.
Depending on the vendor or export type, individual Tanks may need to be mapped as well.
Source Effective Dates
If different sources require separate effective dates, you can click the View/Edit Effective Dates link to configure.
To add effective dates for a new source, click Add New to select a source and date.
To reset effective dates for a previously configured source, click edit.
To recalculate Inventory Variance reports based on updated effective dates, select the Recalculate Now checkmark.
Click OK to save changes.
Data Adjustment Options
You may choose to allow overrides or manual adjustments of inventory variance data.
These selections impact functionality, and determine whether the override and manual adjustment columns are available in the manual inventory entry grid.
Step 3: Profile Setup
Note: Tank profiles should only be created if the client is NOT using a Global Profile at the client level.
Toggle over to the Profile Setup tab to create profiles for each tank. Every tank configured in the facility should be set up with its own variance profile.
Select a tank from the dropdown and select Compliance or Operational as the Profile Type.
Compliance: Output is formatted to help manage regulatory obligations
Operational: Output is formatted to help optimize fuel levels and detect events like theft or leaks.
Tip: Each tank may have one compliance profile and one operational profile!
Admin Setup
Select a Period of Block or Rolling and add an Effective Date. For Units, you may select Liters, Imperial Gallons, or US Gallons. Select an Activity Template if applicable.
Variance Rules
Input values for Inventory Period in Days (7, 10, 30, or Monthly), Percent Rule, +/- Units, and select select the desired options for “Fail for Inventory Variance” and “Variance Calculated from the Larger of.”
Failure Conditions
A period will be considered failing if one or more items checked in this section are present.
Save
Click Save to confirm all settings and repeat as needed for each tank.