| Button | Description |
|---|---|
| Cancel (Esc) | Will cancel your selections. |
| Go to the first first record | Goes to the first period. |
| Go to previous record | Changes to the previous period. If the From period and To period fields are not the same period, this button will change both to and from periods one period back. |
| Go to next record | Changes to the next period. If the From period and To period fields are not the same period, this button will change both to and from periods one period forward. |
| Go to the last record | Goes to the last period. |
| Field | Description |
|---|---|
| Period | An ID of the financial period |
| Control account module | With this field, you can select which control account module you want to perform reconciliation on. A control account is a general ledger account that aggregates the balances of entities in a ledger; it can be used for analytical purposes as well as for the reconciliation of balances between ledgers and the General ledger. You indicate that an account is to be used as a control account for a particular subledger by selecting the ledger. The alternatives are:
|
| Account | Select the control account you want to use in the reconciliation |
| Company | The company you want to filter on. If no company and branch are selected, you will get the sum of all companies.
Note
Company and branch is only available when Multi-branch is activated |
| Branch | The Branch you want to filter on. If no branch is selected, you will get all branches for the selected company. |
| Column | Description |
|---|---|
| Account | The account (associated with the specified branch) whose balance will be updated by the journal entry. |
| Branch | The unique ID of the branch. |
| Account name | The name of the control account. |
| Control account module | This field indicates which control account module is selected for this reconciliation batch. The alternatives are:
|
| Allow manual entry | A check mark that restrict direct posting to the control accounts. If the check mark is set, it indicates that the account allows manual entry to correct the errors the reconciliation discloses. |
| Last period | The last period transactions have been posted on this account. |
| Balance General ledger | A statement of all transactions made in the General ledger at the time given in the field Last period. The link will open the window General ledger details. |
| Balance Supplier ledger | This field displays the Supplier ledger ’s balance for the selected financial period. |
| Balance Customer ledger | This field displays the Customer ledger ’s balance for the selected financial period. |
| Discrepancy | The discrepancy amount is the difference from what is expected or acceptable between the account and the ledgers you have set to calculate. |
| Column | Description |
|---|---|
| Currency ID | The currency for the transactions have been posted. |
| Balance general ledger (currency) | A statement of all transactions made in the General ledger at the time given in the field Last period in currency. |
| Balance supplier ledger (currency) | This field displays the Supplier ledger’s balance for the selected financial period in currency. |
| Balance customer ledger (currency) | This field displays the customer ledger’s balance in currency for the selected financial period. |
| Discrepancy (currency) | The discrepancy amount is the difference from what is expected or acceptable between the account and the ledgers you have set to calculate in currency. |
| Button | Description |
|---|---|
| Release/post | By clicking Release/post, you will release marked documents. Only documents with the error message Not released in General ledger or Not posted in General ledger will be processed. The button is only active if you have selected the Discrepancy category Unposted/Unreleased. |
| Hide/Unhide | A button for hiding/unhiding selected lines. This is used for discrepancy lines that have been corrected. |
| Set reconciled period | A button for updating the reconciled period, used to suggest the From period. This period is found in General ledger preferences - Discrepancy settings, Reconciled financial period. |
| Field | Description |
|---|---|
| Company | Filter on Company. The column is only visible if you have activated multi-branch. |
| Branch | Filter on Branch. The column is only visible if you have activated multi-branch. |
| Discrepancy category | Filtering different categories of discrepancies.
[NN] The numbers correspond with the Discrepancy category (in the top part), see information in the Discrepancy column in the table. |
| Include hidden lines | Selecting this checkbox will display previously hidden transactions, and you will be able to unhide the documents again. |
| From period | Filter on From period. The period is suggested from Reconciled financial period in General ledger preferences and, if that is empty, it will suggest the first open period from Financial periods. |
| To period | Filter on To period. |
| Account | Filter on Account. You can only select accounts defined as Control account module for customers and suppliers. |
| Customer | Filter on Customer. Select the customer you wish to filter upon. |
| Sum Customer ledger | Sum based on the selected tab for Customer ledger documents. |
| Sum General ledger | Sum based on the selected tab for the General ledger documents. |
| Sum discrepancies | Sum based on the selected tab for discrepancies between the Customer ledger and the General ledger documents. |
| Column | Description |
|---|---|
| Note | This is the Note from the transaction. If the line contains a General ledger transaction, it will be the note you see or can edit and if the line only contains a Customer transaction, it will be the invoice note that will shown and can be edited. |
| Selected | The selection column for lines you want to hide/unhide or release/post. |
| Hidden | A check box that, when selected, indicates that the transaction is hidden. To hide or unhide, you can select the line and click the Hide/Unhide button. You hide transactions when you have found a matching correction transaction, so you do not need to check them again. |
| Discrepancy | Discrepancy types:
[99] the number exists in the database text, so it can be used in Generic queries |
| Discrepancy amount | The difference between Customer ledger amount and General ledger amount. (General ledger amount - Customer ledger amount) |
| Currency discrepancy amount | The difference between Customer ledger amount and General ledger amount in currency. |
| Branch, Customer ledger | The branch for the Customer ledger document. This document is found in the Financial setting section in customer documents. |
| Transaction type, Customer ledger | The transaction type of the customer document. |
| Ref. no, Customer ledger | The reference number of the customer document. |
| Amount, Customer ledger | The total amount for the customer document. |
| Adjustment amount, Customer ledger | Currency gain or loss amount. |
| Currency, Customer ledger | The currency of the customer document. |
| Currency rate, Customer ledger | The currency rate for the customer document. |
| Currency amount, Customer ledger | The total amount in currency for the customer document. |
| Workspace | The workspace for the voucher line in the General ledger, if the general ledger transaction is missing, it will display Customer ledger. |
| Transaction type, General ledger | The Transaction type for the voucher line in the General ledger. |
| Ref. no, General ledger | The Reference number for the voucher line in the General ledger. |
| Branch, General ledger | The Branch for the voucher line in the General ledger. |
| General ledger, batch number | The Batch no. for the voucher line in the General ledger. |
| Currency amount, General ledger | The Currency amount for the voucher line in the General ledger. |
| Amount, General ledger | The Amount for the voucher line. |
| Account number | The Account number for the transaction. |
| Account description | The Account name for the account. |
| Period, customer | Financial period for the customer document. |
| Period, General ledger | Financial period for the General ledger transactions. |
| AR Created | The date when the customer document was created. |
| AR Created by Screen ID | The window where the customer document was created. The screen ID will tell you what window the document was created in. (00000000 = created by API). |
| AR Last modified by screen ID | The window where the customer document was last edited. The screen ID will tell you what window the document was modified in. (00000000 = created by API). |
| GL Created | The date when the General ledger transaction was created. |
| Created by window ID General ledger | The window where the GL Batch was created. The screen ID will tell you what window the document was created in. (00000000 = created by API). |
| GL Last modified by screen ID | The window where the customer document was last edited. The screen ID will tell you what window the document was modified in. (00000000 = created by API). |