In the Treasury subsystem, instead of the previous Cash Statement report, four reports have been added to help analyze cash flows.
Cash Statement
The report consists of two tables. The first table contains the beginning and ending balances of the organization’s accounts and cash offices, as well as receipts and disbursements. The second table contains information on cash in transit. Cash in transit includes transfers of cash between the organization’s cash offices or accounts, or collections in progress, as well as acquiring settlements with customers.
The analytics of this report consist of:
- Organization;
- Currency of the cash desk/account;
- Sender of funds (for cash in transit);
- Recipient of funds (for in-transit POs);
- Counterparty (for money in transit);
- Type of funds transfer (for money in transit).
The report can be generated in the currency of managerial or regulated accounting, as well as in the currency of the account or cash (currency of storage locations). If there are different currency data in the grouping analytics, they are not converted to a single currency, but are displayed in all available currencies. This works for outputting data in currency In the currency of storage locations. In other cases, all data is recalculated to the currency of management or regulated accounting.
The report can be drill down to primary documents.
Cash flows
This report helps to analyze cash flows.
The report includes three report options supplied:
- Cash flows;
- Cash flows by line of business;
- Correspondence of cash flows.
Cash flows” report option
The report consists of a graphical part and a tabular part. The graphical representation allows to see:
- receipts;
- payments;
- cash flow for the reporting period;
- cash flow on an accrual basis.
- Graphical variant of cash flow presentation:
The graph can be customized by the user, displayed in bar chart or graph format:
The graph includes both actual data and planned data, if these data are enabled in the report settings.
Planned data consists of: planned payments in relation to customer and supplier orders, contracts with counterparties and invoices, corresponds to schedules of receipts and disbursements, and contains data on loan and deposit agreements.
Account and cash balances for the planned periods are calculated on the basis of planned turnovers and actual balances. Overdue payments are shown for the previous day. Planned data are italicized.
The tabular form of the report includes sections corresponding to the groups of DDS items:
- Core Activities;
- Financial activity;
- Investment activity.
Three predefined groups of DDS items for types of activities have been added. At initial filling of the information base, predefined cash flow items are displayed in the Main activity group.
Control of data output only for the necessary sections is performed in the report settings:
The report structure includes information on cash balances at the beginning and end of the reporting period, and consists of sections on cash receipts and write-offs. The information is further detailed into analytical sections, for example, cash flow items.
The following dimensions (cash measurements and correlating analytics) may be analyzed in the report:
- Organization;
- Bank account / cash;
- Currency of the cash office / account;
- Sender of funds (for cash in transit);
- Recipient of funds (for money in transit);
- Counterparty (for money in transit);
- Type of funds transfer (for money in transit);
- Line of business (of the counterparty);
- Division;
- Cash flow item;
- Business transaction;
- Partner;
- Contract;
- Settlement Object;
- Payment object;
- Item/analysis of assets/liabilities, income/expenses;
- Corresponding line of business.
For comparative cash flow analysis the optional Cash Flow Comparison section of the report is used:
Comparison of cash flows by type of activity:
Comparison of cash flows by DDS items:
Comparison of cash flows by line of business:
The report can be detailed to primary documents.
Variant of the “Cash flows by activity” report
In this variant of the report you can set the selection in the header of the report to the line of business for which you want to estimate cash flows. As a result, a graph and a tabular report on cash flows will be displayed:
When displaying the indicator Cash Flow cumulative, you can estimate the payback period of the project at the intersection of the graph with the abscissa axis. And the value of the indicator at the end point of the time interval will contain the financial result of the project.
Variant of the report “Correspondence of cash flows”
In this variant of the report, the table shows the turnovers of cash flows in the form of a matrix. For example, in the rows you can place the analytics Organization, in the columns – the business region of the partner:
For example, similarly, you can display in the rows – Organizations, in the columns – Business areas.
The report analyzes cash flows and their corresponding analytics and collects the necessary matrix of the chess sheet.
Statement of cash documents
This report is used to analyze the movements of cash documents, the report includes information on purchases of cash documents as well as their transfer to accountable persons.
The report is formed in the currency of:
- management accounting;
- regulated accounting;
- currency of the monetary document.
Analytical sections of the report are:
- Organization;
- Division;
- Monetary document;
- Currency;
- Materially responsible person.
The report can be detailed to primary documents.
Statement of cash with accountable persons
This report is used to analyze settlements with accountable persons. The report contains information on the availability of advances to accountable persons or the organization’s debt to accountable persons at the beginning and end of the reporting period, as well as data on advances issued and their use by accountable persons.
The report can be detailed to the following analytics:
- Accountable Person;
- Organization;
- Division;
- Currency.
Information in the report can be displayed in the currency of:
- management accounting;
- regulated accounting;
- transaction currency.
The report can be detailed down to the primary operations.
The use of these reports helps to analyze cash flows at the enterprise, make managerial decisions based on this information.
— Установка и настройка систем 1С
— Сопровождение программ
— Типовая и нетиповая доработка
— Проектное внедрение системы под ключ
— Помощь и консультация по сдаче отчетов