# Contract Change Order Reconciler Local source edition 1.0.0. Reconcile revised contract balances against approved change orders, separate pending proposals and download a variance list for project review. ## Run locally Extract the complete ZIP. Use Python 3.12 from a terminal in the extracted directory. The tool uses the Python standard library. python run.py example.json results Use a new output folder for each run. Start with example.json and replace its synthetic values with your own data. Preserve field names, types and units. Files and reports are processed on your computer. ## Inputs Supply one currency code, 1–500 contracts (id, originalMinor, reportedRevisedMinor) and up to 2000 orders (contract, id, status, amountMinor). Use anonymous IDs and signed integer minor units; credits are negative. Status: approved, pending, draft, declined or void. All amounts must use the same tax basis, currency and cutoff. Each order is a separate net change, not a cumulative revision. ## Results CONTRACTS.csv reconciles original plus approved net to reported revised value. ORDERS.csv shows the contribution of every row. EXCEPTIONS.csv lists nonzero differences (reported minus calculated). Pending and draft amounts stay separate. The report uses supplied approval status and does not sign, approve or bill a change. The results folder includes summary.json and the output files produced by this input. The sample produces: CONTRACTS.csv, ORDERS.csv, EXCEPTIONS.csv. ## Español · Conciliador de modificaciones de contratos Compara saldos revisados con órdenes de cambio aprobadas y separa las propuestas pendientes y las diferencias. Extrae el ZIP completo y abre una terminal en esa carpeta con Python 3.12. El programa usa la biblioteca estándar de Python. Ejecuta: python run.py example.json resultados Copia example.json para preparar tus datos. Conserva los nombres y tipos de los campos, usa una carpeta de salida nueva y consulta summary.json junto con los archivos generados. La descripción detallada de los campos está en inglés. The included LICENSE covers use and modification for your own personal and commercial projects. This edition includes its source and can run locally after setup.