A REAL BILLING WEEK, STEP BY STEP

Here's exactly what happens
between the work and the check.

Every screen below uses sample data. This is the sequence our founding practice runs every week — with the retyping, reformatting, and cross-checking done by the software instead of by hand.

The whole idea

You work in one place. It lands everywhere it should.

Enter a line of work once. Med Claims Pro writes it into the real files on your computer — the same folders, the same Excel, Word and PDF you'd build by hand — and reads your changes back if you open them. Here is one entry, three ways:

1In the app
Med Claims Pro — Today's Work
ClientCodeUnitsCharge
Rivera, M.W32350.7$57.33
Rivera, M.W32070.2$16.38
Bennett, D.W3207W20.1$8.44
You type the row. It autosaves as you go.
writes to
2On your computer
File Explorer
📁 Documents › Billing Info › Daily Billing Log
📂Daily Billing Log
📊7-7-2026.xlsxjust now
📊7-6-2026.xlsxyesterday
📊7-3-2026.xlsxFri
Saved into your real Documents folder — dated, named your way.
opens as
3In Excel
7-7-2026.xlsx — Excel
ABDEFG
1DateClient NameCodeUnitsRateCharge
27-7-2026Rivera, MarcusW32350.781.90=E2*F2
37-7-2026"W32070.281.90=E3*F3
Case BillingService Codes
The actual .xlsx — live formulas, your two sheets. Edit here and the app reads it back.
Your computer, organized

Every client, filed the way you'd file it.

Add a client and the whole folder set appears — named Last, First — MCO — Case type, with the same subfolders for every case, across BWC, JR, SI and RAW. The dated documents land inside, so an auditor — or you, two years later — finds everything exactly where it belongs.

Nothing is locked in a database you can't open. These are ordinary Windows folders and Office files you fully own — the app just keeps them current.

File Explorer — Documents
📁 Documents
📂Active BWC Cases
📂Rivera, Marcus — Northgate MCO — BWC
📂Billing Info
📄7-6-2026.docxWord log
📂CMS 1500
📕7-6-2026.pdfform A
📕7-6-2026 B.pdfoverflow
📂Emails · Client Billing Log · Fax Confirmations
📂Bennett, Dana — Anchorpoint MCO — BWC
📂Okafor, Priya — Clearpath Comp — JR
📂Sullivan, Grant — Vantage Care — RAW
📂Tran, Elise — Ridgeline WC — SI
📂Billing Info
📂Daily Billing Logdated .xlsx
📂Accounts ReceivableBill Tracker .xlsx
Step 1 · Once per client

Add the client. Get the filing system.

One form captures the client, claim number, payer, case type, and level. The moment you save, the full folder set exists — the same structure you'd have built by hand, ready for every document that follows.

Case type and level matter: they decide which service codes fit and which rates apply, so the daily grid can do the thinking later.

➕ Add New Client
First name *
Marcus
Last name *
Rivera
Insurance (MCO) *
Northgate MCO ▾
Claim number
99-100482
Case type *
BWC ▾
Level
Level 1 ▾
The app will create: Active Cases \ Rivera, Marcus — Northgate MCO — BWC
📁 …and the folders exist, instantly
Active Cases \ Rivera, Marcus — Northgate MCO — BWC \
  ├─ 📂 Billing Info  ·  📂 CMS 1500  ·  📂 Client Billing Log
  └─ 📂 Emails  ·  📂 Fax Confirmations
7-7-2026.xlsx — Daily Billing Log
ClientCodeUnitsRateCharge
Rivera, MarcusW32350.7$81.90=E2*F2 → $57.33
"W32070.2$81.90$16.38

Live VLOOKUP + charge formulas, exactly like the template — edit it in Excel and the app reads it back.

Step 2 · During the day

Enter the work. The Excel file follows.

The grid types like your spreadsheet — client type-ahead, code dropdown in your sheet's order, live charge math, autosave on every keystroke. And the real .xlsx on disk stays current with the screen, both directions.

Hand-edit the file in Excel at lunch? The app notices and reads your changes back in. The file and the screen never disagree.

Step 3 · End of week, one click

The weekly package writes itself.

Per client, per Monday-week: the narrative Word tracking log (grouped by date, your layout) and the CMS-1500 — payer's own template, correct units in box 24G, provider block from Settings. Past six lines? Form B generates itself.

The log and the forms come from the same entries, so they can never disagree — the thing payer reviewers check first.

7-6-2026.docx — Client Tracking Log
Re: Marcus Rivera  #99-100482  Northgate MCO  Level 1
7-7-2026
W3235  0.7  $81.90  $57.33  — Monthly progress report drafted and finalized…
W3207  0.2  $81.90  $16.38  — Email to MCO w/ June progress report…
W3220  0.4  $81.90  $32.76  — Rev'd updated POR notes and IME addendum…
7-6-2026.pdf — HEALTH INSURANCE CLAIM FORM (CMS-1500)
1a. Insured's ID (claim #)99-100482
2. Patient's nameRivera, Marcus
24a. Date07 07 26
24b. POS99
24d. CodeW3235
24f. Charge57.33
24g. Units7
25. Tax IDfrom your Settings
28. Total charge$106.47

0.7 time-based units print as "7" — and mileage prints as-is. The unit math that causes short-pays is handled per code.

Fax to Northgate MCO · 800-555-0142
FAX COVER SHEET — CONFIDENTIAL
To: Northgate MCO · From: Your Practice Name
Re: Weekly billing package — M.R., claim 99-100482
Pages: 4 (cover + Word log + CMS-1500 A/B)
☑ Transmission receipt → filed to Fax Confirmations
Step 4 · Send it off

To the payer, with proof it went.

The package — narrative log plus the claim forms — goes to the payer's fax number with a generated confidentiality cover sheet. The delivery receipt files itself into the client's folder: your timely-filing evidence, kept where an auditor would look.

Then one click marks the week billed — and every form becomes a receivable being watched. (Fax integration ships with the founding customers; forms are fax-ready today.)

Step 5 · When the check arrives

One check, many clients — reconciled in a minute.

Enter the check number and amount, tick the bills it covers; each line pre-fills from the balance due. Fully-applied checks reconcile to the penny. Anything short gets flagged instantly — with the original form preserved as evidence for the rebill.

Overpaying a bill is blocked at entry. Unapplied remainders are surfaced, never lost.

💵 Record a Check — Northgate MCO · #2087411 · $161.64
ApplyClient · FormBalanceThis check
Rivera, M. · CMS$120.45$120.45
Rivera, M. · CMS B$57.33$41.19
Check fully applied ✓  ·  CMS B short-paid $16.14 → flagged for follow-up
Step 6 · Anytime

Reports that answer the owner's questions.

How much did we work, bill, collect — and who owes us? By client, payer, case type, and code, with aging buckets computed on today's open balances. Explore all five screens in the interactive tour.

Questions, answered.

Is this really my workflow, or will I have to adapt to the software?

It was built by replicating a working vocational-rehab practice's files — the daily spreadsheet, the Word logs, the folder trees, the Bill Tracker. Documents generate in those formats, into your folders, with your naming. If your workflow differs meaningfully, book a workflow review and we'll map it honestly.

What if I already have years of billing history?

Your existing files stay exactly where they are — the app works alongside them and writes new documents into the same structure. A read-only historical importer (scan, review, approve) is in development for bringing old records into the reporting.

My daily spreadsheet looks different from this one — can it adapt?

Yes. The daily template name and its live formulas are settings, not code — the app can match your columns and calculations. Practices with a different Excel layout or Word log format map them during setup; that is a big part of what the guided trial call is for.

Can I try it with my own data?

Yes — the 7-day trial is the full Professional product. Add a real client, enter a day of work, and generate the week's documents. Most people know within an hour.