Quick Company Statement Reconciliation

The Quick Company Statement Reconciliation is a reduced version of the regular Company 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 Company Statement Reconciliation program. To do so, follow the steps below.

1. From Home Base, click the Accounting button.
2. Click Reconciliations.
3. Click Agency Bill.
4. Click Quick Company Statement Reconciliation on the Reconcile Company Payables screen.
5. Enter the desired selection for each of the following criteria. The selections you make determine which transactions are reconciled with the agency bill statement.
   • Select a Company: Leave the default of All Companies selected, or deselect it and double click in the Company Code field to select the appropriate company.
     
     Note: If you have previously saved a Company Statement Reconciliation and select the same company 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 Companies and have not yet closed the statement, you may not reconcile the statement of specific companies until you do so. The opposite is true if you previously ran the reconciliation for a selected company(ies).
   • 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 company statements for all companies, the transactions are presented in groups by company. The Sort Order determines the order in which individual transactions are presented within each company group. If possible, choose a sort order that matches the order of the company 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 company statements now or queue them to process later as desired.
6. Click OK to proceed with the reconciliation process. The Quick Company 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.
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 company. 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 company. 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 company.
     
     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 company is different than displayed, click this button to adjust it. TAM displays the Commission Adjustment window.
     
     Enter the adjusted commission information for the company and the producers 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 company without adding the net premium of that item to the company'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 Company 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 company.
   • 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 company 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 company payable accounts for each writeoff CPY transaction and the writeoff payable account.
     • CPY transactions will appear on the Company 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 a Company Statement Issue Date for the reconciliation and click Continue. TAM marks the flagged transactions as reconciled to the company. The total net premium of all paid items is calculated for each company. You are prompted, "Do you wish to issue the check immediately?"
    • Click No to return to the Reconcile Company Payables screen. Until you actually write the check, the statement is considered unpaid. To display these statements, select List Statements on the Reconcile Company Payables screen.
    • Click Yes to enter a disbursement and pay the statement.