Skip to content
English
  • There are no suggestions because the search field is empty.

Accounting Sync History

Business Objective

  • Give accounting teams visibility into every invoice, bill, invoice payment, and bill payment that has been synced (or failed to sync) to an external accounting system such as QuickBooks Online.
  • Reduce support tickets by letting users self-diagnose sync failures with the exact error message returned by the accounting partner, then retry or clear the record without involving engineering.
  • Protect month-end close by surfacing Pending and Failed records at a glance and allowing selective re-sync rather than forcing a full bulk replay.
  • Preserve a complete audit log of sync attempts, amounts, and reference numbers so discrepancies between the TMS and the accounting system can be reconciled line-by-line.

User Guide

Accessing the page

Go to Accounting and select Accounting Sync History. This page requires the Accounting Sync role; users without the role will be redirected to the sign-in page.

Tabs

The page is organized into four tabs, one per entity that syncs to external accounting systems:

  • Invoices
  • Invoice Payments
  • Bills
  • Bill Payments

Filters

  • Sync Status. Defaults to Failed. Also supports Complete and Pending. When Pending is selected the date range is disabled, since pending records have not yet attempted to sync. Status values: Pending (0), Complete (1), Failed (2).
  • Date Range. Defaults to a one-month window starting today. Controls which sync attempts are included.

Results

Each row shows the record’s key fields (for example, invoice/bill number, amount, payer and billing organizations, shipment ID where applicable) alongside the external sync details: sync date, status, reference number returned by the external system, synced amount, and the error message (when the sync failed).

Available actions

  • Select one or many rows using the row checkbox or the Select All control.
  • Update Sync Status. Move selected records to a new status (for example, mark a failing record as Complete after it has been reconciled manually in the external system, or push a Pending record back for a fresh attempt).
  • Export to Excel. Download all results currently shown on the active tab. The export is hidden for users with the Hide Export To Excel role.

Technical Information

  • The external sync status values that appear on a record are Complete, Failed, and Pending. These reflect the outcome of the last sync attempt for that record, not the TMS-side accounting status (Ready, Approved, and so on).
  • Invoices and Bills rows include a “Total vs. Synced” comparison so that partial sync issues (where the TMS amount differs from what was written to the accounting system) can be spotted without opening each record.
  • This page does not push data to the accounting system on its own; it reads the outcomes of sync jobs performed elsewhere. Changing a status here only updates the TMS-side record so future sync jobs can pick it up appropriately.

Troubleshooting checklist when records fail to sync:

  • Confirm the external accounting connection is still authorized (tokens expire; check the accounting source settings).
  • Read the error message on the row; many failures are due to missing customer, vendor, or GL account mappings on the external side.
  • For invoice or bill amount mismatches, compare the TMS-side Total against the Synced Total on the row and reconcile charge lines if needed.
  • For repeated Pending records that never attempt sync, confirm the record is in a syncable TMS status (Invoice must be created, Bill must be approved, and so on).
  • After correcting the external system, update the TMS sync status so the record is retried or closed.