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.


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.

Click to see larger image

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.

image.png

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.

image.png


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:

image.png

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.

image.png


Exporting only sub-categories

When the Nest categories option is toggled off

  • the export is consistent with the on-screen report

image.png

Still need help? Contact Us Contact Us

keyboard_arrow_up