November 2020 - Product release overview

Enhanced Templates Library

The templates library has been upgraded to include:

:white_check_mark: Paid Templates provided by DataDear and Experts
:white_check_mark: Improved and better filters

Paid Templates

The Templates Library has been converted into a marketplace allowing both free and paid templates to be available in the library. Free templates will continue to be provided by DataDear and these will be designed to help users with starting point to customise their own reports. Paid templates will be more sophisticated templates designed around solving specific problems and are published and maintained by DataDear Experts. The process works as follows:

  1. Download the Paid Template
  2. Try it out a few times
  3. Purchase the Template
  4. Allocate this to your company / companies
  5. Use the Template without any restrictions

:information_source: If you would like to create and contribute to the Templates Library, watch this space as guidelines will be published shortly.

Improved Filters

In addition to the My Paid Templates button, you can now filter for templates:
:small_orange_diamond: Featured & New
:small_orange_diamond: For Company or a Group of companies
:small_orange_diamond: By Application
:small_orange_diamond: By Type of use
:small_orange_diamond: By Category
:small_orange_diamond: By Price

As the number of templates in the templates library continues to increase, an improved layout with new filters has been introduced so it is easier to find the required template. Further functional improvements in this area will be introduced in the coming weeks.

Xero - Advanced Management Reports for single and group of companies

The most sophisticated report provided by the DataDear team and a highly requested feature by finance teams!

This advanced report allows you to create management accounts for a single Xero company or a DataDear group based on customisable:

:white_check_mark: Reporting Sections
:white_check_mark: Account Groupings
:white_check_mark: Account Sub-Groups
:white_check_mark: Income Statement and Balance Sheet Mappings
:white_check_mark: Checks for all mappings
:white_check_mark: Profit & Loss and Balance Sheet

The Profit & Loss and the Balance Sheet reports are based on reporting structures created on top of the Chart of Accounts which is used to establish how you wish to display the reports using both sections and groupings.

Report 1 - Profit & Loss

Report 2 - Balance Sheet

:information_source: Visit the Templates Library to try out this template!

Giving users more rights

Another highly requested feature by larger teams is to allow designated users to be able to help with the management of the Organisations and with the Management of users.


Now this will be possible by toggling the respective “Yes/No” options in the Users page - welcome to a new way of collaboration and getting help from colleagues!

Manage organisations

When choosing this option, the user will be able to:
:small_orange_diamond: add new organisations / companies
:small_orange_diamond: create new groups
:small_orange_diamond: edit existing ones (such as assigning a friendly name)
:small_orange_diamond: view usage and properties

Manage users

When choosing this option, the user will be able to:
:small_orange_diamond: add new users and resend invite
:small_orange_diamond: view login history
:small_orange_diamond: assign permissions & rights
:small_orange_diamond: delete users

Tax Reporting - VAT Return for Xero Global

This was officially launched last month and has just got better as the following features have been improved:

:small_orange_diamond: The account owner can limit access to the VAT module per connected organisation / company. This can be done from the Permissions tab next to the name of the user.

:small_orange_diamond: All the mapping and tax reports created by a member of the team will be visible to all users having access to the VAT reporting module within the same account.

:small_orange_diamond: Any saved templates for tax rates are visible to all users within the DataDear account so these can be used across the practice.

Outstanding (Aged) Reports (Payables and Receivables)

These reports have been improved:

Expected / Planned payment dates

A new Detailed Report option in the parameters window provides more information to a group of companies and also shows the Expected / Planned payment dates:

When using the Detailed Report option, the report will also include these extra columns:


DataDear Groups

When using a multi-currency group, the values within the columns are converted to the group currency based on forex rate of the day. This together with an extra column showing the organisation and group currency will provide a more accurate value of the outstanding amounts across the group.

Construction Industry Scheme

The report now also includes the CIS data which was previously ignored. This is useful for the UK construction industry.

Introducing DataDear365

As we have been anticipating over the last few months, the DataDear365 is a new Excel add-in sitting on the side of your Excel and can be installed directly from the Excel > Insert toolbar.

This is still a preview (which means it lacks several functionalities) version and the team will continue to work over the coming months to bring both add-ins to the same level. The data tables and reports provided by the add-in is correct and reliable.

If you wish to have a look :eyes: follow the steps below:

  1. Open Excel and click on the Insert toolbar
  2. Click Get Add-ins
  3. Search for DataDear
  4. Use the green Add button to install the Add-in

:construction: Feedback on this add-in is welcome! Support on this new add-in will be limited as several features are still being developed. :construction:

Other Improvements

  • Colour DataDear Sheets - DataDear created sheets will now be coloured differently depending the application being used.

  • Xero Accounts table - Adding “Current Year Earnings” as another line per company in the accounts data table. This is helpful when creating certain reports.

  • Xero Contacts table - This data table is now also available for DataDear Groups. It also shows all the persons associated with the contact.

  • Various bug fixes and performance improvements.

The upgrade will start on the 11th November 7.00am UTC (18.00 AEDT / 20.00 NZDT / 09.00 CEST / 9.00 SAST / 00.00 PDT) and will take no more than 1 hour during which DataDear will be unavailable. The add-in will update automatically once you open Excel after the release is completed.

1 Like

A post was split to a new topic: Templates Libary not working