Exporting and printing the Income & Expense report
The Income & Expense report (Reports > Income & Expense) can be exported into a spreadsheet. This will allow you to open this report with spreadsheet software such as Excel, Numbers, or Google Sheets. You can also print this report.
For more details on using the Income & Expense Report, see this guide: The Income & Expense Report.
In this user guide
Exporting options for the Income & Expense report
To see the export options in the Income & Expense report, hover over Export in the toolbar, choose the report you want to download, or select the print option.
The Income & Expense report has the following exports:
Income & Expense Statement
You can download the report as a spreadsheet in Excel (XLSX) or Generic (CSV) format. This will allow you to open this report with spreadsheet software such as Excel, Numbers, or Google Sheets.
This export has the same layout as the Income & Expense report, including the Nest categories and roll-up options.
Transaction report
This option generates an Excel (XLSX) or Generic (CSV) file that lists all of the individual transactions that contribute to the Income & Expense report, arranged into their categories.
This export is designed for users in Australia who may need this information to do their annual Australian taxes.
A shortcut to print or download a PDF version of the report using your browser's print feature.
For more details about printing in PocketSmith, see this guide: Printing pages and reports.
The tooltip
When viewing the Income & Expense Report on screen, a tooltip i
icon may be visible if there is something about the total to be aware of.
If it shows, hover over the tooltip i
icon in the total rows to see how the Total Expenses and Total Income have been calculated.
This informs you how many of your sub-categories have been excluded from the sum total due to roll-up and being included in a parent category.
The exports do not include the tooltip. Instead, these will exclude any rolled-up sub-categories to prevent double-counting.
Exporting only parent categories
If you have the Nest categories option toggled on, and the roll-up of the sub-categories is selected
- only the parent category totals are exported
- the sub-categories will not be exported
Example
The Rent and Utilities sub-categories are rolled-up to the Household parent category, and the Groceries and Cafes sub-categories are rolled-up to the Food parent category.
The export contains the Household parent category and the Food parent category, but none of the sub-categories.
Exporting nested sub-categories with only sub-category amounts
If you have the Nest categories option toggled on and roll-up of sub-categories is not selected
- only the sub-category totals are exported
When the Rent and Utilities sub-categories are not rolled-up to the Household parent category, and the Groceries and Cafes sub-categories are not rolled-up to the Food parent category. The Statement appears on the screen as follows:
The export contains the Household parent category and the Food parent category, but none of the sub-categories.
The sub-categories are indicated in the export by the '>' character.
Exporting only sub-categories
When the Nest categories option is toggled off
- the export is consistent with the on-screen report