Tasks to be completed when documenting an operation (from creation to publication)1. Enter the Title of the operation / page2. Add the following Labels :
3. Fill in all fields as described above4. Name the title of each section using OPD methodology naming convention - Infinitive verb without the “to”, mainly action verb...something) - " I do something..."5. Once the description of the operation is completed, ensure it is approved and published by launching the SBS-Finance approval workflow |
| Domain: Country Accounting |
Responsibility area: N/A |
Table of contents
By default the table of contents displays Heading 1 & Heading 2 (other levels can be added)
Scope3. Remove the icon when not applicable ERP4. Remove the icon(s) when not applicable Frequency5. Remove the icon(s) when not applicable (to be filled!) References6. Add the link to SAP transaction(s) (when it exists) Forms7. Insert the links accordingly and change the link text with the OP nam Attachments8. Add the link to attachments or external links Previous OP << |
1. Objective and Scope
1.1. Objective of this Operation
The purpose of this document is to explain how to post the bank statements of the Netherlands companies.
1.2. Scope
This procedure applies to the following NL companies:
- 0012 - Solvay Holding Nederland BV
- 8294 -
- 5997 - Solvay Chemicals and Plastics Holding BV
- 6012 - SolVin Holding Nederland BV
- 6243 - MTP HP JV Management BV
- 6244 - MTP HP JV C.V.
2. Definitions
See Finance Glossary.
3. Tasks description
3.1. Responsibilities
Responsibility of Local Finance Department:
- Provide the counterparts of the movements;
Responsibility of SBS:
- Sending the statements to Local Finance Department;
- Posting the movements in bank statement
|
3.2. Periodicity
The periodicity depends on the general bank flows.
3.3. I perform the booking
|
Taking the example below, the balance of bank account should be equal to 0 EUR (to be confirmed before posting). The balance of the flows generated by the statement lines has to be recorded in the bank account 50602EUR30 (12.378,85 EUR).3.3.1. I check the bank account
Check the previous balance in the bank account open items (through FBL3N) and also the balance after the posting, which should have a balance of 0 EUR. In this case the movements haven't been posted yet.
3.3.2. I verify the counterparts
1) Fill 0294 BNP Posting File with the bank description;
2) Contact the Local Accountant in order to get instructions on how to post it;
3) Proceed accordingly with procedure
3.3.3. I post the document in FB01
Handling the "Document Header" Data
| Document Date | DD.MM.YYYY (the Statement Date) |
| Posting Date | DD.MM.YYYY (Date of the Posting) |
| Company Code | XXXX |
| Doc Hdr text | NL BNP Statement Number |
| Reference | Ticket Number (if necessary) |
| Period | MM (the Month of the Bank Statement) |
| Currency | EUR |
|
In the example shown above, the counterpart posting lines are non-bank accounts that have the amounts in bank statement:
- 5910000294 (SOLVAY CHEMIE)
- 5910005997 (SOLVAY CHEM PLAST HOLD)
These accounts are the counterpart of bank accounts:
- 50601EUR30 or 50602THB30 for Bank ABN-AMRO
- 50512EUR30 for BNP-PARIBAS
Each line of the statement has to be posted, with special attention to the assignment, text and value date "Rentedatum" that can be different line by line.
- "Debit" amount in the statement = Posting key 40 for counterpart and 50 for bank account.
- "Credit" amount in the statement = Posting key 50 for counterpart and 40 for bank account.
For instance, in the example above, despite the two lines have the same counterpart account name and sign, we should post one movement by line with specific amount of each one (4.200,53€ and 175,81€) and not the total amount (4.376,34€).
Value date (or Rentedatum in Dutch) appears in parenthesis "(31-03)" (left side of ABN bank statement, and in the middle for BNP) can be different from bank statement date (Bookdate or Boekdatum). In the above example, the Bookdate is 26-04-2012 and value date is 31-03-2012.
Value date for bank accounts is a required field. Some counterpart accounts have the field others don't.
For the BNP PARIBAS example given in page 5, the statement date is 17-04-2012, but Value date is 19.03.2012:
3.3.4. I fill in the assignment and text (please confirm the title)
| Assignment | XXX NN DDMMYYYY Where:
|
| Text | XXX NN DDMMYYYY Where:
|
However pay attention in the ticket sent because the text can change, as often requested by the costumer, in counterpart posting account lines.
Instead of text "ABN 10 15022012", in counterpart credit account line, in this ticket the customer request the text "RBT Athlon car Lease".
*In the excel file are reported some of these exceptional text different cases.
3.3.5. Example of bank statement posting
Confirm balance of bank account, in this case 50602THB30 (FBL3N):
In the bank statement, the previous balance (Vorig saldo) is 641,64THB that is the same shown in the bank account balance. If it's not the same balance we should contact the customer, because probably is missing a previous bank posting.
b) Proceed with the bank posting (paid attention to the currency of bank account, in this case the bank statement is in THB):
| Document Date and Posting Date | 08.05.2012 |
| Doc. Type | SB |
| Company Code | 6244 |
| Currency | THB |
| Reference | Case number |
| Document Header Text | ABN-AMRO |
In this case we have:
- "Debit" amount in the statement = Posting key 40 for counterpart and 50 for bank account.
Check the description (Omschrijving) of bank statement in excel file, even if written the accounts in the PDF.
We need to confirm always the accounts, text, cost centers in excel file. If they are different from bank statement we should first ask customer the correct procedure and if it's a permanent change, we should update this procedure.
Posting date and document date is 08.05.2012, like bank statement shows, but value date is 30.04.2012.
Finally check if document and posting date, reference, accounts, value date, assignments, texts and amount are correct.
After the posting we should check the new balance of the bank account (FBL3N):
In the bank statement (p.10), the new balance (Nieuw saldo) is 673,64THB, that it's the same shown in bank account balance.
If it's not the same balance we should analyze our posting and bank account, probably was inserted a wrong amount or a new posting was made by someone. If that happen we should contact the customer and let him know that the account balance is not the same as shown in bank statement.
3.3.6. I post in EUR account for non-EUR companies
For instance, company 6244 is in THB currency - however the bank posting can be done in EUR. See bank statement as example below:
1) If a posting is done in EUR in non-EUR companies, don't forget to change the layout of bank account balance to "Amount in document currency", otherwise we only see the amount in local currency:
2) Clear exchange rate differences
Normally, the customer can request to clear any exchange rate difference in accounts. R2R-BO (change R2R-BO?) can do it even if it is a vendor account, so, there's no need to request P2P (change P2P?) to do it.
End of document.