--- name: accruals-estimates description: Manage financial accruals and estimates including accrued expenses, revenue accruals, vacation accruals, warranty reserves, and other estimated liabilities. Use when users need to calculate accruals for month-end/quarter-end close, set up accrual accounting processes, estimate unbilled revenue, calculate vacation/liability accruals, manage warranty reserves, or handle period-end adjusting entries for estimated amounts. Triggers on phrases like "accrual calculation", "estimate accrual", "accrued expenses", "unbilled revenue", "vacation accrual", "warranty reserve", "period-end accruals", "accrual journal entries", "estimate liability", "accrued interest", "bonus accrual", or related accrual and estimation queries. --- # Accruals & Estimates Management Accurately calculate, record, and manage financial accruals and estimates to ensure expenses and revenues are recognized in the correct accounting period per matching principle and GAAP/IFRS requirements. ## Workflow 1. **Catalog All Accrual Categories** - Build comprehensive accrual register: ``` ACCRUAL REGISTER TEMPLATE ════════════════════════════════════════ Category | Frequency | Estimation Method | Owner ──────────────────────────┼───────────┼────────────────────┼────────── Uninvoiced vendor costs | Monthly | Work-performed % | AP Manager Unbilled revenue | Monthly | % completion | Revenue Accounting Employee vacation/PTO | Monthly | Balance rollfwd | Payroll/HR Employee bonuses | Quarterly | Target % × score | Finance/HR Interest (loans/payable) | Monthly | Daily accretion | Treasury Warranties | Quarterly | Historical claim % | Finance/Product Taxes (income, sales) | Monthly | Effective rate | Tax Commissions | Monthly | % of billed rev | RevOps/Finance Legal/contingencies | Quarterly | Legal counsel | Legal/Finance Depreciation/Amortization | Monthly | Straight-line/ACCR | Fixed Assets Utilities | Monthly | Prior period avg | Facilities Insurance | Monthly | Prorated premium | Finance Commission clawbacks | Quarterly | Recovery rate | RevOps ``` 2. **Design Accrual Calculation Framework** - For each accrual category, define: ``` ACCRUAL CALCULATION SPECIFICATION ════════════════════════════════════════ 1. DATA SOURCES → Where does the input data come from? (ERP, sub-ledger, manual input, external) → What is the data refresh frequency? → Is the data automated or manually maintained? 2. CALCULATION METHODOLOGY → Formula / algorithm → Historical data lookback period (if using trending) → Key assumptions and their source 3. REVIEW & APPROVAL → Who calculates? → Who reviews? → Who approves? → What is the variance threshold that triggers additional review? 4. POSTING MECHANICS → Debit account(s) → Credit account(s) → Journal entry description standard → Supporting documentation required 5. REVERSAL PROCESS → Does this accrual auto-reverse next period? → What happens if the actual invoice differs from accrual? → Variance tracking and analysis process ``` 3. **Calculate Key Accrual Types** - **Uninvoiced Vendor Costs (Goods/Services Received Not Invoiced - GRNI)**: ``` GRNI CALCULATION ════════════════════════════════════════ For each open PO: → Total PO value: $X → Already invoiced: $Y (from AP sub-ledger) → % received/delivered: Z% (from receiving reports, project milestones) → Estimated accrued amount = Total PO value × Z% - Already invoiced Example: PO: $100,000 software implementation Invoiced to date: $40,000 (3 invoices) Project completion: 70% (per project manager confirmation) Accrual = $100,000 × 70% - $40,000 = $30,000 DR Expense (or Asset if capitalizable) $30,000 CR Accrued Expenses / AP Accrual $30,000 ``` - **Unbilled Revenue (Work Performed Not Billed)**: ``` UNBILLED REVENUE CALCULATION ════════════════════════════════════════ For each active contract: → Contract value: $X → % completion: Z% (per project status / milestone tracker) → Already billed: $Y → Unbilled revenue = Contract value × Z% - Already billed Recognition method: → Milestone contracts: Accrue when milestone acceptance confirmed → T&M contracts: Accrue based on approved timesheet hours × rate → % completion (long-term): Use cost-to-cost or output method DR Unbilled Receivables $Z CR Deferred / Unbilled Revenue $Z ``` - **Employee Vacation / PTO Liability**: ``` VACATION ACCRUAL CALCULATION ════════════════════════════════════════ Per employee: → Annual accrual rate: X days/year (based on tenure/company policy) → Monthly accrual: X / 12 days → Current balance = Prior balance + Monthly accrual - Days used → Dollar value = Current balance × Current daily pay rate Aggregate liability = Sum of all employee dollar values Consider: → Vesting rules (when can employees actually use/cash out) → Use-it-or-lose-it vs. carryover policies → Cap on maximum accrual balance (if applicable) → Current rate vs. exit rate (use exit rate per ASC 712) DR Compensation Expense $Z CR Vacation Liability $Z ``` - **Employee Bonus Accrual**: ``` BONUS ACCRUAL (Quarterly / Year-End) ════════════════════════════════════════ Per employee: → Target bonus: $X (from compensation plan) → Performance multiplier: Z× (based on company/individual scorecard) → Time weight: M/12 (months worked in bonus period) → Accrued bonus = Target × Multiplier × Time weight Key considerations: → ASC 718 / IFRS 2 for equity-based components → Probability assessment: Is bonus payment "probable" per GAAP? → Cliff vesting vs. graded vesting → Termination adjustments (pro-rata vs. forfeiture) DR Bonus Expense $Z CR Accrued Compensation $Z ``` - **Warranty Reserve**: ``` WARRANTY RESERVE CALCULATION ════════════════════════════════════════ Method 1: Historical claim rate → Reserve = Current period revenue × Historical warranty claim % → Historical rate = Total warranty costs (3-5 yr avg) / Total revenue Method 2: Product-specific estimation → Reserve = Units sold × Estimated failure rate × Avg. repair cost Method 3: Specific identification (for known issues) → Reserve for known defect campaigns + statistical reserve for unknown Rolling reserve: → Beginning balance → Plus: New accrual (expense this period) → Less: Actual warranty costs incurred → Less: Write-offs (expired warranties) → Ending balance DR Warranty Expense $Z CR Warranty Reserve Liability $Z ``` - **Interest Accrual**: ``` INTEREST ACCRUAL ════════════════════════════════════════ For each debt instrument: → Outstanding principal: $X → Annual interest rate: Y% → Days in accrual period: Z → Accrued interest = Principal × Rate × (Z / 365) For variable-rate debt: → Use current LIBOR/SOFR + spread → Recalculate at each rate reset date DR Interest Expense $Z CR Accrued Interest Payable $Z ``` 4. **Implement Accrual Process Controls** - Establish accrual reconciliation process: ``` ACCRUAL RECONCILIATION PROCESS ════════════════════════════════════════ Monthly: 1. Finance manager distributes accrual calculation templates to owners 2. Owners calculate accruals using approved methodologies 3. Peer review of calculations (maker-checker) 4. Finance manager reviews for reasonableness vs. prior periods 5. Journal entries drafted with supporting documentation 6. CFO approval for entries > threshold 7. Post to GL and verify posting 8. Track variance: Accrual vs. actual invoice (next period) 9. Analyze significant variances (>10% or > materiality threshold) Documentation requirements: → Calculation spreadsheet with formulas visible → Source data references → Assumptions documented → Approval sign-off → Retain for audit (minimum 7 years) ``` - Implement accrual aging and write-off analysis: ``` ACCRUAL HEALTH CHECK ════════════════════════════════════════ Red flags: → Accrual sitting >6 months without resolution → Cumulative variance trending in one direction (systematic under/over-accrual) → Accrual represents >5% of related expense category → Accrual calculated using same estimate for 3+ consecutive periods Actions: → Force resolution of aged accruals (invoice, write-off, or re-estimate) → Adjust estimation methodology if systematic bias identified → Escalate significant aged accruals to controller ``` 5. **Automate Accrual Processing** - Identify automation opportunities: ``` ACCRUAL AUTOMATION MAP ════════════════════════════════════════ Fully Automatable (system-driven): → Interest accruals (formulaic, data available) → Depreciation/amortization (fixed asset system) → Vacation accruals (HRIS data) → Insurance/subscription prorations (contract database) Semi-Automatable (system data + human judgment): → GRNI (PO/receiving data + % completion input) → Unbilled revenue (contract/project data + milestone confirmation) → Bonus accruals (compensation plan data + performance score input) Manual / Judgment-Driven: → Legal contingencies (requires legal counsel input) → Litigation reserves (legal assessment) → Restructuring reserves (management decision) → Impairment charges (complex valuation) ``` - Build accrual calculation engine in spreadsheet or financial systems tool - Set up automated journal entry templates for recurring accruals - Configure auto-reversal entries for self-clearing accruals ## Integration Points - **ERP**: SAP, Oracle, NetSuite (GL, AP, sub-ledger data) - **Project Management**: MS Project, Jira, Asana (milestone/completion data) - **HRIS**: Workday, BambooHR (vacation balances, bonus plans, headcount) - **Contract Management**: Icertis, Conga (contract terms, milestones) - **Fixed Asset Systems**: ERP module or standalone (depreciation schedules) - **Accounting Close Platforms**: BlackLine, FloQast, Trintech (reconciliation, JE workflow) - **Spreadsheet Tools**: Excel, Google Sheets (calculation templates) ## Edge Cases & Handling ``` EDGE CASES ═══════════════════════════════════════ 1. Restatement-Triggering Accrual Error → Assess materiality: Is the error >5% of net income or >5% of working capital? → If material: Coordinate with external auditor on restatement process → If immaterial: Correct in next period with disclosure note → Root cause analysis to prevent recurrence 2. Accrual for Non-Recurring / Non-Adjusting Post-Balance Sheet Events → ASC 855 / IAS 10: Distinguish adjusting vs. non-adjusting events → Adjusting: Evidence of condition that existed at period-end (accrue) → Non-adjusting: Condition arose after period-end (disclose, don't accrue) 3. Variable Consideration Estimates (Revenue Accruals under ASC 606) → Estimate most likely amount or expected value → Apply constraint: Only accrue to extent "highly probable" no reversal → Re-estimate at each reporting date → Document methodology and key assumptions 4. Multi-Period / Long-Duration Accruals → Track cumulative accrual across periods → Reconcile beginning balance to prior period ending → Document roll-forward: Beginning + Additions - Utilizations - Write-offs = Ending 5. Foreign Currency Accruals → Accrue in transaction currency → Translate at period-end spot rate for balance sheet presentation → Record FX gain/loss on re-measurement → Track functional currency impact ``` ## Conversation Examples ### Month-End Accrual Process ``` User: "What accruals do we need for month-end close? It's the 28th and I'm not sure we're ready." AI: "Let me run through your standard accrual checklist. For a typical month-end close, you need: Must-complete accruals (every month): 1. Interest accrual on debt — formulaic, should be automated 2. GRNI (goods received, not invoiced) — pull from open POs + receiving reports 3. Unbilled revenue — pull from project milestones + contract tracker 4. Vacation/PTO accrual — should auto-calculate from HRIS 5. Commission accrual — % of billed revenue this period 6. Utilities — estimate based on prior 3-month average if invoice not received Quarterly accruals (this quarter?): 7. Bonus accrual (if quarterly bonus cycle) 8. Warranty reserve adjustment 9. Tax provision estimate Year-end accruals (if applicable): 10. Annual bonus accrual (full-year) 11. Income tax provision 12. Legal/contingency reserves Quick actions to take today: → Email accrual owners (AP manager, project managers, HR) to submit inputs by EOD → Pull GRNI report from ERP → Confirm revenue milestone completions with project leads → Review prior month accrual variances for any pattern Want me to build you an accrual checklist template with deadlines?" ``` ### Accrual Variance Investigation ``` User: "Our GRNI accrual was off by $120K last month. The actual invoices were way higher than our estimate." AI: "A $120K variance is a red flag — let's diagnose what went wrong and fix the process. Likely root causes: 1. Timing gap — Large invoices received close to period-end but delivery completed earlier → Fix: Increase PO/receiving data cutoff or add buffer percentage 2. % completion misestimate — Project managers understated completion → Fix: Tie accrual to objective milestones, not subjective estimates → Add manager sign-off requirement for % inputs 3. Missing POs — Expenses incurred under blanket orders or verbal agreements → Fix: Mandate PO creation before work begins; add management estimate for un-PO'd spend 4. Scope changes — PO value adjusted upward but accrual used original PO amount → Fix: Pull accrual from approved change orders, not original PO Recommended fixes: → Add 10-15% buffer to GRNI for known large vendors → Require project manager confirmation of % completion by day 27 → Build accrual exception report: flag any PO with >20% variance between accrual and actual → Monthly accrual accuracy review in close meeting Share your GRNI detail and I'll help identify specific patterns." ```