The Data quality report goes through your setup and your data for typical mistakes that can make the accounts, the stock or the statistics fail to add up. It collects concrete findings that you can fix, and for each finding it shows a priority (high = fix first) and often the amount affected plus a hint about where to fix it.
You find the report under printouts as "Data quality" (also available as an Excel version). It runs for the accounting books and stock setups you have access to. If a setup is deliberately made in a certain way, the individual check can be switched off for that accounting book or stock setup so it stops reporting.
Below is an overview of what the report checks.
Accounting and account setup
Financial setup and error accounts – accounts in the financial setup that are missing, belong to another accounting book or are error accounts; error accounts that are not set or allow postings; and the default bank and cash account not excluding VAT as a contra account.
VAT setup – VAT types with a rate but no VAT account, and cost-of-goods accounts with a VAT type that has VAT.
VAT types on accounts – sales and stock-receipt accounts on product categories with no VAT type (so sales and purchases on them get no VAT), and books where no account has a VAT type.
Standard chart of accounts (SAF-T) – ledger accounts without a standard account and VAT types without a standard VAT type, which the SAF-T export requires.
Account groups – account groups not set up, ledger accounts with no account group or in several, and account groups that do not net to zero, so the income statement and balance do not add up.
Number series running out – number series in the accounting book that are used up or have 5 % or less left.
Company payment details – stores without an FI creditor number or bank account, and mismatches between the company's and the stores' payment details.
Products and categories
Accounts on product categories and account groups – product categories whose accounts are missing, are error accounts or do not match the stock bookkeeping (services on a stock account, no cost of goods, sales on a stock account), and empty Stock and Revenue account groups.
Products and booked revenue – sold products where "Include in revenue" does not match whether the category's sales account is in the Revenue, Hourly work or Rental account groups.
Action codes and revenue
Action codes counting as revenue – action codes used in the last year that count towards revenue: consider whether the lines are really sales.
Action codes and booked revenue – action codes where "Include in revenue" does not match the bookkeeping, so the lines count in the sales statistics but not in the booked revenue, or vice versa.
Bookkeeping and reconciliation
Manual postings on stock and sales accounts – postings a user has made in a draft directly on a stock or sales account in the last year.
Purchase invoice lines on the wrong account – services on purchase invoices moved to a stock account, and stock products booked outside the stock accounts, in the last year.
Stock not booked in finance – stock entries without a finance date, unbooked cost-price adjustments on stock drafts, and stock-draft vouchers between stock accounts booked with VAT.
Failed cost-of-goods adjustments after cost-price changes – cost-price adjustments where the booked cost of goods has not been corrected along with them.
Failed bookings and missing till settlements – invoices, purchase invoices and till settlements that could not be booked, and till sales not included in a till settlement.
Stock
Product stock value – products with a negative stock quantity and products whose stock value differs from quantity times cost price.
Serial-number product – stock value – serial-number products where the stock value is not as expected.
Operations
Unprocessed emails in the digital inbox – emails in the digital inbox that could not be processed automatically.
Unfinished time registrations – departments with more than 10 time registrations that are not finished and have not changed in over a month.
Customer data and GDPR
CPR numbers in customer names – customers with a CPR number in the name or address, which is printed on invoices and receipts.
Template texts – texts for emails, receipts and labels that still contain the template's "Customer name", "XXXXXXXX" or "Cloud Retail Systems".
High-priority findings should be fixed first. If you have questions about a finding, you are welcome to contact support.

