Cash Allocation Rhodia Companies Brazil

Enter on Itaú's website www.itau.com.br and fill the field "Operator code" with your personal code:

Click on your name to access the virtual keyboard

Enter your password on the virtual keyboard:

Select the desired company than click on "Contas"

Click on "Por periodo" under the "Extratos" menu to get the bank statement.

Always use the last working day.

Below is the bank statement.

Extract this information for all companies in the scope. 

2.2 Bradesco

• Rhodia Brasil [7580] Bradesco Bank Ag. 2372 C/C 555-0 (SAP 500501003) {Statements}
• Rhodia Poliamida [7523] Bradesco Bank Ag. 2372 C/C 74010-1 (SAP 500501003) {Statements}

Enter on Bradesco's website www.bradesco.com..br than click in menu "Para sua Empresa".

On next screen click "Acesso a Conta"

Follow these steps:

1. Select "Certificado Digital" under "Marque tipo de acesso" menu on the left;
2. Search your Digital certificate file (saved in your computer or personal drive) and open it;
3. After this, you should enter your password and click "Avançar" button.

On the home screen click "Saldos e Extratos"

Click on option "Extrato (Ultimos Lançamentos)"

Select the desired date. Usually will be "2 dias" option.

Extract from other companies.

2.2.1 Banco do Brasil

• Rhodia Brasil [7580] Banco do Brasil Ag. 3132-1 C/C 369-7 (SAP 50050100) {Extratos}
• Rhodia Poliamida [7523] Banco do Brasil Ag. 3132-1 C/C 23373-0 (SAP 50050100) {Extratos}

Enter on Banco do Brasil's website www.bb.com.br and click in the option"empresarial" under "Empresa" Menu.

Enter your personal operator code into "Correntista" field and click 

Enter your password and click "Entrar"

Click on "Conta Corrente" and after "Consultas"

To extract the bank statement fills the necessary fields with the bank data of each company and the desired period (last working day). 

Below is the bank statement

Extract this information for all companies in the scope.

2.2.2 Boletos account:

[The "boleto" title is a collection payable at any bank branch of the national territory, home banking, lottery shops, some supermarkets and post offices during the period of maturity.]

The Boletos are issued just for Rhodia Brasil e Rhodia Poliamida and only from Itaú bank.

• Rhodia Brasil [7580] Itaú Bank Ag. 2938 C/C 09584-7 (SAP 50310104) {Boletos}
• Rhodia Poliamida [7523] Itaú Bank Ag. 2938 C/C 09583-9 (SAP 50310104) {Boletos}

Below the steps for extracting the statements of Boletos, these kind of statement is called "francesinha":

On Itaú website, select the account (Rhodia Brasil or Rhodia Poliamida) then click in menu "Cobrança"

Under menu "Cobrança e Desconto" click on option "Detalhado – até 15 dias" 

On "Datas disponíveis para consulta" chose the last date available, usually it will the current day. On option "Tipo de Movimentação" chose "Liquidação".

The Boletos Statement will appear.

Save it with the other files.

3. Procedure

3.1 Boletos Process

The process of boletos is automatically performed by a job that runs every morning.

We should check for any errors in the process, using transaction FEBA. This is a daily check and should be the first activity of the day. The fields to be filled are:

• Company – 7580(Rhodia Brasil) or 7523(Rhodia Poliamida)
• Company Bank – ITAU1
• ID Account - ITBRL
• Nº of Statement (you get the job report) or fills the extract Date field. After fill all fields click 

In the following screen appears the statement that was imported by the system. Double clicking on the next screen you will access the details of the data imported by the system.

On the second screen if there are any line in error, it will appear an "X" (  ) next to the item. To check the reason for the error, click twice on it.

A detailed list of all documents that have been imported will appear. The document with error appears with a warning message "a lançar", double-click on it to process the correction of this document.

On the following screen will appear the details of the Boleto paid, as customer name, invoice number, title of value and interest paid information or discounts. 

1º Example

In this example the client made the underpayment, as we can see in the "Paid Discount" line. 

Click  to save and go to the F-30 clearing transaction to regularize the discount in payment clearing screen appears our difference in this case R$ 43.41.

The amount short paid must be left open as a debit on customer's account. 

Click Document> Simulate.

In the following screen the value of the difference will be highlighted in blue.

Double-clicking on this line and change the following fields: 

In the text field enter the profit center from the correspondence invoice and describe that it is a shortpayment. 

Click on  to save document. 

2º Example

The interest charged by Rhodia on Boletos when customer delay the payment is fixed at 10%. On this example is presented the customer Merbow that have an agreement with CM Team to pay 5% of interest. However the payment comes with error because the client assumes the 10% interest that comes standard on the Boleto and inserts 5% of discount.

Click on save to go to the clearing screen and correct the amount of interest for the 5% agreed and remove the discount amount.

In this case we should simulate and correct the system posting in discount and interest accounts. The launch of the value of 5% must go to interest account (98532300) and we add a profit center that should be the same of the paid invoice.

3.1.1 E-mail to Credit

After analyzing the Boletos in FEBA, we should send an email to the CM Team communicating that this process is finished and corrected.

3.1.2 Analysis of delay on Boletos

Through the "francesinha" taken directly from the bank website, we analyze which customers made a late payment and did not paid interest.

For this we compare the column "Vencimento", that is the due date, with the column "Dia/mês", that is the date of the payment. If the payment was delayed we also check the column "Valor", that is the amount of the invoice, and the column "credito/debito", that brings the paid amount. If it is an over payment, it means that the customer paid the interests.

In the case below we have 3 invoices paid after due date and without interest. 

An email should be sent to the CM Team informing the non-payment of interest and they will decide if we will charge customer this amount or not (see the example below). 

3.1.3 Differences Control Spreadsheet

In cases that the customer has paid discount without previous authorization of CM Team, or do not paid interest, we fill a spreadsheet with the inconsistency and send to the CM Team at the end of applications for analysis. 

3.1.4 Reconciliation of Account 50310104

After Boletos process, the account on account 50310104 must be compensated (this account is a transitory account (Electronic Transmission account) used to receive the Boletos with the automatic process.

To clear this account use the transaction F-03

• Account: account number;
• Compensation Date: entry of forms;
• Period corresponds to the month in question;
• Companies: Rhodia Poliamida(7523) or Rhodia Brasil(7580);
• Currency: BRL

 This reconciliation should be done for both companies.

Select all values of the day, the balance must always be zero. Confirming zero balance, click save.

3.2 Petrobras Service Invoice.

Petrobras pays their Service Invoice at Banco do Brasil, when a credit is identified in the bank statement, as in the case below, we should search the payment details in Petrobras website.

To search the Petrobras service invoices access the website: www.wfat.petrobras.com.br, with the identification code CNPJ 15.179.682/0025-96 and the password "cREDITO1" 

In the field "Periodo" insert the current date until the next 30 days.

check the invoice referring to the day of the payment (identified in the bank statement).

In this screen we can see the tax deduction of invoice and post them.

To post the taxes we use the data retrieved from Petrobras's website. 

In reference field put the number of the SAP document the original invoice

We clear this invoice using F-28 transaction, where we have the gross invoice amount and deducting any withholding taxes we have the net value, that is the amount paid.

Petrobras taxes spreadsheet

FBL5N

Search the invoices open on customer 78050 and 78051 to help to fill the Petrobras taxes spreadsheet together with the information retrieved from Petrobras website. 

There is a control spreadsheet to enter the invoice billed, tax deductions and the release of taxes.

Example: BRENNTAG 

The Treasury team forwards an e-mail with the negotiation data, including invoice numbers, payment date, interest amount and the cost center to be used.

Enter the F-30 transaction and with the following data:

• Document Date - date of receipt of the values
• Posting Date - date of receipt of the values
• Document type - DZ
• Company – 7523 or 7580
• Reference – text "RECEBIVEIS"
• Txt cab. Doc. – text "BANCO ITAU BBA"
• Select the option Transferencia c/ compensação

click in 

Insert the customer number

Select invoices according to the file received and click 

We will clear these invoices against the bank account using Posting Key 40 and account 50050104 (ITAU).

Enter the net amount and fill assignment field with calculation memory as indicated in the file. In the text field use the same text as the example, just changing the date. 

To post the interest, use PK 40 on account 98100129 and fill the Cost Center with the number sent in the email. Fill the amount of interest as indicated in the file and fill in the Assignment field with the calculation memory and field text as below (changing the date). Now click. 

Check the data as the treasury email and click  

3.3.1 Sent Receivables to Itau

This procedure is performed every time that invoices are negotiated with Itaú bank, which is the bank responsible for Boletos portfolio.

We receive from Treasury an email with the details of the negotiated invoices to confirm An email with the securities to be traded is sent with details of the invoices.

This will include e-mail: invoice number, amount, due date, Customer VAT (CNPJ). 

In SAP (FBL5N), make a filter only with the customer involved in the negotiation, in this case Akzo Nobel. Filter as following:

1. Make the search for references of NF's.
2. Check that the sum in FBL5N is the same as in the e-mail
3. Click  to enter the payment method "3" and the company bank (ITAU1).
4. In the assignment field fill with " RECEBIVEIS ".

After setting all invoices go to transaction F110:

Enter the current date and the company code that negotiated the titles, in this case 7523 (PCB0*).

The parameters can be used the same as the previous day we sent the boletos to the bank and change the customer field to set only the customers who will in the negotiation.

Run the proposal and check it to ensure that all invoices are included in the proposal and then run "payment run". 

3.4.1 Banco do Brasil Statement

For this example the amount to be considered is 146k that came with the identification "transferencia online".

3.4.2 Bradesco Statement

For this, the total amount to be considered is 31k that is the sum of four transfers.

3.4.3 Itau Statement

And the last one, we should consider the sum of credits of the day. 13.626k

3.4.4 Collections Forecast spreadsheet

After get all information from the banks website we fill the spreadshet as the example below.

We report it spread by company and detailed by bank.

We should maintain the forecast reported at 2:00 p.m. in the second report. 

Enter the F-27 transaction and complete the following data:

• Document date – date of receipt of the values
• Posting date - date of receipt of the values
• Document type – DG
• Company – 7523 or 7580
• Reference– text "DEP 001"( receipt will always be at the Banco do Brasil)

In the first post use PK 11 on the customer's account. In this case SELL SPORTS, enter the net amount indicated in the spreadsheet sent by CM Team. In the assignment field fill with the text "BNDES" and fill in the Text field with the given cost center and "BNDES".

After it, insert the other customers that could be part of the payment as in the first post.

When posting the counterpart in bank account fill the assignment with "DEP 001 - DD / MM / YY (date of deposit)" in the text field fill "DEP 001 - DD / MM / YY - DINHEIRO."

Click in simulate and  

To clear invoice uses transaction F-30, fill in the details below: 

• Document date – date of receipt of the values
• Posting Date - date of receipt of the values
• Document type – DZ
• Company – 7523 or 7580
• Select the option Transferencia c/ compensação

Click on  

Insert custumer number

Select the invoices mentioned on CM Team email and the credit created through transaction F-27 and click  

To post interest, use PK 40 and account 98100129. Pay attention to the cost center, it should be the same sent in the monthly spreadsheet BNDES. Fill the amount with the interest of operation, and complete the assignment fields with the invoice number negotiated and text field cost center and "BNDES". Then click  

Click in simulate and  

3.6.1 Selecting invoices – FBL5N

In the transaction FBL5N do the following selection:

• Customer Selection: Select two ranges -> 1 – 91000 and 2000000 – 2100000
• On Dinamic Selection, select Country: BR

Click on  to run the transaction

In the next screen select the collumns: CL (posting key), Cliente (customer), Chave ref3 (ref. key 3) e FrmPgto (payment method). And filter it by:

Posting Key → Different from 11;
Customer → Customer numbers from the spreadsheet (customers that pay via direct deposit);
Chave referencia 3 → = equal (empty)
FrmPgto → = equal (empty) 

The results should be blocked to don't go to bank. We do it by filling the payment method field with "9" (meaning that these customers pay via direct deposit). (this process could be done with the Mass Change button).

In the next step, you use the same selection, but change your filter by changing the customers that you have chosen to appear to the tab "Delete val. Individual". And add one extra filter in the Due date: select the due date on the next 16 days Eg: 01.01.2006 to 15/10/14

the last check that should be done is to check if there are any invoice already overdue or with the due date to the next day and use the payment method "9" to block them. On this way we may find all items that should be paid via Boleto. 

For all the other items fill Payment method with "3" (meaning payment through Boleto) and Company bank with ITAU1 (granting that all these items will be sent in the Itaú Bank proposal). 

Next step is to search the invoices with due date up to 30 days from today's date. You can apply the same filters as on the previous step just changing the end due date.

Set Filters by:

Posting Key → Different from 11;
Reference key 3 → = equal (empty);
Payment Method →  = "A" (meaning that the item is blocked because due date is higher than 30 days). 

We should remove the block "A" and leave the field empty. To remove the block "A" you can use the Mass change button and fill it with a blank space. 

The last step is to make a filter for all invoices with due date higher than 30 days from the current date.

Set Filters by:

Reference key 3 → = equal (empty);
Payment Method → = equal (empty);

Select all items and block with the "A" option in Payment Method.

3.6.2 Crating proposal - F110

The transaction that generates the proposal file to be sent to bank is the F110. Fill the following data:

• Run date – today's date;
• Identification – PCB01 for 7523 (Rhodia Poliamida) and RH01 for 7580 (Rhodia Brasil).

Press "enter" then go to the tab "Parâmetro".

Chose a model to you parameter by clicking on button "  ".

A small screen will pop up, fill it with the last proposal date on "Dia de Execução" field and the same identification of the company that you are running (PCB01 or RH01).

Click on the tab Status then select YES when the system ask if you want to save data.

On the next screen click on Proposal. When the small screen pop up again, Flag: Start Immediately.

Click in  to view what invoices the system will process:

We should analyze the lines marked in red. One way to check what is ok is looking at the spreadsheet that we have used to spread the customers that pay via direct deposit.After checking that everything is correct, click on save button. 

Go back and click on Payment Run Button.

On the screen that will pop up, Keep "Start Imediatlly" flaged and flag: Create payment mediun.

Press Enter until everything be processed.

Once completed we can view the items created and a job sends the processed file to the bank automatically

3.8 Accounting Tax Control Spreadsheet – Service Invoices

Once a month, about the 15^th, tax department asks AR to fill a Service Invoices (non-operational) tax spreadsheet. Usually this spreadsheet came already filled and we just need to confirm the payment date, amount paid and if we had any difference. These data are requested in order to enable the fiscal area to use of tax credits and send the correct information to tax authorities. 

Find below an example of the request email:

Tax control spreadsheet model 

Using transaction FBL5N we can filter the dates according to the request. In this example August Invoices,

We will look for all items from Jan/14 to Aug/14.

When the transaction run, filter the results by document type "DR" and currency BRL.

In the Excel file do a filter on Customer and Field "OK". The columns to be filled are:

1. Data do Recebimento (date of receipt)
2. Mês Recebimento (Month of receipt)
3. Valor Recebido (amount received)
4. If everything is correct, insert Ok in the column "OK".

3.9.2 Changing bank instruction

In Itaú website chose the menu "Cobrança" and select the option "Um Título" to search the documents. 

On the next screen fill the field "Carteira/Nosso números" with 112 ("Carteira" code) + the Ref. key 3 of the related invoice ("Nosso Número"). 

When the information appears click on "Comanta Instrução"Command button and select the instruction "0117 (Protestar automaticamente após o vencimento)" and save. In the next screen, in the field "Dias para protesto" insert "URG".

When you save the transaction will be like the image below.

3.9.3 Regularization in SAP

In SAP (FBL5N) insert on the text field the information that CM Team asked to set this invoice to protest, the date and who requested.

3.10 Dismemberment of Invoice

The dismemberment of invoices can happen in a case where the sales team issued only one invocie instead of two or more parts as agreed with customer. We just proceed with the dismemberment when the CM Team send is an email authorizing it. To regularize this invoice we select it and manualy post it again in customer account splited according the netotiation with customer.

3.11 Novation

CM Team sends a contract to formalize the request for Novation. Below are examples of contracts

CM mail model.

The posting in SAP is very similar with the dismemberment of invoices procedure clearing the open invoices and opening it again with the new due date negotiated as described in the contract.

To post the Novation invoices use transaction F-30. 

Document Date: select the date of the novation contract
Document type: DA;
Company Code: Select the company
Posting Date: Current date
Reference: Novação
Doc. Header Text: Novação de Dívida. 

Select the invoices mentioned in the file that comes with the contract. Than post the new line items to be paid. 

Pmt Method: 9 (payment via direct deposit). 

3.12 Prorrogation (instruction via SAP)

When we receive a request from Credit Managemetn Team to extend the due date of and invoice that have generated a Boleto, we should perform this change in the bank website, however if the due date is greater than 3 days from today's date, we can command this instruction through SAP modifying the invoice and so, at the end of the day it will be included again in the proposal of the end of the day to generate an updated Boleto.

Set Payment Method field to "3" and Instruction 6 for extension of notice.

To extend the due date, insert in "dias/%" and modify for the desired days.

In text insert ""prorrogado" + date" 

Viewing the customer's account, there remains only the balance of open invoices already modified.

3.13 Payment via direct deposit

3.13.1 Payment application.

All payments received via bank deposit (Electronic transfer, money or check) are considered on this session.

To apply the cash correctly we search for the customer account using the information on Bank Statement. As we will search customer by name, we should check all codes and look for the possible invoice (check amount and due date). If you find it (invoice due date equal to deposit date and same amount) you can proceed with the clearing.

To clear customer account we use transaction F-28 as following:

• Document date and posting date (bank statement date)
• Value date: bank statement date
• Document type: DZ
• Reference (Text: "DEP 341" For Itau, "DEP 237" For Bradesco and "DEP 001" for Banco do Brasil)
• Currency – BRL
• Company Code: (7523 – Rhodia Poliamida; 7580 – Rhodia Brasil; 6864 – Energy; 6375 – Cogeração);
• Account (bank account): (50050104 – Itaú; 50050103 – Bradesco; 50050100 – Banco do Brail);
• Amount: same as in the statement
• Value date: bank statement date
• Account (customer account): fill with the customer code.

Select the invoice which payment belongs to.

Click in simulate. On this step we should wdit banck line item (line 01 on this example) and fill reference and Assignment as below:

• Reference: DEP + 341 (bank number);
• Assigment: "DEP + 341 + TED Dinheiro".

If we have the customer code, but we're not sure the correct itmes to apply this, we just credit the customer account and ask Credit Management tem how to proceed.

If we can not identify the correct customer code to post the payment, we should sen and email in the end of the day with all cases to Credit Management Team, stating that we have these unallocated cases and we was not able to identify the correct customer. 

3.13.2 Advanced Payments

If we have the customer code and we already have the information that it is an advanced payment, we must create the credit in customer account. For ti we use transaction F-27 as following. 

• Document type: DG;
• Reference: (Text: "DEP 341" For Itau, "DEP 237" For Bradesco and "DEP 001" for Banco do Brasil);
• Posting Key: 19 with Special G/L A;
• Account: custumer number

• Amount: Same as in the bank statement
• Pmt Method 9
• Assignment "Dep 341 DD/MM/YYY" ( Payment method + bank number + date);
• Text: "(profit center of the last invoice) + Dep 341 _ TED Dinheiro".

• Posting Key: 40;
• Account: bank of deposit
• Value date: bank statement date
• Assignment: "Dep 341 DD/MM/YYYY"
• Text: "(profit center of the last invoice) – Dep 341 – TED Dinheiro".

P.S. In order to get the profit center of the last invoice cleared we should go inside the document of this invoice and enter in the line of the sales (account 98100101) to get the profit center. 

3.14 Clearing request

The clearing requests usualy came from CM Team. This procedure could be applied for almost all clearings done after cash application process be finished. It could be also to clear the invoices with a credit note. 

To clear invoices with credit note (canceled invoice), use transaction F-32

To clear invoices with payments that are already in the customer account, use the F-30 transaction. 

• Document date: due date of invoice;
• Special G/L Ind put "A"
• If there is any difference and it is authorized by the CM Team, We should use the tab residual items and use code Z02 (receipts tolerance). This code will pos the difference to account 98532300 (Customers Interests); or to account 98534300 (Custoemr Discount). On this posting, put the Profit Center in the text field.

When is necessary to leave the difference posted on customer account:

• Posting Key: 14 (Credit) ou 04 (Debit);
• Assignment: "Saldo" ou "Pagamento Menor";
• Text: "(Profit Center)";
• Pmt Method: "9";
• Reference "Dep 237".

3.15 Update of Boletos in Itau bank website

3.15.1 Example of E-mail to customer

For several request of boletos.

Site: www.itau.com.br/servicos/boletos chose the option "2º via de boleto".

Insert the bank number of boleto.

3.16 Refund

The refund couldf happen when customer ask us to refund them or with Credit Management team instructions (eg. when we have a credit balance on customer account and it is identified that this customer will not buy from Rhodia in the nearly future).

Usualy customer send to CM Team the bank data where the refund should be done. Our role in this process is to grant that the correct bank data is inserted on customer Masterdata and ask AP team to make the payment.

"H" - Accounting regularization when the customer's account is Itaú (type "saída de pagamento" in Itau Sispag)
"M" – To refund by TED, mark with "M" in the field Pmt Method.

PtP department will process the request.

The value is ready to process by PtP

3.16.1 Registry bank data in customer account

Insert the customer account on FBL5N and go to Master data.

Click on 

Click in Payment tab

Fill the fields:

• Country (BR)
• Bank key: with 8 digits (bank number, and bank agency number).
• Bank Account (without digit)
• Control Key (if the bank account wasn't digit put "0(zero)" caso no put the corresponding digit
• Bk. typ (BRL1)
• Reference details (Bank reference number) Itau (01) and other banks (03)
• Bank name

3.17 CRB

Are financial credit notes without tax that are requested by commercial area and processed by AR.

3.17.1 Processamento de uma CRB

Sales team creates the CRB and sends an email to approvers as indicated in "Matriz de Aprovação" spreadsheet (example below), copying the Credit Management team and Accounts Receivable team.

After the request, the approver will send his/her "OK" and the CRB will be updated by Sales team in order to be processed

For this process we use tramsaction VF01

Insert the CRB number (click  )

Click on 

P.S.: If the billing date is from the previous month, we must change it for today date (to grant that nothing will be posted in a closed period).

In the tab [txtsCab] – Verify the history of CRB. The email from the requester and the approval of the approver should be there.

Everything ok, saves the CRB  and replay to the requester's email granting that CM Team is in copy of it.

3.17.2 Reversal CRB

If necessary to reverse a CRB, it should be done within the same month of entry.

Use transaction VF11.

Enter the document number generated on previous transaction and click 

Check the data and save 

3.18 G/L Accounts Reconciliation

Monthly, after the closing activities we send to Accounting department a report with the position of G/L accounts that are related to customer accounts. The balance on G/L Account should be the same of this account.

Firstly we go to transaction FBL5N and with variant "Previsão-RSA" created by "stavare1"

We should run this transaction with the date of the last day of previous month.

To include in your layout G/L Account column.

Filter it by account and include the balance in the report. 

(The sum of Internal Market and External Market should be the same as the balance on transaction FS10N)

We print the first and the last page of the report. LIST -> PRINT -> Only 1 page than repeat the process and print the last page (the report generates about 58 lines per page, so we should calc what page will be the last one).

We should inform the balance of Internal Market accounts, not necessary to detail it by customer.

For Account 50310104 we should do the template to adapt the Boletos balance on bank account on D1.

Using transaction FBL3N – Variant "BCO Itaú – RSA" created by "isabelcompar"

Change date to consult the last day of the past month.

To inform in the file the document number of the correction of D1.

We should fill the template to adjust the amount on bank account on D1 because the negotiation with the bank is that the money regarding the payments of Boletos, will be deposited on the next working day (eg. The payment occurred on November 30^th however the amount will figure in our bank account only on December 1^st. However the payment on SAP will be on November 30^th) and because of that this adjustment is needed).

On the template we will credit G/L account 50050104 and debit the transitory account 50310104 with the date of the last day of previous month. After that a mirror document, with inversed postings should be sent in the first day of current month in order to balance it.

These template should be sent to RtR in order to be posted.

3.19 Audit Request

When we receive an email requesting to answer an audit request from our customers or just to confirm the balance of their account on a determinate period for a simple check we should use transaction S_ALR_87012173

Fill the customer code and company code (could be more than one).

Fill the desired date.

The result will be similar to this (we should use layout "/SERGIO").

3.20.2 "Mapa Resumo"

This report shows the summary of G/L Accounts. It is used to KPIs purpose.

We use transaction S_ALR_87012172

Chose variant "MAPA RESUMO MI" (will show results from Internal Market) created by "isabelcompar"

We will change only the period.

In the botton of the report we will have the previous balance (Transp.saldo inicial); Sales balance (Saldo dev.per.relat.); Clearings (Credit entries of the period) and present balance (Saldo acum).

Update the account balances using transaction: FS10N

Enter the account code, company code and the year.

It will bring updated balances until current date. (the total amount of all accounts should be the same as the amount presented in the "Mapa Resumo". 

3.20.3 Aging List

This report shows a list of open amounts on customer accounts by period. This reprot is extracted once a month always after closing activities.

It could be a guide for audits and doubtful conciliation.

We use transaction: S_ALR_87012178

Variant "AGING LST MI" (for Internal Market) created by "Isabelcompar".

We should jsut change the date of opent items, It will be the last day of previous month.

Run this transaction  for all companies, one company each time.

Save it as na excel file named "Aging list Clientes Rhpa (Rhodia Poliamida) Agosto 2014 (Month and year) MI (definition for Internal Market).xls"

PS. If the customer name appears as "******" it means that this customer is seted to be deleted.

On this cases we should fill with customer name.

Este arquivo deve ser salvo na pasta compartilhada 

3.20.4 Non Operational Doubtful analysis

Each quarter we extract this report and sent it to accounting in order to have the doubtful balances adjusted.

Documents RV (Operational Sales) and UR (charge documents from other systems). Document DR (Non Operational sales).

We use the aging list as basist for this report. On it we include extra columns representing the three oldest columns plus one for the result of nom operational amount "NR" to calc the doubtful (50% from 91 to 180 days; 75% from 181 to 360 days and 100% from 361 days on).

3.20.5 Indicators ("Medições")

This reprot is to measure the volume of payments received and help us to check how many payments were received with delay. 

Transaction FBL5N: Variant "Medição-RHPA" created by "imeneses":

Select cleared items from previous month.

Layout: /COBRANÇA

Send it to Excel to work on it.

Tabs: 1 - Planilha base - Nome: "RHPA REC Ago"

2 - "Análise" (dopia a base para ca)
3 - "excluidos" (copia somente o cabeçalho para ca)
4 - "Resumo" (em branco)

Tab 2

• To eliminate all credits (Posting Key 11 and 12) that are reversals.

Sort it (a-z) by clearing document.

Exclude the amounts that balance reach 0 (zero) (send them to tab 3) these are the invoices cancelations (PK 12 and 1) if there are differences we should adjust it in the tab 2 manually.

We exclude all Comercial Credits (document RV)

When finish this analysis, we create a formula on the last column = clearing date – net due date.

Create a pivot table to get the results by day.

Tab 4

Fill with the summary of the report.

To get the payments made by Boleto, we should go to Transaction FBL3N and extract the report from G/L Account. 

Select the period of clearted items on the previous month.

Extract to an Excel

Organize with a pivot table.

We will put all results togeter.

Past all days and quantities in a new spreadsheet.

On the first table we have the total number of payments received and on the second table we have the payments received via Boleto. To get the number of payments received via direct deposit we should set a formula to deduct the quantity of boletos from total of payments.

This report should be done for all campanyes separated. And a summary should be created with all results.

3.21 Returned Check

We serach weeklly on bank accounts if some check was returned. To do it we use transaction FBL5N with variant "BANCOS CONCIL" creted by "imeneses". We select the current month.

Filter text field by DEV .

If any check is founded a letter should be created in order to ask someone to get this check in the bank (proceduto processed only at Front Office).