INTEGRATED PLATFORMS FOR AUTOMATING PERSONAL FINANCIAL ACCOUNTING BASED ON CHATBOTS AND CLOUD TECHNOLOGIES
Abstract
In the context of increasing financial complexity and the growing need for better personal finance management, virtual personal financial assistants have emerged as essential tools for individuals seeking efficient ways to track, manage, and analyze their finances. The widespread adoption of smartphones and cloud-based technologies has contributed to the growth of automated financial solutions that assist users in budgeting, expense tracking, and making financial decisions. This study examines the conceptual and practical foundations of developing a virtual personal financial assistant based on Telegram chatbot technology, integrated with cloud services such as Google Sheets. The research explores methods for automating financial accounting, enhancing user interaction with financial data, and ensuring secure, scalable, and accessible financial accounting tool for individual and family.The paper investigates the integration of asynchronous communication models using Aiogram, implementation of cloud- based data management via the Google Sheets API, and the use of a lightweight database SQLite for handling service-related data. Particular attention is given to the interaction logic, user experience design, and security protocols based on OAuth2 for managing sensitive financial data.Furthermore, the research analyzes the user experience, focusing on how the system supports both individual and shared financial management. It explores the functionality that enables multiple users to collaboratively manage a family budget.The proposed solution represents an approach, combining elements of software engineering, cloud computing, and digital finance. The study highlights the advantages of chatbot-driven interfaces for personal finance management and outlines the potential for future enhancements, including greater automation, multi-user collaboration, and artificial intelligence integration.
References
2. Mohanan A., Sabu A., Shinu S.S., Surendran S., ChandraBabu G. Assessing the Development and Use of Virtual Personal Assistants. International Journal for Research Trends and Innovation (IJRTI). 2025. Vol. 10, Issue 1. Pp. a870–a879. URL: https://ijrti.org/papers/IJRTI2501104.pdf.
3. Iovine A., Narducci F., Musto C., de Gemmis M., Semeraro G. Virtual Customer Assistants in Finance: From State of the Art and Practices to Design Guidelines. Computer Science Review. 2023. Vol. 47. Article 100534. DOI: 10.1016/j.cosrev.2023.100534.
4. Худолій Ю. С., Косолапенко В. С. Особливості застосування чат-ботів на основі штучного інтелекту у фінансовій сфері. Економіка і регіон. 2023. № 3 (90). С. 97–103. DOI: 10.26906/EiR.2023.3(90).3036.
5. Jain M., Srihari A. AI Driven Personal Finance Management Tools. International Journal of Novel Research and Development (IJNRD). 2024. Vol. 9, Issue 12. P. b822–b831. URL: https://ijrti.org/papers/IJNRD2412187.pdf.
6. Павлюченко Д. М. Вплив штучного інтелекту та машинного навчання на банківські послуги. Академічні візії. 2024. Вип. 32. 14 с. DOI: 10.5281/zenodo.12936652.
7. Money Manager Expense & Budget. URL: https://www.realbyteapps.com/
8. 10 фінансових додатків для домашньої бухгалтерії. URL: https://new.minfin.com.ua/ua/ideabank/10-prilozhenij-kotorye-pomogut-razbogatet.
9. WHEREISMYMONEY – PERSONAL FINANCE BOT – TELEGRAM BOT. URL: https://tdirectory.me/bot/whereismymoneybot.dhtml.
10. Telegram global MAU 2024. URL: https://www.statista.com/statistics/234038/telegram-messenger-mau-users.