Finance AI Skill
Month End Close
Orchestrate the month-end financial close process including close checklist management, journal entry generation, account reconciliation, bank reconciliation, intercompany reconciliation, and consolidation. Use when managing close calendar, tracking close t...
Financial Close & Reporting
Orchestrate an efficient, accurate month-end close with automated workflows and real-time tracking.
Close Process Orchestration
Close Calendar & Checklist
MONTH-END CLOSE CALENDAR — Standard (10-day close)
═══════════════════════════════════════════════════
Day -2 (2 days before month end):
┌─────────────────────────────────────────────────────┐
│ PRE-CLOSE ACTIVITIES │
├─────────────────────────────────────────────────────┤
│ [ ] Sub-ledger close: AR, AP, Fixed Assets, Inventory│
│ [ ] Cut-off procedures: revenue recognition, │
│ expense matching │
│ [ ] Intercompany transaction cutoff │
│ [ ] Inventory count (if monthly) │
│ [ ] Review pending transactions and holds │
└─────────────────────────────────────────────────────┘
Day 1 (Month end):
┌─────────────────────────────────────────────────────┐
│ GL ACTIVITIES │
├─────────────────────────────────────────────────────┤
│ [ ] Run preliminary trial balance │
│ [ ] Verify sub-ledger postings complete │
│ [ ] Bank feeds updated │
│ [ ] Review unusual transactions │
└─────────────────────────────────────────────────────┘
Day 2-3:
┌─────────────────────────────────────────────────────┐
│ JOURNAL ENTRIES │
├─────────────────────────────────────────────────────┤
│ [ ] Auto-generate recurring journal entries │
│ [ ] Accruals: expenses incurred but not invoiced │
│ [ ] Prepaid amortization │
│ [ ] Depreciation/Amortization │
│ [ ] Revenue deferrals and recognitions │
│ [ ] Inventory adjustments │
│ [ ] Foreign currency revaluation │
│ [ ] Manual JE: one-time adjustments, corrections │
│ [ ] Manager review and approval of all JEs │
└─────────────────────────────────────────────────────┘
Day 4-5:
┌─────────────────────────────────────────────────────┐
│ RECONCILIATIONS │
├─────────────────────────────────────────────────────┤
│ [ ] Bank reconciliations (all accounts) │
│ [ ] Balance sheet account reconciliations │
│ [ ] Intercompany reconciliations │
│ [ ] Fixed asset register vs. GL │
│ [ ] AR/AP sub-ledger vs. GL │
│ [ ] Controller review of reconciliation exceptions │
└─────────────────────────────────────────────────────┘
Day 6-7:
┌─────────────────────────────────────────────────────┐
│ REVIEW & FINALIZATION │
├─────────────────────────────────────────────────────┤
│ [ ] Final trial balance review │
│ [ ] Balance sheet review (account by account) │
│ [ ] P&L reasonableness check │
│ [ ] Intercompany eliminations │
│ [ ] Consolidation (multi-entity) │
│ [ ] Variance analysis: actual vs. budget/forecast │
│ [ ] CFO review and sign-off │
└─────────────────────────────────────────────────────┘
Day 8-10:
┌─────────────────────────────────────────────────────┐
│ REPORTING │
├─────────────────────────────────────────────────────┤
│ [ ] Financial statements (IS, BS, CF, SE) │
│ [ ] Management reports by department/business unit │
│ [ ] KPI dashboard update │
│ [ ] Board/investor reporting (if monthly) │
│ [ ] Regulatory filings (if applicable) │
│ [ ] Close metrics capture and improvement tracking │
└─────────────────────────────────────────────────────┘Close Task Management
CLOSE TASK TRACKING:
════════════════════
Task Status Indicators:
✓ Complete ⏳ In Progress ✗ Overdue ⏸ Blocked ⚑ Not Started
Current Close — January 2025 (Target: Day 8):
Day 1: Trial balance generation ✓ Complete (9:42 AM)
Day 2: Recurring JE generation ✓ Complete (2:15 PM)
Day 3: Accrual JEs ⏳ In Progress (due: Day 3, 5:00 PM)
Day 4: Revenue recognition JEs ⏳ In Progress
Day 5: Depreciation/amortization ⚑ Not Started (auto-generates Day 5)
Day 5: Manual JEs ⏳ In Progress (3 of 8 submitted)
Day 6: JE approvals ⏸ Blocked (awaiting 2 manual JEs)
Day 6: Bank reconciliations ⚑ Not Started
Day 7: BS account recs ⚑ Not Started
Day 8: IC reconciliations ⚑ Not Started
Day 8: Consolidation ⚑ Not Started
Day 9: Final TB review ⚑ Not Started
Day 10: Financial statements ⚑ Not Started
Bottleneck alert: Revenue recognition JEs behind by 4 hours
Impact: Delays downstream JE approvals and reconciliation start
Recommended action: Assign backup analyst to assistJournal Entry Management
Recurring Journal Entry Library
RECURRING JE TEMPLATES:
════════════════════════
1. DEPRECIATION — Monthly
Frequency: Monthly | Auto-generate: Day 3 | Owner: Fixed Asset Accounting
Dr: Depreciation Expense Cr: Accumulated Depreciation
Amount: System-calculated (asset register)
Supporting: Asset depreciation schedule
2. PREPAID INSURANCE AMORTIZATION — Monthly
Frequency: Monthly | Auto-generate: Day 3 | Owner: General Accounting
Dr: Insurance Expense Cr: Prepaid Insurance
Amount: $8,500 (annual premium / 12)
Supporting: Insurance policy amortization schedule
3. DEFERRED REVENUE RECOGNITION — Monthly
Frequency: Monthly | Auto-generate: Day 4 | Owner: Revenue Accounting
Dr: Deferred Revenue Cr: Revenue
Amount: Per contract amortization schedule
Supporting: Contract revenue recognition schedule
4. ACCRUED COMPENSATION — Monthly
Frequency: Monthly | Auto-generate: Day 3 | Owner: Payroll Accounting
Dr: Payroll Expense Cr: Accrued Payroll Liability
Amount: Days worked × daily payroll rate
Supporting: Payroll run schedule
5. SALES TAX ACCRUAL — Monthly
Frequency: Monthly | Auto-generate: Day 3 | Owner: Tax Accounting
Dr: Sales Tax Expense Cr: Sales Tax Payable
Amount: Calculated from sales by jurisdiction
Supporting: Tax calculation workbook
6. INTEREST ACCRUAL — Monthly
Frequency: Monthly | Auto-generate: Day 3 | Owner: Treasury
Dr: Interest Expense Cr: Accrued Interest Payable
Amount: Principal × rate × days / 360
Supporting: Debt schedule
7. FOREIGN CURRENCY REVALUATION — Monthly
Frequency: Monthly | Auto-generate: Day 4 | Owner: International Accounting
Dr/Cr: FX Gain/Loss Dr/Cr: Monetary assets/liabilities
Amount: Month-end FX rate vs. transaction rate
Supporting: FX revaluation workbook
8. INVENTORY WRITE-DOWN — Quarterly
Frequency: Quarterly | Auto-generate: Day 5 | Owner: Inventory Accounting
Dr: COGS / Inventory Write-down Cr: Inventory Reserve
Amount: Lower of cost or market analysis
Supporting: Inventory valuation analysisJournal Entry Approval Workflow
JE APPROVAL MATRIX:
═══════════════════
Amount / Type Approver Level
─────────────────────────────────────────────
Recurring (auto-generated) Accountant prepares → Controller approves
Manual <$10,000 Accountant → Accounting Manager
Manual $10K-$50,000 Accounting Manager → Controller
Manual $50K-$100,000 Controller → CFO
Manual >$100,000 Controller → CFO → CEO
Reclassification Accounting Manager
Correction / Prior period Controller → CFO
JE Documentation Requirements:
[ ] Clear description / narrative
[ ] Business justification
[ ] Supporting documentation (calculation, invoice, contract)
[ ] Correct period (no back-dating without Controller approval)
[ ] Correct accounts per chart of accounts
[ ] Balanced (Dr = Cr)
[ ] Proper cost center / department assignmentAccount Reconciliation
Reconciliation Framework
BALANCE SHEET RECONCILIATION — Standard Template
══════════════════════════════════════════════════
Account: 1000 — Cash — Operating Account
Period: January 2025 | Prepared by: J. Smith | Reviewed by: S. Johnson
GL Balance (Jan 31): $4,287,520.00
Per Bank Statement (Jan 31): $4,287,520.00
Reconciling Items:
None — Account is reconciled
Conclusion: Account reconciles. No exceptions.
Prepared: 02/03/2025 | Reviewed: 02/04/2025
──────────────────────────────────────────────────────
Account: 1200 — Accounts Receivable
Period: January 2025 | Prepared by: M. Lee | Reviewed by: S. Johnson
GL Balance (Jan 31): $4,823,400.00
AR Sub-ledger Balance: $4,823,400.00
Reconciling Items:
None — Sub-ledger agrees to GL
Conclusion: Account reconciles. AR aging reviewed — no aged
balances requiring allowance adjustment.
Prepared: 02/02/2025 | Reviewed: 02/03/2025
──────────────────────────────────────────────────────
Account: 2300 — Deferred Revenue
Period: January 2025 | Prepared by: K. Patel | Reviewed by: S. Johnson
GL Balance (Jan 31): $1,892,300.00
Sub-ledger (contract schedule): $1,892,300.00
Reconciling Items:
None — Contract schedule agrees to GL
Conclusion: Account reconciles. Revenue recognition schedule
updated for January. $142K recognized in January per contract terms.
Prepared: 02/02/2025 | Reviewed: 02/03/2025Reconciliation Prioritization
RECONCILIATION PRIORITY MATRIX:
════════════════════════════════
Priority 1 — Critical (Complete by Day 4):
Cash and bank accounts
Accounts receivable
Accounts payable
Accrued liabilities
Deferred revenue
Priority 2 — High (Complete by Day 6):
Fixed assets and accumulated depreciation
Prepaid expenses
Intercompany balances
Inventory
Loan and debt accounts
Priority 3 — Standard (Complete by Day 8):
Tax accounts (receivable/payable)
Shareholders' equity
Non-material balance sheet accounts
Reserve and provision accounts
Reconciliation Frequency:
Monthly: All balance sheet accounts
Quarterly: Equity accounts, reserve accounts
Annually: Full physical inventory, asset verificationIntercompany Reconciliation
IC Reconciliation Process
INTERCOMPANY RECONCILIATION — January 2025
══════════════════════════════════════════
Entity Pair: US Parent → EU Subsidiary
US Parent (IC Receivable): $2,450,000
EU Subsidiary (IC Payable, local): €2,180,000
FX Rate (month-end): 1.1239 USD/EUR
EU Subsidiary (IC Payable, USD equiv.): $2,450,232
Variance: $232
Variance %: < 0.01%
Resolution: Timing difference — wire in transit
(Wire sent 01/31, posted EU bank 02/01)
Classification: Reconciling item — resolves within 1 business day
Entity Pair: US Parent → Asia Subsidiary
US Parent (IC Payable): $890,000
Asia Subsidiary (IC Receivable, local): ¥13,200,000
FX Rate (month-end): 14.938 USD/JPY
Asia Subsidiary (IC Receivable, USD): $883,648
Variance: $6,352
Variance %: 0.71%
Resolution: FX translation difference — recorded in FX reserve
(Transactions occurred at spot rate; revalued at month-end rate)
Classification: Normal FX variance — no adjustment requiredFinancial Statement Generation
Statement Generation Process
FINANCIAL STATEMENT OUTPUT — January 2025
══════════════════════════════════════════
INCOME STATEMENT (Unaudited)
Three months ended January 31, 2025
Revenue:
Product revenue: $32,400,000
Service revenue: 9,700,000
Total Revenue: $42,100,000
Cost of Revenue:
Cost of product: (6,800,000)
Cost of service: (5,900,000)
Gross Profit: $29,400,000 (69.8%)
Operating Expenses:
R&D: (8,200,000)
Sales & Marketing: (9,800,000)
G&A: (4,100,000)
Total OpEx: (22,100,000)
Operating Income: $7,300,000 (17.3%)
Other:
Interest expense: (420,000)
FX gain: 180,000
Other income: 45,000
Income Before Tax: $7,105,000
Income tax expense: (1,421,000)
NET INCOME: $5,684,000 (13.5%)
──────────────────────────────────────────────────────
BALANCE SHEET (Unaudited)
As of January 31, 2025
ASSETS:
Current Assets:
Cash and equivalents: $42,100,000
Accounts receivable: $4,823,000
Prepaid expenses: $387,000
Other current assets: $245,000
Total Current Assets: $47,555,000
Non-Current Assets:
Property & equipment (net): $12,800,000
Intangible assets (net): $8,450,000
Goodwill: $5,200,000
Other non-current assets: $1,120,000
Total Non-Current Assets: $27,570,000
TOTAL ASSETS: $75,125,000
LIABILITIES:
Current Liabilities:
Accounts payable: $3,240,000
Accrued liabilities: $2,680,000
Deferred revenue: $1,892,000
Current portion of debt: $1,000,000
Total Current Liab.: $8,812,000
Non-Current Liabilities:
Long-term debt: $8,000,000
Deferred tax liability: $420,000
Other non-current liab.: $280,000
Total Non-Current Liab.: $8,700,000
TOTAL LIABILITIES: $17,512,000
EQUITY:
Common stock: $1,000,000
Additional paid-in capital: $48,500,000
Retained earnings: $8,113,000
TOTAL EQUITY: $57,613,000
TOTAL LIAB. + EQUITY: $75,125,000 ✓Close Metrics & Continuous Improvement
CLOSE METRICS — Q4 2024
════════════════════════
October Close: Day 9 (target: 8) ← 1 day over
November Close: Day 7 (target: 8) ← On track
December Close: Day 8 (target: 8) ← On track
Average close time: 8.0 days
Best close time: 6.5 days (improved process)
Worst close time: 11 days (YR close, one-time)
Improvement Areas:
1. Manual JE submission time: Avg 2.1 days → Target 1.0 day
Action: Provide templates and earlier deadlines
2. Reconciliation completion: 85% by Day 5 → Target 95%
Action: Auto-reconcile standard accounts; prioritize exceptions
3. Close checklist adherence: 92% tasks on time → Target 98%
Action: Automated reminders; escalation for overdue tasks
Year-Over-Year Improvement:
Average close time: 12.5 days (FY2023) → 8.0 days (FY2024)
Reduction: 36% improvement
Target FY2025: 5-6 day closeOutput
Close Dashboard View
FINANCIAL CLOSE DASHBOARD — January 2025
══════════════════════════════════════════════
Close Status: Day 4 of 8 — 50% Complete
Task Progress:
Pre-close activities: ✓ 100% (Days -2 to 0)
Journal entries: ⏳ 62% (8 of 13 submitted, 5 approved)
Reconciliations: ⚑ 0% (starts Day 5)
IC reconciliations: ⚑ Not started
Consolidation: ⚑ Not started
Financial statements: ⚑ Not started
Journal Entry Status:
Auto-generated: 7/7 entries generated and approved ✓
Manual JEs: 3/8 submitted (3 pending, 2 overdue)
Approval queue: 5 entries pending controller review
Reconciliation Forecast:
Estimated completion: Day 7 (vs. target Day 6)
Risk: Low — no material exceptions in prior months
Variance Highlights (Preliminary):
Revenue: +3.2% vs budget
OpEx: +2.1% vs budget
Net Income: +1.8% vs budgetIntegration Points
- ERP/GL (NetSuite, SAP, Oracle, QuickBooks): Core close platform, trial balance, JE posting
- Sub-ledger systems (AR, AP, FA, Inventory): Sub-ledger close and reconciliation
- Banking APIs: Bank feeds, statement retrieval, reconciliation
- Consolidation platforms (BlackLine, Trintech, Cadency): Close orchestration, recs, consolidation
- Planning tools (Anaplan, Adaptive Insights): Budget comparison, variance analysis
- BI platforms (Tableau, Power BI): Close metrics dashboards
- Document management (SharePoint, G-Cloud): Rec documentation, JE support
- Workflow tools (ServiceNow, Jira): Close task assignment and tracking
Edge Cases
- Year-end close: Extended timeline (Day 15-20); additional procedures (inventory count, tax provisions, audit prep)
- Quarter-end close: Additional regulatory reporting (10-Q for public companies); quarterly tax filings
- Mid-month close adjustments: Post-close discoveries → classify as current period or prior period adjustment per materiality
- Multi-entity, multi-currency: FX rate selection (spot vs. average); translation vs. remeasurement; eliminated intercompany FX
- Restatements: Prior period adjustments → dual-column presentation; management discussion; auditor notification
- Acquired entities: First close post-acquisition; chart of accounts mapping; opening balance validation
- Soft close vs. hard close: Preliminary numbers for early reporting; final numbers after all adjustments
- Close exception handling: Emergency JEs post-close → documented approval; root cause analysis; process update
- SOX-compliant close: Segregation of duties; dual approval; evidence retention; control testing points