Inventory Reconciliation
Consolidate tank levels, delivery records, and sales data from multiple sources into a single platform to generate monthly inventory reconciliation reports.
Aggregates tank level readings, delivery volumes, and POS sales into a unified dataset
Generates monthly inventory reconciliation reports for every site
Cross-references data from ATGs, fuel deliveries, and point-of-sale systems
Identifies variances between expected and actual inventory — flagging potential losses early
Monthly reports, with custom date ranges when a different period is needed
Reduces manual data gathering from disparate systems
Provides a documented record of inventory variances for loss investigation and compliance programs
Bringing Inventory Data Together
Inventory reconciliation compares the amount of fuel that should be in a tank, based on deliveries and sales, against the actual tank level. The challenge is that the data it needs comes from multiple, often disconnected sources — ATGs provide level readings, delivery tickets record inbound fuel, and POS systems track outbound sales.
Kii’s platform consolidates all of these data streams into a single environment, eliminating the manual effort of gathering records from different systems and reconciling them by hand.
Data Sources Consolidated
The platform captures and correlates data from across the fuel operation:
- ATG tank level readings — continuous inventory data from connected ATGs
- Delivery and fill event records — volume delivered, timestamps, and product grades
- POS sales data — fuel dispensed at the pump, captured through integrations with systems including Gilbarco Passport
- Environmental sensor data — interstitial, sump, and line leak detection results that complement the inventory picture
From Raw Data to Actionable Reports
By bringing these data sources together, the platform can identify discrepancies between calculated and measured inventory levels. A significant variance can indicate a leak, metering error, or delivery discrepancy that requires investigation.
Reconciliation reports are generated monthly for each site, or for a custom period when needed, giving operators a consistent, documented record of inventory variances.
Reducing the Reconciliation Burden
For operators managing dozens or hundreds of sites, the manual process of collecting ATG printouts, cross-referencing delivery tickets, and pulling POS reports is time-consuming and error-prone. By automating data capture at the source and centralizing it in one platform, Kii transforms inventory reconciliation from a manual exercise into an automated process.
Recent Updates
View all updates →
Reconcile Deliveries Against the Bill of Lading
Deliveries on underground tanks can now be corrected to the Bill of Lading amount, and deliveries the tank gauge missed can be added from the BOL, with the original sensor value preserved.
Manage Manifolded Tanks as One System
Underground tanks connected by a manifold can now be grouped into a single manifolded system, and tank lists show which tanks share a manifold.
Monthly Inventory Reconciliation for Every Site
Monthly inventory reconciliation reports are generated for each site from monitored tank inventory, deliveries, and POS sales, with each fuel grade mapped to the tanks that supply it.
Ready to Get Started?
See how Inventory Reconciliation can transform operations.