What is Closing Procedures in SAP FI (Financial Accounting)?
SAP Modules has its own period-end and year-end closing procedures. FI (Financial Accounting) is one such module, which lets the user keep more than one period open at the same time. FI is an on-line system that continuously and completely integrates the general ledger with accounts receivable and accounts payable. At the beginning of a new period, the user has to keep the current period open for new transactions such as posting customer invoices, while the user also has the previous period open for adjustments.
In FI (Financial Accounting), the complicated, technical closing procedures to close the prior period, open the new period and carry forward account balances cease to exist. In fact, the user should have two posting periods open at the same time – to make adjustments in the prior period before reporting the results and to post customer/vendor invoices or other data to the new period. SAP being an integrated system, the user cannot simply hold all invoices and wait for the prior period to be closed before opening the new period and execute the transactions.
SAP Closing Procedures:
During the first few days of the new period, all adjustments are usually to be posted to the prior period. Before closing the prior period, user can run a transaction journal of adjustments and accruals depending on the “document” type of adjustment entries scan the journal and be sure that all of these closing entries were posted to the prior period only.
Fact of the matter lies that homosapiens are bound to make errors. Thus, if a user made a mistake and posted a closing entry to the new period instead of to the prior period, then SAP gives the flexibility to the user to reverse the transaction and post it again to the prior period.
- Overview of the Closing Process
- Overview of the Month-end Closing Process
The above flowchart provides an overview of the integration of various modules in month-end closing process.
- Pre-Close activities, which begin in the old month, include:
- Technical – Open new accounting period (FI).
- FI – Enter accruals/deferrals, process recurring entries and bad debt expense in AR, post depreciation and interest expenses in Asset Accounting.
- MM – Maintain GR/IR clearing account, post-material revaluations.
- HR – Post payroll expenses.
- SD – Record goods issues for deliveries and invoice customers.
- Technical – Close old month in (MM), close sub-ledgers (FI), preliminary close of G/L (FI).
- Managerial Close activities include :
- CO – Allocations and reposting, locking the previous period in CO.
- FI – Re-opening the G/L for adjustment postings.
- Financial Close activities include:
- CO – Reconciliation posting to FI (for cross-organizational-unit CO postings).
- FI – Foreign currency revaluations and postings to correct business area, profit center, and profitability segment out-of-balance conditions.
- Technical – Final close of the old period.
- FI/CO – Create management and financial reports.
- Overview of the Year-end Closing Process
The above flowchart provides an overview of the year-end closing process. These activities are performed in addition to the regular month-end closing process for the final period of the fiscal year.
- Pre-Close activities, which begin in the old month, include:
- Technical – Open the first accounting period of the new fiscal year (FI).
- MM – Perform physical inventory count (may be performed on a monthly basis).
- PP/CO – Update product cost estimates (may be performed more frequently).
- MM – Lowest value determination and LIFO/FIFO valuation.
- AA – Asset revaluations and capital investment support.
- FI – Balance confirmations for receivables/payables.
- Technical – Fiscal year change (AA) and balance carry forward (FI).
- Financial Close activities include:
- FI – GR/IR clearing account analysis, receivables/payables regrouping, reconciliation of prior year to new year, and other adjustment postings.
- Technical – Final close of the old period (AR/AP and GL).
- FI/CO – Create management and financial reports.
- Closing the Period – Step-by-step procedure
Similar to the variety of Kabas we have in India, the closing procedure also varies with organization working on SAP. Opening the new period and closing the previous period are two parts of the closing procedure. A sample procedure to close the period is as follows:
- Coordinate closing with the purchasing department (MM), the cost accounting and internal reporting department (CO), and with fixed assets accounting department (AA).
- In MM, user can post inventory movements only in the current period and the previous period. When the user close the period in the purchasing department using MM, the user prevents posting of vendor invoices (invoice verification) and inventory movements in the closed period and permit posting of invoices in the new period.
- It is usually advisable for the user to enter the new intercompany exchange rates with a validity date from the beginning of the new period. Best practice is to enter both exchange rates, in other words, the intercompany rate from transaction or group currency to local currency, such as from 1 USD to 1 EUR, and the reciprocal from local currency to the same transaction or group currency, such as from 1 EUR to 1 USD.
- Post other accruals to be reversed automatically.
- Post any management fees as G/L transactions.
- Post reserves as G/L transactions.
- If required, revalue open items and G/L accounts according to company policy or GAAP.
- Optionally, revalue prepayments and accruals in local currency to group currency.
- Post revaluation from previous step.
- Run a transaction journal to verify that no adjustments or closing entries were posted at the beginning of the new period.
- Close the previous period. FI automatically carries forward the account balances to the next period (during the fiscal year). At the end of the year, the user has to run two programs in FI. The first carries forward customer and vendor account balances. The second carries forward G/L account balances.
- Prepare the VAT report based on the report supplied by SAP. Make the VAT adjustment, posting VAT payable/refundable either manually or with the supplied VAT report. This adjustment makes the account balances in the input and output VAT accounts zero, so that the calculation for the next month starts at zero.
- If required (at year-end), revalue open items and G/L accounts according to the local regulations and revaluation methods. If required, post transaction gains/losses to separate G/L accounts.
- With the local balance sheet format, prepare the balance sheet and profit & loss account.
- Document briefly any changes to the procedure. Training should be imparted to everyone involved in the process.
- Closing the Period – Major procedures in detail
I. Opening the new posting period in FI
To open the new posting period:
- Menu Path: Financial Accounting – General Ledger – Environment – Current Settings – Open and Close Posting Periods
- T-Code: OB52 / S_ALR_87003642
- For each company code, specify at least + in the second column to specify two possible ranges of open posting periods. Optionally, for each company code, the user can specify by each type of account (A-assets; D-customers; K-vendors; S-G/L accounts) a range of accounts and two ranges of open posting periods. For example, the user could keep one range of posting periods open for the new period and a second range open for adjustment periods in the previous fiscal year.
II. Posting inventory movements in previous period
To post inventory movements in the previous period:
- Menu Path: Logistics – Materials Management – Material Master – Other – Allow Posting to Previous Period
- T-Code: MMRV
III. Posting inventory movements in previous period
To prevent posting of vendor invoices and inventory movements in the closed period and permit posting of invoices in the new period:
- Menu Path: Logistics – Materials Management – Material Master – Other – Close Period
- T-Code: MMPV
IV. Intercompany exchange rates for a new period
To enter the new intercompany exchange rates with a validity date from the beginning of the new period:
- Menu Path: Treasury Management – Basic Functions – Market Data Management – Manual Market Data Entry – Currency
- T-Code: OB08
V. Posting Adjustments
To post an adjustment (a closing entry), post a G/L transaction like any other. Debit one G/L account and credit another.
- Menu Path: Financial Accounting – General Ledger – Document Entry – General Posting
- T-Code: F-02
VI. Posting an Accrual for Automatic Reversal
At the end of the period, one can post an accrual for automatic reversal in the next period. To post an accrual for automatic reversal:
- Menu Path: Financial Accounting – General Ledger – Periodic Processing – Closing – Valuate
- T-Code: FBS1
VII. Reporting Adjustments by Posting Date
Since both the previous posting period (for posting adjustments and accruals) and the new posting period (for posting customer invoices and payments) are open at the same time, it is possible that someone makes a mistake and posts an adjustment or accrual to the new posting period. In this case, one has to reverse the transaction and post it to the proper posting date and posting period.
To make sure that all adjustments were posted to the proper date (in the previous period), the user can report all adjustments (by one or more “document types”) by the posting dates as follows:
- Menu Path: Financial Accounting – General Ledger – Information System – General Ledger Reports – Document – General – Compact Document Journal
- T-Code: S_ALR_87012289
The user would scan the Report and make sure that the posting date of all adjustments and accruals was in the prior period. If any were posted to the new period by mistake, print the report, reverse the transaction by the number, and then post the transaction again with the proper posting date.
VIII. Closing the Previous Posting Period
To close the previous posting period:
- Menu Path: Financial Accounting – General Ledger – Environment – Current Settings – Open and Close Posting Periods
- T-Code: OB52 / S_ALR_87003642
The G/L account balances, customer account balances and vendor account balances are automatically carried forward to the next period. Only at the end of the fiscal year, the user has to run programs to carry forward account balances to the next fiscal year.
IX. Closing the Year & Carrying Forward Balances
SAP Modules such as AA (Asset Accounting) and MM (inventory management & purchasing) have specific procedures and programs required to close the fiscal year. In FI, at the end of the fiscal year, the user needs to run two programs to carry forward the balances to the next fiscal year. One program carries forward the G/L account balances while the other program carries forward the customer and vendor account balances.
When running any carryforward program, the user should make sure that nobody is posting any entries to accounts. Also, the user has to run the carryforward program in the new year. After running the carryforward program, when a transaction is posted to the previous year, the account balances in the current year are immediately updated.
To carry forward the G/L account balances to the next fiscal year:
- Menu Path: Financial Accounting – General Ledger – Periodic Processing – Closing – Carrying Forward – Balance Carry Forward
- T-Code: F.16
To carry forward the customer & vendor account balances to the next fiscal year:
- Menu Path: Financial Accounting – Accounts Receivable/Accounts Payable – Periodic Processing – Closing – Carrying Forward – Balance Carry Forward
- T-Code: F.07
X. Revaluing Open Items & G/L Account Balances
One possible revaluation procedure using SAP is as follows:
- At the end of the month or period, enter the intercompany exchange rates and the final day of the previous period as a validity date. The purpose is to revalue the previous period’s balances with the new exchange rate.
- At the beginning of the next period, after closing the period but before preparing or transmitting P&L and closing balance sheet, run the program to revalue open items into both local currency and into group currency. The revaluation method has to be properly configured according to local requirements and the organisation’s financial policy. Enter the last day of the previous period as the Balance Sheet Key date, depending on the fiscal year. Mark Postings Requested. Enter the posting date as the first of the month of the new period and reversal date as first of the next month.
The program then calculates and posts at least four separate transactions. The first two transactions record the revaluation of the open items into local currency and then reverse this revaluation. The second two transactions record the revaluation of the open items into group currency and then reverse this revaluation.
- At the beginning of the next period, after closing the period, run the program to revalue G/L account balances. This program revalues both account balances kept in local currency, such as prepayments and accruals, and account balances kept in foreign currency, such as bank accounts in foreign currency. Enter the revaluation method for both the company code currency and the group currency. Enter a key date of the last day of the previous period.
If the account is kept in local currency, such as prepayments and expense accruals in local currency, the program calculates and then posts in group currency if the group currency value has been changed, thereby offsetting these entries with the configured accounts for currency gains and losses.
Separately, if the account is kept in foreign currency, the program calculates and then posts each account in local currency and group currency, thereby offsetting these entries with the configured accounts for currency gains and losses.
- When one closes open items, for example, when A/R posts a cash receipt and closes one or more customer invoices, then the program automatically calculates and posts the realized exchange gains or losses to the configured accounts – in both local currency and group currency. If both the invoice and the payment were in local currency, the program posts no exchange gain or loss in local currency, but does calculate and post an exchange gain or loss in group currency. This procedure requires a complete, error-free configuration.
To revalue open items, most of all customer invoices, vendor invoices and intercompany receivables and payables:
- Menu Path: Financial Accounting – General Ledger – Periodic Processing – Closing – Valuate – Foreign Currency Valuation
- T-Code: F.05
- Steps for the Closing Process in FI
Step # | Module | Frequency | T-Code | Description | Comments |
1 | FI | Month-endFirst day of the following month | OB52 | Open FI Period | Accounting entry possible in current period as well as the last period |
2 | MM | Month-endEvening of last day of the month | MMPV | Close MM Period | MM transactions possible in next period and not in previous period |
3 | FI | Month-end | F.05 | Foreign Currency Valuation | Revaluation of Open Items for GL,AP,AR, GR/IR |
4 | FI | Month-end | F.81 | Reverse Accruals | Post reversal of prior period accruals |
5 | FI | Month-end | FBS1 | Enter accrual documents | Posting accruals for current period |
6 | FI | Month-end | F.14 | Create posting documents from recurring documents | Post all the recurring entries for the month |
7 | FI | Month-end | FB50 | Post monthly entries | Use Account Assignment template for items |
8 | FI | Month-end | F-04 | Post with Clearing | Post & Clear I/C & THP incoming & outgoing payments |
9 | FI | Month-end | F.13 | Automatic Clearing | Match & Clear open items of Customers & Vendors |
10 | FI | Weekly | F.19 | GR/IR Clearing | Analyse GR/IR Clearing Account and generate adjustment postings. |
11 | MM | Weekly | MB5S | List of GR/IR balances | Review GR balances with no invoice balances |
12 | FI | Month-end | FB70 | Customer Invoice | Invoicing of non-trading business to affiliates |
13 | FI | Month-end | F.2E | Reconciliation of Receivables/Payables for affiliates | Reconcile balances of affiliate companies |
14 | PP | Daily | COGI | Automatic Goods Receipts – error handling | Analyse any goods movement errors related to Production Orders |
15 | MM | Month-end | MB5L | List of Stock Values : Balances | Reconciliation of Inventory – MM/FI |
16 | SD | Weekly | VF04 | Process Billing Due List | This confirms that all shipped documents have been billed |
17 | SD | Daily | V.21 | Log of collective run | Review error log from the daily billing due list |
18 | SD | Weekly | VFX3 | Release billing documents for accounting | Reconciles billing documents not passed to accounting |
19 | FI | Month-end | S_P99_41000101 | Check Register | Identify the total of all payments for the month in the Check Register |
20 | FI | Month-end | FBL3N | G/L Account Line Item display – Bank Reconciliation | Identify the total of all payments transactions posted to the bank account & reconcile with the Check Register |
21 | CO | Month-end | KO88 | Actual settlement: Order | Settle Internal Orders as Asset Under Construction |
22 | AA | Month-end | AFAB | Fixed Asset Depreciation Run | Asset Depreciation posting in Asset subledger |
23 | AA | Month-end | ABST2 | Reconciliation between FI-AA & FI-GL | Review list of Accounts showing differences |
24 | AA | Year-end | AJRW | Asset Fiscal year change | Posting can be done only in the new fiscal year |
25 | FI | Weekly | FBL5N | Customer line item display | Identify the A/R subledger balances |
26 | FI | Weekly | FS10N | G/L Account balance display | Identify balances of all A/R reconciliation accounts and ensure it ties up with the total A/R subledger balances |
27 | FI | Weekly | FBL1N | Vendor line item display | Identify the A/P subledger balances |
28 | FI | Weekly | FS10N | G/L Account balance display | Identify balances of all A/P reconciliation accounts and ensure it ties up with the total A/P subledger balances |
29 | FI | Month-end | OB52 | Close FI Period | Disallow FI posting to previous period |
30 | FI | Year-end | F.07 | Carry Forward Receivables/Payables | Carry forward of Customer & Vendor balances in the next fiscal year |
31 | FI | Year-end | F.16 | Balance Carry Forward | Carry forward of Balance Sheet account balances in the next fiscal year |
32 | FI | Year-end | OBH2 | Copy Document Number Range to next Fiscal Year | Re-initialize document numbers for the next Fiscal year |
- Steps for the Closing Process in CO
Step # | Module | Frequency | T-Code | Description | Comments |
1 | CO | Month-endFirst day of the following month | OKP1 | Open CO Period | Unlock next period for actual CO transactions |
2 | CO-PC | Month-end | KGI2 (I)CO43 (C) | Actual Overhead Calculation | Apply Cost Center overhead to Production Order |
3 | CO-PC | Month-end | KKAV (I)KKAO (C) | Work in Process Calculation | Computation of WIP amount for FI |
4 | CO-PC | Weekly | KKS2 (I)KKS1 (C) | Variance Calculation | Calculation of Production Variance for Production Orders |
5 | MM | Month-end | MMRV | Allow MM postings to previous period | Enables WIP & Production Variances to be closed to the closing period |
6 | CO-PC | Month-end | KO88 (I)CO88 (C) | Actual Settlement of Production Order | Settlement of WIP & Production Order Variances to FI |
7 | CO-PC | Month-end | VA88 | Actual Settlement of Sales Order | Repair/Retip valuated Sales Order settlement |
8 | MM | Month-end | MMRV | Allow MM postings to previous period | Disallow postings to previous MM period |
9 | CO-IO | Month-end | KO88 (I)KO8G (C) | Internal Order Settlement | Settlement of Internal Order to PA/PCA |
10 | CO-CCA | Month-end | KSU5 | Cost Center allocation | Assessment between Cost Centers |
11 | CO-PA | Month-end | KEU5 | Cost Center assessment | Assessment of Cost Centers to PA |
12 | CO-PCA | Month-end | 3KE5 | Actual PCA Assessment | Assessment of PCA |
13 | CO-PCA | Month-end | 4KE5 | Actual PCA Distribution | Distribution of PCA |
14 | CO | Month-endEvening of last day of the month | OKP1 | Change period lock | Lock current period for actual CO transactions |
Also See: What are the Month End Closing Activities in Finance