Flex Property Microsoft Dynamics for Real Estate Content

Flex. Property Microsoft Dynamics for Real Estate

Content § Introductions and background § References and previous experience § Solution overview § Short demo § Q&A and Next steps

Introductions

References and previous experience

North America Scandinavia Europe Middle East More than 50 customers in 25+ countries Africa ASIAPAC

Tishman Speyer • • Top 5 real estate investor world wide 50 bn USD invested in real estate US, EU, Brazil, India, China Office & Retail Chose AX/Flex. Property to replace MRI Discarded MRI, Yardi, Oracle, SAP Global go-live Q 3 -2016

IKEA Centres (Europe & Asia) 60+ malls in 14 countries (EU, Russia, China) Rip & replace 30 -40 old systems Dynamics 365 Operations, Sales, Field Service Office 365 and Power. BI 1000+ users Chose Dynamics over Oracle, SAP, Yardi and others • Project kicked off September 2016 • • •

Edmonton Airport (Canada) • • Went on AX for financials in 2014 Added Flex. Property in 2015 Terminal commercial leasing Outside terminal leasing In terminal advertising Outside billboards Parking facilities Various advanced percentage rent scenarios

Solution Overview

Dynamics 365 One Microsoft for Real Estate Microsoft Dynamics 365 Common application platform: Power. Apps, Microsoft Flow, Common Data Model

End-to-end Real Estate with Microsoft Dynamics Real Estate Business Value Chain Strategic Planning Procurement Market Analysis Object / Area Management Energy and Utility Consumption Maintenance Risk Management Due Diligence & Acquisition Construction Management Marketing Partner Management Billing General Service Plan Initiatives Business Planning Work Management Deal Capture Contract Management Credit Management Call Center Controlling Pre-Investment Phase Decision Phase Development Phase Operations Phase Divestment Phase

Microsoft Dynamics – Property Management Flex. Property Land, lots, building rights Buildings/ Properties Meter Management Facilities & Equipment Indexation Dates & expirations Automated fee calculation External partners Tenant contracts Cost allocation Alerts and warnings Any data in Dynamics as fee basis Intercompany fee contracts Common Areas Landlord contracts Service Charges One-off fees External data can form the fee basis Manage expirations Key management Flexible charge management Retail rent Lease and break options Flexible reporting periods Recurring and one-off charges Step Rent Utility billing Security Deposits and guarantees Flexible billing periods Leasable units & areas Leasing Process Parking spaces

Microsoft intelligent business cloud Enhanced for Real Estate by Flex. Property Sales Customer Service Property & Lease Management Field Service Project Service Automation Corporate Fee Billing Marketing Operations Multi-entity management

Financials Make decisions based on facts and comply Reporting and consolidation Budget General Ledger Accounts Payable Accounts Receivable Cost Accounting Fixed Assets Project Accounting Build and maintain your budgets with Microsoft Excel Analyze your finances the way you want Manage your vendor relations and disbursements Efficiently manage debtor invoices and collections Distribute costs and analyze profitability Automate your acquire-to-retire process Manage your project tracking profitability Key Benefits Enable users to make decisions based on facts Comply with local regulations Comply with global regulations (IFRS, SOX) Powerful account structure for deeper analysis

Internal Controls & Business Process Tools Automate Corporate Compliance and Business Processes Workflows & Queues ENRICHED VISIBILITY • Compliance status & activities BETTER CONSISTENCY • Configurable Alerts GREATER CONTROL • Alerts Complying with corporate policies Easily track and manage compliance BETTER SEGREGATION OF DUTIES • To comply with regulations Extensive Audit Trails – Track Access Controls & Changes LOWER COST OF COMPLIANCE • Audit IMPROVED GOVERNANCE • Integrated Task Recorder & Business Process Modeller Tracking internal controls FACILITATED KNOWLEDGE MANAGEMENT • BPM & Task Recorder Streamlined/automated processes Captured processes for training and readiness documentation

General Ledger § Intra-unit accounting § Unlimited dimensions § Measure economic performance across departments. § Create alternative reporting hierarchies § Transfer encumbrances and related budget reservations across fiscal years § Establish accounting rules § Distribute transactions across accounts and dimensions by %, amount or quantity § Effectively manage cash flow. § Import from external systems

Accounts Receivable § Free text invoicing, including templates for recurring invoices § Distribute line amounts across multiple dimensions § Invoice services on demand or schedule § Support settlements in a pooled cash set-up § Use collection dashboard as a workbench for central receivable management. § Manage debtor credit & define collection process. § Prepare interest letters and apply interest, late charges and other fees § Use case management to monitor and track collections closely. § Perform write-offs and reimbursements

Accounts Payable § Invoice register with pool or Invoice Journal (non. PO) § Enter and post invoices for recurring expenses § Define invoice matching policies for the organisation. § Three-way invoice-matching based on purchase order, product receipt, or invoice. § Matching variance approval process. § Manage vendor status (active, on hold). § Budget check during invoicing process. § Collaborative process allowing vendors to directly enter their invoices.

Procurement § § § § Vendor Registration RFQ with links & responses Evaluation and Ratings

Fixed Assets § Manage the full life cycle from acquisition to depreciation and disposition. § Record asset acquisition through purchasing § Generate & edit depreciation proposals § Manage accounting of assets for tax preparation. § Forecast using fixed assets budgets and supporting workflow § Transfer assets from one financial dimension to another § Split an asset into another or kit through parent-child relationships § Help verify legal and regulatory compliance. § Track non-transactional data

Project Accounting End-to-End Project Management & Financial Visibility § § § §

What is Flex. Property § Real estate module developed, owned and maintained by Yavica § 15 year product history § >50 implementations globally § Fully embedded in Dynamics § Certified by Microsoft § Flex. Property on Microsoft App. Source

Flex. Property functionality § Property details § Purposes § Types § Standard setup copied to contracts § Contact persons § Etc.

Flex. Property functionality § Lease lines based on lease types (base rent, utilities, security deposits etc. ) § Recurring rent and one-off charges § Flexible invoicing periods § With or without units § Details for invoicing § Standardized prices or specific price on lease § Total price or price per area § Multiple languages and currencies

Flex. Property functionality § § § Individual setup on each contract line Indexation based on indices Manual price adjustment of single contracts Manual price adjustment for multiple contracts (i. e. Cable tv price increase)

Flex. Property functionality PERCENTAGE RENT (TURNOVER RENT) § Define rules, including breakpoints and related percentages by lease line § Combine different rules on same contract § Flexible configuration of reporting and reconciliation periods § Centralized control over actual tenant sales reporting § Tenant sales captured manually, by import or through tenant portal § Reconciliation of percentage rent

Flex. Property functionality AUTOMATED FEE BILLING (MANAGEMENT FEES, FRANCHISES, COMMISSIONS) Define rules for calculated fees Setup percentage breakpoints Query any table in D 365 O for fee basis (e. g. projects, cash receipts, revenue) Automated fee calculation and billing Automated intercompany posting Full audit trail and history

Flex. Property functionality § Setup of different cost pools for different purposes § Multiple cost pools/allocation per property § Prepayments and reconciliation § Direct re-charging of single vendor invoices § Automatic setup of allocation – option to adjust § Option to set fixed prices and/or add mark-up § Cost budgets and actual cost

Flex. Property functionality § Set up main and sub meters for e. g. : § Electricity § Heating § Water § Handles prepayment billing and automatic reconciliation billing based on reported meter readings § Reports to tenants of consumption § Allows for tracking of consumption by tenant, property, company, fund for environmental controlling and reporting

Facility Management & Field Service FIELD SERVICE PLANNING • Advanced Dispatch and Scheduling • Multi-dimensional, dynamic scheduling tools to manage individuals, teams, and assets • Access documentation, knowledge bases, and enterprise social resources MOBILE SUPPORT – IOS, WINDOWS, ANDROID • Route optimization • Schedule and calendar views • Social and team collaboration • CRM/Upsell support

Portals TENANT PORTAL • View account and lease information, detailed installed base and entitlements, create service requests and work orders, track status details, appointment windows and expected delivery times • Access documentation, knowledge bases, and enterprise social resources PARTNER PORTAL • Partner access to relevant functionality: inventory, parts requests, work orders, dispatch, time and material details and work order detail

Flex. Property Reporting & BI

Built in reporting and BI