Examples
Examples
Try the starting example
- Order lines: line ID, ordered units, agreed unit price $
- A,10,5 B,20,2
- Receipts: order line ID, received units; multiple rows sum; or none
- A,8 B,20
- Invoice lines: order line ID, billed units, billed unit price $
- A,10,5 B,20,2.10
- Allowed excess billed units before flagging
- 0
- Allowed absolute unit-price difference before flagging ($)
- 0.05
- Line flags under entered tolerances
- A: billed above received; B: unit price
- Invoice gross ($)
- $92.00
- Matched-unit value at order prices ($)
- $80.00
- Invoice minus matched-unit order-price value ($)
- $12.00
Try another scenario
- Order lines: line ID, ordered units, agreed unit price $
- A,10,5 B,20,2
- Receipts: order line ID, received units; multiple rows sum; or none
- A,10 B,20
- Invoice lines: order line ID, billed units, billed unit price $
- A,10,5 B,20,2
- Allowed excess billed units before flagging
- 0
- Allowed absolute unit-price difference before flagging ($)
- 0.05
- Line flags under entered tolerances
- None
- Invoice gross ($)
- $90.00
- Matched-unit value at order prices ($)
- $90.00
- Invoice minus matched-unit order-price value ($)
- $0.00
Calculation method
Calculation method
Line flags under entered tolerances
Flag billed quantity above ordered/received quantity+tolerance and unit-price difference above supplied cent tolerance.
Invoice gross ($)
Sum billed units×billed price.
Matched-unit value at order prices ($)
For each billed line use min(billed,ordered,received units)×order unit price; tolerances affect flags, not this reference value.
Invoice minus matched-unit order-price value ($)
Invoice gross−matched reference value, retaining signed price reductions and unreceived-unit amounts.
Symbols and units
- a
- Order lines: line ID, ordered units, agreed unit price $
- b
- Receipts: order line ID, received units; multiple rows sum; or none
- c
- Invoice lines: order line ID, billed units, billed unit price $
- d
- Allowed excess billed units before flagging
- e
- Allowed absolute unit-price difference before flagging ($)
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 supplied three-way quantity/price comparison, not approval to pay or a determination of invoice validity. All lines use one currency and already matched IDs.
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.