Accounting Analyst (Fixed-term 1 year)

CocaCola

Job Description Summary: 

Job Summary:

Managing all activities being in scope of Accounts Payable in addition to handling the purchase price variance account (Actual, RE, BP) for P&L reporting as well as supporting some Treasury and Accounts receivable activities that are not handled by our shared services by working cross-functionally to improve efficiency and productivity and meet relevant deadlines and support month end close.

Support Transformations of the Accounts Payable function to operate in a best-in-class environment, utilizing automation and process improvement

Handling related general ledger accounts analysis and maintaining accounts reconciled and accurate aging reports (GRIR, Blocked and parked invoices, vendor with debit balances … etc.) and ensure adherence to company policies and procedures

Maintain sold relationships by providing the needed support to both external vendors/internal to resolve issues in a timely manner and drive improvements in Finance related KBIs.

KEY DUTIES/RESPONSIBILITIES:

Accounts payable 

Codify and process Plant’s non- PO payables: Freight, customs, Capex, OPEX, etc.

Ensure that each payment complies with all requirements.

Review open PO reports and follow up with the owners to close or keep the PO.

Review, coordinate, and follow-up purchase orders/receipts status to ensure timely payments.

Receive, investigate, and solve issues resulting from phones calls, statements of accounts and letters requesting payment of due amounts in coordination with AP team to ensure meeting company AP matrices.

Review and follow-up vendors’ statement of accounts where needed especially for the main local vendors.

Prepare and review the analysis for general ledger accounts (prepayment to vendors, GRIR, blocked and parked invoices, vendor with debit balance, vendor statements …etc.) and determine the proper accounting action to follow clearing accounts, insurance claims, down payments, etc. 

Follow-up Plant’s transactions to keep books accurate and to achieve AP matrices in coordination with AP operation team.

Ensure all transactions have adequate supporting documents and are approved according to the LCOA.

Prepare, follow up and communicate AP reports / matrices to stakeholders (payment on time, GRIR, blocked & parked invoices).

Issue local bank checks and keeping a check register for local banks payments.

Submit the einvoice on the ETA portal as needed.

Treasury

Managing bank reconciliations for ADIB- Credit Agricole banks and related transactions recording including (sending reconciliations to GFO team & uploading our bank statement on our new tool throw SAP Fiori & SAP 4/HANA)

Support corporate Treasury managing excess EGP balances in the On-Shore banks accounts by helping them to transfer the excess EGP as part of our profit for location 1612

Handling local banks requirements and documentation (LGs + create our RFAs for annual renewal + cash against documents) and record necessary entries to avoid any duplicate payments

Purchase Price Vraiance (PPV) 

Mange the PPV GL account and check any unreal or unexpected amounts & do any needed reallocation any to correct accounts (non-MRB amounts …etc.)

Update any price & fright change and reallocate Air freight to the correct accounts

Prepare and submit the needed data for PPV P&L reporting (RE, flash RE & BP).

Provide narratives for actual Vs RE/ BP main drives.

Accounts receivable

Responsible for billing of our stock transfer orders between our plant and other plants and needed JVs if any

Responsible for any reallocation’s JVs for our credit notes/ debit note handled locally   

Record cash collections received in our local banks if any   

Coordinate with our GFO team any customers requirements locally & review balances’ confirmations for our customers as needed 

Follow up on a monthly basis with the customer service team and SAP to make sure that all sales invoices are recorder on Edicom / ETA on timely basis.

Vendor Master file 

Communications with the related parties of the data required by the company to open a new vendor.

Verification of documents received from the vendor including verification of withholding tax data for the vendors.

Getting approval from the Finance Manager for vendor creation.

Raising MDM requests for Egypt CPS vendors’ creation, extension, and amendment after approval from the Finance Manager

Prepare analysis to update our exception list twice per year for vendors with payment over $150K annual payments

Withholding tax 

Preparation and Submission of Quarterly Withholding Tax Declaration (form 41).

Point of contact for tax authorities, Responds to Tax authorities’ requests on a quarterly, annually and ad-hoc requests.

Ensure the company has the required documents to support the withholding tax deductions or exemption on annual basis.

Other Responsibilities 

Preparing month end closing activities including journal vouchers submission.

Comply with company policies and procedures.

Update the Sox narratives related to the source to pay as needed.

Support our travel team with employee expenses if needed

Prepare form 230 once a year

Support our travel team with issuing AMEX card for the new employees

Provide support to the company external auditors.

Offer assistance and orientation to other associates as requested.

Provide information and prepare reports as required to comply with governmental requirements, Free Zone regulations and Company requests.

Maintain an effective communication with associates from other units and external persons to coordinate and execute functions related to Finance area.

Participate in the development and/or modification of procedures and systems to improve the performance in the working area.

Bachelor of commerce degree or equivalent

3+ years of varied experience in a similar sized multinational organization in Finance, covering areas like General Accounting, Accounts Payable, withholding tax and Financial Reporting.