Fuel Reports

 

Back Office >Reports > Fuel

 

Description

 

Nearly all of the Reports in SwiftPOS can be filtered by either a date range or data. The date range can either be selected from the drop down list of Periods or entered manually.

 

To Be Considered

 

Note : These reports are only visible when the Fuel Module is selected as part of the SwiftPOS Registration.

 


Reports

 

Report Name

ID

Sample

Description

Account Statement

FUL020

R

Reports on Account Charge/Payment transactions for the period selected, in an Account Statement format. Lists the Account and any Linked Accounts, Address details, Location, Date/Time of the transaction, Registration, Receipt, Docket Type, Product, Qty, Tax, Price, Transaction Amount and Charged/Payment Amount.

Day Sheet

FUL001

D S

D S

Reports on sales to date for the selected Location and Day ID by Product Group. Product Groups will be repeated and prefixed with an * when Tax Free Product sales are reported. Lists Location, Product Group Name, Units, Sales, Gross Profit value and %, Period to Date Sales and Gross Profit, Sales Forecast and Gross Profit Forecast. The bottom of the report provides an overview and summary of totals. In addition the detailed version lists values by Product.

 

Note : Ensure a Location has been selected prior to selecting a Day from the drop down list Day report parameter.

Day Sheet (CA)

FUL023

D S

D S

See sample reports

Day Sheet (CA2)

FUL024

R R

See sample reports

Day Sheet Theoretical

FUL027

D S

D S

See sample reports

Day Sheet VIVA

FUL026

R

See sample reports

Drive Off Audit

FUL002

R

Reports on Fuel Drive Offs. Lists the Terminal & Name, Receipt #, Date/Time, Clerk Name, Product Code and Description, Qty, Paid and Taken amounts.

Drive Off Summary

FUL003

 

Reports on Fuel Drive Offs. Lists the Location, Receipt No, Sale Total, Charges, Payments & Receipt Date/Time.

EFTPOS Points Summary

FUL017

 

To be continued ...

Fuel Deliveries

FUL021

 

Reports on Fuel Deliveries.

Fuel Grade Sales

FUL018

D S

Reports on Fuel sales summarised by Grade and grouped by Location. Lists the Location, Grade, the Opening and Closing Meter and the Difference in litres, litres sold at the POS, Variance between the Difference and the POS Litres and the Read Type. It also lists the same again but then in dollar values.

 

In addition the detailed version lists the above values for each Meter Reading taken.

Fuel Hose Sales

FUL010

D S

Reports on Fuel sales by Pump and Hose grouped by Location and Pump and summarised by Hose. Lists the Location, Pump # and Hose #, Grade. The Opening and Closing Meter, the Difference in litres sold at the POS, the Variance between the Difference and the POS Litres and the Read Type (R/T). It also lists the same again but then in dollar values.

 

In addition the detailed version lists the above values for each reading taken.

Fuel NMI Tests

FUL009

R

Reports on NMI Fuel Tests grouped by Fuel Grade and Location. Lists the Location, Fuel Grade, Tank, Pump, Hose, Litres, Amount, Price and Clerk.

Fuel Price Break

FUL011

R

Reports on the Fuel sales summarised by Fuel Price changes. Lists the Location, Fuel Grade, Fuel Price Change Start/End Date/Time, Price, total Litres sold and total Amount.

Fuel Pump Sales

FUL008

R

Reports on individual Fuel sales grouped by Fuel Pump/Dispenser. Lists the Location, Pump/Dispenser, Terminal, Receipt #, Fuel Grade, Date/Time, Qty, Price and Total.

Fuel Read Changes Audit

FUL014

R

Reports on changes made to the FuelTankReadTable. Lists the Table, Modified By, Column Modified, Original Value and New Value.

Fuel Sales by Grade Summary

FUL012

R

Reports on Fuel sales summarised by Grade and grouped by Location. Lists the Location, Fuel Grade, Customer Count, Litres sold, Value sold, Average Litres Per Sale, Average Value Per Sale and the Average Cost Per Litre.

Fuel Tank Reconciliation

FUL013

R

Reports on Fuel Tank Reconciliation data grouped by Fuel Grade, Tank and Location. Lists the Location, Tank, Fuel Grade, Closing Date/Time, Opening Dip, Deliveries (Qty), Dispensed (Qty), Closing Dip, Closing Book, Daily Loss/Gain (as a percentage as well), the Cumulative Loss/Gain (as a percentage as well) and the Read Type (R/T).

Fuel Time Period Sales

FUL015


Reports on Fuel Sales for a specified Time Period.

Hi Finance Summary Data

FUL025

R

Reports on SwiftPOS Touch Sales vs Exports to HI Finance summarised by Classification. Lists the Classification, # of POS Transactions, Value of POS Trans, # of Missing, Value of Missing, # Not Expected, Value Not Expected, # Exported, Value Exported, # In Error and Value In Error. Some of the columns are explained below:

 

Missing - Indicates the transactions that were NOT exported to Hi Finance. Drive Off and IOU are excluded.

Not Expected - Indicates these transactions are pending export and at the time the report was generated, they had not yet been exported.

In Error - Indicates these transactions are in error. Currently the only way to see why it is in error, is to check the Events Logs for the Service Monitor. Generally they are in error due to an invalid Site ID, etc.

I.O.U. Audit

FUL004

R

Reports on Fuel Drive IOUs. Lists the Terminal & Name, Receipt #, Date/Time, Clerk Name, Product Code and Description, Qty, Paid and Taken amounts.

I.O.U. Summary

FUL005

R

Reports on Fuel Drive IOUs. Lists the Location, Receipt No, Sale Total, Charges, Payments & Receipt Date/Time.

Period Fuel Sales

FUL019

D S

Reports on Fuel sales summarised by date and grouped by Product. Lists the Product, Date and Day, Litres sold, Amount sold, Litres (4 Wk Avg) and % Difference. Note : The Litres (4 Wk Avg) is based on the 4 weeks of sales prior to the selected period. If no values are reported then no sales were found in the 4 weeks.

 

In addition the detailed version groups the sales by Location.

PLU Fuel Sales by Discount Type

FUL016

D S

Reports on Fuel Sales by Discount Type grouped by Location and Discount Type. Lists the Location, Discount Type, Qty, Price, Sales Ex., Discounted Price, Discount Ex., Discounted Sales Ex. and % Total.

 

In addition the detailed version groups by Product and lists the Product, Terminal, Receipt # and Date/Time.

Sales & Purchases Summary

FUL028

R R

Reports on Sales and Purchase transaction data. Both are grouped by Location. For Sales further grouping is available by Master Group or Product Group. For Purchases further grouping is by Supplier. For Sales the report lists the Location, Master Group / Product Group, Qty, Tax, Total Exc and Total Inc. For Purchases the report lists the Location, Supplier, Reference, Type (invoice (INV) or Credit Note (CN)), date Invoiced, date Posted, Freight, Rounding, Discount, Tax, Total Exc and Total Inc.

Shift Sheet

FUL006

D S

D S

Reports on sales to date for the selected Location, Terminal and Shift ID by Product Group. Product Groups will be repeated and prefixed with an * when Tax Free Product sales are reported. Lists Product Group Name, Units/Litres, Sales, Gross Profit value and %. The bottom of the report provides an overview and summary of totals.

 

Note : Ensure a Location and Terminal ID has been selected prior to selecting a Shift from the drop down list Shift report parameter.

Tax Statement 2

FUL007

R

Reports on Account Charge/Payment transactions for the period selected, in an Account Statement format. Lists the Account and Address details, Location, Date/Time of the transaction, Docket, Type, Product, Qty, Tax, Price, Transaction Amount and Charged/Payment Amount. Statements can be generated by selecting one of the following Type options available.

 


Related Topics

 

  1. Custom Batch Export/Reports - FuelDataExport
  2. Fuel
  3. Reports