View source | View content page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Show collection (0 pages)
Collections help

Search

Projects:AdvPaymentMngt/User Documentation/it

Contents

Stato Documento

DRAFT. Questo documento è un work in progress. Esso contiene prototipi che vengono sostituiti da screenshots. Descrizioni dei processi utente sono inoltre in fase di aggiornamento ed estesi.

Introduzione

Gestione Avanzata di Pagamenti e Incassi di Openbravo ERP fornisce un flusso dei pagamenti semplificato che:

Panoramica sul Workflow

Il nuovo flusso di lavoro semplificato di pagamento (sia per gli incassi che i pagamenti) può essere riassunto nel diagramma a destra.

View larger

Gli utenti sono in grado di entrare in ogni flusso di lavoro in qualsiasi momento, al fine di completare il processo. Per esempio, è possibile accedere processo Incassa Pagamento direttamente da una fattura di vendita (o ordine). Al contrario, un utente nel processo Incassa Pagamento è in grado di trovare un certo numero di fatture contro il quale il pagamento può essere abbinato.

Il concetto di oggetto di pagamento separato (attualmente supportato da Openbravo ERP) viene rimosso dai flussi di lavoro della Gestione Avanzata di Pagamenti e Incassi. Tutti i pagamenti sono gestiti direttamente a livello di fattura e l'ordine.

E' ora possibile inserire un pagamento contro un ordine. Questo è particolarmente utile per gli utenti che non desiderano estendere il credito ai clienti e che richiedono il pagamento in anticipo. Qualsiasi pagamento a fronte di un ordine è ereditato dalla fattura creata da tale ordine.

Si prega di fare riferimento alla Configurazione manuale per una guida su come configurare Openbravo per usare la Gestione Avanzata di Pagamenti e Incassi.

Terminologia

  • Financial Account: Financial Accounts are used in Openbravo to represent accounts at financial institutions such as bank accounts, credit cards, electronic payment services, as well as cash and petty cash registers.
  • Intermediate Account: An account associated with a Financial Account that holds the value of payments that have been made or received, but which are not yet reflected on the Financial Account. An intermediate account is sometimes referred to as a "cash in transit" account. Please refer to the Configuration Manual for examples of the different ways in which Openbravo can be configured to use an intermediate account.
View larger
  • Payment: A payment event. The actual event of either making or receiving a payment.
  • Payment Transaction: The accounting event driven by a payment event.
  • Payment Document: A legal document authorizing a payment transaction. For example a cheque or an electronic file containing an instruction to a bank to make a payment. The Payment Document ID is the ID of the actual document or instruction (e.g., the cheque number).
  • Payment Plan: The list of Scheduled Payments expected against a particular invoice. If an invoice has only one Due Date then there will be only one scheduled payment expected in the Payment Plan. If there are multiple due dates associated with an invoice then there will be multiple scheduled payment events in the Payment Plan associated with that invoice.
  • Scheduled Payment: An event in the Payment Plan defined by its amount and Due Date. The sum of all Scheduled Payments in the Payment Plan must add up to the gross value of the invoice.
  • Payment Proposal: A mechanism by which a user can make a payment by selecting scheduled payment events for a particular payment method by due date. The system "proposes" what should be paid based on the selection criteria provided by the user.
  • Payment Method: Payment methods represent means of payment employed by your enterprise or by a business partner, such as cash, check, money order, or credit card with order or upon invoicing.
    • May have an Automatic Payment Plugin (see below) associated with it.
    • The list of payment methods supported Bank and Cash methods "out of the box", but is extensible to support multiple payment methods such as:
      • Cash
      • Credit Card
      • PayPal
      • Cheque (Requires Cheque Register showing Cheque #, Payee, Amount, Status, etc)
      • Direct Debit
      • Standing Order
      • Bank Transfer
      • Note Payable
  • Automatic Payment Plugin: A module that contains the workflow and user actions necessary to generate a Payment Document in local format. Examples might include modules for "US Check Printing", "Finnish Domestic BACS Payment", etc.
  • Matching Algorithm: A module that contains the logic of matching items in an imported electronic bank statement to the transactions in Openbravo during the bank reconciliation workflow. For example, you may wish the system to propose a match in the reconciliation when it detects both a match between the reference field on the statement and the payment document number in Openbravo, plus a match on the amount.
  • Open Invoice: An invoice that has not received full settlement. It may have been partially paid, but remains open until payment has been received in full.
  • Closed Invoice: An invoice that has been fully settled.
  • Approval Status: Whether an invoice is approved for payment or not. Can be either "On Hold" or "Approved". This will be configurable at the Business Partner level (as a default), but will also be editable at the invoice level and at the Payment Plan line level. No payment will be included in the Payment Proposal unless it has an "Approved" status.
  • Payment Status: The payment events in the payment flow drive the payment status.

Contabilità

Please refer to the Configuration Manual for guidance on how to configure the accounting of Advanced Payables and Receivables Management in Openbravo.

In summary:

  • A Receipt or Payment Event can trigger:
    • No accounting effect. Transactions are triggered later in the process, either by the Deposit/Withdrawal event or the Reconciliation event), or
    • A posting to an Intermediate Account. The Intermediate Account is later cleared by the Reconciliation event, at which point the payment is posted to the Financial Account, or
    • A posting directly to a Financial Account (resulting in later events not triggering financial transactions; later events are then only used to track payment status).
  • A Deposit or Withdrawal Event can trigger:
    • No financial effect. You may not want to use an intermediate account, or
    • A posting to an Intermediate Account. The Intermediate Account is later cleared by the Reconciliation event, at which point the payment is posted to the Financial Account, or
    • A posting directly to a Financial Account
  • A Reconciliation Event can trigger:
    • No financial effect. In this case the posting to the Financial Account has occurred earlier in the process, either by the Receipt or Payment event or the Deposit / Withdrawal event, or
    • A posting to a Financial Account, simultaneously clearing an Intermediate Account used earlier in the process.
    • A posting directly to a Financial Account (where no Intermediate Account has been used).
  • A Bank Statement Import Event can trigger:
    • No financial effect.
    • A posting to the defined "Bank Asset Account" and "Bank Transitory Account" at the Financial Account - Accounting Configuration tab

NOTE: The accounting work flows described in this document assume that the Accounting Server Process (see General Setup || Process Scheduling || Process Request) is active, resulting in postings being created automatically.

Incassare il Pagamento

Incassare il Pagamento contro un Ordine di Vendita

Panoramica

Many businesses do not wish to extend credit to specific customers and may therefore have a payment term that requires payment against an order. In effect this is a prepayment of an invoice. The basic workflow of Receive Payment -> Deposit Payment -> Reconcile Payment is followed.

Processo

To receive payment against a sales order:

  • Navigate to Financial Management -> Receivables & Payables -> Transactions -> Payment In and click on 'Create a New Record'.
  • Enter the name of the Business Partner from which payment has been received and click on 'Add Details'.
View larger
  • In the Add Payment Window, select Orders from the Transaction Type dropdown.
View larger
  • Select the order(s) against which the payment is to be received using the checkbox on the left hand end of each line, and enter the value being received against each order.
View larger
  • Please note that, if you choose to enter a value that represents an under-payment of a particular order, the system will prompt the user to either Leave this as an underpayment or to Write off the difference.
View larger
  • Having decided what action to take the user then clicks on the Process button.
  • The user is then presented with the options to Process Received Payment(s) or to Process Received Payment(s) and deposit. This choice allows the user to choose where in the workflow they wish the payment to be reflected (Receive Payment -> Deposit Payment) and will trigger the accounting events associated with whichever point in the workflow they choose.
View larger
  • Having selected how they wish the payment to be reflected in the workflow, the user then clicks on OK in order to process the payment and complete the task.
  • Validate the payment against the order by navigating to Sales Management -> Transactions -> Sales Order
  • Select the order against which the payment was received and click on the Payment In Plan tab
View larger

Incassare il Pagamento contro una Fattura di Vendita

Panoramica

L'utente dispone di un numero di modi in cui possono incassare il pagamento a fronte di una fattura di vendita.

L'utente può

  1. Incassare il Pagamento a fronte di una Fattura di Vendita (similarmente a un Pagamento a fronte di un Ordine di Vendita).
  2. Creare una fattura di vendita da un ordine che già ha un pagamento incassato a fronte dell'ordine stesso. In questa situazione la fattura eredita automaticamente il pagamento ricevuto a fronte dell'ordine.
  3. Incassare il Pagamento direttamente a fronte di una Fattura . Questo processo è seguito, quando un unico pagamento viene incassato. Esempi di utilizzo possono comprendere
    1. una fattura di vendita being raised in a point of sale environment, where the invoice has just been entered and remains visible on the screen, or
    2. where the user has received a single payment for a particular invoice and prefers to browse for that invoice in order to allocate the payment to it.

NOTE: Va riconosciuto che la ricezione di un pagamento contro un Fattura non deve essere un passaggio manuale. Se si desidera, questo passo nel processo può essere completamente automatizzato tramite la configurazione del metodo di pagamento. Si prega di fare riferimento alla sezione del Manuale di configurazione su

Automatizzazione Workflow Pagamento .

Processo

1. Incassare un Pagamento a fronte di una Fattura di Vendita

  • Seguire lo stesso flusso di lavoro di Incassare un Pagamento a fronte di un Ordine di Vendita, con l'eccezione che nella Finestra Aggiungi Pagamento l'utente dovrebbe scegliere Fatture (o Ordini e Fatture) dall'elenco Tipo Transazione per poter selezionare le fatture. Questo processo viene eseguito, quando molte ricevute di pagamento sono stati inserite in una volta.

2. Creare una fattura da un ordine che ha già ricevuto un pagamento relativo all'ordine stesso.

Per illustrare questo processo, creeremo una fattura da un ordine che ha già ricevuto un pagamento parziale (in modo che la fattura eredita automaticamente il pagamento ricevuto per l'ordine).

  • Dobbiamo in primo luogo inserire un ordine e ricevere un pagamento parziale contro di esso, seguendo le istruzioni in Ricevere il pagamento contro Ordine di Vendita. In questo esempio, l'ordine originale ha un valore di € 116, e di un pagamento parziale di € 58 è stato ricevuto nei suoi confronti. Una volta che abbiamo creato questa voce possiamo convalidarlo visualizzando il Pagamento in Piano associato a tale ordine :
  • Navigare to Sales Management -> Transactions -> Sales Order
  • Selezionare l'ordine che ha il pagamento parziale e clicca sulla scheda Pagamento in Piano. Qui possiamo vedere che l'ordine originale ha un valore di € 116, e di un pagamento parziale di € 58 è stato ricevuto nei suoi confronti.


View larger
  • Dopo aver confermato che l'ordine è un pagamento parziale contro di esso, si può procedere ad inserire una fattura che eredita che il pagamento parziale. Per fare questo dobbiamo passare alla Gestione delle Vendite-> Transazioni->Fattura di Vendita e fare clic su 'Crea nuovo' e inserire i dati della fattura per il business partner. Facciamo quindi clic su 'Crea Righe Da '.
View larger
  • Nella schermata risultante selezioniamo l'ordine da cui vogliamo fare questa fattura (nel nostro esempio questo è l'ordine che abbiamo creato in precedenza) e cliccare su 'OK'.
View larger
  • Dobbiamo poi cliccare su 'Completa ', assicurare che l'opzione 'Completa' è selezionata nel menu a tendina, e cliccare su 'OK' per completare la fattura.
View larger
  • Una volta che la fattura è stata completata l'utente può fare clic sulla scheda 'Pianificazione Pagamenti' e visualizzare la Pianificazione dei Pagamenti. Qui si può vedere che la fattura ha automaticamente ereditato la storia pagamento della fattura originale.
View larger

3. Incassare il Pagamento direttamente nei confronti di una Fattura di Vendita.

Questo processo è seguito quando un viene incassato un unico pagamento. Esempi di utilizzo possono includere:

  • una fattura di vendita creata in un ambiente di punto vendita, se la fattura è stata appena inserita e rimane visibile sullo schermo, oppure
  • quando l'utente ha ricevuto un pagamento unico per una particolare fattura e preferisce cercare la fattura per attribuire il pagamento ad essa.

Per illustrare questo processo, proviamo direttamente su una fattura già esistente e incassiamo il pagamento direttamente contro di essa.

  • Per fare questo dobbiamo passare alla Gestione delle Vendite-> Transazioni -> Fattura di vendita e selezionare la fattura contro la quale si vuole ricevere il pagamento. Nella sezione Monitor Pagamenti della testata della fattura possiamo vedere che questa fattura era di € 116 e che un pagamento parziale di € 58 è stato ricevuto nei suoi confronti. Al fine di ricevere l'importo residuo noi quindi facciamo clic su 'Aggiungi Pagamento/Incasso'.
View larger
  • Nella schermata risultante forniamo il valore del 'Incasso effettivo' ricevuto. Si prega di notare che un mancato pagamento permette all'utente di decidere se lasciare la differenza come un mancato pagamento o di scrivere la differenza. Nel nostro esempio supponiamo che il cliente ha versato l'importo residuo in pieno. Dobbiamo poi cliccare su 'processo ' al fine di elaborare il pagamento.
View larger
  • Nella schermata risultante possiamo scegliere se vogliamo semplicemente Processare i pagamenti ricevuti oProcessare i pagamenti ricevuti e i Depositi. Questo permette all'utente di scegliere in quale parte del flusso di lavoro desiderano che il pagamento sia riflesso (Incasso del pagamento -> Deposito Pagamento) e attiverà gli eventi contabili associati con qualsiasi punto del flusso di lavoro che hanno scelto. Nel nostro esempio, si selezionerà Processa Pagamenti Ricevuti e cliccare su 'OK '.
View larger
  • Infine, possiamo vedere dalla sezione Monitor pagamento della testata fattura che la fattura ha ormai uno status di 'Pagamento Completo' come l'intero importo di 116 € è stato ricevuto.
View larger
  • Possiamo confermare cliccando sulla scheda 'Pianificazione Incassi' , dove possiamo vedere che il numero di pagamenti ricevuti è 2.
View larger
  • Dalla finestra 'Pianificazione Pagamenti' possiamo vedere sulla scheda 'Dettagli Pagamento' il dettaglio dei due pagamenti incassati.
View larger

Eseguire il Pagamento

Eseguire il Pagamento contro un Ordine di Vendita

Panoramica

Molte aziende non hanno credito concesso a loro e possono quindi essere soggette a richieste di effettuare i pagamenti a fronte di un ordine di acquisto. In effetti questo è un pagamento anticipato di una fattura di acquisto (in cui il fornitore non spedisce la merce a meno che non si riceve un pagamento anticipato). Il flusso di lavoro di base di Esecuzione Pagamento -> Prelievo di Pagamento -> Riconciliazione Pagamento è come segue .

Processo

Per eseguire il pagamento a fronte di un ordine di acquisto:

  • Navigare a Contabilità -> Partite Aperte -> Movimenti -> Esecuzione Pagamento e cliccare su 'Crea Nuovo Record'.
  • Immettere il nome del Business Partner a cui il pagamento deve essere effettuato e cliccare su 'Aggiungi Dettagli Pagamento'.
View larger
  • Nella Finestra Aggiungi Pagamento, seleziona Ordini dall'elenco dei Tipi Transazione.
View larger
  • Select the order(s) against which the payment is to be made using the checkbox on the left hand end of each line, and enter the value being paid against each order.
View larger
  • Please note that, if you choose to enter a value that represents an under-payment of a particular order, the system will prompt the user to either Leave this as an underpayment or to Write off the difference. In this example we will intentionally leave an underpayment of €1.
View larger
  • Having decided what action to take the user then clicks on the Process button.
  • The user is then presented with the options to Process Made Payment(s) or to Process Made Payment(s) and withdrawal. This choice allows the user to choose where in the workflow they wish the payment to be reflected (Receive Payment -> Withdraw Payment) and will trigger the accounting events associated with whichever point in the workflow they choose.
View larger
  • Having selected how they wish the payment to be reflected in the workflow, the user then clicks on OK in order to process the payment and complete the task.
  • Validate the payment against the order by navigating to Procurement Management -> Transactions -> Purchase Order
  • Select the order against which the payment was made and click on the Payment Plan tab
View larger

Eseguire il Pagamento contro una Fattura di Vendita

Panoramica

L'utente dispone di un numero di modi in cui possono effettuare il pagamento nei confronti di una fattura di acquisto.

L'utente può

  1. Effettuare il pagamento contro una fattura di acquisto (simili al Pagamento contro un Ordine d'acquisto).
  2. Creare una fattura da un ordine che ha già un pagamento effettuato nei suoi confronti. In questa situazione la fattura eredita automaticamente il pagamento effettuato contro l'ordine.
  3. Ricevere il pagamento direttamente nei confronti di una fattura. Questo processo è seguito, quando un unico pagamento è stato fatto, ad esempio se l'utente vuole effettuare un unico pagamento per una particolare fattura di acquisto e preferisce cercare la fattura, al fine di effettuare il pagamento nei suoi confronti.

NOTE: Va riconosciuto che riceve un pagamento nei confronti di una fattura di acquisto non deve essere un passaggio manuale. Se si desidera, questo passo nel processo può essere completamente automatizzato tramite la configurazione del metodo di pagamento. Si prega di fare riferimento alla sezione del Manuale di configurazione in Automazione Workflow Pagamento.

Processo

1. Make Payment against Purchase Invoice

  • Follow the same workflow as Make Payment against Purchase Order, with the exception that in the Add Payment Window the user would select Invoices (or Orders and Invoices) from the Transaction Type dropdown to be able to select invoices. This process is followed when many receipts of payment are being entered at once.

2. Create an invoice from an order that already has a payment made against it.

To illustrate this process, we will create an invoice from an order that already has a partial payment made against it (so that the invoice automatically inherits the payment made against the order).

  • We will first enter an order and make a partial payment against it following the instruction in Make Payment against Purchase Order. In this example, the original purchase order has a value of €313, and a partial payment of €300 was made against it. Once we have created this entry we can validate it by viewing the Payment Plan associated with that order:
  • Navigate to Procurement Management -> Transactions -> Purchase Order
  • Select the order that has the partial payment and click on the Payment Out Plan tab. Here we can see that the original order has a value of €313,20, and a partial payment of €300 was made against it.
View larger
  • Having confirmed that the order has a partial payment against it, we can then proceed to enter an invoice that inherits that partial payment. To do this we navigate to Procurement Management' -> Transactions -> Purchase Invoice and click on 'Create New' and enter the details of the invoice for the business partner. We then click on 'Create Lines From'.
View larger
  • On the resulting screen we select the order from which we want to make this invoice (in our example this is the order we created above) and click on 'OK'.
View larger
  • We then click on 'Complete', ensure that the 'Complete' option is selected in the dropdown, and click on 'OK' in order to complete the invoice.
View larger
  • Once the invoice has been completed the user can click on the 'Payment Out Plan' tab and view the payment plan. Here you can see that the invoice has automatically inherited the payment history from the original invoice.
View larger

3. Make payment directly against an invoice.

This process is followed when a single payment is being made. For example where a user wishes to make a single payment for a particular invoice and prefers to browse for that invoice in order to make payment against it.

To illustrate this process, we will browse directly to an existing purchase invoice and make payment directly against it.

  • To do this we navigate to Procurement Management -> Transactions -> Purchase Invoice and select the invoice against which we want to make payment. In the Payment Monitor section of the invoice header we can see that this invoice was for €313,20 and that a partial payment of €300 has been made against it. In order to pay the outstanding amount we then click on 'Add Payment In/Out'.
View larger
  • In the resulting screen we enter the value of the 'Actual Payment Out' made. Please note that an overpayment allows the user to decide whether to leave the difference as an overpayment or to write of the difference. The system will assume that the user wishes to pay the outstanding amount in full; the user may edit the amounts if they wish. We then click on 'Process' in order to process the payment.
View larger
  • In the resulting screen we can select whether we want to simply Process Made Payment(s) or Process Made Payment(s) and Withdrawal. This allows the user to choose where in the workflow they wish the payment to be reflected (Make Payment -> Withdrawal Payment) and will trigger the accounting events associated with whichever point in the workflow they choose. In our example we will select Process Made Payment(s) and click on 'OK'.
View larger
  • Finally, we can see from the Payment Monitor section of the invoice header that the invoice now has a status of 'Payment Complete' as the full amount of €313,20 has now been paid.
View larger
  • We can confirm this by clicking on the 'Payment Out Plan' tab, where we can see that the number of payments made is 2.
View larger
  • From the 'Payment Out Plan' window we can also click on the 'Payment Out Details' tab that then shows the detail of the two payments made.
View larger

Effettuare il Pagamento mediante una Proposta di Pagamento

Panoramica

This process supports the automatic payment of a large number of invoices based on the due dates of the lines of the Payment Plan associated with open Purchase Invoices. The user can request a proposal of all invoices to be paid based on a number of criteria, review that proposal, and then automatically make payment

The key steps in automating the payment process are:

  1. Generate a payment proposal
  2. From the proposal select those invoices that you wish to pay.
  3. Generate the payment transactions in Openbravo.
  4. Create the payment documents / files to instruct the bank to make payment.

Processo

To illustrate this process we will assume that there are already Purchase Invoices in the system that are due for payment.

1. Generate a payment proposal

  • Navigate to Financial Management -> Receivables & Payables -> Transactions -> Payment Proposal and click on Create a New Record

The user may enter a description of the payment proposal and then provides the following selection criteria:

  • Business Partner: If payment is to be made to a single business partner then they can be selected. Only payments due to that business partner will be proposed.
  • Payment Method: Select the payment method that you wish to use to make payment.
  • Paying From: It is possible to select a Financial Account that has the above payment method active (i.e., only valid accounts for this payment method).
  • Payment Date: The accounting date of the payment to be generated from this proposal.
  • Due Date: The Due Date of all payments to be proposed. The system will propose for payment all open invoices that are due on or before the date given.
View larger

2. From the proposal select those invoices that you wish to pay.

Once the selection criteria has been entered, click on the Select expected payments button. This shows the invoices that have met the selection criteria entered in the previous window.

The options here are:

  • Show payments for alternate payment methods: Select this checkbox if you would like to see invoices that are currently planned to be paid using other payment methods.
View larger
  • By clicking on the select all checkbox in the top left hand corner of the grid the system will automatically propose the full amount of each invoice for payment.
  • The user can change reduce the amount to be paid if desired.
  • Invoices can also be deselected by unchecking them individually. These deselected invoices will automatically be included in the next payment proposal.
  • Once the user has completed making adjustments to the payment proposal they can click on the Process button.
View larger

The user is returned to the Payment Proposal window, where it is now possible to click on the Lines tab.

View larger
  • In the Lines tab it is possible to see the detail of each invoice added to the payment proposal.
View larger

3. Generate the payment transactions in Openbravo and update the payment status of the invoice.

From the payment proposal window it is now possible to click on the Generate Payments button in order to:

  • create the payment transactions associated with the accounting workflow for the payment method for this financial account. Please refer to the section in the Configuration Manual on Payment Workflow Automation.
  • record the payment against the payment plan for each invoice.
  • control the grouping of the payments. Currently there is only one grouping supported; group separate payments to the same vendor into one payment

The use can click on Process in order to generate the payments in Openbravo and this returns you to the Payment Proposal window.

View larger

4. Create the payment documents / files to instruct the bank to make payment.

The final step is to start the Payment Run in order to create the external documents or file in order to instruct the bank to make payment. There are two mechanisms to allow you to execute the payment run, either immediately directly from the Payment Proposal, or at a later time using the Payment Execution menu item.

  • Immediately from the Payment Proposal:
    • Click on the Execute Payment button on the Payment Proposal window
View larger
  • At a later time using the Payment Execution menu item:
    • Navigate to Financial Management -> Receivables & Payables -> Transactions -> Payment Execution and enter the search criteria to find the payment proposal for which you want to generate the payment documents
      • Select the Payment Method and the Financial Account
      • Filter on the From and To dates of the Payment Proposal
      • Show whether you are searching for a proposal relating to amounts Paid Out or Received In.
    • Once the search criteria have been provided, click on the Search button and this will return the proposals that meet your requirements.
    • Select the payment proposal for which you want to create the payment documents and click on Process.
View larger

Whichever method is used to initiate the creation of the payment documents / files, the result is that the Payment Execution Process associated with the Payment Method is launched.

In order to illustrate this process Openbravo contains an illustrative Payment Execution for cheque printing. This process can interact with the user in generating payment documents.

In our illustrative process we want to print cheques using prenumbered cheque folios provided by our bank. The scenario assumes that the blank cheques are loaded on a printer, so the user is invited to provide the number of the top cheque in order for Openbravo to have a record of which cheque number is used to pay which supplier.

  • In our illustrative process the user is therefore invited to enter the number of the first cheque folio that will be used in the printing process.

NOTE: This information will be used later in the reconciliation process.

  • Once the user has provided the information required by the payment process the user can click on Execute in order to create the payment documents / files.
View larger

Returning to Financial Management -> Receivables & Payables -> Transactions -> Payment Execution and entering the same search criteria used above shows that the proposal has been processed (as it is no longer returned).

View larger

Storia Pagamento

In order to see a history of payment runs:

  • Navigate to Financial Management -> Receivables & Payables -> Transactions -> Payment Run.
  • Select the Payment Run you wish to view. This opens up a window that shows:
    • Client and Organization
    • Payment Execution Process: See the Configuration Manual section on Payment Execution Process
    • Source of the Execution: How the payment run was triggered.
    • Status: Either Executed, Partially Executed or Pending
    • Message: The message entered by the user in the Payment Proposal window.
    • Execution Date: The date the payment run was done.
  • Clicking on the Payments tab opens a window that shows each payment executed by the run
  • Clicking on the Parameters window shows the values returned by the payment execution process. In our illustrative example this is the cheque number used.
View larger

Registrare Deposito / Ritiro

Panoramica

This section deals with the process of manually marking a payment as either deposited or withdrawn in the receivables and payables workflows.


NOTE: It should be recognized that marking a payment as either deposited or withdrawn need not be a manual step. If desired, this step in the process can be completely automated through the configuration of the payment method. Please refer to the section in the Configuration Manual on Payment Workflow Automation.

NOTE: The timing of accounting events are driven by the accounting workflow. This means that marking a payment as either deposited or withdrawn (either manually or automatically) may (or may not trigger) an accounting event, depending on the configuration of the accounting workflow.

NOTE: Commonly an accounting event is not defined for the deposit or withdraw events, but users may still use the deposit or withdraw events to track the status of payments in the receivables and payables workflows for the purposes of cash management (knowing exactly where all funds are in the workflow).

In the following process description the assumption is made that Openbravo has not been configured to automatically mark payments as either deposited or withdrawn as the user wishes to manually keep track of the deposit and withdrawal events.

Processo

To illustrate this process we will assume that there is, intentionally, no automation of the deposit or withdrawal events (as the user prefers to track these statuses manually).

It is also assumed that when processing payments in the receiving or making payment workflows, the user chose, for receivables to Process Received Payment(s) and for payables to Process Made Payment(s).

Had the user chosen for, receivables to Process Received Payment(s) and deposit or for payables to Process Made Payment(s) and withdrawal, then the payments would already have been marked as deposited or withdrawn and there would be no need to manually deposit or withdraw those payments.

  • Navigate to Financial Management -> Receivables & Payables -> Transactions -> Financial Account and click on the account for which you wish to mark transactions as either deposited or withdrawn.
View larger
  • From the 'Financial Account' window we can also click on the 'Transactions' tab in order to see the details of the transactions. In order to change the status of payments not yet marked as deposited, it is necessary to click on the 'Add Transactions' button.
View larger
  • From the 'Add Transactions' window we can see the details of payment transactions not yet marked as deposited or withdrawn, depending on the view selected in the 'Document' window.
  1. If you want to show payments received as 'deposited', then select 'Received In' in the 'Document' window, select the items you want to mark as deposited, and click on 'OK'.
  2. Similarly, if you want to show payments made as withdrawn, then select 'Paid Out' in the 'Document' window, select the items you want to mark as withdrawn, and click on OK.
View larger
  • You are then returned to the Transactions tab of the Financial Account where you can now see the deposited or withdrawn transactions.

Riconciliazione

Questa sezione riguarda il processo di riconciliazione delle transazioni nel Conto Finanziario in Openbravo con le transazioni sull' Estratto Conto (Dalla banca). Il processo di riconciliazione è il passo finale nei Workflows Crediti e Debiti.

L'obiettivo del processo di riconciliazione è quello di spiegare (conciliare) la differenza del saldo finale indicato per il Conto Finanziario in Openbravo e il saldo finale indicato sull' Estratto Conto.

In un mondo perfetto i due saldi saranno sempre gli stessi, ma la realtà è che raramente lo sono. La differenza tra i due saldi può essere spiegato da:

  • Nel Conto Finanziario
    • I pagamenti da parte dei clienti contrassegnati come ricevuti (o in transito) in Openbravo che non sono stati ancora stata cancellati dalla banca
    • I pagamenti a fornitori segnato come pagato (o in transito) in Openbravo che non sono stati ancora stata cancellati dalla banca.

In entrambi i casi queste operazioni non sono ancora stati liquidati tramite il sistema bancario e quindi non figurano ancora sull'estratto conto.

  • Nell'Estratto Conto
    • i pagamenti dai clienti versati direttamente sul conto corrente che devono ancora essere registrate in Openbravo.
    • Ordini Permanenti o addebiti diretti corrisposti ai fornitori direttamente dal conto bancario che devono ancora essere registrate in Openbravo.
    • Interessi e commissioni addebitate dalla banca che devono ancora essere registrate in Openbravo
    • Errori sul conto bancario

In questi casi le operazioni (esclusi gli eventuali errori) dovrebbero essere inseriti nel conto finanziario di Openbravo.

    • Errori sull'Estratto Conto

In questi casi le operazioni (esclusi gli eventuali errori) dovrebbero essere inseriti nel Conto Finanziario di Openbravo.

Poiché il processo di riconciliazione spiega la differenza tra i due saldi, il primo passo nel processo è di rivedere l'estratto conto bancario e registrare come cancellato tutti gli elementi che compaiono sia nel Conto Finanziario che sugli Estratti Conto (come sono stati liquidati con il sistema bancario). Inoltre, tutte le transazioni (incassi e pagamenti) visibile sul estratto conto che dovrebbe riflettersi nel Conto Finanziario dovrebbe essere inserita in Openbravo.

Questo processo è noto come riconciliazione come qualsiasi restanti operazioni non pareggiata spiegherà la differenza tra i due saldi, vale a dire, riconciliare i saldi.

Ci sono due processi di riconciliazione in Openbravo:

  1. Riconciliazione Manuale da un Estratto Conto cartaceo
  2. Riconciliazione Automatica utilizzando Estratti Conto Importati

Riconciliazione Manuale da un Estratto Conto cartaceo

Panoramica

Questo processo presuppone che l'utente disponga di una copia della Estratto Conto e desidera conciliarlo al Conto Finanziario in Openbravo.

Processo

Per illustrare questo processo si suppone che ci sono

  1. transazioni nel Conto Finanziario in Openbravo che ora sono cancellate tramite il sistema bancario (ad esempio, vengono mostrate sull'estratto conto e devono essere marcati come cancellate nel Conto Finanziario).
  2. transazioni sull'Estratto Conto (per esempio spese bancarie) che devono essere riflesse nel Conto Finanziario.


  • Navigate to Financial Management -> Receivables & Payables -> Transactions -> Financial Account, click on the account that you wish to reconcile, and select the Transactions tab.
  • Our example shows that there is a transaction line in the Financial Account to match; it has a "Cleared" status of "No".
  • Referring to my bank statement I can see that the transaction has actually cleared and is now shown on the statement. In order to mark it as cleared I click on the "Reconcile" button.
View larger
  • This opens up the Reconciliation window, which shows all the transaction lines that have not yet cleared. Here I can check those items that have cleared by placing a check in the checkbox in the "Cleared" column.
View larger
  • First I need to enter the End Balance per the Bank Statement.
  • I can check those items that have cleared by placing a check in the checkbox in the "Cleared" column.
  • I can see at the bottom of the screen that there is an unreconciled balance. This is because there is Loan Interest shown on the bank statement that needs to be entered in the Financial Account.
  • I therefore click on the "Save" button in order to return to the Transactions screen so that I can enter the Loan Interest.
View larger
  • I can now see that the item that I marked as cleared is now marked as cleared, however in order to enter the outstanding transaction for the Loan Interst I now click on the "Add Transactions" button.
View larger
  • In the "Add Transactions" window I change the "Transaction Type" to GL Item.
  • In the GL Item drop down I select one of the GL Item.
  • I enter the amount in the "Paid Out" field and click on the "OK" button.
View larger
  • This returns me to the Transactions window where I can now see the transaction line for Loan Interest that I have just entered. Note that this line is not marked as cleared.
  • In order to clear this transaction line I click on the "Reconcile" button
View larger
  • This returns me to the Reconciliation that I saved earlier.
  • I now mark the Loan Interest transaction line as Cleared.
  • At this point please note that the Difference between the two balances is now zero, meaning that the two balances are fully reconciled.
  • I now click on the "Reconcile" button to complete the reconciliation process.
View larger
  • This returns me to the Transactions window where I can see that the reconciliation process completed successfully and I note the reconciliation number.
  • There are no unreconciled transaction lines (Note: The "Hide Reconciled Transactions" check-box is selected.)
View larger
  • In order to view the reconciliation I click on the "Reconciliations" tab and select the most recent reconciliation.
  • This opens up the Reconciliation window showing the detail of the reconciliation performed.
  • If I want to I can print the reconciliation report. I have a choice of:
    • Reconciliation Detail Report: Shows all the transaction lines that reconcile the two balances.
    • Reconciliation Summary Report: Shows only the cumulative values of the transaction lines that reconcile the two balances.
View larger
  • In order to view the detail I click on the "Cleared items" sub-tab.
  • This opens up the Reconciliation Lines window showing the detail of the transaction lines that were reconciled.
View larger

Riconciliazione Automatica usando un Estratto conto Importato

Panoramica

This process assumes that the user receives an electronic bank statement and wishes to automatically reconcile it to the Financial Account in Openbravo.

The automatic reconciliation process involves 4 steps, one of them (step 2) is optional:

  1. Import the bank statement
  2. Post the bank statement
  3. Match using the imported bank statement
  4. Reconcile

Processo

To illustrate these steps we will assume that there are

  1. transactions in the Financial Account in Openbravo that have now cleared through the banking system (i.e., they are showing on the bank statement and need to be marked as cleared in the Financial Account).
  2. transactions on the bank statement (for example bank fees) that need to be reflected in the Financial Account.
  3. we will illustrate this process using a Financial Account of type "Bank", as the process is (intentionally) not supported for Financial Accounts of type "Cash".
  4. we will use whichever matching algorithm is associates with the Financial Account we select. Please refer to the Configuration Manual for more information on defining the Financial Account.
View larger
Importa Estratto Conto
  • Navigate to Financial Management -> Receivables & Payables -> Transactions -> Financial Account, click on the account that you wish to reconcile (making sure you select an account of type "Bank"), and select the Transactions tab.
  • Our example shows that there are four transaction lines in the Financial Account to match; they have a "Cleared" status of "No".
  • In order to see which transactions have actually been cleared by my bank I must first "Import the Bank Statement" by clicking on the button.
View larger
  • This opens up the "Import Bank File" window.
  • I select the location of the bank file and the format of that file (for illustration purposes we will use a Spanish bank file format).
  • I then click on "OK".
View larger
Registrare Estratto Conto
  • Navigate to Financial Management -> Receivables & Payables -> Transactions -> Financial Account, click on the account that you wish to reconcile (making sure you select an account of type "Bank"), and select the Imported Bank Statements tab.
  • Our example shows that there is a Bank Statement containing both Payment Out/In, successfully imported.
  • The bank statement can be posted by clicking on the process button "Post"
View larger
  • Bank statement posting will generate a ledger entry (Debit/Credit) by taking into account the ledger accounts defined in the
    Financial Management -> Receivables & Payables -> Transactions -> Financial Account - Accounting Configuration tab:
    • Bank Asset Account
    • Bank Transitory Account.
  • A bank statement posting will look like:
    • In the case of a "Negative" Bank Statement (by example -4.500,67) => A bank statement containing more Payments OUT lines than Payments IN lines
      • Bank Transitory Account (DEBIT)
      • Bank Asset Account (CREDIT)
    • In the case of a "Positive" Bank Statement (by example 4.850,20)=> A bank statement containing more Payments IN lines than Payments OUT lines
      • Bank Asset Account (DEBIT)
      • Bank Transitory Account (CREDIT)
Confrontare usando un Estratto Conto Importato
  • I am returned to the transactions window where I can see that the import process completed successfully.
  • I now want to "Match using Imported Bank Statement", so I click on that button.
View larger
  • This opens up the "Match using imported Bank Statement Lines" window.
  • I can filter the contents of the window to show:
    • Deposits and Payments
    • Deposits only
    • Payments only
  • The window is divided into two sections:
    • The left hand section shows the Imported Bank Statement Lines and in my example I can see the three lines of the bank statement that I successfully imported in the step above.
    • The right hand section shows the Transactions in Openbravo that have been automatically matched to the lines in the bank statement. The logic used for matching is defined by the matching algorithm associated with this Financial Account. Please refer to the Configuration Manual for more information on associating matching algorithms to Financial Accounts.
View larger
  • I can see that there is a clear match for the first two lines, so I accept the proposal and mark them as a match by clicking on the checkbox in the "Match" column.
View larger
  • For the third line I can see that the bank has made a payment to "Demo Business Partner" for 16.00 (this may have been a direct debit or standing order transaction). I therefore need to add the payment to my Financial Account in Openbravo. In order to do this I click on the "Add" option in the transaction line.
  • This opens up the Add Transaction" window.
View larger
  • In this window I want to add the Payment that is shown on the bank statement, so I leave the Transaction Type as the default "Payment"
  • In the Details section I change the Document to "Paid Out", which shows a list of previously paid items for this Business Partner.
  • In order to add the new payment I click on the "Add Payment" button.
View larger
  • I enter the payment document number
  • In the "To be Paid To" dropdown I select the Business Partner and at this point the system automatically brings up the list of unpaid documents.
  • I select the Payment Method
  • I filter by Transaction Type on
    • Orders
    • Invoices
    • Orders and Invoices
  • I select the item for which payment was received and the system automatically completes the payment amount.
  • I then click on the "Process" button
View larger
  • In the following window you are asked how you want to process this transaction. As this payment has already been cleared by the bank I select "Process Made Payment(s) and Withdrawal"
  • I then click on the "OK" button
View larger
Conciliare

The user clicks on "Reconcile"...

Transactions 0028 Renconcile-pop.png
Image TR0028: ...and is invited to confirm the action.

Transactions 0029 discrep.png
Image TR0029: The user is presented with a warning that there are unreconciled items.

Note: the "Create Adjustment" button is to manage situations where the bank has made an error and the user wants to adjust the imported bank statement to remove the error. Any adjustments must be stored against the bank statement and the adjusting value and description displayed on the reconciliation statement.

In this case the user decides to leave the transaction as unmatched and clicks on the "Leave as Unmatched" button.

Transactions 0030 Reconciled.png
Image TR0030: The user is returned to the transactions screen where they receive confirmation that the process has successfully completed.

Transactions 0031 Statements-update.png
Image TR0031: Clicking in the "Imported Bank Statement" tab the user can see that the bank statement recently used has been marked with the date of the reconciliation. Note:

  • "Import date" shows the date the file was imported
  • Statement Date shows the date of the bank statement.
  • "Reconciliation Date" should show the date that the reconciliation was completed.



Transactions 0032 Statements-Details.png
Image TR0032: Clicking on the Statement Details tab the user can see the detail of the imported statement.

Transactions 0033 Grid.png
Image TR0033: Returning to the Transactions screen the user sees the unreconciled transactions. The message "8 items to match" refers to all unmatched items for today in the grid. The user wants to view the reconciliation summary and clicks on the "Reconciliation" tab.

Transactions 0034 Reconciliations.png
Image TR0034: This opens a summary view of the reconciliation. This shows:

  • Statement Date: Shows the date that the reconciliation was based on.
  • End Balance: The statement end balance.
  • Items reconciled: The number of items reconciled.
  • Unreconciled Statement Lines: Number of unreconciled items (Miss X)
  • Outstanding Payments: Number of outstanding payments (Mari Cleaning Services).
  • Outstanding Deposits: Number of outstanding deposits (Priscilla Pirelli).

The user decides to print the most recent reconciliation statement so clicks on the most recent line.

Transactions 0035 Reconciliations-Form.png
Image TR0035: This opens a summary screen. The user clicks on one of the "Publish" options...



Transactions 0036 Report.png
Image TR0036: ...and the Reconciliation Report is generated. In this case it is the "Publish Detail" option.



Transactions 0037 Report-Summary.png
Image TR0037: The "Publish Summary" does not show the line detail.

Retrieved from "http://wiki.openbravo.com/wiki/Projects:AdvPaymentMngt/User_Documentation/it"

This page has been accessed 2,481 times. This page was last modified on 8 June 2012, at 05:26. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.