Alias for Subgroups?

Question

Is there a way to create some kind of alias/attribute/etc. to group certain subaccounts (which we use for departments) together, without fundamentally changing the naming/numbering convention of the subaccounts?

For example,
000000 Main; 000100 General Corporate; 000200 Sales; 000300 IT
For this example, I would want to pull Subs 000000-000300, but not count 000200 (e.g., Corporate Overhead reporting).

Aside from creating a hidden row that sums 000000-000300 and subtracting a hidden row that only contains 000200, is there a way to create some kind of alias (e.g., CO) to assign to 000000, 000100, and 000300, which I can then use in financial reporting?

Laura02 · Accepted Answer

Hello Don,It seems like you are asking for a Subaccount Class for Subaccounts profile screen, and the new Subaccount Class field (grouping) could be used in Financial Reporting, similarly to the existing Account Class from Chart of Accounts. I like your idea, and I think you should add it to the Ideas section of this Community!In the meantime, we can filter the GL lines of Row Sets with multiple Subaccounts in the Start Sub, separated by Commas, as in this example:An Account has figures posted to three subaccounts, but I only want to include the first and third in my Balance Sheet report.Finance → Detailed Trial BalanceModify Data Source → Start Sub as follows, on the Retained Earnings line of Balance Sheet Row Set:Balance Sheet Row Set, RETEARN Data Source expandedResults on Balance Sheet Report: RE amount includes first and third subaccounts only & this figure does not match total of all three subaccounts from above Detailed Trial Balance (it’s exactly $5000 less).

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded