Incident Lab · SEV2 · dbt
The daily collected revenue report doesn't match the Berlin team's numbers
RevOps (Berlin): our daily collected revenue figures never match the dashboard. Totals over the three days agree, single days don't.
raw payments.paid at is stored in UTC . Ledgerly's business day is Berlin time, UTC+2 (Berlin, October) , and every report is supposed to use it. daily collections groups by CAST(paid at AS DATE) . Investigate: which payments land on a different day in Berlin? Fix daily collections to group by the Berlin day. Keep the columns day , payments and collected (rounded to 2 decimals). Use a fixed offset of 120 minutes ( to minutes(120) ).