CC BY
0
Ahmedjonov A.
Associate Professor of the Department of "Accountingat the Samarkand Institute of Economics and Service, Uzbekistan
USING MS EXCEL FOR ACCOUNTING IN THE DIGITAL ECONOMY
Abstract: By organizing simple calculation processes with the help of MS Excel, templates are presented for performing calculation in service industries. It is shown that it is possible to calculate in Excel without using special programs in accounting. Small service industries can use this software to calculate the amount of work they do when they are just starting out.
Keywords: accounting, calculation, program, excel, service, formula, template.
Formula entry and functions: In addition to the direct tasks in MS Excel, the accountant can add functions such as preparing commercial proposals, calculating contract prices, etc. To perform calculations, it is necessary to apply various coefficients and corrections, as well as to convert prices. And the most important thing is to perform all actions quickly and without harming the tasks. It helps to prepare the main document and separate additional calculations that can be done in an Excel worksheet for the accountant. So, when recalculating the price of a product, you can specify the price in one cell, the number of products in the second, and the conversion formula in the third (= first cell * second cell), then press Enter and get the price. In the first sheet in the desired cell, you can put "=", go to the second sheet and show the third cell with the total. Press Enter again and get the result.
Файл Вставка Разм страницы Формулы Данные Рецензирование Вид Над Что вы хотите сделать? Вход Р+ Общий доступ
^ Пггж New Ro. • 112 - A* A' _И — " * Перенести текст — % ' Вставить Ж fi У ■ | • 6 -Д' = q - *= *| Р/] Объединить и поместить в центре -Вуф8рОбМ8Ш В I_Шрифт__ Выравнивание К | S • щ Щ СГ" » O/L гкм *Л Условное Форматировать Стили ¡tc, _ Л> .00 +.0 г ЕФормат-форматирование • как таблицу - ячеек ■ Чиою г. Стили Ячейни 1 ^ Р ^ ^ Сортировка Найти и и фильтр - выделить • Редактирование Л
А А B С D E f G H 1 J K L M N О P Q
1 2 Mahsulot narxi va sonini ko'paytirib umumiy narxni chiqanivchi shablon
3 Mahsulot nomi Mahsulot soni Mahsulot narxi Umumiy narxi
4 1-mahsulot 500 2000 1000000
5 2-iualmiloi 600 3000 1800000
6 A6 B6 C6 =B6*C6
7
8
9
10
11 n-mahsulot n-mahsulot ii-narx =ii'iuahsulot*u- uarx
12
Figure 1. Calculation of the total price of the product
If you need to make such calculations for a large number of points where the price changes only, you can use the main function of Excel - automatic filling of formulas or weighting. The ability to fill formulas is one of the main functions of the program. It automates the process of calculating data in a table without writing the same formula over and over again. Here's how you can drag and drop formulas.
In the formula line, we put a reference to the cell in the table with equal and source data (=A3). After that, we get only the repetition of the value in the table. When you drag this cell, a copy of the table with data is obtained, which changes accordingly as the data in the original table changes. This is an example of dragging cells without setting ranges. Then you can use the basic techniques of excel - these are auto-completion of formulas or weighting.
Counting calendar days Excel can become an indispensable assistant even in such simple actions as counting calendar days. An accountant needs to know exactly how many days there are in a given period to calculate interest, penalties, credits and the like. If it is a short time, it is easy to calculate it using a calendar, but this format is very inconvenient for continuous calculations. In such situations, Excel will help the accountant. To perform calculations, you need to select three empty cells in the table. To get the results, you need to write the start date in one, the end date in the second, and leave the third blank. Recommendation: type the date in the numeric part of the keyboard: 12/10/2016. The program itself converts the entered data into a date format and it comes out to 10/12/2016. Then select the third cell and click the "Add function" button, which you can find by the symbol f(x). After clicking, the "Function Wizard" window will open. Select "Date and Time" from the "Category" list and "360 DAYS" from the "Function" list and click OK. In the displayed window, you need to enter the values of the start and end dates. To do this, you need to click on the cells of the table with these dates and put one in the "Method" line and click OK. If the total value is not displayed in numeric format, you need to check the cell format: right-click and select "Cell Format" from the menu, set "Number Format" and click OK. You can also count days this way: in the third cell, type = DAYS 360 (B1; B2; 1). In parentheses, you need to specify the coordinates of the first two cells with dates, and you need to set the value of one for the method. When calculating interest for weeks, you can divide the number of days obtained by 7. You can also add or subtract any number of days to the date. To do this, you need to write the date in one cell, put an equal sign in the second, then click on the cell with the date and enter "+" or "-" and the required number of days.
Файл вставке Разметка стр ницы Формулы Данные Рецензировя ие Вид Надстройки 9 4io вы хотите сделать? Вход ^ Общий доступ
1 ^ Times New Ro- 12 - А' А* Ш ф ¿р Форматировать Стили * как таблицу * ячеек • Вставить • Удалить ' ¡'■!; Формат - I га- А- : ST Р Сортировка Найти и и фильтр * выделить *
—- fy ' У} Перенести текст Финансовый щ
u Вставить ^ Ж If Ч • ЕВ • & - Д • Щ - * * Щ Объединить и помести ть в центре • ^ ■ % ООО ».0 ,00 .00 *.о Условное форматирование'
Буфер обмена г, Шрифт г. Выравнивание г. Число г< Стили Ячейки Редактирование Л
L4 - >•/ fx =H4'I4»J4-K4
л G Н I J К L М N О P Q В S T
1 2 Ъ Korxona xodimlarini oylik maoshini hisoblash
Xodim F.l.SH Ishlagan kuni Kunlik ish haqqi Qo'ihimcha bonus Jarimalar Oylik maosbj
4 ] -xodim 30 150 000.00 50 000.00 - 4 550 000.00
Б 2-xodim 29 150 000,00 20 000,00 4 330 000,00
6 7 8 9 10 11 3-xodim 31 150 000,00 30 000,00 - 4 Й80 000,00
-II7»I7+J7-K7
n-xodim л kun n so'm n so'm n so'm n so'm
I ЛИСТ1 I © . ■ __l>
В ЩИ- I + ИД»
Figure 2. Calculation of monthly salary of employees
Working with reports Excel spreadsheets for accountants are a multi-functional working tool that contains a lot of information for reporting and making current calculations. When printing a table that does not fit on one sheet, you can place its "header" on each separate page, which makes it easier to find the information you need. To do this, select the "File" - "Page Setup" menu and the "Sheet" tab. We put the cursor on "Through rows" or "Through columns" and click on the rows that should be placed on each sheet in the table. You can also use headers and footers to work with such documents. They record the necessary information such as date, page numbers, compiler name, etc. Header and footer settings are available in "Page Options" - "Header and Footer". There are ready-made marking options or you can add your own.
conclusion , I will quote the following template: one month cash flow in the "General catering service" enterprise, linking of accounts, monthly payments, advance payments and accounts payable. -books are listed.
Разметка страницы Формулы Данные Реценэиров<
Вход Д. Общий доступ
■ik у
| | ^ Times New Ro - 12 - A* A ^s
Вставить ^ ж к Ч • ■ ■*« ■ Д • Буфер обмена г, Шрифт г»
С12 X V fx 60000000
ггПвренеети текст
|р Объединить Выравнивание
Общий _Ч
, - СГ - % «» ЭД #
Условно« форматирование - как таблицу *
I \J
¡¡¡Г Вставить * X ' Удалить ' Форматировать Стили |^ф0рМа
ЛТ Я*
Р
Сортировка Найти и и фильтр * выделить * Редуцирование
UMUMIY OVQATLANTIRISH XIZMAT1 МымявмЛ-хужалнк ош'рацня.тршш кисиОгн олinn КИТОБИ
1Канна счеглар буйича |i022 йилнинг январ ойи учун »
Cheih Ьшилйш ия чнсо5 чужжшнннш помп нн ря Kit МП Опсрпцияншм ншнуш! Сумип Счетлйр корреспонденция^!!
добот кредит
2 " 3 4 5 6 7
Жпмн ЛII I.IIIМ!1 Ой бошнга коллнк
18.04.22 60000000 3000000 5 000 000,00 4 000 000,00 100 000,00
18 05.22 60000000 3000000 5 ООО 000.00 4 000 000,00 100 000,00
18,06.22 ЙООООООО 3000000 5 000 000,00 4 000 000,00 100 000,00
18.07.22 <10000000 3000000 5 000 000,00 4 000 000,00 1(11] 000.00
18.08.22 60000000 3000000 5 000 000.00 4 000 000,00 100 000,00
18.09 22 . ш 60000000 3000000 лисоолар оуиича аиламма а Н 5 000 000,00 4 000 000,00 100 000,00
Figure 3. Ms in excel account leaflets conduct Used literature :
1. Shakhboz R. USING MODERN TECHNOLOGIES TO INCREASE THE EFFECTIVENESS OF TEACHING COMPUTER SCIENCE BASED ON DISTANCE EDUCATION //Journal of Advanced Scientific Research (ISSN: 0976-9595). - 2023. - Т. 3. - №. 7.
2. Shodiyevich, R. S., Shodiyevich, R. S., & o'g'liU. S. B. (2023). ACCOUNTING ISSUES IN THE DIGITAL ECONOMY. CENTRAL ASIAN JOURNAL OF MATHEMATICAL THEORY AND COMPUTER SCIENCES, 4(6), 80-84. Retrieved from https://cajmtcs.centralasianstudies.org/index.php/CAJMTCS/article/view/475
3. To'lqinjanovna T. N., Shodiyevich R. S. Word Formation by Affixation //INTERNATIONAL JOURNAL OF BUSINESS DIPLOMACY AND ECONOMY. - 2023. - Т. 2. - №. 5. - С. 217-222.
4. Shahboz R., Sayidaxon T., Sheroz R. IQTISODIY FANLARNI O 'QITISHDA MULTIMEDIYA VOSITALARIDAN FOYDALANISH TEXNOLOGIYALARI //International Journal of Contemporary Scientific and Technical Research. - 2023. - С. 518-520.
5. Shodiyevich R. S., Berdiqul o'g'li U. S., Shodiyevich R. S. The Process of Managing the Flow of Information, in the Example of Accounting //Nexus: Journal of Advances Studies of Engineering Science. - 2023. - Т. 2. - №. 5. - С. 99-104.
6. To'lqinjanovna T. N., Shodiyevich R. S. Word Formation by Affixation //INTERNATIONAL JOURNAL OF BUSINESS DIPLOMACY AND ECONOMY. - 2023. - Т. 2. - №. 5. - С. 217-222.
7. Ражабоев Ш. Ш. Экологическое образование в целях устойчивого развития территорий.-2022 //Kielce: Laboratorium Wiedzy Artur Borcuch. - 2022.
8. Rajaboyev S. Экологическое образование в целях устойчивого развития территорий //Scienceweb academic papers collection. - 2022.
9. Rajaboev S. S. Technologies of Using Multimedia Tools in Teaching Economic Sciences //Spanish Journal of Innovation and Integrity.
10. Ражабоев Ш. Ш. РОЛЬ ИНФОРМАЦИОННЫХ ТЕХНОЛОГИЙ В ТЕХНОЛОГИЧЕСКОМ ПРЕДПРИНИМАТЕЛЬСТВЕ //ББК 65.29 я43 Т384. -2022. - С. 54.
11. Ражабоев Ш. Ш. ЦИФРОВИЗАЦИЯ И ЗЕЛЕНЫЙ СЕКТОР В УСТОЙЧИВОМ РАЗВИТИИ //ББК 65.05 П 78. - С. 596.
