US Home Care EVV to Payroll Reconciliation Workbook

Match home-care visits to paid time

Use this Excel workbook to match scheduled visits and electronic visit verification (EVV) records to approved and paid minutes for one U.S. home-care pay period. Log travel and other work as separate rows so the payroll review accounts for time outside visits.

Reconcile one pay group

Open Reconcile to enter up to 48 segments. Use Worked example to see a batch whose totals tie while two rows still need correction.

Download the Excel workbook

Includes a blank worksheet, filled example and methodology.

Read the batch decision

Hold
Resolve a variance, invalid entry, overlap, duplicate, or open evidence review.
Incomplete
Fill in the missing minutes, keys, or evidence. Enter zero only for a confirmed absence.
Ready for payroll review
All included rows and scope fields are complete. Reconcile the file back to your source records, then send it for sign-off.

Build the reconciliation

  1. Set the scope. Record the agency or pay group, period dates, reviewer and source batch reference. Gather the schedule, EVV extract, approved time records and payroll register. Use pseudonymous caregiver keys and keep names, client addresses and geolocation in the source systems.
  2. Match each segment. Give each visit, travel segment or other work segment a unique ID for the batch. Keep unmatched entries in the sheet and use a secure crosswalk when one register line covers several segments. Allocate each register minute once. For visits, enter scheduled minutes and complete EVV timestamps in a common UTC clock. Leave both timestamps blank for documented cancellations and non-visit work.
  3. Enter approved and paid minutes. Use whole minutes under your documented conversion policy. Enter separately approved travel or other payable time without requiring a visit record. The U.S. Department of Labor treats job-site-to-job-site travel during the workday as hours worked under the FLSA. Check the specific work and jurisdiction with your payroll lead. U.S. DOL guidance on hours worked
  4. Document the review. Record the source or correction reference. Use Open when evidence or a correction is outstanding and Confirmed after review. Correct the source records and rerun held rows. Check visit counts and time totals against the complete source extracts, including differences outside the workbook's 48 rows.

Worked example with 125 minutes on both sides

In this synthetic example, a visit has 60 approved minutes and 55 paid minutes. Travel has 20 approved and 25 paid minutes. A second visit matches at 45 minutes. A documented cancelled visit has zero approved and zero paid minutes.

Batch variance
125 paid − 125 approved = 0 minutes.
Workbook decision
Hold. The first visit is five minutes short and travel is five minutes over. Trace the two register lines and correct the allocation before signing off.
How the workbook calculates flags

EVV elapsed minutes are the end timestamp minus the start, converted to minutes and rounded to the nearest whole minute for comparison. The payroll variance equals paid minutes minus approved payable minutes for the same segment. Blank values stay pending. Negative or fractional minute entries, reversed or zero-length EVV intervals and duplicate segment IDs are held.

Same-caregiver visit intervals that share elapsed time are held. Back-to-back visits may share an endpoint. Review non-visit overlaps and duplicates across batches manually. The sheet shows the highest-priority flag per row. A missing EVV interval or a difference from scheduled or approved minutes needs a documented explanation, even when payroll matches.

Which rules and records to check

CMS describes EVV requirements for Medicaid personal care and home health services requiring an in-home visit. Follow your state's or payer's correction and reporting rules. Use the worksheet for operational review of time and evidence. It does not calculate wages, overtime or Medicaid claims. CMS guidance on electronic visit verification

Use the Payroll Reconciliation Checklist when you move from time records to pay-run totals. See TimeTrex Scheduling and Leave Management for schedule templates and employee schedule access.

Disclaimer: This workbook supports an operational review of visit records and paid minutes. It does not determine payable time, calculate wages, validate Medicaid claims, or replace review of applicable wage and program rules. Verify all inputs, results and assumptions against appropriate records and obtain qualified advice before relying on them. To the fullest extent permitted by applicable law, this resource is provided “as is” without warranties of accuracy, completeness or fitness for a particular purpose, and TimeTrex and its affiliates disclaim liability for losses, damages, costs or claims arising from its use, inability to use, or reliance on it, including errors or omissions. Nothing in this disclaimer excludes or limits liability or rights that cannot lawfully be excluded or limited.

Share the Home Care EVV to Payroll Reconciliation Workbook

Facebook
X
LinkedIn
Email
WhatsApp
Print
A home, a phone showing a verified visit, and an open payroll reconciliation ledger.

Disclaimer: The content provided on this webpage is for informational purposes only and is not intended to be a substitute for professional advice. While we strive to ensure the accuracy and timeliness of the information presented here, the details may change over time or vary in different jurisdictions. Therefore, we do not guarantee the completeness, reliability, or absolute accuracy of this information. The information on this page should not be used as a basis for making legal, financial, or any other key decisions. We strongly advise consulting with a qualified professional or expert in the relevant field for specific advice, guidance, or services. By using this webpage, you acknowledge that the information is offered “as is” and that we are not liable for any errors, omissions, or inaccuracies in the content, nor for any actions taken based on the information provided. We shall not be held liable for any direct, indirect, incidental, consequential, or punitive damages arising out of your access to, use of, or reliance on any content on this page.

Trusted By

Trusted by 3.4M+ Employees: 23 Years of Service Across Startups to Fortune 500 Enterprises

Join our ever-growing community of satisfied customers today and experience the unparalleled benefits of TimeTrex.

Logo for H&R Block
Hilton Hotels and Resorts logo
HP computers logo
Oracle logo black and white
PWC brand logo
Texas A&M University logo
Mcdonald's brand logo
New York Stock Exchange Logo black and white
Walmart brand logo
London Drugs logo black and white

Strength In Numbers

Join The Companies Already Benefiting From TimeTrex

Users
0
Companies
0
Years
0

Time To Clock-In

Start your 30-day free trial!

Experience the Ultimate Workforce Solution and Revolutionize Your Business Today

TimeTrex Mobile App Hand