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 |
Objective and Scope
1.1. Objective of this Operation
The purpose of this document is to have a detailed procedure on how to perform the bank reconciliation and posting at the end of the month.
1.2. Scope
This procedure applies to companies 6414, 6424.
2. Definitions
See Finance Glossary.
3. Tasks description
3.1. I perform the postings
3.1.1. I perform bank postings for company 6414 and 6424
This operation can be only performed after Automatic BNP Bank upload in SAP, on daily basis.
For both companies 6414 and 6424 the bank accounts in SAP are 505DEEUR72 (for outgoing payments) and 505DEEUR76 (for incoming payments). Centralized bank account is 505DEEUR70.
To post bank postings, first execute FBL3N, open items at current date, for accounts 505DEEUR72 and 505DEEUR76. The open items have to be cleared, by posting with the same document date and posting date, in the definitive counterpart account (should be a vendor account, customer or can be recognized as a cost in the respective PL account).
For more information (complete description of bank movement), consult FEBA transaction:
Use the file SCo PT LIST OF RECURRENT POSTINGS, sheet 6414 Bank Postings or 6424 Bank Postings, depending on the company where to book the bank postings:
|
|
|---|---|
Bank guarantees | Post Recurrent "PT3SB04". |
Withholding tax payments (IRS or IRC) | Post Recurrent "PT3SB02". Check in FBL3N the open items at end of previous closing month - accounts 2452030000 / 2452093711 / 2452090000 / 2452093714. After the posting clear these accounts. |
| Tax Stamp payment ("imposto de selo") | Post Recurrent "PT3SB07". Check in FBL3N the open items at end of previous closing month - account 2450003715. After the posting clear this account. |
| Judicial discounts ("penhoras de vencimentos") | Are related to a debt of a employee to the Fiscal Authorities. Post against account 2416200000 by splitting the amount based on the details of H0 document and payroll file provided by HR. After the posting clear account 2416200000 with H0 document. |
| Social Security payment | Post Recurrent "PT3SB03". Check in FBL3N the open items at end of previous closing month - accounts 2454003712 and 2454003713. In case we have a small difference to the total amount paid of Social Security, this difference is to be consider in account 7640000000. |
FCT and FGCT payments | Post Recurrent "PT3SB05" - account 2454003714 for FCT and account 2454003715 for FGCT. For additional costs, post in account 6470000000. |
| Bank fees/charges | Post Recurrent "PT3SB06" |
| Fines, Interests related and penalties ("coimas", "juros de mora") | Post in account 6431000000. |
For other cases, consult directly SCo PT LIST OF RECURRENT POSTINGS and/or check historical data from bank accounts line items (505DEEUR72 and 505DEEUR76).
For some spot payments not covered in the template, ask CAM more details for the posting. This bank postings are to be performed, only when we receive the proof of payment to be attached to the posting. If not yet received, it remains to be posted and the open item has to be justified in the bank reconciliation (step 3.2. from the procedure).
3.2. I perform the bank reconciliation
For all companies, there is a file for each company and respective SAP bank account.
These files are available in the dedicated repository:
- Company 6414: Z:\1_SCO\6414_Solvay Biotecnologia Portugal – Unipessoal, Lda\BANCOS & CICC & BANCO DE PORTUGAL & GARANTIAS BANCÁRIAS\RECONCILIAÇÕES BANCÁRIAS and have to be created at D+1.
- Company 6424: Z:\1_SCO\6424_SLV Specialties Portugal, Unipessoal, Lda\Bancos & CICC & Banco Portugal\RECONCILAÇÕES BANCÁRIAS and have to be created at D+1.
In these folders, also archive the respective bank statement (reference period - closing month).
To fill bank reconciliation files:
6414 BNP 505DEEUR72 RECONCILIAÇAO-BO MM.YYYY
6414 BNP 505DEEUR76 RECONCILIAÇAO-BO MM.YYYY
6424 BNP 505DEEUR72 RECONCILIAÇAO-BO MM.YYYY
6424 BNP 505DEEUR76 RECONCILIAÇAO-BO MM.YYYY
- If you have any document in bank but it isn't in SAP you should include the document in "Movimentos lançados no banco e não na contabilidade";
- If you have any document in SAP but it isn't in bank you should include the document in "Movimentos lançados na contabilidade e não no banco".
Example - CCy 6414 - account BNP 505DEEUR72 RECONCILIAÇAO-BO 09.2023
Fill in the file in the pink cells the information needed. In the "Saldo na Contabilidade FS10N", go to FS10N, insert company code and retrieve the accumulated balance for the closing month.
For "Saldo no Banco S/ Extracto" insert the accumulated balance provided by the bank statement. Update the Dates.
Inform CAM that bank reconciliation is done for the closing month and files are stored in the referred folder.
End of document.