Contact Us
If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.
hans.gastmayr@bi4controlling.solutions
Article
Last Month
Menu: Main Menu → Consolidation → Global Accounts In this form, the consolidation settings can be set for each global general ledger account. Field name Description code Number of the global general ledger account (group account) name Global account name UGB detail group (assets, P&L) UGB position of the general ledger account according to loc
Menu path: Main menu → Consolidation → Exchange rates All exchange rates relevant for the consolidation workflow can be entered in this form. 1.) Select the month from which the entered exchange rates should apply. 2.) If different exchange rates apply to different consolidation groups, the desired consolidation group can be entered in this field. I
In this report, currency translation is carried out in accordance with the consolidation rules. 1.) Columns in the overview: Split Description currency Local tenant currency P&L original currency P&L total in original currency P&L EURO according to exchange rate P&L total according to transaction or import rate P&L EURO according
User authorization: The User Authorization documentation describes how to configure and manage permissions for reports in the Web Client . Different levels of permissions are covered: Reports – Setting which reports a user or group can see and open. Individual reports can be made available to users.The second option would be if an entire report grou
Menu: Main menu → Consolidation → Manual postings Manual postings can be made per consolidation group in these input masks. 1.) New booking sheets can be created at any time in the booking sheet overview. 2.) After selecting a journal entry, the corresponding lines can be opened. 1.) The necessary posting lines can be entered in the line overvie
In this table, an abbreviation can and must be created for each client to be imported. If a consolidation group is also used as a client for another consolidation group, this consolidation group must also be created as a client. (Step consolidation) Field name Description code Client's initials. All client data is stored with this key. name Exact co
Expert Settings Quick Reports The Expert Settings Quick Reports documentation describes how to create selection fields: Amount types Formulas Dimensions Date For the creation of amount types, it is also described how to find out which data has been stored for which amount type: Data imports Filter of the extended amount type Search in finished repor
The consolidation is carried out in the following steps: Data imports: Data is imported from the pre systems. Various interfaces are available for import (e.g., Business Central, SQL, Excel, text, XML, web services). Data plausibility check: Depending on the data from the source systems, different plausibility checks can be performed (e.
The consolidation group can be used to control the structure in the consolidation reports, the summation levels for IC reconciliation and the eliminability of the postings per account. Console- group Designation IC Voting Group Eliminability A10 Proceeds AB: Reconciliation of revenues with expenses, inventory, fixed assets Accounts can be eliminated
If data is loaded from external accounting systems, two Excel formats are available for import by default. Additional formats can be provided in the respective customer installations. If direct connections to Business Central or other ERP or accounting systems are used, data can also be imported directly. Excel Format 1 with Intercompany Partner and
This setup is used to convert the local general ledger accounts in individual clients into group accounts. Additionally, the intercompany partner can be defined for each local general ledger account. Field name Description code <Client abbreviation>.<Financial accounting account number> One data record is created for each combination of
Menu path: Main menu → Consolidation → Reconciliation within consolidation group When reconciling the consolidation groups, the debit-credit differences that arise from elimination entries can also be analyzed and checked again in this phase. In the overview, the first value column displays the elimination entries by consolidation group and client .
In this phase, the intercompany bookings between the individual clients are reconciled. Reconciliation is performed per client and intercompany partner. On the one hand, the total of the receivables and payables accounts is reconciled. On the other hand, the total of the revenue accounts is reconciled against the expense, inventory, fixed asset, and
In this step, the actual consolidation calculations are performed. Based on the defined shares and consolidation method, the postings for the respective consolidation group are made. Intercompany postings are also eliminated in this step. Currency translation is still performed at this point based on the transaction or original exchange rates. Curre