Setup Settlements for QuickBooks Export

Owned by Michelle Cabaya (Unlicensed)
May 13, 2022

The Settlement QuickBooks Export feature allows easy transfer of X Dispatch settlement data to QuickBooks. When configured, settlement data can be exported via the "Settlements Display" screen then imported into QuickBooks.

Download/Up Date Report Format(s)

Before settlement data can be exported, download or check for updates for the report format(s) in the Advanced Find Service.

Requires X Dispatch 21.0 or newer for QuickBooks 2019+ Settlement Export (As Bill).

 QuickBooks 2019+ Settlement Export (As Bill) requires the QuickBooks 2019+ "Advanced" version.

  1. Click the Find (BETA) button in the X Dispatch toolbar. 

  2. Go to the Advanced Find Service tab then click Report Formats.

  3. Click the download icon in the Actions column of the QuickBooks settlement you would like. If there is no download icon, then your report format is up to date and ready to be used.

How to Create a Settlement

  1. Go to the Action menu then Settlements > Create Settlements. 

  2. If this is the first time you are creating settlements in the Operations App, you will be asked to select a date as a starting point. It is recommended to leave the default date "1/1/1999". Changing the date could cause a settlement number of -1.

  3. Make sure all fields are filled out in the Create Settlements form.

How to Export a Settlement 

  1. Go to the Action menu then Settlements > Display Settlements. See Display Settlements.

  2. Right-click on batch to export and select the QuickBooks export you would like. If the QuickBooks export you would like is grayed out, you must download it in the Advanced Find Service tab of the Find tool. 

  3. Select location to save output file and press Save.

  4. Click OK when confirmation appears.