Financial Management in 1C:ERP Enterprise Management 2

Home Description Functional model Monitoring and analysis Finance Budgeting Regulated accounting Personnel Production Costs Organization of repairs Sales Customer relations Purchasing Warehouse and inventory Integration with “1C:Document Management 8 KORP ” Technological advantages

Treasury – a system that allows you to effectively manage cash in cash offices, bank settlement, currency, special and deposit accounts, and control payments of the company.

In “1C:ERP Enterprise Management 2” the functionality of management of requests for cash expenditures is created, the stages of formation and approval of requests are supported, the execution of payments on requests is controlled.

In accounting of non-cash funds the operations of registration of operative information on incoming and outgoing payments (according to primary payment documents) and reflection of bank statements (realized by a separate document) are separated. This made it possible to increase the efficiency of accounting (e.g., mutual settlements) without disturbing the accounting of cash on settlement accounts, to speed up the processing of statements and payments, and to establish full control over cash in the process of crediting, debiting, or moving.

The functionality of settlements with the bank on acquiring operations has been implemented. In addition to the registration of payment and return operations on payment cards, a mechanism for registration of reports from banks on credited payments, write-off of returns, withheld commission has been added. This made it possible to track each transaction from the moment the payment was made to the crediting of funds to the settlement account.

Accounting of the financial result (profit, loss) is carried out by the company’s lines of business. The composition of business lines can be set up very flexibly – for example, business lines can correspond to assortment (for distributors), points of sale (for retailers), projects, etc. Customization of arbitrary rules of cost and sales revenue distribution by activity areas based on sales analytics is supported.

All this allows to analyze in detail the efficiency of the company’s activities and develop the business by optimizing the composition of business lines.

Main innovations of the solution and functionality development:

Acquiring (payment cards).

Accounting of credits, deposits and loans.

Flexible tools for creating a payment calendar.

Application approval routes.

Expanded opportunities for managing current payments.

Flexible tools for forming payment documents for future dates.

Analytical reporting on cash flow.

Inventory of cash and settlement accounts.

Customizable posting templates.

Binding of entries to documents without transformation.

Deferred reflection of entries in accounting.

Creation of documents on typical operations.

Registration of non-financial indicators.

Auditable data.

Generator of financial reports.

Customized methodological model is presented: posting templates, chart of accounts, IFRS financial reports.

The Treasury subsystem solves the following tasks:

planning of cash receipts and expenditures;

accounting of operations with cash and non-cash funds;

control of cash availability;

analyzing the targeted use of funds;

maintenance of monetary settlements in foreign currencies;

accounting of settlements with accountable persons;

control of mutual settlements with buyers and suppliers;

accounting of credits, deposits and loans.

Payment calendar

The payment calendar is used for operational management of the company’s funds, formation of payment schedules and control over its timely execution.

The payment calendar is filled in automatically on the basis of data on planned payments from customers and payments to suppliers, planned other cash receipts and expenditures.

The use of the payment calendar facilitates:

analyzing data on available cash balance, planned cash receipts and expenditures;

deciding whether cash expenditure requests can be secured;

making decisions on the movement of funds between settlement accounts and cash offices or on the need to obtain additional funds;

approval of requests with specification of the payment term and the source of cash expenditure (bank account, cash desk);

execution of applications for internal movement of funds;

execution of applications for obtaining a loan from the bank.

When preparing the payment calendar, its feasibility is automatically checked – availability of funds in the places of their accounting.

Formalization of applications for cash expenditures

To register intentions to spend funds, the document Application for Expenditure of Funds is used. The nature and purpose of the planned write-off of funds are set by predefined types of operations of the document.

Applications for cash expenditure allow to take into account the planned type of cash expenditure:

Transfer of cash to a supplier;

Cash disbursement to an accountable person;

Payment on credit;

Return of funds to the client;

Payment to another organization;

Customs payment;

Other cash expenditures, etc.

The planned method of payment for cash expenditures (cash, non-cash) can be set in the request.

The use of requests for expenditure of funds allows to solve the following tasks:

to take into account the need for cash on the part of the company’s subdivisions;

to plan the expenditure of funds, to form a payment calendar;

prevent uncoordinated payments of money;

analyze the amount of money allowed to be spent.

A request is managed using the corresponding document statuses.

Control of targeted use of funds

It is possible to control the limits of cash expenditure.

Various tools of the application solution are used to control the spending of funds, the use of which helps to:

establish the amount of money available for spending for each item of the DDS;

plan how much money should be allocated for the expenses of a particular department;

reduce the amount of expenditures and control them.

Control of the spending limit can be carried out both for the company as a whole and for divisions and organizations.

Exceeding the limits is controlled when agreeing a request to spend money.

If it is necessary to spend funds in excess of the limit set for the item of the DDS, this need is indicated when drawing up a request for the expenditure of funds (the Over Limit sign is set in the request).

To control the expenditure of funds in accordance with the set limits, the report Cash Expenditure Limits is used, which includes expenditure limits, actual expenditure and helps to determine on which cash flow items there is an excess or the limit is not fully spent.

Simplified cash planning and control

Information on planned and actual cash receipts and expenditures can be obtained in a simplified form in the payment journal. When working with the payment journal, cash expenditure requests are not used.

Various options of working with the list of payment documents are available (separate journals for each type of document/general payment journal). Using the payment journal allows you to perform centralized work with payment documents:

execution of a new payment;

analyzing the list of executed payments;

registration of the payment order in the bank statement (performed by the bank);

uploading and downloading of payment documents.

From the payments journal you can quickly go to the reports:

Cash balances – allows you to analyze cash balances and movements, including those of accountable persons;

Control of cash transactions – allows you to control cash and non-cash cash flows.

Cash accounting

The possibility of accounting of various cash receipts operations is supported within the framework of the Cash Receipts workstation.

This workplace contains a list of orders for cash receipts, which in turn simplifies the work of preparing cash receipts with different types of business transactions:

Receipt of payment from the client;

Receipt of payment from the cash desk of the cash register;

Return of payment from the accountable person;

Receipt from another organization;

Return of payment from a supplier, etc.

Various receipt orders can be used as cash receipt orders.

For registration of cash disbursement operations the Expenditure Cash Orders workplace is used, which contains a list of cash disbursement orders, which are the basis for registration of expenditure cash orders with different types of business operations, such as:

Disbursement of DC to an accountable person;

Cash disbursement to a cash register of a cash register;

Payment to the supplier;

Return of payment to the client, etc.

The grounds for cash disbursement are requests for cash expenditures.

Cash inventory

To reflect the process of cash inventory in the cash offices of the company, the application solution tool – Cash Inventory – is used, which allows:

reflect accounting and actual cash balances;

formalize surplus and shortages of cash.

Based on the results of the inventory it is possible to draw up an act in the form INV-15.

Accounting for non-cash funds

To work with non-cash payments, the universal workplace Cashless Payments is used. In this workplace there is a reflection of various operations of receipt and write-off of funds from the settlement accounts of the organization. This workstation also allows to confirm the fact of payments registration in the bank statement on the settlement account (sign Bank executed).

To reflect the receipt of funds on the settlement account, the documents Receipt of non-cash DS are used, which allow to reflect typical operations:

Receipt from another organization;

Receipt of payment from a client;

Loan repayment by a counterparty;

Transfer of cash to the bank;

Other receipts, etc.

Write-off of cash from the current account is formalized by the documents Write-off of non-cash cash with indication of the corresponding standard operation:

Issue to an accountable person;

Payment to a supplier;

Other expense;

Customs payment;

Loan disbursement to a counterparty, etc.

Exchange with the bank

In the program 1C:ERP Enterprise Management version 2 mechanisms are used:

electronic transfer of payment documents to the bank for non-cash transfer of funds from the organization’s settlement account;

automatic reception of bank statements on the current account from banks.

Payment documents can be transferred to the bank using the following technologies:

Exchange through the file “1C:Enterprise Bank Client”. Payment documents are transferred to the bank by uploading payment documents to a file and then loading this data into the “Client-Bank” module. Specifying the upload/download files is not mandatory, they can be specified in the process of exchange with the bank.

“DirectBank” (direct data exchange) is a more convenient and safe way of transferring payment documents to the bank. Payment documents prepared in the system are transmitted to the bank directly, without unloading of payment documents into a file and subsequent loading of these data into the “Bank Client” module. Advantages of “DirectBank” technology (direct data exchange):

management of settlement accounts directly from “1C:Enterprise 8” without installing the Client-Bank system;

increased security level – signing of electronic documents directly in “1C:Enterprise 8”;

a single user interface for managing all accounts opened in different banks;

sending a payment document and receiving a bank statement at a single user command.

Uploading payment documents to the bank and downloading statements from the bank is performed within the workplace Cashless Payments.

Settlements with accountable persons

In the application solution it is possible to keep records of funds issued to accountable persons.

The general scheme of work with accountable persons is presented in the scheme:

Options of settlements with accountable persons using both cash and non-cash funds are supported.

In the program 1C:ERP Enterprise Management version 2 it is possible to take into account the following operations with accountable persons:

purchase of inventory;

registration of other and travel expenses.

Reasonableness of expenditures of accountable persons is confirmed by execution of documents Advance Report, which also allow to control the amount of overexpenditure and expenditure of funds issued to the accountable person.

Control of advances issued to an accountable person

Reports are used for a comprehensive analysis of cash advances issued to an accountable person:

Control of cash transactions:

purchases through accountable persons by purpose;

control of advances issued to the accountable person;

overspending of cash by the reporting person.

Control of advances issued to an accountable person:

incomplete cash transactions (non-cash/cash);

analysis of the amount of advances used and returned by the reporting person;

recommendations on further required actions (Draw up an advance report, Draw up a disbursement to the accountable person, etc.);

control of the outstanding balance – the amount for which the reporting person should report within the specified period of time.

Mutual account management

The mutual settlements subsystem is responsible for assessing the status and analyzing mutual obligations between the enterprise and its counterparties. It allows you to:

keep records of mutual settlements with detailing up to the contract;

keep records of actual and planned debts;

to form and coordinate acts of reconciliation of mutual settlements;

reflect the operations of netting and debt write-off;

analyze the state of settlements, identify overdue debts.

Independent accounting is performed for partners (management accounting) and counterparties (regulated accounting).

Several variants of mutual settlements are supported:

By orders – for each payment the correspondence to a specific order is indicated;

By contracts – mutual settlements are controlled by the contract as a whole;

By waybills – payments are executed in connection with the documents of realization (receipt) of goods.

Various reports are used to analyze data on the current state of mutual settlements, the amount of debt, the amount of overdue debt, amounts payable, amounts to be shipped and received:

Customer Indebtedness;

Statement of settlements with customers;

Customer indebtedness by maturity;

Reconciliation of settlements, etc.

Control of customer/supplier receivables by terms

Receive reports on accounts receivable and accounts payable can be broken down by different debt intervals.

To prepare reports on accounts payable and accounts receivable, 1C:ERP provides the following options:

use the standard debt interval used in the company;

or set your own debt intervals (unlimited number), in the context of which data on accounts receivable and accounts payable will be collected.

The following reports are used to analyze information about the amounts of accounts receivable and accounts payable by debt intervals:

Debt to suppliers by terms (accounts payable) – allows you to monitor the current state of accounts payable by suppliers, the size and duration of overdue debt by debt intervals;

Clients’ debts by terms (accounts receivable) – allows to control the current state of accounts receivable and to analyze clients with the largest overdue debts within the debt interval;

Partner’s file (only if there is only one debt classification option).

The possibility of receiving data on debts to suppliers by terms, debts of clients by terms in the form of diagrams or tables is realized.

Offsetting and writing off debts

The possibility to reflect operations of mutual repayment of accounts receivable and accounts payable for several partners has been implemented.

When setting off debts, different operations are supported:

offsetting of transactions of one customer (supplier) – used to offset debts of one counterparty (customer or supplier) on different objects of settlements within one organization;

offsetting between two customers (two suppliers) within one organization – used to offset debts between two different counterparties (customers or suppliers) for transactions that are registered to one organization;

netting involving two organizations for one client (supplier) – the counterparty (client or supplier) has made payment to one organization, but the shipment of goods is made on behalf of another organization;

offsetting of counter obligations (barter) – used to offset the debt of the counterparty as a customer and as a supplier.

The possibility of accounting of operations of writing off debts arising in the process of registration of business transactions between organizations of the enterprise and its clients or suppliers has been implemented.

To record the state of mutual settlements between a particular organization and a legal entity of a partner for a certain period of time you can use the document Reconciliation of mutual settlements. Reconciliation of mutual settlements can be performed with the detailing by partners and objects of settlements.

The current status of the reconciliation of mutual settlements is determined by the corresponding statuses of the document.

To analyze the documented reconciliations with clients and get information about whether there are discrepancies between the data from the client and “our” data, you can use the Reconciliation report.

Accounting for loans, deposits and borrowings

To keep records on credits, deposits and loans 1C:ERP Enterprise Management 2 has the following features:

to register loan and deposit agreements, taking into account the parameters of loan repayment, interest accrual and commissions for each agreement;

enter initial balances under loan and deposit agreements;

maintain a schedule of payments and accruals on loans and deposits;

calculate and reflect in the information base monthly amounts of commissions and interest on these agreements;

analyze liabilities under loan agreements.

To obtain a cash flow forecast, the possibility to keep records by schedule variants is used.

Chart variants can be filled in both manually and by loading from an external file into the information base.

Data on schedules are the source for formation of applications for cash flow expenditures, accruals of income and expenses on interest and commission.

The following operations can be reflected when making accruals on loans, deposits and borrowings:

Accruals for deposits;

Accruals on loans and borrowings received;

Accruals on loans issued.

Analytical reports can be used to control data on loans and deposits:

Register of loan and deposit agreements – allows to analyze mutual settlements within the framework of concluded loan, deposit agreements and loans;

Plan-and-fact analysis of payments and accruals under the contract – allows to analyze deviations on actually made payments and accruals under the concluded credit (deposit) contracts, taking into account the commission fee.

Further

Что такое ERP-система?

Какая выгода от внедрения ERP?

Как выбрать подходящую систему для предприятия?

Каковы основные модули ERP?

Каковы основные сложности при внедрении?

Консультант фирмы ООО АйТи Консалтинг

Илья

Эксперт портала ERP4u.ru

Задать вопрос

Консультации по вопросам автоматизации на базе ERP-систем:

— Установка и настройка систем 1С
— Сопровождение программ
— Типовая и нетиповая доработка
— Проектное внедрение системы под ключ
— Помощь и консультация по сдаче отчетов