Prerequisites
- A Sage 300 instance with import access.
- A Tread admin user with the Settlements and Exports permissions.
- Customer and vendor records already in Sage 300. Tread maps by external ID.
- An agreed export cadence 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 Sage 300 format.
- Map external IDs — Customer and vendor records carry a Sage 300 external ID set during onboarding.
- Import to Sage — Your accounting team imports the CSV into Sage 300.
- 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 → Sage 300.
2
Confirm the Sage external ID format
Match the external ID format used in your Sage instance — usually a customer or vendor code.
3
Tag customers and vendors
Open each Customer and Vendor in Tread and enter the matching Sage 300 ID in the External ID field.
4
Run a test export
Export one approved settlement and confirm it imports cleanly into Sage.
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 Sage 300.
- CSV-based, not API-based. No live two-way sync.
- Customer and vendor records must exist in Sage before import. Tread does not create them.
- Sage import errors surface in Sage, not Tread. Re-export after fixing source records.
- Custom Sage configurations may need a one-time mapping review.
Troubleshooting
Customer not found on Sage import- Confirm the Sage external ID on the Tread Customer record matches the Sage customer code.
- Fix the ID in Tread and re-export the settlement.
- Check whether the same date range was exported twice — Tread’s export log shows what was included.
- Skip duplicates in Sage or re-export with a tighter date range.
- Confirm Sage’s chart of accounts has the income and cost-of-goods accounts the import expects.
- Add the missing accounts and re-import.