Data-Savvy CPA
With 10+ years in fund accounting and financial reporting across private equity, REITs, and multi-fund portfolios, I share advanced analytics and automation strategies that enhance daily routines—the very skills I wish I’d known when I began my career.
Understanding My Power BI Financial Analysis File (Before You Ask for It 😄)
Power BI for Financial Reporting and Analysis
Power BI for Financial Reporting and Analysis 2 min intro
Excel Print Capital Account Statement • DOUBLE INDEX MATCH • DATA VALIDATION • VBA
Build an Automated Employee Time Tracker in Excel (5) Automation & Study Tips
Build an Automated Employee Time Tracker in Excel (4) Alternative wayUNIQUE • FILTER • Array
Build an Automated Employee Time Tracker in Excel (3) UNIQUE • FILTER • SUMIFS • SUMPRODUCT • Array
Build an Automated Employee Time Tracker in Excel (2) TEXT • AND • MOD • Mathematical Operations
Build an Automated Employee Time Tracker in Excel (1) Python • UNIQUE • FILTER • CHOOSE
Fund Accounting & Financial Reporting Model
Fund Accounting and Financial Reporting 101 - 6. Model Structure, Reconciliation & Reporting
Fund Accounting and Financial Reporting 101 - 5. Booking Management Fees and Performance Fees
Fund Accounting and Financial Reporting 101 - 4. Booking Income, Expenses, Realized and Unrealized
Fund Accounting and Financial Reporting 101 - 3.3 Capital Distributions
Fund Accounting and Financial Reporting 101 - 3.2 Investment Entries
Fund Accounting and Financial Reporting 101 - 3.1 Capital Commitments, Unfunded Capital and Capital
Fund Accounting and Financial Reporting 101 - 2.3 Linking Journal Entries to Financial Statements
Fund Accounting and Financial Reporting 101 - 2.2.3 Business Operations - Loan Payment Schedule
Fund Accounting and Financial Reporting 101 - 2.2.2 Business Operations - Budget
Fund Accounting and Financial Reporting 101 - 2.2.1 Business Operations - Business Plan
Fund Accounting and Financial Reporting 101 - 2.1 Dashboard and Data
Fund Accounting and Financial Reporting 101 - 1.4 Career Opportunities
Fund Accounting and Financial Reporting 101 - 1.3 Fund Lifecycle, Legal Structures and Compliance
Fund Accounting and Financial Reporting 101 - 1.2 Understanding Private Equity Fund Structures
Fund Accounting and Financial Reporting 101 - 1.1 Exploring the World of Funds
Fund Accounting and Financial Reporting 101 - Intro
Automating tasks by Power BI, Power Automate and Power Apps.
Fund Compensation Mini-Course! - 16. Performance fee Soft Hurdle and HWM
Fund Compensation Mini-Course! - 15. Performance fee Hard Hurdle and HMW
Fund Compensation Mini-Course! - 14. Hurdle with No HWM