How True Gross is Calculated
Back to Better Together - Revenue Interface
True Gross Example
Transactions for a single well:
PA File | Line Items | ||||||||
---|---|---|---|---|---|---|---|---|---|
Booking Code | Amount | Account | Vendor | Source Vendor | Account | LI_AMT | LI_VOL | GROSS_UP_AMT | GROSS_UP_VOL |
B | 300.00 | N600.100 | 000001 | TCPL | 600.100 | -700.00 | -7.0 | 100.00 | 1.0 |
B | 400.00 | N600.100 | 100501 | TCPL | |||||
K | 100.00 | N600.100 | 100503 | 100503 | |||||
600.CLR | 700.00 | -7.0 | |||||||
N600.100 | -300.00 | -3.0 | |||||||
. | |||||||||
700.00 | 1200100 | TCPL | 1200100 | 700.00 | |||||
100.00 | 9999999 | 999999 | |||||||
1200998 | -400.00 |
Accountable Gross = LI_AMT only Accountable Gross Amount = $700.00 Accountable Gross Volume = 7.0
This represents the total of the entries with B (Billable) booking codes. It will include the owner’s net share and amounts distributed to insiders or external partners on joint interest billings
True Gross = LI_AMT + GROSS_UP_AMT True Gross Amount = $800.00 True Gross Volume = 8.0
This represents the total amount or volume for the cost centre and account. The GROSS_UP_AMT represents the total entries with K (Take-in-Kind) booking codes.
If an entry with a K booking code has the same source cost centre and account as an entry with a B booking code, the amount and volume for the transaction is populated into the gross_up_amt and gross_up vol fields for the line item for the gross account. If there are no entries with B booking codes for the cost centre and account, a line item will be created with a zero li_amt and li_vol and the gross_up_amt and gross_up_vol will be populated with the total of the entries with K booking codes.
Copyright© 2024 IFS AB. Copying prohibited. All rights reserved.