Accounting Projects in PunjabAccounting Projects in PunjabChartered Accountant (ICAP) with 8+ years of progressive experience leading finance functions for organizations with annual revenues of up to PKR 4 Billion. Proven expertise in financial reporting, bookkeeping, ERP implementation, trade finance, payroll administration for 1,750 employees, IFRS compliance, and international accounting support for UAE and Canadian businesses. Recognized for resolving a PKR 500 Million legacy receivables reconciliation by identifying historical discrepancies, recovering missing invoices, and eliminating unreconciled balances. Highly proficient in QuickBooks Online, Xero, Zoho Books, Oracle, SAP, Microsoft Dynamics 365, and Advanced Excel. Zenith Industries — Integrated Three-Statement Financial Model:
Built a fully integrated, formula-driven financial model for Zenith Industries in Excel, designed so that changes to transactions, assumptions, or accounting entries automatically flow through the entire model.
The model connects the complete accounting and financial reporting process, with complex formulas and linked schedules ensuring that the financial statements update dynamically whenever the underlying inputs are changed.
Key Features:
*Structured Chart of Accounts
*Automated Journal Entries
*Formula-driven General Ledger
*Automated Trial Balance
*Integrated Income Statement
*Integrated Balance Sheet
*Integrated Cash Flow Statement
*Dynamic financial assumptions
*Interactive financial dashboard
*Cross-linked statements with automatic updates
*Built-in formulas and accounting logic to maintain consistency across the model
What makes this model different?
The model is dynamic rather than static. Changing an entry at the source automatically updates the relevant accounts, ledgers, trial balance, and financial statements. This creates a connected financial system that can be used for financial analysis, forecasting, scenario testing, and decision-making.
This project demonstrates advanced Excel financial modeling, accounting integration, formula development, and automation. 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. 
