Mercury Report Builder: Which Open Claims Do You Count?

“How many claims were open on Friday?” sounds like a question with one answer. I’d ask one more thing before building the report: are we looking at the files still on someone’s desk at closing time, or every file that needed attention during the week? One number helps plan Monday’s assignments. The other helps explain where the week went. Swap them and a perfectly good count can lead to a bad staffing conversation.

Mercury includes a report builder. If you’re evaluating it for a carrier or TPA, bring a question like this one instead of a list of column names. Here’s a small exercise I’d use with a claims supervisor before a demonstration. The files are fictional, so anyone in the room can check the result without opening a real claimant’s record.

Five file cards and a Friday cutoff

Write one claim on each of five index cards. Keep the dates on the cards even if you think the final report only needs a total. In this exercise we count claim files, not claimants or payments. One file can count only once in each answer.

  • File A was open before Monday and remained open through Friday.
  • File B was open on Monday and closed on Wednesday.
  • File C opened on Tuesday and closed on Thursday.
  • File D was closed when the week began, reopened on Thursday and remained open on Friday.
  • File E closed the previous week and did not reopen.

Now count files open at the close of business Friday. A and D qualify, so the answer is two. Count files open at any point from Monday morning through Friday close instead. A, B, C and D qualify, so the answer is four. Notice that C disappears from the Friday snapshot altogether, even though somebody could have spent most of Wednesday working on it.

Give the report a name someone can act on

If the supervisor is assigning Monday’s work, I’d label the first result “Open claim files at Friday close” and put the actual cutoff date next to the number. I wouldn’t call it “Weekly open claims.” That shorter label invites a reader to interpret two as the number of files the team touched. Even the count of four doesn’t establish that anyone worked each file. It says the files were open during the period, not how much effort they took.

The reopened file deserves a minute of its own. A colleague might count D as new work on Thursday. That makes sense for a conversation about incoming assignments, but it doesn’t make D a newly reported claim. Ask which decision the reader is making before adding another column. Sometimes a clearer heading will do more for the reader than a more detailed report.

Take the cards to a Mercury demonstration

Hand the presenter the five cards and your definition, and keep your own copy of the two expected answers. Ask them to show how they would approach the Friday question in Mercury Report Builder. Then ask what information would need to be available to answer the weeklong question. A current status can tell you that B is closed now. By itself, it cannot tell you that B was still open on Monday.

If a result differs, ask which files were counted before discussing the total. Seeing A and B rather than A and D would give you the right number for the wrong reason. The individual cards help the claims lead and the person building the report point to the same discrepancy. Write down what was demonstrated and what still needs checking against your own records.

For a first meeting, skip the full reporting binder. Bring one question that prompts a decision, a handful of invented files and the answer you expect. Explore the Mercury platform or schedule a Mercury Report Builder demo with Quick Silver Systems. Start with the number your supervisor actually needs on Monday morning.

Mercury Report Builder: Which Open Claims Do You Count?
P&C Insurance System Overlay

SCHEDULE A DEMO