# Medical Bill PDF to Excel: Charges, Adjustments, Owed

- Author: FastBankConvert (https://www.fastbankconvert.com)
- Published: 2026-04-29
- Updated: 2026-04-29
- Category: Other financial documents
- Canonical: https://www.fastbankconvert.com/blog/medical-bill-pdf-to-excel

> Turn a medical bill PDF to Excel: service lines, insurer adjustments and what you owe, plus matching bills to the insurer's statements.
To turn a medical bill PDF to Excel, give each service line its own row with the date of service, description, charge, insurer adjustment, insurer payment and patient balance. Then match every line to the insurer's explanation of benefits for the same visit, so you can see what you owe and catch a bill that asks for more.

## Service lines on a medical bill PDF

A service line is one row on a medical bill for one thing the provider did: an office visit, a lab test, an X-ray, a supply. Each line normally carries a date of service, a short description, often a procedure code, and the amount charged. Keep every one of those in its own Excel column, one row per line.

### The columns to extract

A layout that fits most provider bills:

- **Provider**, the clinic, hospital or practice that sent the bill.
- **Account or statement number**, the reference you quote when you call billing.
- **Date of service**, the day the care happened, which can be weeks before the bill date.
- **Description**, the provider's wording for the service.
- **Code**, if printed, which is the most reliable way to match a line to the insurer's records.
- **Charge**, the full price before insurance.
- **Adjustment**, **insurer paid** and **patient balance**, covered in the next sections.

### Layout quirks

Medical bills are summary documents more often than itemized ones. A first bill may show one line, such as "Services 08/12/2026 ... 745.00", with no detail. If the bill gives you only a total, ask the provider's billing office for an itemized bill, which lists each service separately. Without the lines, there is nothing to match against the insurer's records.

Hospital bills can run several pages, with a running total that carries forward from page to page. Keep the carried-forward lines out of your rows, or mark them as subtotals, so a SUM does not count the same charges twice.

## What do insurer adjustments on a medical bill mean?

An insurer adjustment is the part of a charge that nobody pays, because the provider has agreed to accept a lower price from the insurer. The charge minus the adjustment is the allowed amount. That allowed amount is split between the insurer and you. Put the adjustment in its own column as a negative number.

The CMS guide to [reading an explanation of benefits](https://cms.gov/medical-bill-rights/help/guides/explanation-of-benefits) names the pieces. "Provider Charges" is what the provider bills for the visit. "Allowed Charges" is what the provider will be paid, which may differ from the charges. "Paid by Insurer" is what the health plan pays the provider. The remainder is the patient's share.

Bills word the adjustment in different ways: "contractual adjustment", "insurance discount", "plan allowance" or simply "adjustment". They all mean the same thing for your sheet. A second kind of adjustment, a write-off for a billing error or a financial assistance discount, is different in cause but goes in the same column, with a note saying which it is.

Adjustments often arrive after the first bill. The provider sends a bill, the insurer processes the claim, and a later bill shows the adjustment and the insurer payment. Keep each bill as its own set of rows with a bill date, rather than overwriting the old numbers, so you can see when each change landed.

## The patient balance column in a medical bill sheet

The patient balance is what remains after the adjustment and the insurer payment are taken off the charge, minus anything you have already paid. In Excel it is a formula, not a typed number: charge, plus the negative adjustment, minus insurer paid, minus patient payments. Computing it yourself is how you find out whether the printed balance is right.

### What makes up your share

Your share of the allowed amount usually comes from three plan rules:

- **Deductible**, an amount you pay each plan year before the plan starts sharing costs.
- **Copay**, a flat amount per visit or service.
- **Coinsurance**, a percentage of the allowed amount.

The bill rarely says which rule produced each number. The explanation of benefits usually does, which is why the two documents belong side by side.

### Payments you made at the desk

A copay paid at check-in reduces what you owe, but the CMS guide notes that an explanation of benefits shows only what you owe, not whether you have already paid part of it. Add a "Paid by me" column and record each payment with its date and method. When you paid by card or from checking, the bank or card statement is the proof.

## Matching each medical bill to the insurer's explanation of benefits

An explanation of benefits, or EOB, is the insurer's statement of how it handled a claim, and CMS is clear that it is not a bill. Match each bill line to the EOB line with the same date of service and, ideally, the same code. Then compare the charge, allowed amount, insurer payment and patient share column by column.

### A worked example

The visit below is an example, made up for illustration. The bill and the EOB are shown line by line in one sheet.

| Date of service | Service | Charge | Allowed (EOB) | Adjustment | Insurer paid | Your share (EOB) |
| --- | --- | --- | --- | --- | --- | --- |
| 2026-08-12 | Office visit | 285.00 | 162.00 | -123.00 | 129.60 | 32.40 |
| 2026-08-12 | Lab panel | 140.00 | 48.00 | -92.00 | 38.40 | 9.60 |
| 2026-08-12 | X-ray, two views | 320.00 | 155.00 | -165.00 | 0.00 | 155.00 |
| | **Totals** | **745.00** | **365.00** | **-380.00** | **168.00** | **197.00** |

Read it across. On the office visit, the charge of 285.00 less the adjustment of 123.00 gives the allowed 162.00. The insurer paid 80 percent, 129.60, and the patient share is the other 20 percent, 32.40. The X-ray went toward the deductible, so the insurer paid nothing and the whole allowed amount is the patient's.

The EOB says the patient share is 197.00. The provider's latest bill asks for 162.00. The 35.00 difference is a payment made at the desk on the day of the visit, which the EOB does not know about. Add it to the "Paid by me" column and the two agree.

### Matching when codes are missing

If the bill has no codes, match on date of service and charge amount. Charges are usually identical on both documents, because the insurer starts from what the provider billed. Allowed amounts and payments then follow.

The insurer pays the provider with a payment and a remittance advice, which lists each claim the payment covers. Providers and their bookkeepers work from that side; [a remittance advice in Excel shows which invoices a payment cleared](/blog/remittance-advice-pdf-to-excel) using the same line matching.

## Why does a medical bill show a balance the EOB does not?

A medical bill shows a balance the EOB does not when it was printed before the claim was processed, a payment has not posted, or it charges you a share the insurer did not assign. CMS says a bill should not exceed the EOB patient balance, and to talk to the provider if it does.

### Common causes, in rough order

1. **Timing.** The bill went out before the insurer paid. The full charge sits on it with no adjustment. A later bill normally fixes this.
2. **A missed payment.** Your desk payment or an earlier card payment is not on the bill. Your "Paid by me" column and your statement show it.
3. **A line not on the EOB.** The provider billed a service the insurer has no record of, possibly because a claim was never sent. The match shows a bill row with no EOB row.
4. **Different allowed amounts.** The bill's adjustment is smaller than the EOB's. That gap is the most important one to raise.

The EOB itself can carry remark codes, which CMS describes as explaining more about the charges and payments. Copy any remark code into a notes column on the matching row. When you call the provider or the insurer, the code and the line date save a lot of explaining.

### When not to pay yet

If the bill is higher than the EOB patient share and the difference is not a payment you made, hold that part until the two agree. Pay the amount both documents agree on if you want to avoid a late notice, and note the date and amount. Then call with the row from your sheet in front of you.

## A medical bill tracker across providers

A medical bill tracker keeps every bill and EOB line for a year in one sheet, with a provider column, a claim or account number, and a status such as Waiting on insurer, Matched, Disputed or Paid. One sheet across providers makes it easy to see the open balances and the deductible as it fills up.

### Tracker columns

| Column | Example value |
| --- | --- |
| Provider | Example Family Clinic |
| Account number | 448210 (stored as text) |
| Date of service | 2026-08-12 |
| Service | Office visit |
| Charge | 285.00 |
| Allowed | 162.00 |
| Insurer paid | 129.60 |
| Your share | 32.40 |
| Paid by me | 32.40 |
| Paid on | 2026-08-12 |
| Status | Paid |

The values in the table are an example. Store account and claim numbers as text so leading zeros survive.

A provider's bill that lists several visits and older unpaid amounts works much like a supplier's account statement. [A vendor statement in Excel lists the open invoices](/blog/vendor-statement-pdf-to-excel), and the same aging columns fit medical balances.

The "Paid on" column comes from your bank or card statement. FastBankConvert is designed to turn that statement PDF into rows with dates, descriptions and amounts, so each payment to a provider can be looked up instead of retyped. It is not open yet, and [the get started page](/get-started) lets you know when trial conversions begin. If you want to know what happens inside a tool like that, [how a bank statement parser reads a statement](/blog/bank-statement-parser) explains the steps.