Operations LibraryTwo sources.
REPORTING RECONCILIATION WORKSHEET · EDIT & DOWNLOAD
Two sources.
One set of numbers.
Define how purchase orders, invoices and payments match before you build a dashboard.
| Record / measure | Procurement source | Accounting source | Match / calculation | Owner | Exception / freshness rule | Remove row |
|---|---|---|---|---|---|---|
Nothing is sent to Knot. Changes reset when you leave unless you download or choose to save a draft. Device drafts remain in this browser until you clear them; avoid saving confidential information on a shared device.
01
Agree the records
Name the source of truth, supplier identifier, currency and purchase-order reference.
02
Separate the balances
Distinguish uninvoiced commitments, invoiced amounts still unpaid and payments. Do not add overlapping totals.
03
Keep exceptions visible
Name the owner of missing references and stale sources. Hold ambiguous matches outside the reconciled totals.