--- name: Finance Operations Expert description: Bank reconciliation, variance analysis, month-end close, AP/AR, intercompany accounting, financial reporting, accrual, trial balance, waterfall, distribution, bad debt, property tax appeal, management fee, close checklist, consolidation. --- # Finance Operations Expert Comprehensive reference for financial operations at a multi-entity manufactured housing community (MHC/MHP) property management company. Covers bank reconciliation, variance analysis, month-end close, AP/AR, intercompany accounting, investor distributions, accruals, financial reporting, internal controls, and decision frameworks. **Scope:** Sunrise Communities (SCI management company + individual property LLCs) operating manufactured housing communities across multiple states under a value-add investment model. **Source dates:** Existing Sunrise skill content (reconciliation, variance-analysis, close-management) preserved in full. Research current as of March 2026. GAAP references: ASC 842 (Leases), ASC 810 (Consolidation), ASC 326 (Credit Losses/CECL), COSO 2013 Internal Controls framework. **Disclaimer:** This skill assists with financial operations workflows but does not provide financial advice. All reconciliations, close entries, and investor calculations should be reviewed by Mike (Controller) or qualified finance team members before sign-off. Investor distribution calculations require legal review against operating agreements. --- ## Table of Contents 1. [Sunrise Financial Environment](#1-sunrise-financial-environment) 2. [Bank Reconciliation](#2-bank-reconciliation) 3. [Variance Analysis Framework](#3-variance-analysis-framework) 4. [Month-End Close Process](#4-month-end-close-process) 5. [AP/AR Management](#5-apar-management) 6. [Intercompany Accounting](#6-intercompany-accounting) 7. [Investor Distributions](#7-investor-distributions) 8. [Accruals and Adjusting Entries](#8-accruals-and-adjusting-entries) 9. [Financial Reporting](#9-financial-reporting) 10. [Internal Controls (COSO Framework)](#10-internal-controls-coso-framework) 11. [GAAP for MHP Operations](#11-gaap-for-mhp-operations) 12. [Decision Trees](#12-decision-trees) 13. [Common Gotchas](#13-common-gotchas) 14. [Procedures](#14-procedures) 15. [Output Formats](#15-output-formats) 16. [References](#16-references) --- ## 1. Sunrise Financial Environment ### Entity Structure ``` Sunrise Capital Investors (SCI) — Management Company / GP | +-- Property LLC 1 (e.g., Ridgebrook MHC LLC) +-- Property LLC 2 (e.g., Sherman Estates LLC) +-- Property LLC 3 (e.g., Oak Ridge MHP LLC) +-- ... (individual LLC per property) | +-- Fund-level entities (capital raise vehicles) ``` **Key structural facts:** - Each property held in a separate LLC for liability isolation and lender requirements - SCI acts as management company and general partner - Individual property LLCs have their own bank accounts, QBO files, and financial statements - Fund-level consolidation required for investor reporting - Intercompany transactions flow between SCI and each property LLC (management fees, shared costs, distributions) ### Systems Landscape | System | Role | Key Integration Points | |--------|------|----------------------| | **QuickBooks Online (QBO)** | General ledger for each entity | Separate QBO subscription per LLC; no native consolidation | | **RentManager (RM)** | Property management, tenant billing, collections | Syncs to QBO; subledger for AR, revenue | | **Divvy (BILL Spend & Expense)** | Credit card expense management | Integrates with QBO; virtual cards per vendor/property | | **Paychex** | Payroll processing | Posts to QBO; allocates by property | | **Bank portals** | Statement access, wire initiation | Manual download or Bank Sync (Plaid) | | **Google Sheets** | KPI dashboard, consolidated reporting | Export from QBO/RM; manual or scripted | **QBO multi-entity pattern:** Each property LLC has its own QBO company. SCI has its own QBO company. Consolidation is done externally (Google Sheets or third-party tools) because QBO has zero native consolidation capability. This means: - Chart of accounts must be standardized across all QBO files - Intercompany transactions must be recorded on both sides manually - Consolidated reports require export, mapping, and aggregation outside QBO - Account numbering convention: use entity prefix or suffix (e.g., 4000-LotRent is the same across all files) ### Banks in Use | Bank | Account Types | Properties/Purpose | Plaid/Bank Sync | |------|---------------|-------------------|-----------------| | **Truist** | Operating, Reserve | Primary operating accounts | Confirmed | | **Flagstar** | Operating | Property accounts | Confirmed | | **Valley National** | Operating | Regional properties | Likely supported | | **Five Star Bank** | Operating | Specific properties | Verify support | | **Old Second Bank** | Operating | Specific properties | Verify support | **Common account types per property:** - **Operating account** — Day-to-day rent collections, vendor payments, payroll - **Reserve/escrow account** — Lender-required reserves for taxes, insurance, capital expenditures - **Security deposit account** — Tenant security deposits (state law may require separate trust account) - **Intercompany account** — SCI-to-LLC transfers for management fees, shared costs **Cash management best practices for multi-bank portfolio:** - Maintain multi-bank relationships for redundancy (single bank failure does not freeze all operations) - FDIC coverage: $250K per depositor per bank; spread balances above this threshold - Weekly cash position report across all banks (aggregate operating + reserve balances) - Target minimum operating balance per property: 1-2 months of operating expenses - Sweep excess cash to reserve accounts or higher-yield positions - Centralize wire/ACH approvals through dual authorization - Reconcile all accounts monthly; no exceptions ### Team and Roles | Role | Person | Responsibilities | |------|--------|-----------------| | **Controller** | Mike | Month-end close, trial balance review, adjusting entries, financial package | | **Finance team** | Staff | Bank recs, AR recs, AP processing, data entry | | **VP/COO** | Sam | Financial package review, strategic decisions, escalation target | | **IT/Systems** | Carlos/Aurora | KPI dashboard exports, QBO-RM sync troubleshooting, automation | | **Property Managers** | Various | RentManager processing, invoice coding, move-in/move-out, utility billing | ### Key Reports | Report | Frequency | Audience | Source | |--------|-----------|----------|--------| | Property P&L (per property) | Monthly | Operations, investors | QBO | | Consolidated portfolio P&L | Monthly | Leadership, investors | Aggregated from QBO | | Balance sheet summary | Monthly | Mike, Sam | QBO | | Cash flow summary | Monthly | Mike, Sam | QBO + bank data | | KPI dashboard | Monthly | Leadership, board | RM + QBO via export scripts | | Investor reporting package | Quarterly | LPs/investors | Consolidated financials + narrative | --- ## 2. Bank Reconciliation ### Standard Bank Reconciliation Procedure Compare the GL cash balance to the bank statement balance. Both must reconcile to an identical adjusted balance. **Step-by-step process:** 1. **Obtain bank statement** — Download from bank portal (or via RentManager Bank Sync if available). Confirm statement period matches GL period (calendar month-end). 2. **Obtain GL cash balance** — Pull cash account balance from QBO as of the same date. 3. **Identify outstanding checks** — Checks issued in QBO but not yet cleared at the bank. Cross-reference check register with cleared items on bank statement. 4. **Identify deposits in transit** — Deposits recorded in QBO but not yet credited by the bank (typically ACH rent payments, late deposits on last business day). 5. **Identify bank charges not recorded** — Service fees, wire fees, returned item fees, monthly maintenance fees. 6. **Identify bank credits not recorded** — Interest income, refunds, credits. 7. **Reconcile both sides** — Adjust both the bank balance and GL balance to arrive at the same adjusted figure. 8. **Prepare adjusting entries** — Journal entries for items in Category 2 (see below). 9. **Document and sign off** — Preparer signs, reviewer (Mike) signs, date stamp. **Standard reconciliation format:** ``` BANK RECONCILIATION — [Property Name] — [Account Name] — [Period End Date] Balance per bank statement: $XX,XXX.XX Add: Deposits in transit $X,XXX.XX Less: Outstanding checks ($X,XXX.XX) Add/Less: Bank errors $X,XXX.XX ---------- Adjusted bank balance: $XX,XXX.XX Balance per general ledger: $XX,XXX.XX Add: Interest/credits not recorded $X,XXX.XX Less: Bank fees not recorded ($X,XXX.XX) Add/Less: GL errors/corrections $X,XXX.XX ---------- Adjusted GL balance: $XX,XXX.XX Difference: $0.00 ========== Preparer: _______________ Date: ________ Reviewer: _______________ Date: ________ ``` ### GL-to-Subledger Reconciliation (RentManager) Compare RentManager tenant receivable balances to GL control account. **Process:** 1. Pull GL balance for Accounts Receivable from QBO as of period end 2. Pull RentManager Aged Receivables report as of same date 3. Compare totals — should match if sync is current 4. Investigate differences **Common causes of differences:** - Manual journal entries in QBO not reflected in RentManager - RentManager transactions not yet synced to QBO - Batch posting timing differences (daily vs. real-time) - Reclassification entries in GL without RM adjustment - Write-offs recorded in one system but not the other - Charge reversals or credits applied in RM but not yet synced ### Intercompany Reconciliation Reconcile balances between SCI (management company) and individual property LLCs. **Common intercompany items:** - Management fees (% of gross revenue, per management agreement) - Shared services allocations (corporate overhead) - Capital contribution calls (investor capital flowing through SCI) - Distribution payments to investors (flowing from property LLC through SCI to investors) - Insurance/vendor payments made centrally by SCI on behalf of property LLCs - Payroll allocated across properties but processed centrally **Process:** 1. Pull intercompany receivable/payable from SCI books 2. Pull corresponding payable/receivable from each property LLC 3. Verify dollar-for-dollar matching (SCI receivable = LLC payable, and vice versa) 4. Identify differences — most commonly management fee calculation timing 5. Confirm all intercompany transactions recorded on both sides 6. Verify elimination entries are correct for fund-level consolidation 7. Intercompany balances MUST net to zero in consolidation ### Reconciling Item Classification **Category 1: Timing Differences (no action needed)** Items that will clear without adjustment: - Outstanding checks: issued, pending bank clearance (normal: 1-5 business days) - Deposits in transit: recorded in GL, pending bank credit (normal: 1-2 business days) - ACH timing: payments initiated, pending settlement (1-3 business days) - Divvy pending charges: credit card charges awaiting final posting - **Expected resolution:** 1-5 business days. No adjusting entry needed. **Category 2: Adjustments Required** Items requiring a journal entry: - Unrecorded bank charges: wire fees, returned item fees, monthly service fees - Unrecorded interest: interest income from operating/reserve accounts - Recording errors: wrong amount, wrong property, duplicate entries - Missing entries: transactions at the bank with no GL entry - **Action:** Prepare adjusting journal entry. Common at Sunrise: bank fees, interest income. **Category 3: Requires Investigation** Items that cannot be immediately explained: - Unidentified ACH debits: unknown automatic withdrawals (red flag) - Disputed items: amounts contested with vendors or tenants - Aged outstanding checks: checks not clearing after 30+ days (stale check) - Recurring unexplained differences: same variance appearing each period - **Action:** Investigate root cause, document findings, escalate per thresholds. ### Aging Analysis for Outstanding Items | Age Bucket | Status | Action | |-----------|--------|--------| | 0-30 days | Current | Monitor — within normal processing cycle | | 31-60 days | Aging | Investigate — follow up on why item has not cleared | | 61-90 days | Overdue | Escalate — notify Mike, document investigation | | 90+ days | Stale | Escalate to Sam — potential write-off or void needed | **Aging report format:** | Item # | Description | Amount | Date Originated | Age (Days) | Category | Status | Owner | |--------|-------------|--------|-----------------|------------|----------|--------|-------| | 1 | Check #4521 to ABC Vendor | $1,250 | 2026-01-15 | 45 | Outstanding | Investigating | Mike | **Trending requirements:** - Compare total outstanding items to prior period - Flag if total reconciling items exceed $10,000 per account - Flag if number of items is growing period over period - Identify recurring items that appear every period (process issue — fix root cause) ### Escalation Thresholds | Trigger | Threshold | Escalation | |---------|-----------|------------| | Individual item amount | > $5,000 | Mike review | | Individual item amount | > $25,000 | Sam review | | Total reconciling items | > $50,000 | Sam review | | Item age | > 60 days | Mike follow-up | | Item age | > 90 days | Sam / leadership review | | Unreconciled difference | Any amount | Cannot close — must resolve | | Growing trend | 3+ consecutive periods | Process improvement investigation | ### Sunrise-Specific Reconciling Items **Common at Sunrise:** 1. Divvy credit card timing — charges pending final posting to QBO 2. ACH rent payments — 1-2 day settlement delay from RM Bank Sync 3. Utility pass-through timing — bill received vs. payment posted 4. RentManager batch posting — daily vs. real-time posting differences 5. Intercompany management fees — monthly calculation timing (usually posted T+5) 6. Lender escrow disbursements — tax/insurance payments from reserve accounts **Red flags to watch:** 1. Unknown ACH debits — could indicate unauthorized access (escalate immediately) 2. Duplicate vendor payments — same invoice paid twice (AP control failure) 3. Checks outstanding 90+ days — need to void and reissue or write off 4. Large unexplained wire transfers — verify authorization chain 5. Intercompany imbalances — must always net to zero ### Bank Reconciliation Automation **RentManager Bank Sync (current capability):** - Uses Plaid integration to connect bank accounts - Auto-imports transactions and matches to RM records - Reduces manual matching effort by approximately 70-75% - Confirmed working: Truist, Flagstar. Verify: Valley National, Five Star, Old Second - Still requires review and sign-off — automation does not replace judgment **Automation maturity roadmap:** 1. **Current state:** Manual download + partial Bank Sync in RM 2. **Near-term (T+5 goal):** Full Bank Sync across all banks, auto-categorization rules, exception-only review 3. **Future state:** AI-powered matching (95%+ auto-match), continuous reconciliation, real-time cash position dashboard **Best practices for automated reconciliation:** - Set up matching rules for recurring transactions (rent ACH, utility payments, payroll) - Define tolerance thresholds for auto-matching (exact match for checks, +/- $0.01 for rounding) - Route exceptions to human review queue - Maintain audit trail of all auto-matched items - Reconcile the reconciliation: spot-check 5-10% of auto-matched items monthly ### Integration with KPI Dashboard After completing bank reconciliations: 1. Verify Cash Collected in Monthly_Data matches bank deposits 2. Verify Collection Rate calculation uses reconciled figures 3. Flag any material timing differences that affect KPI reporting --- ## 3. Variance Analysis Framework ### NOI Variance Decomposition NOI (Net Operating Income) is the primary performance metric for MHP operations. Decompose into revenue and expense drivers: ``` NOI Variance = Revenue Variance + Expense Variance (inverted sign) Revenue Variance: + Lot rent variance (rate x occupancy) + Utility income variance + Other income variance (late fees, application fees, storage, laundry, etc.) Expense Variance: + Payroll variance + Utilities expense variance + R&M variance + Insurance variance + Property tax variance + Management fee variance + Other expense variance ``` ### Lot Rent Variance (Rate x Occupancy) The most important revenue driver. Decompose into rate, occupancy, and mix effects: ``` Total Lot Rent Variance = Actual - Budget Rate Effect = (Actual Rate - Budget Rate) x Budget Occupied Units Occupancy Effect = (Actual Units - Budget Units) x Budget Rate Mix Effect = Residual (if multiple rate tiers exist) Verification: Rate Effect + Occupancy Effect + Mix Effect = Total Variance ``` **Example — single property:** - Budget: 100 units at $400 = $40,000/month - Actual: 98 units at $425 = $41,650/month - Total variance: +$1,650 favorable - Rate effect: +$25 x 100 = +$2,500 (favorable — rent increase captured) - Occupancy effect: -2 units x $400 = -$800 (unfavorable — vacancies) - Mix effect: -$50 (interaction term) - Net: +$1,650 ### Loss-to-Lease Variance Measures gap between actual rent collected and market rent potential. Critical for the value-add model: ``` Loss-to-Lease = (Market Rent - Actual Rent) / Market Rent x 100 LOL Variance = Prior Period LOL% - Current Period LOL% (Positive = LOL shrinking = value capture = good) (Negative = LOL growing = underperformance = investigate) ``` **Drivers of LOL change:** 1. Rent increases implemented -> LOL decreases (good — core value-add strategy) 2. New leases at market rate -> LOL decreases (good) 3. Market rent increases -> LOL increases if Sunrise doesn't follow 4. Long-term residents not renewed -> LOL effect depends on replacement rate **Loss-to-Lease tracking table:** | Property | Market Rent | Actual Rent | LOL $ | LOL % | Target | Gap to Target | |----------|-------------|-------------|-------|-------|--------|---------------| | Ridgebrook | $475 | $425 | $8,400 | 10.5% | 5% | -$4,400 | | Oak Ridge | $400 | $380 | $2,200 | 5.0% | 5% | $0 | | Sherman | $350 | $340 | $1,100 | 2.9% | 5% | +$2,300 | **Total Portfolio LOL:** $X (X%) vs Target 5% ### Same-Store NOI Variance For properties owned 12+ months, track year-over-year growth: ``` Same-Store NOI Growth = (Current NOI - Prior Year NOI) / Prior Year NOI x 100 Decompose into: 1. Rent growth component (lot rent x occupancy) 2. Other revenue component 3. Controllable expense component (payroll, R&M, utilities) 4. Non-controllable expense component (taxes, insurance) ``` **2026 Target:** 5% Same-Store NOI Growth (Q1 2026 Rock) ### Materiality Thresholds **By comparison type:** | Comparison | Dollar Threshold | Percentage Threshold | Trigger | |------------|-----------------|---------------------|---------| | Actual vs Budget (monthly) | $5,000 | 10% | Either exceeded | | Actual vs Prior Period | $5,000 | 15% | Either exceeded | | Same-Store YoY | $10,000 | 5% | Either exceeded | | Quarterly Roll-up | $25,000 | 10% | Either exceeded | **By line item:** | Line Item | Dollar Threshold | Notes | |-----------|-----------------|-------| | Lot Rent | $2,500 | Core revenue — tight threshold | | Utility Income | $1,500 | Pass-through — should track expense | | Payroll | $2,000 | Largest controllable expense | | R&M | $3,000 | Volatile — higher threshold | | Utilities Expense | $2,000 | Seasonal variation expected | | Insurance | $1,000 | Should be stable — investigate any variance | | Property Taxes | $500 | Should match budget closely | ### Narrative Generation for MHP Variances **Structure for each variance narrative:** ``` [Line Item]: [Favorable/Unfavorable] variance of $[amount] ([percentage]%) vs [Budget/Prior Period] for [Property/Portfolio] in [Month] Driver: [Primary driver description] [2-3 sentences explaining the business reason, with specific quantification] Outlook: [One-time / Expected to continue / Seasonal / Trend] Action: [None required / Monitor / Investigate / Update forecast] ``` **MHP-specific narrative templates:** Lot Rent Favorable (Rent Increase): ``` Lot Rent: Favorable variance of $8,400 (+7.5%) vs prior year for Ridgebrook in January. Driver: Successfully implemented $50/lot rent increase effective January 1, capturing loss-to-lease value. 168 occupied lots x $50 = $8,400/month incremental revenue. Outlook: Expected to continue through 2026. Next increase planned for January 2027. Action: None required — performing as planned. ``` Occupancy Unfavorable: ``` Occupancy: Unfavorable variance of $1,800 (-2.1%) vs budget for Sherman Estates in January. Driver: 3 vacant lots vs budget of 0. One eviction (lot 42, non-payment), two resident deaths (lots 18, 91). Currently marketing all three. Outlook: Expect to fill 2 of 3 within 60 days. Death-related vacancies typically longer to turn (home disposal). Action: Monitor fill rate. Consider home acquisition for lot 42 if not filled by March. ``` Utility Expense Unfavorable (Seasonal): ``` Utilities: Unfavorable variance of $4,200 (+35%) vs budget for Oak Ridge in January. Driver: Colder than normal January (15% more heating degree days vs 10-year average). Water main break on Jan 12 added $800 in emergency repairs and increased water loss. Outlook: Seasonal — will normalize in Q2. Water main issue is one-time. Action: Consider infrastructure audit if water main issues recur. ``` **Narrative quality checklist:** - [ ] **Specific:** Names the actual driver (not just "higher than expected") - [ ] **Quantified:** Includes dollar and percentage impact of each driver - [ ] **Causal:** Explains WHY it happened, not just WHAT happened - [ ] **Property-specific:** References the actual situation at that property - [ ] **Forward-looking:** States whether the variance is expected to continue - [ ] **Actionable:** Identifies any required follow-up - [ ] **Concise:** 2-4 sentences, not a paragraph of filler **Anti-patterns to avoid:** - "NOI was lower due to lower revenue" (circular — no explanation) - "Expenses were elevated this month" (vague — which expenses? why?) - "Timing" without specifying what and when it normalizes - "Seasonal" without explaining the seasonal pattern - "Various small items" for a material variance (must decompose) - Focusing only on the largest driver and ignoring offsetting items ### Waterfall Chart Methodology **Text-based waterfall format (when charting tools unavailable):** ``` WATERFALL: Portfolio NOI — January 2026 Actual vs Budget January Budget NOI $1,350,000 | |--[+] Lot rent increase capture +$42,000 |--[+] Higher utility pass-through recovery +$8,500 |--[-] Occupancy shortfall (5 units) -$12,500 |--[-] Higher R&M (weather-related) -$15,200 |--[-] Insurance premium increase -$4,800 |--[+] Payroll savings (vacancy) +$3,200 |--[-] Other (net) -$1,200 | January Actual NOI $1,370,000 Net Variance: +$20,000 (+1.5% favorable) ``` **Bridge reconciliation table:** | Driver | Amount | % of Variance | Cumulative | |--------|--------|---------------|------------| | Lot rent increase | +$42,000 | 210% | +$42,000 | | Utility recovery | +$8,500 | 43% | +$50,500 | | Occupancy shortfall | -$12,500 | -63% | +$38,000 | | R&M (weather) | -$15,200 | -76% | +$22,800 | | Insurance increase | -$4,800 | -24% | +$18,000 | | Payroll savings | +$3,200 | 16% | +$21,200 | | Other (net) | -$1,200 | -6% | +$20,000 | | **Total variance** | **+$20,000** | **100%** | | *Percentages can exceed 100% when there are offsetting items.* ### Revenue and Expense Decomposition for MHP **Revenue decomposition:** ``` Total Revenue Variance = Actual - Budget Decompose into: 1. Lot Rent variance (Rate x Occupancy) — primary driver 2. Utility Income variance (should track utility expense) 3. Late Fees variance (leading indicator of delinquency) 4. Application Fees variance (leading indicator of demand) 5. Other Income variance (storage, laundry, misc.) ``` **Expense decomposition:** ``` Total Expense Variance = Actual - Budget Decompose into: 1. Payroll (headcount x rate x hours) 2. Utilities (rate x consumption + seasonal adjustment) 3. R&M (routine vs capital vs emergency) 4. Insurance (premium change vs coverage change) 5. Property Taxes (assessment vs rate change) 6. Management Fees (% of revenue — should track revenue) 7. Professional Services (one-time vs recurring) ``` ### Budget vs Actual vs Forecast (Three-Way Analysis) | Metric | Budget | Forecast | Actual | Bud Var ($) | Bud Var (%) | Fcast Var ($) | Fcast Var (%) | |--------|--------|----------|--------|-------------|-------------|---------------|---------------| | Gross Revenue | $X | $X | $X | $X | X% | $X | X% | | Operating Expenses | $X | $X | $X | $X | X% | $X | X% | | NOI | $X | $X | $X | $X | X% | $X | X% | | NOI Margin | X% | X% | X% | Xpp | -- | Xpp | -- | **When to use each comparison:** - **Actual vs Budget:** Board reporting, investor updates, annual performance evaluation - **Actual vs Forecast:** Monthly operations review, L10 meetings - **Actual vs Prior Year:** Same-store analysis, growth tracking - **Actual vs Prior Month:** Trend identification, seasonal patterns --- ## 4. Month-End Close Process ### Close Calendar Overview **Current target: T+8. Goal: T+5.** | Day | Milestone | Owner | Dependencies | |-----|-----------|-------|--------------| | T+1 | RentManager month-end processing | Property Managers | None | | T+2 | Bank statement downloads | Finance | Banks post statements | | T+3 | RentManager-to-QBO sync verification | Finance | T+1 complete | | T+3 | Utility invoice entry | Property Managers | Bills received | | T+4 | Bank reconciliations | Mike | T+2 complete | | T+4 | AR subledger reconciliation | Finance | T+3 complete | | T+5 | Intercompany reconciliation | Finance | T+4 complete | | T+5 | Management fee calculation | Finance | T+1 complete | | T+6 | Accruals and adjusting entries | Mike | T+4, T+5 complete | | T+7 | Trial balance review | Mike | T+6 complete | | T+7 | KPI dashboard export | Carlos/Aurora | T+7 complete | | T+8 | Financial package to Sam | Mike | T+7 complete | **T = Last business day of the month** ### Close Acceleration Plan (T+8 to T+5) Key techniques to compress the close by 3 days: | Technique | Days Saved | Implementation | |-----------|-----------|----------------| | Pre-close activities (start recs before month-end) | 1-2 days | Begin bank recs on T-2 using mid-month cutoffs for preliminary work | | Full Bank Sync automation | 1 day | Eliminate manual statement downloads; auto-import via Plaid | | Parallel processing | 1 day | Run AR rec + bank rec + AP review simultaneously instead of sequentially | | Standardized accrual templates | 0.5 day | Pre-calculate recurring accruals; only adjust for changes | | Automated intercompany entries | 0.5 day | Script management fee calculations; auto-post to both sides | | Continuous close practices | 1 day | Post routine entries throughout the month; only exceptions at close | **Accelerated timeline (target T+5):** | Day | Milestone | Change from Current | |-----|-----------|-------------------| | T+0 | Pre-close: RM processing begins same day | Moved up from T+1 | | T+1 | Bank Sync auto-imports; AR rec starts | Parallel with RM | | T+2 | Bank recs + AR recs + AP review (parallel) | Compressed from T+2-T+4 | | T+3 | Intercompany + management fees + accruals | Compressed from T+5-T+6 | | T+4 | Trial balance review + adjustments | Moved up from T+7 | | T+5 | Financial package + KPI export | Moved up from T+8 | ### Close Checklist by Category #### 1. RentManager Processing (T+1) **Property Manager tasks:** - [ ] Process all move-ins/move-outs for the month - [ ] Enter all late fees - [ ] Process any NSF charges - [ ] Complete utility billing entries - [ ] Verify all charges posted for the month - [ ] Run month-end batch posting (if not real-time) **Verification:** - [ ] Occupancy count matches physical count - [ ] All recurring charges posted - [ ] No pending transactions in queue #### 2. Cash and Bank (T+2 to T+4) **Bank statement collection:** - [ ] Download Truist statements (operating + reserve) - [ ] Download Flagstar statements - [ ] Download Valley National statements - [ ] Download Five Star Bank statements - [ ] Download Old Second Bank statements **Bank reconciliations:** - [ ] Reconcile all operating accounts - [ ] Reconcile all reserve accounts - [ ] Identify and categorize reconciling items - [ ] Age outstanding items from prior periods - [ ] Prepare adjusting entries for bank fees/interest **Escalation triggers:** - Outstanding items > 60 days -> Mike review - Unidentified items > $1,000 -> Immediate investigation - Total reconciling items > $50,000 -> Sam notification #### 3. Accounts Receivable (T+3 to T+4) **RentManager AR:** - [ ] Pull Aged Receivables report as of month-end - [ ] Reconcile RM AR total to GL control account - [ ] Review AR aging (0-30, 31-60, 61-90, 90+) - [ ] Identify accounts for collection action - [ ] Review bad debt write-off candidates (90+ days) **Bad debt reserve:** - [ ] Calculate bad debt reserve per policy (see Section 5 for methodology) - [ ] Adjust reserve balance - [ ] Document any write-offs with approval #### 4. Accounts Payable (T+3 to T+5) **Invoice processing:** - [ ] Verify all month invoices entered in QBO - [ ] Accrue for known invoices not yet received - [ ] Review AP aging for duplicates or errors - [ ] Verify vendor payment terms compliance **Common accruals:** - Utility invoices (if not received by close) - Property tax accruals (monthly portion of annual) - Insurance accruals (if paid annually, spread monthly) - Professional services (legal, accounting — estimate if invoice pending) #### 5. Fixed Assets and Depreciation (T+5) - [ ] Record any new asset additions (improvements, infrastructure, homes) - [ ] Record any disposals (demolished homes, retired infrastructure) - [ ] Run monthly depreciation schedule - [ ] Reconcile fixed asset schedule to GL #### 6. Intercompany (T+5) **SCI to property LLC reconciliation:** - [ ] Calculate management fees (% of gross revenue per management agreement) - [ ] Verify all intercompany transactions recorded on both sides - [ ] Reconcile intercompany balances - [ ] Prepare elimination entries for consolidation **Management fee calculation:** ``` Management Fee = Gross Revenue x Management Fee % (Per property, per management agreement) ``` #### 7. Payroll and Benefits (T+5) - [ ] Verify all payroll entries posted for the month - [ ] Reconcile Paychex reports to GL - [ ] Accrue for any unpaid payroll/bonuses - [ ] Verify benefits expense properly allocated by property #### 8. Accruals and Adjusting Entries (T+6) **Standard accruals:** - [ ] Property tax accrual (1/12 of annual assessment) - [ ] Insurance accrual (if prepaid, amortize monthly) - [ ] Interest expense accrual (on loans, per amortization schedule) - [ ] Utility accruals (if invoices pending) - [ ] Legal/professional fee accruals **Reclassifications:** - [ ] Review items needing reclassification - [ ] Correct posting errors identified during recs - [ ] Ensure proper property allocation for shared costs #### 9. Trial Balance Review (T+7) **Balance sheet review:** - [ ] Cash accounts reconcile to bank recs - [ ] AR reconciles to RentManager aging - [ ] Fixed assets reconcile to depreciation schedule - [ ] Intercompany accounts net to zero - [ ] Loan balances agree to amortization schedules **Income statement review:** - [ ] Revenue reasonable for occupancy level - [ ] Expenses in line with budget/prior period - [ ] No unusual or unexplained items - [ ] Proper property allocation #### 10. Reporting Package (T+7 to T+8) **Internal reporting:** - [ ] Property P&Ls by property - [ ] Consolidated portfolio P&L - [ ] Balance sheet summary - [ ] Cash flow summary - [ ] Variance analysis (budget vs actual) - [ ] KPI dashboard update **KPI dashboard export:** - [ ] Run /run-monthly-workflow command - [ ] Verify occupancy numbers match RM - [ ] Verify revenue numbers match GL - [ ] Verify delinquency matches AR aging - [ ] Review automated validation checks ### Critical Path ``` [RentManager Processing] --> [AR Reconciliation] --> [Revenue Verification] | [Bank Statement Download] --> [Bank Reconciliation] --> [Cash Verification] | | [Invoice Entry] --> [AP Accruals] --> [Expense Verification] | [Trial Balance Review] | [Financial Package] | [KPI Dashboard Export] ``` ### Common Close Issues and Resolutions | Issue | Resolution | |-------|-----------| | RentManager not synced to QBO | Run manual sync, verify integration settings, check for failed transactions | | Bank statement not available | Check bank portal, contact bank if delayed, use online banking totals as placeholder | | AR does not reconcile to GL | Check for manual JEs in GL not in RM, verify batch posting complete, check timing | | Intercompany does not balance | Review management fee calculations, check for missing transactions on either side | | Unexpected variance to budget | Use variance analysis framework (Section 3), investigate drivers, document | | Divvy charges not posted | Wait for BILL sync cycle; manually enter if blocking close | | Paychex payroll not posted | Check Paychex-QBO integration; manually post summary entry if needed | ### Close Communication Protocol **Daily updates during close:** - Finance team updates close checklist daily - Blockers communicated to Mike immediately - Sam notified if close will be delayed past target **Close complete notification:** 1. Mike signs off on trial balance 2. Finance notifies Sam financial package is ready 3. Carlos/Aurora runs KPI dashboard export 4. Dashboard links sent to leadership ### Close Quality KPIs | Metric | Current | Target | Measure | |--------|---------|--------|---------| | Close completion | T+8 | T+5 | Days after month-end to final sign-off | | Adjusting entries | Track | < 10 | Count of post-close adjustments | | Reconciling items aged | Track | < $10K | Total items > 60 days | | First-pass accuracy | Track | 95%+ | % of accounts requiring no adjustments | | On-time close rate | Track | 100% | % of closes finished by target date | | Post-close adjustment rate | Track | < 2% | Entries made after "final" close | | Late journal entry rate | Track | < 5% | JEs posted after day-of-close cutoff | | Reconciliation completion rate | Track | 100% | All required recs completed by cutoff | --- ## 5. AP/AR Management ### Accounts Payable #### Invoice Processing Workflow ``` Invoice Received (email/mail/Divvy) | v Capture & Data Entry - Enter in QBO with correct vendor, amount, GL code, property allocation - Attach scanned invoice image - Code to correct property LLC | v Approval Routing - < $1,000: Property Manager approval - $1,000 - $10,000: Mike approval - > $10,000: Sam approval - Capital expenditures: Per CapEx approval matrix | v Payment Scheduling - Net 30 standard (pay on day 28-30) - Utility bills: Pay on receipt (avoid late fees/service interruption) - Insurance: Per payment schedule - Mortgage/loan: Per amortization schedule (never late) | v Payment Execution - ACH preferred (faster, cheaper, traceable) - Check for vendors without ACH - Wire for large/urgent payments (dual authorization required) | v Recording & Reconciliation - Match payment to invoice in QBO - Verify correct property allocation - File in AP aging ``` #### Divvy Credit Card Management **Setup best practices:** - Create virtual cards per vendor or expense category for budget control - Set monthly limits per card aligned to budget - QBO GL code integration for automatic categorization - Assign cards to appropriate property managers **Monthly close procedure for Divvy:** 1. Review all pending transactions by T+3 2. Verify GL coding and property allocation 3. Ensure all receipts attached 4. Reconcile Divvy statement to QBO credit card liability 5. Flag any unrecognized charges for investigation **Common coding issues:** - Charges coded to wrong property (shared vendor, wrong card used) - Missing receipts (require receipt attachment policy) - Split charges across properties not properly allocated - Personal charges on company card (immediate investigation) #### AP Best Practices - **Centralized intake:** All invoices flow to one email/portal; no invoices sitting in individual inboxes - **Three-way match:** Match PO (if applicable), receiving report, and invoice before payment - **Duplicate detection:** Check vendor + amount + date before entering; QBO flags some duplicates - **Vendor master file:** Maintain accurate vendor records with W-9 on file; annual 1099 review - **Payment terms optimization:** Negotiate Net 45 where possible; take early-pay discounts when cash allows (2/10 Net 30 = 36% annualized return) - **Segregation of duties:** Person entering invoices should not be the person approving or signing checks ### Accounts Receivable #### Tenant AR Aging Analysis | Aging Bucket | Expected % | Action | |-------------|-----------|--------| | 0-30 days | 85-90% | Current — monitor | | 31-60 days | 5-8% | Send collection notice; personal contact | | 61-90 days | 2-4% | Formal demand letter; payment plan offer | | 90+ days | 1-3% | Eviction consideration; bad debt reserve candidate | #### Bad Debt Methodology **GAAP requirement:** Under ASC 326 (CECL), use expected credit loss model. For non-public entities (Sunrise), simplified approach is acceptable. **Sunrise bad debt policy options:** **Option A: Percentage of AR method (current)** ``` Bad Debt Reserve = Total AR x 2% (Adjusted quarterly based on actual write-off experience) ``` **Option B: Aging-based specific reserve (recommended upgrade)** ``` 0-30 days: x 1% = $___ 31-60 days: x 5% = $___ 61-90 days: x 25% = $___ 90+ days: x 75% = $___ ------ Total reserve: $___ ``` **Option C: Specific identification + general reserve** ``` Specific reserves: Identify accounts with known collectibility issues + Tenant in eviction process: 90% reserve + Tenant on payment plan (current): 10% reserve + Tenant on payment plan (delinquent): 50% reserve + Tenant deceased/abandoned: 100% reserve General reserve: Remaining AR x 2% Total = Specific + General ``` **Write-off procedure:** 1. Account must be 90+ days delinquent (or vacated/abandoned) 2. All collection efforts documented and exhausted 3. Mike approves write-off (> $1,000 requires Sam approval) 4. Debit: Bad Debt Expense; Credit: Accounts Receivable 5. Reduce bad debt reserve accordingly 6. Maintain record for potential future collection or tax deduction #### Collections Integration with RentManager RentManager drives the collections workflow: 1. Automated late fee posting (per lease terms and state law) 2. Automated past-due notices at 5, 15, 30 days 3. Payment plan tracking within RM 4. Eviction flag triggers in RM when thresholds met 5. Write-off candidates identified via aging report --- ## 6. Intercompany Accounting ### Management Fee Structure **Calculation method:** ``` Monthly Management Fee = Gross Revenue x Management Fee % ``` **Fee percentages (typical for MHP industry):** - 100+ units: 3-5% of gross revenue - 50-100 units: 5-7% of gross revenue - Under 50 units: 7-10% of gross revenue - Note: Actual percentages per Sunrise management agreements; verify each property **"Gross revenue" definition (per management agreement):** - Include: Lot rent, utility income, late fees, application fees, storage income - Exclude (typically): Capital contributions, loan proceeds, insurance proceeds, security deposits **Recording:** - On SCI books: Debit Intercompany Receivable, Credit Management Fee Income - On LLC books: Debit Management Fee Expense, Credit Intercompany Payable - Amounts MUST match dollar-for-dollar on both sides ### Shared Cost Allocation When SCI incurs costs on behalf of multiple property LLCs (corporate overhead, insurance, legal, technology): **Allocation methods:** | Method | Best For | Formula | |--------|----------|---------| | Pro-rata by units | Headcount-driven costs (HR, training) | Entity units / total units | | Pro-rata by revenue | Revenue-driven costs (management oversight) | Entity revenue / total revenue | | Pro-rata by NOI | Profit-driven costs (incentive comp) | Entity NOI / total NOI | | Direct assignment | Property-specific costs | 100% to benefiting property | | Equal share | Fixed costs independent of size | 1 / number of entities | **Common shared costs at Sunrise:** - Corporate office rent and overhead -> pro-rata by units or revenue - D&O insurance -> equal share or pro-rata by asset value - Legal retainer -> pro-rata by revenue; direct for property-specific matters - Technology/software (QBO, RM licenses) -> direct per user/property - Accounting/audit fees -> pro-rata by revenue or equal share **Documentation requirements:** - Written cost allocation policy reviewed annually - Allocation methodology must be reasonable and consistently applied - Intercompany invoices with supporting calculations - Arm's-length standard: fees should reflect market rates ### Intercompany Elimination Procedures **Required under ASC 810 for consolidated reporting:** All intercompany transactions must be eliminated so consolidated statements reflect only external activity. **Types of eliminations:** 1. **Revenue/Expense elimination:** - Eliminate management fee income on SCI books against management fee expense on LLC books - Eliminate any intercompany service revenue/cost 2. **Receivable/Payable elimination:** - Eliminate intercompany receivable on SCI against intercompany payable on LLC - Must net to zero; any imbalance indicates a recording error 3. **Equity/Investment elimination:** - Eliminate SCI's investment in subsidiary LLCs against LLC equity - Record minority interest (LP shares) if applicable **Elimination journal entries (at consolidation level):** ``` Eliminate management fees: DR Management Fee Income (SCI) $XX,XXX CR Management Fee Expense (LLC) $XX,XXX Eliminate intercompany balances: DR Intercompany Payable (LLC) $XX,XXX CR Intercompany Receivable (SCI) $XX,XXX Eliminate equity investment: DR Members' Equity (LLC) $XX,XXX CR Investment in Subsidiary (SCI) $XX,XXX CR Minority Interest $XX,XXX (LP share) ``` **QBO limitation:** Eliminations cannot be done within QBO. They must be performed in an external consolidation workbook (Google Sheets or consolidation software). Maintain a separate "Elimination" column in the consolidation worksheet. ### Fund-Level Consolidation Workflow 1. **Export trial balances** from each QBO entity (SCI + all LLCs) 2. **Map accounts** to standardized chart of accounts (if any variations exist) 3. **Aggregate** all entity balances into consolidation worksheet 4. **Calculate eliminations** for intercompany items 5. **Post elimination entries** in consolidation worksheet (not in individual QBO files) 6. **Generate consolidated financial statements** from adjusted totals 7. **Reconcile** consolidated cash to sum of all bank reconciliations 8. **Review** for reasonableness and intercompany balance = zero check --- ## 7. Investor Distributions ### Distribution Waterfall Framework **Standard real estate PE waterfall structure (4 tiers):** ``` Tier 1: Return of Capital - 100% to LPs until all contributed capital is returned Tier 2: Preferred Return - 100% to LPs until cumulative preferred return achieved - Typical pref: 8% annually (compounding per OA terms) - Accrues if not paid; unpaid pref carries forward Tier 3: GP Catch-Up - 100% (or 50%) to GP until GP has received its promote % of all distributions to date - Example: If GP promote = 20%, catch-up continues until GP has 20% of total distributions (Tiers 1+2+3) Tier 4: Residual Split - Split between LP and GP per operating agreement - Common: 80/20 LP/GP - May have additional tiers (e.g., above 15% IRR: 70/30) ``` **CRITICAL: Read the operating agreement.** Every fund/deal may have different terms. The above is a common framework but actual waterfall terms vary. Legal review required. ### Preferred Return Calculation ``` Preferred Return = Capital Contribution x Pref Rate x (Days in Period / 365) Example: LP contributed $1,000,000 on January 1 Pref rate: 8% annually Q1 calculation: $1,000,000 x 8% x (90/365) = $19,726 Cumulative tracking: - Track cumulative pref earned vs cumulative pref paid - Shortfall carries forward (accrued but unpaid pref) - Some OAs compound unpaid pref; some do not (critical distinction) ``` **Common calculation errors to avoid:** - Failing to prorate for partial periods (mid-quarter contribution) - Not tracking cumulative pref vs. paid pref separately - Misinterpreting compounding vs. simple interest - Not accounting for capital returned when calculating pref base - GP catch-up miscalculation: must gross up to arrive at GP's share of TOTAL distributions ### Distribution Timing and Process **Quarterly distribution process:** 1. Complete quarterly close (monthly close x3 + quarterly adjustments) 2. Calculate distributable cash: Net cash flow - required reserves - debt service 3. Run waterfall calculation per operating agreement 4. Prepare distribution schedule showing each investor's share 5. Mike reviews calculations; Sam approves distribution 6. Wire distributions to investor accounts 7. Post distribution entries: Debit Members' Equity, Credit Cash 8. Issue K-1 supporting schedules (annual, but track quarterly) **Distribution reserve considerations:** - Maintain minimum operating reserve (per lender requirements + prudent buffer) - CapEx reserve for planned improvements - Tax reserve for property tax payments - Insurance reserve for annual premiums - Working capital buffer (typically 1-2 months of operating expenses) ### Investor Reporting Package (Quarterly) | Component | Content | |-----------|---------| | Cover letter | Summary of period performance, highlights, outlook | | Property P&L | Revenue, expenses, NOI by property | | Consolidated P&L | Portfolio-level summary | | Distribution detail | Waterfall calculation, investor-by-investor amounts | | Capital account statement | Beginning balance, contributions, distributions, income allocation, ending balance | | Occupancy report | By property, trend vs. prior quarter | | Variance narrative | Budget vs. actual with driver explanations | --- ## 8. Accruals and Adjusting Entries ### Property Tax Accrual **Method:** Accrue 1/12 of estimated annual property tax each month. ``` Monthly accrual = Annual estimated property tax / 12 DR Property Tax Expense $X,XXX CR Property Tax Payable $X,XXX ``` **Adjustment triggers:** - New tax bill received: adjust remaining months to true up - Assessment appeal filed: continue accruing at current rate until outcome known - Assessment appeal won: adjust accrual and record refund receivable - Reassessment after acquisition: expect 12-24 month lag; accrue at expected (higher) rate **Property tax appeal process (for cost savings):** 1. Review annual assessment notice within 30-60 day appeal window 2. Compare assessed value to recent comparable sales and income approach value 3. Income approach: NOI / Market Cap Rate = Indicated Value 4. If assessed value exceeds indicated value by >10%, appeal is likely worthwhile 5. Engage property tax consultant (contingency fee: 25-40% of first-year savings) 6. File appeal with county board of equalization/review 7. Continue accruing at current assessment until appeal resolved 8. Record any refund as reduction to property tax expense when received **MHP-specific consideration:** Assessors sometimes reassess manufactured housing communities at higher values 1-2 years after acquisition, especially after lot rent increases become public. Budget for potential increases. ### Insurance Accrual **Method:** If paid annually, spread to monthly expense. ``` Monthly accrual = Annual premium / 12 At payment: DR Prepaid Insurance $XX,XXX CR Cash $XX,XXX Monthly: DR Insurance Expense $X,XXX CR Prepaid Insurance $X,XXX ``` **Common insurance types for MHP:** - Property/casualty (including flood if in zone) - General liability - Workers' compensation - Directors & Officers (D&O) — allocated across entities - Umbrella/excess liability - Rent loss/business interruption ### Interest Expense Accrual **Method:** Accrue interest on all outstanding loans based on amortization schedule. ``` Monthly accrual: DR Interest Expense $X,XXX CR Accrued Interest $X,XXX When payment made: DR Accrued Interest $X,XXX DR Loan Principal $X,XXX CR Cash $XX,XXX ``` **Track per loan:** Each property LLC typically has its own mortgage. SCI may have corporate lines of credit. Reconcile loan balance to amortization schedule monthly. ### Utility Accrual **Method:** Accrue for utility invoices not yet received at close. ``` Estimate = Prior month actual +/- seasonal adjustment DR Utilities Expense $X,XXX CR Accrued Utilities $X,XXX When invoice received: DR Accrued Utilities $X,XXX DR/CR Utilities Expense $XXX (true-up to actual) CR Accounts Payable $X,XXX ``` **Sunrise-specific:** Utility billing is a significant line item for MHPs (master-metered communities bill back to tenants). Accrue both expense (utility company invoice) and income (tenant utility billing) if either is pending at close. ### Straight-Line Rent Adjustments For leases with rent escalations (primarily commercial leases or long-term lot leases with scheduled increases): ``` Straight-line monthly rent = Total rent over lease term / Number of months If cash rent differs from straight-line rent: DR Tenant Receivable (straight-line) $XXX CR Rental Revenue $XXX ``` **MHP note:** Most residential lot leases are month-to-month or annual, so straight-line adjustments are uncommon. However, if any commercial leases exist on the property (cell tower, billboard, retail pad), straight-line rent recognition applies under ASC 842. ### Depreciation **Asset categories and useful lives (MHP-specific):** | Asset Category | Useful Life | Method | |---------------|-------------|--------| | Land improvements (roads, pads) | 15 years | Straight-line | | Infrastructure (water/sewer) | 15-20 years | Straight-line | | Buildings (clubhouse, office) | 27.5-39 years | Straight-line | | Park-owned homes (POH) | 15-27.5 years | Straight-line | | Equipment and vehicles | 5-7 years | Straight-line or MACRS | | Furniture and fixtures | 5-7 years | Straight-line | **Capital vs. expense threshold:** Establish a capitalization threshold (e.g., $2,500 or $5,000). Items below threshold are expensed. Items above are capitalized and depreciated. Document policy and apply consistently. --- ## 9. Financial Reporting ### Property P&L Format ``` [PROPERTY NAME] — Income Statement For the Month/Quarter/Year Ended [Date] Actual Budget Variance Var % REVENUE Lot Rent $XXX $XXX $XXX X% Utility Income $XXX $XXX $XXX X% Late Fees $XXX $XXX $XXX X% Application Fees $XXX $XXX $XXX X% Other Income $XXX $XXX $XXX X% ------- ------- ------- TOTAL REVENUE $XXX $XXX $XXX X% OPERATING EXPENSES Payroll & Benefits $XXX $XXX $XXX X% Utilities $XXX $XXX $XXX X% Repairs & Maintenance $XXX $XXX $XXX X% Insurance $XXX $XXX $XXX X% Property Taxes $XXX $XXX $XXX X% Management Fees $XXX $XXX $XXX X% Professional Services $XXX $XXX $XXX X% Administrative $XXX $XXX $XXX X% Marketing $XXX $XXX $XXX X% Bad Debt Expense $XXX $XXX $XXX X% Other Operating $XXX $XXX $XXX X% ------- ------- ------- TOTAL OPERATING EXPENSES $XXX $XXX $XXX X% NET OPERATING INCOME (NOI) $XXX $XXX $XXX X% NOI MARGIN XX% XX% BELOW-THE-LINE Debt Service (P&I) $XXX Capital Expenditures $XXX Distributions $XXX ------- NET CASH FLOW $XXX ``` ### Consolidated Portfolio P&L Same format as property P&L but aggregated across all properties with: - Property-by-property breakdown columns - Elimination column (intercompany management fees) - Consolidated total column - Same-store vs. all-in breakout ### Balance Sheet Summary ``` [ENTITY NAME] — Balance Sheet As of [Date] ASSETS Cash and Cash Equivalents $XXX (reconciles to bank recs) Accounts Receivable (net) $XXX (reconciles to RM aging minus reserve) Prepaid Expenses $XXX (insurance, property tax, etc.) Intercompany Receivable $XXX (SCI only; eliminated in consolidation) Fixed Assets (net) $XXX (reconciles to depreciation schedule) Other Assets $XXX ------- TOTAL ASSETS $XXX LIABILITIES Accounts Payable $XXX Accrued Expenses $XXX (property tax, interest, utilities) Intercompany Payable $XXX (LLCs only; eliminated in consolidation) Security Deposits $XXX Mortgage Payable $XXX (reconciles to amortization schedule) Other Liabilities $XXX ------- TOTAL LIABILITIES $XXX MEMBERS' EQUITY Members' Capital $XXX Retained Earnings $XXX ------- TOTAL MEMBERS' EQUITY $XXX TOTAL LIABILITIES + EQUITY $XXX (must equal Total Assets) ``` ### Cash Flow Summary ``` OPERATING ACTIVITIES Net Income $XXX Adjustments: Depreciation $XXX Change in AR $XXX Change in AP $XXX Change in Accrued Expenses $XXX ------- Net Cash from Operations $XXX INVESTING ACTIVITIES Capital Expenditures ($XXX) Home Purchases (POH) ($XXX) Proceeds from Home Sales $XXX ------- Net Cash from Investing ($XXX) FINANCING ACTIVITIES Loan Proceeds $XXX Principal Payments ($XXX) Capital Contributions $XXX Distributions ($XXX) ------- Net Cash from Financing ($XXX) NET CHANGE IN CASH $XXX Beginning Cash Balance $XXX Ending Cash Balance $XXX (reconciles to bank recs) ``` ### KPI Dashboard Metrics Key metrics exported monthly via /run-monthly-workflow: - Occupancy rate (physical and economic) - Collection rate - Average lot rent and loss-to-lease - NOI and NOI margin - Delinquency rate and aging breakdown - Revenue per occupied lot - Expense per lot (total and by category) - Same-store NOI growth - CapEx per lot --- ## 10. Internal Controls (COSO Framework) ### COSO Applied to Sunrise Operations The COSO 2013 framework has five components. Here is how each applies to MHP property management: **1. Control Environment** - Tone at the top: Sam/leadership commitment to accurate financial reporting - Written policies: AP approval matrix, bank rec procedures, close checklist - Segregation of duties: Person processing transactions is not the person reconciling - Competence: Finance team trained on QBO, RM, and MHP-specific accounting **2. Risk Assessment** - Identify financial reporting risks: revenue recognition timing, expense classification, intercompany accuracy, cash handling - Fraud risk factors: cash-intensive business (rent collections), dispersed properties, limited staff - Key risks for MHP: tenant fraud (identity), vendor kickbacks, misclassified CapEx vs. expense **3. Control Activities** - Preventive controls: approval workflows, budget limits, dual signatures on wires/checks > $10K - Detective controls: bank reconciliations, variance analysis, AR aging review, surprise audits - IT controls: QBO access controls, RM user permissions, Divvy card limits **4. Information and Communication** - Close checklist shared across team with real-time status updates - Escalation thresholds defined and communicated (see Section 2) - Monthly financial package distributed to leadership by target date **5. Monitoring** - Close quality KPIs tracked monthly (Section 4) - Quarterly review of internal controls effectiveness - Annual external audit (if required by lenders or investors) - Periodic surprise cash counts and petty cash audits ### Key Controls Matrix | Process | Control | Type | Frequency | Owner | |---------|---------|------|-----------|-------| | Cash receipts | Bank rec to GL | Detective | Monthly | Mike | | Cash disbursements | Dual approval > $10K | Preventive | Per transaction | Mike/Sam | | Revenue | RM-to-GL reconciliation | Detective | Monthly | Finance | | Payroll | Paychex-to-GL reconciliation | Detective | Monthly | Finance | | Expense coding | Divvy GL code integration | Preventive | Per transaction | Property Mgr | | Intercompany | IC balance reconciliation | Detective | Monthly | Finance | | Financial reporting | Trial balance review | Detective | Monthly | Mike | | Credit cards | Divvy receipt attachment policy | Preventive | Per transaction | Cardholders | | Wire transfers | Dual authorization required | Preventive | Per transaction | Mike + Sam | ### Segregation of Duties | Function | Should NOT also perform | |----------|----------------------| | Processes invoices (AP entry) | Approves invoices, signs checks | | Collects rent (cash/check handling) | Posts rent to tenant accounts | | Reconciles bank accounts | Processes payments or deposits | | Approves vendor setup | Processes vendor payments | | Runs payroll | Approves payroll changes | **Small team reality:** With a lean finance team, perfect segregation is difficult. Compensating controls include: - Mike reviews all bank recs (even if finance prepares them) - Sam reviews and approves all distributions and large payments - External accountant reviews quarterly (independent check) - Surprise audits of petty cash and check stock --- ## 11. GAAP for MHP Operations ### ASC 842 (Leases) — Impact on MHPs **Sunrise as Lessor (lot leases to residents):** - Lessor accounting largely unchanged under ASC 842 - Lot leases classified as operating leases (tenant does not own/control the land) - Revenue recognized straight-line over lease term - Most MHP lot leases are month-to-month or annual; straight-line adjustment minimal - Initial direct costs (application processing, lease prep) capitalized and amortized over lease term - Collect-ability assessment required at inception: if not probable, lease payments recognized as received **Sunrise as Lessee (ground leases, office leases, equipment):** - If Sunrise leases any office space, equipment, or holds a ground lease: ASC 842 requires right-of-use (ROU) asset and lease liability on balance sheet - Operating leases: straight-line expense over term; ROU asset and lease liability recognized - Finance leases: front-loaded expense (interest + amortization); similar to loan treatment - Short-term lease exemption: leases < 12 months with no purchase option can be excluded - Practical expedient: portfolio approach for large number of similar leases **Key exemption:** Land-only leases where Sunrise is lessor (the core lot lease business) do not create lessee-side balance sheet entries. They remain operating lease income on the income statement. ### ASC 810 (Consolidation) - Determines which entities must be consolidated in financial statements - Variable Interest Entity (VIE) analysis: If SCI is the primary beneficiary of a property LLC (has power + economics), consolidation is required - Typical MHP structure: SCI as GP with controlling interest = consolidation required - Minority interest (LP share) reported as separate equity line in consolidated statements ### ASC 326 (Credit Losses / CECL) - Requires expected credit loss model for financial assets (including tenant receivables) - Non-public entities had extended adoption timeline (now effective) - For Sunrise: apply to tenant AR using aging-based reserve methodology (see Section 5) - Requires forward-looking estimate, not just historical loss rate ### Revenue Recognition (ASC 606 vs. ASC 842) - Lot rent = lease income under ASC 842 (not ASC 606) - Utility pass-through income: if lessor-controlled, treat as lease component (ASC 842). If tenant-controlled, may be non-lease component under ASC 606 - Late fees, application fees, other service income = ASC 606 (recognize when earned) - Home sales (POH sold to tenants) = ASC 606 (recognize at closing) --- ## 12. Decision Trees ### Variance Investigation Decision Tree ``` Is the variance above materiality threshold? | NO --> Document "within threshold, no investigation required" YES | v Is this a known/expected variance? | YES --> Document the known reason (rent increase, seasonal, etc.) Is the actual amount within 10% of the expected impact? YES --> Close with narrative NO --> Investigate the delta between expected and actual NO | v Is the variance in a single line item or spread across items? | SINGLE --> Deep-dive that line item (see decomposition framework) SPREAD --> Check for misclassification or systemic issue | v Is the driver a one-time event or recurring? | ONE-TIME --> Document, no forecast adjustment RECURRING --> Update forecast + investigate root cause | v Does this require management action? | YES --> Document action item with owner and due date NO --> Document "monitoring only" with next review date ``` ### Close Blocker Resolution Decision Tree ``` What is blocking the close? | +-- Missing bank statement | --> Check bank portal | --> Use online balance as placeholder | --> Finalize rec when statement arrives | +-- RM not synced to QBO | --> Run manual sync | --> Check for failed transactions | --> If sync broken, post summary JE manually | +-- AR does not reconcile | --> Check for manual JEs in QBO not in RM | --> Check batch posting status | --> Check for write-offs in one system only | --> Quantify difference: if < $500 and explainable, proceed | +-- Missing invoice for accrual | --> Estimate based on prior period + known changes | --> Accrue estimated amount | --> True up when invoice received | +-- Intercompany imbalance | --> Verify management fee calculations match | --> Check for missing entries on either side | --> Must resolve to zero before consolidation | +-- Waiting on third party (bank, vendor, etc.) --> Set deadline for resolution --> If past deadline, estimate and accrue --> True up in next period ``` ### Accrual Decision Tree ``` Is the expense known but invoice not received? | YES --> Accrue at estimated amount (prior period + adjustments) | NO --> Is there a contractual obligation for this period? | YES --> Accrue per contract terms (loan interest, insurance, tax) NO --> Is it probable and estimable? | YES --> Accrue best estimate with disclosure NO --> Do not accrue; consider disclosure if material ``` ### Capital vs. Expense Decision Tree ``` Does the expenditure exceed the capitalization threshold ($2,500)? | NO --> Expense immediately YES | v Does it extend the useful life or add new capability? | YES --> Capitalize and depreciate over useful life NO | v Does it maintain existing condition/functionality? | YES --> Expense as repair and maintenance NO --> Consult with Mike; likely capitalize ``` --- ## 13. Common Gotchas ### QBO-RentManager Sync Issues | Issue | Symptom | Fix | |-------|---------|-----| | Sync lag | GL balances behind RM by 1-3 days | Wait for sync cycle; verify sync schedule | | Failed transactions | RM shows posted, QBO does not | Check sync error log; manually post if needed | | Duplicate entries | Same transaction in QBO twice | Delete duplicate; check sync matching rules | | Account mapping error | Revenue posted to wrong GL account | Fix mapping in integration settings; reclassify | | Chart of accounts mismatch | New RM charge type not mapped to QBO | Add mapping before posting transactions | ### Timing Issues | Issue | Impact | Prevention | |-------|--------|-----------| | ACH rent collected last day of month | May not clear bank until next month | Track as deposit in transit; do not double-count | | Divvy charges span month-end | Charges posted in wrong period | Review Divvy pending at close; accrue if needed | | Payroll period does not align with month | Payroll expense split across months | Accrue stub period payroll at month-end | | Utility bills received after close | Expense understated in closed month | Accrue based on estimate; true up next month | | Management fees calculated after revenue is final | IC entries lag close | Calculate fees as soon as revenue is finalized | ### Common Misclassification Errors | Error | Impact | How to Catch | |-------|--------|-------------| | CapEx coded as R&M expense | Understates assets, overstates expense | Review R&M entries > $2,500 threshold | | Security deposit refund coded as expense | Overstates expense | Review deposit liability account monthly | | Loan principal coded as expense | Overstates expense, understates debt | Reconcile loan balance to amortization schedule | | Intercompany transfer coded as revenue | Overstates revenue | IC revenue should only be management fees | | Tenant credit coded as bad debt | Overstates bad debt | Bad debt should only be write-offs, not credits | | Insurance proceeds coded as revenue | Overstates operating revenue | Should be below-the-line or offset to loss | ### Multi-Entity Pitfalls | Pitfall | Prevention | |---------|-----------| | Posting to wrong entity's QBO file | Verify entity before every entry; use naming conventions | | Inconsistent chart of accounts across entities | Maintain master COA; sync all entities quarterly | | Intercompany transactions recorded on one side only | Reconcile IC accounts monthly; both sides must match | | Consolidation without eliminations | Always run elimination entries; IC should net to zero | | Different accounting policies across entities | Document policies centrally; apply consistently | --- ## 14. Procedures ### Month-End Close Step-by-Step (Detailed) **Pre-Close (T-3 to T-1):** 1. Send close reminder to property managers: "Complete all RM entries by T+1" 2. Review prior month's open items — any still outstanding? 3. Pre-calculate recurring accruals (property tax, insurance, interest) 4. Verify RM sync is running without errors 5. Download mid-month bank activity for preliminary rec work **Close Week (T+1 to T+5 target):** *Day T+1:* 1. Property managers confirm RM month-end processing complete 2. Finance verifies RM-to-QBO sync is current 3. Download final bank statements (all banks, all accounts) 4. Begin bank reconciliations (operating accounts first) *Day T+2:* 5. Complete all bank reconciliations 6. Begin AR subledger reconciliation (RM aging to GL) 7. Review and enter any remaining AP invoices 8. Process Divvy reconciliation *Day T+3:* 9. Complete AR reconciliation 10. Calculate and post management fees (SCI + LLCs) 11. Post intercompany entries on both sides 12. Begin intercompany reconciliation 13. Review AP aging for accrual needs *Day T+4:* 14. Complete intercompany reconciliation (must net to zero) 15. Post all accruals (property tax, insurance, interest, utilities, payroll) 16. Post depreciation entries 17. Review fixed asset schedule 18. Reconcile Paychex payroll to GL *Day T+5:* 19. Mike reviews trial balance for each entity 20. Mike posts any final adjusting entries 21. Run property P&Ls and variance analysis 22. Prepare consolidated financial statements with eliminations 23. Prepare financial package for Sam 24. Run KPI dashboard export (/run-monthly-workflow) 25. Distribute financial package and dashboard links **Post-Close:** 26. Log close completion date and any issues encountered 27. Update close quality KPIs 28. Document any items to carry forward to next month 29. File all supporting documentation (recs, statements, workpapers) ### Quarterly Close Additions In addition to monthly close, add these quarterly procedures: 1. **Bad debt reserve review:** Reassess reserve adequacy based on actual write-off experience 2. **Prepaid expense review:** Verify prepaid balances are amortizing correctly 3. **Loan covenant compliance:** Calculate and document compliance with lender covenants (DSCR, LTV, etc.) 4. **Investor distribution calculation:** Run waterfall per operating agreement 5. **Capital account reconciliation:** Update each investor's capital account (contributions, distributions, allocations) 6. **Property tax review:** Compare accrual to actual bills; adjust if needed 7. **Insurance policy review:** Verify coverage is current and premiums are as expected 8. **Consolidated financial statements:** Full consolidation with eliminations and minority interest 9. **Prepare investor reporting package:** Property P&Ls, consolidated P&L, distribution detail, capital account statements, occupancy, variance narratives ### Year-End Close Additions In addition to quarterly close: 1. **Tax return preparation:** Gather data for CPA; property-level Schedule E or partnership returns 2. **K-1 preparation:** Investor-level tax reporting for each LLC 3. **1099 preparation:** Vendor payments > $600; verify W-9s on file 4. **Fixed asset review:** Verify asset register matches physical assets; identify disposals 5. **Depreciation schedules:** Final year-end run; reconcile to tax depreciation if different from book 6. **Operating agreement review:** Verify compliance with all OA terms (distributions, reporting, etc.) 7. **Budget preparation:** Build next-year budget using current-year actuals and strategic plan 8. **Audit preparation (if applicable):** Prepare schedules, support, and confirmations per auditor request 9. **Entity annual filings:** State registrations, registered agent confirmations --- ## 15. Output Formats ### Reconciliation Report Format ``` ========================================================================= BANK RECONCILIATION REPORT Entity: [Entity Name] Account: [Bank Name - Account Number (last 4)] Period: [Month/Year] Prepared by: [Name] Date: [Date] Reviewed by: [Name] Date: [Date] ========================================================================= SECTION 1: RECONCILIATION SUMMARY Bank Statement Balance: $XX,XXX.XX GL Cash Balance: $XX,XXX.XX Adjusted Difference: $0.00 SECTION 2: OUTSTANDING CHECKS Check # Date Payee Amount ------ -------- ---------------- --------- 4521 01/15/26 ABC Vendor $1,250.00 4533 01/22/26 XYZ Supply $875.00 --------- Total Outstanding Checks: $2,125.00 SECTION 3: DEPOSITS IN TRANSIT Description Date Amount ------------------- -------- --------- ACH Rent - January 01/31/26 $3,400.00 --------- Total Deposits in Transit: $3,400.00 SECTION 4: ADJUSTING ENTRIES REQUIRED # Description DR Account CR Account Amount -- ---------------------- ----------- ----------- -------- 1 January bank fees Bank Fees Cash $45.00 2 January interest Cash Int Income $12.50 SECTION 5: ITEMS REQUIRING INVESTIGATION # Description Amount Age Status -- ---------------------- --------- ------ -------- (none this period) SECTION 6: AGING OF RECONCILING ITEMS 0-30 days: $2,125.00 (2 items) 31-60 days: $0.00 (0 items) 61-90 days: $0.00 (0 items) 90+ days: $0.00 (0 items) SECTION 7: SIGN-OFF [ ] Reconciliation complete and accurate [ ] All adjusting entries posted [ ] No items require escalation Preparer Signature: ___________________ Date: ________ Reviewer Signature: ___________________ Date: ________ ========================================================================= ``` ### Variance Narrative Format ``` ========================================================================= VARIANCE ANALYSIS — [Property/Portfolio Name] Period: [Month Year] Comparison: [Actual vs Budget / Actual vs Prior Year] Prepared by: [Name] Date: [Date] ========================================================================= EXECUTIVE SUMMARY NOI: [Favorable/Unfavorable] variance of $[amount] ([X]%) Primary drivers: [1-2 sentence summary] WATERFALL: Budget/Prior NOI $XXX,XXX [+/-] [Driver 1] +/-$XX,XXX [+/-] [Driver 2] +/-$XX,XXX [+/-] [Driver 3] +/-$XX,XXX Actual NOI $XXX,XXX DETAILED NARRATIVES: [Line Item 1]: [Full narrative per template] [Line Item 2]: [Full narrative per template] ACTION ITEMS: # Action Owner Due Date Status -- ---------------------- ------ --------- -------- 1 [Action description] [Name] [Date] Open ========================================================================= ``` ### Close Status Dashboard Format ``` ========================================================================= MONTH-END CLOSE STATUS — [Month Year] As of: [Current Date] | Target: T+5 | Current Day: T+[X] ========================================================================= OVERALL STATUS: [ON TRACK / AT RISK / DELAYED] TASK STATUS: Task Status Owner Due Complete --------------------------- -------- ------ ----- -------- RM Month-End Processing Done PMs T+1 T+1 Bank Statement Download Done Finance T+2 T+2 Bank Reconciliations In Prog Mike T+2 -- AR Subledger Reconciliation Pending Finance T+2 -- AP Invoice Review Pending Finance T+3 -- Intercompany Reconciliation Pending Finance T+3 -- Accruals & Adjustments Pending Mike T+4 -- Trial Balance Review Pending Mike T+4 -- Financial Package Pending Mike T+5 -- KPI Dashboard Export Pending Carlos T+5 -- BLOCKERS: # Description Impact Resolution Plan -- --------------------------- -------- ---------------- (none currently) NOTES: - [Any relevant notes about this close cycle] ========================================================================= ``` --- ## 16. References ### GAAP Standards - ASC 842 — Leases (lessor and lessee accounting) - ASC 810 — Consolidation (multi-entity, VIE analysis) - ASC 326 — Financial Instruments: Credit Losses (CECL, bad debt reserves) - ASC 606 — Revenue from Contracts with Customers (non-lease income) - ASC 360 — Property, Plant, and Equipment (fixed assets, depreciation) - COSO 2013 — Internal Control: Integrated Framework ### Sunrise Internal References - DATA_DICTIONARY.md — `/Operations/data-pipeline-consolidation/DATA_DICTIONARY.md` - calculations.py — `/rentmanager-mcp/calculations.py` (canonical KPI calculation functions) - validation.py — `/rentmanager-mcp/validation.py` (pre-export data validation) - export_monthly_kpi_dashboard.py — `/rentmanager-mcp/export_monthly_kpi_dashboard.py` - export_occupancy_dashboard.py — `/rentmanager-mcp/export_occupancy_dashboard.py` - rm-accounting-expert skill — `.claude/skills/rm-accounting-expert/` (GL codes, revenue recognition) - mhp-operations-expert skill — `.claude/skills/mhp-operations-expert/` (utilities, infrastructure, POH/TOH) ### Related Skills - reconciliation (merged into this file) - variance-analysis (merged into this file) - close-management (merged into this file) - rm-accounting-expert (GL codes, chart of accounts, revenue recognition details) - mhp-operations-expert (operational context for expense drivers) > **Workflow handoffs — Acquisition pipeline:** `mhp-acquisitions-expert` (deal analysis, DD) → `entity-formation` (LLC setup, bank accounts) → `finance-operations-expert` (accounting setup, QBO entity, opening entries) → `insurance-risk-expert` (coverage placement) → `mhp-operations-expert` (100-day integration) ### Source Skills Preserved All content from the following source skills has been preserved and expanded in this document: - `.claude/skills/finance/reconciliation/SKILL.md` — bank rec procedures, Sunrise bank environment, intercompany - `.claude/skills/finance/variance-analysis/SKILL.md` — NOI decomposition, materiality thresholds, narrative templates - `.claude/skills/finance/close-management/SKILL.md` — month-end close checklist, timeline, critical path ### Research Sources (March 2026) - FinQuery — ASC 842 lease accounting guide - Intuit/QuickBooks — Multi-entity consolidation patterns, intercompany eliminations - COSO.org — Internal Control: Integrated Framework - EisnerAmper — Waterfall calculations, GP catch-up mechanics - HighRadius — Bank reconciliation automation, month-end close process - RentManager — Bank Sync integration (Plaid) - BILL/Divvy — Expense management, QBO integration - CLA/CBIZ — Property tax assessment appeals - PwC Viewpoint — Intercompany elimination procedures (ASC 810) - iCapital — Distribution waterfall structures - NetSuite — Financial close KPIs, month-end acceleration - Domain6 — Portfolio-wide financial consolidation for real estate - JMCO — Accounting for property management companies, fund structures