|
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 well 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 youll 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%
|
| |