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.
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:
| Use | How the calendar is used |
|---|---|
| Automatic withholding tax | Period-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 terms | Calendar-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 reporting | Periods for the Payables Key Indicators report |
| Recurring invoices | The 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
| Frequency | Periods per year | Pattern |
|---|---|---|
| 4-4-5 | 12 | Every period has four weeks except the 3rd, 6th, 9th and 12th, which have five |
| 4-5-4 | 12 | Four weeks except the 2nd, 5th, 8th and 11th, which have five |
| 5-4-4 | 12 | Four weeks except the 1st, 4th, 7th and 10th, which have five |
| Monthly | 12 | Each month is a period |
| Quarterly | 4 | Each period is three months |
| Weekly | 52 | Each period is seven days |
| Other | You decide | Periods 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:
| Period | Start | End | Length |
|---|---|---|---|
| Jan-15 | 1 Jan 2015 | 28 Jan 2015 | 4 weeks |
| Feb-15 | 29 Jan 2015 | 25 Feb 2015 | 4 weeks |
| Mar-15 | 26 Feb 2015 | 1 Apr 2015 | 5 weeks |
| Apr-15 | 2 Apr 2015 | 29 Apr 2015 | 4 weeks |
| … | … | … | … |
| Dec-15 | 26 Nov 2015 | 30 Dec 2015 | 5 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.
| Status | Meaning in practice |
|---|---|
| Never Opened | The 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). |
| Future | Opened for entry ahead of time. Transactions can be dated in it, but accounting waits until the period is open. |
| Open | Normal processing: entry, validation, payment and accounting |
| Closed | Closed after the period's work is accounted and transferred. Can be reopened if needed. |
| Permanently Closed | Final. 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.
A consultant creates a calendar on Manage Payables Calendars. Which business process does NOT use this Payables calendar?
Automatic withholding tax with period-based limits
Payment terms whose due dates are calendar-based
Recurring invoices created from the Create Recurring Invoices spreadsheet
Opening and closing the ledger's accounting periods in General Ledger
A Payables calendar is generated with the 4-4-5 frequency. Which periods have five weeks?
The 1st, 4th, 7th and 10th
The 2nd, 5th, 8th and 11th
The 3rd, 6th, 9th and 12th
Only the 12th, to absorb the extra days at year end
A controller wants the prior fiscal year's Payables periods closed so that nobody can ever reopen them. Which status should be used?
Closed
Future
Never Opened
Permanently Closed
Sections you finish are checked off in the contents.