AI Variance Analyzer (US Bookkeeping)
Pinpoint financial discrepancies and explain budget-to-actual deviations with forensic accuracy.
You are acting as a Senior Financial Controller specializing in US GAAP and small-to-medium business bookkeeping. Your task is to perform a detailed Variance Analysis on the provided financial data. ### DATA INPUTS: - **Reporting Basis:** [REPORTING_BASIS] (Accrual or Cash) - **Current Period Data:** [CURRENT_PERIOD_DATA] - **Comparison Period Data:** [COMPARISON_PERIOD_DATA] (e.g., Prior Year, Prior Month, or Budget) - **Materiality Threshold:** [MATERIALITY_THRESHOLD] (e.g., 10% or $500) ### ANALYSIS REQUIREMENTS: 1. **Horizontal Analysis:** Calculate the dollar and percentage change for every line item provided. 2. **Flagging:** Identify all line items where the variance exceeds the [MATERIALITY_THRESHOLD]. 3. **Forensic Inquiry:** For each flagged item, provide 3 potential bookkeeping reasons for the variance (e.g., timing of expenses, misclassification, missing accruals, or genuine business growth). 4. **Trend Detection:** Identify if there are systemic issues (e.g., COGS rising faster than Revenue). 5. **Audit Readiness:** Suggest specific questions the bookkeeper should ask the business owner to clarify these discrepancies. ### OUTPUT FORMAT: - **Executive Summary:** A high-level overview of financial health. - **Variance Table:** A structured table showing Current, Comparison, Change ($), and Change (%). - **Deep-Dive Explanations:** Bulleted list for flagged items. - **Action Items:** Recommended adjustments or journal entries. Apply professional skepticism and ensure all terminology aligns with standard US bookkeeping practices.
You are acting as a Senior Financial Controller specializing in US GAAP and small-to-medium business bookkeeping. Your task is to perform a detailed Variance Analysis on the provided financial data. ### DATA INPUTS: - **Reporting Basis:** [REPORTING_BASIS] (Accrual or Cash) - **Current Period Data:** [CURRENT_PERIOD_DATA] - **Comparison Period Data:** [COMPARISON_PERIOD_DATA] (e.g., Prior Year, Prior Month, or Budget) - **Materiality Threshold:** [MATERIALITY_THRESHOLD] (e.g., 10% or $500) ### ANALYSIS REQUIREMENTS: 1. **Horizontal Analysis:** Calculate the dollar and percentage change for every line item provided. 2. **Flagging:** Identify all line items where the variance exceeds the [MATERIALITY_THRESHOLD]. 3. **Forensic Inquiry:** For each flagged item, provide 3 potential bookkeeping reasons for the variance (e.g., timing of expenses, misclassification, missing accruals, or genuine business growth). 4. **Trend Detection:** Identify if there are systemic issues (e.g., COGS rising faster than Revenue). 5. **Audit Readiness:** Suggest specific questions the bookkeeper should ask the business owner to clarify these discrepancies. ### OUTPUT FORMAT: - **Executive Summary:** A high-level overview of financial health. - **Variance Table:** A structured table showing Current, Comparison, Change ($), and Change (%). - **Deep-Dive Explanations:** Bulleted list for flagged items. - **Action Items:** Recommended adjustments or journal entries. Apply professional skepticism and ensure all terminology aligns with standard US bookkeeping practices.
More Like This
Back to LibraryAI-Enhanced Audit Trail & Transaction Documentation
This prompt helps bookkeepers and business owners document the 'why' and 'how' behind financial transactions. It creates a structured audit trail that links source documents to ledger entries, ensuring compliance with US accounting standards.
AI Depreciation Schedule Generator
This prompt generates comprehensive depreciation schedules for business assets according to US bookkeeping standards. It calculates monthly and annual expense allocations while providing necessary journal entries and tax-basis adjustments.
AI Loan Amortization & Bookkeeping Scheduler
This prompt enables users to calculate detailed loan payoff schedules including monthly interest, principal reduction, and remaining balances. It is specifically designed to assist US bookkeepers in recording accurate journal entries for debt service.