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

 

References

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

FS10N


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 aim of this document is to verify and ensure the consistency between the movements in bank and SAP, and keep the locals informed.

1.2. Scope

This operating procedure applies to all UK companies.


2. Definitions

See Finance Glossary.


3. Tasks description

3.1. Periodicity

SBS Accounting Platform will perform this task on a monthly basis according to the procedure.

3.2. I ensure consistency between the movements in bank and SAP

Every month several movements are booked in SAP bank statements. One of the purposes of posting the correct bank movement is to have the correct amounts for the interests' calculation. For this, the value dates are indeed very important, as they are used to calculate the monthly interests of the pooled companies.


3.2.1. I export the bank statement

Access bank website: https://connexis.bnpparibas.com/private_portal/homePage.jsp  (update the link and give a name)(error)
To login you need a personal 'Authentication ID', a Personal 'PIN' and a BNP Paribas gadget.

worddav878a55faeebb666343cf60aa5135c805.pngworddavaea1a87609a77bfb85e8986c4662dd21.pngworddav0012cc1f1e9084e1fe29321dd2f25f41.png


Take a look to each company 'Available balance' and write them down (usually it's zero).
Then double click to choose the company:

worddavc15ef6ec566697866c83f13f91aa802c.png


Choose the specific dates:

worddavab7030ec018b7a2b20b3efc0c6a7bde1.png


To export the month movements to an excel file, download the data:

worddavab7030ec018b7a2b20b3efc0c6a7bde1.png

3.2.2. I extract the SAP statement

At transaction FS10N, select account 50604GBP30 and company code 0240 or 5658:

worddavdf3d89ebd90192228c28f8aaa0b1b0ec.png

Click on the month balance to see the movements. Download the data into an excel file to save.

3.2.3. I perform the bank reconciliation

Open the reconciliation file at M drive (there's a file for each company):

worddavcaa0a98378d2c2738beee87ad1d51e4b.png


Each file has 3 sheets:

worddave0286718a263ee087b174ad60e64689d.png


At sheet 'BNP' paste the data from BNP (3.2.1. I export the bank statement).
At sheet 'SAP' paste the data from SAP (3.2.2. I extract the SAP statement).
At sheet 'Month Year' fill in the data as following:

1) Closing balances from previous month, in SAP and BNP

2) Reconciliation month, month balance at BNP, and month movements at SAP by posting key

3) Documents missing in SAP or in BNP

4) Check if SAP balance checks and check if the reconciliation difference is zero

5) Finalize by inserting your name and date

worddav89720dbc3a4f017cd3af5844c146fffb.png


Tip: For a quick check of pending differences, see the file "UK daily bank analysis" at:

worddavfc1130449fa281818978e3c115f330e1.png


The file has two sheets, one for 0240 and other for 5658.
On the left, in black, there are the SAP postings, and on the right, in blue, the BNP movements.
The column in the center shows the differences in bright pink, these should be the documents missing in SAP or in BNP to fill in the reconciliation file. 

worddav76609baa90cd66bcba2cdad433d0b418.png

3.3. I inform locals

The reconciliation files should be sent to locals by Freshdesk ticket.
Example:

worddavb15e59416c40f9a57d7bd61ec85ebf74.png

worddave1eee49ec252d1ae6ab6342447c2e7d0.png


End of document.