I turn numbers into insight — and the story hiding inside them.
Kanishk Sangal — an accounting professional turning data into insights. Four years in finance operations taught me where numbers actually come from; now I build the automation and analysis that turn them into decisions.
About
Working in accounting was where I started — accounts receivable, deposit liability reconciliation, cross-border payment processing. It taught me exactly where numbers break, and why that matters more than knowing any one tool.
Today, I'm a data analyst in the making. Every reconciliation, every ticket, every spreadsheet has a story buried in it — my job is pulling that story out and turning it into something a team can act on. That's the shift: from closing tickets to closing the gap between raw digits and real insight.
I write about that journey publicly as @fromdigitstodata — turning digits into data, one post at a time, for anyone else making the same crossover from finance and operations.
Selected work
Deposit Reconciliation Automation Saves ~1,000 hrs/month
Rebuilt a manual bank-statement reconciliation process — spanning multiple PDF statements — into a structured Excel system using Power Query for ingestion and dynamic-array formulas (GROUPBY, LET, FILTER) for matching logic. In production, it saves the team roughly 1,000 hours of manual reconciliation work every month.
Refund Automation Template
A reusable refund-processing template built the same way — a blank version anyone can drop their own data into, and a sample-data version to see the logic in action before adapting it. Built to remove repetitive manual matching from refund workflows.
Multi-Property Reconciliation Pipeline
Working through the StudentSuite/NetSuite reconciliation pipeline covering roughly 50 properties and 200–300 tenant accounts each — building toward an automated Power Query and VBA process that outputs 50 separate, property-specific Excel files without manual rework per property.
AR Workflow Automation
Manage a Freshdesk-based accounts receivable workflow and am building toward API-driven bulk ticket resolution via Excel VBA — designed to remove repetitive manual closure of high-volume, low-complexity tickets.
From Digits to Data
An ongoing public content project on LinkedIn and Instagram turning stories into insights for anyone crossing over from finance and operations into data — data literacy explained plainly, under the running theme "Data But Make It Fun."
Toolset
- SQL (MySQL)
- Power Query
- Data validation & QA
- Power BI
- Excel (dynamic arrays, VBA)
- Dashboard design
- NetSuite — SME
- FloQast
- Freshdesk