How True Gross is Calculated
Back to Better Together - Revenue Interface Back to Qbyte Metrix 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.