Shepherd Reports
Running reports is a critical function of any veterinary practice, however it’s a responsibility that should be tightly controlled since reports contain medical information for patients, as well as contact/personal information for clients.
Reports can be both created and downloaded. A created report will populate within the Shepherd admin.
Creating Reports
To create a report:
Click 'Reports'
Select the report you want to create
Select or input the date
Click the 'Create Report' button
A downloaded report allows you to open up the report in its entirety in Excel, Google Sheets, or similar. When opened in these programs, you can filter the data in ways that are extremely helpful for things like email campaigns. However, this information is also the backbone of your practice, and should be kept as secure as possible.
Downloading Reports
To download a report:
Click 'Reports'
Select the report you want to create
Select or input the date
Click the 'Download PDF' or 'Download CSV' button
Types of Reports
In order to provide as much information to our practices as possible, we’ve made sure you’re able to generate every report your practice will need to document clients, patients, and medication.
Reports that you can generate in Shepherd fit into 4 groups:
Filtering Reports
With a few exceptions (like the End of Day report), you're able to filter reports by different date ranges:
Tip: A created report can now be filtered/sorted by clicking the icon next to each column header (green). These filtered/sorted results can then be exported to an Excel spreadsheet by clicking the download button (pink).
Financial Reports
Accounts receivable: the amount of money owed to your practice for the amount of work performed in a specific time period; broken down into client/invoice
End of day: contains invoices, payments, totals, and cash drawer reconciliation for a day. Can be run for any single day.
Invoice line item: every invoice line item across all invoices for a specific time period
Invoice summary: every invoice across all patients/clients for a specific time period
Production report: details each doctor’s production quantities (by category), as well as production totals for the clinic
Sales tax report: a breakdown of sales into taxable/non-taxable amounts and the tax totals for all sales, divided into accrual basis and cash basis
Summary report: gives a high level breakdown of: revenue, sales tax, payment types, AR reconciliation, payments, discounts, refunds, returns, sales by product category, invoices, production, and client/patient numbers
QuickBooks Journal Entry Report: This report is a summation of your financial data for the specified date range formatted as an accounting journal entry. The information on this report is usually used with the assistance of a professional accountant or third party software for bookkeeping purposes. Third party tools (such as TransactionPro) can be used to import the financial data directly into Quickbooks Online.
Transaction: all transactions and associated client information for a specific time period
Product and Medication Reports
Controlled drug: all controlled drugs administered to patients (as well as the patient and client name) for a specific time period
Inventory Items Below or at Reorder Point: all items that have reached their Reorder Point
Inventory Items Sale/Usage: how your practice has items set up, and how they are used
Inventory Single Item: a deep dive into the usage of individual items
Inventory Status: view current status of items on your shelf
Product: allows you to run a report for all products in your database—whether active, inactive, or both
Product usage: shows all products administered over a specific timeframe and gives an overview of how each product is set up
Vaccine: all vaccines administered in a specific time period; can be made specifically for rabies vaccinations
Client/Patient Reports
Client: Shows all clients within a specific timeframe who:
Were created in Shepherd
Had a patient added to their profile
Had a patient with a SOAP
Are active/inactive
Patient: Shows all patients within a specific timeframe who:
Were created in Shepherd
Had a SOAP created
Problem and diagnosis: all problems and/or diagnoses recorded in any patient SOAP for a specific time period
Reminders: Shows all reminders
Can be filtered/sorted by Due Date, Patient and/or Client