FleetPartners Interface

FleetPartners finance interface setup

The FleetPartners interface is based on an excel electronic invoice supplied by FleetPartners. Users need to save the excel spreadsheet as .csv prior to importing.

Business rules used by the interface are:

1) Starting from the first row, read each row until reaching a row with 'Dossier' in the first column. This is to skip the invoice header section.

2) Process all other rows with the exception of those with a blank or 'Dossier' in the first column, as they are total or heading lines.

Columns Expected in this order are:

  1. Dossier (used as Card number)
  2. Vehicle Description
  3. Tax Invoice No.
  4. Start Date
  5. End Date
  6. Term
  7. Invoice Date
  8. Due Date
  9. Amount
  10. GST
  11. Amount(GST Incl)
  12. Registration
  13. Description
  14. Cost Centre
  15. Invoice Address
  16. State
  17. Charge Period From
  18. Charge Period To
  19. Driver
  20. Document Code