Andy Tran

Responsibilities:
-The preparation of monthly profit and loss accounts for 4 shopping centres for review with the line manager, analysts and centre managers within the given deadlines.
-The preparation of year end centre audit packs, lead schedules and their accompanying reconciliations.
The preparation of year end centre tax packs.
-Liaising with the analysts, shopping centre managers, accounts payable, leasing and bank reconciliation departments in relation to queries.
-All of the above financial workings involved the use of complex spreadsheets using functions such as Vlookups, pivot tables and macros in conjunction with their accounting system (JD Edwards).

Responsibilities:
-The monthly preparation of management accounts and their associated reconciliations, variance analysis and commentaries for the Group entity.
-The reformatting and submission of the Group P&L figures to head office.
-The calculation and posting of accruals, prepayments, recharges and correcting journals to the General Ledger.
-The monthly preparation of overheads figures, their accompanying variance analysis and commentaries for submission to the profit centre and subsidiary teams.
-The monthly reconciliation of control accounts between the overheads and accounting systems.
-Ongoing review of procedures and controls to improve efficiency and effectiveness.
-Extensive communications with staff of all levels within internal departments and third parties in relation to query resolution, requests and process improvements.
-Quarterly balance sheet reconciliations and review.
-The reformatting and reporting of quarterly rolling forecasts and annual budgets to head office.
-The annual preparation of subsidiary statutory accounts and tax computations.
-Liaising with auditors during interim and final audits.
-Ad hoc: Cover for Accounts payable. Testing and implementation of new fixed asset register.
-Treasurer for the Sports & Social Society where I was responsible for managing the cash accounts, budget and authorising payment of society expenses.