Overview of LEDES XML and Tax
Some users have encountered a problem recently with their LEDES XML file and tax.
File Error: INVOICE_TOTAL #### does not match the total calculated by Collaborati ****
where #### is the invoice total with tax
and **** is the invoice total without tax
and the invoice is LEDES XML
Collaborati seems to be calculating the total and not including this tax amount (only including the fee lines and expense lines). This is due to better validation on how the tax is applied in Collaborati 3.9. The tax will need to be defined at the line items going forward.
Below is a sample of the @FEE segment with the @TAX_ITEM_FEE segment - all the fee segments would need to have this information.
<fee>
<charge_date>2018-12-31</charge_date>
<tk_id>13</tk_id>
<tk_level>Other</tk_level>
<work_location_country>US</work_location_country>
<charge_desc>Fee 2018</charge_desc>
<task_code>B400</task_code>
<task_activity>
</task_activity>
<charge_type>U</charge_type>
<units>8</units>
<rate>1250.00</rate>
<base_amount>10000.00</base_amount>
<item_disc_cred_amount>0.00</item_disc_cred_amount>
<total_amount>10000.00</total_amount>
<file_item_nbr>36</file_item_nbr>
<tax_item_fee>
<tx_id>TAX</tx_id>
<file_item_nbr>99</file_item_nbr>
</tax_item_fee>
</fee>
note, <tx_id>TAX</tx_id> the value TAX would need to match the tx_id reference in the @TAX segment in your file
and <file_item_nbr> value is a unique number
Each line with tax would need to include the @TAX_ITEM_FEE segment.
Here is an example of the error:
Attached is a sample file from the www.LEDES.org website showing how the @FEE segments include the the @TAX_ITEM_FEE segment.