How to Post Recurring Entries in SAP?

What is Reference Document in SAP ?

A reference document is a document from which data is copied to another document. Both the recurring & sample document in SAP are reference documents. They are mainly used to post transactions to General Ledger Accounts. Reference documents are useful when there are many entries to be done, such as many debits and credits

Reference Document -

Recurring Document - FBD1

Sample Document - F-01

From my personal experience, I have observed that most of the organizations post repetitive accounting entries in their system. By repetitive, I mean the same type of entries with the same amount, but on a fixed interval. In SAP, we call them Recurring Entries. In this tutorial, I will share a step-by-step tutorial on the concept of Recurring Entries in SAP.

Why do you need such accounting entries? Before we proceed, it is really important to understand the usage of recurring entries. For example, if an organization has taken a loan from a bank or a third-party, they are liable to pay a fixed amount every month. Now, since it is a fixed amount like an EMI with a fixed duration, you can set up recurring entries in SAP and the system will post them on a fixed interval.

The interval can be monthly, every 2 months, and so on. It depends on the nature of the transaction and how frequently you will be making the payments to the creditor. These details can be maintained while you are preparing a recurring document. You can also set up recurring entries for vendor payments. Without delaying it further, I will quickly move on to the tutorial now.

PATH >> SAP Easy access > Accounting > Financial Accounting > General Ledger > Document Entry > Reference Documents

Step 1: Create a Recurring Document via t-code FBD1 in SAP

The first step of the process is to create a recurring document that contains the accounting entry. For this purpose, you have to use the t-code FBD1 in SAP.

Execute the transaction code FBD1 and enter the required details on the input screen.
  1. Company Code – Enter the company code for which you are creating a recurring document.
  2. First Run On Date – Enter the date on which the first recurring posting will take place. For example, if you want to post the first posting on 1st Jan 2021, then you need to enter the same date in this field.
  3. Last Run On Date – Input the date on which the last recurring posting will take place. For example, if the last posting date is 31st Dec 2021, then you need to enter the same date here.
  4. Interval in Months – Enter the frequency of the recurring postings. For example, Monthly, Every 2 months, Every 3 months, etc.
  5. Run Date – Enter the day of the month on which the posting will be carried out. Please note that this is an optional entry and if you keep it blank, then the posting will take place on the day that you have given in the ‘First Run On’ field.
  6. Document Date – Also, Enter the document date of the recurring document.
  7. Currency/Rate – Enter the currency code. If you are using a foreign currency, then you can also enter the exchange rate.
  8. Reference – Also, you can use this optional field to capture any important information like cheque number, document number, etc.
  9. Document Header Text – In this field, you can enter the narration of the document.

Create a Recurring Document in FBD1

STEP 2: Enter values for 1st line item fields.

STEP 3: Enter values for 2nd line item fields and Post 

Document 9100000000 was stored in company code BAJA.

Step 2: Display Recurring Document in t-code FBD3

To display a recurring document, you can execute the transaction code FBD3 and enter the document number, company code, and fiscal year to display it. Also, please make sure that the details given in the recurring document are correct. If not, you can still change this document in tcode FBD2.

Display a Recurring Document in FBD3
Path to Execute : SAP Easy access> Accounting> FI> GL> Periodic Processing > Recurring Entries >

>>To view list of Recurring Documents use T-Code F.15

Enter company Code, Fiscal year , Document number and Execute to view list.

>> To Execute/Post Recurring Document with T-Code F.14

STEP 1: Enter Company Code, Doc. Number, Fiscal year, Next Run on and Execute in Background.

After that, it is time to post the first accounting entry of the recurring document. In this step, you need to execute the transaction code F.14 in SAP. Enter the company code, recurring document number, and fiscal year on the selection screen.

In case, you don’t remember the document number, you can always get it from tcode FBD3. Alternatively, here in F.14, you have an option to search for a recurring document number with the help of general selections. Here, you can enter the document type, or posting date, or even reference number to search for the recurring document number.

In the ‘Settlement Period‘ field, enter the same date that you had given in the ‘First Run On‘ field while preparing the recurring document in FBD1. You can also give the name of the Batch Input Session.

Session SAPF120 was created.

After that, click on the Execute button to create a session. You will get a message at the bottom of the screen that the session has been created.

STEP 2: Go to 'Batch input: Session' with T-Code SM35 , select and process the batch (keep pressing enter until process is finished)

In the process session screen, you can choose your preferred way of processing. Also, you can select the ‘Process/Foreground‘ option if you want to process this batch job in the front end. Or, you can select the ‘Background‘ option to process the session in the background without disrupting your SAP frontend.

In addition, please make sure to enable the ‘Extended Log‘ checkbox as well. It will show the complete status of the session in the log. Click on the ‘Process‘ button to process the entry.

In the next screen, you can see the details of the recurring entry with a posting date of 1st Jan 2021. The system will also show you the next run date of the session when it will post the second recurring entry. In this example, it is 1st Feb 2021.

Post the Recurring Entry

Press Enter multiple times on your keyboard until you see the notification ‘Processing of Batch Input Session Completed‘. Click on the ‘Session Overview‘ button to display the log of the recurring document.

Batch Session Completed

As a result, you can see the accounting document number that has been posted for the recurring document. You can open this accounting document number in transaction FB03 to display the accounting entry.

Display the Batch Session Log

Optional Step: Display the Accounting Document in FB03

Execute the transaction code FB03 and enter the document number, company code, and fiscal year to view the accounting entry.

Display the accounting document in FB03
Display the document details
You can click on the ‘Display Header Data‘ button to bring the pop-up for the header data section, for instance. Here, you can see the posting date and the original recurring document number.


Check Document posted with T-Code FB03L



















Comments

Post a Comment

Popular posts from this blog

What is General Ledger Master Data creation and deletion ?

Image
SAP FICO Global Parameters refer to a set of mandatory variants and control parameters that must be maintained for every company code to enable smooth financial accounting and integration with Controlling. These parameters define the basic accounting framework of a company code, such as: Chart of Accounts Fiscal Year Variant Posting Period Variant Field Status Variant All these are maintained based on the Variant Principle. Master Data O Master Data is the information which remains in the system for a long period of time and does not change so often such as G/L Master Data, Customer Master Data, Vendor Master Data, Bank Master Data, Item Master, User Master Data etc. O It represents the business objects that contains agreed upon information which is shared across an organization O It is non-transactional in nature but is used in transactional documents as an information about a G/L account, Customer/Vendor or an item etc. O G/L Master data (Centrally) - Both chart of accounts level/seg...
Read more

What is a Chart of Account and how to assign to company code in SAP FICO ?

Image
Chart of accounts  A Chart of Account is assigned to a company code in SAP Configuration by specifying the chart of accounts key in the company code settings. Each company code can be assigned to only one operational chart of accounts, but one chart of accounts can be assigned to multiple company codes. O Highest level of hierarchy for all the G/L accounts O It is created by following the 3-method variant principle O Create Chart of Accounts: T-code: OB13 O Define the properties to the chart of accounts O Assign company code to the chart of accounts: T-code: OB62 Menu path: Display IMG -> Financial Accounting -> General Ledger Accounting -> Master Data -> G/L Accounts -> Preparations -> Edit Chart of Accounts List O Table: SKAI can be viewed through T-code: SE16N to display the relevant information III. Defining Chart of Accounts in SAP S/4HANA – A Step-by-Step Configuration Guide In every SAP S/4HANA implementation, the Chart of Accounts (COA) is one of the most ...
Read more

Reconciliation Accounts and G/L Master Data Creation in SAP S/4HANA – A Complete Beginner’s Guide

Image
If you are learning SAP S/4HANA Finance , understanding Reconciliation Accounts and G/L Master Data is critical. These concepts form the backbone of FI postings, sub-ledger integration, and real-time financial reporting . This blog explains everything clearly, practically, and in simple terms . 1. General Ledger in SAP S/4HANA The General Ledger (GL) is the central repository of financial data in SAP. A G/L account consists of two segments: Chart of Accounts (CoA) segment – global level Company Code segment – company-specific level Business transactions are: Recorded using the double-entry accounting principle (Debit = Credit) Classified into Assets, Liabilities, Income, and Expenses Used to generate Balance Sheet and Profit & Loss statements All transactions with business partners are first posted to sub-ledgers , and their totals are automatically updated in the General Ledger . 1. What Is a Reconciliation Account? A Reconciliation Account is a s...
Read more