RTG Bills

How To Import Time From Amicus Attorney 7
Part 2


Amicus Attorney 7 can export time entries to RTG Bills. Part 1 showed you how to create an export format so that posting entries in Amicus Attorney will produce a properly-formatted file.

The next step is to install RTG Bills Import, a program that reads fees from other programs into RTG Bills. Start RTG Bills, choose File > Upgrade, and click Yes to start RTG Upgrade.

Our goal is to configure RTG Bills Import to read the transactions from Amicus Attorney. You only have to do this once.


Click Check The Internet For Upgrades. The list of available upgrades will be read from the RTG Web site.


In the list of upgrades, look for RTG Bills Import. Click the box to put a check mark next to this item. Click Install to download and install RTG Bills Import.

When the installation is complete, you can exit from RTG Upgrade.


Start RTG Bills and choose File > Tools from the menu. Click on Import Fees and Expenses in the list of tools, then click OK. RTG Bills Import will start.


Click the Browse button, to choose a file to import.


You must locate the file that Amicus Attorney wrote. The export format we defined in Amicus Attorney specified the file name, rtg.asc. It also specified that the file should be written in the location where RTG Bills is installed, such as the folder C:\Program Files\Rtgbills.

Click the file you wish to import, rtg.asc, then click Open.


The Import From This File box should show the file you chose. Click the button labeled 1. Configure.


The choices shown below assume that the Client ID and Matter ID you enter in Amicus Attorney are the fields known as the client number and matter number in RTG Bills. For example, the RTG Bills matter number 1234-567 consists of a client number 1234 and a case number 567.

One by one, select a field from the left-hand list and click Add > to put it in the right-hand list. When you are done, the list must look exactly as it appears in the screen shot below.

In addition, the Field Delimiter must be set to Comma. The Ignore First Line checkbox must be unchecked.

Whether to check Ignore Rates or not is up to you. If it is checked, RTG Bills will use the standard rate for the timekeeper (from the appropriate rate table) to set the hourly rate for each transaction, and the rate assigned by Amicus Attorney is ignored. If the box is not checked, RTG Bills will use the rate that was added to the transaction by Amicus Attorney.

Click Save to save the configuration.


To test that everything is set up properly, click the 2. Test button. RTG Bills Import will read the time entries from the file you selected. First you should see a message telling you that no formatting errors were found. It should also display a record count (how many time entries are in the file created by Amicus Attorney).

When you click OK, you will see the first time entry. Click OK. You will see the second time entry (unless there was only one entry). Click OK.


To import the data, click the 3. Import button. Click Yes to proceed and OK when the import is done.

The data has now been read into the RTG Bills database. The name of the file you imported has been changed so the extension is now .bak. That should prevent you from accidentally importing the same data twice.


Click Close to exit from RTG Bills Import. All of your settings are saved automatically, so you won't need to do any configuration next time.

From now on, these are the steps you will need to transfer fees from Amicus Attorney to RTG Bills:

  1. Post the fees in Amicus Attorney.
  2. In RTG Bills, choose File > Tools from the menu.
  3. Click on Import Fees and Expenses in the list of tools, then click OK. RTG Bills Import will start.
  4. Click the 3. Import button. Click Yes to proceed and OK when the import is done.


The End

Return to the Contents page