Efrain Colon Email & Phone Number

New York, Ny, Us

Lead monthly P&L review calls with at least fourteen General Managers.Calculate, and analyze monthly accruals for expenses such as Utilities, Contract labor, security, etc.Review, reconcile Balance sheet and inter-company account for assigned properties.Review, reconcile, and record daily income journal activity for each hotel assignment.Perform bank reconciliations, process journal entries, and prepare monthly trial balance reports.Reconcile PCard purchases and allocate transactions to proper expense lineCalculate, analyze, and upload accrual adjustment entries for monthly & quarterly property taxes.Ensure accounting management is appropriately notified of accounting, internal control, and business issues as they develop, to devise timely & appropriate action plans.Assist General Managers with payment status queries.

Parsippany

Arranged monthly P&L review calls with at least fourteen General Managers.Identified budget vs actual variances, applying business knowledge in understanding variances, and documenting close.Assisted General Manager with monthly variances commentary for senior corporate management.Researched and responded to monthly allowances and expense inquires following each month-end close.Prepared and uploaded multiple month end reclass and accruals journal entries with backups in the accounting system.Analyzed Balance Sheet and Income Statement.Reconciled PCard purchases and allocated transactions to proper expense lineCalculated, analyzed, and uploaded monthly Utilities accruals journal entries.Performed assigned properties balance sheet reconciliation.Reconciled intercompany amounts monthly for each entity.Prepared schedules and amortized prepaid expenses for all 180 properties.Calculated, analyzed, and uploaded monthly accrual adjustment entries for quarterly taxes for 180 properties.Prepaid and submit monthly labor variances details with commentary to management.Reconciled monthly cash accounts and accounts payable accrual accounts for assigned properties.Worked on various ad hoc projects as needed

Union, New Jersey

Maintained all financial data in the investment database.Performed bank reconciliations, process journal entries, and prepare monthly trial balance reports.Reconciled all cash received from investors and investments.Prepared capital call and distribution calculations, sources/uses of cash, allocations, and investor notices.Allocated income to partners in accordance with terms of partnership agreements.Maintained and update investment data (number of shares, location of securities, country of origin).Prepared work paper files for accuracy and completeness, including capital activity, investment activity, income and expense accruals, valuation adjustments, etc.

Wayne, New Jersey

Performed tasks related to monthly and annual accounting cycles of the University.Performed bank reconciliations, process journal entries and prepare monthly trial balance reportsAnalyzed general ledger accounts and funds, which included layers of research to explain a trail of connected accounting entries.Updated and review fixed asset capitalizations on a monthly basis for accuracy.Utilized Banner the University’s finance system, and Analytical software SAS Enterprise Guide (Analytics Software) to prepare financial reports.Downloaded financial data and worked through a complex matching process via pivot tables and VLOOKUP’s, as well as prepare a variance analysis report.

Paterson,Nj

Managed, interpreted and administered guidelines and regulations for government grants and contracts for fiscal accountability, as well as provided financial analysis for different planning scenarios for individual programs. Prepared journal entries, deposits, expenditures, bank reconciliations, and filed reports for state and federal agencies Created reporting systems to track, monitor and bill all line items to ensure maximization of revenue potential.Managed, reviewed, and processed all travel expenses, mileage reimbursement and maintained a monthly petty cash account.

Bachelor Of Science, Accounting And Finance, 3.2

Activities and Societies: NJCPA, AICPA, Accounting Society club at William Paterson University Graduated August 2018 with 150 credits.

Associate Of Science (A.S.), Business Administration And Management, General, 3.3