Title: Automatic Bookkeeping Workbook — Single-Entry Journal to Full Financial Statements Description: A lightweight, fully automated Excel bookkeeping template built around one core idea: type a transaction once, and every downstream report updates itself. Unlike a full client engagement model, this is designed as a clean, reusable template — enter journal entries as balanced debit/credit lines on the one editable sheet, and the workbook handles the rest automatically: 1.One input sheet: Journal Entries is the only tab you type in — pick accounts from a dropdown, enter debit or credit amounts, and a built-in check column flags instantly if a line doesn't balance 2.Automated General Ledger: every account's full transaction history and running balance, generated without a single manual formula 3.Trial Balance with a live balance check 4.Financial statements: Income Statement, Balance Sheet (with automatic balance verification), and a direct-method Cash Flow Statement — all driven off a Cash Flow Category tag on cash transactions 5.Dashboard: auto-generated KPI snapshot (Total Assets, Liabilities, Equity, Net Income, Ending Cash) plus Revenue vs. Expenses and Operating Expense Mix charts 6.Color-coded design: blue for inputs, black for same-sheet formulas, green for cross-sheet links, grey for automated helper columns — so anyone opening the file immediately understands what's safe to edit Built to show that solid double-entry bookkeeping logic can be made genuinely foolproof for a non-accountant user — no VBA, no macros, just clean formula architecture. Skills demonstrated: Excel automation · Double-entry bookkeeping · Template design · Data validation · Financial statement preparation · Dashboard & chart design

1

157

Startup Financial Model — 3-Year Excel Model for Early-Stage Businesses A complete, investor-ready financial model built for newly established businesses, delivered as a fully dynamic Excel workbook (9 linked tabs, 685+ live formulas, zero hardcoded outputs). What's included: 1.Startup Costs — itemized pre-launch capital requirements with contingency buffer 2.Revenue Build — multi-stream revenue modeling with monthly detail for Year 1 and 3-year projections 3.Operating Expenses — fully categorized cost structure with annual escalation 4.Break-Even Analysis — automated contribution margin, break-even point, and margin of safety, with a visual chart 5.3-Year P&L Forecast — full income statement from revenue down to net income, monthly + annual 6.Cash Flow & Cash Requirement — monthly runway analysis with receivables/payables timing, pinpointing exactly when and how much additional cash is needed 7.Funding Requirement — Sources & Uses summary that ties out automatically, producing a clear capital ask Why it stands out: Every number is a live formula, not a static output — change one assumption and the entire model (break-even, forecast, cash runway, funding ask) recalculates instantly Color-coded inputs (blue), formulas (black), and cross-sheet links (green) so any user can navigate and edit safely Built to professional modeling standards — clean formatting, documented assumptions, verified formula integrity Ideal for: founders raising a pre-seed/seed round, small business owners applying for a loan, or accelerator/incubator applicants who need a credible, lender/investor-facing financial model fast.

1

159

Forward Sports (Pvt.) Ltd — Dynamic 5-Year Three-Statement Financial Model A fully-linked, scenario-driven financial model built in Excel for Forward Sports (Pvt.) Ltd, a Sialkot, Pakistan–based sporting goods manufacturer and exporter — forecasting FY2026–FY2030 off a FY2025 actual base year. Scope of work: 1.Scenario-Driven Assumptions — built a live scenario switch (Base / Upside / Downside) driving revenue growth (3%–13%) and COGS as a % of revenue (59%–64%) through OFFSET + MATCH formulas, so the entire model recalculates from a single dropdown input 2.Operating Expense Build-Up — modeled SG&A, R&D, and Marketing as % of revenue over the forecast period, feeding directly into the income statement 3.Income Statement — fully linked 6-year P&L (2025A–2030F) from revenue through COGS, gross profit, operating expenses, and net income, all formula-driven off the assumptions tab 4.Balance Sheet — dynamic 5-year balance sheet with automatic balance checks tying back to the income statement and cash flow 5.Cash Flow Statement — indirect-method cash flow statement (CFO/CFI/CFF), reconciling net income to the change in cash and linking to the Balance Sheet 6.Ratios & Summary — a KPI panel with margin, efficiency, and return ratios, plus SUMIFS-based period totals for revenue, net income, and marketing spend 7.Dashboard — a forecast-summary dashboard with a scenario selector and revenue/net income/EBITDA-margin charts (Base case: ~19% EBITDA margin through the forecast, Net Income growing from ~$5.0M to $5.8M FY2026F–FY2028F) Why it matters: Every figure flows from a single set of assumptions — change the active scenario and the entire model, from the P&L down to the dashboard chart, updates automatically. Nothing is hardcoded, which is exactly what makes it defensible in front of a client or professor. Skills demonstrated: Financial modeling · Three-statement integration · Scenario/sensitivity analysis · Advanced Excel (OFFSET, MATCH, SUMIFS, dynamic named ranges) · Dashboard design · Forecasting

1

112

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.)

0

72

Account Sphere

Helping Businesses Grow Through Accounting