Various uses of pivot tables in practice including calculating ProSal salaries
DOI:
https://doi.org/10.21423/aabppro20228622Keywords:
production pay, pivot table, ExcelAbstract
The author implemented a production pay system within his veterinary practice, Waupun Veterinary Services LLP, in which partners and senior veterinarians are compensated for 2 different activities. First, a percentage of client invoices is returned to the veterinarian who generated the invoice. Second, activities that benefit the overall health of the practice are compensated. These activities include nights, weekends and holiday on-call, in-clinic management, vacation, continuing education and student/ new hire mentoring. A pivot table within Excel® is used to summarize the data on a monthly basis. Other applications of Excel and pivot tables within the partnership are presented. They include customized client product and services breakout per client requests, aged receivables management, and invoice development from pharmaceutical distributors to client invoices within Sage® accounting. The later invoicing requires no data entry by office staff. All the Excel applications save office labor and increase accuracy by eliminating manual data entry and transfer.