What possibilities does billwerks accounting export offer me?

Follow

1. Introduction

The transfer of business transactions processed with billwerk to your financial accounting is simple and flexible. You can display the data

  • transaction-based with debitor accounts
  • transaction-based with G/L accounts
  • and aggregated on a time-related basis

While the first two options differ in whether receivables are to be posted in the debitor account or in the account for trade receivables, the third option allows you to transfer summarized figures to Financial Accounting for one month.

2. Configuration

Under "Settings > Accounting > Accounts" you configure the billwerk accounting export.

2.1 Debitor accounts vs. G/L account

You can first choose whether you want to use the debitor accounts or a G/L account for the receivables.
If you activate "Use debitor accounts", billwerk uses the debitor ID stored for the customer as the customer debitor number. This therefore presupposes that all customers have such a debitor ID before a financial accounting export.

accounting1.png

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

accounting2.png


2.2 Accrued expenses and deferred income

If you choose the "Include deferrals" option, billwerk automatically generates deferred income (PRAPs) for all revenues whose performance period exceeds a calendar month. You can set up an account from your financial accounting. The current month is not delimited.

Example for bookings in billwerk including PRAPs and their deferrals:

Postings:
24.01.2019 - 10031 to 8400 - 142.80 EUR - Document no. RE-0120
24.01.2019 - 8400 to 0990 - 117.50 EUR - "Abgrenzung RE-0120 bis 2019-02"
28.02.2019 - 0990 to 8400 - 10.00 EUR - "Abgrenzung RE-0120 aufl. 2019-02"
...
31.12.2019 - 0990 to 8400 - 10.00 EUR - "Abgrenzung RE-0120 aufl. 2019-12 "
31.01.2020 - 0990 to 8400 - 7.50 EUR - "Abgrenzung RE-0120 aufl. 2020-01"

 

2.3 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.

2.4 Revenues

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

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.

accounting3.png

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

accounting4.png

 

3. Export of financial accounting data

3.1 Transaction-based financial accounting data

You will find detailed instructions on how to perform the FiBu export in the following article:

Please read on here

 

3.2 Time-aggregated financial accounting data

If you want to transfer the data to your financial accounting on a time-aggregated basis, you can do this via "Activities > Reporting > Aggregated Accounting".

accounting6.png

Select the desired period and export the financial accounting data. You receive a csv file with the aggregated financial accounting data for the required period.

Bildschirmfoto_2017-09-27_um_17.08.39.JPG

The columns contain the following values:

  • Month - the selected report period
  • Currency - the invoiced currency; a separate line is generated for each currency
  • Account - the revenue account
  • VatPercentage - the applied tax rate; a separate line is generated for each tax
  • TotalGross - the total gross amount of the proceeds
  • TotalVatFromGross - the tax amount calculated from the total gross amount and the tax rate
  • TotalNetFromGross - the net total calculated from the gross total and tax amount
  • TotalVatSum - the sum of all tax amounts of the invoices for this tax rate and this currency
  • TotalNetSum - the sum of all net amounts of invoices for this tax rate and this currency
  • Deferrals - the total amount of accruals and deferred income newly accrued in this period
  • ResolvedDeferrals - the total amount of all deferred income released in this period

 

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