--- name: journal-entry description: Generate, review, approve, and post journal entries including recurring entries, accruals, deferrals, allocations, and adjusting entries. Use when creating manual or automated journal entries, managing JE approval workflows, processing month-end accruals, handling intercompany entries, or maintaining JE audit trails. Triggers on phrases like "journal entry", "JE", "accrual entry", "adjusting entry", "recurring entry", "manual JE", "prepaid amortization", "deferred revenue", "allocation entry", "reversal entry", "JE approval". --- # Journal Entry Management Generate, validate, approve, and post journal entries with full audit trail and SOX-compliant controls. ## Workflow ### Journal Entry Lifecycle Trigger: Recurring entries on schedule; manual entries as needed; month-end close batch (Days 1–5 post-close): 1. **Recurring entry auto-generation**: Template library of standard entries — prepaid amortization, deferred revenue, depreciation, interest accruals, payroll tax, SBC. Configure frequency (daily/weekly/monthly/quarterly). 2. **Manual entry creation**: Standardized form; account validation; entity/cost center assignment; supporting documentation; business purpose narrative; period designation. 3. **Validation and controls**: Debits = credits (hard control); account validity; period openness; amount thresholds; segregation of duties (creator ≠ approver); account combination validation. 4. **AI-assisted review**: Flag unusual combinations, period-end large amounts, reversals, new users; suggest correct coding from description. 5. **Approval workflow**: < $10K → Finance Manager; $10K–$50K → Controller; > $50K → CFO; prior period → CFO + audit committee; SLA: 24 hours during close. 6. **Posting and confirmation**: Post to GL on approval; generate confirmation ID; update trial balance; lock entry; trigger downstream reporting. 7. **Documentation and audit trail**: Complete history; before/after values; supporting docs linked; user attribution; immutable log. ### Month-End Journal Entry Calendar ``` MONTH-END JOURNAL ENTRY CALENDAR — 6-DAY CLOSE ================================================ DAY 1 (Sub-ledger Cutoffs): └─ AR sub-ledger: Lock invoices; run bad debt provision └─ AP sub-ledger: Lock invoices; capture unrecorded liabilities └─ FA sub-ledger: Run depreciation; capture additions/disposals └─ Inventory sub-ledger: Cutoff physical count; run valuation └─ Output: Sub-ledger trial balances for reconciliation DAY 2 (Auto-Generated Recurring Entries): ├─ Prepaid amortization (straight-line monthly) │ Dr Insurance Expense / Cr Prepaid Insurance: $12,500 │ Dr Rent Expense / Cr Prepaid Rent: $25,000 ├─ Deferred revenue recognition │ Dr Deferred Revenue / Cr Revenue: Variable (by contract) ├─ Depreciation and amortization │ Dr Depreciation Expense / Cr Accumulated Depreciation: Variable ├─ Interest accruals on debt │ Dr Interest Expense / Cr Interest Payable: Principal × Rate × Days/360 ├─ Stock-based compensation │ Dr SBC Expense / Cr APIC: Variable (from equity system) └─ All entries: Auto-generated, auto-approved (pre-validated templates) DAY 3 (Manual Accrual Entries): ├─ Revenue accruals (unbilled work) │ Dr Accounts Receivable / Cr Unbilled Revenue: Based on % completion │ Example: Consulting project 75% complete, $400K contract → $300K accrued ├─ Expense accruals (incurred but not invoiced) │ Dr Operating Expense / Cr Accrued Liabilities: Based on estimates │ Example: Legal services through month-end, last invoice Jan 10 → accrue 20 days ├─ Commission accruals │ Dr Commission Expense / Cr Commissions Payable: Closed deals × rate │ Example: $500K closed in January × 10% commission = $50,000 ├─ Bonus accruals │ Dr Bonus Expense / Cr Accrued Bonuses: Headcount × target × % achievement │ Example: 500 employees × $5,000 target × 100% = $2,500,000 ├─ Payroll accruals (through last business day) │ Dr Payroll Expense / Cr Wages Payable: Daily rate × days worked ├─ Tax accruals (income, payroll, sales, use tax) │ Dr Tax Expense / Cr Taxes Payable: Estimated based on YTD rates └─ Data sources: Department heads submit accrual packages by 5 PM Day 3 DAY 4 (Intercompany and Allocations): ├─ Intercompany eliminations │ Dr IC Payable (Entity A) / Cr IC Receivable (Entity B): Match balances │ Resolve mismatches: Timing differences, FX translation errors ├─ Shared expense allocations │ Dr Department Expense / Cr Allocated Expense Clearing: By headcount % │ Example: IT shared cost $100K × Engineering 40% = $40K allocated ├─ Cost center transfers │ Dr Correct Cost Center / Cr Incorrect Cost Center: Reclassification └─ Validation: IC balances must net to zero at consolidated level DAY 5 (Review and Approval): ├─ Controller reviews all manual entries (> $5,000 individually reviewed) ├─ Exception resolution: Unusual amounts, new accounts, period-end clustering ├─ CFO approval: Material entries (> $50,000) and prior period adjustments ├─ Trial balance review: Reasonableness check vs. prior period and budget └─ Final posting: All approved entries posted before close cutoff (11:59 PM) DAY 6 (Post-Close Validation): ├─ Trial balance validates: BS balances, cash ties, equity roll-forward ├─ Flash reports generated: P&L vs. prior period and budget ├─ Post-close adjustments identified: Any errors found after posting │ Target: < 3 post-close adjustments per close cycle ├─ JE documentation archived: All entries with support in audit system └─ Close metrics recorded: Total JEs, processing time, exception count ``` ## Journal Entry Types and Templates ### Common Recurring Entry Library ``` RECURRING JOURNAL ENTRY TEMPLATES =================================== Template 1: Prepaid Insurance Amortization Frequency: Monthly Trigger: First business day of each month Amount: Annual premium / 12 = $12,500/month Entry: Dr 6150 - Insurance Expense $12,500 Cr 1150 - Prepaid Insurance $12,500 Narrative: Monthly amortization of annual insurance premium paid [date] Review: Annual (verify remaining prepaid balance matches policy schedule) Reversal: N/A (permanent amortization) Template 2: Deferred Revenue Recognition (SaaS) Frequency: Monthly Trigger: Second business day of each month Amount: Contract value / contract months (variable by contract) Entry: Dr 2250 - Deferred Revenue $XXX,XXX Cr 4000 - Subscription Revenue $XXX,XXX Narrative: Monthly recognition of deferred revenue per ASC 606 contract schedule Source: Revenue recognition system (RevPro/Tricor) generates amounts Review: Monthly (reconcile to deferred revenue roll-forward) Reversal: N/A (permanent recognition) Template 3: Depreciation — Straight-Line Frequency: Monthly Trigger: Third business day of each month Amount: (Cost − Salvage) / Useful Life / 12 Entry: Dr 6200 - Depreciation Expense $XXX,XXX Cr 1650 - Accumulated Depreciation $XXX,XXX Source: Fixed asset sub-ledger (auto-calculated by FA module) Review: Monthly (verify new assets added; disposals processed) Reversal: N/A (permanent depreciation) Template 4: Interest Accrual on Term Loan Frequency: Monthly (or daily for accuracy) Trigger: Last business day of each month Amount: Outstanding principal × stated rate × days in period / 360 Entry: Dr 6400 - Interest Expense $XX,XXX Cr 2200 - Interest Payable $XX,XXX Source: Debt schedule in treasury system Review: Monthly (verify principal balance; rate changes; payment application) Reversal: Auto-reverses on payment date Template 5: Stock-Based Compensation Frequency: Monthly Trigger: Fifth business day of each month Amount: (Grant FV × shares vested) / vesting period × months in period Entry: Dr 6300 - Stock-Based Compensation $XX,XXX Cr 1040 - Additional Paid-in Capital $XX,XXX Source: Equity management system (Carta/Pulley) calculates monthly expense Review: Monthly (verify grant activity; forfeitures; accounting policy) Reversal: N/A (permanent expense recognition) Template 6: Bad Debt Provision Frequency: Monthly Trigger: After AR aging report generated Amount: Based on aging provision method or expected credit loss model Entry: Dr 6250 - Bad Debt Expense $XX,XXX Cr 1120 - Allowance for Doubtful Accts $XX,XXX Source: AR aging report × provision percentages Review: Monthly (assess provision adequacy; write-offs; recoveries) Reversal: N/A (adjustment to provision balance) ``` ### Accrual Calculation Methods ``` ACCRUAL ESTIMATION METHODS ============================ Method 1: Daily Proration Use case: Expenses that accrue uniformly over time (rent, utilities, salaries) Formula: Monthly amount × (days elapsed / days in month) Example: Rent $30,000/month × 25 days / 31 days = $24,194 accrued through 25th Accuracy: High for uniform expenses Data needed: Monthly contract amount, cutoff date Method 2: Percentage of Completion Use case: Services performed but not yet invoiced Formula: Contract value × % complete − Revenue recognized to date Example: $500K contract × 75% complete − $250K recognized = $125K to accrue Accuracy: Medium (depends on % complete estimate quality) Data needed: Project manager estimate, contract value, recognition to date Method 3: Invoice Extrapolation Use case: Regular vendor invoices not yet received Formula: Average of last 3 invoices × (days since last invoice / invoice cycle) Example: Avg invoice $15,000 monthly; last invoice Jan 10; accrue 21 days $15,000 × (21 / 30) = $10,500 accrued Accuracy: Good for regular recurring expenses Data needed: Last 3 invoice amounts, last invoice date, invoice cycle Method 4: Headcount-Based Use case: Payroll, benefits, commissions, bonuses Formula: Headcount × rate × period fraction Example: 500 employees × $5,000 bonus target × 100% achievement = $2,500,000 Accuracy: High if headcount and rates verified Data needed: HR headcount report, compensation data, performance metrics Method 5: Formula-Based (Tax) Use case: Income tax, payroll tax, sales tax Formula: Taxable base × effective tax rate × period fraction Example: YTD pre-tax income $5M × 25% effective rate − taxes paid $800K = $450K accrual Accuracy: Medium (effective rate may change) Data needed: Pre-tax income, effective rate, taxes paid to date ``` ## Approval and Control Framework ### SOX-Compliant JE Controls ``` JOURNAL ENTRY INTERNAL CONTROLS (SOX) ======================================== Control 1: Segregation of Duties - Entry preparer ≠ entry approver (hard system control) - Entry approver ≠ GL poster (if separate posting function exists) - System enforces: User roles defined; cannot self-approve - Exception: Single-controller companies — compensating control = external review - Testing: Quarterly access review; user role validation Control 2: Approval Authority Matrix - < $10,000: Finance Manager - $10,001–$50,000: Controller - $50,001–$250,000: CFO - $250,001+: CFO + CEO (or Board for > $1M) - Prior period: Always CFO + Controller (regardless of amount) - Off-cycle: Always Controller + CFO (additional scrutiny) - System enforces: Amount-based routing; cannot bypass Control 3: Period Control - GL periods locked after close (only CFO can unlock) - Unlock requires: Documented reason, CFO approval, audit log entry - Target: < 2 period unlocks per year - Monitoring: Monthly report of all period unlock requests Control 4: Documentation Requirement - Mandatory fields: Entry reason, supporting document attachment - Narrative: Minimum 20 characters; cannot be generic ("adjustment") - Supporting docs: Spreadsheet, email, contract, calculation — linked to entry - System enforces: Cannot submit without narrative and attachment Control 5: JE Review and Exception Monitoring - Monthly JE review: Controller reviews all entries > $10,000 - Exception report: Flag entries with: * Round amounts (potential estimation rather than calculation) * Entries posted on last day of period (potential earnings management) * Entries reversing entries from same preparer within 30 days * Entries to unusual account combinations * Entries from new users or users with limited history - Review frequency: Monthly (at least); weekly during close Control 6: Audit Trail - Immutable log of: Creation, modification, approval, posting, reversal - Timestamps: Creation date, approval date, posting date - User attribution: Every action linked to specific user ID - Before/after: All changes recorded with old and new values - Retention: 7 years minimum (SOX requirement) ``` ## Edge Cases - **Prior period adjustments**: - Materiality assessment: > 5% of net income or > 1% of total assets → material - Treatment: If material → restate prior period financials; if immaterial → current period - Approval: Elevated — CFO + Controller + external auditor notification (if material) - Documentation: Root cause analysis, impact quantification, remediation plan - SOX: Assessed as control deficiency if frequent (indicates process weakness) - Communication: Board notification if material; restatement disclosure in 10-K - **Off-cycle entries** (between close periods): - Justification required: Why entry cannot wait for regular close? - Typical valid reasons: Error correction, intercompany resolution, audit adjustment - Scrutiny: Controller + CFO approval regardless of amount - Documentation: Enhanced narrative with urgency justification - Impact: May trigger interim reporting update (for public companies) - Risk: Indicates close process weakness if frequent (> 2 per quarter) - **Multi-entity journal entries**: - Intercompany: Both sides of entry must post simultaneously - FX rate: Transaction date rate for original entry; spot rate for revaluation - Elimination: Consolidated entries to eliminate IC balances and transactions - Currency: Entry in local currency; translated for consolidation - Validation: IC receivables/payables must match between entities - Common mismatches: Timing differences (one entity recorded, other hasn't), FX rounding - **Reversal entries**: - Purpose: Undo prior period accrual when actual invoice received - Auto-reversal: Configure at entry creation (reverses on first day of next period) - Example: Jan accrual $50,000 → Feb 1 auto-reversal ($50,000 credit to accrual) - When invoice arrives in Feb: Record actual amount (may differ from accrual) - Tracking: Monitor reversal execution rate (target: > 95%) - Exception: Missed reversals flagged monthly; manual correction required - **Complex multi-line entries** (10+ lines): - Break into logical groups: Each component documented separately - Example: Month-end close bundle — 25 lines across 8 accounts - Supporting schedule: Detailed calculation spreadsheet with line-by-line amounts - Review: Each component reviewed individually by controller - Risk: Higher error rate for complex entries — target error rate < 2% - Best practice: Split into multiple simpler entries when possible - **System-generated entries** (from sub-ledgers): - Sources: AR sub-ledger, AP sub-ledger, FA sub-ledger, inventory, payroll - Validation: Reconcile sub-ledger totals to GL postings - Review: Sample test of system-generated entries (5–10% sample) - Anomaly detection: Flag entries with unusual amounts or account combinations - Control: System configuration reviewed annually; access restricted to authorized users - **Error corrections**: - Discovery: Through reconciliation, audit review, or self-discovery - Correction: Reverse incorrect entry; post correct entry (never modify posted entry) - Documentation: Root cause of error; impact assessment; remediation to prevent recurrence - Escalation: Material errors → Controller → CFO → Board (if material to financials) - Trend: Track error types and frequency; target < 1% error rate ## Integration Points - **ERP/GL**: NetSuite, SAP S/4HANA, Oracle ERP Cloud — entry posting, trial balance, chart of accounts, period control - **Sub-ledgers**: AR (Salesforce/ERP), AP (Bill.com/ERP), FA (ERP module), Inventory (ERP/WMS) — auto-generated entries - **Equity systems**: Carta, Pulley, Carta — SBC calculation, grant tracking, vesting schedules - **Revenue recognition**: RevPro (Vertex), Tricor Revcom, Bright Sphere — deferred revenue entries - **Payroll systems**: ADP, Workday, Gusto — payroll accruals, tax entries - **Document management**: SharePoint, Google Drive, NetDocuments — supporting documentation storage and retrieval - **SOX compliance tools**: AuditBoard, SAI360, Workiva — control testing, evidence collection, JE monitoring - **Approval systems**: ApprovalMax, Conga, native ERP workflows — routing and tracking - **BI tools**: Tableau, Power BI — JE analytics, trend monitoring, exception dashboards - **Data warehouse**: Snowflake, BigQuery — JE data integration, ML-based anomaly detection