Finance AI Skill
Accruals Estimates
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...
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
- 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- 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- 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- 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- 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 impactConversation 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."