Customer and supplier reconciliation (GL408000)
By using this window, you can set up reconciliation between
- General ledger
- and Customer ledger
- General ledger
- and Supplier ledger
The window toolbar
| 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. |
The window will display the balances on Accounts between General ledger and Customer ledger / Supplier ledger causing the discrepancies.
The top part
| 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. |
The table
| 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. |
The additional table columns
The following columns also appear if the Split by currency check box is selected.
| 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. |