Veterinary accounting software: what your PIMS should give your accountant
How veterinary accounting software and your PIMS split the bookkeeping: daily cash-ups, month-end locks, write-offs and what the IRS expects from your records.
Every payment your front desk takes ends up in your books. Getting it there cleanly, with nothing changed after the month has closed, is what month-end depends on.
Veterinary accounting software is the accounting package a vet practice uses for its books, bookkeeping and tax filings. It's fed by the payments, invoices and refunds recorded in the practice management system (PMS, often called a PIMS in the US). In a typical setup, a general accounting package holds the ledger and a veterinary PIMS records everything that happens at the front desk and in the exam room. Good veterinary bookkeeping depends on how well those two hand over.
What your PIMS records and what your accounting software does
Your PIMS is where money first gets recorded. Your accounting software is where it gets reported. This split keeps clinical detail out of your ledger.
| Job | Usually done in | Why it sits there |
|---|---|---|
| Invoices for exams, treatments and products | PIMS | The charge comes from the work done for each patient |
| Payments, refunds and payment method | PIMS | The front desk takes them |
| Daily cash-up (end-of-day reconciliation) of cash and card payments | PIMS | It checks the PIMS figures against what was counted |
| Credit memos and bad debt write-offs | PIMS | They change a client's balance |
| General ledger, bank reconciliation, vendor bills | Accounting software | These cover every part of the business, including vendors |
| Payroll and tax returns | Accounting software, payroll provider or your CPA | They draw on figures from across the business |
If your PIMS figures are wrong, your accounting software just records the mistake. So most of the work of clean books happens on the PIMS side, every day.
Every day: reconcile the drawer
A cash-up, or end-of-day reconciliation, compares what your PIMS says you took with what's actually in the cash drawer and on the card terminal. Run it at the end of each day or shift.
A good cash-up screen shows:
- every payment and refund since the last cash-up
- the totals for each payment method (cash, card, check, insurance)
- what you expected in the drawer, what you counted, and the difference
- a place to write a note explaining any difference
Once approved, the cash-up becomes your record of receipts for that period. The IRS's small business recordkeeping guide, Publication 583, includes a daily summary of cash receipts in its example recordkeeping system. If a $10 difference turns up on a Tuesday, you can check it the same week. Found at month-end, it's much harder to trace.
Decide who can approve a cash-up that doesn't balance. You might let any front desk team member approve a clean one and keep differences for a lead CSR or the practice manager.
Every month: close and lock the period
Once a month is reconciled and the figures have gone to your bookkeeper or CPA, lock it. A financial lock stops anyone editing, backdating or refunding transactions dated inside a closed period.
Without a lock, an invoice edited in March for a January exam changes January's figures after your books for that month have been closed. Your PIMS reports and your accounts then disagree, and someone has to find out why.
Lock settings usually work in one of these ways:
- on a fixed date you choose
- a set number of days after each month ends, which gives the team a short window to clean up
- every day at a set time, after the last shift has finished
Fixing a mistake after the period has closed
Locked periods still need corrections sometimes. Your PIMS should let you record them in the current period instead of editing the old invoice.
A credit memo reduces what a client owes, for example when a charge was wrong or as a goodwill gesture. A write-off clears a debt you've decided not to chase. Both should be separate records with a date, a reason and the name of the person who raised them. Your accountant can then see the correction where it happened.
Limit who can raise each one. A goodwill credit and a $400 write-off shouldn't need the same sign-off as a corrected $12 product line.
What the IRS expects from your records
Your practice's records have to meet IRS rules whichever software you use. Your CPA can tell you which of these apply to your business, and whether your state has its own rules.
- Supporting documents. Publication 583 says you must keep supporting documents for the entries in your books, and that electronic records have to meet the same requirements as paper ones.
- How long to keep records. The IRS's record retention guidance says to keep records for 3 years in most cases, 7 years if you claim a bad debt deduction, and employment tax records for at least 4 years.
- Cash or accrual. Publication 538 explains the two most common accounting methods. Under the cash method you generally report income when you receive it. Under the accrual method you generally report it when you earn it, whenever the client pays.
Two things follow for your PIMS. You need those records for as long as the IRS requires, so check you can export your full financial history if you ever change PIMS. And the figures it exports have to match what your accountant reports. The accounting method matters here too: unpaid invoices count differently under cash and accrual, so your accountant needs both invoice and payment figures.
Questions to ask about your PIMS and your accounting software
Ask these before you choose a new PIMS, or when you review your current setup with your CPA:
- How do our invoice and payment figures reach our accounting software, and how often?
- Does the export separate invoices from payments, so it works for our accounting method?
- If our state charges sales tax on products we sell, how is it recorded and reported?
- Can we run a daily cash-up, and who can approve one that doesn't balance?
- Can we lock a closed month, and who can change the lock?
- How are credits and write-offs recorded once a period is locked?
- Can we export reports as a spreadsheet for our accountant?
- Can we get our full financial history out if we leave?
Ask to see each one working in a demo. Then ask your accountant which format they want the figures in. The billing software guide covers the invoice side in more detail.
How Lupa handles the practice side
Lupa is a practice management system (PIMS), so it records the day-to-day money and your accounting software keeps the books.
In Lupa, the Cashups page lists every payment and refund since the last cash-up, totaled by payment method. You enter what you counted, and Lupa shows the difference. You can approve a clean cash-up, or approve it with issues and add notes. Approving one with a difference needs Extended or Full cash-up access, and each cash-up can be saved as a PDF.
The financial lock can lock transactions on or before a date, a set number of days after each month ends, or daily at a set time. Once a day is locked, staff are told to raise a credit note or speak to their manager. Only people with the Manage Financial Lock permission can change it.
Credit notes and write-offs are separate records, and Lupa warns you before you write off a debt that's less than 6 months old. Reports can be exported as CSV files. You can see the rest on our features page, or book a demo to see a cash-up and a month-end lock.
Frequently asked questions
- What accounting software do vets use?
A typical vet practice uses a general accounting package for its books and taxes, and a veterinary PIMS for invoices, payments and end-of-day reconciliation. The PIMS figures are exported into the accounting software, usually every day or every month.
- Does a veterinary PIMS replace accounting software?
Usually not. A veterinary PIMS records invoices, payments and refunds, while your general ledger, bank reconciliation and tax returns usually stay in your accounting software or with your CPA.
- How long should a vet practice keep financial records?
The IRS says to keep records for 3 years in most cases, 7 years if you claim a bad debt deduction, and employment tax records for at least 4 years. Your state may have its own rules, so check with your CPA.
- What is a financial lock in vet software?
A financial lock stops anyone editing, backdating or refunding transactions in a period that has already been closed. Corrections are then recorded in the current period, usually as a credit memo.
- How often should a vet practice reconcile the cash drawer?
Reconciling at the end of every day or shift is the usual rhythm. That way a difference is spotted while the team still remembers the day's payments.
