5 ways to prepare for End of Year Inventory

By Michelle Campoli, CVT, CVPM

1. Post inventory receipts for all products that you’ve received. Set the Receipt List window to show any receipts with a status of Not Posted and a longer date range to catch any overlooked receipts that were started and saved. Only posted inventory receipts will update cost and quantity on hand.

2. Perform a cycle count. Go to Reports > Inventory > Counts Report. Have the report sort by class or location to streamline the process.

3. Correct any Quantity on Hand (QOH) amounts, from the View Quantity on Hand window using the same criteria from the report so the window matches (filter/sort by class or location).

  • Using the Shift (for consecutive item selection) or Ctrl (for non-consecutive item selection) keys, select the items that need to be adjusted and click Edit QOH.
  • Update each record with correct QOH and adjustment reason and click next record, and then Save when all selected records have updated.

4. Correct any costs as needed. Go to Reports > Inventory > Cost Report to review for any potential cost discrepancies by comparing last purchase (vendor) cost and average cost columns.

  • To adjust a cost (average) after updating the QOH, go to Inventory > Adjustment List > New Cost Adjust.
  • After selecting the item, enter either a new average cost or total cost amount and click Save.
  • Repeat for each item as needed.

5. Inventory reports to retain for end of year inventory record keeping (run prior to EOY processing):

  • Inventory Cost Report and Inventory Cost Totals Report (both are saved in the cstone Share folder as PDFs when EOY is processed.)
  • Items Profit Analysis Report

Cornerstone Roadshow Classes at VHMA

We have three Cornerstone courses taking place at the Veterinary Hospital Manager’s Association (VHMA) Conference in New Orleans.

Do you or your team members want to take full advantage of all the features and functionality in your versatile Cornerstone Software? Learn about all of it’s latest capabilities available and how to make the most of the system by registering for:

Getting the Most Out of Your Cornerstone Practice Management System
Saturday, September 30, 1:30 p.m.–5:00 p.m. CT
CE credits: 3
Sign up

For advanced users, we’re offering two new classes:

Advancing Your Inventory and Reporting Know-how
Sunday, October 1, 8:30 a.m.–12:00 p.m. CT
CE credits: 3
Sign up

Mastering Efficiency and Communications with Electronic Medical Records and Whiteboards
Sunday, October 1, 1:30 a.m.–5:00 p.m. CT
CE credits: 3
Sign up

Register for one, two, or all three. Each class is a unique opportunity to learn tips and tricks from Cornerstone® Software expert Michelle Campoli, network with other users, and have fun.

No charge to attend. These classes are one more benefit of your Cornerstone support contract. And although they take place during the VHMA, you don’t need to be registered for the conference to attend.

Courses take place at the New Orleans Marriott
555 Canal Street
New Orleans, LA 70130
(504) 581-1000

Your laboratory results, in one location

By Michelle Campoli, CVT, CVPM

Do you ever run a lab test like an in-house fecal or a glucose on a glucometer and wish the result would appear on the Lab tab of the Patient Clipboard with your other results? You can! Just follow these 3 simple steps for both setup and entry.

Setup
1. Define an age group for the appropriate species the lab entry will be made for under Lists > Species > Lab Age Groups.
Tip: For simplicity, use a single age range unless you need age specific default test ranges

2. Create a lab template under Activities > Lab Work > Templates
Tip: use ‘In House’ to group other manual entry templates together on the template list

3. Set Default High and Low Values under Activities > Lab Work > Default Test Ranges


 
Entry
1. Go to Activities > Lab Work > Manually Enter Results
2. Enter the patient information and select the correct lab, staff, and template*
3. Enter in the Value field and click OK


* for those of you already using manual lab entry for tests such as bile acid results from an unintegrated lab, use the Chemistry template to access the BILE01, BILE02 and BILE03 tests

Your result is now on the Lab tab of the Patient Clipboard and the Diagnostics tab of the Daily Planner (see examples below). How cool is that? And as always, you can use F1 within Cornerstone for more help.

 

Michelle Campoli loves teaching people how they can do more with Cornerstone. When she’s not sharing her favorite tips and tricks in one of our Cornerstone user group meetings, Michelle enjoys spending time with her husband, cat, and three retired greyhounds; playing in her kitchen and volunteering for her local greyhound adoption group.

Cornerstone Roadshow classes at CVC Kansas City

The Cornerstone Roadshow is coming to the CVC Kansas City Convention, with classes for users of all levels. Register for one, two, or all three classes: each one is a unique opportunity to learn tips and tricks from Cornerstone Software expert Michelle Campoli, network with other users, and have fun.

Do you or your team members want to learn new ways to use Cornerstone to save time every day and streamline essential tasks and workflows? Register for this brand-new course (appropriate for basic through advanced users): 

Tips and workflows to keep your day on track and connect with more clients
Friday, August 25, 8:30 a.m.–11:00 a.m. CT
Register now 

For advanced users, we’re offering two new classes:

Mastering Efficiency and Communications with Electronic Medical Records and Whiteboards
Friday, August 25, 1:30 p.m.–5:00 p.m. CT
CE credits: 3
Register now 

Advancing Your Inventory and Reporting Know-how
Saturday, August 26, 8:30 a.m.–11:00 a.m. CT
CE credits: 3
Register now 

No charge to attend. These classes are one more benefit of your Cornerstone support contract. And although they take place during CVC Kansas City, you don’t need to be registered for the conference to attend.

Only 30 seats per session: register today!

5 ways Cornerstone makes going paperless easy

By Michelle Campoli, CVT, CVPM

Going paperless can seem like a daunting task, but it doesn’t need to be! Here are 5 tools within Cornerstone to help make the process easier:

1. Starter medical note templates
Cornerstone has medical note templates designed to help you easily create medical records and patient report cards. These documents can be used as-is or customized to your preferences. And they can be emailed, printed, or shared on Pet Health Network Pro Petly Pages with the click of a button. Templates include top reasons for visit like: skin/dermatology, ears, eye, limping/orthopedic, and vomiting. Plus, preventive care visits for all three of the life stages for both dogs and cats are also available.

2. AAHA Diagnostic Code list
A standard in the veterinary industry, this list is automatically available within the Cornerstone database for all recently install systems. If you don’t have the list, you can request to have it imported into your database here.

3. Daily Planner
One big barrier for going paperless is that doctors worry they will forget to finish their records if the physical chart is not on their desk. The Daily Planner is like a virtual desk that can be viewed for a specific staff ID (i.e. Doctor) or for all staff. Easy to use tabs (like stacks of charts) show patients that have checked-in, tentative medical notes (records you need to finish), incoming lab results and pending charges. Now your desk is always as close as the nearest computer!

4. Integrated diagnostics with VetConnect Plus and IDEXX PACS
If you have lab results and images within Cornerstone – congrats! Your already paperless! This information is stored in your patient’s electronic record, which means no more pages of results or hard films. All IDEXX results (reference lab or in-house) can be viewed side-by-side with VetConnect Plus directly through the Patient Clipboard or the Daily Planner. And all images can be viewed from any computer, how cool is that?

5. Touchscreen signature capture
Estimates and consents can be signed by the client electronically. The signed document is then stored within the patient record – pretty slick! All you need is a touchscreen laptop and Cornerstone 8.4 NEXT or higher, then follow these steps:

  • Add electronic signature options to your estimate defaults (Controls > Defaults > Practice & Workstations > Estimates)
  • Ensure consent forms are setup as a document type (not title, or print only)
  • Use the client signature bookmark

Plus staff signatures can also be stored under Lists > Staff > Signature. Then use the staff signature with password bookmark on any needed document’s.

 

Michelle Campoli loves teaching people how they can do more with Cornerstone. When she’s not sharing her favorite tips and tricks in one of our Cornerstone user group meetings, Michelle enjoys spending time with her husband, cat, and three retired greyhounds; playing in her kitchen and volunteering for her local greyhound adoption group.

Record attendance at NAVC, WVC and AAHA Cornerstone Roadshows!

Here’s a shout-out to everyone who joined us for Cornerstone Roadshow courses at NAVC, WVC and AAHA. Attendance topped 220, and we’ll award 687 CE credits!

Among those was Stacey Hamilton, practice manager at AAHA’s 2017 Hospital of the Year, Loving Family Animal Hospital, Aurora, Colorado. “This class is going to make me more efficient as a manager,” she said. “I’ll have a system that will free me up so I can dedicate more time to helping my staff reach their goals.”

Click here to find Cornerstone Roadshow classes coming to your area.

Cornerstone End of Year FAQs

By Michelle Campoli, CVT, CVPM

For many of us, the end of December means end of year processing. While attending to both personal and practice needs, end of year often becomes a scramble and some of the details can slip past us. To lend a helping hand, here are some EOY FAQs to help you stay on track.

When should I run end of year?

End of year should be processed on the last business day of the year. Most practices run it December 31st. We recommend consulting with your accountant to determine if a calendar or fiscal end of year is best for your practice.

Note: end of year should be processed at the same time each year (Ex: every Dec 31) in order to create meaningful year-year comparisons. Be sure to check out our recommended processing steps in the EOY tutorial.

What about my end of year backup?

We recommend two backups:

  1. Before you begin your end of period processing (in the event of an error during processing)
  2. After processing EOD, EOM and EOY. Make sure to store this in a secure location!

Note: during the EOY process, you are prompted to make another database copy. This copy is optional. Review the backup section of the EOY tutorial for additional details.

There are so many reports. Which ones should I be looking at?

We recommend the following reports for your annual reporting:

  • Account Write Off
  • High/Low Client Sales
  • Inventory Sales
  • Sales Tax Summary/Income Reconciliation
  • Service Sales
  • Statistics by Staff and Species reports
  • Yearly Sales summary

Note: these reports can be run at any time once EOY has been processed.To help remember which ones to run, set them as default EOY reports under: Controls > Defaults > Practice & Workstation > End of Period

I forgot to run my year-end inventory reports!

It happens. Luckily, a copy of your year-end Inventory Cost and Cost Totals reports are saved in pdf format under the Cstone/Share/EOYInvCost folder. Another helpful report that should be run before you start your EOP processing for the year is the Inventory Item Profit Analysis report. The following reports are also recommended and can be run at any time as well as for past periods:

  1. Inventory Sales
  2. Cost of Goods Sold

Note: The EOY tutorial includes recommended steps to help ensure your EOY inventory is accurate!

Recommended end of year resources:

Interactive End of Year tutorial
End of Year Checklist

Request a demo