
Ditutup
Disiarkan
Dibayar semasa penghantaran
I need a small utility that pulls customer sales and payment-receipt data out of Tally, drops it neatly into Excel, reconciles each invoice against what has been paid, and then reminds the customer when something is coming due. In the Excel file I must see: • Customer name and contact information • Exact sales and payment amounts already recorded in Tally • The original invoice date alongside the payment due date As soon as the sheet opens it should refresh from Tally (ODBC/XML is fine), calculate outstanding balances, flag anything overdue, and fire a WhatsApp reminder directly from Excel. A quick “Send All” button that loops through the due items is ideal, but individual sends must also be possible. I am happy with a lightweight VBA or Power Query approach; if you prefer another method let me know as long as the workflow stays inside the workbook and the message goes out through WhatsApp. Please deliver the working Excel file, connection instructions for Tally, and a brief note on how to adjust the reminder text so I can personalise future messages.
ID Projek: 40356780
5 cadangan
Projek jarak jauh
Aktif 9 hari yang lalu
Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
5 pekerja bebas membida secara purata ₹1,930 INR untuk pekerjaan ini

As a freelancer with a decade of experience in data analysis with Excel, I believe my expertise is perfect for the job. Over the course of my career, I've automated multiple excel-based workflows which required extracting data from different sources, reconciling, analyzing and presenting it meaningfully. I've also used APIs to integrate commonly used messaging apps like WhatsApp with excel before, so setting up communication channels within the workbook would not be an issue. Furthermore, since I possess a good command over ODBC/XML & VBA, I'm adept at handling vast datasets and can connect your Tally account seamlessly for export. Additionally, having worked with similar tools and softwares previously, I know the importance of accurate and convenient representations. Thus, rest assured that post-exportation, you'll get timely and easily accessible information on customer contacts, outstanding balances and due dates conveniently clumped together. Moreover, my "Reference Note" skill will undoubtedly come in handy when you require personalized future messaging. By providing clear instructions to me on what sort of reminders you plan on sending to customers in the future, we can incorporate an algorithm that auto-generates such emails based on your reminders instructions. Just know that my commitment is unwavering — so I won’t be satisfied until you are! Let’s collaborate now to transform your project vision into reality!
₹5,050 INR dalam 1 hari
4.3
4.3

Hi, I can build a lightweight, Excel-based utility that connects to Tally (via ODBC or XML), extracts customer sales and payment data, reconciles invoices against payments, and sends WhatsApp reminders directly from the workbook. Key features I will deliver: * **Customer & Payment Dashboard:** Customer names, contact info, invoice details, original invoice date, due date, and payments recorded in Tally * **Automatic Refresh:** Upon opening, the workbook refreshes data from Tally, calculates outstanding balances, and flags overdue items * **WhatsApp Reminders:** * “Send All” button to loop through all due items * Option to send individual reminders * Easily customizable message template for personalization * **Excel-Based Workflow:** Fully contained inside the workbook using VBA / Power Query * **Instructions & Documentation:** Step-by-step guidance for connecting to Tally, adjusting the reminder text, and maintaining the workbook This solution ensures you can reconcile invoices efficiently and automate customer follow-ups without leaving Excel, saving time and reducing errors. I can deliver the working Excel file, connection setup instructions, and customization guide promptly. Looking forward to helping streamline your sales and collections workflow. Best regards, Mohamed
₹1,500 INR dalam 3 hari
2.2
2.2

Hi, I can easily DO your work IN 24 HOURS, DM me now to get started, PRICE NEGOTIABLE 100% Work satisfaction is provided
₹1,000 INR dalam 1 hari
2.5
2.5

My name is Garuda, a chartered accountant with broad expertise in foreign compliances, bookkeeping, and virtual CFO services. I have been helping businesses around the world streamline their financial operations for over 8 years. In addition to my CA qualification, I am well-versed in using various accounting software solutions including Tally, Zoho Books, QuickBooks, Xero, and Wave. This technical knowledge combined with my skills in Excel is essential for seamlessly exporting and reconciling data between platforms. Similarly, being adept at MSME recovery advisory will be beneficial in ensuring your reminder texts are not only professional but also aligned with legal requirements. Furthermore, my fluency in Power Query and Vlookup will enable me to develop a robust workbook that extracts timely data from Tally, perform necessary calculations promptly and generate WhatsApp reminders as desired. I'm dedicated to providing tailored solutions to my clients' needs; thus delivering a working Excel file, providing comprehensive connection instructions for Tally and a brief note on adjusting the reminder text won't be a problem. Instead of just hiring an individual for the job, choose a whole team fully equipped to provide you holistic compliance solutions including this project requirement. Let's untangle your finance difficulties with utmost accuracy and timeliness. Let's chat and ensure your finance function runs without a hitch!
₹1,050 INR dalam 1 hari
1.8
1.8

As an Accountant at Ambience Cooling Corporation llp, I work extensively with Excel, which gives me a deep understanding of its various functions and features. I understand the importance of maintaining accuracy and organization when it comes to handling financial data, making me the perfect fit for your project. I can not only transfer customer sales and payment-receipt data from Tally to Excel but also reckon each invoice against what is paid, and refresh the data whenever necessary. Moreover, given my experience with Power Query and VBA, I can create a lightweight yet efficient utility that will automatically extract the required details from Tally, calculate outstanding balances, and flag anything overdue. My focus will be on ensuring the data's integrity while providing an easy-to-use platform that auto-reminds your customers via WhatsApp for any pending payments. As a detail-oriented professional, I understand the need for personalized messages in reminder systems. Therefore, along with a working Excel file and connection instructions for Tally, I'll provide you with a comprehensive note on how to adjust the reminder texts as per your preference. The project sounds intriguing, and I assure you that hiring me for this job would guarantee precise deliverables that are tailored to meet your specific requirements. Let's get started!
₹1,050 INR dalam 7 hari
0.0
0.0

Bengaluru, India
Ahli sejak Apr 8, 2026
₹12500-37500 INR
$30-250 USD
₹37500-75000 INR
₹1500-12500 INR
$30-250 USD
₹1500-12500 INR
$1500-3000 USD
₹75000-150000 INR
$10-30 USD
$15-25 USD / jam
$750-1500 USD
₹12500-37500 INR
€250-750 EUR
$30-250 USD
min £36 GBP / jam
$12-30 SGD
$30-250 USD
$250-750 AUD
₹12500-37500 INR
$10-30 USD