1. Overview & Architectural Context
Manual entry of hundreds of fuel purchase bills, coal weighbridge receipts, and utility electricity invoices is labor-intensive and error-prone. Carbonatoz provides a high-throughput, idempotent CSV and Tally Prime XML batch ingestion pipeline that reconciles financial ledger entries with physical greenhouse gas emission streams.
2. Prerequisites & Input Schema
Before starting the batch import, verify that your CSV or XML export adheres to the canonical columns:
| Column Name | Required | Data Type | Permitted Values / Description |
|---|---|---|---|
transaction_date | Yes | ISO Date (YYYY-MM-DD) | Transaction or invoice date |
facility_tag | Yes | String | Registered plant ID (e.g. FAC-JSR-01) |
source_stream_id | Yes | String | Physical stream tag (e.g. BLR-02-NORTH) |
fuel_or_material_type | Yes | String | coking_coal, natural_gas, grid_electricity, diesel |
quantity | Yes | Decimal (> 0) | Quantity in physical invoice units |
unit_of_measure | Yes | String | MT, Nm3, kWh, MWh, kL |
invoice_reference | No | String | Vendor invoice or weighbridge serial number |
custom_ncv_gj_per_t | No | Decimal | Net Calorific Value from supplier lab test |
3. Step-by-Step Execution Procedure
Step 3.1: Navigate to the Data Ingestion Console
Log in to the Carbonatoz Workspace.
In the primary left navigation menu, expand GHG Accountingselect Batch Ingestion.
Select the target Facility and Reporting Period (e.g., April 2026).
Step 3.2: Upload & Schema Mapping
Click + New Batch Ingestion Job.
Select your file format: Tally Prime XML or Generic ERP CSV.
Drag and drop your file into the secure dropzone (max 25MB per batch).
Review the auto-detected column mappings on the preview screen. If custom ERP column names were used, select the appropriate target fields from the dropdown selectors.
Step 3.3: Pre-Ingestion Dry Run & Anomaly Check
Click Run Validation Dry Run.
The platform executes an in-memory test run checking for:
Unknown source stream tags.
Out-of-bounds quantity spikes (> 300% historical monthly rolling average).
Incompatible units of measurement (e.g. attempting to import liters for electricity).
If errors are detected, click Download Error Log CSV to inspect and rectify row-level mismatches.
Step 3.4: Finalize & Commit Ingestion
Once the dry run reports
100% Validated, click Commit Ingestion Batch.Records are written to the monthly activity ledger in
pending_review status.System triggers calculate preliminary Scope 1 and Scope 2 CO2e values automatically.