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
Automated Multi-Source File Merger & Reconciliation Tool
Project Description
Project Title: Multi-Source Excel Data Consolidation & Discrepancy Finder
The Challenge: Daily reconciliation across 20+ regional files with different column naming structures and messy formatting was causing delays and missing records.
The Solution (Python + Power Query): Engineered a unified pipeline where a Python script uses Fuzzy Logic & Pandas to standardize column headers, deduplicate records, and automatically reconcile mismatched totals into a clean Excel output.
The Impact: Reduced 3 hours of daily manual cross-checking to 10 seconds with zero human error.
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
Related posts
Esports players generate a lot of performance data. The challenge is making it useful at a glance.
Fragstat is a mobile analytics app concept that brings champion insights, match statistics, seasonal progress, and achievements into one clear experience. Soft blue gradients, translucent cards, bold typography, and character imagery give the data a distinct gaming identity.
The result is a more approachable way to review performance, spot patterns, and follow progress over time.
Analyzed a dataset of 100 students using Microsoft Excel to evaluate revenue collection, outstanding payments, and instructor-wise performance. Created charts and a dashboard to visualize key findings and provide actionable recommendations for improving payment recovery.
A demo project built on fictional sample data, not a live client engagement. The problem: a small business exports invoices as separate monthly CSV files and has no quick view of who owes what. The fix: a short Python script that merges every monthly CSV, cleans the columns, and builds an Excel summary with totals and unpaid amounts per customer. In the sample run it merged 24 invoices from 3 files across 4 customers and flagged £2,978.43 still unpaid, in seconds instead of an afternoon of copy-paste. Good fit for: bookkeepers, trades and shops that export invoices from different tools and want one tidy workbook. We can adapt it to your file layout as a small fixed-price job.
