---
title: "Accounting export"
slug: "accounting-export"
updated: 2026-07-27T15:46:07Z
published: 2026-07-27T15:46:07Z
canonical: "help.frisbii.com/accounting-export"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.frisbii.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Accounting export

**Plans supporting this feature:** Growth Enterprise

With our DATEV accounting export, you can seamlessly transfer your financial data from Frisbii Billing to DATEV, the leading accounting software in Germany. This means no more manual data entry or double-checking, saving you valuable time and effort.

You can find the option to enable the feature under **Configurations → Finance and accounting → Accounting export.**

![](https://cdn.document360.io/b84e1b5d-2ba6-4465-8c62-fb45a2f31314/Images/Documentation/image-1PA84H5E.png?sv=2026-02-06&spr=https&st=2026-07-27T15%3A25%3A34Z&se=2026-07-27T15%3A40%3A34Z&sr=c&sp=r&sig=T3O0AYP76MpI4veZfNRWjEDUi2%2FSU17b5DZy7ySdI9s%3D)

## General export settings

> [!WARNING]
> Accounting export will function correctly if you have set up the following components.
> 
> - Make sure that the Account [**Timezone**](/frisbii/docs/account-settings) is set up accurately.
> - Confirm that the [**Invoice numbering**](/frisbii/docs/invoice-settings) is turned on.
> - Either the Automatic **Debtor Id** feature is activated, or you must verify that **every** customer has a proper Debtor Id configured.

Turn on the automated accounting export by enabling the toggle “Enable accounting export”.

![](https://cdn.document360.io/b84e1b5d-2ba6-4465-8c62-fb45a2f31314/Images/Documentation/image-TL7C9XKV.png?sv=2026-02-06&spr=https&st=2026-07-27T15%3A25%3A34Z&se=2026-07-27T15%3A40%3A34Z&sr=c&sp=r&sig=T3O0AYP76MpI4veZfNRWjEDUi2%2FSU17b5DZy7ySdI9s%3D)

Then choose your desired **export format**:

- **DATEV**: You will receive a format that's compatible with the accounting program “DATEV” which can be customized using the settings below.
- **CSV**: You will receive a neutral CSV-format containing your accounting data.

Next, choose your desired **export interval**: Choose how often you would like to get your accounting exports generated. You can choose between:

- **Monthly**: Accounting exports will be generated on the first of the following month for the previous month.
- **Weekly**: Accounting exports will be generated every Monday for the previous week.
- **Daily**: Accounting exports will be generated every day for the previous day.

##### DATEV export settings

If you have chosen DATEV, in the **General export settings**, you can configure how your DATEV exports should look like:

- **Include header**: You can decide whether you want your DATEV export to include a header. If you want a header to be part of your DATEV-export, make sure to also fill in the settings for “DATEV consultant” and “DATEV client”.
  - “On” means that the export file includes the header and thus complies with **DATEV’s EXTF-format.**
  - “Off” means that the export file does not include the header and hence complies with **DATEV’s ASCII-format.**
- **DATEV consultant**: Enter here your DATEV consultant number. It will be included in the header of your DATEV-export files.
- **DATEV client**: Enter here your DATEV client ID. It will be included in the header of your DATEV-export files.

> [!NOTE]
> Tip
> 
> If you don't use DATEV, but any system that is compatible with the DATEV-format, you can enter any dummy values here.

- **G/L account length**: Select how many digits your account numbers have. Please note: In DATEV it is not possible to decrease the length of the field "G/L Account length" after it has been increased.
- **G/L account chart type**: Postings will be generated using the standard account numbers of the selected G/L account chart type. Please select between SKR03 and SKR04. These are the standard accounts that are assigned by default:

### Standard Chart of Accounts

| **SKR03** | **Domestic (DE)** | **EU** | **Non-EU countries** |
| --- | --- | --- | --- |
| **B2B** | 8449 (19 % VAT) 8334 (7 % VAT) | 8337 | 8338 |
| **B2C** | 8332 |
| Payments | 1211 |
| Deferrals | 0990 (Germany), 0991 (EU), 0992 (Third party countries) |

| **SKR04** | **Domestic (DE)** | **EU** | **Non-EU countries** |
| --- | --- | --- | --- |
| **B2B** | 4449 (19 % VAT) 4334 (7 % VAT) | 4337 | 4338 |
| **B2C** | 4332 |
| Payments | 1811 |
| Deferrals | 3900 (Germany), 3901 (EU), 3902 (Third party countries) |

> [!NOTE]
> **Note**
> 
> For B2C invoices to other EU-countries, Frisbii Billing always assumes local tax rates are applied and that you take part in the OSS procedure.

### Override Deferral/Revenue Posting Keys

In addition to overwriting the account number itself, you can optionally override the **BU-Schlüssel (posting key)** — the German tax/posting code that DATEV requires alongside each account number — for a specific transaction type.

- The **account number** is still always chosen automatically by the system — this doesn't change.
- The override only changes the additional tax code attached to that account number, and only for the specific transaction type you configure it for.
- If you don't set an override, nothing changes: the system keeps using its normal default code, the same as before.
- If you do set an override for a given transaction type, that code is used instead from then on, for that type only.

To set up an override, go to **Override Deferral Posting Keys/Override Revenue Posting Keys** and, for the relevant **Tax Type** (for example Domestic deferrals standard tax rate, Domestic deferrals reduced tax rate, EU deferrals (B2C), EU deferrals (B2B), or Non-EU deferrals), enter your **Override value**. The **Default value** column shows the system's standard code for reference. Click **Add** to save it.

> [!NOTE]
> **Note**
> 
> This override only applies to your regular booking export. It doesn't affect the separate alternate revenue export report, which always uses the system default code, regardless of any override you've set.

![](https://cdn.document360.io/b84e1b5d-2ba6-4465-8c62-fb45a2f31314/Images/Documentation/image-ZN2BGC1G.png)

### Overwrite Standard Chart of Accounts

For each account that will be used in your DATEV-export, you can overwrite the before mentioned standard accounts by writing your account number into the respective field on the left.

![](https://cdn.document360.io/b84e1b5d-2ba6-4465-8c62-fb45a2f31314/Images/Documentation/image-L5JA2FVD.png?sv=2026-02-06&spr=https&st=2026-07-27T15%3A25%3A34Z&se=2026-07-27T15%3A40%3A34Z&sr=c&sp=r&sig=T3O0AYP76MpI4veZfNRWjEDUi2%2FSU17b5DZy7ySdI9s%3D)

When recording bookings, the following tax codes (booking keys) apply, irrespective whether you use our standard accounts or your own values:

### Tax codes (Booking keys)

| **Tax rate/use case** | **Tax Key** |
| --- | --- |
| VAT 7 % | 2 |
| VAT 19 % | 3 |
| EU tax rates | 250 |
| Blocks DATEV from automatically deducing tax when booking from a deferral amount on a revenue account, except for revenues that are subject to VAT in another EU country | 40 |

## Debtor Id settings

You can choose to automatically assign debtor Ids to new customers in order to identify each customer customer in your accounting. The assigned debtor ID will be used as the customer's debtor account number in your accounting export.

In order to assign debtor Ids automatically, enable “Automatically assign Debtor IDs to new customers” and configure from what number the system should start counting, then save your settings.

![](https://cdn.document360.io/b84e1b5d-2ba6-4465-8c62-fb45a2f31314/Images/Documentation/image-CTH9Y9Y0.png?sv=2026-02-06&spr=https&st=2026-07-27T15%3A25%3A34Z&se=2026-07-27T15%3A40%3A34Z&sr=c&sp=r&sig=T3O0AYP76MpI4veZfNRWjEDUi2%2FSU17b5DZy7ySdI9s%3D)

> [!WARNING]
> **Important**
> 
> Debtor Ids can also be assigned manually/via API when creating a new customer. Please be aware that manually assigned debtor Ids should always be lower than the next debtor Id that should be assigned automatically.

## Transfer Accounting Export to Google Drive, OneDrive, SFTP

### GoogleDrive

You can send your accounting export files automatically to your own Google Drive by following these easy steps:

Steps for using the **Google Drive API:**

1. Set up a Google Cloud project:
  1. Go to the Google Cloud Console.
  2. Create a new project or use an existing one.
  3. Activate the Google Drive API for your project.
2. Create OAuth 2.0 credentials:
  1. Navigate to "APIs & Services" > "Login data".
  2. Create OAuth 2.0 credentials and download the JSON file with the Client ID and Client Secret values.
3. Enable Google Drive and configure the client secret and the folder-Id in the Accounting export settings.

## OneDrive

Steps for using the **Microsoft Graph API**:

1. Set up Azure AD application:
  1. Go to the [Azure Portal](https://portal.azure.com/).
  2. Register a new application under "Azure Active Directory" > "App registrations".
  3. Make a note of the application ID (client ID) and the directory ID (tenant ID).
  4. Create a new client secret under "Certificates & secrets" and make a note of the secret.
2. Enable OneDrive and configure the client-Id, client secret, tenant-Id, drive-Id and upload path in the Accounting export settings.

### SFTP

You can also choose to transfer the accounting exports to your own SFTP.

> [!WARNING]
> **Important**
> 
> The following IP addresses need to be on the whitelist so that exports can be received via SFTP:
> 
> - Test Account: `18.198.112.162`
> - Production Account: `3.70.163.236`

In the Accounting export settings, simply enable the SFTP-export and fill the following settings:

- server URL,
- user,
- password,
- port,
- and path.