(please write this in the right section)(error)

Reference Documents

  • Document Number: 4300001393
  • Company Code: 0012
  • Year: 2010


(please confirm the section numbering)(error)

Tasks to be completed when documenting an operation (from creation to publication)

 1. Enter the Title of the operation / page

2. Add the following Labels : 

    • Scope of applicability: ww, country_accounting 

    • Country or group of countries (if applicable): belux, china, france, italy, lam, nam, uk_ie, bulgaria, dach, netherlands, iberia, poland, latvia, australia, india, japan, south_korea, thailand, singapore, new_zealand, emea_transversal, apac_transversal

    • Unit and Domain according to the List of labels to be used in the Finance Service Line space

      • E.g. 1: WW Operation in Financial Accounting under domain "Central Finance Processes & Compliance":
        • Labels to be used: ww, financial_accounting, central_fin_proc_compliance

      • E.g. 2: France Operation in Financial Accounting:
        • Labels to be used: country_accounting, france, financial_accounting
          (for country operations, the Domain is always country_accounting)


3. Fill in all fields as described above

4. 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)



Scope

3. Remove the icon when not applicable


ERP

4. Remove the icon(s) when not applicable


Frequency

5. Remove the icon(s) when not applicable

 

 

 (to be filled!)(error)

References

6. Add the link to SAP transaction(s) (when it exists)

FBL3N


Forms

7. Insert the links accordingly and change the link text with the OP nam

NL - Bank Statement Postings


Attachments

8. Add the link to attachments or external links



Previous OP << >> Next 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
  • 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: (please replace local, as it is not used anymore. Who do you mean? controller? cam?)(error)

  • Scanning and sending the statements to SBS (through Freshdesk);
  • Coding the non-standard postings and updating the OP (OP = procedure?)(error).


Responsibility of SBS:

  • Booking the bank statement;
  • Providing a monthly posting number list giving each posting number related to each statement number.


  • Gaspar Olivier for 0012 and 5997
  • Klaus Henke for 6012
  • Ruud Schlicher for companies 6243 and 6244

3.2. Periodicity

The periodicity depends on the general bank flows.

3.3. I perform the booking


  • Files received from Local Finance might contain several pages related to various bank statements and therefore, more than one posting is required depending on the case (start posting orderly starting with the bank statement with the lowest number);
  • ABN-AMRO bank statements could be found written in English or Dutch (both layouts are given);
  • Check the previous balance in the bank account open items (through FBL3N), check also the balance after the posting;
  • Generally, ABN-AMRO bank accounts are "50601EUR30" and "50602THB30", and account "50512EUR30" is associated to BNP-PARIBAS;
  • Both posting and document dates are equal, but the value date could be different.


(the information box below was a section, I have written it here. please confirm)(error) 

In the case we have to make one posting which is not detailed in the excel file that can be found attached to this procedure (change to forms?)(error), we should proceed in the following way: 

1) Contact the Local Accountant in order to get instructions on how to post it;

2) In case an answer is not received by the local accountant in useful time, and if the amount is lower than 10 k€, we can post the statement against account 5080000000 and inform the customer afterwards, so that he can advise us on the corrections to be made. If the amount is bigger than 10 k€, we need to wait for the customer feedback in order to allocate it correctly.

3.3.1. I post the document in FB01



Handling the "Document Header" Data

Document DateDD.MM.YYYY (the Statement Date)
Posting DateDD.MM.YYYY (Date of the Statement Receipt)
Company CodeXXXX
Doc Hdr textBO-XXXXXXXX (Salesforce Case Number)
ReferenceABN-AMRO or BNP-PARIBAS
PeriodMM (the Month of the Bank Statement)
CurrencyEUR/THB (Depending on the Statement's Currency)

3.3.1.1. I post a BNP PARIBAS bank statement

The statement number


"Value date" is to be included in the posting's line items to be posted The bank account balance before the postingThe bank account balance after the posting  (is this phrase correct?)(error)



3.3.1.2. I post an ABN-AMRO bank statement



The bank account balance before and after the posting 

Following the example shown above, it means that the balance of the bank account should equal to "0" EUR prior to the posting (to be confirmed before posting).
After posting, again the balance is to be equal to "0" EUR.

3.3.2. I check the bank account (please confirm the title)(error)

The balance of the flows generated by the statement lines has to be recorded in the bank account 50601EUR30 or 50602THB30 for Bank ABN-AMRO, and account 50512EUR30 for BNP-PARIBAS. 



Taking the example above, this means that the balance of bank account should be equal to 0 EUR (to be confirmed before posting) 
After the bank statement posting we should have a balance also of 0 EUR.
The balance of the flows generated by the statement lines has to be recorded in the bank account. To check if the posting is correct, the amount that has to balance the posting has to be equal of the difference between the new balance ("nieuw saldo") and the previous balance ("vorig saldo") of the Bank Account.

3.3.3. I verify counterpart posting lines (please confirm the title)(error)

In our example below (referred in the "Description" or "Omschrijving"):

  • First statement line (MAANDBIJDRAGE ABNAMRO):

Negative balance = posting keys are "50" in the bank account and "40" in counterpart account.

  • Second statement line (ZERO BALANCING): 

Positive balance = posting keys are "40" in the bank account and "50" in counterpart account.


  • Sometimes Local Finance might write the counterpart account number on the bank statement
  • Other posting keys might be required (e.g. 25)



  • In the excel file (attached in the end of the procedure) (please link to the file)(error) we can see which accounts we should use to perform the posting.


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)(error)

Assignment

XXX NN DDMMYYYY

Where:

  • XXX = ABN/BNP (the Bank Name)
  • NN = the Bank Statement Number (located on the right side of the bank statement ("Stamt no" or "Volgnr" in ABN-AMRO postings, in BNP is "nr.");
  • DDMMYYYY = the Date of the Bank Statement.
Text

XXX NN DDMMYYYY

Where:

  • XXX = ABN/BNP (the Bank Name)
  • NN = the Bank Statement Number
  • DDMMYYYY = the Date of the Bank Statement


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 Date08.05.2012
Doc. TypeSB
Company Code6244
CurrencyTHB
Reference Case number
Document Header TextABN-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?)(error) can do it even if it is a vendor account, so, there's no need to request P2P (change P2P?)(error) to do it.

End of document.