Case studies

Real finance problems, and what fixed them

Seven real problems from client and in-house work: the situation, what I built and what changed. Figures are anonymised where clients asked.

7case studies
50+people on payroll managed
3countries of operations
9accounting and data tools

All case studies

Filter by the kind of work

Multi-department KPI dashboard for Big Bear Vans01

Big Bear Vans · Van conversion and manufacturing

Multi-department KPI dashboard

Each department tracked its numbers in its own sheet. Payroll, purchasing and project costs lived in different places, so nobody saw the full picture until the month was already closed.

  • Mapped every data source and agreed one set of KPI definitions
  • Built a shared model for payroll, budgets, expenses and cash
  • Designed the dashboard around the questions managers actually asked
Power BIExcelClickUp
Read the case study
COGS and inventory valuation model for Vankea02

Vankea · E-commerce, campervan furniture

COGS and inventory valuation model

Product margins were estimated from supplier prices alone. Freight, duties and batch-to-batch price changes were not reaching the cost of goods sold.

  • Collected purchase, freight and duty data by shipment
  • Built a weighted-average costing model at SKU level
  • Reconciled stock movements against sales records
ExcelShopify dataZoho Books
Read the case study
Financial BI dashboard for Intellifyx03

Intellifyx · Technology services

Financial BI dashboard

Monthly reports were rebuilt by hand from exports, which took days and made it easy for small errors to slip through.

  • Wrote SQL queries to pull ledger and billing data
  • Cleaned and joined the data with Python
  • Built Power BI pages for revenue, costs and margins
Power BISQLPython
Read the case study
Revenue forecasting model for Forecasting project04

Forecasting · Small business planning

Revenue forecasting model

Planning relied on last year plus a percentage. Seasonal swings and one-off months made that number unreliable.

  • Cleaned and grouped historical sales by month
  • Tested seasonal and trend-based forecasting methods
  • Presented a base case with low and high ranges
PythonPandasExcel
Read the case study
Multi-country expense tracking for BBV Group05

BBV Group · Manufacturing and operations

Multi-country expense tracking

Expenses from the overseas team arrived through chats and email, in different currencies and formats, which made month-end reconciliation slow.

  • Designed an expense list with required fields and categories
  • Set up an approval flow with a clear process owner
  • Linked the records to monthly reporting
ClickUpExcelGoogle Sheets
Read the case study
Leave and payroll tracker for BBV Group06

BBV Group · Teams across Pakistan, India and Vietnam

Leave and payroll tracker

Leave was tracked differently in each country. Payroll deductions depended on messages and memory rather than a single record.

  • Built one leave register with country-specific rules
  • Added balances, approvals and monthly summaries
  • Connected the monthly summary to payroll inputs
Google SheetsExcel
Read the case study
Team KPI scorecards for BBV Group07

BBV Group · Engineering, marketing and IT teams

Team KPI scorecards

Performance reviews depended on impressions. There was no consistent record of targets, results and follow-ups.

  • Agreed KPIs and weights with each team lead
  • Built report cards and a scoring method in ClickUp
  • Set a monthly routine for updates and reviews
ClickUpGoogle Sheets
Read the case study

Industries

Where this work comes from

Different industries, the same need: numbers that are ready on time and easy to explain.

Manufacturing and vansJob costing, payroll, budgets
E-commerceInventory, COGS, margins
Technology servicesBI reporting, automation
Multi-country teamsExpenses, leave, payroll inputs

Meet Zaineb

Hi, I'm Zaineb. I speak fluent spreadsheet.

Four years closing books, running payroll and building reports for teams in the US and beyond. You get the numbers, and what they mean, in plain words.

Want to learn it yourself?

My free Finzain Academy courses teach bookkeeping step by step, with short videos, practice templates and interactive exercises. New lessons land on YouTube first.

QuickBooks · Xero · Zoho 50+ on payroll Power BI dashboards Hello! 👋

From the blog

Guides and research for business owners

Practical write-ups on bookkeeping, cash flow, accounting terms and automation.