In this article you will learn how to export your accounting from the tax consultant portal, which file formats and options you can combine, what the export contains and how to create the same export through the Open API.
Contents
- Quick Guide
- Prerequisites
- The tax consultant portal
- Create an export
- File formats and options
- What the export contains
- Export through the Open API
- Export lists
Quick Guide
- Open Finance / Tax consultant / Tax consultant portal.
- Select Export.
- Choose the File format and the Period.
- Tick at least one option, for example Individual postings per posting account with the Excel format.
- Select Export again to create the file.
Prerequisites
Your role needs the permission Use tax advisor portal in the category Finance.
The account numbers in the export come from the accounting configuration of your studio. To change which revenue goes to which account, see Accounting configuration: setup, activation and change history and Managing booking rules.
The tax consultant portal
Open Finance / Tax consultant / Tax consultant portal. The portal shows the bookings of the selected month by account group and the payments as cash flow. Select the month at the top to change the period.
Account groups contain all bookings, for example the charge of a membership fee and its later payment. The cash flow contains only payments. A membership fee that is due in one month and paid in the next therefore appears in the account groups of the first month and in the cash flow of the second month.
Create an export
- In the tax consultant portal, select Export in the upper right corner.
- Under File format, choose the format. The available formats are listed in the next section.
- Under Period, choose the start and end date. The period can end yesterday at the latest.
- Tick the options you need under Account groups, Cash flow and Cash registers. At least one option must be ticked, otherwise the software shows At least one export option must be activated.
- Select Export at the bottom of the dialog. The file is downloaded to your computer.
File formats and options
The dialog offers these formats:
- Export as PDF file: a PDF file for reading and printing. This format is preselected.
- Export as excel file: an Excel file.
- export as CSV file: a CSV file in DATEV structure, with bookings summarised per account.
- Invoice export: only offered if all selected studios use invoice-based accounting.
- export as SAP file: only offered if this export has been set up for your company.
Not every option can be combined with every format. The dialog greys out options that do not fit the selected format:
| Option | export as CSV file | Export as PDF file | Export as excel file |
|---|---|---|---|
| Balanced posting accounts | Yes | Yes | No |
| Individual postings per posting account | No | No | Yes |
| Payments by payment type | No | Yes | No |
| Detailed export of payment runs | No | Yes | Yes |
| Cash journals | No | Yes | No |
| Cash journal closings | No | Yes | No |
Individual postings per posting account and Detailed export of payment runs exclude each other: if you tick one, the other is greyed out.
If you want to import the bookings into your accounting software line by line, choose Export as excel file with Individual postings per posting account.
What the export contains
Each booking line has a debit and a credit side, shown in the columns Account and Counter account. They contain the account numbers of the posting accounts in your accounting configuration. The export with individual postings also contains, among others, the booking date, the net amount, the VAT rate and amount, the gross amount, the customer number and a booking text.
Booking codes, booking rule names and article names as separate columns are not part of the export. If you need revenue per booking code in your accounting software, give each booking code its own revenue account, see Booking codes: setup, booking rules and assignment.
Example (amounts and account numbers are illustrations): a member is charged a monthly fee of 59.90 on the 1st and pays it by direct debit on the 15th.
- The charge on the 1st creates a line with the member account as Account and the revenue account of the fee, for example 4100, as Counter account. This line carries the VAT.
- The payment on the 15th creates a line with the bank account as Account and the member account as Counter account. It carries no VAT, because the VAT was already recorded with the charge.
Account numbers in the software always consist of 4 to 9 digits. If your accounting software uses other codes, for example three-digit codes, map the account numbers during the import.
Export through the Open API
If you want to load the bookings into your accounting software automatically, you can create the same export through the Open API under /v1/taxadvisor/exports. The export runs in two steps:
-
POST /v1/taxadvisor/exports/createstarts the export and returns an export ID. -
GET /v1/taxadvisor/exports/{exportId}returns the download data, including the download URL, once the export is ready.
| Parameter | Values |
|---|---|
fromDate, toDate
|
Booking date range. Both dates must be in the past, and the range can be at most 90 days. |
exportFormat |
SINGLE: every booking as a single line. AGGREGATED: bookings summarised per account number. |
exportFileFormat |
JSON, CSV or XLSX
|
exportLocale |
ENGLISH or GERMAN, optional |
The application that calls the API needs the scopes TAX_ADVISOR_EXPORT_WRITE for creating and TAX_ADVISOR_EXPORT_READ for downloading the export.
Export lists
Further lists, for example the export list Booking codes with the booking codes of your rates and articles, are under Finance / Tax consultant / Export lists.
Note: This article was created with the help of artificial intelligence and editorially reviewed.