Days in Accounts Receivable Worksheet for Medical Practices

Article

Here's an Excel-based tool to help you better understand how long it is taking for claims to be paid at your medical practice.

Knowing your medical practices days in accounts receivable (A/R) is critical information and simple to calculate. Here's a spreadsheet you can use to start filling in your monthly charges and your monthly A/R. This will help you understand how long it is taking for your claims to be paid.

For more information, see P.J. Cloud-Moulds' blog "Anticipating and Planning the Finances of Your Medical Practice."

Newsletter

Optimize your practice with the Physicians Practice newsletter, offering management pearls, leadership tips, and business strategies tailored for practice administrators and physicians of any specialty.

Recent Videos
Should your practice outsource?
Boosting collections
Getting your practice paid fast
© 2025 MJH Life Sciences

All rights reserved.