Reporting Analyst
Bsc
Total years of experience :5 years, 8 Months
Responsible for preparing monthly reporting for the AP Team
• To follow up on Aged items, vendor aged item basically invoices that pending in the system which still Waiting for invoices to be sent to SSSCKL for payments, these items should be followed up between the range of 31- 60 days, 61- 90 days and 90 above.
• To download open items and prepare monthly tracking log for all the aged items.
• Preparation of summary ageing report for supervisor & owner review.
• To perform SRC balance sheet review analysis
• To attend to ad hoc - meeting sessions with business or vendors.
• To perform duplicate review check on posted invoices.
• Monitoring the scanning team on timely basis and to ensure invoices are scanned correctly without any rejections.
• To prepare reports for monthly, weekly and daily, (The reports are prepared for shell Philippines (SPEX), Shell Sarawak (SMEP) and Shell Australia (SDA)
• The reports are GRIR, APGL, PVOT, Debit Balances, Fringe Benefits Report and Daily RTP Performance report.
• Some of this report is required to be completed by end of the month and to be send via softcopy and hardcopy to Manila.
• This Reports Basically focuses on percentage of invoices of invoices paid on Time and it keep track on the late payments as well.
• Reviewing duplicate posted invoices and vendor master entries for SMEP team, this is ensure there is no double payment or wrong payments are made to vendors.
• Generating Fringe benefit report in quarterly basis and to be send to Philippines managers for review, this is basically to update on every stafs' expenses claim.
• Gained experience in processing FI and MM invoices.
• To update the documentation on the reports as and when changes arise.
Responsible for maintaining vendor database for AP team
• To attend to vendor queries as and when the database is not updated in the system.
• To monitor on vendor payments and handle invoice rejections if the bank account number or vendor name is not updated as per vendor's invoice.
• To conduct telecon on every Quarter with Singapore managers to ensure all KPI's is met in timely basis and to discuss on upcoming projects for Accounts Payable.
• To perform mass deletion exercise in quarterly basis for inactive vendors, this exercise is crucial exercise where by approval should be obtain from all the managers before we start deleting the vendors from the system.
• Have been an active back-up for Malaysia and Philippines Process in maintaining the Vendor Database and to attend to vendor queries.
• To prepare documentation pack as and when changes arise within the scope.