OnPoint Fuel Reconciliation System

Upload Bank Statement (.xlsx, .xls, .csv)

No bank file loaded.

Upload Zoho Document (.xlsx, .xls, .csv)

No Zoho file loaded.

Zoho mapping: Vehicle Reg No. · report_number / Reference · Amount

Summary View Period

Include Driver Fuel Log in reconciliation Untick to reconcile Bank and Zoho only.

Fuel Log not loaded yet

Google Sheet ID: 1SnhLTWgzJfkKNmIvtj8uwa-8x7TsnRtqkfX3deEuHIQ · Driver tab: Fuel Log · Recon output tab expected: Fuel Recon

Bank Total

R0.00

Zoho Total

R0.00

Driver Log Total

R0.00

Exceptions

Missing in Zoho

Missing in Driver Log

Duplicate ER Numbers

Total Bank-Zoho Variance

R0.00

0.00%

Total Zoho-Driver Variance

R0.00

0.00%

Total Bank-Driver Variance

R0.00

0.00%

Date	Report_number / ER No	Vehicle	Driver	Cost Center	Department	Bank Amount	Zoho Amount	Driver Log Amount	Bank-Zoho	Zoho-Driver	Bank-Driver	Bank-Zoho %	Zoho-Driver %	Bank-Driver %	Status	Issue
Upload Bank and Zoho files, load Fuel Log, then click Run Reconciliation.

This section maps Zoho columns: Vehicle Reg No., report_number / Reference, and amount.

Date	Report_number / Reference	Vehicle Reg No.	Amount	Status
Zoho file not loaded yet.

This section should show transactions pulled from tab Fuel Log.

Date	ER Number	Driver	Vehicle	Merchant	Fuel Total	Grand Total	Litres	Cost Center	Department	KM	Status
Fuel Log not loaded yet.

Group	Bank	Zoho	Driver Log	Bank-Zoho	Zoho-Driver	Bank-Driver	% Bank-Zoho	% Zoho-Driver	% Bank-Driver	Records

No data mapped yet.