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
Prepared a complete Balance Sheet for Blue Horizon Traders — a trading business. Included Current Assets, Fixed Assets, Current Liabilities, and Owner's Equity sections. Delivered in Excel format with IFRS based professional presentation
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 it?
Contra University
Learn from expert creatives how to earn more using next-gen AI tools.
Brand Design
The best brand designers are on Contra. Scroll to see what's trending in brand design. What are you building?
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
Finance Dashboard | Cash Flow & Profit Analysis
Project Overview
A comprehensive financial analytics dashboard built in Power BI to track cash flow, revenue generation, net profitability, and cost distribution. It provides decision-makers with clear visibility into corporate financial health and expense drivers.
Key Highlights & Features
Executive Summary (KPIs): High-level metrics tracking Total Revenue ($3.8M), Total Expenses ($2.1M), Net Profit ($1.7M), and Net Cash Flow ($890K) with year-over-year (YoY) comparison.
Monthly Revenue vs. Expense: Visual comparison of monthly income against operational expenditures to monitor cash dynamic stability.
Profit Margin (%) Trend: Tracks percentage margin fluctuations over time (averaging between 41% to 44%).
Expense Breakdown & Top Costs: Detailed table and chart categorizing operational expenses—highlighting Salaries ($800K | 38.1%), Marketing ($420K | 20.0%), and Rent ($300K | 14.3%).
Cash Flow Trend: Continuous monitoring of net liquidity movement across the months.
Tools & Technologies
Power BI (Financial Modeling & DAX)
Financial Analytics & Cash Flow Management
Data Visualization & Reporting
We created the visual identity and UI/UX for Traydex, a concept built around giving traders a clearer, more engaging way to view their performance.
Instead of presenting numbers in a traditional dashboard, we introduced modular trader cards that showcase key metrics in a clean, personalized format. Paired with a bold dark theme, vibrant accents, and a polished interface, the experience feels modern while keeping the focus on the data that matters most.
A concept that explores how thoughtful design can make financial information more accessible, intuitive, and enjoyable to interact with.
I rebuilt a real UK charity's books from scratch in Xero.
Narthex Sparkhill — a Birmingham-based charity running 7 community programmes including a Foodbank, Advice Centre, and Domestic Violence Support service.
Starting point: zero entries in a blank Xero organisation.
End point: a fully balanced set of accounts reconciled to within 0.3% of their real filed figures.
What went into it:
✦ 30-account Chart of Accounts built on UK Charities SORP framework
✦ Restricted vs. Unrestricted Fund tracking — a legal requirement for UK charities
✦ 31 contacts (real UK funders: National Lottery Community Fund, Comic Relief, Birmingham City Council)
✦ 7 Programme Tracking Categories for per-service reporting
✦ 215 bank transactions — imported and cash coded in bulk
✦ Full invoice-to-payment cycle for the Birmingham City Council grant
✦ Year-end depreciation journal: £9,921 (exact figure from real filed accounts)
Final P&L: £908,800 income vs. £911,700 real filed — 0.3% variance.
Balance Sheet: fully balanced to the penny.
This is the level of detail nonprofit boards actually need.
If your charity, NGO or nonprofit needs accurate, programme-level financial reporting — I'd love to talk.
