Quick Insurer Statement Reconciliation

The Quick Insurer Statement Reconciliation is a reduced version of the regular Insurer Statement Reconciliation. This option enables you to reconcile one transaction or a small group of transactions related to a policy without taking the time to prepare and process the full Insurer Statement Reconciliation program. To do so, follow the steps below.

1. From Home Base, click the Accounting button.
2. Click Reconciliations.
3. Click Client Bill.
4. Click Quick Insurer Statement Reconciliation on the Reconcile Insurer Payables screen.
5. Enter the desired selection for each of the following criteria. The selections you make determine which transactions are reconciled with the client bill statement.
   • Select an Insurer: Leave the default of All Insurers selected, or deselect it and double click in the Insurer Code field to select the appropriate insurer.
     
     Note: If you have previously saved an Insurer Statement Reconciliation and select the same insurer parameter, TAM automatically recalls the saved reconciliation parameters. Choose whether to change any of the reconciliation parameters previously selected.
     
     If you previously ran the reconciliation for All Insurers and have not yet closed the statement, you may not reconcile the statement of specific insurers until you do so. The opposite is true if you previously ran the reconciliation for a selected insurer(s).
   • Select an Agency: Leave the default of All Agencies selected, or deselect it and double click in the Agency field to select the appropriate agency.
   • Sort: Select the appropriate sort order for the transactions. If you are reconciling the insurer statements for all insurers, the transactions are presented in groups by insurer. The Sort Order determines the order in which individual transactions are presented within each insurer group. If possible, choose a sort order that matches the order of the insurer statement to make reconciliation easier.
   • All Items, Fully Paid, or Partially Paid items: Choose whether to reconcile all items or items that are fully paid or partially paid by the customer.
   • Begin Now or Queue For Later: Choose whether to begin processing insurer statements now or queue them to process later as desired.
6. Click OK to proceed with the reconciliation process. The Quick Insurer Statement Reconciliation window displays.
7. Click Flag Individual Items to display the Customer screen.
8. Click the desired customer in the list and click OK.
   
   TAM displays the selected customer's invoices in the Flag Individual Items screen. The bottom half of the screen displays a detailed view of the highlighted transaction.
   • The first column denotes if there is a Split Transaction (*) and if there is a Combined Tax Transaction (+). Clicking the + (plus sign) will expand the transaction to show the Premium Transaction and the Tax Transaction (L).
9. Click on the desired transaction, and then click one of the following buttons to perform the desired function:
   • Full Payment: Click this button to flag the selected transaction as fully paid. Before choosing this option, make sure the information displayed for the item is correct. If anything is incorrect, correct the discrepancies before marking the item as paid. Once you flag an item, TAM no longer includes it with the Items Due to be Paid or presents it for reconciliation. The net premium for the item is also added to the reconciliation total for the selected insurer. An "F" displays in the left column to denote the payment.
   • Partial Payment: Click this button to flag a selected transaction as partially paid to the insurer. TAM displays a Create Partial Payment screen.
     
     Enter the partial payment amount in the field provided and click OK. The payment amount is added to the reconciliation total for the selected insurer.
     
     Note: If a "P" is displayed next to a transaction, a partial payment has been entered on the current statement. All previous partial payments display when entering another partial payment. This feature ensures that you do not apply a partial payment to a transaction twice. An asterisk (*) displayed next to a transaction denotes a partial payment from a prior statement.
   • Adjust Com %: If the commission percentage information shown on the statement from the insurer is different than displayed, click this button to adjust it. TAM displays the Commission Adjustment window.
     
     Enter the adjusted commission information for the insurer and the introducers as needed and click OK. Choose whether to reflect these adjustments on the billing screen.
     
     Click Yes to update the customer's policy screen with the changes, or click No to return to the Flag Individual Items screen.
   • Remove Bal: Click this button to mark the selected transaction as paid to the insurer without adding the net premium of that item to the insurer's reconciliation balance. TAM displays a warning message. Click Yes to verify that you want to remove the selected item, or click No to leave the item as displayed. Use this option with caution. If you choose to remove the transaction balance, the following occurs.
   • • The transaction is removed from statement but remains in the Insurer Payables General Ledger account.
     • The transaction is not displayed when you list unpaid items.
     • The transaction does not appear on the Items Flagged to be Paid Report.
     • The transaction is not added to the reconciliation balance that must be remitted to the insurer.
   • Write Off: Click this button to write off all or part of the payable balance for the selected transaction. This option is similar to the Remove Balance option with one exception. Both options remove an item from the list of unpaid items. However, the Write Off option creates a journal entry between the individual insurer payable accounts for each writeoff transaction and the writeoff payable account. The Remove option removes an item but does not charge it against an account. If your agency is installed on a cash basis, the writeoff correctly calculates the percentage of unearned commission that needs to be journal entried out of that account.
     
     When you select this option, TAM displays the Create Write Off screen. Enter the amount to write off in the Payment field, then click OK. Click Cancel to return to the Flag Individual Items screen.
     
     If you click Yes and choose to write off the transaction balance, the following will occur:
   • • Amount written off is NOT added to the statement total the program is storing.
     • Each writeoff CPY transaction will have the label WRTEOFF in the reference field so that you can identify it later on reports or when viewing the transaction in the Update Transaction view.
     • A writeoff CPY transaction is included in the Month-End journal entry generation. A journal entry is created between the individual insurer payable accounts for each writeoff CPY transaction and the writeoff payable account.
     • CPY transactions will appear on the Insurer Payables Report.
   • History: Click this button to view the selected client's transaction history. Use the arrow keys and scroll bar to view the transactions. Click Cancel to return to the Flag Individual Items screen.
   • Unflag Payment: Click this button to unflag a selected item that has already been flagged to be paid or written off on the current statement. The flag is removed and the item's Net Premium returns to the original amount.
   • Locate Client: Click this button to locate a new client to reconcile. That client's transactions display on the Flag Individual Items screen.
     All transactions that you flag here, as well as the transactions you flagged for the previous client, will be included on the statement. You may also use the Locate Client button to switch back to the transaction list for the previous client if you need to make additional adjustments.
10. When you have finished flagging/adjusting items, click Exit.
11. Click Items Flagged as Paid Report to display all items flagged to be paid in this statement. Choose whether to preview the report, send it straight to a printer, or send the report straight to a disk file.
12. Click Cancel to exit the reconciliation. The Close Statement window displays.
13. Revise the Statement Completion Date if necessary and click Continue.
14. Enter an Insurer Statement Issue Date for the reconciliation and click Continue. TAM marks the flagged transactions as reconciled to the insurer. The total net premium of all paid items is calculated for each insurer. You are prompted, "Do you wish to issue the check immediately?"
    • Click No to return to the Reconcile Insurer Payables screen. Until you actually write the check, the statement is considered unpaid. To display these statements, select List Statements on the Reconcile Insurer Payables screen.
    • Click Yes to enter a disbursement and pay the statement.