Reports

Fuel

Back Office - Reports

Provides a list of Fuel related reports available in Back Office. To access, select the Reports option in the Fuel menu in Back Office, to open the Reports screen. Then expand the Fuel option listed on the left-hand side of the screen, to view the list of Fuel reports.

 


Reports        

 


Fuel Reports      

 

Account Statement

FUL020

pdficon24x24

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

pdficon24x24

pdficon24x24

pdficon24x24

pdficon24x24

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,dition the detailed version lists values by Product.

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

Day Sheet (CA)

FUL023

pdficon24x24

pdficon24x24

pdficon24x24

pdficon24x24

See sample reports

Day Sheet (CA2)

FUL024

pdficon24x24

pdficon24x24

See sample reports

Day Sheet Theoretical

FUL027

pdficon24x24

pdficon24x24

pdficon24x24

pdficon24x24

See sample reports

Day Sheet VIVA

FUL026

pdficon24x24

See sample reports

Drive Off Audit

FUL002

pdficon24x24

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

pdficon24x24 

pdficon24x24

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

pdficon24x24

pdficon24x24

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

pdficon24x24

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

pdficon24x24

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

pdficon24x24

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

pdficon24x24

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

pdficon24x24

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

pdficon24x24

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

pdficon24x24

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

pdficon24x24

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

pdficon24x24

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

Period Fuel Sales

FUL019

pdficon24x24

pdficon24x24

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

pdficon24x24

pdficon24x24

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

pdficon24x24

pdficon24x24

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

pdficon24x24 

pdficon24x24

pdficon24x24

pdficon24x24

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 have been selected prior to selecting a Shift from the drop-down list Shift report parameter.

Tax Statement 2

FUL007

pdficon24x24

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.

 

End of article