Qvinci's Report Styler allows Admins, Leaders and Managers to create templated reports (for P&L, Balance Sheet and CashFlow) which can then dynamically update across all clients/companies/entities in the account. The purpose of this feature is to save accounting professionals or corporate users time by allowing them to create standard reports which can be styled and customized, yet still utilized across many clients/companies/entities. The "Columns Chooser" feature allows users on the Qvinci Enterprise subscription to easily create multi period reports.
Choose a Jumpstart Template
- Visit the Reports & Libraries > My Reports > Qvinci Gallery.
- Peruse the available templates and find one that talks about multiple periods, ie: "Last Mo vs Prev Mo", etc. (Note that you're able to custom select the new date range).
- Click the "Edit" button on the right, and upon opening choose "Save As".
- Save the template with a custom name. The saved version will then appear under the "My Reports" tab, verses Qvinci Gallery moving forward.
- The newly saved report template will automatically open upon save-as.
Customize the Template
- Notice that macros fill the template. This is what makes it a template, verses hard-coded report. Macros are very important in templates as they drive the datasets.
- All macros in the Chart of Accounts should remain. For example, "Income" and "Total Income" have an accounts macro between them. This allows the current client/company income accounts to dynamicall insert between the header and total rows upon download or preview.
- Insert rows at the top and create a title for the template. (View this article to learn how to create contextual titles with macros.)
- Perform other styling edits as desired, such as font changes, font sizes, alignment, etc.
- Once styled then add a macro to drive the financial data columns. A columns macro allows users to set the financial data and frequency desired in the report. The columns macro(s) should be inserted in the first column where you would like the first financial data column to appear. The Column Chooser macro should always appear in a cell above where the first account in the chart of accounts appears.
- To change a date range simply click into the cell where the first date range exists and open the Column Chooser to insert a new date range or frequency.
- For a multi period report the user should insert one macro from the Columns Chooser into the desired column (such as Frequency = By Month, Date = Last Month) and then in the next column add another macro (such as Frequency = By Month, Date = Last Month, plus an offset of -12). This combination will yeild "Last Month" data in the first column, and the same month from the prior year in the next column.
- A user could also add a Totals column via the Column Chooser in another column.
- Be sure to click Save to save all edits to this template.
- The template might look something like this:
12. This new template may be downloaded from the grid screen by using the "Export" icon (second from the left in the grid control panel) to be exported to PDF or Excel or may be accessed in the future from the Libraries > Report Library tab. Data updates into a report template upon download or by clicking the "Refresh" button.
13. The new template may also be added to a Package on the Libraries > Package Library tab so that it becomes part of a reporting package which might contain other template reports and/or documents.
NOTE: Report templates may contain up to 1,000 rows and 50 columns. If you have reached the maximum amount and you get an error when attempting to add a row or column, scroll over until you have blank rows or columns. Highlight as many blank rows or columns that you need to add, right-click on them and click "Delete". You should then be able to insert more.