BI-63 · Technical FASB GAAP, ERISA, U.S. Customs & Cyber Loss Suite

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

Live Zero-Code Statutory Calculator & .xlsx Builder

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)
Showing verified Washington, D.C. baseline — edit any input and click Recalculate.

Computed Headline Statutory & Financial KPIs

Study Id
BI-63
GAAP Effective Tax Rate (%)
25.64%
Total Tax Provision (USD)
$10,768,434.85
Net Deferred Tax Asset (USD)
$6,634,970.00
Fin48 Utp Reserve (USD)
$1,545,000.00
Residual Us Gilti Tax (USD)
$78,484.85

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:

2. Input Schema & Workpaper Output Schedules

Structured Input Datasets (structured_inputs)

Input SlotDataset / Trial-Balance ScheduleAccepted Format
FILE-1Consolidated & Entity-Level Year-End GAAP Trial Balance plus Book-to-Tax M-1 / M-3 ReconciliationsStructured JSON object/array or CSV text
FILE-2Prior 3 Years of Signed Federal, Multi-State & Foreign Income Tax Returns plus Prior Provision BinderStructured JSON object/array or CSV text
FILE-3State Apportionment Workpapers, Tax Fixed-Asset Register, IRC § 174 R&D & Equity Cap-Table HistoryStructured JSON object/array or CSV text
FILE-4Open Tax Examination Correspondence, R&D Credit Studies, Transfer-Pricing Reports & Prior UTP RollforwardStructured JSON object/array or CSV text

Deterministic Output Workpaper Schedules

Workpaper ScheduleComputed Output Schedule & Tie-Out
Schedule 101 Summary Budget Bridge
Schedule 202 ASU2023 09 ETR Rate Bridge
Schedule 303 Temp Diff DTA DTL Rollfwd
Schedule 404 Valuation Allowance Weight
Schedule 505 FIN48 UTP Cumulative Prob
Schedule 606 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": {}
})

← Back to All 73 QuantLedger Accounting, Tax & SEC Engines