Oracle Project Billing allows you to generate draft invoices and draft revenue using separate processes, which you can run at different times. To allow for different billing cycles and revenue accrual, Oracle Projects creates the accounting distribution lines during invoice and revenue generation.
During the AutoInvoice process in Oracle Receivables, the balance on the advance is reduced (if applicable). The default account that is credited with the invoice amount is either the unbilled receivables (UBR) account or the unearned revenue (UER) account, depending on whether you accrue revenue before or after you generate invoices.
You can apply advance receipts to an agreement using the Apply Receipt window. When you run the program PRC: Generate Draft Invoices, the program reduces the available advance balance associated with the agreement.
The following examples illustrate how Oracle Projects accounts for revenue transactions.
After an advance receipt is applied to an agreement, Oracle Receivables creates the prepayment entry. The following table shows an example of a prepayment entry that Oracle Receivables creates:
| Account | Debit | Credit |
|---|---|---|
| On Account Cash | 200.00 | |
| Prepayment | 200.00 |
Once revenue is created, Oracle Projects runs AutoAccounting to determine the appropriate default accounts. AutoAccounting selects all of the AutoAccounting parameters for each item or event, determines the account coding, validates the account coding against the general ledger, and updates each revenue distribution line with the appropriate default account.
Any items or events that fail in AutoAccounting are marked accordingly, and the associated draft revenue is marked with a generation error. See: Overview of AutoAccounting, Oracle Projects Implementation Guide.
| Account | Debit | Credit |
|---|---|---|
| Unbilled Receivables and/or Unearned Revenue | 200.00 | |
| Revenue | 200.00 |
When you run the program to interface invoices to Oracle Receivables, Oracle Projects runs AutoAccounting to determine the appropriate default accounts. If the invoice fails AutoAccounting, then the program marks the draft invoice with an error. See: Overview of AutoAccounting, Oracle Projects Implementation Guide.
The following table shows entries Oracle Projects creates when the Interface Invoices to Oracle Receivables process is run:
| Account | Debit | Credit |
|---|---|---|
| Receivables | 200.00 | |
| Unbilled Receivables and/or Unearned Revenue | 200.00 |
The following table shows a Collections entry Oracle Receivables creates:
| Account | Debit | Credit |
|---|---|---|
| Cash | 200.00 | |
| Receivables | 200.00 |
The following table shows a prepayment matching entry that Oracle Receivables creates:
| Account | Debit | Credit |
|---|---|---|
| Prepayment | 200.00 | |
| Receivables | 200.00 |
The following examples shows accounting transactions for revenue accrual and billing.
The following table shows a revenue transaction entry prior to billing:
| Account | Debit | Credit |
|---|---|---|
| Unbilled Receivables | 200.00 | |
| Revenue | 200.00 |
The following table shows an invoice transaction entry prior to billing:
| Account | Debit | Credit |
|---|---|---|
| Receivables | 200.00 | |
| Unbilled Receivables | 200.00 |
The following table shows an invoice transaction entry prior to accrual:
| Account | Debit | Credit |
|---|---|---|
| Receivables | 200.00 | |
| Unearned Revenue | 200.00 |
The following table shows a revenue transaction entry prior to accrual:
| Account | Debit | Credit |
|---|---|---|
| Unearned Revenue | 200.00 | |
| Revenue | 200.00 |
The following table shows a revenue transaction entry prior to invoicing:
| Account | Debit | Credit |
|---|---|---|
| Unbilled Receivables | 200.00 | |
| Revenue | 200.00 |
The following table shows a partial invoice transaction entry:
| Account | Debit | Credit |
|---|---|---|
| Receivables | 100.00 | |
| Unbilled Receivables | 100.00 |
The following table shows a pre-bill transaction entry:
| Account | Debit | Credit |
|---|---|---|
| Receivables | 200.00 | |
| Unearned Revenue | 200.00 |
The following table shows an accrue more than pre-bill transaction entry:
| Account | Debit | Credit |
|---|---|---|
| Unearned Revenue | 200.00 | |
| Unbilled Receivables | 100.00 | |
| Revenue | 300.00 |