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
Title: UrbanMart Retail — Complete Monthly Bookkeeping & Financial Reporting (Excel)
Description:
A full-cycle monthly bookkeeping package built in Excel for a fictional retail business, showcasing end-to-end accounting workflow from raw transactions to finished financial statements.
What's included:
* Chart of Accounts — structured account codes, types, and normal balances
* General Journal — 27+ dated transaction entries with debit/credit logic and memos
* General Ledger — auto-posting from the journal with running balances per account
* Trial Balance — pulled directly from the ledger, verified to balance to the cent
* Bank Reconciliation — deposits in transit, outstanding checks, adjusted balances tying out to $0 difference
* Income Statement — revenue, COGS, gross profit, and operating expenses
* Balance Sheet — assets, liabilities, and owner's equity, with a built-in check that Assets = Liabilities + Equity
* Statement of Cash Flows — indirect method, reconciling net income to ending cash
Every statement is fully linked with live formulas — no hardcoded numbers — so the workbook updates automatically as transactions change, and every total is traceable back to its source.
Skills demonstrated: double-entry bookkeeping, Excel formula design (cross-sheet references, IF logic), financial statement preparation, bank reconciliation, and accounting workflow documentation.
(Sample project — all figures are illustrative for demonstration purposes.)
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
Water, texture, and light, reframed as a moment of reflection. This piece was about finding rhythm in stillness letting color grading and sound carry the emotion instead of cuts.
I'm Victor Rodrigues, a video editor specialized in cinematic storytelling, color grading, sound design, and mood-driven visuals. I work with brands, creators, and agencies worldwide, turning raw footage into something people actually feel.
Currently open to new projects let's create something together. 🎬
📩 DM me or check the link in bio for more work.
#videoeditor #colorgrading #cinematicediting #filmmaker #contentcreator #editorforhire
Amazing shot! 🚀
📊 Interactive Sales Analytics Dashboard in Excel
I created an interactive Excel dashboard to analyze sales performance across different business dimensions.
Key Insights & Features:
• Total Orders, Sales & Profit KPIs
• Sales & Profit by Region
• Sales by City
• Category-wise Sales, Profit & Profit %
• Weekly Sales Analysis
• Interactive Slicers for Week, Category & Region
• Start Date & End Date tracking
• PivotTable-based analysis
This dashboard is designed to turn raw sales data into clear and actionable business insights using Excel.
Hello.
I guess we're in the same page about data analysis and visualization
Starter Tier Project
Project name (100 characters limit)
Starter E-Commerce Sales & Inventory Dashboard
