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
A self-initiated Excel workbook project created for Nomika Studio.
The goal was to organise income and expense records in one structured system and make monthly performance easier to review.
The workbook includes:
• An organised transaction-entry table
• Income and expense categories
• Transaction statuses and payment methods
• Dashboard summaries
• Monthly and category reports
• Formula-only Excel calculations
Designed for Microsoft Excel Desktop using a clear, beginner-friendly layout.
Skills demonstrated: Excel workbook design, formulas, dashboard design, data validation, reporting and spreadsheet organisation.
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
Trending
Claude
Claude has entered the design space. How are you using Claude Design?
Contra University
Learn from expert creatives how to earn more using next-gen AI tools.
creativeaiflow
Creative AI workflows are evolving. What tools do you use, and what are their strengths and weaknesses?
freelancerlife
Freelancer life is wins, pivots, and everything in between. What’s yours right now?
Related posts
Formula-driven Excel KPI dashboard
Synthetic portfolio demonstration: organized clean operating data into defined KPIs, formula-driven summaries, clear charts, and repeatable QA checks.
Daily Financial Ledger & Automated Cash Flow Tracker
Short Overview / Summary
Custom Excel daily report template designed for small business revenue tracking, expense categorization, and cash reconciliation.
Roles & Tools
Roles: Bookkeeping, Financial Analysis, Data Entry
Tools: Microsoft Excel, Google Sheets
Project Description / Body (Case Study) Overview
Designed and built a clean, automated daily financial reporting sheet for tracking multi-channel sales, operational expenses, and physical stock counts in real time.
Key Features & Problem Solved:
Daily Reconciliation: Tracks opening cash balance, cash sales, bank deposits, credit transactions, and closing balance to eliminate missing funds.
Categorized Expense Tracking: Clear breakdown of daily operational costs (management allowances, labor, transport, and supplier payments).
Inventory & Post-Dated Tracking: Tracks opening and closing stock (Broiler/Layer units) and monitors post-dated cheques to maintain healthy cash flow visibility.
Clarity & Transparency: Structured layout that provides business owners with instant clarity on daily profit margins without complex software.
I used to think dashboards were just about making data look good.
The more I worked with data, the more I realized that's not the point.
A good dashboard should answer questions instantly.
• What's working?
• What needs attention?
• What should I do next?
If you still have to open five spreadsheets to find those answers, your data isn't really working for you.
That's the kind of problem I enjoy solving.
