Settlement Advance Types Export Details

What You Should Know About Settlement Advance Data Integration

• Ditat TMS will request an updated Chart of Accounts and Item List from QuickBooks before each sync.

• Ditat TMS does not retrieve vendor information from QuickBooks — it only creates and updates vendors.

• Before exporting, Ditat TMS checks whether a vendor with the same Accounting ID already exists in QuickBooks. If it does, the vendor record will be updated with any new information. If it does not, a new Vendor will be created using the Accounting ID as the vendor name.

• For each advance, Ditat TMS sends two offsetting entries to the QuickBooks General Journal:

  • Debit – Driver Advances (Other Current Asset)

  • Credit – Fuel Card Payable (Credit Card)

• Ditat TMS checks whether a Vendor Credit with the same reference number already exists in QuickBooks. If it does, it will not be exported.

• If a duplicate Vendor Credit or General Journal entry is found in QuickBooks, Ditat TMS will mark it as exported and log a warning in the export report.

• Ditat TMS only exports certain fields to QuickBooks (see below). All other fields in QuickBooks can be modified independently and will not be affected by the export.

• Due to QuickBooks' 11-character limit, Ditat TMS will shorten the Vendor Bill ID to comply. For example, SB-0000123456-01 will be transferred to QuickBooks as 123456-01.

For frequently asked questions about sync warnings and errors, click here.

Fields exported to QuickBooks

Header Data

Detail Data