HOF Clinic Financial Spreadsheet: What to Record

Many HOF clinics grow with their finances in the owner's head, in the bank statement and in a notebook. It works while volume is small. Then comes the month when cash gets tight for no clear reason, the accountant asks for a report and nobody knows which procedure was profitable. The solution does not have to be expensive: a well-designed financial spreadsheet solves most of the problem, if used with discipline.

This guide lays out the tabs, the minimum columns, the entry routine and the most common mistakes. It is not accounting or tax advice. Taxes, tax classification and filing obligations are for your accountant. The tax references are Brazilian.

Principles before the columns

Three rules underpin any financial spreadsheet:

1. Enter data the same day. Data entered a week later already carries memory gaps.
2. Fixed categories. If an expense is "material" one day and "supplies" the next, the report is useless.
3. Separate account. Clinic money and personal money in different accounts. See separating personal and clinic accounts.

The fourth principle is implicit: the spreadsheet is a means. The goal is to decide better, and for that the report must answer questions like "how much came in", "how much went out", "how much is coming" and "how much was left".

The four tabs

Tab 1: Income

Each row is a payment received. Minimum columns:

The fee column shows the real cost of cards. See card terminal fees in the procedure price and the glossary entry card terminal fee. Without separating gross and net, the margin looks larger than it is.

Tab 2: Expenses

Each row is a payment made. Minimum columns:

Suggested categories, adjustable to your case: rent and building fees; electricity, water and internet; salaries and payroll charges; pró-labore; materials and supplies; injectable products; disposables and biosafety; marketing; software and systems; taxes; accounting; bank fees; maintenance and equipment; training; other. Separating fixed from variable is essential. See fixed and variable costs of the HOF clinic.

The owner's withdrawal is neither profit nor an ordinary expense. Record the pró-labore (the owner's pay as a manager, in Brazil) in its own category, and profit withdrawals separately, following your accountant's guidance. See the clinic owner's pró-labore.

Tab 3: Receivables

This is the tab that is most needed and least often seen in homemade spreadsheets. Each row is a future installment:

With it, you know how much will come in over the next 30, 60 and 90 days, and you can avoid decisions based on the day's balance. To track late payments, see delinquency in the HOF clinic and collecting from late-paying patients ethically. If you use early payout, see advancing card receivables.

Tab 4: Monthly summary

A single tab that pulls the totals through formulas, with few rows:

Hypothetical reading example: net income of R$ 52,000.00, variable expenses of R$ 14,000.00 and fixed expenses of R$ 26,000.00 give R$ 12,000.00 for the month. Then look at receivables: if R$ 30,000.00 is due the following month and there are R$ 38,000.00 in bills to pay, the positive result may hide a squeeze. For the next step, see cash flow in the HOF clinic and simple income statement.

Cash and accrual: two readings of the same month

Cash and accrual accounting answer different questions. Cash is the money that came in and went out during the month. Accrual is what was generated in the month, even if you get paid later. The spreadsheet above has both dates (payment and service) precisely so you can read it both ways. Leave the formal classification to your accountant, but use both views in management.

Entry routine

Who enters the data? If reception enters income and the owner enters expenses, that is fine, as long as there is a single spreadsheet and one person responsible for reconciliation. Two parallel spreadsheets are a guaranteed source of discrepancies.

Mistakes that distort cash

Mixing gross and net. The amount charged is not the amount received. Without separating the fee, the margin looks larger.

Forgetting installments. A sale paid in 6 installments shows up as R$ 6,000.00 on the day, but the money arrives over months. Without a receivables tab, the month looks stronger than the cash.

Logging personal expenses in the clinic. It erodes the reading of profit and can create tax problems.

Not recording discounts. If the amount entered is the list price and the amount received was lower, the report lies. See discount policy for the HOF clinic.

Closing the month without reconciling the statement. A forgotten entry accumulates and becomes a gap nobody can explain.

Linking the spreadsheet to daily clinical work

To know which procedure gives the best return, the category column in the Income tab must match the procedures you actually perform. Another useful link is with the quote. If the clinic uses Harmy to present the plan, the PDF quote shows the price per ml for each area, discount, validity and notes, and the price table can be saved in My clinic. This helps keep the quoted amount equal to the amount entered, reducing discrepancies in the spreadsheet.

When to move to a system

A spreadsheet has a ceiling. Consider moving to a system when several people enter data at the same time, when you need integrated invoicing, when there are many installment plans or when you want automatic reports. See management software for the HOF clinic. Even so, understanding the spreadsheet's structure helps you choose well and check what the system shows.