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
Must-dos before you upgrade your tech
Safeguard your bottom line
Tips for controlling overhead costs
© 2025 MJH Life Sciences

All rights reserved.