Ideal Online Documentation

14177 T/B PROCESSING
TB2-12 Retainer-Bill Allocations

 

PURPOSE

 

The retainer bill allocations program is used to allocate pre-billed (retainer) amounts to unbilled time and/or disbursement entries that are selected for allocation. The retained amounts originate from previously created manual bill entries.

 

The program enables you to determine if estimated time and/or disbursement billings were over- or under-estimated. The program compares the pre-billed values that appear as credits against subsequently posted time and disbursement transactions that appear as debits on the matter. The resulting variance between the two is automatically posted to statistical reports and the general ledger.

 

From the time of the posting of the manual bill entry, pre-billed amounts are referenced as credits within the unbilled time and disbursement categories on the matter. The pre-bill option in manual bill entry allows you to post an invoice prior to posting the time and disbursement entries and places credit balances in the unbilled categories. The time and/or disbursement entries are eventually posted to the matter and then allocated against the pre-billed values.

 

After entering the client/matter code the program automatically displays the totals of both the selected time & disbursements and the pre-billed time & disbursements.

 

When you press [Enter] the program applies the pre-billed amounts to the selected unbilled amounts. You have the option to press [F1] to open a window displaying all unbilled time and disbursement details for the matter where you can select or deselect transactions to match details to the pre-billed amounts.

 

Depending on just how your company control parameters have been set up, the effect on the G/L accounts will vary. No matter which of the following examples are relevant, the net effect of the retainer bill allocations program is that the pre-billed disbursement and pre-billed time G/L accounts will be credited at the time of the manual bill entry and then debited or zeroed at the time of the retainer bill allocations program update. Examples follow.

 

 

Example A:

 

If the "Allocate Pre-Billed Fees Immediately (Y/N)" parameter is set to "N", the posting of the pre-bill type during manual billing will have the following effect:

 

DR Accounts Receivable

CR Pre-Billed Disbursements

CR Pre-Billed Fees

 

The posting of the subsequent pre-bill allocation will then result in:

 

DR Pre-Billed Disbursements Asset

CR Unbilled Disbursements Asset

DR or CR Disb. Recovery Revenue (Variance)

 

DR Pre-Billed Fees Asset

CR Unbilled Time Asset

DR or CR Fees Billed Revenue (Variance)

 

DR Unearned Fees (Equity or Liability)

CR Fees Billed Revenue

 

The last portion of this entry will only occur if the "G/L Update In Time Entry" company control parameter has been set to "Y" and the "Unearned Fees G/L Code" has been defined in the equity or liability section G/L account.

 

 

Example B:

 

If the "Allocate Pre-Billed Fees Immediately (Y/N)" Parameter is set to Y, the posting of the pre-bill type during manual billing will have the following effect:

 

DR Accounts Receivable Asset

CR Pre-Billed Disbursements Asset

CR Fees Billed Revenue - Variance

 

The posting of the subsequent pre-bill allocation will then result in:

 

DR Pre-Billed Disbursements Asset

CR Unbilled Disbursements Asset

DR or CR Disb. Recovery Revenue (Variance)

 

DR Unearned Fees (Equity or Liability)

CR Unbilled Time Asset

 

DR Fees Billed Revenue - Variance

CR Fees Billed Revenue

 

The last portion of this entry will only occur if the "G/L Update In Time Entry" Company Control Parameter has been set to "Y" and the "Unearned Fees G/L Code" has been defined in the equity or liability section G/L account.

 

 

Important:

 

Refer to the lawyer/timekeeper maintenance program, found on the time billing code maintenance menu, for details on just how the statistical reports and general ledger will be affected by your firm's policy decisions on the allocation of billings and variance billings between working and assigned Lawyers. See also 14176 MANUAL BILL PROCESSING for additional information.

 

Retainer-Bill Allocations is accessed from:

  • Time Billing menu.

 

PROCEDURE - BATCH CREATION

 

Select Retainer-Bill Allocations from the Time Billing menu.


You are taken to the batch selection screen where you may create a new batch or select an existing batch for further processing. Batches are not terminal dependent. To select an existing batch for further processing see PROCEDURE - ACCESS AN EXISTING BATCH. Additional batches can be created whether or not previous batches have been updated. To update or abort a batch see PROCEDURE - REGISTER PRINTING AND UPDATE. If there are existing batches the first will be displayed and you have the options of processing the displayed batch, accessing another batch or creating a new batch.

 

If you are creating a new batch, press [Enter] at the batch selection screen. This clears the display of any existing batches and assigns the next sequential batch number.

 

BATCH SELECTION SCREEN

┌────────────────────────────────────────────────────────────────────────────────┐
│01/02/07 Tm6     ***** TERMINAL INDEPENDENT BATCH SELECTION *****        3TPAI1 â”‚
│                                                                                â”‚
│                                                                                â”‚
│          COMPANY:                                                              â”‚
│          BATCH NUMBER:                                                         â”‚
│                                                                                â”‚
│          G/L DATE:                                                             â”‚
│          CONTROL TOTAL:                                                        â”‚
│          BATCH DESCRIPTION:                                                    â”‚
│                                                                                â”‚
│                                                                                â”‚
│** SPECIFY BATCH (CR=NEW BATCH; F4=END):  ____                                  â”‚
│PRESS CR FOR NULL, F5 FOR INQUIRIES, F2 FOR NULL, F3 TO BACK UP.                â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
COMPANY

 

Displays the company you are working in.

 

BATCH NUMBER

 

Defaults to the next available batch number, no input required.

 

G/L DATE

 

Enter a G/L date for the batch.

 

[Enter] for the current system date.

 

Many programs use the dates of the individual entries in the batch as the date the G/L is affected by the entries. For those programs, the batch G/L date indicates the date of batch creation. Some programs use the batch G/L date as the date the G/L is affected by ALL entries in the batch. The effective date is noted in PROCEDURE - DATA ENTRY.

 

 

CONTROL TOTAL

 

Enter the dollar total of the adjustments to be posted.

 

[Enter] to bypass.

 

Generally, a control total is optional. However, some programs require a control total. In either case a control total serves as a handy check-sum against the total entries in a batch and should be entered. Simply add up the total of the transactions to be made in the batch and enter that as your control total.

 

 

BATCH DESCRIPTION

 

Enter a description to identify the batch.

 

[Enter] to bypass.

 

You can enter up to 30 characters.

 

 

When you have completed the batch header fields the following prompt is displayed:

 

** PRESS ENTER TO CONTINUE; F3 TO RE-ENTER; F4 TO END:

 

[Enter] to continue to data entry.

 

[F3] to return to the previous field.

 

[F4] to exit to menu.

 

The information entered is discarded, not batch is created and the batch number remains available for use.

 

 

 

PROCEDURE - DATA ENTRY

 

Example Retainer Allocations display:

┌────────────────────────────────────────────────────────────────────────────────┐
│01/10/07            ***** PRE-BILL DETAIL ALLOCATIONS *****                 TALI│
│────────────────────────────────────────────────────────────────────────────────│
│BATCH: 0006     CONTROL:   1,173.72   ACTUAL:  1,173.72    LEFT:      0.00      â”‚
│────────────────────────────────────────────────────────────────────────────────│
│                         SELECTED   SELECTED     PREBILL    PREBILL       TOTAL â”‚
│SEQ# CLIENT MATTER LYR        WIP       DISB        TIME       DISB         TAX â”‚
│────────────────────────────────────────────────────────────────────────────────│
│0001 000888  0001  SLR    1618.75    1029.58        0.00    1029.58      144.14 â”‚
│___                                                                             â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│────────────────────────────────────────────────────────────────────────────────│
│CLIENT: JOHN DOE                        MATTER: M.V.A. - DEC. 12/04             â”‚
│────────────────────────────────────────────────────────────────────────────────│
│PRESS CR FOR NEXT, F2 TO DISPLAY, F3 FOR BATCH CONTROL, F4 TO END,              â”‚
│OR ENTER THE SEQUENCE# OF THE LINE YOU WISH TO DISPLAY OR PROCESS.              â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
PRESS CR FOR NEXT, F2 TO DISPLAY, F3 FOR BATCH CONTROL, F4 TO END

 

Enter the SEQ# of the detail line you wish to display or delete.

 

** PRESS ENTER TO CONTINUE; 'D' TO DELETE

 

[Enter] to continue with data entry.

 

"D" to delete the line.

 

The line is deleted without further warning.

 

 

[Enter] to begin new detail line with next sequential number.

 

[F2] to display detail lines.

 

** ENTER STARTING SEQ# (CR FOR FIRST; F4 TO END)

 

Enter SEQ# of detail line to begin display.

 

[Enter] to begin display at first detail line of batch.

 

[F3] to return to batch selection screen.

 

[F4] to exit to menu.

 

 

FIELDS

 

SEQ#

 

[Enter] to display the next sequence number.

 

If you enter an existing sequence number, the system will display the transaction and will provide the option to bypass or delete it from the batch.

 

 

CLIENT

 

Enter the client code.

 

[F5] to display list of client/matter codes for selection.

 

MATTER

 

Enter the matter code.

 

[F5] to display list of client/matter codes for selection.

 

LYR

 

Enter the desired lawyer code.

 

[Enter] to accept the default lawyer code.

 

The program defaults to the assigned lawyer as set up in the matter maintenance program.

 

 

[F5] to display list of lawyer and timekeeper codes for selection.

 

The assigned lawyer's lawyer code will be automatically displayed here.

 

 

SELECTED WIP

 

Displays the total value of selected time details.

 

>> SELECTED TOTALS ARE ZERO. PRESS F1 TO SELECT OR ENTER TO CONTINUE:

 

This message occurs when no time has been selected for the matter.

 

[Enter] to clear the alert and return to CLIENT field.

 

>> THERE ARE NO PREBILLS TO ALLOCATE AGAINST. PRESS ENTER:

 

This message occurs when there are no existing pre-bills associated with the selected client and matter.

 

[Enter] to clear the alert and return to CLIENT field.

 

[F1] to display time/disbursements selection screen for selection.

 

See PROCEDURE - TIME/DISBURSEMENTS SELECTION.

 

 

SELECTED DISB

 

Displays the total value of selected disbursement details.


PREBILL TIME

 

Displays the total value of pre-billed time details, if any.

 

PREBILL DISB

 

Displays the total value of pre-billed disbursements, if any.

 

TOTAL TAX

Displays the total value of pre-billed GST and PST.

 

 

PROCEDURE - TIME/DISBURSEMENTS SELECTION

 

Pressing [F1] opens a window displaying all unbilled time and disbursements for the related client/matter, allowing you to flag entries you wish to delete.

 

Example Time/Disbursements Selection display:

┌────────────────────────────────────────────────────────────────────────────────┐
│01/08/07                 TIME/DISBURSEMENTS SELECTION                       TWOI│
│────────────────────────────────────────────────────────────────────────────────│
│CLIENT  012345   XYZ CORPORATION LTD.                 TRUST BAL      TERM BAL   â”‚
│MATTER  0000     CORPORATE MATTERS              CD          .00           .00   â”‚
│T/D/B   B            SELECTED TIME         .00  US          .00           .00   â”‚
│S/L/B   L            SELECTED DISB         .00  BILL STAT ON HOLD LAWYER JM     â”‚
│────────────────────────────────────────────────────────────────────────────────│
│  DATE/STAT  SOURCE LAWYER CODE   GL/HRS  REF/RATE    VALUE  ADJUST  BILLABLE   â”‚
│────────────────────────────────────────────────────────────────────────────────│
│ 1. 121006 TW0047-001 AMW  001     10.00    10.00    100.00     .00    100.00   â”‚
│           test                                                                 â”‚
│ 2. 121106 TW0047-002 WPL  001      5.00   175.00    875.00     .00    875.00   â”‚
│           consultation                                                         â”‚
│ 3. 121106 TW0047-003 SMMA 001      1.00   125.00    125.00     .00    125.00   â”‚
│           consultation                                                         â”‚
│ 4. 121106 TW0047-004 SMMA 001      1.00   125.00    125.00     .00    125.00   â”‚
│           consultation                                                         â”‚
│                                                                   ----------   â”‚
│                                     TOTAL UNBILLED TIME             1,225.00   â”‚
│                                                                                â”‚
│────────────────────────────────────────────────────────────────────────────────│
│** ENTER SEQ # TO CHG; ENTER FOR MORE; F4 TO END; F5 FOR OPTIONS; ______        â”‚
│   F1=START AT FEES; F2=START AT DISB'S; MMDDYY=START AT DATE.                  â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** ENTER SEQ # TO CHG; ENTER FOR MORE; F4 TO END; F5 FOR OPTIONS; ______
   F1=START AT FEES; F2=START AT DISB'S; MMDDYY=START AT DATE.

 

Enter the item line number to select or deselect.

 

To display by date enter the date in the format MMDDYY.

 

 

[Enter] to display next screen

 

When there are more items that will fit on one screen press [Enter] to advance and [F3] to return to the previous screen.

 

 

[F1] to start display at fees.

 

[F2] to start display at disbursements.

 

[F3] to display the previous screen.

 

[F4] to return to main display.

 

[F5] to display selection options.


SELECTION OPTIONS

┌────────────────────────────────────────────────────────────────────────────────┐
│01/08/07                 TIME/DISBURSEMENTS SELECTION                       TWOI│
│────────────────────────────────────────────────────────────────────────────────│
│CLIENT  012345   XYZ CORPORATION LTD.                 TRUST BAL      TERM BAL   â”‚
│MATTER  0000     CORPORATE MATTERS              CD          .00           .00   â”‚
│T/D/B   B            SELECTED TIME         .00  US          .00           .00   â”‚
│S/L/B   L            SELECTED DISB         .00  BILL STAT ON HOLD LAWYER JM     â”‚
│────────────────────────────────────────────────────────────────────────────────│
│  DATE/STAT  SOURCE LAWYER CODE   GL/HRS  REF/RATE    VALUE  ADJUST  BILLABLE   â”‚
│────────────────────────────────────────────────────────────────────────────────│
│F = CHANGE FLAG ON FEE ENTRIES                                                  â”‚
│                                                                                â”‚
│D = CHANGE FLAG ON DISB. ENTRIES                                                â”‚
│                                                                                â”‚
│A = CHANGE FLAG ON ALL ENTRIES                                                  â”‚
│                                                                                â”‚
│** ENTER CHOICE (F/D/A/F5=FLAG ALL):                                            â”‚
│────────────────────────────────────────────────────────────────────────────────│
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** ENTER CHOICE (F/D/A/F5=FLAG ALL):

 

"F" to modify flag on fees.

 

"D" to modify flag on disbursements.

 

"A" to modify flag on any entries.

 

[F5] to modify flag on all entries.

 

 

PROCEDURE - ACCESS AN EXISTING BATCH

 

Select Retainer-Bill Allocations from the Bill Processing menu. You are taken to the batch selection screen where you may create a new batch or select an existing batch for further processing. If there are existing batches, the oldest batch will be selected and the fields in the batch selection screen will be completed and the following prompt displayed.

 

Example Retainer-Bill Allocations Header Entry display:

┌────────────────────────────────────────────────────────────────────────────────┐
│01/02/07 Tm6          *****  PRE-BILL DETAIL ALLOCATIONS *****            3TPAI1│
│                                                                                â”‚
│                                                                                â”‚
│          COMPANY:            IdeaLaw Ltd.                                      â”‚
│          BATCH NUMBER:       0005                                              â”‚
│                                                                                â”‚
│          G/L DATE:           12/12/06                                          â”‚
│          CONTROL TOTAL:            375.00                                      â”‚
│          BATCH DESCRIPTION:  MILLER                                            â”‚
│                                                                                â”‚
│                                                                                â”‚
│** SPECIFY BATCH (CR=NEW BATCH; F1=START; F2=NEXT; F4=END):  ____               â”‚
│PRESS CR FOR NULL, F5 FOR INQUIRIES, F2 FOR NULL, F3 TO BACK UP.                â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** SPECIFY BATCH (CR=NEW BATCH; F1=START; F2=NEXT; F4=END):

 

Enter the number of the batch to access.

 

[Enter] to create a new batch.

 

See PROCEDURE - BATCH CREATION/ACCESS.

 


[F1] to process the displayed batch.

 

** PRESS ENTER TO CONTINUE; F3 TO RE-ENTER; F4 TO END:

 

[Enter] to continue to data entry.

 

See PROCEDURE - ADD/DELETE LINES.

 

 

[F3] to return to the previous field.

 

[F4] to exit to menu.

 

[F2] to display header of next batch, if any.

 

[F4] to exit to menu.

 

[F5] to display list of existing batches for selection.

 

 

PROCEDURE - ADD/DELETE LINES

 

If you access an existing batch the following prompt is displayed at the batch header.

 

** SPECIFY BATCH (CR=NEW BATCH; F1=START; F2=NEXT; F4=END):  ____

 

[Enter] to create a new batch.

 

See PROCEDURE - BATCH CREATION/ACCESS

 

 

[F1] to process the batch details.

 

You are taken to the data entry screen where you may add or delete lines in the batch.

 

 

[F2] to display the next batch, if any.

 

[F4] to exit to menu.

 

The following prompt is displayed at the data entry screen.

 

PRESS CR FOR NEXT, F2 TO DISPLAY, F3 FOR BATCH CONTROL, F4 TO END

 

Enter the SEQ# of the detail line you wish to display or delete.

 

** PRESS ENTER TO CONTINUE; 'D' TO DELETE

 

[Enter] to continue with data entry.

 

"D" to delete the line.

 

The line is deleted without further warning.

 

 

[Enter] to begin new detail line with next sequential number.

 

This enables you to add additional lines to the batch (See PROCEDURE - DATA ENTRY).

 

 

[F2] to display detail lines.

 

** ENTER STARTING SEQ# (CR FOR FIRST; F4 TO END)

 

Enter the SEQ# of detail line to begin display.

 

[Enter] to begin display at first detail line of batch.

 

[F4] to return to SEQ# field.

 

[F3] to return to batch selection screen.

 

[F4] to exit data entry and display the print selection menu.

 

 

PROCEDURE - REGISTER PRINTING AND UPDATE

 

After you have completed data entry in a new batch or completed adding and deleting lines to an existing batch, press [F4] to exit. You are taken to the print selection menu where you may print the batch registers.

 

PRINTER SELECTION & CONFIGURATION

┌────────────────────────────────────────────────────────────────────────────────┐
│08/14/07                *****  PRINTER SELECTION  *****                         │
│                                                                                â”‚
│                                                                                â”‚
│** MAKE SURE PRINTER IS READY BEFORE PRESSING CR .....                          â”‚
│                                                                                â”‚
│1. PRINTER NAME ................................. P1  OKIDATA 390               â”‚
│                                                                                â”‚
│2. CHARACTERS PER INCH ? (10,12,17) ............. 10                            â”‚
│   SINGLE OR DOUBLE DENSITY ? (S,D) ............. S   SINGLE DENSITY            â”‚
│                                                                                â”‚
│** PRESS CR TO SET PRINTER, OPTION# TO CHANGE, F4 TO END (BYPASS): _            â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** PRESS CR TO SET PRINTER, OPTION# TO CHANGE, F4 TO END (BYPASS):

 

"1" to change printers.

 

"2" to change the CPI and/or print density.

 

[Enter] to print.

 

[F4] to not print and exit to the menu.

 

[F5] to display a list of printers for selection.

 

After printing the registers you have the following options. If you do not print the registers, the batch options are not available.

 

** ENTER OPTION.....   REPRINT; MORE INPUT; UPDATE; ABORT; END:

 

"R" to reprint the register.

 

"M" to enter additional data into the batch.

 

"U" to update the batch.

 

"A" to abort the batch, all data in the batch is lost.

 

"E" to exit, batch remains open, no data is lost.