Automated Download Invoicing

Automated Download Invoicing

Product: TAM Series 10.0 and higher.

Automated Download Invoicing is a new feature that will give you the ability to invoice various transactions that you receive from the company's daily download. You will have full control of what the system will do. ADI will save you time and provide you with accurate, automatic invoicing that will match the company accounting records.

Automated Download Invoicing

What Does it Do?

Automated Download Invoicing automatically invoices HOME and AUTO transactions that are received from a download of a company with which you interface.

When you process the data received from the company to update your policy and application details, this program creates a new file that is processed when you choose to initiate it. It creates an invoice for each transaction received that would normally be invoiced by a CSR. The program can invoice all transactions: Renewal, New Business, Endorsement, Reissue, etc. It can process Direct Bill and/or Agency Bill transactions.

You will have full control of what should be invoiced and what should not be invoiced. To do so, there is a setup that needs to be done before you start using this feature. The setup is explained further in this document.

Before you perform the setup, examine the different levels of options that are available to you.

Return to TOP

ACORD Transactions and Equivalent in TAM

The first level of options tells the system how you want to have the ACORD transactions translated in TAM. For instance, if you receive an RWL transaction in a download, this is a Renewal transaction and you need to tell TAM what its equivalent transaction code will be. You are able to define up to nine different transaction codes.

There are also certain preclassifications that have already been defined. There are many transaction codes that the companies may send for various reasons, but for the agency and from an accounting point of view, they would be invoiced with only one transaction code in TAM.

There are many ACORD transaction codes that can be received, but not all of them should have an accounting impact. Here is the list of the transactions for which the creation of an invoice is being considered. In the program, you will have to assign a TAM transaction code that will be used in the invoice.

NBS New Business New Business code in TAM
RWL Renewal Renewal code in TAM
REW Rewrite Rewrite code in TAM
PCH Policy Change Changed/Endorsed code in TAM. Usually two codes are used, such as +EN and -EN
RIX Reissue Reissue Code in TAM
REI Reinstatement Reinstatement
XLC Cancellation Confirmation Cancellation code in TAM

Follow the steps below for the initial setup and then complete the setup for each company for which you choose to create invoices.

  1. Access Utility Manager, then Automated Download Invoicing.
  2. On the Main screen, click Setup.
  3. Click Association List.
  4. This is where the associations between the ACORD transaction codes and the TAM codes are set.

  5. To create an association, you must first select the transaction code in the Choose a Transaction Type (Accounting) dropdown list. This is the code that you want the system to generate. For example, to create the association for New. Business, click New.

  6. Define the Status code that should be generated for this transaction when an invoice is created. In the Choose a Status Type (Billing Screen) dropdown list, select the policy status that should be associated when a new transaction is created.

  7. Once this is done, click the New Business box; you will have the first ACORD group association completed.

  8. You must define transaction and status types before you click the left box to choose the association. Once you click that box, it assigns the values that are in the Transaction field and the Status field.

  9. The first three options (New Business, Renewal and Rewrite) must have a Policy status type.

    For the Positive and Negative endorsements, normally you should not attach a Status type since you can have an Endorsement on a New business or on a Renewal.

    On a custom setup, the only other transaction that should require a Policy status is "Reissue".

Return to TOP

Company Setup

You must select the companies for which you want the system to create an invoice. Therefore, you may decide to do this for some of your companies or for all of them. For each company, you must choose what will be invoiced.

First, you must make sure that in the Company File Interface setup, the option to Update Premiums on Billing Screens for these policy types is Unchecked.

  1. In Utility Manager expand Company Interface, select Company File Interface Setup and open it with the arrow at the bottom.

  2. In Company File Interface Setup, select a Company from the drop-down.

  3. Go to the Download Options tab, and there you will see "Update premiums on billing screen for the chosen policy types". Make sure this is unchecked.

Important: If this is checked, then when an invoice is created by you or Automated Download Invoicing for an Endorsement, the change to the premium will be done twice.

For example, if you receive a PCH transaction for +50.00, with the option set to Yes, the premium would increase by 50.00. Then when you invoice it later, the premium will be increased again by $50.00.

Note: For a New Business, it is important to create the billing screen before it is automatically generated by the Interface module. This is to make sure that it contains the right data, like the producer code and department. Transactions cannot be added without a department selected on the policy detail screen.

Follow the steps below to set up the ADI program for your companies:

  1. In the main screen of the ADI program, select Setup.

  2. On the Invoice Setup screen, select the Company.

  3. Once the company is highlighted, click Update to display the Company Setup screen.

Return to TOP

Billing Mode

For each company, you have to decide if you want the system to create an invoice for Agency Bill transactions and/or Direct Bill transactions. You can choose to invoice for one type or for both. The system will invoice in the proper mode based on what is received from the company transaction. If the billing screen has, prior to the download, an Agency mode and the company is sending you a Direct Bill transaction, then the program will change it to Direct Bill mode. To select one mode or both, click the checkbox beside the option. It will then make the other options (Auto, Home) available to select.

Note: For the Direct Bill mode, the system will not print the invoice in the Close-Day procedure. If using Direct Bill Commission Download or Record Commissions is your Direct Bill Commission Reconciliation method, it is recommended that ADI not be used for Direct Bill items.

Return to TOP

Policy Type

For each company and billing mode, you must decide if you want the system to create an invoice for Auto and/or Home policies. You can choose to invoice one type or both. You then click the one you want to be set.

Return to TOP

Transaction Types

For each company, you must choose the Transaction Types for which you want an invoice to be created. For example, do you want to invoice Renewal Transactions, New Business, Endorsement, Reissue, Cancellation? You can invoice all of them or only one type.

In the Transaction Type window on the left side of the screen, select the Transaction Type that you would like to have an invoice generated for automatically. If you are doing it for both billing modes, you have to do this for both Home and Auto in the Direct Bill option and in the Agency Bill option. If you don't select a type of transaction, then no invoice will be created for it, it will be rejected by the program, and an entry will be logged in G:\APPS\ADIDOWN.LOG (Rejected Log File).

Return to TOP

Using the Automated Download Invoicing Program

Once all your setups are complete, you have two more options on the main screen: Invoice and View Log.


  1. Click the Invoice box to start processing the transactions received from the download.

  2. The program first determines if you have received an ADI download. If you have, then the necessary information is extracted to be used later in creating the invoice in TAM. Once this is done, the program brings up the list of all of the transactions that are ready to be invoiced. If no new transactions were received since the last time the program was run, a message displays: "No New Download Received!"

  3. Click OK to continue.

  4. The next screen shows the suspense transactions, including all of the new transactions just received in the last download. You can view what will be sent to the WUT_DOWN program to create the invoice in TAM. As you can see, there is information that can help you to decide if you want the invoice created immediately or if, for some reason, you want it to be delayed until further investigation. The program lets you sort the list in any of the fields that you see on the screen. For example, if you click the Trans. column, the list sorts by Transaction type; you can see all of the REN transactions together.

Important Note: If you add a company to the automatic invoicing process, you must revise this company's setup before you start the invoicing process. In fact, when you click the Invoice button, the program filters all of the incoming transactions and rejects all of the transactions that do not meet all of the conditions. This means that all of the transactions for a particular company could be rejected and there would be no way to retrieve them.

Return to TOP

Option Menu

At the top of the screen, you have three other menus. The first menu is Option.

This menu gives you two functions: Purge and Print.

State Menu

The second menu is State.

Here you have three choices: Remove, Skip and Invoice.

Defaults Menu

The third menu is Defaults.

There are two different modes to generate the invoices: Batch mode and Confirm mode.

  1. The Invoice All button starts creating the invoices. If you have selected the Confirm mode, the next screen lets you view and change some of the data before the invoice is created.

  2. When you are done, click OK to bring up the next invoice.

  3. Not all of the fields can be changed. The fields that are grayed out cannot be modified. You can also enter a description that will overwrite the default that has been defined in TAM for the Transaction Type (Trans Type) on the left side. If you deselect the Print checkbox, then no invoice will print in Close-Day.

  4. If you click Cancel Transaction, you advance to the next transaction. The transaction that was skipped is not really deleted; it will come back in your next session. If your next session is processed in batch mode, then the invoice will be created. Once all the transactions are processed, a message displays to confirm completion.

Return to TOP

View Log File

The View Log button displays the Rejection Log and the Success Log.

By default, when you click the View Log button, the Rejection Log displays. This log lists all of the transactions that have been rejected from the received download, with the reason for rejection. You can click the heading of each column to sort the list. You may need to investigate why a particular transaction was not invoiced. To switch to the Success Log, click the Option menu and select the desired log listing.

In both log screens, there are three more options available to you:

Return to TOP

Download Procedures and Changes

The main thing to remember is that there are no changes in the download workflow to incorporate ADI with your daily download. However, it must be noted that specific exceptions exist for this process to function as required.

If a problem occurs during the download, do not attempt another session. Log a Support call immediately. Ensure that a Pack is not turned on for that night in case Support is unable to contact you the same day. Any errors received on the screen (e.g., internal errors stopping download completely, red box messages indicating an error exists, etc.) require a Support call. Failure to do so may result in multiple/inaccurate invoicing when ADI is run.

ADI can be discontinued at any time by selecting the Disable Automatic Download checkbox on the main screen. Once checked, the download will continue to process, but no transactions will be created from the download.

Return to TOP

Last Revised: August 15, 2013