Schema Care

Where Manual Data Entry Slows the Revenue Cycle

By Schema CarePublished Updated

Manual data entry slows the revenue cycle wherever a page arrives from outside and someone types it into a system: intake forms at registration, outside records at coding, paper claims at submission, and EOBs at payment posting. Each re-keying point adds a queue, a typing step and a chance of error, and errors come back later as denials.

The re-keying points where manual data entry enters the cycle

Manual data entry enters the revenue cycle at four main re-keying points: registration, charge entry, claim correction and payment posting. At each one, a staff member reads a document that came from a patient, a clinician or a payer and types its values into the practice management or billing system. The document and the system never talk directly.

The first point is registration. A patient fills in a paper or PDF intake form, and the front desk types the name, date of birth, address, insurance plan, member ID and group number into the practice management system. The insurance card copy is read the same way. For where registration sits in the order of steps, see the front-end revenue cycle steps.

The second point is charge entry. Practices that still use paper encounter forms, or that receive charges from outside facilities, re-type each procedure code, diagnosis code, date and provider into the billing system. Hospitals that receive outside records for coding re-key diagnoses and procedures from discharge summaries and operative notes.

The third point is claim correction. When a clearinghouse or payer rejects a claim, a biller reads the rejection, opens the claim and types the fix. Paper claims received from other parties, such as a billing service taking over a practice's backlog, are also typed in.

The fourth point is payment posting. Payers that do not send an electronic remittance mail a paper EOB. A poster reads each service line and types the allowed amount, adjustments, reason codes, patient share and payment into the ledger. A single EOB can cover dozens of patients, so posting can be the largest block of typing in a billing office.

How much delay does manual data entry add to each claim?

Manual data entry adds delay in two ways: queue time, when a document waits for someone to type it, and touch time, when someone is typing it. Queue time is usually the larger share, because documents pile up behind other work. The only reliable number for your team is one you measure, since volumes and staffing differ widely.

No published benchmark fits every office, so this post gives a method instead of a figure. Count the days between two dates for a sample of claims: the date a document arrived and the date its data reached the system. Then count touches, meaning each time a person opened the document or the account to act on it.

A worked example with fictional numbers

These numbers are made up to show the arithmetic. Suppose an example practice receives paper EOBs on Monday and posts them on Thursday, a three-day queue. During those three days, the patient share on each line is not yet on the patient's account, so statements go out three days later than they could. If one example EOB is re-opened twice because a posted total did not match the check, that EOB has three touches instead of one.

Now suppose an example registration error sends a claim back. The claim waited four example days for coding, two for submission and twenty-one for the payer's answer before the denial arrived. After correction and resubmission, it waits another twenty-one example days. In this example, the single typing mistake at registration added more delay than every queue in the office combined. A time study on your own claims shows whether the same pattern holds for you.

Manual data entry errors that turn into denials

Manual data entry errors turn into denials when a typed value does not match what the payer holds. A transposed member ID, a wrong birth date, an old plan or a wrong digit in a procedure code reaches the payer unchanged. The remittance then names the problem with a reason code that points back to the typing step.

The X12 Claim Adjustment Reason Codes list contains several codes that billing teams often trace to keying. CARC 16 means the claim lacks information or has submission or billing errors, and it must come with at least one remark code that says what is missing. CARC 27 covers expenses incurred after coverage terminated, which often means the registrar typed an old plan from a previous visit. CARC 18 marks an exact duplicate claim or service, which can happen when the same charge is keyed twice.

Some errors do not cause a denial at all. A posting mistake, such as typing $96.00 as $69.00, leaves the claim paid but the ledger wrong. The patient may receive a statement for the wrong amount, and the error surfaces only when someone reconciles the deposit against the EOB.

Tracing a denial back to a keying error takes a habit, not a tool. When a denial arrives, the person working it compares the value the payer rejected with the source document: the intake form, the insurance card copy or the encounter form. If the document was right and the system was wrong, the error happened at the keyboard. Logging those cases for a month shows which field and which step produce the most rework, which is more useful than a general sense that "registration is sloppy".

The worst errors are the ones that run out the clock. For Medicare, 42 CFR 424.44 on time limits for filing claims sets one calendar year after the date of service. A claim that loops through two rejections and a slow correction queue can approach that limit, and CARC 29, the time limit for filing has expired, ends the conversation.

Common keying errors by field

FieldTypical keying errorWhat the payer sees
Member IDTransposed or missing charactersNo matching member
Date of birthDay and month swappedPatient does not match the member
Insurance planOld plan carried overCoverage terminated before the service
Procedure codeOne digit wrongA different service, or an invalid code
ChargeSame line keyed twiceDuplicate claim or service
Payment amountDigits swapped while postingNo denial, but a wrong ledger and statement

How do you measure manual data entry time on your own team?

You measure manual data entry time with a one-week time study. For five working days, each person who types documents logs every document they key, how many times they touched it, and how many minutes each group of fields took. The log gives a baseline before you change software, staffing or workflow, so later results have something to compare against.

Keep the study small enough that people actually fill it in. A paper sheet or a shared spreadsheet beside each workstation works. Ask staff to log as they go, not from memory at the end of the day, because memory compresses small interruptions that add up.

The one-week time study template

Use one row per document per touch. The example row below is fictional.

ColumnWhat to recordExample value
Date and timeWhen the touch startedTue 10:42
Staff initialsWho touched itJL
Document typeIntake form, EOB, paper claim, outside record, rejectionPaper EOB
Document IDYour reference for the documentExample EOB 7731
ArrivedDate the document reached the officeMon
Touch number1 for the first touch, 2 for the next1
PagesPages in the document4
Header fields (minutes)Payer, check number, totals2
Patient fields (minutes)Names, IDs, dates3
Line fields (minutes)Codes, amounts, adjustments14
Reason for re-touchMismatch, missing data, interruptionNone
Errors found laterFilled in when a denial or mismatch traces backBlank

At the end of the week, total three things for each document type: documents keyed, average touches per document and average minutes per document. Then look at the gap between the arrival date and the first touch. That gap is your queue time. The post on baseline costs in an RCM automation ROI model shows how to turn those minutes into dollars.

Two mistakes spoil a time study. The first is measuring during an unusual week, such as the start of the year when deductibles reset and patient balances spike. The second is leaving out re-touches. The second and third touch on a document are the cost of errors, and they are often larger than the first.

Split the minutes by field group rather than by document for a reason. A paper EOB's header takes about the same time whether the EOB covers one patient or forty, while the line fields grow with every service line. Knowing which group eats the time tells you where a change would help. If line fields dominate, the problem is volume of detail. If patient fields dominate, the problem may be hard-to-read handwriting or missing identifiers that send staff searching.

Share the results with the people who did the logging. They usually know why a document type is slow, and the numbers give them a way to say so that a manager can act on.

Staffing for paper volume when manual data entry is the bottleneck

Staffing for paper volume starts from your time study, not from a ratio. Multiply each document type's weekly count by its average minutes per document, add the re-touch minutes, and divide by the productive hours one person has each week. The result is the number of people the paper needs before any other billing work gets done.

Fictional staffing arithmetic

The values below are an example, not a benchmark. Suppose an example office keys 300 paper EOBs a week at 18 minutes each, and 150 intake forms at 6 minutes each. Re-touches add 10% to the total.

  • EOBs: 300 × 18 = 5,400 minutes
  • Intake forms: 150 × 6 = 900 minutes
  • Subtotal: 6,300 minutes, plus 630 minutes of re-touches, for 6,930 minutes, or 115.5 hours
  • If one person has 30 productive hours a week for typing, the paper needs about 3.9 people

That figure tells you what the paper costs in people, not what to do about it. The options are hiring, moving volume to electronic remittances where payers offer them, sending the work to a billing company, or reducing the typing itself. The guide to revenue cycle automation compares what software can take on, and where to start automating the revenue cycle uses the same time study numbers to rank tasks.

Reducing the typing usually means software that reads the page. The medical OCR basics category explains how that works and where it breaks. Schema Care takes this approach for EOBs, intake forms and claim forms: each field comes back with a confidence score, and the ones below the threshold you choose go to a reviewer who sees the field highlighted on the original page, as shown in the human review workflow. The reviewer's minutes still belong in your staffing math.

All posts in Revenue Cycle Automation