Title: UrbanMart Retail — Complete Monthly Bookkeeping & Financial Reporting (Excel) Description:...Title: UrbanMart Retail — Complete Monthly Bookkeeping & Financial Reporting (Excel) Description:...
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
Account's avatar
Account Sphere
• 1d
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.)
BookkeepingMicrosoft ExcelFinancial AnalysisVideo EditingFFmpeg
Back to feed
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