Getting Started
1.1 Logging In
- Navigate to https://frontage.app
- Enter your email and password
- If your account has two-factor authentication enabled, enter the 6-digit code from your authenticator app
- If you were invited via SSO, click "Sign in with SSO" and enter your work email
First-time users: If you received an email invitation, click the link in the email to set your password, then log in normally.
1.2 Your Role
Your account has one of three roles that control what you can do:
| Role | Can View | Can Edit | Can Delete | Can Manage Users |
| Admin | Everything | Everything | Everything | Yes |
| Editor | Everything | Everything | No | No |
| Viewer | Everything | No | No | No |
Your role badge appears in the bottom-left corner of the sidebar.
1.3 Organization
Frontage is multi-tenant. Your organization is displayed in the sidebar. All data is scoped to your organization — you will never see another organization's data.
Dashboard & Navigation
2.1 Sidebar
The left sidebar organizes Frontage into logical sections:
| Section | Pages |
| Overview | Dashboard |
| Portfolio | Properties, Tenants, Vendors & Expenses, Stacking Plans |
| Leasing | Lease Management, Lease Library, Generate Lease, LOI Generator |
| Legal | Provision Intelligence, Legal Notices |
| Finance | Rent & Payments, Tenant Billing / AR, Property Debt, Management Contracts, Expenses, Accounting Reports, Consolidated Financials |
| CRM | Prospect Pipeline |
| Analytics | Performance Reports, AI Assistant |
| Investment | RE Calculator, Investment Analyst AI |
| Deals | Deal Pipeline, New Deal, Market Comps |
| Tasks | To-Do List |
| Banking | Bank Accounts, Tenant Statements, Budgets & Forecasts, General Ledger, Tax Center, Accounting AI |
| Legal AI | Lease Abstracts, Claude Doc Search, Claude Legal Advisor |
| Vendors | Vendor Directory, Maintenance Schedule, Work Orders, Purchase Orders, Inspections |
| Compliance | ASC 842 / IFRS 16, Insurance Certificates, Audit Trail |
| Documents | SharePoint Files, E-Signatures |
| Admin | Data Migration, Settings |
Tip: Pages with green badges (AI, PRO, CPA) use AI features that require an API key configured in Settings.
2.2 Dashboard
The dashboard shows your portfolio at a glance:
- 6 stat cards: Properties, Tenants, Monthly Revenue, Occupancy Rate, Management Fees, Net Revenue
- Quick Actions: 5 buttons to jump to common tasks (Add Property, Add Tenant, Upload Lease, Record Payment, Create Notice)
- Recent Activity: Latest actions taken in the system
- Upcoming Lease Expirations: Leases expiring within 90 days
2.3 Global Search
The search bar at the top of most pages filters content in real time. Type a tenant name, property address, or keyword — results update as you type.
Properties & Tenants
3.1 Properties
Adding a Property:
- Click "+ Add Property" on the Properties page
- Fill in: Name, Address, City, State, ZIP, Property Type, Units, Year Built, Square Footage
- Click Save
Property Detail View: Click any property name to see its full detail page with 7 tabs:
| Tab | What It Shows |
| Tenants | All tenants at this property with lease details |
| Leases | Active, expired, and draft leases |
| Vendors & Expenses | Property-specific expenses and vendor list |
| Management | Management contract details |
| Stacking Plan | Visual building cross-section showing tenant placement |
| Governing Docs | REAs, CC&Rs, easements — uploaded with AI extraction |
| Location Plan | Floor-plate 2D view of tenant spaces |
Stacking Plan Setup:
- Go to Stacking Plans or Property Detail > Stacking Plan tab
- Click Configure Building
- Enter number of floors, plate square footage per floor
- Assign tenants to floors using the dropdown
- Save — the stacking visualization appears immediately
- Toggle between Lease Expiry colors (green/amber/red by time remaining) and Tenant Type colors
3.2 Tenants
Adding a Tenant:
- Click "+ Add Tenant" on the Tenants page
- Select the property, enter name, email, phone, unit, rent, lease dates, deposit
- Click Save
Tenant Profile: Click any tenant name to open their full profile showing:
- Contact information and property assignment
- Lease details (rent, term, days remaining, type, square footage, deposit)
- Extended terms and options (renewal, termination, exclusive use, ROFO, ROFR)
- Percentage rent (if applicable) — enter gross sales to calculate
- Performance score and active defaults
- Portal access status (invite to tenant portal)
Inviting a Tenant to the Portal:
- Open the tenant's profile
- The tenant must have an email address on file
- Click "Invite to Portal" — an invitation email is sent automatically
- The tenant clicks the link, sets a password, and can access their portal at
portal.html
AI Assistants
Frontage includes four specialized AI assistants, each with deep expertise in a specific domain. They share your portfolio data as context, so they can reference your actual properties, tenants, and leases.
4.1 Which Assistant to Use
| Question Type | Use This Assistant | Page |
| General platform questions, lease administration, workflow help | AI Assistant | AI Assistant |
| Legal analysis, lease review, landlord-tenant disputes, compliance | Legal Counsel AI | Claude Legal Advisor |
| Tax strategy, GAAP/IFRS accounting, CAM reconciliation, financial reporting | Accounting AI | Accounting AI |
| Acquisition underwriting, portfolio analysis, cap rates, refinancing | Investment Analyst AI | Investment Analyst AI |
4.2 How to Get the Best Results
Be specific. The AI performs better with concrete details than vague questions.
| Instead of... | Ask... |
| "Tell me about my leases" | "Which tenants at Oakwood Plaza have leases expiring in the next 6 months?" |
| "What should I charge for rent?" | "Based on the market comps for Class A retail in Atlanta, what rent per SF should I target for a 2,500 SF restaurant space?" |
| "Is this lease good?" | "Review the assignment and subletting provisions in our lease with ABC Corp at 100 Main Street — are there gaps in our landlord protections?" |
| "Help with taxes" | "Walk me through the cost segregation analysis for the HVAC system we installed at Building A last year — acquisition cost was $180,000" |
Mention property and tenant names. The system automatically detects entity names in your question and injects full details about those specific properties and tenants into the AI's context. This gives you much more relevant answers.
Use topic cards. Each AI page has clickable topic cards that provide pre-crafted, comprehensive prompts. These are the fastest way to get a thorough analysis:
- Legal: 28 topics across 8 categories (Lease Review, Landlord-Tenant, Assignments, CAM, Acquisitions, Financing, REIT Compliance, Environmental)
- Accounting: Topics for depreciation, 1031 exchanges, cost segregation, tax planning, property-level accounting
- Investment: 8 topics across 4 categories (Acquisition, Disposition, Debt & Refinancing, Portfolio)
Use filters. The Legal Counsel AI has dropdowns for Matter Type, Jurisdiction, and Property. Setting these narrows the AI's focus and produces more targeted advice.
Multi-turn conversations. All assistants remember the last 10 messages in your conversation. Follow up with "Can you elaborate on point 3?" or "Now apply that analysis to Building B instead." Clear the chat when switching to a new topic.
4.3 Response Times
| Feature | Typical Wait |
| AI chat response (any assistant) | 3–8 seconds |
| Lease PDF extraction (two-pass) | 30–60 seconds |
| LOI generation | 10–20 seconds |
| Full lease draft generation | 20–45 seconds |
| Redline analysis | 15–30 seconds |
| Legal notice generation | 5–10 seconds |
| Provision conflict detection | 5–15 seconds |
| Deal PSA generation | 30–60 seconds |
| Due diligence analysis (multiple PDFs) | 30–90 seconds |
| Closing statement generation | 10–20 seconds |
4.4 SharePoint Integration
If your organization uses SharePoint for document storage, toggle the SharePoint switch (available on all 4 AI pages) to include your SharePoint documents as additional context. The AI can then search and reference documents stored in your SharePoint library.
Setup: Go to Settings > SharePoint Integration and enter your Azure AD Client ID, Tenant ID, Site URL, and Document Library name.
Lease Administration Guide
This section is for lease administrators who manage lease documents, extract data, generate drafts, and handle LOIs.
5.1 Uploading Lease Documents
Single lease upload (with AI review):
- Go to Lease Library
- Drag a PDF into the upload zone, or click to browse (10 MB max)
- The AI automatically extracts all lease data in two passes:
- Pass 1 (fast): Broad extraction of 60+ fields in ~15–30 seconds
- Pass 2 (verification): A second AI model audits the extraction for accuracy in ~15–30 seconds
- A review modal opens with 6 tabs: Parties, Property, Terms, Financial, Options, Provisions
- Each field shows a confidence badge:
- Green (High): Value clearly stated in the document
- Amber (Medium): Value inferred from context or found in an exhibit
- Red (Low): Value is ambiguous or only partially found — verify manually
- Edit any field that needs correction
- Click Save & Import
Batch upload (multiple leases):
- Drag multiple PDFs into the upload zone
- Files are queued — AI extraction runs during import
- Use the auto-import options:
- Auto-create properties: Creates new property records from extracted addresses
- Auto-create tenants: Creates new tenant records from extracted names
- Auto-match existing: Matches to existing properties/tenants by name similarity
- Review the import preview table showing what will be created vs. matched
- Click Import All
Re-extraction: If extraction quality was poor or you've updated the PDF, open the lease document and click Re-extract with AI.
Best practices for upload:
- Use the original executed lease PDF, not a scan of a scan
- Higher-quality PDFs produce better extraction accuracy
- If a lease has exhibits/riders in separate PDFs, upload them together
- After import, always verify red (low confidence) fields manually
5.2 Viewing and Managing Leases
Lease Library shows all uploaded documents with:
- Toggle between card view and table view
- Filter by property, tenant, status, or search by keyword
- Sort by name, tenant, rent, or expiry date
- Export to CSV
Lease Management page organizes leases into 3 tabs:
- Active Leases: Currently in effect
- Expired: Past leases
- Drafts: AI-generated drafts not yet executed
Click any lease to view full extracted data, provisions, and download the original PDF.
5.3 LOI Generation
Creating an LOI:
- Go to LOI Generator > Create tab
- Fill in property details (type, address, square footage, building class)
- Fill in tenant details (name, use, contact)
- Select your industry sector — this tailors LOI topics and market benchmarks
- Check the LOI topics you want included (some are marked "Required")
- Add any additional instructions in the text area
- Click Generate LOI with AI (10–20 seconds)
What you get:
- Landlord Score (0–10) with 5 dimensions: Market Alignment, Tenant Protections, Clarity, Completeness, Negotiability
- Market Analysis panel showing rent range, comparable properties, TI range, vacancy rate
- Full LOI preview with all selected sections
- Actions: Download DOCX, Email to Tenant, Approve & Draft Lease
Uploading an existing LOI for review:
- Go to LOI Generator > Upload tab
- Drop a PDF or click to browse
- AI reviews and scores the LOI (15–30 seconds)
- View improvement suggestions with impact ratings
- Click Proceed to Lease Drafting if satisfied
LOI to Lease transition: When you approve an LOI, Frontage:
- Automatically pre-fills the Lease Generator with all extracted terms
- Updates market intelligence to keep your benchmarks current
- Navigates you to the Lease Generator to create the full draft
5.4 Lease Draft Generation
Creating a full lease draft:
- Go to Generate Lease (or arrive here after approving an LOI)
- Complete the 5-step wizard:
- Step 1 — Property & Space: Select property, unit, square footage, permitted use
- Step 2 — Tenant: Select existing tenant or enter new details
- Step 3 — Lease Terms: Type, dates, rent, escalation, deposit, free rent, TI allowance
- Step 4 — Provisions: Select which provisions to include (exclusive use, assignment, ROFO, etc.)
- Step 5 — Review & Generate: Review summary, then click Generate AI Lease Draft (20–45 seconds)
What you get:
- Full legal lease document with 15+ sections of substantive language drafted from the landlord's perspective
- Landlord Favorability Score (0–10) with 5 dimensions: Rent Optimization, Risk Mitigation, Control Retention, Flexibility, Enforceability
- Negotiation panel for handling tenant counter-proposals
5.5 Redline Analysis & Negotiation
After generating a draft, you can analyze tenant counter-proposals:
Option A — Upload a redlined PDF:
- In the negotiation panel, switch to the Upload tab
- Drop the tenant's redlined PDF
- Click Analyze (15–30 seconds)
Option B — Enter counter-terms manually:
- Switch to the Manual tab
- Each lease section shows a text area — type the tenant's proposed changes
- Click Analyze Counter-Terms
What you get: A card for each detected change showing:
- Original text vs. proposed text
- AI recommendation: Accept (green), Reject (red), or Counter (gray) with counter-language
- Score impact on each dimension (e.g., "Rent Optimization -0.3")
Making decisions: Click Accept, Reject, or Counter on each change. A tracker shows "N of M decisions made." When all decisions are recorded, click Generate Next Round to produce an updated draft incorporating your decisions.
Round history: A horizontal bar shows all negotiation rounds with their scores. Click any round to review its draft.
5.6 Lease Abstracts
Go to Lease Abstracts to see a structured summary of every lease in your portfolio. Each abstract card shows:
- Tenant, property, unit, lease type
- Term dates, rent, square footage
- Key provisions
Click Generate All Missing to batch-generate AI summaries for leases that don't have abstracts yet (3–5 seconds per lease).
5.7 E-Signatures
- Generate a lease draft and download as DOCX
- Go to E-Signatures > New Signature Request
- Enter the tenant's name and email
- Add a custom message
- Click Send — the tenant receives an email with a signing link (valid for 7 days)
- Track status: Draft Created > Sent to Tenant > Tenant Signed > Fully Executed
- After the tenant signs, click Countersign to add your signature
5.8 Troubleshooting — Lease Admin
| Issue | Cause | Fix |
| Extraction has many red (low) fields | Poor PDF quality or scanned image | Use the original digital PDF, not a photocopy. Re-extract after uploading a better copy. |
| Extraction missed provisions entirely | Provisions in exhibits/riders not attached | Upload the complete lease including all exhibits. |
| "Rate limit exceeded" on extraction | Too many extractions in 1 minute | Wait 60 seconds and try again. Limit is 5 per minute. |
| Upload fails with "10MB limit" | PDF is too large | Compress the PDF using a tool like SmallPDF or Adobe Acrobat before uploading. |
| Lease draft is too short or generic | Not enough detail in the form | Fill in all fields in Steps 1–4, especially Additional Terms. The more context you provide, the better the output. |
| LOI score is low | Terms are far from market rates | Review the Market Analysis panel and adjust your terms to align with comparable deals. |
| Re-extract produces same results | PDF content hasn't changed | The AI will extract the same data from the same PDF. Only re-extract after updating the source document. |
| Auto-create made duplicate properties | Property names differ slightly | Merge duplicates manually. Use Auto-Match to reduce duplicates. |
Legal User Guide
This section is for legal team members who handle lease review, notices, provision analysis, and compliance.
6.1 Legal Counsel AI
The Legal Counsel AI acts as a senior CRE attorney with expertise in 8 areas:
- Lease Review & Negotiation
- Landlord-Tenant Matters
- Assignments & Subleasing
- CAM & Operating Expenses
- Acquisitions & Dispositions
- Financing
- REIT Compliance
- Environmental & Insurance
Using topic cards (fastest method):
- Go to Claude Legal Advisor
- Click any topic card (e.g., "Assignment Review") — a comprehensive analysis framework loads as your question
- The AI responds with a structured analysis including risk assessments, checklists, and jurisdiction-specific guidance (3–10 seconds)
Free-form questions:
- Type your question in the chat input
- Set the Matter Type dropdown to narrow the AI's focus (optional but recommended)
- Set the Jurisdiction if your question is jurisdiction-specific
- Set the Property dropdown to inject that property's full lease data into context
- Press Send
Tips for legal queries:
- Ask one question per message for the most thorough response
- The AI includes disclaimers — it provides analysis, not licensed legal advice
- Follow up with "Draft the actual language for Section 12" to get ready-to-use clause text
- Use the Clear button when switching to an unrelated legal matter
6.2 Legal Notices
Creating a notice:
- Go to Legal Notices
- Click "+ Create Notice"
- Select the notice type:
| Type | Purpose | Default Cure Period |
| Late Rent | Demand for overdue rent payment | 5 days |
| Cure or Quit | Formal cure demand for lease violations | 10 days |
| Lease Expiry | Notification of upcoming expiration | 90 days |
| Rent Increase | Notification of rent escalation | 30 days |
| Insurance | Demand for insurance certificate renewal | 15 days |
| CAM Reconciliation | CAM adjustment notice | 30 days |
| Maintenance | Notice of maintenance violation | 14 days |
| Non-Renewal | Notice that lease will not be renewed | 60 days |
- Select the tenant and property — the template auto-fills with their actual data (name, address, rent amount, lease dates)
- Edit the subject and body as needed
- Click Save (saves as draft) or use AI to draft
AI-drafted notices: The AI generates notice content with specific dates, dollar amounts, lease section references, and legally appropriate tone (5–10 seconds).
Violation Checker:
- On the Legal Notices page, expand the Lease Violation Checker
- Check the violation types to scan for (Late Rent, Expiring Leases)
- Click Run Check — the system scans your portfolio data for matching issues
- Results show each violation with a "Create Notice" button
- Select multiple violations and click Generate Selected Notices for batch creation
Notice workflow: Draft > Sent > Acknowledged > Resolved (or Escalated)
6.3 Provision Intelligence
The Provision Intelligence page has 5 tabs for deep analysis of lease provisions across your portfolio:
Tab 1 — Search:
- Filter by property, provision type (exclusive use, assignment, ROFO, ROFR, renewal, termination, etc.)
- Text search across all provisions
- Toggle AI Semantic Search for natural-language queries like "which tenants can sublease without consent?" (5–10 seconds)
Tab 2 — Conflicts:
- Select a property and click Detect Conflicts (5–15 seconds)
- AI analyzes all provisions at that property for overlaps and contradictions
- Results show severity (High/Medium/Low), the two affected tenants, their conflicting provisions side-by-side, and a resolution recommendation
- Common conflicts detected: exclusive-use overlaps, radius restrictions, parking allocations, operating hours, construction restrictions, signage conflicts
Tab 3 — Compare:
- Select a property to build a comparison matrix
- Rows = provision types, Columns = tenants
- Quickly see which tenants have which provisions and compare language side-by-side
Tab 4 — Consent:
- Describe a proposed scenario (e.g., "Allow Tenant A to sublet to a coffee shop")
- AI analyzes which tenants require consent, what conditions apply, and risk levels (5–10 seconds)
- Traffic light indicators: Required (red), Conditional (yellow), Not Required (green)
Tab 5 — Draft:
- After consent analysis, click Draft Agreement for any tenant requiring consent
- AI generates a full consent agreement with sections: Recitals, Consent Grant, Conditions, Representations, General Provisions, Signatures (10–20 seconds)
- Download as DOCX
6.4 Governing Documents
Upload and analyze REAs, CC&Rs, easements, and covenants:
- Go to Property Detail > Governing Docs tab
- Click Upload
- Select document type, enter a name, upload the PDF
- AI extracts parties, use restrictions, parking restrictions, construction requirements, no-build areas, consent rights, and provisions (15–30 seconds)
- View extracted restrictions and provisions on the document card
- Governing doc provisions feed into Provision Intelligence conflict detection
6.5 Troubleshooting — Legal
| Issue | Cause | Fix |
| Legal AI gives generic advice | No property/matter context set | Set the Property dropdown and Matter Type before asking your question. |
| Provision conflicts not detected | Only 1 tenant at property | Conflict detection requires at least 2 tenants with provisions at the same property. |
| Consent analysis says "no provisions found" | Lease documents haven't been uploaded or extracted | Upload lease PDFs for all affected tenants first. Provisions are extracted during upload. |
| Notice template has placeholder text | Tenant or lease data is incomplete | Edit the tenant record to add missing information (address, lease dates, rent). |
| Governing doc extraction missed restrictions | Complex multi-party document | The AI extracts the most prominent restrictions. Review the original PDF for completeness. |
| "API key required" message | API key not configured | Ask your admin to set the Claude API key in Settings > AI Assistant. |
Accounting User Guide
This section is for accounting team members who manage the general ledger, expenses, AP/AR, CAM reconciliation, fixed assets, and financial reporting.
7.1 General Ledger
Go to General Ledger — the page has 10 tabs:
| Tab | Purpose | Key Actions |
| All Entries | View all journal entries | Filter by property and period |
| Receivables | AR entries (account 11xx) | Track tenant receivables |
| Payables | AP entries (account 2000) | Track vendor payables |
| Manual | Manual/adjustment entries only | Create manual journal entries |
| Recurring Charges | Auto-generated rent and CAM charges | Set up, generate, and post charges |
| AP Invoices | Accounts payable workflow | Create, approve, and pay invoices |
| Bank Recon | Bank reconciliation | Match transactions to entries |
| CAM Recon | CAM reconciliation | Calculate, review, and post |
| Fixed Assets | Asset register and depreciation | Track assets, run depreciation |
| Chart of Accounts | Account list | Add/remove accounts |
7.2 Journal Entries
Creating a manual journal entry:
- Click "+ New Journal Entry" on the GL page
- Select date, property, and enter a memo
- Add journal lines: select account from your Chart of Accounts, enter debit or credit amount
- The modal shows running totals — a green "Balanced" indicator appears when debits equal credits
- Click Save Entry (disabled until balanced)
Auto-generated entries: Frontage automatically creates journal entries when you:
- Record a payment (DR Cash / CR Revenue)
- Record an expense (DR Expense / CR Cash)
- Post recurring charges (DR AR / CR Revenue)
- Approve or pay an AP invoice (DR Expense or AP / CR AP or Cash)
- Run depreciation (DR Depreciation Expense / CR Accumulated Depreciation)
7.3 Importing Data from Yardi / MRI
- Click "Import Data" on the GL page
- Select your source system: Yardi Voyager, MRI Software, or Generic CSV
- Upload your CSV file
- Frontage auto-detects column mappings based on your source system's column names
- Review the preview table
- Click Import — each row creates a journal entry
Supported Yardi columns: TransactionDate, Amount, Description, AccountNumber, Reference, PropertyCode, TenantCode
Supported MRI columns: TRAN_DATE, AMOUNT, DESCRIPTION, ACCT_CODE, REF_NUM, PROP_CODE, TENANT_CODE
Date formats accepted: MM/DD/YYYY, YYYY-MM-DD, M/D/YY
7.4 Recurring Charges
Recurring charges automate rent billing and CAM charge generation.
Auto-create from leases (fastest):
- Go to GL > Recurring Charges tab
- Click "Auto-Create from Leases"
- Frontage creates a monthly base-rent charge for every active lease that doesn't already have one
Manual creation:
- Click "+ New Charge"
- Select tenant, property, charge type (Base Rent, CAM, Escalation, % Rent, Insurance, Taxes, Other)
- Set frequency (Monthly, Quarterly, Annually), amount, start/end dates
- Click Save
Generating charges:
- Click "Generate Charges" on the GL page header
- This creates pending charge schedule entries for all charges due up to today
- Pending charges appear in the Pending Charges section below the recurring charges table
Posting charges to the GL:
- Click "Post All Pending" to post all pending charges at once
- Each posted charge creates a journal entry: DR Accounts Receivable / CR Revenue
- Status changes from "pending" to "posted"
7.5 AP Invoices
Workflow: Draft > Approved > Paid
Creating an invoice:
- Go to GL > AP Invoices tab
- Click "+ New Invoice"
- Fill in: Vendor, Property, Invoice #, Amount, Due Date, GL Account (expense category), Description
- Click Save — invoice is created in "draft" status
Approving:
- Find the invoice in the table
- Click Approve
- This creates a journal entry: DR Expense / CR Accounts Payable
Paying:
- Find the approved invoice
- Click Pay
- This creates a journal entry: DR Accounts Payable / CR Cash
Stats bar shows: Outstanding total, Overdue total, Total invoice count
7.6 Expenses
Recording an expense:
- Go to Expenses > click "+ Add Expense"
- Fill in: Property, Category, Date, Amount, Description, Vendor, Reference #
- Optionally mark as recurring with a frequency
- Click Save — auto-creates a journal entry (DR Expense / CR Cash)
12 expense categories: Maintenance & Repairs, Utilities, Insurance, Property Taxes, Legal Fees, Management Fees, Marketing & Leasing, Capital Expenditures, Landscaping, Cleaning & Janitorial, Security, Other
Filtering: Use the Property, Category, and Month dropdowns to narrow results. The category breakdown panel shows spending distribution.
7.7 CAM Reconciliation
Annual CAM reconciliation for NNN leases:
Step 1 — Calculate:
- Go to GL > CAM Recon tab
- Select property and reconciliation year
- Click Calculate (3–5 seconds)
- Frontage:
- Pulls all property expenses and maps them to 10 CAM categories
- Calculates each tenant's pro-rata share based on square footage
- Compares estimated CAM collected vs. actual expenses
- Creates a reconciliation record per tenant
Step 2 — Review:
- CAM Expense Pool table: Shows actual vs. budgeted amounts by category (Maintenance, Utilities, Insurance, Taxes, Management, Cleaning, Landscaping, Security, CapEx, Other)
- Tenant Allocations table: Shows each tenant's square footage, share %, estimated paid, actual owed, and variance
- Click View on any tenant to see the full breakdown by category
Step 3 — Generate Statements:
- Click Generate Statement to produce a printable CAM reconciliation statement
- The statement includes: company name, tenant info, pro-rata share calculation, category breakdown, and amount due/credit
- Click All Statements to generate for all tenants at once
Step 4 — Post to GL:
- Click Post to GL to create journal entries for the variances
- If tenant owes additional: DR AR-CAM / CR CAM Revenue
- If tenant gets credit: DR CAM Revenue / CR AR-CAM
Reconciliation statuses: Draft > Sent > Acknowledged > Disputed > Reconciled
7.8 Fixed Assets
Adding an asset:
- Go to GL > Fixed Assets tab
- Click "+ Add Asset"
- Fill in: Name, Property, Category (13 options including Building, HVAC, Roofing, Elevator, Tenant Improvement, Furniture, Equipment, Vehicle), Acquisition Date, Cost, Salvage Value
- Select depreciation method:
- Straight-Line: Equal monthly amounts over useful life
- Declining Balance: Accelerated (double-declining, based on current net book value)
- MACRS: IRS tax depreciation with standard tables (5, 7, 15, 27.5, or 39-year classes)
- Set useful life (months) or select MACRS class
- Click Save
Running depreciation:
- Click "Run Depreciation" on the Fixed Assets tab
- Monthly depreciation is calculated for each active asset
- Journal entries created: DR Depreciation Expense (7100) / CR Accumulated Depreciation (1520)
- Assets that reach salvage value are automatically marked "Fully Depreciated"
Disposing an asset:
- Click the Dispose button on any active asset
- Enter disposal proceeds and method (Sale, Scrap, Trade-In, Write-Off)
- Frontage calculates gain/loss and creates the disposal journal entry
View depreciation schedule: Click any asset row to see the full projected depreciation table (period-by-period) through end of useful life.
7.9 Bank Reconciliation
- Go to GL > Bank Recon tab
- Import bank transactions (CSV)
- Click Auto-Match — Frontage matches transactions to paid AP invoices by exact amount
- Unmatched transactions can be manually matched by clicking Match and selecting the corresponding AP invoice
- Stats show: Unreconciled count, Reconciled count, Total
AI Transaction Categorization: When you import bank transactions, the AI can automatically categorize them as rent, CAM, maintenance, utilities, etc. and match them to known tenants or vendors based on descriptions and amounts (5–10 seconds).
7.10 Financial Reports
Performance Reports (5 types):
| Report | What It Shows |
| Financial | Gross income, expenses, NOI, operating expense ratio, property comparison |
| Occupancy | Units, occupied vs. vacant, vacancy rate by property |
| Lease Expiry | Leases expiring in 90/180 days, at-risk revenue |
| Rent Roll | Monthly and annual rent totals by tenant |
| Building | Building-level metrics |
Accounting Reports (10 types):
| Report | What It Shows |
| Rent Roll | Active leases with rent amounts |
| Income Statement (P&L) | Revenue vs. expenses, net income |
| Balance Sheet | Assets, liabilities, equity |
| Cash Flow Statement | Operating, investing, financing activities |
| AR Aging | Receivables in 5 aging buckets (Current, 1–30, 31–60, 61–90, 90+) |
| AP Aging | Payables aging similar to AR |
| Tenant Ledger | Per-tenant payment history with running balance |
| Property Summary | Multi-property comparison |
| Expense Detail | All expenses with category breakdown |
| Budget vs. Actual | Planned vs. actual by account code |
Generating a report:
- Select report type, property (or All), and period
- Click Generate — report renders instantly from your data
- Click Export to download as CSV
7.11 Consolidated Financials
For multi-entity portfolios:
- Go to Consolidated Financials
- Click Manage Entities to configure: Entity Name, Ownership Type (Wholly-Owned, JV, Partnership, Fund), Ownership %, Region for each property
- Select report type: Income Statement, Balance Sheet, or Cash Flow
- Choose segmentation: None (consolidated), by Property Type, Region, Legal Entity, or Ownership Type
- View: Consolidated total or Side-by-Side comparison
Elimination Entries: Click Elimination Entries to manage intercompany eliminations (IC Revenue, IC Expense, IC Receivable, IC Payable, Equity Investment, Management Fee).
7.12 Budgets & Forecasts
- Go to Budgets & Forecasts
- Create a budget: Set year, property, and budget amounts for revenue and 6 expense categories
- Overview tab: Budget vs. actuals dashboard with progress bars (green = under budget, yellow = near, red = over)
- Variance tab: Formal variance report table
- Forecast tab: 12-month cash flow projection based on tenant rents and historical expenses
7.13 Troubleshooting — Accounting
| Issue | Cause | Fix |
| Journal entry won't save | Debits don't equal credits | Add or adjust lines until the "Balanced" indicator appears (green checkmark). |
| CSV import fails | Wrong column names or date format | Use the source system preset (Yardi/MRI). Ensure dates are MM/DD/YYYY or YYYY-MM-DD. |
| Recurring charges not generating | Charges have no next_due_date or end_date is in the past | Check the recurring charge's start/end dates and ensure end date is in the future. |
| CAM reconciliation shows $0 actual | No expenses recorded for that property/year | Record expenses for the property before running CAM reconciliation. |
| Fixed asset depreciation shows $0 | Asset already fully depreciated or disposed | Check asset status — it may have reached salvage value. |
| AP invoice won't approve | User role is Viewer | Only Admin and Editor roles can approve invoices. |
| Period close blocked | Pending journal entries exist | Post or delete all pending entries for the period before closing. |
| Budget variance shows no data | No budget created for the selected property/year | Create a budget first, then generate the variance report. |
| Export produces empty CSV | No data matches current filters | Adjust property and period filters, then re-export. |
Financial Analyst Guide
This section is for investment analysts who handle deal pipeline, market intelligence, financial modeling, and portfolio analysis.
8.1 Investment Analyst AI
The Investment Analyst AI acts as a senior REIT analyst with expertise in:
- CRE valuation (cap rates, NOI, IRR, cash-on-cash, equity multiples)
- Acquisition underwriting and due diligence
- Debt structuring and refinancing
- Portfolio allocation and benchmarking
Using topic cards:
- Acquisition: Underwrite, Compare, Risk Assessment, Negotiation Strategy
- Disposition: Timing, Pricing, Tax Optimization
- Debt & Refinancing: Structure Analysis, Refinancing Opportunities
- Portfolio: Allocation Review, Performance Benchmarking
Best practices:
- Provide specific numbers: "Underwrite this deal: 50,000 SF office building, $8M asking price, $600K NOI, 7.5% cap rate"
- Ask for scenario analysis: "What if interest rates rise 100 bps and vacancy increases from 5% to 12%?"
- Use the Context dropdown to select analysis context (e.g., "Acquisition Due Diligence")
- Use the Property dropdown to inject specific property data
8.2 Real Estate Calculator
An interactive financial calculator with real-time computation:
Input 4 sections:
- Property Details: Purchase price, down payment %, closing costs %
- Income: Gross rental income, vacancy rate %, other income
- Operating Expenses: Management %, maintenance, insurance, taxes, other
- Financing: Loan amount (auto-calculated), interest rate, amortization years
Output 8 metrics:
- Cap Rate, NOI, Cash-on-Cash Return, DSCR
- Total Investment, Monthly Cash Flow, Annual Cash Flow, Equity Multiple
All metrics update in real time as you adjust inputs.
8.3 Deal Pipeline
Creating a deal:
- Go to New Deal
- Complete the 6-step wizard:
- Step 1: Acquisition or Disposition? Asset deal or Entity deal?
- Step 2: Property details (name, type, address, sqft, units, year built)
- Step 3: Counterparty info (seller/buyer, broker)
- Step 4: Financial terms (asking price, offer price, NOI, cap rate auto-calculates)
- Step 5: Select LOI topics
- Step 6: Review & Generate AI LOI (15–25 seconds)
Deal lifecycle: LOI Draft > LOI Negotiating > LOI Agreed > PSA Draft > PSA Negotiating > Under Contract > Closing > Completed
Pipeline views:
- Kanban board: Cards organized by status column — drag-ready visual pipeline
- Table view: Sortable list with property, type, price, cap rate, status, days active
AI Deal Documents:
| Document | How to Generate | Wait Time |
| LOI | Generated in Step 6 of wizard | 15–25 seconds |
| PSA / MPA | Advance deal to PSA stage, enter critical dates | 30–60 seconds |
| Closing Statement | Advance to Closing stage, click Generate | 10–20 seconds |
Redline negotiation works identically to lease drafts — upload counterparty's redlined LOI/PSA, get accept/reject/counter recommendations per section.
Due Diligence Analysis:
- Upload DD documents (rent rolls, P&Ls, environmental reports, inspections, appraisals)
- Click Analyze Due Diligence (30–90 seconds depending on document count/size)
- Get comprehensive analysis: Executive Summary, Rent Roll Analysis (occupancy, WALT, tenant breakdown), Financial Analysis (stated vs verified NOI), Liability Assessment (5 risk categories with estimated costs), and an Ideal Purchase Scenario with recommended terms
Auto Milestones: Each deal automatically generates milestone targets: LOI Execution, PSA Execution, Due Diligence, Financing, Survey, Title, Environmental, Closing — with estimated dates.
8.4 Market Comps
The Market Comps page provides CRE market benchmarks across property types, building classes, and metro markets:
- 5 filter dropdowns: Property Type, Building Class, Metro Area, Tenant Size, Tenant Industry
- Stats panel: Median Rent/SF, Median TI/SF, Median Free Rent, Deal Count
- Comp cards: Each shows property type, metro, rent/SF, TI, free rent, escalation, term, lease type
How comps improve AI output: When you generate an LOI, lease draft, or deal document, Frontage automatically injects relevant market comps into the AI's context. The AI anchors proposed terms to market benchmarks for the selected property type, class, and metro — producing more accurate, market-aligned terms than generic AI advice.
Threshold: The system requires at least 3 matching comps for statistically meaningful benchmarks. Below that, the AI falls back to its training knowledge.
8.5 Troubleshooting — Financial Analyst
| Issue | Cause | Fix |
| RE Calculator shows $0 cap rate | NOI or purchase price is zero | Enter both purchase price and income/expense data. |
| Deal LOI has no market analysis | No matching comps for this segment | Provide complete property details (type, class, metro) so the AI can find the best available benchmarks. |
| Due diligence analysis is slow | Multiple large PDFs | Each PDF is analyzed individually. For fastest results, upload fewer, more relevant documents (2 per minute rate limit). |
| PSA generation fails | Missing critical dates | Fill in all date fields (effective, inspection, title, survey, financing, closing) before generating. |
| Deal stuck at a stage | No "Advance" button visible | Check that all required actions for the current stage are complete (e.g., LOI must be generated before advancing past LOI Draft). |
| Market comps show "insufficient data" | Fewer than 3 matching comps | Broaden your filters (e.g., remove Building Class filter, expand metro area). |
| Closing statement prorations look wrong | Missing property tax or insurance data | Enter annual property tax and annual insurance amounts in the deal's financial terms. |
Tenant Portal
The Tenant Portal is a separate, read-only interface for tenants to view their lease information and communicate with their landlord.
For landlords — Inviting tenants:
- Open the tenant's profile (click their name on the Tenants page)
- The tenant must have an email address on file
- Click "Invite to Portal"
- The tenant receives an email with a link to set their password
For tenants — Using the portal:
- Click the link in your invitation email to set your password
- Log in at the portal URL
- Navigate using the horizontal tabs:
| Tab | What You Can Do |
| Dashboard | View your lease summary, property, rent amount, term, next payment due |
| Documents | View and download your lease documents |
| Payments | View your payment history (date, type, amount, status) |
| Work Orders | View existing work orders and submit new ones |
| CAM | View your annual CAM reconciliation statement |
| Messages | Send messages to your landlord and view replies (real-time) |
Submitting a work order:
- Go to the Work Orders tab
- Click "Submit Work Order"
- Enter title, description, select category and priority
- Click Submit — your landlord is notified
Data isolation: You can only see your own data. You cannot view other tenants' information, payments, or leases.
Troubleshooting by Role
10.1 Common Issues (All Users)
| Issue | Fix |
| Page is blank or not loading | Refresh the browser. If the issue persists, clear your browser cache and log in again. |
| "Unauthorized" error | Your session may have expired. Log out and log back in. |
| Toast notification says "error" | Read the error message. Common causes: missing required fields, rate limits, network issues. |
| Data seems stale | Frontage loads all data on login. If another user made changes, refresh to see them. |
| Can't find a feature | Use the sidebar navigation. All 44 pages are organized by section. Check your role — Viewers cannot access edit/delete functions. |
| AI features show "API key required" | Ask your admin to configure the Claude API key in Settings > AI Assistant. |
10.2 Performance Tips
| Tip | Why |
| Upload one lease at a time for the best extraction quality | Single-file uploads get the full two-pass extraction with review modal |
| Use topic cards instead of typing generic questions | Topic cards are pre-crafted expert prompts that produce more thorough responses |
| Set filters before generating reports | Narrower scope = faster generation and more relevant results |
| Clear AI chat history when switching topics | Prevents context pollution from unrelated prior messages |
| Use the Kanban board for deal pipeline | Visual pipeline is faster for tracking deal status than the table view |
| Export to CSV for offline analysis | All major views support CSV export |
Keyboard Shortcuts & Tips
| Action | Shortcut |
| Send AI message | Press Enter in the chat input |
| Search | Click any search bar and start typing — results filter in real time |
| Close modal | Click outside the modal or click the X button |
| Navigate | Click sidebar items — your last page is remembered across sessions |
Data Export
Every major table in Frontage has an Export button that downloads a CSV file:
- Lease Library, Tenants, Properties
- General Ledger (all entries + lines)
- Legal Notices
- Accounting Reports
- Fixed Assets
- Deal Pipeline
Getting Help
- In-app: Use the AI Assistant page for any platform question — it knows the full feature set
- Support: Contact your Frontage administrator
Tenant Billing & Accounts Receivable
Found under Finance → Tenant Billing / AR. This module replaces spreadsheet-based rent tracking with a full AR workflow: create invoices, record payments, and monitor aging.
12.1 Creating an Invoice
- Click + New Invoice
- Select the tenant — property and lease auto-fill
- Set the invoice date, due date, and optionally the billing period
- Add line items: description, amount, GL account, and charge type (Base Rent, CAM, Tax, Insurance, etc.)
- Click Save as Draft or Send
Sent invoices appear in the tenant's billing history. Void an invoice to reverse it — it will be marked void and excluded from aging.
12.2 Recording a Payment
- Click the payment icon on any open invoice, or go to the Payments tab and click Record Payment
- Select the invoice (pre-filled if opened from an invoice row)
- Enter: payment date, amount, method (Check, ACH, Wire, Credit Card, Cash), and reference number
- Click Record Payment — the invoice balance updates immediately
Partial payments are supported: an invoice will show status Partial until paid in full.
12.3 AR Aging Report
Click the Aging tab to see all outstanding balances bucketed by days past due:
| Bucket | Meaning |
| Current | Not yet due |
| 1–30 Days | Overdue ≤ 30 days |
| 31–60 Days | Moderately overdue |
| 61–90 Days | Seriously overdue |
| 90+ Days | Severely delinquent — escalate immediately |
The red badge on the Tenant Billing nav item shows the count of overdue invoices at a glance.
12.4 Stats Overview
- Total Billed: All invoices (sent + partial + overdue)
- Collected: Sum of all payments
- Outstanding: Current balance due
- Overdue: Amount past due date
CRM & Prospect Pipeline
Found under CRM → Prospect Pipeline. Track every prospective tenant from initial inquiry through executed lease. The pipeline uses a standard 7-stage commercial leasing funnel.
13.1 Pipeline Stages
| Stage | Meaning |
| Lead | Initial inquiry received — contact info captured |
| Qualifying | Gathering size, budget, timeline requirements |
| Touring | Property tours scheduled or completed |
| LOI | Letter of Intent under negotiation |
| Negotiating | Lease terms being negotiated |
| Executed | Lease signed — convert to active tenant |
| Dead | Deal did not proceed — capture reason in notes |
13.2 Adding a Prospect
- Click + Add Prospect
- Enter: company name, contact name, title, email, phone
- Select the target property and pipeline stage
- Fill in deal parameters: desired SF (min/max), target move-in date, budget $/SF, industry
- Optionally add broker name/firm, source (referral, broker, cold outreach, website)
- Set Last Contact and Next Follow-Up dates for CRM reminders
- Click Save
13.3 Kanban vs. Table View
Toggle between views using the buttons in the page header:
- Kanban: Visual columns per stage — drag-and-drop concept; click a card to edit
- Table: Sortable rows with all key fields visible — best for large prospect lists
Use Export to download all prospects as CSV for broker reports or board presentations.
13.4 Integration with Deals
When a prospect reaches Executed, create a formal Deal record in the Deal Pipeline for PSA / closing management. The CRM tracks the leasing pipeline; Deals tracks acquisitions and dispositions.
Purchase Orders & Procurement
Found under Vendors → Purchase Orders. Manage vendor POs with line-item detail, approval workflow, and GL account coding — from draft through receipt.
14.1 Creating a Purchase Order
- Click + New PO
- Select Property, Vendor, and optionally a linked Work Order
- Enter a PO Number (your internal numbering), description, budget account, and requested by
- Add line items: description, quantity, unit, unit price, GL account — subtotal auto-calculates
- Add tax if applicable
- Set Expected Delivery date
- Click Save as Draft or Submit for Approval
14.2 Approval Workflow
| Status | Action |
| Draft | Being built — not yet submitted |
| Pending Approval | Submitted — awaiting approval |
| Approved | Click Approve button — records approver name and timestamp |
| Ordered | PO sent to vendor |
| Received | Goods/services received — enter received date |
| Closed | AP invoice matched and paid |
| Cancelled | PO voided |
The Approve button on a pending PO records your name and timestamp as the approver. This is an SOD (segregation of duties) control.
14.3 Linking to Work Orders
When a maintenance work order requires materials, create a PO and select the work order in the Work Order field. This links procurement spend to the specific repair job for cost tracking.
Property Inspections
Found under Vendors → Inspections. Schedule and record property condition inspections — move-in, move-out, periodic, drive-by, and capital inspections.
15.1 Inspection Types
| Type | When to Use |
| Move-In | Document condition before tenant occupancy |
| Move-Out | Document condition after tenant vacates — supports deposit claims |
| Periodic | Scheduled routine inspections (quarterly, annual) |
| Drive-By | Quick exterior check without entering the property |
| Capital | Detailed assessment for capex planning or refinancing |
15.2 Creating an Inspection
- Click + New Inspection
- Select property, tenant (optional), inspection type, scheduled date, and inspector name
- The checklist is pre-loaded with 6 default areas: Exterior, Common Areas, Tenant Space, HVAC, Plumbing, Electrical
- Add or remove areas as needed
- For each area: set condition (Excellent / Good / Fair / Poor), add notes, flag deficiencies, add photo URL
- Set overall condition rating and write a summary
- If deficiencies were found, check "Work Order Created" after creating the linked WO
- Click Save
15.3 Status Flow
Inspections move through: Scheduled → In Progress → Complete. Cancel an inspection if it won't occur. Stats on the page show counts by status and how many have open deficiencies (Fair or Poor condition items).
Data Migration
Found under Admin → Data Migration. Import existing data from Yardi, MRI, QuickBooks, or any CSV export. Use this when first onboarding to Frontage to avoid manual re-entry.
16.1 Supported Import Types
| Import Type | What It Creates | Supported Sources |
| Tenants | Tenant records (name, email, phone, rent, unit, lease dates) | Yardi, MRI, Generic CSV |
| Properties | Property records (name, address, type, SF, units) | Yardi, MRI, Generic CSV |
| Vendors | Vendor records (name, category, contact, email) | Yardi, QuickBooks, Generic CSV |
| GL Transactions | General ledger entries (date, account, description, debit, credit) | Yardi, MRI, QuickBooks, Generic CSV |
16.2 How to Import
- Select the Source System (Yardi, MRI, QuickBooks, or Generic CSV)
- Select the Import Type (Tenants, Properties, Vendors, or GL Transactions)
- Click Choose CSV File and select your export file
- A preview table shows the first few rows and how columns will be mapped
- Review the mapping — if a column doesn't match, use Generic CSV source which maps by position
- Click Confirm Import to create all records
- A success toast shows how many records were imported
16.3 Column Mapping by Source
Frontage automatically maps common column names from each source system:
| Source | Auto-mapped Columns |
| Yardi | TenantName, UnitNumber, LeaseStart, LeaseEnd, MarketRent, Email, Phone |
| MRI | tenant_name, unit_no, lease_from, lease_to, base_rent, email_addr, phone_no |
| QuickBooks (vendors) | Vendor, VendorType, BillingAddress, Email, Phone |
| Generic CSV | name, email, phone, rent, unit, leaseStart, leaseEnd (any order) |
Tip: Export your data from Yardi/MRI as a standard report CSV — do not manually reformat the columns. The auto-mapper handles the native export format.
Debt Covenant Tracking
Found under Finance → Property Debt. After entering your loans, set covenant thresholds on each to monitor compliance against lender requirements in real time.
17.1 What Are Covenants?
Loan covenants are contractual requirements from your lender. Breaching them can trigger default, accelerated repayment, or penalty rates. Frontage tracks the three most common financial covenants:
| Covenant | How Frontage Calculates It | Typical Threshold |
| DSCR (Debt Service Coverage Ratio) | Annual NOI (from debt record) ÷ Annual Debt Service (monthly payment × 12) | ≥ 1.20x to 1.35x |
| LTV (Loan-to-Value) | Current Balance ÷ Property Value (from debt record) × 100 | ≤ 65% to 80% |
| Occupancy | Active tenants ÷ Total tenants at the property × 100 | ≥ 80% to 90% |
17.2 Setting Covenant Thresholds
- Go to Finance → Property Debt
- Find your loan in the Debt by Property table
- Click the shield icon in the Actions column (it turns green when covenants are set)
- Enter minimum DSCR, maximum LTV%, minimum Occupancy%, and next test date
- Add notes for cure periods, reporting obligations, or custom definitions
- Click Save Covenant Thresholds
17.3 Reading the Covenant Panel
The Covenant Compliance card at the bottom of the Debt page shows all loans with thresholds set:
- Green dot: All covenants passing
- Red dot: One or more covenants failing
- Each metric shows actual value, PASS/FAIL badge, and the threshold
- Next covenant test date is shown — update it after each quarterly/annual test
Important: Frontage uses the Annual NOI and Property Value you entered on the debt record for DSCR and LTV. Keep these updated as your NOI changes or you get a new appraisal. Occupancy is calculated live from your tenant roster.
Insurance Certificate Tracking
Found under Compliance → Insurance Certificates. Track insurance certificates for all tenants and vendors — receive early warning of expirations and non-compliance.
18.1 Certificate Statuses
| Status | Meaning |
| Active | Certificate on file, not expiring within 30 days |
| Expiring Soon | Expires within the next 30 days — request renewal |
| Expired | Past expiration date — tenant is in violation |
| Non-Compliant | Manually flagged as non-compliant (insufficient coverage, missing riders, etc.) |
| Missing | No certificate on file — tenant has not provided one |
Status is computed automatically from the policy end date — you don't need to manually update it.
18.2 Adding a Certificate
- Click + Add Certificate
- Select the tenant or vendor, property, and coverage type (General Liability, Property, Workers Comp, Umbrella, Professional, Auto)
- Enter insurer name, policy number, policy start/end dates
- Enter coverage amounts: General Liability (per occurrence and aggregate), Property, and Workers Comp
- Check whether Frontage is named as Additional Insured and/or Waiver of Subrogation is in place
- Upload a copy of the certificate (optional)
- Click Save
18.3 Best Practices
- Set a calendar reminder to check this page monthly — the Expiring Soon filter shows what needs attention
- Require certificates as a condition precedent to lease commencement
- Verify that your required coverage minimums match the lease insurance requirements
- Always confirm Additional Insured status — a certificate without it may not protect you
ASC 842 / IFRS 16 Compliance
Found under Compliance → ASC 842 / IFRS 16. Generate GAAP-compliant operating lease disclosures, amortization schedules, and journal entries for your portfolio's leases.
19.1 Overview
ASC 842 (US GAAP) and IFRS 16 require lessees to recognize a right-of-use asset and lease liability on the balance sheet for leases longer than 12 months. As a landlord, you use this module to produce the disclosures your auditors and lenders require.
19.2 How to Use
- Go to Compliance → ASC 842 / IFRS 16
- Select the accounting standard: ASC 842 (US GAAP) or IFRS 16
- Enter your Incremental Borrowing Rate (IBR) — this is the rate used to discount future lease payments to present value. Default is 5%; ask your auditor for the correct rate.
- Click Generate Compliance Report
19.3 The Four Output Tabs
| Tab | What It Shows |
| Summary | Portfolio totals: PV of lease liability, current portion (due within 12 months), non-current portion, right-of-use asset, and operating classification confirmation for each lease. Balance sheet presentation table. |
| Amortization | Month-by-month schedule for each lease showing: beginning liability, interest expense, principal reduction, ending liability, and ROU asset balance. Up to 60 months displayed. |
| Journal Entries | Initial recognition entries per ASC 842-20-30: Dr ROU Asset / Cr Lease Liability (with authoritative cite). Copy/paste into your GL system. |
| Maturity Analysis | 5-year undiscounted future lease payments with present value reconciliation — required for footnote disclosure. |
19.4 Key Formulas
Lease Liability (PV of future payments):
PV = PMT × (1 − (1 + r)^−n) / r
Where: PMT = monthly rent, r = IBR/12, n = remaining months
Current vs. Non-Current split: Frontage simulates month-by-month amortization for the first 12 months to calculate the exact principal reduction — this is the current portion. The remainder is non-current.
Export: Click Export Schedule CSV to download the full amortization schedule for all leases.
Budgeting, Variance & Forecasting
Found under Banking → Budgets & Forecasts. Build annual budgets by category, compare actual results to plan, and run a 5-year NOI projection.
20.1 Creating a Budget
- Go to Banking → Budgets & Forecasts
- Click + New Budget
- Select the year and property (or portfolio-wide)
- Enter budgeted amounts for each revenue and expense category
- Click Save Budget
The Overview tab shows budget vs. YTD actual at a glance (total budget, YTD actual, variance in dollars and percent).
20.2 Variance Analysis
Click the Variance tab to see Budget vs. Actual broken down by category:
- Revenue rows: Actual rent collected vs. budgeted rental income + CAM + other revenue. Green = favorable (above budget). Red = unfavorable.
- Expense rows: Each expense category budget line vs. actual spend. Favorable when actual is below budget.
- NOI row: Budget NOI vs. actual NOI with variance in dollars and percent.
Actuals pull from payments recorded in Rent & Payments and expenses in Vendors & Expenses. The comparison period defaults to year-to-date; change it with the period dropdown.
20.3 5-Year NOI Forecast
Click the Forecast tab for a 5-year projection:
- Base revenue = current monthly rent × 12 (from all active tenants)
- Revenue grows at 3.0% per year
- Base expenses = actual expenses this year ÷ 12 × 12 (annualized). If no expense data, defaults to 35% of revenue.
- Expenses grow at 1.5% per year
- NOI = Revenue − Expenses for each year, with year-over-year growth rate shown
This forecast is directional for planning purposes. For a lender-grade proforma, use the Investment Analyst AI to build a custom model.