My Fuel Reconciliation is way off

3 days of Fuel Sales are shown below. If you have 2 days that are coming up off by about the same amount with one amount as positive and the other as negative, this means that you have entered an incorrect date for a fuel invoice. Below, for 1/4/2006, it is showing a net over/short as -8,667.80. If you look at opening gallons minus the sold qty, the amount is wrong. You will also notice that there are all zero amounts for fuel purchase on 1/3/06. This means that the date on the fuel invoice is wrong. There is a fuel invoice dated 1/4/06 that should be dated 1/3/06.

 

If the Recon date for the invoice circled above is changed to 1/3/06 then the over/short will be corrected.

**Its important to remember that the Recon date is the date that the fuel goes into the ground. The invoice date is the date that is on the actual invoice.

 

Hit the refresh button after changing the date and the over/short amounts should be between 0-30 gallons. This depends on your system, temperatures, state requirements etc. S2k cannot determine the allowable/legal range of gallons that are over/short.