Reconciliation lines Sub-Tab
This section includes the fields and descriptions for the Reconciliation lines sub-tab.
| Field | Description |
|---|---|
| Entry Date | This field shows the entry date. You cannot change the value of posted entries. If you create a new line in the window, it is necessary to enter an entry date. The date must be within the G/L open posting period of the company performing the bank reconciliation. This period can be found in the "Posting Period Setup" window. The transaction type to look for is the one specified in the field “Transaction Types,” on the line. |
| Trans. No. | This field shows the transaction number of the entry. You cannot change the value of posted entries. If you create a new line in the window, you cannot enter a transaction number. Maconomy will automatically enter a transaction number on the entry at the approval of the reconciliation. The transaction number is ignored in the number series “Bank Reconciliation.” |
| Trans. Type | In this field, you can enter a transaction type. By default, the field shows the transaction type selected in the card part. You cannot change the value of posted entries. Also, all entries with the same Trans. No. must have the same Trans. Type. |
| Description | This field shows the description of the entry. You cannot change the value of posted entries. If you create a new line in the window, it is necessary to enter an entry description. |
| Debit | This field shows the entry’s amount in the G/L account’s currency, provided that the entry is a debit entry. You cannot change the value of posted entries. If you create a new line in the window, it is necessary to enter either a debit or a credit amount. Note that a debit entry on the G/L account normally appears as a credit entry on the account statement. |
| Credit | This field shows the amount of the entry in the currency of the G/L account, provided that the entry is a credit entry. You cannot change the value of the posted entries. If you create a new line in the window, it is necessary to enter either a debit or a credit amount. Note that a credit entry on the G/L account normally appears as a debit entry on the account statement. |
| Balance | This field shows the current balance of the G/L account. |
| To Reconcile | In this field, you can specify that the entry is reconciled on approval. If you create new entries in the window, they must be reconciled. In this case, this field is automatically checked and cannot be changed. |
| Comment | In this field, you can attach a comment to the entry, for instance the entry date of the bank. |
| Date Posted | This field shows the date posted to the account. If you create a new entry in the window, this field will remain blank and cannot be changed. |
| Journal No. | This field shows the journal number posting journal to which the entry has been posted. If you create a new entry, this field will remain blank and cannot be changed. |
| Offset Account No. | If you create a new entry, this field requires that you enter the account number of the offset entry. If the new entry is a debit entry on the G/L account, and this entry is reconciled with the account statement, Maconomy will credit the offset account and vice versa. |
| Offset Account Text | This field shows the offset account text assigned to the offset account. |
| Location | In this field, you can enter a value for the dimension Location. If you do not manually enter a value, Maconomy will attempt to derive a value, using the order of priority set up in the window Dimension Derivations in the G/L module. However, any manually entered value will be overwritten if Maconomy can derive a value for which overwriting has been selected. If no value can be derived, Maconomy transfers the value from the field “Location” in the card part of the window, and if no value has been entered in the card part, the standard value is transferred from the window System Parameters in the Set-Up module.
See the section on dimension derivation in the chapter “Introduction to the G/L module” as well as the description of the window Dimension Derivations for further information about dimension derivation. |
| Entity | The functionality of this field is similar to that of the field “Location” above. |
| Project | The functionality of this field is similar to that of the field “Location” above. |
| Purpose | The functionality of this field is similar to that of the field “Location” above. |
| Spec. 1 – 10 | The functionality of these fields is similar to that of the field “Location” above. |
| Local Spec. 1 – 10 | The functionality of these fields is similar to that of the field “Location” above. |
| Tax Code | If you create a new entry, you can enter a tax code in this field. Maconomy will automatically suggest that the tax code be assigned to the offset account information card. This can be changed when the line has been created.
You can add up to three different tax codes if necessary. To enable multiple tax codes, the system parameters “Show Three Tax Levels” and/or “Show Two Tax Levels” must be marked in the System Parameters window. When multiple tax codes are enabled, the “Tax Code” field will be replaced by the following fields: “Tax Code 1,” “Tax Code 2” and, if enabled, “Tax Code 3.” For further information on multiple tax codes, please see the description in “Tax Codes.” |
| Currency Direction | If the currency of the account is different from the base currency, you must enter a currency direction in this field. The currency direction specifies which currency table is to be used for the entry. If the currency direction is sales, the currency table for sales should be used and vice versa for purchases. |
| Check No. | This field shows the check number if payment is made by check. |
| Check Book | This field shows the check book that can be assigned to a check. |
| Payment No. | This field shows the number of the payment if payment is made by check or electronically. |
| Payment Group No. | This field shows the number of the payment group if payment is made by check or electronically. |
| Payment Line No. | This field shows the number of the payment line if payment is made by check or electronically. |
| Job No. | Enter the job number that is related to the bank reconciliation line. |
| Job Name | This field shows the name of the job that is related to the bank reconciliation line. |
| Activity | Enter the activity number that is related to the bank reconciliation line. |
| Activity Name | This field shows the name of the activity that is related to the bank reconciliation line. |
| Task | Enter the task that is related to the bank reconciliation line. |
| Task Description | This field shows the description of the task that is related to the bank reconciliation line. |
| Employee No. | Enter the employee number that is related to the bank reconciliation line. |
| Employee Name | This field shows the name of the employee that is related to the bank reconciliation line. |
| Customer No. | Enter the customer number for the customer payment. |
| Customer Name | This field shows the name of the customer who is paying. |
| Reconc. Invoice No. | Enter the invoice number to be reconciled against the customer payment that you are creating. You can only enter a reconciliation invoice number if you entered a value for Customer No. |
| Vendor No. | Enter the vendor number for the vendor payment. |
| Vendor Name | This field shows the name of the vendor that you are paying. |
| Reconc. Vendor Invoice No. | Enter the vendor invoice number to be reconciled against the vendor payment that you are creating. |
| Currency | Enter the original currency for the vendor payment. |
| Currency Amount | Enter the vendor payment, in original currency. |
| Entry No. | This field shows the entry number for the bank reconciliation line. |