Contracts & Finance Systems

Migrating seven years of accounting history

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

239,086 lines loaded once · dollar totals matching the source in every period · $0.00 net GL impact

The problem

The organization moved from Microsoft Dynamics GP to NetSuite. Auditors and Finance needed seven fiscal years of trial-balance history in the new system.

It had to match the old system to the penny.

What I built

A re-runnable pipeline

A scripted pipeline turns GP detail into NetSuite journal entries. It loads to a sandbox first and can be re-run safely, because reloads replace lines instead of appending them.

Line-level traceability

Every historical line carries its original document number, source, and date, so staff can trace any entry back to GP after the old system is switched off.

Master-data corrections surfaced by validation

349 sub-grants re-parented under their parent grants, a mislabeled cash offset account corrected, and grant tags filled in on about 14,100 lines that had none.

Batching for the largest periods

The biggest months exceeded what NetSuite would accept in a single request, so the loader splits them and reconciles the parts.

Outcomes

  • 239,086 historical lines loaded exactly once, with dollar totals matching GP across every period and a net GL impact of $0.00.
  • Several validation sessions with the finance lead closed with every open item being a labeling or detail question. None was a money discrepancy.

Stack

  • Python
  • NetSuite REST
  • SuiteQL
  • Journal-entry automation
  • Data reconciliation
  • Microsoft Dynamics GP

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.