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.
- Access the
Import area.
- Click Reconciliations under
Import on the navigation
panel.
- Do one of the following:
- Click the Add
button
to the left of the list.
- With focus on the list, press [Insert]
on your keyboard.
- Press [Ctrl]
+ N.
- 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.
- Select the Entity
type and then the specific entity
that sent the transactions.
- Click Browse
and navigate to the file with the statements you want to import. Select
it and click Open.
- 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.
- Determine whether it contains a header row and whether its
cells are formatted as Text.
- 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.
- 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.
- In the Ending
row field, enter the last row number that you want to import.
- In the Criteria section,
you can filter the items you want to import:
- Month/Date
- Select one of the following:
- Accounting month:
Choose the appropriate ending month
and year.
- Payables due date:
Specify the ending date.
- Agency
- Click the All
or Selected
radio button.
- If you click Selected,
choose an agency
in the dropdown menu and click Add.
Repeat this action until you have selected all desired agencies.
Note:
To remove an agency, click to highlight it in the list and
then click Delete.
- Branch
- Click the All
or Selected
radio button.
- If you click Selected,
choose a branch
in the dropdown menu and click Add.
Repeat this action until you have selected all desired branches.
Note:
To remove a branch, click to highlight it in the list and
then click Delete.
- Department
- Click the All
or Selected
radio button.
- If you click Selected,
choose a department in the dropdown menu and click Add. Repeat this action until
you have selected all desired departments.
Note:
To remove a department, click to highlight it in the list
and then click Delete.
- Profit Center
- Click the All
or Selected
radio button.
- If you click Selected,
choose a profit center in the dropdown menu and click Add.
Repeat this action until you have selected all desired profit
centers.
Note:
To remove a profit center, click to highlight it in the list
and then click Delete.
- Receivable (Premium payable only)
- Select the appropriate radio button:
- All
- Partially Paid
- Fully Paid
- Select the Finalize
statement checkbox if applicable.
- Enter a Statement
description.
- Choose the Accounting
month and year
for the statements.
- The Payment description
defaults but can be changed if necessary.
- 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.