Freelancers using Microsoft Excel in PunjabFreelancers using Microsoft Excel in Punjab
ProjectsPeople
Shahid Iqbal's avatar
Shahid Iqbal
proBhakkar, Pakistan
AI Automation & Business Systems Expert | Make.com, Zapier
$5k+
Earned
4x
Hired
5.0
Rating
57
Followers
ANYTHING_EXPERT

Expert

AI Automation & Business Systems Expert | Make.com, Zapier
Cover image for Just finished an Employee Hour Tracker + Dashboard in Excel ...
Just finished an Employee Hour Tracker + Dashboard in Excel ⏱️📊 It tracks total hours, workers, contracts, margin, and total charge, plus top employees/contracts with clean visuals so managers can see everything in seconds ✅ If you need an Excel tracker like this (hours, payroll, invoices, KPIs), I can build a custom version for your business, fast and easy to use.
0
161
Cover image for Inventory Management System
Inventory Management System
1
56
Cover image for 📊 Just completed a Real Estate Tracker in Excel, built to h...
📊 Just completed a Real Estate Tracker in Excel, built to help agents and teams track deals, leads, and performance in one clean dashboard. It includes: 📈 Sales summary by agent 🧲 Lead tracking (weekly + pipeline stages) 🏠 Properties by buyer/rental/seller ✅ Tabs for business tracking, property supplies, closed transactions, and conveyancing flow If you need a custom Excel tracker for your real estate business (leads, listings, closings, commissions), message me, and I’ll build it around your workflow.
0
230
Cover image for 📊 Just built a Project Management Control Dashboard in Exce...
📊 Just built a Project Management Control Dashboard in Excel, a full command center to track project health in one place. It shows: ✅ Schedule, budget & resource health (visual dashboards) 📌 Task status (done / in progress / not started) ⚠️ Risks, issues, and action items with severity tracking 🔁 Change requests + pending decisions so nothing gets missed 📂 Clean tabs for control, schedule, budget, resources, risks, docs, and more If you want a custom Excel PM system for your team (easy to update + executive-ready reporting), message me, and I’ll build it for your workflow.
0
216
Microsoft Excel(4)
Ali Hassan's avatar
Ali Hassan
Rawalpindi, Pakistan
Transforming Data into Actionable Insights 🔍
Transforming Data into Actionable Insights 🔍
Cover image for SALES PREDICTION USING PYTHON
SALES PREDICTION USING PYTHON
0
235
Cover image for IRIS FLOWER CLASSIFICATION
IRIS FLOWER CLASSIFICATION
0
127
Cover image for Bikes Sales Analysis
Bikes Sales Analysis
0
248
Cover image for Titanic Analysis Project
Titanic Analysis Project
0
60
Microsoft Excel(6)
Mouaz Umer's avatar
Mouaz Umer
Lahore, Pakistan
CPA | Streamlining Your Finance |QuickBooks | XERO
CPA | Streamlining Your Finance |QuickBooks | XERO
Cover image for Streamlined Accounting Systems for Startups
Streamlined Accounting Systems for Startups
0
7
Cover image for Advanced Accounting and Bookkeeping Services for Businesses
Advanced Accounting and Bookkeeping Services for Businesses
0
7
Cover image for You will get CPA Accountant | Senior Bookkeeper | Tax Expert
You will get CPA Accountant | Senior Bookkeeper | Tax Expert
0
27
Placeholder project card media
View more →
Microsoft Excel(3)
Account Sphere's avatar
Account Sphere
Sialkot, Pakistan
Helping Businesses Grow Through Accounting
Helping Businesses Grow Through Accounting
Cover image for Title: Automatic Bookkeeping Workbook —
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
193
Cover image for Startup Financial Model — 3-Year
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
198
Cover image for Forward Sports (Pvt.) Ltd —
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
143
Cover image for Title: UrbanMart Retail — Complete
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
97
Microsoft Excel(5)
Haadi Hassan's avatar
Haadi Hassan
Lahore, Pakistan
Senior Accountant for US, UK & Australian Businesses
New to Contra
Senior Accountant for US, UK & Australian Businesses
Cover image for I performed a full QuickBooks
I performed a full QuickBooks Online cleanup, reconciliation, and month-end close for a US-based service business. The work included reviewing and correcting transaction classifications, cleaning up uncategorized and duplicate entries, reconciling bank and credit-card accounts, reviewing accounts receivable and payable, updating the chart of accounts, and recording accruals, prepayments, depreciation, and other adjusting journal entries. I also prepared monthly Profit and Loss, Balance Sheet, cash-flow, AR aging, AP aging, and budget-versus-actual reports. The completed cleanup gave management more reliable financial information, clearer visibility into cash flow and profitability, and a structured process for future monthly reporting. Sample data has been used to maintain confidentiality.
1
79
Cover image for I managed the complete monthly
I managed the complete monthly bookkeeping and month-end close process in Xero for Australian service-based businesses. The work included bank and credit-card reconciliations, accounts receivable and payable reviews, payroll and superannuation checks, accruals and prepayments, GST/BAS review, intercompany reconciliations, and investigation of outstanding or incorrectly classified transactions. I also prepared Profit and Loss, Balance Sheet, cash-flow reports, and management summaries to give clients clear visibility into profitability, cash position, receivables, payables, and compliance obligations. A structured close checklist was used to ensure accurate records, timely reporting, and completion of all month-end activities. Sample data has been used to maintain confidentiality.
0
58
Cover image for I managed a structured month-end
I managed a structured month-end close and balance-sheet reconciliation process to ensure the financial records were complete, accurate, and ready for management reporting. The work included bank and credit-card reconciliations, accounts receivable and payable reviews, accrual and prepayment entries, fixed-asset and depreciation updates, deferred-revenue analysis, intercompany reconciliations, and investigation of unusual general-ledger balances. These activities align with my experience directing close processes and maintaining supporting accounting schedules. I also maintained a reconciliation tracker to monitor account balances, supporting documents, unresolved differences, review status, ownership, and completion deadlines. This helped identify outstanding issues, strengthen financial controls, and support accurate and timely reporting. Sample data has been used to maintain confidentiality.
0
78
Cover image for I prepared a detailed budget-versus-actual
I prepared a detailed budget-versus-actual analysis to help management evaluate monthly and year-to-date financial performance against plan. The report compares actual results with budget across revenue, cost of sales, gross profit, operating expenses, EBITDA, and net profit. It calculates both value and percentage variances, identifies favorable and unfavorable movements, and explains the main drivers behind each significant variance. I also included trend analysis, visual summaries, management commentary, and recommended actions to support cost control, profitability improvement, and better financial decision-making. The model was designed as a reusable monthly reporting tool that can be updated after each accounting period is closed. Sample data has been used to maintain confidentiality.
0
75
Microsoft Excel(6)
Muhammad Aamir Subhani's avatar
Muhammad Aamir Subhani
Lahore, Pakistan
Precision-Driven Data Analyst & Assistant
Precision-Driven Data Analyst & Assistant
Cover image for Hospital Visit Summary & Records
Hospital Visit Summary & Records
0
6
Cover image for Purchase and Payment Track
Purchase and Payment Track
0
5
Cover image for Budget Summary
Budget Summary
0
4
Cover image for Real Estate Dashboard
Real Estate Dashboard
0
8
Microsoft Excel(4)