(please write this in the right section, if necessary)(error)

Reference Documents

  • Document Number: 1300000000
  • Company Code: 6301
  • Year: 2015

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; FD03; FK03


Forms

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

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 Netherland Company for WP1.

1.2. Scope

This procedure applies to the following NL companies:

  • 6301 - Solvay Solutions Netherland


2. Definitions

See Finance Glossary:


3. Tasks description

3.1. Responsibilities

Responsibility of Local Finance Department:

  • Scanning and sending the statements to SBS through Freshdesk ticket
  • 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


Local Accountant Team:

  • Ruud Schlicher for companies 6301
  • Ans vandenbemt and Pauline Flury

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);
  • Check the previous balance in the bank account open items (through FBL3N), check also the balance after the posting;
  • Generally, BNP-PARIBAS bank account is "51000757" and Cash Pooling 50980000;
  • Posting and document dates can be equal, but the value date could be different.

3.3.1. I post document in FB01

Handling the "Document Header" Data:

Document DateDD.MM.YYYY (the Statement Date)
Posting DateDD.MM.YYYY (Date of the Statement Receipt)
Document typeSK
Company CodeXXXX
Doc Hdr textBO-XXXXXXXX (Salesforce Case Number)
ReferenceBNP-PARIBAS XX (STATEMENT NR)
PeriodMM (the Month of the Bank Statement)
CurrencyEUR (Depending on the Statement's Currency)

3.3.1.1. I post a BNP Paribas bank statement

worddav186a0480fe04416b9f4e7ed2228e0a2c.png

The bank account balance after the posting.
"Value date" is to be included in the posting's line items to be posted.

worddav93a86985c575354c3071b089c5a949cd.png


The bank account balance after the posting

The bank account balance after the posting 
The bank account balance after the postingThe bank account balance after the posting 

(are the above phrases suppose to be here?)(error)


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.


Bank Account the balance of the flows generated by the statement lines has to be recorded in the bank account bank 51000757 BNP-PARIBAS and Cash pooling 50980000.

worddavc8b7846392166ecbcafe19ddad602f21.pngworddavc05a523b62e05c868e0981ebe4055ff4.png

worddav55e6c5da6749b93b2f38d0ecd2d7671b.png


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 and the previous balance of the Bank Account. All IBA´s will impact account 50980000, directly from PI1 system. In a weekly basis we will enter in Account 50980000 and request CAM /controllers bank Statements. 

3.3.2. Assignment and Text

Assignment

XXX NN DDMMYYYY

Where:

  • XXX =BNP (the Bank Name)
  • NN = the Bank Statement Number (located on the right side of the bank statement ( in BNP is "nr."); and
  • DDMMYYYY = the Date of the Bank Statement.
Text

XXX NN DDMMYYYY

Where:

  • Same TEXT as in IBA Doc


worddav497fc907e1ce3137952b6598586ff8c6.png


However pay attention in the ticket sent because usually write the number of customer and vendor number, but we need always to confirm in FK03 or FD03 is the name and number match.

Posting date and document date can be same date, but value date is always the one that appear in the bank statement.

worddavf2058bf64b142865ec5c8684e6ce90aa.png

worddava81638ca90192653c7e3ca60b772635c.png

worddav42f0775118270ed54a743f840c0d3d6c.png


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 the new balance it's the same 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.3. I post the counterpart for bank accounts

We have recurrent situations to post the counterpart of bank account in a Vendor, Customer and G/l account. If we are not finding the counterpart in the system and if it is not recurrent, we should contact our CAM (Ruud schlicher) or Controllers in Moerdijk (Ans vandenbemt and Pauline Flury):

Recurrent Situations (detailed in the following sections):

  1. Monthly commissions
  2. Customers in bank statement
  3. Vendors in bank statement
  4. Social contribution


We need to contact the following list:

  1. Contact the Local Accountant in order to get instructions on how to post it when we have doubts;
  2. After posting in Customers we should inform OTC (change OTC)(error) to clear misdirect payments; 
  3. After posting in Vendors we should inform PTP (change PTP)(error) to match with invoice; 
  4. After posting social contribution if we have doubt we need to contact HR.


3.3.3.1. Monthly Commissions

worddav258a2c2193e4dd15e8cbc8f8b4802fba.png

worddav7396bb92ed14e57e11c61bd6da46649b.png


After we need to use the following posting SCHEME: 

  • 50 5098000 Assignment BNP XX Values date DD.MM.YYY
  • 40 51000757 Assignment BNP XXValues date DD.MM.YYY
  • 50 51000757 Assignment BNP XX Values date DD.MM.YYY
  • 40 98300702 Assignment BNP XX Values date DD.MM.YYY and cost center (cost Center 8298-2011)

worddav9595b7c42e819f47eecaa44e6df08835.png


Remove the amounts from Cash pooling Account 50980000 into BNP Paribas Account 51000757. The final Step, is transfer the amounts from BNP Paribas Accounts into P&L account 98300702 (cost Center 8298-2011). For monthly commissions use always the same posting Scheme (just pay attention to posting keys).

3.3.3.2. Customers in bank statement

worddav60c9fd3b676b5e70dd1c3384544e4310.png

worddav34de4a4163303abcfdc4dc6d43aef9a3.png


The amount we have in account 50980000 is the same as in ACC DEB-CATI CLIENT. We need to be very careful to see if the bank statement is a customer or vendor. We need to retrieve the name and check in FD03 or FK03. For company 6301 the usual customer is Wilmar.

We need to confirm in invoice if customer is assign to CICC (should have D in invoice).


worddavb9fd722a80afeca4115ee669aa3f5091.png


After we need to use the following posting SCHEME: 

  • 40 5098000 Assignment BNP XX Values date DD.MM.YYY
  • 50 51000757 Assignment BNP XXValues date DD.MM.YYY
  • 40 51000757 Assignment BNP XX Values date DD.MM.YYY
  • 50 51100860 Assignment BNP XX Values date DD.MM.YYY 

For Customers, we never transfer amounts directly to customer account. The counterpart account must always be account 51100860. After the posting is done, we need to inform OTC (change OTC)(error) in order for them to proceed with misdirect peymenth (payment?)(error) procedure. 

3.3.3.3. Vendors in bank statement

worddav6375be4ba2c761bd2e6682421c7005fd.png

worddav87fe14e8a9e801332b13d192580266c4.png


The amount we have in account 50980000 is the same as in ACC DEB-CATI CLIENT. We need to be very careful to see if the bank statement is a customer or vendor. We need to retrieve the name and check in FD03 or FK03. 

For company 6301 most comun (usual?)(error) Vendors are:

  • NV NUON SALES NEDERLAND 502562198
  • KPN MOBIEL GRONIGEN 502562199
  • KPN BACKOFFICE CONSUMENTE 502558128
  • BNP PARIBAS LEASING SOLUT 502562119


Bank statement with vendors we need to post two documents (Vendor accounts does not allow SK document type, so the second document we use SX);

worddavf2a2ce8a921da6c1c4e41e0e734c7236.png


50 5098000 Assignment BNP XX Values date DD.MM.YYY
40 51000757 Assignment BNP XXValues date DD.MM.YYY 

worddava6cf16b0e8cd0964cbbcead192325cc7.png


50 51000757 Assignment BNP XX Values date DD.MM.YYY
25 502562199 Assignment BNP XX Values date DD.MM.YYY

We use payment block B(Accounts dept block). We need always to add profit center 6301-Z0449 in order to avoid non allocated amounts in Working capital.

worddav1e685b8a02a9971b9093ae11469fa8b9.png


For vendors, we transfer amounts directly to vendor account, if we cannot find the vendor in FK03 we need to confirm with locals. 
After the posting is done, we need to inform PTP (change PTP)(error) in order for them to match bank statement with invoice. In the end of the month if the invoice is not yet posted, we need to see with PTP (change PTP)(error) if is blocked in Cockpit. All the posting done in vendors in the end of the month should be balanced with invoice/ /credit note.

3.3.3.4. Social contribution

worddavac04e060ee5fc86e5010907e729c0e7b.png


The amount we have in account 50980000 is the same as in ACC DEB/CRE-CATI CLIENT. When we have in text the In favor of X beneficiaries we should transfer this amount to 44900800 and 43900101 (it should be Controllers to provide us the correct allocation between both accounts).

worddav32158602b3424c4a6eb63d48749baaf9.png

3.3.3.5. Vat posting

worddavcbf66d668f2673c74c2a8de74466de78.png


The amount we have in account 50980000 is the same as in ACC DEB/CRE-CATI CLIENT. When we have in text the In favor of Belastingdients.
we should transfer this amount to 44700100 and 44900200 (If the amount is positive you should book on account 44700170, if negative you should centralize the amount of VAT of the month on 44900100). After we need to see if the Bank statement match with VAT quarterly posting.


End of document.