Payroll Import
Map external payroll data into Sage 100 Contractor's structure using OPDC's transaction model. Import from spreadsheets today, with native provider connectors coming soon.
Back to IntegrationsCapabilities
Spreadsheet Import
Upload Excel or CSV files containing payroll data. Column mapping lets you match your file layout to Sage fields without reformatting.
Field Mapping Engine
Map employee numbers, cost codes, job numbers, and pay types to their Sage 100 equivalents. Save mapping templates for repeated imports.
Pre-Post Validation
Every row is validated against your Sage master files before posting. Invalid records are flagged with clear error messages for correction.
Batch Processing
Group payroll records into batches for review and approval. Post entire batches as a single Sage transaction with full rollback support.
Audit Trail
Every import is logged with the original file, mapped data, validation results, and posting status. Full traceability from source to ledger.
OPDC Transaction Pipeline
All data flows through OPDC's secure API layer. No direct database access required — the same pipeline used by all OPDC integrations.
Supported Formats
Excel & CSV
Upload .xlsx, .xls, or .csv files. Flexible column mapping supports any layout your payroll provider exports.
ADP
Native ADP connector in development. Will pull payroll data directly via ADP's API without manual file exports.
Gusto
Native Gusto connector in development. Automated payroll sync with Sage 100 Contractor.
Ready to automate your payroll import?
We'll walk your team through the setup and help you build your first mapping template.