1. Objectives of deposit performance report
In 1C:CPM solution the report should be created to reflect all cash in-flow and outflow operations on the account with the deposit type.
Deposit performance report in the bank should be done using information in Russian and English.
This deposit performance report is done by all organizations. It is necessary to provide selection by organization, by group of organizations.
Period - the report is completed with actual information for the year, divided by months.
Currency - USD. Transactions are shown at the currency rate as of the transaction date.
Deposit performance data - The deposit performance of the organization is completed with actual information on purchases and payments, based on the documents “ Flows to the current account ” and “Withdrawal from the current account” (status = Paid) on the account with the type = Deposit.
Features of the deposit performance in 1C:CPM - The currency rate difference does not need to be posted. Information is grouped by banks and nominal currencies, not by bank accounts. It should be possible to get out by selecting the cash flow item in the settings.
Structure - Organization-Bank
Report details:
Company name - Organization
Bank name - Bank
Nominal currency - account currency
Current valuation - current account balance
Current year performance - current year's accrued income. Amount for the year of the “Interest income” column.
Annualized current year performance, % - calculated average weighted annual interest on deposit. Formula = Interest income for the current year/Average monthly balance for the current year. The calculation is done in nominal currency, not in USD.
Interest income - % for placement. The actual amount under the contract is reflected by the document “Flows to the current account ”. Allocated under cash flow item Interest received 345211. Add to the settings the ability to select an item for this parameter, as well as the ability to assign in the report the value of Interest income and the period for which the value is adjusted. The value is given in nominal currency and the date of the USD currency rate is also provided. Calculation should be done by the value if it is assigned manually.
Average monthly balance - account balance for the month. The balance for each month day/number of month days is analyzed
Annualized monthly performance, % - the actual interest on the deposit performance, based on the income received within the given month and company. Formula: Interest income/Average monthly balance. The calculation is done in nominal currency, not in USD.
2. Deposit performance in the CPM system
Deposit performance in the CPM system (Russian/English interface) is set by the user with the appropriate checkmark:
Reflection of Deposit Performance in the Russian interface of the 1C CPM solution:
Reflection of Deposit Performance in the English interface of the 1C CPM solution:
