In-house interest-rate sheet and intercompany fee calendar — "Intercompany interest posts from a stale rate tab that missed the policy effective date"
Why the manual spreadsheet breaks financial controls and how a deterministic workflow replaces it.
In-house bank interest and fees are computed from a rate tab that is edited when policy changes, so a value date can still use the prior rate if the tab was not refreshed.
Intercompany interest posts from a stale rate tab that missed the policy effective date, so counterparties book different interest on the same house balance.
In-house interest engine that applies the policy rate in force on the value date and posts paired entity entries from that single rate table.
Rate assertion: an in-house interest or fee posting must cite the policy rate version effective on the value date, or it cannot post.
Three-stage comparison between manual workbook reconciliation and automated rule-based execution.
In-house interest is computed from a rate sheet that lags policy.
Intercompany interest posts from a stale rate tab that missed the policy effective date.
Paired entries post from the rate in force on the value date.
An in-house interest or fee posting must cite the policy rate version effective on the value date.
Adjacent spreadsheet failure modes in the same APQC Category 9 process group.
In-house bank balance sheet and subsidiary cash export
Central receipts sheet and subsidiary open-invoice export
House-statement workbook and subsidiary cash export
Scope the replacement architecture for manual calculation of in-house bank interest and fees or combine multiple failure modes in the directory.
