Real Estate Management
Resume:
Bei Guo
Elmhurst, NY *****
347-***-****, ******@*****.***
SUMMARY
Over ten years in real estate field with commercial and residential property accounting experiences in the financial statement preparation, budgeting, escalation, accounts analysis and cash management. Strong organizational and analytical skills, efficient problem-solver. Committed to high quality performance and accuracy.
PROFESSIONAL EXPERIENCE
Senior Property Accountant – The Moinian Group, NY, NY, 4/15 – 5/17
●Prepared monthly, quarterly, and year end financials for partners, lenders, and auditors. Reviewed accuracy of financial data, ensure invoices were code correctly.
●Worked closely with Property Managers to prepare the annual budget, and be able to explain the budget variances.
●Calculated RE tax escalations for the commercial tenants & tenant letters. Recorded transfer funds between properties, and different type of cash accounts.
●Reviewed & approved monthly billing statements. Checked new commercial leases to ensure all charges were billed accordingly, and explained variances comparing to previous month.
●Prepared cash flow projections and bank reconciliation for all operating cash accounts as well as tenant security deposit accounts. Ensure all cash receipts, return items were recorded properly, and posted to the correct cash accounts.
●Reviewed tenant security withdrawal, security deposit, and security transfer forms. Ensure the accuracy of the data.
Real Estate Accountant (Consulting Project) – Robert Half, NY, NY, 2/14 – 3/15
●Consulting Projects for Real Estate Investment, Development, and Management Companies &other company. Prepared monthly financial statements and support documents, bank reconciliations. Prepared and post journal entries. Analyzed and reconciled financial data for development projects. Entered invoices into QuickBooks.
Senior Property Accountant (Consulting Project) – Tryad Group, Brooklyn, NY, 7/13 – 12/13
●Prepared monthly work papers to supporting the balance sheet & income statement accounts for 15 entities.
●Prepared and recorded monthly accruals, mortgage payments, intercompany transactions, journal entries for depreciation & amortization.
●Reconciled intercompany accounts, escrow accounts and management fees. Posted 2012 audit AJE’s in MRI.
●Calculated management fees and prepared invoices to all properties.
Property Accountant – Manhattan North Management Co., Inc., NY, NY, 5/09 – 5/13
●Prepared monthly financial statements including variance analysis for numerous properties. Updated monthly work papers to supporting the balance sheet accounts.
●Set up residential and commercial leases in Skyline. Calculated RE Tax escalations for commercial tenants.
●Responsible for month end close. Prepared annual budget assumptions & budgets, cash flow projections, bank reconciliations, accrual entries, payroll entries, and posted late fees to tenant ledger.
●Prepared and filed RPIE (Real Property Income and Expense), TC201. Maintained and reconciled tenant security deposit account.
●Reviewed, approved and posted AP batches.
●Responsible for preparing annual audit package for external auditors.
Assistant Property Controller - Williams Real Estate Co. Inc., NY, NY, 04/07 – 02/09
●Provided monthly consolidated financial statements including variance analysis as well as work papers to clients for portfolio of properties ahead of deadlines.
●Meet all deadlines to prepare annual budget, CAM, CPI and RE Tax escalations, accrual entries, bank reconciliations including tenant security account, and funding request to the owner.
●Reviewed lease abstracts for the accuracy before enter in MRI. Set up and updated lease profiles in MRI for new leases, lease amendments, and stipulation agreements. Ensure rent statement reflected these changes.
●Calculated owner’s distribution based on monthly cash flow projection, and prepared wire transfer.
●Reviewed and approved invoices for proper coding. Interacted with owners, district managers, banking relations regarding the financial issues.
●Coordinated with external annual audits by providing supporting documents.
Senior Property Accountant - Related, NY, NY, 01/06 – 04/07
Provided monthly and quarterly financial statements, variance analysis reports, and monthly work papers to investor for 2 entities.
Prepared CAM calculations, RE Tax escalations, accrual entries, and annual budget. Worked with the management team to assure budget quality.
Worked with asset managers to resolve old CAM and RE tax billing issues.
Prepared complex accounts analysis including tenant CM ledger and reconciliations, and researched for the supporting documents.
Recorded cash receipts allocation, updated recurring billing information in MRI and JD Edwards.
Generated tenant rent statements. Closely followed up outstanding balances by making collection calls and sending out late notices.
Property Accountant - Jones Lang LaSalle, NY, NY, 01/03 – 01/06
Provided monthly financial statements and budget versus actual variance analysis reports to client.
Prepared annual budget, operating expense escalations, accrual entries, bank reconciliations and various accounts analysis for senior management.
Responsible for month-end close. Reviewed expense distribution reports, and assisted with rent collections.
Senior Property Accountant - Sentinel Real Estate Corporation, NY, NY, 08/00 – 09/02
Provided quarterly consolidated financial statements for investors and prepared monthly variance analysis reports for firm asset managers.
Prepared annual budgets, revenue forecasting, real estate taxes analysis, sales tax returns, operating expense escalation schedules and tenant letters. Processed quarterly accrual journal entries, updated the amortization schedules.
Financial Analyst -Cushman & Wakefield, Inc., NY, NY, 09/99 – 08/00
Prepared and provided client with detailed income/expense variance analysis report, cash flow projection, capital expenditure tracking report, summary of cash balances and accounts receivable summary report.
Prepared annual budget and explanations for budget variances. Prepared rent escalation, operating expense escalation schedules, real estate tax, and other financial information for internal/external auditors. Prepared lease abstracts and act as liaison between tenant and client.
SKILL Yardi Voyager, Skyline, MRI, JD Edwards, QuickBooks, Excel and Word
EDUCATION QUEENS COLLEGE OF THE CITY UNIVERSITY OF NEW YORK
Bachelor of Arts in Accounting and Information Systems
Contact this candidate