RMD Reporting

RMD Reporting

The RMD information tool can be used to track Required Minimum Distributions that are done or need to be done for a client’s Account or Accounts. The system enables you to track this for both he client and the spouse. This is done by the system pulling basic data from the Accounts Tab and the client’s birthday.

  • To access this section in Junxure, open a contact record. Click on the Accounts/Assets Tab and then click on the Accounts Tab.

  • On the far right of the menu, click on the RMD Information button.

  • The RMD Information Form window opens. This will display any RMD information currently entered into Junxure by individual tax year, or an aggregate of all years. To edit data, click on the appropriate tax year tab and edit directly into the grid.

  • Note:
    Changes to data can only be made on the individual tax year tabs. The aggregate (all years) tab is Read Only.
  • To add a new tax year, use the Add New RMD button circled in red above. A wizard will open, similar to the one below. Use the Next button to move through the screens. The Year Information circled in blue indicates the tax year affected by the RMD.

  • The fields circled in green, Get Accounts from, will automatically pull in account numbers listed on the Accounts/Assets. If prior year RMD information has been entered, Junxure can populate many data fields from that year.
  • Follow the Wizard through to the Finish. Continue this process for all qualified accounts, the Client's accounts in the top grid, the Spouse's accounts in the bottom grid. A breakdown of data fields follows:
    • Year: Year RMD is taken.
    • Account Num: Listed on the Accounts Tab.
    • Account Type: Type of the Account. Example: IRA, 401(k).
    • RMD Taken: Check this box to indicate RMD has been satisfied for this tax year.
    • Account Value: The value of the account at 12/31 of the year. Junxure will put a value in this field if you imported from the accounts tab. If you are doing a Junxure Asset Import, then the value entered will be the most value of the most recent import. You can manually adjust the value for each account to reflect the 12/31 actual value.
    • Factor: RMD divisor factor from the IRS tables. You must manually enter this number. For help with RMD go to http://www.irs.gov/retirement/article/0,,id=96989,00.html.
    • Req RMD Amount Calculated: Amount of RMD needed in this tax year.
    • Notes: Notes regarding RMD, this field can be left blank.
    • Age: Age of the client in the tax year.
    • Bene Name: Name of the Beneficiary. This is a manual entry.
    • Bene Age: Age of the Beneficiary. This is a manual entry.
    • Final Dist Date: Date that the RMD was completed for this tax year.
    • Dist Amt Taken: Enter the distributions that have been taken for this account. Like the Req RMD Amount, you can aggregate this all on one account. By doing this, you will lose the ability to see this account by account.
    • Fed Tax Check: Indicates Federal Tax withholding.
    • State Tax Check: Indicates State Tax withholding.
    • Dist Method: Wire, Check, etc.
    • Auto Dist: Indicates if the client has automatic distributions from this account.
    • Auto Dist Freq: The Frequency of the auto distributions.
    • Liquidation Req: Indicates if assets need to be liquidated to create cash for the RMD distribution.
    • LOA: Check this box if there is a Letter of Authorization on file for the account. This field is pulled from the Accounts Tab.
Note: Junxure will not populate RMD factors, nor will Junxure calculate Required Minimum Distributions for you. This tab is for record-keeping purposes only!
    • Related Articles

    • Accounts/Assets Tab Overview

      The Accounts/Assets Tab in a contact record stores account information and underlying assets. This data can be inputted in the system in two ways: imported through Asset Imports or entered in the system manually. This tab stores assets such as ...
    • Top 10 Reasons to Use the Accounts/Assets Tab

      The Accounts/Assets tab gives you a place to store account and asset information for your clients. This area can be populated by using one of our portfolio management system interfaces. You can also add information to this area manually, entering ...
    • Accounts Tab

      The Account Tab is located under the Actions tab of a contact record. This tab displays account numbers and Actions related to the contact’s accounts. To view the Accounts tab: Open a contact record and click on the Actions tab. Then, click the ...
    • Reports List: RMD Information Report

      This report will generate a list of all RMD information on the Accounts/Assets Tab for any given tax year across all clients or filtered by Rules. Choose RMD Information Report from the Reports > Reports List > Financial menu. This will launch the ...
    • Adding Accounts

      The Accounts/Assets Tab in a contact record stores account information and underlying assets. This data can be entered in the system manually or through Asset imports such as Portfolio Center. This tab stores assets such as Stocks, Bonds and Mutual ...