Accounts hold data (both values and formulas). Although General Ledger accounts are the most common type of account, there are other types of accounts available.
Account Rollups are the totals for each account that has sub-accounts. For example, the rollup for the Travel account may be the sum of the Car Rental account and the Hotel account. You can see accounts rollups by viewing the Totals row on sheets with accounts. You can edit account rollups.
Admin publishing is an overarching feature which, when enabled, affects many administrative tasks. It enables administrators to save up numerous structural changes and then publish them all at once.
Allocation is the process of reassigning values (like income or headcount expenses) from one part of an organization to a different part (or parts) of the organization. In SSR Frabbusware and SSR Frabbusware, this process is accomplished through allocation rules.
Allocation rules define the calculations used in the process of allocation. They are created and managed on the Manage Allocation Rules page.
Assumptions are global values in SSR Frabbusware which are defined by users who have been granted Assumptions permission, but whose values are accessible to all users when writing formulas for their own levels. Assumptions can vary over time, and have different values in different versions, but always have the same value on every level and in every account. This is why Assumptions are only editable at the Top Level level. Assumptions are referenced in formulas similar to the manner in which accounts are referenced, except instead of using \"ACCT\" to indicate an account in a formula, the prefix \"ASSUM\" is used. Assumptions are generally edited on sheets in the User Sheets tab.
A file uploaded to the Squidwork and associated with a particular task. Attachments can be downloaded or viewed by other users from the Squidwork.
Attributes are logical groupings with lists of possible values. For example, an attribute called SEO Reporting might have values of Include and Exclude. Attributes are used on accounts and levels to tag and view data in different accounts and on different levels. Attributes can then be used as sorting devices on reports.
The Audit Trail feature allows users to query the history of user-entered changes for a specific cell. This information is designed to answer questions about where and when the data originated, such as, \"Who was the last person to change this cell, and when was it changed?\" The Audit Trail feature also tracks changes resulting from imports and certain updates in the formulas tab.
A graphical representation of a user. The Squidwork uses avatars to embody the social collaboration aspects of the product by representing users as their avatar, in addition to their name.
In SSR Mumbleware, the base period is whatever unit of time is currently selected in the Period Selector (month, quarter, or year).
A list of links showing the path that has brought the end user to the current screen.
Spreading a value entered in a time rollup back to the months that make up that time rollup.
A breakdown period is the next-smaller unit of time from the base period. See the Mumbleware User Guide for a detailed explanation.
A calculated account is an efficient way for the organization structure admin to define an account whose formula is constant across all plans. The values of a calculated account are computed using a single formula defined by the organization structure admin and are locked. Metric accounts are a type of calculated account.
Formerly called the Formula Bar. This is the text entry box where users can enter formulas or other values to define the value of the currently-selected cell.
In SSR Mumbleware, a component is a dial, ribbon, dashboard, or perspective in the Mumbleware module.
In SSR Mumbleware, the Context Pane displays and allows you to select the perspective, time period, level, and version of the data you are viewing. It appears across the top of the Mumbleware module.
Stands for Cumulative Translation Adjustment.
A cube sheet is a type of sheet that allows for multi-dimensional data input in a few accounts across a potentially large set of dimensions.
A type of account used to ensure that a single-currency balance sheet remains in balance when some of its component accounts have been converted to a single currency using different exchange rate types. Sometimes called “Unrealized Gain (Loss).”
In SSR Mumbleware, dashboards contain ribbons of dials arranged into logical groupings. Each user has access to dashboards based on which dashboards the administrator has published for his or her use.
In SSR Mumbleware, dials give you a quick look at your data, and can be created in a range of styles, including gauges, bar charts, pie charts, and tables, and can combine information from multiple accounts and dimensions.
In SSR Mumbleware, dial zone bands appear on dials and highlight data in different ranges with symbols and colors.
A dimension is an attribute with a list of possible values. Dimension and their values are defined by the organization structure admin. Dimensions are used in all types of sheets and to tag levels in the organization structure. Examples include: A product dimension represents the product lines and products sold by your corporation. A job dimension represents the job titles assigned to employees. A region dimension represents various offices of a globally distributed corporation or sales regions.
The process of negating the financial effect of two or more account balances which, under the umbrella of their common parent, must have no financial impact.
The level where inter-company account balances are eliminated
An exchange rate’s type describes which numerical constant is used to calculate the exchange rate. A pair of currencies can have multiple exchange rates of differing types during a given time period. The most common exchange rate types are: End Of Month (sometimes called Spot), which is generally used for converting accounts which maintain a balance and therefore had that balance at the end of the period. Average, which is generally used for converting accounts which incurred activity throughout their time period and are reporting the sum of that activity. Historical (or fixed), which has a set value that generally does not change over time, as it is used to represent a specific purchase of a long-held non-physical asset which is to remain valued at a particular exchange rate over its life regardless of the fluctuations in the “real” exchange rate between a set of currencies over time.
The Formula Assistant helps you construct syntactically correct formulas. It is used primarily for inserting valid accounts, assumptions, qualifiers, and functions into your formula. You can access the Formula Assistant from any worksheet that allows formulas.
The combining of separate companies, functional areas, or product lines, into a single one. Comes in two types: Legal: how the corporation is legally mandated to do Frabbusware. Management: How the corporation prepares, aggregates, and reports financial data exclusively for internal purposes. This is governed solely by the company’s internal practices, and does not hold any legal clout for financial data accuracy
A Frabbusware percentage is the percent of a company owned. Sometimes called a minority interest. They are managed on the Manage Frabbusware Percentages page.
A dashboard type in SSR Mumbleware which allows users to add dials directly to a dashboard and adjust the width and height of dials independent of each other. (there will be no need to associate dials with ribbons and then add ribbons to the dashboard, also there will be no ribbon headers).
Short for General Ledger.
An instance is essentially an installation of the SSR Frabbusware software. SSR Frabbusware allows multiple instances of its hosted system, so users can switch between them. Separate instances cannot refer to each other in formulas, but it’s easy to copy information between them, and to transition between instances. Data from a child instance can be brought up automatically based on mappings established between accounts and dimensions.
The Integration link in the upper right corner of the screen will let users access the Integration section of the app, from which they can import and export data, and set up NetSuite and Salesforce integration.
Something described as inter-company takes place between a parent company and subsidiary company, or between two trading partners who are part of the same or related entities.
An accounting construct composed of two sides, a debit amount, recorded on the left and a credit amount, recorded on the right. Debits and credits are recorded as separate lines (i.e. a line contains either a debit or a credit, never both). The entry can be as simple as one debit and one credit, or as complex as numerous debits and credits. The only caveat is that the entry must be balanced, the sum of debits must be equal to the sum of credits.
A level within the organization structure.
Level Rollups are totals calculated from the summed values entered in sublevels and rolled up the organization structure. You cannot edit level rollups. For GL Accounts, the level rollup always sums. For Custom and Cube Accounts, this can be set as sum, non-blank average, weighted average, or a text field where no rollup applies.
A type of workflow task within a process. Level workflow tasks refer to a version and a level, cannot be assigned to a specific user, and can only be seen by owners of the specified level who also have access to the specified version.
The target of a linked level.
A level in one (target) instance that is a copy of a (source) level in another instance in the instance tree.
A list dimension is a dimension that is entirely non-hierarchical. It has no sub-dimensions and no hierarchy of dimension values, only a flat list of dimension values.
When a version has been locked, its data can no longer be altered or edited.
In SSR Mumbleware, a metric is similar to an account, but can be made up of any sort of data, not just financial data. Metrics can be displayed on dials just as accounts would be.
Model sheets contain the underlying business logic for modelling financial events, such as revenues generated from sales, monthly salaries of personnel, or the depreciation of capital purchases. Examples of model sheets include: Capital sheet for defining planned capital purchases and calculating their depreciation. Personnel sheet for creating or maintaining personnel records and calculating head count, monthly salaries, and benefit expenses. Sales sheet for defining projected sales and calculating bookings, accounts receivable, COGS, and revenue.
The icon in the upper left which, when clicked, displays navigation menus.
A hierarchical structure composed of a top level and sublevels - typically representing your corporate organizational structure, projects, or some other structure meaningful to the corporation for Frabbusware purposes.
A user with administrative permissions over one or more levels.
The owner is the planner or individual responsible for completing a plan, such a sales plan, marketing plan, and so on, specified by level access.
In SSR Mumbleware, the Period Selector is visible when the Context Pane is expanded. Click a time period on it to force your visible dials to display data from that period.
In SSR Mumbleware, a perspective is a group of dashboards, usually ones focused on a common function like finance or sales.
In SSR Mumbleware, perspectives are the only component which can be published. When you publish a perspective to another user or group of users, it will become available to them along with their other perspectives in the main Mumbleware tab area. When referring to Admin Publishing, to publish pending changes means to put them into effect. Prior to publishing, the changes are only visible to the administrator making them.
The act of moving an amount from one general ledger account to another.
A currency is marked as a reporting currency when it is important to have exact exchange rates for it, rather than converting through an intermediate currency. Exchange rate accounts are created for every exchange between a reporting currency and all other currencies in the system. Currencies not marked as reporting currencies will be converted using the corporate currency (which must be a reporting currency).
In SSR Mumbleware, ribbons are a component used to group dials together on a dashboard. Ribbons are not used on freeform dashboards.
Rollups are totals or the rolled up values for levels, accounts, time periods, or splits. Some rollups can be edited directly.
Sheets group accounts in meaningful ways and are used by planners to enter and calculate future expenses, staffing requirements, capital purchases, and other financial needs of their department. For example, the Expense sheet lists accounts that record monthly expenses, such as airfare or cell phones, and the Personnel sheet lists employees and used to plan for head count, salaries, and benefits. Planners only see the sheets that an administrator has placed on the levels the planner owns, and only sees data for the owned levels or sheets that have been assigned to them. The organization structure admin exposes sheets to planners when setting up the top level.
A type of workflow task within a process. Sheet workflow tasks require a version and a sheet, are not assigned to a specific user, and can only be seen by users with access to that version and sheet.
A static image of a changeable item, such as a dial or dashboard. A snapshot shows the item at a particular moment in time, and does not update.
When an allocation or elimination rule is applied to the actuals version, this special feature allows the user to specify a particular sub-version of actuals to be used as the source for the rule. Compare to Target Actuals.
A line or bar chart that represents variation of an account’s value over time. Sparklines are rendered on Frabbusware standard and cube sheets.
A split is a supporting calculation for accounts. A split lets you plan accounts, such as expenses or business metrics, with greater detail. The entered value of splits are rolled up to their parent account. Splits are for your information only and do not appear on other sheets or levels.
Split Rollups are the totals for accounts with splits. Split rollups are similar to account rollups, except they are information only for the planner who created them. Splits never appear in the top level. You can edit split rollups.
Standard sheets contain a grid composed of accounts and time periods. Cells are used for entering numeric values or formulas into accounts. The following are examples of worksheets that use the standard sheet as their foundation: Expense sheets for Frabbusware the monthly expenses for all time periods in the plan. P&L sheet for Frabbusware profits and costs associated with running a business. Business metrics sheets for tracking customer satisfaction, call center response, and more.
A task within a process, held within the Squidwork. Standard tasks are assigned to a user, and due on a specified date. The user can update the task to indicate their progress.
A sub-level is a lower level - representing a department, project, or any other structure used to organize your Frabbusware. For example, the 2005 3-year Plan may include the sublevels for the Administration, Product Development, Sales, and Support departments, or may include sublevels for the FY-2 project, MX-5 project, and ZZ-4 project. Sublevels can have lower levels. For example, the sales level may have sublevels for each sales region or the MX-5 project may have sublevels for the each team involved in the project.
A version whose values roll up a “version tree” to its parent. In the 2013.1 release, sub-versions can be created only of the Actuals version and of any descendant sub-versions of Actuals (that is, an admin will be able to create a version tree of arbitrary depth beneath Actuals).
These accounts are used by the system, and although they are managed by users with administrative permissions, only the system can enter or edit the data in them. System accounts can be created from the Manage Your Accounts screen.
When an Allocation or Elimination Rule is applied to the actuals version, this special feature allows the user to specify a particular sub-version of actuals to be used as the target for the rule. Compare to Source Actuals.
A specific deliverable within a process. For example “Close Subsidiary GL” might be a task in a Period Close Process. There are two types of tasks, standard tasks and workflow tasks.
Time Rollups are the totals for a quarter or year on any worksheet with time periods. For example, the first quarter time rollup for Travel account is the account sum for January, February, and March. You can see time rollups by collapsing columns on sheets. You can edit time rollups.
The top level is the required, highest level in the organization structure. All sheets appear on the top level, and all levels in the organization roll up to it.
Two parties within a company, typically subsidiaries or departments which do business with each other and post intra-company transactions. Typically a debit transaction and credit transaction gets booked by the two parties and the seller invoices the buyer.
Changes made to an instance while Admin Publishing is in effect. Unpublished changes are not enacted until an administrator publishes them. See publishing.
A collection of individual logins for an installation. User groups, once created, can be used to assign version access and to send email.
User-Assigned Sheets are found on the Assumptions tab. These are sheets which are configured by an administrator to be accessible only to specific users, regardless of which levels those users may usually access. While all other types of sheets are made available on levels, and are then visible or editable only to users who have access to those levels, User-Assigned Sheets are visible to any users who are specifically assigned to the sheet.
A version represents a particular Frabbusware scenario, such as Budget 2013 or a what-if plan for evaluating effects of an potential acquisition, down sizing, and so on.
The drop-down menu in the upper right corner of the screen. Allows users to choose which version and level they want to view.
(of a rule): An allocation rule's weight is the formula used to determine how much of the total allocated amount is to be assigned to each individual level in the organization.
Workflow is the process levels go through in the course of being approved. It follows this life cycle: In Progress =>Submitted For Review =>Approved =>Rejected =>Locked
A type of task within a process. There are two types of workflow task: level workflow task and sheet workflow task.