Skip to content

Which reports you have and how to export them to Excel or CSV

An overview of Reports (trends, VAT, profitability, top products, claims, stock ageing) and of the exports in Reports and Accounting.

The shop reports are in Reports › Reports. Choose the dates and click Query.

Tabs

  • Trends: sales by day and by category.
  • Tax / VAT: base, output VAT (with equivalence surcharge), input VAT and the difference for the period.
  • Profitability: margin of the period's documents, by product and category.
  • Top Products: best sellers by volume (not money collected).
  • Claims: returns and claims in the period.
  • Stock ageing: dead stock and value by age.

Export

With export permission, at the top you have Sales (Excel), Tax (Excel), Inventory (Excel) and Customers (Excel).

In Accounting, each tab (receivables, no collection document, payables, P&L, VAT, 347, received invoices, general ledger) has Export CSV with what you are viewing. In Banks, Export CSV downloads the reconciled movements for your accountant.

If you have several shops, Company › Consolidated reports adds up all of them.

Keep in mind

  • Money in the reports comes from documents and matches the POS daily report for the same day. Sales volume, money collected and tax revenue for the same day can differ: they are different things.
  • The VAT tab needs the tax viewing permission; Profitability, the profit viewing permission; the Excel buttons, the report export permission.
  • The pack for your tax adviser and the official files are in Company › Tax returns («Tax filing» add-on).
Back to the help centre