Raken's integration with Sage 100 Contractor automatically syncs your Projects, Employees, Cost Codes, Classifications, and Pay Types between Sage 100 Contractor and Raken every 30 minutes — so your field team always has accurate data and your payroll team can push completed time cards back to Sage with a click.
Quick Answer
The Sage 100 Contractor integration is CS-managed via the Trimble AppXchange platform. To get started:
Contact your Customer Success Manager or email help@rakenapp.com to request access.
Your Raken integration specialist will confirm eligibility and schedule an intro call.
Sage 100 Contractor integration requires the Performance Plan.
How It Works
The integration is built on the Trimble AppXchange platform, which connects Raken to Sage 100 Contractor via a connector agent installed alongside your Sage instance. Once live, the following data syncs from Sage 100 Contractor to Raken every 30 minutes:
Jobs — synced as Raken Projects
Employees — synced as Raken Workers
Job Phases — synced as Raken Cost Code Divisions
Budgeted Cost Codes — synced as Raken Cost Codes (Labor Hours/Dollars budget required)
Pay Groups — synced as Raken Classifications
When it's time to process payroll, you export completed time cards from Raken Timesheets. Synced time cards appear directly in Sage 100 Contractor's Daily Payroll Entry (section 5-5-1) via API — ready for your payroll team to review and post.
Data Mapping
The table below shows how data maps between Sage 100 Contractor and Raken, and in which direction.
Sage 100 Contractor | Raken | Direction |
Jobs | Projects | Sage 100 → Raken |
Job Phases | Cost Code Divisions | Sage 100 → Raken |
Budgeted Cost Codes | Cost Codes | Sage 100 → Raken |
Employees | Workers | Sage 100 → Raken |
Pay Groups | Classifications | Sage 100 → Raken |
Time Cards | Daily Payroll Entry (5-5-1) | Raken → Sage 100 (on-demand) |
What to Expect During Onboarding
Your Raken integration specialist manages the full onboarding process. Here's what to expect:
Request & intro call — Your specialist confirms eligibility, walks through the integration data mapping, and agrees on next steps.
AppXchange workspace setup — Your specialist creates your AppXchange workspace and sends you an activation email.
Connector agent install — Your IT administrator installs the AppXchange Connector Agent alongside your Sage 100 Contractor instance. Your specialist provides instructions and is available to assist via Zoom.
Data cleanup — Before connecting, your Raken data is aligned with Sage 100 records. Job Numbers in Raken must match Sage 100 Contractor exactly (e.g.,
1234). Employee IDs must match Sage 100 employee numbers exactly. Your specialist guides you through this step.Connection & initial sync — Your specialist connects Raken to the AppXchange cache and activates the data flows: Classifications → Employees → Projects & Cost Codes → Time Cards.
Data review — You review synced data together and confirm the Job Phase → Division and Budgeted Cost Code mapping is accurate.
Time card sync test — You run a test export with one or two workers to confirm time cards are appearing correctly in Sage 100 Daily Payroll Entry.
Go live — Your team starts using the integration for their regular payroll process.
How to Sync Time Cards to Sage 100 Contractor
Log into the Raken web app and click Time in the left side navigation.
Click Time cards, then click Timesheets.
Select the pay period you want to export.
Select all or specific time cards, then click Sync.
Synced time cards appear in Sage 100 Contractor under 5-5-1 Daily Payroll Entry.
Troubleshooting & FAQ
What is the difference between Job Phases and Budgeted Cost Codes in Raken?
Job Phases from Sage 100 sync as Cost Code Divisions in Raken — they are the top-level groupings. Budgeted Cost Codes (those with Labor Hours or Labor Dollars budgets) sync as the individual Cost Codes within those Divisions. Only cost codes with a labor budget sync — your specialist will confirm this during onboarding.
What if I have custom pay types in Raken?
Sage 100 Contractor only supports RT, OT, and DT pay types. These three map directly to the corresponding Raken default pay types. Custom pay types not linked to Sage 100 records can cause sync failures — your specialist will help resolve these during onboarding.
Where do synced time cards appear in Sage 100?
Synced time cards appear in section 5-5-1 Daily Payroll Entry in Sage 100 Contractor, ready for your payroll team to review and post.
Technical Specifications
Integration platform: Trimble AppXchange
Compatibility: Web app only (Raken side); Sage 100 Contractor (active instance required)
Sync frequency: Every 30 minutes (inbound); on-demand via API (time card outbound)
Plan required: Performance Plan
Role required: Account Administrator
Onboarding: CS-managed
Considerations
Requires the Performance Plan and an active Sage 100 Contractor instance.
Job Numbers in Raken must match Sage 100 Contractor exactly before connecting.
IT access is required to install the AppXchange Connector Agent alongside your Sage 100 instance.
Only Budgeted Cost Codes with Labor Hours or Labor Dollars budgets sync — cost codes without a labor budget are excluded.
Job Phases sync as Cost Code Divisions, not as individual cost codes.
Related Articles
More Questions?
Feel free to email us or call us at +1 866-438-0646. We're always glad to answer your questions!