Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

End of month cash balance recon report

Questions on using, creating, or understanding data in Fund Manager reports.

Postby marathon » Thu May 07, 2015 10:02 pm

How to generate the month end cash balance by month for a time period e.g. qtr, year?

breakdown by currency and sub portfolio across selected portfolios

purpose is to have the cash balances to tally with the statements to reconcile that the dividend and coupon distributions are correctly feeding
Last edited by marathon on Fri May 08, 2015 8:47 am, edited 1 time in total.
marathon
 
Posts: 32
Joined: Thu May 07, 2015 11:44 am

Postby Mark » Fri May 08, 2015 8:08 am

Hi marathon,

How to generate the month end cash balance by month for a time period e.g. qtr, year?


Use a "Monthly Performance" report and select "Value" as the performance metric. Turn on a filter, to only show investment type of cash.

breakdown by currency and sub portfolio across selected portfolios


You can use a Portfolio Value report and "List By" currency. You can also optionally sub-total by sub-portfolio.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11674
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Reports

Who is online

Users browsing this forum: No registered users and 29 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2025 Beiley Software, Inc. All rights reserved.