Copy of Insurance billing cost analysis
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Insurance billing cost analysis
2
Month 1Month 2Month 3Month 4Month 5 Month 6Month 7Month 8Month 9Month 10 Month 11Month 12
3
Your expenses
4
Your salary
5
Rent
6
Money paid to others
7
Equipment
8
Insurance
9
Licensing fees
10
Massage supplies ie. oils
11
Laundry
12
Office supplies
13
Utilities
14
Billing services
15
Association fees
16
Marketing
17
Other
18
Other
19
Other
Total expenses for 12 month period:
Average monthly Expenses (total expenses divided by 12)
20
Totals:00000000000000
21
22
Month 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9Month 10Month 11Month 12
23
Number of total client visits per month:
Total client visits for 12 month period:
Average client visits per month (total client visits divided by 12)
24
00
25
Cost per client (total monthly expenses divided by total monthly client visits):
26
#DIV/0!
27
28
Insurance company name/plan:Health Net
Regence BCBS
ProvidenceKaiserMODALifewisePacificSourceMVA
Workers Comp
29
Fee schedule:


30
Profit margin (fee paid by insurance company minus your cost per client:
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu