With MoneyWiz you can generate various reports which help you understand your financial status. Different reports are used to show you different type of information. For example, Compare Budgets report shows you the areas you spend most, while Net Worth report shows you the graph of your finances for some period. Depending on what you are interested in you can generate various reports in order to find the information that you need.
Reports are only meaningful when you have entered transactions for at least some small period of time. You will not be able to generate an account balance report if you don’t have any transactions in this account. The same is valid for Budgets and Categories.
The screenshots in this guide are made from an iPad device. Whenever there are differences between the platforms/devices where MoneyWiz is available, these will be described. Please, do not hesitate to contact us in case you have any questions.
When you land in the Reports section you will see that they are divided into 3 major parts:
- Predefined reports - quick view of your overall financial picture, you can swipe through 3 carefully selected reports (this section is not available on iPhone and Android).
- Templates - you can choose between 28 templates and also access the custom reports feature.
- Saved reports - you can save the reports that you want to see regularly and access them at any time you need without need to configure them again.
With MoneyWiz we made sure that you can generate any type of report you want and find any information you may need. We did that by providing you with a Custom Report - this report allows you to configure everything - we will explain it in more details later in this guide.
In this guide, we will explain:
- Custom reports
- Interaction with reports
- Ready-to-use templates
- Save, Export & Print
You can access the custom report feature by visiting the Reports section, the last one of the available templates is Custom report. Click/tap on it and you will be allowed to configure everything about the report you want to generate.
We will explain each option in detail below.
Historical or Forecast period range
At the very top you can choose between Historical and Forecast tabs. You first need to decide if you want to look at the past or the future. The difference is in what pre-defined periods the application will offer you (for example you'll see an option to review Last 3 Months if you select Historical or Next 3 Months if you select Forecast).
Moreover, the choice of the period will affect whether or not you'll be seeing upcoming Scheduled transactions in your report. Only Forecast tab will display upcoming transactions (the Historical will show all transactions that have been executed already).
Select what is the main type of data you are interested in:
Depending on what you select here some other options below will change. For example, when you select Accounts, the app lets you select which accounts you want to see a report for. Same goes for Budgets.
If you select Categories, the app allows you to select the type of the report - Expenses or Incomes, then select the set of categories you need to see in the report. At the end you can add some filters to your report (filter out some Accounts, Payees or Tags). The same goes for Payees.
Depending on what you selected for Report by, different options for charts will be available. For example you can choose:
- Graph chart (line chart) - useful for seeing information over time
- Bar chart - good for stacking some values together for easier comparison
- Pie chart - perfect to check how various pieces of data contribute to a whole
Group by accounts
This option only available if you selected Report by Accounts. If you set it to ON, the transactions below the chart are going to be grouped by accounts, then sorted chronologically. If you set it to OFF, the transactions will not be grouped and will be just sorted chronologically.
This option is only available if you selected the chart type to be Bar chart. The available options may be different, but they always include at least breakdown by Budgets, Categories or Payees (depending on what you selected for Report by) and various periods.
Simply select the period you are interested in from the available options. As noted before, you'll see suggestions for past periods if the Historical tab is selected and future periods if Forecast tab is selected.
You can of course select the Custom period option and then pick the exact start and end date of the report.
Interaction with reports
Once you configure your report, you can generate it. To do that just tap the Done button (available on iOS/Android at the top right corner) or press Generate (available on Mac/Windows on the bottom right).
Each report is represented with a chart and list of transactions.
Notice that the graph features some buttons to the left (note that not all buttons might be available in all reports):
The plus button allows you to combine all accounts together. For example, with Account Balance Over Time report you're looking at the each account balance historical lines individually (see above). By pressing this button you can combine all accounts into a single line.
The pushpin button allows you to "unpin" the report to the top. By default, if you start scrolling through the list of transactions, the chart stays in place - which sometimes is good as you don't lose it from sight. But in case you need more space to scroll through your transactions, just use this button to "detach" the chart and have it scroll away as you scroll down.
The magnifying glass button allows you to zoom to the chart so it can take full screen and show you more data. This is when the next feature comes in handy - touching the reports.
You can click/tap on the report charts to show, for example, account balance on that particular day. This is where the zoom button comes in very handy as it gives you more control.
Now let's take a look at some of the most popular reports.
The report templates in MoneyWiz are grouped to make it easier to find the one you need. Remember how you had to choose the "Report by" when generating Custom report? Choosing between the report groups is similar - you want to ask yourself what do you want to look at. Accounts? Then choose from one of the reports in the first "Accounts" group. Budgets? Head over to second group and pick one of the reports - and so on.
Net Worth report
This report shows you changes to your total Net Worth (sum of all accounts) over time and the transactions that contribute to the changes. You are unable to choose which accounts go here as all accounts are included by default - unless some were explicitly excluded from Net Worth calculation in general.
Balance Over Time report
This report shows you how the balance of each account changed over time. You can choose which accounts to generate the report for and review the transactions in the report in the table below the chart. If you tap on the + button next to the report chart you can combine all account lines into one graph - just like the Net Worth chart.
This bar-type report shows you expenses and incomes for each month (unless you select a different breakdown, such as by Weeks) so you can see, for example, if month-to-month you're spending more than you earn (which is not a good sign).
Compare budgets report
This report allows you to compare how each budget allowance you've set contributes to the total. If - after you've set up your budgets - you find that you often don't have enough money for Entertainment, you can use this report to check if perhaps one of the other budgets isn't too big.
Budget Balance Over Time report
Setting the budget allowance is one thing but how does your spending look like in practice? Perhaps you're often overspending your budgets? This report allows you to find out. You can either browse a single month for a budget or review a budget over the span of a couple months/weeks/etc.
Categories, Payees and Tag groups
The next 3 groups all display 3 types of templates, one for each transaction type (expense and income) which makes it 6 per group or 18 in total. Because those templates are very much related (they just look at different type of data - category, payee or tag) we'll review just one of each template type.
Compare Expense/Income Categories/Payees/Tags
This pie-chart report allows you to select some categories/payees or tags (depending on the report type) for expense or income transactions and check how much money is allocated to each. For example, using Compare Expense Categories you can check how do your monthly expenses compare to each other - and you'll most likely see your loan/mortgage eating most of your salary.
Or if you generate Compare Income Payees report for example, you can check which client in the given period paid you most money. The possibilities these reports offer are endless.
Remember that these reports also offer a special button - "Add filter". This way you can filter the results a bit, for example to exclude a particular tag when generating categories report.
Expense/Income Category/Payee/Tag Over Time report
With this report you choose a piece of data you want to analyse over time (categories/payees or tags), add some filters if needed, choose whether you're looking at expenses or incomes and then generate! The chart allows you to see the expenses/incomes over time filtered by your settings. You could use this for example to see how does the winter affect your heating bill (Expense Category Over Time report) or perhaps how many more clients you get after that marketing campaign you've paid for (Income Payee Over Time report).
Breakdown Expenses/Incomes Over Time
This report of a spreadsheet type allows you to review each piece of data (categories, payees, tags) by period where each category/payee/tag is in a separate row and each period is a separate column. This report also features sophisticated stacked bar-type report above the table.
These three report templates allow you to breakdown one piece of data against another. You can choose from:
- Breakdown Payees Over Categories
- Breakdown Categories Over Tags
- Breakdown Payees Over Tags
- Custom Spreadsheet report (in the "Others" group - see below)
We could for example investigate how much money we spend for Groceries category at each of the shops we visit:
The statistics report is different from all other reports - it provides statistical information about your finances and it doesn't have a chart. You can't make it using the custom report feature. The report includes the following statistical information:
- Daily, Monthly and Yearly average of your Expenses
- Daily, Monthly and Yearly average of your Incomes
- Top 5 Expense Categories
- Top 5 Payees by expenses
- Top Income Category
- Top Payee by expenses
- Current Net worth
- Highest Net worth
- Lowest Net worth
- Total number of transactions
Profit & Loss report
Another unique type of report includes expenses and incomes at the same time, allows you to review the sources of your profits and sources of your losses in a structured way:
Custom Spreadsheet report
Just like we can generate a regular Custom report allowing you to choose precisely what you want to see, MoneyWiz also offers custom Spreadsheet reports. Using this report you can compare two sources of information to create just the report that you need.
Save, Export & Print
Once you generate any report, you will see a button on the bottom right called "Save report" - click/tap button and you will be provided with 3 options - Save locally, Export and Print.
Saving a report locally within MoneyWiz
If you are frequently interested in the same piece of information – like how much you spent on a certain category last month, you can save a report so you can access this information quickly. Just click Save Report from the lower right end of the screen, then select Save locally. It will be synced to your other devices.
All reports in MoneyWiz are dynamic. If you generate a report for Last month in February, the report will show you information about January, but when you access it in March, the report will start showing you data for February (considering that you selected Last month), provided that you chose one of the pre-defined periods to generate the report (Last Month, Last 3 months).
You can also print reports directly from MoneyWiz (it's the same as if you were to export the report to PDF then print it separately). What's more, the iOS version of MoneyWiz supports printing via AirPrint - if you have an AirPrint-enabled printer, you can directly print from your mobile devices. The Android version lets you do the same via Google Cloud Print if you have a printer connected.
Export to PDF and CSV
Export to PDF
With MoneyWiz you can export reports in beautiful PDF files if you want to share them with someone, like your accountant for example. Just press Save and select Export to PDF. You can also select whether your PDF should include any attached images your transactions may have.
Export to CSV
You can also export them in convenient CSV format if you want to open with Excel or Numbers, or convert them to another data format. Just press Save and select Export to CSV - the CSV export is also configurable.
Delete Locally Saved Report
To delete a locally saved report, on an iOS device you need to use a gesture. Please your finger on the report and swipe right to left to reveal the Delete button.