Choices are saved for this tab and remembered after reload.
Page 1 / 1
#
Section / Carrier / Patient
Chart #
Visit #
Provider
CPT
Current
30 Days
60 Days
90 Days
120 Days
Total
1
CCM25 carriers · 1,174 lines
$0.00
$29,719.58
$0.00
$10,652.01
$24,207.97
$64,579.56
AET07Aetna4 lines
$0.00
$187.94
$0.00
$171.08
$0.00
$359.02
AETN2Aetna Better Health11 lines
$0.00
$0.00
$0.00
$223.34
$467.60
$690.94
AMB03Ambetter From Sunshine Health8 lines
$0.00
$187.94
$0.00
$121.51
$292.59
$602.04
AHP01American Health Plan36 lines
$0.00
$1,691.46
$0.00
$0.00
$1,473.72
$3,165.18
CARE1Careplus Health Plans5 lines
$0.00
$187.94
$0.00
$99.14
$171.08
$458.16
CIG09Cigna Ppo14 lines
$0.00
$563.82
$0.00
$171.08
$513.24
$1,248.14
FLO01Florida Blue Shield28 lines
$0.00
$776.82
$0.00
$368.92
$358.64
$1,504.38
FCC00Florida Community Care46 lines
$0.00
$751.76
$0.00
$537.45
$609.31
$1,898.52
FCC05Florida Complete Care2 lines
$0.00
$187.94
$0.00
$0.00
$0.00
$187.94
FLO03Florida Medicaid354 lines
$0.00
$751.76
$0.00
$2,421.12
$5,251.20
$8,424.08
FLO02Florida Medicare311 lines
$0.00
$16,350.78
$0.00
$2,627.65
$4,639.51
$23,617.94
FREE1Freedom Health12 lines
$0.00
$375.88
$0.00
$0.00
$634.75
$1,010.63
HEAL1Health First Health Plan5 lines
$0.00
$187.94
$0.00
$0.00
$193.45
$381.39
HUM01Humana99 lines
$0.00
$2,443.22
$0.00
$857.80
$2,716.96
$6,017.98
Not Billed Yet27 lines
$0.00
$563.82
$0.00
$243.02
$1,391.01
$2,197.85
OSCA1Oscar Insurance24 lines
$0.00
$563.82
$0.00
$513.24
$976.91
$2,053.97
RAIL1Rail Road Medicare8 lines
$0.00
$187.94
$0.00
$171.08
$342.16
$701.18
SIMP1Simply Healthcare Plans37 lines
$0.00
$939.70
$0.00
$392.81
$363.25
$1,695.76
SUN01Sunshine State Health Plan43 lines
$0.00
$1,127.64
$0.00
$64.35
$860.25
$2,052.24
TRI05Tricare For Life10 lines
$0.00
$0.00
$0.00
$21.45
$86.36
$107.81
ULTI1Ultimate Health Plans2 lines
$0.00
$0.00
$0.00
$0.00
$171.08
$171.08
AAR01Uni0110 lines
$0.00
$0.00
$0.00
$64.35
$42.90
$107.25
UNI20United Healthcare64 lines
$0.00
$1,315.58
$0.00
$1,240.46
$2,138.76
$4,694.80
WEL04Wellcare6 lines
$0.00
$187.94
$0.00
$171.08
$171.08
$530.10
WELL4Wellmed8 lines
$0.00
$187.94
$0.00
$171.08
$342.16
$701.18
2
AcuteCare/Telehealth21 carriers · 976 lines
$23,356.05
$30,504.39
$19,609.29
$8,313.46
$0.00
$81,783.19
AET07Aetna4 lines
$0.00
$95.64
$95.64
$215.76
$0.00
$407.04
AHP01American Health Plan10 lines
$647.28
$407.04
$175.30
$0.00
$0.00
$1,229.62
CARE1Careplus Health Plans40 lines
$395.94
$1,054.32
$2,010.72
$742.92
$0.00
$4,203.90
CIG09Cigna Ppo1 lines
$143.46
$0.00
$0.00
$0.00
$0.00
$143.46
CIGHS01Cigna-Healthspring3 lines
$286.92
$0.00
$0.00
$16.26
$0.00
$303.18
FLO01Florida Blue Shield138 lines
$3,240.66
$6,546.16
$3,035.21
$1,196.64
$0.00
$14,018.67
FCC00Florida Community Care8 lines
$0.00
$399.73
$0.00
$0.00
$0.00
$399.73
FLO03Florida Medicaid144 lines
$134.53
$1,152.93
$997.97
$321.82
$0.00
$2,607.25
FLO02Florida Medicare142 lines
$6,127.24
$3,215.59
$1,564.48
$606.36
$0.00
$11,513.67
FREE1Freedom Health32 lines
$812.94
$2,130.84
$335.88
$191.28
$0.00
$3,470.94
HUM01Humana271 lines
$5,583.22
$9,666.70
$8,561.54
$3,312.77
$0.00
$27,124.23
Not Billed Yet43 lines
$669.48
$1,076.52
$2,273.16
$431.52
$0.00
$4,450.68
OPTI1Optimum Healthcare12 lines
$478.20
$789.60
$0.00
$0.00
$0.00
$1,267.80
OSCA1Oscar Insurance7 lines
$0.00
$669.48
$0.00
$0.00
$0.00
$669.48
SIMP1Simply Healthcare Plans10 lines
$0.00
$284.96
$236.18
$120.12
$0.00
$641.26
SUN01Sunshine State Health Plan15 lines
$0.00
$310.54
$168.16
$0.00
$0.00
$478.70
TRI05Tricare For Life6 lines
$0.00
$0.00
$16.26
$89.91
$0.00
$106.17
AAR01Uni015 lines
$16.26
$52.94
$19.13
$0.00
$0.00
$88.33
UNI20United Healthcare76 lines
$4,496.28
$2,651.40
$119.66
$349.66
$0.00
$7,617.00
VACCN01Va Community Care Network1 lines
$0.00
$0.00
$0.00
$120.12
$0.00
$120.12
WEL04Wellcare8 lines
$323.64
$0.00
$0.00
$598.32
$0.00
$921.96
3
Cardiology25 carriers · 1,049 lines
$35,009.73
$21,261.98
$15,098.70
$6,083.04
$3,340.20
$80,793.65
AET07Aetna13 lines
$0.00
$731.96
$351.09
$78.73
$78.73
$1,240.51
AETN2Aetna Better Health14 lines
$216.17
$660.83
$141.71
$141.71
$0.00
$1,160.42
AMB03Ambetter From Sunshine Health12 lines
$228.10
$236.19
$338.48
$220.44
$141.71
$1,164.92
AHP01American Health Plan44 lines
$3,972.18
$451.77
$458.67
$124.26
$236.19
$5,243.07
CARE1Careplus Health Plans6 lines
$102.29
$16.93
$414.07
$0.00
$0.00
$533.29
CIG09Cigna Ppo20 lines
$560.19
$826.72
$157.46
$94.48
$173.21
$1,812.06
FLO01Florida Blue Shield12 lines
$731.42
$131.83
$344.70
$0.00
$78.73
$1,286.68
FCC00Florida Community Care19 lines
$370.07
$229.37
$45.45
$0.00
$0.00
$644.89
FCC05Florida Complete Care3 lines
$0.00
$0.00
$0.00
$299.17
$0.00
$299.17
FHCPFlorida Health Care Plan2 lines
$0.00
$0.00
$220.44
$0.00
$0.00
$220.44
FLO03Florida Medicaid252 lines
$704.02
$3,114.78
$2,443.81
$1,454.85
$351.09
$8,068.55
FLO02Florida Medicare219 lines
$15,424.27
$3,702.67
$2,008.63
$92.78
$1,132.56
$22,360.91
FREE1Freedom Health25 lines
$1,607.48
$1,432.42
$0.00
$0.00
$114.90
$3,154.80
HEAL1Health First Health Plan8 lines
$78.73
$220.44
$414.35
$220.44
$0.00
$933.96
HUM01Humana123 lines
$4,597.14
$2,694.59
$2,196.98
$1,006.32
$78.73
$10,573.76
INNO1Innovage Florida1 lines
$0.00
$193.91
$0.00
$0.00
$0.00
$193.91
MOL10Molina Healthcare Of Florida3 lines
$0.00
$34.77
$0.00
$0.00
$0.00
$34.77
Not Billed Yet29 lines
$259.75
$1,316.55
$844.17
$299.17
$78.73
$2,798.37
OSCA1Oscar Insurance72 lines
$536.63
$1,992.42
$2,960.05
$1,426.48
$713.24
$7,628.82
SIMP1Simply Healthcare Plans31 lines
$528.15
$445.65
$51.70
$0.00
$0.00
$1,025.50
SUN01Sunshine State Health Plan63 lines
$1,648.68
$1,263.71
$684.61
$371.51
$0.00
$3,968.51
TRI05Tricare For Life3 lines
$0.00
$11.59
$11.59
$11.59
$0.00
$34.77
AAR01Uni0111 lines
$50.79
$147.28
$114.95
$0.00
$0.00
$313.02
UNI20United Healthcare52 lines
$3,094.93
$982.17
$357.46
$99.40
$162.38
$4,696.34
WEL04Wellcare12 lines
$298.74
$423.43
$538.33
$141.71
$0.00
$1,402.21
4
WoundCare30 carriers · 2,392 lines
$33,951.20
$82,837.58
$42,577.56
$28,108.38
$62,597.86
$250,072.58
AET07Aetna37 lines
$0.00
$2,245.12
$708.22
$1,291.37
$760.20
$5,004.91
AETN2Aetna Better Health24 lines
$149.37
$2,458.54
$324.81
$0.00
$355.33
$3,288.05
AMB03Ambetter From Sunshine Health7 lines
$0.00
$0.00
$656.48
$0.00
$31.88
$688.36
AHP01American Health Plan103 lines
$2,770.17
$1,444.23
$2,516.99
$2,418.34
$4,832.97
$13,982.70
CARE1Careplus Health Plans51 lines
$213.09
$806.24
$1,410.92
$547.31
$1,681.43
$4,658.99
CHA03Champva9 lines
$0.00
$24.15
$0.00
$0.00
$120.57
$144.72
CIG09Cigna Ppo39 lines
$0.00
$320.65
$0.00
$120.68
$860.07
$1,301.40
CIGHS01Cigna-Healthspring13 lines
$651.38
$1,214.73
$434.72
$0.00
$0.00
$2,300.83
FLO01Florida Blue Shield84 lines
$621.96
$3,869.23
$1,107.15
$1,676.94
$1,464.88
$8,740.16
FCC00Florida Community Care12 lines
$48.58
$490.40
$0.00
$148.91
$0.00
$687.89
FCC05Florida Complete Care10 lines
$0.00
$0.00
$0.00
$0.00
$932.59
$932.59
FHCPFlorida Health Care Plan14 lines
$0.00
$0.00
$2,032.01
$0.00
$193.91
$2,225.92
FLO03Florida Medicaid294 lines
$47.17
$1,858.47
$2,414.07
$579.39
$3,049.23
$7,948.33
FLO02Florida Medicare743 lines
$21,326.10
$32,617.19
$7,953.21
$2,694.20
$18,272.06
$82,862.76
FREE1Freedom Health148 lines
$2,023.41
$8,324.58
$2,075.43
$2,366.76
$6,992.53
$21,782.71
HEAL1Health First Health Plan12 lines
$0.00
$1,148.66
$817.11
$0.00
$0.00
$1,965.77
HUM01Humana166 lines
$1,714.59
$7,100.08
$3,870.27
$3,913.49
$3,379.96
$19,978.39
Not Billed Yet2 lines
$0.00
$0.00
$0.00
$322.25
$0.00
$322.25
OPTI1Optimum Healthcare8 lines
$352.58
$556.37
$0.00
$0.00
$121.51
$1,030.46
OSCA1Oscar Insurance111 lines
$0.00
$2,409.50
$5,827.00
$2,251.90
$5,896.24
$16,384.64
RAIL1Rail Road Medicare6 lines
$0.00
$0.00
$0.00
$0.00
$823.28
$823.28
SIMP1Simply Healthcare Plans53 lines
$953.48
$1,678.63
$683.28
$176.42
$1,855.91
$5,347.72
SUN01Sunshine State Health Plan204 lines
$2,009.60
$8,724.19
$5,938.32
$4,827.83
$5,464.95
$26,964.89
TRI05Tricare For Life13 lines
$0.00
$53.44
$65.09
$54.39
$113.43
$286.35
ULTI1Ultimate Health Plans1 lines
$0.00
$0.00
$0.00
$0.00
$114.90
$114.90
AAR01Uni0110 lines
$0.00
$116.41
$177.93
$0.00
$0.00
$294.34
UNI20United Healthcare199 lines
$920.35
$5,141.69
$2,984.04
$4,065.19
$4,314.42
$17,425.69
VACCN01Va Community Care Network5 lines
$0.00
$0.00
$416.41
$324.81
$0.00
$741.22
WEL04Wellcare11 lines
$0.00
$0.00
$164.10
$328.20
$965.61
$1,457.91
WELL4Wellmed3 lines
$149.37
$235.08
$0.00
$0.00
$0.00
$384.45
5
Physiatry12 carriers · 75 lines
$1,385.39
$3,788.73
$1,226.09
$0.00
$0.00
$6,400.21
CARE1Careplus Health Plans3 lines
$181.02
$141.71
$0.00
$0.00
$0.00
$322.73
CIG09Cigna Ppo2 lines
$0.00
$272.64
$0.00
$0.00
$0.00
$272.64
FLO03Florida Medicaid12 lines
$0.00
$276.18
$221.19
$0.00
$0.00
$497.37
FLO02Florida Medicare12 lines
$468.24
$368.45
$23.04
$0.00
$0.00
$859.73
HEAL1Health First Health Plan1 lines
$0.00
$193.91
$0.00
$0.00
$0.00
$193.91
HUM01Humana10 lines
$0.00
$654.80
$34.01
$0.00
$0.00
$688.81
MOL10Molina Healthcare Of Florida2 lines
$0.00
$13.64
$33.10
$0.00
$0.00
$46.74
Not Billed Yet9 lines
$102.29
$624.01
$581.73
$0.00
$0.00
$1,308.03
OSCA1Oscar Insurance4 lines
$248.24
$379.06
$0.00
$0.00
$0.00
$627.30
SIMP1Simply Healthcare Plans4 lines
$102.29
$13.64
$46.74
$0.00
$0.00
$162.67
SUN01Sunshine State Health Plan6 lines
$0.00
$171.10
$286.28
$0.00
$0.00
$457.38
UNI20United Healthcare10 lines
$283.31
$679.59
$0.00
$0.00
$0.00
$962.90
6
Unassigned0 carriers · 0 lines
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Page 1 / 1
Grand Total
(5 sections
· 32 carriers
· 5,666 lines)
$93,702.37
$168,112.26
$78,511.64
$53,156.89
$90,146.03
$483,629.19
Export Options by Report
Columns listed under Hidden for export / display are currently turned off for that report.
Change them with Show/Hide Columns on each report, or restore app defaults below.
#
Report
Hidden for export / display
Clear Data
This will permanently remove the current working import from the database
(transactions, visits, A/R lines, and related lookup tables).
Saved month/year snapshots are not deleted. You can switch back to them
from the month dropdown after clearing. To restore working data, import Excel files again.
Import Data
KOPA Help
What this application does
KOPA Medical Billing Ops lets you import the monthly source files and review month-end billing reports for visits, providers, facilities, specialty collections, A/R, and transaction-to-section assignment.
Getting started
Open the app and click Import Data.
Select all required files (exact names required):
Transaction Data → TransactionDetail.xlsx
Patient AR Data → ResponsiblePartyArFlexible.xlsx
Carrier AR Detail (CSV) → CarrierArDetailFlexibleCSV.csv
Click Start Import. The page reloads when finished.
Import replaces current database contents. All listed files are mandatory. After data is loaded, the button changes to Clear Data — confirm in the popup to wipe the database, then Import Data returns.
Screen layout
Top bar — brand, period, Import Data, export-all actions, Help
Left panel — report list by category
Right panel — active report grid and controls
The selected report is highlighted in light grey.
Reports
Base Data — Unique Visits and Month Report for KOPA LLC (tabs 01–02).
Analysis Reports — Transaction Assignment plus end-of-month charge, collection, and practice production analysis (tabs 03–09).
CCM / AcuteCare / Cardiology — specialty patient and entity reports (tabs 10–18), including EoM - AcuteCare/Telehealth and Cardiology Collection.
A/R — Aging Summary (CSV) grouped by section → carrier → patient, and Carrier A/R by Section (CSV) (tabs 29–30).
Summary — Month End by Provider/Facility; Visits by Provider/Facility by Charge Entry Date; Charges by Provider by Charge Entry Date; EoM - Charge Analysis by Provider/Facility; Encounter Analysis by Provider/Facility (tabs 31–39).
Common controls
Search Data — filter the current report; press Enter to apply.
Group by … — toggle grouped vs flat detail rows (where available). Use + to expand.
Show/Hide Columns — hide columns for display and export (saved per tab).
View Export Options — popup grid of each report and its currently hidden columns; use Restore Defaults to reset.
Export Report — Excel for the current report; EoM - Production Summary exports as PDF; Month Report for KOPA LLC exports as Word (.docx).
Export All - Zip / Export All - Single — ZIP of individual files (Excel/PDF/Word), or one multi-sheet workbook plus PDF/Word files in a ZIP.
Tips
Use the top-bar Include voids switch to include or exclude VOID transaction lines across all reports. On 01 : Unique Visits, VOID badges mark affected visits and transaction detail rows.
Re-import when new monthly extracts arrive.
Clear column filters when the card info shows filters active.