Invoice ingestion
Bring new Linde invoices into one clean inbox.
Sign in to Linde in the same browser you use for this app. The Ranger Gas Co. browser helper finds only invoices prefixed with RI (purchased) or GC (cylinder rental and tracking), reads the invoice detail, and sends only structured invoice data back for import.
Connect, scan, import
-
1
Import new invoices
Click once to open Linde in a new tab. Sign in there if needed; this page will detect authentication and automatically scan every invoice-history page.
-
2
Review the import
Only new RI and GC invoice numbers are added. Re-running a scan updates the same invoice instead of creating duplicates.
Nothing imported in this session.
Cylinder check
Linde cylinder comparison report
Choose a date to review the selected-period GC and RI invoices.
| Linde Rental Item | GC Begin | GC Ship | GC Return | GC End | Rent Days | Rate | Over Charge | Amount | Charge Check | RI Rec. | RI Ret. | RI net | GC Roll-Fwd | RI Roll-Up | Status | Why Different |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading comparison… | ||||||||||||||||
Reference comparison
QuickBooks vs Linde rental invoice
Use the selected period to compare the GC month-end rental balance with QuickBooks and manually recorded warehouse inventory.
| Linde Rental Item | Mapped RGC product(s) | GC ending/billed | QB month-end | Warehouse | Exceptions | Combined expected | GC minus expected | Review | Why it differs |
|---|---|---|---|---|---|---|---|---|---|
| Loading QuickBooks comparison… | |||||||||
Reference input
Add warehouse inventory
Enter the RGC cylinder quantities physically held in the warehouse for the selected period. These quantities are added to QuickBooks for the reference comparison only.
| RGC product | Linde Rental Item | Quantity |
|---|---|---|
| No warehouse count loaded. | ||
Manual invoice check
Review the selected GC invoice
Choose a period above to load the invoice detail stored in the app.
| Linde Rental Item | Mapped RGC product(s) | Beg. bal. | Cyl. ship | Cyl. returned | End bal. | Subject to rent | Rate | Invoice amount | App GC billed | Charge check |
|---|---|---|---|---|---|---|---|---|---|---|
| Loading invoice detail… | ||||||||||
Primary source · selected period
RI invoice evidence
The received and returned movements from RI invoices in the selected period will appear here.
| RI invoice | Date | RI item description | Mapped RGC product | Linde Rental Item | Inventory treatment | Received | Returned | Net movement | Unit price | Line total |
|---|---|---|---|---|---|---|---|---|---|---|
| Loading RI invoice evidence… | ||||||||||
Backup reference only · year to date
Linde portal cylinder balance
This portal snapshot is not used in the selected-period report. Capture it as a backup reference for investigating invoice discrepancies.
| Category | Product number | Beginning | Ships | Returns | Balance |
|---|---|---|---|---|---|
| Loading portal balance… | |||||
Operations view
Cumulative cylinder balance roll-forward
Each billing period remains available in the period report. This view carries the GC movement and RI movement forward so you can see whether the account stays internally consistent over time.
Operations heatmap
Period reconciliation map
Select a period and Linde Rental Item to trace where the rental invoice and invoice movement agree or diverge.
| Period | Linde Rental Item | GC beginning | GC shipped | GC returned | GC ending/billed | GC roll-forward | RI received | RI returned | RI net | Cumulative GC net | Cumulative RI net | QB reference | QB variance |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading cumulative report… | |||||||||||||
Imported history
RI + GC invoice inbox
Account balance
Linde cylinder balance snapshot
Not captured yet.
CY container transactions
Import missing RI+ movements
Reads CY invoice references from the Linde container transaction history for Nov 24, 2025 through Mar 6, 2026.
| Loading imported invoices… | ||||
Reference data
QuickBooks API
The existing QuickBooks connection and invoice sync API remain available while this first workflow is simplified.
Reference data
Cylinder mapping table
Keep the Linde categories connected to the RGC cylinder items used for comparison. These mappings remain available to the later reconciliation workflow.
| Linde Rental Item | RGC item | Actions |
|---|---|---|
| Loading mappings… | ||
Three-way mapping
RI item description mapping
RI descriptions map to one canonical RGC product; that RGC product then derives its Linde Rental Item from the table above. Item numbers are retained as reference only.
| RI item description | RI item number | RGC product | Linde Rental Item | Treatment | Notes | Actions |
|---|---|---|---|---|---|---|
| Loading RI mappings… | ||||||
Reference data
Business Rules
These rules drive ingestion, mapping, period comparisons, cumulative roll-forward, and review status. The list is generated from the app’s rule registry so new rules can be added with the logic that uses them.