Beschreibung
Role: For a client project we are looking for a SAP FI Consultant wiht good know how in Asset Accounting.
Context:
The client has been using two separate systems for the management of Fixed Assets: SAP for the calculation of book values (US-GAAP), and Bloomberg BNA Fixed Assets to calculate tax valuations.
The desire has been expressed to:
Simplify processes by elimination of manual double-entry
Reduce or eliminate the effort of reconciliation of multiple systems
Reduce cost coming from the use of two separate systems.
The scope of work includes the migration of all tax valuations from the BNA Fixed Assets system to SAP
The fixed asset solution needs to deliver accurate values for the following six different valuations:
US-GAAP (Book)
Federal Tax (MACRS)
AMT
ACE
Calculation w/o bonus depreciation
State depreciation for New York and California.
The fixed asset solution needs to be able to deliver reports for income tax and property tax:
Income tax: For all six valuations listed above, which means, under consideration of the location (state) of the assets for the calculation of state level depreciation (NY and CA)
Property tax: Original acquisition values (US-GAAP), by exact location (street address), considering that in many cases assets are placed with customers.
Role and responsibilities:
As the Asset Functional consultant on this project, you will perform the following activities during the phases of the project:
1. Analysis of situation
Review the project approach for a mid-year conversion
Review of existing configuration
Review of data stored in SAP vs. BNA
Analyze how assets are stored in the system that came in during acquisition of other companies (assets from mass creation)
Confirmation of timeline and release schedule with IT
2. Design of future solution
Design on how to derive and store location information
Identify the required depreciation keys
Identify and design the required asset classes and default values for depreciation (defaults for new assets)
Design the conversion approach for a mid-year conversion
3. Configuration of future solution
Configuring all tax depreciation rules (depreciation keys, period controls, default values)
Preparing new data import file:
Preparing old data export from SAP
Preparing old data export from BNA
Merging of data from SAP with data from BNA
Adding location information to export data
Configuring SAP data conversion settings
Developing the data import into SAP using LSMW
Unit testing
Knowledge transfer on system changes to business and IT
4. Testing
Test extract
Test data merge
Test re-load
Test-setup of existing Assets under Construction
Reconciliation of loaded data:
• Assisting the business team with the Financial reconciliation between SAP new and old, SAP new and BNA, SAP new and GL
• Technical/logical reconciliation such as record counts, check sums
Depreciation simulation and forecast
Transactional tests on loaded data
5. Cutover
Develop cutover plan
Test cutover in QA system
Reconciliation in QA system
Production cutover
Re-creation of Assets under Construction
Reconciliation in Production system