Back |
Home > Advisor View > Reports > Dynamic and PDF Reports > Performance Calculations and Transaction Display > See Cash-Impacting Transactions
|
See Cash-Impacting Transactions
TThe Money Security grouping option on the Transactions report allows you to track the impact of every transaction on an account's cash balance and to see exactly how an account arrived at its current cash balance.
In the report, the Cash Balance column starts with the Cash Beginning Balance, which is the amount of cash available at the beginning of the period. Transactions are added or subtracted from the beginning balance, totaling to the Cash Ending Balance. The Cash Ending Balance matches the amount of cash available at the end of day on the final day of your selected date period.
When running this report, you will see three unique columns:
Money Security: Shows the symbol of the security (for example, CASH or the symbol for sweep). This is also available as a column on the Account Transaction bulk report.
Cash Impact: Shows whether the transaction increases or decreases the amount of cash in the account. These values are either positive or negative. This column is only available when sorting by Money Security.
Cash Balance: Shows the Beginning balance, plus or minus the Cash Impact amounts. This column is only available when sorting by Money Security.
To find this new view:
In Reports, click on Transactions report.
Click Edit.
Under Group by, select Money Security.
As in the standard Transactions report, you can still choose to exclude or include certain securities in this report. However, the only securities you will actually see included or excluded will be cash or money securities.
Since the Cash Balance columns sum when viewing this report, dynamic sorting is disabled. Columns automatically sort by date, and then by activity type alphabetically.
Click Save.
The Account Transactions bulk report gives you access to the Money Security column data in bulk so you can do deeper analysis of cash movement with the bulk report.
To export a money security data in bulk:
Create an Account Transactions bulk report. For steps to create a bulk report, see Bulk Reports.
In Available/Selected columns, choose and add Money Security.
Click Save.
Run the bulk report. For more information, see Bulk Reports.