Examples
Examples
Try the starting example
- Approved contract metadata: contract ID, supplier, allowed categories joined by |, start date, end date inclusive
- C1,V1,office,2026-10-01,2026-12-31 C2,V2,software,2026-10-01,2026-12-31
- Transactions: ID, supplier, contract ID or none, category, date, amount $
- T1,V1,C1,office,2026-10-20,100 T2,V1,none,office,2026-10-20,50 T3,V3,C1,office,2026-10-20,70 T4,V2,C2,office,2026-10-20,30
- Spend flagged outside supplied contract metadata ($)
- $150.00
- Flagged spend share (%)
- 60
- Flagged records and metadata reasons
- T2: missing contract; T3: supplier mismatch; T4: category not covered
- Spend matching supplied metadata ($)
- $100.00
Try another scenario
- Approved contract metadata: contract ID, supplier, allowed categories joined by |, start date, end date inclusive
- C1,V1,office,2026-10-01,2026-12-31 C2,V2,software,2026-10-01,2026-12-31
- Transactions: ID, supplier, contract ID or none, category, date, amount $
- T1,V1,C1,office,2026-10-20,100 T2,V1,none,office,2026-10-20,50 T3,V3,C1,office,2026-10-20,70 T4,V2,C2,software,2026-10-20,30
- Spend flagged outside supplied contract metadata ($)
- $120.00
- Flagged spend share (%)
- 48
- Flagged records and metadata reasons
- T2: missing contract; T3: supplier mismatch
- Spend matching supplied metadata ($)
- $130.00
Calculation method
Calculation method
Spend flagged outside supplied contract metadata ($)
Sum positive transaction cash where no contract, unknown contract, supplier mismatch, category mismatch or date outside contract is recorded.
Flagged spend share (%)
Flagged amount/all supplied transaction amount×100; undefined for zero total spend.
Flagged records and metadata reasons
List every applicable supplied-metadata reason without asserting legal noncompliance.
Spend matching supplied metadata ($)
Total amount−flagged amount.
Symbols and units
- a
- Approved contract metadata: contract ID, supplier, allowed categories joined by |, start date, end date inclusive
- b
- Transactions: ID, supplier, contract ID or none, category, date, amount $
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- A local provided-metadata exception audit. It does not infer procurement authority, determine legality, block payments or certify that a contract-matching transaction is permitted.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.
Further reading
Background reading; this does not imply endorsement or independent review of SumFizz.