Examples
Examples
Try the starting example
- Invoice lines: role, invoiced minutes, approved minutes, $/hour
- A,600,480,20 B,300,360,30
- Invoiced minus approved amount by line ($)
- A: 40.00; B: -30.00
- Total invoiced labour ($)
- $350.00
- Total approved-time labour ($)
- $340.00
- Signed total invoice difference ($)
- $10.00
- Sum of positive line overstatements ($)
- $40.00
Try another scenario
- Invoice lines: role, invoiced minutes, approved minutes, $/hour
- A,600,600,20 B,300,360,30
- Invoiced minus approved amount by line ($)
- A: 0.00; B: -30.00
- Total invoiced labour ($)
- $350.00
- Total approved-time labour ($)
- $380.00
- Signed total invoice difference ($)
- -$30.00
- Sum of positive line overstatements ($)
- $0.00
Calculation method
Calculation method
Invoiced minus approved amount by line ($)
Apply the supplied line hourly rate to invoiced and approved minutes separately; subtract cent-rounded amounts.
Total invoiced labour ($)
Sum invoice line pay equivalents.
Total approved-time labour ($)
Sum approved line pay equivalents.
Signed total invoice difference ($)
Total invoiced−total approved.
Sum of positive line overstatements ($)
Sum only positive line differences so other negative differences cannot hide them.
Symbols and units
- a
- Invoice lines: role, invoiced minutes, approved minutes, $/hour
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
- An invoice/approved-time comparison using one supplied rate per role. It does not approve timesheets, decide contractual scope or modify an invoice.
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
US Department of Labor: pay/time recordkeeping background; actual rules vary ↗
Background reading; this does not imply endorsement or independent review of SumFizz.