Document Current Day 2 Process

[jwnich93]

Detailed Steps on how to complete Day 2 Accrual Process - Due 8/31/18

Work in Progress PDF File is located here : https://github.com/jwnich93/Fuel-Accounting/blob/master/Day%202%20Accrual%20Process.pdf

Work in Progress FDM Excel File is located here : https://github.com/jwnich93/Fuel-Accounting/blob/master/Fuel%20Expense%20Query.xlsx (also on our shared server)

Work in Progress AIS Excel File is located here : xxxxxxxxxxxxx (need to add) (also on our shared server)

• [x] FDM Data Download

• [x] E Cars Data Download

• [ ] FDM Data Query

  • [x] Split, Sort by Tank, Date, BOL
  • [x] Filter individual table for current month fuel drops
  • [x] Filter individual table for reversing journal entrie
  • [x] Combine fuel drop list with reversal list (APPEND OPERATION)
  • [ ] Sort line item detail (fuel type, tank, date) - figure out excel / power query maneuver
  • [x] Query for Ending Inventory CPG for Dallas (Due 11:00 ET).

• [x] Seperation of Gas / Diesel / LNG

• [ ] Matching / Cross Reference Process

• [ ] Reversal Matching Process

• [ ] Journal Form

• [ ] Audit Process

  • [ ] Define Data Sets

          - **FDM** : GL Day 2 + Accruals
                    - existing data set + query calculation
          - **AIS** : Monthly Recon Day 1 - Final Day of Month

  • [ ] Sum by AIS Tank Location

  • [ ] Create AIS GL Gallon Variance calculation

  • [ ] Total Number of drops AIS vs GL

[jwnich93]

Issues / Discussion

it is hard to filter data set for fuel drops, since naming conventions and not consistent. hard to filter out madison heights outside purchases. found a way to do it preliminary, but this needs to be revisited at a later date to make a fullproof way to do it. filtering the fuel expense data set to not included MIMAD4834 in the Delvr to Lctn Cd works, but if someone doesnt code this location when submitting invoices, it would fail the filter test for this query.

While trying to complete the reversal section, i ran into a roadblock, since im using July's Fuel Expense, the accruals done during July dont have BOL numbers. BOL was not submitted to the GL. Will have to revisit with downloaded file from previous month with BOL included. The nomenclature needs to be defined further for how to code fuel, so that standardized processes for doing the accrual can be implemented.