Language: EN
Log in

Account & billing

Export payments (CSV and DATEV format)

  • Last updated:

Under Payment reports & export, you see the guest payments recorded in tapcoat, online and cash, and export them for your accounting or tax advisor.

The reports are available if your organization uses online payments (add-on) or the Guest till feature (depending on the plan). Otherwise, the page shows a note with a link to Licences & upgrades.

Review payments

  1. In the dashboard, open Settings and, in the Guest payments & billing area, click Payment reports & export.
  2. Under Filter, choose the period with From and To.
  3. Under Aggregation, choose whether you want to see Single transactions or totals Per day or Per month.
  4. If needed, narrow down by payment method (online or cash), Event and Cloakroom.
  5. Click Refresh preview. The Preview shows the number of transactions as well as gross, net and VAT.

Export

Button Result
Export CSV CSV file with the payments in the selected filter, for example for a spreadsheet
DATEV posting batch export in DATEV format (posting batch) for online payments
DATEV cash journal export in DATEV format (cash journal) for cash payments
PDF batch PDF documents for the payments in the filter as a ZIP file (Managers only)

The export in DATEV format (posting batch, cash journal) is only available for organizations in Germany. DATEV posting batch only becomes active once the DATEV settings are complete.

“DATEV cash journal” is the name of the export format; the file is not a cash book.

A PDF batch is created in the background. When it’s ready, you receive an email at your account’s address. Under PDF batch downloads, you can download finished ZIP files again later.

DATEV settings

Only people with the Manager role can see and change the DATEV settings.
  1. On the Payment reports & export page, scroll to DATEV settings.
  2. Enter Advisor number, Client number, Chart of accounts, Tax key (VAT), Revenue account and Bank account (online). You get these values from your tax advisor.
  3. Click Save DATEV settings.
The export is an export aid. It replaces neither your accounting nor your cash register system and is no assurance that your records meet tax requirements. Check the files before importing them and clarify accounts and keys with your tax advisor. The tax obligations lie with you as the operator.

More articles: Payment at the cloakroom · Cash register · Setting up online payments

Up and running without an IT project.

Sign up for free, create an event in the dashboard, invite your team, scan the first code.

Sign up