Multipurpose excel utility - Useful for every manufacturing /trading business with statutory compliances
Today sharing one of my excel programming which has helped me to the maximum in my professional career and allowed me to work with accuracy, speedy reporting & controlling. And this also allowed to access most data within a single excel file and not to make the computer messy with thousands of useless sheets. I have named it as operation sheet. The time taken to design this is around 10 Years. Yes the first operation sheet was designed in the Year 2007 which was just for Purchase & Sales data with no auto error checks and gradually I included many functions which are inter linked with the basic functions of a business (i.e. Purchase & Sales) ** This sheet has been designed considering the Place of business is within Odisha and so far no effects of GST has been included. The Usefulness about this sheets (as per me): - 1. Purchases & Sales Databases (with all relevant transaction details which we are not able to maintain or generate through tally/sap) Like Waybi