📲 Install HotelOps: tap Share⎙ then Add to Home Screen
Google Sheets not connected — click ⚙ Sheets to set up📶 OFFLINE — cached data
Property
Date
Timeframe
Connect Google Sheets
Paste your Web App URL to sync data automatically from your Google Sheet.
How to get your Web App URL:
1. Open your Google Apps Script project
2. Click Deploy → New Deployment
3. Type: Web App · Execute as: Me · Access: Anyone
4. Click Deploy → copy the URL and paste it below
⚠️ Before syncing, make sure:
1 · WebApp.gs is replaced with v5 and deployed as a New Version (/exec URL)
2 · Apps Script setup scripts have been run (setupFinancialsTabs, setupNewProperties)
3 · Deploy settings: Execute as: Me · Access: Anyone
Add Property
Each property tracks its own daily reports.
Add Daily Report
Enter data from your nightly PDF report or email.
Tip: Copy the numbers directly from your nightly Hotel Statistics PDF report. Fill in as many fields as you have — anything left blank will show as $0 or 0%.
Today (Actual)
Month-to-Date (MTD)
Last Year MTD (LMTD)
Year-to-Date (YTD)
Last Year YTD (LYTD)
PDF Import: Drag in your nightly Hotel Statistics PDF. The parser reads occupancy, ADR, RevPAR, revenue, and room-count figures automatically. For best results use the standard Best Western / franchiser night-audit report.
📄
Click to select PDF
Your nightly Hotel Statistics report
Email Import: Drop a .eml or .txt copy of your nightly stats email. The parser extracts date, occupancy, ADR, RevPAR, revenue and room counts automatically.
📧
Click to select email file
.eml or .txt format
⚠️ Sync Validation Report
Review issues before confirming save
Add P&L Statement
Upload a monthly P&L PDF or enter figures manually.
Enter figures from your monthly P&L statement. Leave blank if not applicable.
Income
Operating Expenses
Other Income / Expense
Bottom Line
Export P&L Summary and P&L Detail from QuickBooks into one Excel file with two tabs. Both summary totals and every transaction will be parsed automatically.
📊
Click to select Excel file
QuickBooks export with P&L Summary + P&L Detail tabs
Parse Expense Transactions
Upload the financial package PDF to extract all individual transactions for each expense category.
Tip: To avoid the 413 error, extract just the transaction pages (pages 7–20) from the full PDF using smallpdf.com before uploading.
📄
Click to upload PDF
Detailed Income Statement Transactions pages
Transactions
Loading…
📤 Upload Center
Upload PDF or Excel reports — all line items are extracted and pushed directly to Google Sheets.
📊
P&L / Income Statement
Monthly financial statement. Extracts all revenue & expense line items, GOP, NOI, Net Income.
💰
Cash Flow Statement
Operating, Investing & Financing activities. Extracts each line item and section totals.
⚖️
Balance Sheet
Assets, Liabilities & Equity. All line items with prior period comparison.
🧾
Detail Transactions
QuickBooks or bank transaction export. Date, payee, category, amount for every line item.
Forward nightly stats emails. Parses all numeric fields from the email body.
Parsing file...
💡 Upload via Genspark (Recommended for large files):
You can also drop any PDF or Excel file directly into the Genspark chat and ask: "Parse this [P&L / Cash Flow / Hotel Statistics] report for [Property Name] [Month YYYY] and upload to Google Sheets"
Genspark will extract every line item and write directly to your sheet — no size limits, handles scanned PDFs.