Summary and balance list of G/L accounts
Description
This module is used to call up the totals and balances list. The debit and credit values are displayed for the selected posting period (the so-called period values), cumulated from the beginning of the fiscal year belonging to the posting period up to the specified accrual period or optionally up to the end of the corresponding fiscal year.
Totals of debit, credit and balance values are output across all accounts and additionally separated into balance sheet and profit and loss accounts.
A further option enables the additional output of cost elements posted to a profit and loss account. A difference line is displayed in red if the total of these cost element postings does not match the total costs posted to the P&L account (Find cost element differences).
If this option for displaying the cost elements is selected, you can also determine whether the profit and loss account belonging to the cost elements should be displayed at all.
A double click on a list entry navigates - if period values exist - directly to a list of postings, otherwise to an overview of the period balances of the selected fiscal year. By using the right mouse button you always reach the overview of the period balances of the selected account in the selected fiscal year.
Functionality
| Menu item | Description |
|---|---|
| Edit | - |
| : Search for cost element differences : : In Selected posting period : : In selected financial year | Either over the selected posting period or over the entire fiscal year, you can search for postings where a cost element account has posted to a different P&L account than the one currently stored in the master data of the cost element account. Such differences always arise when the allocation of a cost element account to its P&L account is changed during the fiscal year. However, the sum of all differences is always zero, since the value missing from the current P&L account is posted "too much" in the previously assigned P&L account. |
| Check account balances : : In Selected posting period : : In selected financial year | Either over the selected posting period or over the entire fiscal year, you can check whether the balance of an account does not match the total of the postings to this account. Such differences cannot actually arise due to the transaction security of the database. Nevertheless, it is basically possible that transaction descriptions are adapted to individual customers and that these are faulty. |
| Close | Close window |
| Symbol | Description |
|---|---|
 | When all the presettings have been set as desired, the summary, balance list is created. |
 | Copy the list to the clipboard. |
 | Easy printing of the list. |
| Field | Description | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Posting period | The first time the mask is opened, the posting periods of the current fiscal year are displayed. The current posting period is pre-selected. By pressing the "Posting period" button you can select previous financial years. | ||||||||||||||||||||||
| Issue accounts without period values | Accounts that do not show any values for the selected posting period are also displayed. Otherwise, a list of only the accounts that were posted to in the selected posting period is displayed. (default setting) | ||||||||||||||||||||||
| Issue accounts without annual values | Accounts that do not show any values for the selected financial year are also output. Otherwise, you receive a list of only those accounts that were posted to in the fiscal year. | ||||||||||||||||||||||
| Outputting cost elements | Below each P&L account, the posted cost elements are also displayed with their values. If this option is selected, the next field becomes visible. | ||||||||||||||||||||||
| : Hide P&L accounts | If this option is selected, the P&L account belonging to the cost elements is omitted in the listing. | ||||||||||||||||||||||
| Company codes | If a posting to company codes is planned for the client, the summary and balance list can also be output for individual or several company codes. If one or more company codes are selected, then you can specify in the next field "deduct" whether the values of the selected company code(s) should be deducted from the client, i.e. you get a client totals and balance list without the values of the selected company code(s) | ||||||||||||||||||||||
| Accumulated values | - | ||||||||||||||||||||||
| : End of period | Cumulation of values from the beginning of the financial year to the end of the selected accounting period. | ||||||||||||||||||||||
| : End of financial year | Accumulation of values over the entire financial year. | ||||||||||||||||||||||
| List |
| ||||||||||||||||||||||
| Totals | Totals of debit, credit and balance values are output across all accounts and additionally separated into balance sheet and profit and loss accounts. |
Related topics
- Index
- Totals and balance list for debtors
- Totals and balance list for creditors
- Totals, balance list Employees
Technical documentation
Summary and balance list of G/L accounts
Module name
glacbals.mod
Classes
-
Security
In addition to restricting access rights via the class and its data fields, the module can be restricted in its use via some of the received messages.
| Message | Parameters | Function | Security |
|---|---|---|---|
| Message | Parameters | Function | Receiver module |
|---|---|---|---|
;){kind=link}
;){kind=link}
;){kind=link}