Technology

PharmTracker is a web based solution for Pharmacy Receivables Reconciliationdeveloped 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.

Pharmacy Receivables ReconciliationServices

Import

Claims can be imported from electronic files or from ImageCADE after data capture.

Analytics

PharmTracker has a data warehouse implemented using MS Analytical Services.

Auto reconciliation

This module matches checks with RAs.

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.

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.

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

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.

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.

Your Benefits

  • Web-based Pharmacy Receivables Reconciliationsystem 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