Prerequisites
- A Foundation instance with import access.
- A Tread admin user with the Settlements and Exports permissions.
- Customer and vendor records already in Foundation. Tread maps by external ID.
- A Foundation import template confirmed with your accounting team.
How it works
- Approve in Tread — Settlements close once both sides sign off. See Settlements & Driver Pay.
- Generate export — From the Settlements page, pick a date range and export to Foundation format.
- Map external IDs — Customer and vendor records carry a Foundation customer or vendor code as the external ID.
- Import to Foundation — Your accounting team imports the CSV into Foundation’s AR or AP module.
- Track exported settlements — Tread marks each exported settlement so the same settlement is not exported twice.
What flows where
Setup
1
Open Integrations settings
Go to Settings → Integrations → Foundation.
2
Confirm your Foundation import schema
Have your accounting team share the AR and AP import templates in use.
3
Tag customers and vendors
Open each Customer and Vendor in Tread and enter the matching Foundation code in the External ID field.
4
Run a test export
Export one approved settlement and confirm the import succeeds in Foundation.
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 Foundation.
- CSV-based, not API-based. No live two-way sync.
- Customer and vendor records must exist in Foundation before import. Tread does not create them.
- Foundation import errors surface in Foundation, not Tread.
- Custom configurations may need a one-time mapping review with the Tread team.
Troubleshooting
Foundation rejects rows on import- Read the Foundation import log to find rejected rows.
- Match each row to the Tread settlement using the invoice number.
- Fix the missing field (often a job code or external ID) and re-export.
- Tread’s export log shows which settlements were in each file.
- Avoid overlapping date ranges on subsequent exports.
- Delete the duplicate in Foundation if needed.
- Pull the Foundation customer or vendor list.
- Reconcile against Tread external IDs and update Tread to match.
- Re-export.