Overview
Siteline integrates with Sage 100 Contractor to streamline construction billing workflows for specialty subcontractors. While Sage 100 remains your system of record, Siteline simplifies billing—helping teams work faster, reduce errors, and get paid sooner.
How Siteline Works with Sage 100
Siteline connects to Sage 100 via a secure API integration. This allows users to import project and schedule data into Siteline and sync finalized pay apps back to Sage 100 for accounting.
This integration reads real-time data from Sage 100 and syncs billing values back via user-initiated push. Here's how it works:
Import project data and SOVs from Sage 100 into Siteline
Bill using Siteline’s intuitive interface (e.g., progress billing)
Sync invoices back to Sage 100 for financial tracking and reporting
The integration reads real-time data from Sage 100 and syncs billing values back via user-initiated push.
Key Integration Notes
Bidirectional API Sync: Read/write access via secure integration
On-Demand Sync: Users initiate all data syncs; Siteline never auto-posts to Sage
SOV Source: Schedule of Values are pulled from Sage 100’s 6-9 Proposals module
Invoice Sync: Invoices are pushed into Sage 100’s AR module with values, retention, and income accounts
Invoice Code Handling: Siteline generates the next invoice number in sequence, based on what exists in Sage
Period Sensitivity: Sage auto-assigns the posting period based on its current accounting period
Retention Note: Retention-only pay apps are not currently supported by the integration
Change Order Sync Timing: Approved COs in Sage may take 5–10 minutes to appear in Siteline
Integration Details
Type: API-based
Data Flow: On-demand, bidirectional (user-initiated syncs)
Security: Encrypted API communication; no direct database access
Posting Rules: Sage 100 determines posting period based on current open period
Detailed Field-Level Mapping: Siteline <> Sage 100
Project Import
Direction: Sage 100 > Siteline
Source Module: 3-5 Jobs module
Sage 100 Field >>> | >>> Siteline Field |
Job Name / Number | Project Name |
Client | GC / Owner |
Cost Codes | Cost Codes in SOV |
Address | Project Address |
Sales Tax District | Taxes |
Contract # | Contract # |
Retainage rate | Contract retention |
Schedule of Values (SOV)
Direction: Sage 100 > Siteline
Source: 6-9 Proposals module
Sage 100 Field >>> | >>> Siteline Field |
Cost Code | Cost Code |
Description | Name |
Amount | Scheduled Value |
Change Orders | COs appear in SOV view (if approved) |
Invoices (Progress Billing)
Direction: Siteline > Sage 100
Target Module: Accounts Receivable
Siteline Field >>> | >>> Sage 100 Field |
Invoice # | Invoice # (auto-incremented) |
Invoice Date | Invoice Date |
Line Items* | AR Line Items* |
Amounts* | Line Totals* |
Retention | Included (except for retention-only pay apps) |
Income Account | Selected during sync step |
*While Line Items and Amounts aren’t literal field names in either system, they represent the line-level billing details that Siteline syncs into Sage 100’s AR module. This table reflects how your project billing data flows between the two platforms during invoice sync.
Vendor Records
Direction: Sage 100 > Siteline
Source Module: Vendor records
Sage 100 Field >>> | >>> Siteline Field |
Vendor Name | Vendor Name |
Contact Info | Vendor Details |
Vendors must be manually added to each project in Siteline to trigger waiver workflows.
FAQs
Can Siteline handle lien waiver tracking?
Yes. Siteline imports vendors from Sage 100, then lets you manage waivers through the vendor module. Vendors must be added to projects manually to initiate waiver tracking.
Do retention values sync?
Yes, retention is included in invoice syncs. However, retention-only pay apps are not currently supported and must be entered directly into Sage 100.
What about unapproved change orders?
Only approved change orders from Sage will sync. Others can still be tracked manually within Siteline.
How long does integration setup take?
Most customers are fully connected and syncing data within a few days of onboarding.
[Appendix]: Screenshot Level Detail
This section walks through what Siteline <> Sage 100 sync looks like in practice—from project setup to invoice posting.
Please Note: Field names may vary slightly depending on your Sage 100 configuration.
This is what a job looks like in Sage 100 before importing into Siteline:
These two screenshots show what the above project looks like when imported from Sage 100 into Siteline. (To import a project, select “New project” on the homepage. Next, in the modal box that pops up: select the project type, select the ERP you want to import the project from, and then search for your desired project in the search bar.):
This is where we can import SOV’s from Sage 100- Module 6-9 Proposals.
These two screenshots show what an invoice looks like in Siteline before syncing over to Sage 100 (To sync an invoice to sage, you can click the “Sync invoice to Sage” button shown in the top right corner of the screenshot below):
This is what invoice looks like in Sage 100 after syncing from Siteline:
This is an example of what a Vendor could look like in Sage 100 before importing to Siteline (To import a vendor, navigate to the Vendor module and select “Add vendor” in the top right corner.):
This screenshot shows what that Vendor would look like after importing in Siteline: