Latest News: MIDAS v4.30 Out Now | Refer-a-Friend | We Stand With Ukraine

Posts Tagged: export

There’s a whole host of new features in MIDAS v4.25. One area that’s had a big overhaul for this update is invoicing. Combined with this, we’ve also overhauled the exporting capabilities of our software. You can now export invoice data to several popular 3rd party accounting packages.

MIDAS can export invoices to QuickBooks Online, Xero, Clear Books, and KashFlow.

In addition, you can also export Invoice Summaries to Sage Business Cloud, and QuickFile.

Export invoice to QuickBooks, Sage, Xero and more!
Export invoice to QuickBooks, Sage, Xero and more!

Exported data is tailored to each specific accounting package in CSV format, allowing for easy import.

We also provide some additional export options for applicable accounting packages. For example, to allow you to specify a ledger/account code, or to map a custom customer field in MIDAS to a customer reference field in your account package.

Additional format-specific export options
Additional format-specific export options

For more information on exporting invoices from MIDAS to 3rd party account packages, please see our KB articles:

Plus, you can still export in previously available formats too. These include Excel, standard CSV (comma separated values), Tab-Delimited Text File, and XML formats.

We’ve improved these too, as they now also include each invoice’s Payment Terms, and therefore their Due Dates as well.


These are just a few of the new and improved features for MIDAS v4.25. Please see this post for details of other new features you’ll find in v4.25.

Reddit You can also ask questions and discuss the new features of v4.25 over on Reddit.

Statistics and Reporting Improvements

We’re making some improvements to Statistics and Reporting for v4.25. These include…

Filter Options

To declutter the Statistics & Reporting screen, the display of filters – such as date range selection – can now be toggled. There’s a new “Filter” button at the top of Statistics screens:

Advance Filter Options may be accessed via the new "Filter" button
Advance Filter Options may be accessed via the new “Filter” button

Clicking this button will toggle the display of applicable filters for the current report:

Advanced Filters shown for Booking Statistics report
Advanced Filters shown for Booking Statistics report

Filter Venue Statistics By Booking Type

Previously, Venue Statistics report generation was for all venues, or for an individual venue. Now, it’s possible to further filter Venue Statistics by Booking Type too.

Identify Clients Who Are Also Users

When viewing Statistics for an individual client, MIDAS will now indicate whether that client also has a user account in the system.

Export Statistics

Since v4.18, it’s been possible to export Statistics and Reports in Excel format (.xlsx). This feature was available to all users who had access to the Statistics screen (via the “Can Use Statistics” User Permission).

As we’re introducing a dedicated “Can Import / Export” user permission for v4.25, the ability to export Statistics and Reports will now only be available to users who are allowed to export data.


These are just a few of the new and improved features for MIDAS v4.25. Please see this post for details of other new features you’ll find in v4.25.

Reddit You can also ask questions and discuss the new features of v4.25 over on Reddit.

User Management Improvements

For v4.25, we’ve made a some improvements to user management. These include..

New “Can Search” Permission

We’ve added a new “Can Search” user permission allowing administrators to control which users can access the Search features within MIDAS.

New “Can Import / Export” Permission

We’ve also added a new “Can Import / Export” user permission allowing administrators to control which users can import and/or export data. As well as simple Yes/No options, this setting also includes “Export Only” and “Import Only” options too.

Re-Show The Quick Tour Upon A User’s Next Login

Re-enable the Quick Tour option on any user account. The next time the user logs in, they’ll be presented with the option of a quick tour of the user interface. For more information please see this post.

Support For Users On Unstable Connections

One of the security features we built into MIDAS automatically logs out a user’s session if it detects their IP address has changed. As a result of the COVID-19 pandemic, we found many more users were working remotely from home. Often their home internet connections were unstable, or their ISPs were under heavy load as a result of increased demand. Consequently, some users were finding that their IP address was frequently changing. In some cases, this was happening every couple of minutes! Due to the security restrictions we built into our software, this meant they were being frequently logged out of their MIDAS system.

So for v4.25, we’ve introduced a new “User is on an unstable connection” setting. With this setting enabled on a give user account, MIDAS will ignore any IP address changes whilst the user is logged in. This means that even if their IP address changes, they will remain logged into MIDAS.

This setting, disabled by default, should only be temporarily enabled for users who are experiencing frequent log outs due to a fluctuating IP address.

Optionally Add New Users As Clients

Whenever an administrator adds a new user to their MIDAS system, a corresponding entry is automatically made in the client database for the individual. This is because it is generally assumed that there will be instances when a user adds a booking for themselves.

However, following customer feedback, we’ve now made automatically adding a new user as a client optional. Now, when a new user is added, an “Also add user as a client” box is shown. If this box is unselected, the new user will be added without an associated entry made in the client database.

Easily Toggle “View Access” settings

The “View Access” options allows an administrator to control which venue groups (and therefore venues) a user has access to. By default users have access to all venue groups, but there may be instances when you wish to restrict this. If you have a long list of venue groups, it can be tedious to manually check/uncheck lots of groups. As such we’ve added a way to “toggle” all currently selected groups. Simply click/tap on the “View Access” label, and all checked groups will become unchecked, and vice versa.

Easily toggle View Access options
Easily toggle selected “View Access” options for a user by clicking/tapping “View Access”

These are just a few of the new and improved features for MIDAS v4.25. Please see this post for details of other new features you’ll find in v4.25.

Reddit You can also ask questions and discuss the new features of v4.25 over on Reddit.

We think we’ve really “Excelled” with our forthcoming update to MIDAS… literally!

…because we’re adding the ability to export directly in the native Excel (2007+) .xlsx format.

Previously in MIDAS, if you wished to export bookings, clients, invoice summaries, or resources directly to Excel, you’d first need to export as a .CSV (Comma Separated Values) file, and then import this file into Excel.

However, in MIDAS v4.18, you’ll now be able to export data directly into a native .xlsx Excel 2007+ format!

Export data to Excel (.xlsx)
Export data to Excel (.xlsx)

Furthermore, following customer feedback, we’re also providing the ability to export Statistics & Reports data directly to Excel too. On Statistics report pages you’ll now find an “Export” icon:

Export statistics to Excel (.xlsx)
Export statistics to Excel (.xlsx)

Self-Hosted Customers: Please note – in order to take advantage of the new Excel export options in MIDAS v4.18, you’ll need to ensure that the Perl module “Excel::Writer::XLSX” has been installed on your server. (This module is already installed on our cloud-hosted infrastructure). For assistance installing Perl modules on your server, please refer to our KB article: How to install Perl modules.

Click here to continue reading about some of the other new & improved features coming in MIDAS v4.18!