Bank Statement Reconciliation
Prerequisite
Refer to documentation Implementation
Screen management
Parameter entry
When you access this function, you need to enter to following to continue the process:
- Bank account
- Date of the last statement
- Date of the last accounting entry to be considered
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.
Bank (field BAN) |
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. |
Bank account (field BANACC) |
This field displays the general ledger account associated with the bank account. |
Bank BP (field BANBPR) |
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. |
Bank statement (field BSISTM) |
Last statement date (field DATRBK) |
This field displays the last bank statement date by default. Only the entries for bank statements before this date are reconciled. |
Last entry date (field DATACE) |
This field displays the last bank statement date by default. Only the entries for bank statements before this date are reconciled. |
Entry screen
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.
Selection
Bank (field BAN) |
This code identifies a bank account. You can enter the code directly or select from the bank account table. |
Account (field BANACC) |
This field displays the general ledger account associated with the bank account. |
Bank BP (field BANBPR) |
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 (field FCY) |
Site associated with the bank. |
Balances
Sign (field SNSBLC2) |
Account balance (field BLC) |
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 (field CUR) |
Currency in which the bank account is kept. |
Sign (field SNSBLB2) |
Bank balance (field BLB) |
Reconciliation balance (field CHKBLC) |
Grid Details
Select (field CHX) |
Check no./Reference (field REFC) |
Date (field ACCDAT) |
This date represents the accounting date of the original transaction. |
Value (field VALDAT) |
Value date. |
Bank date (field BANDAT) |
This field is specific to the Italian law and used to specify the posting date of the operation. |
Interbank code (field BANCIB) |
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. |
Description (field DES) |
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. The connection language must be defined as a default language for thefolder. |
Sign (field SNS2) |
Bank currency amount (field AMTBNQ) |
Currency amt. (field AMTCUR) |
Amount expressed in the selected transaction currency. |
Curr. (field BANCUR) |
Specifies the operation-keeping currency. |
Mark (field CHK) |
This field is used to perform the reconciliation of the banking operations that are actually listed on the hardcopy bank statement. |
Bank reference/Journal type (field REFB) |
Slip no. (field FRMNUM) |
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. |
Ledger amount (field AMTLED) |
Amount expressed in ledger currency. |
Com. (field INDCOM) |
Rejection (field RENREJ) |
Selection |
To select a line to be reconciled, click the Actions icon located at the beginning of each line and click Selection. |
Document |
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. |
Process bank transactions |
Reports
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.
Options available from the Printer icon
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.
Specific Buttons
Reconciliation |
Use this button to assign the same reconciliation code to all the selected lines. |
Sort |
Use this button to sort the table according to the Amount, BTC or Datecriteria, in ascending or descending order. |
Menu Bar
Use this button to search an entry according to:
|
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
Full grid
This message appears upon loading of the posting lines when the maximum size of the table has been reached.
Empty grid
This message appears upon loading the table. No recording corresponds to the criteria entered in the first screen.
You do not have access to the bank xxxxx
This message opens when the user profile code does not authorize access to the "BANK RECONCILIATION" function for the selected bank.
Journal number xxxxxxxx : record locked
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.
Account in the process of being reconciled
This message appears if the bank account is being reconciled or if the reconciliation of said bank account is being reversed by the processings:
- SUBCHK "RECONCILIATION",
- RECONCILIATION REVERSAL "RECONCILIATION REVERSAL,
- RECONCILIATION WITHOUT OFFSET "UTICHK",
- BANK STATEMENT CANCELLATION "ANURBK",
- ENTRY OF STATEMENT " SUBRLK "
These processings cannot be carried out together on the same bank.
Sort order incorrect
A figure cannot give the same sort order to two different criteria.
A search criterion has already been entered
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.
Reconciliation incorrect/Selection total for the statement=/Selection total for the postings=
The balance between the statement lines and the entries is not complied with. The selection needs to be reviewed.
Number between between 0 and 8
The reference field of the entry only contains 8 characters. A number between 0 and 8 must be entered.
Some open items or entries are being viewed and could not be loaded
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.