Integrity
5of 9 checks passed last night
Passed
Sources read last night
13 of 13 read
Review
ERP invoices to platforms vs platform lines
86 invoices counted once · 1 with a gap
- Rule
- Platform lines are kept (real sale date, end account); the ERP invoice that bills the same sales to the platform is voided.
- Voided ERP lines
- 3,207 · €10,443,495
- INV-2026-01555 · Galeries Ostrand
- gap €187.60 on 2026-08
| ERP invoice | Invoice | Gap |
|---|---|---|
| INV-2026-0155539 lines voided | €14,367.00 | €187.60 |
| INV-2026-0180438 lines voided | €12,030.32 | €0.00 |
| INV-2026-0179938 lines voided | €21,150.25 | €0.00 |
| INV-2026-0178938 lines voided | €923,623.95 | €0.01 |
| INV-2026-0165338 lines voided | €9,452.84 | €0.00 |
| INV-2026-0164638 lines voided | €13,176.15 | €0.00 |
| INV-2026-0164538 lines voided | €17,312.55 | €0.00 |
| INV-2026-0164438 lines voided | €710,538.18 | €0.08 |
Passed
Same line read twice
206 duplicate lines voided
- Where
- amazon-na report of 2026-07-15, re-read on an overlapping window
- Value kept out
- €7,991
Review
Platform sales not yet invoiced
1 month overdue · 4 in progress
- Wendemark · 2026-10
- Overdue · 2,074 lines · €17,105
- Wholesale marketplace · payout entity · 2026-11
- Current month · 4,381 lines · €460,321
- Galeries Ostrand · 2026-11
- Current month · 1,700 lines · €14,395
- Wendemark · 2026-11
- Current month · 1,103 lines · €9,038
- Pellham Stores · 2026-11
- Current month · 861 lines · €7,563
Review
Codes not in the catalogue
3 codes · 274 lines kept as "Unknown product"
- HLV-BNDL-XMAS-DE
- Amazon · Europe (UK, DE, FR, IT, ES) · 122 lines · €3,648
- PLH-5520433
- Pellham Stores · supplier portal · 112 lines · €2,180
- PLH-5520417
- Pellham Stores · supplier portal · 40 lines · €1,066
Passed
No end-customer personal data
157 columns checked · 0 suspicious values
- Shopify · never read
- customer, email, phone, billing and shipping address
- Amazon · never read
- buyer name, buyer email, ship-to address
- Dropship portals · never read
- end-customer delivery address and phone
- Wholesale marketplace · never read
- retailer contact person and email
- Accounts
- B2B companies only; consumer orders sit on their store or marketplace account
Passed
Converted at the rate of the sale day
359,601 foreign-currency lines · 0 without a rate
- CHF
- 5,081 lines
- GBP
- 169,203 lines
- USD
- 185,317 lines
- Weekends
- take the last published reference rate
Failed
Sales at the price charged, fees as costs
238 lines differ from quantity × price charged
- B2B
- counted at the wholesale price invoiced
- Commissions & platform fees
- 617,309 cost lines · €4,816,972, never deducted from sales
Passed
Screen totals re-add to their lines
Gap €0.00 over €62,234,032
- How
- Daily summaries are recomputed from the lines at every load, never imported