When reporting on a class basis with multiple files, there are times when a custom summation of individual classes needs to occur.
For example, let's say the user has (2) QB files with (3) classes each.
- QB File 1 - Zebra LLC
- QB File 2 - Elephant LLC
- QB File 3 - Monkey LLC
- QB File 2 - Zebra MSLP
- QB File 2 - Elephant MSLP
- QB File 3 - Monkey MSLP
Let's say in this example the user wants Zebra to be calculated all in one column, Elephant in another, and Monkey in a third. This is a custom report that would utilize the principles of both a static named cell report and a template (to review these principles - check out the links at the bottom of this article)
Before proceeding - build and map a SCOA
Column A will need to have all of the accounts named in each category, as well as use the %%accounts%% macro to ensure that it is a template. To do so, run a report from the Qvinci Gallery
- Find the correct type (Balance Sheet or P&L)
- Edit the template
- Click the blue Options button in the top left and change the Frequency to Entity, and the Date Range to Last Two Fiscal Years (to pull all the data over possible)
- Save As in My Reports
- Save As
- Compare against the accounts in each category in the Manage >SCOA
- Add %%accounts%% macro above every cell with 'Total'
- Check the columns to ensure that all of the entities are in the report
- All Entities must match in character and in alphanumeric order
- Delete all financial data
One column over from all the static columns, you can "name" the columns to begin your report.
- Add the cells in the named accounts under the appropriate headers
- Add the cells for the appropriate columns in each named cell and for the totals
- For custom ordering of accounts review this article: https://qvinci.zendesk.com/hc/en-us/articles/360000177966-Ordering-of-Accounts-in-a-Report
- Hide all static columns
- Highlight static columns
- Right click the letter of the first column
- Click Hide
- Save Template
- In the Options Section of the top of the report, select frequency as By Entity and Date Range as the desired Date Range. To change the date range at a later date you will manipulate this section