A medical practice can show a healthy investment balance and still face a payroll cash shortage. Market value is not the same as immediately available cash, and investment gains do not explain whether patient services are covering operating costs.
For owners of staffed private practices, treasury portfolio reporting connects practice-held cash and investments to upcoming business commitments. It should answer three questions: What does each entity own? When can those funds be used? And how much remains after payroll, taxes, equipment purchases and other obligations?
AI may help organize bank and custodian statements into draft summaries. It should not determine accounting treatment, recommend securities or authorize transactions. A useful workflow keeps source documents, reconciliation and human approval at the center.
Define What Belongs in the Treasury Report
Start with accounts owned by the practice entities covered by the report. These may include operating bank accounts, reserve accounts and practice-owned brokerage or custody accounts. Exclude owners’ personal investments and personal retirement portfolios.
For every account, record the legal owner, institution, account identifier, reporting date and purpose. Use masked identifiers in the owner-facing report. Identify restrictions, pledges and earmarked funds separately rather than presenting every balance as available for distribution.
A multi-location practice also needs to distinguish legal ownership from management allocation. Cash held by one entity should not automatically be treated as available to another. Likewise, allocating a shared account across location reports does not create separate cash balances.
| Report component | What it should show | Owner decision it supports |
|---|---|---|
| Account inventory | Entity, institution, account purpose and statement date | Whether the report covers all practice-held funds |
| Liquidity schedule | Available cash, access conditions and settlement timing | Whether obligations can be paid when due |
| Maturity schedule | Principal due dates and expected proceeds | Whether timing aligns with planned spending |
| Concentration summary | Exposure by institution, issuer and relevant asset category | Whether specialist review is needed |
| Investment activity | Income, fees, realized results and unrealized changes | What caused the balance to change |
| Commitment schedule | Payroll, taxes, debt service and approved capital spending | How much cash is genuinely uncommitted |
Concentration reporting should distinguish the institution holding an asset from the issuer responsible for it. Several holdings at one custodian may have different issuers; accounts at different custodians may still hold exposure to the same issuer. Ask a licensed investment adviser to interpret material exposures rather than letting AI assign an unsupported risk score.
Keep Investment Results Separate From Practice Operations
The operating report and the treasury report serve different purposes.
The operating report explains practice activity: payer receipts, patient collections, provider and administrative payroll, occupancy costs and other operating expenses, presented according to the practice’s accounting basis. The treasury report explains where cash is held, its availability and changes in investment balances.
An owner contribution is not patient-service revenue. Moving money from checking to a brokerage account is not an operating expense. An increase in investment market value is not a payer receipt.
Show these categories separately:
- Interest and distributions: Identify amounts received or credited and distinguish cash payments from reinvestments.
- Realized gains or losses: Report results associated with dispositions, subject to CPA review of basis and accounting treatment. Sale proceeds are not themselves the gain.
- Unrealized changes: Identify changes in the reported value of holdings that remain owned. These changes do not create spendable cash by themselves.
- Fees: Separate identifiable advisory, custody and transaction charges. Some investment costs may be embedded rather than separately billed; do not assume statement charges capture every cost.
- Transfers: Separate internal movements from external contributions or withdrawals so consolidated totals are not inflated.
Have the CPA approve how these items appear in the books and financial statements. A custodian’s market-value report may differ from ledger carrying values or tax records. Explain those differences rather than forcing all reports to match by posting an unsupported adjustment.
Use AI to Prepare Drafts, Not Approve Results
Depending on the tool and document quality, AI may help extract statement fields, group holdings, summarize activity and draft explanations of changes. Test these tasks against actual statements before relying on them.
A practical instruction for a draft report is: identify the source statement and page for each balance; preserve the statement’s valuation date; and mark missing or ambiguous information as unresolved.
Common extraction errors include confusing security units with dollar values, reading a year-to-date figure as current-month income, or counting a sweep balance both separately and within the brokerage total. An AI-generated summary can sound confident even when those errors remain.
| Draft task | Required human check |
|---|---|
| Extract account balances | Match totals and dates to the original statements |
| Group maturity dates | Confirm actual maturity versus settlement or other dates |
| Summarize liquidity | Verify access restrictions and expected availability |
| Explain investment changes | Separate income, fees, transfers and valuation movements |
| Flag missing information | Confirm every account and statement period is included |
| Draft an owner summary | Check that conclusions follow from reconciled figures |
Treasury analysis generally does not need patient-level data. Use aggregate collection forecasts rather than patient names, diagnoses or identifiable billing records. Do not place patient-identifiable information into ordinary Slack messages or a general-purpose AI tool. If a proposed workflow involves protected health information, obtain an appropriate privacy and vendor review; HHS guidance on cloud computing explains why encryption alone does not resolve business-associate responsibilities.
sbb-itb-17e8ec9
Build a Reconciled Treasury Portfolio Report
Prepare the report at a consistent month-end date, then update the near-term liquidity schedule when material commitments or receipts change. Distinguish the statement date from the date the report was prepared. A month-end statement is not a live balance.
1. Collect the supporting records
Gather bank and custodian statements, transaction details, the general ledger, prior-period reconciliations and the current cash forecast. Obtain the approved payroll funding schedule, CPA-confirmed tax commitments, debt payments and capital purchase schedule.
Use complete statements rather than screenshots of selected balances. The IRS business recordkeeping guidance in Publication 583 supports maintaining complete business records, keeping business accounts separate and reconciling bank records.
2. Reconcile each account before consolidating
Tie bank balances to bank reconciliations and custodian balances to supporting holdings and activity. Investigate missing transactions, outstanding payments, accrued income, settlement differences and valuation differences.
Then reconcile the consolidated report. Match transfers between included accounts so the same funds do not appear as both new deposits and existing assets. Retain an exception list with an owner and resolution status for every unexplained difference.
3. Explain the movement in total value
Illustrative example—not a practice benchmark or investment recommendation: A practice’s statement-based treasury value changes as follows during one month. This example assumes no sales or realized gains and uses consistent market-value presentation.
| Movement | Amount |
|---|---|
| Beginning treasury value | $590,000 |
| External deposits | $40,000 |
| External withdrawals | −$35,000 |
| Interest and distributions | $2,000 |
| Separately charged fees | −$1,000 |
| Unrealized valuation increase | $4,000 |
| Ending treasury value | $600,000 |
The ending value must tie to the combined statements after eliminating duplicate balances. It does not mean the practice earned $10,000 from patient care. The change includes external cash movements, investment income, fees and an unrealized increase.
When sales occur, the reconciliation needs additional care: sale proceeds, cost basis and realized gains must not be counted twice. Have the CPA review the bridge between statement activity and ledger entries.
4. Add availability and maturity timing
Continuing the illustrative example: The reconciled $600,000 consists of the following balances. Availability assumptions must be confirmed with the relevant institution or adviser.
| Holding category | Statement value | Planning treatment |
|---|---|---|
| Operating bank cash | $200,000 | Available for near-term commitments, subject to bank reconciliation |
| Custodian cash or sweep balance | $100,000 | Included after confirming access and transfer timing |
| Securities maturing in 45 days | $150,000 | Excluded from the next-30-day cash base |
| Securities maturing in 90 days | $150,000 | Mapped to later commitments; maturity proceeds verified separately |
| Total | $600,000 | $300,000 included in the near-term cash base |
Statement value and maturity proceeds are not necessarily identical. Record both when they differ. Do not assume a security can be sold early at its reported value or that an expected maturity will automatically fund a payment on time.
Map the Report to Payroll, Taxes and Capital Commitments
A treasury report becomes useful when it is connected to a dated cash forecast. Include provider and administrative payroll, payroll-related payments, rent, debt service, vendor obligations and approved equipment purchases. Use CPA-confirmed tax estimates and payment timing rather than asking AI to invent them.
Continuing the illustrative example: The practice has $300,000 in confirmed near-term cash and expects $80,000 of payer and patient receipts over the next 30 days.
| Next-30-day item | Cash effect |
|---|---|
| Opening available cash | $300,000 |
| Forecast payer and patient receipts | $80,000 |
| Provider and administrative payroll | −$140,000 |
| Payroll-related and other tax payments | −$35,000 |
| Rent, vendors and debt service | −$55,000 |
| Approved equipment deposit | −$30,000 |
| Projected closing cash | $120,000 |
| Owner-approved minimum operating reserve | −$100,000 |
| Headroom above that reserve | $20,000 |
That $20,000 is planning headroom, not an automatic distribution amount. Review entity ownership, restrictions, later commitments and collection uncertainty first. The reserve is an illustrative management assumption, not an industry standard.
Also test timing within the month. A positive month-end projection can hide a shortage before payroll if payer receipts arrive later. Add a downside case with delayed collections and identify which commitment would become unfunded. Do not fill the gap by assuming investment returns or early sales at favorable prices.
For multi-entity practices, prepare this schedule for each paying entity before presenting a consolidated view. Identify which entity owes shared costs and document any proposed inter-entity funding with professional review.
Assign Review and Decision Responsibilities
Keep preparation, accounting approval and investment decisions distinct:
- Practice manager or finance lead: Confirms account completeness, payroll timing, approved purchases and forecast collection assumptions.
- Bookkeeping team: Reconciles accounts, matches transfers and documents unresolved differences.
- CPA: Reviews accounting treatment, ledger presentation, realized and unrealized items, and tax-related commitments.
- Licensed investment adviser, where appropriate: Reviews liquidity characteristics, concentration, fees and investment-policy questions.
- Authorized practice owner: Approves funding actions and changes to operating reserves or planned spending.
The final report should show the reporting date, reviewer, unresolved items and decisions required. Do not let a draft AI narrative trigger trades or transfers.
Lucid Financials provides CPA-led bookkeeping, tax and CFO services for US private medical practices, combining AI-assisted financial work with a human finance team. Clean books, catch-up bookkeeping and location/entity visibility can support the accounting foundation for treasury oversight. Its approved scope should not be confused with investment-management software or licensed investment advice. Slack support can help coordinate finance questions without introducing patient-identifiable information.
Make the Owner Summary Decision-Focused
Close each reporting cycle with a short explanation of what changed, what is available and what requires action. Highlight unreconciled differences, payments due before maturities, concentrated exposures requiring adviser review and decisions about capital-spending timing.
The goal is not a more impressive performance dashboard. It is a reviewed connection between practice-held assets and the obligations those assets must support—without allowing investment results to obscure operating performance.
FAQs
Does a medical practice need treasury reporting if it holds only cash?
A simplified report can still be useful. List each entity’s bank balances, reconcile them, identify restricted or earmarked amounts and map available cash to commitments. Investment-performance sections are unnecessary when there are no investments, but entity ownership and payment timing still matter.
Can AI calculate returns from custodian statements?
It may help organize the inputs, but a change in account value is not a return calculation. Deposits, withdrawals, fees and timing affect the result. If performance reporting is needed, have a qualified reviewer confirm the method and reconcile it to custodian records. Do not present an AI-generated percentage as verified performance.
Should unrealized gains count as cash available for payroll?
No. An unrealized gain is a valuation change, not a cash receipt. Payroll planning should use confirmed available funds and appropriately supported receipts. Any plan involving an asset sale needs separate review of timing, proceeds and investment implications.
Who should review the report before the owner uses it?
The bookkeeping team should reconcile the underlying accounts, and the CPA should review accounting treatment. The practice manager should verify operating commitments. A licensed investment adviser should address investment-specific questions where appropriate, while the authorized owner retains responsibility for approved business funding decisions.