GL Planning/Budgeting
Purpose
In this Document we will capture GL Planning/ Budgeting Process, Scenarios and requirement of an Organization.
This component is used to handle GL accounting transactions that you can Prepare Future forecast, Allocation in a Particular Department.
You can use the planning function in General Ledger accounting to enter and distribute plan data to create budgets, forecasts, and other reports.
You can quickly and easily enter large amounts of plan data. You have the following options for plan data entry:
- You can enter amounts as plan totals that are (automatically or manually) distributed to the planning periods.
- You can enter amounts as period amounts that are automatically totaled.
- You can enter a combination of both totals and period amounts.
Features
Planning in General Ledger Accounting comprises the following functions:
- You can perform planning locally. When setting up planning, you provide a framework for the individual planners and assign authorizations. You can also adapt the entry screen layout.
- For balance sheet accounts, you can choose between planning balance sheet change values or balance sheet values.
- For each fiscal year, you can post plan data to multiple versions.
- You can compare actual and plan data
- You can display totals records of your plan data.
- You can display individual plan documents.
- You can use allocations to allocate/distribute plan data
Planning
Planning is generally part of controlling. However, we can plan for the general ledger accounts in finance module of sap. This can be done to prepare the variance analysis within financial accounting.
Cost Center Planning
The planning application “cost center planning” enables the planning of the necessary budget of cost centers in the organizational structure of your company. You identify and value the relevant cost drivers, define manually entered prices (also called “political prices”) for the internal activity allocation and enter primary and secondary costs.
Cost center planning involves entering plan figures for costs, activities, prices or statistical key figures for a particular cost center and a particular planning period. You can then determine the variances from these figures when you come to compare these plan values with the costs actually incurred. These variances (see: Variance Calculation) serve as a signal to make the necessary changes to your business processes.
Cost center planning forms part of the overall business planning process, and is a prerequisite for standard costing. The main characteristic of standard costing is that values and quantities are planned for specified time frames, independently of the actual values from previous periods.
Prerequisites
You have to activate the delivered planning application. For more information
Process Flow
The general process flow of cost center planning covers the following steps:
- Preparation: Planning cost drivers for externally related activities and the manually entered prices for internal activity allocation
- Planning of primary costs
- Planning of secondary costs
- Analysis of results in the SAP Business Information Warehouse
- Optional: Returning the plan data into the operational Cost Center Accounting of the R/3 System
Profit center Planning
Profit center planning forms is a part of corporate planning. For this reason, planning integration and reconciliation are particularly important.
Planning is a combination of top-down/bottom-up planning on several aggregation levels. The different roles of the persons involved in the planning process are reproduced with the help of various Planning Profiles, which enable a role-specific view of the existing planning objects.
Process Flow
Process Flow
The persons responsible for planning for their respective company call up their planning folder and plan revenue cost of sales, working capital, investments, and depreciation corresponding to the sequence suggested in the planning folder.
Master Data
The following profit center master data is maintained in the central master data maintenance system and distributed from there to the local systems:
- Profit centers
- Profit center groups
- Account groups
Planning Program Update
Description: |
Planning tables Update |
Transaction Code: |
GLPLINSTALL |
Menu Path: |
|
Client dependent settings: |
Yes / No |
Cost Center Planning
Define versions
Description: |
Define versions |
Transaction Code: |
SPRO |
Menu Path: |
|
Client dependent settings: |
Yes / No |
Maintain fiscal Year -Select Version “0” and double Click on Settings for Each Fiscal Year .
Define Defined Planner Profiles
You use planner profiles to control the way planning is carried out. In a planner profile, you specify per planning area which planning layout is to be used with which default values. Per planning area, you can create as many planning layouts as you require. The profile item determines the order of the planning layouts within a planning area and can be used to assign the same planning layout to a planner profile in multiple areas, but with a different default setting each time.
Description: |
Define Planner Profile |
Transaction Code: |
GLPLADM |
Menu Path: |
|
Client dependent settings: |
Yes / No |
Define Plan Versions
In this activity you can maintain plan versions for each ledger. For each fiscal year, you can post plan data to an unlimited number of versions.
Description: |
Define Plan version |
Transaction Code: |
GLPV |
Menu Path: |
|
Client dependent settings: |
Yes / No |
Assign Fiscal Year to Version
In this activity, you can specify fiscal-year-dependent parameters for the plan versions of your ledgers. In so doing, you assign the desired fiscal year and posting period to your plan versions and activate them. You can also lock a plan version.
Description: |
Define Plan version |
Transaction Code: |
GLPV |
Menu Path: |
|
Client dependent settings: |
Yes / No |
Define Plan Period
In this activity you can determine the posting periods allowed for entering planning data. You can create permitted posting periods in the form of variants, which can then be assigned to company codes.
Description: |
Define Plan version |
Transaction Code: |
GCP5 |
Menu Path: |
|
Client dependent settings: |
Yes / No |
Define Number Ranges for Plan Documents
In this IMG activity, you define the number range for your planning documents in General Ledger Accounting. You specify the following number range details for each company code:
- A number interval from which the document numbers are to be chosen
- The type of number assignment (internal or external)
Activate Line Items for Planning
In this activity you determine in the planning if summaries as well as plan line items are to be written.
Description: |
Define Plan version |
Transaction Code: |
GLPV |
Menu Path: |
|
Client dependent settings: |
Yes / No |
And execute to update
User-Defined Planning Layouts
To be able to plan for cost elements, you first need to define the planning layout. In the planning layout, you specify the format of the planning screens.
Description: |
User-Defined Planning Layouts |
Transaction Code: |
SPRO |
Menu Path: |
|
Client dependent settings: |
Yes / No |
Planning data
Transaction GP12N
Display Plan Data F.01
Here Plan Version “0” used for display Plan data
Great documment! More than 300 views and no-one tell nothing!
Well, I did!
Excellent post.
Please if u have more information about "cash flow", tell me.
Regards,
Oswald
Thanks Oswald,
Please find link for cash flow, i hope it would be helpful..
https://help.sap.com/saphelp_byd35/en/KTP/Software-Components/01200615320100003379/SAP_BBD/Print_Files/PDF_FILES/CashFlowManagement_BA_en.pdf
Regards
Raheem
Thank you very much for this link.
Dears, I am not able to open the link, could you please let me know if this is the one or share the doc ASAP, I ll be very greatful. Thanks, Lokesh
nice document .... thanks for sharing
Thanks Ansh,
Regards
Raheem
Dear Raheem,
Very useful document, it can be road map for activating planning.
Could you please let me know if there is a way to copy actual Blance sheet data to any version. Also I would like to know if we can transfer plan data of CO (KP06 & 7KE1) to Balance sheet.
Thanks,
Lokesh
Useful Info...Thanks.
Best Regards,
Naresh K.
Thanks Naresh
Regards
Raheem
This is very useful in my current project
Thanks for putting it through
Regards
Sanil Bhandari
Hi Sanil,
Thanks for appreciation
Regards
Raheem
Hi Raheem
Useful document keep sharing
thanks
Trinath
Thanks Trinath Gujari
Good document
Thanks Pavan Kumar Arvapally
Excellent Document.
Thanks Muhammad Fahad Raza
Very useful document, it can be road map for activating planning.
Thanks Lokesh Thimmappa
Good and simple documentation for easy understanding.
Thanks Shivakumar Subramani
thanks
, how can we control actual expenses that keep under plan , and if it over plan didn't save entry
BR
Hi Ahmed Ibrahim
This can be by possible by using Fund management (Public sector A/c )
thanks Raheem, for replay
BR
Hi Raheem,
Thanks for sharing this document !!
Kind Regards,
Prakash
Thanks Prakash Kumar
Hi,
Can you tell what is purpose of creating number range? I didn't see it from your document.
Also, can you share how to generate file description?
Thanks
Hai
Dear Hai Tran ,
Number range is used for planning documents for object "FAGL_PL_LC", This is require if you have activated planning in line item level.
Activate it line item Level path - MG --> Financial Accounting (New) --> General Ledger Accounting (New)>Planning-->Plan Versions--> Fiscal-Year-Dependent Version Parameters--> Activate Line Items for Planning
Regards
Raheem
Hi Raheem,
Thank you for your advise.
Previously, I can create document and I can see it from line item display with FAGLP03.
However, currently I am unable to generate planned document number even I have configured everything needed.
Can you share me your ideas?
Thanks
Hai
Hi Raheem,
Nice document...
Regards
Satya
Thanks Stya,
Very nice document it is obvious dirty trick for Small Cost Budgeting in CO instead of FM.
Wonderful work..very useful documents for FI projects
Thanks Suresh.
Hi don't you know if this works on Simple Finance?
It is not working in Simple finance, bcz these function moved to IBP.
Hi Raheem
This is a great document thanks for it. We currently use a tool outside SAP for budgeting which is uploaded to SAP annually. We are hoping to do monthly Forecasting by cost center and cost elements level.
Will this be possible using the process you have documented here ?
Thanks very much for your assistance !
Laura
Hi RAHEEM BAKSH,
Very Nice Document.
I would like to ask you one question, to perform this activity we need to activate new GL?
If this activity is possible in classical GL, could you please share the document or what are additional steps do I need to perform!
Thanks
Srini