A monthly investor packet should help a medical practice’s existing partners and appropriately authorized capital stakeholders understand performance, cash availability and decisions requiring attention. It should not leave recipients guessing whether a figure represents billed charges, recognized revenue or money received.
The most useful template starts with approved financial records and stable definitions. AI can help turn verified aggregate figures into readable commentary, but it should not determine who receives information, invent explanations for variances or decide how much cash owners can distribute.
For a staffed private practice, the goal is a repeatable packet: the same core schedules, clearly defined reporting boundaries, controlled recipient-specific additions and documented human review.
sbb-itb-17e8ec9
Establish the Reporting Boundaries First
Before building a template, have the practice’s advisers review the applicable agreements to determine recipients, required disclosures and any restrictions. A partner, lender and other capital stakeholder may have different information rights. Do not assume that everyone should receive the same packet.
Document these boundaries:
- Entities covered: Identify the legal entities included and whether figures are separate, combined or consolidated.
- Locations covered: Define how locations map to entities. A location report is not necessarily an entity financial statement.
- Accounting basis: State whether the packet uses cash, accrual or another specified basis consistently with the underlying books.
- Reporting period: Identify the month, year-to-date period, comparison periods and balance-sheet date.
- Status: Mark the packet draft, approved or revised, with a version identifier.
- Authorized recipients: Maintain an approved distribution list and any recipient-specific schedules.
Keep payroll and patient detail out of the general packet unless specifically necessary and authorized. Aggregate provider and administrative payroll usually supports financial analysis without exposing individual compensation.
Patient-level billing exports should not be used as ordinary AI drafting inputs. HHS explains the minimum necessary standard and its exceptions; practical reporting design should minimize patient information rather than assume every financial recipient needs it.
A Repeatable Monthly Packet Template
Use the following structure as the master template. Each field ID connects to the source dictionary below. Bracketed entries are placeholders, not financial results.
| ID | Packet section | Required template content |
|---|---|---|
| H1 | Reporting cover | Practice name; covered entities and locations; month and year-to-date dates; accounting basis; version; approval status; recipient group |
| F1 | Financial summary | Revenue; operating expenses; net income; month and year-to-date actuals; corresponding approved budget figures |
| F2 | Location and entity detail | Revenue, expenses and net income by location or entity; allocation method; intercompany eliminations where applicable |
| C1 | Cash bridge | Opening cash; payer and patient receipts; other cash inflows; operating payments; debt principal; capital purchases; distributions; ending cash |
| C2 | Cash availability | Ending cash by entity; documented restrictions; planned payroll and other near-term obligations; management reserve assumptions |
| D1 | Debt schedule | Borrower; lender; opening principal; draws; principal repayments; ending principal; interest expense; next required payment and contractual maturity |
| B1 | Budget explanations | Metric; actual; budget; dollar variance; confirmed explanation or unresolved question; supporting reference |
| O1 | Owner distributions | Distributions paid by entity; proposed distributions; approval status; funding source; relevant agreement reference |
| Q1 | Open questions | Issue; financial effect if known; evidence needed; responsible person; target resolution date; decision requested |
| N1 | Executive commentary | Brief summary of performance, cash movement and decisions, referencing approved schedule IDs |
| R1 | Review and release | Preparer; reviewers; sign-off dates; unresolved limitations; approved recipients; released version |
Not every recipient needs every supporting schedule. Keep the master packet intact, then prepare approved recipient versions without changing the underlying definitions or calculations.
Keep revenue and receipts distinct
On an accrual-basis report, revenue and cash receipts can differ. On a cash-basis report, definitions still need to distinguish operating receipts from loans, owner contributions and transfers.
Do not treat gross billed charges as cash available for payroll or distributions. If the packet includes receivables context, use a verified aggregate report, identify its date and reconcile its scope with the financial statements. Avoid combining billing-system totals and general-ledger revenue without explaining the difference.
Field Dictionary: Where Each Template Item Comes From
The dictionary is the production specification. Each grouped entry below covers every field in its corresponding template row. If a field is added later, add its source, period, preparer and reviewer before publishing it.
Roles may overlap in a small practice, but the person preparing a figure should not be its only check. Assign named individuals to these roles in the working template.
| ID | Source and definition | Reporting period | Preparer | Reviewer |
|---|---|---|---|---|
| H1 | Practice records and adviser-reviewed agreements for names, scope and recipient group; accounting policy for basis; release log for version and status | Current packet and stated comparison periods | Practice manager or finance lead | Owner; adviser for scope and disclosure questions |
| F1 | Closed trial balance and mapped P&L accounts; approved budget using the same account mapping; net income reconciled to the books | Current month and year to date; matching budget periods | Bookkeeper or accountant | CPA or designated finance reviewer |
| F2 | Location/entity ledger reports; documented shared-cost allocation worksheet; intercompany reconciliation and elimination worksheet where applicable | Same periods as F1 | Accountant | CPA or CFO reviewer |
| C1 | Reconciled bank records and ledger cash activity; receipt summaries; payment classifications; debt, capital and distribution schedules | Opening through ending date of the month | Bookkeeper or accountant | Finance reviewer |
| C2 | Reconciled cash by entity; documented account restrictions; payroll and payable schedules; management-approved reserve assumptions | Month-end balances and explicitly dated forward-looking obligations | Finance lead | Owner and finance reviewer |
| D1 | Loan agreements, lender statements and debt ledger; repayment split between principal and interest | Monthly movement, month-end balance and future contractual payment dates | Accountant | CPA or finance reviewer |
| B1 | F1/F2 actuals; approved budget version; variance calculations; documented operational evidence or unresolved-question notation | Month and year to date, clearly distinguished | Finance lead with practice manager input | CFO or owner |
| O1 | Distribution ledger and bank activity for payments; documented proposal, approval record and adviser-reviewed agreement reference for proposed amounts | Payments during the month; proposals as of the packet date | Accountant and practice manager | Authorized owner; CPA or legal adviser as needed |
| Q1 | Close exception list and owner/manager submissions; estimated effects labeled as estimates; assigned action log | Open as of packet date | Practice manager | Owner or finance lead |
| N1 | Approved F1–Q1 schedules only; no independently generated financial facts | Same periods as referenced schedules | Finance lead, with optional AI drafting | Human finance reviewer and releasing owner |
| R1 | Sign-off record, issue log, approved distribution list and final packet file | Current release | Packet coordinator | Authorized releasing owner or delegate |
For foundational recordkeeping, IRS Publication 583 supports complete business records, separate business accounts and bank reconciliation. A polished packet cannot substitute for those underlying records.
Illustrative Example: Connecting Profit, Cash and Debt
All figures in this section are invented solely to illustrate template structure. They are not benchmarks, forecasts or actual practice results.
Consider an accrual-basis practice with two locations. Its summary schedules show:
| Financial summary | Location A | Location B | Practice total |
|---|---|---|---|
| Revenue | $260,000 | $190,000 | $450,000 |
| Operating expenses | $220,000 | $170,000 | $390,000 |
| Net income | $40,000 | $20,000 | $60,000 |
The illustrative expenses include shared administrative costs allocated under a documented method. Changing that method would require disclosure so recipients do not mistake an allocation change for improved operating performance.
The cash bridge tells a different, complementary story:
| Cash movement | Amount |
|---|---|
| Opening cash | $180,000 |
| Payer and patient receipts | $420,000 |
| Operating payments, including interest | ($350,000) |
| Debt principal repayments | ($15,000) |
| Capital purchases | ($20,000) |
| Owner distributions paid | ($10,000) |
| Ending cash | $205,000 |
The debt schedule shows opening principal of $300,000, no new draws, principal repayments of $15,000 and ending principal of $285,000. Interest expense is $5,000 and is already included in operating expenses and operating payments; it must not be deducted again in the cash bridge.
The template should not suggest that $60,000 of net income equals distributable cash. Receipts differ from revenue, while principal repayments, capital purchases and distributions affect cash differently from expenses. Any proposed distribution still needs entity-level liquidity review and the required approvals.
For a budget variance, report the calculation before the explanation. If actual revenue is $450,000 against a $470,000 budget, the unfavorable variance is $20,000. If its cause has not been verified, write “explanation pending review” rather than attributing it to payer delays or provider availability.
Use AI to Draft Commentary, Not Establish Facts
Give the drafting tool a controlled input: approved aggregate schedules, metric definitions and a list of verified explanations. Exclude patient identifiers, detailed payroll records, account credentials and unnecessary confidential information.
A reusable instruction could read:
Draft a concise owner summary using only the approved figures and explanations supplied. Cite schedule IDs for financial statements. Distinguish revenue from receipts and paid distributions from proposals. Do not infer causes, forecast results or recommend distribution amounts. Mark missing explanations as open questions. Report inconsistent figures without choosing a replacement.
Using the illustrative figures above, acceptable commentary would be:
Revenue was $450,000 and net income was $60,000 in F1. Cash increased from $180,000 to $205,000 in C1 after operating payments, debt principal, capital purchases and paid distributions. Revenue was $20,000 below budget; the cause remains under review in B1.
An unacceptable draft would claim that collections improved because a payer resolved delayed claims. That explanation is not established by the totals. A fluent sentence is not supporting evidence.
Human checks before approval
The reviewer should:
- Recalculate totals, variances and cash movements independently of the prose.
- Match every quoted number to its approved schedule and period.
- Confirm that location totals reconcile to practice totals and entity reporting does not double-count transfers.
- Check principal versus interest, distributions versus compensation, and actuals versus proposals.
- Remove causal explanations that lack documented support.
- Confirm that draft figures and unresolved estimates remain visibly labeled.
If an AI draft finds conflicting numbers, return the issue to the preparer. Do not let the drafting tool silently select the more plausible value.
Control Customization and Final Production
Customize by adding approved schedules or limiting disclosure—not by creating different versions of financial truth. For example, a partner packet might include distribution detail, while an authorized lender packet might include a contractually required debt schedule. Both should use the same approved balances and definitions.
Use this release sequence:
- Freeze the source set: Identify the closed ledger export, budget version and supporting schedules used.
- Resolve reconciliation exceptions: If something remains unresolved, assess whether to delay release or disclose a clearly bounded limitation.
- Draft and review: Prepare schedules first, commentary second, then complete numerical and disclosure checks.
- Approve recipient versions: Review each version against the authorized recipient list and applicable requirements.
- Release and preserve: Retain the approved packet, supporting workpapers and sign-offs under the practice’s adviser-reviewed records policy.
- Correct visibly: If a released figure changes, issue a clearly identified revision and explain what changed.
Lucid Financials provides CPA-led bookkeeping, tax and CFO services for staffed US private medical practices, combining AI-assisted financial work with a human finance team. Clean books, catch-up bookkeeping and location/entity financial visibility provide a foundation for this reporting process. Slack support can help coordinate questions, but patient-identifiable information should not be placed in ordinary Slack or general-purpose AI tools.
FAQs
Should every investor receive the same medical practice packet?
No. Adviser-reviewed agreements should determine recipients and required disclosures. Maintain one approved financial source set, then create controlled recipient versions. Do not assume that a reporting template establishes anyone’s information rights.
Can AI explain a missed budget automatically?
It can draft from verified explanations, but totals alone do not establish causes. Require a source for each explanation. If management has not confirmed why revenue or expenses differed from budget, include an open question instead of a confident narrative.
Does ending cash show how much owners can distribute?
No. Review cash by entity, upcoming payroll and other obligations, documented restrictions, reserve assumptions and required approvals. Keep proposed distributions separate from paid distributions, and have advisers address agreement and tax questions.
What patient information belongs in the reporting template?
Design the packet around aggregate financial information rather than patient-identifiable records. If a workflow would involve protected health information, obtain appropriate privacy and legal review before using it. HHS explains that accounting services can involve business-associate responsibilities; a reporting template or AI tool does not itself establish compliance.