Good import hygiene
Treat source revenue as append-only evidence. Corrections should arrive as refunds, adjustments, or new import rows instead of editing historical rows in place.
- Keep stable external IDs when possible.
- Separate test data from production data.
- Confirm currency before mixing rows into a calculation period.
- Map external product identifiers before running allocation rules.