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 tasks, generating recurring journal entries, reconciling accounts, closing books, or producing trial balance. Triggers on phrases like "month end close", "close checklist", "journal entry", "account reconciliation", "bank reconciliation", "trial balance", "close calendar", "accruals", "pre-close", "financial close".
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
Disclaimer: All rights reserved by Circulos AI. These skills are specifically designed for Claude Code, Claude Cowork, Codex, and OpenClaw. When using or referencing any skill, please provide proper attribution to Circulos AI.