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 Ahmad Traders as at 30 June 2026. Included Current Assets, Fixed Assets, Current Liabilities, and Owner's Equity sections. Delivered in professional Excel format.
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
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.
Google Sheets Automation with Apps Script | Workflow & Reporting
Description
Built a complete Google Sheets automation system using Google Apps Script to eliminate repetitive manual tasks and improve business efficiency.
Key Features
✅ Automated data import from Google Forms, CSV files, and APIs
✅ Data cleaning, validation, and transformation
✅ Auto-generated reports and Pivot Tables
✅ Email notifications and scheduled reports
✅ Google Drive backup and file management
✅ Dashboard with real-time KPIs and performance tracking
✅ Automated workflows using Google Apps Script
Tools Used
Google Sheets
Google Apps Script
Google Forms
Google Drive
Gmail API
Google Calendar
Outcome
Reduced manual work by up to 90%, improved data accuracy, and saved significant time through fully automated workflows.
