Safe, auditable migration of legacy Excel sales data into the Verified Historical layer. Imported records are marked historical and are excluded from live Desk, Counter, supplier automation, and payment reminders.
1. Paste & Map
2. Validate
3. Review Groups
4. Commit
Important: Do not allow raw Excel rows to write directly into production orders. This centre validates, groups multi-activity bookings, and writes only to the historical layer with full lineage. Historical = TRUE is not enough — operationsEligible is forced to FALSE.
1. Paste data & select Mapping Profile
Discounted is treated as Selling Unit Price. Date format: DD/MM/YYYY or YYYY-MM-DD. Currency: NZD.
Expected columns (order not required if header present): Date, Ref, Name, Activity Date, Operator, Product, Retail, Qty, Discounted, Sub-total, Total Bill, Payment Method, Salesperson, Contact, Note…
2. Import Validation Preview
Select the rows to import. Edit any incorrect values before continuing. Final is the full line total in NZD; a negative quantity is a historical adjustment, not a cash refund.
3. Review candidate Bookings (grouped)
Rows are grouped by Ref + Guest (preferred) or Guest + Activity Date. Multi-activity rows in the same group become one Booking. Check guests with the same name before committing.
4. Commit to Verified Historical layer
Records will be written with: status=historical, historical=true, operationsEligible=false, source=legacy_import, locked=true. They appear in Orders / Finance / Report but do not trigger Desk notifications, supplier tasks, or payment reminders.