i have been trying to create a report that will group specified subsets of general ledger accounts by various Companies. for instance, i need to group all the Cash accounts together while still showing individual totals for each account and then set up another group that will give me totals for 3 other specified group of accounts. with these accounts however, i only need the grand total of all the accounts in the group. after these two groups i need a subtotal of both groups totals. Finally i need another specified group as just a total that i can subtract from the subtotal of the two previous groups.
basically it would look like this:
Company 1
Cash Account 1 500 (individual account)
Cash Account 2 450 (individual account)
Cash Account 3 200 (individual account)
Total Cash 1150
Accts Receivable 1000 (total of multiple accounts)
Allow. Doubtful Accts 500 (total of multiple accounts)
Deferred Income 2000 (total of multiple accounts)
Total A/R 3500
Total Cash and A/R 4650
Company Payables 4000 (total range of account)
Net Balance 650
Company 2
Cash Account 1 500 (individual account)
Cash Account 2 450 (individual account)
Cash Account 3 200 (individual account)
Total Cash 1150
Accts Receivable 1000 (total of multiple accounts)
Allow. Doubtful Accts 500 (total of multiple accounts)
Deferred Income 2000 (total of multiple accounts)
Total A/R 3500
Total Cash and A/R 4650
Company Payables 4000 (total range of account)
Net Balance 650
i have used the specified grouping option and am able to set up the individual subgroupings listed above, but since they are all in one group, i can't get them to show individual accounts totals vs subgroup totals (ie: A/R, Allow Doubtful Accts and Deferred Income). also i can't get it to subtotal the Cash and the A/R accounts and then subtract out the Company payables total.
i've tried creating additional specified groups for the A/R accounts and then the Company Payables but can't figure out how to get them into the report in the right place and under the right company. i have also tried to use sub-reports but that only inserts all companies info under each company in the main report. and i have tried using formulas as well.
i am at a total loss as to how best to do this though i'm sure there must be a way.
any help or direction would be greatly appreciated.
IP Logged
