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.
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 workbookIncludes a blank worksheet, filled example and methodology.
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.
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.
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.
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
Join our ever-growing community of satisfied customers today and experience the unparalleled benefits of TimeTrex.
Strength In Numbers
Time To Clock-In
Experience the Ultimate Workforce Solution and Revolutionize Your Business Today
Saving businesses time and money through better workforce management since 2003.
Copyright © 2026 TimeTrex. All Rights Reserved.