Technology

PharmTracker is a web based solution for pharmacy receivables management developed by Tranquilmoney to address various aspects of a process including:

• Reconciliation of checks with corresponding payment
• Application of payments to claims
• Exception processing
• Reporting
• Compliance with laws

It gives Pharmacy clients the flexibility to see data and reports online. The back office is provided the necessary functionality and workflow to perform the reconciliation and receivables follow up process. Besides PharmTracker, TeleScan is used to scan paper batches. These images are imported into ImageCADE and data is captured from images using key, verify and correct.

Import: Claims can be imported from electronic files or from ImageCADE after data capture. Auto reconciliation: This module matches checks with RAs. Auto-match: Claims and payments are matched on 4 key fields Interactive match: The software assists the research team in manual matching based on configurable rules. Reporting: PharmTracker™ has standard reporting features that display professional reports that can be printed, saved as PDF, Excel etc. There are summary reports with drill down facility on a summary number to several levels. There are options to do a dynamic sort on any of the fields at the first level. Some of the reports generated are Aging Report, Aging analysis, Aging by month, Unapplied payments, Complete payments, Partial payments, Over payments, RAs without checks, Checks without RAs, Batch status.

Analytics: PharmTracker has a data warehouse implemented using MS Analytical Services. Search: Pharmacy clients can search on Checks, Payments, Claims, or Files. The fields on which the search can be done as well as the columns to display in the search results are configurable. Storage: PharmTracker stores all source files - EDI 835, images and claim - in a folder structure ordered on payer and date. These files are available for download for the user Processing: matching claims with payments, applying reversals of claims and payments, processing of fees and adjustments based on payer specific rules, matching checks with RAs, research and follow up on mismatches. Output file: Output for the client includes a list of all records that are new or modified, in the format specified by them.

Benefits:

+ Web-based pharmacy receivables management system accessible by client anytime
+ Integrates with electronic switch data OR data feeds from POS systems including
   Condor, TechRx, PDX, QS1, Renlar, MPS, etc.
+ High end functionality: expert systems identify rules used by each payer for each
   retail pharmacy client
+ Implements Deming's principles of workflow management and accountability

Technology:

Pharmacy Receivables Services use multiple proprietary software products for different needs:

TeleScan: VC++ and MS Access

ImageCADE suite: VC++ and MS Access

TelePost: VB as the front end and SQL Server at the back end. Stored Procedures convert the processed data into the reporting schema.

PharmTracker is implemented as a three tiered application.

Presentation Tier
The web browser forms this layer and it displays the requested information to the end user and also captures user input. The web pages are generate by ASP.NET on the server (IIS) and sent to the web browser. The web browser renders the pages received from the server.

Business Logic Tier
Business logic is written in VB.NET. Crystal reporting components are used for implementing reports. ASP.NET separates application logic and user interface. Data access is done via ADO.NET.

Data Tier
MS SQL Server is used as the database. MSAS is used for implementing the data warehouse