AP Three-Way Match Audit, Duplicate Invoice & Early-Pay Discount Workpaper — Calculator, Excel Workpaper & API (BI-03)
Evaluates PO-Receipt-Invoice 3-Way Match Price & Quantity Overbilling Variance Recovery; Duplicate Invoice & Off-Contract Maverick Spend Segregation; Trade Credit Early-Pay Discount Annualized APR vs. Revolver Carry; Working Capital DPO & FASB ASC 405-20 Liability Extinguishment Cut-Off Reconciliation. Submit: Annual AP Spend, Po Matched Spend (USD), Unit Price Overbilling Rate, Quantity Overbilling (USD). Excel Tabs: Exec Spend Dashboard, UNSPSC Spend Cube, Duplicate Maverick Scan, DPO Working Capital. 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 405-20 Accounts Payable Extinguishment, 3-Way Match Variance & Trade-Credit APR Schedule
Official Agency Form / Workpaper Standard: FASB ASC 405-20 / IIA IPPF 2130 Three-Way Match Workpaper
Governing Accounting, Tax & Statutory Authorities: IIA IPPF Standard 2130; ISM Principles of Sustainability & Supply Management; FASB ASC 405 (Liabilities / AP Cutoff)
Common Practitioner & Search Aliases: AP 3-Way Match Audit, Duplicate Invoice Recovery, 2/10 Net 30 Discount Calculator, Maverick Spend Audit, DPO Working Capital Schedule
Interactive AP Three-Way Match Audit, Duplicate Invoice & Early-Pay Discount Workpaper Calculator (BI-03)
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-03 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) PO-Receipt-Invoice 3-Way Match Price & Quantity Overbilling Variance Recovery [IIA IPPF Standard 2130.A1 & COSO Internal Control — Integrated Framework Principle 10]
- (2) Duplicate Invoice & Off-Contract Maverick Spend Segregation [IIA IPPF Standard 2130 & AICPA AU-C 240 Disbursement Control Segregation]
- (3) Trade Credit Early-Pay Discount Annualized APR vs. Revolver Carry [Corporate Treasury Trade-Credit Yield Formula & ABL Working-Capital Cost of Carry]
- (4) Working Capital DPO & FASB ASC 405-20 Liability Extinguishment Cut-Off Reconciliation [FASB ASC 405-20-40-1 (Extinguishments of Liabilities), ASC 340-10 & UCC Sec. 2-319]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | 24-Month Accounts Payable Voucher & Check/ACH Disbursement Register | Structured JSON object/array or CSV text |
FILE-2 | Active Vendor Master File (TIN/EIN, Remit Address, Bank Routing Metadata & Payment Terms) | Structured JSON object/array or CSV text |
FILE-3 | Top-30 Executed Indirect Supplier Contracts, SaaS Subscriptions, Leases & Rate Cards | Structured JSON object/array or CSV text |
FILE-4 | Period-End Accounts Payable Aging Schedule, Open PO Report & Subsequent Disbursements Ledger | Structured JSON object/array or CSV text |
Deterministic Output Workpaper Schedules
| Workpaper Schedule | Computed Output Schedule & Tie-Out |
|---|---|
| Schedule 1 | 00 Exec Spend Dashboard |
| Schedule 2 | 01 UNSPSC Spend Cube |
| Schedule 3 | 02 Duplicate Maverick Scan |
| Schedule 4 | 03 DPO Working Capital |
| Schedule 5 | 04 ASC405 AP Cutoff Test |
| Schedule 6 | 05 Vendor Renegotiation Queue |
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/suites/BI-03/compute" \
-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-03",
"jurisdiction": "DE",
"naics_or_sic": "541211",
"structured_inputs": {}
})