Your EOD report is crucial for a few specific reasons:
1. Daily Financial Accuracy
Reconciles all payments (cash, check, Shepherd Pay, CareCredit, etc.) with services rendered.
Ensures that financial totals match your actual bank deposits and Shepherd records.
2. Prevents Revenue Leakage
Helps catch missed charges, duplicate payments, or unrecorded transactions.
Ensures inventory used (like medications or vaccines) lines up with billed items.
3. Fraud Prevention
Flags suspicious discrepancies early (e.g., missing cash, unusually high refunds, edited invoices).
Tracks which users completed various financial transactions.
4. Smooth Handover & Transparency
Creates a clear snapshot of the day’s financials for managers, owners, or accountants.
Useful when multiple people touch the system—techs, reception, DVMs.
Advanced Filters
To help you retrieve the most relevant and focused report results, the End of Day (EOD) report includes three advanced filters: Time Period, Invoice Status, and Payment Method. These filters are especially useful when reviewing specific events or transactions during daily or shift-based financial reconciliations.
Time Period
Define a custom time range using a start and end date in the format MM/DD/YYYY HH:MM AM/PM. This flexibility allows you to tailor the report to meet your exact reconciliation needs. By default, the report selects today's date to streamline daily workflows.
Invoice Status
Filter by any of the three available invoice statuses—or view all—to isolate the transactions you need. This makes it easy to review invoices based on their current state, providing greater control over your analysis.
Payment Method
Use the Payment Method filter to view transactions by specific payment types (e.g., cash, card, check). This ensures you're working with the most relevant financial data for your reconciliation process..
Key Tables
The End of Day report is organized into four key tables to support comprehensive financial review:
Invoices
Payments
Cash Reconciliation
Totals
Invoices
The Invoices table displays all invoices within the selected time period and filtered by the chosen invoice status. It includes:
Client and invoice details
Financial breakdowns
Total summaries
This all-in-one view ensures you have access to the critical information you need for accurate and efficient reconciliation, whether you're reviewing daily totals or investigating specific transactions.
Payments
The Payments section is divided into two sub-tabs: All Payments and Refunds, each providing a focused view of financial transactions. Payments shown are filtered according to the Payment Method selected in the Advanced Filters. This ensures that only the relevant payment types (e.g., cash, credit card, CareCredit) are included in your report results.
All Payments
The All Payments tab displays all incoming payments recorded during the selected time period. Refunds are not included in this view to maintain clarity in revenue reporting. This tab provides key details such as:
Payment amount
Payment method
Date and time
Associated invoice and client
Transaction reference details
This organized view supports accurate tracking of all received funds as part of the reconciliation process.
Refunds
The Refunds tab displays all refund transactions processed within the selected time period. While similar in structure to the All Payments tab, it focuses exclusively on outgoing funds. Key details include:
Refund amount
Original payment method
Linked invoice or client
Refund date and time
Reference or notes for context
By separating refunds from incoming payments, this layout helps ensure a more transparent and error-free financial review.
Cash Reconciliation
The Cash Reconciliation section focuses specifically on cash-related and deposit-handling metrics. It includes two key tables designed to support accurate tracking and handover of physical payments:
Cash Payment Summary
Deposit Summary
Cash Payment Summary
The Cash Payment Summary table provides a detailed overview of all cash-related activity within the selected time period. It includes a running tally of:
Total cash received
Change given to clients
Cash refunds issued
Net cash in amount
This breakdown supports transparent and accountable cash drawer management, whether for daily closeout or shift reconciliation.
Deposit Summary
The Deposit Summary table provides a clear total of all manual payment types that require physical deposit handling. It includes:
Cash payment total
Check payment total
Combined total for quick reference
This summary is particularly helpful for end-of-day bank deposits and ensures accurate handoff between team members or to management.
Totals
The Totals section provides a high-level overview of all financial activity, with a focus on payment method distribution and net transaction values. It includes two main tables:
Payment Type Summary
Payment Total Summary
Payment Type Summary
The Payment Type Summary table displays a breakdown of all incoming payments, grouped by payment method. For each method, it shows:
Payment Count – total number of transactions per method
Total Amount – cumulative value of transactions per method
A final row provides the grand total for both count and amount across all methods. This summary is useful for quickly assessing how payments were distributed throughout the day.
Payment Total Summary
The Payment Total Summary gives a concise view of the day’s financial totals by:
Payments Received – all incoming funds for the period
Refunds Given – total value of processed refunds
Total – calculated as Payments Received minus Refunds Given, representing net revenue collected
This summary allows for a quick financial check and serves as a reliable reference for end-of-day reconciliation and reporting.