SP.FINANCIALS

SP.FINANCIALS allows you to pull data from the singlepane database for any financial/GL account in our chart of accounts. This includes data from hotel P&Ls, budgets, monthly forecasts and owner and operator pro-formas.

SP.FINANCIALS has the following arguments, which can either be entered directly into the formulas surrounded by quotation marks, or entered by cell reference (A1).

Property Code - a unique singlepane property code, usually three letters. All property codes that are authorized under your account can be found in the "My Properties" excel tab that is automatically created in the workbook when you log-in to the add-in.

USALI - the singlepane GL account code that you would like to pull data for. All available USALI accounts are found in the "Usali Reference" tab that is automatically created in the workbook when you log-in to the add-in.

Month - A three letter month abbreviation (i.e. "Jul" for July). You can also pull the following time aggregations:

• Total Year

• Q1, Q2, Q3, Q4

• MMMYTD (i.e. "JulYTD") (Note: no space)

• MMMBOY - Balance of Year, exclusive of the month referenced (i.e. "JulBOY" for Aug through Dec)

• MMMTTM - Trailing 12 Months (i.e. "JulTTM") for Jul of current year through Aug of prior year

Year - a four digit year

Version - the version of the data to pull. Available versions include:

• Actual (from hotel P&Ls)

• Budget (current/final budget)

• Budget1 through Budget12 (budget drafts)

• Forecast1 through Forecast12 - monthly forecasts as of the end of the month number (i.e. Forecast6 is the forecast received at the end of June/with June actuals)

• Proforma

• LY_Actual (Last Year Actuals, same Month)

• Var_LY_Actual (Variance to Last Year Actuals)

• Var_Budget (Variance to Budget)

Example:

=SP.FINANCIALS("XYZ,"Total Revenue - 100","JulYTD",2023,"Actual")

Will return the Room Revenue for hotel XYZ for July Year-to-Date 2023 Actuals.

Using cell references: