#121Taxes Management

Map this tell

Manual consolidation of the global income-tax plan

Where It Shows Up: Linked jurisdiction tax-plan workbooks and provision bridge

“The consolidated tax plan does not equal the sum of jurisdiction packs at provision lock”

Tax-Plan Consolidation Engine & Jurisdiction Bridge

#122Revenue Accounting

Map this tell

Manual tracking of ASC 606 variable-consideration adjustments

Where It Shows Up: Contract-adjustment policy sheet and deferred-revenue waterfall

“Concession and rebate adjustments are applied after revenue posts from a side policy tab”

Variable-Consideration Policy Engine & Schedule Rev

#123Revenue Accounting

Map this tell

Manual logging of customer revenue concession emails

Where It Shows Up: Concession email folder and deferred-revenue override sheet

“Negotiated concessions patch the waterfall without a contract-modification version”

Concession Case Manager & Contract-Mod Versioning

#124Planning & FP&A

Map this tell

Manual calculation of standalone selling prices for new SKUs

Where It Shows Up: New-product SSP workbook and ASC 606 allocation model

“New SKUs inherit a blended SSP so performance obligations allocate to the wrong amounts”

New-SKU SSP Registry & Allocation Assertion

#125Internal Controls

Map this tell

Manual assignment of SOX control owners in a RACI sheet

Where It Shows Up: Control-owner RACI workbook and SoD conflict log

“Control tests run under last quarter's owner after the role changed in HR”

Control-Owner Registry & SoD Conflict Gate

Pipeline Archetype: Entity Graph & Golden Record Master Registry

Relational entity graphs with automated deduplication and tax ID validation replace fractured departmental vendor sheets.

Spreadsheet Failure (Before)Manual Slog

Manual Data Flow Trap

1Typed

RACI Typed

Owners are assigned in a control RACI workbook.

2Stale Owner

Role Changes

HR moves the person; the RACI still names last quarter.

3Wrong Name

Wrong Tester

The evidence pack names someone who no longer holds the control.

Root Operational Bottleneck

SOX control owners are assigned in a RACI workbook that is not synced to HR roles or the SoD map, so a test still names last quarter's owner after the job changed.

Control Hazard & Audit Exposure

Control tests run under last quarter's owner after the role changed in HR, so the evidence pack names a person who no longer holds the control.

Deterministic Replacement (After)Golden Door Standard

Target Software Architecture

Control-Owner Registry that Blocks Tests When the RACI Drifts from the SoD Map

Deterministic Pipeline Execution

1Synced

HR Event

A role change updates the control-owner registry.

2Matched

SoD Test

The registry is compared to the live SoD map.

3Blocked

Start Block

A drifted owner blocks the test from opening.

Software Pattern

Control-owner registry that reads HR role changes and blocks a test from starting when the RACI owner is not the current SoD assignee.

Continuous Assertion Rule

Owner assertion: a control test cannot start unless the RACI owner equals the current HR assignee on the SoD map for that control and period.

Map this tell

#126Internal Controls

Map this tell

Manual assembly of the quarterly SOX management report

Where It Shows Up: Internal SOX dashboard pack and control-log screenshot folder

“Management receives a rebuilt control dashboard that does not match the live control log”

Live Control-Log Report & Management Pack Gate

#127Treasury Operations

Map this tell

Manual confirmation of treasury control tests in Excel

Where It Shows Up: Treasury control-matrix workbook and wire-approval export

“Wire releases pass a stale control matrix that was never tested against live approvals”

Treasury Control-Test Engine & Wire-Release Gate

#128Treasury Operations

Map this tell

Manual tracking of in-house bank balances by subsidiary

Where It Shows Up: In-house bank balance sheet and subsidiary cash export

“Subsidiary in-house balances disagree with the cash ledger after a missed paste”

In-House Bank Ledger & Subsidiary Balance Sync

#129Treasury Operations

Map this tell

Manual calculation of in-house bank interest and fees

Where It Shows Up: In-house interest-rate sheet and intercompany fee calendar

“Intercompany interest posts from a stale rate tab that missed the policy effective date”

In-House Interest Engine & Policy-Rate Posting

#130Treasury Operations

Map this tell

Manual booking of hedge trades from a treasury blotter

Where It Shows Up: Hedge blotter workbook and dealer-confirmation email folder

“Hedge trades hit the register after the fill because the blotter was typed from the confirm”

Hedge Execution Gateway & Confirmation Match

Close still runs on a spreadsheet.

Spreadsheet problems · 157 operational tells

Forensic Contrast: Manual assignment of SOX control owners in a RACI sheet

Close still runs on a spreadsheet.

Spreadsheet problems · 157 operational tells

Forensic Contrast: Manual assignment of SOX control owners in a RACI sheet

#	Spreadsheet Problem	Where It Shows Up	CEO / CFO Tell	Software Architecture	Action
121	PCF 9.9.1.2 · Taxes Management	Linked jurisdiction tax-plan workbooks and provision bridge	“The consolidated tax plan does not equal the sum of jurisdiction packs at provision lock”	Tax-Plan Consolidation Engine & Jurisdiction Bridge	Map this tell
122	PCF 9.2.5.1 · Revenue Accounting	Contract-adjustment policy sheet and deferred-revenue waterfall	“Concession and rebate adjustments are applied after revenue posts from a side policy tab”	Variable-Consideration Policy Engine & Schedule Rev	Map this tell
123	PCF 9.2.5.3 · Revenue Accounting	Concession email folder and deferred-revenue override sheet	“Negotiated concessions patch the waterfall without a contract-modification version”	Concession Case Manager & Contract-Mod Versioning	Map this tell
124	PCF 9.1.5.2 · Planning & FP&A	New-product SSP workbook and ASC 606 allocation model	“New SKUs inherit a blended SSP so performance obligations allocate to the wrong amounts”	New-SKU SSP Registry & Allocation Assertion	Map this tell
125	PCF 9.8.1.3 · Internal Controls	Control-owner RACI workbook and SoD conflict log	“Control tests run under last quarter's owner after the role changed in HR”	Control-Owner Registry & SoD Conflict Gate	Map this tell
Problem #125APQC PCF 9.8.1.3Internal Controls Forensic Contrast: Manual assignment of SOX control owners in a RACI sheet Where fragile workbook transcription creates operational hazards, versus deterministic software control. Map this tell Pipeline Archetype: Entity Graph & Golden Record Master Registry Relational entity graphs with automated deduplication and tax ID validation replace fractured departmental vendor sheets. The Spreadsheet Failure (Before)Manual Slog CEO / CFO Operational Tell “Control tests run under last quarter's owner after the role changed in HR” Manual Data Flow Trap 1Typed RACI Typed Owners are assigned in a control RACI workbook. 2Stale Owner Role Changes HR moves the person; the RACI still names last quarter. 3Wrong Name Wrong Tester The evidence pack names someone who no longer holds the control. Root Operational Bottleneck SOX control owners are assigned in a RACI workbook that is not synced to HR roles or the SoD map, so a test still names last quarter's owner after the job changed. Control Hazard & Audit Exposure Control tests run under last quarter's owner after the role changed in HR, so the evidence pack names a person who no longer holds the control. Manifests in: Control-owner RACI workbook and SoD conflict log Deterministic Replacement (After)Golden Door Standard Target Software Architecture Control-Owner Registry that Blocks Tests When the RACI Drifts from the SoD Map Deterministic Pipeline Execution 1Synced HR Event A role change updates the control-owner registry. 2Matched SoD Test The registry is compared to the live SoD map. 3Blocked Start Block A drifted owner blocks the test from opening. Deterministic Software Pattern Control-owner registry that reads HR role changes and blocks a test from starting when the RACI owner is not the current SoD assignee. Continuous Assertion Rule Owner assertion: a control test cannot start unless the RACI owner equals the current HR assignee on the SoD map for that control and period. Audit Outcome: Immutable Trail · Continuous Balance Diagnostic Handoff: Clicking Map opens our confidential 3-question Workflow Advisory with this exact problem pre-populated. Map this tell
126	PCF 9.8.3.4 · Internal Controls	Internal SOX dashboard pack and control-log screenshot folder	“Management receives a rebuilt control dashboard that does not match the live control log”	Live Control-Log Report & Management Pack Gate	Map this tell
127	PCF 9.7.1.7 · Treasury Operations	Treasury control-matrix workbook and wire-approval export	“Wire releases pass a stale control matrix that was never tested against live approvals”	Treasury Control-Test Engine & Wire-Release Gate	Map this tell
128	PCF 9.7.3.1 · Treasury Operations	In-house bank balance sheet and subsidiary cash export	“Subsidiary in-house balances disagree with the cash ledger after a missed paste”	In-House Bank Ledger & Subsidiary Balance Sync	Map this tell
129	PCF 9.7.3.6 · Treasury Operations	In-house interest-rate sheet and intercompany fee calendar	“Intercompany interest posts from a stale rate tab that missed the policy effective date”	In-House Interest Engine & Policy-Rate Posting	Map this tell
130	PCF 9.7.5.5 · Treasury Operations	Hedge blotter workbook and dealer-confirmation email folder	“Hedge trades hit the register after the fill because the blotter was typed from the confirm”	Hedge Execution Gateway & Confirmation Match	Map this tell