Import Receipts

iSalus Healthcare allows a practice to import patient payments so that receipts can be generated in mass.  This is commonly done when a bank or other third party may be able to provide a file containing patient payment information.  For example, when a patient mails in a statement payment to your bank/lock box, the bank may be able to provide a file with these details on a recurring basis.

Generate a Receipt Import Template

The first step to import a receipt is to obtain the Import Specifications/ Import Template.  This can be done by taking the following steps:

  1. Navigate to Billing > Receipts
  2. Click More > Import Receipts
  3. Click Template > Select the Template Type
    1. Full: This template includes multiple tabs that define each column for the import.
    2. Basic: This template only includes the necessary column headers for the import.
  4. A Microsoft Excel template will be opened on your computer


Understand the Receipt Column Definitions

The Import Template provided will ask for the following columns:

  • Patient ID: The iSalus patient chart number
  • Statement ID: This statement number generated out of our application.
  • Date:  The date of the receipt. This must be in the format MM/DD/YYYY.
  • Amount:  The total value of the receipt. This must be in the to be format as ###.##.
  • Type: This is the payment type for the receipt (i.e. Co-Pay or General Payment).  
  • Method:  This is the payment method for the receipt (i.e. Check or Cash)
  • Check or Trace Number:  This field will populate the 'ID #' field on the receipt.
  • Comment:  This is the comment that will be associated with the claim.

Setup your file to include these options as you see fit.

Import Receipts

To begin the receipt import process, follow the below steps:

  1. In the Receipts window, click More > Import Receipts
  2. Click the Import button
  3. In the Import Table tab, click Browse... to locate the file you want to load
  4. Select the file from your computer to import.  Click Upload.
  5. In the Field Mapping tab, map each column header to the appropriate receipt field.
  6. In the Field Mapping tab, be sure to match Your Field Values from the import to the correct OfficeEMR Value.
  7. In the Record Verification tab, click the Go button to perform the verification.
  8. In the File View tab, review failed records as needed.
  9. In the Ready to Go tab, click Go to import the receipts.
  10. Monitor progress in the File Import screen.