An invoice places a transaction on a timeline, but it does not by itself prove the entire action or guarantee that CAEs will be issued. A useful control links supplier, customer, site, line items, quantities, references and dates to the inventory, photographs, technical report and commissioning. The applicable sheet or methodology and procedure determine the exact records and whether additional proof is required, so the recommended breakdown must be confirmed for each dossier.
Define what each commercial record must prove
Start by defining what each commercial record is expected to establish. A quotation may describe intended scope, an order may authorise supply, a delivery note may locate receipt, an invoice may evidence a billed transaction, and a bank record may evidence settlement. None automatically proves that the equipment was installed or that the action is eligible. Read the applicable sheet or methodology first, then build a reconciliation table whose columns reflect the required technical quantities, dates, parties and locations.
Enter invoices line by line rather than as document totals. Capture issuer and customer tax identity, invoice and correction references, issue date, site reference, item text, manufacturer code, quantity, unit, net amount, discounts, tax and gross amount. Add delivery, asset and calculation identifiers beside each line. When a description is generic, link a contemporaneous specification or delivery record instead of rewriting the invoice. Keep the source PDF and record any structured extraction as a derived working copy.
Reconcile line items, payments and execution
Tie commercial quantities to physical execution. For each billed model or work package, identify delivery location, installed asset tags, serial numbers where relevant, photographic references, commissioning date and quantity accepted into the savings calculation. Explain normal differences such as spares, minimum order quantities or partial installation. The reconciled quantity is not necessarily the purchased quantity. Items held in stock, returned, installed outside the boundary or attributable to non-energy work remain visible but excluded from the evidenced calculation amount.
Reconcile payment only to the extent required for the dossier. Map each transfer, card settlement or financing drawdown to invoice references, dates and amounts without assuming that payment proves technical completion. Handle deposits, milestones, retentions and grouped transfers through an allocation schedule whose total returns to the bank evidence. Limit bank data to relevant fields and protect unrelated transactions. The authorised CAE scheme participant should see the chain without receiving unnecessary financial or personal information.
Handle complex invoices and differences
Treat credit notes and rectifying invoices as changes to the chain, not peripheral paperwork. Link each credit to the original line, state whether quantity, model, price, tax or customer changed, and update the reconciliation and calculation where necessary. A replacement item needs delivery and installation evidence for the final model. For cancelled or reissued documents, preserve both records and explain status. Check arithmetic across net values, tax, credits and payments so the schedule closes without concealing residual balances.
Multi-site and mixed-scope invoices need an explicit allocation basis. Use line references, delivery notes, work orders, measured quantities or another contemporaneous source to separate eligible assets from other sites and from maintenance, civil works or unrelated upgrades. Avoid allocating a global amount solely by savings percentage. Leasing, energy-service contracts and related-party billing may require additional records to explain possession, payment responsibilities and the connection between commercial parties and the implemented action.
Close the financial and technical control
Run contradiction checks across chronology and master data. Compare invoice dates with delivery, installation and commissioning; legal names with agreements; addresses with site identifiers; billed models and quantities with photographs and inventory. Investigate duplicate invoice numbers, repeated lines, unexplained round sums and payments predating the underlying obligation. Correct a working schedule through a logged revision, never by altering source records. Assign every unresolved mismatch an owner and state its possible effect on scope or calculation plainly.
Close with three totals that reviewers can reproduce: invoiced, adjusted after credits and accepted for the evidenced technical boundary. Supply a document index, line reconciliation, payment allocation where applicable, exception log and links to physical evidence. Have a second person sample lines in both directions, from invoice to installed asset and from asset back to invoice. Commercial completeness does not establish CAE eligibility or issuance; the controlling sheet or methodology and current procedure determine which records and conditions matter.