Skip to main content

Importing QTPOD Transactions into X-1FBO

How to Import QTPOD Transactions into X-1

Amanda avatar
Written by Amanda
Updated over 2 years ago

These are steps on how to pull the report for QTPOD and the step-by-step guide on importing QTPOD transactions into X-1 FBO.

  1. Sign on to the OTPOD portal.

  2. Click on Transactions

  3. Enter the Start/End Date & Time and click Search

  4. Click on Export to CSV

  5. Click and open the Excel file at the bottom of the page

6. Edit the file for import by updating the following columns on the Excel spreadsheet: (Note: All edits are Case Sensitive.)

Column C - Change Customer Name to QTPOD

Column H - Fuel: Avgas

Column I - Pump Name: Self Serve Pump

Column O - Tail #: SELFSERVE

Column G - Card: Only MSA card payments need to be changed to Multiservice

7. Save to your Desktop

8. Log into X-1FBO

9. Fuel Management > Import Operations > click on Import in the upper right-hand corner.

10. Search for the Customer Name QTPOD and then click on Import File.

11. Locate the saved file from step 7.

12. Click on Upload

13. Click the checkmark to select all transactions.

14. Next click on the Process Data button.

Note: Transactions that are unable to be imported will show in red. If this occurs recheck the file for errors, i.e unnecessary spaces, proper capitalization, and that in column G MSA cards have been updated to Multiservice.

Did this answer your question?