/
How True Gross is Calculated

How True Gross is Calculated

Search the Qbyte Financial Wiki
 

Back to Better Together - Revenue Interface     Back to Qbyte Metrix Interface

True Gross Example

Transactions for a single well:

PA File

Line Items

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.