# Charge the customer: open balance and statement

> Set up the collection portfolio of the bank, see what each customer still owes on a date. In Odoo 18, by KMEE.

Fonte: https://docs.kmee.com.br/en/odoo/18.0/funcional/financeiro/saldo-e-extrato-do-cliente/

Set up the collection portfolio of the bank, see what each customer still owes on a date, issue a statement with the due ranges or the movement of a period, and return a credit to the customer by transfer.

## Before you start

The agreement, the portfolio and the company code come from the collection contract with the bank, and the bank journal and the payment mode Cobrança Banco do Brasil are created. The user who configures has the CNAB manager and accounting access. For the return of a credit, the customer's bank account is registered in the contact. This applies in Brazil with configuration: the agreement, the portfolio and the company code of the contract with the bank, and accounts such as 5.1.1.3.07 Tarifas Bancárias, 6.1.2.1.01 Juros Ativos and 5.1.1.6.03 Descontos Concedidos.

## Step by step

### 1. Set up the collection portfolio of the bank

In Invoicing, open Configuration > CNAB Configuration and the configuration of the bank. On the Collection tab, check the Portfolio, the Modality and the Security Type. On the General tab, in Collection instructions, enter the text printed on the bank slip, and click Save. On the Accounting tab, check the accounts of fee, interest and discount. Open Configuration > Payment Modes and the mode Cobrança Banco do Brasil: it points to the configuration and to the journal. Example: Guatambu Móveis collects through Banco do Brasil, CNAB 400, portfolio 18, modality DM, Duplicata Mercantil. The next invoices with this mode generate the bank slip and the collection order with these parameters.

### 2. See what each customer still owes on a date

Open the Reports menu and choose Open Items. In Until, enter the date and tick Receivable Accounts Only. Click Preview and check the open invoices with the due date and the balance of each one, and the total. Example on 03/31/2026: invoice FAT/2026/00006 of Lince Azul, 20,000.00, due 04/17/2026, and FAT/2026/00005 of Escola Corruíra, 30,000.00, due 04/15/2026, a total of 50,000.00 to receive.

### 3. Issue the customer statement of what is owed

In Customers, in list view, tick the customer and, in Actions, choose Partner Outstanding Statement. Enter the Final Date and tick Show aging buckets. Click View. Check the open invoice and the due ranges, counted up to the final date. Example: statement of Escola Corruíra up to 04/30/2026, with invoice FAT/2026/00005, 30,000.00, due 04/15/2026: overdue by 15 days, the whole value is in the 1 - 30 Days range, and the final balance is 30,000.00.

### 4. Issue the statement of purchases and payments of the quarter

In Customers, tick the customer and, in Actions, choose Partner Activity Statement. Enter the Initial Date and the Final Date and click View. The statement lists, in date order, the previous balance, the invoices, the receipts and the final balance. Example: Clínica Tamboril from 01/01/2026 to 03/31/2026: previous balance zero, invoices of 30,000.00 and 25,000.00 (55,000.00), receipts in Itaú of 30,000.00 on 02/14/2026 and 25,000.00 on 03/18/2026 (55,000.00), final balance 0.00 + 55,000.00 - 55,000.00 = zero.

### 5. Return the customer's credit by transfer

Open Customers > Credit Notes and the credit note of the customer. Click Pay, choose the Itaú journal and the customer's bank account that receives the transfer. Click Create payment: the credit note is In Payment until the statement confirms the outflow. On the Payments tab, check the outgoing transfer. Example: Clínica Tamboril has no open invoice and prefers to receive by transfer the 300.00 of an agreed rebate, to the Itaú account, branch 0731, account 27459-1: the outgoing transfer of 300.00 settles the credit note.

## Expected result

The collection portfolio is set up for the next bank slips, the open balance of each customer is known on any date, the statement with the due ranges or the movement of the period is ready to send to the customer, and the credit of a customer is returned by transfer.

## If something goes wrong

If the CNAB Configuration menu does not appear, ask the administrator to give the user the CNAB collection manager and accounting access. If a paid invoice stays in the open items, check the date of the receipt: it was posted after the chosen date. If the statement comes out empty, the customer has no open item up to the final date: check the date and the customer. If an invoice appears in an unexpected range, the Final Date was left with today's date: enter the day on which you want to measure the delay. If the ranges do not appear, tick Show aging buckets and click View again. If the statement shows another period, enter the Initial Date and the Final Date before View. If Actions does not appear in Customers, switch to list view and tick the customer. If the payment comes out as a receipt, register it with the Pay button of the credit note itself. If the destination bank account is empty, register the customer's bank account in the contact and open the Pay window again.

## Continue the process

- [Follow the accounts payable and receivable](https://docs.kmee.com.br/en/odoo/18.0/funcional/financeiro/contas-a-pagar-e-a-receber/)
- [Import the bank statement and reconcile](https://docs.kmee.com.br/en/odoo/18.0/funcional/financeiro/importar-extrato-e-conciliar/)