MennÄ“ Software Solutions Mennē Software Solutions, LLC
Software that helps

Moneydance™ Ratios Extension

General Information

This extension to Moneydance allows you define financial ratios, and show them on your home page or generate a report. There are five standard ratios that are added the first time you install the extension:

License

This extension is licensed as freeware, and the source code is also released as open source. Please read the license for the extension.

The source code is released under the Apache 2.0 License

Download

In Moneydance, select Extensions → Manage Extensions... From the resulting list of extensions, click Install next to Ratios and continue through the installation process.

Immediately after the first time you install an extension, the Ratio widget may be hidden on the Home Page. To show the widget, either close and restart Moneydance, or go to Preferences (Ctrl+, or ⌘,) and edit the Home Page settings. New extensions are typically added to the bottom of the list on the right hand side, and this extension is entitled "Ratios". You can position the widget on your Home Page anywhere you like by moving it to the right or left side, and using the Up and Down buttons.

Click here to go to the Bitbucket website hosting source code (in Java) for this and some of the other Moneydance extensions.

Compatibility

The Ratios extension is tested to be compatible with Moneydance 2011 build 803 and newer.

Release Notes

Release notes can be read here.

Installation

Installation is automatic using the download from within Moneydance process described above.

The extension supports English, French, Italian, German, Spanish, Greek, Norwegian and Brazilian Portuguese locales. You can change locales in Moneydance File → Preferences

Support

Being freeware software, support is a bit limited. You may report bugs by sending an e-mail to 'bugs at mennesoft dot com'.

Usage

The Ratios extension allows you to define financial ratios and show them on your home page. You define the numerator and denominator of the ratio by selecting account balances or transactions.

You can generate a detailed report for each ratio, to find out how the system arrived at the value that is displayed.

All ratios are computed using the Base Currency defined in the file. Note that security accounts are not allowed to be selected as transactions or account balances. Their value is automatically computed as part of the parent investment account value (in the base currency).

Home Page View

Home Page View

The home page view displays each ratio, the most recently computed value, and a report icon for launching the report generator for that ratio.

Click on the date selector to choose one of the standard date ranges, or a custom date range. Note that if a standard date range is chosen, it will be remembered by the software when you close and restart Moneydance. If you select a custom date range, it will not be remembered and reverts back to the previously selected standard date range when you close and reopen Moneydance.

Click the Settings button to launch the settings dialog. You may also launch the dialog by electing Extensions → Ratios from the menu.

Click the report icon to the right of any of the listed ratios to launch a report that details how the extension arrived at the ratio shown.

There are five standard ratios that are automatically generated the first time you install the Ratios extension. These are given as examples to demonstrate how you would define financial ratios for your set of accounts. Because they are automatically generated, you will need to look at them and edit them for your specific situation to make sure they are accurate.

Loans

A quick note on loans: previous to build 1033, it was difficult to include both principal and interest in a ratio like Debt Service to Income because the principal was treated as a positive number, but the interest was treated as negative, so they offset each other. In build 1033, loan accounts are now treated as if they are expense categories for the purposes of sign. Potentially this is a breaking change to your ratios, if you were counting on the principal and interest to be of different sign. But this should make it a bit easier to create debt ratios that include interest "out of the box".

Another approach to grouping the principal and interest (and potentially escrow) in a ratio is to mark those transactions with a special tag (that you create and name anything you want), and then filter by that tag in the ratio settings. You can use the Find and Replace extension to locate the transaction splits you wish to group together, and then apply the special tag to all of them. Those transactions will then be found as a group.

Settings Window

Ratios Settings

These define the settings for the ratios in your file.

Click on the name of a ratio to edit the name.

Click the buttons below the list to perform actions on ratios.

The middle section contains the settings for the selected ratio.

At the bottom is a control for the number of digits beyond the decimal point to display for all ratios.

Click Ratios User Guide to go to this page.

Ratio Settings

Show as percent %
The ratio will be displayed as a percentage, otherwise it will be a numeric figure.
Always positive
The ratio will never be shown as a negative number (uses absolute value).

The numerator and the denominator each have the same settings. They are discussed here. Each are referred to as a "ratio part" below. A ratio part can be transaction based, where transactions are summed to form the amount, or ending account balance based, where the account balance at the end of the date range is used for the amount.

Label
Text that is displayed in the report associated with the ratio part.
Accounts
Select one or more accounts to which a transaction must belong, or an account for which a balance is to be calculated. There are three types of account selections:
  1. Required - the account must be referenced by the transaction for the transaction to be matched. This also determines the accounts for which an ending balance is calculated, for balance-type ratio parts.
  2. Allowed - The account can be referenced by a matching transaction, but it isn't required.
  3. Disallowed - If the account is referenced by a transaction, the transaction cannot match and is disqualified.
Transaction Match
Select how the number in the ratio part (numerator or denominator) is to be calculated. Here are the options:
Filter by Tag
Select the tags to require for the transaction to match. You may select a list of tags, any of which will match (Or) or a list of tags all of which must match (And). You may also select that the list must list exactly (Exact), which will allow you to screen out other tags. For example, let's say you have 3 tags defined as "One", "Two" and "Three". If you enter "One, Two" in the tags list and click Find, the system will match transactions as follows: Or will match any transaction with either "One" or "Two" or both, And will match any transaction that contains both "One" and "Two", including transactions that have all three tags. Activating Exact will only match transactions that have "One" and "Two" and no other tags.

If the list of tags to require is empty, but this criterion is still in use, then all transactions will match if Or is selected. If And is selected and the list is blank, then only transactions that have no tags will be matched.

Clicking All will select all defined tags, None will remove all tags from the selected list.

Account Selector

Clicking on either the Required or the Disallowed accounts in the account selection area of a ratio part will bring up the Select Accounts window.

Select Required in order to ensure that a transaction must interact with the account in order to match. Required accounts also have balances computed, when the Transaction Match setting is set to Beginning Balance, Average Balance, or Ending Balance.

Select Disallowed in order to prevent a transaction from matching if it interacts with the account.

Select Allowed to keep the account 'neutral' for transaction selection. A transaction can interact with the account and still match, but it is not required.

If you select Required, Allowed or Disallowed for an account type row, such as Bank or Investment, then all accounts of that type will be set to that value.

If you select Required, Allowed or Disallowed for a parent account, then all subaccounts be set to that value.

Click OK to save your settings, or Cancel to revert back to the previous settings.

Click Ratios User Guide to go to this page.

Click Reset to delete all your ratios and revert back to the original default ratios. You will be prompted to make sure you want to do that. You can still click Cancel after the reset to keep your current ratio definitions. This feature can be helpful if you change language settings and you want the default ratios in the new language.

Ratio Report

The Ratio report gives detailed information on a particular ratio. If the ratio result is an unexpected value, you can use the report to figure out why. The report can also serve as way to save a ratio result. The report can be printed (either to a printer or to file). Ratio reports cannot be memorized.

Click here for an example report, printed to PDF.

The first part of the report gives information on the numerator. The second part of the report details the denominator. The last part of the report summarizes the ratio calculation and lists the notes.

The numerator or denominator section will either list the transactions that make up the ratio part, or list the account balances if the ratio part has Transaction Match set to Ending Balance.

When account balances are listed, if the account uses a currency that is different from the base currency of the Moneydance file, then the original currency balance will be put in the Description column.