# SAP Fiscal Year and Posting Period Calculator

> Source: https://netray.co/tools/sap-fiscal-period-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Convert a calendar date to the SAP posting period and fiscal year for a non-calendar fiscal year, with a year shift option.

## Category

sap

## Erp

SAP ECC / S/4HANA

## Audience

- SAP FICO consultant
- Controller
- Finance key user

## Tool

**Kind:** calculator

**Inputs:**

#### Calendar month of posting date

**Key:** month

**Type:** select

**Default:** 4

**Options:**

##### January

**Value:** 1

##### February

**Value:** 2

##### March

**Value:** 3

##### April

**Value:** 4

##### May

**Value:** 5

##### June

**Value:** 6

##### July

**Value:** 7

##### August

**Value:** 8

##### September

**Value:** 9

##### October

**Value:** 10

##### November

**Value:** 11

##### December

**Value:** 12

#### Calendar year of posting date

**Key:** year

**Type:** number

**Default:** 2026

**Min:** 2000

**Max:** 2100

**Step:** 1

#### First month of fiscal year

**Key:** start

**Type:** select

**Default:** 4

**Help:** Month where period 001 starts. January means a calendar fiscal year.

**Options:**

##### January

**Value:** 1

##### February

**Value:** 2

##### March

**Value:** 3

##### April

**Value:** 4

##### May

**Value:** 5

##### June

**Value:** 6

##### July

**Value:** 7

##### August

**Value:** 8

##### September

**Value:** 9

##### October

**Value:** 10

##### November

**Value:** 11

##### December

**Value:** 12

#### Fiscal year naming

**Key:** shift

**Type:** select

**Default:** 0

**Help:** Year shift in the fiscal year variant: 0 names the year by its starting calendar year, 1 by its ending year.

**Options:**

##### Named by starting year (shift 0)

**Value:** 0

##### Named by ending year (shift +1)

**Value:** 1

**Outputs:**

#### Posting period

**Key:** period

**Expr:** month - start + 1 + 12 * lt(month, start)

**Format:** integer

**Primary:** true

**Description:** The period number from 1 to 12 within the fiscal year.

#### Fiscal year

**Key:** fy

**Expr:** year - lt(month, start) + shift * gt(start, 1)

**Format:** integer

**Primary:** true

**Description:** Fiscal year as SAP would store it in GJAHR.

#### Regular periods remaining after this one

**Key:** remaining

**Expr:** 12 - period

**Format:** integer

#### Share of regular periods elapsed

**Key:** elapsed

**Expr:** period / 12 * 100

**Format:** percent

**Chart:**

#### Posting period by calendar month

**Type:** line

**X:** month

**From:** 1

**To:** 12

**Steps:** 12

**Series:**

- period

**Disclaimer:** This models a simple 12-period fiscal year variant where each calendar month is one period. Special periods 13 to 16 are posted by period number rather than date, and your variant may differ. Check the variant in transaction OB29.

## Content

**Intro:** When your fiscal year does not match the calendar, it is easy to mix up which SAP period and fiscal year a posting date falls in. This calculator converts a calendar month to the period number and fiscal year for any start month, including the common April to March year.

**Sections:**

#### How to use the calculator

**Body:** Choose the calendar month and year of the posting date, the first month of your fiscal year and whether the fiscal year is named by its starting or ending year. The result shows the period (1 to 12) and the fiscal year as stored in the document field GJAHR. Compare it with your fiscal year variant in OB29 before you rely on it.

**Bullets:**

- April start: April is period 1, March is period 12.
- Shift 0 names the year by its starting year.
- Shift +1 names the year by its ending year.

#### The formula

**Body:** The period equals the calendar month minus the start month plus one, with 12 added if the month falls before the start month. The fiscal year equals the calendar year, minus one when the month falls before the start month, plus the shift when the fiscal year does not start in January. For April 2026 with start April and shift 0, the period is 1 and the fiscal year is 2026. For March 2027 the period is 12 and the fiscal year still 2026.

#### Special periods and period control

**Body:** SAP fiscal year variants usually add special periods 13 to 16 for year-end adjustments, such as audit postings. They are posted by entering the period explicitly, not by date. Posting periods are opened and closed per variant and account type in OB52, so an open period in one account type may still be closed for another. Always confirm that the target period is open before posting.

#### Common mistakes

**Body:** Teams often forget the year shift when they build reports and compare a fiscal year in SAP with the one used in budget files. Another mistake is assuming that the document date drives the period, when the posting date does. Be careful at year boundaries: a document dated 31 March but posted on 2 April belongs to period 1 of the new year.

**Cta:** If you are mapping fiscal calendars across SAP and other systems for consolidated reporting, Netray can discuss a read-only layer that applies the period logic consistently.

**Faq:**

#### What is the SAP period for April in an April to March year?

**Answer:** April is period 1 and March is period 12. In the standard variant that has this structure, special periods 13 to 16 follow for year-end postings. Check your own variant, since companies can define it differently.

#### What does the year shift do?

**Answer:** It moves the fiscal year label. With a shift of 1 and an April start, April 2026 to March 2027 is fiscal year 2027. With a shift of 0 the same span is fiscal year 2026.

#### Where is the fiscal year variant defined?

**Answer:** In configuration, under maintaining the fiscal year variant (transaction OB29), and assigned to the company code. Posting period variants are set separately in OB52.

#### Can a posting go into a special period by date?

**Answer:** No. Special periods 13 to 16 have no calendar dates. They are used by entering the period number on the posting, and they must be open in the posting period variant.

## Search terms

sap fiscal year variant calculator, sap posting period april march, sap fiscal period from date, sap v3 fiscal year variant period, sap fiscal year shift, sap period 1 april, sap fiscal year variant ob29, sap special periods 13 to 16

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json
