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
I set up the general journal for a small business for the month ended February 28, 2026. I entered the opening balances and recorded the owner's capital contributions, so the books started from a clean, balanced position.
Scope of work:
Recorded the opening balance across all account types: cash, receivables, inventory, furniture, computer equipment, vehicle, accumulated depreciation, payables, short- and long-term loans, and owner's equity
Confirmed the opening entry balances (total assets of 180,500 equal total liabilities and equity)
Recorded additional cash introduced by the owner as capital
Recorded non-cash contributions, including computer equipment and inventory transferred into the business
Added a clear reference note to every entry, so each transaction can be traced and audited
Result
The business had a documented starting point and a clear record of how the owner funded it. The journal was ready to post to the ledger and to feed the trial balance, P&L, and balance sheet.
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
Crystal Homes: Real Estate Sales and Rental Analytics Dashboard
End-to-end analytics project for a fictional Nigerian real estate agency. Raw data from Google Sheets went into MySQL, where I built 21 SQL views, then into a 4-page Power BI dashboard covering sales performance, active rental income, lease expiry tracking, portfolio health, and agent/branch performance. It surfaced findings like ₦468M in tracked revenue and cross-branch sales attribution.
Tools: MySQL, Power BI, SQL, Google Sheets
Year-end giving season is about 90 days out — and for most nonprofits, it's when close to a third of annual donations come in, in the space of a few weeks.
That's not the moment to discover your restricted fund tracking is off, or that your board can't get a clean report on short notice. September is when that gets fixed, not December.
If your books aren't ready to handle the year-end push yet, now's the window to close that gap.
BEFORE: Client had messy Excel inventory with 500 rows, duplicates (A12 / a12), blanks, wrong prices like "$ 2.5" and "N/A", and different warehouse names (KER / ker / Kericho).
AFTER: I did:
Removed 12 duplicate SKUs
Standardized item names to Title Case
Fixed QTY and Prices to 2 decimals
Unified Warehouse to Kericho
Made sheet ready for pivot dashboard
Result: Clean, ready-to-use inventory in 2 days using Excel.
Tools: Excel, Remove Duplicates, Text to Columns, TRIM, PROPER
