|Articles|February 23, 2013

Days in Accounts Receivable Worksheet for Medical Practices

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."

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.

Subscribe Now!

Latest CME

Video

Cases and Conversations™: Applying Best Practices to Prevent Shingles in Your Practice

Paul G. Auwaerter, MD, MBA; Paul P. Doghramji, MD, FAAFP; Aruna Subramanian, MD

Video

Clinical Consultations™: Addressing Elevated Phosphate Levels in Patients with END-STAGE Kidney Disease (ESKD)

Anil K. Agarwal, MD, FACP, FASN, FNKF, FASDIN; Jay B. Wish, MD

Multimedia

Advances In: Managing Hyperphosphatemia in Chronic Kidney Disease – Bridging Treatment Gaps With Novel Therapies

Glenn M. Chertow, MD, MPH; Anjay Rastogi, MD, PhD

Case-based Simulation

SimulatED™: Understanding the Role of Genetic Testing in Patient Selection for Anti-Amyloid Therapy

Nicholas Doher, DO; Babak Tousi, MD

Multimedia

Burst CME™: Addressing Inadequate Response to Anti-TNF Therapy in Patients With Rheumatoid Arthritis

Jeffrey A. Sparks, MD, MMSc

Multimedia

Community Practice Connections™: Cases and Conversations – Keeping Up with Novel Approaches to Managing ANCA-Associated Vasculitis

Frank B. Cortazar, MD; Lindsay S. Lally, MD

Video

Burst CME: Targeted Therapy for Optimal Psoriasis Management

Tina Bhutani, MD

Video

Cases and Conversations™: A Horizon View of Continuous Monitoring Systems for Diabetes Management

Diana Isaacs, PharmD, BCPS, BC-ADM, BCACP, CDCES, FADCES, FCCP; Anders Carlson, MD; Jennifer B. Green, MD

Video

Progress in Hyperlipidemia Management to Reduce ASCVD Risk: An Illustrated Update

Nihar R. Desai, MD, MPH; Martha Gulati, MD, MS, FACC, FAHA, MASPC, FESC, FSCCT (hon), FRCP Edin

Days in Accounts Receivable Worksheet for Medical Practices

Newsletter

Related Content

Medical billing and budgeting: What every practice needs to know

Staying resilient with Andrew Swanson, M.P.A., FACMPE, of MGMA

Making the most of referrals

Should your practice outsource?

Boosting collections

Latest CME

Cases and Conversations™: Applying Best Practices to Prevent Shingles in Your Practice

Clinical Consultations™: Addressing Elevated Phosphate Levels in Patients with END-STAGE Kidney Disease (ESKD)

Advances In: Managing Hyperphosphatemia in Chronic Kidney Disease – Bridging Treatment Gaps With Novel Therapies

SimulatED™: Understanding the Role of Genetic Testing in Patient Selection for Anti-Amyloid Therapy

Burst CME™: Addressing Inadequate Response to Anti-TNF Therapy in Patients With Rheumatoid Arthritis

Community Practice Connections™: Cases and Conversations – Keeping Up with Novel Approaches to Managing ANCA-Associated Vasculitis

Burst CME: Targeted Therapy for Optimal Psoriasis Management

Cases and Conversations™: A Horizon View of Continuous Monitoring Systems for Diabetes Management

Progress in Hyperlipidemia Management to Reduce ASCVD Risk: An Illustrated Update

Trending on Physicians Practice

7 reasons your medical practice shouldn’t outsource

AI's hidden hand: Decoding prepayment denials and the evasion of high-dollar claims

Learning moment: Medicaid fraud is still a priority

Putting fun in the medical practice: Hire for attitude, train for skills

New lessons in lifestyle medicine, with Jennifer Trilk, Ph.D., FACSM, DipACLM