Get the sample weekly report

Reporting

The weekly billing report, line by line

A weekly billing report is useful when every number on it is defined, tied to your own systems, and followed by what your biller is doing about it. This page shows the one-page format we send, then defines each line and the formula behind it, so two people reading it get the same answer.

Reporting is the last of the five stages of how Remitwright works, and it runs every week from go-live onward.

Last reviewed by the Remitwright billing team. Editorial policy

The format

The one-page format

What went out, what came in, what is stuck and what your biller is doing about it. The numbers are made up to show the layout.

Weekly billing report

Example family practice, 3 providers

Sample report · illustrative data

Charges entered
412claims
Claims submitted
405accepted by payer
Payments posted
$71,318this week
Denials worked
9 of 9same week
A/R by age (days)Example
  • 0-3058%
  • 31-6022%
  • 61-9011%
  • 91-1205%
  • 120+4%

Denials this week

Denials received this week, with reason, count, status and the week's total. Illustrative data.
CodeReasonClaimsStatus
CO-16Missing information on the claim4 claimsCorrected and resubmitted
CO-197No prior authorization on file3 claimsRetro-auth requested, on hold
PR-27Coverage had ended by the date of service2 claimsEligibility rechecked, patient contacted
Total this week9 claimsAll worked the same week

What's stuck and why

  • BCBS: 6 claims pending medical records. Records sent Tuesday, follow-up booked for day 10.
  • Medicaid MCO: 2 visits retro-termed. Secondary coverage found on one, patient statement on the other.
  • Aetna: 3 procedures denied for authorization. Retro-auth filed, peer-to-peer requested if refused.
The numbers above are made up to show the format. Your report shows your practice, every week, on one page.

Keep a copy of the sample

The same one-page format with its own illustrative numbers, to read offline or pass to a partner.

Download the sample report (PDF)

Email me a copy

Definitions

Each line, defined

Each metric on the billing report, how it is calculated, and what it tells you.
MetricHow it is calculatedWhat it tells you
Charges enteredCount and dollar value of charges entered in the week, by date of entry.Shows whether every visit became a claim. Compared with the schedule, it exposes unbilled visits.
Claims submitted and acceptedClaims released to the clearinghouse, and the share acknowledged as accepted by the payer.A claim that is not accepted does not exist at the payer. The gap between the two numbers is the rejection work.
Payments postedDollar value of payer and patient payments posted in the week, reconciled to deposits.Cash, not promises. Tied to the bank so the number means what it says.
Denials received and workedDenials appearing on remittances in the week, and how many were corrected, appealed or closed with a reason.The second number should match the first. If it does not, the report says why.
A/R by bucketOpen balances grouped by age from date of service: 0-30, 31-60, 61-90, 91-120 and 120+ days.The shape matters more than the total. Money moving right is money getting harder to collect.
Days in A/RTotal open A/R divided by average daily charges over the trailing 90 days.How many days of billing are sitting unpaid. The trend tells you whether the cycle is speeding up or slowing down.
Clean claim rateClaims that pass the scrubber edits with no manual intervention, divided by claims accepted into the claims processing tool for billing (the HFMA MAP Key definition).1The clearest single measure of front-end quality: eligibility, coding, charge entry and scrubbing all show up here.
Denial rateClaims with at least one denied line divided by claims adjudicated in the period.Tracked by payer and reason, it tells you where the prevention work should go.
Net collection ratePayments received divided by charges less contractual adjustments, over a trailing period long enough for claims to resolve.What share of the money you were entitled to actually arrived. The number that write-offs and underpayments hide in.
Charge lagAverage days from date of service to charge entry, by provider.Long lag means late claims and filing-limit risk, and it usually points at unsigned notes.
A/R over 90 daysShare of open A/R older than 90 days from date of service.The backlog measure. If it grows while the total holds steady, old claims are being abandoned.

Your metric glossary uses these definitions unless we agree a change in writing, and the change is dated.

The monthly report

Once a month the same numbers come with the trend over the last twelve months, broken down by payer and by provider, with write-offs by reason and a written commentary on what changed and why. It ends with the prevention list: the front-end fixes raised from the month's denials and rejections, with an owner and a status.

Between reports

Some things should not wait for the weekly report. A payer that goes quiet, a batch that did not release, a denial reason that spikes: your biller sends a short note between reports, with what is being done.

The reporting is included with every service, and billing reporting is also available on its own for practices that keep billing in-house and want an independent view of it.

Questions

About the report

Still deciding?

If your question is not here, add it as a note in the review and a billing specialist replies in writing.

Get a billing review

Or write to sales@remitwright.com

Why is the weekly report only one page?

Because a report that takes an hour stops being read in week three. One page holds what changed, what is stuck and what is being done. The monthly report carries the trends and breakdowns for the people who want them.

What is a good clean claim rate or days in A/R?

Published benchmarks exist, mostly from surveys of larger groups, and they vary by specialty and payer mix. We do not quote a target we cannot source for your situation. What the report shows is your own number, every week, and whether it is moving the right way.

Can the report include our own metrics?

Yes. Anything your PM system records can be reported, and the definition is written into your metric glossary so it means the same thing every week.

Who writes the commentary?

Your biller writes the weekly actions; the account lead reviews the report before it goes and writes the monthly commentary. Both are named on it.

Next step

See what your first report would say.

Three quick questions. No patient data. A written review of your aging, denials and payer mix.

  • Three questions, about two minutes
  • No patient data, no software to buy
  • A written reply from a biller, not a sales deck

What happens next

  1. You answer three questions

  2. A billing specialist reads them

  3. A written reply by email

Prefer email? sales@remitwright.com

Get a billing review

See where claims are getting stuck. No patient data needed.

Step 1 of 3

What do you bill for?

A little about your volume
How many providers? (Medical practice)

Trips per month? (NEMT)

Active clients? (Home care / home health)

Orders per month? (DME)

How many clinicians? (Behavioral health / therapy)

Claims per month, roughly? (Something else)

What's the biggest problem right now?

Where should we send the review?

Add details (optional)

We work inside your system; this tells us which login to ask for.

Please don't include patient information in this form.

  • No patient data requested
  • No obligation
  • Reply in writing
Get a billing review
Billing review

Get a billing review

See where claims are getting stuck. No patient data needed.

Step 1 of 3

What do you bill for?

A little about your volume
How many providers? (Medical practice)

Trips per month? (NEMT)

Active clients? (Home care / home health)

Orders per month? (DME)

How many clinicians? (Behavioral health / therapy)

Claims per month, roughly? (Something else)

What's the biggest problem right now?

Where should we send the review?

Add details (optional)

We work inside your system; this tells us which login to ask for.

Please don't include patient information in this form.

  • No patient data requested
  • No obligation
  • Reply in writing

BAA signed before any access, a user you create, MFA on. Patient data stays in your systems. How access works