Refer to documentation Implementation
Presentation
When you access this function, you need to enter to following to continue the process:
In the Last statement date field, click the Selection icon to select the last statement date from the list of the last 10 statement imports.
Close
Fields
The following fields are present on this tab :
| This field displays the bank for the reconcilation between bank statement postings and the journal entries. Only the entries with the same currency as the bank account are kept. |
| This field displays the general ledger account associated with the bank account. |
| This field displays the BP Code, which is mandatory when one of the journals is associated with a collective account. The BP code must be a miscellaneous BP and is considered as a subdivision of the bank account. For example, this setup makes it possible to follow the entries and avoid duplicating bank accounts in Financials. |
|   |
| This field displays the last bank statement date by default. Only the entries for bank statements before this date are reconciled. |
| This field displays the last bank statement date by default. Only the entries for bank statements before this date are reconciled. |
Close
Presentation
This screen displays the table of accounting entry lines and statements. You can reconcile movements manually or automatically.
To reconcile automatically, click Proposal.
Before reconciling the proposed matches to accounting entries and statements, you can modify the accounting entries and statement lines for balanced amounts. The balance of reconciled entries is displayed in the header window and it must equal zero.
The reconcile with or without making modifications, click Save.
See the section on Proposal for more information.
Close
Fields
The following fields are present on this tab :
Selection
| This code identifies a bank account. You can enter the code directly or select from the bank account table. |
| This field displays the general ledger account associated with the bank account. |
| This field displays the BP Code, which is mandatory when one of the journals is associated with a collective account. The BP code must be a miscellaneous BP and is considered as a subdivision of the bank account. For example, this setup makes it possible to follow the entries and avoid duplicating bank accounts in Financials. |
| Site associated with the bank. |
Balances
|
| Displays the amount calculated by the system, which is the sum of the transactions on, or before the statement date. The amount represents the current book balance as of the statement date. |
| Currency in which the bank account is kept. |
|
|
|
Grid Details
|
|
| This date represents the accounting date of the original transaction. |
| Value date. |
| This field is specific to the Italian law and used to specify the posting date of the operation. |
| The Inter-banking code is used by all the banks to specify the bank operation type on the lines of the bank statements that are sent to their customers. It is used to facilitate (sort, selection) and control the bank reconciliation between the postings in a bank account with the lines in the bank statements. This field is initialized in the journals generated for the entered payment lines with an appropriate payment attribute. |
| This field is used to link a description to its record. This description can be printed on the records, displayed when the record code is entered in a screen, or used on selection. By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.
|
|
|
| Amount expressed in the selected transaction currency. |
| Specifies the operation-keeping currency. |
| This field is used to perform the reconciliation of the banking operations that are actually listed on the hardcopy bank statement. |
|
| This field is the unique identifier for the deposit slip. When you create a new deposit slip, the number is assigned according to a sequence number counter that can be set up. By default, this sequence number counter is PY5. |
| Amount expressed in ledger currency. |
|
|
Close
Action icon
To select a line to be reconciled, click the Actions icon located at the beginning of each line and click Selection.
To view the accounting entry from which the bank line was created, click the Action icon at the beginning of each line and click Entry.
Close
By default, the following reports are associated with this function :
RAPPRO : Banking reconciliation report
RAPPROCHK : Bank reconciliation
RAPPRODBL : List of duplicates
This can be changed using a different setup.
Print-outs
Click Print to print the list of manually or automatically reconciled entries. The EDITRBK initialization processing updates the EDITRBK table. This function is only available if elements are reconciled.
List
Click List to print the list of duplicates (non-reconciled entries, with the same type, the same amount and the same sign). The EDITDBL initialization processing updates the EDITRBK table.
Use this button to assign the same reconciliation code to all the selected lines. |
Use this button to sort the table according to the Amount, BTC or Datecriteria, in ascending or descending order. |
Use this button to search an entry according to:
In addition to the generic error messages, the following messages can appear during the entry :
This message appears upon loading of the posting lines when the maximum size of the table has been reached.
This message appears upon loading the table. No recording corresponds to the criteria entered in the first screen.
This message opens when the user profile code does not authorize access to the "BANK RECONCILIATION" function for the selected bank.
This message appears upon loading of the postings, when an item is being modified for a journal that needs to be reconciled. This journal is then not loaded into the grid.
This message appears if the bank account is being reconciled or if the reconciliation of said bank account is being reversed by the processings:
These processings cannot be carried out together on the same bank.
A figure cannot give the same sort order to two different criteria.
The search is carried out either on the basis of the amount, or on the bank transaction code, or on the reference.
These three criteria exclude each other.
The balance between the statement lines and the entries is not complied with. The selection needs to be reviewed.
The reference field of the entry only contains 8 characters. A number between 0 and 8 must be entered.
An entry generating a movement on the cash account of the bank being reconciled or reversed could not be loaded because it is already used (locked) in another product function.
If you click OK, Sage X3 will still load the data (except locked data) and reconciliation or reversal processes remain possible.
If you click Cancel, the log of entries that were not loaded is displayed.