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
Inventory & Purchase Order Reconciliation
Developed an Excel-based inventory and purchasing workbook for real retail pharmacy operations.
The project involved:
Consolidating inventory, sales, purchase order, and receiving data.
Matching product records using SKU codes.
Tracking purchase orders and identifying outstanding or partially received quantities.
Performing stock reconciliation and identifying discrepancies.
Supporting purchasing decisions through sales trends, stock levels, and Pareto analysis.
Tools: Microsoft Excel, Data Cleaning, Data Reconciliation, Inventory Analysis.
Real project. Portfolio preview reconstructed using anonymized example data to protect confidential business information.
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
Relivo — Multi-Store Retail POS & Inventory Orchestration Platform 🛍️✨
Relivo is an enterprise-grade retail management web app built around real-time inventory observability, order auditability, and seamless customer retention.
The goal was to remove register checkout friction and multi-branch inventory opacity — pairing high-contrast OLED dark panels with vibrant status badges and structured tabular grids to make high-volume store tracking feel effortless.
Special attention was given to:
• A product-focused catalog grid managing 1,482 SKUs with real-time stock threshold bars, margin calculations, and channel tags.
• Full-spectrum order audit feeds tracking turn-level transaction events from item addition down to receipt printing and pickup confirmation.
• Customer CRM integration connecting loyalty points (Gold Tier) and purchase histories directly to active order inspection panels.
• Granular transaction tracking separating payments across Visa, QRIS, GoPay, and Cash alongside exception statuses (Part. refunded, Refunded).
• High-visibility neon status badges (Out of stock, Low stock, Processing, Completed) for instant scannability during busy shifts.
• An elevated presentation aesthetic showcasing dark tablet and desktop displays resting on textured metallic and ambient backlit surfaces.
The result is a fast, reliable digital workspace that combines raw enterprise utility with modern software sophistication.
Ready to transform your retail, POS, or enterprise software into a seamless digital experience? Let’s partner up to build something extraordinary ✨
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.
Who else agrees that messy data sets are the biggest headache🧠
Data records are one of your corner posts of you business, with messy data comes messy and chaotic business.🔥
Am I the only one who continues to work and improve on skills needed to do this correctly and accurately, or do you the same.
