US fulfilment invoice reconciliation template

Use one row per invoice charge line. Retain the invoice and operation references, period, currency and rate-card version. Calculate expected_amount using the actual agreement, including any minimum, rounding, bundled work or credit rule. For a simple unit line only, expected_amount = observed_quantity * agreed_unit_rate. Difference = billed_amount - expected_amount. A difference remains unresolved until its evidence and provider response explain it. Keep credits linked and avoid counting them twice.

The companion example is entirely hypothetical: expected USD 609.00, billed USD 625.00, unresolved difference USD 16.00. Invented rates are not Jeton or market prices. The ordinary-transport line covers 100 parcels; two replacements are charged separately in the example. Real contracts and accounting treatment may differ.