--- name: month-end-close description: 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 assist ``` ## Journal 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 analysis ``` ### Journal 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 assignment ``` ## Account 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/2025 ``` ### Reconciliation 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 verification ``` ## Intercompany 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 required ``` ## Financial 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 close ``` ## Output ### 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 budget ``` ## Integration 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