Python Code with Telegram Bot

PLEASE READ FULL BEFORE APPLYING! Failure to follow screening process may result in auto rejection of application

We are in search of a coder or programmer with Python knowledge to help us create a code to pair together with telegram bot. It would be a finance expenses tracking tool for our company. The bot will receive expense information from us in the telegram group chat and the data will be output in a Google Sheets file. Requirements of the bot are stated below:

How the bot should work:
1. We will send in expenses in the following format:
“today, office supplies – paperclips, $10, cash”
“26/9, meals & entertainment – lunch, $20, bank card A”
“yesterday, office supplies – envelopes, $1080, cash”

2. The bot should check if the message sent is same as above format, if not, these are some other formats which we may use:
“$20 mcdonalds”
” $10 water yesterday”
From these messages, the bot then has to ask, “Which category does this belong to?” then automatically send me a list of the categories that i have preset (The data will be hosted in a Google Sheets file)

3. The data will be stored in a Google Sheets file with the following columns:
Date, Category, Item Details, Amount, Payment Method, Recorded By, Image Reference
“Recorded by” records userid of telegram, and “image reference” records the photo if a photo is sent with the details in the captions.

4. I can send commands to get a summary of the data (statistics), some examples includes:
Total current month expenses, total september 2023 expenses, total expenses for meals in october, total expenses incurred by staff A.
For this, we do not have a requirement of how it can be done, you can suggest ways which will make this possible.

5. Simple /start or /help should send me a prewritten message on how to use the bot

Requirements:
1. Work with python-telegram-bot latest update v20.5
2. Experienced coder/programmer with good basic logic
3. #notes to be written in Python code for ease of editing in future should we need to edit some parts of the code.

Qualifications / Requirements:
1. Must be confident to deliver our requirements exactly the way we need it to function
2. Prior experience in in coding / programming, telegram bot (especially with python-telegram-bot v20.5) is highly preferred.

Screening Process:
1. To make sure you’ve read and understood this job post, please start your application with the phrase “Expense Bot Python”.
2. Please also include your resume and expected amount of hours it will require you to complete the job, along with hourly expected pay. You can also estimate the total cost for the gig and propose it to us as a one off payment.
3. You need to send proof and sample work of previous work. Screen recording of previous bots would be great.