LEDES 1998BI V2 Format Specifications

Last updated
Save as PDF

Here are the specifications for LEDES98BI V2 additional fields.

This format is also known as LEDES98B-INTL. The specification describes the fields that make up a single row in a LEDES98BI V2 file. All of the fields described in LEDES98B Format Specifications are part of this format also with the exception of the LINE_ITEM_TOTAL which would include the tax (see below). Those fields are not repeated in the table below; click the link to see those fields. Only the additional fields that are unique to LEDES98BI V2 are shown in this table. The Comments column contains information that relates to Collaborati's processing of the file.

LINE_ITEM_TOTAL = (LINE_ITEM_UNIT_COST * LINE_ITEM_NUMBER_OF_UNITS) + LINE_ITEM_ADJUSTMENT_AMOUNT + LINE_ITEM_TAX_TOTAL

You can find additional information about LEDES format specifications can be found at www.ledes.org.

Specifications for LEDES98BI V2 additional fields


Character	100	PO_NUMBER	The alphanumeric, client assigned purchase order number or code.	This field is not used.
Character	20	CLIENT_TAX_ID	The client's identification for tax purposes.	This field is not used.
Character	255	MATTER_NAME	The name of the matter to which this invoice relates.	This field is not used. Matter names are provided by the client's system to match the referenced Matter IDs.
Currency	12.4	INVOICE_TAX_TOTAL	The sum of all LINE_ITEM_TAX_TOTAL items in this invoice.
Currency	12.4	INVOICE_NET_TOTAL	The sum of all LINE_ITEM_TOTAL values in this invoice minus the INVOICE_TAX_TOTAL. A null value ("") would be an error.
Character	3	INVOICE_CURRENCY	The submission currency by the law firm or office denoted by the 3 character ISO currency code (ISO 4217).	If left null, the currency code from the office profile will be used.
Character	30	TIMEKEEPER_LAST_NAME	The last name of a timekeeper.	This field is not used. Timekeeper name is defined on the timekeeper's profile in Collaborati.
Character	30	TIMEKEEPER_FIRST_NAME	The first name of a timekeeper.	This field is not used. Timekeeper name is defined on the timekeeper's profile in Collaborati.
Character	1	ACCOUNT_TYPE	An identifier indicating whether an invoice is "own account" ("O"), or "third party" ("T").	This field is not used.
Character	60	LAW_FIRM_NAME	Law firm name.	This field is not used. Law firm's name is defined on the law firm's profile in Collaborati.
Character	60	LAW_FIRM_ADDRESS_1	The street address of the law firm. Given these display fields can be supplemented by intermediate office applications, a null value ("") would be acceptable.	This field is not used. Law firm's address is defined on the law firm's profile in Collaborati.
Character	60	LAW_FIRM_ADDRESS_2	Optional second street address of the law firm. Given these display fields can be supplemented by intermediate office applications, a null value ("") would be acceptable.	This field is not used. Law firm's address is defined on the law firm's profile in Collaborati.
Character	40	LAW_FIRM_CITY	The city of the law firm.	This field is not used. Law firm's address is defined on the law firm's profile in Collaborati.
Character	40	LAW_FIRM_STATEorREGION	The state or region of the law firm.	This field is not used. Law firm's address is defined on the law firm's profile in Collaborati.
Character	20	LAW_FIRM_POSTCODE	The postal code of the law firm.	This field is not used. Law firm's address is defined on the law firm's profile in Collaborati.
Character	3	LAW_FIRM_COUNTRY	The country code of the law firm.	This field is not used. Law firm's address is defined on the law firm's profile in Collaborati.
Character	60	CLIENT_NAME	Client name.	This field is not used. Client name is defined on the client profile in Collaborati.
Character	60	CLIENT_ADDRESS_1	The street address of the client.	This field is not used. Client address is defined on the client profile in Collaborati.
Character	60	CLIENT_ADDRESS_2	Optional second street address of the client.	This field is not used. Client address is defined on the client profile in Collaborati.
Character	40	CLIENT_CITY	The city of the client.	This field is not used. Client address is defined on the client profile in Collaborati.
Character	40	CLIENT_STATEorREGION	The state or region of the client. Given these display fields can be supplemented by intermediate office applications, a null value ("") would be acceptable.	This field is not used. Client address is defined on the client profile in Collaborati.
Character	20	CLIENT_POSTCODE	The postal code of the client.	This field is not used. Client address is defined on the client profile in Collaborati.
Character	3	CLIENT_COUNTRY	The country code of the client.	This field is not used. Client address is defined on the client profile in Collaborati.
Decimal	0.4	LINE_ITEM_TAX_RATE	Percentage tax rate against charge. A decimal number between 0 and 1 indicating the rate of taxation on the line item. A null ("") or 0 would indicate no taxes apply to the line item.
Currency	10.4	LINE_ITEM_TAX_TOTAL	Total amount of tax for the line item.	Total amount of tax for the specified Non-US-Tax Code for the matter for the invoice. Cannot be null (zero is a valid value).
Character	20	LINE_ITEM_TAX_TYPE	Tax type indicator (e.g. VAT, GST, PST, Other). Information purposes only and not used in the invoice calculation.	This field is required and must contain a client-authorized Non-US-Tax Code. If the EXP/FEE/INV_ADJ_TYPE field is E, this field has to be an authorized Non-US tax code on expense; If the EXP/FEE/INV_ADJ_TYPE field is F, this field has to be an authorized Non-US tax code on fees.
Currency	12.4	INVOICE_REPORTED_TAX_TOTAL	The amount of tax in the national currency as reported to the tax authorities.	This field can equal the sum of all LINE_ITEM_TAX_TOTAL items in the invoice or be blank.
Character	3	INVOICE_TAX_CURRENCY	The currency of INVOICE_REPORTED_TAX_TOTAL denoted by the 3 character ISO currency code (ISO 4217). A null value ("") would mean that the total tax on an invoice is in the same currency as the INVOICE_CURRENCY.	This field can match the INVOICE_CURRENCY field or be blank.