Sunday, October 3, 2010

Autoinvoice Interface : Accounting Rules Setup

We can setup as many rules as required to cover our various business scenarios involving how you want to recognize revenue.

we have a seeded Accounting Rule named Immediate. This Accounting Rule is provided by Oracle. The only field we can modify here is the Period type, and we should ensure that the value here matches the Period type used by our Ledger.

                Responsibility: Receivables Manager
               Navigation: Setup > Transactions > Accounting Rules

 Below is the form used to do the Accounting Rules setup.

Following describes each of the fields in the above form:

Enter a unique and descriptive name for your Accounting Rule

Enter text that describes this Accounting Rule

You have 4 options for Rule type
  • Fixed Schedule (formerly Fixed Duration), this type prorates 100% evenly across the Number of Periods you specify
  • Variable Schedule (formerly Variable Duration), this type allows you to later specify, during invoice data entry, the number of periods over which you want to recognize revenue.
  • Daily Revenue Rate, All Periods, this type will use a daily revenue rate to calculate the precise amount of revenue for all periods whether it is full or partial. Use accounting rules of this type to meet strict revenue accounting standards which require accurate revenue recognition on a per-day basis.
Daily Revenue Rate = Total Revenue / Total Number of Days across all periods

  • Daily Revenue Rate, Partial Periods, this type is a hybrid between Fixed Schedule and Daily Revenue Rate, All Periods. It will use a daily revenue rate to calculate the precise amount of revenue for the partial periods in the schedule, then prorate the revenue evenly across the full periods.
Partial Period is when the invoice exists for only part of the period as opposed to all days within the period

This corresponds to the Period types you defined in Oracle General. Keep in mind that during data entry of the invoice lines, you can only use Accounting Rules that have the same Period as your Ledger. In addition to period types you've defined you can also pick Specific Date, which enables you to enter a specific date in the Date field in the Schedule section discussed below.

Number of Periods:
Enter the number of periods you want this accounting rule to recognize revenue across.

Deferred Revenue:
If you want to delay recognizing revenue, check this check box. When checked, invoices using this rule will have its revenue deferred to an unearned revenue account, and you must later use the Revenue Accounting Management (RAM) wizard to recognize the revenue.
Invoices that use a Deferred Rule, will not appear in the Revenue Recognition Report, until Revenue is Scheduled via the Revenue Accounting process.
Responsibility: Receivables Manager
Navigation: Control > Accounting > Revenue Accounting

Schedule Section:
Period: Specify the sequence of the Period starting with 1.
Percent: Indicate the percent of the revenue you want to recognize in this period. Total Percent across all periods must equal 100% for Fixed Schedule types. For Variable Schedule types, you are allowed to define the percentage for the first period, which is typically less than 100%.
Date: Enter a specific date, e.g.  10-JUN-2010, this field is only enabled if the Period you specified in the header section is Specific Date

If you pick Type = Fixed Schedule, the Schedule section is automatically populated for you with as many rows as you specified in Number of Periods, and the percentage will be evenly spread across all periods to sum up to 100%.

If you pick Type = Variable Schedule, you do not need to enter any details in the Schedule Section. However, if you want to recognize a specific percentage of revenue in the first period, you can enter Percent details for Period 1. The remaining percentage will be spread across the remaining periods you specify during transaction data entry.

3 Responses to “Autoinvoice Interface : Accounting Rules Setup”

bheconsulting said...
November 12, 2010 at 7:40 AM

Really Nice and Interesting Blog Post! we share the information to all. Anyway, Thanks deferred revenue accounting .

matt said...
November 25, 2010 at 8:08 AM

Thanks for the information, we will add this story to our blog, as we have a audience in this sector that loves reading like this deferred revenue accounting .

Anonymous said...
February 9, 2011 at 9:07 PM

I am a frequent follower of your Blog!!
Exspecially this is one our best blog post.. Thank you..


Post a Comment


The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.