Corporate Income Tax Provision (ASC 740), ASU 2023-09 Rate Bridge & FIN 48 UTP Schedule — Calculator, Excel Workpaper & API (BI-63)
Evaluates FASB ASU 2023-09 (ASC 740-10-50-12) Disaggregated ETR Reconciliation; FASB ASC 740-10-30-16 Valuation Allowance & 3-Year Cumulative Loss Gate; FASB ASC 740-10-25-6 (FIN 48) & Schedule UTP >50% Measurement Rule; 26 U.S.C. Secs. 951A & 250 GILTI Inclusion & 80% Foreign Tax Credit Haircut. Submit: Pre Tax Book Income, Utp Mltn Prob. Excel Tabs: Summary Budget Bridge, ASU2023 09 ETR Rate Bridge, Temp Diff DTA DTL Rollfwd, Valuation Allowance Weight. Calibrated across all 57 US States, Washington, D.C., US Territories, and Federal IRC § 11 baselines in sub-millisecond deterministic Python & NumPy CPU execution.
Official Statutory & Regulatory Workpaper Title: FASB ASC 740-10 Current/Deferred Provision, Valuation Allowance & IRS Schedule UTP (FIN 48) Workpaper
Official Agency Form / Workpaper Standard: FASB ASC 740-10 (ASU 2023-09 ETR Footnote) & IRS Form 1120 Schedule UTP
Governing Accounting, Tax & Statutory Authorities: FASB ASC 740-10 (Income Taxes & FIN 48 UTPs); FASB ASU 2023-09 (Rate Reconciliation Disclosures); IRC §§ 163(j), 174, 382 & 951A
Common Practitioner & Search Aliases: ASC 740 Tax Provision Calculator, ASU 2023-09 Effective Tax Rate Bridge, Deferred Tax Asset Valuation Allowance, FIN 48 Uncertain Tax Position Reserve, GILTI Section 250 Tax Provision
Interactive Corporate Income Tax Provision (ASC 740), ASU 2023-09 Rate Bridge & FIN 48 UTP Schedule Calculator (BI-63)
Enter your trial-balance, schedule, or contract numbers below to verify headline statutory outputs in real time across 57 US jurisdictions (zero data stored).
Optional: Paste Advanced Custom Schedule / Array Overrides (JSON)
Computed Headline Statutory & Financial KPIs
Download 5-Tab Formula-Linked Excel Workpaper (.xlsx) — $19.00
Includes 5 formatted CPA/analyst tabs compiled from your exact inputs: 01_Executive_Summary, 02_Statutory_Rules (4 rules), 03_Workpaper_Schedule (5 rows + =SUM/=AVERAGE formulas), 04_Scenario_Sensitivity (=C-B variance formulas), and 05_Compliance_Audit_Flags (3 threshold gates).
1. Deterministic Statutory & Regulatory Laws Executed
Unlike prompt-only LLM skills that approximate multi-period schedules in token space, BI-63 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) FASB ASU 2023-09 (ASC 740-10-50-12) Disaggregated ETR Reconciliation [FASB ASC 740-10 & ASU 2023-09 Disaggregated Rate Reconciliation]
- (2) FASB ASC 740-10-30-16 Valuation Allowance & 3-Year Cumulative Loss Gate [FASB ASC 740-10-30-16 to 30-24 Valuation Allowance Rules]
- (3) FASB ASC 740-10-25-6 (FIN 48) & Schedule UTP >50% Measurement Rule [FASB ASC 740-10-25-6 (FIN 48) & IRS Form 1120 Schedule UTP]
- (4) 26 U.S.C. Secs. 951A & 250 GILTI Inclusion & 80% Foreign Tax Credit Haircut [26 U.S.C. Secs. 951A, 250, 960(d) & FASB ASC 740-10]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | Consolidated & Entity-Level Year-End GAAP Trial Balance plus Book-to-Tax M-1 / M-3 Reconciliations | Structured JSON object/array or CSV text |
FILE-2 | Prior 3 Years of Signed Federal, Multi-State & Foreign Income Tax Returns plus Prior Provision Binder | Structured JSON object/array or CSV text |
FILE-3 | State Apportionment Workpapers, Tax Fixed-Asset Register, IRC § 174 R&D & Equity Cap-Table History | Structured JSON object/array or CSV text |
FILE-4 | Open Tax Examination Correspondence, R&D Credit Studies, Transfer-Pricing Reports & Prior UTP Rollforward | Structured JSON object/array or CSV text |
Deterministic Output Workpaper Schedules
| Workpaper Schedule | Computed Output Schedule & Tie-Out |
|---|---|
| Schedule 1 | 01 Summary Budget Bridge |
| Schedule 2 | 02 ASU2023 09 ETR Rate Bridge |
| Schedule 3 | 03 Temp Diff DTA DTL Rollfwd |
| Schedule 4 | 04 Valuation Allowance Weight |
| Schedule 5 | 05 FIN48 UTP Cumulative Prob |
| Schedule 6 | 06 State Apportion GILTI Opt |
3. Quick Integration — REST API (cURL) & AI Agent MCP
A. Direct HTTP / REST API Call
curl -X POST "https://quantledger-73-engine-financial-and-statutory-api.p.rapidapi.com/v1/gaap/asc740-corporate-tax-provision" \
-H "Content-Type: application/json" \
-H "X-RapidAPI-Key: YOUR_RAPIDAPI_KEY" \
-H "X-RapidAPI-Host: quantledger-73-engine-financial-and-statutory-api.p.rapidapi.com" \
-d '{
"jurisdiction": "NY",
"naics_or_sic": "541211",
"structured_inputs": {}
}'
B. Model Context Protocol (MCP) Tool Call
// Tool call inside Claude Desktop, Cursor, VS Code Copilot, LangGraph, or CrewAI:
execute_institutional_math_engine({
"engine_code": "BI-63",
"jurisdiction": "DE",
"naics_or_sic": "541211",
"structured_inputs": {}
})