Creating Balance 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 Balance Report:
- Select the "Reports" view from the account list.
- Select the "Balance" 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 (the "Frequency" refers to how the details of the report will be grouped together).
- 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).
- 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.
Balance Report Notes and Tips
- 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 are calculated based on the common present value (PV) of a bond formula. In order for the PV of a bond calculation to be accurate the bond transactions must be setup with the relevant bond specific information (coupon rate, coupon frequency, maturity date, and par value).
- You can change the currency for the report by Control clicking the name of the selected report and choosing the desired currency.
- The table 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 and their sorting (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 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 View: ⌘ 1
Show Report PDF View: ⌘ 2
Show Report Graph View: ⌘ 5
Expand All Report Table Items: ⌘ E
Collapse All Report Table Items: ⌘ L
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