OnPoint Fuel Reconciliation System

Upload Bank file, pull Driver Fuel Log from Google Sheets, reconcile by ER/Auth number, and export the report.
No bank file loaded.
Fuel Log not loaded yet
Google Sheet ID: 1SnhLTWgzJfkKNmIvtj8uwa-8x7TsnRtqkfX3deEuHIQ · Driver tab: Fuel Log · Recon output tab expected: Fuel Recon
Bank Total
R0.00
Driver Log Total
R0.00
Exceptions
0
Missing in Driver Log
0
Duplicate ER Numbers
0
Total Bank-Driver Variance %
0.00%

Reconciliation Detail

DateER/Auth NoVehicleDriverCost CenterDepartmentBank AmountDriver Log AmountBank-DriverBank-Driver %StatusIssue
Upload files and click Run Reconciliation.

Driver Fuel Log from Google Sheets

This section should show transactions pulled from tab Fuel Log.
DateER NumberDriverVehicleMerchantFuel TotalGrand TotalLitresCost CenterDepartmentKMStatus
Fuel Log not loaded yet.

Pie Chart by Vehicle Registration

Summary Table

GroupBankDriver LogBank-Driver% Bank-DriverRecords

Bank Uploaded Rows

Mapped Fields

No data mapped yet.