Print Investment Trial Balance
These steps explain how to produce an Investment Trial Balance, which is useful when balancing investments.
-
Launch Tool #408 Investment Trial Balance Report.
-
Optionally, use the Customized Report Heading.
-
Depending on your timing of payments, utilize the Customized Report Heading to define the actual month you are processing. For example, if you are balancing for May but the Process date on the report you pull is June (since May investments were processed in June and effective dated for May), type “May Investment Balancing” in the field for ease of balancing and reconcilement in the future.
-
-
Enter a Corp ID or leave blank to pull all.
-
Select the Investment status. You can pull only active investments, only closed investments, or both.
-
Enter the Process date. The trial balance will be pulled for activity processed during this month.
-
NOTE: The Process date for generating an Investment Trial Balance is dependent on the timing of all your monthly activity. If you process adjustments, payments, maturities, or otherwise in June with an effective date of May, your trial balance Process date will need to be June. If you process all your adjustments, payments, maturities or otherwise all in the current month, your Process date for the report will be the current month. Trial balances don’t take effective dating into account, so you will see only the activity processed up to the last day of the selected month.
-
-
Optionally, filter the report by selecting Investment type(s), FASB code(s), and/or Broker code(s).
-
Select the Primary sort option as Investment type, FASB code, or Maturity date.
-
Optionally, select a Secondary sort option.
-
Choose to Print either a Detail report, Summary report, or Detail & summary report.
-
Optionally, filter the report by selecting specific G/Ls.
-
Optionally, filter the report by inputting date ranges for the Maturity date, Settlement date, and/or Purchase date.
-
Select the Printer.
-
Use the forward arrow to produce the report.