↖ BACK TO THE GALAXY
02 · HOW SHE WORKS · THE METHOD

The Leak Ledger. Five stages, four depths.

Money gets stuck at the seams between systems — an invoice never raised, a date that quietly became a blank, a status kept in someone's head. Every one of those is a rule waiting to be written. This is the method for finding them, in the order that pays.

TRACEMap every point money should move and doesn't.
AGECohort the stuck money by age, segment and cause.
RANKScore each leak by recoverable value against effort.
SEALAutomate the top leaks, reconciliation built in.
WATCHA standing dashboard and a monthly read, so it stays fixed.
TRACE · AGE · RANK

The Leak Audit

2 WEEKS · FIXED FEE · WHERE EVERY ENGAGEMENT STARTS
from ₹75,000 · about $2,000 international

Eighteen months of invoice and payment data in; two weeks later you know exactly where your cash is stuck, why, and which three fixes are worth doing.

  • The full map of where money should move and does not
  • Ageing and cohort analysis by segment and cause
  • A ranked recovery list with the top three circled, plus the working file
SEAL

The Seal

3–4 WEEKS · FIXED FEE · HIGHEST REPEAT RATE
from ₹1,50,000 · about $3,500 international

Whatever your team rebuilds by hand every Monday arrives on its own, correct, with a check that tells you when it is not.

  • One manual reporting or chasing process killed end to end
  • A scheduled pipeline with error handling and alerting
  • Reconciliation checks tying every figure back to source, and handover docs
WATCH

The Read

MONTHLY RETAINER · TWO DAYS A MONTH
from ₹1,25,000 / month · about $3,000

Too small for a finance-analytics hire, too big to keep guessing. She is that function, two days a month — and she already knows your numbers.

  • One dashboard answering one question, refreshed automatically
  • A monthly written read: what changed, what it means, what to do
  • A quarterly TRACE re-run to catch new leaks early
FULL METHOD · EMBEDDED

Fractional Analytics Partner

MONTHLY · 20–40 HOURS · ON INVITATION AFTER TWO READS
from ₹2,50,000 / month · about $6,000

Not a project. She owns the number, quarter after quarter, and you stop having to wonder whether anyone is watching it.

  • Your analytics function, part-time and on call
  • The full Leak Ledger cycle, run continuously
  • A seat in the planning conversation — judgement, not deliverables
START WITH A TRACE → SEE IT RUN ON A REAL LEDGER GET THE CV
STRAIGHT ANSWERS
What is the Leak Ledger?

The Leak Ledger is Simran Jaiswal's five-stage method for recovering money that gets stuck between a company's systems: TRACE maps where cash should move and doesn't, AGE cohorts what is stuck by age and cause, RANK scores each leak by recoverable value against effort, SEAL automates the top leaks with reconciliation built in, and WATCH keeps a standing dashboard and a monthly read so it stays fixed.

What does Simran Jaiswal do?

Simran Jaiswal is a Data Storyteller based in Gurugram, India, and a Consultant I, Data & Analytics at EXL Service on the British Gas account, where she owns the Enduring Debt Path debt-recovery reporting. Her specialism is stuck money — billing, collections and pricing — and automating the reporting around it in SQL, Python, Power BI and Databricks.

How does an engagement start, and what does it cost?

Every engagement starts with The Leak Audit — a two-week, fixed-fee TRACE from ₹75,000 (about $2,000 internationally). You share roughly eighteen months of invoice and payment data; you get the map of where money is stuck, an ageing analysis by segment, and a ranked recovery list with the top three fixes circled. Email hello@simranjaiswal.in with the subject "Leak Ledger TRACE".

Which businesses is this for?

Mid-market and growth-stage companies that sell on credit terms — B2B commerce, logistics, services, utilities — where receivables, invoicing or pricing live across more than one system and the month-end question "who hasn't paid us?" still takes a week to answer.

Which tools does she work in?

Advanced SQL (CTEs, window functions, query optimisation), Python with pandas and NumPy, Power BI, Databricks, MySQL, the Google Sheets API, Zoho Books and Inventory, LeadSquared CRM, and AWS EC2 for scheduled pipelines. The work always lands in the tools a team already lives in.