FP&A Spreadsheet - Formula Integrity Check
Problem
Catches hidden formula errors, hardcoded overrides, double-counted totals, and sign mismatches in financial spreadsheets before they reach stakeholders. Eliminates the manual cross-checking that auditors and FP&A teams spend hours on every reporting cycle.
Prompt Input
Act as a Financial Modeling Quality Assurance Expert. Examine the formula structure and logic of the attached spreadsheet/data table. Perform a logic check on all subtotals and totals by completing these tasks: 1. Re-calculate independent subtotals: Audit all category subtotals by manually summing their components to ensure they match the reported subtotal row. 2. Double-Counting Check: Verify that the Grand Total row only sums the Subtotal rows, and does not accidentally double-count the raw line items. 3. Formula Continuity: Scan down the columns to ensure that identical rows use the exact same formula structure (flag any hardcoded numbers hidden in formula rows). 4. Signage Check on Subtotals: Ensure contra-accounts or discounts are properly subtracted rather than added to the subtotals. If you find a math mismatch, output the exact Row Category, the reported total, your calculated total, and the exact variance amount.
Prompt Output
Returns a row-by-row audit report flagging: math mismatches (with reported vs calculated vs variance), hardcoded values hidden in formula rows, double-counted line items in grand totals, and sign errors on contra-accounts — with exact cell/row references for each finding.