Inspiration

Small shopkeepers often allow regular customers to purchase goods on credit and pay later. Many still manage these transactions using paper notebooks. As customer records and transactions increase, tracking who owes money, how much has been paid, and the remaining balance can become difficult.

I wanted to build a simple digital solution to make this everyday business problem easier. This idea inspired me to create Udhaar – Smart Debt Management Assistant.

What It Does

Udhaar is a Telegram-based debt management assistant designed for small shopkeepers. It helps them manage customer records, create debt entries, view all recorded debts, and check individual customer outstanding balances through simple Telegram commands.

The goal is to reduce manual record-keeping and make customer credit information easier to organise and access.

How I Built It

I developed the project using Python and SQLite, with Telegram as the user interface.

The main components include:

Python: Handles the application logic and Telegram commands. Telegram Bot API: Allows the shopkeeper to interact with the system. SQLite: Stores customer records, debt entries, and payment-related data. Shopkeeper Authorization: Restricts access to the authorised shopkeeper's Telegram account.

I focused on building the core workflow first: adding customers, recording debts, listing debt records, and checking outstanding balances.

Challenges I Faced

One of my biggest challenges was connecting the Telegram bot to the SQLite database and making sure information was stored and retrieved correctly.

I also faced issues with Python virtual environments, missing dependencies, and duplicate Telegram polling connections that prevented the bot from responding.

Another important challenge was handling money accurately. I designed the system to store amounts as integer paise instead of relying on floating-point calculations.

These challenges helped me understand debugging, database operations, API integration, and how different parts of a software application work together.

What I Learned

While building Udhaar, I gained practical experience with Python, SQLite, Telegram bot development, database relationships, command handling, authorization, and software debugging.

Most importantly, I learned how to identify a real-world problem and turn it into a working software prototype.

What's Next

I plan to extend Udhaar with customer repayment recording, payment history, and PayPal payment integration with proper payment verification.

My long-term vision is to make digital debt management simple, reliable, and accessible for small businesses.

Udhaar – Less paperwork. Better tracking. Smarter shop management.

Built With

Share this project:

Updates

Submission history