Archita Gupta

Sr. Financial Project Controller for Middle East & Africa region.

Managing end to end complex accounting & controlling for customer projects for all BGs.

Ensure support to Internal & Statutory Audits requirements and effectively & efficiently implementation of Internal Controls compliance via SOX Controls.

Project setup in system together with delivery team i.e., PM/PMO at the beginning of the project. • Preparing RRB’s (revenue recognition) templates for customer controller for each new PO received/new business received. • Month-End closing activities: preparing revenue & cost accrual deferral tracker for all AMC projects; preparing monthly journal entries & posting on the tool; preparing balance sheet schedules for unbilled revenue, deferred revenue&fines & penalties.

ERP used – QuickBooks • Working with project managers for internal audit of respective customer accounts. • Global Resource Management – Onshore + Offshore data. • Calculating gross margin on quarterly basis. • Preparing revenue reports/sales report for respective account managers. • Preparing Cash Position from P&L a/c on monthly basis. • Mapping practice wise revenue existing in the organization. • Forecast project spending and provide monthly accruals on work. • Aging reports for account managers. • Maintaining PO/SOW tracker for all account managers • PO utilization/balancing report for respective projects and account managers. • Over hours payout working of employees on monthly basis.

• ERP used-Oracle12i. • Vendor payments–through cheque, RTGS, NEFT-TDS deductions. • TDS reconciliation–tie out between system & excel sheet. • Preparing AP report on daily basis. • Responsible for cash management. • Processing employee claims on monthly basis. • Bank reconciliation –AP system tie out with the bank.
• Streamlined operations for increased efficiency by identifying bottlenecks in sales processes and implementing targeted solutions.
• Streamlined operations to maximize business efficiency and profits.
• Enhanced customer satisfaction ratings through implementation of targeted programs aimed at addressing specific areas of concern identified via research and surveys.
• Strengthened stakeholder relationships with regular communication, resulting in improved alignment on strategic initiatives.

• ERP used - QuickBooks. • Responsible for invoicing & billing. • Preparing invoices in our system and uploading them on Client’s portal. • Cash application – applying payments against invoices in the system. Book-keeping-entering & reconciling Credit Card bills in the system. • Recording all bank transactions in system & bank reconciliation on monthly basis. • Preparing AR & AP reports on weekly basis for project managers. • Preparing Sales Tax Matrix for all customer invoices on which sales tax has been charged. • Involved in management–financial reporting. • Preparing Month-End closing financials. • Involved in Year-End closing Financials – Preparing schedules for each P&L and Balance sheet account heads, Adjusting Journal entries and Adjusted Trial balance. • Passing Journal entries for settlement of Intercompany transactions, Expense out entries, Accrual entries, Write-Offs, Deferred income entries. • Consolidating reimbursable expenses for all clients and invoicing them. • Entering Payroll entries in the system on monthly basis. • Tracking and consolidating international & Domestic Travel expenses of the company. • Tracking and preparing total Marketing Expense-project-wise. • Preparing Cash Position from P&L a/c on monthly basis. • Preparing individual project P&L on monthly basis. • Preparing revenue projections quarterly on the basis of SOW’s. • Preparing expense projections on the basis of actual numbers in P&L a/c. • Involved in company Compliances –STPI, PF, ESI • Preparing & filing Labor List department documents for office compliances on quarterly basis. • Supporting and preparing reports for audit purpose. • Actively involved in Hiring process of company employees.
• Streamlined accounting processes for increased efficiency and reduced errors.
• Reduced month-end closing time through streamlined account reconciliations and process improvements.
• Researched billing and invoice problems and resolved issues in compliance with established standards.
• Mentored junior team members, sharing knowledge and expertise to promote professional growth within the department.

ERP–Oracle11i, 12i. • International market reporting to GTM (Go –To- Market) finance, to update them about the outstanding invoices with the accurate reason of delinquency, credit limit, actual collection from the customer and theforecast cash collection for the month and their AR Aging. • Preparing the Monthly Insurance report and MCC (Monthly Cash Collection) past due report on monthly basis. • Responsibility of approving shipment releases based on Customer credit limits and payment analysis. • Responsibility to do the Quarterly Reclassification of customers prepaid balance to AR Account by passing entry directly into GL. • Handling abroad scope of Reconciliation, General Ledger and month-end-closings with the main focus on Accounts Receivable functions. • Preparing DSO (Day Sales Outstanding) for various accounts. • Raising Credit/Debit notes on the request of GTM Team in Oracle ERP-11i in Roam system for all markets. • Responsible to do the Monthly Bank Reconciliations. • Responsible to do the Monthly Balance Sheet Reconciliations. • Monthly Subledger v/s GL reconciliation to check that all the entries are flowing into GL from Oracle ERP Roam system. • Global AR report for all markets. • Headcount report- Consolidating the list of employees (Regular & Temporary), Contractual, Interns and Promoters of the company. • Travel report-consolidating all the travelling expenses & and travel itenary of SLT’s (Senior leading team) and reporting the same to CEO of the company