The Recon Report provides a listing of recon files that have been sent to partners via SFTP/email/API. Each day, PatientPay sends a recon file for each active merchant ID (MID) in our system. The report listing includes details about the file including the date it was generated, the practice name, MID, recon type (ACH, ACH Refund, ACH Reject, Cash, Credit/Debit, Insurance,  Lockbox or Subscription), total number of transactions, total disbursed, total sales, transaction fees, refunds and chargebacks.

To filter the report, choose which practice(s) you wish to view and the time frame, and press Refresh. The Recon Type(s) filter lets you filter the list by specific recon types (e.g., ACH). You can optionally filter by Deposit Total or MID with a search value. The listing will be updated to show files that match your criteria.

Figure 149 - Recon File Report

Recon File Detail

If you wish to view the details for a given recon file, select the item in the list to be shown the Recon File Details Screen. This screen displays the same details for the file in a header and includes the recon filename. The lower half of the screen is broken into three tabs: Transactions, Fees & Adjustments and Chargebacks. You can press the Download Recon File button to get an Excel version or original copy of the recon file sent to the partner. This is helpful if a partner doesn’t receive a file or Support needs to confirm the exact file contents that were sent to the partner. The Excel download will follow the same column layout as the original recon file (e.g., CSV).

Transactions

The Transactions tab will list all transactions contained in the file, sorted by transaction date. We show the transaction date, patient ID, amount, payment method and confirmation number. The confirmation number will hyperlink to the Transaction Detail screen if the transaction was successful.

Figure 150 - Recon File Detail Transactions

Fees & Adjustments

The Fees & Adjustments tab provides a listing of any processor fees and adjustments made for a given day. This listing is sorted by the timestamp and lists the category, type, amount and description provided by the processor.

Figure 151 - Recon File Detail Fees & Adjustments

Chargebacks

The Chargebacks tab provides a listing of any chargebacks made by the processor for a given day. This listing is sorted by the timestamp and lists the reason/code, reason description, amount, transaction date, and case number provided by the processor.

Figure 152 - Recon File Detail Chargebacks