What is the desired preparation for integration with financial software?
  • 01 Jul 2024
  • 9 Minutes to read
  • Contributors
  • Dark
    Light
  • PDF

What is the desired preparation for integration with financial software?

  • Dark
    Light
  • PDF

Article summary

<span class="fr-marker" data-id="0" data-type="true" style="display: none; line-height: 0;"></span><span class="fr-marker" data-id="0" data-type="false" style="display: none; line-height: 0;"></span>

This document provides an introduction to the integration between RetailVista and various financial systems. This document provides an overview of the technical and functional impact and the role distribution between NedFox or reseller, RetailVista user, and the accountant.

What will be integrated?

Currently, RetailVista offers integrations in the areas of cash and invoicing. The cash export is used to integrate the cash register systems. Invoicing is used for invoicing deliveries to debtors, as well as for registration of personal use and waste. Inventory adjustments and corrections are currently not integrated. The integration is one-sided: journal files are provided that can be imported into a financial package. There is no import of, for example, received invoice payments and debtors.

Roadmap

The roadmap for RetailVista includes offering inventory adjustments. These will come from the 'Purchase Invoice Control' module. This module is relatively new and once proven stable and sufficiently applied, the export will be realized.

Furthermore, full integrations are planned with Multivers and Twinfield. These integrations will eliminate the need to manually export and import files. Some data will also be read back, such as debtors and received invoice payments.

Supported financial systems

RetailVista currently offers integrations to Multivers, Exact Globe, Exact Online, AccountView, and King.

There are separate documents available on the exact setup per financial system, which also describe the advantages and disadvantages of such a connection. One financial package sometimes offers more or better possibilities than another, and these implementation documents mention those points of attention.

The above export formats are also supported in many cases by other financial systems not mentioned above. Therefore, RetailVista can often be connected to financial systems that are not mentioned, for example by choosing the AccountView (CSV) or Exact Online (CSV) export format for the setup.

Licenses

In order to connect RetailVista to a financial system, the 'Financial Export' license is required. This license allows for connections to all mentioned financial applications. Therefore, there is no need to choose in advance which software will be connected when ordering this license.

Implementation

Connecting a retail environment to a financial administration requires some effort in the setup. New general ledgers may need to be created in the financial administration and/or in RetailVista. And a connection needs to be established between the cash groups and revenue types in RetailVista and the general ledger administration.

Furthermore, certain settings need to be configured in RetailVista, such as which system to connect to, whether the revenue should be presented including or excluding VAT, etc. For this purpose, a quickscan document has been developed that needs to be filled in by the accountant. With that information, NedFox or a reseller can efficiently set up and start the integration.

Role Distribution

The overview below shows the different tasks involved in the process of connecting RetailVista to a financial administration.

Handing over configuration document to accountant

NedFox or reseller

Filling out configuration document and returning it to NedFox or reseller

Accountant

Creating general ledgers

NedFox or reseller

Creating general ledger links

NedFox or reseller

Configuring RetailVista financial export

NedFox or reseller

Configuring cash reconciliation

NedFox or reseller

Creating test export for cash reconciliation

NedFox or reseller

Creating test export for invoicing

NedFox or reseller

Importing test export for cash reconciliation into financial administration

Accountant

Importing test export for invoicing

Accountant

Daily use of cash reconciliation

RetailVista user

Daily use of cash accountability journals

RetailVista user

Configuration

In order to perform the configuration of RetailVista quickly and effectively, the following information is required. This information will need to be provided by the accountant. The desired configuration items depend on the financial administration that is being linked and will be mentioned in the accompanying document.

General:

The financial links in RetailVista currently provide a link for cash transactions and a link for invoicing. Cash transactions refer to cash sales through the cash register. Inventory transactions and purchase invoices, for example, are not yet part of a financial link. Please indicate below which of the available links need to be activated.

Desired links

O Cash transactions

O Invoicing


How is the cash register setup done, is it per user (cashier) or per POS terminal/workstation. In case of setup per user, each user has their own cash drawer.

Cash register setup

O Per user

O Per POS terminal


Which financial application is being used. We support the following standard applications, but some exports are also suitable for other financial administrations.

Product

O Multivers

O Exact Globe

O Exact Online

O AccountView

O King

O Twinfield


RetailVista exports sales journals with revenue excluding VAT per cash group and the VAT component totaled per VAT rate. Some financial products want to receive revenue per cash group including VAT and then split the VAT themselves. How should the revenue per cash group be provided in a journal, including or excluding VAT?

Sales revenue delivery in journal

O Including VAT

O Excluding VAT (default)


If the revenue per cash group is provided excluding VAT, can the VAT be provided in one general ledger per VAT rate, or must the VAT be provided in a VAT general ledger per cash group. The latter requires considerably more time in setting up the cash accountability export.

Ability to set VAT general ledger per cash group

O Yes

O No (Default)

If 'Yes' is chosen here, report xxx must be printed and completed.

Not all financial administrations and not all imports work with a general ledger for VAT. Sometimes VAT must be imported using a code. Specify below the codes used for VAT as they occur in the financial package (as far as applicable VAT rate).

VAT Low



VAT Medium



VAT High



VAT None/0%



When using Exact, turnover per branch must be booked on a relationship number. What is the relationship number on which the turnover of this branch should be booked (only in case of Exact integration)

Relationship number



Cash differences are the differences that arise between the counted amount in a cash drawer and the amount that should be in the drawer.

General ledger cash differences



Safe differences are the differences that arise between the counted amount in the (sometimes fictitious) safe and the amount that should be in the safe.

General ledger safe differences



Cash transactions are the increases or decreases in outstanding cash. If a cash drawer starts with 100 euros in the morning and contains, for example, 500 euros at the end of the day (without being skimmed), a cash transaction of 400 euros occurs.

General ledger cash transaction



Safe transactions are the increases or decreases in outstanding safe money. If there is an amount of 1000 euros in the safe in the morning and due to skimming the safe contains an amount of 1800 euros at the end of the day, a safe transaction of 800 euros occurs.

General ledger safe transaction



If customers pay invoices in cash, it is a balance entry. These payments are offered by RetailVista on the specified general ledger account.

General ledger paid invoices in cash



If customers make down payments in cash, it is a balance entry. These payments are offered by RetailVista on the specified general ledger account. When items are later picked up, a corresponding negative entry is made on this general ledger.

General ledger down payments



The money that is deposited from the safe to the bank, or vice versa, the deposit of, for example, change in the safe, is recorded in the ledger below.

Ledger safe to bank



If money is taken out of the cash register during the day, for example, for payment of lunch, it is recorded as a payment from the cash register. This payment is recorded in the ledger below.

Ledger cash withdrawal



RetailVista can create a journal file per day, week, month, or on request. For example, if a journal is requested on March 25th while the month is not yet over, no journal is created. Only when a specified period is over, the journal is created. By choosing 'On request', a journal can be created at any time.

Journal per period

O Day

O Week

O Month

O On request


The turnover and VAT rules can be compressed to the end journal date of the period. The individual daily sales are effectively eliminated.

Compress turnover and VAT to end journal date

O Yes

O No (Default)


The sum of all journal lines in the journal file results in the cash mutation. Some financial applications calculate this journal mutation themselves, while others want to receive this cash mutation as an additional line in the journal file. In the first situation, the journal will not be balanced by itself, while in the latter situation, a journal is always balanced.

Add cash mutation line to journal

Yes (Default)

No


Non-cash payments (EFT payments) can be compressed per POS terminal. Different card types such as Maestro, Visa, etc. can then be combined into 1 EFT payment line per POS terminal.

Compress non-cash payments

Yes

No (Default)


Some financial applications determine the + or - sign for a general ledger mutation themselves, depending on the debit or credit setting of the general ledger. In that case, RetailVista must provide the mutations without a sign.

Include debit/credit sign in cash journal

Yes (Default)

No


Include debit/credit sign in invoice journal

Yes (Default)

No


Financial software sometimes looks at + or - amounts differently. It depends on the perspective, whether it's from the bank or the entrepreneur. Revenue from RetailVista is offered as positive by default, while payments are offered as negative. However, RetailVista can provide the opposite indication.

Reverse debit/credit sign in cash journal

Yes

No (Default)


Reverse debit/credit sign in invoice journal

Yes

No (Default)


RetailVista links cash and credit sales solely based on the combination of VAT rate and cash register group revenue/no revenue. If further breakdown is desired, it is possible. Further breakdowns work on revenue types. For example, all landscaping work can be separately provided to the financial administration. We do not prefer such breakdowns, as detailed reports can also be requested from RetailVista itself. Moreover, the integration becomes significantly more complex and expensive because linking by revenue type is labor-intensive.

Breakdown by revenue types desired

Yes

No (Default)

If 'Yes' is chosen, general ledgers must be indicated per revenue type.

Sold gift cards are registered by default per type of gift card on a separate ledger code. It is possible to create multiple variants of the same type of gift card, for example, the 'Fleurop' gift card in a 10 and 25 euro product variant. In RetailVista, there are then 2 products. Is it desired to register the sale of gift cards per individual product instead of per type of gift card?

Registration of sold gift cards per product

Yes

No (Default)

If 'Yes' is chosen, a ledger code must be indicated for each gift card product.

In addition to the above settings, it is important that the ledger numbers for cash register groups, VAT rates, payment methods, and any gift cards are aligned. For this, it is necessary to print the following reports from RetailVista. Specify the ledger code to be used for each line in each report.

Revenue and VAT ledgers per cash register group, VAT rate. If 'Yes' was chosen for the previous question 'Can set VAT ledger per cash register group', print the following report:

Ledgers per revenue type, VAT rate, and cash register group

Print report 165

If 'No' was chosen for the previous question 'Can set VAT ledger per cash register group', print the following report:

Cash register group maintenance

Print report 164

Maintenance VAT rates

Print report 163

Every non-cash payment method must be assigned to an account, except for payment methods of the type 'On account'.

Maintenance payment methods

Print report 162

The sales of gift cards are not considered as revenue but as a balance sheet item. Each type of gift card can be booked to a separate general ledger account. Specify the general ledger account to be used for each type of gift card.

Maintenance gift card types

Print report 166


Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.