November 2009

SAP FICO Year End Procedures

06 November 2009 |

Posted by Santosh Puthran

We are approaching the year end. And those of you who are new to SAP year end procedure for FICO, I am listing the transactions or procedures you need to follow. This is an indicative list and you can tailor the year end procedures as per the requirements of your company or client.

This is also one of the interview questions for SAP FICO Consultants.

1. Pre-Year End/House Keeping - Actioned before Year End

1.a Confirm that balance carried forward account exists - Txn OB53
1.b Review Customer/ Vendor number ranges: Txn XDN1 for AR and XKN1 for AP
1.c Review Document number ranges for AP/AR/GL: Txn FBN1
1.d Review Document number ranges for Assets: Txn AS08
1.e Review Document number ranges for EC-PCA: Txn GB02
1.f Review Document number ranges for CCA: Txn KANK
1.g Review All program variants and variant variables: Txn SE16 and review table VARIT for Z* programs and other scheduled jobs
1.h Factory Calendar: Txn SCAL
1.i Open Periods Txn OB52
1.j Create Fiscal Year Variants 5 years ahead - GL Txn OB29
1.k Create Fiscal Year Variants 5 years ahead - Txn OA85
1.m Create Next Plan Year in CO - Txn OKEV
1.n Create Next Plan Year in PCA - Txn OKEQ
1.o Add new Activitiy Rates that will be required for the new period / year : Txn KP26 / KP97
1.p Add new Statistical key figures that will be required for new period / year Txn KP46 / KP97
1.q Check last closed fiscal year in FI and FI-AA Txn TBP
1.r Check customising using report RACHECKO
1.s Check Incomplete Assets using Report RAUNVA00
1.t Open MM period on the first day of the year MMPV

2. Period End Processing : Regular Month End Procedures

3. Mandatory Year End Processing: For Fiscal Year Change

3.a General Ledger Txn F.16
3.b Accounts Receivable Txn F.07
3.c Accounts Payable Txn F.07
3.d Fixed Assets

- Process depreciation in usual way
- Reconcile Asset Ledger with GL - Start Report RAABST02 to note the differences. Check the missing items using program RAABST01
- Execute Fiscal Year change Txn AJRW
- Execute Year End Closing program - Txn AJAB

3.e CO - Budget Carry Forward -

Copy Plan to Plan - Txn KP97
Copy Actual to Plan - Txn KP98
Copy Resource Prices - Txn KP9R

4. Financial Month End Reports

4.a General Ledger Reports - Txn FS10n
4.b General Ledger Line Items Display Txn FBL3n
4.c General Ledger Account Balances Report Txn S_ALR_87012277
4.d Structured GL Account Balances Txn S_ALR_87012279
4.e Trial Balance
4.f Financial Statements

Menu Path Accounting - Financial Accounting - General Ledger - Information System - General Ledger Reports - Balance Sheet Profit and Loss Statement - General

4.g Document Journal Txn S_ALR_87012287
4.h Compact Document Journal Txn S_ALR_87012289
4.i Document Listing - Txn SE38 Program RFBUEB00
4.j Extract for the Accumalated Historical Balance Audit Trail Txn S_ALR_87012314
4.k Report from the Accumalated Historial Balance Audit Trail Txn S_ALR_87012315
4.l Identification of Postings by Amount Txn S_ALR_87012282

5. Auditing Reports

5.a Financial Accounting Comparative Analysis F.03
5.b Gaps in Document Number Range Assignment Txn S_ALR_87012342
5.c Invoice Number Ranges Allocated Twice Txn S_ALR_87012341
5.d Changes to GL Accounts Txn S_ALR_87012308
5.e Changes to Customer Accounts Txn S_ALR_87012182
5.f Changes to Customer Credit Data Txn S_ALR_87012215

Further Reading:

Do you like to be updated in Accountancy ?

Click here to get updates by Email in your inbox

Or

Subscribe in a reader

or Follow me on Twitter

You may also like to read

Operating and Financial Review - OFR

04 November 2009 |

Posted by Santosh Puthran

Non financial information in the form of additional reporting provides alongside the financial information in the annual report, provides a good insight to the stakeholders on the company.

In January 2008 the ASB issued a press notice reminding UK quoted companies of the need to follow the enhanced business review reporting requirements in the Companies Act 2006. The ASB believes its Reporting Statement on the OFR includes all of the new Companies Act 2006 requirements and that this statement continues to provide applicable best practice guidance for UK companies.

The Reporting Statement involves:

The specification of a number of principles for directors to apply when preparing an OFR; and the provision of recommended key elements of a disclosure framework to apply in an OFR.
The principles in particular make clear that the OFR should reflect the directors' view of the business. The objective is to assist members of the company (the current shareholders) to assess the strategies adopted by the entity and the potential for those strategies to succeed. While the OFR should focus on matters that are relevant to members, the information in the review will also be useful to other users.
The Reporting Statement sets out a framework of the main elements that should be disclosed in an OFR, leaving it to directors to consider how best to structure their review, in the light of the particular circumstances of the entity. It contains recommendations on the disclosures that should be made in respect of any Key Performance Indicators (KPIs) included in an OFR, but it does not specify any particular KPIs that entities should disclose, nor how many, on the grounds that this is a matter for directors to decide.

Case Study: This Business Review analyses the performance of the Tesco Group in the financial year ended 28 February 2009. It also explains other aspects of the Group’s markets, results and operations, including strategy and risk management.

Long Term Strategy: The rationale for the strategy is to broaden the scope of the business to enable it to deliver strong, sustainable long-term growth by following the customer into large expanding markets at home – such as financial services, non-food and telecoms – and new markets abroad, initially in Central Europe and Asia, and more recently in the United States.
International: "How do you run successful business in so many countries ?" We’ve long understood that retailing is local. Each team on the ground is able to adjust our offer to each market because customers in China, for example, aren’t the same as those in Poland or South Korea,
Core UK: "Is every little helps still important ? " Making many small improvements in everything we do is what ‘Every Little Helps’ is about, because when we all work together on the little things, it amounts to a great deal. It’s more important today than it’s ever been – it keeps us focused on what matters most to customers.
Non Food: It’s been a challenging year for non-food as consumers around the globe have been hit by the economic downturn and are cutting back on non-essential purchases – but by keeping our prices low, improving our offer in key categories like electricals and clothing and giving customers more choice about how they shop, such as through Tesco Direct – we have outperformed the market.
Community and Environment: All communities have their own individual concerns and priorities and so each of our countries has its own Community Plan. Whilst the goals and targets are tailored specifically to each country, each plan is underpinned by five core promises: actively supporting local communities; buying and selling our products responsibly; caring for the environment; giving customers healthy choices; and creating good jobs and careers.
People and Customers: As a Group, we’re still investing hard and growing through the downturn, with sales growing by 15% last year. To handle that growth well, we need to bring skilled, experienced people through all the time to fill the thousands of jobs it creates. Take Fresh and Easy where our team has grown from 65 to over 2,500 in less than two years. Hundreds more will join us this year, so we can’t rely on bringing people in from other parts of the business. We need to develop our own talent locally and equip our people with the skills they need to be able to do the job and lead others. That’s why we’re absolutely committed to putting the best training plans in place making sure that all of our people have the opportunity to get on in the business.
Key Performance Indicators: We operate a balanced scorecard approach to managing the business that is known internally within the Group as our ‘Steering Wheel’. This unites the Group’s resources and in particular focuses the efforts of our staff around our customers, people, operations, finance and the community. Its prime focus is as a management tool for the company so that there is appropriate balance in the trade-offs that need to be made all the time between the main levers of management – such as operations measures, financial measures or delivery of customer metrics.
Risk and Uncertainties: To ensure the Group continues to pursue the right strategy, the Board discusses strategic issues at every Board meeting, and dedicates two full days a year to reviewing the Group’s strategy. The Executive Committee also holds specific sessions to discuss strategy on a regular basis. We have structured programmes for engaging with all our stakeholders including customers, employees, investors, suppliers, government, media and non-governmental organisations.