At the end of the month, the general contractor receives a pile of subcontractor completion certificates with invoices, usually PDFs from Buildxact or Excel. The project manager has to check that the quantities in the certificate match the work actually done and the CostX estimate limits, that the rates are those in the contract, that no work is included that was already paid under an earlier certificate, that the retention required by the contract has been applied, and that the invoice total matches the certificate. The manager does this from memory and in Excel, often in a hurry because the subcontractor is waiting for payment, and then the accountant keys the invoice into SAP Business One. Errors come to light months later, when the cumulative value of the certificates exceeds the contract or the retention was never applied.
The solution accepts certificates and invoices from email or SharePoint, reads them down to the line level and compares them with the contract, the CostX estimate and the Procore project budget, if you use it: for every line it checks the rate, the cumulative quantity including earlier certificates, the estimate limit, the retention percentage and whether the invoice matches the certificate. Discrepancies are presented to the project manager in a list with the certificate line, the contract clause and the difference, and the manager marks whether to accept the explanation or return the certificate to the subcontractor for correction. Clean documents are prepared for import into SAP Business One or NetSuite with the project and cost code assigned, and the accountant approves the batch, and only then does the entry appear in the books and the costs are updated in Procore. For document recognition we use Azure AI Document Intelligence in an EU region or AI Builder in your Microsoft 365 tenant, we build the flows with Power Automate, and we integrate with Buildxact, Procore and SAP Business One or NetSuite through the API, file export or an email flow, depending on the version. Documents stay in SharePoint and the accounting system and are not used for model training.