Navigator User Forums
  Transaction Reports
  Transactions by Account report headings and grouping

Post New Topic  Post A Reply
profile | register | preferences | faq | search

UBBFriend: Email This Page to Someone! next newest topic | next oldest topic
Author Topic:   Transactions by Account report headings and grouping
FN_User
Member
posted 10-10-2007 08:53 AM     Click Here to See the Profile for FN_User     Edit/Delete Message
When I run a Transactions by Account report for an income or expense account, the transactions are grouped by account, with a heading for each group showing from where the transaction came.
But when I run a Transactions by Account report for an asset or liability, the only grouping/heading is for the asset or liability itself. There is no indication what the account on the other side of the transaction is. Is there a report that groups the transaction by account?
To confuse things further, sometimes a Transactions by the account they came from. Why this inconsistency?

IP: Logged

David
Administrator
posted 10-10-2007 08:53 AM     Click Here to See the Profile for David     Edit/Delete Message
Thanks for the questions.

Yes, it would be helpful to have a Transactions by Account report for an asset or liability that is grouped by account, with a heading for each group. But there is no such report. Part of the reason is that each transaction can be a multiple distribution, so a single transaction can hit many accounts. To see all the accounts affected, run the Transactions with Distributions report. Unfortunately, that report does not group or total by account.

As you noticed, sometimes a Transactions by Account report for an asset or liability will grouped by some accounts. That happens when you have a transfer of funds between two assets or an asset and a liability, for instance, paying a credit card. This is the same situation for which we recommend you use a transfer clearing account (TCA). Note that whether you use a TCA or not, the report correctly shows the destination account, not the TCA. If you don’t use TCA, the transaction will only show in one account’s transaction screen, but will show in both account’s Transactions by Account report.

You can turn off this grouping by accounts feature by clearing the check mark next to Memos on the Trans by Account Report Options screen. It is strange that the Memos checkbox has anything to do with grouping, but that’s the way it is.

- David
FNI Technical Support

[This message has been edited by David (edited 10-10-2007).]

IP: Logged

All times are PT (US)

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply
Hop to:

Contact Us | Home

Copyright 2010 Financial Navigator, Inc.


Ultimate Bulletin Board 5.47e