What is a Month-End Save?
»» A self-audit that
checks the accuracy of your numbers.
Why do Month-End Saves?
»»
If you
currently want to do historical
reporting.
»» If you
currently want to do performance
reporting.
»» If you ever
want to do historical or performance
reporting in the future.
»» If any of
these are true, then you need to do
month-end saves.
How do I do Month-End Saves?
1. In the Products
Manager, confirm that the prices are
correct for the end of the month that
you wish to save. Pull up a few
securities, go to the Product
tab (which should be there by default), and check that the
"as-of" dates are correct.
2. In the top toolbar, go to Tools --> Month-End Saves.
Click on the Product Prices tab.
3. The default date is
the month-end date from the last
month. So, you would usually just
choose the default. You can also
enter the month-end date (e.g. 1/31/02,
2/28/02, 4/30/02) for which you are
saving prices. Click Start.
When the program completes this task,
you have completed the Product Price
Save. You always want to finish
the Product Price Save before starting
the Account Value Save. Click Done.
4. Click on the Account Values tab. Enter the same
month-end date, and click Start. If you know your free cash amount
is correct on the account record, then leave the button by "Account Records" checked (under
Cash Value to be Saved). If you are unsure of your free cash amount, then choose "Calculate It,"
and the program will calculate the cash balance from the previous month's save.
5. The program will post the current cash
balances and market values to the
Account History file. You have now
completed the Month-End Saves.
6. If you would like to view
the Account Balance spreadsheet you have
just created, go to the
Accounts Manager, pull up an account, and click on the Balance tab. It will show
the saved values by date. The columns should appear
as: Date, Type, Free Cash, Market
Value, Contributions, Withdrawals, Fees,
Interest, Dividends, Accrued Interest,
Accrued Dividends, Capital Gains, Capital Returns, and Capital Base Correction.
Helpful Hints
»» Worried that you might
forget to save prices? It helps to
set a recurring reminder for the first
day of each month. To do this, click on the Planner.
From the toolbar at top, select Planner --> New Commitment,
enter appropriate info in the Reminder
and Recurrence tabs, and click OK.
»» The most important aspect
of the month-end save is the Product
Price Save. You only see those
prices once, so you cannot do Product
Price Saves retroactively unless you
manually enter prices. The Account
Value Save, on the other hand, can be
done at any time. If you forget to
save month-end prices for a particular
month, you can go into each security, go into the
Price History tab, and manually enter
the corresponding month-end prices for
that particular month.
go to Helper Help index page