A bank feed helps a medical practice see cash movement without entering every transaction manually. But a connected account is not necessarily current, and an imported transaction is not necessarily posted to the books.
That distinction matters when an owner approves provider and administrative payroll, pays a large vendor invoice or takes an owner distribution. Yesterday’s accounting balance may omit a withdrawal. Today’s available bank balance may still need to cover payroll that has not reached the bank.
Use bank feeds as one input to a timestamped cash position—not as permission to spend. The daily workflow should answer three questions: What does the bank make available now? What activity has not reached the accounting records? What known payments must that cash still cover?
Understand the Stages Between a Receipt and the Books
Cash information moves through several systems on different schedules. A payer remittance, patient payment report, bank balance and accounting ledger can all be accurate for their respective purposes while showing different amounts.
| Stage | What it tells the practice | What it does not establish |
|---|---|---|
| Receipt or settlement report | A payer payment was reported, a patient payment was collected or a processor settlement was initiated | That the money is available in the bank |
| Pending bank activity | The bank displays a transaction that has not completed posting | Final posting timing or whether its effect is already included in the available balance |
| Posted bank activity | The bank has recorded the transaction | That the accounting feed has imported it |
| Imported feed activity | Transaction data reached the accounting system | That someone matched, classified or posted it to the ledger |
| Posted ledger entry | The transaction is recorded in the books | That the ledger captures all current bank activity or that revenue is accurate |
A feed can update after a delay, omit pending transactions or require renewed authorization. Its timing depends on the bank, connection method and accounting system. Do not assume a fixed update interval or instantaneous syncing.
Likewise, a bank deposit does not prove revenue accuracy. A payer deposit might settle an existing receivable; a patient-card settlement might arrive net of fees or refunds. Cash visibility and revenue review are related but separate tasks.
sbb-itb-17e8ec9
Establish Which Accounts and Balances Matter
Maintain a short account register showing each account’s legal owner, purpose, last four digits, responsible reviewer and expected feed behavior. Include operating and payroll accounts, plus reserve accounts relevant to payment decisions. Review credit-card activity for upcoming cash obligations, but do not treat unused credit as cash.
For multi-entity practices, prepare cash positions by entity before showing a combined total. Cash belonging to one entity should not silently fund another entity’s payroll in a worksheet. Identify any proposed transfer separately and obtain the appropriate review and authorization.
Multiple locations within one entity may share an operating account. In that case, show the account once and identify relevant location obligations separately. A per-location P&L is useful for profitability, but it does not establish how much cash each location has available.
Distinguish available, posted and ledger balances
Use the bank’s available balance as the starting point for a near-term payment decision, while checking how the bank defines it. Display the posted bank balance and accounting cash balance as separate reference figures when useful.
Before adjusting available cash, determine whether the bank has already included each pending debit, deposit hold or other item. Subtracting a pending withdrawal already reflected in available cash understates the position; adding an unavailable deposit overstates it.
Identify amounts reserved by practice policy, subject to account restrictions or committed to another purpose. Avoid deducting the same obligation both as an earmarked amount and as a scheduled payment.
Build a Timestamped Daily Cash-Position Worksheet
Prepare the worksheet before the day’s payment approvals. Refresh it again when a material receipt, withdrawal or funding decision changes the position.
The worksheet needs two separate sections: evidence about current cash and known upcoming outflows. Label each source’s timestamp, not just the time the worksheet was prepared. Include the time zone so reviewers can compare records consistently.
Section 1: Current cash and feed freshness
Illustrative example: The following figures describe a fictional practice operating account. They are not recommended balance targets.
| Source or control | Observation | Source timestamp or coverage | Treatment |
|---|---|---|---|
| Bank available balance | $92,000 | Tuesday, 8:30 a.m. ET | Starting cash figure |
| Bank posted balance | $96,000 | Tuesday, 8:30 a.m. ET | Reference only; do not add to available cash |
| Pending equipment debit | $4,000 | Bank checked Tuesday, 8:30 a.m. ET | Bank confirms it is already reflected in available cash; no further deduction |
| Accounting feed | Last successful refresh Monday, 6:00 p.m. ET; latest imported transaction dated Monday | Checked Tuesday, 8:40 a.m. ET | Current-day coverage is unverified |
| Ledger cash balance | $96,000; bank activity reviewed through Monday afternoon | Report generated Tuesday, 8:45 a.m. ET | Reference only; not the spending starting point |
| Patient-card settlement | $7,500 reported by processor; not visible at bank | Settlement report checked Tuesday, 8:20 a.m. ET | Exclude from available cash |
| Practice operating reserve | $15,000 | Owner policy confirmed Tuesday, 8:50 a.m. ET | Deduct once; this reserve is separate from the payments below |
A recent refresh timestamp does not necessarily prove complete transaction coverage. Record both the last successful refresh and the latest imported activity, then compare important recent bank transactions with the feed. A quiet account may legitimately have no new transactions, so an old transaction date alone does not prove failure.
Section 2: Known upcoming outflows
Choose a defined decision window, such as through the next scheduled cash review and any payroll funding cutoff that must be covered. Use the expected bank debit or funding date, not merely the payroll payday or invoice due date.
Illustrative example, continued:
| Obligation | Expected bank debit or funding time | Amount | Source and timestamp | Already reflected in available cash? |
|---|---|---|---|---|
| Provider and administrative payroll funding | Wednesday morning | $48,000 | Payroll funding notice checked Tuesday, 8:15 a.m. ET | No |
| Approved supply vendor payment | Tuesday afternoon | $8,000 | Payment queue checked Tuesday, 8:25 a.m. ET | No |
| Scheduled tax payment | Thursday morning | $6,000 | Payment confirmation checked Tuesday, 8:25 a.m. ET | No |
| Proposed owner distribution | After required payments are reviewed | $10,000 | Owner request received Tuesday, 8:35 a.m. ET | No; not approved |
Here, the payment-review amount before the proposed distribution is:
$92,000 available cash − $15,000 separate reserve − $48,000 payroll − $8,000 vendor payment − $6,000 scheduled tax payment = $15,000.
The $4,000 pending equipment debit is not deducted again. The $7,500 settlement is not added because it is not yet available. The $15,000 result is a decision aid, not automatic distribution approval: the reviewer must confirm the worksheet’s completeness and any other applicable constraints.
Keep proposed discretionary payments separate from approved obligations so the owner can see the effect of approving them.
Review Exceptions Before Approving Payments
Focus the daily review on differences that could change a cash decision. A full bank reconciliation remains a separate accounting control; it should not be confused with this short operational check.
| Exception | What to check | Cash-position response |
|---|---|---|
| Delayed or disconnected feed | Last successful refresh, connection message and recent bank activity | Use direct bank evidence and label the feed coverage gap |
| Transaction imported but not posted | Feed review queue and existing ledger entries | Flag the ledger lag; do not assume imported activity changed the books |
| Possible duplicate | Account, amount, dates, bank reference and existing records | Count the actual bank movement once; investigate before changing records |
| Missing payer deposit | Receipt evidence, deposit account and bank posting status | Keep it outside available cash until bank availability is confirmed |
| Undeposited patient receipts | Deposit log, processor settlement status and bank receipt | Track separately; do not add them to spendable cash |
| Transfer between practice accounts | Both account records and transfer status | Avoid counting the movement as new group cash |
Investigate duplicates without creating new ones
A transaction may appear twice after a manual upload overlaps with a restored feed, or a feed item may need to match an existing payment rather than create a new expense.
Compare the records before deleting or excluding anything. A payroll withdrawal may already have a related ledger entry; adding it again can distort the books. Keep the correction reason and supporting evidence with the review record.
Separate receipts from bank availability
A payer payment notice is not a bank balance. Neither is a patient balance marked paid in a practice-management report.
Track undeposited checks and unsettled card receipts with their amount, source report, expected deposit account and investigation owner. Use aggregate payment references where possible rather than patient-identifiable details. These items explain timing differences, but they do not increase today’s available cash until the bank confirms availability.
Use a Defined Fallback When the Feed Stops
A feed outage should change the evidence source—not stop cash review or trigger blind re-importing.
- Record the gap. Note the affected account, last successful refresh, known coverage and time the issue was discovered. Assign an owner to investigate.
- Check the bank directly. An authorized user should retrieve current available and posted balances, pending activity and recent posted transactions. Record the retrieval timestamp.
- Compare with the last reviewed position. Identify withdrawals, deposits and transfers since that review. Retain bank evidence through the practice’s approved document process.
- Refresh upcoming obligations. Confirm payroll funding, queued vendor payments, scheduled tax payments and other known debits with their responsible owners.
- Approve conservatively. Base payment decisions on bank-confirmed availability less obligations not already reflected. Defer discretionary distributions if material uncertainty remains.
- Restore the feed through authorized channels. Follow the bank or accounting provider’s connection instructions. Do not share credentials in ordinary messages.
- Check the restored coverage. Compare recovered transactions with the gap log. Review overlapping imports and manual entries for duplicates before closing the issue.
A manual bank export can support review, but do not automatically upload it. First establish the missing date range and how the accounting system handles overlap. Sometimes the safer short-term approach is to use the export as worksheet evidence while the connection is repaired.
Assign Preparation, Review and Escalation
Give a practice administrator or finance team member responsibility for preparing the worksheet, and identify who can approve payments. Where staffing permits, separate preparation from approval.
The daily handoff should state:
- Which entity and accounts are covered.
- When bank evidence was retrieved and how current the feed and ledger are.
- Which obligations are included and which uncertainties remain.
- What payment decision is requested and who approved it.
Escalate a stale feed when it affects an imminent payment decision, rather than relying on a universal number of hours. A payroll account with a funding deadline requires different attention from an inactive reserve account.
The IRS guidance on business recordkeeping supports complete records, separate business accounts and reconciliation of bank records. This daily worksheet complements those practices; it does not replace formal reconciliation or supporting records.
Make Cash Freshness Visible Before Spending
The goal is not to make every system display the same number at every moment. It is to explain the differences well enough to approve payments responsibly.
Start with timestamped bank availability, identify feed and ledger gaps, deduct known obligations only once, and keep unsettled receipts outside spendable cash. That gives the owner a clearer basis for payroll, vendor and distribution decisions without pretending the feed is instantaneous.
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. For support with this workflow, define who prepares the cash position, reviews entity-level exceptions and follows up on missing activity. Slack support can help coordinate questions, but patient-identifiable information should stay out of ordinary messages and general-purpose AI tools.
FAQs
Does a successful bank-feed refresh mean the cash balance is current?
Not necessarily. A successful connection may still have incomplete transaction coverage, and imported items may await review or posting. Compare important recent bank activity with the feed and label the source timestamps before using the report for a payment decision.
Should pending withdrawals be subtracted from available cash?
Only if they are not already reflected in the bank’s available balance. Check the bank’s treatment of each material pending item. Deducting it twice understates cash; ignoring a known debit that is not yet reflected overstates the amount available for other payments.
Can expected payer receipts fund today’s payroll decision?
Do not treat an expected payer receipt as currently available cash. Confirm the bank’s availability and the payroll funding requirement. If the payment decision depends on an unsettled receipt, escalate the uncertainty before authorizing funding or discretionary spending.
What should the practice do first when a feed disconnects?
Record the last reliable coverage and obtain current balances and activity directly from the bank through an authorized user. Update the cash worksheet and upcoming obligations while the connection is repaired. After restoration, review the missing period and any overlap before importing or posting additional transactions.