Expert Accountant & Financial Analyst Needed
Budget: $25 – $50 USD
General Accountant/ Financial Analyst
Skills & Certifications
• General Accounting
• Analytical and Managing skills
• Expense Reporting
• Budgeting
• Financial Planning
• Public Speaking
These are my tasks completed
Journal Entry
• Reclass of IO Number, GL Account and Cost Center
CAR Cleaning/ Settlement Run
• Run transaction code GR55 to review if there is an outstanding balance for Capital Appropriation Request (CAR) internal order. Perform settlement if there is (Latina).
Sending FX Rate
• Internal control for Internal Order (IO) preparation phase where threshold are based on most updated rate based on the JNJ forex website ; download exchange rate and send to IO requestor.
Capex Breakdown
• Prepare capital expenditures (capex) breakdown and movement based on Asset History Report and send to Controller.
SOX_FIN_FA_07 - Impairment Review
• Quarterly Secure confirmation on impairment triggering event, BU performance on impairment analysis and calculation of assets to ensure that fixed assets are accurately recorded in Balance Sheet ; secure digital signature
• Completion of contact confirmation
• Send email confirmation if there was an impairment triggering event and if BU performed an impairment analysis to all assets excluding Goodwill to ensure fixed asset balances are not overstated ; extraction of data from Asset History Sheet
ITSS Spend Report
• Quarterly Prepare ITSS capital spending report and send to BU
Final Depreciation Run
• Download report from RFO on successful Depreciation Run
• Prelim depreciation run using transaction code AFBP and ASKB/ASKBN to post depreciation expense of Tangible and Intangible assets in all depreciation areas
FA: Final request - 12:00
• Complete all Fixed Asset requests (capitalization, transfer, disposal, master data changes) received for the Period before execution of depreciation run
CAPEX YTD Spend Report
• Download transaction details for General Ledger account 60909000 using FS10N C+3
Finalize FA Action Items
• Reminder: Complete all Fixed Asset requests (capitalization, transfer, disposal, master data changes) received for the Period before execution of depreciation run
• Reminder: Complete all Fixed Asset requests (capitalization, transfer, disposal, master data changes) received for the Period before execution of depreciation run
•
SOX_FIN_FA_11- FA Movement Report
• Preparation and analysis or monthly FA accounts reconciliation (Sub Ledger vs General Ledger) ; month before quarter - Period 2, 5, 8, 11
SOX_FIN_FA_06 - Master File Edit Report (MFER)
• Generate and review the Fixed Asset Master Data Edit Report for the reasonableness of the changes to the master data impacting depreciation expense (MFER)
CAPEX report to BUF
• Prepare and submit Fixed Asset Balance Report to BUF
• Reconcile capital acquisition (capex) SL vs. GL for progression reporting and send to Reporting Team
SOX_FIN_FA_04 - Capital Spend Report/CIP Monitoring Report
• Generate Capital Appropriation Request (CAR) reports and send to Business Partners to monitor spending vs. budget and confirm status of Projects to determine assets ready for capitalization
• Send follow up email to Project Owner to provide appropriate commentary/status for each of their project and perform follow thru actions
• Sent 2nd email reminder (quarterly the SOX control has to be signed)
• SOX_FIN_FA_04-Approve CIP monitoring report (Period 2, 5, 8, 11 Report)
Completion of Action Items
• Complete all Fixed Asset requests (capitalization, transfer, disposal, master data changes) received for the Period before execution of depreciation run
SOX_FIN_FA_01 - Calculation of thresholds and update of approval matrix
• Yearly The approval hierarchy levels for CAR's/FA is formally reviewed and approved via signature annually prior to Q1 close
Skills & Certifications
• General Accounting
• Analytical and Managing skills
• Expense Reporting
• Budgeting
• Financial Planning
• Public Speaking
These are my tasks completed
Journal Entry
• Reclass of IO Number, GL Account and Cost Center
CAR Cleaning/ Settlement Run
• Run transaction code GR55 to review if there is an outstanding balance for Capital Appropriation Request (CAR) internal order. Perform settlement if there is (Latina).
Sending FX Rate
• Internal control for Internal Order (IO) preparation phase where threshold are based on most updated rate based on the JNJ forex website ; download exchange rate and send to IO requestor.
Capex Breakdown
• Prepare capital expenditures (capex) breakdown and movement based on Asset History Report and send to Controller.
SOX_FIN_FA_07 - Impairment Review
• Quarterly Secure confirmation on impairment triggering event, BU performance on impairment analysis and calculation of assets to ensure that fixed assets are accurately recorded in Balance Sheet ; secure digital signature
• Completion of contact confirmation
• Send email confirmation if there was an impairment triggering event and if BU performed an impairment analysis to all assets excluding Goodwill to ensure fixed asset balances are not overstated ; extraction of data from Asset History Sheet
ITSS Spend Report
• Quarterly Prepare ITSS capital spending report and send to BU
Final Depreciation Run
• Download report from RFO on successful Depreciation Run
• Prelim depreciation run using transaction code AFBP and ASKB/ASKBN to post depreciation expense of Tangible and Intangible assets in all depreciation areas
FA: Final request - 12:00
• Complete all Fixed Asset requests (capitalization, transfer, disposal, master data changes) received for the Period before execution of depreciation run
CAPEX YTD Spend Report
• Download transaction details for General Ledger account 60909000 using FS10N C+3
Finalize FA Action Items
• Reminder: Complete all Fixed Asset requests (capitalization, transfer, disposal, master data changes) received for the Period before execution of depreciation run
• Reminder: Complete all Fixed Asset requests (capitalization, transfer, disposal, master data changes) received for the Period before execution of depreciation run
•
SOX_FIN_FA_11- FA Movement Report
• Preparation and analysis or monthly FA accounts reconciliation (Sub Ledger vs General Ledger) ; month before quarter - Period 2, 5, 8, 11
SOX_FIN_FA_06 - Master File Edit Report (MFER)
• Generate and review the Fixed Asset Master Data Edit Report for the reasonableness of the changes to the master data impacting depreciation expense (MFER)
CAPEX report to BUF
• Prepare and submit Fixed Asset Balance Report to BUF
• Reconcile capital acquisition (capex) SL vs. GL for progression reporting and send to Reporting Team
SOX_FIN_FA_04 - Capital Spend Report/CIP Monitoring Report
• Generate Capital Appropriation Request (CAR) reports and send to Business Partners to monitor spending vs. budget and confirm status of Projects to determine assets ready for capitalization
• Send follow up email to Project Owner to provide appropriate commentary/status for each of their project and perform follow thru actions
• Sent 2nd email reminder (quarterly the SOX control has to be signed)
• SOX_FIN_FA_04-Approve CIP monitoring report (Period 2, 5, 8, 11 Report)
Completion of Action Items
• Complete all Fixed Asset requests (capitalization, transfer, disposal, master data changes) received for the Period before execution of depreciation run
SOX_FIN_FA_01 - Calculation of thresholds and update of approval matrix
• Yearly The approval hierarchy levels for CAR's/FA is formally reviewed and approved via signature annually prior to Q1 close