ExcelFlux
← Electrical and mechanical contracting

Procurement Contracts and Commitments

Reconcile contract budgets, releases, received value and invoices in one reporting period.

Premium workbook preview · Member downloads are not yet available

Results from the sample workbook

Approved budget
544,000
Open commitment
161,240
Receipt-to-invoice difference
12,600

Who can use it, and for what?

Purchasing, contract management and accounting

See outstanding commitments before releasing an order and investigate receipt-to-invoice differences.

A worked example from the workbook

K-001 has an approved budget of 544,000, invoices of 177,400 and open commitments of 161,240. The receipt-to-invoice difference of 12,600 is shown separately.

Worksheet from the completed Excel sample
View from the Excel workbook. Open the image to enlarge it.
MeasureSample result
Approved budget544,000
Open commitment161,240
Receipt-to-invoice difference12,600

How do you start with your own data?

  1. Set the base and approved additional budget, opening invoices and opening commitments.
  2. Post new orders, approved invoices, received value and cancellations against the contract code.
  3. Set the report start, end and scenario on Ayarlar. Both boundary dates are included.
  4. Review per-record calculations on Analiz and totals and selected cards such as K-001 on Panel. Resolve unmatched codes, missing dates and duplicate records on Kontrol.

Test a different scenario

Reduce the base budget in Kartlar B7 from 500,000 to 280,000. K-001’s approved budget drops to 324,000 and its risk-adjusted budget gap grows to 30,764. The open commitment stays at 161,240. Keep K-001 selected on Panel and compare the result. Restore the original input when you finish.

Hücre adresleri ve formüller için Türkçe kılavuzu aç