Topic Options
#26241 - 02/17/11 10:36 AM Financial Reporter
SSteffler Offline
Stranger

Registered: 06/23/10
Posts: 4
Loc: Canada
I have set up my statements in the financial reporter using account groups and further allocated by ranges. For example:
Income statement - Expenses - Salaries & Benefits. When I open my Income Statement I see the Expense heading and the related ranges that I set up below. I can either expand to individual accounts or collapse to the "Salaries & Benefits" range. This has worked wonderfully until now because I have had one salaries account and one benefits account per department. I have now have had to further subdivide both my salaries and my benefits into even more account codes which I can group into the ranges previously set this is not the problem. The problem is that when I print my statements and expand to see the details I cannot pool all of my new multiple salaries or multiple benefits accounts into a "salaries number" and a "benefits number" all I can do is to now present all of the multiple accounts which is not what management wants to see and is skewing the budget figures that are not broken down to such detail. It seems like an all or nothing senario. Can I group a set of accounts to appear as a pool in the expanded statement format while not pooling others as the indivdual account details are required for some but not all of the aspects within the same statement. Confusing I know but it would be a great help to maintain my GL detail without messing with management's required reporting. Ie: reporting salaries as "salaries" and not as "part-time, full-time, casual etc". OR is there a way to create a total line on the expanded statement and hide the individual accounts within a range within a group?

Top
#26245 - 02/17/11 11:30 AM Re: Financial Reporter [Re: SSteffler]
Softrak Support Online   happy

Adagio Action Team

Registered: 03/09/99
Posts: 11545
Loc: Vancouver, BC Canada
Hi SSteffler,

If you do not want accounts within a particular range to Expand to one row for each account, you can choose to delete the .Range cell value in Column A for that row. Thus when you Expand a sheet, that row will remain consolidated and only show the total for all accounts within the range, and not the account breakdown.

If you want some account range(s) to Expand and show details, and other account range(s) to remain summarized, you can do tht do. You have to enter the accounts that you want to see detail for on one row, and the accounts that you want to remain summarized on a separate row. On the row that you want to show individual account on Expand, ensure that .Range is in the cell on column A, and for the summarized-only row, ensure that the cell in column A is blank.

Perhaps check out the Financial Reporter webinars for particulars on how the structure of statement design works.

As finanical statement requirements are often unique to the company, you may want to be in touch with your Adagio consultant to assist, as seeing and working with the statement will be easier than attempting to describe specifics on an online forum.
_________________________
Regards,
Softrak Tech Support

Top


Moderator:  Softrak Support 
Who's Online
1 registered (Softrak Support), 49 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14465 Topics
70655 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30