GP Optimizer Winter 2013: Managing Long-Term Investment Assets in Microsoft Dynamics GP

Written By ICAN Software Solutions for  GP
Optimizer Winter 2013  Edition by Rockton Software

Microsoft Dynamics GP users who need to track holdings of long-term investment assets such as stocks, bonds, collateralized securities, gold, land, etc. know the difficulty of properly accounting for such holdings in accordance with Generally Accepted Accounting Principles (GAAP).

In many cases, organizations have been tracking such assets within complicated Excel spreadsheets manually maintained by accounting staff.  A normal scenario is one where all purchases and sales are manually added to the worksheet and where staff regularly have to manually update the current market value of the investment holdings.  We met with one organization whose usual procedure was to spend hours each evening looking up each investment’s market value on Yahoo Finance and copying/pasting that value into each row of the spreadsheet.  They would also spend days at the close of each month trying to reconcile the spreadsheet and identify the inevitable human errors introduced by the manual processes of maintaining the spreadsheet.

Investment Assets for Microsoft Dynamics GP provided them with a full sub-ledger module in Dynamics GP for tracking buys/sells of investment holding within different trading accounts.  And with one click of a button, Investment Assets downloads market values off the internet for all of the thousands of investments within their system.  It allows them to import investment masters, buy/sell transactions, investment-related cash transactions like dividends and interest, and market values provided by their investment broker in a file format.

Other organizations spend time and effort tracking interest accruals and amortization of discount/premium on amortizable investments like bonds.  Investment Assets automates interest accruals for interest-bearing investments and also automates the amortization of discount/premium of amortizable investments.

Family Office organizations that track investments for the members of high net worth families need to be able to track investments within trading accounts by the owners/beneficiaries of those trading accounts.  Investment Assets tracks owner percentage of holdings, so that a report can be generated for each family member showing their percentage of the market value of investment holdings in accounts that they have a percentage ownership within.

Investment Assets is just one of many great products from ICAN Software Solutions. We make solutions that turn hours into minutes…

We Work Late So You Won’t Have To!

Want more information? View Investment Assets Demo!

Follow ICAN Software - Like ICAN Software - Email ICAN Software

Download GP Optimizer Winter 2013 Edition by clicking here!