| Tips for Getting Started with BizInsight |
| Expandable's replacement for FRx is being installed at new customer implementations and is now available to customers ready to migrate to Excel-based financial reporting. |
| As with most software applications there are a few critical guidelines that represent the keys to success with BizInsight. Expandable's Patti Hales has assembled insightful tips to help you get started on the right foot when digging into Expandable's new financial reporting tool. |
- Do not have any spreadsheets open when enabling BizInsight explorer. If any spreadsheets are open, close them, close Excel and then re-launch Excel. Failure to do so could result in a return of an error code of #REPORTSERVER or #VALUE instead of the expected function return of financial data
|
- The templates are found in the BizContent folder:
|
 |
- Password for templates = esi
|
- The functions you will use most often are MTDNET & YTDENDBAL along with information functions.
|
- The company ID must be a text field, i.e. ‘00
|
- Use F4 to anchor cells (making them an absolute or mixed cell). By default, a cell reference is relative (relative reference: In a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to. If you copy the formula, the reference automatically adjusts. A relative reference takes the form A1.). For example, when you refer to cell A2 from cell C2, you are actually referring to a cell that is two columns to the left (C minus A), and in the same row (2). A formula that contains a relative cell reference changes as you copy it from one cell to another. As an example, if you copy the formula =A2+B2 from cell C2 to D2, the formula in D2 adjusts downward by one row and becomes =A3+B3. If you want to maintain the original cell reference in this example when you copy it, you make the cell reference absolute (absolute cell reference: In a formula, the exact address of a cell, regardless of the position of the cell that contains the formula.
An absolute cell reference takes the form $A$1.) by preceding the columns (A and B) and row (2) with a dollar sign ($). Then, when you copy the formula (=$A$2+$B$2) from C2 to D2, the formula stays exactly the same.
In less frequent cases, you may want to make a cell reference "mixed" by preceding either the column or the row value with a dollar sign to "lock" either the column or the row (for example, $A2 or B$3).
|
- Do not name a range of cells the same name as one of the BizInsight functions. For example, if you name a range MTDNET the BizNet MTDNET function will not work properly.
|
- Please be aware that all data returned in the analysis sets are dynamic. For example, if you use the Chart of Accounts analysis set to create your balance sheet and a new asset account is added in the Chart of Accounts editor, the next time you run your balance sheet the analysis set will be updated, which may shift cells used to create your report resulting in the return of erroneous data. There may be times in which you will want to use the analysis sets to create a report but for the most part Expandable recommends that these sets be used for ad hoc analysis purposes only.
|
 |
Download the Financial Reporting with BizNet datasheet |
 |
 |
|
