Custom Development Projects - Our Stories

Custom Desktop Excel to Tally Converter

Problem

OACS is a private company engaged in the business of selling extended warranty / damage protection plans for consumer electronics. They use Tally for their daily work and have made a few Tally customizations to allow storage of additional fields. As they had thousands of transactions / invoices every month, it was a very time consuming process to manually pass entries and they were looking for an automation solution that would cut down on time spent in monthly work. As data security compliance was also a consideration, they wanted a on-premise solution as opposed to a cloud based solution.

Solution

We build a desktop based version of the excel to tally converter along with support for their additional customized Tally fields.

Impact

pending

Automated Bank Entries in Tally

Problem

Mr. S has a complex group structure with over 10 companies and 3-4 bank accounts in each company. The process of daily update of the bank transactions would take hours each day as it required downloading the account statements for over 30 banks and manually entering the entries in Tally. He was looking for an automation that would help save time and effort spent on this task.

Solution

After understanding the existing process, we built a desktop software that would continuously "listen" for new transactions in any of the bank accounts and on finding one, would automatically pass the appropriate entry into Tally.

Impact

The bank balances are now updated on a real time basis and hours of daily work has reduced to a few minutes of verifying simple balance reconciliations built into the software.

Email Reminders for Outstanding Invoices

Problem

Mr. H faced issues with collections from some of his customers. Although they were happy with his work and were willing to pay, they required constant follow up and reminders before settling their dues. Mr. H has a small team and was unable to devote resources regularly to this due to which his working capital needs increased. He was looking for a software based solution to automate collections / follow up.

Solution

We built a desktop software that synced with Tally and every 2 weeks days sent out reminder emails to all parties who had invoices outstanding for more than 30 days since the date of invoice. The reminder email included the list of such invoices as well as instructions for payment. The software was fully customizable for both frequency of emails as well as setting the number of days post which invoices were to be included in the statement. There was also the facility to send out an ad-hoc statement to selected parties when they asked for them.

Impact

Mr. H's customers are now paying much earlier than they used to as they receive regular reminders. Disputes have reduced significantly and reconciliations are easier as there is an automated follow up every 2 weeks and issues are raised promptly. Consequently, working capital requirements have also gone down.

Die / Molds Maintenance and Production Tracking Tool

Problem

Mr. V is in the business of manufacturing induction sealing wads and seals serving a wide range of industries. The manufacturing process requires use of dies / molds of various sizes that are customized to the requirements of each client and require frequent maintenance in order to ensure end product quality. Sometimes sales orders were lost due to non-availability of ready to use dies as there was no track of production for each die and when it had last been sent for maintenance. Mr. V has over 200 dies so it is not practical to do this manually. There was also no information on which dies were due to go to maintenance at any given time so it used to be done on an ad hoc basis.

Solution

We build a browser based desktop software that served as a reporting summary as well as data entry system for dies / molds including with relevant information such as last production date, last maintenance date, production info, etc. This enabled a real time tracking and summarisation of die / mold status. Maintenance is warned by the system automatically if a die exceeds its predefined production quota.

Impact

Mr. V has now got full control over the condition of every single one of his dies. There is no chance of an order being missed due to non-availability. Wear and tear is also reduced by ensuring maintenance is done at regular intervals.

Custom MIS Reports from Tally

Problem

Mr. B is a fourth generation entrepreneur who is running his family business which has been in existence for over a 100 years. As a modern day businessman, he is looking for the next growth avenues for which he wanted a solution to give him MIS reports at a granularity that was not natively possible in Tally (e.g. 2 dimensional Sales MIS (segment wise + product / category wise), 2 dimensional standard cost based MIS, party wise + product wise margins, cash flow using indirect method etc.).

Solution

We built an easy to use MIS reporting software that allowed Mr. B to run his required reports at his convenience and as per the dates he wanted to analyse.

Impact

By converting raw data that was earlier stuck inside Tally and not possible to analyse into understandable reports, Mr. B is able to identify new opportunities for growth and also inefficiencies that can be improved. He is now able to take decisions based on actual data combined with business experience rather than only "gut feel".

Inter Company Contractor Balances

Problem

Mr. D is running a large group with multiple legal entities including sole proprietorships, partnerships and companies. He regularly works with certain contractors but finds it difficult to monitor their receivables / payables / transactions at a group level which he requires from a business as well as regulatory (TDS) perspective. As he had over 20 companies to monitor, this would take a long time to update individually.

Solution

We built a flexible reporting tool that allowed Mr. D to view balances and transactions for any ledger / ledgers he specified across the companies he wanted.

Impact

Mr. D does not waste time opening and exporting company wise data anymore. Instead he runs the tool and gets his report in a few seconds!

Related Party Balance Reconciliations

Problem

Mr. D is running a large group with multiple legal entities including sole proprietorships, partnerships and companies. There are many inter company / related party transactions that need to be eliminated / adjusted in order to give a true picture of the groups financial position and results. As he had over 20 companies to monitor, this would take hours to update manually and was a very tedious process.

Solution

We built a flexible reporting tool that allowed Mr. D to quickly unreconciled balances across any set of companies that he needed. The tool would calculate the net balance of Entity A in the Books of entity B (across multiple ledgers) and vice versa and do the same for ALL companies in the list (i.e. for a set of 20 companies compared 2 at a time, there would be 380 comparisons!). If there is a mismatch, the tool indicates that so that the balances can then be investigated and reconciled.

Impact

Mr. D does not waste hours opening each company in Tally individually, totalling the ledger balances and comparing them to the corresponding companies. Instead he runs the tool and gets his report in a few seconds!