JOVITO B. ESTERA
**-** ***** ******, ********, New York
Mobile Number: +1-347-***-****
Email: ad2ba6@r.postjobfree.com / ad2ba6@r.postjobfree.com Professional Experienced: Fifteen Years - Project Construction Accountant Recent Company: Redco Construction Almana (RCA)
Recent Designation: Chief Project Accountant
From Dec 24, 2012 till May 28, 2023
• Project Accounting and Construction Management
o Perform project accounting, project and contract set-up and create project accounts in ERP. o Works with Project Managers to develop project budget, contracts and timely completion of project. o Review all invoices and subcontractor’s requisitions related to billings and due payment. o Engage with clients/customers for project payments collections, aging receivables and reconciliation. o WIP analysis and schedules, project revision and adjustment, implement project close-out. o Monitor the project tracker relative to payment certificates and insurance certifications. o Works with Project Managers for accuracy of all invoices in compliance with project accounting standard and construction guidelines.
• Project Contract and Budget
o Entry and review project contracts details and works with team to establish approved budget. o Review all contracts, budgets and subcontractors change orders and all supporting information. o Review invoices from subcontractor & subconsultant to ensure compliance with contract and budget. o Assist with budget preparation and enter budget changes, variance adjustments and forecasting. o Monitor change orders and potential change items related to project budgets and anticipated costs. o Collaboration with Project Managers with financial status of projects and contract modifications.
• Project Billing and Revenue recognition
o Prepare project billing and verified billable items, rates and contract value and terms. o Works with project team to ensure timely and accurate submission of construction billing. o Review client contracts for project billing, change order summary, total retainage amount, lien waivers. o Prepare and review AIA billings applications for assign projects (Format G702 & G703) o Ensure proper revenue recognition, monitoring actual cost to date and cost to complete. o Prepare requisitions AIA G702 & G703 billing format and follow-up payments. o Assist the preparing for monthly WIP schedules and booking job cost accruals. o Review schedule of values, works completed, total retainage, waivers lien releases (G703). CURRICULUM VITAE
• Accounts Payable (AP)
o Enter all invoices for payment, issue checks and organize sign approval, prepare for mailing to vendors. o Review the payment of subcontractor requisitions and other constructions invoices. o Prepare and analyze accounts payable aging reports to optimize cash flow payment schedules. o Entry accurate reference of invoices for vendors ID, job reference, match invoices to each contract. o Review insurance certificate to ensure contract compliance and applicable with financial regulations. o Prepare accounts payable list at month-end closing, check reconciliation on ledger trial balance.
• Accounts Receivable (AR)
o Monitor on project accounts receivables aging and support project collections. o Periodic aging analysis to identify outstanding accounts, follow-up base on collections schedules. o Responsible for accounts receivable (AR) tracking and management reporting for multiple projects. o Manage and analyze project collections and update project summary reports on due for collection. o Monitor unpaid contract billings, follow-up delinquent accounts receivable (AR) and unbilled cost.
• Project Job Costing
o Tracking project cost update and compare with project budgets to identify project variance. o Review unbilled costs and unpaid invoices to maximize billing and collection schedules. o Monitor project costing and revenue recognition and reconciliations, resolve discrepancies. o Support with project teams to develop cost to completion, forecasting and approved billing. o Analyze project costing and identified potential budget overruns. o Tracking project cost up to date and analyzing project profitability. o Review project expenditures, ensuring adhere to financial policies and accuracy.
• Working with Project Team (Contract & Finance)
o Works with project team for construction budget, actual cost to date and progress billings. o Assist project teams for job costing and update budget-to-actual schedules and analysis. o Collaborate with Project Managers, Engineers and Procurement to gather financial information. o Works with project team to ensure timely and accurate submission of billings on multiple projects. o Collaboration with sub-contractors and project team relative to job costing, waivers of lien, insurance certificate and releasing payments to subcontractors.
• Month-End Closing and Yearly Audit
o Provide support schedules for month-end closing and annual audit requirements. o Assist with external audits and project audits and provide support as needed. o Prepare and analyze monthly journal entries, income and expense accruals. o Implement month-end and year-end closing activities, reconciliations and accruals and yearly audit.
• Project Financial Reporting
o Analyze project financial reports and project performance, monitor actual cost vs budgets. o Assist in the preparation of project budgets and project financial forecasts. o Prepare and analyze project financial statements and project profitability (Profit & Loss) o Working with Project Managers for construction budget vs actual cost (Variance analysis). o Analyze and investigating project variances and submit variance report to management. Previous Company: Lebanese Constructions Company (Qatar) Designation: Senior Project Accountant
From Aug 10, 2010 till Dec 15, 2012
• Sub-contractor Payable (AP)
o Prepare schedule for sub-contractor payment for aging/due base on contract terms. o Review the payment of subcontractor requisitions and construction invoicing. o Collaboration with finance team to ensure timely preparation of check for vendors payment. o Reconciliation of accounts payable transactions and resolve discrepancies and issues. o Review and processing of all subcontractor related payments associated with assigned projects. o Generate financial reports related to assign project (AP Summary) accounts payable activities. o Organized and up-to-date records of accounts payable transactions in ERP. o Handling accounts payable / payment processing / lien waivers / vendors reconciliation. o Review payment for retainage releases and elevating aging/due vendors payments. o Waiver of liens and Insurance certificate are in hand prior to the release of payments.
• Project Accounting and Financial Reporting
o Prepare project financial reports and statements, variance analysis, and project profitability. o Prepare monthly project reports includes analysis of budget vs actual results. o Monitoring of construction expenditures update and compared to budget. o Manage job costing reports, prepare project aging AP & AR summary reports. o Monitor and track project expenditures to maintain accurate financial records. o Manage projects financial objectives includes budgeting, collections and P&L. o Prepare monthly accruals for outstanding project cost and unbilled cost. o Review and analyze capitalization of costs in compliance with management policy. o Prepare monthly project financial reports and statement for management review.
• Project Team Collaboration
o Coordinate with project managers to ensure revenue recognition and project profitability. o Set-up project ID, project budget and cost codes for new project module implementation. o Work closely with all Project Managers to insure accurate monthly WIP process. o Assist project budget, schedules and forecast in collaboration with project teams. o Collaboration with project managers and clients to resolve billing issues and discrepancies. o Work closely with accounts payable team and project team for streamline payment process. o Establish excellent working relationships with internal vendors and external clients.
• Project processing and verification
o Review, verified and process all incoming invoices from subcontractors and vendors. o Ensure all invoices are comply with proper supporting documentation and sign approval. o Review project contracts and budgets in the system and assign billing terms on new projects. o Management of projects; Project coding, job costing, project tacker and financial closeout. o Check and review of subcontractor insurance and verified lien waiver.
• Monthly End Closing and Compliance
o Ensure month-end and year-end closing processes are accurate and timely implemented. o Support internal and external audit by providing necessary documentation and schedules. o Adherence to project accounting standards and processes and contract compliance. o Identify process improvements for profit/cost and monitor actual against budgets/forecasts. o Review project expenditures to ensure compliance with capitalization policy. Previous Company: Lebanese Constructions Company (Qatar) Designation: Project Accountant
From Aug 03, 2007 till Aug 07, 2010
• ERP Project Set-up and Project Team Collaboration o Setup projects in ERP system in accordance with management policy and construction guidelines. o Assist project managers on set-up of projects in construction management platform. o Closely works with project managers and clients to ensure monthly billings and contract compliance. o Works with project managers for update project costs, monthly reports and payable schedules. o Works with project teams for timely completion of project and financial goals are met. o Maintain project management system, includes projects ID, project budget, job costs, cost code, project contracts, change orders and purchase orders.
• Vendors invoicing and Payable (AP)
o Prepare priority payment checks and processes for sub-contractor due invoices. o Post monthly subcontractor progress billings with supporting documents for compliance. o Reviews and ensure the accuracy of sub-contractor invoicing before billing clients. o Review project invoicing, project overhead journal entries and year-end audit adjustment. o Review and process of project-related invoices, ensure adherence to contract terms and budgets. o Assist the Project Manager or Finance Controller for monthly cash flow requirements.
• Project Accounting & Project Billing
o Manage project accounting activities, includes AIA billings and project job costing. o Provide insights of project accounting for complex transactions, Cap-Exp and cost allocations. o Prepare and maintain billing contract format (G702 & G703) o Processing billings, manage project-related accounts receivables, and sub-contractor payables. o Ensure in compliance with project accounting policies and construction standards procedures. o Review and analyze general ledgers for assigned projects and prepare monthly accruals. o Prepares reconciliations of P&L ledgers accounts, general ledgers account and accruals.
• Project Contract & Budget, Job Costing & Project Reporting o Analyze and review project contract, project cost and ensure accuracy and within the budget. o Enter project budget changes and variance adjustments in the reporting system. o Prepare monthly project financial reports for project managers and senior management. o Preparing support data and analysis for financial reporting, budget variance and change orders. o Investigate project variances and submit variance reports to management. o Review insurance certificate and bonds to ensure contract compliance. Previous Company: City Government of Sagay (Philippines) Designation: Computer Accounts Controller
From Mar 16, 1997 till Jul 30, 2007
Detailed Core Responsibilities:
• Manage the daily cash position and monthly bank reconciliations.
• Manage fund control and review disbursement schedule and payables.
• Review all accounts payable transactions and update tracking of historical disbursement.
• Accurately maintain and up-to-date records of all government project financial transactions.
• Reconcile project loans accounts and beneficiaries’ repayment receipt.
• Monitoring cash flow to ensure more enough budget available for loan renewal.
• Maintain and update project files and financial records on shared system.
• In-charged for cash disbursement schedules and update collection reporting.
• Resolve queries with internal departments and external loan beneficiaries.
• Well-organized and prioritizing the release of renewal applicants on timely schedules. Previous Company: Mardal Corporation (Philippines) Designation: Accountant
From Jun 15, 1995 till Mar 10, 1997
Detailed Core Responsibilities:
• Manage day-to-day accounting activities, open new accounts and ledger reconciliation.
• Monthly bank reconciliations and ensure booking of finances and other cost incurred.
• Investigates and resolve invoicing and payment discrepancies.
• Implement accuracy of accounting records and timeliness of payments.
• Ensure compliance with accounting policies and company procedures and processes.
• Prepare of month-end closing accounting packages (P&L and Balance Sheet)
• Assist in year-end audits by providing schedules and analysis of financial disclosures.
• Ensure timely management of accounts receivable (AR) and accounts payables (AP)
• Prepare financial reports and reconciliation for general ledger accounts.
• Prepare journal entries and reconciliations relative to balance sheet and profit and loss.
• Review and verified vendors/supplier invoices and process checks for payments.
• Analyze financial information, identify discrepancies, provide valuable insights with the team. HIGHEST EDUCATION & CERTIFICATES:
Highest Degree: Bachelor’s Degree in Commerce – Management Accounting Colegio San Agustin Bacolod, Negros Occidental, Philippines (1991-95) Certificates: Analyzing and Visualizing Data with Microsoft Power BI Aptech Qatar Computer Education, Doha–Qatar (28 November 2021) PROJECT REPORTING AND ACCOUNTING SYSTEM EXPERIENCED: Project Tracker Report Update and Analysis Project Management Reporter - P&L and G&A Project Financial Close-out Report Project Account Summary Report Project Revenue, POC and Performance Report Project Receivables (AR) & Payables (AP) Report Project Cost Accrual Report (WIP & Provisions) Project Contract and Project Budget Update Posting of Fixed Assets and Reconciliation G&A Analysis Report and Budget allocation ERP Microsoft Dynamic D365, AX2012 & AX2019 QuickBooks Accounting & Peach Tree Acctg. Excellent in Excel, Data Analysis & Power BI Quickly learner, Detail-oriented strong working ethics