Contracts & Finance Systems

Connecting contract management to accounting

A Chicago workforce-development nonprofit, roughly 70 staff · 2025–2026

No manual re-entry between CLM and ERP · daily reconciliation inside hours

The problem

Grants, budgets, and invoices were approved in a contract-management system and then retyped by Finance into the ERP. Retyping was slow and error-prone.

Worse, there was no reliable way to tell whether every approved invoice had actually been paid.

What I built

A webhook service between the two systems

A Python and Flask service, containerized with Docker and running on Azure App Service. It listens for contract and invoice events, enriches them from the source system's API, and writes grants, budgets, and vendor bills into NetSuite.

Idempotent write endpoints

Custom NetSuite SuiteScript RESTlets handle upserts. Every record is keyed to its source ID, so a repeated event updates the existing record instead of duplicating it. NetSuite's token-based OAuth 1.0a signing is implemented by hand.

Writeback in the other direction

Bills paid in NetSuite update the contract's spending in the source system, so the two systems agree without anyone re-entering numbers.

Daily reconciliation

A scheduled job matches every approved invoice to its bill and alerts accounts payable to gaps within hours rather than at month end.

Guardrails at the boundary

Duplicate invoice numbers are refused, with an alert listing the existing bills. Negative-total bills are stopped up front and routed to accounts payable as credits. Large batch updates are throttled before they reach NetSuite. A deployment check confirms that scheduled jobs survived each release.

Outcomes

  • Grant, budget, and bill creation run automatically, with no manual re-keying between the two systems.
  • Found and fixed a reporting error that overstated amount paid on about 1,274 of 4,082 rows, where batch totals were being shown in place of each bill's share.
  • Program coding for a new grant type became automatic, checked against all 44 affected contracts before going live.

Stack

  • Python
  • Flask
  • Docker
  • Azure App Service
  • Azure WebJobs
  • NetSuite SuiteScript 2.x
  • SDF
  • REST APIs
  • OAuth 1.0a
  • Power Automate
  • SharePoint

Work like this, for your organization

If the systems behind your contracts and finances are still joined by hand, that’s the problem I solve.