Jet Cube Inc

Specializing in Financial Reporting, Budgeting & Forecasting Software.

Benefits of using Jet Cube

Learn how the Jet Cube software can help your business automate and streamline your budgeting, forecasting and financial reporting requirements.

Cloud Data Warehouse

All data can be stored in the secure Jet Cube Cloud and all Excel report, budget and forecast data can be linked to the cloud providing your company a “single version of the truth” that allows you to update a single source and have all reports update automatically upon refresh.

100% Excel Based

Jet Cube is a Microsoft Excel based add-in that allows your users to harness all their existing Excel knowledge to create fully customizable reports, dashboards, budgets and forecasting templates right from within Excel.

Security

Cloud data is fully encrypted and there is a robust data security model to define user groups and user roles with the ability to control which users can access which features and also completely control read/write access to the underlying data.

JET - Productivity Enhancing Excel Tools

Over 60 useful Excel tools  and 8 user-defined functions that make Excel far more efficient and easier to use when doing everyday tasks regardless of the industry of your company.

JCube – Budgeting, Forecasting and Reporting

  • True two-way communication between Excel and the Jet Cube Cloud server allowing you to not only pull data for reporting purposes but also write back data to the server for Budgets and Forecasts.
  • Cube based, multi-threaded calculation engine for fast reporting.
  • Quickly import data from any Microsoft SQL Server (including Microsoft Great Plains and Microsoft SL accounting systems) or import from any MS Access Database, Excel File or CSV file.
  • Manage all cube, dimensions, elements, external data connections, queries, mapping tables, template definitions, users, user roles and user groups directly from within Excel.
  • A powerful drill function to quickly see the details behind any number on your reports.
  • The ability to link the drill function to your underlying accounting system to see more details like who posted the accounting entry or if any vendor or client is associated with the entry.
  • A report exporter feature that allows creating static de-linked reports for distribution. For example, you can create a total company P&L and then use the report exporter to run that P&L for all departments.
  • The ability to create budgeting and forecast templates that allow you to create a single template for all companies and departments that customizes itself when the user logs in to show only their clients and employees.
  • Cube rules with over 60 functions to create complicated staffing models or rolling forecasts with actual overlays.
  • A full audit trail of everything that changes on the server, whether those changes are model related (new GL accounts, sub accounts, etc.) or financial cube value changes.

JET – Useful Excel Tools

  • My Folders – Create a custom collection of your most used folders to allow quick access to all your important Excel files.
  • Navigate – Show all open workbooks and sheets and quickly navigate between them. There are also tools for protecting/unprotecting, hiding/unhiding multiple sheets, reordering sheets, bulk renaming sheets and copying print settings across sheets.
  • Goto Cell – go to next unique cell, select identical cells or adjust selection to another column or row.
  • Select Cells – select by type, format and or cell value including unique and duplicate values.
  • Convert – a range of cells to text, number, value, change case, clean, trim, transpose or normalize.
  • Cell Styles – create custom cell styles that can be used in any workbook.
  • Define Name Manager – Quickly add, edit, delete hide/unhide or filter defined names.
  • Formula Viewer – View formulas in a tree structure with range values.
  • Multi-Cell Copy & Paste – Copy and paste non-adjacent multi-area selected cells.
  • Value Formulas – Value formulas by formula contents.
  • Get External Data – Create linked tables and pivot tables to external data sources using a powerful yet easy-to-use query editor.
  • Find Links – Find, list and/or break all external links showing each links parent sheet, parent object name and property, visible hidden status and link source.
  • Many other useful Excel tools that make using Excel more efficient and easier to use.

Managing Your Business Doesn’t Have to Be Hard.

Let Jet Cube help to make your financial reporting, budgeting and forecasting much more efficient while also ensuring more accurate and reliable information all while significantly lowering your cost.