8.1 Payables Calendars and Payables Accounting Period Statuses

Key Takeaways

  • Payables calendars are used for automatic withholding tax, payment terms, key indicator reporting and recurring invoices, and their periods are separate from accounting calendar periods.

  • Payables calendar frequencies are 4-4-5, 4-5-4, 5-4-4, Monthly, Quarterly, Weekly and Other; Other means you enter periods manually.

  • In a 4-4-5 calendar the 3rd, 6th, 9th and 12th periods have five weeks; in 5-4-4 the 1st, 4th, 7th and 10th; in 4-5-4 the 2nd, 5th, 8th and 11th.

  • Period generation uses the period frequency, periods per year, start date and period name format; weekly and quarterly names combine the frequency, the period number and the year, for example Quarter1-15.

  • Payables accounting periods move through Never Opened, Future, Open and Closed, and finally Permanently Closed, which can't be reopened.

Last updated: October 2026

The published objective is Manage Payables Calendars. It's easy to confuse with the accounting calendar that a ledger uses. Oracle is explicit: periods in Payables calendars are separate from the accounting periods defined on Manage Accounting Calendars. Payables needs both.

What Payables calendars are for

You create Payables calendars on Manage Payables Calendars. Oracle lists four uses:

UseHow the calendar is used
Automatic withholding taxPeriod-based withholding limits and rate schedules, for example a yearly threshold per supplier (section 7.3). If a needed period is missing, validation places a Withholding Tax hold.
Payment termsCalendar-based due dates assign the due date to the period that includes the terms date, for example to avoid weekends or holidays. You can't assign a calendar-based term to an invoice if no period is defined for its terms date.
Key indicator reportingPeriods for the Payables Key Indicators report
Recurring invoicesThe Create Recurring Invoices spreadsheet uses a Payables calendar, of type General Purpose in Oracle's example, and a from and to period range (section 4.3)

Period frequencies

FrequencyPeriods per yearPattern
4-4-512Every period has four weeks except the 3rd, 6th, 9th and 12th, which have five
4-5-412Four weeks except the 2nd, 5th, 8th and 11th, which have five
5-4-412Four weeks except the 1st, 4th, 7th and 10th, which have five
Monthly12Each month is a period
Quarterly4Each period is three months
Weekly52Each period is seven days
OtherYou decidePeriods are entered manually

How periods are generated

When you create a calendar or add years, four attributes control generation:

  • Period frequency, for example Monthly or 5-4-4. Other means manual entry.
  • Periods per year, calculated from the frequency.
  • Start date: the first day of the calendar and of its first period.
  • Period name format: the naming convention.

For weekly and quarterly frequencies, the period name combines the frequency, the period number and the year. With a Quarterly frequency starting 1 January 2015, the first period is Quarter1-15.

Oracle's 4-4-5 example

A 4-4-5 calendar with a start date of 1 January 2015 and name format MMM generates periods like these:

PeriodStartEndLength
Jan-151 Jan 201528 Jan 20154 weeks
Feb-1529 Jan 201525 Feb 20154 weeks
Mar-1526 Feb 20151 Apr 20155 weeks
Apr-152 Apr 201529 Apr 20154 weeks
…………
Dec-1526 Nov 201530 Dec 20155 weeks

Notice that period names don't match calendar months: "Mar-15" ends on 1 April. That's why a calendar-based payment term can give a different due date from a "Day of Month" term.

Payables accounting periods and their statuses

Payables keeps its own accounting period statuses, maintained with the Payables Manage Accounting Periods task for the ledger. They follow the ledger's accounting calendar, which is separate from Payables calendars.

StatusMeaning in practice
Never OpenedThe period has never been used. A recurring invoice created for a Never Opened period gets a closed-period hold until the period is opened and the invoice revalidated (section 4.3).
FutureOpened for entry ahead of time. Transactions can be dated in it, but accounting waits until the period is open.
OpenNormal processing: entry, validation, payment and accounting
ClosedClosed after the period's work is accounted and transferred. Can be reopened if needed.
Permanently ClosedFinal. Can't be reopened.

How Payables and General Ledger periods interact

  • Payables periods are opened and closed independently of General Ledger periods, but they follow the same accounting calendar.
  • Oracle's close guidance (section 8.3): close a Payables period after accounting entries are created and transferred to the general ledger.
  • Run the Payables Unaccounted Transactions and Sweep process, which can move unaccounted transactions to an open or future period, then close the period.
  • Review the Payables Period Close Exceptions Report when closing.
  • Open the next Payables period and run the interface processes.
  • Adjustment periods: the Payables to Ledger Reconciliation report runs only for non-adjustment periods of the primary ledger. Payables activity belongs in regular periods.

Exam patterns

  • "Calendar" payment term won't default on an invoice. There is no Payables calendar period that covers the terms date. Generate more periods or years.
  • Withholding stops with a Withholding Tax hold. Check the period-based limits that rely on the Payables calendar.
  • Recurring rent invoices for next year are on hold. Those Payables periods were Never Opened. Open them and validate.
  • An auditor wants a year locked for good. Use Permanently Closed, which can't be reversed. Use Closed if you might need to reopen.
Loading diagram...
Test Your Knowledge

A consultant creates a calendar on Manage Payables Calendars. Which business process does NOT use this Payables calendar?

A

Automatic withholding tax with period-based limits

B

Payment terms whose due dates are calendar-based

C

Recurring invoices created from the Create Recurring Invoices spreadsheet

D

Opening and closing the ledger's accounting periods in General Ledger

Test Your Knowledge

A Payables calendar is generated with the 4-4-5 frequency. Which periods have five weeks?

A

The 1st, 4th, 7th and 10th

B

The 2nd, 5th, 8th and 11th

C

The 3rd, 6th, 9th and 12th

D

Only the 12th, to absorb the extra days at year end

Test Your Knowledge

A controller wants the prior fiscal year's Payables periods closed so that nobody can ever reopen them. Which status should be used?

A

Closed

B

Future

C

Never Opened

D

Permanently Closed

Sections you finish are checked off in the contents.