How can I configure the accounting export?

Follow

To configure the accounting export, go to "Settings > Accounting > Accounts". All configurable financial accounts appear here. Revenue accounts and accounts for means of payment can only be configured as soon as the first posting for the respective country and tax rate has been created due to a receivable posting after an invoice or when the first payment has been made using the means of payment. 

Please note that if you change the account assignment, postings that have already been exported and are affected by this change are automatically corrected. billwerk creates a reversal posting against the previous account and a new posting with the changed account assignment.

Posting "drafts" - i.e. postings that have not yet been exported - are not affected by this.

General settings

You can choose for which target system the financial accounting exports should be created.

You can choose between the following target systems:

  • DATEV (this option is also available if you use the Lexware format)
  • SAP

If you use the EXTF (DATEV External Format) you can additionally store your Datev Consultant and your Datev Client

If the target system is SAP, you can enter a tax code for deferrals.

mceclip0.png

 

You can also define the start of the fiscal year. Additionally, you can specify whether the accounting records should be summarized per invoice/credit note, or whether a separate posting should be created per line item.

Debitor accounts vs. G/L account

You can first choose whether you want to use the customer accounts or a G/L account for the receivables.
If you activate "Use debitor accounts", billwerk uses the debitor ID saved for the customers as the customer debitor number. This means that before exporting financial accounting data, you must ensure that all customers have such a debitor ID. You can manage this under "Settings > Accounting> Debitor Ids". Here you can also create debitor IDs for customers who are already in your account and do not yet have one.

mceclip1.png

Deactivate this option to post the receivables to the G/L account "Account for receivables".

Accrued expenses and deferred income

If you choose the "Include deferrals" option, billwerk automatically generates deferred income for all revenues whose performance period exceeds a calendar month. You can set up an account from your financial accounting. You can find further information in this article.

Payments

billwerk can export all recorded payments for your financial accounting. This makes sense, as the majority of these payments are usually made automatically and billwerk is also automatically informed about the status of each individual payment.

Use the "Include payments" option to activate this option. For each means of payment used, a separate financial accounting bank account can be deposited.

Revenue

The revenue accounts are managed in the last section of the financial accounting account configuration. billwerk offers you the following settings per country and tax rate for each tax rule used:

  • Account type
    • Here you can choose between the output of the gross value or the net value and the sales tax
  • Account
    • The revenue account and - if "Net" is selected as the account type
  • Account for tax
    • the VAT account for the tax rule applied
  • Tax Code 
    • the tax code (only for SAP)

The "gross" account type is used if the financial accounting system supports automatic accounts and is to make the split posting for the sales tax included.

        mceclip4.png

As already described, you can also explicitly specify the sales tax account for the "Net" account.

mceclip3.png

For SAP exports you can also enter a tax code

mceclip2.png

 

Was this article helpful?
1 out of 1 found this helpful