Bookkeeping Projects in SialkotBookkeeping Projects in SialkotTitle: 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 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 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.) 
