Exporting the Income & Expense report will allow you to open it 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.
How to export and print 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.
There are two types of reports that you can export from the Income & Expense report.
- Income & Expense report - a spreadsheet copy of the current Income & expense report that you are viewing.
- Transaction report - an export file that contains all the transactions for each category within the current Income & Expense report that you are viewing.
Income & Expense report export
You can download the report as a spreadsheet in Excel (XLSX) or Generic (CSV) format. This will allow you to open this report in spreadsheet software such as Excel, Numbers, or Google Sheets, or in any text editor using the CSV file.
This export has the same layout as the Income & Expense report, including any sidebar options and comparison periods.
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
For example, in the screenshot below 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
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.
Transaction report export
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.
You can read more on the Income & Expense report in our overview guide: The Income & Expense report: Overview