What do the different cash accounting journal settings do?

This document explains some important settings related to the journal file from the cash statement. When it refers to an 'export file', it means the file that is the result of an export routine.

When it refers to an 'export table', the data in RetailVista is meant, which can be used to create reports and from which a journal file is ultimately created.

Some settings only affect the export file, while other settings affect the export table. The consequence of this distinction is that certain settings only take effect if the journals are first removed from RetailVista and then rebuilt. Other settings that apply to the export files can be adjusted without first removing and rebuilding journals. These settings are applied as part of the export process.

Compress non-cash payments

Cash statement sales export including VAT: By activating this, the sales rules in the journal export file are supplemented with the VAT value. Most accounting software generally prefer to receive sales excluding VAT.

Separately export VAT: By activating this, separate lines with only the VAT information are added to the journal file.

At this moment, this setting is exclusively used for the journal file that is exported to Twinfield. This setting is similar to the aforementioned 'revenue accountability turnover export including VAT', but works additionally: By choosing 'Revenue excluding VAT' in the revenue setting, it can be indicated with this setting that separate lines with the VAT amounts are added.

Also export cash mutation: By activating this setting, an extra line is added to the export file as cash mutation.

This means that RetailVista calculates the increase or decrease of the total cash and sends it as a separate line to the financial software. Most accounting applications calculate the cash mutation themselves, but in some cases, it can also be sent along.

The cash mutation is essentially the difference in cash between the previous journal and the current journal. Kind of like the total amount in the drawers and safe between the previous and current journal. Revenue accountability journal debit/credit sign: This setting determines in the journal export file whether RetailVista may place a token (- or +) in the export file. There are accounting applications that want to determine the sign themselves based on their own debit or credit setting.

Reverse revenue accountability journal debit/credit: This setting determines in the journal export file whether RetailVista may reverse the debit and credit columns. Not every accounting application has the same view on what debit and credit are, or in other cases, it has to do with from which standpoint an accounting is set up.