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