Skip to main content

End of Day Report

Summarizes daily transactions, including sales, payments, and adjustments, to close out the day’s financials.

Updated over 3 weeks ago

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:

  1. Invoices

  2. Payments

  3. Cash Reconciliation

  4. 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:

  1. Cash Payment Summary

  2. 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:

  1. Payment Type Summary

  2. 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.

Did this answer your question?