Money Manager Ex (MMEX) 是一款个人资金管理系统,它可用来记录开支、资金结存和分析消费习惯。 MMEX简单易用,基于此,即使是对财务和簿记了解不多的用户,也可以成功地打理资金。 通过模拟真实的财务世界,MMEX帮助用户维持个人理财。 Money Manager EX 软件,开放源码, 并免费使用。
MMEX 的主要目标是简化跟踪财务信息的过程,在一个易于使用的程序中,可以根据需要定期使用,帮助我们跟踪我们的钱从哪里来,更重要的是,我们的钱去哪里了, 以便为我们的未来做出更好的财务决策。
将 Money Manager Ex 视为一个计算机支票簿,它使您能够平衡您的账户、组织、管理和生成财务报告。
这也是了解您的财务价值的好方法。
本手册的目的是为您(用户)提供一些使用 MMEX 的基本说明。 本说明手册将随着程序的发展而发展。 因此,请检查每次更新时的帮助系统,看看有哪些新内容以及如何更好地利用 MMEX。
在财务上变得有组织需要一定程度的纪律。 当我们不清楚我们得到多少钱时,财务管理会变得复杂,将收入视为收入,而不是支出,即我们花了多少钱。
当我们的现金流因您的支出超过您的收入而受到限制时,通常会产生债务。 然后我们需要借钱来维持我们的现金流,使我们能够购买我们需要的物品。
改善财务状况的第一步是保持良好的财务记录。 只有当我们清楚地了解我们的资金去向时,我们才能在现金流紧张时做出明智的决定,决定在何处削减开支。 如果我们确实需要借钱,我们也可以更好地管理债务。
您是否意识到您去年花了 600 美元购买 DVD 电影? 你看了他们多少次? 您现在认为 600 美元是否会更好地用于昨天出现的汽车意外维护? 当然,对于您应该如何花钱,没有正确或错误的答案。 毕竟,是您赚到了这笔钱,并有权以您认为合适的方式花钱。 但是你总是可以让你的钱为你更努力地工作。
这就是个人理财软件的用武之地。 它们帮助您对财务数据进行切片/切块,让您更好地了解正在发生的事情。 永远记住,软件只能与它必须处理的数据一样好。 垃圾进垃圾出。 但是,如果您已经开始考虑使用个人理财软件,那么您就可以很好地利用每一美元。
阅读有关如何与 Money Manager Ex 合作的信息。
Money Manager EX 模拟现实世界以帮助我们维持个人财务状况。
通常,我们会从某人那里收取我们提供的服务或我们销售的产品的钱。 这被视为我们系统的收入或存款。 当我们购买商品或使用服务时,我们花费的钱被视为我们系统的费用或提款。 在 MMEX 中,给我们钱或收钱的人被视为系统的收款人。
由于我们希望不会花光我们收到的所有钱,因此我们显然需要一个地方来存放我们的钱。 这通常是一些金融机构,或几个机构或在我们的口袋里。 MMEX 将这些地点标记为帐户。
当我们花钱或收到钱时,我们将其视为交易,我们收入或支出的原因是我们的类别 有时我们需要将钱从一个地方转移到另一个地方,例如从 ATM 取款,这种类型的交易称为转账。
这可以简化如下图所示:
要考虑的另一件重要事情是我们用于执行交易的货币。
为了跟踪所有这些事情,MMEX 使用一个数据库来存储所有这些实体并将其连接在一起。
MMEX 生成的数据库,称为.mmb
文件,成为您维护的重要文件。 根据情况,可以采用加密等安全功能,被识别为 。 这是我们可以为数据库附加密码的地方,每次打开 MMEX 时都需要密码。
.emb
文件
与任何计算机系统一样,我们产生的数据对我们很重要,因此需要防止系统故障。 MMEX 有一个备份系统,它可以在打开数据库时生成一个带日期的副本,和/或在检测到更改时生成一个带日期的数据库副本。 在系统初始化和/或检测到系统更改以及系统关闭时,每个数据库最多可维护 4 个备份。
.mmb
或 .emb
数据库文件。.mmb
或 .emb
数据库文件。
当 MMEX 最初启动时,它将尝试加载上次打开的数据库。 如果不存在数据库,则向用户提供打开现有数据库或创建新数据库的选项。
如果您需要创建一个新的数据库文件,请从菜单中选择文件 → 新建数据库。
这将提示您在您指定的位置为 .mmb
数据库文件指定一个新名称。 您的新数据库文件现已创建,新建数据库向导将显示以帮助您初始化新数据库并协助创建您的第一个帐户。
新建数据库向导将要求您设置基础货币和用户名。
MMEX 带有一组您可以使用的默认货币,以对应您所在国家/地区的货币设置。 然后,新帐户将使用此基础货币设置作为默认设置。 这允许来自不同国家的账户反映基础货币的价值。
为了帮助确定数据库的用途,需要一个用户名。 这是可选的,因为它仅用作主页和报告中的标题。
如果需要,可以稍后通过选择菜单更改这两个设置:工具 → 选项。
数据库名称将显示在标题栏上,有助于提醒您打开了哪个数据库文件。
新的
.mmb
数据库文件未加密。
创建新数据库文件时,系统会自动要求您创建新帐户。
要手动创建新帐户,请从菜单中选择帐户 → 新建帐户。
这将打开添加帐户向导。 该向导将协助收集帐户名称和类型的重要信息。 账户类型不可更改,但可在编辑账户信息时更改名称。
帐户名称:这是必填字段。 建议为您的帐户命名唯一且与现实世界帐户相关的名称。 示例:在花旗银行,我们有一个储蓄账户和一个信用卡 Visa 账户。 您可以将您的帐户命名为 CitiBank Savings
和 Citibank Visa
。
账户类型:MMEX 支持多种账户类型。
要正确设置帐户,您应该拥有要添加到 MMEX 的帐户的余额信息。 您可以从最近的银行、投资和信用卡对帐单中获取此信息。 要跟踪有关此帐户的其他信息,您可以选择输入您的帐户详细信息,例如帐号、持有地址、网站、联系信息和访问信息。 您可以在备注字段中输入有关帐户的其他备注。
大多数帐户都有某种余额,例如在信用卡帐户中,您的当前余额为 2304.67 美元,您可以将该值放在初始余额字段中。 展望未来,您只需要在您拥有余额时添加该日期之后的交易。
帐户状态可以设置为打开或关闭。 关闭的帐户就是这样。 他们不再活跃。 设置此状态只是在树视图导航窗格中整理视图的一种方法。 通过更改菜单、工具 →选项来进行永久设置。您可以隐藏关闭的帐户。 请参阅导航树提示。
货币:这最初设置为创建数据库时最初设置的数据库基础货币设置。 您可以设置与此帐户关联的货币,并且可以与基础货币不同。
可以使用菜单更改货币的汇率:工具 → 整理货币。
示例:您使用美元居住在美国,并拥有使用欧元的意大利银行账户。 您的大部分帐户都是美元。 您意大利银行账户的真实价值是多少? 通过更改意大利欧元的汇率,您可以获得正确的帐户价值。
您还可以将帐户标记为收藏帐户>。 这再次用于更改导航栏中可见的帐户。 请参阅导航树提示。
我们有一个 1250 美元的储蓄账户,一个 500 美元的支票账户,一张 250 美元的万事达卡,一张 475 美元的 Visa 卡,230,965 美元的房屋抵押贷款和一个教育基金,用于未来送孩子上大学,目前赚取 5000 美元的利息。
我们将设立以下账户:
帐户类型 | 帐户名称 | 初始金额 |
---|---|---|
支票/储蓄 | 储蓄 | $1,250.00 |
支票 | $500.00 | |
万事达卡 | -$250.00 | |
Visa 信用卡 | -$475.00 | |
定期账户 | 住房抵押权 | -$230,965.00 |
教育基金 | $5,000.00 |
在主页上,银行账户的余额为 1025 美元,定期账户的余额为 -225,965 美元
当通过转账交易从您的储蓄账户向万事达卡付款时,主页上的余额保持不变。 当您从储蓄中支付房屋抵押贷款时,主页上的余额将反映支付金额。 现在,您可以确定每天拥有的金额。 还可以使用经常性交易从您的储蓄账户设置定期付款到您的抵押账户。
创建帐户后,您可以通过以下方式编辑任何帐户信息字段:
这将打开帐户信息对话框,可以在其中更改必填字段。
编辑帐户详细信息,然后使用 确定 按钮保存帐户信息。
一旦您创建了一个新账户,并从导航树或主页中选择了所需的账户,显示的账户可以添加新的交易,如下所示:
对于新交易,将出现此对话框。 使用 对话框来输入以下详细信息:
Editing existing transactions can be achieved in a number of ways:
Any of these actions will open the transaction dialog box containing the details of the selected transaction. Make the changes and click OK to save the changes.
Transactions can be filtered by either fixed filters or, by using the Transaction Filter in the Account View. This will allow the user to limit the visible transactions to those defined by the appropriate filter. These filtered transactions can then be easily selected and individually modified.
These visible transactions can also be deleted in bulk if so desired.
In MMEX, reconciled and unreconciled transactions are shown by different icons. When bank details are not checked against a bank statement, the user can select to set the default as Reconciled when creating transactions in the Options settings.
Some transactions might have some issues that you want to follow up on. Mark these as with status of flag for followup. This is indicated in MMEX with a different icon.
The user can specify 7 custom colors in the color section of the options dialog. In the checking/term panel, pressing Ctrl+1 through Ctrl+7 sets the transaction entry color to the user specified custom color. Pressing Ctrl+0 will change it back to the mmex default transaction color.
MMEX can be used in many countries, MMEX need to consider the currency for the country of use. When creating a new database, the Base Currency is set to the currency used in the user's country. If the user's currency setting is not listed in the default currencies, the user can create their own currency Listing.
MMEX allows us to work with more than one currency. Each account has its own currency setting, and will default to the base currency. When we set accounts with different currencies, the transactions we create in these accounts will reflect the currency of the account.
You can manage Currencies by using the menu item: Tools → Organize Currency.
Add a new Currency:
当使用一种以上的货币时,转换为
需要设置基本费率。 这将使
货币的值能够正确反映基率的值。
要允许 自动更新 货币,货币符号需要
设置为所使用的特定货币。
类 说明支出或收到 收入的原因。
一个类别一般用来记录收入或支出。 因为 MMEX 允许我们在账户之间转账,所以 还建议使用类别来记录转账。 这将 使我们能够确定出于 个特定原因正在转移什么钱,例如偿还贷款。 这不会 在整体情况下被视为收入或支出。 使用相同的 类收入和支出会打乱余额 个数字。
示例:如果我们想记录一辆车运行的价值,我们 会设置以下内容:
前 4 个子类别用于记录费用。 如果我们是 出于任何原因报销燃料费用,我们需要使用燃料 作为收入子类别报销。 这将使我们能够 确定我们在燃料上花费的正确金额来运行 车。 当我们使用预算时,这种情况将变得更加明显。
添加新交易时,我们可以使用更多类别 来记录交易。 这被称为 拆分类别。
总拆分类别的交易要么是提款要么 是存款。 Although the categories within the split, need to reflect the overall transaction type, each category can be classified as a withdrawal or deposit within the split.
Split categories can easily be viewed for a transaction by using a pop-up menu selection when a split category entry exists.
You can manage Categories by using the menu item: Tools → Organize Categories. Once the category dialog opens, you can add new categories and subcategories.
To Add a new Category:
To Add a new Subcategory:
You can also change the names by selecting the category/subcategory in the list, modify the name in the text box, then use the Edit button. Use a similar action to delete the category/subcategory in the list.
Ensure that no transactions use this category/subcategory combination. This can be done by:
This would then make the category free so it can then be deleted.
Payees are the people or institutions that give us money, or the people or institutions who we pay, for our goods and services.
You can manage Payees by using the menu item: Tools → Organize Payees.
Once the payee dialog opens you can add new payees, edit or delete existing payees.
To Add a new Payee:
You can also select the payee in the list, then use the Edit or Delete button to perform the required action.
To delete a payee, ensure that no transactions use this payee. This can be done by:
This would then make the payee free so it can then be deleted.
MMEX has a light WebApp that can be installed on every PHP webserver like NAS, shared hosting or other PHP local installation.
You can download all needed files from WebApp project page.
To start-up WebApp you only have to:
htaccess.txt
in .htaccess
(on Windows you need to do
it from CMD
and rename command)
PDO_SQLite
if neededThen simply open your browser to the folder URL, fill first settings and insert correct URL and GUID in MMEX settings (import/export tab).
Now at every start-up MMEX will contact WebApp for new transaction that will be downloaded and imported in desktop database.
All main transaction linked settings will be automatically synced to WebApp, in this way you can have all your account and payees ready to use inserting new transaction.
Quicken Interchange Format (QIF) is an open specification for reading and writing financial data to media (i.e. files). A QIF file typically has the following structure:
!Type:type identifier string [single character line code]Literal String Data ... ^ [single character line code]Literal String Data ... ^
Each record ends with a ^ (caret).
See example QIF transaction:
!Type:Bank Header
D6/ 1/94 Date
T-1,000.00 Amount
N1005 number
PBank Of Mortgage Payee
^ End of transaction
QIF is older than Open Financial Exchange (OFX). The inability to reconcile imported transactions against the current account information is one of the primary shortcomings of QIF. It is commonly supported by financial institutions to supply down-loadable information to account holders.
MMEX can import transactions from specific types of QIF formats into an account (you can find the type of QIF by opening in a text editor)
After importing from QIF, all transactions will have a Follow Flag as it its status. You can mark all transactions with this flag using the bulk status setting commands using the right click menu in the account view.
To alleviate the problem of users having to pre-format their bank transaction CSV files into the fixed format MMEX requires, MMEX also allows users to import CSV files where the order of fields is completely freeform.
To use this importer, select the account you want to import into and then select the order of fields in the CSV file by picking and choosing from the list of possible fields. MMEX will now import the CSV file using the format information specified by the user.
MMEX can import from a wide
variety of formats. One of them is a fixed format CSV file. This
file format exactly matches the CSV format that MMEX can export. So
it can be useful to move data from one .mmb
database file to
another .mmb
database file. To easily see the format of the CSV
file, you can try exporting an account to a CSV file and then
analyzing the format created.
The CSV field options are as follows:
When creating your CSV file be sure that you remove the commas from your deposits and withdrawals. This can be done easily through a program such as Excel or OpenOffice Calc.
After importing from QIF, all transactions will have a Follow Flag as it its status. You can mark all transactions with this flag using the bulk status setting commands using the right click menu in the account view.
Importing from XML for recognizes XML file in Excel format
named XML Spreadsheet 2003
in Excel. This is the recommended
import method if required to import transactions from Excel.
Method of import and field selection is same as importing from CSV.
MMEX can export to a fixed format CSV file. This file format
exactly matches the CSV format that MMEX can import. So it can be
useful to move data from one .mmb
database file to another .mmb
database file. To easily see the format of the CSV file, you can
try exporting an account to a CSV file and then analyzing the
format created.
The general format is as follows:
MMEX can export to an XML file. The XML format is compliant with Excel and can be read by it. The general format is the same as CSV.
MMEX can export an account to a file of the QIF format. This format can also be used by MMEX to reload into an account.
Recurring Transactions are special transactions that we set up in order to have the transaction entered into the data base at some future date. These transactions generally occur at regular intervals, such as the payment of a bill.
These transactions:
Recurring Transactions can be accessed from the navigation tree or from the menu item Tools → Recurring Transactions. This will display the Recurring Transactions page.
To create a new transaction, use the New button:
MMEX allows you to track Stocks and Shares. The total Stocks are added to your total financial worth.
Further details refer to Stocks, Shares and Share Dividend Management in MMEX
MMEX allows you to track fixed assets like cars, houses, land and others. Each asset can have its value appreciate by a certain rate per year, depreciate by a certain rate per year, or not change in value.
The total assets are added to your total financial worth.
Assets are accessed via the Tools →
Assets or via the Navigation Menu.
Assets are created in the Asset Management window.
Asset transactions are added to an asset and tied to an account.
MMEX allows a variety of reports. Select the appropriate report under the Reports node in the navigation tree. Some reports require some user input, some do not.
These reports generally do not start at the beginning of the
calendar year, and appear as branches of the main report titles.
These reports cover:
The start date can be changed by the user to start on any day of any month, within a 12 month period by using the menu Tools → Options → General.
This allows the user to generate specific reports based on user selected criteria.
A Transaction Report is generally used to locate specific transactions made within Bank or Term type accounts. This report can also be used to display specific details for a particular account.
For a Transaction Report, the resulting list of transactions can be printed or saved as a HTML file.
Since a transfer transaction is a withdrawal from one account and a deposit to another account, a transaction report done on multiple accounts loses the reference point for determining whether the transaction is a deposit or withdrawal.
When a transaction report is used for a specific account, it will generate a report that will match the account details. The reference point for transfers in known for this report, which will reflect in the report having correct balances displayed.
This report projects the amount of funds available, based on future commitments.
The report will use the Recurring Transactions for the various accounts, and reflect forward 10 years on a monthly basis. This becomes a prediction of the amount of money that may be available each month based on current payments.
MMEX supports printing of all reports that can be viewed.
Once you view a report, you can print the report using the File → Print… menu.
You can modify some run time behavior of MMEX by changing the options in the Options Dialog.
Access from the menu with Tools → Options.
你也可以为我们做出贡献!
最初我开发了一个名为 Money Manager 的个人财务软件。 它是用.NET编写的,更多的是学习练手性质而非正式开发, 它的发展远远超出了原来的设计。 The software was frozen and work began on a new version which had a similar user interface and features, but written in C++.
Usually Microsoft names their second version of their improved
software APIs with an Ex extension as in doSomething()
and
doSomethingEx()
. So I just followed the model and tacked on a 'Ex'
to the end.
.mmb
格式是专有的吗?No, .mmb
file is not proprietary.
MMEX uses SQLite databases to store user data. That
means that the .mmb
file is a regular SQLite database.
SQLite is one of the smallest, free relational database
systems around and there are tons of tools to open and
access SQLite databases. SQLiteSpy and
SQLite Browser
are two such utilities. Once you open the database using these tools,
you can do anything you want with the data.
Yes. Your data is completely safe.
The data is self contained on your PC, (or USB stick if you have made it portable). To further protect your data, encryption can now be added. This applies a password to your database file, and can only be opened by MMEX or any other software if you have the correct password.
Yes.
MMEX is a portable application which means ability to run
without installation, for example, from USB flash drive. If MMEX
finds mmexini.db3
in its folder, it assumes portable
mode. Copy mmex's files to USB Key and copy yours
mmexini.db3
to mmex's folder on that drive.
To make MMEX portable:
F:\
is USB flash drive)
C:\Program Files\MoneyManagerEx
to
F:\
%APPDATA%\MoneyManagerEx\mmexini.db3
to
F:\MoneyManagerEx
F:\
/media/disk
is mounted USB flash drive)
make install prefix=/media/disk cp ~/.mmex/mmexini.db3 /media/disk/mmex/share/mmex
/usr
:
cp /usr/bin/mmex /media/disk/mmex/bin cp /usr/share/mmex /media/disk/mmex/share cp /usr/share/doc/mmex /media/disk/mmex/share/doc cp ~/.mmex/mmexini.db3 /media/disk/mmex/share/mmex
Generally, with any closed source program, you have to depend upon the vendor's word regarding safety of the data. But with MMEX being open source, you can verify this claim yourself.
Even if you are not a C++ expert, you can rest assured that anyone can access the source code at any time and verify the legitimacy of MMEX's intentions.
MMEX does connect to the internet only to send anonymous usage statistics or when checking for an update. Here is a sample of data that MMEX will send:
Version | Operating System | Language | Country | Resolution | Start Time | End Time |
---|---|---|---|---|---|---|
1.3.0 Portable | Windows 8 (build 9200), 64-bit edition | english | United States | 1366x768 | 2014-05-01 09:00:00 | 2014-05-01 09:01:30 |
要打印包含任意一组条件的交易的语句,请使用交易过滤器选择您想要的交易,然后从 文件 → 打印… 菜单。
事务过滤器从报告→ 交易报告在导航树上,或从MMEX左上角的快速导航按钮。