Tuesday, May 31, 2016

Why don't my reports show the same numbers . . . grrrrrr!

“I have pulled up three different reports trying to find out what my accounts receivable number is and they all have different numbers,” says Nichole from a client office in New York. Renee from a different office states, “I have a patient who has a $6,000 balance and she has never received a statement and she did not show up on my collection report.” Sound familiar? I know these situations can be frustrating and it is easy to blame the software for differences in reporting. However, I want to take you through a few check points to make sure you are getting similar data on different reports and also walk you through what is different on reports.


If you have been reading my blog for a while, you know that my favorite report for managing your accounts receivable is the CollectionManager. There are some things to know about the Collection Manager Report . . .

  • This report only shows positive accounts receivable so if you are trying to compare it to an Aging Report or the Practice Analysis snapshot, you will not get the same numbers. The Aging Report can be filtered to show all balances, positive balances or credits, and, if you have a lot of credit balances, these two reports could show very different bottom line numbers.
  • The Collection Manager can be filtered down a lot to give you a very specific report or a very broad report and, depending on how you are matching it up to another A/R report, if you don’t select the same parameters, you will get different numbers.

If you are looking at the snapshot Practice Analysis report (Office Manager > Analysis > Practice), then you will also get a different ending balance depending on a few things . . .

  • This snapshot is affected by month end so, depending on if you are up to date with month end, will determine how accurate this number is and if it will match up to any other A/R report.
  • This Analysis snapshot cannot be filtered by billing type … so if you have balances in billing types like “Sent to Collection,” this will affect this number.
  • This report is only run by Entry Date (you cannot change this). If you are running any of the other A/R reports by Procedure Date, then you will get different numbers.

Most of the accounts receivable and collection management reports can be filtered by different parameters to give you different numbers. Here are the most common troubleshooting tips to check if you are matching up reports.

  • Did you select the same providers?
  • Did you select the same billing types?
  • Did you choose Entry Date or Procedure Date?
  • What aging category did you select?
  • Are you selecting the same date range or ending date?
  • Were there any other boxes that were checked that might have filtered out a particular patient from one report over another? In the first paragraph, I had an office questioning why a particular patient did not show up on the Collection Manager Report. It was because she had checked “If not billed since” on the filters so this particular patient had been excluded.


Hopefully this will help you understand how different each report is and why they might give you different numbers. Numbers tell a story and it is important to have as accurate report as possible.


Dayna Johnson, Certified Dentrix Trainer
Dayna loves her work. She has over 25 years of experience in the dental industry, and she’s passionate about building efficient, consistent, and secure practice management systems. Dayna knows that your entire day revolves around your practice management software—the better you learn to use it, the more productive and stress-free your office will be. In 2016, Dayna founded Novonee ™, The Premier Dentrix Community, to help cultivate Dentrix super-users all over the country. Learn more from Dayna at www.novonee.com and contact Dayna at dayna@novonee.com.


No comments:

Post a Comment