Projects:CashFlowForecastReport/User Documentation

Contents 1 Cash Flow Forecast Report - User documentation 1.1 Overview 1.1.1 Purpose 1.1.2 Movements 1.1.3 Multi-currency 1.2 Filters 1.3 HTML/PDF output 1.4 Excel output

Cash Flow Forecast Report - User documentation

Overview

Purpose

This report shows amounts of cash coming into your business and amounts of cash going out over a given period. It enables you to predict peaks and troughs in your cash balance.

Movements

The ERP calculates the incomes and payment taking into account three different movements: Invoices, payments In/Out and financial transactions.

• Invoices
  • Every invoice has its corresponding payment plan meaning that the Date planned will be the due date of this payment plan
  • The invoice does not have a financial account but the business partner meaning that through him the report knows in which account to place the invoice
• Payments in/out
  • Please notice that you are allowed to enter payments in the future
  • Please notice that you are allowed to enter payments directly from a G/L item
  • Please notice that you are allowed to group invoices leaving the business partner in blank. The invoices have a payment plan with their corresponding due date
  • No matter the case, the field Date planned will be the payment in/out date of the document and not the due date of the invoice/s
  • If the payment in/out comes from an invoice, the system will skip the invoice not to sum twice the amount
• Transactions in the financial account (Deposits/Withdrawals)
  • Please notice that you are allowed to enter movements in the future
  • Please notice that you are allowed to enter movements directly from a fee or G/L item
  • In case you enter movements in the future that are included in the given period these will be included in the report
  • If the movement in the future comes from a payment in/out, the system will skip this payment not to sum twice the amount
  • The column Date planned will be the transaction date of the movement

Multi-currency

• Invoices: If the exchange rate exists at document level then the amount is calculated based on this value, if it doesn't exist then the rate is taken at client level (Conversion Rates window)
• Payment: The rate is the one defined in the header of the payment
• Transaction: The rate is the one defined in the transaction itself

Filters

• Date planned: Last day shown in the report
• Financial account: You can select one or leave it blank. In this case you would see the info related to all the financial accounts
• Break by date:
  • Not marked: The data is shown grouped by Incomes and payments. The date planned is ascending

• • Marked: The data is shown grouped by Date Planned and is ascending

HTML/PDF output

This report has two sections:

• Summary: Allows you to know, in a quick way, the position of the financial account. If you leave the Financial Account combo box in blank you will see the position of all the financial accounts that are in the drop down list
  • Financial account no.: What is shown is configurable through the column identifiers. Usually name of the account plus the account number
  • Current balance: The balance of the account till today. The way this field is calculated is slightly different from the one it is in the Financial Account window. For the report we take the value of the Current balance that it is stored in the window minus the sum of all deposits/withdrawals that occur in the future
  • Income: Sum of all incomes (Invoices, payments in and deposits)
  • Payment: Sum of all payments (Invoices, payments out and withdrawals)
  • Final balance: Current balance + (Incomes-Payments)

• Detail: All movements with the corresponding info
  • Date planned: The date when the event will take place. The details are sorted (Ascending) by this date. This date is filled based on the document:
    • Invoice: The date of the payment plan
    • Payment In/Out: The date of the payment
    • Deposit/Withdrawal: The date of the transaction
  • Date Invoiced: The date of the invoice. If the event comes directly from a payment or transaction this info will be null
  • Invoice No.: It shows the document number and links to the invoice header
  • Business partner: The business partner of the invoice or payment. If the payment groups invoices from different partners the report will show these invoices and the date planned will be the date of the payment instead of the due date
  • Payment: Shows the description of the payment in/out and links to the document
  • Transaction': Shows the description of the transaction and links to the document
  • Orig.Amount: Shows the amount of the document when the document currency differs from the financial account
  • Orig.Currency: Shows the currency of the document when this differs from the financial account
  • Amount: The amount in the financial account currency. Links to different places:
    • Payment plan: When there is no payment related to the invoice
    • Payment in/out lines: When there is a payment
    • Financial account: When the deposit/withdrawal comes from a fee or gl item

Excel output

The excel format has been design in a simpler manner avoiding groups (Date planned, Income/Payment). The reason for this is to allow end users manipulate the document