General Financial Performance

General Practice Management

FINANCIAL PERFORMANCE ANALYSIS AND REPORTS

In the last issue we laid the groundwork for a monthly reporting package. We showed how to prepare reports of clinical activity and patient type. In this issue we’ll use the data from those reports in describing the reporting of collection performance, accounts receivable (AR), and practice expense.  

Collection Performance  
There are several ways to display collection performance in a report. Because very few computer systems can display a revenue flow report of this type, in most cases you’ll have to build this table on a spreadsheet, using data from the billing computer system. Here is an example (the acronym GCR refers to Gross Collection Ratio):

 

Month

Charges

Coll'n

Pct

Cum

GCR

Cum

GCR

Cum

GCR

Cum

GCR

Cum

GCR

Cum

GCR

Cum

 

 

Jan

 

Coll'n

 

Coll'n

 

Coll'n

 

Coll'n

 

Coll'n

 

Coll'n

 

Coll'n

 

 

 

 

Feb

 

Mar

 

Apr

 

May

 

Jun

 

July

 

Aug

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Jan

$55,445

$1,219

2.20%

$19,384

34.96%

$29,404

53.03%

$30,254

54.57%

$31,098

56.09%

$31,248

56.36%

$31,841

57.43%

$31,901

Feb

$47,276

 

 

$1,063

2.25%

$6,618

14.00%

$13,968

29.55%

$17,512

37.04%

$21,104

44.64%

$22,008

46.55%

$22,019

Mar

$50,610

 

 

 

 

$1,506

2.98%

$10,349

20.45%

$13,193

26.07%

$18,552

36.66%

$19,919

39.36%

$20,194

Apr

$63,320

 

 

 

 

 

 

$1,231

1.94%

$10,666

16.84%

$17,663

27.89%

$26,887

42.46%

$27,741

May

$73,549

 

 

 

 

 

 

 

 

$178

0.24%

$11,807

16.05%

$17,094

23.24%

$20,579

Jun

$55,507

 

 

 

 

 

 

 

 

 

 

$3,017

5.44%

$8,832

15.91%

$17,502

Jul

$89,220

 

 

 

 

 

 

 

 

 

 

 

 

$898

1.01%

$8,434

Aug

$81,175

 

 

 

 

 

 

 

 

 

 

 

 

 

 

$1,226

Sept

$85,569

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Oct

$51,200

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

TOTAL

$652,871

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

This table shows how revenue flows into the practice. All of the collections are tied to the charges that generated them.  

Another format for the same information is as follows:

 

 

Coll'n Month 1

Coll'n Month 2

Coll'n Month 3

 

Coll'n Month 4

 

Coll'n Month 5

 

 

$

%

 

$

%

Cum%

 

$

%

Cum%

 

$

%

Cum%

 

$

%

Cum%

Month

Charges

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Jan

$55,445

$1,220

2.20%

 

$18,164

32.76%

34.96%

 

$10,019

18.07%

53.03%

 

$854

1.54%

54.57%

 

$843

1.52%

56.09%

Feb

$47,276

$1,064

2.25%

 

$5,555

11.75%

14.00%

 

$7,351

15.55%

29.55%

 

$3,541

7.49%

37.04%

 

$3,593

7.60%

44.64%

Mar

$50,610

$1,508

2.98%

 

$8,842

17.47%

20.45%

 

$2,844

5.62%

26.07%

 

$5,360

10.59%

36.66%

 

$1,366

2.70%

39.36%

Apr

$63,320

$1,228

1.94%

 

$9,435

14.90%

16.84%

 

$6,997

11.05%