Navigator User Forums
  Investment Reports
  Balance Sheet - Asset Statement

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:   Balance Sheet - Asset Statement
LITTLE9481
Member
posted 10-16-2003 08:11 AM     Click Here to See the Profile for LITTLE9481   Click Here to Email LITTLE9481     Edit/Delete Message
For monthly reporting to the officers of a foundation, I need a report that has the following infomration for each security:

Date acquired
# of shares
cost basis
tax basis
market value

and the cash in the accounts. Now I need to import data from the Basis Balance Sheet and the Securities Portfolio Analysis into Excel and make adjustments for securities that have been sold.

IP: Logged

fni_support
Moderator
posted 10-20-2003 12:57 PM     Click Here to See the Profile for fni_support     Edit/Delete Message
Hello, thank you for posting your question.

Try running the following two reports:

  • Investment Portfolio Analysis
  • Current Portfolio Analysis

    Both reports show detailed security information including date acquired, number of shares, cost basis, and market value. In addition, both show the balances of Broker Cash Accounts. Therefore, any account with the format type of Broker Cash Account (44) will appear on these reports.

    For example, if you wanted a checking account to appear on this report you could change the format type of the checking account to Broker Cash Account instead of Bank Account. This will add the checking account to both of these reports. You can do this with many different accounts, just be sure to change the format types back to their original types to ensure that the accounts behave as intended during transaction entry.

    Please let me know if you have any questions. Thanks.

    --------------------------------------------
    George
    Financial Navigator Int’l

    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