IN THIS SECTION

• Overview
• Using Layouts
  • Ways you can access Layouts
    • Running a Financial Report
    • Building a Report Pack
    • Layouts List
  • Selecting and Editing Layouts
  • Automatically Added Accounts
• Layout List page
• Types of Layout
• Editing Layouts
• Changing the layout name
• Searching/Filtering within a layout
  • Show hidden elements
  • Show archived accounts
  • Search by name
  • Filter by company
• Moving and copying accounts between groups
  • One at a time
  • Bulk move
• Adding/Editing Groups, Formulas and Charts
  • Quick Toolbar
  • Adding/Editing Groups
  • Options for editing groups
  • Adding/Editing Formulas
    • Types of Operand
  • Options for editing formula
  • Total Calculation Method Explained
  • Adding/Editing Charts
  • Options for editing charts
  • Moving and Nesting Groups
  • Deleting a Group, Formula or Chart

NOTE: This article refers to Layouts which are only available in the latest version of Joiin. Layouts replace Custom Reports in the latest version - if you're on the old version you may want to look at this article.

Overview

Layouts allow you to tailor the Profit & Loss, Balance Sheet and Cashflow Reports and layout the data as you require - each layout can be saved and run as and when needed or used within Report Packs. Layouts can be used for many purposes including:

• Creating custom layouts to meet statuary form requirements, e.g. GAPP, IFRS
• Consolidating accounts with different codes/names into a single line
• Performing calculations and presenting the results as a single item (e.g. KPI)
• Displaying charts summarising report data

With layouts you can:

• Add, rename and delete groups
• Move accounts between groups
• Set groups to display Debit or Credit accounts as positive
• Control how results and totals are displayed for a particular group
• Hide groups - handy if you only want to see certain accounts/formulas in the report results
• Add, rename and delete formulas
• Change formulas to perform calculations with the totals from groups, other formulas and raw numbers
• Add charts
• Create a Copy of an existing layout
• Move groups and formulas up and down in the report and nest them in other groups

Using Layouts

You can choose a Layout to use when running a report and you can create and edit custom layouts.

Ways you can access Layouts

You can select, create or edit Layouts from several places:

Running a Financial Report

When you run any of the standard financial reports (Profit & Loss, Balance Sheet etc.) you can select the layout from the Report layout dropdown. By default, the Built-in Layout for that report will be used. Click on the layout dropdown and you can select, create or edit a custom layout. See the Running Reports article for more information.

Building a Report Pack

When you're viewing or editing a Report Pack you can select the Layout of a Report by clicking on the Edit Report Layout icon on the report toolbar at the top right of the report - from there you can select, create and edit layouts. Alternatively, when adding a new Report you can select the desired layout - or create and edit layouts from there. See the Report Packs article for more information.

Layouts List

You can view a list of all Layouts through the Layouts item on the top-right Settings menu. From there you can click on a Layout to edit it - or delete, duplicate and copy layouts between clients (see below).

Selecting and Editing Layouts

When you access layouts through a financial report or Report Pack you will see the Layout Selector pane on the right. This will show all the available Layouts for the type of Report being viewed (see Types of Layout below). Here you can choose the Built-In Layout or from one of the Custom Layouts, should they exist. Simply click on the Layout name to select it - the Report will be re-generated using that Layout.

To Edit one of the Custom Layouts click on the Edit icon on the Layout you wish to edit.

To Create a new Layout click on the Create button.

When you create a new layout it will be laid out depending on the report type you selected (see table below).  From there you can make changes to the layout as described further in this guide.

Automatically Added Accounts

Sometimes, a new account is added to your Chart of Accounts - this may be because a new account has been added to an existing entity in the source system or you have added an additional entity to Joiin. When this happens Joiin will automatically add that account to any existing layouts - so you will see the account appear when you run a report using that layout or edit the layout. 

Joiin will attempt to add the new account to the default section for that layout type. The default sections for each layout type correspond to the sections you see on the standard reports. For example the P&L Report has Revenue, Cost of Sales, Expenses etc. section - each account in the Chart of Accounts is mapped to the relevant section - when a new account is added it will appear in that section in any P&L layouts. If the section does not existing because it has been customised by the user, then the section will be created again automatically. The user can then make any required changes to the layout to move the account where required.

Layout List page

Once you've created and saved a Layout you can access it again through the Layouts item on the top-right Settings menu.

• Select Layouts from the Settings menu - a list of previously saved layouts will be displayed
• The Type of Layout, the date is was last modified and a count of how many Report Packs the layout is used on will be displayed.
• Click on the layout name to edit the layout
• Click on the Delete button on the right of the report to delete the layout
• Click on the Duplicate button on the right of the layout to create a copy of an existing layout
• If you have multi-client enabled, click on the Copy to Client option to copy that layout to another client - select the client you wish to copy the report to, amend the name if necessary and click Copy

Types of Layout

You can create different types of layout - the type you choose dictates the type of accounts that are included and the initial layout of the report. 

Editing Layouts

When you create a new layout or edit an existing layout you enter layout edit mode.  Some things to note while you're in this mode:

• In Edit mode the editor will include all accounts from your Chart of Accounts of the type corresponding to the report type. When you run a report with that layout only the accounts corresponding to the selected Companies and other filters will appear.
• You must click the Save button to save any changes you make.  The Save button will be greyed out initially but will become active as soon as you make any changes.  TIP: We recommend you save often when editing a layout especially if you're making a lot of changes.
• The Save button has a number in parentheses which tells you how many Report Packs this layout is used in. This acts as a warning to make the user aware that if they are adjusting a layout from with a particular Report Pack then it may affect other report packs.
• Once you save a layout, you will be returned to the report/pack you were viewing and the report will be re-generated using that new layout.
• In this guide we refer to the "three-dot" menu by which we mean the icon with three vertical dots that appears on every group and formula which, when you click on, opens up a menu of actions you can perform on that group or formula.

Changing the layout name

Simply change the name in Layout Name field and click on Save.

Searching/Filtering within a layout

You can filter the groups and accounts you see when editing a layout in a number of ways. The filter and search boxes below the layout name allow you to do this.

Show hidden elements

Switching this toggle controls whether hidden elements are displayed while editing the layout. Groups and formulas can be hidden so that they are not shown when a report using that layout is run. However, while editing the layout it is useful to see those hidden elements. Use this toggle to hide or display them as required.

Show archived accounts

Use this toggle to show or hide any archived accounts. If you have a lot of archived accounts it can be useful to hide them to reduce the amount of accounts to work with. 

NOTE you cannot delete a group unless it is empty and that includes archived accounts so you may need to switch this toggle on to see all archived accounts if you are having trouble deleting a group.

Search by name

To search for a group or account simply enter your search text in the search box on the left. Search will be performed across all groups, formulas, account codes and names and the matching items will be filtered as you type.  

Filter by company

You can select specific companies to filter by. To only show accounts for specific companies select the companies from the dropdown on the right.

Moving and copying accounts between groups

Accounts can be moved or copied from one group to another in one of the following ways:

One at a time

• Click on the three-dot menu on the right of the account you wish to move
• Select Move to or Copy to
• Select the group to move the account to
• Click on Save to save your changes

Bulk move

• Select the accounts you wish to move by clicking on the checkbox - the Bulk Move box at the top will highlight how many accounts have been selected
• When you've selected all the accounts you wish to move click on the Bulk Move button and select the group you wish to move them to - once moved your selected accounts will be cleared
• To clear all the selected accounts, click on the Bulk Move button and select Clear Selected
• To reselect the accounts you have just cleared click on the Bulk Move button and select Reselect last Cleared - helpful in case you moved accounts into the wrong group accidentally

TIP: you can select more than one account by clicking on the first account - this will highlight it green - then holding the shift button down and selecting the last account - this will select all accounts between the first and las

NOTE: You may need to Expand the group first to see the accounts before you can move/copy them - see Collapse/Expand below.

Adding/Editing Groups, Formulas and Charts

Layouts are made up of Groups, Formulas and Charts.

Groups are report sections containing accounts, or other groups and formulas - you can organise accounts into different groups of your choosing. Groups are indicated by the grey Group badge. The number of accounts, groups and formulas within a group is displayed below the group name.

Formulas are calculations performed on the group totals or results of other formulas.  Formulas are indicated using the green Formula badge. The formula itself is displayed below the formula name.

Charts are report sections that display data from groups or formulas in bar or line chart format. Charts are indicated by the Chart icon. 

Groups, Formulas and Charts can be arranged within the layout in any desired order - they can also be hidden, collapsed and styled to achieve the required report output. This section describes how to make changes to Groups, Formulas and Charts to meet your layout specification.

Quick Toolbar

You can quickly perform many of the actions described below using the Quick Toolbar. Simply hover your mouse over the Group, Formula or Chart to bring up the quick toolbar. Hover over each button to see what it does. In the section below, if an option is available through the Quick Toolbar it will be marked with QT.

Adding/Editing Groups

Groups are layout sections containing accounts. The accounts that appear within each group of a newly created layout are based on the accounts that are within the Chart of Accounts of all the Companies  you have linked.  

• The accounts will appear in the standard layout groups (Revenue, Expenses, Current Asset etc.) depending on the account mapping - see the Chart of Accounts section for more information on accounts mappings.  
• The Balance Sheet and Cashflow reports have additional accounts (for Profit for the Year and Net Income respectively) which are added automatically by Joiin.
• In the same way as Joiin merges accounts with the same name/code on the main reports, accounts are merged in the edit screen too.

To add or edit groups:

• Click on the New Group button to add a new group
• Alternatively, to edit an existing group, click on the Group Name or select Edit from the three-dot menu on the group
• Make your changes to the group options - see below
• Click on Accept to make the changes or Cancel to abort the changes
• Click on the Save button to permanently save the changes

Options for editing groups

When editing a Group there are various options available. To show the group options, click on the group's name.

Adding/Editing Formulas

Formulas are calculations that are performed when a report using this layout is run. Groups and other Formulas can be combined with operators (PLUS, MINUS etc.), KPIs and Temporals to create formulas. 

• Click on the New Formula button to add a new formula
• Alternatively, to edit an existing formula, click on the Formula Name or select Edit from the three-dot menu on the formula
• Enter or change the name of the Formula in the Formula Name field
• Build your formula using the Formula Editor - for details on how to use the formula editor see this article.
• Click on Accept to make the changes or Cancel to abort the changes
• Click on the Save button to permanently save the changes

Types of Operand

When selecting operands for your formula you can choose from the following types.

	Type	Description
	Group	A group from within the layout.
	Formula	Another formula within the layout.
	KPI	A built-in KPI. This is a convenient way to access common values without having to calculate them yourself.
	Temporal	A built-in Temporal value which can be useful for certain types of formula. Currently there are two available temporals. Days in Period - This function calculates the number of days in each period on the report. Can be used for calculating a daily value such as daily revenue, or combined with Days in Year, an annualised value such as annualised revenue. Days in Year - This function calculates the number of days in the year for each period on the report. Can be used for calculating an annualised value such as annualised revenue.
	Enter a value	This allows you to enter a fixed, numeric value into your formula - select this option and enter the required value.

* Note you cannot select another Formula as an operand if it includes the formula you're editing as an operand - this prevents circular references from occurring

Options for editing formula

When editing a Formula there are various options available.

Total Calculation Method Explained

Adding/Editing Charts

• Charts are always displayed at the top of a report.
• Charts will use the data based on the Report Filters set for the report that is being run - this is distinct from Report Pack charts which have their own report filters. You can have a combination of both on report pakcs.
• You can arrange charts so that they are in two columns or a single column.
• Click on the New Chart button to add a new chart
• Alternatively, to edit an existing chart, click on the Chart Name 
• Enter or change the name of the Chart in the Chart Name field
• Select the Chart Type: Bar, Line or Donut.
• Select the Groups or Formulas you wish to include as the Chart series.  Each group or formula you select will appear on the chart as a bar, line or donut segment.
• Click on Accept to make the changes or Cancel to abort the changes
• Click on the Save button to permanently save the changes
• To move a chart up or down, click on the up/down arrows to the top right of the chart

Options for editing charts

When editing a Chart there are various options available.

Moving and Nesting Groups

You can move groups, charts and formulas around in the layout so they appear where desired.  You can also move groups or formulas to be nested within other groups.

• Click on the three-dot menu on the group, chart or formula you wish to move
• Select Move
• Select To, Above or Below
• Select the Group, Chart or Formula to move to/above/below
• Click on the Save button to save your changes

Alternatively use the Quick Toolbar to move groups, charts and formulas up and down within the layout.

Deleting a Group, Formula or Chart

To delete a group, formula or chart:

• Click on the Group Name or select Edit from the three-dot menu on the group
• Click on the Delete button
• Click on the Save button to save your changes

NOTE Groups cannot be deleted if they have accounts in them or if they are referenced by formulas. Formulas cannot be deleted if they are referenced in other formulas.