Monthly P&L Analysis of Expense Variances and Unrecorded Costs

Monthly P&L Analysis of Expense Variances and Unrecorded CostsMonthly P&L Analysis of Expense Variances and Unrecorded Costs

The network for creativity

Join 1.25M professional creatives like you

Connect with clients, get discovered, and run your business 100% commission-free

Creatives on Contra have earned over $150M and we are just getting started

Back to feedPost

Thalmees Ahmadh

• Sep 30

Prepared a comprehensive monthly P&L analysis for an African client, comparing October and November financial performance across direct costs, finance, administrative, operational, and selling & distribution overheads. Reviewed expense movements, identified unrecorded costs and unusual variances, and documented follow-up queries to support accurate financial reporting.

Auditing Consulting Google Drive Microsoft Access Microsoft Excel Financial Analysis

Rooney Kibet

• Sep 27

BEFORE: Client had messy Excel inventory with 500 rows, duplicates (A12 / a12), blanks, wrong prices like "$ 2.5" and "N/A", and different warehouse names (KER / ker / Kericho).

AFTER: I did:

Removed 12 duplicate SKUs

Standardized item names to Title Case

Fixed QTY and Prices to 2 decimals

Unified Warehouse to Kericho

Made sheet ready for pivot dashboard

Result: Clean, ready-to-use inventory in 2 days using Excel.

Tools: Excel, Remove Duplicates, Text to Columns, TRIM, PROPER

Data Analysis Microsoft Excel

Syed Abdul Qadir Gilani

• Sep 27

A data-driven quarterly business review dashboard built to track key performance metrics — monthly revenue trends, customer churn rate, and support response time. This project demonstrates data analysis, visualization, and business intelligence reporting skills using Python for data processing and chart generation.