What this guide will cover
Reports section in MoneyWiz is where you can make sense of all the data you've been entering so far to draw informative conclusions that will help you change your spending habits, save more money and invest better!
This guide will cover the basics of reports: how to access them, how to generate them and how to customise them!
Table of contents
- Report types
- Generating a report
- Viewing a report
- Saving a report
To access reports, use the 6th icon from top on the sidebar in MoneyWiz for Desktop. On MoneyWiz for Mobile, the section is also appropriately labelled in the navigational bar:
MoneyWiz on Desktop and MoneyWiz on iPads offers a set of pre-generated reports on top that you can switch by swiping on them or using the small buttons at the bottom. MoneyWiz on iPhones and Android devices, due to limited screen space, do not feature those pre-generated reports.
Reports are grouped based on the data they use:
- Net Worth: displays changes in your Net Worth (combined accounts balance) over a given period.
- Balance Over Time: displays changes in specific accounts balance over a given period.
- Cashflow: illustrates flow of money among accounts.
- Compare budgets: compares budgets in terms of their spending and allowance.
- Balance Over Time: displays changes in particular budget balance over time.
- Compare Expense/Income Categories: (two separate reports) displays a pie chart, comparing a specific set of categories.
- Expense/Income Category Over Time: (two separate reports) displays changes in category amounts for specified set of categories over time.
- Breakdown Expenses/Incomes Over Time: (two separate reports) generates a table with categories as rows and period as columns.
- Compare Expense/Income Payees: (two separate reports) displays a pie chart, comparing a specific set of payees.
- Expense/Income Payee Over Time: (two separate reports) displays changes in category amounts for specified set of payees over time.
- Breakdown Expenses/Incomes Over Time: (two separate reports) generates a table with payees as rows and period as columns.
- Compare Expense/Income Tags: (two separate reports) displays a pie chart, comparing a specific set of tags.
- Expense/Income Tag Over Time: (two separate reports) displays changes in category amounts for specified set of tags over time.
- Breakdown Expenses/Incomes Over Time: (two separate reports) generates a table with tags as rows and period as columns.
- Breakdown Payees Over Categories: generates a table with payees as rows and categories as columns.
- Breakdown Categories Over Tags: generates a table with categories as rows and tags as columns.
- Breakdown Payees Over Tags: generates a table with payees as rows and tags as columns.
- Statistics: displays various statistical information about selected accounts for a given time.
- Profit & Loss: lists both expenses and incomes in one combined report, totalling them and displaying one grand total.
- Spreadsheet: allows you to generate a customised spreadsheet report.
- Custom report: allows you to generate a customised non-spreadsheet report.
Generating a report
To generate a report, simply click or tap on the report you wish to create. Note the tabs on top: if you wish to generate a report that looks into the past, select Historical report. If you wish to include Scheduled transactions and look into the future, select Forecast. Please note that technically the difference between those is just whether to include Scheduled transactions or not. You can select Forecast report type but through setting a custom report period, have it look into the past and in the future.
Depending which report it is, you'll be asked for certain information, such as:
- Which accounts, categories, payees or tags to include.
- What period to generate the report for. You can choose from a pre-defined set of periods or set a custom one.
- The Chart Type. Some reports allow you to select how the chart should look like.
- What to break the data down by. Some reports allow breaking data down, for example by months. You can customise this.
Various reports offer different types of customisation - play with it a little to see what effects your changes make!
Something worth noting is the Add filter button you might see in some reports. Clicking this allows you to add more conditions to the reports - only transactions that pass the conditions you set will be included in the report. This for example allows you to generate a monthly categories report but only including transactions with "Business" tag to list business expenses only.
Why I can't generate reports for both expenses and incomes?
Many reports in MoneyWiz include both expenses and incomes: all account-based reports, Statistics and Profit & Loss report. However, reports that are based on categories, payees or tags generally do not allow generating them for both expenses and incomes.
This decision comes from a decision we've made earlier to keep expense and income categories separated.
Once a report has been generated, you can modify it using the Edit button in top-right in MoneyWiz for Desktop or pencil button in the top-right in MoneyWiz for iPad. Editing reports in MoneyWiz for iPhone and Android is done differently - after generating a report, just go back one step and change the report settings before generating it again.
Viewing a report
Here is how a generated Account Balance Over Time report looks like:
Working with transactions
In most cases, transactions will be hidden by default, collapsed into the row containing them (in this case account row). To expand the row, just click on the little diamond to the right of the container name. You can also use the Expand/Collapse All button in the bottom-left corner.
You can work with transactions just as if you were looking at them from the Account register. Clicking on a transaction expands it, showing more information. You can modify, duplicate, delete them right from the report.
Working with the chart
Remember that while chart is present in most reports, it is not available in some. In MoneyWiz for Desktop, it is visible immediately, on top of the transactions table. In MoneyWiz for Mobile, you can switch between transactions table and the chart using the tabs at the top of the report screen (below the report name).
You can hover your mouse or finger over the report to display balances for a particular period in time, for a given data piece (e.g. accounts). Data pieces that make up the report are displayed below the chart as a legend - you can click on them to hide or show them on the chart.
MoneyWiz for Desktop features two small buttons in the bottom-left of the chart:
- Magnifying glass: hides the transactions table so the report chart can take 100% of the available space, making it easier to see the details.
- Pushpin: by default, if you scroll the transactions list down, the report will stay on top so you can still refer to it - but it takes some space. If you prefer for the report to scroll along with the transactions list, click on this button.
Those buttons are not available in MoneyWiz for Mobile as it separates chart and transactions table into two different screen areas.
Saving a report
Any report you generate can be saved locally for quick access later. To save a report locally use the Save report button (MoneyWiz for Desktop and MoneyWiz for iPad) or + button (MoneyWiz for iPhone and Android) and select Save locally.
You'll be asked to name the report. After saving the report will be present in Saved reports section of Reports area:
You can find all your saved reports at the very bottom of the Reports section (MoneyWiz for Desktop and MoneyWiz for iPad) or in the Saved reports tab of the Reports section (MoneyWiz for iPhone and Android).
A couple of notes:
- saved reports will sync to other devices via SYNCbits,
- saved reports can be deleted by clicking the Delete button (MoneyWiz for Desktop) or swiping to the left on their name (MoneyWiz for Mobile),
- saved reports cannot be re-ordered at this time,
- if in March you locally save a report for which you have selected a period of Last Month (and saw February in the report), when you generate the report next month you'll see transactions from March. That's because Last Month period is (and all other pre-defined periods in fact are) always dynamic so it'll always show you last month. To save a report that will always show a certain period, use the Custom period instead. This won't change.
Exporting and printing reports
Reports can also be exported to different formats and printed straight from the application (depending on the platform). To begin, start Saving report (like explained above) but choose either Export or Print. Please note that Print might not be available on all platforms.
If you choose Export, you'll have the option to export a report to either CSV or PDF file. Please note that PDF export is not available on all platforms.
- For CSV export, you can choose the encoding, separator and date format. If not sure - best to leave the default options.
- For PDF export, you can choose whether to include transaction attachments in the report or not.
Please note that the exported report will always reflect the report you see in MoneyWiz, meaning that if you did not expand all data rows (e.g. accounts) to display transactions, the exported report will display them as collapsed as well.