IN THIS SECTION


Overview

You can view the individual Journals that make up a particular number on a report by clicking on the number. See this article for more information on running Joiin reports.


Simply run any Joiin Financial report from the left menu and click on the number you want to drill-down on.



A list of the underlying journals will be displayed.




This shows all the Journals for the selected Account, Company(s) and date range. Information such as the Date, Reference and Gross amount will be displayed. You can click on a link to see the related transaction (Invoice, Bill etc.) in the source system.


Some things to note:


  • Journals will be displayed in the currency of the original transaction, regardless of the reporting currency chosen.
  • Journals are not available for Manual (CSV uploaded) companies or Sage companies.
  • Eliminations or Adjustments that have been added may mean the report value doesn't match the total of the journal records.
  • If you have recently added a Xero company, it is possible that not all Journals are downloaded immediately - this is due to Xero API limits we have no control over. You will see a message saying "We're still processing journals data for the following companies" if this is the case.


Search by Text

You can search for text within the results by entering text in the Search by text box. The search will be performed across all the fields and any journal records with matching text in any of its fields will be displayed.


Filtering by Type

You can filter the results by the type of Journal record, e.g. Invoice, Credit Note etc. Simply click on the type box and select the desired types.


Sorting

You can click on the column heading to sort the results by that criteria. The initial click will sort ascending and an up arrow will be displayed in the column heading, e.g.


Click again to sort descending - the direction of the arrow will change:




Selecting Columns

You can choose which columns to display when viewing results. To do this

  • Click on the cog icon at the top right

  • Click on Select columns to bring up a list of columns.
  • Check/Uncheck the columns you wish to see/hide
  • Click on Apply changes


Changing Column Order

You can change the order in which columns are displayed when viewing results. To do this


  • Click on the cog icon at the top right

  • Click on Change column order to bring up a list of columns.
  • Click and hold the three-bar icon at the left of the column name and drag/drop it into the place required.
  • Click on Apply changes



Clearing Filters

Click on the Clear Filters button at the top right to reset all filters, columns and sort order to their default settings.




NOTE: Any changes you make to the columns and sort order will be saved in your browser for the next time you visit the page.