Cashbook data export (PDF or Excel) - POS

This article refers to the cash book version for financial statements from April 16, 2020 or for customers who have already switched to the new cashbook.
Further helpful articles on cashbook data export:
How the accounting categories work in cashbook
The automatic assignment of accounting accounts to cashbook categories (DATEV export)
accountancy export for the cash book (DATEV)

You can export the data as a PDF (POS) document or as an Excel table (Admin Interface).

The export includes the following information:

  • Company data
  • Information on cashbook export
    • Creation Date
    • Export period
    • Cash balance beginning & end
  • Transactions
  • Summary of transactions
    • Cash balance beginning & end
    • Sum inputs & outputs

When exporting all individual transactions, each split position is displayed in one row.

PDF Export

To export PDF data directly in the cashbook, open the “History” tab.

  1. Select the time period for which you want to export the report
  2. If you leave the end date open, all transactions available up to the last date will be selected for export
  3. Confirm the period with “Yes”, the document will open automatically

It may happen that the PDF export cannot be loaded if you want to export a lot of data. It is best to select a shorter time period or use the Excel export in the Admin Interface.

Excel Export

The data can also be exported in Excel format in the Admin Interface. There are three options available. You can download the following data:

  • Single transactions – contains all data on a single transaction basis
  • Grouped by month – Groups the data by month and summarizes it by categories and tax rates
  • Grouped per Z-Bon – Groups the data per Z-Bon and summarizes it by categories and tax rates
We will show you how to access the different settings here.
  1. Go to the Admin Interface
  2. Go to settings
  3. Open the Accounting option
  4. Select the cashbook tab
  5. Enter the desired time period and data source and click on the download icon

Example image of the export

Are you currently using the free version of the cash book? You can subscribe to the full version here ›
We also answer your support requests via chat. Click here to go to the chat.

How did we do?