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

Modeling Journal-Entry Sequences in Production: Encoding the Chart of Accounts, Selecting a Baseline, and Handling the Close-Cycle Shift

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

The first-order Markov apparatus from First-Order Markov Modeling for Transaction-Stream Analysis in Audit worked cleanly on a 5-state synthetic dataset with 1,000 transitions and a known baseline. Production audit work breaks each of those assumptions. The chart of...

Same-Same-Different in Excel: Detecting Identical-Value-Different-Date Patterns Across Vendor Files

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

Duplicate disbursements erode 0.8–1.1% of organizational spending annually (ACFE, Report to the Nations, 2024 ed., p. 47). Excel’s COUNTIFS function detects these control failures through systematic pairwise comparison: records matching on vendor and invoice...

First-Order Markov Modeling for Transaction-Stream Analysis in Audit

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

Financial-statement auditors and DD analysts work with sequences: journal-entry posting streams, period-over-period account-reconciliation states, customer-vendor transaction chains, adjusting-entry timing through close. The standard analytical toolkit — descriptive...

Benford’s Law in Excel: Setting Up the First-Digit Test for Mass-Transaction Screening

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

The first-digit distribution of naturally occurring numerical populations follows a logarithmic pattern. Auditors leverage this pattern to screen transaction datasets for anomalies. The implementation requires precise Excel formulas, statistical validation, and...
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.