Portfolio home

Portfolio demonstration with synthetic data

Leading weekly and monthly revenue reviews

This example follows a question raised in the weekly Data meeting through the month-end close.

My role

I built the end-of-month reports and led the weekly Data meeting, where we reviewed revenue and discussed what changed week over week.

Weekly Data meeting brief

Week three discussion. The first view shows $2,170 MRR, down $250 from week two. The team traces $200 of the apparent decline to a delayed refresh and verifies that the remaining $50 came from a customer spending less.

Weekly MRR in the synthetic January close
CheckpointAs first reportedValidatedValidated change
Opening$2,000$2,000—
Week one$2,300$2,300+$300
Week two$2,420$2,420+$120
Week three$2,170$2,370−$50
Month-end$2,450$2,400+$30

Decisions and follow-up

The month-end adjustment includes a $150 account match and a $200 late cancellation. The week-three reporting delay clears separately and contributes no movement to the monthly bridge.

Related walkthroughs

Billing data in the CRM · Revenue reconciliation and sign-off