- invantiveget my report
- invantivecurrency toolsFree
- invantivecloudfor Power BI
- invantivecontrolfor Excel
- invantivecompositionfor Word
- invantivebusinessfor Outlook
- invantivebusinessfor Windows
- invantivequery toolFree
- invantiveonline sql editorFree
- invantivedata loaderFree
- invantivedata hub
- invantivedata access point
- invantivedata replicator
Analysis, reporting, consolidation and risk control within Microsoft Excel and Exact Online
Real-time reporting and analysis with Microsoft Excel and Exact Online
Invantive Control is an Excel add-in. Invantive Control provides businesses and organizations with all the information needed to make real-time management decisions. In addition Invantive Control empowers you to create, secure and share (Qlikview, Power BI) detailed Excel models and reports in Microsoft Excel.
The input and outcome of your Excel models will be exchanged with your Exact Online administrations. It doesn't matter whether you report, process or consolidate 1 or 100 administrations. With Invantive Control you will have all the functionalities you need to structure your reports and to decide how to optimise your business in real-time.
Invantive Control for Excel is compatible with all solutions of Exact Online. Frequently used reports are:
- Sales overview
- Speed of items in the stock
- Liquidity prognosis
- Sales forecast
- Liquidity planning
- Cash flow
- Financial dashboard
- Financial statements
- Budget versus actuals across cost centres and cost units
- Time sheets and revenues across all projects per period
- Check lists for invoices, stock control and projects
- Generate general ledger transactions for reconciliation and cost/revenue allocation
- Create and import complex calculations
- Import data from other applications and databases
- One-time migration or continuous conversion for switching to Exact Online
You don't need a consultant to compose a report; using the hundreds readily available Excel functions on general ledger, debtors, creditors, fixed assets, but also on logistics, trade, projects and production you easily compose your own report. Any the outcome of your formulas are updated automatically every time you open the report in the form of an Excel workbook.
Already existing Exact Globe Excel add-in reports can easily be converted by you to Invantive Control. The creation of new reports such as a trial balance is also aided by a report wizard, which allows you to create and configure new reports using the mouse. Large volumes of Exact Online data sets can also be downloaded easily into a worksheet of their own.
You can also use the bundled Microsoft Power BI Data Access Point to process data such as KPIs from Exact Online in your Microsoft Power BI reports.
For worldwide reporting and analysis on Exact Online you can use Invantive SQL to collect data across multiple Exact Online countries. Also you can use the so-called "distributed option" to real time combine and change data across multiple databases through SQL as if all company data are one big data warehouse. Access is available for XML, Microsoft SQL Server, MySQL and PostgreSQL. Access to enterprise platforms such as Teradata, IBM or Oracle requires a difference license form.
All features of the software can be used during 30 days for free. After registration you will get invoiced EUR 50 every month you use Invantive Control for Excel (per named user). There is no term of notice; when you stop using the software you will only get an invoice for the current month and no subsequent invoices.
According to our users are "Excel Controller", "VisionPlanner", "Speedbooks" and "CData" similar solutions for similar reporting and consolidatie problems which you can also solve using Invantive Control. Don't forget to also consider these alternatives!
The software can be active at the same time as other popular Excel add-ins such as CaseWare for accountancy.
This edition can address at most 2 administrations; contact us for the pricing of additional administrations. Compatible with Microsoft Office 2013, 2016, 2019 and Office 365 for Microsoft Windows, both 32 and 64 bit versions.
Cash flows, Finance, Risks, Valuations and Exact Online, together in control
The Exact Online Edition of Invantive Controls provides you with benefits such as:
- Flexibility of Microsoft Excel paired with the data integrity provided by Exact Online in the cloud.
- Download and upload facts to Exact Online directly from within Excel using an Excel add-in.
- Process, consolidate and report 1 or 100 administrations at once.
- Easy-to-use Excel formulas to retrieve facts from Exact and data blocks for large volumes.
- Calculate projected figures, future cash flows and return on capital investment in real-time.
- Use Exact Online data from within Microsoft Power BI.
Load Exact Online fast and easy into Power BI or Power Query
With Invantive Cloud you are loading current Exact Online data into Power BI and Excel (Power Query) within minutes. No need for an extra connector and easily process data using Power BI web. Invantive is the only supplier to provide access to all data made available by Exact; in total approximately 1.000 tables across all Exact Online modules such as manufacturing, distribution and PSA. You can also easily load tens of companies instead of just one. Finally you can not only work with Exact Online, but also with approximately 70 other platforms such as Teamleader and various Visma products.
Pricing starts with a free subscription for Exact Online Netherlands. Additionally we offer a guaranteed lowest price in case you find somewhere else a better offering. Details available on opening page of the Invantive Cloud site.
- Free: completely free of charge when at most 5 Dutch Exact Online companies are available, a total yearly revenue of at most EUR 1 M and with a daily maximum download of 100.000 rows.
- Basic, EUR 15 per month for 100.000 daily downloaded rows when at most 5 Dutch Exact Online companies are used with a total yearly revenue of at most EUR 3 M.
- EUR 49 per month within a subscription to Invantive Office for Accountants per 50 Exact Online companies and other platforms such as Loket, Teamleader and Salesforce.
- EUR 49 per month within a subscription to Invantive Office for Entrepreneurs per the first two users and 100 Exact Online companies and other platforms such as Loket, Teamleader and Salesforce.
- Cash planning
- Sales dashboard
- Budget versus actuals per cost center and cost unit
- Hours and revenues across all projects in a year
Invantive Cloud for Power BI provides you with benefits such as:
- Live within 2 minutes.
- Runs always and everywhere; no extra connector.
- Approximately 1.000 tables across all modules.
- Load one or more companies.
- Dozens of additional platforms supported in addition to Exact Online.
Generate complex documents or serial letters in Microsoft Word with data from Exact Online
Save money by merging data from Exact Online with Microsoft Word documents
An often occurring business problem is the generation of complex documents or serial letters with data from Exact Online. For instance, employees spend a lot of time composing correct sales quotes, contracts, invoices, pack slips, general ledger cards or Profit and Loss sheets. This manual and repetitive activity causes unnecessary employee costs and more erroneous composed documents reducing business profit. The efficient automatic generation and creation of documents is easily done using Invantive Composition! You can easily combine texts, bar codes and images from Exact Online with standard templates or create labels with a 2D bar code.
Invantive Composition for Word is compatible with all solutions of Exact Online.
You can also use the bundled Microsoft Power BI Data Access Point to process data from Exact Online in your Microsoft Power BI reports.
According to our users the "Advisie Offerte Tool" for Exact Globe is a comparable solution specifically for quotes.
All features of the software can be used during 30 days for free. After registration you will get invoiced EUR 50 every month you use Invantive Composition (per named user). There is no term of notice; when you stop using the software you will only get an invoice for the current month and no subsequent invoices.
Invantive Composition for Word is compatible with all solutions of Exact Online.
Compatible with Microsoft Office 2010, 2013 and 2016 for Microsoft Windows, both 32 and 64 bit versions.
Your gains by filling a Word template with data from Exact Online
The automated filling from Exact Online with Invantive Composition will bring you advantages such as:
- Automatically fill pre-composed templates in Microsoft Word..
- Focus on your business; without any programming and without Excel downloads.
- Reduce time-to-market for changing your business.
- Merge texts and images in a document with structured data from Exact Online.
- Optimise your documentation and communication process.
- Reduce production costs of documents.
- At most 2 administrations, contact us for more.
Execute SQL queries on Exact Online
Free Real-time Business Intelligence for Exact Online
Invantive's free SQL Query Tool for Exact Online provides you with real-time Business Intelligence across your entire enterprise. It provides access to your crucial company information stored in the Exact Online cloud. No programming, no coding, no Excel downloads; just use the SQL knowledge you already have gained using ODBC driver or JDBC. This enables you to organize your business data fast for correct decision making. You are be able to extract, analyze and report business data such as sales leads, project execution, general ledger transactions and accounts payables.
Optimize your Business Intelligence with Exact Online and the Invantive Query Tool
The Invantive Query Tool provides all the functionalities needed to make the right business decisions based upon your business data in the Exact Online cloud. Businesses and organizations will be provided with the following benefits:
- Automatic analysis of your business activities, compliance and business rules.
- Uncover threats and opportunities by turning business data into real-time intelligence.
- Connect real-time to Exact Online corporate data for both on and off database reporting.
- Share reports in PDF, SQL, CSV, Excel and XPS formats with information from Exact Online.
- Directly connect to Exact Online; no programming, no coding, no Excel downloads.
- Open SQL scripts from the file system or a document management system.
For use we request you to provide us with your contact data.
The supported SQL grammar and the restrictions are available on https://www.invantive.com/products/invantive-sql/grammar.
The free edition is limited to 100 rows when used in combination with Invantive SQL.
Optimize your Business Intelligence with Exact Online and the Invantive Query Tool
The Exact Online Edition of Invantive Query Tool provides you with benefits such as:
- Free query tool for Exact Online.
- Use of SQL for your Exact Online environment.
- Consolidate and report on hundreds of administrations at once.
- No programming is needed to access the Exact Online webservices.
- Re-use your existing SQL skills.
online sql editor
Free Online SQL Editor for Exact Online via web browser
The Online SQL Editor for Exact Online provides you with real-time Business Intelligence. It doesn't matter where you are; via the web browser you can login from any location and you are be able to extract, organize and analyze data, stored in the cloud of Exact Online. The requested information can then be processed easily into insightful reports. Then, you can save your reports in PDF, Excel and other formats.
This allows you to visualize opportunities and threats and deliver reports to the management. This way you can make the right business decisions.
For use we request you to provide us with your contact data.
The supported SQL grammar for your query and the restrictions are available on https://www.invantive.com/products/invantive-sql/grammar, but of course the most SQL statements you have learned using ODBC driver or JDBC will work too.
Optimize your Business Intelligence and the Online SQL Editor
The Online SQL Editor provides you with the following benefits:
- Interactive and online access to your company information via any modern web browser
- Usable from any location and any platform, such as Windows, Mac, Linux, iPhone, iPad etc.
- Connect directly with Exact Online with the same credentials.
- Share reports in PDF, Excel and other formats with information from Exact Online
- Over 400 tables and views accessible through both XML and REST APIs
- Consolidate and report across one or multiple administrations at once.
Connect your applications using proven Invantive technology and ADO.NET
Invantive Bridge is an SDK that enables your applications and databases to connect using the same technical features as offered by the range of Invantive products. Invantive Bridge provides cloud connectivity as well as an advanced SQL engine and drivers. With Invantive Bridge you can access your cloud and on-premise applications and data from within Microsoft Visual Studio, Microsoft Power BI, Telerik and many others using familiar SQL statements and Microsoft ADO.NET.
The use of the cloud connectivity options of Invantive Bridge allows you to use a wealth of connection options to combine applications, processes and data across the cloud into one connected solution.
The advanced Invantive SQL engine within the SDK enables your solutions to offer an easy reporting and analysis environment independent of and in addition to the connectivity protocols already available. Both 32 and 64 bit drivers are supported.
The following Invantive SQL features are included:
Connections can be made to the platforms listed below. Some connectors such as traditional database drivers require additional licenses and/or software:
- Business Exact Online
- Business Invantive Vision
- IBM DB2/UDB
- Dynamics CRM
- ECB Exchange Rates
- Exact Online Combined
- Microsoft Graph
- In Memory Storage
- OAuth Headless
- OAuth Windows Forms
- Oracle Legacy
- Oracle Managed
- SQL Server
- XML Audit File Cash Registers
- XML Audit File Financial
- XML Audit File Salary
- The preferred dealer for Invantive's PowerBI solutions is KPI Solutions. You can reach Gino van Altena by email firstname.lastname@example.org and by mobile phone +31 6 23 16 02 51.
Invantive Bridge connects your applications
The Exact Online Edition of Invantive Bridge provides you with benefits such as:
- Microsoft Power BI and Visual Studio.
- Microsoft ADO.NET driver.
- Advanced Invantive SQL engine.
- Large number of possible on-premise and cloud platforms.
Controlled and timed data exchange for Exact Online
Invantive Data Hub is command-line driven software that is capable of executing Invantive Query Tool-compatible scripts on Exact Online. Ideal for high volume data loads (import) and extractions (export) for Exact Online ("ETL"). It provides a headless mode which makes it ideal for use in server environments and scheduled uploads and downloads in lights-out operations. But also interfaces for EDI (XML, text), MailChimp, outbound email, PayPal, web services, cash registers, XML Audit files (XAF, XAA, XAS), Odoo and/or SugarCRM can easily be established using the available connectors. Data Hub also assists you with a an initial migration or continuous conversion for switching to Exact Online.
Thanks to the seamless compatibility with the popular Invantive Query Tool scripting language, you can easily move business processes you have designed on Invantive Query Tool into a server environment. Besides high volume data loads (such as importing General Ledger Transactions) you can also generate reports in Excel and other formats using data from Exact Online and export documents such as invoices. For this you will use Invantive SQL, similar to the SQL you use with ODBC driver or JDBC.
Supports database platforms in addition to Exact Online are for example:
- Microsoft SQL Server
- Dynamics CRM
- Office 365
The support for headless mode enables Invantive Data Hub to be started by batch files or from the Windows Task Scheduler. When running Invantive Data Hub in headless mode, you will enjoy the integrated logging features for easy analysis and auditability.
For worldwide reporting and analysis on Exact Online you can use Invantive SQL to collect data across multiple Exact Online countries. Also you can use the so-called "distributed option" to real time combine and change data across multiple databases through SQL as if all company data are one big data warehouse. Access is available for XML, Microsoft SQL Server, MySQL and PostgreSQL. Access to enterprise platforms such as Teradata, IBM or Oracle requires a different license form.
All features of the software can be used during 30 days for free. After registration you will get invoiced EUR 50 every month you use Invantive Data Hub (per server and two administrations). Each additional administration is charged EUR 5. There is no term of notice; when you stop using the software you will only get an invoice for the current month and no subsequent invoices.
According to our users are "CData" and "Invantive Data Access Point" similar solutions for exchanging data with Exact Online through SQL. Don't forget to also consider these alternatives!
Optimize your Exact Online business processes
The Exact Online Edition of Invantive Data Hub provides the following benefits to optimize your business processes:
- Schedule and run high volume data loads and extractions of Exact Online.
- Headless and command-line driven for use on servers.
- Invantive Query Tool-scripting language compatible.
- Share reports in PDF, SQL, CSV, Excel and XPS format to network shares or Dropbox.
Replicate data from Exact Online in a relational database
Invantive Data Replicator allows you to replicate data from Exact Online and over 50 other platforms in a relational database such as Microsoft SQL Server or PostgreSQL. Invantive Data Replicator ensures the presence of sufficiently "fresh" data for your reporting purposes by applying a combination of techniques, including near real-time synchronization using webhooks (where available and supported).
The replicated data is made available through configurable views, including consolidation across multiple companies such as with Exact Online and Nmbrs. Effectively you get a so-called "ODS" (Operational Data Store). The performance gain compared with repeatedly accessing the XML and REST APIs of Exact Online is between 50 and 2.500.
These database views can be used in your Power BI reports, Microsoft Access, custom reports and from traditional SQL. Data Replicator also automatically maintains indexes for optimal performance even with very large data sets and ad-hoc queries.
The advanced Invantive SQL engine included with Invantive Data Replicator enables you to configure the cloud sources for Data Replicator and trigger downloads. Data Replicator also includes Invantive Data Hub and Invantive Data Cache, so you can also run ad-hoc queries directly on over 50 cloud platforms, including cross-company and cross-country queries and uploads in Exact Online.
Data Replicator runs on 32 and 64 bit Windows devices. For compliance with data management and Exact Online guidelines you can only replicate data in a database managed by the owner of the Exact Online companies or by the legal entity administered.
- The first subscription period includes 1 hour of Getting Started consultancy.
- Subscription per 100 companies.
- Support available 9:00-17:00 CET through phone +31 88 00 26 599 or email@example.com.
Replicate your Exact Online data with Invantive Data Replicator
The Exact Online Edition of Invantive Data Replicate provides the following benefits to optimize your business processes:
- Replication ensures use of fresh data.
- Fresh data using a combination of techniques.
- Consolidation into one reporting environment.
- Runs on inexpensive PostgreSQL and Microsoft SQL Server databases.
- Over 50 supported on-premise and cloud platforms.
Load data into cloud applications and relational databases
Invantive Data Loader transports data between Exact Online, cloud applications, relational databases and files in one integrated solution. Based upon Invantive SQL with it's dozens of connectors, you can easily load data into your cloud application or relational database using a graphical user interface.
For instance, Invantive Data Loader guides you through the exchanging data with Exact Online and many other platforms with a few clicks. It can take data from over 50 platforms such as Microsoft SQL Server, PostgreSQL, Exact Online, Freshdesk or CSV or Excel files.
The integrated advanced Invantive SQL engine provides a proven base for you to exchange data, including the use of fast bulk loaders on supported platforms such as Microsoft SQL Server. A flexible mapping of fields enables basic transformations during the process, while the flexibility of Invantive SQL on the background ensures that no tasks is too hard to accomplish.
The free version of Invantive Data Loader is restricted to at most 1.000 rows per run. For high volume use or background processing, please consider the use of compatible enterprise solutions such as Invantive Data Hub or Invantive Control. An unlimited use variant is included in these solutions.
Business for Outlook
Easily access to your business data in Exact Online
Save money by combining Microsoft Word documents with data from Exact Online
You have spent numerous hours to organize, clean and improve your business data in Exact Online. Invantive Business for Microsoft Outlook leverages this incredible power of your business data in Exact Online. Through a deep integration with Microsoft Outlook, you can easily access your business data in Exact Online.
To get started, click in the Download section on ' One Click Install' to download Invantive Business for Outlook.
- Share contact data, like email addresses, between Exact Online and Outlook.
- Send mailings using information about prospects and current customers.
- Archive emails and documents at your offers , orders etc. within Exact Online.
- Register time on Exact Online projects from your Outlook calendar.
Business for Windows
Run your Exact Online business processes on Microsoft Windows
Invantive Business enables you to run your Exact Online business processes on Microsoft Windows. This allows on-premises extensions and customizations for a better fit to your business. Also, Invantive Business allows you in an enterprise environment to reduce training costs and improve business processes by consolidating the use of multiple similar applications behind one frontend.
The one-size-fits-all approach of Exact Online eases implementation and reduces pricing levels at the cost of reduced flexibility to adapt the software to different business processes. However, the additional labor costs to compensate the missing flexibility can outweigh the reduced costs as compared to traditional on-premises solutions. With Invantive Business you can easily extend Exact Online by using Invantive Business as a frontend to cloud applications and use the enterprise-features of Invantive Business to add additional functionality and integrations to Exact Online. Such additional functionality can be additional forms, reports, downloads or integrations.
In enterprise environments, it is not uncommon to find multiple applications of different vendors or versions to provide similar functionality across multiple companies owned. For instance, one company uses Microsoft CRM whereas another one runs Exact Online. In such situations, Invantive Business can be configured such that it real-time integrates all similar data across multiple applications into one consolidated enterprise-wide view. For instance, Invantive Business allows you to retrieve all customers from both Microsoft CRM as Exact Online in one overview.
To get started, click the 'Download' button to download Invantive Business.
- Real-time consolidate data across multiple applications into one view.
- Leverage existing skills.
- Reduce training costs for new applications.
data access point
Add additional protocol support to Exact Online APIs
The Exact Online Edition of Invantive Data Access Point is available both online and on-premise. The software allows you to exchange data across various communication protocols with Exact Online. But also interfaces for EDI (XML, text), MailChimp, outbound email, PayPal, web services, Odoo and/or Sugar CRM can easily be established using the available API connectors.
Invantive Data Access Point acts as a proxy that based upon Invantive SQL statements (such as used with ODBC driver or JDBC) exchanges data with Exact Online using ten additional API protocols:
- Excel 2007
All features of the software can be used during 30 days for free. After registration you will get invoiced EUR 50 every month you use Invantive Data Access Point (per 10 administrations). For each additional administration EUR 5 will be charged. There is no term of notice; when you stop using the software you will only get an invoice for the current month and no subsequent invoices.
According to our users are "CData" and "Invantive Data Hub" similar solutions for exchanging data with Exact Online through SQL. Don't forget to also consider these alternatives!
Cross-protocol data exchange across many platforms
Invantive Data Access Point provides the following benefits to optimize your business processes:
- Simplify business process automation by integration and orchestration.
- Extend Exact Online by supporting many additional communication protocols.
- Re-use Invantive SQL statements to specify data down- and uploads.
Free import of daily exchanges rates of foreign currencies in Exact Online
It is cumbersome to continuoulsy enter exchange rates in Exact Online when you do a lot of business in foreign currencies. Using valuta-tools.nl you can easily import daily exchange rates for almost 200 currencies in one or multiple Exact Online companies. This tool is available for all countries in which Exact Online is available.
Execute the following steps:
1. Select the Exact Online country of choice.
2. Log on by providing user and password on Exact Online.
3. Choose the tool "Load last exchange rates".
4. Choose the companies and currencies.
5. Apply the "Import" button to load the exchange rates into your Exact Online companies. Previously registered exchange rates are not changed.
- Fast, free and easy import of daily exchange rates.
- Available in all Exact Online countries.
- Archive exchange rates.
- Source ECB for rates on 31 currencies, Open Exchange Rates for almost 200 currencies.
Trusted and Free Dutch software for Exact Online Verification Code
Invantive Authenticator is a two-step verification solution for use with TOTP-protected websites and products such as Exact Online. Made in Holland by a partner of Exact, awarded accountancy app partner of the year 2017. It supports TOTP according to RFC 6238 and provides additional export/import options.
First, install the application on a Windows PC, laptop or terminal server. Then you run Invantive Authenticator from the start menu.
You can copy and paste a picture or PNG-file with a QR code into Invantive Authenticator. You can also use the button "Add" to add a QR code for which you want to get verification codes. You can also manually provide a secret. Follow the instructions on https://documentation.invantive.com/notes/webhelp/invantive-notes-circumvent-exact-online-2fa.html to retrieve the secret.
Questions, suggestions and/or comments? Preferably call us at +31 88 00 26 599. Alternatively, email your remarks to firstname.lastname@example.org.
- Made in Holland.
- Trusted and free software.
- Export accounts to QR Code images.
- Import accounts by drag&drop of QR Code images in files and clipboard.
- Integrates with other Invantive products.
Get My Report
Easily access reports with current numbers and update your business data
Get My Report is een app om actuele rapportages uit Exact Online op te vragen en gegevens in Exact Online te laden of te wijzigen. U meldt zich via uw PC, mobiele telefoon, tablet of Mac aan met uw Exact Online aanmeldcode en kunt meteen van start. U hoeft verder niks in te stellen. Get My Report werkt zowel voor een specifieke administratie als voor tientallen administraties tegelijk.
U krijgt niet alleen de beschikking over uitgebreide standaardmodules, maar u kunt vanaf EUR 500 ook bedrijfsspecifieke modules laten toevoegen zoals bijvoorbeeld een offertemodule voor uw verkoopteam.
Get My Report is an app to get reports with current number from Exact Online and Teamleader. It also offers updates and uploads, especially targeting large volumes of data to be processed. You log on using your PC, phone, tablet or Mac using the platform-specific log on code and are ready to go. No set-up needed. On accounting packages you can work with a specific company or work across all available companies.
In case you need an extension to the extensive standard modules, you can have company-specific modules added such as a quotation tool for your sales team.
Samples of popular modules are:
- Extensive sales overview.
- Download all documents as a ZIP-file.
- Overview of bank subscriptions (accountants).
- Change sales price to cost price plus customer-specific surcharge.
- Mass updates of purchase-, sales- and cost prices of articles.
- Load hundreds of thousands of business transactions in one go.
- Actuele rapportages uit Exact Online.
- Gemakkelijk gegevens massaal muteren of laden.
- Meerdere administraties in 1x gebruiken.
- Werkt op PC, mobiele telefoon, tablet en Mac.
- Uitbreidbaar met bedrijfsspecifieke modules vanaf EUR 500.
- Biesteweg 11
- 3849 RD Hierden
- the Netherlands
- Telephone: +31 88 00 26 500
- Support: +31 88 00 26 599
- Office hours: 09:00 - 17:00 CET
- Email: email@example.com
- Web: www.invantive.com
- Portal: cloud.invantive.com
- Bank: IBAN NL 42 RABO 01 23 4097 80, BIC RABO NL 2U.
- PayPal: firstname.lastname@example.org
- Rabobank Groep N.V., Branch: Rabobank Peel, Maas en Leudal.
- Sint Antoniusstraat 40, 6093 GC, Heythuysen the Netherlands