How Reclassified Billing Offset Balances are Calculated
Unbilled receivables and deferred revenue aren't automatically cleared during regular invoice and revenue processing. Periodically submit the Create Accounting Transactions process to automatically create reclassification accounting transactions that net the unbilled receivables and deferred revenue balances together into a single balance.
Create an accounting transaction if you want to manually override the projected reclassified amount or the reversal option on the reclassification accounting transaction for a single contract line. The billing offset balances are reclassified when you save the accounting transaction.
Settings That Affect Reclassified Billing Offset Balances
Select the business unit and accounting period that contain the balances you want to reclassify. If you choose to generate a success report, the Create Accounting Transactions output report will contain detail of the accounting transactions. Additional criteria you can select are:
-
Contract type
-
Revenue method classification
-
Contract number
-
Contract line number
How Accounting Transactions for Reclassified Billing Offset Balances Are Calculated
Project Billing uses a formula to calculate the projected amount of an accounting transaction for reclassified billing offset balances. This formula uses the lesser value of either the inception-to-date (ITD) revenue amount or the ITD invoice amount, and the period-to-date (PTD) reclassification amount. The formula is as follows:
Projected Accounting Transaction Amount = Lesser value of ITD Revenue Amount or ITD Invoice Amount - PTD Reclassification Amount
Oracle Fusion Project Billing performs these steps when reclassifying billing offset balances:
-
Create accounting transactions.
-
Set the accounting type to Billing Offset Reclassification.
-
Calculate the reclassification amounts.
-
-
Create reversal accounting transactions when the reversal option is selected.
-
Set the accounting type to Billing Offset Reclassification Reversal.
-
Change the accounting period to the next period, and set the accounting date to the first day of that period.
-
The reclassification amount is equal to the value of the billing offset reclassification accounting transaction, multiplied by -1.
-
-
If the contract business unit is configured to transfer revenue to general ledger, Oracle Fusion Project Billing creates accounting events.
Reclassified Billing Offset Balances Example
The following tables illustrate a scenario where existing revenue and invoice accounting entries are reclassified.
Revenue Accounting Entry for Month 1
Entry |
Distribution |
Account |
Debit |
Credit |
---|---|---|---|---|
SLA1 |
RDL1 |
Unbilled Receivables |
100 |
0 |
SLA1 |
RDL1 |
Revenue |
0 |
100 |
Invoice Accounting Entry for Month 1
Entry |
Receivables Item |
Account |
Debit |
Credit |
---|---|---|---|---|
SLA2 |
AR1 |
Accounts Receivable |
120 |
0 |
SLA2 |
AR1 |
Deferred Revenue |
0 |
120 |
Reclassified Billing Offsets Accounting Entry for Month 1
Entry |
Accounting |
Account |
Debit |
Credit |
---|---|---|---|---|
SLA3 |
RCLS1 |
Deferred Revenue |
100 |
0 |
SLA3 |
RCLS1 |
Unbilled Receivables |
0 |
100 |
Reclassified Billing Offsets Reversal Accounting Entry for Month 2
Entry |
Accounting |
Account |
Debit |
Credit |
---|---|---|---|---|
SLA4 |
RCLSR1 |
Unbilled Receivables |
100 |
0 |
SLA4 |
RCLSR1 |
Deferred Revenue |
0 |
100 |