IN THIS SECTION
- Running Reports
- Filtering Data
- Display Filters
Once you've set up at least one Company you're ready to run the Joiin reports. For more information on what reports are available see the Joiin Reports section. For more information on how to exclude accounts from reports see the Chart of Accounts and Eliminations article.
Simply select the Report from the menu on the left, select the filter criteria and click on Run. The results will be displayed. Once you've run a report, the filters will be saved and it will run automatically when you return to that report.
The results will be displayed in tabular form. If there are a lot of columns you can scroll from right to left to see more columns. Scrolling can be easily achieved, depending on your device and setting options include:
SCROLLING TIPS - Traditional Mouse with wheel - Hold down shift key and spin the mouse wheel - Trackpad - Use two fingers and move left and right - Magic Mouse - Swipe left and right
Downloading to Excel
To download the results to an Excel file, click on the Download icon at the top right, below the Run button.
To print the report or to save it as a PDF, click on the Print icon at the top right.
When you click this button you will be presented with the print dialog where you can select the printing format (portrait/landscape), paper size etc. You can select a printer to print to or select Save as PDF to save the document as a PDF.
Viewing Exchange Rate
If currency conversion was performed, the Exchange Rates used can be viewed by clicking on the Fx Rates button above the report results. More information on how exchange rates work and how they can be customised can be found in the Exchange Rates section.
Creating Custom Reports
To create a custom version of the report click on the Create custom report button. See the Custom Reports article for more information.
Adding Report to a Report Pack
To save the report to a Report Pack click on the Add to Report pack button. See the Report Pack article for more information.
You can collapse or expand all the sections within a report in one simple operation. Simply click on the 3-dot menu at the top-left of the report results (next to the first section heading). Select Collapse groups to collapse all sections. Select Expand groups to expand all sections.
There are several controls available that allow you to filter and display the report data in different ways. The Main Filters are listed below, followed by additional Display Filters which allow you to further control what is shown on screen.
Once you've selected filters and run a report for the first time, each time you visit a report it will be run automatically using the previously selected filters. NOTE that not all filters below are available on the A/R Ageing Report - for more information on that report see the A/R Ageing Report section.
Select the companies you want to run the report for. You can select multiple companies and if you do Joiin will merge the figures into a single report. The Accounts from the Chart of Accounts of each Company will be merged based on the Account Type, Account Code and Account Name. You can change this through the Reporting Configuration page if needed.
For more information on how accounts from Xero/QuickBooks/Sage are mapped to Joiin accounts see the Account Mapping section.
You also have the option to Select All or Deselect All companies and the number of currently selected companies is shown on the right.
Select the currency you wish to see the report in. If you select a currency that is different to the home currency of the company in QuickBooks, Xero or Sage, Joiin will automatically convert the values (see the Exchange Rates section for more information on how currency conversion is performed and how you can customise rates).
The Format section provides a common list of reporting formats. Clicking on a format will set the Start/End Date and Compare filters (see below) accordingly and run the report automatically.
Click on More formats to bring up the full list of formats. Some formats may be unavailable (e.g. if you have selected companies with different fiscal year starts) - you can hide unavailable format by ticking the Hide unavailable formats box.
The formats available are as follows:
- This month
- This calendar quarter
- This calendar quarter to date
- This financial quarter
- This financial quarter to date
- This calendar year by month
- This financial year by month
- This calendar year by company
- This month
- This calendar quarter
- This financial quarter
- This calendar year
- This financial year
- Last month
- Last calendar quarter
- Last financial quarter
- Last calendar year
- Last financial year
If your required format is not in the list of common formats you can set the Start and End dates to whatever months you require. For the P&L based reports the data shown will be the totals for the period selected - e.g. if you select Apr 2017 - Nov 2017 - the data will be the sum of all the transactions on P&L accounts for April 2017 to Nov 2027 inclusive. For Balance Sheet based reports the data shown will be the account values at the End Month selected.
NOTE: The periods available will depend on the dates you have configured the Company data import for - see the Company Management section for more information. The first month available will be the month you have set for Company import Start Date. If you have selected more than one Company then the Month available will be the month of the latest Company import start date.
You can compare the results against other periods or break the results down by company or category using the Compare option. The options available are:
to Previous Period - see the results for the previous period - e.g. if you selected the current month you would see the previous month - if you selected the current Quarter you would see the previous quarter etc. The number of periods to display can be selected from the Periods to Compare dropdown - see below. Additional periods will be displayed in chronological order, from left to right.
to Previous Year - see the results for the previous year - e.g. if you selected the current month you would see the same month in the previous month - if you selected the current Quarter you would see the same quarter in the previous year etc. The number of years to display can be selected from the Periods to Compare dropdown - see below. Additional years will be displayed in chronological order, from left to right.
to Financial Year To Date - see the results for the year to date - only available on Profit & Loss reports.
by Company - see the results for each selected company in a separate column and the consolidated total for all companies in a column at the end
by Tracking Category/Class - See the results broken down by Xero Tracking Category or QuickBooks Class - only available on Profit & Loss reports. Joiin will use any Xero Tracking Categories or QuickBooks Classes that exist on your companies when displaying data by category. This option will only be available if you selected a QuickBooks company or a Xero company which has Tracking Categories set up. If you selected a Xero company with categories you will be able to select which Tracking Category to use with the Categories dropdown - see below. For QuickBooks companies only a single Category is available and that equates to the QuickBooks Classes. The By Category option is currently not available for Sage.
You can optionally choose with category options to include in your results by selecting them from the Options dropdown.
NOTE the to Previous period and to Financial year to date options may not be available if the Company Import Start Date is not far enough in the past. For more information on configuring Import dates see Managing Companies.
Periods to Compare
If you have selected To Previous Period or To Previous Year in the Compare dropdown you can also select the number of periods you want to see. Additional periods will be displayed in chronological order, from left to right. This is a useful way to see, for example, the years results month-on-month. For example to view the results for 2018 simply select Dec 2018 for the Report Period, select To Previous Period from the Compare dropdown and select 11 from the Periods to Compare dropdown.
You can control how Eliminations are handled by clicking on the Elimination Settings button at the top right.
NOTE: Accounts may be eliminated through the Chart of Accounts page in Joiin - the settings here control how those eliminations are applied.
|Remove Eliminated Accounts||Accounts that you have marked as Eliminated will be removed from all reports.|
|Remove all but Eliminated Accounts||All accounts apart from those you have marked as Eliminated will be removed from all reports. This can be helpful to run checks to see what eliminated amounts come to.|
|Remove None||No accounts will be removed from reports, whether they have been marked as Eliminated or not. This helps to run a report without any eliminations, saving you from having to individually remove and re-add eliminations.|
|Show in Separate Column||An additional column will be shown on the report - the first column will show the values before elimination, the second column will show the elimination values and the third will show the total after eliminations.|
Below the main filters are additional display filters. These are toggles which control what is displayed on screen and can be adjusted without the need to run the report again. The available display filters depend on the type of report and the main filters that have been selected.
This filter is displayed when the Compare By Period main filter has been selected. Switching it on will cause the percentage change from one period to another to be displayed on the report.
This filter is displayed when the Compare By Company or Compare By Category main filter has been selected. Switching it on will cause the percentage split across each company/category to be displayed on the report.
This filter is displayed if you have Budgets in Xero or QuickBooks for the selected companies and period(s). Switching it on will display the Budget values and budget variance amount/percent against each account. For more information see the Budgets section. This toggle is not available when the Compare By Category main filter has been selected.
Percent of Sales
Selecting this filter will show the percentage of the Total Revenue for each account. This can be useful when developing budgets and forecasting future values of Profit and Loss items such as Revenue, Cost of Goods Sold or Expenses. For example, if the historical cost of goods sold as a percentage of sales has been 42%, then the same percentage can be applied to a forecast sales level. It can also be useful for some Balance Sheet items, such as accounts receivable, accounts payable, and inventory.
This filter is displayed when the Compare to Previous Period/Year or Compare by Company/Category main filters have been selected. Switching it on will show an additional column at the end of the report with the total of all the main column values.
This filter is displayed when the Compare to Previous Period/Year or Compare by Company/Category main filters have been selected. Switching it on will show an additional column at the end of the report with the average of all the main column values.
This toggle allows you to switch Compact View on or off.
Compact View displays the report results with some data such as Budgets, % Change and Percent of Sales displayed stacked below the actual amount - this view means you can fit more on the screen and is useful to see info at a glance or in report packs and presentations.
Switching Compact View off displays the data in a more traditional tabular style with each value in a separate column.