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.

| Measure | Sample result |
|---|---|
| Approved budget | 544,000 |
| Open commitment | 161,240 |
| Receipt-to-invoice difference | 12,600 |
How do you start with your own data?
- Set the base and approved additional budget, opening invoices and opening commitments.
- Post new orders, approved invoices, received value and cancellations against the contract code.
- Set the report start, end and scenario on Ayarlar. Both boundary dates are included.
- 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ç