Garber² Partners Studio
Health Source Chiropractic of McKinney
October 2026Dr. Chris Phillips, DC (Clinic Founder & Chiropractor) · McKinney, TX · CPA: Legacy Trail CPAs (Plano, TX) · Banker: Green Bank — Private & Business Banking
Month-End Close Checklist (Leigh Ann Garber, CIA Audit Standard)
4 of 6 Steps Completed (67%)Click any internal audit control to mark complete or inspect workpaper tie-outs.
Chase Operating (#4829) and Money Market accounts matched to bank feeds. $0 unexplained variance.
Control: Unmatched items >90 days flagged for Texas unclaimed property review.
Gusto / ADP gross wages, employer FICA/FUTA, and SUTA matched against Form 941 impounds.
Control: Zero balance in payroll tax clearing account after monthly sweep.
Chase Ink (#8841) card charges verified against source receipts; mystery items queued in 6890 Chaser.
Control: Mystery transactions pending 60-Second Client Portal confirmation.
Monthly debt service payment split into principal debt reduction vs. deductible interest expense.
Control: Principal debt balance tied to bank loan statement within $0.01 tolerance.
Compile taxable sales receipts, apply Plano/McKinney 8.25% district rates, log 0.5% electronic prepay discount.
Control: Electronic prepayment discount booked to Other Income.
Isolate personal partner credit card charges from business P&L and reclassify to Owner Draw.
Control: Eliminate IRS commingling audit exposure; protect true clinic EBITDA.
Multi-Month P&L Variance & Anomaly Engine
Swings >15% or >$1,500 HighlightedDisplays prior month, current closed month, budget, and Leigh Ann's clinical/operational audit notes.
| GL Account & Line Item | Type | Prior Month | Current Month | MoM Variance ($ / %) | Audit Status / Indicator | Clinical & Operational Rationale |
|---|---|---|---|---|---|---|
| 4010 · Patient Care & Adjustments | Revenue | $68,400 | $76,250 | +$7,850 (+11.5%) | EMERALD: Favorable MoM | Strong patient retention + 18 new McKinney patient intakes |
| 4020 · Rehab & Decompression Therapy | Revenue | $22,100 | $26,800 | +$4,700 (+21.3%) | EMERALD: Favorable MoM | High-margin decompression package utilization up 21.3% MoM |
| 4090 · Merchant Processing Fees | COGS | $2,410 | $3,190 | +$780 (+32.4%) | CRIMSON: Action Required | Effective merchant rate rose from 2.66% to 3.09% — flagged for audit |
| 5010 · Clinical & Rehab Supplies | COGS | $4,120 | $7,600 | +$3,480 (+84.5%) | CRIMSON: Action Required | Includes $3,480 Chattanooga traction table — move to Fixed Assets |
| 6100 · Clinic Payroll & Benefits | Expense | $38,200 | $39,100 | +$900 (+2.4%) | Routine In-Budget | On budget (37.9% of gross collections) |
| 6400 · Facility Lease, EHR & Admin Overhead | Expense | $16,850 | $17,050 | +$200 (+1.2%) | Routine In-Budget | Steady fixed overhead |
| 6420 · Digital Local Patient Acquisition & Marketing | Expense | $4,800 | $4,690 | $-110 (-2.3%) | Routine In-Budget | McKinney search & community outreach campaigns |
| Net Operating Income (EBITDA) | Net | $28,920 | $31,420 | +$2,500 (+8.6%) | CRIMSON: Action Required | +$4,720 ahead of October target (+$34,900 after Fixed Asset reclass) |
6890 "Ask My Accountant" Mystery Transaction Chaser
1 of 5 Cleared (20%)Identifies uncategorized card disbursements, evaluates AI confidence, and links 1-click inquiries to client portal.
| Date & Payee | Account / Card | Amount | AI Prediction & Confidence | CIA Audit Guard Flag | Client Resolution Status | Actions |
|---|---|---|---|---|---|---|
DJO GLOBAL / CHATTANOOGA REHAB Oct 12, 2026 · POS DEBIT DJO GLOBAL VISTA CA #4829 | Card #8841 | $3480.00 | 1520 · Fixed Assets (Medical Equipment)98% AI Confidence | Exceeds $2,500 De Minimis Safe Harbor — Capitalize for CPA Section 179 | Resolved via Client Portal: Yes — New Rehab Equipment (Capitalize) | |
AMAZON MARKETPLACE *MK892 Oct 16, 2026 · AMZN MKTPLACE PMTS SEATTLE WA | Card #8841 | $642.18 | 5010 · Clinical & Rehab Supplies87% AI Confidence | Routine In-Budget | Awaiting Confirmation Mixed Amazon order — clinical therapy supplies or front-desk office supplies? | |
TEXAS CHIROPRACTIC ASSOCIATION Oct 19, 2026 · TCA AUSTIN TX ANNUAL CONF / CEU | Card #8841 | $1290.00 | 6340 · Continuing Education & Licensing96% AI Confidence | Verify 0% lobbying allocation for CPA tax deductibility | Awaiting Confirmation Annual CEU conference registration for you and Associate DC? | |
RUTH'S CHRIS STEAK HOUSE PLANO Oct 23, 2026 · RUTHS CHRIS #104 PLANO TX | Card #8841 | $418.50 | 6520 · Business Meals (50% Deductible)84% AI Confidence | IRS Audit Rule: Requires attendee name & business purpose note | Awaiting Confirmation Who attended this dinner so we can log the IRS audit note for your CPA? | |
APPLE STORE #R084 FRISCO Oct 27, 2026 · APPLE.COM/RETAIL STONEBRIAR | Card #8841 | $1149.00 | 6240 · Clinic IT & Check-In Kiosks (<$2,500 Safe Harbor)91% AI Confidence | Routine In-Budget | Awaiting Confirmation New iPad check-in kiosk for patient intake room? |
CIA Trial Balance Integrity Scanner
Arthur Andersen RigorGuarantees cent-level double-entry tie-out (Debits === Credits) and audits clinical healthcare controls.
Certified Internal Auditor double-entry control validates all journal feeds before CPA tax packet dispatch.
6-Point Clinical Bookkeeping Audit Suite
All 22 October batch deposits matched to bank statement #4829 within $0.00.
$3,480.00 DJO/Chattanooga charge detected in GL 5010 Clinical Supplies.
Effective merchant fee rose 43 bps (2.66% → 3.09%) in October.
Form 941 & Texas Workforce Commission accruals tie 100% to general ledger.
All corporate debit card charges audited for personal commingling; Ruth's Chris dinner flagged for attendee substantiation.
Taxable ancillary retail supplements ($4,120) reconciled against non-taxable professional chiropractic adjustments ($76,250).
AI Executive Financial Storyteller & Advisory Narrative
Plain-English monthly narrative with margin drivers, tax directives, review agenda, and client email draft.
Record October Collections ($103.1K, +13.9% MoM) Driven by Rehab Modalities—Plus a $3,480 Section 179 Tax Saving Reclassification
Dr. Phillips, October was Health Source Chiropractic’s strongest revenue month of the quarter, closing at $103,050 in gross collections (+13.9% over September and $8,550 ahead of budget). Most importantly, high-margin Rehab & Decompression modalities grew 21.3% MoM while clinic payroll remained tightly anchored at 37.9% of revenue.
During our CIA month-end reconciliation, we identified two items that will immediately put money back in your pocket: First, a $3,480.00 Chattanooga Rehab Table was booked inside Clinical Supplies—reclassifying this above the $2,500 Fixed Asset threshold lifts your true October Net Operating Income to $34,900 (33.8% margin) and flags it for your CPA's Section 179 depreciation schedule. Second, your merchant processor’s effective fee crept from 2.66% to 3.09% ($440/mo excess cost) due to downgraded card-not-present HSA transactions.
- Net Operating Income reached $31,420 ($34,900 adjusted for equipment capitalization), beating budget by +17.7%.
- Insurance clearing account vs. EHR deposit reconciliation completed with $0 unexplained variance across 412 patient claims.
- Cash position rose to $148,600 (3.1x monthly operating burn), putting the clinic in an ideal position for Q4 tax distribution planning.
- Reclassify $3,480.00 (Chattanooga Rehab Table) from GL 5010 Clinical Supplies to GL 1520 Medical Equipment for Section 179 bonus depreciation.
- Package Q1–Q3 reconciled workpapers + October projection for Legacy Trail CPAs ahead of the November year-end tax planning call.
- 1. Celebrate October crossing $103K & review Decompression package margin expansion
- 2. Approve 1-click reclassification of the $3,480 Chattanooga table to Medical Equipment
- 3. Review Merchant Processing rate creep (3.09% vs 2.66%) — Glen prepared a rate-reduction script for your processor
- 4. Clear the 5 remaining Chase Ink (#8841) mystery transactions (60 seconds in your portal)
- 5. Set Q4 owner draw & CPA year-end tax projection targets
Subject: Health Source Chiropractic — October Financial Brief & 3 Wins Before Our Review Call Hi Dr. Phillips, Your October books are reconciled and ready! Before we hop on our monthly review call, here is your interactive Garber² Executive Financial Brief: https://garber2.com/brief/healthsource-oct-2026 Three quick highlights from Leigh Ann & Glen: • Top-Line Momentum: Gross collections hit $103,050 (+13.9% MoM), led by a 21.3% surge in Rehab & Decompression packages. • CPA Tax Optimization: We caught the $3,480 Chattanooga table sitting in supplies—moving that to Fixed Assets boosts your true October net income to $34,900 (33.8% margin) and preps it for Section 179 with your CPA. • 60-Second Check-In: We have 5 quick Chase card charges that need your 1-click confirmation here: https://garber2.com/clarify/healthsource-oct-2026 Looking forward to walking through the numbers together! Warmly, Leigh Ann & Glen Garber Garber² Partners | Plano, TX
1-Click Export Actions: Resolved QBO CSV & CPA Close Memo
Pending Clarification (1/5 Resolved)Generates the official QuickBooks General Journal Reclassification CSV (debiting target GL accounts and crediting 6890 Suspense) alongside Leigh Ann Garber's certified CPA Audit Workpaper Memo.
Client Portal Access Link & PIN Security Gate
Configures the 4-digit security PIN for client access at /portal/healthsource-oct-2026