Creating Balances Reports
Balance reports allow you to track historical balances of cash and values of investments across accounts of your choosing and over the time period of your choice. Creating Balance reports is easy, just follow the steps below.
Creating a Balances Report:
- Select the Reports View by selecting "Reports" from the Account List.
- Select the "Balances" button on the top bar.
- Click the "+" button underneath the reports table on the top left.
- You can rename the new report by double clicking the new report's name in the "Report Name" column of the table and entering the new desired name.
- Select the desired "Start Date" and "End Date" for the report.
- Select the "Frequency" of report under the dates. This "Frequency" is for listing comparative time intervals within the report's date range when using some List Styles.
- Select whether or not to show individual investment positions in this report using the "Show Investment Positions" checkbox. If "Show Investment Positions" is not chosen the report does include the values of these positions they are just not displayed individually.
- Choose the desired "List Style" of the report (Account List or Net Worth).
- Add the account(s) you would like to see information for.
- View the results using the options on the "Balance Report" bar in the middle of the screen. You can see all the details of the report in a table, in a PDF view showing what would be printed, or in graph view.
Balances Report Notes and Tips
- Accounts marked to "Hide Balance" are not included in reports.
- For calculating historical values for investment positions the quotes saved in the database are used. If a historical quote is not available for the held security then the last known price paid for the held security in the account is used as the market value. Historical values for bonds can be calculated based on the common present value (PV) of a bond formula if the Investment Preferences for "Use PV of a Bond Formula for Bond Quotes" is turned on.. In order for the PV of a bond calculation to be accurate the bond transactions must be setup with the relevant bond specific information (bond issuer type, coupon rate, coupon frequency, par value, issue date and maturity date).
- You can change the currency for the report by Control clicking the name of the selected report and choosing the desired currency.
- The Table List View for the report has optional columns that can be shown or hidden. You can Control click the table to display the table's contextual menu with selections for setting the optional columns and column sorting.
- Generated PDFs from the report are based on the columns shown in the Table List View (WYSIWYG). Their font and colors for headings and numbers are based on user preferences.
- You can force the generated PDFs to reload by Control clicking the PDF view and selecting "Clear All PDF Reports".
- You can also change the type of graph shown (line graph or bar chart) by Control clicking the graph view.
- You can export the report to a CSV or PDF file using the "Export" button under the reports table on the top left.
- There are several Keyboard Shortcuts making navigating reports easier:
Raise Report Results View: ⌘ 3
Lower Report Setup Details View: ⌘ 4
Show Report Table List View: ⌘ 1
Show Report PDF View: ⌘ 2
Show Report Graph View: ⌘ 5
Expand All Report Table Items: ⌘ Right Arrow
Collapse All Report Table Items: ⌘ Left Arrow
See also
Reports
Creating Cash Flow Reports
Creating Investment Reports
Creating Payee Reports
Creating Transaction Type Reports
Creating Category Reports
Creating Memo Reports
Deleting Reports
Duplicating Reports
Keyboard Shortcuts
List of Reports & Budgets Topics