Migrating open quotes and deposits: reconcile each construction job
Check quote versions, existing invoices, payments and unfinished billing when moving live construction jobs into new software.
When moving from Excel or an older system, matching the number of imported rows does not prove that the records are correct. Reconcile each active job’s accepted quotation, existing documents, allocated payments and work still awaiting a billing decision before continuing in the new system.
This is an operational handover check. It is not an accounting close or a VAT treatment guide. Agree how existing invoices, deposits and credit notes will be handled with your accountant and the receiving software provider.
Define the cutover point
Record the date and time at which the old administration is copied. Decide where new documents will be created afterwards. Without that rule, two people may process the same change in different systems, creating histories that each appear plausible on their own.
Preserve a readable copy of the old records and their original document references. A new internal job number must not break the connection with an existing customer invoice. Keep a mapping of old job ID, new job ID and responsible owner.
Check four separate layers
Start with the commercial agreement: which quotation version was accepted, and which changes were approved? Then check issued documents, distinguishing an invoice that already exists from one still to be created. Review payments and their allocation. Finally, inspect completed work that still needs a billing decision.
A paid deposit must not reappear both as a missing payment and as an entirely new amount to invoice. An open quotation must not silently become accepted merely because it was imported.
Use a representative reconciliation case
A job has an accepted quotation of € 12,000 excluding VAT. A deposit invoice for € 3,000 excluding VAT already exists and is recorded as paid in the old administration. A proposed € 1,000 extension has not been approved.
After migration, the accepted € 12,000 scope must remain identifiable, together with the existing deposit invoice and payment allocation. The extension remains a proposal. This example deliberately creates no new invoice or tax posting: it checks preservation of the original states.
Do not compare only the total across all projects. A missing payment on job A can happen to be offset by a duplicated amount on job B. The portfolio total balances while both job records remain wrong.
Record differences before going live
For each job, record the old value, new value, difference, explanation and reviewer’s decision. Compare document counts and amounts, but also statuses and references. Identify whether a missing field represents unavailable information or an intentionally empty value.
Include a normal job, a partial payment, a cancelled quotation, a credit note and a job with several contacts in the review. These are verification scenarios. Use anonymised copies when a software provider does not need actual customer information.
Give one person responsibility for acceptance
An owner resolves the differences and releases the job for continued use. Restrict new entry while the authoritative record is unclear. If an error emerges after cutover, correct it with a reference to the original reconciliation. Do not repeat the entire import without understanding what has already changed in the receiving system.
This check adds a specific acceptance method to the broader Excel migration guide. In an Enfin demonstration, review a job with an existing quotation, invoice and payment. The important question is not simply whether a file can be imported, but whether the same live job can continue with its commercial state intact.
Returnable pallet deposits: reconcile accepted returns with supplier credits
Reconcile pallet deposits with returned, accepted and credited quantities. Separate a missing supplier credit from pallets still on a Belgian site.
Forecast final job margin with open purchase orders
Use a Belgian contractor’s worked example to reconcile posted costs, outstanding orders and the cost of remaining work before handover.
Belgian site-safety cascade: who checks each subcontractor in the chain?
Map safety duties through a Belgian construction subcontractor chain and keep contracts, evidence, owners and escalation separate from attendance records.