DataXcel Blog — Sage 100 Contractor Reporting Tips & Insights
Practical tips, setup guides, and product updates for Sage 100 Contractor users — from the team behind DataXcel.
Why DataXcel Needs a Sage 100 SQL User — And Why It's Safe
Is giving DataXcel a Sage 100 SQL login with sysadmin dangerous? Here's exactly what the dataxcel user does, why your data never leaves your server, how the access is monitored and audited, and how to revoke it in seconds.
How DataXcel Connects to Your Sage 100 Server — Securely, with NetBird and WireGuard
A plain-English security white paper on how DataXcel reaches your Sage 100 Contractor SQL Server — an outbound-only WireGuard tunnel via NetBird, exactly one allowed port, zero-trust access control, and zero inbound firewall changes.
Don't Migrate Yet: How We Are Using AI to Extend the Life of Sage 100 Contractor
Why we built DataXcel to give Sage 100 Contractor users Intacct-level reporting, security, and AI without the migration nightmare.
TUG 2026 Booth Handouts — DataXcel One-Pagers
The two printable one-pagers from the DataXcel table at TUG 2026 (Booth #32): the Sage 100 MCP connector info sheet and the DataXcel offer + pricing sheet.
TUG 2026 Recap — Thank You, New Partnerships, and What's Coming Next
Thank you to everyone who stopped by Booth #32 at TUG 2026. A quick recap of new customers, new partnerships, and the new trend reports I'm building next based on what I learned at the show.
Never Dread December Again: Turning the Year-End Crisis into a Daily Routine
How to turn manual year-end close checklists into a continuous, AI-assisted daily audit so December never feels like a crisis again.
Claude Just Got Read-Access To Your Sage 100. Free. Here's How.
Customer Q&A recap (May 21, 2026): wire Anthropic Claude to your DataXcel + Sage 100 data via the new MCP server. Free, five-minute setup, real demo. Plus the Sage Estimating pilot interest check and Greg from Burbach's dashboard fix.
The 6 Ratios Your Bonding Company Checks Before Raising Your Line
Working capital, current ratio, debt-to-equity, revenue-to-working-capital, days in AR, and AR:AP — the year-end ratios sureties and bankers actually compute from your Sage 100 Contractor financials.
Profit Fade: Why a Job Looks Profitable Right Up Until It Isn't
Profit erosion hides in plain sight on jobs that are 'making money' — how to measure profit realization against percent complete in Sage 100 Contractor and catch fade before close-out.
Over/Under Billing: The One Report That Must Tie to Your Balance Sheet
Your WIP schedule's over/under billing totals must reconcile to the GL — it's the first thing a bonding company verifies, and a growing gap means your job costing and your books are drifting apart.
Change Orders by Job Type: Catching the Ones You Forgot to Write
Your history knows how many change orders a job of each type should have by each stage — when an active job falls below its own trend, you're probably doing changed work for free.
Bid Accuracy by Cost Area: Where Your Estimates Actually Go Wrong
Your completed jobs already know which part of your bids is broken — compare estimate vs actual by cost type (labor, material, sub, equipment) in Sage 100 Contractor and stop repeating the same estimating miss.
Sage 100 Contractor: Vendor and 1099 Setup — Avoiding Year-End Surprises
Vendors with a 1099 type of Undetermined are the #1 cause of missed 1099 filings — here is how to set them up correctly in Sage 100 Contractor.
Sage 100 Contractor: Assigning Supervisors and Salespersons to Jobs
Leaving Supervisor and Salesperson blank on jobs is a management blind spot — here is why it matters and how to fix it in Sage 100 Contractor.
Sage 100 Contractor: Why Every Job Needs a Budget Before the First Dollar Is Spent
Jobs without budgets break profitability tracking, WIP, and percent-complete reporting in Sage 100 Contractor — here is how to fix it.
Sage 100 Contractor: Why Every GL Account Needs a Category
GL accounts without an account type break the Balance Sheet and P&L in subtle ways — here is how to map them correctly in Sage 100 Contractor.
Sage 100 Contractor: Employee Setup Fields That Matter for Payroll and Reporting
Position, Department, Pay Class, and Employee Type drive payroll, certified payroll, and labor reporting — here is how to set them up right.
Sage 100 Contractor: Getting Your Cost Code Master List Right
Cost codes are the backbone of job costing — here is how to set up and maintain a clean cost code master list in Sage 100 Contractor.
Connect Claude to Your Sage 100 Contractor Data — DataXcel MCP Connector Setup
A friendly, step-by-step guide for contractors and controllers: connect Anthropic Claude to your live Sage 100 Contractor data with the DataXcel MCP connector, and start asking about jobs, WIP, change orders, and costs in plain English — no SQL, no exports.
DataXcel AI Briefing: Beta Tester Training Guide
Beta training reference for the DataXcel CEO Weekly Briefing — covering pipeline, the 10 alert categories, urgency scoring, and tool walkthrough.