Perfect Gallon Meter Sales and BOL Deliveries File Import Specifications
Use this resource to ensure files uploaded for Inventory Reconciliation purposes are formatted correctly.
Written by Jess Hamilton
Updated at October 12th, 2026
Table of Contents
The file format specified in this resource is intended for use with SD Inventory Variance and legacy Fuel Analytics features (Perfect Gallon, Perfect Gallon HD) in Titan Cloud Edge. A different format may be required for HD Inventory Variance or other integrations.
Please reach out to your Implementations Manager or Titan Cloud Support to ensure you have the correct resources for your workflow.
File Format
General Rules
- Imported files must be in .csv format.
- Any columns that do not match the accepted headers below will not be imported.
- If a facility does not match what has been mapped in Titan, the data will not be imported.
Required Columns
The following columns must be included, using the format described below.
Column Header |
Data Format |
Example Value |
|---|---|---|
| Internal ID | Alphanumeric, must match the field by the same name on the Titan facility profile page. | 001111 |
| Tank Internal ID | Alphanumeric, must match the field by the same name on the Titan tank page. | 001 |
| Delivery Date |
Date Time: YYYY-MM-DDThh:mm:ssTZD This timestamp may identify the local date and time of delivery + offset to GMT OR may identify the UTC time clearly showing zero offset. |
2023-12-31T23:59:59+1000 OR 2023-12-31T13:59:59+0000 |
| BOL Number | Alphanumeric | REC123 |
Substance Product |
Alphanumeric, must match to the field Internal Grade Name in Dropdown List Management for Substance/Product. |
REGULAR UNL |
| Gross Units | Decimal, up to two decimal places | 10000.00 |
| Net Units | Number, up to two decimal places | 1000.00 |