The Dental Billing Podcast
Dental billing is not data entry. It's the difference between a practice that collects what it earned and one that writes it off and calls it the cost of doing business.
The Dental Billing Podcast is hosted by Ericka Aguilar and Jen Lyman, RDH. Ericka has been a dental biller since 1998 and has taught billing in 31 states and Mexico. Jen came out of the operatory and now runs Lyman Revenue Solutions, handling both dental and medical billing. One of us knows exactly what the carrier is going to do with your claim. The other one knows what actually happened in that chair. You get both.
Every week we break down denials, appeals, coding, and the carrier behavior nobody warns you about, in plain language, with real sources. We teach the law before the codes, because a code doesn't win an appeal. Knowing what that carrier is legally required to do wins the appeal.
If you've ever been told you're "just the biller," this show is for you. Downloads in 114 countries and counting. Bring your coffee and your worst denial.
The Dental Billing Podcast
Billing Meets Bookkeeping: Why Your Numbers Never Match
Use Left/Right to seek, Home/End to jump to start or end. Hold shift to jump forward or backward.
You posted a $100 payment. The bank shows $97. That missing 3% is merchant fees and it is technically income, and if your bookkeeper only records the net deposit, it never shows up anywhere. Neither do your write-offs, your credits or your true production.
In this episode, Jen brought her mom. She is a career bookkeeper who has worked as a tax preparer and for dental CPAs, holds a Level 2 QuickBooks Online ProAdvisor certification, and works for Intuit today. She is here as a bookkeeper and as Jen's mom, not speaking for Intuit.
Every dental office has two sets of books: the practice management software and the accounting software. This episode is about why they so often disagree, who should be checking them every month, and what it costs the doctor when nobody does. Share it with your office manager and whoever does your books.
What we cover:
- Where the missing 3% goes, and why recording only the net deposit hides merchant fees, write-offs and true production from the doctor
- Why that 3% is still income
- The easy math: $100,000 collected with 3% in fees lands as $97,000 in the bank
- Recording gross income first, then fees and adjustments underneath it, so the profit and loss tells the truth
- Who reconciles: one person working the practice management software, a separate bookkeeper matching deposits. Never the same person
- Patient credits are a liability, not revenue. Negative receivables are really payables, and uncashed refund checks become unclaimed property that goes to your state
- Why banks and practice buyers look hard at your receivables report
- Bad debt as an expense on the profit and loss, and why your adjustment types need to be specific
- Make adjustments in the month they happen. Waiting until December makes the whole year wrong
- You don't have an AR (accounts receivable) problem, you have an AP (accounts payable) problem if you are holding onto credits
- Cash versus accrual in plain language
- Why one person handling billing, collections, write-offs and adjustments is an embezzlement risk, and how one office found $80,000 after a single meeting with their bookkeeper and biller together
Nothing in this episode is tax advice for your practice. Take what you hear to your own CPA and attorneys. Everything in this episode is Jen and Alida's experience only.
End of year billing department audit - click here!
Want to know how much treatment you have sitting on the books? Schedule a consultation with MaxAssist here:
https://maxassist.com/thedentalbillingpodcast/
Grab the FREE End of Year Revenue Push Playbook Here:
https://link.captivationhub.com/widget/form/rHoSnbSvVMeFH4V2GFsf
Get your Dental Billing Toolkit Here:
https://www.dentalbillingdoneright.com/the-dental-billing-toolkit
Download "The Most Underused Codes in Dentistry - And How to Get Them Paid" checklist here:
Schedule a billing chat with Ericka:
https://calendly.com/ericka-dentalbillingdoneright/30min
Email Ericka:
ericka@dentalbillingdoneright.com
Email Jen:
jen@dentalbilli...
Meet Jen’s Bookkeeper Mom
SPEAKER_00Welcome back. I'm Jen Lyman, one of the co-hosts of the Dental Billing Podcast. And for once, it's not just me today, I brought my mom. That's not a bit. My mom has been a bookkeeper for more than 30 years. She's been a tax preparer. She's worked for dental CPAs. So she's seen what a dental office's books look like after the billing side hands them over. She's a level two certified QuickBooks Online Pro Advisor. And today she works for Intuit, the company behind QuickBooks. Everything I know about making a ledger balance to the penny I learned at her kitchen table. We spend a lot of time on this show inside the practice management software. Today we're talking about what happens after the money leaves it, when it lands in the bank and in QuickBooks, and why those two sets of numbers so often don't agree. One note before we start she's here as a bookkeeper and as my mom, not speaking for Intuit, and nothing today is tax advice for your practice. Take what you hear to your own CPA. Alita, welcome to the show. I'm excited to be here. Talk about money. Yeah, I feel like we talk about this all the time, but now we get to do it formally. So I want to dive into some questions here about the practice management software, the money that is behind everything. And we talk about, you know, our worlds are colliding at this point. So every dental office has two sets of books, whether they know it or not.
Why Deposits Don’t Match Collections
SPEAKER_00We have the practice management software on our side. And on your side, you have QuickBooks or some kind of bookkeeping software. When collections in the practice management software don't match the deposits in the bank, where do you look first as a bookkeeper and who should be reconciling that every month? Good question.
SPEAKER_01Receivables need to show a true picture of what the practice is doing on a day-to-day basis. So it should show your income, but it also needs to show the income in relation to merchant fees, write-offs, credits, refunds, discounts, anything you give related to the income, anything you give the patient related to the income. So if your collections don't match what's showing up in the bank, there's a disconnect between the practice management software and your accounting software. And usually that is related to all those things I mentioned before: the merchant fees, the refunds, the write-offs, the credits, anything, discounts that you give your patients. Those should be reported to your bookkeeper so that you can have a true picture and things match your practice software versus your accounting software. The disconnect comes in because what's happening is only the net deposit is coming through your bank. Your bookkeeper records that net deposit as income when that net deposit has so many other factors into it that need to be accounted for. But they don't see that. They don't see what's going on behind the scenes. So they only record that net deposit. Does not give you a true picture of what's going on. That workflow should be done by two separate people. Ideally, you would have a person in the office working the practice management software and reconciling that on a day-to-day basis. Then you would have the bookkeeper who would have access to those daily reports and was able to match up those deposits that were actually coming through the bank. You do not want one person doing that. The factor of possible embezzlement or giving their friends free dental is really high.
SPEAKER_00You're just setting yourself up for failure. Yeah, I think we see that a lot in a lot of questions we get from providers are well, I got, you know, it says the payment from the insurance was $100. And, but I only see 97 in my bank account. That kind of leads us to our
Record Revenue Gross Not Net
SPEAKER_00next question. How should a practice record revenue in QuickBooks? Should it be gross production with PPO write-offs shown as adjustments or only what was collected? And then what does each method hide from the doctor?
SPEAKER_01Yeah, so that's a really good question. Income comes through the bank as a net deposit, net of merchant fees. Your sale to the patient was $100. You collected $97. That $3 is not being recorded anywhere. So what's happening is your income is being adjusted by that 3%. It doesn't give you a true picture of what your income was for the practice. It's hiding many things from the doctor. The doctor does not know their true production for a month. They don't know what they paid in merchant fees. They don't know write-offs. They don't have any of those details. Those numbers need to come through on the accounting software as well. They should be shown on a profit and loss as gross income, which was the total income billed to that patient. And then you should have contra accounts, we call them, underneath that are basically negative to those sales. You would have a sale of $100, you would have the merchant fee, $3, and then the net income, $97. You should always gross up your income to the build amount from the practice that day.
SPEAKER_00So we're talking about insurance payments coming in as like virtual credit cards or EFT fees, things like that. You're saying that these would be expenses that can be a loss, according to, you know, a CPA, of course, check with your CPA, but those can be a loss or a business expense at the end of the year on their PL, right? So if it pays by virtual credit card at $100 and then the virtual credit card fee is 3%, that fee comes out before money hits the bank. So you were saying that we record that on the day sheet as an expense, right? So at the end of the year, if we don't track those expenses, it's like it never happened.
SPEAKER_01That's exactly right. Merchant fees are one of those hidden things that they take out before you even see it. And that is the only thing that gets taken out before you even see it. Many, many bookkeepers don't even true up your gross income based on what was actually happening. So you can see a true picture of merchant fees over the course of time. And you can say, hey, why are we paying so much in merchant fees? You can go, maybe let's look for a different merchant provider. If you don't know that information, you're completely dark. You don't have any idea. And it's not a true picture of what your practice is doing. So if you want to sell your practice in the future, it's not as clean, it's not as true. And you don't have the good data you need to make the decisions for your practice regarding merchant fees or the sale of the business. Yeah.
SPEAKER_00That makes a lot of sense. And we get this question a lot as billers when we talk about, you know, a doctor all the time will say, well, that doesn't match what's in my practice management software when an insurance pays. And it is because of fees. So if you're not tracking your merchant fees and if you are not reconciling those to your ledger, it's going to be less than what you're expecting and what is actually showing in your practice management software. For easy math, let's say you collected $100,000, but you have 3% fees in merchant fees every month, your bank account is going to show income of $97,000, not $100,000. And that is a big difference when it comes to reporting and how we're going to actually track how much money the practice is making. You want it to look like you're making $100,000, not $97,000. So when we're talking about trueing up these merchant fees, it's to show the actual income that the practice is collecting, in addition to, you know, comparing that to your production numbers. So you don't want $97,000 collected when you produced $100,000. You want $100,000 collected. It makes a difference for our percentages as well and all the things that we track within a dental practice management software, but it has to equal and match up to what your bookkeeper and what your accounting software is also telling you. Another thing I want to get into here is credits.
Credits Prepayments And Refund Risk
SPEAKER_00So I tell offices, and the last episode was about this, I tell offices a patient credit or prepayment sometimes even is a liability and it's not revenue. What does that look like in QuickBooks? And what happens on the books when a refund check never gets cash? You should never have a negative receivable.
SPEAKER_01On a receivable report, that's your report that shows what your patients owe you on a day-to-day basis at any point in time. If you have a lot of negative numbers on patient balances, that's a problem. Because now those negative numbers are not receivables, they become payables. You owe those to your client in some form or fashion, either as a credit on their next service in the office or as a check in the mail or a refund on a credit card. If perhaps you send a check and it comes back to you as uncashed or could not send to address, those become unclaimed property. They are not to be just written off and thrown to the side. They need to be submitted to your governing state and the unclaimed property division. And here in Oregon, that's a state lands division. Those need to be recorded properly. Also, your receivables report should show you a true picture of what you're making and what you expect to collect. If you have a lot of negative numbers or a lot of write-offs or credits or prepayments, it does not give you a good picture if you want to make a large purchase of new equipment. Usually the bank looks at those receivables numbers and a balance sheet and a profit and loss and says, well, how much are you expected to collect? Receivable numbers really tie into your cash flow statement, how much you're going to collect within the next month or the next 60 days or the next 90 days. It gives you a true picture. If you have a lot of negatives, you don't have good information to make those decisions. And a bank always looks at that. And that will be a red flag for them. Also, anyone who's looking to buy your business, they're going to want to make sure that your patients are paying. You know, they're paying on time, you're collecting the revenue. You don't have this receivable report that's everything is in the 90-day or you have a lot of credits, meaning that you owe people, it's not a good look and it's not a true picture of what your practice is doing.
SPEAKER_00So it actually looks like you're in debt to your patients. If you have, let's say a practice has negative $300,000 in only credits in accounts payable, as you say. I say credits. But, and then their balances, you know, their accounts receivable, their AR report for their patients, excluding credits is $200,000. So they are now in debt to their patients, $100,000. Is that correct? Absolutely.
SPEAKER_01That becomes a payable. You owe it. And now it's a completely different report. What a disaster.
SPEAKER_00So we've talked about kind of our merchant fees and other things that we need to true up to the total gross income for the practice. Now you've also sat on the tax prep side of things too.
Tax Time Clues Your Books Drifted
SPEAKER_00So what shows up at tax time that tells you the billing and the books weren't talking to each other all year?
SPEAKER_01If you run a merchant report at the end of the year from your merchant provider, and it doesn't closely match what you collected or what you billed for the year, the CPA is not necessarily going to make those adjustments for you. And he's not necessarily going to ask you that information in tax preparation. That's usually the job of the bookkeeper or the person who's reconciling your books on a monthly basis. That is why it is so important to have a bookkeeper running these reports, reconciling these things monthly and capturing all those details of merchant fees.
SPEAKER_00A bookkeeper and a CPA and a biller all need to work hand in hand. We had a practice recently this week that was talking about how they were missing money, you know, their bank account was not matching what was being posted. And come to find out after some more digging and one meeting with their bookkeeper, we found out where $80,000 was. So it is not something small that you can just push to the side. Another thing about the monthly reconciling is that I've also seen where if we don't reconcile month to month and we're trying to reconcile a whole year of discounts and where did this money go? And where did this money go? It's so confusing. And I try, I guarantee you, if you don't make ridiculously specific notes, you're going to forget why you gave a discount to this patient, why this debt was written off, why, you know, you have so much in write-offs for this one insurance, whatever the case may be, you need to be able to track that every month. On our end, we track, you know, how much of your income is Delta, how much of your income is GHA, how much of it is regents. All of those things make a difference because then you can also track your write-offs and adjustments up to that dollar amount. One thing I do want to slightly touch on is bad debt as well.
Bad Debt Needs Clear Tracking
SPEAKER_00There are a lot of different state laws that talk about bad debt and how quickly you have to collect from the patient before you can write that off as bad debt and certain requirements. So again, please meet with your CPA or your lawyer on that. But, mom, when it comes to bad debt, how does that get shown in a profit and loss report?
SPEAKER_01It becomes an expense, just like any other expense, office supplies, job supplies, whatever it is. It becomes an expense to the company because you've carried this on your books in receivables for how many months now? And you want to show exactly what was written off.
SPEAKER_00So that also means that we would have to have specific adjustment types, right? To where we would need a bad debt adjustment, we would need a discount adjustment, we would need adjustments to be very, very specific so that you know as a bookkeeper which ones we need to track. Correct.
SPEAKER_01And your prop practice management software should give you that detail. If the level of reconciliation on a daily basis is too much, you can do it monthly, but you do want to show that within the month it happened. You don't want to wait until the end of the year to make these adjustments because what happens is then your books have been wrong the entire year. If you're making huge adjustments in December, your December reports look crazy. They will be huge adjustments and you won't know why. You just got to make those on a monthly basis, keep it within the same month, any adjustments or credits or write-offs and things like that, so that is recorded timely.
Cash Versus Accrual Made Simple
SPEAKER_00As billers, we work off of an accrual basis, right? So a patient will be seen, let's say September 1st, and we don't get payment for maybe two weeks, maybe there's some more information needed or whatever, and we don't get an ad until October. Under the bookkeeping side of things, do you work on a cash basis or an accrual basis? And can you explain the difference between the two?
SPEAKER_01So cash versus accrual is nothing more than when you record the income and the expense. If you provide the service in January of $100 to your patient, but they don't pay until February. On an accrual basis, that income is recorded in January. On a cash basis, that income is recorded in February. Cash versus accrual is nothing more than when you receive that cash. If you bill it, but you don't receive it, that's a cash versus accrual situation. It depends on the industry, depends on how you want to show it. But taxes are normally filed on a cash basis. However, we do want to show those details in a receivables or payables report, and that's where accruals come in from those receivables and payables reports.
SPEAKER_00Okay. I think that is a lot of information.
Month End Handoff And Fraud Controls
SPEAKER_00So from your years working with dental CPAs and all across the industry, really, what does the CPA wish that the billing team handed over at month end? And what mistake do you see the most often that the front desk had no idea they were making?
SPEAKER_01I think the front desk is focused on the patient billing and not what's going on behind the scenes. So the level of detail that most bookkeepers get is not sufficient to produce profit-loss reports that are correct. More detail is needed to make sure that all those pieces are captured. I also think that we hear a lot about embezzlement in any industry, but particularly in the dental industry, and I'll just speak to that. Dental offices are more prone to this type of thing because you have only one person doing the billing, the collecting, the write-offs, the adjustments. There's no visibility to anyone else in the office, much less the owner. Please get two different people. Create an audit. Don't provide the opportunity for anybody to steal from your practice. If you have an audit trail, you want to say, okay, this person handles the billing, the adjustments, the write-offs. What is that number? Comes to the bookkeeper. That should always be reconciled separately. There should be two sets of eyes on any adjustments or write-offs or credits. Don't allow one person to become jailbait.
SPEAKER_00Yes. And this is why we think that it's so important that offices have a CPA and a bookkeeper. Most CPA practices will have a dedicated bookkeeper that they refer to. We see this mistake all the time when it comes to front office. There's one person that's doing the patient payments, the adjusting, the write-offs, the insurance payments, the EFT setup. And the doctor has no idea. That is one of the benefits we believe of doing a third-party billing company because we are very transparent. We don't have access to any actual cash that comes through the practice. We are very transparent when it comes to what your office is collecting, where it's coming from, here's the fees that you are incurring, all of these things that the front desk may not have any idea for. And there's no formal training when it comes to front desk and billing. A lot of times, you know, we're just taking classes, we're learning from different people that may have taught us, but maybe they taught us wrong. And maybe it was for a different state or something like that. It's so important, you guys, that you have multiple sets of eyes on your accounts receivable, your accounts payable, making sure that everything is reconciled in your accounting software as it is in your practice management software. And if you do not have one, I highly, highly encourage you to get one or look at getting a billing company like Erica's or mine that we can take a quick peek at everything. We do an audit, we check for any embezzlement. Things need to be red flagged. So if you're noticing that, let's say Jane Doe up front is doing multiple really large write-offs each month. That needs to be tracked. It needs to be flagged. A couple different things that we look at. But yeah, you're right, Mom. Dental offices are really high risk for embezzlement because there's no reconciliation, there's no oversight. So, mom, thank you for doing this. Here's what I want you guys to do with this one. Your practice management software and your QuickBooks file should agree. And someone should be checking that every month. If nobody in your office owns it, you now know what to ask your bookkeeper and your CPA. Thank you, Mom, for coming on the show. I really appreciate your insight and it's been fun having you here.
What To Do Next
SPEAKER_00Thank you, dear. So, you guys share this with your office manager and whoever does your books owners. If you have any questions, please reach out. Our contact information will be in the show notes. I'm Jen Lyman. Thank you for listening, and I'll see you guys at the next episode.