Data quality issue: project revenue records
Ticketclosed
Ashwell Mercer Interiors · Data quality issue: project revenue records
Sunil Kapoor reported that project revenue totals in the brain did not match the finance system, blocking month-end close. Bethan Lister identified duplicate records from the finance connector and cleaned the data.
What happened
What this says
As at Fri 9 Oct 2026Sunil Kapoor reported that project revenue totals in the brain did not match the finance system, blocking month-end close. Bethan Lister identified duplicate records from the finance connector and cleaned the data.
Problem: Data quality issue where project records were duplicated from previous syncs, causing revenue totals to mismatch the finance system and blocking critical month-end reconciliation. Handling: Bethan audited the data, identified the connector was pulling all historical records instead of deltas, cleaned existing records, and adjusted the connector logic. High-priority ticket resolved in 5 days with 80-minute first response. Watch: Connector now pulling only new records; monitor for any recurrence of this pattern.
Details
Updated 9 Oct 26Trail
created · Sunil Kapoor 2 Jul 2025 11:39We've identified a data quality issue that's affecting our month-end close. Several of our project records are showing different revenue totals in the brain compared to what's in our finance system. This doesn't tie to the ledger at all. The amounts are quite far off in some cases. I need this reconciled urgently. We can't close the month without knowing which system has the right figures. Can you help identify what's causing this discrepancy? Is it a data sync issue, a transformation problem in one of the connectors, or something else?- Internal note · Bethan Lister 2 Jul 2025 12:32Pulled the project data from the brain export and compared with the latest finance system extract. Found duplicate records from the previous day's sync for at least three projects. The connector appears to be pulling all historical records again rather than just the delta. Needs investigation by Felix on the connector logic. Sunil needs the fix before month-end.
- Public reply · Bethan Lister 2 Jul 2025 12:59Just so I've got this right, you're seeing project revenue totals in the brain that don't match your finance system, and it's blocking month-end. I've picked this up and done a quick audit of the data. The issue is in how the finance connector is pulling records: it's bringing through duplicates from previous syncs. I've cleaned up the brain records for today and adjusted the connector to pull only new records. Can you re-run a quick check on those three projects and tell me if the figures line up now? Thanks, Bethan
- Status change · 11 Jul 2025 23:59