ingenious
Finance account report
System modules > Program settings > Finance account report

With the help of the finance account report, invoices and credit notes of a time period can be transferred to a book keeping program e.g. Datev. A time costly double recording through the bookkeeper can be avoided.

In the program settings it is determined, on which accounts which revenues are booked. Further, the formatting of the export file is preset.

 

Miscellaneous configurations of the FIBU export

Miscellaneous configurations of the FIBU export

  

Finance target format Selection list Selection from currently two different end formats.

Datev; unified billing account - the revenues will be booked on the standard accounts.

Datev; differentiated billing accounts- The revenues are booked on different accounts (see billing accounts of the items).
Export type Selection list The export can be executed for the completely whole time period or differentiated; documents already exported are not considered twice.
Configure file Button Column selection for the export file.
Debitors Selection list The debitor export can be done for all contacts of differential only for contacts within the exported projects.
Configure file Button Column selection for the debitor export file.
Export file Simple input fields/ Checklist The export file is saved with the name "FibuExp+time stamp". If the file shall be always consistent, an own name can be defined here and the respective checkbox activated.  If a prefix separator is used in the document numbers, it has to be mentioned.
Configure file Simple input field / Button As field separator, the sign expected from the bookkeeping program has to be used. Further formatting of the export file can be executed via the "configure file" button.
File depository Simple input fields / Button In the input field, the path under which the FIBU export file shall be saved can be inserted. Via the button, the path can be selected with the windows standard dialogs. 
Print reports Selection list Reports that shall be executed after export.
Standard accounts national Simple input field The standard accounts, according to the presettings from the bookkeeping / the tax accountant are to be inserted here, divided in revenue accounts, bonuses accounts and accounts for sales deductions for domestic sales,  full and half - tax rate and after tax- free sales separately.
Default accounts abroad (EU) Simple input fields The standard accounts, according to the presettings from the bookkeeping / the tax accountant are to be inserted here, divided in revenue accounts, bonuses accounts and accounts for sales deductions for EU sales, full and half - tax rate and after tax- free sales separately.
Standard accounts international Simple input fields The standard accounts, according to the presettings from the bookkeeping / the tax accountant are to be inserted here, divided in revenue accounts, bonuses accounts and accounts for sales deductions for international sales,  full and half - tax rate and after tax- free sales separately.
Further accounts Selection list / Checkbox / Simple input fields Through the gross booking and the separate booking of discounts rounding differences around 1-cent-can occur, which are booked up to choice either on the account for bonuses or a separate account. If no splitting of the discounts is desired, the checkbox "sumcalc"  can be checked (booking of the real revenues). 
Permitted finance accounts for export by split proceeds account Simple input fields During the export to split proceeds accounts, the revenues can be booked on different accounts, e.g. according to the sales positions in the documents (goods, own products...). The definition of an account is executed in the document itself. Which of the individual accounts is considered in the export, has to be inserted in the program settings.  

 

Configurate export file

The export file is created by default in the following structure:

 

If a different format is needed of the bookkeeping program, the structure can be modified via the button "configure file". The available fields can be dragged and dropped into the selection in the desired order.  For each value, also the formatting can be adjusted (there are the options of a c# string formatting).  

 

Configuration of the FIBU export file 

Configuration of the FIBU export file 

 

Modified structure and modified formatting: