In my last blog, I discussed Multi-Period Accounting in Oracle Accounts Payable (AP) and how it helps organizations accurately distribute expenses across accounting periods. Continuing the revenue and expense recognition journey, let's now shift our focus to the Accounts Receivable side and explore one of the most important billing concepts in Oracle AR: Invoicing Rules.
Multi-Period Accounting is an Accounts Payable functionality where expenses are recognized/accrued in the correct periods; Invoicing Rules is an Oracle Receivables functionality that determines when customers are billed for goods or services and when revenue is recognized.
In this blog, we will explore the functionality of Invoicing Rules for organizations that manage subscriptions, maintenance contracts, and other business processes where billing and revenue recognition occur at different times.
Oracle Invoicing Rules in Accounts Receivable
An Invoicing Rule determines how and when an invoice amount is billed to the customer.
Oracle provides two standard invoicing rules:
- Bill in Advance
- Bill in Arrears
These rules are assigned to transaction lines and work in conjunction with accounting rules.
Think of it this way:
- Invoicing Rule = When do I bill the customer?
- Accounting Rule = When do I recognize the revenue?
Most Common Scenarios:
- Software Services rendered
- Rental Agreements
- Multi-Year Support Projects
These are common business scenarios where organizations bill customers using invoicing rules; without them, the organization would have to create invoices manually every month or quarter, which increases effort and may delay the period-end process.
Bills in Advance
In AR Bills in Advance, Oracle generates an AR Invoice before the service period has occurred.
Example:
- Yearly Support Projects
- Lease Agreements
Example:
A contract of CAD 120,000 is generated for MSA Contract for year long service (12 Months). The start date of the contract is 9/1/2026 to 8/31/2027.
The Invoicing rule used for this example will be Bills in Advance- with monthly revenue recognition process.
To create the AR Invoice and use Invoicing Rules- you need to setup the scheduling rules and Invoicing Rules.
Setup and Maintenance-->Financials-->Customer Billing-->Manage Revenue Scheduling Rules
Name: Month, 1 Yr, Non Deferred
Type: Fixed Schedule
Number of Periods: 12
Now add the percentage of revenue recognition over 12 Months- we are taking equal distribution
Create an AR Invoice with Invoicing Rule--> In Advance
Click in Invoice Line Details to enter the revenue Scheduling
Complete and Post the AR Invoice for Accounting
Accounting in this case would be the following:
Accounts Receivable A/c Dr.- 120000
Deferred/Unearned Revenue A/c Cr- 120000
During Month end- the create accounting and revenue recognition process will automatically create the revenue recognition entries i.e.
Deferred/Unearned Revenue A/c Dr- 10000to Revenue Cr- 10000
Bills in Arrears
Under Bill in Arrears, the service is delivered, and an AR invoice is generated later.
Examples
- Time and Material contracts
- Utility Bills
Lets consider a scenario where contract is of CAD 120,000 with duration 12 months and there will be monthly billing of CAD 10000. Same Period as above example
9/1/2026 to 8/31/2027
Under Bill in Arrears, September services are delivered first and invoiced later.
Under Bill in Arrears, January services are delivered first and invoiced later.
Accounting in this case will be
Unbilled Receivables A/c Dr 10000
to Revenue A/c Cr 10000
When Invoice is generated
Accounts Receivables Dr 10000
to Unbilled Receivables Cr 10000
For a bill in Arrears, Oracle AR does not create Deferred Revenue (Unearned Revenue) like a bill in Advance.
As you see, similar to Payables - Receivables also has a deferred revenue recognition process feature available.
Organization implementing this feature will definitely benefit from Automated billing schedules, improved cash flow management, reduction in monthly journal entries and accurate accounting with better controls
No comments:
Post a Comment