The FinJinni Excel add-in can create formatted reports from Excel tables containing Query data. “Template” worksheets are used to create these reports. These template worksheets are read from a standard Excel workbook and can be customized to meet specific needs.

All of the currently-released standard templates are contained in the following workbook:

C:\Program Files (x86)\GypsyBI\FinJinni Professional\Documents\FinJinni Report Templates.xlsx

The first sheet in this workbook lists the reports that are currently available. If you have a specific need for an additional formatted report, please contact GypsyBI for assistance. 

Including account hierarchies

Normally, only the data shown in the query is placed in the formatted report. If you want, FinJinni can include the full account hierarchy, showing proper sums for parent accounts. To use this feature, add the Account_Hierarchy column to the query before formatting the report. FinJinni will automatically recognize this for most formatted reports and read the parent account names from this field.

If you only want the immediate parent of child accounts, use the Account_Parent column instead.

A query that has a name ending with “w/ Account_Hierarchy” already has that column added.

Modifying report templates

When the “Format as Report” button is pressed while on a Query worksheet, FinJinni merges the query worksheet into the appropriate template. On the template worksheet, all cells that start with a ‘@’ are directives to FinJinni. Please do not modify those cells. All other text and formatting on the template is preserved when it is copied to the formatted report worksheet. You can change any of the text and formatting, such as fonts, borders, and column widths.

Tip: If you want a border before the total line, do not put borders on the bottom of cells that FinJinni replaces with account information, since those are copied multiple times. Instead, put the border on the top of the cell containing the total.

In order to modify the FinJinni templates, all you need to do is to create or modify an Excel workbook. Custom templates that you create must be placed in the following workbook (create it if it does not already exist):

[documents]\My Templates\FinJinni\Report Templates.xlsx

Where “[documents]” is your normal documents folder.

You can copy individual worksheets from the standard file, FinJinni Report Templates.xlsx, to your custom file and modify them there. Please do not modify the standard file.

All query worksheets are matched to template worksheets using a unique short character identifier, such as ‘BSSumRange”. You can locate the appropriate template to modify by first finding this identifier in the document:

C:\Program Files (x86)\GypsyBI\FinJinni Professional\ Documents \FinJinni Query Identifiers.pdf

Match this to the value on the first row of the template workbook which looks like this:

@id:bssumrange.1

The numeric suffix, such as “.1” is used to uniquely identify a template when multiple templates can be used for the same query. You will be given a choice when you are formatting the report.

If you need assistance, please contact Gypsy BI support.