FleetAdmin Assets - Costs - Xero Integration

FleetAdmin Costs can be synced with Xero to display paid Revenue & approved Purchase Order & Billing information on individual Assets, straight into FleetAdmin. Displaying a Profit and Loss on each Asset. It is as easy as linking Xero, Xero Tracking Category 1 & TFO Asset Unit ID numbers.        

Screen_Shot_2022-10-06_at_9.03.35_am.png

 

Linking Xero Tracking Categories

  • In Xero, Create Tracking Category 1 - Please advise TFO via support@thefleetoffice.com.au the Tracking Category Name.  TFO will need to create this link in the backend.  
  • In Xero Create Tracking Category Options - These are your Asset Unit ID in FleetAdmin- The Category options & the Unit ID in TFO must match to enable the syncing of data.

Screen_Shot_2021-12-06_at_10.30.06_am.png

Only Assets listed in Xero Category Options will sync with FleetAdmin Costs.

Using the example below, only Assets TFO-01 through to TFO-04 will collect data in Costs.  The remaining Assets listed in TFO Admin will not sync. Xero cannot create Assets in FleetAdmin, nor can FleetAdmin create Category options in Xero.  These must be added in manually in Xero.

Screen_Shot_2022-06-02_at_11.49.44_am.png Screen_Shot_2022-06-02_at_11.56.48_am.png

 

Initial Connection - Xero & The Fleet Office

  • Click on Show Xero Tools

Screen_Shot_2021-12-06_at_10.34.19_am.png

  • Connect to Xero

 

Screen_Shot_2021-12-06_at_10.36.46_am.png

  • Allow The Fleet Office to connect to Xero 

Screen_Shot_2021-12-06_at_11.21.44_am.png

  • Once login is confirmed, you will be taken back to The Fleet Office

Regular Xero Integration

  • Go to Costs page
  • Click on Show Xero Tools
  • Click on Sync Now to import data from Xero
  • This will update data for all linked Assets

Screen_Shot_2022-10-06_at_9.16.22_am.png

Interpreting Xero Cost data

Estimated Are estimated costs added in FleetMaint - See below
Committed Are Approved Purchase Orders & Bills in Xero
Actual Are Paid Bills in Xero

Revenue

Is Paid Invoices in Xero
   
Payments

Detail lines with a Type I are approved Bills & lines with a P are approved Purchase Orders

Revenue Detail lines for all Paid Tax Invoices
Estimated Costs Detail lines for all estimates with Work Order number listed
  •  
Screen_Shot_2022-10-06_at_9.41.13_am.png

 

  • Use the headings to filter information as required
  • Information will update as it progresses through Xero & when the Sync Now button in The Fleet Office is triggered.

Enter Estimated Costs in FleetMaint

If you have FleetMaint enabled, you have the ability to enter Estimated Costs via Work Items

Screen_Shot_2021-12-08_at_12.59.19_pm.png

  • Go to FleetMaint
  • Find the correct Work Order
  • Open the Work Item
  • Enter the estimated amount in Cost Estimate
  • The Work Order will add all Work Item estimates together 
Screen_Shot_2021-12-08_at_1.10.42_pm.png
 
 
Was this article helpful?
0 out of 0 found this helpful