Add a Reconciliation Statement Batch

Importing reconciliation statements allows you to import PPE and direct bill statements directly from carriers and automatically reconcile those imported statements against the items already billed in Applied Epic. 

  1. Access the Import area.
  2. Click Reconciliations under Import on the navigation panel.
  3. Do one of the following:
  4. The Add Batch – Reconciliation Statement screen displays. The statement type defaults to Premium payable. To add a direct bill statement instead, select the Direct bill commission radio button.
  5. Select the Entity type and then the specific entity that sent the transactions.
  6. Click Browse and navigate to the file with the statements you want to import. Select it and click Open.
  7. Select a Mapping file that defines the data. See Import/Export for more information on creating mapping files. Before importing the XLS or XLSX file, open it in Microsoft Excel to verify its formatting.
    1. Determine whether it contains a header row and whether its cells are formatted as Text.
    2. If you import an XLSX file without a header row whose cells are not formatted as Text, dates and amounts will be formatted according to Excel’s formatting settings, rather than the mapping formats set up in Configure. To ensure that the file uses these mapping formats, update the cell formatting to Text if necessary.
  8. In the Starting row field, enter the first row number that you want to import. All of the rows that follow the selected row will also import.
  9. In the Ending row field, enter the last row number that you want to import.
  10. In the Criteria section, you can filter the items you want to import:
  11. Select the Finalize statement checkbox if applicable.
  12. Enter a Statement description.
  13. Choose the Accounting month and year for the statements.
  14. The Payment description defaults but can be changed if necessary.
  15. Click Finish to return to the Import - Reconciliations list.

The transactions are not imported automatically. You must use Import Batch under Actions to load the transactions into the system. Applied Systems recommends reviewing the import before applying the transactions to make sure everything imports correctly.

See Also