SequelBasis is a free (GPL-licensed) cost basis and capital gain calculator for mutual funds. Cost Basis and capital gain are calculated using both the FIFO and Average Cost Basis Single Category methods. Entering mutual fund data and generating comprehensive reports is simple. U.S. citizens living abroad, and other U.S. taxpayers who own mutual funds denominated in a foreign currency, will appreciate the ease with which SequelBasis can convert all prices into the dollar reference currency for every purchase or redemption using the appropriate daily foreign exchange rate. Users with other reference currencies may also appreciate the flexibility and simplicity of SequelBasis.
To operate, SequelBasis requires PostgreSQL (a free multi-platform relational database management system that is easy to install). Sequelbasis has been tested on UNIX and GNU/Linux machines, but it should work on other operating systems as well. The conversion of the Federal Reserve foreign exchange data (for users with mutual funds which are not denominated in their reference currency), and customization of the pivot table views with SequelPivot, are both done in the Perl language, which is also available on many platforms. Features
- Straightforward data entry
- Report generation presenting FIFO cost basis, average cost basis, capital gain, total number of shares, total market value, and portfolio allocation.
- Report generation can be extended with SQL commands, or with SequelPivot, a pivot-table view generator.
- When shares are sold, purchases are automatically 'split' into smaller chunks if necessary.
- To calculate your cost basis, SequelBasis takes into consideration the following basis adjustments:
- Purchase Fees
- Redemption Fees
- Undistributed Capital Gain
- Return of Capital (Nontaxable Distributions)
- Fund data is stored in a group of simple, easy to manage tables. These tables, as well as report tables, can be exported in CSV format to a variety of other programs. Data for different funds is kept in the same tables, identified by a different fund ID.
- Funds in different currencies are managed easily.
- A fund in one currency can be copied and converted to a fund in another currency. All prices are converted using the daily exchange rate that was current on the transaction date, like tax laws of some countries may require.
- The exchange rate historical data can be entered by hand, or it can be downloaded from the U.S. Federal Reserve web site and converted automatically.
- SequelBasis can easily be extended to perform other calculations, if you know SQL.