Excel
This function returns the arithmetic mean of a range.
What is AVERAGE?
This is OneStream's term for the dimension that represents the legal or reporting structure of the organization.
What is the Entity dimension?
These are arrivia's four core values.
What are Stay Curious, Keep It Real, Own It, Win Together?
This foundational equation must always stay in balance: Assets = Liabilities + this.
What is Equity (or Stockholders' / Owner's Equity)?
This acronym for a company's earnings strips out interest, taxes, depreciation, and amortization.
What is EBITDA?
This function counts cells in a range that meet a specified condition.
What is COUNTIF?
This is the process of pulling actuals from source systems into OneStream.
What is Data Loading (or Data Integration)?
With the introduction of UKG Pro, this module is where employee's go to submit PTO.
What is Workforce Management?
This visual tool is used to show debits on the left and credits on the right of an account.
What is a T-account?
These are the accounting standards followed by most U.S. companies.
What is GAAP (Generally Accepted Accounting Principles)?
This function pair is the flexible predecessor to XLOOKUP, using one function to find position and another to return the value.
What are INDEX and MATCH?
This process combines subsidiary results into a parent entity's financial statements, including eliminations.
What is Consolidation?
This magazine just recognized arrivia for the 11th consecutive year on their prestigious Power List.
What is Travel Weekly?
This account, contra to an asset like PP&E, carries a credit balance and reduces the asset's net value.
What is Accumulated Depreciation?
This term is the money a business spends on big long-term assets like equipment or buildings.
What is CapEx (Capital Expenditure)?
This tool cleans and transforms data with a step-by-step interface before loading it into Excel.
What is Power Query?
This OneStream feature translates entity data from local currency into the reporting currency.
What is Foreign Currency Translation (FX)?
This is the training portal used to access arrivia University.
What is myAbsorb?
This principle says revenue is recorded when earned, not necessarily when cash is received.
What is the revenue recognition principle?
These international accounting standards are used by companies in over 140 countries outside the U.S.
What is IFRS (International Financial Reporting Standards)?
This 2024-era Excel function lets you write reusable custom logic in a formula without needing VBA.
What is LAMBDA?
This governance object controls what actions a user can perform, from viewing a Cube View to running a business rule
What is a Security Role (or Access Group)?
The recently acquired Bon Voyage Travel company was founded in this year.
What is 1976?
When a company issues stock above par value, this equity account is credited for the excess over par.
What is Additional Paid-In Capital (APIC)?
This 2002 law, passed after Enron and WorldCom, tightened corporate financial controls and reporting.
What is SOX (Sarbanes-Oxley Act)?