Financial Analyst / Senior Accountant
Print Media Advertising Agency
Total years of experience :7 years, 6 Months
Achievements/Tasks
Financial Reporting and Analysis:
- Utilise Excel pivots and formulas for the preparation and analysis of financial statements, presenting findings to support decision-making.
- Automate report generation processes to enhance efficiency.
- Ensure compliance with accounting principles and regulatory requirements.
- Identify areas for process improvement and cost efficiencies.
Month/Year-End Closing:
- Lead month-end and year-end close processes.
- Reconcile accounts and resolve discrepancies in a timely manner.
Accounts Receivable Management:
- Supervise the accounts receivable process, including invoicing and collections.
- Monitor aging reports and implement strategies to reduce outstanding receivables.
- Collaborate with sales and customer service teams to resolve billing discrepancies.
Accounts Payable Management:
- Lead the accounts payable function, overseeing the full cycle from invoice receipt to payment.
- Coordinate with vendors to address inquiries, negotiate terms, and optimise payment schedules.
Payroll Processing:
- Manage end-to-end payroll processing, including timekeeping, deductions, and compliance.
- Collaborate with HR to address payroll-related employee inquiries.
Budgeting and Forecasting:
- Collaborate with cross-functional teams to gather financial data and insights for the development of accurate and comprehensive budgets and forecasts.
- Conduct thorough analysis of historical financial performance and market trends to inform realistic budget projections.
Tax Calculation and Submission:
- Prepare and submit business income tax returns and payroll tax for individuals to the tax authorities, adhering to strict deadlines.
- Stay updated on changes in tax laws to accurately apply adjustments and deductions during the tax calculation process.
- Collaborate with internal teams to gather the necessary financial data and documentation for precise tax assessments.
Achievements/Tasks
- Reduced the operational expenses by 20% in my first year.
- Successfully migrated and implemented financial data for various companies into XERO Accounting and CLIMAX Shipping Accounting.
- Compiled data from the accounting team to create a master spreadsheet and developed a shipping company`s financial statements model on Microsoft Excel, using the master spreadsheet to produce B.S., P&L, Cash flow statements, customer and vendor ledgers, and other management reports.
- Examined CLIMAX-generated financial reports, e.g., GL, P&L, B.S., customer, and vendor balances, and synchronised them with the help of the CLIMAX IT Team.
- Audited the financial statements and reports of subsidiary companies and made sure all calculations and data entries were correct and in accordance with IAS/IFRS.
- Performed monthly stock audit and reported discrepancies to the HOD.
Accounts Receivable and Payable Management on Xero and Climax: Approved payable vouchers, processed vendors’ payments, issued invoices, followed up on payments, and reconciled all accounts.
- Tax Management: Prepared and submitted monthly payroll tax and income tax withheld from vendors on the FBR Portal.
- Developed a sales commission model on Microsoft Excel to reduce 4 days’ manual work and ensure error-free payroll disbursement to employees.
- Worked as a single point of contact for over 800 sales employees, answering all their commission-related requests and queries in a timely manner.
- Developed the Provident Fund Model on Microsoft Excel to be able to extract an employee-wise detailed report by entering an employee's unique ID only.
- Created standardised check printing formats for various bank accounts to facilitate the printing of checks in bulk together.
- Prepared Standard Operating Procedures for procurement, accounts payable, petty cash, and employee final settlements.
- Payroll Management: Managed the payroll activities such as obtaining data from HR and finalising monthly payroll, processing full and final settlements, obtaining data from SBT Japan, and preparing monthly sales commissions for agents for all groups with multiple criteria.
- In-house management of all employees' pension funds
- EOBI (Employees' Old-age Benefits Institution) Management: Registration and deletion of employees on the EOBI Portal, keeping up-to-date records of employees, and processing payments within the due date
- Health Insurance Management: Coordination with health and life insurance companies for employee registration and facilitation and in-time processing of staff health claims
- Prepared a systematic monthly budget sheet on Microsoft Excel based on past trends and future expected cash flows with the help of multiple departments and imported it to XERO to see year-to-date live results.
- Prepared customised financial and management reports on XERO for the management for a better understanding of the business operations and business position.
- Constructed a report on multiple IT-based projects cost and revenue along with various insights.
- Expected unfavourable events through the analysis of data and recommended control strategies.
- Managed cash flows and supervised financial transactions within and outside the company.
- Managed the entire procurement process and developed and implemented successful sourcing and procurement strategies. Foresaw alterations in the comparative negotiating ability of suppliers.
Personal Achievements
- Award - Unsung Hero - Running the show and never in the spotlight 2020
- Letter of Thanks & Appreciation to my Spouse 2019
- Award - The Surprise Factor - Outstanding Performance 2018
Achievements/Tasks
- Maintained the database by entering new and updated customer and account information and extracting reports using the billing and Invoicing Modules in SAP and Oracle as an end user.
- Extracted and compiled consumer data for analysis using SAP’s associated software (BEX analyzer and QlikView).
- Helped set Financial and Non-Financial KPIs for each Integrated Business Centre (IBC) and monitor actual performance against KPIs.
- Performed the variance analysis of actual performance compared to last year on a monthly basis.
- Obtained data from IT and maintained the master file to prepare multiple management reports.
- Coordinated with different departments to get Non-Financial KPI data.
- Ensured scores against KPIs.
- Prepared a presentation of incentive results for all clusters of KE.
- Prepared a forecast, updated it on a weekly basis, and compared it with the budget.
- Forecasted day-wise, month-wise, and branch-wise revenue and recovery.
- Reviewed, processed, and reported disputed billing cases.
Finance, Audit and Taxation
Accounts, Audit and Taxation
URL removed due to policy violation. Please contact support for further information.