Integrations and data-import

Integrate and import your most important financial data

It is hard to get good insights if your data is fragmented. Manually exporting data and merging them with Excel spreadsheets takes time and with risk of errors. Liquid connects with your current accounting software, and other tools, to bring all your data together in a single location.

Integrations overview

Microsoft Excel

Spreadsheets
Microsoft Excel

Use the Microsoft Excel import integration to import your forecasts from Excel to Liquid.

Exact Online

Accounting
Exact Online

With this API link, your accounting data is automatically synchronized from Exact Online to Liquid.

Twinfield

Accounting
Twinfield

With this API link, your accounting is automatically synchronized from Twinfield to Liquid.

Lyanthe

Invoice Access
Lyanthe

For users who use Twinfield in combination with Lyanthe, you can now easily open your invoices directly in Liquid.

Basecone

Invoice Access
Basecone

For users who use Twinfield in combination with Basecone, you can now easily open your invoices in Liquid.

Auditfile (.XAF)

Accounting
Auditfile (.XAF)

You can easily update your accounting data in Liquid by importing an Audit File (.XAF).

Nmbrs

HRIS & Payrolling
Nmbrs

Use our import wizard to import your employees from Nmbrs for your forecast into Liquid.

“Connecting Liquid to our client's accounting data just takes a few clicks.”

Jos van der Meer - Owner of Flanc

Connecting with your accounting data:
Auditfiles vs API integration

To link your accounting data with Liquid, there are two options: with an automatic API integration or by using Auditfiles. The API connection is currently available for Twinfield and Exact Online, with more integrations on the way. Auditfiles (.XAF) are available in a variety of accounting software platforms, including Yuki, Snelstart, AFAS, Moneybird, and more.

The table below shows which functionality is available for both integration types.

Functionalities

Auditfiles (.XAF)

(Most accounting software)

API integration

Twinfield and Exact Online

Synchronization
Manual upload
Import ledgers
Import debtors/creditors
Real-time reporting (actuals)
Profit & Loss (P&L) actuals
Balancesheet actuals
Cashflow actuals with Cashflow Analytics
Without Cashflow Analytics
Accounts Payable/Receivable (AP/AR)
Access underlying invoices
Forecasting
P&L, Balancesheet and Cashflow forecasts
Rolling Forecast and Forecast vs. Actuals
Consolidation
Liquid's full consolidation platform

You don't have to be an excel superhero to take control of your finances.

Liquid builds on top of RGS

RGS, also known as Reference Ledger Schedule (Dutch: Referentie Grootboekschema), is a standard taxonomy for properly categorizing ledger accounts (for turnover and costs, for example). This means that companies that are RGS-ready can immediately use all reports and functionalities in Liquid, without additional configuration.

RGS (Reference Ledger Schedule (Dutch: Referentie Grootboekschema)) is a Dutch standard for structuring accounting data. It is a taxonomy to organize all ledger accounts (“categories” that contain your transactions) within an administration. This is done by assigning an RGS code to each ledger account so that other software, like Liquid, knows what is in the ledger account (e.g. “turnover” or “costs”).

In Liquid, we use RGS to put all the ledger accounts (“categories”) in your accounts in the right place. For example, it helps us understand that a certain ledger may be about company costs, and even which company costs specifically. This way, we always generate correct Profit & Loss, Cash Flow and Balance Sheet Reports and Forecasts.

If you want to link your own accounting data to Liquid, your ledger accounts must be provided with an RGS mapping. If this is not provided by your bookkeeping software, it is also possible to assign an RGS mapping directly (one-time) to the ledger accounts in your administration in Liquid.

Explore the rest of the Liquid platform

Real-time Insights ARROW_FORWARDForecasts ARROW_FORWARDConsolidation ARROW_FORWARD