Skip to content

Tag: Export

Duty schedule: Exports

The service schedule exports give you the option to save various formats of your service schedules.

You can access this area via Service Schedule > Options

Export for Employees (PDF)
Provides a clear print view with one page per employee, which lists the working hours for the next 6 weeks.

Example of an employee working hours export:


Current Monthly Sheet (PDF)
Provides a detailed summary of the current month with all vacation and sick days as well as the target-actual hours.

Example of a monthly sheet:


Attendance List (PDF)
This list shows you the attendance and absences of your employees in the current month.


For more information about the service schedule, see here.

Register: DATEV Export

Below we describe what configuration options you have to generate your DATEV export. Certain tools require explicit sales tax postings, for example, while for others the sales account is an automatic account.

In general, the DATEV export always follows the chart of accounts and stored account plan. Revenues can either be posted directly or via a debtor account. If postings are made "directly", different payment methods are subsequently debited from the cash account.

Direct Posting without Accounts Receivable


Customer pays 119 euros (incl. 19% VAT) directly in cash

The general posting entry without accounts receivable is as follows:

Debit Credit
· 119 to · 100
· 19

If is not an automatic account, this posting entry is translated into the following postings:

Amount Debit/Credit Indicator Account Contra Account
100 C 1600 4400
19 C 1600 3806

If is an automatic account, this posting entry is translated into only the following posting:

Amount Debit/Credit Indicator Account Contra Account
119 C 1600 4400 (Automatic Account)

 


Customer pays 119 euros (incl. 19% VAT) directly with 50 euros cash and 69 euros card

The general posting entry without accounts receivable is as follows:

Debit Credit
· 50
· 69		 to · 100
· 19

In theory, both the cash account and the card account would need to post against the sales revenues. If accounts receivable accounting is used, this can be separated more cleanly. Otherwise, the cash account is typically misused as a transit account and the full amount is debited against the cash account. Subsequently, the card account is posted from the cash account.

If is not an automatic account, this posting entry is translated into the following postings:

Amount Debit/Credit Indicator Account Contra Account
100 C 1600 4400
19 C 1600 3806
69 C 1800 1600

If is an automatic account, this posting entry is translated into only the following posting:

Amount Debit/Credit Indicator Account Contra Account
119 C 1600 4400 (Automatic Account)
69 C 1800 1600

Customer pays 119 euros (incl. 19% VAT) directly with 50 euros voucher and 69 euros card

The general posting entry without accounts receivable is as follows:

Debit Credit
· 50
· 69		 to · 100
· 19

In theory, both the voucher account and the card account would need to post against the sales revenues. If accounts receivable accounting is used, this can be separated more cleanly. Otherwise, the cash account is typically debited with the full amount in this case - even though no cash transaction took place! Subsequently, the card and voucher accounts are posted from the cash account.

If is not an automatic account, this posting entry is translated into the following postings:

Amount Debit/Credit Indicator Account Contra Account
100 C 1600 4400
19 C 1600 3806
50 C 1604 1600
69 C 1800 1600

If is an automatic account, this posting entry is translated into only the following posting:

Amount Debit/Credit Indicator Account Contra Account
119 C 1600 4400 (Automatic Account)
50 C 1604 1600
69 C 1800 1600

If you choose the cash account as the reference account, your posting entries would look as follows:

Amount Debit/Credit Indicator Account Contra Account
119 C 1600 4400 (Automatic Account)
50 D 1600 1604
69 D 1600 1800

Posting with Accounts Receivable


Customer pays 119 euros (incl. 19% VAT) directly in cash

The general posting entry with accounts receivable is as follows:

Debit Credit
· 119 to · 100
· 19
· 119 to · 119

If is not an automatic account, this posting entry is translated into the following postings:

Amount Debit/Credit Indicator Account Contra Account
100 C 1200 4400
19 C 1200 3806
119 C 1600 1200

If is an automatic account, this posting entry is translated into only the following posting:

Amount Debit/Credit Indicator Account Contra Account
119 C 1200 4400 (Automatic Account)
119 C 1600 1200

 


Customer pays 119 euros (incl. 19% VAT) directly with 50 euros cash and 69 euros card

The general posting entry with accounts receivable is as follows:

Debit Credit
· 119 to · 100
· 19
· 50
· 69		 to · 119

If is not an automatic account, this posting entry is translated into the following postings:

Amount Debit/Credit Indicator Account Contra Account
100 C 1200 4400
19 C 1200 3806
50 C 1600 1200
69 C 1800 1200

If is an automatic account, this posting entry is translated into only the following posting:

Amount Debit/Credit Indicator Account Contra Account
119 C 1200 4400 (Automatic Account)
50 C 1800 1200
69 C 1800 1200

Customer pays 119 euros (incl. 19% VAT) directly with 50 euros voucher and 69 euros card

The general posting entry with accounts receivable is as follows:

Debit Credit
· 119 to · 100
· 19
· 50