CONTENT
01. OVERVIEW
Protheus gathers all transactions to be performed in the Accounts Payable and Accounts Receivable portfolios and displays them as a query in the Cash Flow form specifically.
The Cash Flow can be defined as the visual demonstration of revenues and expenses in a period. By analyzing it, we can optimize decisions for raising and applying financial resources in a company.
All inflow and outflow predictions can be observed in the Cash Flow, which graphically represents the union of Accounts Receivable and Payable, paid commissions, overdue bills, with control over five distinct currencies and Real as the official currency.
Important
The accrued balance is started by the values referring to the overdue bills (payable and receivable), the Balances in Cash and in Banks (if selected) and, finally, by the Inflows and Outflows performed daily.
The routine's characteristic is that it does not go back to a sporadic situation, i.e., the system does not give a base-date retroactive treatment to the data statement, considering only the current situation of an order, a bill or other data to be considered when building the Cash Flow.
The cash flow allows you to perform the following functionalities:
- Selecting one or more banks to compose the flow balance;
- Financial simulation of inflows and outflows;
- Analysis of the sales order and purchase order portfolio, if Billing and Purchase modules are integrated;
Note
The Purchase/Sales Orders statement is made according to the Balance and the payment method (balance divided in installments).
For example: An order registered with payment method in 4 installments and that was partially served will still be considered by the query as a 4 installments financial prediction.
Consider a registered purchase order with 2 items and total value of BRL 4,600.00 to be paid in 4 installments.
Then, an inflow invoice is registered in the system using the receiving of a part of the order.
The order data will be used for filling in the invoice, but it will be adjusted according to the content received.
This receiving is for BRL 3,200.00 and was registered in 4 installments payable, each of BRL 800.00.
Cash Flow View:
- Bills Payable totaling BRL 3,200.00 referring to the 4 installments of BRL 800.00
- Purchase Order totaling BRL 1,400.00 to be paid in 4 installments of 350.00 each.
- Analysis of the applications/loans performed, calculating their values daily by the daily quota information.
- Control over cash overflow using a minimum value information;
- Detailing of bills payable and receivable using detailed query, which presents all bills information (number, installment and issue date);
- Viewing the financial values of Bills Receivable of check type under custody;
- Sending charts by email;
- Obtaining the financial managerial view based on the Nature registration;
- Saving charts in BMP for use in other applications;
- Generating temporary bills payable or receivable in the Simulation
- Viewing balance details in the Export to Excel option that allows printing;
- Stating the predicted data for anticipated payments from the Funds Request routine and the ability to filter the desired statuses:
- 0 - Portfolio;
- 1 - Simple collection;
- 3 - Pledged collection;
- 4 - Linked collection;
- 5 - Collection with attorney;
- 6 - Judicial collection;
- F - Protest portfolio;
- G - Agreement portfolio;
- H - Notary collection (civil record);
- Obtaining the financial managerial view based on the Nature registration;
Hint
The cash flow Variation column shows how much income is compromised.
Example:
Inflows $ 27,000.00
Outflows $ 3,500.00
Balance of the day $ 23,500.00
Resulting:
(Outflows / Inflows) * 100 = Variation
(3,500.00 / 27,000.00) *100 = 12.96%
02. PROCEDURES
To query the cash flow:
- In Cash Flow, the configuration screen is displayed.
Note
To perform a cash flow query using bank balance by branch, enter the branch to be queried and check the Bank Balances option.
For the bank filter (SA6), the branches entered will be considered in the following priority:
Select Branches: The range of the selected branches will be considered
Consider Branches: If the "Select Branches" option is not checked, the range of the branches entered in the "From Branch" and "To Branch" will be considered.
If the options above are unchecked, the logged-in branch will be considered.
Using the filtered banks (according to the selected branch), the query will search the bank balances considering the branch less shared between tables SA6 (banks) and SE8 (bank balances).
Example:
Logged-in branch: D MG 01
SA6 - CEE sharing (Shared Branch, Unit and Exclusive Company)
BRANCH | BANK | BANK BRANCH | ACCOUNT |
D MG | 341 | 0910 | 01362 |
M SP | FN2 | 0002 | 00002 |
SE8 - EEE Sharing SE8 (Completely Exclusive)
BRANCH | BANK | BANK BRANCH | ACCOUNT | BALANCE |
D MG 01 | 341 | 0910 | 01362 | 500.00 |
D MG 03 | 341 | 0910 | 01362 | 1000.00 |
M SP 01 | FN2 | 0002 | 00002 | 2000.00 |
Result from Select Branches:
If the branches are not selected, the D MG 01 logged-in branch will be considered. As the less shared between SA6 and SE8 is CEE, the bank balances will consider all D MG bank branches.
BANK | BANK BRANCH | ACCOUNT | BALANCE |
341 | 0910 | 01362 | 1500.00 |
Note: bank FN2/0002/00002 will not be brought because it is from company M
If you select the Consider Branches option and enter From Branch: "D MG 01" and To: "D MG 02", as the less shared between SA6 and SE8 is CEE, the bank balances will consider all D MG bank branches, ignoring the selection that did not enter branch D MG 03.
BANK | BANK BRANCH | ACCOUNT | BALANCE |
341 | 0910 | 01362 | 1500.00 |
If you select the Consider Branches option and enter From Branch: " " and To: "ZZZZZZZZ". All banks from all branches and the bank balances from all branches will be considered.
BANK | BANK BRANCH | ACCOUNT | BALANCE |
341 | 0910 | 01362 | 1500.00 |
FN2 | 0002 | 00002 | 2000.00 |
If you select option Select Branches and select branches "D MG 01" and "M SP 01" Banks and bank balances from branches "D MG" and "M SP" will be considered.
BANK | BANK BRANCH | ACCOUNT | BALANCE |
341 | 0910 | 01362 | 1500.00 |
FN2 | 0002 | 00002 | 2000.00 |
Check the information to be considered in the Cash Flow.
Important
The Advance composition option refers to the advance values that can be pointed out as a reduction from inflows or outflows (for advance payments) or as inflow or outflow reduction (for advance receipts). These values are settled with bills receivable in another fashion.
Click OK to confirm the configuration.
The cash flow is presented.
The Overdue bills area displays the overdue bills payable and receivable values according to the system date (if defined in the configuration window).
The Balances area displays the available values in cash and in the banks selected in the configuration window.
The bottom part of the screen lists the total payable and receivable values according to the periodicity selected.
- To finish the query, click Exit.
To query the Funds Requests:
- In the Cash Flow options screen, select the Fund Req.
- In the grid, select the desired options.
- The Cash Flow is presented.
- Right-click a record.
- Select the Analytical Flow option.
- The system presents the Details screen.
- Select the Funds Requests folder.
- The Funds Requests are displayed.
03. VIEW MORE
- Funds Request
- Cash Flow Report
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas