On May 12, 2003, the president of a family medicine clinic, a physician and a nursing informatics specialist won first place in a competition sponsored by Microsoft Corp. to honor innovative healthcare professionals. Participants were evaluated by a panel of Microsoft representatives based on how many Office features they were using, their productivity gains, and how applicable the featured uses would be in other healthcare settings. All three winners use Excel for financial reporting, data collection or tracking of employee payroll and record the number and types of office visits.
However, until recently, the use of Excel for medical billing analysis has been limited due to the difficulty of producing effective ad hoc reports and the inability to export data to Excel. Vericle overcomes the limitation with its integrated medical billing reports, Excel export capability, and a standard data import capability to Microsoft Excel.
Vericle reports include expectation management for both medical billing payments and charges, accounts receivable analysis, medical billing compliance violations, and SOAP note tracking. To take advantage of Vericle medical billing data export to Excel, follow a two-step procedure:
- InVericle
- Create desired medical billing report in Vericle, sort and filter according to requirements
- Click on the Excel icon in the lower left corner of the window
- Select all the data in the separate window that has the data (CNTRL-A)
- Copy all data into buffer (CNTRL-C)
- On the destination Excel page,
- Place the cursor in a cell where you want the top left corner of the copied data
- Select Edit -> Paste Special -> Plain Text -> OK