Prepaid Grant Billing

 

  • Initial Grant Prepaid Billing: Journal ID begins BI%

Debit AR (100029)

Credit Deferred Inflows/Liability Acct (default is 700004, but can be whatever account entered by user).

Initial accounting string entered in Customer Contract Prepaid Lines (Dept, Fund, Authority, Project). Fields are missing PC Business Unit and Activity, which causes the above accounting to also miss these fields during streamlined billing. Oracle known deficiency.

  • Initial Prepaid Deposit Application to that initial billing: Journal ID begins AR%

Debit Cash (1XXXXX, specific cash account is automatically identified depending on deposit Bank Account)

Credit AR (100029)

Initial accounting string entered in Customer Contract Prepaid Lines (Dept, Fund, Authority, Project). Fields are missing PC Business Unit and Activity, which causes the above accounting to also miss these fields during streamlined billing. Oracle known deficiency.

  • After Expense Transaction or Allocation (System background batch process—GL updated several times per day): Journal ID begins CAPC%

Debit Unbilled AR (100040)

Credit Revenue (444999, 448999, or 449999)

Dept, Fund, Authority, Project and Activity Inherit from expense transaction (Debit Expenditure, Credit Cash). Account is the only value that changes at this step.

 

Utilization (User process, step 4 in billing—GL updated several times per day): Two Journal IDs, one begins BI% and other begins CAREV%

Debit AR (100029)

Credit Unbilled AR (100040) – BIL analysis Type

Debit Unbilled AR (100040) – UTL analysis Type

Credit AR (100029)

Debit Deferred Inflows/Liability Acct (700004).

Credit Unbilled AR (100040) – UTL analysis Type

Dept, Fund, Authority, Project and Activity Inherit from expense transaction (Debit Expenditure, Credit Cash). Account is the only value that changes at each step.


Example attached: