Prerequisites
- A Spectrum instance with import access for AR and AP.
- A Tread admin user with the Settlements and Exports permissions.
- Customer and Vendor records already in Spectrum. Tread maps by external ID.
- A Spectrum import template confirmed with your accounting team.
How it works
- Approve in Tread — Settlements close once approvals land. See Settlements & Driver Pay.
- Generate export — Pick a date range from the Settlements page and export to Spectrum format.
- Map external IDs — Customers and Vendors carry the Spectrum customer or vendor code as an external ID.
- Import to Spectrum — Your accounting team imports the CSV into Spectrum AR and AP.
- Track exported settlements — Tread marks each exported settlement so it can’t be re-included.
What flows where
Setup
1
Open Integrations settings
Go to Settings → Integrations → Spectrum.
2
Confirm your Spectrum import schema
Have your accounting team share the AR and AP templates in use.
3
Tag Customers and Vendors
Enter the matching Spectrum customer and vendor codes in each Tread record’s External ID field.
4
Run a test export
Export one approved settlement and verify it imports cleanly into Spectrum.
5
Set the cadence
Pick a recurring cadence with your accounting team. Tread does not auto-push.
Limitations
- Export only. Tread does not pull data back from Spectrum.
- CSV-based, not API-based. No live two-way sync.
- Customer and Vendor records must exist in Spectrum before import. Tread does not create them.
- Spectrum import errors surface in Spectrum, not Tread.
- Custom configurations may require a one-time mapping review with the Tread team.
Troubleshooting
Spectrum import errors out- Open the Spectrum import log to find the failing row.
- Match the row to the Tread settlement using the invoice number.
- Fix the missing field and re-export.
- Confirm Spectrum’s chart of accounts matches the GL map in Tread.
- Update the GL map in Settings → Integrations → Spectrum.
- Re-export affected settlements.
- Check Tread’s export log for overlapping date ranges.
- Skip duplicates in Spectrum or re-export with a corrected range.