Skip Headers

Oracle Public Sector Financials (International) User Guide
Release 12.1
Part Number E13418-03
Go to Table of Contents
Go to previous page
Go to next page

Multi-Period Posting Process


Multi-Period Posting enables expenses to be recognized over multiple periods when the supplier issues one invoice. With Multi-Period Posting, users register an invoice once to automatically prorate it over the required periods and accounting entries are generated accordingly.


Multi-Period Posting enables the user to define various accounting rules to spread expenses over multi-periods. For example, an accounting rule can be defined to evenly spread an expense, such as insurance or rent, evenly over 12 periods. Users can assign a predefined accounting rule to the relevant invoice distribution lines and the system automatically spreads the expense over the general ledger periods. Users can manually update the automatically prorated lines.

At month end, a process is run to select all non-posted multi-period posting distribution line postings for the specified period and interface them to General Ledger for posting. Before posting, users run a report to recognize and update all the non-posted multi-period posting entries for the current period. Alternatively, users can run this report to list all the multi-period posting entries for the month.

Note: Multi-Period Posting is only available for expense account distribution. The procedure excludes accruals, assets, and all other account types.

Multi-Period Posting Process Flow Diagram

The diagram below shows the Multi-Period Posting process, as described in the accompanying text.

Multi-Period Posting Process Flow Diagram

the picture is described in the document text

Setting Up Multi-Period Posting

Set Up Accounting Rules

To spread expenses across a defined period, an accounting rule is created for each method required by the user defining the period, type of rule, and duration. An example of an accounting rule is 12 equal monthly postings.

Each accounting rule is set up with the following information:

Assign Multi-Period Posting Setup

The default accounting rules control account information that is used for Multi-Period Posting as follows:

Assign Default Accounting Rules

When an invoice is selected for Multi-Period Posting, the set of books default accounting rule is applied to all distribution lines. No action is automatically taken against an invoice expense distribution, but if the invoice is selected for Multi-Period Posting, a different accounting rule can be defaulted to the distribution line.

The default accounting rules by account are defined as follows:

The default accounting rules defined for the set of books and for individual accounts can be changed when Multi-Period Posting is applied to the invoice.

Selecting Invoices

Enter Payables Invoices

The invoice is entered in Payables in the standard manner. At this stage in the process, users cannot spread payments over multiple periods as the table below illustrates:

Enter Payables Invoices Example
Account Amount
Expense account 5050 debit GBP1200.00
AP Control account credit GBP1200.00

For information on entering invoices, see Oracle Payables User’s Guide.

Transfer Invoices to Multi-Period Posting

The invoices are selected from a list and transferred to the Multi-Period Posting process. They must be approved, but there are no further restrictions on their status, whether posted or paid.

When selected, the invoice is assigned a default accounting rule, as defined in the setup process. When the selection is complete, Transfer Invoice is clicked to start the multi-period posting invoice collection concurrent process. When the process is complete, the invoices are available in Multi-Period Posting.

Enter Multi-Period Posting Distributions

The required accounting rule is assigned to each expense distribution line of the invoice.

The required invoices are found, the invoice is selected, and distribution lines are displayed. Only those lines relating to expenses that can have Multi-Period Posting accounting rules applied are displayed. The following entries can be made:

When the amendments are saved, the postings to be made to General Ledger can be viewed on the MPP Distribution window. The MPP Distribution window also displays the status of the postings as they are made.

Subledger Entries

This is a one-time posting to General Ledger crediting the expense and debiting the future postings control account as shown in the table below:

Subledger Entries Example
Account Amount
Expense account (5050) debit GBP100.00
Future postings (1370) credit GBP100.00

Detailed Distributions

Based on a 12 month rule, the detailed distributions for each of the 12 periods is as shown in the table below:

Detailed Distributions Example
Account Amount
Expense account (5050) debit GBP100.00
Future postings (1370) credit GBP100.00

Period End Processing

Payables Accounting Process

The first stage of the month-end process runs the standard Payables posting to General Ledger, which consists of the following procedures:

These procedures move the standard Payables postings from invoices into General Ledger.

Multi-Period Posting Expense Recognition

The next stage of the month-end process recognizes the expense postings required to maintain the Multi-Period Posting invoices. This report can be run in the following modes:

In the first period for a Multi-Period Posting invoice, the recognition process identifies the subledger entries to credit the expense and debit the future postings account. The process recognizes the first of the 12 monthly postings crediting the future postings account and debiting the expense account. Subsequent monthly processes only post the remaining 11 monthly postings.

Multi-Period Posting Transfer to General Ledger

The final stage runs the Multi-Period Posting transfer to General Ledger that creates journal entries for General Ledger from the recognized multi-period postings and updates the posting status on the Multi-Period Posting distributions. Optionally, the process also runs the General Ledger journal import.