A program for maintaining the balance of counterparties' accounts. Simple ways to conduct mutual settlements with counterparties. Supplement to the program for professional managers - The Bible of the Modern Leader

Working with clients

Working with clients is an important and integral part of business. Attentiveness to clients and improvement of work with them is the key to successful business management. We offer you a client program that will cope with all complex tasks. The database program has a multi-user interface that will help you limit access to the database. Thanks to this function, in the client program it is possible to view the work history for each user and even for each client.

The program for clients is very easy to use, which will allow people of different ages and different types of thinking to understand it. Convenient menu layout makes it easy to navigate the system and manage lists.

When working with the client program, you have three main menus: modules, directories and reports. Such simple navigation allows you to carry out very intensive work and improve accounting with buyers and customers, customer accounting, register maintenance and customer accounting. Everyday work with clients requires more accurate use of information. If you use our customer accounting software, then a common category for work will be “Counterparties”. In it you can keep systematic records of counterparties. The AWP program here will show you a convenient database, where each client, under his individual number, will be located in his own editable line. This allows you to quickly search for a client using any of the fields. You can also use a card system with barcodes, and search for each client using an individual code. This will become complete automation for you.

In the AWP program, you can very accurately fill out information on the client, divide them into categories, select each client’s price list and indicate the card number, and maintain a register of shareholders. Conveniently, you can indicate in the fields not only the name or name of the client, but also the contact person. By indicating the date of birth, you can congratulate him on the holidays and possibly give some encouragement. This way you show your attentiveness to the client. And also carry out contact management and customer management in the database. There is also a special report for this field that will show you clients and their date of birth for a certain period.

In the program you can conduct settlements with customers, as well as settlements with buyers and customers and accounting for settlements with customers.

An automated accounting system is an integrated approach to accounting for clients and customers in any area.

A convenient module in the client program is mailing. By working with the mailing list you can attract more customers. By specifying a cell phone number in the field, you can send out mailings to customers, notifying them, for example, about discounts or congratulating them on a holiday. It is also possible to send mailings to mailboxes. You will not forget the client, and the client accounting software will allow you to do this accurately and quickly. Mailing through the client program has three important categories: errors, mailing and templates. These three submodules will allow you to automatically work with the mailing list and carefully monitor the quality of work in this area. You can specify the date, type of recipients, subject and mailing status. The "Errors" submodule will show you not only the error code, but also its content and which user made the error, its date and time.

Automated management systems allow you not only to work with clients, but also to maintain reports on employees, to keep track of settlements with customers, to account for securities. You have a special report that will show the work time of each employee with the client program for a certain period.

You can download the AWP for free in the form of a truncated version on our website or by contacting us by e-mail. By purchasing the program you will have an automated workstation.

You can plan work with clients through our client program. When you open a report on working with clients, you will see the actions of your employee for a certain period. ERP systems are our program, with all its capabilities.

The client CRM system program is very versatile and is an excellent solution for working with clients, employees and the enterprise! All you have to do is contact us!

Video programs for clients

By watching the following video, you can quickly familiarize yourself with the capabilities of the USU program - the Universal Accounting System. If you do not see the video uploaded to YouTube, be sure to write to us, we will find another way to show the demo video!

Anatoly Wasserman about the new version 5.0 of the USU program

In addition to the opinions of ordinary users about the USU program, we now present to your attention the opinions of experts. Anatoly Wasserman was born on December 9, 1952. An engineer by training, he graduated from the Odessa Technological Institute of Refrigeration Industry. After graduating from the institute, I got a job as a programmer, then as a system programmer. He first appeared on screen in 1989, taking part in the “What? Where? When?" and at the Brain Ring. In the television “Own Game” he won fifteen victories in a row over two years, from 2001 to 2002. and became the best player of the decade in 2004. According to the sports version of “My Game,” he became a five-time champion of Ukraine. Four-time champion of Moscow in the sports version of “Own Game”, bronze and silver medalist in 2017. Silver medalist of the “Connoisseur Games”, the World Games of Connoisseurs in 2010 for “Your Game”.

Supplement to the program for professional managers - The Bible of the Modern Leader

Addition to the program for professional managers: for business development and increased income. A unique product developed at the intersection of two sciences: economics and information technology. There are no analogues

USU Mobile App

With the development of technology, life speeds up. You need to be on time everywhere - because the faster you do things, the more you earn. For this reason, it is very important to have a feature-rich mobile application at hand.

Alexander Druz about the Universal Accounting System

In addition to the opinions of ordinary users about the USU program, we now present to your attention the opinions of experts. Among them is the first master of the intellectual game "ChGK" Alexander Druz. He was awarded the Crystal Owl prize six times as the club's best player. Winner of the "Diamond Owl" - a prize for the best player. Received the title of champion of the television version of the Brain Ring. In the television program “Own Game” he won “Line Games”, “Super Cup”, won the “III Challenge Cup” with the team, and set an absolute record for performance in one game. Author and presenter of intellectual games and educational programs on various television channels.

Maxim Potashev on the effectiveness of the USU program

In addition to the opinions of ordinary users about the USU program, we now present to your attention the opinions of experts. Maxim Potashev - master of the game “What? Where? When?”, four times won the “Crystal Owl” prize, twice world champion, three times Russian champion, six-time Moscow champion, three-time winner of the Moscow Open Championship in the game “ChGK”. Based on the results of a general audience vote in 2000, he was recognized as the best player in all the years of existence of the elite club, created in 1975. 50 thousand viewers of the program voted for the candidacy of Maxim Potashev. The "Big Crystal Owl" and the main prize of the anniversary games - the "Diamond Star" of the master of the game - were awarded. Member of the board and since 2001 - vice-president of the International Association of Clubs. By profession - mathematician, marketer, business coach. He graduated from the Faculty of Management and Applied Mathematics, taught at the Department of General and Applied Economics at the Moscow Institute of Physics and Technology. In August 2010, he was appointed president of the All-Russian public organization “Russian Sports Bridge Federation”. He heads a consulting company that helps various organizations solve problems related to sales, marketing, customer service and business process optimization.

Sergey Karyakin about tactics in business

In addition to the opinions of ordinary users about the USU program, we now present to your attention the opinions of experts. Sergey Karyakin. At the age of 12, he became the youngest grandmaster in world history, which was included in the Guinness Book of Records. Won the Candidates Tournament. Awarded the FIDE World Cup. World champion in rapid chess, world champion in blitz. Honored Master of Sports of Ukraine. Honored Master of Sports of Russia, Grandmaster of Russia. Received the Order of Merit, 3rd degree. Member of the Public Chamber of the Russian Federation in its sixth composition. Repeated winner of children's and youth world and European championships. Winner and medalist of many major tournaments. Champion of the XXXVI World Chess Olympiad as a member of the Ukrainian team, silver medalist of the Olympics as a member of the Russian team. He showed the best result on his board in the tournament and received the first individual prize (on board 4). Champion of Russia with the best result on board 1. World champion in the Russian national team. Reached the semi-finals of the World Cup. Winner of a number of international tournaments.

Features of the client accounting program

Below is a short list of the capabilities of the USU program - the Universal Accounting System. Depending on the software configuration, the list of capabilities may change - become smaller or larger.

The client control program supports the simultaneous operation of several users.
Each user login of the program that manages customer accounting is password protected.
While managing the program, each employee can periodically change their password.
The program will provide you with reliable accounting and control of all clients.
The client control program supports work over a local network through various network protocols.
It is possible to manage the program via the Internet, if there is a network of branches, or if the manager wants to view management reporting from home.
When working with customer accounting management, in the program you can select your favorite color scheme for displaying windows from a list of templates.
The title of the main window will display the name of your organization.
When accounting for clients, each report will be generated with the logo and details of your company.
The program, which automates customer accounting, supports working with several open windows, between which you can easily switch using tabs.
We care about our clients!
When working with client control, you can set the name of your organization, contact information and details in the program settings.
It will not be difficult for you to work with the program and automate your organization. The main menu of the program is implemented simply and clearly. It consists of only three points: modules, reference books and reports. Modules are needed for everyday work, reference books are needed to customize the program to the specifics of your company, and with the help of reports you can analyze the results of work for any period of time.
Taking into account possible holidays, the program can congratulate clients on their birthday or any other holidays.
When monitoring customers, using mass mailings you can notify customers about ongoing promotions or discounts.
SMS messages can be sent to mobile operators around the world so that customers can receive your notifications wherever they are.
Automation allows the manager to create a whole list of management reports.
Customer management software audits each user's activity.
When automating customer accounting, you will use a lock when editing any table entry, so that several simultaneously working employees do not overwrite the information entered by another person.
The client base is simple and convenient. The program has a quick search based on the first letters.
The program takes into account and supports data filtering.
Given the data, you can easily group it, and the resulting groups can be collapsed and expanded. In the software, new information can be added not only by adding, but also by copying an existing line.
When managing client records, nothing can be deleted accidentally in the program; a confirmation message will always appear.
In the program that controls customer records, when deleting information from the system, a company employee will have to indicate the reason for the deletion.
By controlling the work of the company, you can update any information yourself or set automatic updating to always see the latest data.
The program supports data import. For example, you can download a list of clients when starting to work with the accounting system.
Any analytical report can be printed.
You will be able to control the work of your organization at a new level. Each report can be exported to a variety of well-known formats.
When exporting information to MS Excel, you can use old and new file formats.
Almost all reports in a program that takes into account clients are generated for a specified period of time, which allows you to analyze a specific day, month or year.
The client accounting automation program can generate a report for each city if there are branches in different cities.
Let's start automating your company together!
USU software - Universal Accounting System - also includes many other features!

Wine Gallery Company

Manager Kirichenko D. Product:

Wine Gallery is the first retail project of our team. We are a distributor of local alcohol products in Vietnam. Our main target audience is tourists coming on holiday to Vietnam.

When launching this project, we clearly understood that accounting and analysis of goods and cash flows is the basis of our business. On the advice of friends, we chose the USU (Universal Accounting System) program.

We were prepared for a long learning curve since this was our first experience with this type of program. But the program turned out to be simple and intuitive. The very next day after the acquisition, we put it into practice and every day we discovered new opportunities that helped us record and analyze a huge flow of information without any difficulties.

This program certainly helps in our daily tasks, but with the development and growth of our business, many regular clients have appeared, and we have an individual approach to each of them. Therefore, it was important for us to be able to obtain sales data for very different categories of goods, for each counterparty. We turned to USU specialists to resolve this issue. The guys quickly modified the program to suit our needs, which greatly improved and simplified our interactions with clients.

We are glad that we chose the USU company to implement the accounting system for our first business and continue to cooperate with the guys on the basis of other projects.

Sincerely, Director of “Wine Gallery” Kirichenko D.S.

We sell children's orthopedic shoes, children's rehabilitation equipment and various orthopedic products. Every year the range of products and the number of customers increases. For more efficient management, accounting automation is necessary. It is automation that allows any enterprise to move to a new level of development!

The selection of the program took a long time and carefully. The task was to find a universal program at an affordable price, which would combine all the functions at once: both the position of a cashier and a merchandiser, and when logging in with a different password, it would serve as an excellent analytical program for the store manager. And so we found USU. Just a godsend for an individual entrepreneur!

There was only one thing that bothered me... the lack of representation in our city, and then, as it turned out, in Russia as a whole. We couldn’t imagine how we could successfully collaborate while being on different parts of the world.

But, thanks to the professionalism and attentive attitude of the team USU, we have decided.

Today we have an easy-to-use sales automation program. Accounting for inventory balances, sales analysis by product groups, maintaining a customer base and much more. It is possible to model a program specifically for our type of activity.

Technical support is excellent. Specialists quickly respond to all questions and help with any request.

Sincerely, Head of the OrthoBots store A.A. Timerbaeva

We express our deep gratitude to the entire team of the Universal Accounting System. As owners of a children's consignment store, we know the importance of systematizing data about consignors and incoming goods for sale. On the recommendation of our partners, we decided to try USU for a consignment store, and after using its demo version, we were delighted with what you can do in this program. Accounting for the receipt of goods from consignors, suppliers, barcoding of goods, cost accounting, warehouse balances, inventory, payments to consignors, returns of goods to consignors and much more.

The developers are great, they listened to our wishes and added an agreement, a deduction for storing goods, and our percentage for the agency fee. Despite the fact that the training took place remotely, USU employees were very accessible and quickly explained how to work in the program. In general, working with such a program is a pleasure.

Director of the children's consignment store "Baby to Baby" Finagin M.Yu.

Russian Federation, Leningrad region, city of Vsevolozhsk

IP Bogubaeva Dinara

Sharipov Darkhan Product:

Wedding boutique Malinelli (IP Bogubaeva Dinara) expresses its heartfelt gratitude to the company IP Akulov N.N. for installing the program at our enterprise Universal Accounting System.

Thanks to the program, we forgot about keeping records in notebooks and Excel. All our information is stored on a computer and processed within a few seconds.

The program interface is very simple. All sellers mastered working in the system very quickly.

As a manager, I can view the results of the day’s work at any time from my workplace or while at home.

We have set up a visiting system. Now we can see which employees are on vacation or sick. It has become very convenient to calculate vacations and sick leave.

The accountant now sees the whole picture of the movement of goods and cash flows, and can also reflect payments both in cash and by card or using various payment systems.

Maintenance is carried out in a very timely manner and at a high professional level. The guys patiently answer all our many questions and complete the work on time.

Sincerely, Sharipov Darkhan

IP "Buranbaev"

Director Buranbaev U.A. Product:

Rating: 5/5

Product: Program for trade and warehouse.

Our company sells auto parts.

The management and team of IP “Buranbaev” expresses gratitude to you for the provision of quality services and a professional approach to supporting and maintaining the program USU – universal accounting system.

Taking into account our experience with the program developed for us, we can note the effectiveness and stability of the software. The provided program fully meets the requested parameters. The specialists of your company showed high professionalism, installing the program efficiently and training employees to use it.

We thank the employees of your company for their professional service and look forward to further cooperation.

Director of IP "Buranbaev" Buranbaev U.A.

IP Kurakova O.N.

Individual entrepreneur Olga Nikolaevna Kurakova Product:

Letter of thanks.

We would like to express our deep gratitude to IP Akulov N.N. and his team for assistance in organizing the business, namely adapting the program USU for clothing retail.

Today, the software market offers a fairly large number of business support options, but all of them are either high in price or do not have the required functionality and require additional improvements, which also affects the final price and timing of the project launch.

Our choice fell on USU for a number of reasons, namely:

1) reasonable price.

2) transparency of calculations.

3) the opportunity to try a demo version of the product.

4) high speed of project launch in the stages from product selection to the full launch of the project (less than 5 days.)

Unlike many software products on the market, this software is quite flexible to user requirements and allows you to customize almost any aspect according to the specifics of your business. Another advantage is the absence of requirements for the use of special equipment. Separately, I would like to say thank you for the lightning-fast reaction of those. support for inquiries.

We wish your team prosperity and new professional successes!!

Sincerely,

Individual entrepreneur Olga Nikolaevna Kurakova.

Institute of Proper Nutrition, Keith LLP

Director Koishegarina A.N. Product:

Individual entrepreneur "Universal Accounting System" managed to quickly and efficiently organize the development and implementation of a software system for the Institute of Proper Nutrition in Astana, as a result of which the company systematized the current work of several departments, optimizing it to a minimum, but at the same time the report form remained complete, detailed and transparent.

We would like to note that the employees completed all installation work on time, made our adjustments and changes, in strict accordance with the terms of the Agreement. Upon completion of the work, the employees promptly provided a Certificate of Completion.

Managers and programmers are very punctual and polite.

In general, the program is simple and easy to use.

Director Koishegarina A.N.

06/01/2017

Company "ECOSTIL"

Director Arkaev N.E. Product:

Taking into account our experience with the program developed for us, we can note the effectiveness and stability of the software. When our company ordered a warehouse accounting program, the software development was completed on time. The presented program fully meets the requested parameters; the company’s specialists showed high professionalism, performing high-quality installation, setting up the program and training employees to use it.

Thanks to this software, it was possible to most fully optimize all processes for managing and controlling warehouse accounting.

Trade organization "Valuables Shop"

Director Seitkazieva M.M. Product:

I started my business from my small kitchen. First bouquet. First excitement. Mommy is on maternity leave. Standard story. The time has come for volumes to increase. The customer base is growing. At first I managed to keep everything in my head. Then Excel came. By the way, it turned out to be not so easy to lead. Since all the formulas, names, lines, everything had to be thought out independently. Having abandoned Excel and received even more volume, invoices came to replace it. It seemed like happiness. But as it turned out. Not at all either. The numbers differed. Determining the presence of residues took a huge amount of time. And then the idea of automation came to mind. The analysis and calls began. And I chose usu. What I don’t wish for to this day. I've been using it for over a month and a half. More specifically: the happiest thing is making reports. Balances are withdrawn instantly, it is possible to make a discount, add bonuses, and view any charts. Today I can’t do a single step without this program. If something happens to my laptop, I go into convulsions.

What difficulties. 1. Get ready if you are Plyushkins like me. Then you will have to enter a thousand little things into the database and think through them. But this is a matter of 3-4 days of hard work. During this time, you become more familiar with the program and begin to feel it. I am grateful to Irina, who initially withstood the attack of calls: what, how, where, what gives. Then there were the programmer guys. By the way, those who have golden patience and good brains :-). So, my experience using the program is positive. On the downside, I became somewhat dependent on it and fell in love with the reports. Well, of course, now I take reports and hold meetings with a smart look). Usu is a new level for me. Which showed my growth. Efficiency. Nothing goes unaccounted for. Every penny, every product knows its place. Usu has helped me grow as a businessman. Who knows: oh well, I won’t count it. Okay, I'll give it to you. The stage of calmness is passing. The stage of growth and respect for one’s own work begins. I'm grateful. I am grateful to every employee who led me to my personal small victory.

2) It is possible to take a photograph of the product, and sellers can see what they are selling when selling. This is great - there is much less re-grading.

3) It is possible to issue a receipt of 2 types and make a sale without a receipt - the goods are written off in any case.

4) Wonderful performance analysis. You can see graphically (which is more visual) the result of the question asked. And by profit, and by product, and by sales of each seller, and much more.

5) Responsive and competent company employees, which is very pleasant. They quickly come to the rescue and help resolve the issue.

I think I made the right choice.

Great accounting tool! Convenient, simple, understandable and intelligible program.

Thanks to its creators for making accounting easier.

Individual entrepreneur Samarina T.V.

Control over mutual settlements with counterparties is the basis for the stable financial activities of an organization. Therefore, it is so important to have a well-functioning system of working with suppliers, buyers, creditors and other organizations financially connected to your company.

Relations with counterparties

Counterparties are all organizations and individuals (suppliers, contractors, buyers, intermediaries, own employees, banks, etc.) that have any financial ties with this company. Virtually every company in business is a counterparty to someone.

To ensure that the company does not incur losses, its funds are not “frozen” due to non-payments from partners, fines and penalties are not accrued for late mandatory payments, it is necessary to have a well-functioning control system:

over the movement of funds on receivables and payables,
for paperwork,
for delivery times,
for the quality and quantity of delivered products, for the compliance of services provided
on the status of goods reserves
for obligatory payments of taxes, wages, utilities, etc.

Mutual settlements at the enterprise are controlled using closely related accounting and management accounting. The recording of all transactions in accounting books, documents and client cards by managers is duplicated by the registration of income/expenses of funds in the corresponding accounts by the accounting department.

This article will focus on management accounting.

Accounting for mutual settlements with clients is best done using modern automation programs.

Programs for accounting for goods in trade

Automation software products can be of two types:

“Boxed” - the product is sold as a package, you carry out all operations for its launch, use and system maintenance yourself;
“Cloud” – the product is “rented”: all software is stored on the data servers of the company from which you purchased the automated service; you pay for installing the service, choosing the appropriate tariff with the required set of options, create your account in this system and work in it in real time, without worrying about system maintenance, and resolve all issues that arise during its operation with the help of the technical support of the selling company .

As a rule, small and medium-sized businesses are closer to “cloud” software products, since they are cheaper than “boxed” ones, are easier to install and maintain, and their functionality contains everything necessary for the successful management of trading activities.

Automation of mutual settlements with counterparties using the Business.Ru program

Choosing a suitable software product for managing offsets is not difficult, since today there are enough such automated services on the market. In this case, the choice is determined by the necessary tools and the optimal ratio of its cost and capabilities.

This is, for example, “cloud”

By implementing this program, you will be able to monitor all the work of your organization online, from anywhere and from any electronic device - computer, tablet, smartphone - at any time you need.

The service allows you to:

Create an extensive catalog of goods and services, a large database of counterparties with all kinds of data on each of them,
Create and send documents directly from the client card,
Improve the quality of customer service by optimizing the management of relationships with them, planning sales stages, stages of interaction with counterparties,
Keep records of your own production,
Introduce a flexible system of pricing, incentives, statuses for clients, orders and documents at the enterprise,
Analyze the company’s profit by product groups, customer categories (region, type of activity, sources)
Generate reports, analyze the results of the company’s financial, production, trading and other activities

Note
Dear readers! For representatives of small and medium-sized businesses in the field of trade and services, we have developed a special program "Business.Ru", which allows you to maintain full warehouse accounting, trade accounting, financial accounting, and also has a built-in CRM system. There are both free and paid plans.

The main task of automating mutual settlements is to organize control over all commodity and financial transactions that are carried out between the enterprise and its counterparties. will help you make the necessary payments on time, take into account all debts and optimize work with clients, suppliers and your own employees, which will be the key to the stable operation of your organization and make it profitable.

Country support:
Operating system: Windows
Family: Universal Accounting System
Purpose: Business automation

Accounting for mutual settlements

Main features of the program:

Work with money in any currency is supported

All departments of the organization can work in a single information system via the Internet

The program shows current balances in real time for any cash register or bank account

You will be able to keep full financial records: post income, any expenses, see profits and view various analytical reports

You will have a unified database of clients and suppliers with all the necessary contact information

You can plan cases for any client

The program will allow you to plan expenses for a certain period

You will always have all detailed reporting for each cash register or account in any currency “at your fingertips”

All financial movements will be under your complete control. You can easily track what you spend the most money on for any period

The program will show you statistics on savings or excess costs for your items

A clear visualization of profit dynamics will help you easily analyze the company’s activities and profitability

Separation of access rights is supported. Each employee will see only what he is supposed to see

Integration with the latest technologies will allow you to shock your clients and deservedly gain the reputation of the most modern company

A special program will save a scheduled copy of all your data in the program without the need to stop working in the system, automatically archive and notify you when it is ready

Reserve
copying

Connection with payment terminals so that customers can pay at the nearest terminal. Such payments will be automatically displayed in the program

Payment
terminals

The scheduling system allows you to set up a backup schedule, receive important reports strictly at a certain time, and set any other program actions

Reliable control will be ensured by integration with cameras: the program will indicate data on payments made, payments received and other important information in the captions of the video stream

You can quickly enter the initial data necessary for the program to work. This is done using convenient manual data entry or import.

The program interface is so easy that even a child can quickly figure it out.

We have completed business automation for many organizations:

Language of the basic version of the program: RUSSIAN

You can also order an international version of the program, into which you can enter information in ANY LANGUAGE of the world. You can even easily translate the interface yourself, since all the names will be placed in a separate text file.

Maintaining mutual settlements is essential for the correct and accurate functioning of your business in order to avoid the possibility of accumulating unpaid and overdue debts, and to prevent non-receipt of goods, works or services from suppliers for whom payment or prepayment has already been paid. The larger the company or the faster it develops, the more difficulties arise in managing settlements with numerous clients, suppliers or contractors.

After all, accounting for mutual settlements occurs in the course of the company’s activities every day; the main profit lies in working with the company’s clients. Everything is based on the accounting of mutual settlements, from production, procurement, preparation to the sale of goods, works or services, their sale, etc. At each stage there are mutual settlements. For example, to order inventory, stocks, production equipment, spare parts and parts used in the production process, it is necessary to account for mutual settlements with suppliers. During production and development, mutual settlements are used with contractors - employees of the company who perform certain tasks for which funds are allocated. After the company receives the finished product and is engaged in its sale, the stage of keeping records of mutual settlements with customers begins. This is the most important stage in the activities of any company of any type and form of business, because it is the sale of goods, work or services that makes up your profit. If the accounting of mutual settlements at this stage is incorrect, then there is a risk of loss or unaccounted profit.

All these processes include accounting for mutual settlements with counterparties. Maintaining and controlling mutual settlements in many companies is part of an automated process. Accounting for mutual settlements with suppliers and customers is carried out with greater accuracy using various programs for accounting for mutual settlements and their control. We present to your attention a program for accounting for mutual settlements with counterparties, the Universal Accounting System, which is our own development and can be modified for your convenience and tailored to the specifics of your business. The program for accounting for mutual settlements with counterparties is an extensive and centralized system for registering mutual settlements, collecting and analyzing information on the financial and economic activities of an enterprise. This approach provides enterprises with control over mutual settlements with counterparties.

The monitoring and control program can be used by:

Any government company;
Private company;
Individual entrepreneur;
Self employed;
and so on.

Video programs for accounting mutual settlements

Possibilities for control and management of mutual settlements

The program allows automated registration of mutual settlements, conducting mutual settlements according to settlement documents;
Depending on the specifics and focus of your business, additionally production control of mutual settlements;
Timely registration of mutual settlements in the USU program ensures control of mutual settlements with suppliers;
Control over the maintenance of records of mutual settlements with all counterparties is possible using the internal audit function for company managers;
The program has an extensive and easy-to-use database;
Based on the automated database, the USU program automatically sends notifications and SMS. This function can be configured depending on the debts of suppliers or buyers, or for reporting new promotions, etc.;
The more users of the program are installed, the more convenient it can be to check and control all operations occurring in the company;
The program provides different levels of access to making changes to the program depending on the employee’s status in the company;
The USU provides extensive directories that can be created for each type of counterparty separately - suppliers, contractors, buyers;
The Universal Accounting System program for maintaining records of mutual settlements with counterparties is intended not only for accounting, but is intended mainly for management accounting;
The USU program is convenient for business management, since it can be used to conduct a comprehensive analysis of activities, income, operational efficiency and much more;
To work in the Universal Accounting System there is no need for the Internet;
The program has an accessible and intuitive interface;
Specialists can install the control system anywhere in the world, because we work remotely;
Keeping records of mutual settlements using the USU settlement accounting system becomes much easier, faster and more convenient!

Program Contactor balances (balances.xls) is an Excel workbook (97-2003 format) containing a ready-made example (template) for maintaining management records of relationships with clients and suppliers of a small enterprise.

Introduction

An Excel spreadsheet file solves several pressing financial accounting problems. The file does not require an additional installer, does not use add-ons, and can be copied, saving an unlimited number of backup copies.

The file pre-sets restrictions on 10 counterparties and 100 transactions for each, and protection is also installed on sheets (without a password). With a little skill in working with Excel, the example can be easily expanded both by the number of counterparties and by operations (up to reasonable limits limited by Excel performance).

Main features of the program

Calculation of accounts receivable/payable for customers and suppliers.
Calculation of planned payment dates for orders for buyers and suppliers based on the deferred payment standard.
Possibility of entering a planned payment date different from the standard.
Calculation of overdue receivables/payables for customers and suppliers.
Automatic determination of the list of orders closed by current payments (using the FIFO method).
Automatic calculation of the final summary for all counterparties.

Connecting macros

The example requires VBA macros to work. In Excel 2002-2003, you may need to first change macro security to Medium or Low ( Tools\Macros\Security). In Excel 2007, click the message line below the ribbon, and then confirm the operation.

Program structure

The structure of the workbook is very simple: there is one sheet with a list of counterparties and summary data ( Vault), the remaining worksheets contain data on transactions for a specific counterparty.

Sheets with balance sheets of counterparties are absolutely identical in structure and formulas. The inscriptions “Supplier” and “Client”, as well as the color of the headings, change automatically depending on the parameters specified on the sheet Vault.

To enter data for a new counterparty, simply rename the prepared blank sheet and enter a description line on the summary sheet.

The editable data is also the start date of the period and the current date. For the latter, the TODAY formula is set, but if desired, it can be translated manually.

For ease of use, transitions to counterparty sheets are organized in the form of hyperlinks. For new sheets, you need to set these hyperlinks manually (unfortunately, there is no way to organize this automatically, since hyperlinks are not saved when changing the sheet name).

The following information is displayed on the counterparty sheets:

Heading	Description	Input accessibility	Mandatory
date	Date of the accrual or payment transaction. It is advisable to start entering new data from this field.	Yes	Yes
Order code	Any order code or invoice for payment	Yes	No
Revenue Accrual	Charge amount per order (for customers and suppliers).	Yes	No
List of paid orders	Calculated list of order codes closed in the current payment (using the FIFO method)	No	No
Payment date (plan)	Date of payment for the order according to the standard. Can be fixed manually.	Yes	No
Date of payment (actual)	Date of payment for the order by calculation.	No	No
Payment amount (actual)	Payment amount for the order by calculation.	No	No
Remaining payment	Unpaid order balance.	No	No
Overdue, days	Number of days payment is overdue.	No	No
Overdue DZ Overdue short circuit	Amount of overdue accounts receivable (for clients). Amount of overdue accounts payable (for suppliers).	No	No
DZ for date Short circuit for date	Amount of regular accounts receivable (for customers). Amount of ordinary accounts payable (for suppliers).	No	No