International Accounting

Data modeling in management accounting and budgeting systems

Vol. 20, Iss. 20, OCTOBER 2017

Received: 9 August 2017

Received in revised form: 6 September 2017

Accepted: 5 October 2017

Available online: 27 October 2017

Subject Heading: Managerial accounting

JEL Classification: C50, М40

Pages: 1183–1201

Trachenko M.B. State University of Management, Moscow, Russian Federation

Importance Budgeting as a management technology is highly sought after by enterprises and groups of companies all over the globe regardless of their industry affiliation and scale of operations. The budgeting methodology is a dynamically developing field of scientific research; it provides tools enabling to solve urgent problems, namely those related to data bulk processing at the stage of planning and generation of budget versions.
Objectives The study aims to justify principles of data modeling in management accounting and budgeting; to develop data modeling tools aimed at achieving the objectives of an enterprise or a group of companies.
Methods In the study, I employ logical analysis methods and a systems approach.
Results The paper substantiates data modeling principles in management accounting and budgeting systems of enterprises and groups of companies. Based on the formulated principles, I developed data modeling tools for implementation in spreadsheets, special applications, and cloud-based technologies.
Conclusions Developing and elaborating the budgeting system of enterprises and groups of companies should be based on data modeling under the principles and approaches to their systematization and structuring formulated in the paper. The offered data modeling tools may be useful in the organization of management accounting and formation of a budget model on all automation platforms, as well as in Microsoft Excel, using Power Pivot and Power Query add-ins.

Keywords: management accounting, budgeting, data modeling principles, automation


  1. Amosova N.A., Vasil'ev A.V. [Risk-focused budgeting as a tool of financial risk management]. Sovremennye naukoemkie tekhnologii. Regional'noe prilozhenie = Modern High Technologies. Regional Application, 2011, no. 4. (In Russ.)
  2. Vasenev K.P. [Integration of enterprise management system with application of Beyond Budgeting concept]. Kontrolling = Controlling, 2017, no. 1, pp. 12–25. (In Russ.)
  3. Mizikovskii I.E. Genezis upravlencheskogo ucheta na otechestvennykh predpriyatiyakh [Genesis of management accounting at domestic enterprises]. Moscow, Ekonomist" Publ., 2006, 199 p.
  4. Nikolaeva S.A., Shebek S.V. Upravlencheskii uchet. Legendy i mify [Management accounting. Legends and myths]. Moscow, TsBA Publ., 2004, 288 p.
  5. Palii V.F. [Development of the management accounting methodology]. Bukhgalterskii uchet = Accounting, 2004, no. 12. (In Russ.)
  6. Kerimov V.E. [On the organization of management accounting]. Bukhgalterskii uchet = Accounting, 2003, no. 14, p. 44. (In Russ.)
  7. Baumgarten L. [Budgeting as a basis for implementing the strategy and enterprise resource management]. Upravlenie Korporativnymi Finansami, 2008, no. 2, pp. 94–100. (In Russ.)
  8. Rybakova O.V. Bukhgalterskii upravlencheskii uchet i upravlencheskoe planirovanie [Management accounting and planning]. Moscow, Finansy i statistika Publ., 2005, 464 p.
  9. Vakhrushina M.A. [Convergence of information resources of accounting subsystems: A managerial aspect]. Ekonomika. Biznes. Banki = Economy. Business. Banks. 2013, no. 2, pp. 7–15. (In Russ.)
  10. Kapulin D.V., Tsarev R.Yu. et al. Razrabotka vysokonadezhnykh integrirovannykh informatsionnykh sistem upravleniya predpriyatiem: monografiya [Development of highly reliable integrated information systems of enterprise management: a monograph]. Krasnoyarsk, SFU Publ., 2015, 184 p.
  11. Katunin A.A. [Specifics of cost classification in the system of car service management accounting]. Upravlencheskii uchet = Management Accounting, 2017, no. 4, pp. 19–25. (In Russ.)
  12. Popova L.V., Maslov B.G., Maslova I.A. [Basic theoretical principles of building an accounting and analytical system]. Finansovyi menedzhment = Financial Management, 2003, no. 5. (In Russ.)
  13. Sidorova M.I., Gulyaeva A.A. [Management Accounting System as an Element of an Entity's Common Information Space]. Uchet. Analiz. Audit = Accounting. Analysis. Audit, 2016, no. 5, pp.50–65. (In Russ.)
  14. Lozhkina S.L. Metodologicheskoe soprovozhdenie postanovki sistemy upravlencheskogo ucheta v period adaptatsii k MSFO: monografiya [Methodological support to the management accounting system organization during the period of adaptation to IFRS: a monograph]. Bryansk, OOO Ladomir Publ., 2014, 200 p.
  15. Khlevnaya E.A [Economic indicators monitoring in the system of management accounting and controlling of business processes of industrial holdings]. Upravlencheskii uchet = Management Accounting, 2017, no. 5, pp. 17–27. (In Russ.)
  16. Khlevnaya E.A. [The information-analytical system of business processes financial controlling of industrial holdings]. Finansovyi menedzhment = Financial Management, 2017, no. 2, pp. 3–13. (In Russ.)
  17. Sharovatova E.A. [Features of management and cost accounting depending on the sectorial technology of organizations]. Vestnik professional'nykh bukhgalterov = Bulletin for Professional Accountants, 2016, no. 2, pp. 44–48. (In Russ.)
  18. Upchurch A. Upravlencheskii uchet: printsipy i praktika [Management Accounting: Principles and Practice]. Moscow, Finansy i statistika Publ., 2002, 952 p.
  19. Horngren Ch., Foster G., Datar S. Upravlencheskii uchet [Cost Accounting: A Managerial Emphasis]. St. Petersburg, Piter Publ., 2008, 1008 p.
  20. Trachenko M.B. Byudzhetirovanie kak universal'naya tekhnologiya upravleniya: monografiya [Budgeting as a universal management technology: a monograph]. Saarbruchen, LAP Lambert Academic Publishing Publ., 2013, 576 p.
  21. Trachenko M.B. Byudzhetirovanie v sisteme upravleniya finansami: monografiya [Budgeting in the financial management system: a monograph]. Moscow, State University of Management Publ., 2011, 168 p.

View all articles of issue


ISSN 2311-9381 (Online)
ISSN 2073-5081 (Print)

Journal current issue

Vol. 20, Iss. 21
November 2017