A finding you can
check yourself.
Customer: Example Store · Warehouse: Example Warehouse
The source records
- Rate agreement R1: effective 1 August 2026. First-item picking: $1.20 per fulfilled order; additional items: $0.30 each. A monthly minimum of $500 applies to total picking charges. No amendments supplied in this illustration.
- Activity export A1: 1,000 fulfilled orders, each containing exactly one picked item.
- Invoice I1, line 1: 1,000 first picks at $1.35, billed at $1,350.
- Invoice I1, line 2: storage, billed at $200. No storage schedule or occupancy records supplied.
- Invoice I1, line 3: 100 additional-item picks at $0.30, billed at $30. This conflicts with the activity export; its completeness needs confirmation.
The reconciliation
| Charge | Billed | Expected | Difference | Evidence / status |
|---|---|---|---|---|
| First-item picking | $1,350 | $1,200 | $150 | I1 line 1, R1 and A1: 1,000 × $1.20. The $500 minimum does not change the calculation. Supported within the supplied records. |
| Additional-item picking | $30 | Unresolved | Excluded | A1 shows no additional items. Confirm that all billed activity is represented before treating this as an overcharge. |
| Storage | $200 | Untestable | Excluded | Storage schedule and occupancy records missing. No conclusion. |
A draft warehouse query
Please review invoice I1 line 1. Our supplied August rate agreement R1 specifies $1.20 per first pick, while the invoice applies $1.35 to 1,000 first picks. The difference is $150. Could you confirm whether an effective amendment explains the rate, or issue a correction if the agreed $1.20 rate applies?
Separately, line 3 bills 100 additional picks that we cannot match to the activity export. Please provide the corresponding activity detail. We have not included these charges in the supported discrepancy total.
What this example establishes
This illustrates the structure of the intended deliverable: the calculation, source references, limitations and a practical billing query. It does not demonstrate production performance. Actual reviews require checks of source locations, effective dates, amendments, units, credits and activity coverage.