#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

#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

Pipeline Archetype: Deterministic Multi-Way Matcher & Assertion Rules

Continuous algorithmic 3-way matching and license-to-login assertions replace end-of-quarter panic true-ups.

Spreadsheet Failure (Before)Manual Slog

Manual Data Flow Trap

1Paste

Export Pasted

Wire-approval rows are pasted into the control matrix.

2Stale

Matrix Ages

A later release is not in the last paste.

3Cleared

Untested Clear

The wire releases while the control still shows confirmed.

Root Operational Bottleneck

Treasury control tests are confirmed in a matrix workbook that is refreshed from a wire-approval export, so a release can clear after the matrix was last pasted.

Control Hazard & Audit Exposure

Wire releases pass a stale control matrix that was never tested against live approvals, so an untested control still shows as confirmed.

Deterministic Replacement (After)Golden Door Standard

Target Software Architecture

Treasury Control-Test Engine that Blocks Wires When the Matrix Misses a Live Approval

Deterministic Pipeline Execution

1Live

Approval Feed

Live wire approvals stream into the test engine.

2Tested

Matrix Test

Each required control is sampled against that path.

3Blocked

Release Block

A missing current-period test blocks the wire.

Software Pattern

Treasury control-test engine that samples live wire approvals against the matrix and blocks release when a required control has no current-period test.

Continuous Assertion Rule

Matrix assertion: a treasury wire cannot release unless every required control on the matrix has a current-period test result tied to that approval path.

Map this tell

#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 confirmation of treasury control tests in Excel

Close still runs on a spreadsheet.

Spreadsheet problems · 157 operational tells

Forensic Contrast: Manual confirmation of treasury control tests in Excel

#	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
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
Problem #127APQC PCF 9.7.1.7Treasury Operations Forensic Contrast: Manual confirmation of treasury control tests in Excel Where fragile workbook transcription creates operational hazards, versus deterministic software control. Map this tell Pipeline Archetype: Deterministic Multi-Way Matcher & Assertion Rules Continuous algorithmic 3-way matching and license-to-login assertions replace end-of-quarter panic true-ups. The Spreadsheet Failure (Before)Manual Slog CEO / CFO Operational Tell “Wire releases pass a stale control matrix that was never tested against live approvals” Manual Data Flow Trap 1Paste Export Pasted Wire-approval rows are pasted into the control matrix. 2Stale Matrix Ages A later release is not in the last paste. 3Cleared Untested Clear The wire releases while the control still shows confirmed. Root Operational Bottleneck Treasury control tests are confirmed in a matrix workbook that is refreshed from a wire-approval export, so a release can clear after the matrix was last pasted. Control Hazard & Audit Exposure Wire releases pass a stale control matrix that was never tested against live approvals, so an untested control still shows as confirmed. Manifests in: Treasury control-matrix workbook and wire-approval export Deterministic Replacement (After)Golden Door Standard Target Software Architecture Treasury Control-Test Engine that Blocks Wires When the Matrix Misses a Live Approval Deterministic Pipeline Execution 1Live Approval Feed Live wire approvals stream into the test engine. 2Tested Matrix Test Each required control is sampled against that path. 3Blocked Release Block A missing current-period test blocks the wire. Deterministic Software Pattern Treasury control-test engine that samples live wire approvals against the matrix and blocks release when a required control has no current-period test. Continuous Assertion Rule Matrix assertion: a treasury wire cannot release unless every required control on the matrix has a current-period test result tied to that approval path. 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
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