Sheepdog Prosperity Partners
Due Diligence
  • Home
  • Services
  • Process
  • About
  • Contact

Random-Walk and Stationarity Tests on Account Reconciliations

by Noah Green CPA CFE | Apr 9, 2026 | DD Tech Lab

A reconciliation account that should oscillate around its expected balance—intercompany clearing, suspense, accrued-payroll roll-forward—but instead wanders without bound has failed its control objective. The variance grows linearly with time; the account cannot...

OSINT for Financial Fraud in Excel: Integrating Public-Source Verification Into the Workpaper Workflow

by Noah Green CPA CFE | Apr 6, 2026 | DD Tech Lab

Vendor validation at engagement scale breaks when each lookup requires manual browser navigation. The auditor opens OpenCorporates, searches the vendor name, copies registration status, switches to EDGAR, runs full-text search, copies filing presence, opens PACER,...

Markov Mixture Models for Round-Tripping and Lapping Detection

by Noah Green CPA CFE | Apr 2, 2026 | DD Tech Lab

Round-tripping and lapping share a structural feature that breaks both First-Order Markov Modeling for Transaction-Stream Analysis in Audit’s first-order Markov framework and Hidden Markov Models for Earnings-Management Regime Detection in Public-Company...

Geospatial Address Mapping in Excel: Vendor-Employee Address Overlap and Risk Clustering

by Noah Green CPA CFE | Mar 30, 2026 | DD Tech Lab

The vendor-employee address-overlap test addresses a specific control objective under ACFE Fraud Examiners Manual §3.5.2 and PCAOB AS 2401.A5: detecting unauthorized payments routed through fictitious vendors controlled by responsible parties. The operational form of...

Hidden Markov Models for Earnings-Management Regime Detection in Public-Company Financials

by Noah Green CPA CFE | Mar 26, 2026 | DD Tech Lab

The first-order Markov framework from First-Order Markov Modeling for Transaction-Stream Analysis in Audit assumes the auditor can observe the state directly — an account class touched by a journal entry, a reconciliation status, a transaction counterparty. For...

Linear Regression for Outlier Detection in Excel: Building the Standardized-Residual Workpaper for Expense-Account Analytics

by Noah Green CPA CFE | Mar 23, 2026 | DD Tech Lab

When utility costs scale with square footage, sales commissions track revenue, or freight charges follow tonnage shipped, the auditor needs more than ratio analysis to spot anomalies. PCAOB AS 2305.15 explicitly endorses detailed expectations over broad comparisons:...
« Older Entries
Next Entries »

Recent Posts

  • What I Learned from Conduit Finance
  • The Diligence Triangle
  • Neo4j Aura vs Self-Hosted vs Alternative Graph Databases: Architecture Choices for the Mid-Size DD Practice
  • Loading and Maintaining Production-Scale DD Graphs: APOC Procedures, Bulk Loading, Index Strategy, and Memory Tuning
  • Graph-Based Wash-Sale and Layering Detection in Securities Transactions

Recent Comments

No comments to show.

Sheepdog Prosperity Partners LLC

5940 S Rainbow Blvd, Ste 400 PMB 855226
Las Vegas, NV 89118-2507

Contact

888-533-3495
noah@noahgreencpa.com

Schedule

Discovery Call

Veteran-owned and operated.



© 2026 Sheepdog Prosperity Partners LLC

Information on this site is general. A CPA-client engagement begins only with a signed Master Services Agreement and per-matter Statement of Work. Pre-engagement notice.